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

•

数据库管理

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.

主要功能

Optimized spatial indexing strategies (GiST, BRIN, SP-GiST)
5 GitHub stars
Bigint topology support for massive-scale datasets
Advanced SFCGAL 3D spatial functions and modeling
Standardized GeoJSON import/export and API integration
Topology repair and cleaning with ST_CoverageClean

使用场景

Managing national-scale cadastral or parcel datasets with billions of records
Building high-performance location-based services and mapping APIs
Performing complex 3D terrain analysis and urban infrastructure modeling

关于

主要功能

Optimized spatial indexing strategies (GiST, BRIN, SP-GiST)
5 GitHub stars
Bigint topology support for massive-scale datasets
Advanced SFCGAL 3D spatial functions and modeling
Standardized GeoJSON import/export and API integration
Topology repair and cleaning with ST_CoverageClean

使用场景

Managing national-scale cadastral or parcel datasets with billions of records
Building high-performance location-based services and mapping APIs
Performing complex 3D terrain analysis and urban infrastructure modeling