Looks like you already have lat/long coordinates and don't need to use ST_Transform. Make sure you know if the original values are in 'decimal degrees' or 'degrees minutes seconds'. If in DD, just divide your values by 100 which should be easy in SQL. If in DMS, then you need to parse the data first. I'm not sure how to do that in SQL but sure it's possible.<br>
<br>- John<br><br><br><br><div class="gmail_quote">On Tue, Jul 12, 2011 at 8:58 AM, Yamini Singh <span dir="ltr"><<a href="mailto:yaminijsingh@live.com">yaminijsingh@live.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div><div dir="ltr">
<div><p class="MsoNormal" style="font-size:10pt;font-family:Tahoma;margin-top:0.2in;margin-right:0in;margin-bottom:0.2in;margin-left:0in;line-height:normal"><b><span style="font-size:10.0pt;color:#666666">Hi All,<u></u><u></u></span></b></p>
<p class="MsoNormal" style="font-size:10pt;font-family:Tahoma;margin-top:0.2in;margin-right:0in;margin-bottom:0.2in;margin-left:0in;line-height:normal"><b><span style="font-size:10.0pt;color:#666666"><br></span></b></p>
<p class="MsoNormal" style="font-size:10pt;font-family:Tahoma;margin-top:0.2in;margin-right:0in;margin-bottom:0.2in;margin-left:0in;line-height:normal"><b><span style="font-size:10.0pt;color:#666666">I have a column 'geocode' in a table which has
attributes like 2329/4727 now I would like to convert these </span></b><b style="text-indent:0px !important"><span style="text-indent:0px !important;font-size:10pt;font-family:Verdana, sans-serif;color:rgb(102, 102, 102)">attributes </span></b><b><span style="font-size:10.0pt;color:#666666">in another
column to 'lat' and 'long'. For example, 'Lat' column will have </span></b><b style="text-indent:0px !important"><span style="text-indent:0px !important;font-size:10pt;font-family:Verdana, sans-serif;color:rgb(102, 102, 102)">attribute '</span></b><b><span style="font-size:10.0pt;color:#666666">23.29' and 'long' column will have </span></b><b style="text-indent:0px !important"><span style="text-indent:0px !important;font-size:10pt;font-family:Verdana, sans-serif;color:rgb(102, 102, 102)">attribute </span></b><b><span style="font-size:10.0pt;color:#666666"> '47.27'.</span></b></p>
<p class="MsoNormal" style="margin-top:0.2in;margin-right:0in;margin-bottom:0.2in;margin-left:0in"><b><font color="#666666" face="Verdana, sans-serif" size="2">Is there a way through which this can be
converted automatically by a query or so.<u></u><u></u></font></b></p><p class="MsoNormal" style="font-size:10pt;font-family:Tahoma;margin-top:0.2in;margin-right:0in;margin-bottom:0.2in;margin-left:0in;line-height:normal">
<b><span style="font-size:10.0pt;color:#666666"><br></span></b></p><p class="MsoNormal" style="font-size:10pt;font-family:Tahoma;margin-top:0.2in;margin-right:0in;margin-bottom:0.2in;margin-left:0in;line-height:normal"><b><span style="font-size:10.0pt;color:#666666">Looking fwd..</span></b></p>
<p class="MsoNormal" style="font-size:10pt;font-family:Tahoma;margin-top:0.2in;margin-right:0in;margin-bottom:0.2in;margin-left:0in;line-height:normal"><b><span style="font-size:10.0pt;color:#666666"><u></u> <u></u></span></b></p>
<p class="MsoNormal" style="font-size:10pt;font-family:Tahoma;margin-top:0.2in;margin-right:0in;margin-bottom:0.2in;margin-left:0in;line-height:normal"><b><span style="font-size:10.0pt;color:#666666">Thanks<u></u><u></u></span></b></p>
<p class="MsoNormal" style="font-size:10pt;font-family:Tahoma;margin-top:0.2in;margin-right:0in;margin-bottom:0.2in;margin-left:0in;line-height:normal"><b><span style="font-size:10.0pt;color:#666666">YJ<u></u><u></u></span></b></p>
</div> </div></div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br></blockquote></div><br>