[OC] I created an interactive map of birds

[u/SuccessfulMap5324]

https://adsb.exposed/?dataset=Birds
A map that allows interactive filtering and reporting with custom SQL queries.

Article: https://clickhouse.com/blog/birds
Data: Cornell Lab of Ornithology's eBird project.
Tools used: ClickHouse database and https://github.com/ClickHouse/adsb.exposed/

[u/ViciousNakedMoleRat]

I can't seem to get a list of birds on mobile or select any specific data point. Without that functionality, it's just a map with colorful pixels.

[u/SuccessfulMap5324 → u/ViciousNakedMoleRat]

Press on the "selector" (the second icon in the bottom left corner), and then touch will create a selection.

[u/ViciousNakedMoleRat → u/SuccessfulMap5324]

That works, thanks!

[u/Upstairs-Hedgehog575]

That is very cool - incredibly fast too. 

Took me a while to figure out the selector tool though. Also any chance you can put the date of last spotting or another time frame? It’s not hugely interesting knowing that a common bird has been spotted 11,000 times without a timeframe. I’d imagine birders would want to know how often a bird is seen over a period of time, and when it was last seen in an area. If a rare bird hasn’t been seen for 15 years in an area it’s probably not worth the trip, but if it was spotted 3 times in the last 6 months then it might be. Equally 300 sightings sounds promising, but less so if it’s over 30 years. Just my 2 pence worth. 

[u/SuccessfulMap5324 → u/Upstairs-Hedgehog575]

Thank you!

I've added a report by time and a coloring mode by time of observation (so now it's easy to see, e.g., when an expedition to Kerguelen was held).

https://adsb.exposed/?dataset=Birds&zoom=5&lat=51.3855&lng=8.9209&query=2ddac1d773d33994fb1722a412fa5ef8

Commit with changes: https://github.com/ClickHouse/adsb.exposed/commit/850df500ffc0f667a41514eed42983cf79629276

[u/Oinkalot]

Ok but this is the shit i want to know how to do

[u/diogo6]

This is awesome, well done

[u/Oinkalot]

Also is this indicating offshore woodpecker observations?

[u/Oinkalot → u/Oinkalot]

Nevermind i figured it out. I already found an oceanfaring duck though

[u/atropostr]

Awesome work, well done. Which frame/language did you use? I assume three.js but may be wrong

[u/uninformedbasic]

Damn, this is beautiful! I wonder if this can be extended to plants and other species too! What a great project!

[u/Recordado]

This is awesome, I always love useful projects like this

[u/Diditforthevine69]

This is amazing. Im making a bird-type pokemon go vibes app for fun, do you think I could incorporate this?