Re: [postgis-users] accuracy of coverage

2013-05-01 Thread Gold, Jack L (US SSA)
2013 3:35 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] accuracy of coverage >From http://postgis.refractions.net/documentation/manual-svn/ST_DWithin.html : boolean ST_DWithin(geography gg1, geography gg2, double precision distance_meters); boolean ST_DWithin(

Re: [postgis-users] accuracy of coverage

2013-05-01 Thread Andy Anderson
Gold, Jack L (US > SSA) > Envoyé : mercredi 1 mai 2013 20:34 > À : PostGIS Users Discussion > Objet : Re: [postgis-users] accuracy of coverage > > This 4000.0 is a double precision distance as defined by ST_DWithin ("The > distance is specified in units defined by the s

Re: [postgis-users] accuracy of coverage

2013-05-01 Thread Hugues François
ne- De : postgis-users-boun...@lists.osgeo.org [mailto:postgis-users-boun...@lists.osgeo.org] De la part de Gold, Jack L (US SSA) Envoyé : mercredi 1 mai 2013 20:34 À : PostGIS Users Discussion Objet : Re: [postgis-users] accuracy of coverage This 4000.0 is a double precision distance as

Re: [postgis-users] accuracy of coverage

2013-05-01 Thread Gold, Jack L (US SSA)
tgis-users-boun...@lists.osgeo.org] On Behalf Of b.j.kob...@utwente.nl Sent: Wednesday, May 01, 2013 1:25 PM To: postgis-users@lists.osgeo.org Subject: Re: [postgis-users] accuracy of coverage Since Gmaps uses not the geographic positions (lat-lon), but the feared "google maps projection&

Re: [postgis-users] accuracy of coverage

2013-05-01 Thread Ivan Santiago
--Original Message- From: postgis-users-boun...@lists.osgeo.org [mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of b.j.kob...@utwente.nl Sent: Wednesday, May 01, 2013 1:25 PM To: postgis-users@lists.osgeo.org Subject: Re: [postgis-users] accuracy of coverage Since Gmaps uses not the

Re: [postgis-users] accuracy of coverage

2013-05-01 Thread b.j.kobben
Since Gmaps uses not the geographic positions (lat-lon), but the feared "google maps projection" which has many geodetic problems, I would trust the PG calculation. However, are you sure the 4000 in your SQL will be interpreted as meters, not as 4000 decimal degrees (in that case the point will cer

[postgis-users] accuracy of coverage

2013-05-01 Thread Gold, Jack L (US SSA)
I am trying to determine the accuracy of the ST_DWithin function. I have a position at 32.52550166, -84.96989441 and I want to know if it is within a projected circle of 4km radius centered on 32.5, -85. I am running the following query: SELECT "id","location", ST_AsText(location) as "text_pos