query nodes by attributes of connected ways

Question

I'm am trying to extract a set of nodes that represent signalized intersections with bike infrastructure leading into them.

the trouble I have run into is that I don't think there is a way to query nodes according to the attributes of the ways that connect to them.

Is that correct? If it is I can download the data and run the query as a join on the to and from OSM_ID's of the way in postgres. this will be fairly time consuming though so i wanted to first check and see whether anyone had a way to do this in overpass or overpass turbo.

thanks for any and all suggestions.

edit: I can query nodes and ways separately in overpass turbo using:

node [highway=traffic_signals] ({{bbox}}); out; way [bicycle=designated] ({{bbox}}); out;

but my goal is to return the subset of that query that is nodes connected to a line where bicycle=designated.

Accepted Answer

1	You need to recurse down from the ways to find the appropriate child nodes. `[bbox:{{bbox}}]; way[bicycle=designated]; node(w)[highway=traffic_signals]; out center;` permanent link answered 03 Jun '21, 15:37 DaveF 3.3k●84●98●133 accept rate: 16%

query nodes by attributes of connected ways

Follow this question

Related questions