Lightweight geospatial indexing functions for DuckDB, including Geohash encoding, GEOMETRY decoding, bounding boxes, and neighbors.
Maintainer(s):
tshelianthus
Installing and Loading
INSTALL pintail FROM community;
LOAD pintail;
Example
INSTALL pintail FROM community;
LOAD pintail;
SELECT st_geohash(31.2304, 121.4737, 6);
About pintail
Pintail is a lightweight geospatial and spatial-indexing extension for DuckDB. The initial release provides dependency-free Geohash encoding, native Core GEOMETRY decoding (POINT/POLYGON, EPSG:4326), bounding-box extraction, and adjacent-cell operations implemented in C++17. Decode functions return GEOMETRY(EPSG:4326) and do not require DuckDB Spatial, GEOS, or PROJ.
Added Functions
| function_name | function_type | description | comment | examples |
|---|---|---|---|---|
| pintail | scalar | NULL | NULL | |
| st_geohash | scalar | NULL | NULL | |
| st_geohash_bbox | scalar | NULL | NULL | |
| st_geohash_neighbors | scalar | NULL | NULL | |
| st_geomfromgeohash | scalar | NULL | NULL | |
| st_pointfromgeohash | scalar | NULL | NULL |
Overloaded Functions
This extension does not add any function overloads.
Added Types
This extension does not add any types.
Added Settings
This extension does not add any settings.