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

I can write an overpass turbo wizard query to find all the street addresses in my town. I would like to export the list as a csv file. Can anyone help?

asked 02 Aug '18, 10:07

Alan01730's gravatar image

Alan01730
464343552
accept rate: 0%


Overpass-API has a csv output mode.

An setting like [out:csv(::lat, ::lon, "addr:housenumber","addr:unit","addr:street","addr:postcode","addr:city")]; will request csv output with the fields there (empty values if a given OSM object does't have the tag).

You'd probably want to look through the data you are retrieving and include more tags than that.

permanent link

answered 02 Aug '18, 11:02

maxerickson's gravatar image

maxerickson
12.7k1083176
accept rate: 32%

2

Just as a clarification: OSM currently uses postal addresses in the addr:* tags, these may be in particular different from the concept of a "street address" particularly in that addr:city should refer to the postal city and not the actual administrative unit/place the address is located in.

(02 Aug '18, 11:07) SimonPoole ♦

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "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:

×228

question asked: 02 Aug '18, 10:07

question was seen: 2,600 times

last updated: 02 Aug '18, 11:07

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