Performs high-performance geographic data analysis and H3 hexagonal indexing using DuckDB's spatial extensions.
This skill empowers Claude to execute complex geospatial operations directly within DuckDB, combining the speed of an analytical database with PostGIS-compatible spatial functions. It supports H3 hexagonal grid operations, GeoJSON parsing, GeoParquet integration, and advanced coordinate reference system (CRS) transformations. Unique to this skill is the integration of GF(3) coloring for topological data management, making it an essential tool for developers and data scientists building location-aware applications, environmental models, or high-density urban planning visualizations.
Key Features
018 GitHub stars
02Precise Coordinate Reference System (CRS) transformations and area calculations
03PostGIS-compatible spatial SQL queries and point-in-polygon analysis
04Deterministic GF(3) coloring for topological spatial indexing and balance
05Seamless GeoParquet and GeoJSON data ingestion and export
06Advanced H3 hexagonal indexing for grid-based geographic data
Use Cases
01Creating H3 hexagonal heatmaps for population or density analysis
02Processing and converting complex spatial data between Parquet and SQL formats
03Performing high-speed proximity searches and spatial joins on large datasets
