h3_postgis

H3与PostGIS集成的扩展插件
仓库
zachasme/h3-pg
https://github.com/zachasme/h3-pg

概览

扩展包名版本分类许可证语言
pg_h34.2.3GISApache-2.0C
ID扩展名BinLibLoadCreateTrustReloc模式
1530h3否是否是否是-
1531h3_postgis否是否是否是-
相关扩展h3 postgis postgis_raster postgis qdgc pg_geohash pgrouting q3c pg_polyline pg_eviltransform earthdistance mobilitydb

pgdg missing el8.x86.pg17 and el8.x86.pg18

版本

类型仓库版本PG 大版本包名依赖
EXTPGDG4.2.31817161514pg_h3h3, postgis, postgis_raster
RPMPGDG4.2.31817161514h3-pg_$v-
DEBPGDG4.2.31817161514postgresql-$v-h3-
OS / PGPG18PG17PG16PG15PG14
el8.x86_64PIGSTY 4.2.3PIGSTY 4.2.3PGDG 4.1.3PGDG 4.1.3PGDG 4.1.3
el8.aarch64PGDG 4.2.3PGDG 4.1.3PGDG 4.1.3PGDG 4.1.3PGDG 4.1.3
el9.x86_64PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3
el9.aarch64PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3
el10.x86_64PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3
el10.aarch64PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3
d12.x86_64PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3
d12.aarch64PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3
d13.x86_64PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3
d13.aarch64PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3
u22.x86_64PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3
u22.aarch64PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3
u24.x86_64PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3
u24.aarch64PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3
u26.x86_64PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3
u26.aarch64PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3PGDG 4.2.3

安装

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

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

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

安装
BASH 
pig install pg_h3;          # 当前活跃 PG 版本安装
pig
BASH 
pig ext install -y pg_h3 -v 18  # PG 18
pig ext install -y pg_h3 -v 17  # PG 17
pig ext install -y pg_h3 -v 16  # PG 16
pig ext install -y pg_h3 -v 15  # PG 15
pig ext install -y pg_h3 -v 14  # PG 14
dnf
BASH 
dnf install -y h3-pg_18       # PG 18
dnf install -y h3-pg_17       # PG 17
dnf install -y h3-pg_16       # PG 16
dnf install -y h3-pg_15       # PG 15
dnf install -y h3-pg_14       # PG 14
apt
BASH 
apt install -y postgresql-18-h3   # PG 18
apt install -y postgresql-17-h3   # PG 17
apt install -y postgresql-16-h3   # PG 16
apt install -y postgresql-15-h3   # PG 15
apt install -y postgresql-14-h3   # PG 14

创建扩展：

SQL 
CREATE EXTENSION h3_postgis CASCADE;  -- 依赖: h3, postgis, postgis_raster

用法

h3_postgis: H3 的 PostGIS 集成

h3_postgis 是将 H3 六边形层次空间索引与 PostGIS 集成的桥接扩展。它实现了 H3 索引与 PostGIS 几何类型之间的转换。

SQL 
CREATE EXTENSION h3_postgis CASCADE;

该扩展需要同时安装 h3 和 postgis。它提供了在 H3 单元格索引与 PostGIS 几何体之间转换的函数，使得可以将 H3 的六边形网格系统与 PostGIS 的空间能力结合使用。

主要函数

SQL 
-- 将 PostGIS 点转换为 H3 单元格索引
SELECT h3_latlng_to_cell(ST_MakePoint(-73.985, 40.748)::point, 9);

-- 获取 H3 单元格边界的 PostGIS 几何体
SELECT h3_cell_to_boundary_geometry('892a1008003ffff'::h3index);

-- 将 H3 单元格转换为 PostGIS 多边形用于可视化
SELECT h3_cell_to_geometry('892a1008003ffff'::h3index);

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