A continuous monitoring, using UV-VIS spectrometers, was carried out in Berlin from 2010 to 2012. It combined (i) continuous measurements of the quality and flow rates of combined sewer overflows (CSO) at one main CSO outlet downstream of the overflow structure and (ii) continuous measurements of water quality parameters at five sites within the urban stretch of the receiving River Spree. Locally, the collection of data aims at (i) characterizing CSO emissions, (ii) assessing the local dynamics and intensity of CSO impacts on the river and (iii) calibrating sewer and river water quality models being part of a planning tool for future CSO management in Berlin (Riechel et al., 2011). UV-VIS spectrometers are in-situ probes, which measure absorbance spectra ranging from UV to visual wavelengths. Concentrations, such as chemical oxygen demand (COD), are calculated from these spectra. Due to the varying composition of waste and river water a local calibration is required to enhance the measurement quality. According to Gamerith et al. (2011), manufacturer global calibration can lead to systematic error up to 50% for COD measurements.

Das vorgestellte modellbasierte Werkzeug bildet Mischwasserüberläufe aus dem Berliner Mischkanalsystem und deren kurzfriste Auswirkungen im Gewässer ab. Es soll für die Maßnahmenplanung und die Berechnung von Zukunftsszenarien verwendet werden. Das Werkzeug zeigt eine gute Übereinstimmung mit Messungen bezüglich des Verlaufes der Sauerstoffkonzentration im Gewässer und des Auftretens kritischer Bedingungen für die Fischfauna. Eine Szenarienuntersuchung für ein Extremjahr zeigt, dass durch die bis zum Jahr 2020 geplante Stauraumvergrößerung die Häufigkeit fischkritischer Bedingungen im Gewässer bereits um ein Drittel reduziert werden kann. Eine Reduktion um ein zusätzliches Drittel wäre durch weitergehende Maßnahmen im Bereich der Entsiegelung möglich. Die verbleibenden fischkritischen Bedingungen sind das Ergebnis von sehr starken Regenereignissen und können kaum verhindert werden. Eine durch Klimaveränderung erhöhte oder reduzierte Regenintensität im Sommer hätte starken Einfluss auf das Auftreten fischkritischer Bedingungen; die erwartete Temperaturerhöhung würde hingegen hauptsächlich die Sauerstoffsituation bei Trockenwetter verschlechtern.

Das vorgestellte modellbasierte Werkzeug bildet Mischwasserüberläufe aus dem Berliner Mischkanalsystem und deren kurzfristige Auswirkungen im Gewässer ab. Es soll für die Massnahmenplanung und die Berechnung von Zukunftsszenarien verwendet werden. Das Werkzeug zeigt eine gute Übereinstimmung mit Messungen bezüglich des Verlaufes der Sauerstoffkonzentration im Gewässer und des Auftretens kritischer Bedingungen für die Fischfauna.

Data play an important role in water-related research. In the field of limnology, monitoring data are needed to assess the ecological status of water bodies and understand the bio-geochemical processes that affect this status. In wastewater management, measured or simulated data are the basis for planning and control of sewer networks. Given the importance of data in water-related research makes them a valuable resource, which should be handled in an adequate way. Based on experiences in data collection and data processing in water-related research this paper proposes – both from a computer scientist’s and an environmental engineer’s point of view – a set of rules for data handling: Rule 1: Protect raw data. Rule 2: Save metadata. Rule 3: Use databases. Rule 4: Separate data from processing. Rule 5: Use programming. Rule 6: Avoid redundancy. Rule 7: Be transparent. Rule 8: Use standards and naming conventions. Applying these rules (i) increases the quality of data and results, (ii) allows to prepare data for long-term usage and make data accessible to different people, (iii) makes data processing transparent and results reproducible, and (iv) saves – at least in the long run – time and effort. With this contribution the authors would like to start a discussion about best data handling practices and present a first checklist of data handling and data processing for practitioners and researchers working in the water sector.

Combined sewer overflows (CSO) after heavy rainfall can cause acute depletions of dissolved oxygen (DO) in the Berlin River Spree. Further aggravation of ecological deficits can be expected from global climate change. A planning instrument for CSO impact assessment under different sewer management and climate conditions has been developed at Kompetenzzentrum Wasser Berlin. It couples the sewer model InfoWorks CS, the river water quality model Hydrax/QSim and an impact assessment tool. The planning instrument was validated for the years 2010 and 2011. Simulation results for the critical parameters discharge and DO concentrations in the Berlin River Spree agree well with measurements. Although not all observed DO deficits can be simulated accurately, the very good representation of processes related to the oxygen budget allows assessing relative changes in boundary conditions, e.g. from climate change or different CSO control strategies. The conducted scenario analysis indicates that the coupled sewer-rivermodel reacts sensitively to changes in boundary conditions (temperature, rainfall, storage volume and other CSO control strategies, etc.). Based on the simulation year 2007 – representing an extreme year with regards to CSO volume and critical conditions in the river – sewer rehabilitation measures planned to be implemented until 2020 are predicted to reduce total CSO volumes by 17% and discharged pollutant loads by 21 - 31%. The frequency of critical DO conditions for the most sensitive local fish species will decrease by one third. For a further improvement of water quality after the year 2020, the reduction of impervious surfaces emerges as a very effective management strategy where feasible. A reduction of the impervious connected area by 20% results in a decrease in the frequency of critical DO conditions by another third. The studied increase in surface air and water temperature as part of the climate change scenarios leads to a significant aggravation of DO stress due to background pollution in the Berlin River Spree, while acute DO depletions after CSO are barely affected. However, changes in rain intensity have a considerable effect on CSO volumes, pollutant loads and the frequency of critical DO concentrations. A general reduction of discharged pollutant loads by 60% based on the sewer status 2020 can prevent critical DO conditions in the Berlin River Spree, even for the exceptionally rain intense year 2007. A detailed analysis of river processes after CSO, has shown that the biodegradation of organic carbon compounds is the most important contributor to acute DO depletions in the Berlin River Spree. An additional impairment of DO conditions is caused by the inflow of oxygen free CSO spill water and suspended solids into the Berlin River Spree. In this report, CSO impacts under different management strategies or climate change conditions are assessed only for a part of the Berlin combined sewer system (although the main part) and for one exemplary year. An extension of the planning instrument to the entire combined sewer system would enable to evaluate the full impact of measures. For a robust prediction of future CSO impacts it is also recommended to test different simulation periods or conduct long-term simulations.

Theoretically the Berlin River Spree could be under pressure from depressions in dissolved oxygen (DO) and high concentration of fish toxic ammonia following overflows of the combined sewer system. However, monitoring results indicate that the Spree is only under pressure from depressions in dissolved oxygen (DO). Consequently, a sewer model, a river water quality model and an impact assessment tool were calibrated and validated for representation of DO depressions. The three elements are joined in a planning tool, which will be used to test the effect of CSO management approaches for the current situation and with altered boundary conditions to account for expected climate change.

Im Rahmen eines Forschungsprojektes wurden die Auswirkungen von Mischwasserentlastungen auf die Berliner Stadtspree untersucht und ein Planungsinstrument zur Reduzierung der Auswirkungen von Mischwasserüberläufen entwickelt.