Dataset of Multiple Water Quality Parameters Measured in a Drinking Water Distribution System

Data was gathered through the deployment of two distinct monitoring systems across four varying locations and connection types. The observation periods spanned from several weeks to several months. Specifically, the YSI EXO 3 monitoring system was placed at three different locations and affixed to fire hydrants, and the ATI MetriNet Q52 system was affixed to a service line within an academic building. These sensors captured multiple water quality parameters, including temperature, conductivity, specific conductivity, turbidity, fDOM, pH, ORP, and combined chlorine, at 5-minute intervals throughout the observation period. The data is split in to five separate datasets. Each dataset is stored in the .csv file format and named dataset_#, where # is the number of the dataset. Each dataset is formatted with labeled columns and values in the appropriate units. Additional supplementary datasets are provided that include the maintenance logs for the YSI and ATI sensors. A Python code is also included to read the data and create time series plots for each parameter.

数据采集是通过在四个不同地点和连接类型上部署两种不同的监测系统来实现的。观测周期从几周到几个月不等。具体而言，YSI EXO 3监测系统被放置在三个不同的地点，并固定在消防栓上，而ATI MetriNet Q52系统则被固定在学术建筑内的服务线路上。这些传感器在观测期间以5分钟为间隔，捕捉了包括温度、电导率、比电导率、浊度、荧光溶解性有机物、pH值、氧化还原电位和总氯在内的多项水质参数。数据被分割成五个独立的子集。每个子集均以.csv文件格式存储，命名为dataset_#，其中#代表子集的编号。每个子集均按照标签化的列和适当的单位进行格式化。此外，还提供了包含YSI和ATI传感器维护日志的补充数据集。同时，还附带了一段Python代码，用于读取数据并为每个参数创建时间序列图。