stefanzweifel/php-swiss-cantons

Keep Zipcode Dataset automatically up to date

stefanzweifel opened this issue · 4 comments

The original zipcode data set has been downloaded from cadastre.ch in 2016.
Between 2016 and now, there have probably been some changes: Cities merged with other cities and received a new zipcode, Cities switched Cantons, etc.

I would like to add some bit of code (little bash script) to automatically download the latest dataset from a trusted source. Maybe we can use the open sourced data of the Swiss Post? (https://swisspost.opendatasoft.com/explore/dataset/politische-gemeinden_v2/table/)

If possible, it would also be great to automate this step. GitHub Actions makes it easy to schedule a monthly workflow to execute some scripts.

Related Issues

In #38 a new console command has been added to:

  • download the latest dataset from Swiss Post
  • parse the CSV
  • simplify the data and store it as zipcodes.json

We could now write a GitHub Action to periodically run the command and create a PR, if the data set changed. 🤔