Summary
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-codeInstalls into .claude/skills of the current project.
Keep your Mac awake while Claude Code and 40+ AI agents run. Sleeps when they're idle.
One time payment $9 →
Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →
Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →
On Capafy, your Skill runs online 24/7 as an agent product, and you get paid every time someone uses it.
Start earning →
Files
SKILL.md
Select a file.
Featured
Keep your Mac awake while Claude Code and 40+ AI agents run. Sleeps when they're idle.
One time payment $9 →Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →On Capafy, your Skill runs online 24/7 as an agent product, and you get paid every time someone uses it.
Start earning →
