locating cities within a radius of another

From: Geoffrey <lists(at)serioustechnology(dot)com>
To: PostgreSQL List <pgsql-general(at)postgresql(dot)org>
Subject: locating cities within a radius of another
Date: 2010-07-21 13:01:19
Message-ID: 4C46EF9F.9030303@serioustechnology.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2010-07-21 13:27:52 Re: Insert and Retrieve unsigned char sequences using C
Previous Message paladine 2010-07-21 12:21:04 Re: pg_dump-restore concurrency