Noise Mapping with KSQL, a Raspberry Pi and a Software-Defined Radio
Blog post from Confluent
To determine which plane is disturbing a cat's sleep by utilizing Apache Kafka and KSQL, a streaming SQL engine for Apache Kafka, along with a Raspberry Pi and RTL2832U, a software-defined radio (SDR) device can be used. Raw ADS-B signals are processed on the Raspberry Pi, separated into location update messages or identification messages, and then relayed to Kafka topics using a Confluent REST Proxy. KSQL is used to combine the incoming stream of location data against reference data topics, creating enriched topics such as `location_and_details_stream` and `ident_callsign_stream`. These topics can be used to create dashboards displaying aircraft location on a map, manufacturer information, altitude, and destination routes, allowing for real-time analysis and monitoring.
| Trend | Post Mentions | Total Month Mentions | Posts | Companies | MoM |
|---|---|---|---|---|---|
| Real-time | 2 | 370 | 126 | 47 | +1% |
Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.