Show simple item record

Metadata

Other contributing persons, institutions or organisationsBenisch, Jakob - TU-Dresden - RelatedPerson
Other contributing persons, institutions or organisationsHelm, Björn - TU-Dresden - RelatedPerson
Other contributing persons, institutions or organisationsHeidt, Sinaida - TU-Dresden - DataCollector
Other contributing persons, institutions or organisationsGebauer, Ulrike - TU-Dresden - DataCollector
Other contributing persons, institutions or organisationsWittwer, Anika - TU-Dresden - Other
Other contributing persons, institutions or organisationsBaier, Andreas - TU-Dresden - Other
Other contributing persons, institutions or organisationsSchulz, Gesa - TU-Dresden - WorkPackageLeader
Other contributing persons, institutions or organisationsJulia, Zimmermann - TU-Dresden - Other
Other contributing persons, institutions or organisationsGrüner, Stefan - TU-Dresden - ResearchGroup
Other contributing persons, institutions or organisationsGheorghe, Daniel - TU-Dresden - Other
Other contributing persons, institutions or organisationsHartung, Mark - TU-Dresden - Other
Other contributing persons, institutions or organisationsWalter, Rosa - TU-Dresden - WorkPackageLeader
Other contributing persons, institutions or organisationsLinden, Julius-Paul - TU-Dresden - Other
Person(s) who is (are) responsible for the content of the research dataKrebs, Peter - TU-Dresden
Person(s) who is (are) responsible for the content of the research dataMayer, Robin-Pascal - TU-Dresden
Person(s) who is (are) responsible for the content of the research dataWeber, Steffen - TU-Dresden
Type of data acquisitionExperiment: water quality measurement in combined sewer at two measuring stations
Type of data acquisitionObservation: COD transformation between two measuring stations
Used research instruments or devicesCOD 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 devicesFiltration unit (Sartorius AG, Type: Sartolab P20 pressure filter units, Info: Pressurized filtration unit)
Used research instruments or devicesMembrane 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 devicesDispersion (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 devicesBOD measurement (BOD determination from raw sample according to DIN EN 1899-1 (ISO 5815))
Used research instruments or devicesSpectrophotometer (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 devicesSpectrophotometer (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 devicesSpectrophotometer (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 devicesSpectrophotometer (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 devicesPOA Korrelations-Keilsensor (Nivus GmbH, Type: POA-V2U1KTE20L0, Info: POA Korrelations-Keilsensor)
Used research instruments or devicesNivuCompact Echolot (Nivus GmbH, Type: ultrasonic compact echo sounder, Serial No.: 1650NF70607)
Used research instruments or devicesOFR-Radarsensor (Nivus GmbH, Type: OFR-EV0001020, Serial No.: 1882OFG0016)
Research objectsPhysicalObject: combined sewer system
Research objectsSubstance: COD fractions in municipal waste water under dry weather conditions
AbstractIn 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 techniquesPre-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 referencingDresden-Stetzsch
Counties, the data is referencingGERMANYde
Coordinates of places, the data is referencing51°04'33.4"N 13°40'01.2"E (upper measuring location)
Coordinates of places, the data is referencing51°05'00.5"N 13°39'41.4"E (lower measuring location)
Regions the data is referencingDresden, Sachsen
Additional keywordsoptical spectrophotometry
Additional keywordsCOD-fractions
Additional keywordsCOD-transformation
Additional keywordsUV-Vis calibration
Additional keywordsin-situ measurements
Additional keywordscombined sewer
Languagedeu
Year or period of data production2018-2020
Publication year2023
PublisherTechnische Universität Dresden - Faculty of Environmental Sciences - Department of Hydrosciences - Institute of Urban and Industrial Water Management
References on related materialsIsPartOf: 123456789/5825 (Handle)
Content of the research dataDataset: 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 rightsInstitut für Siedlungs- und Industriewasserwirtschaft, TU Dresden
Usage rights of the dataCC-BY-SA-4.0
SoftwareResource Processing: ana::pro 5.9f
SoftwareResource Viewing: NivuFlow 750
SoftwareResource Processing: Microsoft Excel 2019
Additional precise description of disciplineUrban drainage, combined sewer, wastewater management
Discipline(s)Environmental Science and Ecologyde
Title of the datasetMeasuring the transformation of biodegradable and inert COD fraction concentrations along flow path in combined sewer system


Files in this item

Thumbnail
Thumbnail
Thumbnail

This item appears in the following Collection(s)

Show simple item record