PostGIS Project

PostGIS Project
Name	PostGIS Project
Operating system	Cross-platform
Genre	Spatial database extender
License	GNU General Public License

PostGIS Project PostGIS Project is an open-source spatial extender for the PostgreSQL object-relational database system that adds support for spatial objects and geographic queries. It enables spatial SQL, spatial indexing, and topological functions used by organizations such as NASA, European Space Agency, United Nations, World Bank, National Oceanic and Atmospheric Administration, Esri, Google, Uber, Amazon Web Services, Microsoft and Oracle in geospatial workflows. The project interoperates with standards from the Open Geospatial Consortium and integrates with client libraries like GDAL, GEOS, Proj, QGIS, MapServer, Leaflet, OpenLayers and GeoServer.

History

The project traces its origins to spatial extensions developed for PostgreSQL in the early 2000s, building on work from the PostGIS precursor libraries and contributors affiliated with institutions such as Oslandia, Refractions Research, Boundless (company), Khronos Group and researchers at University of California, Berkeley, University of Cambridge, Imperial College London and Massachusetts Institute of Technology. Early milestones aligned with releases of PostgreSQL major versions and with standardization efforts from the Open Geospatial Consortium and the ISO/TC 211 committee. The project evolved through community events like FOSS4G, State of the Map, Code Sprint, OSGeo gatherings, and conferences hosted by Red Hat, Linux Foundation, Apache Software Foundation meetups and corporate contributors including IBM, HP, Intel and Nokia.

Features and Architecture

PostGIS Project extends PostgreSQL with a spatial type system, spatial indexing, and a suite of functions for spatial analysis. Its architecture leverages underlying libraries such as GEOS for geometry operations, Proj for coordinate transformations, GDAL for raster/vector translation, and the liblwgeom library for internal geometry handling. The system supports standards from the Open Geospatial Consortium including Simple Features and implements SQL/MM spatial features aligned with ISO 19125. It integrates with networked services such as OGC Web Feature Service, OGC Web Map Service, OGC Web Coverage Service and cloud platforms like Amazon Web Services, Google Cloud Platform, Microsoft Azure and container ecosystems such as Docker and Kubernetes.

Data Types and Functions

PostGIS Project provides geometry and geography types, supporting two-dimensional, three-dimensional and measure-aware geometries used in analyses by teams at Harvard University, Stanford University, Cornell University, University of Oxford and Princeton University. Core functions include spatial predicates (e.g., ST_Intersects, ST_Contains), spatial measurements (e.g., ST_Distance, ST_Length), topology operators (e.g., ST_Touches), and construction utilities (e.g., ST_Buffer, ST_Union). Raster support includes coverage functions interoperable with GRASS GIS and SAGA GIS, and web mapping integrations with Mapbox, Carto, Mapnik, TileMill and CARTO platforms. The extension supports coordinate reference systems from the EPSG dataset and manages transformations using datasets maintained by European Petroleum Survey Group and standards influenced by International Hydrographic Organization.

Spatial Indexing and Performance

Performance in PostGIS Project relies on spatial indexing strategies implemented via GiST and SP-GiST index types in PostgreSQL, with optional use of BRIN and B-tree indexes for attributes. Query performance benefits from plane-sweep algorithms in GEOS, R-tree approximations, indexing heuristics used in pgRouting, and optimizer statistics tuned through tools from pgAdmin, PGBouncer and Patroni. High-performance deployments leverage hardware and software from NVIDIA GPUs, Intel processors, AMD EPYC platforms, NVMe storage arrays from Dell EMC, NetApp and distributed systems such as Ceph and Hadoop distributions maintained by Cloudera and Hortonworks.

Integration and Ecosystem

The PostGIS Project ecosystem includes client and server integrations with QGIS, ArcGIS, GeoServer, MapServer, OpenLayers, Leaflet, Mapbox GL JS, Cesium (software), Kepler.gl, GDAL/OGR, R spatial packages (e.g., sf (R package), rgdal), Python libraries like GeoPandas, Shapely, Fiona, psycopg2 and SQLAlchemy, and enterprise platforms such as Tableau, Power BI, SAS and SAP. Development tooling integrates with continuous integration services from Travis CI, GitHub Actions and GitLab CI/CD and source control hosted on GitHub, GitLab and mirrors maintained by Bitbucket.

Governance and Development

Project governance is driven by an open-source model involving community contributors, companies, and academic partners, with collaborative events at FOSS4G and coordination through channels affiliated with OSGeo and PostgreSQL Global Development Group. Contributors have included developers from Refractions Research, Boundless (company), MontserratTech and independent committers participating via GitHub pull requests and issue trackers. Funding and sponsorship have come from organizations like Google, ESRI, Amazon Web Services, European Commission research programs, Horizon 2020 projects, and national research grants from agencies such as NSF and EPSRC.

Use Cases and Adoption

Adoption scenarios span urban planning projects by City of New York, City of London, Los Angeles, Singapore Government, and Transport for London, environmental monitoring by United Nations Environment Programme, World Wildlife Fund, and Conservation International, logistics and routing by UPS, FedEx, DHL, ride-hailing by Lyft and Uber, telecommunications network planning by AT&T and Verizon Communications, and emergency management used by Federal Emergency Management Agency and national agencies in Australia, Canada, Germany and Japan. Academic use includes research labs at MIT Media Lab, ETH Zurich, Max Planck Society, CSIRO and CNRS applying spatial analytics, remote sensing, and land cover change detection.

Category:PostgreSQL extensions