[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?
Cheers.
--
Liem Nguyen
Developer
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