| Other contributing persons, institutions or organisations | Benisch, Jakob - TU-Dresden - RelatedPerson | |
| Other contributing persons, institutions or organisations | Helm, Björn - TU-Dresden - RelatedPerson | |
| Other contributing persons, institutions or organisations | Heidt, Sinaida - TU-Dresden - DataCollector | |
| Other contributing persons, institutions or organisations | Gebauer, Ulrike - TU-Dresden - DataCollector | |
| Other contributing persons, institutions or organisations | Wittwer, Anika - TU-Dresden - Other | |
| Other contributing persons, institutions or organisations | Baier, Andreas - TU-Dresden - Other | |
| Other contributing persons, institutions or organisations | Schulz, Gesa - TU-Dresden - WorkPackageLeader | |
| Other contributing persons, institutions or organisations | Julia, Zimmermann - TU-Dresden - Other | |
| Other contributing persons, institutions or organisations | Grüner, Stefan - TU-Dresden - ResearchGroup | |
| Other contributing persons, institutions or organisations | Gheorghe, Daniel - TU-Dresden - Other | |
| Other contributing persons, institutions or organisations | Hartung, Mark - TU-Dresden - Other | |
| Other contributing persons, institutions or organisations | Walter, Rosa - TU-Dresden - WorkPackageLeader | |
| Other contributing persons, institutions or organisations | Linden, Julius-Paul - TU-Dresden - Other | |
| Person(s) who is (are) responsible for the content of the research data | Krebs, Peter - TU-Dresden | |
| Person(s) who is (are) responsible for the content of the research data | Mayer, Robin-Pascal - TU-Dresden | |
| Person(s) who is (are) responsible for the content of the research data | Weber, Steffen - TU-Dresden | |
| Type of data acquisition | Experiment: water quality measurement in combined sewer at two measuring stations | |
| Type of data acquisition | Observation: COD transformation between two measuring stations | |
| Used research instruments or devices | 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.) | |
| Used research instruments or devices | Filtration unit (Sartorius AG, Type: Sartolab P20 pressure filter units, Info: Pressurized filtration unit) | |
| Used research instruments or devices | Membrane filter (Sartorius AG, Type: Cellulose nitrate filter, Serial No.: 11306-47-N, Info: diameter: 47 mm; pore size 0,45 µm) | |
| Used research instruments or devices | 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) | |
| Used research instruments or devices | BOD measurement (BOD determination from raw sample according to DIN EN 1899-1 (ISO 5815)) | |
| Used research instruments or devices | 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)) | |
| Used research instruments or devices | 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)) | |
| Used research instruments or devices | 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)) | |
| Used research instruments or devices | 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)) | |
| Used research instruments or devices | POA Korrelations-Keilsensor (Nivus GmbH, Type: POA-V2U1KTE20L0, Info: POA Korrelations-Keilsensor) | |
| Used research instruments or devices | NivuCompact Echolot (Nivus GmbH, Type: ultrasonic compact echo sounder, Serial No.: 1650NF70607) | |
| Used research instruments or devices | OFR-Radarsensor (Nivus GmbH, Type: OFR-EV0001020, Serial No.: 1882OFG0016) | |
| Research objects | PhysicalObject: combined sewer system | |
| Research objects | Substance: COD fractions in municipal waste water under dry weather conditions | |
| Abstract | 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). | |
| Applied methods and techniques | 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). | |
| Areas the data is referencing | Dresden-Stetzsch | |
| Counties, the data is referencing | GERMANY | de |
| Coordinates of places, the data is referencing | 51°04'33.4"N 13°40'01.2"E (upper measuring location) | |
| Coordinates of places, the data is referencing | 51°05'00.5"N 13°39'41.4"E (lower measuring location) | |
| Regions the data is referencing | Dresden, Sachsen | |
| Additional keywords | optical spectrophotometry | |
| Additional keywords | COD-fractions | |
| Additional keywords | COD-transformation | |
| Additional keywords | UV-Vis calibration | |
| Additional keywords | in-situ measurements | |
| Additional keywords | combined sewer | |
| Language | deu | |
| Year or period of data production | 2018-2020 | |
| Publication year | 2023 | |
| Publisher | Technische Universität Dresden - Faculty of Environmental Sciences - Department of Hydrosciences - Institute of Urban and Industrial Water Management | |
| References on related materials | IsPartOf: 123456789/5825 (Handle) | |
| Content of the research data | Dataset: 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. | |
| Holder of usage rights | Institut für Siedlungs- und Industriewasserwirtschaft, TU Dresden | |
| Usage rights of the data | CC-BY-SA-4.0 | |
| Software | Resource Processing: ana::pro 5.9f | |
| Software | Resource Viewing: NivuFlow 750 | |
| Software | Resource Processing: Microsoft Excel 2019 | |
| Additional precise description of discipline | Urban drainage, combined sewer, wastewater management | |
| Discipline(s) | Environmental Science and Ecology | de |
| Title of the dataset | Measuring the transformation of biodegradable and inert COD fraction concentrations along flow path in combined sewer system | |
