Reported Sewer Overflows (New For 2023)
State of Maryland
@usgov.state_of_maryland_reported_sewer_overflows_new_for_2023
State of Maryland
@usgov.state_of_maryland_reported_sewer_overflows_new_for_2023
This report has replaced the https://opendata.maryland.gov/Energy-and-Environment/Reported-Sewer-Overflows/3rgd-zjxx/about_data Reported Sewer Overflows. This report contains overflows from February 10th, 2023, onward. Although MDE requires that all public sewer system owners or operators report overflows to us, there may be incidents that were not reported. Note that overflow amounts provided by the person reporting the overflow may be estimated using best professional judgment or they may be actual readings from flow measurement devices when available.
Organization: State of Maryland
Last updated: 2024-05-10T23:52:01.614802
Tags: bypass, sewer-overflow, sso
CREATE TABLE table_1 (
"overflow_type" VARCHAR,
"facility_collection_system" VARCHAR,
"npdes_no" VARCHAR,
"start_date" TIMESTAMP,
"start_time" VARCHAR,
"duration_day" DOUBLE,
"duration_hour" DOUBLE,
"duration_minute" DOUBLE,
"overflow_address" VARCHAR,
"zip" VARCHAR,
"owner_name" VARCHAR,
"discharge_volume" DOUBLE,
"overflow_cause" VARCHAR,
"receiving_water" VARCHAR,
"county" VARCHAR,
"penalty_id" VARCHAR,
"overflow_latitude" DOUBLE,
"overflow_longitude" VARCHAR
);Anyone who has the link will be able to view this.