Permit and zoning data

Query normalized EPA ECHO NPDES all-version sewer-overflow event rows

Returns R2-backed EPA ECHO NPDES all-version sewer-overflow and bypass event rows with permit, event type, timing, reported discharge volume, current/replaced report flags, replacing payload IDs, receiving-water, coordinate, and source-manifest context. This endpoint is public context, not an autonomous settlement oracle until refresh, checksum, revision-window, and resolver policies are published.

get/api/v1/data/environmental/epa-echo/npdes-sewer-overflow-history

Request

  • Base URL: https://www.homecastr.com
  • URL: https://www.homecastr.com/api/v1/data/environmental/epa-echo/npdes-sewer-overflow-history
  • Auth: none declared

Query parameters

statestring
Example:IL

2-letter permit state prefix.

permit_idstring
Example:IL0029449

NPDES permit identifier.

event_typestring
Example:Sanitary Sewer Overflow

Event type text filter.

yearinteger
Example:2026

Event year from start datetime or report start date.

min_volume_gallonsnumber

Minimum reported discharge volume in gallons.

with_coordinatesboolean

Require latitude and longitude.

current_onlyboolean

Return only rows where EPA marks the report form as current.

include_replacedboolean

If false, exclude replaced or non-current report versions.

limitinteger

Maximum records to return.

summaryboolean

Return manifest and count metadata without row payloads.

Response

EPA ECHO NPDES sewer-overflow event history response.

schema_idstring required
asset_idstring required
source_idstring required
data_snapshot_idstring required
record_countinteger required
filtersobject required
_linksobject required

Example response

{
  "schema_id": "hc.epa_echo_npdes_sewer_overflow_history_event.v1",
  "asset_id": "context.epa_echo_npdes_sewer_overflow_history",
  "source_id": "epa_echo_npdes_sewer_overflow_history",
  "manifest": {
    "schema_id": "hc.epa_echo_npdes_sewer_overflow_history_manifest.v1",
    "run_id": "20260718T200643+0000",
    "source_id": "epa_echo_npdes_sewer_overflow_history",
    "event_payload_bytes": 24299652,
    "event_count": 5480,
    "permit_count": 639,
    "events_with_coordinates": 3768,
    "events_with_volume": 4081,
    "reported_volume_gallons_sum": 15097207815,
    "current_event_count": 4685,
    "replaced_event_count": 795
  },
  "records": [
    {
      "schema_id": "hc.epa_echo_npdes_sewer_overflow_history_event.v1",
      "record_id": "epa_echo_npdes_sewer_overflow_history:IL0029449:4199:303117009",
      "source_id": "epa_echo_npdes_sewer_overflow_history"
    }
  ]
}

Changes

No recorded changes to this operation across all 1 revision of this API.