Request for Question Clarification by
10 Jun 2004 07:08 PDT
The databases you are asking about do exist, and they can be
downloaded free of charge. But (there's always a but...!) they are
large datasets and will require some clean-up and manipulation.
The most comprehensive database of city names is 25 Mb (5 Mb zipped),
and contains thousands upon thousands of records that look like this:
PA Wallaceton ppl Clearfield 405735N 0781721W Wallaceton 1721 295
What this shows is the city of WALLACETON in the county of CLEARFIELD
in the state of PA. The rest is information and markers that you
didn't ask for -- such as latitude/longitude. That's where the
"cleanup" comes in.
A smaller (about 5MB) file may be easier to work with but (1) on the
one hand, it's not quite as comprehensive a city listing as the above
database (but it's still awfully good), and (2) on the other hand, it
includes other types of information, like park names, rivers, etc,
that you would have to, again, clean up (easily done, as the cities
are all coded as such, so you can do a spreadsheet sort to isolate
them). Records look like this:
Abbeville ppl Vermilion Louisiana 295828N0920803W 18
Abbey Point cape Harford Maryland 392058N0761341W
Abbot Cemetery cemetery Grafton New Hampshire 440455N0720106W
The "ppl" indicates a populated place -- the cities you are looking
for. I suppose a cemetery can be considered a "populated place" as
well, but I suspect you'll want to remove these from your records.
Anyway, I can lead you to one or both datasets as an answer to your
question, if they would be of interest to you, but I just wanted you
to be aware in advance that some work would be needed at your end to
manipulate the data to best meet your needs.
Let me know what you think.