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 <[email protected]> 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 > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
