[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