How to Convert Degrees, Minutes & Seconds to Google Earth format in SQL Server 2008 Database
Posted on 2010-04-03
I have Longitude and Latitude data imported into SQL Server 2008. The issue I am facing is converting this into a format which can be used with the Google Earth Plugin in C#. The expected data type is Double for example longitude(4.039), latitude(3.490), however the rows in the database are in the format of degrees, minutes and seconds for example 50:22:109. I need an sql query which will convert all the rows to the correct Double format. I am unsure of the maths or sql query that would give the desired output.
This is an example row from my table
bssid latitude longitude
002222444e33 50:22:109 4:08:166