PostGIS Tiger Geocoder 2025.1

The PostGIS development team is pleased to provide postgis_tiger_geocoder extension. This is the very first release since the break from the PostGIS core. This version requires PostgreSQL 16 and above and should work with any supported PostGIS version.

PostGIS 3.6 series is the last series to include postgis_tiger_geocoder. PostGIS 3.7 will be shipped without postgis_tiger_geocoder.

Moving forward postgis_tiger_geocoder has its own dedicated repo at OSGeo Gitea postgis_tiger_geocoder under the PostGIS org.

The versioning model has also changed to be versioned based on the year of the Census US Tiger dataset that is current at time of it’s release.

• 2025.1 source md5 NEWS README docs

For installing, refer to Installing the extension

If you are upgrading from an older release do:

ALTER EXTENSION postgis_tiger_geocoder UPDATE;

If you get an ERROR: extension "postgis_tiger_geocoder" has no update path from version "x to version "2025.1" or you are upgrading from a development version, do:

ALTER EXTENSION postgis_tiger_geocoder UPDATE TO "ANY";
ALTER EXTENSION postgis_tiger_geocoder UPDATE;

• Remove support for PostgreSQL < 16 (Regina Obe)
• postgis_tiger_geocoder moved out of the main PostGIS tree into its own repository during the PostGIS 3.7 cycle (Paul Ramsey, Regina Obe)
• quote_ident tiger loader schema and table names (Paul Ramsey)
• No longer set search path of database to include tiger. Users are expected to do this themselves.
• Refer to README for guidance (Regina Obe)

• GT-26, quote_ident tiger loader schema and table names (Paul Ramsey)
• GT-3, Prefix operators with system name space (Paul Ramsey)

• TR-6013, update the geocoder to load TIGER 2025 data (Regina Obe)

• GT-2, strip trailing country names before built-in normalize_address() parsing
• GT-10, support SH and compact SH121 input for state-highway geocoding
• GT-13, generate SP-GiST indexes for missing_indexes_generate_script() LIKE-search helpers
• GT-20, escape user-provided address fragments before interpolating them into normalize_address() regular expressions
• GT-24, create tiger_data schema from shell tiger loader scripts (Darafei Praliaskouski)
• TR-1599, 73892dce, improve country-aware address normalization in normalize_address() and related wrapper paths (Darafei Praliaskouski)
• TR-2459, 73892dce, speed up pagc_normalize_address() by avoiding redundant wrapper parsing while preserving ZIP+4 and country details from the structured parser (Darafei Praliaskouski)
• TR-1461, 73892dce, geocode_intersection() now tolerates irregular spacing in highway names such as I- 635 vs I-635 (Darafei Praliaskouski)