FOSS4GNA 2023 | Feeding Your 911 Data from QGISPostGIS - Randal Hale

Summary:

Feeding 911 data from QGIS/PostGIS is discussed by Randal Hale in his FOSS4GNA 2023 presentation. He shares insights into transitioning from proprietary to open-source tools, recounting experiences with a 911 proof-of-concept project in the Caribbean. The talk covers setting up PostGIS servers, overcoming challenges, and expanding GIS capabilities over time. Noteworthy aspects include leveraging GitHub for collaborative development, improving SQL scripts for efficiency, and adopting GeoPackage for streamlined data management.

Highlights:

🗺️ Randal Hale recounts experiences with a 911 addressing system project using QGIS/PostGIS in the Caribbean.

🔄 Transition from proprietary to open-source tools, emphasizing cost-effectiveness and increased flexibility.

🚀 Setting up PostGIS servers, overcoming challenges, and building a solid foundation for GIS data.

🤝 Collaboration with Chad to move away from manual data passing, adopting PostGIS for efficient data management.

🛠️ Continuous improvement: Randal discusses script enhancements, GitHub collaboration, and transitioning to GeoPackage.