[postgis-users] ST_DWithin with radius 0.000001

nguyen liem liemnguyendl at gmail.com
Tue May 25 07:33:06 PDT 2010


Hi Charles

Thanks for your answer, i can understand a little, i will try to research
more.
One more time, i would like to say thank you with you and Nicklas.

Cheers

On Tue, May 25, 2010 at 6:47 PM, Charles Galpin <cgalpin at lhsw.com> wrote:

>
> On May 25, 2010, at 5:43 AM, nguyen liem wrote:
>
> > One more question, if i would like to use ST_DWithin in projection WGS84
> and the radius is in 1 meter, how to do that?
>
> As someone else said it depends on the latitude you are dealing with, but
> you take the circumference of the earth at your location and divide by 360
> to get one degree. So at the equator one degree is roughly 69 miles or
> 111km.  So 0.00001 is 1m at the equator (but is .8m in NJ for example).
>
> hth,
> charles
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



-- 
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/1dd618a1/attachment.html>


More information about the postgis-users mailing list