Wildfire-Twin: streaming geospatial digital twin
Real-time fire-risk joins against 11.5M building footprints, indexed with H3 at resolution 7 and landed in a DuckDB analytical sink that keeps the dashboard stable at statewide zoom.
The spatial join was the bottleneck, and it wasn't the algorithm: it was the boundary. Moving the join onto native Sedona Java expressions instead of crossing into Python per row cut P95 latency by 91%, from 215s to 18.65s.