Convert DMS from Excel to ArcGIS ?

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

New Contributor

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

Reply
0 Kudos
MVP Regular Contributor

Reply
0 Kudos
MVP Regular Contributor

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

Reply
0 Kudos