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><p>
<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>