14 Replies Latest reply on May 27, 2013 8:40 AM by Haralambos Kontrafouris

# coordinates

hello, I have coordinates of various locations and a number of measures to apply. Is there a way to project the location on the map just by using Longitude and latitude?

Thanx!

• ###### 1. Re: coordinates

I know T wants you to post "Newbie" questions here. But you're much better off posting your question to the main forums. You are more likely to get your question answered. Ping me and I'll attempt to help.

--Shawn

1 of 1 people found this helpful
• ###### 2. Re: coordinates

To do this you need to make a data sheet with the Latitude and Longitude coordinates and the various fields associated with them. It should look something like this if you use Excel:

 Point Name Latitude Longitude Type Value Point 1 10 100 A 23 Point 2 20 100 A 62 Point 3 30 100 B 12 Point 4 40 100 B 77 Point 5 50 100 C 9 Point 6 60 100 C 100

Save this file then connect to in in tableau.

Then you drag longitude into the column self and latitude into the rows shelf. Then drag Point Name into the detail box so each coordinate is named. It should look like this

Now you can drag the other fields into color or size or whatever you want.

Let me know if you have any questions. I posted the workbook if you want to take a look.

1 of 1 people found this helpful
• ###### 3. Re: coordinates

Hey, thanks

but still have issues. You see I finally get the map view but no locations or points show up, is it perhaps the format of the coordinates?

• ###### 4. Re: coordinates

Well, coordinates have to be in the decimal form like 123.0043 or something and not in the degrees, minutes, seconds form. Can you post a sample of the coordinate data? Or if you post a packaged workbook I can better see what the problem is. Also if you coordinates aren't labeled "Latitude" and "Longitude" then you will have to manually assign them their geographic role so tableau will know what they are.

1 of 1 people found this helpful
• ###### 5. Re: coordinates

Actually data looks ok,  labels too pls see below,

 NAME Current DWt LATITUDE LONGITUDE MV Abigail 13.330 4.60971 ######## MV Adelaide 9.325 40.551582 -73.524294 MV Alyce 26.500 42.337898 -70.881092 MV Amarylis 9.251 6.143911 2.707806 MV Ava 23.664 4.267617 6.986763 MV Bernadette 9.350 51.469299 0.802594 MV Bertha 9.402 59.476869 24.664929 MV Bertilde 9.251 59.924007 30.200432 MV Beth 9.402 21.966903 37.962077 MV Buick 9.251 -5.273844 67.151133 MV Candra 8.899 34.223150 138.922647 MV Cara 9.402 17.824264 131.639120 MV Carolyn 9.350 -31.593.103 112.747820 MV Cassandra 26.500 4.267617 6.986763 MV Catherine 9.251 51.469299 0.802594 MV Cicily 9.484 59.476869 24.664929 MV Davina 9.251 59.924007 30.200432 MV Day 14.355 21.966903 37.962077 MV Delora 9.251 -5.273844 67.151133

thoughts?

• ###### 6. Re: coordinates

Try converting the longitude and latitude fields to Dimensions once they are in the Column and Row shelves.

Also after that make sure to drag [Name] into the detail self.

I attached the packaged workbook if you want to take a look. One change I did to the data was I changed the longitude of the first point (MV Abigail) to 0 because it was showing up as ####### when you pasted it. If you are still having trouble, save the file as a packaged workbook and post it and I'll be able to see exactly what need to do.

1 of 1 people found this helpful
• ###### 7. Re: coordinates

here is the file,

I wonder if there are any restrictions in the trial version...

1 of 1 people found this helpful
• ###### 8. Re: coordinates

I see, your latitude and longitude fields were set at a string type field, you need to convert it to number by right clicking the field then go to Change Data Type = > Number,   then Geographic Role => Latitude and Longitude then it works. Here is the workbook.

1 of 1 people found this helpful
• ###### 9. Re: coordinates

hmm, this exactly what I've done so far and I keep getting the same result. here is how it looks when I open the attachment you've sent. All points are projected on the edges of the y axis. So I guess there is something wrong with the formatting of the Longitudinal coordinates or with localizations (formats etc) I will check that way.

Thanks so much!

• ###### 10. Re: coordinates

I think your biggest problem is really 'dirty' data. I opened the Excel file in the packaged workbook you posted and here's what I see:

Problems:

1. Your Date field is referring to other cells that don't exist in this version of the workbook
2. The first number in the Longitude field is 7 million (instead of 74.08?).
3. The biggest problem is that all your Lat/Longs are preceded by apostrophes, which is making Tableau think these are text fields.

Tableau is a great tool but you have to give it a fighting chance of producing a good viz by giving it reasonably clean data.

Now to some of your conjectures. I don't think this has anything to do with a problem with the free-trial, since the trial software is a fully-functioning install of the software. Also I doubt if the problem you are experiencing in that last screenshot you posted has anything to do with your locale setting, but I must say I have been unsuccessful at recreate that last viz you posted using the workbook you posted. Somehow you've changed all the Latitudes to zeros. (?)

Anyway, here's a new workbook with all the data cleaned up. What do you see when you open it?

--Shawn

• ###### 11. Re: coordinates

Hey Shwan, it, works! thanks for your time! I know time is precious, this is why I've chosen to spend some of mine with Tableau,

really great tool!

• ###### 12. Re: coordinates

Whew! Glad it worked for you finally. Also glad the experience didn't sour you on the software. Most of the time it isn't this hard.

Cheers,

--Shawn

• ###### 13. Re: coordinates

PS: I think Noel deserves a few 'Helpful' stars, he hung in with you through several rounds.

--Shawn

• ###### 14. Re: coordinates

very well said, indeed,

thank you both!