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%


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.)

permanent link

answered 16 Mar '12, 20:14

TheOddOne2's gravatar image

TheOddOne2
6851621
accept rate: 3%

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:

×240
×184
×71
×42
×2

question asked: 16 Mar '12, 00:44

question was seen: 3,791 times

last updated: 16 Mar '12, 20:14

powered by OSQA