Using Addresses to Create Maps in Tableau

Data

Using Addresses to Create Maps in Tableau

We all know that we can create some pretty cool maps in Tableau using fields like City, State and ZIP Code; however, Tableau cannot natively map street addresses. In order to plot specific addresses, we’ll need to use latitude and longitude coordinates. Through the use of some free online tools, we can convert addresses in our data into coordinates for use in our Tableau maps.

For this example, I’m going to map a list of marinas surrounding my hometown of Warsaw in Virginia’s beautiful Northern Neck.

After some collection of data via Google Maps, we have a pretty simple data set – one column for Marina and another for address. We want to expand on this data set so that we have separate columns for Address, City, State and ZIP. From there, we can hit the internet.

Addresses CSV

There are a number of free online geocoding applications, but for this case we’re going to use the Alteryx Public Geocoder – a free tool (requires sign up) that allows users to upload a small (1000 records or less) spreadsheet like the one I’ve created and turn addresses into latitude and longitude coordinates.  All you need to do is select your data set; map your Address, City, State and ZIP fields accordingly; and select Run. Once the app finishes running, we can save to a .csv and import into Tableau:

Alteryx Public Geocoding App

Addresses with GEO Latitude & GEO Longitude

When we bring the data into Tableau, it has automatically picked a Geographic Role for our GEO Latitude & GEO Longitude fields. This is great, but remember: If our fields don’t seem to work properly, we can always right-click on the fields and assign the proper Geographic Roles:

Tableau: GEO Latitude > Geographic role > Latitude” src=”/sites/default/files/blog-content/GeoAdd4.png” style=”border-width: 0px; border-style: solid;” /></p>
<p>Now, we’ll want to create our Map. Double-click on both the <strong>GEO Latitude</strong> and <strong>GEO Longitude</strong> fields to start building the map. To show each of our Marinas, I’ll drag a dimension with unique values to <strong>Detail</strong>. </p>
<p align=Tableau Addresses Map

And there we have it. We’ve taken addresses in a data set and turned them into coordinates, making it possible to create this map in Tableau.

With a little bit of tweaking Tableau’s Map Layers, and by bringing in a custom shape like the boat below, we can create some fun projects using a combination of Tableau and a free geocoding tool. 

Do you have any street addresses in your data? Perhaps you already have latitude and longitude coordinates? You can skip the geocoder altogether and use your data to perform a similar exercise for business practices.

More About the Author

Chris Sanders

Analytics Consultant
InterWorks Mentors the Next Generation of Analysts at Alteryx for Good Last week, Alteryx folks from all over the world donated their time in a concerted effort on behalf of Alteryx for Good. I had the ...
Gauges vs. Bullet Graphs in Tableau Quite frequently, students in training will ask “How do I make a gauge in Tableau?” While it’s possible, it’s not one of ...

See more from this author →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK