[postgis-users] Reprojecting a postgis layer

[Jeremy Brenner]

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
<marcuscengland at gmail.com> 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
>  postgis-users at postgis.refractions.net
>  http://postgis.refractions.net/mailman/listinfo/postgis-users
>



-- 
Jeremy Brenner
Phone: 618-219-2310
Email: jeremyjbrenner at gmail.com