Total and Dissolved Organic Carbon in Drinking Water Treatment

Total Organic Carbon (TOC) and Dissolved Organic Carbon (DOC) measurements from drinking water treatment, used to evaluate water quality and compliance with U.S. Safe Drinking Water Act regulations. The dataset includes raw and finished water concentrations, removal ratios, and related parameters like UV254 and alkalinity to assess treatment performance. Data columns suggest it is used for regulatory reporting and monitoring the formation of disinfection byproducts.

Use Cases

• Calculating regulatory compliance percentages using Running Annual Average Compliance (%) and IDEM Requirement (%)
• Analyzing treatment plant performance using TOC Removal Ratio, TOC ReductionPCT (%), and Quarterly Average (%)
• Monitoring raw water quality characteristics with Raw TOC (mg/l), Raw DOC (mg/l), Raw UV254 (cm-1), and Raw Alkalinity
• Assessing finished water quality and disinfection byproduct precursor levels using Finish TOC (mg/l) and Fin DOC (mg/l)
• Tracking temporal trends in water treatment by aggregating data by Quarter and DATE

Strengths

• Cross-platform presence on Socrata and Data.gov signals importance and validation
• Columns provide specific, actionable metrics for regulatory compliance (e.g., Running Annual Average Compliance, IDEM Requirement)
• Dataset description explicitly links parameters to federal regulations (Safe Drinking Water Act, LT2ESWTR, Stage 2 DBP Rule)

Limitations

• Critical metadata conflicts: last updated date differs between sources (2026-05-28 vs 2026-04-12)
• Essential metadata missing: row count, dataset size, and author are unknown
• Documentation gaps: no explicit time range or geographic scope provided for the data records

Provenance

Source

data.bloomington.in.gov

Collection Method

Likely collected through routine monitoring at a water treatment facility.

Freshness

Last updated dates conflict: 2026-05-28 (Socrata) and 2026-04-12 (Data.gov)