How to get ways and associated nodes in CSV with Overpass QL?

Question

Hello,

I try to use Overpass QL to get all ways in a given area in CSV. I want to have all coordinates of all nodes of each street.

For example:

 node_id_1 lat lon way_id_1 
 node_id_2 lat lon way_id_1 
 node_id_3 lat lon way_id_1 
 node_id_4 lat lon way_id_2
 node_id_5 lat lon way_id_2

I tried several approaches but none worked. I can get all nodes and all ways but I found no way to have an explicit association between nodes and ways. I do not manage to add the way information to each node, and the node list does not appear for each way in the CSV output.

Any help would be appreciated. Thanks.

Accepted Answer

At this time, it's not possible to have details originating from several OSM objects in one single line. In your case, that's the node id + details, as well as the corresponding way id.

I suggest to take advantage of the foreach statement like in the following example.

It will first output the way id, followed by a list of its nodes with their respective node id and lat/lon details.

[out:csv(::type, ::id, ::lat, ::lon)]
[bbox:{{bbox}}];
way[highway];
foreach(           // for each way tagged as highway=* do...
  out;             // output way id
  node(w);         // determine respective nodes
  out;             // output all node details
);

Try it in overpass turbo: http://overpass-turbo.eu/s/bpj

In a post processing step, you'll have to transform this output to whatever format you need.

Caveat: CSV output does NOT preserve the sequence of nodes per OSM way. Depending on your requirements, the results may therefore be completely useless to you!

CSV output was primarily designed to return tags for relations/way/nodes,.... Returning geometry information for ways was not a main focus. Maybe you want to check JSON/XML output with out geom; instead, which is also rather easily parse-able.

How to get ways and associated nodes in CSV with Overpass QL?

Follow this question

Related questions