• Replies 4 replies
  • Subscribers 961 subscribers
  • Views 348 views
  • Users 0 members are here
Related

Next Level Visualization - Heat Map for Zip Codes?

Rachel Brown
$organization

Hi all,

New to Tessitura and trying to figure out if it is possible to create a heat map with the zip codes around the city for where our constituents are located. Does anyone know if this is possible in the system as is? If not as is, does anyone have any round-a-bout ways they have done it in the past?

Thank you!

Parents
  • $organization

    Hi Rachel --

    If you want to dive a bit deeper and have some fun with some free tools, you can turn to QGIS (credit to Tom Brown for recommending QGIS way back when).

    Although it works a bit better with geocoded addresses (latitude, longitude), you can find an open source databases that provides a latitude and longitude for postal codes.  Append the latitude and longitude of each postal code to an export of your addresses (actually, you'd only need to export customer number and postal code).  Load that data into QGIS.  Add a shape layer for the United States or your state -- depends on what resolution you want.  Then create a heatmap.

    If you'll be at TLCC next week, find me and I'd be happy to demo this.  My colleague Nicole Keating and I will actually be presenting on geocoding addresses and what you can do with that info on Monday at 2 PM - "Integrating through the Tessitura API: A Deep Dish on Data Share".  I'd also be happy to connect offline to discuss in greater detail -- you can find me at dgomez@arshtcenter.org.

    Here's a quick sample of a heatmap of Miami-Dade County that I threw together quickly.

    DGomez

Reply
  • $organization

    Hi Rachel --

    If you want to dive a bit deeper and have some fun with some free tools, you can turn to QGIS (credit to Tom Brown for recommending QGIS way back when).

    Although it works a bit better with geocoded addresses (latitude, longitude), you can find an open source databases that provides a latitude and longitude for postal codes.  Append the latitude and longitude of each postal code to an export of your addresses (actually, you'd only need to export customer number and postal code).  Load that data into QGIS.  Add a shape layer for the United States or your state -- depends on what resolution you want.  Then create a heatmap.

    If you'll be at TLCC next week, find me and I'd be happy to demo this.  My colleague Nicole Keating and I will actually be presenting on geocoding addresses and what you can do with that info on Monday at 2 PM - "Integrating through the Tessitura API: A Deep Dish on Data Share".  I'd also be happy to connect offline to discuss in greater detail -- you can find me at dgomez@arshtcenter.org.

    Here's a quick sample of a heatmap of Miami-Dade County that I threw together quickly.

    DGomez

Children