[postgis-users] Using PostGIS for latitude & longitude

[Nicolas Ribot]

Hi,

You could create a geometric column storing points based on coordinates,
then use a spatial query to also include near locations.

Recent threads on this list can give you hints:
   • on creating a geographic column based on lat long values
   • on using st_dwithin or nearest neighbor to find locations 7 miles
apart.

Nicolas


On 19 December 2012 10:51, nevillekb <nevillekb at gmail.com> wrote:

>
> I have a table in postgresql 9.2 that stores the latitude and longitude of
> locations as integer values.
>
> I intend to do something like when a user searches for a location, he also
> gets information on other locations that are within a 7 mile radius of that
> searched location.
>
> How do i use postGIS for this since i am new to it. Any idea.?
>
>
>
>
> --
> View this message in context:
> http://postgis.17.n6.nabble.com/Using-PostGIS-for-latitude-longitude-tp5002097.html
> Sent from the PostGIS - User mailing list archive at Nabble.com.
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20121219/c4ccdb4e/attachment.html>