Mapping of Postal and District Codes
Map of Austria at the district level, viewed from the Metabase Admin console

The CSV file consists of a mapping from Austrian 4-digit postal codes to Austrian 3-digit district codes.

I created this dataset while working on a reporting task using Metabase. The requirements were to create a Metabase map, depicting user statistics in Austria, aggregated at the Austrian district level. The dataset at my disposal had the users’ postal codes but no district codes.

In Austria, the Gemeindekennziffer is a 5-digit string, used to identify municipalities. The first three digits of the Gemeindekennziffer is used to identify a municipality’s district. Meanwhile, postal codes in Austria are 4-digit strings which are not related to the Gemeindekennziffer.

I found the GeoJSON file of Austria at the district level in this repository and Gemeindekennziffer information in excel-karte.de. With these two sources, I was able to create the mapping, and finally, the required report.

Mapping of Postal and District Codes
Older post

Working from Corralejo, Fuerteventura

Some learnings from my travels in the nomad island

Newer post

Gathering Questions about GCP

A sample of questions about GCP used as a study-guide for Google's Associate Cloud Engineer Certification

Mapping of Postal and District Codes