[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] [GENERAL] Need Help to implement Proximity search feature
From:       itishree sukla <itishree.sukla () gmail ! com>
Date:       2014-01-16 9:52:45
Message-ID: CAL-g6VQvKVuXsiEdW=do=dG3AcW6E=bviLiLpve1Tr-VfGQ=Sw () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


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
>

[Attachment #5 (text/html)]

<div dir="ltr"><div><div><div>Thanks for your reply, i am totally new to \
Postgis.<br><br></div>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.<br> <br></div>Regards, \
<br></div>Itishree<br></div><div class="gmail_extra"><br><br><div \
class="gmail_quote">On Wed, Jan 15, 2014 at 11:28 PM, Oleg Bartunov <span \
dir="ltr">&lt;<a href="mailto:obartunov@gmail.com" \
target="_blank">obartunov@gmail.com</a>&gt;</span> wrote:<br> <blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex">check knn search, <a \
href="http://www.sai.msu.su/~megera/postgres/talks/pgcon-2010-1.pdf" \
target="_blank">http://www.sai.msu.su/~megera/postgres/talks/pgcon-2010-1.pdf</a><br>

<div class="HOEnZb"><div class="h5"><br>
On Wed, Jan 15, 2014 at 8:04 PM, itishree sukla<br>
&lt;<a href="mailto:itishree.sukla@gmail.com">itishree.sukla@gmail.com</a>&gt; \
wrote:<br> &gt; Deal all,<br>
&gt;<br>
&gt; In my project, there is a requirement to implement proximity search feature.<br>
&gt; We are running a mobile app, for which proximity search is require. Can any<br>
&gt; one guide me how i can achieve this using postgis, or is there any other way<br>
&gt; i can achieve this.<br>
&gt;<br>
&gt; We are using postgresql 9.2.<br>
&gt;<br>
&gt; Thanks in advance .<br>
&gt;<br>
&gt; Regards,<br>
&gt; Itishree<br>
</div></div></blockquote></div><br></div>



_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

[prev in list] [next in list] [prev in thread] [next in thread]