I have a PostgreSQL/PostGIS database with a two string fields containing Lat and Long coordinates in degrees and decimal minutes, like this
45° 24.5' N
3° 43.01' E.
How can I convert them into decimal degrees, for use in
For your business:
When you are familiar with R than you can use this function, which converts your coordinates from degrees to decimals.