Degrees Minutes Seconds - Decimal Degrees changes the Degrees integer

10-18-2016 05:07 AM
New Contributor III

I have been given a spreadsheet containing Degrees Minutes Seconds coordinates in the format 'DD MM SSS' (including the spaces). I've used the DMS - DD formula ‘DD = (Seconds/3600) + (Minutes/60) + Degrees' to convert the DMS values to DD. I have also used the Convert Coordinate Notation tool in ArcMap. Both methods agree that my DMS of 53° 47’ 985” = 54.05694. This would seem to be because the seconds contain three digits when they should contain only two. Does anyone have any ideas as to how this could have arisen? I'm now thinking that what I have is in fact Degrees, Minutes, Decimal Seconds.

0 Kudos
3 Replies
MVP Esteemed Contributor

well more than that is wrong since there is no way of getting 54 degrees in any event.

consider 54 deg 54 min 54 seconds

54 deg  54 +54/60 min

54 deg 54.90 min

54 deg 54.9/60

notice it never gets to 55, no matter how hard you try.

quit trying to use those old formula since they lead to errors, just use sequential math and you will notice that you don't 'add' to the degree portion it 'becomes' the decimal portion a conceptual versus mathematical difference

New Contributor III

Thanks Dan, yes of course the DMS integer of 53 degrees can never become a DD integer of 54 degrees which means that my example calculation produces an incorrect result. I believe that the calculation is sound in principle however this is a textbook case of rubbish in - rubbish out! Thanks for your feedback.

0 Kudos
MVP Esteemed Contributor

You guessed it right. The value of Seconds should be less than 60. The calculation seems correct but the Seconds' value seems incorrect.

It may seem correct if I consider it as Degree Minute (decimal), not DMS. e.g. 53° 47’ 985” looks incorrect, but it could be 53° 47.985'

Please check with the data provider.

Think Location