<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7653.38">
<TITLE>RE: [postgis-users] Coordinates transform</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<BR>
<P><FONT SIZE=2>Damn typo<BR>
<BR>
3) should be<BR>
UPDATE sometable SET new_column = ST_Transform(old_column, new_srid);<BR>
<BR>
-----Original Message-----<BR>
From: postgis-users-bounces@postgis.refractions.net on behalf of Obe, Regina<BR>
Sent: Tue 11/11/2008 10:09 AM<BR>
To: PostGIS Users Discussion<BR>
Subject: RE: [postgis-users] Coordinates transform<BR>
<BR>
Yes. Use ST_Transform.<BR>
<BR>
<BR>
Basic approach is<BR>
1) bring your data in with right SRID<BR>
2) Use AddGeometrycolumn to add a new column<BR>
<A HREF="http://postgis.refractions.net/documentation/manual-svn/AddGeometryColumn.html">http://postgis.refractions.net/documentation/manual-svn/AddGeometryColumn.html</A> to add a new column with new srid you want to use<BR>
<BR>
3) Update the new column with<BR>
UPDATE new_column SET new_column = ST_Trasform(old_column, old_srid, new_srid);<BR>
<BR>
<A HREF="http://postgis.refractions.net/documentation/manual-svn/ST_Transform.html">http://postgis.refractions.net/documentation/manual-svn/ST_Transform.html</A><BR>
<BR>
<BR>
4)Drop the old column with DropGeometryColumn<BR>
<A HREF="http://postgis.refractions.net/documentation/manual-svn/DropGeometryColumn.html">http://postgis.refractions.net/documentation/manual-svn/DropGeometryColumn.html</A><BR>
<BR>
<BR>
<BR>
<BR>
-----Original Message-----<BR>
From: postgis-users-bounces@postgis.refractions.net on behalf of Lonelu Lukas<BR>
Sent: Tue 11/11/2008 9:06 AM<BR>
To: postgis-users@postgis.refractions.net<BR>
Subject: [postgis-users] Coordinates transform<BR>
<BR>
Hi All,<BR>
<BR>
I have a list of longitude / latitude records in TM65 projection which<BR>
needs to be transformed into Google Map standard (UTM). Is Postgis proper<BR>
tool for that kind of transformations ? I mean .. can I import the data and<BR>
then use sql function to transform the data ? If yes could you point me<BR>
somewhere I could start ?<BR>
<BR>
<BR>
Regards,<BR>
<BR>
Luk<BR>
<BR>
<BR>
<BR>
-----------------------------------------<BR>
The substance of this message, including any attachments, may be<BR>
confidential, legally privileged and/or exempt from disclosure<BR>
pursuant to Massachusetts law. It is intended<BR>
solely for the addressee. If you received this in error, please<BR>
contact the sender and delete the material from any computer.<BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>