For example: I want to export the position, Street and names of all fire hydrants of my city in a spreadsheet or csv file? How can I do that? Is there an easy web frontend to configure and download the export? Or do I have to code? asked 18 Dec '18, 08:27 Vale |
As you've already found out (for not all too large areas) the overpass api or the overpass-turbo frontend is likely the best choice. If you need to refine your searches you should consult the wiki for information on the objects and how they are tagged (and yes there may be a couple of variants that you will need to consider). For your example http://overpass-turbo.eu/s/EC5
To get CSV output you will need to directly use the overpass-api and specify that you want CSV output. answered 18 Dec '18, 11:17 SimonPoole ♦ I've added the Overpass API query to your answer in case overpass-turbo becomes (temporarily) unavailable.
(18 Dec '18, 11:45)
scai ♦
1
You can get csv in overpass turbo, by replaceing [out:json] like this: [out:csv (::id, ::lat,::lon, "recycling_type","recycling:glass_bottles")]
(18 Dec '18, 12:52)
SK53 ♦
|
I am experimenting with http://overpass-turbo.eu/ For example I try to get all glass containers in a city.
qith the query I get all recycling related points: // query part for: “recycling” node"amenity"="recycling"; way"amenity"="recycling"; relation"amenity"="recycling";
How do I get only the glass containers?