<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Hi,<br>
<br>
try this <a class="moz-txt-link-freetext" href="http://www.postgis.org/docs/ST_GeomFromText.html">http://www.postgis.org/docs/ST_GeomFromText.html</a><br>
<br>
Marco<br>
<br>
Am 03.02.2015 um 05:11 schrieb KhunSanAung:<br>
</div>
<blockquote
cite="mid:CAAQr1janLXYynjCuyU1X82g_Mv_apD2s=4yQrZ-vr23-jvMp5Q@mail.gmail.com"
type="cite">
<div dir="ltr">
<div class="gmail_default" style="color:rgb(0,0,255)">Hi All,</div>
<div class="gmail_default" style="color:rgb(0,0,255)"><br>
</div>
<div class="gmail_default" style="color:rgb(0,0,255)">I have one
table (Town info) in postgres without Geometry field.</div>
<div class="gmail_default" style="color:rgb(0,0,255)">I have
Latitude and Longitude information for those points data
separately (collecting & filling).<br>
</div>
<div class="gmail_default" style="color:rgb(0,0,255)"><br>
</div>
<div class="gmail_default" style="color:rgb(0,0,255)">I created
the postGIS extension and add the Geometry field in the above
postgres table.</div>
<div class="gmail_default" style="color:rgb(0,0,255)">Now, I'd
like to add the location information into the postGIS geometry
field so that I can immediately view those points on the map. </div>
<div class="gmail_default" style="color:rgb(0,0,255)"><br>
</div>
<div class="gmail_default" style="color:rgb(0,0,255)">How can I
convert the Latitude/Longitude value into postGIS geometry
value?</div>
<div class="gmail_default" style="color:rgb(0,0,255)"><br>
</div>
<div class="gmail_default" style="color:rgb(0,0,255)">Thank you
very much in advance.</div>
<div class="gmail_default" style="color:rgb(0,0,255)"><br>
</div>
-- <br>
<div class="gmail_signature">
<div dir="ltr"><span style="color:rgb(0,0,153)">Have a nice
day!</span><br>
--<br>
<p style="line-height:115%"><b><span
style="font-size:9pt;line-height:115%;color:rgb(127,127,127)"
lang="EN-GB">Mr. Khun San Aung</span></b></p>
<u><span style="font-size:9pt;line-height:115%;color:blue"
lang="EN-GB"></span></u><u><span
style="font-size:9pt;line-height:115%;color:rgb(127,127,127)"
lang="EN-GB"></span></u></div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a></pre>
</blockquote>
<br>
</body>
</html>