This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
This is an awesome idea, I am looking forward to hearing more!
I haven't had much experience with OSM, aside from a couple of data downloads. In my free time, I've been experimenting with the address data available at https://openaddresses.io/ In the US, there are around 150 million parcel centroids, and an extensive amount of international address data is also available.
I haven't been able to put in as much time as I'd like, however I made some progress.
I converted the OSM file to an yxdb without many changes, basically I just filtered out rows without tags.
After that, what I'm attempting to do is to isolate tag combos that can give us city name and street + civic number:
It's definitely not the most refined workflow but I still haven't found an equivalent function to Excel's Horizontal Lookup, so any suggestion on how to do this a smarter way would definitely be welcome.
I also did some quick calculations and I'm pretty sure that either the osm dataset is incomplete or I'm missing something, because the maximum possible addresses are short of 2 million VS the roughly 30 million they should be.
It could perhaps be related to the XML format but this will be for later investigation...
Ok, I found a somewhat less precise but definitely easier to handle solution.
Geofabrik (and a few other planet osm mirrors) has a list of openstreetmap files that gives road shapefiles along with other points of interest: https://download.geofabrik.de/
Unfortunately in my case it did not have the city name along with road but that's easily fixed using as most governments have shapefiles with city boundaries so you can easily associate city and street, making possible to have a handy coordinates database.