[postgis-users] retransform coordinates to lat/long

[strk at refractions.net]

On Fri, Feb 25, 2005 at 10:52:18AM +0100, roxana at torre.nl wrote:
> Hello,
> I have installed PostGIS two days ago and I now have an esri shapefile in the
> database representing the boundaries of Europe. The idea is to get the whole
> worldmap there. 
> I have the next question: 
> I would like to get the coordinates of the boundary points back in lat/long, can
> I use the transform function to do this, and in that case how?

SRID for lat/long is 4326.

The transform function can be used to reproject data from a
Spatial Reference System to another.

If your geometries have the correct SRID set this should work:
SELECT transform(the_geom, 4326);

The SRID of input geometry can be specified with the -s flag
of shp2pgsl or - if you're using postgis >= 1.0.0RC1 - using
the UpdateGeometrySRID() function. Check the manual for further
informations.

--strk;

> thanks,
> roxana
> 
> 
> 
> ----------------------------------------------------------------
> This message was sent using IMP, the Internet Messaging Program.
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users