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

How to get a list of London street names

0

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
1111
accept rate: 0%

edited 01 Jun '14, 08:40

iii's gravatar image

iii
4.9k84082


3 Answers:

1

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

http://overpass-turbo.eu/s/3AJ

http://overpass-turbo.eu/s/3AK

answered 01 Jun '14, 11:47

RicoElectrico's gravatar image

RicoElectrico
37161117
accept rate: 0%

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.

answered 01 Jun '14, 08:39

iii's gravatar image

iii
4.9k84082
accept rate: 10%

edited 01 Jun '14, 08:40

2

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

0

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

answered 05 Jun '14, 11:02

stephan75's gravatar image

stephan75
12.6k556210
accept rate: 6%

Source code available on GitHub .