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

Postal code mapping to municipalities #8

Open
DJSmallSquare opened this issue Jun 27, 2019 · 0 comments
Open

Postal code mapping to municipalities #8

DJSmallSquare opened this issue Jun 27, 2019 · 0 comments

Comments

@DJSmallSquare
Copy link
Contributor

DJSmallSquare commented Jun 27, 2019

I think there's room to improve the way one maps the postal codes to municipalities. There are two fixed values: (i) the official list of municipalities and (ii) the official list of postal codes. We should be able to figure out a way to map one postal code to exactly one municipality. However, a municipality may have multiple postal codes.
I found an Excel file detailing the correspondence between postal codes and municipalities. It is dated as of 2016.01.01. Therefore, we know we should end up with exactly 2294 municipalities after completing the mapping procedure. According to the same file, there are 3186 postal codes. Therefore, we should end up with a object containing 3186 rows, where each postal code is match with exactly one municipality.
The challenge here is that postal codes may overlap one or more municipalities. A trade-off will be necessary.

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

1 participant