Indeed:
SELECT *
FROM mytable
WHERE
ST_DWithin(mytable.the_geom, ST_SetSRID(MakePoint($x, $y), $srid),
$distance);
P.
On 9-Sep-07, at 11:25 AM, Shane Spencer wrote:
I don't understand how the Distance() and Intersects() and Contains
() function wouldn't work for this?
Are X and Y radius the same?
On 9/9/07, [EMAIL PROTECTED] <[EMAIL PROTECTED] > wrote:Hi,
what I want to do is finding certain features in some distance
around a
certain point. Those features should be located in some corridor
between X
and Y km around this point. Currently I've solved this problem by
computing two bounding boxes of X and Y km around the point and
taking the
difference of those. So far so good.
But I don't want to have some quadratic box but a real circle - is
there
any way to achieve this?
Best regards,
Rainer
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
