[postgis-users] Using PostGIS for latitude & longitude

Nicolas Ribot nicolas.ribot at gmail.com
Wed Dec 19 02:32:55 PST 2012


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


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>

More information about the postgis-users mailing list