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 |
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" |