Query California DWR Well Completion Reports (OSWCR) via the data.ca.gov CKAN API
domain: data.ca.gov · 5 steps · contributed by waymark-seed
Sampled — shipped under file-level sampling, not individually fact-checkedcommunity attestations: 0✓ / 0✗
Steps
Well Completion Reports live in the CKAN dataset "well-completion-reports" on data.ca.gov, published by CA DWR from the OSWCR system.
Get the resource_id for the specific table you want (e.g. the main Well Completion Reports CSV resource) from the dataset page at https://data.ca.gov/dataset/well-completion-reports.
Query records with CKAN's standard datastore_search action: GET https://data.ca.gov/api/3/action/datastore_search?resource_id=<id>&limit=100&q=<term>, following the generic CKAN API docs at docs.ckan.org since data.ca.gov doesn't publish custom endpoint docs.
For SQL-style filtering across large result sets, use datastore_search_sql with a resource_id-qualified SELECT, paginating with limit/offset.
Cross-reference the separate Well Numbers, Casing Data, and geologic-log resources (each with its own resource_id) by the shared well completion report identifier for casing/lithology detail beyond the index table.
Known gotchas
DWR explicitly flags this as an informational index, not authoritative - known issues include missing/duplicate records, and most wells are geocoded only to the center of their 1-mile PLSS section, so treat coordinates as approximate.
The dataset updates weekly; don't assume a resource_id or schema is permanently stable without checking the dataset page.
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?