2 Replies Latest reply on Jan 15, 2019 11:12 AM by Dennis Stevens

Longitude and Latitude not recognized; Set to Geographic Role

Dennis Stevens Jan 14, 2019 6:26 PM

I have a spreadsheet that includes Latitude and Longitude, but Tableau treats them like integers when I try to create a map.

They are recognized as having a Geographic Role as Latitude and Longitude. I changed them to be discrete, non-aggregated Measures. But when I drag them on to the sheet, Tableau doesn't create a map.

Any ideas of what I can check?

The values are like this: 34.1428 -118.2281

I am using Tableau Public.

1. Re: Longitude and Latitude not recognized; Set to Geographic Role

Shinichiro Murakami Jan 14, 2019 7:11 PM (in response to Dennis Stevens)

In some cases, Longitude and Latitude is recognized oppositely which causes trouble.
Please make its sure, nevertheless of the field name, based on value itself, three digits -180~180 assigned to longitude an field with -90 ~ 90 is assigned as latitude.
And need to put latitude field to rows and longitude field to column.

Thanks,
Shin
Like Show 0 Likes(0)

Actions
2. Re: Longitude and Latitude not recognized; Set to Geographic Role

Dennis Stevens Jan 15, 2019 11:12 AM (in response to Shinichiro Murakami)

Thanks - I think I have it.
First I had to make the Latitude and Longitude into Dimensions.
I also found I had the string 'NULL' as a value. I had copied the data from
a sql query into a spreadsheet, and I hadn't noticed that.

Data prep is important!

On Mon, Jan 14, 2019 at 7:51 PM Shinichiro Murakami <
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

Longitude and Latitude not recognized; Set to Geographic Role

1. Re: Longitude and Latitude not recognized; Set to Geographic Role

2. Re: Longitude and Latitude not recognized; Set to Geographic Role

Sign In or
Create your Account

Actions

More Like This

Sign In or Create your Account

Sign In or
Create your Account