When people think of GIS, they picture maps. But the most important decisions in a geospatial system are made below the map, in how spatial data is stored, validated and queried. For most web-based GIS applications, PostgreSQL with the PostGIS extension is an excellent foundation.
Spatial analysis where the data lives
PostGIS adds geometry and geography types, spatial indexes and hundreds of spatial functions to PostgreSQL. Questions such as "which households are more than five kilometres from a health facility?" or "which deliveries crossed this district boundary?" become SQL queries that run close to the data, using indexes designed for spatial search.
Because the analysis happens in the database, every application that connects to it, whether a web map, a dashboard or a desktop GIS, works from the same results. There is no drift between a figure in a report and a figure on the map.
One database for spatial and business data
Spatial data rarely stands alone. A facility has staff, stock and services; a vehicle has trips, drivers and maintenance records. Keeping geometry and business data in the same relational database means they can be joined, constrained and secured together, without synchronizing separate systems.
It works with the tools specialists already use
- QGIS and ArcGIS can connect directly to PostGIS for editing and advanced analysis.
- GeoServer can publish PostGIS tables as standard WMS and WFS services.
- Web libraries such as Leaflet and Mapbox can display vector tiles generated from the same data.
Quality is built into the schema
Spatial data has its own failure modes: invalid geometries, mixed coordinate reference systems and duplicate features. Database constraints, validation functions and consistent projections catch these problems when data is loaded, rather than when an analysis quietly returns the wrong answer.
A beautiful map built on inconsistent data is still the wrong map.
PostGIS is not the only option, and very large or specialized workloads may need additional tools. As the core of a geospatial platform, however, it offers a rare combination of maturity, openness and analytical power.