How to store weather forecast data for fast time-series APIs
In this post, I am explaining how Open-Meteo APIs store numerical weather-model data for fast access. I will briefly explain:Basics of geographical gridsWhat weather-model runs areShow different storage approaches for gridded dataHow efficient weather forecast APIs can be designedWeather-models store data in grids with columns for east-west direction and rows for north-south direction. With 1000 columns and 1000 rows you would get 1 million grid-cells. With an earth circumference of around 40.00...
Read more at openmeteo.substack.com