Yes. Use ST_Transform.
Basic approach is
1) bring your data in with right SRID
2) Use AddGeometrycolumn to add a new column
http://postgis.refractions.net/documentation/manual-svn/AddGeometryColumn.html
to add a new column with new srid you want to use
3) Update the new column with
UPDATE new_column SET new_column = ST_Trasform(old_column, old_srid, new_srid);
http://postgis.refractions.net/documentation/manual-svn/ST_Transform.html
4)Drop the old column with DropGeometryColumn
http://postgis.refractions.net/documentation/manual-svn/DropGeometryColumn.html
-----Original Message-----
From: [EMAIL PROTECTED] on behalf of Lonelu Lukas
Sent: Tue 11/11/2008 9:06 AM
To: postgis-users@postgis.refractions.net
Subject: [postgis-users] Coordinates transform
Hi All,
I have a list of longitude / latitude records in TM65 projection which
needs to be transformed into Google Map standard (UTM). Is Postgis proper
tool for that kind of transformations ? I mean .. can I import the data and
then use sql function to transform the data ? If yes could you point me
somewhere I could start ?
Regards,
Luk
-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
