<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; ">Hi Gates,<DIV>The unit returned will be the distance in the same units as the source data in the_geom column.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Tyler</DIV><DIV><BR><DIV><DIV>On 5-Aug-06, at 4:47 PM, gates jr wrote:</DIV><BR class="Apple-interchange-newline"><BLOCKQUOTE type="cite">I’m Gates, a university student. I got two problems: <OL> <LI> <DIV style="MARGIN-BOTTOM: 0cm">I have a table called “state_point table”. I calculate the distance between a new point to all point in my table with query:</DIV></LI></OL> <DIV style="MARGIN-BOTTOM: 0cm; MARGIN-LEFT: 0.64cm"><BR></DIV> <DIV style="MARGIN-BOTTOM: 0cm; MARGIN-LEFT: 1.27cm"><I>CREATE TABLE distance AS</I></DIV> <DIV style="MARGIN-BOTTOM: 0cm; MARGIN-LEFT: 1.27cm"><I>SELECT distance(state_point.the_geom, geomfromtext('POINT(100000 200000)',-1)) AS distance, state_id, state_name</I></DIV> <DIV style="MARGIN-BOTTOM: 0cm; MARGIN-LEFT: 1.27cm"><I>FROM state_point</I></DIV> <DIV style="MARGIN-BOTTOM: 0cm; MARGIN-LEFT: 1.27cm"><I>order by distance</I></DIV> <DIV style="MARGIN-BOTTOM: 0cm; MARGIN-LEFT: 1.27cm"><BR></DIV> <DIV style="MARGIN-BOTTOM: 0cm; MARGIN-LEFT: 1.27cm">My Question is : what measure unit that’s return by this query? Meters? Miles? Or another? If it’s not in meters how could I convert it to meters?</DIV> <DIV style="MARGIN-BOTTOM: 0cm; MARGIN-LEFT: 1.27cm"><BR></DIV> <OL start="2"> <LI> <DIV style="MARGIN-BOTTOM: 0cm">I want to make user interface in VB.NET 2005, which driver or connection should I use to show my map? Is there any VB.net or another language samples, which use postgreSQL/postgis database, that I can access in the internet? (a link site? ) I’m a kind of people that learn by example.</DIV></LI></OL> <DIV style="MARGIN-BOTTOM: 0cm"><BR></DIV> <DIV style="MARGIN-BOTTOM: 0cm"><BR></DIV> <DIV style="MARGIN-BOTTOM: 0cm">Thank</DIV> <DIV style="MARGIN-BOTTOM: 0cm"><BR></DIV> <DIV style="MARGIN-BOTTOM: 0cm">Gates</DIV> <DIV style="MARGIN-BOTTOM: 0cm"><BR></DIV> <DIV style="MARGIN-BOTTOM: 0cm"><BR></DIV> <DIV style="MARGIN-BOTTOM: 0cm"> </DIV><DIV> <BR class="khtml-block-placeholder"></DIV><HR size="1">See the all-new, redesigned Yahoo.com. <A href="http://us.rd.yahoo.com/evt=40762/*http://www.yahoo.com/preview"> Check it out.</A><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">_______________________________________________</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">postgis-users mailing list</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><A href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><A href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A></DIV> </BLOCKQUOTE></DIV><BR></DIV></BODY></HTML>