Does this skill support H3 hexagonal grids?

Yes, it includes comprehensive support for H3 operations, including lat/lng to cell conversion, boundary generation, and neighbor (k-ring) lookups.

What is the primary benefit of using DuckDB for spatial data?

DuckDB provides an extremely fast, in-process analytical engine that handles large spatial datasets more efficiently than traditional row-based databases, especially when paired with its Spatial extension.

Can I process GeoJSON and GeoParquet files with this skill?

Absolutely. The skill provides patterns for reading and writing both GeoJSON and GeoParquet, allowing for seamless integration with modern geospatial data pipelines.

Is the spatial syntax compatible with PostGIS?

Yes, the skill utilizes DuckDB's spatial extension which implements many standard ST_ functions (like ST_Distance, ST_Intersects, and ST_Buffer) familiar to PostGIS users.

DuckDB Spatial Analysis

Name: DuckDB Spatial Analysis
Author: plurigrid

byplurigrid

•

데이터 과학 및 ML

Performs high-performance geospatial analysis, H3 hexagonal indexing, and PostGIS-compatible spatial SQL queries using DuckDB.

The DuckDB Spatial skill empowers Claude to handle complex geographic data processing and spatial analytics. It provides a robust framework for executing PostGIS-compatible queries, managing H3 hexagonal grid operations, and performing coordinate reference system (CRS) transformations directly within the DuckDB ecosystem. By integrating advanced features like GF(3) coloring for data organization and GeoParquet support, this skill is ideal for developers and data scientists who need to analyze large-scale spatial datasets with speed and topological precision.

주요 기능

01Advanced H3 hexagonal indexing for grid-based geographic analysis

02PostGIS-compatible spatial SQL query generation and execution

03Support for GeoJSON parsing and high-performance GeoParquet integration

04Deterministic GF(3) coloring for topological data balancing and flow

05Coordinate Reference System (CRS) transformations and area calculations

062 GitHub stars

사용 사례

01Analyzing urban density by mapping point-in-polygon relationships across city-wide datasets

02Generating optimized hexagonal grids for spatial data visualization and proximity analysis

03Automating the migration and transformation of spatial data between GeoJSON and GeoParquet formats

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add plurigrid/asi duckdb-spatial

For use in Claude.ai and ChatGPT

Download Skill