Convert DMS from Excel to ArcGIS ?

1529
4
Jump to solution
01-19-2017 01:25 AM
JoSurinx
New Contributor

I'm trying to display the coordinates (DMS2) in my excel file in ArcGIS for Desktop by using the geoprocessing tool "Convert coordinate Notation" but i'm Always getting  the same error " 999999 : Error executing function". I cannot figure it out why it will not work ? Can somebody help me with this ? The excel file is attached ?

0 Kudos
1 Solution

Accepted Solutions
FC_Basson
MVP Regular Contributor

The last row of the list of coordinates has the N and E swopped.  Change the Latitude column to N and the Longitude column to E and it works.

View solution in original post

4 Replies
FC_Basson
MVP Regular Contributor

The last row of the list of coordinates has the N and E swopped.  Change the Latitude column to N and the Longitude column to E and it works.

JoSurinx
New Contributor

What a stupid mistake ! Thx very much to direct me to this error !

0 Kudos
FC_Basson
MVP Regular Contributor

0 Kudos
FC_Basson
MVP Regular Contributor

Oh and don't forget to close this thread by marking the answer as correct. Thanks!

0 Kudos