Design Postgis Tables

This is a well-structured reference for designing spatial tables in PostGIS. It walks you through the geometry versus geography decision (projected versus spherical calculations), explains when to use each geometry type (point, linestring, polygon), and covers SRID selection with practical examples. The five opening questions about scope, query patterns, and scale help you make the right choices upfront. What stands out is the clear guidance on spatial indexing with GiST and the comparison tables that cut through the complexity. If you're building anything location-based, from store locators to regional GIS systems, this gives you the patterns to avoid common mistakes like mixing coordinate systems or choosing the wrong index type. The SQL injection reminder is a good touch for production code.

Install to Claude Code

npx -y skills add timescale/pg-aiguide --skill design-postgis-tables --agent claude-code