<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" 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 11 (filtered medium)">
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PostalCode"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="State"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="Street"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceName"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceType"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="address"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Lucida Sans";
panose-1:2 11 6 2 3 5 4 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>SELECT <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> ST_AsText(<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> ST_GeomFromText('POINT(-81.064544
40.28787)', 3857)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> )
<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>AS goog, <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> ST_AsText(<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> ST_Transform(<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> ST_GeomFromText('POINT(-81.064544
40.28787)', 3857)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> ,
4326)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> )
<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>AS gcs<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>3857 is “Google’s” SRID, and 4326 is a
fairly standard GPS SRID. I’m getting this:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Goog: "POINT(-81.064544 40.28787)";<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Gcs: "POINT(-0.000728215188753794
0.000361912093851508)"<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>What am I doing wrong, that they’re so different?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoAutoSig><font size=3 face="Lucida Sans"><span style='font-size:
12.0pt;font-family:"Lucida Sans"'>Ronald Phillips, B.S., M.S.<o:p></o:p></span></font></p>
<p class=MsoAutoSig><font size=3 face="Lucida Sans"><span style='font-size:
12.0pt;font-family:"Lucida Sans"'>Programmer/Analyst<o:p></o:p></span></font></p>
<p class=MsoAutoSig><font size=1 face="Lucida Sans"><span style='font-size:
8.0pt;font-family:"Lucida Sans"'><o:p> </o:p></span></font></p>
<p class=MsoAutoSig><st1:City w:st="on"><font size=1 face="Lucida Sans"><span
style='font-size:8.0pt;font-family:"Lucida Sans"'>Summit</span></font></st1:City><font
size=1 face="Lucida Sans"><span style='font-size:8.0pt;font-family:"Lucida Sans"'>
<st1:place w:st="on"><st1:PlaceType w:st="on">County</st1:PlaceType> <st1:PlaceName
w:st="on">Engineer</st1:PlaceName></st1:place><o:p></o:p></span></font></p>
<p class=MsoAutoSig><st1:Street w:st="on"><st1:address w:st="on"><font size=1
face="Lucida Sans"><span style='font-size:8.0pt;font-family:"Lucida Sans"'>538
E. South St</span></font></st1:address></st1:Street><font size=1
face="Lucida Sans"><span style='font-size:8.0pt;font-family:"Lucida Sans"'>.<o:p></o:p></span></font></p>
<p class=MsoAutoSig><st1:place w:st="on"><st1:City w:st="on"><font size=1
face="Lucida Sans"><span style='font-size:8.0pt;font-family:"Lucida Sans"'>Akron</span></font></st1:City><font
size=1 face="Lucida Sans"><span style='font-size:8.0pt;font-family:"Lucida Sans"'>
<st1:State w:st="on">OH</st1:State> <st1:PostalCode w:st="on">44311</st1:PostalCode></span></font></st1:place><font
size=1 face="Lucida Sans"><span style='font-size:8.0pt;font-family:"Lucida Sans"'><o:p></o:p></span></font></p>
<p class=MsoAutoSig><font size=1 face="Lucida Sans"><span style='font-size:
8.0pt;font-family:"Lucida Sans"'>330.643.8061<o:p></o:p></span></font></p>
<p class=MsoNormal><a name=webProfileURL></a><a
href="http://www.linkedin.com/in/rwphillips" title="View public
profile">http://www.linkedin.com/in/rwphillips</a><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>