US EPA SDWIS PWSID Portfolio Activity Status Monitor
Pricing
from $20.00 / 1,000 sdwis pws status event delivereds
US EPA SDWIS PWSID Portfolio Activity Status Monitor
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.
Pricing
from $20.00 / 1,000 sdwis pws status event delivereds
Rating
0.0
(0)
Developer
Daniel Witney
Maintained by CommunityActor stats
0
Bookmarked
2
Total users
1
Monthly active users
3 days ago
Last modified
Categories
Share
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:
pwsidexact 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 /
ROWSwindowing 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.
