On 7/21/2010 8:01 AM, Geoffrey wrote:
We need to locate all cities within a certain distance of a single city. We have longitude and latitude data for all cities. I was thinking postGIS was a viable solution, but I don't see a way to use our existing data via postGIS. Is postGIS a viable solution, or should I be looking at a different approach? Thanks for any suggestions or RTFM pointers.
I'd say PostGIS is a great option. Did you try: http://postgis.refractions.net/documentation/manual-1.5/ST_Distance_Sphere.html or do you mean, how do I turn my lat, long columns into a geomentry column? -Andy -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
