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

•

数据科学与机器学习

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.

主要功能

Advanced H3 hexagonal indexing for grid-based geographic analysis
PostGIS-compatible spatial SQL query generation and execution
Support for GeoJSON parsing and high-performance GeoParquet integration
Deterministic GF(3) coloring for topological data balancing and flow
Coordinate Reference System (CRS) transformations and area calculations
2 GitHub stars

使用场景

Analyzing urban density by mapping point-in-polygon relationships across city-wide datasets
Generating optimized hexagonal grids for spatial data visualization and proximity analysis
Automating the migration and transformation of spatial data between GeoJSON and GeoParquet formats

关于

主要功能

Advanced H3 hexagonal indexing for grid-based geographic analysis
PostGIS-compatible spatial SQL query generation and execution
Support for GeoJSON parsing and high-performance GeoParquet integration
Deterministic GF(3) coloring for topological data balancing and flow
Coordinate Reference System (CRS) transformations and area calculations
2 GitHub stars

使用场景

Analyzing urban density by mapping point-in-polygon relationships across city-wide datasets
Generating optimized hexagonal grids for spatial data visualization and proximity analysis
Automating the migration and transformation of spatial data between GeoJSON and GeoParquet formats