Make an adress list

Help and support
1

Hi,
New here! I want to compile a list of Addresses on a couple blocks near my house. Is there an easy method to use to maybe use a polygon to outline an area and then export all the addresses inside that are? Thanks

2

Yes, what you’re looking for is definitely possible - but it’s usually done with external tools rather than directly on the main OSM website.

A common approach is to use Overpass Turbo, which lets you query OSM data and export it.

You can try:

  1. Go to https://overpass-turbo.eu/
  2. Use the map to zoom to your area
  3. Click the “Wizard” and try something like: addr:housenumber=*
  4. Run the query and then export the results (e.g. as CSV or GeoJSON)

Keep in mind that OSM data completeness varies - if some addresses are missing, you can always help improve the map by adding them :slightly_smiling_face:

3

Thank you that is exactly what am looking for and very helpful!! Thank you Thank you!!

4

So I tried that and it shows up a lot of technical words, is there any way to just export the street name and the house adress and that’s it? Thank you!

5

It would probably be more helpful if you explain in detail what you want to achieve in the end.
Basically, you can do this: export the address data as GeoJSON, convert it to CSV, and in Excel, keep only the columns for street name and house number and delete the rest.

image
image2511Ă—1371 1.16 MB

I’m not exactly sure what the specific area you want looks like, but the addresses around “Penn Wynne” don’t seem to be fully recorded yet, as someone already noted in the other thread.

6

Got it you explained it perfectly in that post. I’ve gained a lot of clarity from that. Thank you! And thank you once again for putting the houses into the map I am still very appreciative of that!!

1 Like
7

You could use this code in Overpass turbo:

 [out:csv("addr:street","addr:housenumber")][timeout:25];
// gather results
nwr["addr:housenumber"]["addr:street"]({{bbox}});
// print results
out geom;

It only generates a list of the visible objects with “addr:housenumber” & “addr:street” and outputs an csv with only these values.

1 Like
8

Thank you!!