[postgis-users] Coordinates transform

Obe, Regina robe.dnd at cityofboston.gov
Tue Nov 11 07:23:37 PST 2008


Damn typo

3) should be 
UPDATE sometable SET new_column = ST_Transform(old_column, new_srid);

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net on behalf of Obe, Regina
Sent: Tue 11/11/2008 10:09 AM
To: PostGIS Users Discussion
Subject: RE: [postgis-users] Coordinates transform
 
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: postgis-users-bounces at postgis.refractions.net on behalf of Lonelu Lukas
Sent: Tue 11/11/2008 9:06 AM
To: postgis-users at 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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20081111/87ddec8e/attachment.html>


More information about the postgis-users mailing list