H3 is a hexagonal hierarchical geospatial indexing system that allows for efficient spatial partitioning and analysis, which this skill implements via the DuckDB H3 community extension.

Does this skill support PostGIS functions?

Yes, it supports many PostGIS-compatible functions through the DuckDB Spatial extension, including ST_Distance, ST_Contains, and ST_Transform.

Do I need to install the extensions manually?

The skill includes the SQL commands required to INSTALL and LOAD the 'spatial' and 'h3' extensions directly within your DuckDB environment.

Can I work with GeoJSON and GeoParquet files?

Absolutely. The skill includes capabilities to parse GeoJSON strings and read or write spatial data using the high-performance GeoParquet format.

DuckDB Spatial & H3 Analysis

Name: DuckDB Spatial & H3 Analysis
Author: plurigrid

byplurigrid

•

Database Management

Executes PostGIS-compatible spatial SQL queries and H3 hexagonal indexing for advanced geographic data analysis within DuckDB.

This skill empowers Claude to perform complex geospatial operations using DuckDB's powerful spatial extension. It enables users to handle GeoJSON data, perform point-in-polygon and distance queries, and utilize H3 hexagonal grid indexing for large-scale geographic data partitioning. Unique to this implementation is the integration of GF(3) trit coloring for coordinated spatial data flow, making it an essential tool for developers and data scientists working with topological data structures, city-scale analysis, and high-performance GeoParquet files.

Key Features

01PostGIS-compatible spatial SQL operations including ST_Distance and ST_Contains

02High-performance H3 hexagonal grid indexing and k-ring neighbor calculations

03Seamless Coordinate Reference System (CRS) transformations via EPSG codes

04GF(3) trit-based spatial data coloring for deterministic data coordination

057 GitHub stars

06Support for GeoJSON parsing and native GeoParquet file integration

Use Cases

01Analyzing city-scale demographic data using H3 hexagonal bins for statistical aggregation

02Performing spatial joins between point-of-interest data and complex regional boundary polygons

03Converting and transforming large geospatial datasets between GeoParquet and WGS84/Web Mercator 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