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

Global weather data from flying airplanes

Blog post from ClickHouse

Post Details
Company
Date Published
Author
Alexey Milovidov
Word Count
1,386
Company Posts That Month
30
Language
English
Hacker News Points
-
Post removed?
No
Summary

The blog post explores the innovative use of airplane telemetry data, such as position, altitude, speed, and heading, to derive weather information, specifically focusing on wind direction and speed, without directly measuring temperature or wind data. By utilizing the ADS-B Massive Visualizer and storing data in the ClickHouse database, the author demonstrates how comparing various in-flight measurements can yield insights into meteorological conditions. The post delves into the technical aspects of visualizing this data using color spaces like sRGB and OKLCH, where angles are represented by different hues, and discusses how crabbing angles, wind speed, and direction can be calculated. Despite not deriving actual temperatures due to the complexity of formulas, the post highlights the beauty and utility of visualizing derived data, comparing it to real-world weather patterns. The author also shares a method to create video visualizations of these data insights, underscoring the value of real-time, queryable data through ClickHouse and encouraging further exploration with a promotional offer for ClickHouse Cloud.

Trends Found in this Post
Trend Post Mentions Total Month Mentions Posts Companies MoM
Real-time 2 4,542 1,005 235 -31%
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.