5 tips to create a map based on postal codes

Create a map based on postal codes with these 5 tips


At Spotzi we believe that a map tells you more than any Excel sheet or data table. We can see that an increasing number of companies also embracing this solution because it gives a great overview of all your data. At Spotzi we call this feature the Join App.

No wonder that lots of companies are looking for a way to segment their data by postal code and visualize this data on a map. Our location data specialists are turning data into maps every day. That’s why we asked them some PRO tips you can use when you want to create maps/dashboards with our Spotzi Plans.

Tips

1. Mind the data type

A postal code column in a data set can be stored in a text or number column. Keep this in mind when you are joining the postal codes from your Excel file to a postal code boundary file. You are only able to join data sets with the same column type.

5 tips to create a map based on postal codes

2. Make your Excel geocode-ready

To make sure the Spotzi Geocoder can process your CSV/Excel well, please create a file where you give as much information as possible. The more information you give the better the Spotzi Geocoder will determine the right location.

5 tips to create a map based on postal codes

3. Check for postal codes starting with zero

Got postal code areas that are starting with a 0? That might cause a problem, because a number column might cut off the first zero. In this case, we recommend to use a text (string) type.

5 tips to create a map based on postal codes

4. Save time with our postal code based data

Spotzi offers lots of data that is also segmented by postal code. We offer data with more information about demographicsdisposable income and consumer behavior. Data you can use to enrich your map based on the same postal code.

5 tips to create a map based on postal codes

5. Analyze postal codes within a certain range

Do you only want to visualize the postal code areas that lay within a certain radius of a business location? Use the buffer functionality of our GIS app in combination with our Filter app.

5 tips to create a map based on postal codes

Turn data into maps with our Location Plan

Our Location Plan offers you all the tools you need to map out your data and segment your data by postal code. You can geocode addresses from your Excel file or you can join your data per postal code to the boundary data that is included in this package.