h3-pg: Uber's H3 Hexagonal Hierarchical Geospatial Indexing System in PostgreSQL

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

Developed in collaboration with Scandinavian Highlands.

Binary distributions

These don't require you have the development headers or cmake installed.

Debian/Ubuntu (Ubuntu 22.04 LTS (Jammy Jellyfish) +)

Replace 16 with your postgresql version. Refer to PGDG Ubuntu and PGDG Debian for installing PostgreSQL. More details about the various packages at https://apt.postgresql.org sudo apt install postgresql-16-h3

Redhat Derivatives (Rocky / EL 8+ / Fedora 37+)

Replace 16 with your postgresql version Refer to PGDG Redhat Derivatives for installing PostgreSQL. More details about the various packages at https://yum.postgresql.org sudo yum install h3-pg_16

Windows

Included as part of PostGIS Bundle 3.3+ for PostgreSQL 11-16 Details: postgis.net windows
Works with PostgreSQL Windows and PostGIS bundle is accessible via the included Application Stackbuilder.

Compiling Prerequisites

• PostgreSQL 11+ (including server headers, e.g. postgresql-server-dev-14)
• C compiler (e.g., gcc)
• CMake 3.20+
• GNU Make

Quick Overview

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

```shell $ pgxn install h3 $ pgxn load h3 $ psql =# SELECT h3latlngto_cell(POINT('37.3615593,-122.0553238'), 5);

h3latlngto_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)

See Building for other installation methods.

Usage

:tada: 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.

See API reference for all provided functions.

Building

```bash

Generate native build system

cmake -B build -DCMAKEBUILDTYPE=Release

Build extension(s)

cmake --build build

Install extensions (might require sudo)

cmake --install build --component h3-pg ```

Contributing

Pull requests and GitHub issues are welcome. Please include tests for new work. Please note that the purpose of this extension is to expose the API of the H3 Core library, so we will rarely accept new features that are not part of that API. New proposed feature work is more appropriate in the core C library or in a new extension that depends on h3-pg.

See Development.

License

This project is released under the Apache 2.0 License.