Extensions
h3

h3

pg_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

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

Packages

Type Repo Version PG Major Compatibility Package Pattern Dependencies
EXT
PGDG
 4.2.3
18
17
16
15
14
 pg_h3 -
RPM
PGDG
 4.2.3
18
17
16
15
14
 h3-pg_$v -
DEB
PGDG
 4.2.3
18
17
16
15
14
 postgresql-$v-h3 -
Linux / PG PG18 PG17 PG16 PG15 PG14
el8.x86_64
MISS
MISS
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
el9.x86_64
PGDG 4.2.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
el10.x86_64
PGDG 4.2.3
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
d12.x86_64
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
d13.x86_64
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
u22.x86_64
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
u24.x86_64
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
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.7 KiB postgresql-18-h3_4.2.3-3.pgdg12+1_amd64.deb
postgresql-18-h3 4.2.3 d12.aarch64 pgdg 50.8 KiB postgresql-18-h3_4.2.3-3.pgdg12+1_arm64.deb
postgresql-18-h3 4.2.3 d13.x86_64 pgdg 52.9 KiB postgresql-18-h3_4.2.3-3.pgdg13+1_amd64.deb
postgresql-18-h3 4.2.3 d13.aarch64 pgdg 51.4 KiB postgresql-18-h3_4.2.3-3.pgdg13+1_arm64.deb
postgresql-18-h3 4.2.3 u22.x86_64 pgdg 48.6 KiB postgresql-18-h3_4.2.3-3.pgdg22.04+1_amd64.deb
postgresql-18-h3 4.2.3 u22.aarch64 pgdg 46.6 KiB postgresql-18-h3_4.2.3-3.pgdg22.04+1_arm64.deb
postgresql-18-h3 4.2.3 u24.x86_64 pgdg 48.6 KiB postgresql-18-h3_4.2.3-3.pgdg24.04+1_amd64.deb
postgresql-18-h3 4.2.3 u24.aarch64 pgdg 47.2 KiB postgresql-18-h3_4.2.3-3.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-3.pgdg12+1_amd64.deb
postgresql-17-h3 4.2.3 d12.aarch64 pgdg 50.7 KiB postgresql-17-h3_4.2.3-3.pgdg12+1_arm64.deb
postgresql-17-h3 4.2.3 d13.x86_64 pgdg 52.9 KiB postgresql-17-h3_4.2.3-3.pgdg13+1_amd64.deb
postgresql-17-h3 4.2.3 d13.aarch64 pgdg 51.5 KiB postgresql-17-h3_4.2.3-3.pgdg13+1_arm64.deb
postgresql-17-h3 4.2.3 u22.x86_64 pgdg 48.6 KiB postgresql-17-h3_4.2.3-3.pgdg22.04+1_amd64.deb
postgresql-17-h3 4.2.3 u22.aarch64 pgdg 46.5 KiB postgresql-17-h3_4.2.3-3.pgdg22.04+1_arm64.deb
postgresql-17-h3 4.2.3 u24.x86_64 pgdg 48.6 KiB postgresql-17-h3_4.2.3-3.pgdg24.04+1_amd64.deb
postgresql-17-h3 4.2.3 u24.aarch64 pgdg 47.3 KiB postgresql-17-h3_4.2.3-3.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.7 KiB postgresql-16-h3_4.2.3-3.pgdg12+1_amd64.deb
postgresql-16-h3 4.2.3 d12.aarch64 pgdg 50.8 KiB postgresql-16-h3_4.2.3-3.pgdg12+1_arm64.deb
postgresql-16-h3 4.2.3 d13.x86_64 pgdg 53.0 KiB postgresql-16-h3_4.2.3-3.pgdg13+1_amd64.deb
postgresql-16-h3 4.2.3 d13.aarch64 pgdg 51.4 KiB postgresql-16-h3_4.2.3-3.pgdg13+1_arm64.deb
postgresql-16-h3 4.2.3 u22.x86_64 pgdg 48.6 KiB postgresql-16-h3_4.2.3-3.pgdg22.04+1_amd64.deb
postgresql-16-h3 4.2.3 u22.aarch64 pgdg 46.6 KiB postgresql-16-h3_4.2.3-3.pgdg22.04+1_arm64.deb
postgresql-16-h3 4.2.3 u24.x86_64 pgdg 48.7 KiB postgresql-16-h3_4.2.3-3.pgdg24.04+1_amd64.deb
postgresql-16-h3 4.2.3 u24.aarch64 pgdg 47.2 KiB postgresql-16-h3_4.2.3-3.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-3.pgdg12+1_amd64.deb
postgresql-15-h3 4.2.3 d12.aarch64 pgdg 50.8 KiB postgresql-15-h3_4.2.3-3.pgdg12+1_arm64.deb
postgresql-15-h3 4.2.3 d13.x86_64 pgdg 52.9 KiB postgresql-15-h3_4.2.3-3.pgdg13+1_amd64.deb
postgresql-15-h3 4.2.3 d13.aarch64 pgdg 51.4 KiB postgresql-15-h3_4.2.3-3.pgdg13+1_arm64.deb
postgresql-15-h3 4.2.3 u22.x86_64 pgdg 48.7 KiB postgresql-15-h3_4.2.3-3.pgdg22.04+1_amd64.deb
postgresql-15-h3 4.2.3 u22.aarch64 pgdg 46.5 KiB postgresql-15-h3_4.2.3-3.pgdg22.04+1_arm64.deb
postgresql-15-h3 4.2.3 u24.x86_64 pgdg 48.6 KiB postgresql-15-h3_4.2.3-3.pgdg24.04+1_amd64.deb
postgresql-15-h3 4.2.3 u24.aarch64 pgdg 47.3 KiB postgresql-15-h3_4.2.3-3.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.9 KiB postgresql-14-h3_4.2.3-3.pgdg12+1_amd64.deb
postgresql-14-h3 4.2.3 d12.aarch64 pgdg 50.8 KiB postgresql-14-h3_4.2.3-3.pgdg12+1_arm64.deb
postgresql-14-h3 4.2.3 d13.x86_64 pgdg 53.0 KiB postgresql-14-h3_4.2.3-3.pgdg13+1_amd64.deb
postgresql-14-h3 4.2.3 d13.aarch64 pgdg 51.5 KiB postgresql-14-h3_4.2.3-3.pgdg13+1_arm64.deb
postgresql-14-h3 4.2.3 u22.x86_64 pgdg 48.7 KiB postgresql-14-h3_4.2.3-3.pgdg22.04+1_amd64.deb
postgresql-14-h3 4.2.3 u22.aarch64 pgdg 46.5 KiB postgresql-14-h3_4.2.3-3.pgdg22.04+1_arm64.deb
postgresql-14-h3 4.2.3 u24.x86_64 pgdg 48.7 KiB postgresql-14-h3_4.2.3-3.pgdg24.04+1_amd64.deb
postgresql-14-h3 4.2.3 u24.aarch64 pgdg 47.2 KiB postgresql-14-h3_4.2.3-3.pgdg24.04+1_arm64.deb

Source

Repository
github.com/zachasme/h3-pg

Install

Make sure PGDG repo available:

pig repo add pgdg -u    # add pgdg repo and update cache

Install this extension with pig:

pig install pg_h3;		# install via package name, for the active PG version
pig install h3;		# install by extension name, for the current active PG version

pig install h3 -v 18;   # install for PG 18
pig install h3 -v 17;   # install for PG 17
pig install h3 -v 16;   # install for PG 16
pig install h3 -v 15;   # install for PG 15
pig install h3 -v 14;   # install for PG 14

Create this extension with:

CREATE EXTENSION h3;
Last updated on
pointcloud_postgish3_postgis