[postgis-users] ST_DWithin with radius 0.000001

nguyen liem liemnguyendl at gmail.com
Tue May 25 01:10:24 PDT 2010

Hi all

At the first time i used ST_Contains but it take a long time, so I used
ST_Dwithin to improve the performance for the query statement but i don't
know it is correct or not.
I would like to know my points are within in polygon or not:

SELECT id, geom
FROM my_neighbour
WHERE ST_Dwithin (geom, *geometry*, *0.00001*)

*geometry:* is a polygon(input parameter).
*0.00001:* I means the radius of *geometry* is 1 meters, is it right?


Liem Nguyen
Axon Active Corp.
Direct Line      : +84 38 948 4645
Fax                  : +84 38 811 3489
Mobile Phone  : +84 168 994 8897
Skype ID         : liemnguyendl2204
Email               : liem.nguyen at axonactive.net / liemnguyendl at gmail.com
Web Site          : http://axonactive.vn
Address           : 87 Thang Long Street,Gate 2 Ward 4,
                         Tan Binh District, HCM city, Vietnam.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100525/9ec79cb1/attachment.html>

More information about the postgis-users mailing list