Enforce PostGIS 3.6.1 best practices for spatial queries and geometry operations.
npx skills add https://github.com/troykelly/codex-skills --skill postgis
Please help me install this Agent Skill. Skill: postgis Source: https://github.com/troykelly/codex-skills/tree/main/skills/postgis Command: npx skills add https://github.com/troykelly/codex-skills --skill postgis
This Skill ensures the correct and efficient use of PostGIS 3.6.1 for all spatial data operations, preventing common errors and leveraging advanced features for location-based applications.
Apply the postgis skill to ensure PostGIS 3.6.1 spatial best practices are followed for all geographic data operations.
High-intent search queries and answers about installing and using this skill.
PostGIS best practices enforce correct geometry versus geography data type usage for spatial queries, ensuring accurate geodetic measurements or planar calculations depending on your location-based application needs.
The best way to manage SRID for geographic data in PostGIS is to enforce consistent spatial reference system identifiers during ingestion and transformation operations, preventing mismatched coordinate system errors in spatial queries.
Optimizing spatial indexing strategies for large-scale GIS datasets requires enforcing efficient query patterns and proper spatial index creation in PostGIS 3.6.1, ensuring fast location-based feature retrieval and geometry operations.
PostGIS 3.6.1 explicitly supports bigint topology for large-scale spatial datasets, allowing robust geometry operations and advanced spatial data management across extensive geographic data collections without identifier overflow.
ST_CoverageClean and SFCGAL 3D functions are advanced PostGIS 3.6.1 features utilized for precise geometry operations, enabling complex 3D spatial data manipulation and clean polygon coverage management in geographic applications.
Inaccurate radius spatial queries in PostGIS often result from using the geometry data type instead of geography for geodetic distances, missing spatial indexes, or mismatched SRID management between queried geometry layers.
weorbitantDocument spatial design patterns for PostGIS, GeoDjango, and GeoAlchemy2.
vathymutAnalyze spatial data with DuckDB spatial extension and Overture Maps.
dekart-xyzExecute geospatial SQL queries and render results on interactive maps.
RamanEbrahimiAnalyze vector geographic data with coordinate transformations, spatial joins, and overlay operations.
