[postgis-users] Geom to Lon Lat

[Dane Springmeyer]

Hi David,

Try this:

SELECT
   'lat: ' || ST_Y(a.geometry) as Latitude,
   'long: ' || ST_X(a.geometry) as Longitude
FROM (
     SELECT ST_Transform(geometry,4326) AS geometry
     FROM YOUR_TABLE
     );

Dane


On Aug 11, 2008, at 2:24 PM, David Calle wrote:

> Hi List,
>
> I need to convert geometry information to the GPS format:
>
> 01010000202D610000E81559FA0BD62541DA82728C04776241
> to
> lat:   -2.9033  long:    -79.138
>
> Using PostGis functions like GeometryfromText.... thanks
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080811/ba35cea2/attachment.html>