postgres-impl-postgis-geometry-2d

What problem does it solve?

This Skill addresses the challenges of spatial queries in PostgreSQL, particularly with PostGIS, by providing best practices and patterns to optimize performance and accuracy.

Core Features & Use Cases

• Spatial Indexing: Ensures efficient spatial queries by enforcing GIST indexes.
• Proximity Filtering: Implements ST_DWithin for precise distance calculations and proximity filtering.
• SRID Management: Offers guidance on choosing the appropriate SRID for spatial data.
• Use Case: When dealing with geospatial data in PostgreSQL, this skill helps in selecting the right spatial data type, indexing strategy, and spatial operations to ensure accurate and efficient spatial queries.

Quick Start

Apply the postgres-impl-postgis-geometry-2d skill to create a GIST index on the 'geom' column of your 'places' table and execute spatial queries efficiently.