<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
</style>
</head>
<body class='hmmessage'>
That's awesome. Thanks very much Kevin.<br><br>On another note, can anyone recommend a book where I can learn the basics of the PostGIS database? <br><br>Thanks,<br>Michael<br><br>> Date: Fri, 7 Nov 2008 09:03:35 -0800<br>> From: kneufeld@refractions.net<br>> To: postgis-users@postgis.refractions.net<br>> Subject: Re: [postgis-users] Amatuer question - Distance between two points<br>> <br>> SELECT ST_Distance_Sphere('POINT(-38.034031 145.201711)', 'POINT(-37.899854 145.087116)');<br>> st_distance_sphere<br>> --------------------<br>> 17670.9023488375<br>> (1 row)<br>> <br>> <br>> or use ST_Distance_Spheroid for a more correct answer.<br>> <br>> http://postgis.refractions.net/documentation/manual-svn/ST_Distance_Sphere.html<br>> <br>> Cheers,<br>> Kevin<br>> <br>> Michael Signup wrote:<br>> > Hi,<br>> > <br>> > This is probably a very simple question but I am unable to find anything <br>> > to point me in the right direction.<br>> > <br>> > I am trying to understand how I can make distance related queries with <br>> > PostGIS. To do this, I am attempting to calculate the distance between:<br>> > <br>> > in Lat/Long<br>> > Point A(-38.034031,145.201711) and Point B(-37.899854,145.087116)<br>> > <br>> > I have tried several methods and am still getting the distance as <br>> > 92072.62 (I don't know what units this is in, but I am trying to get it <br>> > in meters).<br>> > <br>> > Google Earth calculates the distance as 17.4 km (approximately).<br>> > <br>> > Regards,<br>> > Michael<br>> > <br>> > <br>> > <br>> > <br>> > ------------------------------------------------------------------------<br>> > Find great deals on eBay Net yourself a bargain <br>> > <http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Frover%2Eebay%2Ecom%2Frover%2F1%2F705%2D10129%2D5668%2D323%2F4%3Fid%3D10&_t=763807330&_r=hotmailTAGLINES&_m=EXT><br>> > <br>> > <br>> > ------------------------------------------------------------------------<br>> > <br>> > _______________________________________________<br>> > postgis-users mailing list<br>> > postgis-users@postgis.refractions.net<br>> > http://postgis.refractions.net/mailman/listinfo/postgis-users<br>> _______________________________________________<br>> postgis-users mailing list<br>> postgis-users@postgis.refractions.net<br>> http://postgis.refractions.net/mailman/listinfo/postgis-users<br><br /><hr />Sign up for the Hotmail Road Trip today. <a href='http://www.ninemsn.com.au/hotmailroadtrip' target='_new'>Your dream beach house escape for summer!</a></body>
</html>