How does it handle massive datasets?

It implements bigint topology support, allowing for more than 2 billion features per topology, and provides indexing strategies like BRIN for high-volume, ordered data.

Why is this skill necessary for spatial data?

Spatial data requires specialized handling that generic database patterns often miss. This skill enforces PostGIS 3.6.1 standards to ensure query accuracy and index performance.

Can it help repair broken geometry data?

Absolutely. It utilizes ST_CoverageClean and ST_MakeValid patterns to fix self-intersections, gaps, overlaps, and other topological inconsistencies.

Does this skill support 3D spatial operations?

Yes, it includes patterns for SFCGAL 3D functions, including 3D intersections, unions, area calculations, and Minkowski sums for polyhedral surfaces.

PostGIS Spatial Database

Name: PostGIS Spatial Database
Author: troykelly

bytroykelly

•

Database Management

Enforces PostGIS 3.6.1 best practices for managing complex geographic data, spatial queries, and advanced geometry operations.

This skill provides Claude with expert-level guidance for PostGIS 3.6.1 and GEOS 3.14, specifically designed to handle the nuances of geographic and spatial data. It ensures the correct application of topology repair using ST_CoverageClean, leverages SFCGAL for 3D operations, and implements bigint topology support for datasets exceeding two billion features. By standardizing indexing strategies and SRID management, this skill helps developers avoid common pitfalls in location-based services and GIS application development, ensuring spatial queries are both mathematically accurate and highly performant.

Key Features

01Optimized spatial indexing strategies (GiST, BRIN, SP-GiST)

025 GitHub stars

03Bigint topology support for massive-scale datasets

04Advanced SFCGAL 3D spatial functions and modeling

05Standardized GeoJSON import/export and API integration

06Topology repair and cleaning with ST_CoverageClean

Use Cases

01Managing national-scale cadastral or parcel datasets with billions of records

02Building high-performance location-based services and mapping APIs

03Performing complex 3D terrain analysis and urban infrastructure modeling

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add troykelly/claude-skills postgis

For use in Claude.ai and ChatGPT

Download Skill