Re: Search by distance

From: "John D(dot) Burger" <john(at)mitre(dot)org>
To: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Search by distance
Date: 2006-04-11 14:24:25
Message-ID: d49c2804ba0afe2a5dddac5ebee37c92@mitre.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Oscar Picasso wrote:

> I guess I also need a database of the cities coordinates. Where could
> I find one?

You can download US data here:

http://geonames.usgs.gov/domestic/download_data.htm

These are tables of geo entities with a number of columns, including
lat/long. NGA (formerly NIMA) has similar data for non-US entities:

http://earth-info.nga.mil/gns/html/cntry_files.html

Note that these data sets include =lots= of entities, not just cities -
we've combined them into a DB with about 6 million items, and only
about 2.5 million are population centers (by our scheme). Each of the
data sets has feature type columns that you can filter on, though.

- John Burger
MITRE

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mitch Pirtle 2006-04-11 14:35:29 Re: LW Boston
Previous Message Merlin Moncure 2006-04-11 13:22:41 Re: Fw: Performance UPDATE/INSERT