# GPS coordinates in access database

Ed McNierney ed at TOPOZONE.COM
Mon Dec 18 19:46:18 EST 2006

```Jacob -

Just remember that if the sign of the degrees is negative, you need to SUBTRACT the minutes divided by 60, so -110 degrees, 30 seconds ends up as  -110.5 degrees and not -109.5.

- Ed

Ed McNierney
TopoZone.com

-----Original Message-----
From: UMN MapServer Users List [mailto:MAPSERVER-USERS at LISTS.UMN.EDU] On Behalf Of Delfos, Jacob
Sent: Monday, December 18, 2006 5:23 PM
To: MAPSERVER-USERS at LISTS.UMN.EDU
Subject: Re: [UMN_MAPSERVER-USERS] GPS coordinates in access database

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!
»

```