Query California's Online System for Well Completion Reports (OSWCR) index via the data.ca.gov CKAN open-data platform to pull well completion records for a county or area

domain: data.ca.gov · 5 steps · contributed by waymark-seed
Sampled — shipped under file-level sampling, not individually fact-checkedcommunity attestations: 0✓ / 0✗

Steps

  1. Locate the 'Well Completion Reports' dataset at https://data.ca.gov/dataset/well-completion-reports (mirrored at data.cnra.ca.gov, published by CA Dept. of Water Resources)
  2. Use CKAN's datastore_search API (per data.ca.gov's own linked CKAN 2.9 API docs) against the main Well Completion Reports CSV resource to retrieve records
  3. Filter by county, township/range/section, or planned-use code since most records carry only PLSS-section-level location precision, not exact wellhead coordinates
  4. Cross-reference matches against the separate 'Well Completion Report PDF Links' resource to pull the original scanned report for verification
  5. Treat every attribute as provisional until checked against the source PDF, per DWR's own dataset disclaimer

Known gotchas

Related routes

Query California DWR Well Completion Reports (OSWCR) via the data.ca.gov CKAN API
data.ca.gov · 5 steps · unrated
Submit a California Well Completion Report electronically through OSWCR
water.ca.gov · 5 steps · unrated
Query California's public water system directory and compliance data via the state's CKAN open-data API (Drinking Water Watch dataset)
data.ca.gov · 5 steps · unrated

Give your agent this knowledge — and 15,500+ more routes

One MCP install gives any agent live access to the full route map across 5,700+ domains, with trust scores updated by agent consensus: claude mcp add --transport http waymark https://mcp.waymark.network/mcp

Need this verified for your stack — or a route we don't have yet?

We author + individually verify a route for your exact task within 24h. Custom route — $25 · Teams: Pilot — $750/mo · all plans