Converting degrees, minutes and seconds to decimal
Thu, 01/03/2008 - 12:34pm
16 years
|
I'm new to this site and to GPS in general. I have a Garmin Nuvi 200 and want to add some POI's. I went to Google Earth and found one of the locations and tried to convert Google's coordinates to decimal via a spreadsheet that I downloaded. The resulting decimal coordinates placed the location two or three miles north of where it should be.
Google's coordinates were:
32 50'02.65 N
97 10'50.73 W
In the spreadsheet, I entered the minutes as 50.02 and 10.50 because I got an error if I put in the ' symbol. I just don't know what I'm doing on this conversion. Can someone help?
Thanks
In google earth go to
In google earth go to "tools" "options" and change it to "decimal degrees".
http://i31.photobucket.com/albums/c361/bbapties/GE.jpg
Google Earth converts it for you.
Hope this helps!
Google earth gives you that
Google earth gives you that choice.
In GE, go to "Preferences" and you can select the format you want.
Nuvi 650 (SW 4.30; GPS SW 3.00) , GPSmap 60CSx (SW 3.50; GPS SW 3.00), GPS III Plus
Basically Google Earth. Just
Basically Google Earth. Just hit Satellite. Fun to play with
Here's what it should look like
-97.105073 in Col A of your Excel Spreadsheet
32.500265 in Col B
Col C can have a Description
Col D I use for the address
Download one of the CSV POI's from here and you will see how they are done.
Larry - Nuvi 680, Nuvi 1690, Nuvi 2797LMT
use this website to convert
use this website to convert http://www.gpsvisualizer.com/calculators
or when looking at the location in google earth, you can highlight it and if you are using the new version you can click on the properties and it will give you the longitude and latitude in the correct format.
Miss POI
Thanks
Well, that makes it pretty easy! Thank you very much!
If converting with a spreadsheet
I'm new to this site and to GPS in general. I have a Garmin Nuvi 200 and want to add some POI's. I went to Google Earth and found one of the locations and tried to convert Google's coordinates to decimal via a spreadsheet that I downloaded. The resulting decimal coordinates placed the location two or three miles north of where it should be.
Google's coordinates were:
32 50'02.65 N
97 10'50.73 W
In the spreadsheet, I entered the minutes as 50.02 and 10.50 because I got an error if I put in the ' symbol. I just don't know what I'm doing on this conversion. Can someone help?
Thanks
If converting with a spreadsheet, the location is the degrees + (Minutes/60) + (Seconds/3600). Longitude is negative in W.
Garmin StreetPilot c530, Mapsource