[postgis-users] Need Help to implement Proximity search feature
Stephen Woodbridge
woodbri at swoodbridge.com
Wed Jan 15 08:14:32 PST 2014
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
More information about the postgis-users
mailing list