Converting Location Data
Tue, 08/28/2007 - 9:24am
 |
 16 years
|
How do u convert location data from degrees format to decimal coordinate format?
|
16 years
|
How do u convert location data from degrees format to decimal coordinate format?
Re: Converting Location Data
How do u convert location data from degrees format to decimal coordinate format?
Hi WindChill,
If you're using Google Earth, that setting can be changed to "Decimal Degrees" in the Preferences (Mac) or not being a Windows user, I'm guessing the Properties in Windows.
Otherwise go to this site:
Latitude/Longitude Conversions
Regards,
Tailspin
Sullivan's Law: Murphy was an optimist!
excel does the trick
To convert from gps to decimals:
1. take the seconds and divide by 60
2. add result to minutes (gives you decimal minutes and part minutes)
3. take the minutes and decimal part minutes and divide by 60 to get decimal degrees
4. add result to full degrees and there you have it.
Full formula looks like this: =sum((((seconds cell/60)+minutes cell)/60)+degrees cell)
The reverse applies to convert degrees and decimals to degrees minutes and seconds
I set the math up in a new column and simple copy down. Remember to multiple by (-1) where the longitude is W!
Anyway. the above works for me!
Tom
Thank you very much.......I
Thank you very much.......I will try to make one POI file and see.
WindChill
***Garmin Nuvi 350/StreetPilot c340***