You'd probably need to perform some "reverse geocoding" outside of Tableau. See https://stackoverflow.com/questions/4013606/google-maps-how-to-get-country-state-province-region-city-given-a-lat-long-v…
There are many resources online where you can blend to your data to the the state from latitude and longitude. Here are a couple:
2 of 2 people found this helpful
If you need US state names, you can just download the State boundary shapefile from the US Census and then use the spatial intersection in Tableau to identify the state that each point falls into. If you want States outside the US, you would need to find a corresponding spatial file to use the method that I just mentioned.
But, the reverse geocoding tools mentioned above are another good way...just depends on how many points you need to geocode, how easy the APIs are to use, and whether or not they are a pay-for-service model.
Thanks for the reference. Can i embed this geocoding logic into tableau ? or Is this something i need to download raw data and do the transformation.
You'd have to do this outside of Tableau, likely in code, then write that data to a file, which could then be used in Tableau.
I have data for about 10 years and each data point has unique lat and long . How can i integrate this into tableau ? I believe this works only if we have the exact lat and long in my data set ?
Thank you !
You can set your latitude field to geographic type 'Latitude' and the longitude field to geographic type 'Longitude' and you should be able to just put those on rows and columns for the map. All you need is the latitude and longitude values in separate columns.
If this doesn't match with the format of your data, can you share a sample of the data and I'll take a look?