HAA5 Moving Avg
City of Bloomington
@usgov.city_of_bloomington_haa5_moving_avg_f077d
City of Bloomington
@usgov.city_of_bloomington_haa5_moving_avg_f077d
Two disinfectant byproducts (DBPs), Total Trihalomethanes (TTHMs) and Haloacedic Acids (HAA5s) are regulated by the Safe Drinking Water Act through the Stage 2 Disinfectant Byproduct Rule. The City of Bloomington Utilities collects samples for DBPs monthly at 8 testing locations throughout the distribution system and follows a quarterly compliance schedule. Compliance is calculated on a Locational Running Annual Average (LRAA). The Maximum Contaminant Levels are 80 µg/l for TTHMs and 60 µg/l for HAA5s. Micrograms per liter (µg/l) is equal to parts per billion (ppb). One part per billion is roughly equal to a teaspoon of water in an Olympic-size swimming pool.
Organization: City of Bloomington
Last updated: 2023-05-20T03:41:15.092661
CREATE TABLE table_1 (
"date" TIMESTAMP,
"marlin" DOUBLE,
"service_center" DOUBLE,
"college_mall" DOUBLE,
"hospital" DOUBLE,
"blucher_poole" DOUBLE,
"profile" DOUBLE,
"gentry" DOUBLE,
"miller_showers" DOUBLE,
"showers_bldg" DOUBLE,
"n_12_month_average_limit" BIGINT -- 12-Month Average Limit,
"n_12_month_average_goal" BIGINT -- 12-Month Average Goal
);Anyone who has the link will be able to view this.