[OpenLayers-Users] Geometry to Long / Lat

[Nathan Gerber]

SELECT ASTEXT(thegeom);

That should do what you are looking for.
--
Nathan Gerber


On Mon, Aug 11, 2008 at 5:05 PM, David Calle <davydky at gmail.com> 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
>
> _______________________________________________
> Users mailing list
> Users at openlayers.org
> http://openlayers.org/mailman/listinfo/users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/openlayers-users/attachments/20080811/c631e69c/attachment.html