Tableau Tip: Exploring the Built-In Geocoding System

Data

Tableau Tip: Exploring the Built-In Geocoding System

//

Fresh off a West Coast swing that took me from the Central Valley to Silicon Valley and into San Francisco, I’m back in Oklahoma for Independence Day.

This quick blog post explores a question that always comes up during Tableau Training sessions – “What locations can Tableau geocode using the built-in system?” We’re going to investigate the files where your Tableau Desktop goes to get every Latitude and Longitude it needs, and make some quick visualizations to show every location. Join me for the exploration of this topic, and download the attached workbook to visualize every Country, State/Province, City, Zip/Postal Code, County, and CBSA/MSA yourself! 

Happy Mapping and hope you’re all enjoying the Independence Day fireworks!

NOTE: In the video, I made a small omission and only showed filtering to IsDisplayName=1 and Locale=Eng/US. In many of the visualizations in the attached workbook you’ll see that I also added filters to CountrySynonymsLocale=Eng/Us and CountrySynonymsIsDisplayName=1. Adding those filters will reduce that City count from 220K down to 43K, a more accurate number that avoids duplicates.

More About the Author

James Wright

Global BI Practice Director
Unexpected Surprises: IMDB Movie Analytics I haven’t blogged much recently, but I wanted to quickly share a really great moment. Onsite with one of our long-term and larger NYC ...
10 Ways to Drive End-User Adoption of Tableau – Part 2 Ready to pick up where we left off? Last week, I posted “10 Ways to Drive End-User Adoption of Tableau – Part 1.” ...

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

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072