select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Geospatial

postgis

PostGIS geometry and geography spatial types and functions

pgext.cloud · Source code · Website · License text · Control file

Overview

Packagepostgis
Version3.6.4
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryPGDG
Extension typeStandard
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableNo
Stars9
Latest commit2026-05-11
Latest release2026-04-14
Catalogue updated2026-07-29

Related extensions

Required by

ast_postgisAdvanced spatial data types and spatial integrity constraints for PostGIS.
brin4postgisBRIN indexes for PostGIS
cartodbArchived PostgreSQL extension for turning a database into a CartoDB user database.
crankshaftArchived CARTO spatial-analysis functions for clustering, segmentation, and spatial statistics.
documentdbAPI surface for DocumentDB for PostgreSQL
dumppointsC implementation of ST_DumpPoints for PostGIS geometry collections.
fireflyPostGIS-backed Firefly database schema for tracking 3D points and add/delete operations by task.
frapiIn-database wrappers for French public-administration data APIs.
gbuilderAdditional geometry builders
geohash_extraAdditional geohash functions
geohistorical_objectsGeohistorical objects support
h3_postgisH3 PostGIS integration
hamradioham radio extension
hartonomousHartonomous substrate — schemas, types, tables, BLAKE3, S^3 geometry, traversal, UCD/UCA atoms
htcHorvitz-Thompson continuous-population estimator functions for PostgreSQL.
li3dsPostgreSQL extension for managing 3D sensor data
livewirepower delivery modeling
lostgisLostGIS spatial helper functions and types
mastermobilitydbSchema, types, and utilities for managing moving-object trajectories with MobilityDB.
mobilitydbMobilityDB geospatial trajectory data management & analysis platform
nfiestaPostgreSQL extension implementing nFIESTA forest inventory estimation functionality.
nfiesta_gisdatanfi gisdata database
nfiesta_sdesignPostgreSQL extension for manipulating sampling design data.
osrmintPostgreSQL route OSRM integration
pg_eviltransformCoordinate transforms for BD09/GCJ02 via PostGIS ST_Transform
pg_geohash_extraAdditional geohash functions for PostGIS
pg_lake_spatialAdds geospatial file-format and spatial-function support to pg_lake through PostGIS and GDAL-backed workflows.
pg_landmetricsA PostgreSQL/PostGIS extension for calculating landscape metrics.
pg_popyramids_datamartsCreates population-pyramid analytics data-mart objects in a hard-coded dms schema from a pre-existing ods schema.
pg_siose_benchA PostgreSQL extension for benchmarking different SIOSE database configurations (pure relational, with indexes, json, jsonb, xml, etc))
pg_tilelessTools for packaging twkb in sqlite for tileless
pg_tmsfunctions to tile rasters in TMS format
pg_trajectoryDefine PostGIS trajectory types and spatiotemporal analysis functions in SQL and PL/pgSQL
pg_twkbTWKB tools etc
pg_wuiPostgreSQL extension for wildland urban interface data analysis using SIOSE databases
pg_xarrayCatalog and query layer for chunked scientific arrays (NetCDF, Zarr, HDF5, GRIB, COG, SELAFIN, MED, CGNS, FITS)
pgh3Expose Uber H3 hierarchical geospatial indexing functions for PostGIS geometries
pgh_consistencyPfafstetter consistency checks for PgHydro
pgh_hgmHydrogeomorphological analysis extension for PgHydro
pgh_outputOutput and reporting objects for PgHydro
pgh_output_en_auAustralian English output pack for PgHydro
pgh_output_pt_brBrazilian Portuguese output pack for PgHydro
pgh_rasterRaster hydrology extension for PgHydro
pghydroDrainage network analysis core for PostgreSQL and PostGIS
pgroutingpgRouting Extension
plv8geoPL/v8 geospatial functions that bundle D3, TopoJSON, JSTS, GeoTIFF and related JavaScript libraries for PostGIS workflows.
pointcloud_postgisintegration for pointcloud LIDAR data and PostGIS geometry data
postgis_domainsDefine reusable PostGIS geometry and geography domains constrained to valid, simple SRID 4326 values
postgis_lettersconvert text letters into PostGIS geometries using packaged vector fonts
postgis_rasterPostGIS raster types and functions
postgis_sfcgalPostGIS SFCGAL functions
postgis_tiger_geocoderPostGIS tiger geocoder and reverse geocoder
postgis_topologyPostGIS topology spatial types and functions
qdgc_postgisAdd PostGIS geometry and geography bindings plus area-to-cell fills for QDGC.
rasterdbrasterdb: filesystem-backed PostGIS raster foreign data wrapper
rtilesRust/PostGIS extension for serving configurable Mapbox Vector Tile layers for self-hosted interactive maps.
siguanet_questApplication-specific PL/pgSQL reporting layer for spatial aggregation over SIGUANET/PostGIS campus asset databases.
vasavgeomVague geometry handler - VASA

See also

pgroutingpgRouting Extension
h3H3 bindings for PostgreSQL
mobilitydbMobilityDB geospatial trajectory data management & analysis platform
ogr_fdwforeign-data wrapper for GIS data access
pointclouddata type for lidar point clouds
q3cq3c sky indexing plugin
pg_spherespherical objects with useful functions, operators and index support
nominatim_fdwNominatim Foreign Data Wrapper for PostgreSQL
pg_polylineFast Google Encoded Polyline encoding & decoding for postgres
earthdistancecalculate great-circle distances on the surface of the Earth
pg_eviltransformCoordinate transforms for BD09/GCJ02 via PostGIS ST_Transform
pg_geohashHandle geohash based functionality for spatial coordinates

Same project

postgis_topologyPostGIS topology spatial types and functions
postgis_rasterPostGIS raster types and functions
postgis_sfcgalPostGIS SFCGAL functions
postgis_tiger_geocoderPostGIS tiger geocoder and reverse geocoder
address_standardizerUsed to parse an address into constituent elements. Generally used to support geocoding address normalization step.
address_standardizer_data_usAddress Standardizer US dataset example