[postgis-users] database transformation

[ibrahim saricicek]

Hi;

Create a new geometry column "the_geom_3763"

then run this

UPDATE  table_name SET the_geom_3763=transform(the_geom,3763),
(You have now one table data in two projections. Then if you want, change
the geometry column names "the_geom, the_geom_27492".)

!!! don't forget to update also gemetry_columns table....

Regards,
IBO...


On Thu, Jan 21, 2010 at 1:22 PM, legio nostra <legio.patria at gmail.com>wrote:

> Hello everyone,
>
> I have a database created with the program pgadmin3. The geo-referencing
> system is the Datum 73 / Modified Portuguese
>
> Grid (deprecated) "EPSG: 27492" and wanted to change the whole database to
> the coordinate system ETRS89 / Portugal TM06 (EPSG: 3763).
>
> How can I make this transformation?
>
> Thank you for your help
>
> -- bernardo --
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100121/337c2673/attachment.html>