mcorbett51090/ravenclaude/spatial-data-quality
Claude Code and agent skill by mcorbett51090/ravenclaude
- community
Checking that the SKILL.md file is still in the repository.
Keep spatial data trustworthy: geometry validity (ST_IsValid / ST_MakeValid, self-intersections, ring order), topology, declared-vs-actual SRID checks, coordinate-order (lon/lat) sanity, and validating geometry at load time so bad data never lands. Reach for this when loading a dataset, debugging a function that crashes on some rows, or hardening an ingest. Used by `geospatial-data-engineer` (primary).
Install
npx vskill@latest install mcorbett51090/ravenclaude/spatial-data-qualitySKILL.md
The same SKILL.md was published earlier as mcorbett51090/ravenclaude/spatial-data-quality.
Skill: spatial-data-quality
Invoked by:geospatial-data-engineer(primary). Pairs withdesign-postgis-schema(the table the validated data lands in) andwrite-spatial-query(when a query crashes on invalid geometry).When to invoke: loading a Shapefile / GeoJSON / GeoPackage; "ST_Area/ST_Unioncrashes on some rows"; "my points show up in the ocean"; hardening an ingest so bad geometry never lands.Output: the validity / SRID / coordinate-order / topology checks + a validate-at-load constraint or repair-on-ingest query, run at the boundary.
Bad geometry fails silently in some functions and loudly in others — gate it at the boundary.
The checks
- Validity:
ST_IsValid(geom)/ repair withST_MakeValid(geom). Self-intersections and bad ring order breakST_Area,ST_Intersection,ST_Union. - SRID present and correct:
ST_SRID(geom)is the declared SRID (not0); enforce with a typmodgeometry(Polygon, 4326). - Coordinate order / extent sanity: values plausibly within the CRS bounds (lon ∈ [-180,180], lat ∈ [-90,90] for 4326). A cluster off west Africa = swapped lon/lat.
- Topology (where it matters): no gaps / overlaps between adjacent polygons (e.g. admin boundaries) — check with
ST_Relate/ topology rules. - Empty / null geometry handled explicitly (
ST_IsEmpty).
Validate at load, not after
Loading checklist (ogr2ogr)
-s_srsset to the source CRS,-t_srsto the table CRS.-nlt PROMOTE_TO_MULTIwhere mixed single / multi geometry would otherwise fail.- Validate (
ST_IsValid) and reproject before the data is queryable.
Guardrails
- Trusting a file's claimed CRS without checking the extent is how lon/lat swaps land — sanity-check the extent (the GeoJSON-is-lon-lat trap).
- Never run area / union on un-validated polygons.
- Never let SRID
0(unknown) into a column — declare a typmod. See `../../best-practices/validate-geometry-at-load.md`, `../../best-practices/geojson-is-lon-lat.md`, and `../../best-practices/always-store-an-srid.md`.
Security
- Security scanPassed, 100 of 100Pattern checks on the skill's files.
- Model reviewNot runA model review is scheduled for the next rescan.
Quality evaluation
- Task evaluationNot runNo evaluation yet. Run one in Skill Studio.
Source
- SKILL.md in the repositoryCheckingplugins/geospatial-engineering/skills/spatial-data-quality/SKILL.md
Popularity
- Repository stars
- 8
- Repository forks
- 1
- 7-day trend score
- 16
Stars and forks are for the whole GitHub repository, not this skill alone. Not refreshed yet.
Works with
Any agent vskill installs to: 56 targets in all. These 39 have a page on this site.
- Claude Code
- Cursor
- GitHub Copilot
- Windsurf
- Codex
- Gemini CLI
- Cline
- Amp
- Roo Code
- Goose
- Continue
- Kilo Code
- Junie
- Trae
- OpenHands
- Qwen Code
- AI Agent
- Tabnine Chat
- Sourcegraph Cody
- Amazon Q
- Firebase Genkit
- Sweep
- Devin
- Phind
- Mentat
- Claude Desktop
- Aider
- GPT Pilot
- Plandex
- bolt.new
- v0
- Replit Agent
- Anse
- TypingMind
- BetterChatGPT
- LibreChat
- Warp AI
- Pieces
- Fig AI
Embed badge
[](https://verified-skill.com/skills/mcorbett51090/ravenclaude/spatial-data-quality)