Forum Closed  
 
Thread Tools Search this Thread
21-01-2013, 16:45   #1
hamguy
Registered User
 
Join Date: Nov 2008
Posts: 52
Help converting co-ordinates to GPX

Hi everyone,
I'm looking for assistance convert an excel file containing about 270 gps coordinates to kml or gpx.

I've managed to convert - but my co-ordinates are possibly the correct format.

For example, this is one line:

Regional Hospital (Limerick) Limerick 52N3804 08W3910

Is there anyone that can assist please?

(I hope this is the correct forum!)

Thanks
hamguy is offline  
Advertisement
21-01-2013, 18:51   #2
Alun
Registered User
 
Join Date: Nov 2002
Posts: 19,848
Checking on my maps, they would appear to be degrees / minutes / seconds rather than decimal degrees, so your example of 52N3804, would be 53° 38' 04" North, for example (and NOT 53.3804° North).

If you have them as an excel file you should be able to write a simple formula to convert them into the format required by GPX, i.e. decimal degrees, with any latitudes W of Greenwich being negative, and any latitudes S of the equator being negative also.
Alun is offline  
12-02-2013, 13:00   #3
MunsterGeo
Registered User
 
Join Date: Feb 2013
Posts: 8
Not strictly related but probably the best place to ask witput starting a new thread...

What is the format of coordinates used in Geocaching? Is it decimal degrees or degrees / minutes / seconds?
MunsterGeo is offline  
12-02-2013, 21:42   #4
GhostInTheRuins
Registered User
 
GhostInTheRuins's Avatar
 
Join Date: Jun 2006
Posts: 5,787
Quote:
Originally Posted by MunsterGeo View Post
Not strictly related but probably the best place to ask witput starting a new thread...

What is the format of coordinates used in Geocaching? Is it decimal degrees or degrees / minutes / seconds?
It's degrees and decimal minutes, I think.

This format anyway:
N 53° 14.591
W 006° 17.887
GhostInTheRuins is offline  
Thanks from:
Forum Closed

Thread Tools Search this Thread
Search this Thread:

Advanced Search



Share Tweet