The Textizen Blog

OCT 30 2014

Visualize your Data in Minutes with Textizen and Esri Maps

We are excited to announce that Textizen is now an official Esri Business Partner! You may know Esri as the industry-leading provider of Geographic Information System software, which makes it easy to collect and analyze geographic data.

What does this partnership mean for you? As we build out our geographic capabilities, Esri’s best-in-class platforms are powering Textizen behind the scenes. This means you will soon be able to collect geographic data from your participants and visualize those responses on a map as they arrive.

In the meantime, however, geocoding Textizen data using Esri is an easy way to gain insight into your results. In just a few minutes you can create an intuitive visual representation of your data to share with your team, your clients, or the public!

legend

The power of Esri: survey responses grouped by ZIP code, color coded by score, and scaled based on response volume.

Here’s a map we made using data from Buffalo Niagara’s One Region Forward initiative. In one of their polls, Buffalo asked residents how easy it is to access healthy, affordable food. (Poll results here.)

Read on to see an interactive version and learn how to make your own geocoded maps!

This interactive map (created using ArcGIS.com) uses the same data from Buffalo’s food access poll. Each point on the map can be clicked to view further information on the data from that area.

Making a map like this is surprisingly easy – here is a brief tutorial to get you started.


Building Your Interactive Map

Getting a simple interactive map up and running on ArcGIS.com can be done in just 4 easy steps. We’ll assume you have an account already, but if you don’t, you can sign up for a trial here. For those who are not Esri customers, don’t worry – we’ll soon be including similar maps on the Textizen dashboard itself.

Step 1: Export Your Data to CSV

This one is easy: navigate to a poll that collects geographic data, and from its dashboard page click “Download CSV.”

csv export In case you’re following along, here’s the data we’re using for this example.

Step 2: Process Your Data in a Spreadsheet

Next, fire up your favorite spreadsheet editor and clean your geographic data, making sure that everything in your geodata field (in this case ZIP code) is valid. Then create a Pivot Table using these settings:

  • Row Labels, and Values: Your geographic field (in our case ZIP Code)
  • Column Labels: The question whose responses you want to map.

In this example, we added in a column at the end to average all the scores per ZIP.

pivot table

Tips:

  • ArcGIS.com hates apostrophes (‘), so remove them all using Find and Replace to ensure a smooth import process.
  • To make your data as clean as possible before importing it into ArcGIS.com, save your pivot table as a CSV, then reopen it and remove extraneous cells (like the titles at the top and any bad values).
  • If you want to use multiple variables in your map, you can make a second pivot table (follow Step 2 again) and copy that variable’s column into the first CSV.

Step 3: Save and drag into ArcGIS.com

Make sure your new pivot table is saved in a CSV file, log in to ArcGIS.com, then open up the map window. Drag your CSV file onto the map… drag CSV

…and you’re ready to geocode!

Step 4: Geocode

geocode

Tell ArcGIS.com what field to use to map the data (e.g. ZIP code), tweak the symbols and settings to your liking, and voila, you have an interactive map!

The Final Result:

final map

Moving forward, you can expect to find maps in the Texizen dashboard itself, as well as more tips from us on how to make powerful maps on your own using your Textizen data.

Curious about the future of Textizen geocoding? Get in touch: hello@textizen.com.