Query Ways with Nodes

Question

I managed to select ways or nodes, but not both at the same time. I am wondering if it was not intended by Overpass QL?

What I got so far:

[out:csv(::id,::type, ::lat, ::lon,"name", "addr:street")]; 
area[name="Prenzlauer Berg"][boundary=administrative]->.prenzlauer_berg;
(
  way(area.prenzlauer_berg)[~"highway"~"."][name] ;     
  node(w);
)->.result_set;
out geom;

I would like something like this as a result:

way_id, way_name, node_id, position, ...
way1, some_name, node1, 0, ...
way1, some_name, node2, 1, ...
way2, some_name_ node3, 0, ..

Answer 1

Without looking at it real closely I imagine the simplest thing is to ask Overpass-API for JSON and then transform that into the row format you want. I don't think there is a way to get it to emit a way line for each member node.

Answer 2

This earlier question may be relevant.