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
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
