ETL for 15 million GPS pings: stack and architecture https://sudonull.com/etl-for-15-million-gps-pings-stack-and-architecture
Breakdown of ETL system processing 15 million GPS coordinates of buses per day. PostgreSQL, PostGIS, PySpark, Data Vault. Trip segmentation and spatial analytics for middle/senior dev. Study the implementation.
Satellite imagery selection by water level https://sudonull.com/satellite-imagery-selection-by-water-level
Learn how the “Uroven-Sputnik” service automates Landsat and Sentinel search for hydrological data. Architecture on PostGIS, STAC and MPC for hydrologists. Study the stack and implementation.