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.