Re: [Talk-GB] Turbo Overpass Help
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 Olbrichtwrote: > 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
Roland you are a star! It works a treat. Many many thanks Brian On 6 February 2017 at 11:53, Roland Olbrichtwrote: > 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
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
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