[postgis-users] [GENERAL] Need Help to implement Proximity search feature

[itishree sukla]

Thanks for your reply, i am totally new to Postgis.

we have Database, but not ready for Geocode use.  what i understood from
different blog, we should have latitude and longitude either based on
addresses, or postal code we have. However if I will get the lat and long,
need to calculate earth distance to give  location based on user location.
Formula i got, is calculating shortest distance, which always not true
practically. Please address my concern, how i will get rid of these issues.

Regards,
Itishree


On Wed, Jan 15, 2014 at 11:28 PM, Oleg Bartunov <obartunov at gmail.com> wrote:

> check knn search,
> http://www.sai.msu.su/~megera/postgres/talks/pgcon-2010-1.pdf
>
> On Wed, Jan 15, 2014 at 8:04 PM, itishree sukla
> <itishree.sukla at gmail.com> 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.
> >
> > Thanks in advance .
> >
> > Regards,
> > Itishree
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140116/4534a2da/attachment.html>