Dear All, I have my geographical coordinates in the following format: 3d44'42.838"E 51d25'38.268"N 44.443 3d45'9.935"E 51d30'2.643"N 44.330 3d44'54.911"E 51d30'5.507"N 44.328 How can I convert them into the decimal format. I also do not know the numbers after N such as 44.443 etc. asked 15 Dec '14, 11:14 Ebrahiem retagged 15 Dec '14, 13:25 rorym |
One Answer:
This is s programming problem. There are 60 minutes in one degree, and 60 seconds in one minute (i.e. 60×60 = 3600 seconds in one degree). I don't know what the answered 15 Dec '14, 12:00 rorym |
I converted the coordinates from Amsterfoort RD to the conventional format and that is where I got that. Let me rephrase the question, can I just replace the d with the degree sign and make spaces in order to use these coordinates? many thanks in advance
No.
40d30'
is "40 degrees and 30 minutes". This is also40.5 d
. So you can't just do a text replace. You need to do the calculationyes a text replacement before a calculation