About this Dataset

DWSD CSO Event Data

Detroit Water & Sewerage waste water discharge event location data (2008-2014).

Information on location and function of various structures involved with discharging effluent collected by the Detroit Water & Sewerage Department. Combined sewer overflow (CSO) discharge event data from 2008-2014 (2014 data are recorded through June) is available (data are to be interpreted in millions of gallons).
Organization: City of Ferndale, Michigan
Last updated: 2024-02-21T07:00:25.949474
Tags: combined-sewer-overflow, cso, detroit-river, discharge, dwwtp, environment, health, overflow, pollution, rouge-river, sewage, sewer, waste, waste-water-treatment-plant, water

Tables

Table 1

@usgov.city_of_ferndale_michigan_dwsd_cso_event_data_668e4.table_1

21.02 KB
138 rows
16 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "location_id" VARCHAR,
  "structure_type" VARCHAR,
  "location_name" VARCHAR,
  "receiving" VARCHAR,
  "discharge_area" VARCHAR,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "dilute_raw_sewage_2008" DOUBLE,
  "dilute_raw_sewage_2009" DOUBLE,
  "dilute_raw_sewage_2010" DOUBLE,
  "dilute_raw_sewage_2011" DOUBLE,
  "dilute_raw_sewage_2012" DOUBLE,
  "dilute_raw_sewage_2013" DOUBLE,
  "dilute_raw_sewage_2014" DOUBLE,
  "total_dilute_raw_sewage" DOUBLE
);