Skip to content
Eden Engine

List Public Water Systems

epaenvirofacts/water-systems

Lists public drinking-water systems regulated by one US state or territory (the system's primacy agency) from EPA's Safe Drinking Water Information System (SDWIS) in Envirofacts, filtered by activity status and system type: id, name, mailing city and state, primacy agency, type, status, owner type, primary source, population served, connections and whether it is a wholesaler or serves a school or day-care. Pages with first_row and last_row (default the first 100 rows). Contact persons, phones, e-mail addresses and street addresses are not returned. Source: U.S. Environmental Protection Agency (EPA) Envirofacts, https://www.epa.gov/enviro, U.S. government data in the public domain, reduced to the fields listed (contact persons, phone numbers, e-mail addresses and mailing addresses are not returned) and served by Eden Engine; not an official EPA product.

activeper callv1

Price

$0.0026 per call

You pay the price shown. If a call turns out to cost more than its quote, you pay the actual price, capped at twice the quote. No monthly minimum. Top-ups start at $0.50.

Data source

U.S. EPA Envirofacts

Source: U.S. Environmental Protection Agency (EPA) Envirofacts, https://www.epa.gov/enviro, U.S. government data in the public domain, reduced to the fields listed (contact persons, phone numbers, e-mail addresses and mailing addresses are not returned) and served by Eden Engine; not an official EPA product.

Use it

Five steps: search, inspect, learn, run, settle. No per-tool setup; your agent reaches this tool through the meta-tools it already has.

Connect once and your AI can find and run this tool, and any other it needs.

agent
// 1. search: find the tool
omnial_search({ query: "what you need" })

// 2. inspect: price and input schema
omnial_inspect({ tool: "epaenvirofacts/water-systems" })

// 3. learn: read the usage guide at runtime
omnial_learn({ tool: "epaenvirofacts/water-systems" })

// 4. run: price the exact call first, then run it
omnial_execute({ tool: "epaenvirofacts/water-systems", input: { /* see input_schema */ }, dry_run: true })
omnial_execute({ tool: "epaenvirofacts/water-systems", input: { /* ... */ } })

// 5. settle: the call is charged when it finishes, nothing to do

Not connected yet? Point your MCP client at https://mcp.eden-engine.com/mcp, then copy a config for your client.

Pricing

Every charge this tool can incur.

ChargePrice
Per call
$0.0026
Updated
Oct 27, 2026

Input and output schemas

Input schema
input_schema.json
{
  "type": "object",
  "required": [
    "state",
    "activity",
    "system_type"
  ],
  "properties": {
    "state": {
      "enum": [
        "AL",
        "AK",
        "AZ",
        "AR",
        "CA",
        "CO",
        "CT",
        "DE",
        "DC",
        "FL",
        "GA",
        "HI",
        "ID",
        "IL",
        "IN",
        "IA",
        "KS",
        "KY",
        "LA",
        "ME",
        "MD",
        "MA",
        "MI",
        "MN",
        "MS",
        "MO",
        "MT",
        "NE",
        "NV",
        "NH",
        "NJ",
        "NM",
        "NY",
        "NC",
        "ND",
        "OH",
        "OK",
        "OR",
        "PA",
        "RI",
        "SC",
        "SD",
        "TN",
        "TX",
        "UT",
        "VT",
        "VA",
        "WA",
        "WV",
        "WI",
        "WY",
        "AS",
        "GU",
        "MP",
        "PR",
        "VI"
      ],
      "type": "string",
      "description": "Two-letter postal code of the state or territory whose regulated systems to list (the system's primacy agency, not its mailing address): a state, DC, American Samoa (AS), Guam (GU), the Northern Mariana Islands (MP), Puerto Rico (PR) or the US Virgin Islands (VI), for example DE."
    },
    "activity": {
      "enum": [
        "A",
        "I",
        "N"
      ],
      "type": "string",
      "description": "A lists active systems, I inactive ones, N systems that changed from public to non-public."
    },
    "last_row": {
      "type": "integer",
      "default": 99,
      "maximum": 4999,
      "minimum": 0,
      "description": "Index of the last row to return, counting from 0 and INCLUDING that row, so first_row 0 and last_row 99 return up to 100 rows. The highest allowed value is 4999. Must not be below first_row (a smaller value is a validation error). Fewer rows than asked for means the end of the matches."
    },
    "first_row": {
      "type": "integer",
      "default": 0,
      "maximum": 4999,
      "minimum": 0,
      "description": "Index of the first row to return, counting from 0 in EPA's ordering of the matches. Combine with last_row to page."
    },
    "system_type": {
      "enum": [
        "CWS",
        "NTNCWS",
        "TNCWS"
      ],
      "type": "string",
      "description": "CWS lists community water systems (homes), NTNCWS non-transient non-community ones (schools, workplaces), TNCWS transient non-community ones (campgrounds, rest stops)."
    }
  },
  "additionalProperties": false
}
Output schema
output_schema.json
{
  "type": "object",
  "required": [
    "water_systems"
  ],
  "properties": {
    "water_systems": {
      "type": "array",
      "items": {
        "type": "object",
        "required": [
          "pwsid"
        ],
        "properties": {
          "name": {
            "type": [
              "string",
              "null"
            ],
            "description": "Water system name."
          },
          "pwsid": {
            "type": "string",
            "description": "Public water system identifier: two-letter primacy agency code plus seven digits, for example DE0000004."
          },
          "epa_region": {
            "type": [
              "integer",
              "null"
            ],
            "description": "EPA region number, 1 to 10."
          },
          "owner_type": {
            "type": "object",
            "properties": {
              "code": {
                "type": "string",
                "description": "Owner code."
              },
              "label": {
                "type": [
                  "string",
                  "null"
                ],
                "description": "Plain-language owner type."
              }
            },
            "description": "Federal, local, state, Native American, private or public/private ownership; null when EPA holds none.",
            "additionalProperties": true
          },
          "system_type": {
            "type": "object",
            "properties": {
              "code": {
                "type": "string",
                "description": "CWS, NTNCWS or TNCWS."
              },
              "label": {
                "type": [
                  "string",
                  "null"
                ],
                "description": "Plain-language type."
              }
            },
            "description": "Type: community, non-transient non-community or transient non-community water system.",
            "additionalProperties": true
          },
          "mailing_city": {
            "type": [
              "string",
              "null"
            ],
            "description": "City in the system's mailing address."
          },
          "is_wholesaler": {
            "type": [
              "boolean",
              "null"
            ],
            "description": "True when the system sells water to other systems."
          },
          "mailing_state": {
            "type": [
              "string",
              "null"
            ],
            "description": "Two-letter code of the state in the system's mailing address. It can differ from the state the system serves; primacy_agency is the regulating state."
          },
          "primacy_agency": {
            "type": [
              "string",
              "null"
            ],
            "description": "Code of the agency that regulates the system, usually the state."
          },
          "primary_source": {
            "type": "object",
            "properties": {
              "code": {
                "type": "string",
                "description": "Source code."
              },
              "label": {
                "type": [
                  "string",
                  "null"
                ],
                "description": "Plain-language source."
              }
            },
            "description": "Ground water, surface water or purchased water; null when EPA holds none.",
            "additionalProperties": true
          },
          "activity_status": {
            "type": "object",
            "properties": {
              "code": {
                "type": "string",
                "description": "A, I, N or M."
              },
              "label": {
                "type": [
                  "string",
                  "null"
                ],
                "description": "Plain-language status."
              }
            },
            "description": "Whether the system is active, inactive, or changed from public to non-public.",
            "additionalProperties": true
          },
          "deactivation_date": {
            "type": [
              "string",
              "null"
            ],
            "description": "Date the system was deactivated, YYYY-MM-DD; null while it is active."
          },
          "population_served": {
            "type": [
              "integer",
              "null"
            ],
            "description": "People served by the system (a count)."
          },
          "service_connections": {
            "type": [
              "integer",
              "null"
            ],
            "description": "Number of service connections."
          },
          "is_school_or_daycare": {
            "type": [
              "boolean",
              "null"
            ],
            "description": "True when the system serves a school or day-care."
          }
        },
        "description": "A public water system from EPA's Safe Drinking Water Information System (SDWIS).",
        "additionalProperties": true
      },
      "description": "Matching systems in EPA's order."
    }
  },
  "additionalProperties": true
}