PostgreSQL bindings for H3

This library provides PostgreSQL bindings for the H3 Core Library. For API reference, please see the H3 Documentation.

Developed in collaboration with Scandinavian Highlands.

Prerequisites

• PostgreSQL 9.6 or higher (including server headers). It might work with earlier versions, we have not tested earlier than 9.6.
• C compiler (e.g., gcc)
• GNU Make
• Git & CMake (for libh3)

Quick Overview

If the prerequisites are met you can use the PGXN Client to download, build, and install, e.g.:

$ pgxn install h3
$ pgxn load h3
$ psql
=# SELECT h3_lat_lng_to_cell(POINT('37.3615593,-122.0553238'), 5);
  h3_lat_lng_to_cell
-----------------
 85e35e73fffffff
(1 row)

(You can install a specific version using pgxn install 'h3=3.7.2' and pgxn load 'h3=3.7.2' for example)

On macOS with the Postgres.app Universal Binary

brew install pgxnclient make cmake
export CMAKE_OSX_ARCHITECTURES="arm64;x86_64"
pgxn install h3

Usage

🎉 Note: The following usage docs apply to H3 v4, which was released on August 23, 2022.

• For v3 docs, see the latest v3.x.x release.
• For breaking changes in v4, see the CHANGELOG. In particular, most function names have changed.

Generally, all functions have been renamed from camelCase in H3 to snake*case in SQL with an added h3* prefix.

See API reference for all provided functions.

For developers

See Development.

License

This project is released under the Apache 2.0 License.