This is a static archive of our old OpenStreetMap Help Site. Please post any new questions and answers at community.osm.org.

how can I download/ extract road names in to a word document

0

I want to download all the road names (and the post code if possible) from one particular town in the UK and put it into a word or excel document- is this possible? if so, how?

asked 16 Mar '12, 00:44

summerbreeze123's gravatar image

summerbreeze123
1111
accept rate: 0%


One Answer:

0

I think your question was left unanswered because one might suspect it will be a steep learning curve for you to accomplish your wish, as you imply that getting it in to a Word-document is part of the problem ;)

But a straightforward way of doing this could be:

  1. Download planet.osm (20 GB), or better, a UK extract (~500 MB)
    (Don't do this if you don't feel confident executing the other steps)
  2. Install PostgreSQL
  3. Install Osm2pgsql and import your osm-file to PostgreSQL
  4. Apply relevant SQL-query

Or, if you're willing to compensate, you could contact any of the Openstreetmap consultants, like Geofabrik or gravitystorm

(There might be some clever way of doing this easy, like this, or for your particular question: http://nominatim.openstreetmap.org/search?q=Residentials%20in%20London, but it doesn't work and would be some pain to extract the result.)

answered 16 Mar '12, 20:14

TheOddOne2's gravatar image

TheOddOne2
6851621
accept rate: 3%

Source code available on GitHub .