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
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 |