[postgis-users] Geom to Lon Lat

[Jaime Mejia]

David you can to use:
SELECT ASEWKT(the_geom) ....
or use:
SELECT x(the_geom), x(the_geom) ...
x is long and y is lat

2008/8/11 David Calle <davydky at gmail.com>

> 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
>
>


-- 

Cordial Saludo,

Jaime Mejía
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080811/2ea2ccba/attachment.html>