h3 4.0.1
- This Release
- h3 4.0.1
- Date
- Status
- Stable
- Latest Stable
- h3 4.1.2 —
- Other Releases
- Abstract
- PostgreSQL bindings for H3
- Description
- PostgreSQL bindings for H3, a hierarchical hexagonal geospatial indexing system.
- Released By
- bytesandbrains
- License
- Apache 2.0
- Resources
- Special Files
Extensions
- h3 4.0.1
- PostgreSQL bindings for H3
- h3_postgis 4.0.1
- H3 PostGIS integration
Documentation
- api
- API Reference
- development
- development
- CHANGELOG
- Changelog
README
Contents
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.:
```shell $ 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) ```
On macOS with the Postgres.app Universal Binary
shell
brew install pgxnclient make cmake
export CMAKE_OSX_ARCHITECTURES="arm64;x86_64"
pgxn install h3
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 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.