top-poop / top-of-the-poops

Analysing Sewage Information from the UK Environment Agency
https://top-of-the-poops.org
Other
17 stars 5 forks source link

Some data for River Lim is missing #13

Open VickiElcoate opened 1 year ago

VickiElcoate commented 1 year ago

The data for the River Lim doesn't include the Uplyme Sewage Treatment Works which it should - it says it's on a tributary but is actually within a metre or so of the main river. The spillage hours are over 2000 in total for the river according to the EA data. Spill data for 2022 - Lyme Regis.xlsx

top-poop commented 1 year ago

Thanks for reporting this - we'll take a look.

top-poop commented 1 year ago

We've looked into this. The data we get from the EA is a bit of a mess. We match up the permit given in the EDM data with the consent id given in the EA permit database. There are a few that despite a lot of data mangling, don't match, so we don't count them. This is one of those. Trying to get perfect data match is quite difficult, and strategies that work for some outlets don't work for others... so we have to accept that we will miss some. If we had some funding we could spend some more time on this.