Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Integration of Germany's postal code areas into WhosOnFirst data #197

Open
dawidl11 opened this issue Sep 30, 2022 · 5 comments
Open

Integration of Germany's postal code areas into WhosOnFirst data #197

dawidl11 opened this issue Sep 30, 2022 · 5 comments
Assignees

Comments

@dawidl11
Copy link

Hi all,
I am using WhosOnFirst data for my geocoding Pelias instance:

  • whosonfirst-data-postalcode
  • whosonfirst-data-admin-latest
    I noticed that for some countries there are postal code areas in the data and for others not.
    For example, for Netherlands there are this areas and for Germany not.

My question:
Is there any way to know if you are planning to add the German postal code areas to the WhosOnFirst data as well? If yes, then when should it be done?

Many thanks in advance for the answers!
Dawid

@nvkelso
Copy link
Member

nvkelso commented Sep 30, 2022

@dawidl11 Thanks for your question!

Postal code data is not generally as available as open data as the rest of the "administrative" data in Who's On First. We have imported it for a few countries also including the United Kingdom.

If you know of an open data source for Germany postal codes than we can work with you to import it.

Do you know of a good source?

@dawidl11
Copy link
Author

dawidl11 commented Oct 4, 2022

Thanks for your quick reply.
I do know this data source: https://opendata-esri-de.opendata.arcgis.com/datasets/5b203df4357844c8a6715d7d411a8341_0/explore? .
Would it be possible to import this data into WhosOnFirst?

@nvkelso
Copy link
Member

nvkelso commented Oct 6, 2022

The license on that page in German:

Die Daten stehen unter der Open Database Licence frei zur Verfügung. Quelle der Rohdaten: © OpenStreetMap contributors
Einwohnerzahlen als Berechnungsgrundlage © Statistische Ämter des Bundes und der Länder

Translated using Google translate:

The data is freely available under the Open Database License. Raw data source: © OpenStreetMap contributors
Population figures as a basis for calculation © Federal and state statistical offices

Elsewhere on the site it says: The 5-digit postal code areas come from OpenStreetMap and are enriched with the EWZ attributes (census 2011) and AGS, district, municipality or city affiliation in order to optimize the usage and analysis options.

Generally OpenStreetMap is not an allowlisted source for Who's On First. But this license doesn't totally make sense to me, @stepps00 can you dig into it a bit more, please? If we follow the thread far enough upstream OSM may list out the open data source they used to import the data. (And it's unusual to see postalcode data in OSM at all in my experience.)

@stepps00
Copy link
Member

stepps00 commented Oct 6, 2022

So it looks like the postalcode data on the ESRI site does come directly from OSM.

Looking at OSM change history on some of the postalcode features, it looks like those features were imported from this now defunct site: https://arnulf.us/PLZ

I also found this page which gives more context to the German postalcode data in OSM: https://wiki.openstreetmap.org/wiki/Import/Catalogue/Postleitzahlen_Deutschland_2010

I've reviewed a few other sites with postalcode data online, but those all point back to the same data (example one, example two).

Who's On First would require a different data source for German postalcodes.. @dawidl11 do you happen to have another source for this data?

@dawidl11
Copy link
Author

Thank you for your research on this. Unfortunately, I have no other source for the postal code areas for now. But I will still do a little research. If I do find something, I will let you know.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants