address_standardizer_data_us

postgis : Address Standardizer US dataset example

Overview

Packages

Source

Install

Make sure PGDG repo available:

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

Install this extension with pig:

pig install postgis;		# install via package name, for the active PG version
pig install address_standardizer_data_us;		# install by extension name, for the current active PG version

pig install address_standardizer_data_us -v 18;   # install for PG 18
pig install address_standardizer_data_us -v 17;   # install for PG 17
pig install address_standardizer_data_us -v 16;   # install for PG 16
pig install address_standardizer_data_us -v 15;   # install for PG 15
pig install address_standardizer_data_us -v 14;   # install for PG 14

Create this extension with:

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.)