locating cities within a radius of another - Mailing list pgsql-general

From Geoffrey
Subject locating cities within a radius of another
Date
Msg-id 4C46EF9F.9030303@serioustechnology.com
Whole thread Raw
Responses Re: locating cities within a radius of another  (Andy Colson <andy@squeakycode.net>)
Re: locating cities within a radius of another  (Joe Conway <mail@joeconway.com>)
List pgsql-general
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.

--
Until later, Geoffrey

"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them."
- Thomas Jefferson

pgsql-general by date:

Previous
From: paladine
Date:
Subject: Re: pg_dump-restore concurrency
Next
From: Merlin Moncure
Date:
Subject: Re: Insert and Retrieve unsigned char sequences using C