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