Forum Discussion
Zip Code Heat Map
I just posted an answer here which should help.
If you get the data in the format:
Company Zip
A 1
B 1
A 2
A 3
I think you can use the heat map to plot zip codes and Count of Company
I Googled and found a site that had the latitude/longitude coordinates of the zips I needed. I was able to download via csv file, then uploaded these into a SQL database that I then imported into PB.
The only other data involved is a second sql table -- no aggregations -- every record counts as "1" and is summed together in the shape file.
For mapping I put the Zip Code field from the Boroughs table into the Location and the # Students from the Enrollment table into Color Saturation. And like magic I had a nice map!!
There is no 'Data category' for zipcode, so what do you set it as? Postal code?