select open change scope Open full search

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

Extensions / Geospatial

historical_geocoding

SQL toolkit for geocoding historical addresses by combining textual, temporal, and spatial evidence.

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

Overview

Packagehistorical_geocoding
Version1.0
RepositoryUnspecified
Extension typeSQL only
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableNo
Schemahistorical_geocoding
Stars5
Latest commit2018-07-19
Catalogue updated2026-08-30

Related extensions

Requires

geohistorical_objectsGeohistorical objects support
postalPostgreSQL bindings for libpostal that normalize free-form addresses and parse them into labeled components.
unaccenttext search dictionary that removes accents

See also

addressing_dictionaryAddress handling dictionaries for PostgreSQL, applying smarter handling to addresses in text search.
pg_geohashHandle geohash based functionality for spatial coordinates
postalPostgreSQL bindings for libpostal that normalize free-form addresses and parse them into labeled components.
address_standardizerUsed to parse an address into constituent elements. Generally used to support geocoding address normalization step.
lostgisLostGIS spatial helper functions and types
qdgcEncode, decode, navigate, and fill Extended Quarter Degree Grid Cell codes in pure SQL.
frapiIn-database wrappers for French public-administration data APIs.
h3H3 bindings for PostgreSQL
knxdata types for KNX Addresses
ocgeo_fdwForeign data wrapper for the OpenCageData API