search

whosonfirst-data / whosonfirst-data-postalcode-de

Who's On First postal code data for DE
https://whosonfirst.mapzen.com
Other
0 stars 1 forks source link

No coordinates in German whosonfirst postalcodes #3

Open rabidllama opened 6 years ago

rabidllama commented 6 years ago

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 commented 6 years ago

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:

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 commented 6 years ago

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 commented 6 years ago

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 commented 4 years ago

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 commented 1 year ago

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 commented 2 months ago

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