Stage 1
Bounding Box + Haversine
28.21–28.56°N / -81.74 to -81.40°W eliminates 95% of CONUS data. Haversine distance to 4 park centers (MK, EPCOT, HS, AK). nearest_park assigned at ingest — no runtime geo math.
›
Stage 2
BigQuery Ingest
tbl_lightning_whisperer: strike_id, timestamp, lat/lon, energy_Joules, nearest_park, distance_miles. 20-mile radius filter. Flash rate aggregated per 15-min window.
›
Stage 3
Storm State Machine
5 states: CLEAR → WATCH → APPROACH → ACTIVE → SEVERE. Fuses GLM flash rate, METAR present-wx, NWS alerts, SPC outlooks, and 24hr forecast probability.