[Talk-GB] Anyone fancy a bit of mindless drudgery?

[osm at poppe.dev]

I was the one asking for the source data.

There seem to be three versions of the XLSX:

July 2020: https://www.yorkshirewater.com/media/f10fpjkw/yky-bioresources-market-information-2020.xlsx
July 2021: https://www.yorkshirewater.com/media/te0n4ivv/bioresources-market-information.xlsx (found via Internet Archive, but still one the server)
June 2022: https://www.yorkshirewater.com/media/sxnfahsl/market-information-publication.xlsx (current one)
(the page where the market info are linked from isn't archived before Oct 2021 sadly)

I haven't got the time right now to compare where the off-by-one-error exists.

K

On Tue, 14 Feb 2023 10:57:26 +0000 Andy Townsend ajt1047 at gmail.com said

> I suspect that "place/STW" is just a copy and paste from the
>      spreadsheet that the original mapper used.  Handily, that
>      formatting allows a web search to find the data: 
> https://www.yorkshirewater.com/media/f10fpjkw/yky-bioresources-market-information-2020.xlsx
> 
> Personally, I'd have omitted the "/STW" part (likely as per the
>      sign) since that formatting appears to be just for Excel's
>      benefit. 
> 
> In that version there's no off by one error so Flaxton is at 
> 
> https://www.openstreetmap.org/#map=19/54.04490/-0.96097 
> which is correct.  Someone was asking for the source data -
>      perhaps web.archive.org has an earlier version of Yorkshire
>      Water's website without the off-by-one error in it? 
> Best Regards, 
> Andy 
> PS: Overpass says down to 35 now: https://overpass-turbo.eu/s/1oyq 
> 
> On 14/02/2023 10:23, Philip Barnes
>      wrote: 
> Thank you Russ 
> 
> I had assumed it was the operator, but it does illustrate
>      perfectly why abbreviations should be expanded as you cannot
>      assume it will be interpreted the same way by different people. 
> 
> Phil (trigpoint) 
> 
> On 14 February 2023 10:10:51 GMT, Russ
>        Garrett  wrote: On Tue, 14 Feb 2023 at 10:08, Philip Barnes  wrote:
> Main error is they have included (STW) in the name. This is not part of the
> name but the operator which was already included. I suspect STW here stands
> for Sewage Treatment Works, not Severn Trent
> Water. I'd argue that it should be part of the name, but the
> abbreviation should be expanded. 
> _______________________________________________
> Talk-GB mailing list Talk-GB at openstreetmap.org
> https://lists.openstreetmap.org/listinfo/talk-gb