[postgis-users] Using PostGIS for latitude & longitude
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:
> Sent from the PostGIS - User mailing list archive at Nabble.com.
> postgis-users mailing list
> postgis-users at lists.osgeo.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-users