Converting GPS Positions to Google Maps

I have a set of GPS-coordinates in a database, which I want to compare to a coordinate supplied by the html5 location API.

My coordinates look like this:

            <WGS84Coordinates>
<Longitude>180325E</Longitude>
<Latitude>591947N</Latitude>
</WGS84Coordinates>


This is from Stockholm Central Station. If I enter these coordinates into google maps, I end up southwest of Stockholm in Google Maps. If I enter coordinates supplied by the html5 location API, I end up right next to Stockholm Central Station in Google Maps (which is my correct location).

The same pattern applies to all the coordinates I supply form my GPS-coordinate-database.

What is going on here? I've read that Google Maps uses WGS84, as does the coordinates from my database. I've also read that the html5 position API uses WGS84. Also, I've read something about Google Maps using Mercator Projection. I am unsure which projection the coordinates from the database has.

Ideally, I'd want a converter to convert between the two formats.

Any ideas?

• Your coordinates are of the type degrees-minutes-seconds. Try pasting this in Gmaps search 59 19'47" 18 03'25", it'll take you right to the central station. Use the formula @AndreJoost posted to convert all your data to decimal degrees. In the above example, 59 is your degrees, 19 is minutes and 47 is seconds. – Martin Jun 17 '14 at 7:40

If you need decimal degrees, you have to calculate degrees + minutes / 60 + seconds / 3600. This can be done easy with any spreadsheeet calculation.