<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hi David,<div><br></div><div>Try this:</div><div><br></div><div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal 'Lucida Grande'; color: rgb(35, 35, 14); "><span style="color: #673820">SELECT</span><span style="color: #760f15"></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal 'Lucida Grande'; color: rgb(35, 35, 14); "><span style="color: #760f15"> 'lat: '</span> || <span style="color: #003369">ST_Y</span>(a.geometry) <span style="color: #673820">as</span> Latitude,<span style="color: #760f15"></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal 'Lucida Grande'; color: rgb(35, 35, 14); "><span style="color: #760f15"> 'long: '</span> || <span style="color: #003369">ST_X</span>(a.geometry) <span style="color: #673820">as</span> Longitude<span style="color: #673820"></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal 'Lucida Grande'; color: rgb(35, 35, 14); "><span style=""><font class="Apple-style-span" color="#673820">FROM</font></span><span style="color: #003369"> </span>(<font class="Apple-style-span" color="#673820"></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal 'Lucida Grande'; color: rgb(35, 35, 14); "><font class="Apple-style-span" color="#673820"> SELECT</font> <span style="color: #003369">ST_Transform</span>(geometry,<span style="color: #0000ff">4326</span>) <font class="Apple-style-span" color="#673820">AS</font> geometry</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal 'Lucida Grande'; color: rgb(35, 35, 14); "> <font class="Apple-style-span" color="#673820">FROM</font> YOUR_TABLE</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal 'Lucida Grande'; color: rgb(35, 35, 14); "> );</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal 'Lucida Grande'; color: rgb(35, 35, 14); "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal 'Lucida Grande'; color: rgb(35, 35, 14); ">Dane</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal 'Lucida Grande'; color: rgb(35, 35, 14); "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal 'Lucida Grande'; color: rgb(35, 35, 14); "><br></div><div><div>On Aug 11, 2008, at 2:24 PM, David Calle wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div dir="ltr">Hi List,<br><br>I need to convert geometry information to the GPS format:<br><br>01010000202D610000E81559FA0BD62541DA82728C04776241<br>to<br>lat: -2.9033 long: -79.138<br><br>Using PostGis functions like GeometryfromText.... thanks<br> </div> _______________________________________________<br>postgis-users mailing list<br><a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>http://postgis.refractions.net/mailman/listinfo/postgis-users<br></blockquote></div><br></div></body></html>