Time series of flow measurement and water quality monitoring at a large combined sewer overflow in Berlin

The table contains 3 years CSO monitoring time series, already split in 22 separated CSO events. All details about the monitoring set up in the papers and reports indicated below.

Fields:

evtID: event ID

myDateTime; date/time

v: m/s velocity

Q: m³/s flow

TSS: mg/l TSS concentration

COD: mg/l COD concentration

CODf: mg/l dissolved COD concentration

EC: µS/cm electric conductivity

NH4_N: mg/l NH4_N concentration

TSS and COD have been measured with a spectrometer using a linear local calibration as presented in Lepot et al., 2016.

ore information about the monitoring set up in 

Sandoval, S., Torres, A., Pawlowsky-Reusing, E., Riechel, M., Caradot, N. (2013): The evaluation of rainfall influence on CSO characteristics: the Berlin case study. Water Science & Technology Vol. 68 (12): 2683-2690 10.2166/wst.2013.524

Caradot, N. (2012): Continuous Monitoring of Combined Sewer Overflows in the Sewer and the Receiving River: Return on Experience. Kompetenzzentrum Wasser Berlin gGmbH; MIA-CSO Project Report

Riechel, M., Matzinger, A., Pawlowsky-Reusing, E., Sonnenberg, H., Uldack, M., Heinzmann, B., Caradot, N., von Seggern, D., Rouault, P. (2016): Impacts of combined sewer overflows on a large urban river - Understanding the effect of different management strategies. Water Research 105: 264-273 10.1016/j.watres.2016.08.017

Caradot, N., Sonnenberg, H., Riechel, M., Matzinger, A., Rouault, P. (2013): The influence of local calibration on the quality of UV-VIS spectrometer measurements in urban stormwater monitoring. Water Practice & Technology Vol 8 (No 3-4): 417-425 10.2166/wpt.2013.042

Lepot, M., Torres, A., Hofer, T., Caradot, N., Gruber, G., Aubin, J.-B., Bertrand-Krajewski, J.-L. (2016): Calibration of UV/Vis spectrophotometers: A review and comparison of different methods to estimate TSS and total and dissolved COD concentrations in sewers, WWTPs and rivers. Water Research 101 (15 September 2016): 519-534 10.1016/j.watres.2016.05.070

本数据集包含3年的合流制下水道溢流（Combined Sewer Overflow，简称CSO）监测时间序列，已被划分为22个独立的CSO事件。所有关于监测设置的详细信息均见下述论文与报告。

字段说明：
evtID：事件编号
myDateTime：日期/时间
v：流速（单位：m/s）
Q：流量（单位：m³/s）
TSS：总悬浮固体（Total Suspended Solids，TSS）浓度（单位：mg/l）
COD：化学需氧量（Chemical Oxygen Demand，COD）浓度（单位：mg/l）
CODf：溶解性化学需氧量浓度（单位：mg/l）
EC：电导率（Electric Conductivity，EC）（单位：µS/cm）
NH4_N：氨氮浓度（单位：mg/l）

TSS与COD的测定采用紫外-可见分光光度法，并基于Lepot等人2016年的研究中提出的线性局部校准方法完成。

更多关于监测设置的信息见下述论文与报告：
1. Sandoval, S., Torres, A., Pawlowsky-Reusing, E., Riechel, M., Caradot, N. (2013)：《降雨对合流制下水道溢流特征的影响评估——以柏林为例》，《水科学与技术》（Water Science & Technology）第68卷第12期，2683-2690页，DOI: 10.2166/wst.2013.524
2. Caradot, N. (2012)：《下水道及受纳河流中合流制下水道溢流的连续监测：经验回顾》，柏林水能力中心有限公司（Kompetenzzentrum Wasser Berlin gGmbH）；MIA-CSO项目报告
3. Riechel, M., Matzinger, A., Pawlowsky-Reusing, E., Sonnenberg, H., Uldack, M., Heinzmann, B., Caradot, N., von Seggern, D., Rouault, P. (2016)：《合流制下水道溢流对大型城市河流的影响——解析不同管理策略的作用效果》，《水研究》（Water Research）105，264-273页，DOI: 10.1016/j.watres.2016.08.017
4. Caradot, N., Sonnenberg, H., Riechel, M., Matzinger, A., Rouault, P. (2013)：《局部校准对城市雨水监测中紫外-可见分光光度法测量质量的影响》，《水实践与技术》（Water Practice & Technology）第8卷第3-4期，417-425页，DOI: 10.2166/wpt.2013.042
5. Lepot, M., Torres, A., Hofer, T., Caradot, N., Gruber, G., Aubin, J.-B., Bertrand-Krajewski, J.-L. (2016)：《紫外/可见分光光度计的校准：估算下水道、污水处理厂及河流中总悬浮固体、总化学需氧量与溶解性化学需氧量浓度的不同方法综述与对比》，《水研究》（Water Research）101（2016年9月15日），519-534页，DOI: 10.1016/j.watres.2016.05.070