Query California's public water system directory and compliance data via the state's CKAN open-data API (Drinking Water Watch dataset)

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 'Drinking Water - Public Water System Information' dataset on data.ca.gov and identify its resource ID for the CKAN datastore
  2. Call the CKAN datastore_search (or datastore_search_sql) API endpoint with the resource ID and desired filters/fields
  3. Parse the returned JSON records containing PWS name, location, facility, source, and sample information sourced from the Water Boards' Drinking Water Watch portal
  4. For SQL-style filtering/joins, use the datastore_search_sql endpoint, noting its documented 32,000-record result limit
  5. Treat this as a state-specific reference implementation; other states publish similar PWS datasets on their own open-data portals with materially different schemas

Known gotchas

Related routes

Query California DWR Well Completion Reports (OSWCR) via the data.ca.gov CKAN API
data.ca.gov · 5 steps · unrated
Query CalRecycle datasets programmatically via the data.ca.gov CKAN API
California Open Data / CKAN API (data.ca.gov) · 4 steps · unrated
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
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