Re: [Talk-GB] Q2 2020 Quarterly project GP Surgeries and health sites

[Mark Goodge]

On 17/04/2020 15:15, Brian Prangle wrote:
Rather than mappers up and down the country with varying evels of Excel 
skills spending many dozens of hours cleaning up this csv could somebody 
be kind enough to publish somewhere a cleaned up copy? It would be a 
great resource for the QP.


OK, here you go. Here are Excel and proper comma separated csv versions.

https://www.dropbox.com/s/ekokv1lz4wlgxfg/Pharmacies.xlsx?dl=0
https://www.dropbox.com/s/xhszbngsps4p14e/Pharmacies.csv?dl=0

I haven't made any attempt to normalise the addresses. Doing so reliably 
would require referencing AddressBase or the PAF, and therefore render 
the data non-open. And doing it unreliably is probably worse than not 
doing it at all.


It is not, though, particularly difficult to import the original version 
into a spreadsheet or database, and I would recommend that anyone who 
wants to use this data regularly does take a bit of time to learn how.


Mark



___
Talk-GB mailing list
Talk-GB@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-gb

Re: [Talk-GB] HS2 Phase 1 Construction NTP

[Brian Prangle]

Hi Andy

I think maybe a bit premature to make the change you've suggested. OK to
convert parcels of land to landuse-=construction as and when HS2 activity
gets going - even if its only demolition.

Regards

Brian

On Fri, 17 Apr 2020 at 11:48, Andy Robinson  wrote:

> Tony, thus far all the construction activity has been and is enabling
> works. That is mostly related to relocating utilities (especially the major
> ones), site clearances and the establishment of the working compounds. Many
> of these have already in full or in part been mapped into OSM. As yet they
> haven’t mostly been fencing off the main line route. I expect we will see
> that happen soon for the over land sections. In London not much change will
> be visible beyond the current clearances and site compound set-ups. The
> shafts and portals for the main tunnels will be about the only obvious new
> work in the future outside of the station developments. The construction of
> the stations themselves is not yet confirmed.
>
>
>
> Cheers
>
> Andy
>
>
>
> *From:* Tony OSM [mailto:tonyo...@gmail.com]
> *Sent:* 17 April 2020 10:02
> *To:* talk-gb@openstreetmap.org
> *Subject:* Re: [Talk-GB] HS2 Phase 1 Construction NTP
>
>
>
> we've seen news reports of parts of the alignment fenced off and invaded
> by protestors - those parts are certainly under construction, and the
> pictures show that bulldozers have been active. I think if we can identify
> those areas then construction is now correct.
>
> Tony Shield
>
> TonyS999
>
> On 17/04/2020 09:14, Andy Robinson wrote:
>
> Jez, I think the actual rails may be a long way off but I agree it’s an
> opportunity to stay ahead of the completion.
>
>
>
> A question for the whole list. How do folks feel about changing the Phase
> 1 route from rail=proposed to rail=construction. Perhaps it’s a bit
> premature but then perhaps not.
>
>
>
> Cheers
>
> Andy
>
>
>
> *From:* Jez Nicholson [mailto:jez.nichol...@gmail.com
> ]
> *Sent:* 16 April 2020 22:15
> *To:* Andy Robinson
> *Cc:* Talk-GB
> *Subject:* Re: [Talk-GB] HS2 Phase 1 Construction NTP
>
>
>
> Thanks Andy, this is opportunity for OSM to be *the* best source of HS2
> rails data.
>
>
>
> On Wed, 15 Apr 2020, 17:48 Andy Robinson,  wrote:
>
> Government issued Notice to Procced for Phase 1 today, which means the
> main contracts construction between London and Birmingham will start
> imminently so keep an eye out for major new works in your area soon (though
> I expect these will be slow to spot while we are in lockdown!)
>
>
>
> Till now all works relating to HS2 have been enabling works or design
> related.
>
>
>
> Cheers
>
> Andy
>
> ___
> Talk-GB mailing list
> Talk-GB@openstreetmap.org
> https://lists.openstreetmap.org/listinfo/talk-gb
>
>
>
> ___
>
> Talk-GB mailing list
>
> Talk-GB@openstreetmap.org
>
> https://lists.openstreetmap.org/listinfo/talk-gb
>
> ___
> Talk-GB mailing list
> Talk-GB@openstreetmap.org
> https://lists.openstreetmap.org/listinfo/talk-gb
>
___
Talk-GB mailing list
Talk-GB@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-gb

Re: [Talk-GB] Q2 2020 Quarterly project GP Surgeries and health sites

[Brian Prangle]

Rather than mappers up and down the country with varying evels of Excel
skills spending many dozens of hours cleaning up this csv could somebody be
kind enough to publish somewhere a cleaned up copy? It would be a great
resource for the QP.

Regards

Brian

On Thu, 16 Apr 2020 at 16:00, Peter Neale via Talk-GB <
talk-gb@openstreetmap.org> wrote:

> Thanks for pointing out how to import and convert the file.  After a bit
> of trial and error, I discovered how to get Excel to use the "¬" as the
> delimiter and (as you said), the addresses are quite inconsistent, but the
> data all lines up again in the Post Code Column.  There are some further
> issues in the ParentName Column, with the County sometimes duplicated there
> and sometimes there instead of the County Column.
>
> Thank you for taking me a step forward in my "How to Use Excel" course!
>
> Regards,
> Peter
>
>
> On Thursday, 16 April 2020, 13:52:06 BST, Robert Whittaker (OSM lists) <
> robert.whittaker+...@gmail.com> wrote:
>
>
> On Thu, 16 Apr 2020 at 12:27, Peter Neale  wrote:
> > I tried following the link to your proposed new source of “official”
> data, but none of the 3 links to the data worked very well for me.
> >
> > Link 1:  (API format) led to http 404 error.
> > Link 2  (CSV(TSV) format – led to http 404 error
> > Link 3  (XSV format) downloaded a file with a “.csv” file extension that
> seemed to be tab-separated, rather than comma-separated.  I took that into
> a text editor and did a global Find and Replace of Tab with Comma.  The
> resultant .csv file loaded into Excel just fine, but it has over 11,000
> lines and many of them must now have additional commas, because a number of
> fields are right-shifted (Post Code in the Latitude Column, Latitude in the
> Longitude Column, etc.)  Also, over 700 have Blank in the Address1 Field,
> with the whole address in Address 2, Address 3, etc.  Then quite a few
> (from my sample in the first 30) have County values in the ParentName
> Field.  So I fear that, unless you can do a better conversion than I did
> (and you almost certainly could, I know!) you will have a lot of manual
> cleaning up to do, before you can use this data.
>
> Yes, the first two links at
> https://data.gov.uk/dataset/e373eb6a-fffd-48e5-b306-71eb17f97af2/pharmacies
> are broken for me as well. For the third link, it looks like they
> tried to do CSV, but didn't understand how to escape commas within the
> fields, and so opted to use a different character "¬" instead. If you
> import this into a spreadsheet, and tell it to use just "¬" as the
> column separator, I think it works out fine, with all the entries in
> the right place. (You can certainly do this with LibreOffice; I'm not
> sure about Excel.) The address lines seem to be used inconsistently,
> but everything is back aligned when you get to the postcode field.
>
> Best wishes,
>
>
> Robert.
>
> --
> Robert Whittaker
>
> ___
> Talk-GB mailing list
> Talk-GB@openstreetmap.org
> https://lists.openstreetmap.org/listinfo/talk-gb
> ___
> Talk-GB mailing list
> Talk-GB@openstreetmap.org
> https://lists.openstreetmap.org/listinfo/talk-gb
>
___
Talk-GB mailing list
Talk-GB@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-gb

Re: [Talk-GB] HS2 Phase 1 Construction NTP

[Andy Robinson]

Tony, thus far all the construction activity has been and is enabling works. 
That is mostly related to relocating utilities (especially the major ones), 
site clearances and the establishment of the working compounds. Many of these 
have already in full or in part been mapped into OSM. As yet they haven’t 
mostly been fencing off the main line route. I expect we will see that happen 
soon for the over land sections. In London not much change will be visible 
beyond the current clearances and site compound set-ups. The shafts and portals 
for the main tunnels will be about the only obvious new work in the future 
outside of the station developments. The construction of the stations 
themselves is not yet confirmed.

 

Cheers

Andy

 

From: Tony OSM [mailto:tonyo...@gmail.com] 
Sent: 17 April 2020 10:02
To: talk-gb@openstreetmap.org
Subject: Re: [Talk-GB] HS2 Phase 1 Construction NTP

 

we've seen news reports of parts of the alignment fenced off and invaded by 
protestors - those parts are certainly under construction, and the pictures 
show that bulldozers have been active. I think if we can identify those areas 
then construction is now correct.

Tony Shield

TonyS999

On 17/04/2020 09:14, Andy Robinson wrote:

Jez, I think the actual rails may be a long way off but I agree it’s an 
opportunity to stay ahead of the completion.

 

A question for the whole list. How do folks feel about changing the Phase 1 
route from rail=proposed to rail=construction. Perhaps it’s a bit premature but 
then perhaps not.

 

Cheers

Andy

 

From: Jez Nicholson [mailto:jez.nichol...@gmail.com] 
Sent: 16 April 2020 22:15
To: Andy Robinson
Cc: Talk-GB
Subject: Re: [Talk-GB] HS2 Phase 1 Construction NTP

 

Thanks Andy, this is opportunity for OSM to be *the* best source of HS2 rails 
data.

 

On Wed, 15 Apr 2020, 17:48 Andy Robinson,  wrote:

Government issued Notice to Procced for Phase 1 today, which means the main 
contracts construction between London and Birmingham will start imminently so 
keep an eye out for major new works in your area soon (though I expect these 
will be slow to spot while we are in lockdown!)

 

Till now all works relating to HS2 have been enabling works or design related.

 

Cheers

Andy

___
Talk-GB mailing list
Talk-GB@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-gb





___
Talk-GB mailing list
Talk-GB@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-gb

___
Talk-GB mailing list
Talk-GB@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-gb

Re: [Talk-GB] HS2 Phase 1 Construction NTP

[Jez Nicholson]

+1 for changing Phase One to rail=construction  although not, like my
earlier typo, rails=construction ;)

On Fri, Apr 17, 2020 at 10:03 AM Tony OSM  wrote:

> we've seen news reports of parts of the alignment fenced off and invaded
> by protestors - those parts are certainly under construction, and the
> pictures show that bulldozers have been active. I think if we can identify
> those areas then construction is now correct.
>
> Tony Shield
>
> TonyS999
> On 17/04/2020 09:14, Andy Robinson wrote:
>
> Jez, I think the actual rails may be a long way off but I agree it’s an
> opportunity to stay ahead of the completion.
>
>
>
> A question for the whole list. How do folks feel about changing the Phase
> 1 route from rail=proposed to rail=construction. Perhaps it’s a bit
> premature but then perhaps not.
>
>
>
> Cheers
>
> Andy
>
>
>
> *From:* Jez Nicholson [mailto:jez.nichol...@gmail.com
> ]
> *Sent:* 16 April 2020 22:15
> *To:* Andy Robinson
> *Cc:* Talk-GB
> *Subject:* Re: [Talk-GB] HS2 Phase 1 Construction NTP
>
>
>
> Thanks Andy, this is opportunity for OSM to be *the* best source of HS2
> rails data.
>
>
>
> On Wed, 15 Apr 2020, 17:48 Andy Robinson,  wrote:
>
> Government issued Notice to Procced for Phase 1 today, which means the
> main contracts construction between London and Birmingham will start
> imminently so keep an eye out for major new works in your area soon (though
> I expect these will be slow to spot while we are in lockdown!)
>
>
>
> Till now all works relating to HS2 have been enabling works or design
> related.
>
>
>
> Cheers
>
> Andy
>
> ___
> Talk-GB mailing list
> Talk-GB@openstreetmap.org
> https://lists.openstreetmap.org/listinfo/talk-gb
>
>
> ___
> Talk-GB mailing 
> listTalk-GB@openstreetmap.orghttps://lists.openstreetmap.org/listinfo/talk-gb
>
> ___
> Talk-GB mailing list
> Talk-GB@openstreetmap.org
> https://lists.openstreetmap.org/listinfo/talk-gb
>
___
Talk-GB mailing list
Talk-GB@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-gb

Re: [Talk-GB] HS2 Phase 1 Construction NTP

[Tony OSM]

we've seen news reports of parts of the alignment fenced off and invaded 
by protestors - those parts are certainly under construction, and the 
pictures show that bulldozers have been active. I think if we can 
identify those areas then construction is now correct.


Tony Shield

TonyS999

On 17/04/2020 09:14, Andy Robinson wrote:


Jez, I think the actual rails may be a long way off but I agree it’s 
an opportunity to stay ahead of the completion.


A question for the whole list. How do folks feel about changing the 
Phase 1 route from rail=proposed to rail=construction. Perhaps it’s a 
bit premature but then perhaps not.


Cheers

Andy

*From:*Jez Nicholson [mailto:jez.nichol...@gmail.com]
*Sent:* 16 April 2020 22:15
*To:* Andy Robinson
*Cc:* Talk-GB
*Subject:* Re: [Talk-GB] HS2 Phase 1 Construction NTP

Thanks Andy, this is opportunity for OSM to be *the* best source of 
HS2 rails data.


On Wed, 15 Apr 2020, 17:48 Andy Robinson, > wrote:


Government issued Notice to Procced for Phase 1 today, which means
the main contracts construction between London and Birmingham will
start imminently so keep an eye out for major new works in your
area soon (though I expect these will be slow to spot while we are
in lockdown!)

Till now all works relating to HS2 have been enabling works or
design related.

Cheers

Andy

___
Talk-GB mailing list
Talk-GB@openstreetmap.org 
https://lists.openstreetmap.org/listinfo/talk-gb


___
Talk-GB mailing list
Talk-GB@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-gb
___
Talk-GB mailing list
Talk-GB@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-gb

Re: [Talk-GB] HS2 Phase 1 Construction NTP

[Andy Robinson]

Jez, I think the actual rails may be a long way off but I agree it’s an 
opportunity to stay ahead of the completion.

 

A question for the whole list. How do folks feel about changing the Phase 1 
route from rail=proposed to rail=construction. Perhaps it’s a bit premature but 
then perhaps not.

 

Cheers

Andy

 

From: Jez Nicholson [mailto:jez.nichol...@gmail.com] 
Sent: 16 April 2020 22:15
To: Andy Robinson
Cc: Talk-GB
Subject: Re: [Talk-GB] HS2 Phase 1 Construction NTP

 

Thanks Andy, this is opportunity for OSM to be *the* best source of HS2 rails 
data.

 

On Wed, 15 Apr 2020, 17:48 Andy Robinson,  wrote:

Government issued Notice to Procced for Phase 1 today, which means the main 
contracts construction between London and Birmingham will start imminently so 
keep an eye out for major new works in your area soon (though I expect these 
will be slow to spot while we are in lockdown!)

 

Till now all works relating to HS2 have been enabling works or design related.

 

Cheers

Andy

___
Talk-GB mailing list
Talk-GB@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-gb

___
Talk-GB mailing list
Talk-GB@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-gb