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

a table or file for german cities and villages and their corresponding streetnames for postal-ZIP(PLZ)-area 5****

0

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%


One Answer:

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"

answered 07 May '12, 21:36

stephan75's gravatar image

stephan75
12.6k556210
accept rate: 6%