The Road Less Travelled: A corporation’s journey...
summary
A large insurer rewrites its geospatial stack to run natively on Postgres/PostGIS and a Greenplum data lake ingesting 230 source systems, replaces heavy ESRI dependence with Python, GeoServer, Flask and Leaflet, and prototypes Cesium and nodejs for visualization. Built automated ETL with foreign data wrappers, materialized views and tuned Postgres (st_subdivide, indexes, fillfactor 50) and ran a hex-grid claims analysis that cut claims-settlement insight time; migration works though scaling and real-time streaming (Kafka, Airflow, Spark) remain active priorities.
AI-written summary · about
chapters (11)
- 0:00Introduction and hero's journey
- 1:03IAG's geospatial evolution
- 5:45Call to action and data Lake
- 7:55Crossing into innovation
- 9:20Mentor and team challenges
- 11:49Temptations and open source
- 12:54Dark moment and technical hurdles
- 14:39Final conflict and cloud migration
- 16:06Return with the quest's benefits
- 17:49Mindset and automation
- 18:52Future plans and closing
