address_standardizer_data_us

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_data_us;

Usage

Address Standardizer Data US: US address data for the address_standardizer extension

This extension provides pre-built US lexicon, gazetteer, and rules data for use with the address_standardizer extension. It includes tables with common US street types, directional abbreviations, state names, and grammar rules needed to parse US addresses.

• Address Standardizer Reference

Setup

CREATE EXTENSION address_standardizer_data_us;

This creates the us_lex, us_gaz, and us_rules tables in the public schema, pre-populated with US address data.

Using with address_standardizer

Once installed, you can immediately standardize US addresses:

SELECT *
FROM standardize_address(
    'us_lex', 'us_gaz', 'us_rules',
    '123 Main Street NW, Apt 4B, Springfield, IL 62704'
);

The provided data covers common US address patterns including:

• Street types (Street, Avenue, Boulevard, Drive, Lane, Court, etc.)
• Directional prefixes and suffixes (North, South, N, S, NW, SE, etc.)
• State names and abbreviations
• Unit designators (Apt, Suite, Unit, etc.)
• Highway designators (US, State, County, Interstate, etc.)