Postgis Spatial
Use when working with geographic queries, geometry filtering, ST_* functions, or region-based candidate filtering. Load for PostGIS spatial operations, polygon intersections, distance calculations, or geographic bounds. Covers ST_Intersects, ST_Contains, GiST indexes, and geometry storage patterns.
Install
/plugin marketplace add Freddy-CHEN-ux/00_claude_skillsThe repo is a Claude Code plugin marketplace. Run /plugin afterwards to pick the plugin that includes this skill.
npx skills add Freddy-CHEN-ux/00_claude_skills --skill postgis-spatialgit clone --depth 1 https://github.com/Freddy-CHEN-ux/00_claude_skills.git /tmp/00_claude_skills
mkdir -p ~/.claude/skills
cp -r /tmp/00_claude_skills/skills/postgis-spatial ~/.claude/skills/postgis-spatialPersonal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.
From the SKILL.md
# PostGIS Spatial Geographic query patterns for place and region filtering. > **Announce:** "I'm using postgis-spatial to implement geographic queries correctly." ## Geometry Storage Places store their geometry as PostGIS geometry: ```sql CREATE TABLE places ( id uuid PRIMARY KEY, name text NOT NULL, geom geometry(Geometry, 4326), -- Can be Point, Polygon, or MultiPolygon -- SRID 4326 = WGS84 (standard lat/lng) ); -- GiST index for spatial queries CREATE INDEX idx_places_geom ON places USING gist (geom); ``` Geographic regions for questions: ```sql CREATE TABLE geographic_regions ( id uuid PRIMARY KEY, name text NOT NULL, region_type text, -- 'continent', 'country', 'subregion' geom geometry(MultiPolygon, 4326) ); CREATE INDEX idx_geographic_regions_geom ON geographic_regions USING gist (geom); ``` ## Core Functions ### ST_Intersects - Overlap Check ```sql -- Does place intersect with region? SELECT p.id, p.name FROM places p JOIN geographic_regions r ON ST_Intersects(p.geom, r.geom) WHERE r.name = 'Europe'; ``` ### ST_Contains - Fully Inside ```sql -- Is place fully contained within region? SELECT p.id, p.name FROM places p JOIN geographic_regions r ON ST_Contains(r.geom, p.geom) WHERE r.name = 'France'; ``` ### ST_DWithin - Distance Check ```sql -- Places within 100km of a point SELECT p.id, p.name FROM places p WHERE ST_DWithin( p.geom::geography, ST_Point(2.3522, 48.8566)::geography, -- Paris 100000 -- 100km in meters ); ```
Details
- Skill name
postgis-spatial- Repository
- Freddy-CHEN-ux/00_claude_skills
- Path
skills/postgis-spatial/SKILL.md- Repo updated
- 10 January 2026
FAQ
What does the Postgis Spatial skill do?
Use when working with geographic queries, geometry filtering, ST_* functions, or region-based candidate filtering. Load for PostGIS spatial operations, polygon intersections, distance calculations, or geographic bounds. Covers ST_Intersects, ST_Contains, GiST indexes, and geometry storage patterns.
How do I install the Postgis Spatial skill?
Claude Code plugin: /plugin marketplace add Freddy-CHEN-ux/00_claude_skills. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.
Is Postgis Spatial popular?
It lives in Freddy-CHEN-ux/00_claude_skills, which has 8 GitHub stars and 3 forks.
Related skills
Add Integration
8Freddy-CHEN-ux/00_claude_skills
Build a new API integration for Nexus. Load when user mentions "add integration", "new integration", "integrate with", "connect to [service]", or "build [service] integration". Interactive workflow that discovers API endpoints, plans the integration, and creates a project for implementation.
AI Agents
8Freddy-CHEN-ux/00_claude_skills
Production-grade AI agent patterns with MCP integration, agentic RAG, handoff orchestration, multi-layer guardrails, and observability (modern best practices)
AI LLM
8Freddy-CHEN-ux/00_claude_skills
Production LLM engineering skill. Covers strategy selection (prompting vs RAG vs fine-tuning), dataset design, PEFT/LoRA, evaluation workflows, deployment handoff to inference serving, and lifecycle operations with cost/safety controls.
Project Astrology Chinese
8Freddy-CHEN-ux/00_claude_skills
Expert Chinese astrology advisor for the 12 Animal Zodiac, Five Elements, BaZi (Four Pillars), and traditional Chinese timing systems. (project)
Openspec Check
8Freddy-CHEN-ux/00_claude_skills
Use BEFORE any implementation to check if specs exist for the capability. Run this first when starting any feature work. Reports: spec exists, no spec, or active change in progress.
Project Astrology Tarot Divination
8Freddy-CHEN-ux/00_claude_skills
Expert Tarot reader and divination advisor for card meanings, spreads, reading techniques, and integration with astrological timing. (project)
Browse the most popular Claude skills, all other skills, or write your own with the skills generator.