GPS coordinates in access database

[Delfos, Jacob]

Robert,

To get from degrees minutes to degrees decimal, simply devide the minutes by 60, and add it to the degrees:

49 + (15.942/60) = 49.2657

So you can use SQL to do it, or temporarily export your database to Excel.

Regards,

Jacob



» -----Original Message-----
» From: UMN MapServer Users List 
» [mailto:MAPSERVER-USERS at LISTS.UMN.EDU] On Behalf Of robert fritz
» Sent: 18 December 2006 18:42
» To: MAPSERVER-USERS at LISTS.UMN.EDU
» Subject: [UMN_MAPSERVER-USERS] GPS coordinates in access database
» 
» Hello,
» 
» I've got GPS data as geogaphical coordinates (e.g. 49° 
» 15.942, 007° 07.943) in an access database. the coordinates 
» are splitted in 4 columns:
» 
» columns:      value:
»   N                  49 
»   '                   15.942
»   E                  007 
»   '                   07.943
»              
» 		  
» I want to display the points - is it possible? How do I 
» create a point position in 2 columns instead of 4 columns? 
» 
» regards,
» Robert
» ______________________________________________________________
» ________________
» "Ein Herz für Kinder" - Ihre Spende hilft! Aktion: 
» www.deutschlandsegelt.de
» Unser Dankeschön: Ihr Name auf dem Segel der 1. deutschen 
» America's Cup-Yacht!
»