Converting Lat/Long values

Extensibility

Converting Lat/Long values

How do I convert between different Geospatial coordinates? Is there a Teradata function that I can use?

For example, i have a coordinate of 24.3N 97.8W; How do I convert this to a regular lat/long value?
Tags (1)
1 REPLY

Re: Converting Lat/Long values

In decimal degrees (as you seem to have) you just change:

Latitude:
N -> +
S -> -

Longitude:
E -> +
W -> -

In your example: 24.3N, 97.8W => +24.3, -97.8 (Somewhere in the Gulf of México, near the US border and Ciudad Victoria ;-) )

If you have Degrees, Minutes, Seconds you need to change to decimal first.

HTH.

Cheers.

Carlos.