NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

Good evening,

I'm looking for a table or file for german cities and villages and their corresponding streetnames for postal-ZIP(PLZ)-area 5****. I'd be much obliged if anyone may help me. I would prefer a table, to help myself with copy&paste and edit the data with EXEL to thousands of MySQL-INCLUDE-orders. I need these data for a non commercial client-server-database-aplication, which builds my final projekt.

Thanks a lot, Tilman Bracht

asked 07 May '12, 20:16

Tilman%20Bracht's gravatar image

Tilman Bracht
1111
accept rate: 0%


This should be possible:

In Germany almost all postal code areas are collected in the OSM data.

So you have to find out all boundary relations that have postal_code=5**** ...

and then find all streets that belong to each postal code area.

Some basic hints might be found at Straßenverzeichnis in the wiki

Although I do not know the exact tools to do that, do not hesitate to ask also at the German section of the OSM forum or the German OSM mailinglist, there are more "experts"

permanent link

answered 07 May '12, 21:36

stephan75's gravatar image

stephan75
12.6k556210
accept rate: 6%

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:

×1

question asked: 07 May '12, 20:16

question was seen: 2,090 times

last updated: 07 May '12, 21:36

Related questions

NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum