Enable geospatial analysis in DuckDB with H3 indexing and spatial queries.
npx skills add https://github.com/plurigrid/asi --skill duckdb-spatial
Please help me install this Agent Skill. Skill: duckdb-spatial Source: https://github.com/plurigrid/asi/tree/main/skills/duckdb-spatial Command: npx skills add https://github.com/plurigrid/asi --skill duckdb-spatial
This Skill enables geospatial analysis with DuckDB Spatial, including H3 hex indexing, spatial queries, and GF(3) coloring to color data deterministically.
Install the spatial extension, load h3, and run examples like converting lat/lon to an H3 index and querying features by distance.
High-intent search queries and answers about installing and using this skill.
DuckDB Spatial enables spatial queries through PostGIS-compatible functions for point-in-polygon, distance, and proximity calculations. Load the spatial extension, define geometry columns (POINT, LINESTRING, POLYGON), and use SQL functions to query features by location, distance, or containment without separate GIS software.
H3 indexing converts latitude/longitude coordinates into hierarchical hexagonal cells for efficient geospatial aggregation. DuckDB Spatial provides H3 functions to convert coordinates to hex indices, retrieve cell boundaries, and perform spatial operations at multiple resolutions, enabling scalable analysis of point clouds and regional data.
Yes. DuckDB Spatial supports GeoParquet I/O for reading and writing geospatial Parquet files with coordinate reference system transformations. This enables seamless interchange of spatial data across GIS workflows, urban planning, and analytics pipelines without format conversion.
GF(3) coloring applies deterministic trit-based coloring to geospatial features for analytical visualization and classification. DuckDB Spatial includes GF(3) functions to assign colors consistently across datasets, useful for distinguishing spatial regions, administrative boundaries, or analysis categories.
Yes. DuckDB Spatial handles spatial indexing, hex grids, and efficient proximity queries at scale, making it suitable for logistics route optimization, urban planning analysis, and environmental monitoring. Coordinate system transformations and GeoParquet support integrate with existing GIS pipelines.
DuckDB Spatial supports standard geometry types including POINT, LINESTRING, POLYGON, and MultiVariant geometries. Combined with spatial indexing and H3 hexagonal grids, these types enable comprehensive geospatial workflows from simple coordinate queries to complex multi-feature spatial joins.
nq-rdlEnable DuckDB spatial extension to analyze Overture Maps geospatial data.
crazymsnPerform geospatial analysis in Python with pandas-like GeoDataFrames.
swaruplabAnalyze and manipulate geospatial vector data with GeoPandas for spatial operations.
felixboehmManipulate and analyze geospatial vector data with the Python geopandas library.
