select open change scope Open full search

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

Extensions / Geospatial

postgis_tiger_geocoder

PostGIS tiger geocoder and reverse geocoder

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
TrustedYes
RelocatableNo
Schematiger
Stars9
Latest commit2026-05-11
Latest release2026-04-14
Catalogue updated2026-07-29

Related extensions

Requires

postgisPostGIS geometry and geography spatial types and functions
fuzzystrmatchdetermine similarities and distance between strings

See also

nominatim_fdwNominatim Foreign Data Wrapper for PostgreSQL
geoipIP-based geolocation query
tzfFast lookup timezone name by GPS coordinates
pg_geohashHandle geohash based functionality for spatial coordinates
ogr_fdwforeign-data wrapper for GIS data access

Same project

postgisPostGIS geometry and geography spatial types and functions
postgis_topologyPostGIS topology spatial types and functions
postgis_rasterPostGIS raster types and functions
postgis_sfcgalPostGIS SFCGAL functions
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