From: | Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz> |
---|---|
To: | itishree sukla <itishree(dot)sukla(at)gmail(dot)com>, obartunov(at)gmail(dot)com |
Cc: | PostGIS Users Discussion <postgis-users(at)lists(dot)osgeo(dot)org>, Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Need Help to implement Proximity search feature |
Date: | 2014-01-16 19:20:01 |
Message-ID: | 52D830E1.8030406@archidevsys.co.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Please see the comment at the bottom of this post.
On 16/01/14 22:52, itishree sukla wrote:
> Thanks for your reply, i am totally new to Postgis.
At least you've got into it, I keep meaning do do so myself.
>
> 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(dot)com
> <mailto:obartunov(at)gmail(dot)com>> wrote:
>
> check knn search,
> http://www.sai.msu.su/~megera/postgres/talks/pgcon-2010-1.pdf
> <http://www.sai.msu.su/%7Emegera/postgres/talks/pgcon-2010-1.pdf>
>
> On Wed, Jan 15, 2014 at 8:04 PM, itishree sukla
> <itishree(dot)sukla(at)gmail(dot)com <mailto:itishree(dot)sukla(at)gmail(dot)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
>
>
Pleas bottom post like I am here, it is the norm for these mailing
lists. Some comments interspersed are also okay.
It makes it easier for people to see the context of what you are saying.
Thanks,
Gavin
From | Date | Subject | |
---|---|---|---|
Next Message | Rémi Cura | 2014-01-16 19:25:30 | expert : SRF returning double[] |
Previous Message | Peter Eisentraut | 2014-01-16 18:43:01 | commit fest 2014-01 wants reviewers |