[postgis-users] Transform Coordinates

Pablo Tutino ptutino at gmail.com
Wed Nov 12 06:38:58 PST 2008


Thank you very much Nicolas.



On Wed, Nov 12, 2008 at 8:42 AM, Nicolas Ribot <nicky666 at gmail.com> wrote:

> > How can I transform the coordinate system of a table ?
> > I know the SRID is 4326.
> >
> > Thanks a lot
> >
>
> Basically, by using st_transform(geometry, srid) on your table.
> It may be a little more complicated if you have SRID constraints on your
> table.
>
> 2 options among several:
>
> 1°) Drop the constraint, update your data by transforming them, readd
> the constraint with updated SRID value
>
> 2°) Add a new geometric column to your table and insert into it
> transformed geometries from the first column.
>
> HTH
> Nicolas
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



-- 
Ing. Pablo Hernán Tutino
DIVENTI - Ingeniería y Desarrollo
pablo.tutino at diventi.com.ar
www.diventi.com.ar
TE: +54-11-1569719001
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20081112/22adc5af/attachment.html>


More information about the postgis-users mailing list