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

Hello Guys,

i am looking for way to get a List of House Numbers which are mapped in OpenStreetMap. I was using a method which is creating a request for every possible HouseNumber when i was looking for a certain street. This doesnt work because i am creating too many requests. So i hope there is a way to get a List of existing house numbers for a certain street.

Thank you very much.

asked 23 Sep '17, 17:21

mtz93's gravatar image

mtz93
36113
accept rate: 0%


Did you know https://overpass-turbo.eu/ ? You can search after addr:housenumber (based on the map area or town area and filtered by other key values). You can also change the the grafical output to an other type like csv list.

permanent link

answered 24 Sep '17, 07:24

user_5359's gravatar image

user_5359
91117
accept rate: 0%

1

Late answer for me but yes, i managed to make it work using Overpass. Thank you very much! :)

(03 Nov '17, 08:17) mtz93

@mtz93 It would be useful if you post your own answer here or edit the original question and put your query here. So it would be useful for everybody.

(03 Nov '17, 09:35) Sergey Karavay

I was stuck with the same task; get all housenumbers of a given street.

Found this hacky way:

[out:csv("addr:housenumber")][timeout:25]; {{geocodeArea:Gänserndorf}}->.searchArea; ( node["building"]["addr:street"="Hauptstraße"]["addr:housenumber"](area.searchArea); way["building"]["addr:street"="Hauptstraße"]["addr:housenumber"](area.searchArea); relation["building"]["addr:street"="Hauptstraße"]["addr:housenumber"](area.searchArea); ); out body; >; out skel qt;

I have to say, the learning curve can be a wall and I'm not totally happy with the result. Maybe someone else has a nicer version.

Afterwards I used "sort -g" under Linux to sort the list.

permanent link

answered 29 Sep '20, 14:58

neo0x3d's gravatar image

neo0x3d
11
accept rate: 0%

edited 29 Sep '20, 18:06

It gets more complicated where associatedStreet relations have been used rather than addr:street on every building...

(29 Sep '20, 17:30) EdLoach ♦

Short hint: instead using node, way, relation with the same condition you can use the short cut nwr [ out:csv("addr:street", "addr:housenumber")][timeout:25]; {{geocodeArea:Gänserndorf}}->.searchArea; ( nwr["building"]["addr:housenumber"]"addr:street"="Hauptstraße"; ); out; ] Edit add code formatting

permanent link

answered 30 Sep '20, 20:02

user_5359's gravatar image

user_5359
91117
accept rate: 0%

edited 30 Sep '20, 20:05

Your answer
toggle preview

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:

×362
×142
×63
×16
×7

question asked: 23 Sep '17, 17:21

question was seen: 39,177 times

last updated: 30 Sep '20, 20:05

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