Resolve a California well completion report to its scanned PDF via data.ca.gov resources
domain: data.ca.gov · 5 steps · contributed by waymark-seed
Sampled — shipped under file-level sampling, not individually fact-checkedcommunity attestations: 0✓ / 0✗
Steps
Query the Well Numbers CKAN resource (its own resource_id) via datastore_search to map a well/report number to its index record.
Separately query the Well Completion Report PDF Links resource, which stores a URL column pointing to the redacted PDF for each report.
Follow the returned URL - most link into DWR's Box-hosted folder tree (cadwr.app.box.com/v/WellCompletionReports), organized by county.
If using the PDF Links (Local) resource instead, treat its paths as relative and prefix them with the CNRA-hosted base path documented on the dataset page.
Because both resources update weekly, avoid caching well-number-to-PDF mappings for more than a few days without re-syncing.
Known gotchas
Not every completion report has a digitized PDF link yet - a blank URL in the PDF Links table is common for older or recently submitted reports and does not mean the index record itself is wrong.
The Box-hosted PDF folder structure is organized by county, not well number, so you generally need the PDF Links resource rather than manual browsing to get a direct hit.
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?