<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>I would suggest that first you check your data has a consistent format, i.e. “zero” is represented as 0000, 12.3 degrees is represented as 1230 and 1.23 degrees is represented as 0123.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Otherwise you need to do a little preparation work…<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>HTH,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Michael<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> postgis-users-bounces@postgis.refractions.net [mailto:postgis-users-bounces@postgis.refractions.net] <b>On Behalf Of </b>John Callahan<br><b>Sent:</b> Tuesday, July 12, 2011 9:13 AM<br><b>To:</b> PostGIS Users Discussion<br><b>Subject:</b> Re: [postgis-users] converting to lat long<o:p></o:p></span></p></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='margin-bottom:12.0pt'>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><o:p></o:p></p><div><p class=MsoNormal>On Tue, Jul 12, 2011 at 8:58 AM, Yamini Singh <<a href="mailto:yaminijsingh@live.com">yaminijsingh@live.com</a>> wrote:<o:p></o:p></p><div><div><div><p class=MsoNormal style='mso-margin-top-alt:.2in;margin-right:0in;margin-bottom:.2in;margin-left:0in'><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:#666666'>Hi All,</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:.2in;margin-right:0in;margin-bottom:.2in;margin-left:0in'><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p> </o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:.2in;margin-right:0in;margin-bottom:.2in;margin-left:0in'><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";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><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#666666'>attributes </span></b><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:#666666'>in another column to 'lat' and 'long'. For example, 'Lat' column will have </span></b><b><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#666666'>attribute '</span></b><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:#666666'>23.29' and 'long' column will have </span></b><b><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#666666'>attribute </span></b><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:#666666'> '47.27'.</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:.2in;margin-right:0in;margin-bottom:.2in;margin-left:0in'><b><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#666666'>Is there a way through which this can be converted automatically by a query or so.</span></b><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:.2in;margin-right:0in;margin-bottom:.2in;margin-left:0in'><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p> </o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:.2in;margin-right:0in;margin-bottom:.2in;margin-left:0in'><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:#666666'>Looking fwd..</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:.2in;margin-right:0in;margin-bottom:.2in;margin-left:0in'><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:#666666'> </span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:.2in;margin-right:0in;margin-bottom:.2in;margin-left:0in'><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:#666666'>Thanks</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:.2in;margin-right:0in;margin-bottom:.2in;margin-left:0in'><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:#666666'>YJ</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'><o:p></o:p></span></p></div></div></div><p class=MsoNormal style='margin-bottom:12.0pt'><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><o:p></o:p></p></div><p class=MsoNormal><o:p> </o:p></p></div></body></html>
<BR>
The information contained in this transmission is to be considered CONFIDENTIAL and PROPRIETARY to Consortium Health Plans, Inc. and intended for the use of the Individual or Entity named above. If the reader of this message is not the Intended Recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is Strictly Prohibited. If you have received this transmission in error, please notify us immediately by telephone at 410-772-2900 or return email to sender immediately. Thank You.