h3

H3 bindings for PostgreSQL

Overview

ID	Extension	Package	Version	Category	License	Language
1530	h3	pg_h3	`4.2.3`	GIS	Apache-2.0	C

Attribute	Has Binary	Has Library	Need Load	Has DDL	Relocatable	Trusted
--s-d-r	No	Yes	No	Yes	yes	no

Relationships
Need By	h3_postgis
See Also	postgis q3c pg_geohash postgis_topology postgis_raster postgis_sfcgal postgis_tiger_geocoder address_standardizer
Siblings	h3_postgis

no el8.pg17.x86

Packages

Type	Repo	Version	PG Major Availability	Package Pattern	Dependencies
EL	PGDG	`4.2.3`	18 17 16 15 14 13	`h3-pg_$v*`	-
Debian	PGDG	`4.2.3`	18 17 16 15 14 13	`postgresql-$v-h3`	-

Linux / PG	PG18	PG17	PG16	PG15	PG14	PG13
el8.x86_64	MISS	MISS	PGDG 4.1.3	PGDG 4.1.3	PGDG 4.1.3	PGDG 4.1.3
el8.aarch64	PGDG 4.2.3	PGDG 4.1.3	PGDG 4.1.3	PGDG 4.1.3	PGDG 4.1.3	PGDG 4.1.3
el9.x86_64	PGDG 4.2.3	PGDG 4.1.3	PGDG 4.1.3	PGDG 4.1.3	PGDG 4.1.3	PGDG 4.1.3
el9.aarch64	PGDG 4.2.3	PGDG 4.1.3	PGDG 4.1.3	PGDG 4.1.3	PGDG 4.1.3	PGDG 4.1.3
el10.x86_64	PGDG 4.2.3	PGDG 4.2.2	PGDG 4.2.2	PGDG 4.2.2	PGDG 4.2.2	PGDG 4.2.2
el10.aarch64	PGDG 4.2.3	PGDG 4.2.2	PGDG 4.2.2	PGDG 4.2.2	PGDG 4.2.2	PGDG 4.2.2
d12.x86_64	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3
d12.aarch64	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3
d13.x86_64	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3
d13.aarch64	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3
u22.x86_64	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3
u22.aarch64	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3
u24.x86_64	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3
u24.aarch64	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3	PGDG 4.2.3

Package	Version	OS	ORG	SIZE	File URL
`h3-pg_18`	4.2.3	`el8.aarch64`	pgdg	70.5 KiB	h3-pg_18-4.2.3-1PGDG.rhel8.aarch64.rpm
`h3-pg_18`	4.2.3	`el9.x86_64`	pgdg	72.6 KiB	h3-pg_18-4.2.3-1PGDG.rhel9.x86_64.rpm
`h3-pg_18`	4.2.3	`el9.aarch64`	pgdg	70.7 KiB	h3-pg_18-4.2.3-1PGDG.rhel9.aarch64.rpm
`h3-pg_18`	4.2.3	`el10.x86_64`	pgdg	73.2 KiB	h3-pg_18-4.2.3-1PGDG.rhel10.x86_64.rpm
`h3-pg_18`	4.2.3	`el10.aarch64`	pgdg	72.6 KiB	h3-pg_18-4.2.3-1PGDG.rhel10.aarch64.rpm
`postgresql-18-h3`	4.2.3	`d12.x86_64`	pgdg	52.6 KiB	postgresql-18-h3_4.2.3-2.pgdg12+1_amd64.deb
`postgresql-18-h3`	4.2.3	`d12.aarch64`	pgdg	50.7 KiB	postgresql-18-h3_4.2.3-2.pgdg12+1_arm64.deb
`postgresql-18-h3`	4.2.3	`d13.x86_64`	pgdg	52.8 KiB	postgresql-18-h3_4.2.3-2.pgdg13+1_amd64.deb
`postgresql-18-h3`	4.2.3	`d13.aarch64`	pgdg	51.4 KiB	postgresql-18-h3_4.2.3-2.pgdg13+1_arm64.deb
`postgresql-18-h3`	4.2.3	`u22.x86_64`	pgdg	48.6 KiB	postgresql-18-h3_4.2.3-2.pgdg22.04+1_amd64.deb
`postgresql-18-h3`	4.2.3	`u22.aarch64`	pgdg	46.5 KiB	postgresql-18-h3_4.2.3-2.pgdg22.04+1_arm64.deb
`postgresql-18-h3`	4.2.3	`u24.x86_64`	pgdg	48.6 KiB	postgresql-18-h3_4.2.3-2.pgdg24.04+1_amd64.deb
`postgresql-18-h3`	4.2.3	`u24.aarch64`	pgdg	47.1 KiB	postgresql-18-h3_4.2.3-2.pgdg24.04+1_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`h3-pg_17`	4.1.3	`el8.aarch64`	pgdg	63.8 KiB	h3-pg_17-4.1.3-3PGDG.rhel8.aarch64.rpm
`h3-pg_17`	4.1.3	`el9.x86_64`	pgdg	65.8 KiB	h3-pg_17-4.1.3-3PGDG.rhel9.x86_64.rpm
`h3-pg_17`	4.1.3	`el9.aarch64`	pgdg	64.3 KiB	h3-pg_17-4.1.3-3PGDG.rhel9.aarch64.rpm
`h3-pg_17`	4.2.2	`el10.x86_64`	pgdg	71.7 KiB	h3-pg_17-4.2.2-1PGDG.rhel10.x86_64.rpm
`h3-pg_17`	4.2.2	`el10.aarch64`	pgdg	71.0 KiB	h3-pg_17-4.2.2-1PGDG.rhel10.aarch64.rpm
`postgresql-17-h3`	4.2.3	`d12.x86_64`	pgdg	52.7 KiB	postgresql-17-h3_4.2.3-2.pgdg12+1_amd64.deb
`postgresql-17-h3`	4.2.3	`d12.aarch64`	pgdg	50.7 KiB	postgresql-17-h3_4.2.3-2.pgdg12+1_arm64.deb
`postgresql-17-h3`	4.2.3	`d13.x86_64`	pgdg	52.9 KiB	postgresql-17-h3_4.2.3-2.pgdg13+1_amd64.deb
`postgresql-17-h3`	4.2.3	`d13.aarch64`	pgdg	51.4 KiB	postgresql-17-h3_4.2.3-2.pgdg13+1_arm64.deb
`postgresql-17-h3`	4.2.3	`u22.x86_64`	pgdg	48.7 KiB	postgresql-17-h3_4.2.3-2.pgdg22.04+1_amd64.deb
`postgresql-17-h3`	4.2.3	`u22.aarch64`	pgdg	46.5 KiB	postgresql-17-h3_4.2.3-2.pgdg22.04+1_arm64.deb
`postgresql-17-h3`	4.2.3	`u24.x86_64`	pgdg	48.6 KiB	postgresql-17-h3_4.2.3-2.pgdg24.04+1_amd64.deb
`postgresql-17-h3`	4.2.3	`u24.aarch64`	pgdg	47.3 KiB	postgresql-17-h3_4.2.3-2.pgdg24.04+1_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`h3-pg_16`	4.1.3	`el8.x86_64`	pgdg	65.9 KiB	h3-pg_16-4.1.3-1PGDG.rhel8.x86_64.rpm
`h3-pg_16`	4.1.3	`el8.aarch64`	pgdg	63.6 KiB	h3-pg_16-4.1.3-1PGDG.rhel8.aarch64.rpm
`h3-pg_16`	4.1.3	`el9.x86_64`	pgdg	65.4 KiB	h3-pg_16-4.1.3-1PGDG.rhel9.x86_64.rpm
`h3-pg_16`	4.1.3	`el9.aarch64`	pgdg	63.8 KiB	h3-pg_16-4.1.3-1PGDG.rhel9.aarch64.rpm
`h3-pg_16`	4.2.2	`el10.x86_64`	pgdg	71.6 KiB	h3-pg_16-4.2.2-1PGDG.rhel10.x86_64.rpm
`h3-pg_16`	4.2.2	`el10.aarch64`	pgdg	71.0 KiB	h3-pg_16-4.2.2-1PGDG.rhel10.aarch64.rpm
`postgresql-16-h3`	4.2.3	`d12.x86_64`	pgdg	52.6 KiB	postgresql-16-h3_4.2.3-2.pgdg12+1_amd64.deb
`postgresql-16-h3`	4.2.3	`d12.aarch64`	pgdg	50.7 KiB	postgresql-16-h3_4.2.3-2.pgdg12+1_arm64.deb
`postgresql-16-h3`	4.2.3	`d13.x86_64`	pgdg	52.9 KiB	postgresql-16-h3_4.2.3-2.pgdg13+1_amd64.deb
`postgresql-16-h3`	4.2.3	`d13.aarch64`	pgdg	51.4 KiB	postgresql-16-h3_4.2.3-2.pgdg13+1_arm64.deb
`postgresql-16-h3`	4.2.3	`u22.x86_64`	pgdg	48.7 KiB	postgresql-16-h3_4.2.3-2.pgdg22.04+1_amd64.deb
`postgresql-16-h3`	4.2.3	`u22.aarch64`	pgdg	46.5 KiB	postgresql-16-h3_4.2.3-2.pgdg22.04+1_arm64.deb
`postgresql-16-h3`	4.2.3	`u24.x86_64`	pgdg	48.7 KiB	postgresql-16-h3_4.2.3-2.pgdg24.04+1_amd64.deb
`postgresql-16-h3`	4.2.3	`u24.aarch64`	pgdg	47.2 KiB	postgresql-16-h3_4.2.3-2.pgdg24.04+1_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`h3-pg_15`	4.1.3	`el8.x86_64`	pgdg	65.9 KiB	h3-pg_15-4.1.3-1PGDG.rhel8.x86_64.rpm
`h3-pg_15`	4.1.3	`el8.aarch64`	pgdg	63.6 KiB	h3-pg_15-4.1.3-1PGDG.rhel8.aarch64.rpm
`h3-pg_15`	4.1.3	`el9.x86_64`	pgdg	65.5 KiB	h3-pg_15-4.1.3-1PGDG.rhel9.x86_64.rpm
`h3-pg_15`	4.1.3	`el9.aarch64`	pgdg	63.8 KiB	h3-pg_15-4.1.3-1PGDG.rhel9.aarch64.rpm
`h3-pg_15`	4.2.2	`el10.x86_64`	pgdg	71.6 KiB	h3-pg_15-4.2.2-1PGDG.rhel10.x86_64.rpm
`h3-pg_15`	4.2.2	`el10.aarch64`	pgdg	71.2 KiB	h3-pg_15-4.2.2-1PGDG.rhel10.aarch64.rpm
`postgresql-15-h3`	4.2.3	`d12.x86_64`	pgdg	52.7 KiB	postgresql-15-h3_4.2.3-2.pgdg12+1_amd64.deb
`postgresql-15-h3`	4.2.3	`d12.aarch64`	pgdg	50.8 KiB	postgresql-15-h3_4.2.3-2.pgdg12+1_arm64.deb
`postgresql-15-h3`	4.2.3	`d13.x86_64`	pgdg	52.9 KiB	postgresql-15-h3_4.2.3-2.pgdg13+1_amd64.deb
`postgresql-15-h3`	4.2.3	`d13.aarch64`	pgdg	51.4 KiB	postgresql-15-h3_4.2.3-2.pgdg13+1_arm64.deb
`postgresql-15-h3`	4.2.3	`u22.x86_64`	pgdg	48.6 KiB	postgresql-15-h3_4.2.3-2.pgdg22.04+1_amd64.deb
`postgresql-15-h3`	4.2.3	`u22.aarch64`	pgdg	46.5 KiB	postgresql-15-h3_4.2.3-2.pgdg22.04+1_arm64.deb
`postgresql-15-h3`	4.2.3	`u24.x86_64`	pgdg	48.6 KiB	postgresql-15-h3_4.2.3-2.pgdg24.04+1_amd64.deb
`postgresql-15-h3`	4.2.3	`u24.aarch64`	pgdg	47.3 KiB	postgresql-15-h3_4.2.3-2.pgdg24.04+1_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`h3-pg_14`	4.1.3	`el8.x86_64`	pgdg	65.9 KiB	h3-pg_14-4.1.3-1PGDG.rhel8.x86_64.rpm
`h3-pg_14`	4.1.3	`el8.aarch64`	pgdg	63.6 KiB	h3-pg_14-4.1.3-1PGDG.rhel8.aarch64.rpm
`h3-pg_14`	4.1.3	`el9.x86_64`	pgdg	65.5 KiB	h3-pg_14-4.1.3-1PGDG.rhel9.x86_64.rpm
`h3-pg_14`	4.1.3	`el9.aarch64`	pgdg	63.7 KiB	h3-pg_14-4.1.3-1PGDG.rhel9.aarch64.rpm
`h3-pg_14`	4.2.2	`el10.x86_64`	pgdg	71.6 KiB	h3-pg_14-4.2.2-1PGDG.rhel10.x86_64.rpm
`h3-pg_14`	4.2.2	`el10.aarch64`	pgdg	71.0 KiB	h3-pg_14-4.2.2-1PGDG.rhel10.aarch64.rpm
`postgresql-14-h3`	4.2.3	`d12.x86_64`	pgdg	52.7 KiB	postgresql-14-h3_4.2.3-2.pgdg12+1_amd64.deb
`postgresql-14-h3`	4.2.3	`d12.aarch64`	pgdg	50.8 KiB	postgresql-14-h3_4.2.3-2.pgdg12+1_arm64.deb
`postgresql-14-h3`	4.2.3	`d13.x86_64`	pgdg	53.0 KiB	postgresql-14-h3_4.2.3-2.pgdg13+1_amd64.deb
`postgresql-14-h3`	4.2.3	`d13.aarch64`	pgdg	51.4 KiB	postgresql-14-h3_4.2.3-2.pgdg13+1_arm64.deb
`postgresql-14-h3`	4.2.3	`u22.x86_64`	pgdg	48.7 KiB	postgresql-14-h3_4.2.3-2.pgdg22.04+1_amd64.deb
`postgresql-14-h3`	4.2.3	`u22.aarch64`	pgdg	46.5 KiB	postgresql-14-h3_4.2.3-2.pgdg22.04+1_arm64.deb
`postgresql-14-h3`	4.2.3	`u24.x86_64`	pgdg	48.6 KiB	postgresql-14-h3_4.2.3-2.pgdg24.04+1_amd64.deb
`postgresql-14-h3`	4.2.3	`u24.aarch64`	pgdg	47.1 KiB	postgresql-14-h3_4.2.3-2.pgdg24.04+1_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`h3-pg_13`	4.1.3	`el8.x86_64`	pgdg	65.6 KiB	h3-pg_13-4.1.3-1PGDG.rhel8.x86_64.rpm
`h3-pg_13`	4.1.3	`el8.aarch64`	pgdg	63.7 KiB	h3-pg_13-4.1.3-1PGDG.rhel8.aarch64.rpm
`h3-pg_13`	4.1.3	`el9.x86_64`	pgdg	65.2 KiB	h3-pg_13-4.1.3-1PGDG.rhel9.x86_64.rpm
`h3-pg_13`	4.1.3	`el9.aarch64`	pgdg	64.0 KiB	h3-pg_13-4.1.3-1PGDG.rhel9.aarch64.rpm
`h3-pg_13`	4.2.2	`el10.x86_64`	pgdg	71.8 KiB	h3-pg_13-4.2.2-1PGDG.rhel10.x86_64.rpm
`h3-pg_13`	4.2.2	`el10.aarch64`	pgdg	71.2 KiB	h3-pg_13-4.2.2-1PGDG.rhel10.aarch64.rpm
`postgresql-13-h3`	4.2.3	`d12.x86_64`	pgdg	52.1 KiB	postgresql-13-h3_4.2.3-2.pgdg12+1_amd64.deb
`postgresql-13-h3`	4.2.3	`d12.aarch64`	pgdg	50.8 KiB	postgresql-13-h3_4.2.3-2.pgdg12+1_arm64.deb
`postgresql-13-h3`	4.2.3	`d13.x86_64`	pgdg	52.4 KiB	postgresql-13-h3_4.2.3-2.pgdg13+1_amd64.deb
`postgresql-13-h3`	4.2.3	`d13.aarch64`	pgdg	51.6 KiB	postgresql-13-h3_4.2.3-2.pgdg13+1_arm64.deb
`postgresql-13-h3`	4.2.3	`u22.x86_64`	pgdg	48.2 KiB	postgresql-13-h3_4.2.3-2.pgdg22.04+1_amd64.deb
`postgresql-13-h3`	4.2.3	`u22.aarch64`	pgdg	46.7 KiB	postgresql-13-h3_4.2.3-2.pgdg22.04+1_arm64.deb
`postgresql-13-h3`	4.2.3	`u24.x86_64`	pgdg	48.5 KiB	postgresql-13-h3_4.2.3-2.pgdg24.04+1_amd64.deb
`postgresql-13-h3`	4.2.3	`u24.aarch64`	pgdg	47.2 KiB	postgresql-13-h3_4.2.3-2.pgdg24.04+1_arm64.deb

Source

Repository

github.com/zachasme/h3-pg

Install

To add the required PGDG / PIGSTY upstream repository, use:

pig repo add pgsql -u   # add PGDG + Pigsty repo and update cache (leave existing repos)

Install this extension with:

pig ext install h3; # install by extension name, for the current active PG version
pig ext install pg_h3; # install via package alias, for the active PG version
pig ext install h3 -v 18;   # install for PG 18
pig ext install h3 -v 17;   # install for PG 17
pig ext install h3 -v 16;   # install for PG 16
pig ext install h3 -v 15;   # install for PG 15
pig ext install h3 -v 14;   # install for PG 14
pig ext install h3 -v 13;   # install for PG 13

Create this extension with:

CREATE EXTENSION h3;

Last updated on 2025-11-02

pointcloud_postgis h3_postgis