# postgis/postgis

PostGIS spatial database extension to PostgreSQL [mirror]

Repository: https://github.com/postgis/postgis
Canonical: https://ross.abutalabs.com/products/postgis
Homepage: https://postgis.net
Language: PLpgSQL
License: GPL-2.0
License Family: copyleft
Topics: postgis, postgresql, geospatial, plpgsql, c, gis
Last push: 2026-08-26T09:39:54+00:00

## Health v2 (maintenance only)
Score: 77/100 (v2, computed 2026-09-02T17:46:02.011165+00:00)
- activity 99, release rhythm 35, longevity 100
- inputs: {"age_days": 5216, "days_push": 7, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: no_releases
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 2209, forks 433 (observed 2026-08-28T04:06:26.152032+00:00)

## What it is
PostGIS is a spatial extension for PostgreSQL that adds storage, indexing, and querying of geospatial vector and raster data. It provides hundreds of spatial SQL functions for geometry processing, measurement, reprojection, and geocoding.

## Use cases
- store and query points, lines, and polygons in postgres
- find all locations within a radius of a point
- calculate distances and areas between geometries
- reproject coordinates between spatial reference systems
- import openstreetmap data for spatial analysis
- geocode and reverse geocode addresses in sql
- serve spatial data to qgis or geoserver

## When to choose
- you need spatial queries and indexes on top of an existing postgresql database
- you want a mature, standards-compliant open-source gis database engine
- your stack already uses postgresql and you want to avoid a separate spatial database

## When to avoid
- you need a lightweight embedded spatial database without running postgres
- your project has no geospatial data or queries
- you require a managed database service that does not offer the postgis extension

## Facets
- artifact type: library
- maturity: stable
- function: database, geospatial, search-engine, data-science
- domain: databases
- platform: windows, self-hosted, cloud
- tags: postgresql-extension, spatial-sql, gis, spatial-indexing, raster, geocoding, openstreetmap, geospatial, maps, linux, macos, docker

## Member repositories
- postgis/postgis (main) score 77

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:06:26.152032+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T02:46:19.419413+00:00, confidence not recorded.
  - readme: https://github.com/postgis/postgis (fetched 2026-08-28T04:06:26.152032+00:00, sha b21555ee2bc6)
  - homepage: https://postgis.net (fetched 2026-08-29T10:26:52.519278+00:00, sha 966dfcf7b868)
  - site_page: https://postgis.net/documentation/developer_docs (fetched 2026-08-29T10:26:52.537702+00:00, sha b92a1b27d25e)
  - site_page: https://postgis.net/documentation/tips (fetched 2026-08-29T10:26:52.534163+00:00, sha f936b11e9db3)
  - site_page: https://postgis.net/documentation/training (fetched 2026-08-29T10:26:52.535749+00:00, sha 1520f89edb76)
  - site_page: https://postgis.net/documentation (fetched 2026-08-29T10:26:52.528619+00:00, sha 0f0b805b3b9d)
  - site_page: https://postgis.net/documentation/getting_started (fetched 2026-08-29T10:26:52.530697+00:00, sha e2b5cde48888)
  - site_page: https://postgis.net/documentation/manual (fetched 2026-08-29T10:26:52.532550+00:00, sha 2add540c4d63)
  - site_page: https://postgis.net/documentation/faq (fetched 2026-08-29T10:26:52.539216+00:00, sha 87aef928dc01)
  - site_page: https://postgis.net/development/source_code (fetched 2026-08-29T10:26:52.540773+00:00, sha bb1e2882a031)
- Data as of 2026-08-30T08:39:29.467469+00:00.