# US EPA SDWIS PWSID Portfolio Activity Status Monitor (`plym-actor-factory/us-epa-sdwis-pwsid-portfolio-status-monitor`) Actor

Watch EPA Public Water System IDs (PWSIDs) and emit typed ACTIVE/ACTIVITY\_CHANGED/DEACTIVATED/REACTIVATED events from the official EPA Envirofacts WATER\_SYSTEM JSON API. Not TRI twin; not ECHO compliance; not nationwide water leads dump; not unpaid water SaaS.

- **URL**: https://apify.com/plym-actor-factory/us-epa-sdwis-pwsid-portfolio-status-monitor.md
- **Developed by:** [Daniel Witney](https://apify.com/plym-actor-factory) (community)
- **Categories:** AI, Automation, Business
- **Stats:** 2 total users, 1 monthly users, 100.0% runs succeeded, 0 bookmarks
- **User rating**: No ratings yet

## Pricing

from $20.00 / 1,000 sdwis pws status event delivereds

This Actor is paid per event. You are not charged for the Apify platform usage, but only a fixed price for specific events.

Learn more: https://docs.apify.com/actors/running/actors-in-store.md#pay-per-event

## What's an Apify Actor?

An Actor is a serverless cloud program that runs on the Apify platform. It has two run modes.
In Batch mode, an Actor accepts a well-defined JSON input, performs an action which can take anything from a few seconds to a few hours,
and optionally produces a well-defined JSON output, datasets with results, or files in key-value store.
In Standby mode, an Actor provides a web server which can be used as a website, API, or an MCP server.

Apify vocabulary and the platform model are defined once, in the agent quickstart at https://apify.com/agents.md.

## How to integrate an Actor?

If asked about integration, you help developers integrate Actors into their projects.
You adapt to their stack and deliver integrations that are safe, well-documented, and production-ready.

Do not guess an integration path. Every one of them is in the agent quickstart at https://apify.com/agents.md: the Apify MCP server, Agent Skills with the Apify CLI, the JavaScript and Python clients, the REST API, and the account-free path for an agent with no human to sign in. It also carries the rule on stating cost before the first paid run.

For examples already wired to this Actor's own input schema, see the [API](#api) section below.

Each client library has reference documentation the quickstart does not restate: [JavaScript/TypeScript](https://docs.apify.com/api/client/js/docs.md) (`npm install apify-client`) and [Python](https://docs.apify.com/api/client/python/docs.md) (`pip install apify-client`).

# README

## US EPA SDWIS PWSID Portfolio Activity Status Monitor

Watch a book of **EPA Public Water System IDs (PWSIDs)** and emit typed activity / deactivation events when the official **EPA Envirofacts `WATER_SYSTEM`** table shows a system **becoming active**, **changing activity code**, **deactivating**, or **re-activating**.

**Not** a TRI facility twin (#31). **Not** an ECHO compliance / violation / enforcement scrape. **Not** a nationwide water-utility leads dump. **Not** unpaid water SaaS. **Not** a health-based violation screener (default SKU is activity status only).

### Why this Actor (A1b — phase3-a1b-next3-v14.md)

Same-job shelf: **0** quiet PWSID portfolio activity-status event PPE products. Adjacent wrong jobs cited from v14 only:

| Actor | Why wrong job |
|-------|----------------|
| `scrapesage/us-water-system-scraper` (1 MAU) | Utility **leads** dump |
| `usta/epa-sdwis-water-systems` (1, NEW 2026-09-08) | Violation **counts by county** CSV |
| `malonestar/epa-drinking-water-quality-screener` (1) | Coordinate → violation/LCR/PFAS **point screener** |

Material wedge: **PWSID watchlist × scheduled official SDWIS WATER\_SYSTEM snapshot diff → typed activity/deactivation events only for the book**.

### Matching honesty

- Primary key: **`pwsid` exact match** after normalize (uppercase, strip separators; typically 9 alphanumerics).
- Name / state / population / owner / source / primacy are **evidence fields**, not alternate match keys.
- First observation of each PWSID = **baseline only** (no product charge).

### Events (PPE)

| Event | When |
|-------|------|
| `SDWIS_PWS_ACTIVE` | Activity becomes Active (`A`) from a non-inactive prior, or appears on WATER\_SYSTEM as Active |
| `SDWIS_ACTIVITY_CHANGED` | Other activity-code / deactivation-date fingerprint changes |
| `SDWIS_DEACTIVATED` | Leaves Active for Inactive (`I`) / deactivation date, or drops off WATER\_SYSTEM |
| `SDWIS_REACTIVATED` | Was inactive-like, now Active (`A`) |

Plus one non-billable `RUN_STATUS` / `FIXTURE_HEALTH` health row per run (Store auto-test path).

### Source

- Official EPA Envirofacts: `https://data.epa.gov/efservice/WATER_SYSTEM/PWSID/{pwsid}/JSON` (no API key).
- Sample verified: `https://data.epa.gov/efservice/WATER_SYSTEM/ROWS/0:2/JSON`.
- Fields used: `pwsid`, `pws_activity_code`, `pws_deactivation_date`, `pws_name`, population, owner/source type, primacy agency. Personal admin-contact fields are **not** required in default product rows.
- Cadence = EPA Envirofacts publish. Pagination / `ROWS` windowing is for discovery only — live path uses **per-PWSID lookup** (portfolio-safe).

### Modes

| `sourceMode` | Behavior |
|--------------|----------|
| `fixture` (default) | Store auto-test: `RUN_STATUS` only unless `emitFixtureDemoEvents=true` |
| `live` | Public Envirofacts API, no key |

### Pricing (Model A — ADR 0010)

- `sdwis-pws-status-event-delivered` @ **$0.02** / unique delivered event ($20 / 1k)
- `apify-actor-start` @ **$0.00005**
- Quiet / baseline / fixture health → **0** product charges

### Legal

**GREEN** — EPA Envirofacts open data. Cite EPA SDWIS + retrieval date. Facility/org activity data; minimise personal admin-contact fields in defaults.

### Input highlights

See `.actor/input_schema.json`. Defaults: `sourceMode=fixture`, `emitFixtureDemoEvents=false`, sample PWSIDs `DC0000001` / `010106001`.

### Coverage limits (honest)

- SDWIS **system activity / deactivation** only — README does **not** claim full health-based violation streaming.
- Absence from `WATER_SYSTEM` ≠ every drinking-water determination / ECHO violation status.
- Not TRI twin, not ECHO twin, not leads dump, not unpaid water SaaS.

# Actor input Schema

## `pwsids` (type: `array`):

EPA Public Water System IDs (durable pwsid keys, e.g. DC0000001, 010106001) to monitor against the official Envirofacts WATER\_SYSTEM table. Exact match after normalize. Invalid entries are skipped with no charge. Not a nationwide dump — only IDs on the book are evaluated.

## `pwsIds` (type: `array`):

Alias for pwsids.

## `signalGroups` (type: `array`):

Which change groups to evaluate: activity (ACTIVE/ACTIVITY\_CHANGED/DEACTIVATED/REACTIVATED on activity code + deactivation date), presence (appear/absent mapped to activity events). Default: all.

## `maxRunSeconds` (type: `integer`):

Wall-clock budget for the run (API lookups + watchlist diff).

## `maxEvents` (type: `integer`):

Stop after this many unique change events are delivered (does not include RUN\_STATUS).

## `resumeFromCheckpoint` (type: `boolean`):

If true, resume PWS snapshots and seen event\_uids from the default Key-Value Store.

## `sourceMode` (type: `string`):

fixture = local/CI / Apify Store daily auto-test default (no network; emits RUN\_STATUS only unless emitFixtureDemoEvents=true). live = official EPA Envirofacts WATER\_SYSTEM JSON API (no API key). Not TRI twin; not ECHO HTML/compliance scrape; not nationwide water leads dump; not unpaid water SaaS.

## `emitFixtureDemoEvents` (type: `boolean`):

When sourceMode=fixture, if true push fabricated change events from local fixtures (unit/local demos only). Default false so Store daily auto-tests never emit fake SDWIS events or charge sdwis-pws-status-event-delivered. Production: leave false and use sourceMode=live. SAMPLE rows only: demo events use placeholder entities (never real companies/IDs), are flagged sample=true / isSample=true, and are NEVER charged.

## `asOfHint` (type: `string`):

Optional as\_of label for events / RUN\_STATUS (retrieval date).

## `maxTotalChargeUsd` (type: `number`):

Optional soft budget hint for delivered change events. Platform ACTOR\_MAX\_TOTAL\_CHARGE\_USD also applies when set.

## `envirofactsBaseUrl` (type: `string`):

Optional override for the official EPA Envirofacts WATER\_SYSTEM service root. Default: https://data.epa.gov/efservice/WATER\_SYSTEM

## Actor input object example

```json
{
  "pwsids": [
    "DC0000001",
    "010106001"
  ],
  "signalGroups": [
    "activity",
    "presence"
  ],
  "maxRunSeconds": 55,
  "maxEvents": 500,
  "resumeFromCheckpoint": true,
  "sourceMode": "fixture",
  "emitFixtureDemoEvents": false
}
```

# Actor output Schema

## `OUTPUT` (type: `string`):

JSON summary: delivered, charged, runStatus, checkpoint, stats, SDWIS WATER\_SYSTEM activity coverage limits

# API

You can run this Actor programmatically using our API. Below are code examples in JavaScript, Python, and CLI, as well as the OpenAPI specification and MCP server setup.

## JavaScript example

```javascript
import { ApifyClient } from 'apify-client';

// Initialize the ApifyClient with your Apify API token
// Replace the '<YOUR_API_TOKEN>' with your token
const client = new ApifyClient({
    token: '<YOUR_API_TOKEN>',
});

// Prepare Actor input
const input = {};

// Run the Actor and wait for it to finish
const run = await client.actor("plym-actor-factory/us-epa-sdwis-pwsid-portfolio-status-monitor").call(input);

// Fetch and print Actor results from the run's dataset (if any)
console.log('Results from dataset');
console.log(`💾 Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`);
const { items } = await client.dataset(run.defaultDatasetId).listItems();
items.forEach((item) => {
    console.dir(item);
});

// 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/js/docs

```

## Python example

```python
from apify_client import ApifyClient

# Initialize the ApifyClient with your Apify API token
# Replace '<YOUR_API_TOKEN>' with your token.
client = ApifyClient("<YOUR_API_TOKEN>")

# Prepare the Actor input
run_input = {}

# Run the Actor and wait for it to finish
run = client.actor("plym-actor-factory/us-epa-sdwis-pwsid-portfolio-status-monitor").call(run_input=run_input)

# Fetch and print Actor results from the run's dataset (if there are any)
print(f"💾 Check your data here: https://console.apify.com/storage/datasets/{run.default_dataset_id}")
for item in client.dataset(run.default_dataset_id).iterate_items():
    print(item)

# 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start

```

## CLI example

```bash
echo '{}' |
apify call plym-actor-factory/us-epa-sdwis-pwsid-portfolio-status-monitor --silent --output-dataset

```

## MCP server setup

```json
{
    "mcpServers": {
        "apify": {
            "type": "http",
            "url": "https://mcp.apify.com/?tools=fetch-actor-details,plym-actor-factory/us-epa-sdwis-pwsid-portfolio-status-monitor"
        }
    }
}
```

The hosted server signs you in with OAuth on first connect, so no API token belongs in this config. Clients without OAuth support can send an `Authorization: Bearer <APIFY_API_TOKEN>` header instead, using a token from API & Integrations in Apify Console (https://console.apify.com/settings/integrations).

## OpenAPI specification

Download the OpenAPI definition: https://api.apify.com/v2/actors/a5MLqSKUIDqGcu1kO/builds/0HTaSHM7VIJdga2vb/openapi.json