Re: Need Help to implement Proximity search feature

Поиск
Список
Период
Сортировка
От itishree sukla
Тема Re: Need Help to implement Proximity search feature
Дата
Msg-id CAL-g6VQvKVuXsiEdW=do=dG3AcW6E=bviLiLpve1Tr-VfGQ=Sw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Need Help to implement Proximity search feature  (Oleg Bartunov <obartunov@gmail.com>)
Ответы Re: Need Help to implement Proximity search feature
Re: Need Help to implement Proximity search feature
Список pgsql-general
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@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@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

В списке pgsql-general по дате отправления:

Предыдущее
От: Sébastien Lorion
Дата:
Сообщение: PostgreSQL with ZFS on Linux
Следующее
От: Sébastien Lorion
Дата:
Сообщение: Re: PostgreSQL with ZFS on Linux