Search Shortcut cmd + k | ctrl + k
us_address_standardizer

US address parsing and standardization (PAGC + Rust addrust)

Maintainer(s): ericmanning, sj-io

Installing and Loading

INSTALL us_address_standardizer FROM community;
LOAD us_address_standardizer;

Example

-- addrust parser (no reference tables required)
SELECT addrust_parse('123 N Main St Apt 4, Springfield IL 62704');

-- PAGC (Postgis) standardizer (loads reference tables from embedded data)
SELECT load_us_address_data();
SELECT standardize_address('us_lex', 'us_gaz', 'us_rules',
    '123 Main Street', 'Kansas City, MO 45678');

About us_address_standardizer

Provides two US address parsers:

  • addrust_parse — Rust-based parser from the addrust project, with optional TOML configuration for customizable parsing pipelines.
  • parse_address / standardize_address — PAGC rule-based parsers ported from the PostGIS address_standardizer. Call load_us_address_data() first to populate the reference tables from data embedded in the extension binary.
  • For more information, visit the GitHub repository.

Added Functions

function_name function_type description comment examples
addrust_parse scalar NULL NULL  
debug_standardize_address scalar NULL NULL  
load_us_address_data scalar NULL NULL  
parse_address scalar NULL NULL  
standardize_address scalar NULL NULL  

Overloaded Functions

This extension does not add any function overloads.

Added Types

This extension does not add any types.

Added Settings

This extension does not add any settings.