The points look about 70m apart to me. Duncan
On Thu, Dec 6, 2012 at 8:47 AM, tasneem dewaswala <[email protected]> wrote: > Hello, > > i want to know whether two location's are within 100 meters range of each > other or not. > i tried using ST_DWITHIN, but its not giving me appropriate answers. > > my query is " > > select st_dwithin(ST_GeomFromText('POINT(19.235308 > 72.977955)',2163),ST_GeomFromText('POINT(56.6647756667 > 12.877464)',2163),100) as "result"; > > the result that i get is "t" i.e true, which is logically not correct, the > answer i should get is false, since two locations are far beyond 100 meters > range. > > Please help me forming an exact query for this. > > Regards > Tasha > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users > -- Dr Duncan Golicher Investigador Titular, El Colegio de la Frontera Sur, Chiapas,Mexico Mexico tel +52 1 967 137 94 20 Skype name duncangolicher Publications: http://www.mendeley.com/profiles/duncan-golicher Senior lecturer, Bournemouth University, UK Centre for Conservation Ecology & Environmental Change School of Applied Sciences Christchurch House rm C218a Bournemouth University Fern Barrow Poole (Dorset) BH12 5BB UK Tel. +44 (0)1202 961682 For list of publications see Researcher ID: http://www.researcherid.com/rid/B-4240-2009 [email protected] [email protected] Researcher ID: http://www.researcherid.com/rid/B-4240-2009 _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
