About this Dataset

Watershed Water Quality Data

Data collected to fulfill the requirements of the SWTR (Surface Water Treatment Rule) and FAD (Filtration Avoidance Determination). Data is collected via grab sampling, analysis, LIMS data capture and reporting. Each record represents either a four hour turbidity result, a 24 hour average turbidty result, or a daily fecal coliform result from DEL18DT (Delaware Shaft 18 downtake). Data is used to monitor compliance with the requirements above. There are no limitations for the data.
Organization: City of New York
Last updated: 2020-11-10T17:06:18.049307
Tags: coliform, del18dt, fecal-coliform, quality, turbidity, water, watershed

Tables

Table 1

@usgov.city_of_new_york_watershed_water_quality_data.table_1

67.36 kB
3,833 rows
10 columns

CREATE TABLE table_1 (
  "site" VARCHAR,
  "date" TIMESTAMP,
  "turbidity_ntu_at_12am" DOUBLE  -- Turbidity(NTU) At 12AM,
  "turbidity_ntu_at_4am" DOUBLE  -- Turbidity(NTU) At 4AM,
  "turbidity_ntu_at_8am" DOUBLE  -- Turbidity(NTU) At 8AM,
  "turbidity_ntu_at_12pm" DOUBLE  -- Turbidity(NTU) At 12PM,
  "turbidity_ntu_at_4pm" DOUBLE  -- Turbidity(NTU) At 4PM,
  "turbidity_ntu_at_8pm" DOUBLE  -- Turbidity(NTU) At 8PM,
  "average_24hrturbidity_ntu" DOUBLE  -- Average 24hrTurbidity(NTU),
  "coliform_fecal_fc_100ml" VARCHAR  -- Coliform, Fecal(fc/100mL)
);