Why not ask your question on the new OpenStreetMap Community Forum?

Hello, how can I get a list of London streets and postcodes in excel/word please. Any help great fully received. Thanks in advance. K

asked 31 May '14, 23:24

Kevy%20kev's gravatar image

Kevy kev
accept rate: 0%

edited 01 Jun '14, 08:40

iii's gravatar image


You could use Overpass API that offers basic spatial queries. Like this:



permanent link

answered 01 Jun '14, 11:47

RicoElectrico's gravatar image

accept rate: 0%

Currently we don't provide an easy to use way to get plain lists. Thus you need to process it on your own:

  1. Open a OSM Planet extract of London
  2. Parse .XML file with a SAX parser
  3. Trigger on highway=, name= items
  4. Add this name to a dictonary
  5. Save this dictonary list to a file

That can be done easily in a Python file but as I say, AFAIK we don't provide a ready-to-use service.

permanent link

answered 01 Jun '14, 08:39

iii's gravatar image

accept rate: 10%

edited 01 Jun '14, 08:40


The above can also be achieved with existing software like osmconvert/osmfilter, yielding a CSV file with London streets. However the post codes are another matter entirely; they will not be recorded as attributes to the street so deducing them will require spatial computations if it is possible at all. -- Also note one street can consist of a number of individual parts in OSM and therefore will show up multiple times in your result list.

(01 Jun '14, 09:20) Frederik Ramm ♦

Thank you Fredrik Excuse my lack of knowledge but I would not know the first thing about how to do this. Can a simpleton do this? Regards K

(01 Jun '14, 14:35) Kevy kev

... also do a search on this FAQ site about "street list" ... there have been already similar topics with helpful solutions.

I recommend to use overpass-api or overpass-turbo and to limit the query area to an administartive area of your choice.

Thus you can get the desired result definitively!

permanent link

answered 05 Jun '14, 11:02

stephan75's gravatar image

accept rate: 6%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



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:


question asked: 31 May '14, 23:24

question was seen: 5,507 times

last updated: 05 Jun '14, 11:02

powered by OSQA