• Replies 4 replies
  • Subscribers 961 subscribers
  • Views 346 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!

  • $organization

    Welcome to the Tessitura Community.

    What version of Tessitura are you on.  If you are on Tessitura V15 you can use Tessitura Analytics you can do a scatter map by Postal Code.  But the Area Map does not seem to support that capability.

    If you also have T-Stats Available this tool will allow you to do this kind of thing for any values you can show in T-Stats,

  • $organization in reply to Tom Brown (Past Member)

    Thank you for your help Tom. I am on V15. I'll work with my team and test this and report back with any questions.

  • $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

  • $organization in reply to Daniel Gomez

    Looking forward to seeing you at TLCC! Been checking out your slides for your presentation.  Looking forward to hearing more about what you have been able to achieve with GeoCoding and other items.

    --Tom