address_standardizer

Overview

Version

Install

You can install postgis directly. First, make sure the PGDG repository is added and enabled:

pig repo add pgdg -u          # Add PGDG repo and update cache

Install the extension using pig or apt/yum/dnf:

pig install postgis;          # Install for current active PG version

pig ext install -y postgis -v 18  # PG 18
pig ext install -y postgis -v 17  # PG 17
pig ext install -y postgis -v 16  # PG 16
pig ext install -y postgis -v 15  # PG 15
pig ext install -y postgis -v 14  # PG 14

dnf install -y postgis36_18       # PG 18
dnf install -y postgis36_17       # PG 17
dnf install -y postgis36_16       # PG 16
dnf install -y postgis36_15       # PG 15
dnf install -y postgis36_14       # PG 14

apt install -y postgresql-18-postgis-3   # PG 18
apt install -y postgresql-17-postgis-3   # PG 17
apt install -y postgresql-16-postgis-3   # PG 16
apt install -y postgresql-15-postgis-3   # PG 15
apt install -y postgresql-14-postgis-3   # PG 14

Create Extension:

CREATE EXTENSION address_standardizer;

Usage

Address Standardizer: Address parsing and standardization for PostGIS

The Address Standardizer is a PostGIS extension that parses a single-line address string into a structured form using configurable lexicon, grammar, and rules tables. It is a more flexible alternative to the built-in normalize_address function in the TIGER geocoder.

• Address Standardizer Reference

Setup

CREATE EXTENSION address_standardizer;

Standardizing Addresses

The core function takes an address string and three table references (lex, gaz, rules):

SELECT *
FROM standardize_address(
    'us_lex',        -- lexicon table
    'us_gaz',        -- gazetteer table
    'us_rules',      -- rules table
    '1600 Pennsylvania Ave NW, Washington, DC 20500'
);

The result contains structured fields:

Lexicon, Gazetteer, and Rules Tables

The standardizer is driven by three user-configurable tables:

Lexicon (lex) – Maps input tokens to standardized forms and token classes:

CREATE TABLE us_lex (
    id serial PRIMARY KEY,
    seq integer,
    word text,
    stdword text,
    token integer
);

Gazetteer (gaz) – Maps place names (cities, states) to standard forms:

CREATE TABLE us_gaz (
    id serial PRIMARY KEY,
    seq integer,
    word text,
    stdword text,
    token integer
);

Rules (rules) – Defines grammar rules for parsing addresses:

CREATE TABLE us_rules (
    id serial PRIMARY KEY,
    rule text
);

For US addresses, the address_standardizer_data_us extension provides pre-built data for these tables.