Create a map based on postal codes with these 5 tips
date_range 24/05/2019 | label CREATE POSTAL CODE MAPS, DATA BY POSTAL CODE, 5 TIPS
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 Spotzi Premium and Enterprise.
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.
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.
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.
Turn data into maps with our Territory package
Our Territory package 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.