top-poop / top-of-the-poops

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

Show data by new UK constituencies (post-boundary-review) #18

Open asibs opened 1 year ago

asibs commented 1 year ago

Hi :wave:

Great work on this site!

I've checked out the code, and been trying to get all the data in order to generate data / rankings for the new UK constituencies (post the final boundary review recommendations which came out this year).

I've managed to source a combined dataset of the new shapefiles from MySociety:

And I've got that downloading and loaded into the PostGIS database (I'll put in a PR shortly to show where I'm up to).

However, when I get to the stage of actually loading the water company data, I'm getting errors on the Wales dataset (there's a comment - link looks dodgy - might be time limited? - in the makefile against the consents-wales.zip file, which is the one I'm unable to download).

Do you know where you managed to get this link from? As per the comment, it may be a time-limited download token, but I couldn't find a data download on Wales Water (just a link to an online map...)

Thanks!

asibs commented 1 year ago

Also worth noting the old constituency data download doesn't seem to exist anymore either unfortunately: https://opendata.arcgis.com/api/v3/datasets/19841da5f8f6403e9fdcfb35c16e11e9_0/downloads/data?format=shp&spatialRefId=27700