4 Replies Latest reply on May 24, 2017 11:43 AM by Sherzodbek Ibragimov

Ambiguous Location for City

Alexis White May 24, 2017 10:43 AM

I am working with a world wide data set that contains Country and City fields, but no state/province field. I have over 700 cities labeled as 'Ambiguous'. Is there a way to easily assign the right location for these cities instead of manually adding the Lat/Long for each one?

1. Re: Ambiguous Location for City

Sherzodbek Ibragimov May 24, 2017 11:00 AM (in response to Alexis White)

Alexis,
This can be done by custom geocoding. It is not super quick fix since it needs lat and long for those cities first. I have answered here: How do I resolve unknown/unrecognized cities? Please check and let me know if you still further help.
Sherzod
Like Show 0 Likes(0)

Actions
2. Re: Ambiguous Location for City

Shawn Wallwork May 24, 2017 11:16 AM (in response to Sherzodbek Ibragimov)

Batch Geocode is no longer available. Also without a State field Batch Geocode would also return ambiguous results. How is any software to know which of the 88 towns named Washington you are referring to?

--Shawn
Like Show 0 Likes(0)

Actions
3. Re: Ambiguous Location for City

Alexis White May 24, 2017 11:20 AM (in response to Shawn Wallwork)

Very true. I was hoping there would be a way to get around this without creating another extract from the database.
Like Show 1 Likes(1)

Actions
4. Re: Ambiguous Location for City

Sherzodbek Ibragimov May 24, 2017 11:43 AM (in response to Shawn Wallwork)

Shawn,
Very true. When I was reading the question, I didn't pay attention for missing State info, thus replied assuming State was present. My bad. Thanks for correcting me.
Sherzod
Like Show 1 Likes(1)

Actions

Go to original post

Tableau Community Forums

Ambiguous Location for City

1. Re: Ambiguous Location for City

2. Re: Ambiguous Location for City

3. Re: Ambiguous Location for City

4. Re: Ambiguous Location for City

Actions

More Like This