Convert DMS from Excel to ArcGIS ?

1034
4
Jump to solution
01-19-2017 01:25 AM
Highlighted
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 ?

Reply
0 Kudos
1 Solution

Accepted Solutions
Highlighted
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
Highlighted
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

Highlighted
New Contributor

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

Reply
0 Kudos
Highlighted
MVP Regular Contributor

Reply
0 Kudos
Highlighted
MVP Regular Contributor

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

Reply
0 Kudos