Home / Companies / Confluent / Blog / Post Details
Content Deep Dive

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

Blog post from Confluent

Post Details
Company
Date Published
Author
Simon Aubury, Gil Friedlis, Matt Mangia
Word Count
1,238
Company Posts That Month
7
Language
English
Hacker News Points
4
Post removed?
No
Summary

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.

Trends Found in this Post
Trend Post Mentions Total Month Mentions Posts Companies MoM
Real-time 2 370 126 47 +1%
Use This Data

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.