Measuring the transformation of biodegradable and inert COD fraction concentrations along flow path in combined sewer system
Contributing person | Heidt, Sinaida | |
Contributing person | Gebauer, Ulrike | |
Contributing person | Technische Universität Dresden - Faculty of Environmental Sciences - Department of Hydrosciences - Institute of Urban and Industrial Water Management | |
Contributing person | Benisch, Jakob | |
Contributing person | Helm, Björn | |
Contributing person | Grüner, Stefan | |
Contributing person | Institut für Siedlungs- und Industriewasserwirtschaft, TU Dresden | |
Contributing person | Walter, Rosa | |
Contributing person | Schulz, Gesa | |
Contributing person | Baier, Andreas | |
Contributing person | Hartung, Mark | |
Contributing person | Wittwer, Anika | |
Contributing person | Linden, Julius-Paul | |
Contributing person | Gheorghe, Daniel | |
Contributing person | Julia, Zimmermann | |
Documentation of the data | Methods: Pre-processing of raw data from identical spectrophotometers: recordings from dilution series from several spectrophotometers were checked for comparability using univariate linear regression analysis and wavelength-specific adjustment functions were developed. Application of developed UV/Vis calibration functions for COD fractions (SS, XS, SI and XI) to raw data from field measurements. Validated and univariate, linearly recalibrated with reference values from analysis results, interpreted using the approach of Roeleveld and Loosdrecht 2002 ("Experience with guidelines for wastewater characterization in The Netherlands"). COD transformation between measuring stations with load-weighted substance concentrations validated and quantified. Comparative value determined from the flow velocity at the lower measuring station. A more detailed explanation of all analysis methods can be found in the dissertation "Fraktionierung des Chemischen Sauerstoffbedarfs mithilfe von Extinktionsmessungen im UV/Vis-Spektralbereich" of Steffen Weber (link: https://nbn-resolving.org/urn:nbn:de:bsz:14-qucosa2-847298). Data Acquisition: water quality measurement in combined sewer at two measuring stations, COD transformation between two measuring stations | |
Additional geographical or spatial references | Dresden-Stetzsch | |
Additional geographical or spatial references | Dresden, Sachsen | |
Additional geographical or spatial references | 51°04'33.4"N 13°40'01.2"E (upper measuring location) | |
Additional geographical or spatial references | 51°05'00.5"N 13°39'41.4"E (lower measuring location) | |
Countries to which the data refer | GERMANY | |
Description of the data | The collected time series of water level, flow velocity and spectrophotometer recordings are provided as raw data. In addition, the data collection contains an ecxel file with analysis results from random sampling - including metadata (time and place of sampling of the wastewater sample, processor, serial number of the spectrophotometer). The data collection includes recordings from two measurement stations installed along a flow path - 940m apart. A catchment area with an urban settlement structure drains via the flow path. The times at which the reference samples were taken at the upper and lower measuring points were selected in such a way that substance transformations in individual water packages could be traced. Waste water that passed the upper measurement location within 3 minutes was referred to as a water package.The data for each measurement day includes wet chemical analysis results (COD, CODmf, BOD5 and NO3-N), the continuously recorded extinction spectra during the test period and their calculated equivalent concentrations based on the manufacturer's calibration "INFLUENT V160". The flow rate was calculated internally in the sensor from the fill level and the flow rate and is also part of the data collection. In addition, dilution series with municipal waste water were generated as a data basis in order to check the comparability of identical spectrophotometer technology in parallel operation. In addition UV/Vis calibration functions for determining COD fractions are part of the upload. They are the result of a laboratory measurement campaign (raw data can be found in the data collection "Batch test for measurement of biodegradable and inert COD fraction concentrations in municipal waste waters using UV-Vis sensors", Weber et al. 2023). The functions were determined using Partial Least Squares Regression (PLS-R): Intercept and the regression coefficients for relevant wavelengths are part of the upload. | |
Type of the data | Dataset | |
Total size of the dataset | 16002356 | |
Author | Weber, Steffen | |
Author | Mayer, Robin-Pascal | |
Author | Krebs, Peter | |
Upload date | 2023-04-12T08:18:52Z | |
Publication date | 2023-04-12T08:18:52Z | |
Publication date | 2026-06-10T15:42:05Z | |
Data of data creation | 2018-2020 | |
Publication date | 2023-04-12 | |
Abstract of the dataset | In wastewater from a combined sewer of the city of Dresden, the wastewater composition was determined using in-situ UV-Vis measurement technology and wet chemical analyzes from random samples as a reference. In addition, the comparability of measurement results from identical spectrophotometer technology was checked. This data set was used for the publication of Steffen Weber's doctoral thesis "Fractionation of the chemical oxygen demand using absorbance measurements in the UV/Vis spectral range" by Steffen Weber (link: https://nbn-resolving.org/urn:nbn:de:bsz:14-qucosa2-847298). The aim of this work was to extend the system understanding of the wastewater composition beyond the standard analysis parameters by using in situ UV-Vis measurement techniques to determine the COD components (fractionated according to activated sludge model No.1). | |
Public reference to this page | https://opara.zih.tu-dresden.de/handle/123456789/2611 | |
Public reference to this page | https://doi.org/10.25532/OPARA-216 | |
dc.language | deu | |
Publisher | Technische Universität Dresden | |
Licence | Attribution-ShareAlike 4.0 International | |
URI of the licence text | http://creativecommons.org/licenses/by-sa/4.0/ | |
Title of the dataset | Measuring the transformation of biodegradable and inert COD fraction concentrations along flow path in combined sewer system | |
Research instruments | Spectrophotometer (s::can GmH, spectro::lyser V2, Serial No.: 09210165, Information: Use manufacturer's global calibration 'INFLUENTV160' for calculation equivalence parameters (TSS, NO3, CODtotal, CODmf, SAC254, SAC436)) | |
Research instruments | NivuCompact Echolot (Nivus GmbH, Type: ultrasonic compact echo sounder, Serial No.: 1650NF70607) | |
Research instruments | Spectrophotometer (s::can GmH, spectro::lyser V2, Serial No.: 18400001, Information: Use manufacturer's global calibration 'INFLUENTV160' for calculation equivalence parameters (TSS, NO3, CODtotal, CODmf, SAC254, SAC436)) | |
Research instruments | COD measurement (Hach Lange GmbH, Type: Cuvette test LCK 314, LCK 514, LCK 014, Info: COD determination from raw sample according to DIN 38409 Teil 4. The homogenization of the sample was carried out according to DIN 38402 Teil 30.) | |
Research instruments | POA Korrelations-Keilsensor (Nivus GmbH, Type: POA-V2U1KTE20L0, Info: POA Korrelations-Keilsensor) | |
Research instruments | Membrane filter (Sartorius AG, Type: Cellulose nitrate filter, Serial No.: 11306-47-N, Info: diameter: 47 mm; pore size 0,45 µm) | |
Research instruments | OFR-Radarsensor (Nivus GmbH, Type: OFR-EV0001020, Serial No.: 1882OFG0016) | |
Research instruments | Spectrophotometer (s::can GmH, spectro::lyser V2, Serial No.: 14350400, Information: Use manufacturer's global calibration 'INFLUENTV160' for calculation equivalence parameters (TSS, NO3, CODtotal, CODmf, SAC254, SAC436)) | |
Research instruments | BOD measurement (BOD determination from raw sample according to DIN EN 1899-1 (ISO 5815)) | |
Research instruments | Spectrophotometer (s::can GmH, spectro::lyser V2, Serial No.: 11280255, Information: Use manufacturer's global calibration 'INFLUENTV160' for calculation equivalence parameters (TSS, NO3, CODtotal, CODmf, SAC254, SAC436)) | |
Research instruments | Dispersion (IKA-Werke GmbH & CO. KG, Type: IKA T25 D (digital ULTRA-TURRAX), Info: used cutting tool S 25 N - G 45 M, max. 10.000 rpm, selected dispersion time between 30 s to 60 s Sauerstoffsensor (Luminescent Dissolved Oxygen-Sensor (LDO), Hach-Lange GmbH, Serial No.: 1108410198) | |
Research instruments | Filtration unit (Sartorius AG, Type: Sartolab P20 pressure filter units, Info: Pressurized filtration unit) | |
Underlying research object | combined sewer system | |
Underlying research object | COD fractions in municipal waste water under dry weather conditions | |
Software | Microsoft Excel (Version 2019) | |
Software | ana::pro (Version 5.9f) | |
Software | NivuFlow 750 | |
Project title | Fraktionierung des chemischen Sauerstoffbedarfs mithilfe von Extinktionsmessungen im UV/Vis-Spektralbereich |
Collections
