NOTICE: is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

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's gravatar image

accept rate: 0%

I am experimenting with 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?

(18 Dec '18, 08:52) 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

This has been generated by the overpass-turbo wizard.
The original search was:
“amenity=recycling and recycling_type=container and "recycling:glass_bottles"=yes”
// gather results
  // query part for: “amenity=recycling and recycling_type=container and "recycling:glass_bottles"=yes”
// print results
out body;
out skel qt;

To get CSV output you will need to directly use the overpass-api and specify that you want CSV output.

permanent link

answered 18 Dec '18, 11:17

SimonPoole's gravatar image

SimonPoole ♦
accept rate: 18%

edited 18 Dec '18, 12:20

I've added the Overpass API query to your answer in case overpass-turbo becomes (temporarily) unavailable.

(18 Dec '18, 11:45) scai ♦

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 ♦

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 18 Dec '18, 08:27

question was seen: 8,650 times

last updated: 18 Dec '18, 12:52

NOTICE: is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum