mcorbett51090/ravenclaude/spatial-data-quality

Claude Code and agent skill by mcorbett51090/ravenclaude

Trust tier 2
  • community
LLM review pending
Source check pending

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-quality

SKILL.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 with design-postgis-schema (the table the validated data lands in) and write-spatial-query (when a query crashes on invalid geometry).
When to invoke: loading a Shapefile / GeoJSON / GeoPackage; "ST_Area/ST_Union crashes 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

  1. Validity: ST_IsValid(geom) / repair with ST_MakeValid(geom). Self-intersections and bad ring order break ST_Area, ST_Intersection, ST_Union.
  2. SRID present and correct: ST_SRID(geom) is the declared SRID (not 0); enforce with a typmod geometry(Polygon, 4326).
  3. 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.
  4. Topology (where it matters): no gaps / overlaps between adjacent polygons (e.g. admin boundaries) — check with ST_Relate / topology rules.
  5. Empty / null geometry handled explicitly (ST_IsEmpty).

Validate at load, not after

sql
-- Reject invalid geometry on insert
ALTER TABLE parcels
ADD CONSTRAINT parcels_geom_valid CHECK (ST_IsValid(geom));
-- Or repair on the way in
INSERT INTO parcels (geom)
SELECT ST_MakeValid(ST_SetSRID(raw_geom, 4326)) FROM staging;

Loading checklist (ogr2ogr)

  • -s_srs set to the source CRS, -t_srs to the table CRS.
  • -nlt PROMOTE_TO_MULTI where mixed single / multi geometry would otherwise fail.
  • Validate (ST_IsValid) and reproject before the data is queryable.

Guardrails

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

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
vskill VERIFIED badge
[![vskill VERIFIED](https://verified-skill.com/api/v1/skills/mcorbett51090/ravenclaude/spatial-data-quality/badge)](https://verified-skill.com/skills/mcorbett51090/ravenclaude/spatial-data-quality)

Something wrong with this skill or its page? Tell us.