PostGIS Spatial Database Extension

PostGIS is a spatial database extender for PostgreSQL object-relational database, adding support for geographic objects and allowing location queries to be run in SQL. Developed by Refractions Research (Paul Ramsey and team) in 2001, later maintained by the Oslandia group and a broad open-source community, PostGIS has become the de facto standard for open-source spatial databases, with widespread adoption by governments, enterprises, and mapping platforms worldwide. Key features include: geometry and geography types (OGC Simple Features for SQL specification compliance with Point, LineString, Polygon, MultiPoint, MultiLineString, MultiPolygon, and GeometryCollection in projected and geographic coordinate systems), raster data support (storing, querying, and analyzing raster data with map algebra, pixel value extraction, and raster-vector conversion), topology support (topological data model with edges, faces, and nodes for network analysis), spatial indexing (GiST and SP-GiST indexes for spatial query acceleration, plus 3D and 4D indexing), spatial functions (over 500 functions for measurement, transformation, overlay, proximity, geometry processing, and coordinate conversion using PROJ and GEOS), coordinate reference systems (integration with PROJ library supporting over 6,000 CRS definitions and custom transformations), Tiger Geocoder (address standardization and census data-based geocoding for the United States), routing (pgRouting extension for shortest path, traveling salesperson, and driving distance analysis), 3D and TIN support (3D geometries, polyhedral surfaces, triangular irregular networks), point cloud support (pointcloud extension for LiDAR and photogrammetry data), and external integration (GDAL, QGIS, GeoServer, MapServer, and ArcGIS compatibility).