| Other contributing persons, institutions or organisations | Brückner, Heike - TU Dresden - DataCollector | |
| Other contributing persons, institutions or organisations | Oertel, Reinhard - TU Dresden - DataCollector | |
| Other contributing persons, institutions or organisations | Reyes Silva, Julian David - RelatedPerson | |
| Other contributing persons, institutions or organisations | Weber, Steffen - TU Dresden - ResearchGroup | |
| Other contributing persons, institutions or organisations | Benisch, Jakob - TU Dresden - RelatedPerson | |
| Other contributing persons, institutions or organisations | Walter, Rosa - TU Dresden - Other | |
| Other contributing persons, institutions or organisations | Hartung, Mark - TU Dresden - Other | |
| Other contributing persons, institutions or organisations | Gheorghe, Daniel - TU Dresden - Other | |
| Other contributing persons, institutions or organisations | Wischnewski, Jonas - TU Dresden - Other | |
| 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 | Mann, Ute - TU Dresden - DataCollector | |
| Person(s) who is (are) responsible for the content of the research data | Grüner, Stefan - 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 | Krebs, Peter - TU Dresden | |
| Description of further data processing | The collected time series of flow, level and flow velocity records are provided as raw data.
The excel file contains the reference parameters and analysis results of the sampling at the combined sewer. The data include wet chemical analysis results, the results of the pharmaceutical trace substance analysis, the recorded absorbance spectra during sampling and their calculated reference parameters based on manufacturer's calibration 'InfluentV160' of the Spectrolyser V2. The included values were taken from the respective data formats and merged into a file without further processing, based on their time stamp (CEST). | |
| Used research instruments or devices | POA Korrelations-Keilsensor (Nivus GmbH, Type: POA-V2U1KTE20L0, Info: POA Korrelations-Keilsensor) | |
| Used research instruments or devices | TOC/DOC measurement (Shimadzu Deutschland GmbH, Type: TOC V CPH, Info: determination according to DIN EN 1484) | |
| 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 | Solid phase extraction (SPE) (Gilson Incorporated, Type: Abimed ASPEC XL) | |
| Used research instruments or devices | high performance liquid chromatography (HPLC) (Thermo Fisher Scientific GmbH, Type: Dionex-HPLC-System (UltiMate 3000 Pumpe und Autosampler), Info: HPLC-MS/MS) | |
| Used research instruments or devices | Tandem Mass Spectrometry (HPLC-MS/MS) (AB Sciex LLC, Type: API 4000 Tandem-Massenspektrometer) | |
| Used research instruments or devices | Spectrophotometer (s::can GmH, Spectrolyser V2, Serial No.: SP-1-005-p0-S-NO-075 Info: Use of the manufacturer's global calibration 'INFLUENTV160' for calculation of equivalence parameters (TSS, NO3, CODtotal, CODmf, SAC254, SAC436) using the device-specific software) | |
| Used research instruments or devices | Automatic sampler (MAXX Mess- und Probenahmetechnik GmbH, Type: SP5 B with peristaltic pump (peristaltic system), Serial No.: 33557) | |
| 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) | |
| 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 | Extraction cartridges (Waters Corporation, Type: Oasis HLB 1cc (10 mg) Extraction cartridges, Info: Before extraction, 50 mL of sample was mixed with 500 µL of Na_2-EDTA solution (80 mg mL-1)) | |
| 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 | |
| Used research instruments or devices | 63 µm-Analysis sieve (VWR International GmbH, Type: VWR Test Sieves - 63 µm, Catalogue Number: 510-0618, Info: diameter 200 mm, mesh size <=63 µm, Frame: Stainless Steel 1.4301 – AISI 304, Material of sieve cloth: Stainless Steel 1.4401/1.4404 – AISI 316/316L) | |
| Research objects | PhysicalObject: The object of research is the discharge within the combined sewer system. The investigation was carried out using a measuring station (for further details see section 5). | |
| Abstract | The wastewater composition was determined at a combined sewer of the city of Dresden using in situ UV-Vis measurement technology, referenced by wet-chemical analysis of collected samples and additionally a determination of pharmaceutical trace substances was carried out.
This data set was used for the publication of the doctoral thesis "Multiparameteranalyse und pharmazeutische Spurenstoffuntersuchung im Mischwasserkanal" of Stefan Grüner. (link: https://nbn-resolving.org/urn:nbn:de:bsz:14-qucosa2-793815).
The aim of this work was to extend the system understanding of wastewater composition beyond the standard analytical parameters by using in situ UV-Vis measurement techniques, enhanced by the determination of pharmaceutical trace substances for different solid fractions. | |
| Applied methods and techniques | The sampling campaign to collect the reference samples was carried out as follows:
sampling campaign at MS1 Flensburger Str. (catchment area population: approx. 3800 Inhabitants, no hospitals or medical institutions connected to combined sewer system, mean daily flow at MS1: approx. 600 m3).
field instruments used for campaign under g):
prerequisites for sampling campaigns: minimum of 12 hours dry weather conditions prior to sampling campaign.
24 samples over a time period of 24 hours (1000 ml/hour):
Mixed sample (sample nr. 25) created out of aliquot of all 24 samples using flow proportional data registered by flow meters.
the wet chemical analyses were carried out according to standardized procedures:
TSS/VSS: analysis according to 'DIN 38409 Teil 2 (H2)', Homogenization of the sample according to 'DIN 38402 Teil 30 (A30)'.
COD: analysis according to 'DIN 38409 Teil 41 (DIN 1980)', Homogenization of the sample according to 'DIN 38402 Teil 30 (A30)'.
TOC/DOC: analysis according to 'DIN EN 1484'.
The pharamaceutical trace substance analysis was carried out according to the following procedure:
Methodology results of a comination of solid phase extraction (SPE) combined with high performance liquid chromatography and tandem mass spectrometry (HPLC-MS/MS).
SPE: Cleansing and removal of disruptive matrix compounds of wastewater, then enrichment of sample in order to lower LoQ (Limit of Quantification).
Chromatic separation: HPLC works with unpolar solid phase and polar liquid phase, the longer analytes adsorb at solid phase, the longer they remain in chromatographic detection phase.
Mass spectrometric detection: works with triple-quadrupols (QqQ), combination of methodologies via electro spray ionisation (ESI - atmospheric ionisation method): Ions quantified selectively and sensitively within QqQ-mass spectrometer.
A more detailed explanation of all analysis methods can be found in the dissertation "Multiparameteranalyse und pharmazeutische Spurenstoffuntersuchung im Mischwasserkanal" of Stefan Grüner (link: https://nbn-resolving.org/urn:nbn:de:bsz:14-qucosa2-793815). | |
| Additional descriptive information to understand the data | Naming convention of lab parameters (the following additions were used for a more precise classification): '_total' - Analysis of the raw sample was performed. '_63' - Analysis of the fractionated sample from 0,45 to 63 µm was performed. '_mf' - Analysis of the membrane filteres sample (<=0,45 µm) was performed.
Further information on pharmaceutical trace substance analysis: Values above 10000 ng/L and 20000 ng/L indicate that the limit of quantification of the measuring instrument was exceeded. A incorrect measurement could not be entirely excluded. It is recommended to treat the values as outliers and exclude them from evaluations. The determination of measured values for levetiracetam was affected by a high degree of uncertainty. This must be taken into account when carrying out evaluations for this parameter.
PhD related information: The 'mp'-values were not used in PhD for the data sets for calibration and validation using linear regression. Since they are the wet chemical analysis results of the individual samples already considered. Values that where treated as outliers and not used for evaluation within PhD:
CODmf: 308 [mg/L] (2018-03-28 07:15:00 CEST),
Pregabalin: 37,66 [ng/L] (2019-10-07 21:00:30 CEST).
All pharamceutical concentrations below the threeshold of measuring device (tagged with '<') where treated as '0' within PhD. The determination of measured values for levetiracetam was affected by a high degree of uncertainty. Within the doctoral thesis, substances ciprofloxacin and levofloxacin were not evaluated, due to the limited data base. | |
| Counties, the data is referencing | GERMANY | de |
| Coordinates of places, the data is referencing | measuring location: 51°04'33.4"N 13°40'01.2 "E | |
| Regions the data is referencing | Sachsen | |
| Additional keywords | UV-Vis calibration, in-situ measurements, combined sewer, fine particulate solids, pharmaceutical trace substances | |
| Year or period of data production | 2017-2019 | |
| Publication year | 2022 | |
| Publisher | Technische Universität Dresden - Faculty of Environmental Sciences - Department of Hydrosciences - Institute of Urban and Industrial Water Management | |
| Content of the research data | Text, Dataset: The data set includes the absorption spectra of a UV-Vis probe (from 200 nm to 735 nm, in 2.5 nm intervals), flow, level and flow velocity signals, as well as the analytical results of a total of 173 corresponding reference samplings (102 dry weather, 71 wet weather). Based on wet chemical analysis, the reference samples were analyzed for 14 water quality parameters and 14 pharmaceutical trace substances. In addition to analysis of the raw samples, the solid fractions (membrane filtered (<0.45 µm) and <63 µm) were also analyzed for a number of the analytical parameters. | |
| Holder of usage rights | Institut für Siedlungs- und Industriewasserwirtschaft, TU Dresden | |
| Usage rights of the data | CC-BY-4.0 | |
| Software | Resource Processing: ana::pro 5.9f | |
| Software | Resource Processing: maxxware Connect 2.1 | |
| 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 | Analysis of water quality parameters and pharmaceutical trace substances for different solid fractions in a combined sewer. | |
