madethemcry 33 minutes ago

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/

lexlambda 3 hours ago

This is certainly missing some kind of legend explaining the colors of the lines, and what data is actually shown.

Is "red" high or low velocity? And as an example, I do not understand what the "Boeing vs. Airbus" selection is trying to represent, as well as how "Altitude & Velocity" are supposed to be displayed at the same time.

Project certainly requires a bit more care if any discussion should happen around it.

  • amiga386 an hour ago

    Boeing vs Airbus:

        count() AS total,
        sum(desc LIKE 'BOEING%') AS boeing,
        sum(desc LIKE 'AIRBUS%') AS airbus,
        sum(NOT (desc LIKE 'BOEING%' OR desc LIKE 'AIRBUS%')) AS other,
    
        greatest(1000000 DIV {sampling:UInt32} DIV zoom_factor, total) AS max_total,
        greatest(1000000 DIV {sampling:UInt32} DIV zoom_factor, boeing) AS max_boeing,
        greatest(1000000 DIV {sampling:UInt32} DIV zoom_factor, airbus) AS max_airbus,
        greatest(1000000 DIV {sampling:UInt32} DIV zoom_factor, other) AS max_other,
    
        pow(total / max_total, 1/5) AS transparency,
    
        255 * (1 + transparency) / 2 AS alpha,
        pow(boeing, 1/5) * 256 DIV (1 + pow(max_boeing, 1/5)) AS red,
        pow(airbus, 1/5) * 256 DIV (1 + pow(max_airbus, 1/5)) AS green,
        pow(other, 1/5) * 256 DIV (1 + pow(max_other, 1/5)) AS blue
    
        SELECT round(red)::UInt8, round(green)::UInt8, round(blue)::UInt8, round(alpha)::UInt8
    
    The redder the pixel, the more Boeing planes there.

    The greener the pixel, the more Airbus planes there.

    The bluer the pixel, the more non-Boeing/Airbus planes there.

    The less transparent the pixel, the more planes in total.

    White means all planes fly there, yellow means Boeing and Airbus dominate, red means Boeing dominates, green means Airbus dominates, cyan means Airbus+others, magenta means Boeing+others, etc.

  • keepamovin 2 hours ago

    I see you highlight that, but I believe the visualization is designed to be intuitive once you interact with it a bit—no legend stricty needed if you calibrate against what you already know.

    Pick a flight you know (maybe one near yer home) and play with the options -- what patterns emerge? Red draws attention, “Boeing vs. Airbus” compares data, while “Altitude & Velocity” combines them. Explore hands-on; discovery often makes insights click better than instructions.

cozzyd 2 hours ago

We have a an ADS-B receiver at Summit Station in Greenland which we use to track airplanes that produce RFI we see in our experiment. I've considered sharing data (since nobody else seems to have data there) but the feeding instructions always scare me (run this script that downloads a bunch of random crap as sudo... no thanks).

Please just give me a cURL command I can run... (perhaps some services have that, I haven't looked that hard).

  • toomuchtodo 2 hours ago

    https://airplanes.live/get-started/

    (other sites are corporate or have sold out [adsbexchange], happy to contribute reasonable costs to get a feed, no affiliation, I just like sensor feeds, thank you for the offer and consideration)

    • cozzyd an hour ago

      I appreciate the information! And yes, the fact that most sites are corporate makes me really distrustful of running random scripts from them.

      This is sort of an example of what I'm talking about though, this script seems to install a bunch of random stuff but what I really want is an API to incorporate into our own recording process. As far as I can tell from a brief look, this binary (?) is downloaded from somewhere and run: https://github.com/airplanes-live/feed/blob/main/scripts/air... but I just want to incorporate it in the system we're using already when I finally get to improving it from a 10-minute hack job from when I set it up as a side project that ended up being really useful (https://arxiv.org/abs/2506.17522)

    • ikmckenz 38 minutes ago

      What's the story behind adsbexchange selling out?

  • NoiseBert69 2 hours ago

    ADS-B is easy to receive with an 'rtlsdr' and opensource tools.

    • cozzyd an hour ago

      Yeah we are receiving it and dumping it into a sqlite database per day, but we're not sharing it.

  • rootusrootus 2 hours ago

    You can get containerized feeders for services like fr24 (e.g. liggy1/fr24feed) but that may not meet your requirements since it's really intended to handle everything from the sdr to the API, not siphon off data you are collecting some other way and then feed it.

    • cozzyd an hour ago

      Yeah I definitely don't want to run an opaque container either. We're already collecting and storing the data... I am happy to throw the data over via a udp socket or http request, but I don't want random software that we don't control running...

zX41ZdbW 2 hours ago

Thanks for posting!

I've recently added more datasets, "Places", "Birds", "Photos", and "You".

Also, a hint - the rectangular selection tool lets you generate custom reports for a location.

  • bwestergard 20 minutes ago

    This is super cool.

    Where is the bird dataset coming from? I assumed ebird at first, but these datapoints don't map on to ebird hotspots...

    Also, where did you get the collection of creative commons licensed bird species photos?

  • CamperBob2 24 minutes ago

    Awesome work, but please consider providing some contrast options. You can't see the country or continent boundaries unless they are full of tracks (or at least I can't.)

  • etskinner 2 hours ago

    What is "You"? I tried reading the query to understand but couldn't figure it out

    • zX41ZdbW 2 hours ago

      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...

      • etskinner 42 minutes ago

        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

      • dkenyser 2 hours ago

        Interestingly it seems to line up quite well with population density maps.

ronbenton 4 hours ago

URL makes this sound like it’s supposed to be scandalous

  • keepamovin 3 hours ago

    I know! I think the creator, brilliant as they must be, is not an English native speaker. Or perhaps they simply enjoy the controversy / provocation heh :)

    • ascorbic 31 minutes ago

      I think it's just a fun tld with the "adsb" domain available.

    • kevinsundar an hour ago

      Eh I think the name kinda works from the perspective that it exposes patterns in adsb data. If you just glanced at adsb maps you wouldn't really see many of these patterns unless you stared at it for a very long time.

nickysielicki an hour ago

I love how you can clearly make out the VFR EAA approach going into Oshkosh from Ripon. It’s only one week out of the year, but there’s so much traffic in that week that it still stands out.

blakesterz 4 hours ago

It took me a little while to figure this out, but it's pretty cool. Try the A-380 limit in the examples and it starts making sense pretty quick.

Also, .exposed has been a TLD since 2014? I'm not sure I've seen another .exposed site.

  • zparky 4 hours ago

    float.exposed is fun

scrozier 42 minutes ago

Eschew abbreviations!

jmux an hour ago

this is super cool!

sryNot_ 4 hours ago

Issue with adsb is that very few outside Europe and the US share their signals, so any app will have partial validity, unless you use satellite feeds.

  • Havoc 3 hours ago

    Last I looked at it coverage is pretty good for land globally? Sea less so.

    The bigger issue is that in first world buying a sdr dongle for giggles is viable while in poor countries less so. A raspberry and dongle is a substantial investment if you’re earning 1/20th of a US salary. Don’t think there is an issue with willingness to share data

  • keepamovin 3 hours ago

    How to utilize sat feeds with open data? Across ADS-B track data (like OpenSky Network) South America, Africa and Oceania seem covered in addition to Europe and America, as does East Asia, and India. But China, and some parts of Central Asia and Middle East appear absent?

  • computerfriend 2 hours ago

    I have had no problem accessing ADSB data for various parts of Asia.

  • esseph 3 hours ago

    A lot of people running SDRs send beacon info upstream on the internet.