indeed, you could even pregenerate the correct ellipse geometry then use that with ST_DWithin. At least if you have an ellipse instead of a true circle.<br><br>Shane<br><br><div><span class="gmail_quote">On 9/9/07, <b class="gmail_sendername">
Paul Ramsey</b> <<a href="mailto:pramsey@refractions.net">pramsey@refractions.net</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Indeed:<br><br>SELECT *<br>FROM mytable<br>WHERE<br> ST_DWithin(mytable.the_geom, ST_SetSRID(MakePoint($x, $y), $srid),<br>$distance);<br><br>P.<br><br>On 9-Sep-07, at 11:25 AM, Shane Spencer wrote:<br><br>> I don't understand how the Distance() and Intersects() and Contains
<br>> () function wouldn't work for this?<br>><br>> Are X and Y radius the same?<br>><br>> On 9/9/07, <a href="mailto:postgis@jochem.name">postgis@jochem.name</a> <<a href="mailto:postgis@jochem.name">
postgis@jochem.name</a> > wrote:Hi,<br>><br>> what I want to do is finding certain features in some distance<br>> around a<br>> certain point. Those features should be located in some corridor<br>> between X
<br>> and Y km around this point. Currently I've solved this problem by<br>> computing two bounding boxes of X and Y km around the point and<br>> taking the<br>> difference of those. So far so good.<br>>
<br>> But I don't want to have some quadratic box but a real circle - is<br>> there<br>> any way to achieve this?<br>><br>> Best regards,<br>> Rainer<br>> _______________________________________________
<br>> postgis-users mailing list<br>> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">
http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>><br>> _______________________________________________<br>> postgis-users mailing list<br>> <a href="mailto:postgis-users@postgis.refractions.net">
postgis-users@postgis.refractions.net</a><br>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br><br>_______________________________________________
<br>postgis-users mailing list<br><a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users
</a><br></blockquote></div><br>