| 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: | Whole Thread | Raw Message | 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 |