No coordinates in German whosonfirst postalcodes

[rabidllama]

It seems that all coordinates in the data files for German postcodes are 0.0,0.0 (and also in the csv when downloaded from https://whosonfirst.mapzen.com/bundles/wof-postalcode-de-latest-bundle.tar.bz2.)
Is there something that needs to be run in order to add the geometry to the data?

[thisisaaronland]

Hi @rabidllama

Apologies for the slow reply. Many (most) of the postal codes lack geometries either because that data is not available or not available under a license suitable for Who's On First.

https://whosonfirst.mapzen.com/spelunker/nullisland/?placetype=postalcode

We've imported them anyway (the initial source was the Y! Geoplanet data dump which includes ~3M postalcodes) because we are able to infer a parent ID and at least a partial hierarchy for each code.

We have been updating the data with geometries when suitable data becomes available, for example:

• https://github.com/whosonfirst-data/whosonfirst-data-postalcode-au
• https://github.com/whosonfirst-data/whosonfirst-data-postalcode-fr

In some cases we will assign "approximate" geometries. For example, in Canada there are 800K (6-character) postal codes and ~ 1600 (3-character) "forward sorting areas" or FSAs. The geometries for the former are commercially licensed and the latter are open data. We've imported all the FSA as-is and then used their centroids as the approximate location for all the postal codes contained within a given FSA (and flagged them as mz:is_approximate=1).

https://github.com/whosonfirst-data/whosonfirst-data-postalcode-ca

Some countries have approximate postal codes derived from third-party data sources, like Open Addresses:

https://github.com/whosonfirst-data/whosonfirst-data-postalcode-nl

If there is a suitable data source for German postal codes, authoritative or approximate, we would love to hear about it and update the data accordingly.

[rabidllama]

Hi @thisisaaronland ,
the data I have been looking into as a workaround has been the geonames data as they seem to have a lot of postcodes, though only individual points and there is often more than one entry in their datasets for each postcode.

http://download.geonames.org/export/zip/

[marc-mabe]

german postal codes are available here incl. geometries (as KML) : https://www.suche-postleitzahl.org/downloads
(e.g. for berlin https://www.suche-postleitzahl.org/berlin.13f)

License: Open Database Licence
(as the raw data are from OpenStreetMap)

[orangejulius]

Hi! Shamelessly bumping this issue because I just noticed today that German postalcodes don't have coordinates. Let me know if having someone spending some time format shifting the KMLs linked above to something else would be helpful.

[arnesetzer]

Heyo, anything new here? If we want to skip the kml to geojson conversion Overpass will do it as well. (https://overpass-turbo.eu/s/1uEI). Is there any script to automate the wof:id assignment?

[blacktoby]

Hey!
I would fill the existing jsons with the coordinates.
If I'm ready, I will create a PR.
Is this fine @thisisaaronland ?