Re: [Talk-GB] Turbo Overpass Help

2017-02-06 Thread Brian Prangle
For anyone else wanting to run this query to help them clean up naptan
data, just one small addition: add the qualifier unclassified to the list
of roads

Regards

Brian

On 6 February 2017 at 11:53, Roland Olbricht  wrote:

> Hi
>
> As part of the cleanup and refresh of NaPTAN data in the West Midlands
>> we need to identify any bus stope nodes that were added in the old
>> manner i.e as a node on the highway rather than as a separate node to
>> the side.
>>
>> Is this possible in turbo overpass?  It's  defeated me so far! Any help
>> appreciated
>>
>
> Please have a look at
> http://overpass-turbo.eu/s/lJk
>
> This chooses all nodes with highway=bus_stop that are also part of a way
> with a highway tag whose value contains motorway, trunk, primary, and so on.
>
> Useful variants might be
> - use of "West Midlands" instead of Birmingham as area name
> - use "out meta" instead of "out" to get the metadata as well
> - prepend the query with a line "[out:csv(::lat,::lon,::timest
> amp,::user,name)];"
> to see a condensed table that tells you whether any of these stops have
> seen recent updates.
>
> Regards
>
> Roland
>
> --
> Dr. Roland Olbricht
> MENTZ GmbH, Am Mittelhafen 10, 48155 Münster
> T: +49 (0)251 7 03 30-232, F: +49 (0)251 7 03 30-300
> E: olbri...@mentz.net, www.mentz.net
>
> Sitz der Gesellschaft:
> Grillparzerstraße 18, 81675 München
> Geschäftsführer Dr.-Ing. Hans-J. Mentz
> Amtsgericht München, HRB 91898
>
___
Talk-GB mailing list
Talk-GB@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-gb


Re: [Talk-GB] Turbo Overpass Help

2017-02-06 Thread Brian Prangle
Roland you are a star! It works a treat. Many many thanks  Brian

On 6 February 2017 at 11:53, Roland Olbricht  wrote:

> Hi
>
> As part of the cleanup and refresh of NaPTAN data in the West Midlands
>> we need to identify any bus stope nodes that were added in the old
>> manner i.e as a node on the highway rather than as a separate node to
>> the side.
>>
>> Is this possible in turbo overpass?  It's  defeated me so far! Any help
>> appreciated
>>
>
> Please have a look at
> http://overpass-turbo.eu/s/lJk
>
> This chooses all nodes with highway=bus_stop that are also part of a way
> with a highway tag whose value contains motorway, trunk, primary, and so on.
>
> Useful variants might be
> - use of "West Midlands" instead of Birmingham as area name
> - use "out meta" instead of "out" to get the metadata as well
> - prepend the query with a line "[out:csv(::lat,::lon,::timest
> amp,::user,name)];"
> to see a condensed table that tells you whether any of these stops have
> seen recent updates.
>
> Regards
>
> Roland
>
> --
> Dr. Roland Olbricht
> MENTZ GmbH, Am Mittelhafen 10, 48155 Münster
> T: +49 (0)251 7 03 30-232, F: +49 (0)251 7 03 30-300
> E: olbri...@mentz.net, www.mentz.net
>
> Sitz der Gesellschaft:
> Grillparzerstraße 18, 81675 München
> Geschäftsführer Dr.-Ing. Hans-J. Mentz
> Amtsgericht München, HRB 91898
>
___
Talk-GB mailing list
Talk-GB@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-gb


Re: [Talk-GB] Turbo Overpass Help

2017-02-06 Thread Roland Olbricht

Hi


As part of the cleanup and refresh of NaPTAN data in the West Midlands
we need to identify any bus stope nodes that were added in the old
manner i.e as a node on the highway rather than as a separate node to
the side.

Is this possible in turbo overpass?  It's  defeated me so far! Any help
appreciated


Please have a look at
http://overpass-turbo.eu/s/lJk

This chooses all nodes with highway=bus_stop that are also part of a way 
with a highway tag whose value contains motorway, trunk, primary, and so on.


Useful variants might be
- use of "West Midlands" instead of Birmingham as area name
- use "out meta" instead of "out" to get the metadata as well
- prepend the query with a line 
"[out:csv(::lat,::lon,::timestamp,::user,name)];"
to see a condensed table that tells you whether any of these stops have 
seen recent updates.


Regards

Roland

--
Dr. Roland Olbricht
MENTZ GmbH, Am Mittelhafen 10, 48155 Münster
T: +49 (0)251 7 03 30-232, F: +49 (0)251 7 03 30-300
E: olbri...@mentz.net, www.mentz.net

Sitz der Gesellschaft:
Grillparzerstraße 18, 81675 München
Geschäftsführer Dr.-Ing. Hans-J. Mentz
Amtsgericht München, HRB 91898

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


[Talk-GB] Turbo Overpass Help

2017-02-06 Thread Brian Prangle
Hi everyone

As part of the cleanup and refresh of NaPTAN data in the West Midlands  we
need to identify any bus stope nodes that were added in the old manner i.e
as a node on the highway rather than as a separate node to the side.

Is this possible in turbo overpass?  It's  defeated me so far! Any help
appreciated

Regards

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