I’m tracking influenza-like illness across 64 neighborhoods and pushing a hex-grid hotspot map to our clinic teams by 9 a.m., but my ArcGIS Pro + PostGIS ETL (7 a.m. lab feed, binning, Emerging Hot Spot Analysis) still runs too slow. What tweaks or tool swaps have helped you get near-real-time disease maps out the door without losing spatial accuracy?
swaps have helped you get near-real-time disease maps out the door without losing spatial accuracy? Agree — shifting hex binning to H3 in Postgres (h3-pg), storing an h3 index per record and aggregating in a materialized view, let ArcGIS Pro just draw pre-binned features; our 7–9 a.m. run dropped from about 40 min to about 8, with the caveat that EHSA is still heavy so we incrementally rebuild only the last 6–8 weeks — want the view/index snippet?
Short answer from my side: I’m seeing the same pattern — one concrete thing that helped was writing down the exact handoff and timebox it to 15–20 min. Does that match what you’re running into?