On 1/15/2014 11:04 AM, itishree sukla wrote:
Deal all,
In my project, there is a requirement to implement proximity search
feature. We are running a mobile app, for which proximity search is
require. Can any one guide me how i can achieve this using postgis, or
is there any other way i can achieve this.
We are using postgresql 9.2.
select * from things_to_search where
st_dwithin(st_setsrid(st_makepoint(long, lat), 4326), geom, radius);
where radius is in degrees
-Steve
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
