address_standardizer_data_us

地址标准化函数：美国数据集示例
仓库
https://git.osgeo.org/gitea/postgis/postgis
https://git.osgeo.org/gitea/postgis/postgis

概览

扩展包名版本分类许可证语言
postgis3.6.4GISGPL-2.0C
ID扩展名BinLibLoadCreateTrustReloc模式
1500postgis否是否是否否-
1501postgis_topology否是否是否否topology
1502postgis_raster否是否是否否-
1503postgis_sfcgal否是否是否是-
1504postgis_tiger_geocoder否是否是是否tiger
1505address_standardizer否是否是否是-
1506address_standardizer_data_us否是否是否是-
相关扩展nominatim_fdw country geoip tzf pg_geohash ogr_fdw

版本

类型仓库版本PG 大版本包名依赖
EXTPGDG3.6.41817161514postgis-
RPMPGDG3.6.31817161514postgis36_$v-
DEBPGDG3.6.41817161514postgresql-$v-postgis-3-
OS / PGPG18PG17PG16PG15PG14
el8.x86_64PGDG 3.6.3PGDG 3.6.3PGDG 3.6.3PGDG 3.6.3PGDG 3.6.3
el8.aarch64PGDG 3.6.3PGDG 3.6.3PGDG 3.6.3PGDG 3.6.3PGDG 3.6.3
el9.x86_64PGDG 3.6.3PGDG 3.6.3PGDG 3.6.3PGDG 3.6.3PGDG 3.6.3
el9.aarch64PGDG 3.6.3PGDG 3.6.3PGDG 3.6.3PGDG 3.6.3PGDG 3.6.3
el10.x86_64PGDG 3.6.3PGDG 3.6.3PGDG 3.6.3PGDG 3.6.3PGDG 3.6.3
el10.aarch64PGDG 3.6.3PGDG 3.6.3PGDG 3.6.3PGDG 3.6.3PGDG 3.6.3
d12.x86_64PGDG 3.6.4PGDG 3.6.4PGDG 3.6.4PGDG 3.6.4PGDG 3.6.4
d12.aarch64PGDG 3.6.4PGDG 3.6.4PGDG 3.6.4PGDG 3.6.4PGDG 3.6.4
d13.x86_64PGDG 3.6.4PGDG 3.6.4PGDG 3.6.4PGDG 3.6.4PGDG 3.6.4
d13.aarch64PGDG 3.6.4PGDG 3.6.4PGDG 3.6.4PGDG 3.6.4PGDG 3.6.4
u22.x86_64PGDG 3.6.4PGDG 3.6.4PGDG 3.6.4PGDG 3.6.4PGDG 3.6.4
u22.aarch64PGDG 3.6.4PGDG 3.6.4PGDG 3.6.4PGDG 3.6.4PGDG 3.6.4
u24.x86_64PGDG 3.6.4PGDG 3.6.4PGDG 3.6.4PGDG 3.6.4PGDG 3.6.4
u24.aarch64PGDG 3.6.4PGDG 3.6.4PGDG 3.6.4PGDG 3.6.4PGDG 3.6.4
u26.x86_64PGDG 3.6.4PGDG 3.6.4PGDG 3.6.4PGDG 3.6.4PGDG 3.6.4
u26.aarch64PGDG 3.6.4PGDG 3.6.4PGDG 3.6.4PGDG 3.6.4PGDG 3.6.4

安装

您可以直接安装 postgis 扩展包的预置二进制包，首先确保 PGDG 仓库已经添加并启用：

BASH 
pig repo add pgdg -u          # 添加 PGDG 仓库并更新缓存

使用 pig 或者是 apt/yum/dnf 安装扩展：

安装
BASH 
pig install postgis;          # 当前活跃 PG 版本安装
pig
BASH 
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
BASH 
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
BASH 
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

创建扩展：

SQL 
CREATE EXTENSION address_standardizer_data_us;

用法

Address Standardizer Data US：address_standardizer 扩展的美国地址数据

此扩展为 address_standardizer 扩展提供预置的美国词典、地名和规则数据。它包含常见美国街道类型、方向缩写、州名以及解析美国地址所需的语法规则表。

安装

SQL 
CREATE EXTENSION address_standardizer_data_us;

这将在 public 模式中创建预填充了美国地址数据的 us_lex、us_gaz 和 us_rules 表。

与 address_standardizer 配合使用

安装后即可立即标准化美国地址：

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

提供的数据涵盖常见的美国地址模式，包括：

  • 街道类型（Street、Avenue、Boulevard、Drive、Lane、Court 等）
  • 方向前缀和后缀（North、South、N、S、NW、SE 等）
  • 州名及其缩写
  • 单元标识符（Apt、Suite、Unit 等）
  • 公路标识符（US、State、County、Interstate 等）

最后修改 2026-08-12 · extension update 2026-08-12 (7a2fdbbd)