Noise Mapping with KSQL, a Raspberry Pi and a Software-Defined Radio | Confluent

What this post added

This post details using a Raspberry Pi with a Software-Defined Radio (SDR) to capture ADS-B aircraft transmissions. The captured data is then sent to Kafka topics (location-topic and ident-topic) via the Confluent REST Proxy. KSQL is used to enrich this data by joining it with reference data (ICAO to aircraft mapping and callsign details) to create new streams (location_and_details_stream and ident_callsign_stream). These enriched streams are then pushed to Elasticsearch using Kafka Connect for visualization in Kibana dashboards. The post demonstrates a specific use case of identifying a low-flying aircraft that woke the author's cat by querying the enriched location data.