<div>If I use sphere they have to both be points, the actual search I am doing is </div> <div>distance(the_geom, GeometryFromText('POINT(10 10)',4326))</div> <div> </div> <div>the_geom field is a polygon or a multipolygon<BR><BR><B><I>Paul Ramsey <pramsey@cleverelephant.ca></I></B> wrote:</div> <BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">distance_sphere(GeometryFromText('POINT(10 10)',4326),<BR>GeometryFromText('POINT(11 11)',4326))<BR><BR>On 3/18/08, davidj2k <DAVIDJ2K@YAHOO.COM>wrote:<BR>><BR>> I am trying to find the distance from a point to a polygon object and when I<BR>> use the distance(geometry,geometry) function it returns something that is<BR>> not in meters, I have been doing searches and all the examples of using this<BR>> function shows it in meters but that is not what I am seeing for example if<BR>> I use<BR>><BR>> distance(GeometryFromText('POINT(10 10)',4326),
GeometryFromText('POINT(11<BR>> 11)',4326))<BR>><BR>> I get<BR>><BR>> 1.4142135623731<BR>><BR>> How can I get this in meters? I need to do<BR>> distance < 1000 meters<BR>><BR>> --<BR>> View this message in context: http://www.nabble.com/Distance-function-is-not-in-meters-tp16127891p16127891.html<BR>> Sent from the PostGIS - User mailing list archive at Nabble.com.<BR>><BR>> _______________________________________________<BR>> postgis-users mailing list<BR>> postgis-users@postgis.refractions.net<BR>> http://postgis.refractions.net/mailman/listinfo/postgis-users<BR>><BR>_______________________________________________<BR>postgis-users mailing list<BR>postgis-users@postgis.refractions.net<BR>http://postgis.refractions.net/mailman/listinfo/postgis-users<BR></BLOCKQUOTE><BR><p> 
<hr size=1>Looking for last minute shopping deals? <a href="http://us.rd.yahoo.com/evt=51734/*http://tools.search.yahoo.com/newsearch/category.php?category=shopping">
Find them fast with Yahoo! Search.</a>