I have data that contains geographic coordinate values in various
geographic coordinate system formats such as "degrees minutes seconds" and
"degrees decimal minutes".
I would like to convert these geographic coordinate values into decimal
degrees format.
Does PostgreSQL (more specifically PostGIS) have functions for these types
of conversions.
Below are examples of the geographic coordinates values I have coupled with
the resulting decimal degrees values.
39.529053 N 107.772406 W= 39.5290530°, -107.7724060°
27.485973 S 153.190699 E= -27.4859730°, 153.1906990°
30°32’39” N, 91°07’36” E= 30.5441667°, 091.1266667°
27.485973 S 153.190699 E= -27.4859730°, 153.1906990°
1¡20'1N 103¡45'15E= 01.3336111°, 103.7541667°
S 20 10.8035165 W 176 36.074496= -20.1800586°, -176.6012416°
The "°" sign in the results is optional.
Allan.