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
13
 pg_h3 -
RPM
PGDG
 4.2.3
18
17
16
15
14
13
 h3-pg_$v* -
DEB
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

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
pig install h3 -v 13;   # install for PG 13

Create this extension with:

CREATE EXTENSION h3;
Last updated on
pointcloud_postgish3_postgis