select ST_Transform( the_geom, 26911) from california_counties; If you want it to be readable, you will need to convert it to text:
select ST_AsText( ST_Transform( the_geom, 26911 ) ) from california_counties; Hope this helps. On Fri, Apr 4, 2008 at 6:57 PM, Marcus C. England <[EMAIL PROTECTED]> wrote: > Hi all, > > I have spent the last three hours trying to find a plain-English > description of how you change the projection of a PostGIS layer, and I am > now giving up. I have found quite a few questions about this on the > internet, but not a single answer that allows for a newbie to SQL. Every > answers states something like "transform (arguments)"... what arguments? > > So, here it goes. I have a layer called "california_counties". The layer's > current SRID is correctly set at 3309. I want to transform the layer into > SRID 26911. How do I do that? It seems it should be so simple. > > Thanks in advance for your help. > > -Marcus > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > -- Jeremy Brenner Phone: 618-219-2310 Email: [EMAIL PROTECTED] _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
