Downloads 5.8kthis week

GitHub stars 4

Extension descriptor (YAML)

US address parsing and standardization (PAGC + Rust addrust)

Compatibility Matrix

This table covers all DuckDB releases that have not reached end-of-life, including LTS releases, and shows the 2 most recent patch releases of each. Older patch releases are not listed, but the extension may be available for them as well.

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

Overloaded Functions

This extension does not add any function overloads.

Added Types

This extension does not add any types.

Added Settings