Turbo Overpass Help

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Turbo Overpass Help

Brian Prangle-2
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
[hidden email]
https://lists.openstreetmap.org/listinfo/talk-gb
Reply | Threaded
Open this post in threaded view
|

Re: Turbo Overpass Help

Roland Olbricht-4
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: [hidden email], 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
[hidden email]
https://lists.openstreetmap.org/listinfo/talk-gb
Reply | Threaded
Open this post in threaded view
|

Re: Turbo Overpass Help

Brian Prangle-2
Roland you are a star! It works a treat. Many many thanks  Brian

On 6 February 2017 at 11:53, Roland Olbricht <[hidden email]> 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,::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: <a href="tel:%2B49%20%280%29251%207%2003%2030-232" value="+4925170330232" target="_blank">+49 (0)251 7 03 30-232, F: <a href="tel:%2B49%20%280%29251%207%2003%2030-300" value="+4925170330300" target="_blank">+49 (0)251 7 03 30-300
E: [hidden email], 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
[hidden email]
https://lists.openstreetmap.org/listinfo/talk-gb
Reply | Threaded
Open this post in threaded view
|

Re: Turbo Overpass Help

Brian Prangle-2
In reply to this post by Roland Olbricht-4
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 <[hidden email]> 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,::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: <a href="tel:%2B49%20%280%29251%207%2003%2030-232" value="+4925170330232" target="_blank">+49 (0)251 7 03 30-232, F: <a href="tel:%2B49%20%280%29251%207%2003%2030-300" value="+4925170330300" target="_blank">+49 (0)251 7 03 30-300
E: [hidden email], 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
[hidden email]
https://lists.openstreetmap.org/listinfo/talk-gb