Re: countries,states and cities

"Chris W. Parker" <cparker@swatgear.com> wrote in message news:001BD19C96E6E64E8750D72C2EA0ECEE2B8022@ati-ex-01.ati.local... Augusto Cesar Castoldi <mailto:accastoldi@yahoo.com.br> on Monday, September 08, 2003 4:16 PM said: > where can I download a database with all countries and > states and cities? I don't know but I would also be interested in this!! > like: > http://www.datingplace.com/servlet/NewRegistration What? No North Korea? ;) Chris. -------------------------------------- The world is a big place. To get you started here's the 2000 US Census data. The file you want is the one labled 'Places.zip'. The schema is available on the page but I've posted it below for convenience sake.. http://www.census.gov/geo/www/gazetteer/places2k.html a.. Columns 1-2: United States Postal Service State Abbreviation b.. Columns 3-4: State Federal Information Processing Standard (FIPS) code c.. Columns 5-9: Place FIPS Code d.. Columns 10-73: Name e.. Columns 74-82: Total Population (2000) f.. Columns 83-91: Total Housing Units (2000) g.. Columns 92-105: Land Area (square meters) - Created for statistical purposes only. h.. Columns 106-119: Water Area(square meters) - Created for statistical purposes only. i.. Columns 120-131: Land Area (square miles) - Created for statistical purposes only. j.. Columns 132-143: Water Area (square miles) - Created for statistical purposes only. k.. Columns 144-153: Latitude (decimal degrees) First character is blank or "-" denoting North or South latitude respectively l.. Columns 154-164: Longitude (decimal degrees) First character is blank or "-" denoting East or West longitude respectively Enjoy! Kevin