Storm overflows (England)
Updated:
The Water and Sewerage Companies provide data to the Environment Agency each year as part of their regulatory Annual Return, to fulfil their permitted conditions to discharge from these storm overflows under the Environmental Permitting Regulations. We took the OS Grid Reference for every storm overflow event reported in the Environment Agency's Event Duration Monitoring datasets (2022, 2023 and 2024) and found the corresponding Parliamentary constituency to create the visualisations for total number of spills and total duration in hours.
Total spills§
This visualisation shows the result of adding up the values in the Counted spills using 12-24h count method
column by constituency calculated from the OS Grid Reference.
Total duration (hours)§
This visualisation shows the result of adding up the values in the Total Duration (hrs) all spills prior to processing through 12-24h count method
or Total Duration (hh:mm:ss) all spills prior to processing through 12-24h count method
columns by constituency calculated from the OS Grid Reference.
Notes
The totals are similar but not-quite-the-same-as those shown at Top of the Poops. We haven't been able to determine why there are differences.
The 2024 data has a column Total Duration (hh:mm:ss) all spills prior to processing through 12-24h count method
which should be in "hh:mm:ss" format but which has been converted to a date string by Excel i.e. a date since 1900. As Excel incorrectly thinks 1900 was a leap year, this means that long duration spills (that Excel thinks extend beyond the end of February) may be wrong by 24 hours.