adsb.exposed

Yes, for example, the datasets at this page: https://adsb.exposed/ are indexed by the Morton curve: https://github.com/ClickHouse/adsb.exposed/#database-and-que... and https://reversedns.space/ as well. Also, a trivial application is image compression. Let's say you have a PNG image. PNG uses zlib, so if instead you take a raw bitmap and compress it with ZSTD, it typically will be better, but if you also sort pixels by the Hilbert curve first and then compress with ZSTD, it will be typically even better.

It appears to be where "you" (website visitors) have loaded page tiles. I was able to draw a little picture on the map by zooming in and panning around! The PR introducing it is easier to read than the whole repo: https://github.com/ClickHouse/adsb.exposed/pull/48/files

I missed the "About" link in the footer but still found my way to the repo [1], where the project is briefly explained including a ton of great example images. Thanks for that! > This website (technology demo) allows you to aggregate and visualize massive amounts of air traffic data. The data is hosted in a ClickHouse database and queried on the fly. You can tune the visualizations with custom SQL queries and drill-down from 50 billion records to individual data records. [1] https://github.com/ClickHouse/adsb.exposed/

Apparently my 'easy' isn't the same as yours. There's nothing I could find in the code that describes what it is. You'd have to make a pretty big logic leap to figure it out. All you can see in the code (in config.js, not in index.html) is the dataset url (random string) and the description "this website", which tells you very little. For anyone who just wants to skip to the answer, I found it in the pull requests / issues: https://github.com/ClickHouse/adsb.exposed/issues/47

I'd like it if you try to guess :) But it is easy to figure it out from the source code. The source code is here: https://github.com/ClickHouse/adsb.exposed/blob/main/index.h...

"ADS-B Massive Visualizer" is the right title per https://github.com/ClickHouse/adsb.exposed

Nice find! The GitHub repo near the top of that thread is great, too: https://github.com/ClickHouse/adsb.exposed For those wondering the license is a CC-NC-ShareAlike type

https://github.com/ClickHouse/adsb.exposed/ Show HN: ADS-B visualizer - https://news.ycombinator.com/item?id=39990346 - April 2024 (76 comments)

There is the "About" link at the bottom, pointing to the source code: https://github.com/ClickHouse/adsb.exposed/ In fact, the data processing pipeline is entirely trivial (a one-page shell script), and the frontend is also trivial (a single HTML page with vanilla JavaScript).

I did research on that topic when implementing my project https://adsb.exposed/ The list of all data exchanges is here: https://github.com/ClickHouse/adsb.exposed/?tab=readme-ov-fi... One of the best is https://airplanes.live/ - which currently aggregates data from nearly 1700 feeders globally; they have a legal agreement preventing sale of this data (to avoid situations like with adsbexchange); they share the data on a selective basis. One of the largest ones, Opensky Network - is supposed to be open for research purposes but they refused my request straight ahead. https://adsb.lol/ - is controversial. This database is made available under the Open Database License: http://opendatacommons.org/licenses/odbl/1.0/ plus under CC0, but there is some drama that I don't understand: https://github.com/ClickHouse/adsb.exposed/issues/12#issueco...

This looks surprisingly similar to my project, https://github.com/ClickHouse/adsb.exposed/, but more complex and less performant.

This looks similar to my project https://github.com/ClickHouse/adsb.exposed/, which allows us to analyze this data in real-time and is much simpler and elegant.

I use this technique in a few of my projects: https://reversedns.space/ (a map of the Internet) - Morton curve is used as a visualization tool; https://adsb.exposed/ (a visualizer of air traffic) - Morton curve is used as a database index; Both projects are open-source, so you can find how exactly it is applied: https://github.com/ClickHouse/adsb.exposed/blob/main/setup.s...

Could you please clarify the details? I took extra care to provide all the needed attributions and credits and I believe it is complete and sufficient. If I missed something, please describe it at https://github.com/ClickHouse/adsb.exposed/issues, and I will correct it.