Google Answers Logo
View Question
 
Q: Country/State/City Listings ( Answered 2 out of 5 stars,   2 Comments )
Question  
Subject: Country/State/City Listings
Category: Science
Asked by: scottyboy-ga
List Price: $10.00
Posted: 25 May 2003 22:40 PDT
Expires: 24 Jun 2003 22:40 PDT
Question ID: 208742
Hi, I'm looking for the following:

1. For each continent in the world I want the list of countries
2. For each country I want the list of states (or
provinces/regions/counties - whatever is appropriate in that country)
3. For each state I want the list of major cities.

I would like to be able to download this information (for free if
possible) into files that I can load into a database.

I would like the lists to be related so that for any city I know
exactly what country and state it belongs to.

Can you tell me the best place to find this information (preferably
for free)

thanks for your help
Scott Tucker
Answer  
Subject: Re: Country/State/City Listings
Answered By: journalist-ga on 25 May 2003 23:13 PDT
Rated:2 out of 5 stars
 
Greetings Scott:

There are a few places to easily locate the data you seek at no cost
to you.  I'm not certain if the information can be downloaded from
these sites and you might inquire at each to see if database files are
available for download.  However, all the data you seek is free and
may be found among the following:

  GeoHive
    Beginning at http://www.xist.org/reg/index.php, you can see the
world in regions and within each region you can view the countries. 
From each country, you may view the divisions of the country and the
capitol cities.

  InfoPlease
    Here you'll find a list of all the countries in the world.  From
each country, you'll see a page of statistics that include the capitol
cities *and* the largest cities in each country. 
http://www.infoplease.com/countries.html

  Countries of each continent
    Listed below are the names of each continent and the countries
    within them.  The main page is
    http://www.nationsonline.org/oneworld/world_population.htm
    
    Africa
    http://www.nationsonline.org/oneworld/africa.htm

    the Americas
    http://www.nationsonline.org/oneworld/america.htm

    Aisa
    http://www.nationsonline.org/oneworld/asia.htm

    Europe
    http://www.nationsonline.org/oneworld/europe.htm

    Oceania
    http://www.nationsonline.org/oneworld/oceania.htm
    

In addition, an interesting site I ran across that I thought you might
enjoy is the 2002 CIA World Factbook at
http://www.odci.gov/cia/publications/factbook/ I didn't know the CIA
had such a website.

Should you require clarification of any of the links or information I
have provided, please request it and I'll be happy to respond.


SEARCH STRATEGY:

world almanac countries provinces states cities
countries on each continent

Request for Answer Clarification by scottyboy-ga on 26 May 2003 02:44 PDT
Hi journalist-ga, thanks for the info but it was not quite as I
needed. I really need the lists to be related, as I will be loading
the information into a relational database. i.e for the city "San
Francisco" I need to see that it relates to the state "California",
which in turn relates to the country "USA" which relates to the
continent "North America".
I need more than the capitals for each state, I want all of the main
cities in each state.
do you know of anything?

Clarification of Answer by journalist-ga on 26 May 2003 07:48 PDT
Greetings again Scott:

The InfoPlease link above - http://www.infoplease.com/countries.html -
*does* list the largest cities.  See a sample at
http://www.infoplease.com/ipa/A0108078.html and look in the lavender-
shaded area to find:

"Capital and largest city (2000 est.): London, 11,800,000 (metro.
area)

Other large cities: Birmingham, 1,009,100; Leeds, 721,800; Glasgow,
681,470; Liverpool, 479,000; Bradford, 477,500; Edinburgh, 441,620;
Manchester, 434,600; Bristol, 396,600"

Also, my colleague Secret901 posted a good source below.  From there
you will discover:

http://www.world-gazetteer.com/home.htm - This drills down from
country to state/province to capitals of each and, when applicable,
there are other large cities listed.

In addition, I executed more searches and visited numerous sites
today.  From those, I located
http://www.worldatlas.com/webimage/countrys/eu.htm (see across top of
page for the other continents).  It lists continents, countries, and
largest cities.  For instance, choosing Sweden from the Europe map
produced http://www.worldatlas.com/webimage/countrys/europe/se.htm and
then there is a link on that page to major cities at
http://www.worldatlas.com/webimage/countrys/europe/ciamaps/se.htm -
this should work for your needs as well.  The start page begins at
http://www.worldatlas.com/geoquiz/thelist.htm

Another is http://www.worldskip.com/ and it offers the same -
continents, countries, states/provinces and largest cities of each. 
However, it costs $1 a month ($12 a year) for a subscription to the
database.  Sample pages are available for view - see the sign up page
at https://commerce35.datapipe.com/worldskip/registration.asp?accessdenied=%2Fregion%2Easp%3FPartnerID%3D%26RegionID%3Dse
and click on the screenshot of "country information" to see the
presentation of facts.  You'll see "Largest Cities" present.  Also see
http://www.worldskip.com/company/index.shtml for information about the
site.


Should you require clarification of any of the additional links or
information I
have provided, please request it and I'll be happy to respond.


SEARCH STRATEGY:

continents countries largest cities
continents countries regions largest cities
download continents countries largest cities

Request for Answer Clarification by scottyboy-ga on 27 May 2003 16:15 PDT
Hi again Journalist-ga... regarding your clarification, the additional
sites still do not provide what I am looking for. They do not have the
state/province/region level in the heirarch. It is not enough for me
to have Continent/Country/Largest Cities. I need
Continent/Country/State/Major Cities. In the original question I also
asked that the info be downloadable in lists, so that I can load to
database. The sites you have provided would mean manual cutting and
pasting, and this would take a lifetime.
The links from Secret901-ga and Kyrie26-ga get me closer, but still
not there as the places are not the english placenames.
Once again I need lists of the heirarchy Continent/Country/State/City
where the cities are the major cities (plural) in each state of the
country. The placenames need to be the english placenames.
Your thoughts??

Clarification of Answer by journalist-ga on 27 May 2003 21:38 PDT
It appears that a downloadable database as you request is not
available.  I equated the term "largest cities" with "major cities"
and I apologize for the error.  How would you like me to proceed from
here?

Request for Answer Clarification by scottyboy-ga on 27 May 2003 22:06 PDT
Hi Journalist-ga - I understand. If you are convinced that there are
no such lists out there then why don't you tell me what you think is
fair in terms of the time you have put in? I appreciate your help, but
don't feel that I got what I was looking for. Your thoughts?

Clarification of Answer by journalist-ga on 27 May 2003 23:09 PDT
The fee is entirely up to you.  I have over 2 hours invested in
searching and examining links.  If you wish to seek a refund, I will
also understand.  I found the sources but not the download and I
searched with the word download with other keywords before returning
just now to respond.  I'll respect whatever decision you make.

Request for Answer Clarification by scottyboy-ga on 30 May 2003 18:59 PDT
appreciate your help anyway... proceed with payment
scottyboy-ga rated this answer:2 out of 5 stars
not exactly what I wanted, but a step in the right direction

Comments  
Subject: Re: Country/State/City Listings
From: secret901-ga on 25 May 2003 23:57 PDT
 
Hi scottyboy,
The answer to a previous question may be of interest to you:
http://answers.google.com/answers/main?cmd=threadview&id=67684

secret901-ga
Subject: Re: Country/State/City Listings
From: taz_in_auckland-ga on 20 Jul 2003 07:34 PDT
 
Don't know if you ever found what you where looking for - I was
looking for similar information in order to create a match making
website I wanted to develop. I got as far as finding Countries and
States/Regions/Provinces for 170 countries which I have loaded into a
mysql database. I figured that with the amount of work it would take
to populate the database with major cities wouldn't be worth it. If
you're interested in finding similar lists or regions in countries you
should do a goole search for 'ISO 3166-2'.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy