About this Dataset

Summary Of DBP Quarterly Report

The data tables summarizes the disinfection by-product results for TTHM and HAA5 from distribution sites and calculated compliance values for each quarter

(a) : analyzed by EPA Method 524.3
(b) : analyzed by EPA Method 552.3
LRAA: The Locational Running Annual Average (LRAA) is calculated by taking the value of this quarter and the three previous consecutive quarters.
RAA: The System-wide Running Annual Average (RAA) is calculated by taking the average of the Quarterly Average of this quarter and the three previous consecutive quarters.
OEL: The Operational Evalution Level (OEL) is calculated by averaging 2 times this quarter's value and the two previous consecutive quarters.
Both the LRAA and the System-wide RAA is not to exceed 80 µg/L for TTHM and 60 µg/L for HAA5.
Organization: City of New York
Last updated: 2020-11-10T17:00:25.588805

Tables

Table 1

@usgov.city_of_new_york_summary_of_dbp_quarterly_report.table_1

20.44 kB
840 rows
11 columns

CREATE TABLE table_1 (
  "site" BIGINT,
  "location" VARCHAR,
  "sample_date" TIMESTAMP,
  "analysis_date_tthm_g_l_a" TIMESTAMP  -- Analysis Date TTHM (µg/L) (a),
  "result_tthm_g_l_a" BIGINT  -- Result TTHM (µg/L) (a),
  "lraa_tthm_g_l_a" BIGINT  -- LRAA TTHM (µg/L) (a),
  "oel_tthm_g_l_a" BIGINT  -- OEL TTHM (µg/L) (a),
  "analysis_date_haa5_g_l_b" TIMESTAMP  -- Analysis Date HAA5 (µg/L) (b),
  "result_haa5_g_l_b" BIGINT  -- Result HAA5 (µg/L) (b),
  "lraa_haa5_g_l_b" BIGINT  -- LRAA HAA5 (µg/L) (b),
  "oel_haa5_g_l_b" BIGINT  -- OEL HAA5 (µg/L) (b)
);