|
(converted from https://help.openstreetmap.org/questions/9816/the-best-way-to-extract-street-list/40874 ) There still doesn't seem to be any simple way to get a proper Country->Province/State->Place->Street hierarchy out. I need that for the entire US and UK to start. A highway is an open Way polyline, and the others are closed Way polylines. The only relationship between them known to OSM is geographical, as far as I can tell. Converting this data to an address hierarchy requires a lot of polygon intersection tests to tell what's inside what. Has anyone built a tool for that? I don't see capabilities for that in osmfilter or osmosis. Loading all that spatial data into an SQL database with spatial indices is possible, but most of those don't do spatial joins very well. |
|
Have a look at the web service from OSM user Wambacher: There you have a tree structure of all valid boundary relations on the planet. Can this be an entry point for you? 1
That will fetch the hierarchy for named places, but doesn't do anything with highway/Way info other than display it. I just want Country->Province/State->Place->Street without the geometry, for the entire US. Calculating that from highway and region geometry is a big job. Someone must have done this already.
(10 Feb '15, 18:17)
John_Nagle
When I do this (I do OSM data extraction as a commercial service) I always run a number of more or less manual steps on an osm2pgsql import. Of course you can greatly speed up the osm2pgsql import by only importing the bits you're interested in. The difficult bit is that depending on the country you're running this in, a sizable proportion of streets will not have a full hierarchy (e.g. in the US, will be inside a state but not inside any county or street) - do you then omit them, or assign them to a virtual place called "other", or...?
(10 Feb '15, 19:12)
Frederik Ramm ♦
|