GPS coordinates in SQL to google map

I have GPS longitudes and latitudes saved in SQL server, it has format of dddd.dddd and Hemisphere value.
How do I convert this in SQL on fly so that Google map accepts it.
For example, one has;
LastGPS_Latitude      LastGPS_LatHemisphere      LastGPS_Longitude
4045.2576      N      7352.8029

This coordinate is supposed to show somewhere in New York city or close.
LVL 1
crcsupportAsked:
Who is Participating?
 
Eugene ZCommented:
you missed  coordinates part  LastGPS_LonHemisphere      W
just use this format ( substring to ad space after 1st 2 digits <=> degrees .. let us know if need help,,
like this:

40 45.2576  N  73 52.8029 W

and use with google map to find location on  87Str 34 Ave Queens, NY
0
 
Mark BullockQA Engineer IIICommented:
I tried inputting degrees and decimal minutes (DMM) into Google Maps.

I used a negative number for your longitude to get the location in New York City. If you don't have a field for it, maybe it's assumed.

https://www.google.com/maps/place/40%C2%B045'15.5%22N+73%C2%B052'48.2%22W/@40.7543051,-73.8800556,15z/data=!3m1!4b1!4m2!3m1!1s0x0:0x0
0
 
Mark BullockQA Engineer IIICommented:
The string I entered in Google Maps was 40 45.2576, -73 52.8029
0
 
crcsupportAuthor Commented:
Can I assume N=+, W=-?
0
 
crcsupportAuthor Commented:
Thanks all.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.