?
Solved

Anyone has a database of countries and regions?

Posted on 2006-04-16
8
Medium Priority
?
401 Views
Last Modified: 2008-01-09
Hi all

I need a relational databse of countries and regions, which must have a comprehensive list of counties and regions and sub-regions.

Does anyone know of any company that specialises in this kind of data?

I would like the data in one of the following format:

MS Access
Flat files
CSV


Thanks
Med
0
Comment
Question by:uncle_med
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 4

Expert Comment

by:samb39
ID: 16467008
This site might have something that would help:

http://earth-info.nga.mil/gns/html/index.html

It comes in a flat file, here are the specs:

http://earth-info.nga.mil/gns/html/gis.html
0
 
LVL 3

Accepted Solution

by:
smartjen4u earned 375 total points
ID: 16468481
0
 
LVL 3

Expert Comment

by:smartjen4u
ID: 16468495
download the csv file here
atlast i found the file here it is

http://andrewpatton.com/countrylist.csv
and the source is frm
http://andrewpatton.com/countrylist.html
hope it works for you
regards
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 5

Expert Comment

by:Painfree888
ID: 16471997

UM,

Just throwing my .02 cents in here, but I would go with Sam's link. That or the ISO listing of countries and subdivisions (this will include political subdivisions). I am sure the other lists are fine, but Sam's link points to a site that maintains the FIPS 10-4 (think this is the right designator) country list standard for the US government. Going with a standard, either FIPS or ISO, will insure a couple of things:

1. Timely updates
2. Accuracy (well, most of the time ;-).
3. Compatability with other information systems

Just a few thoughts from someone who had to learn this the hard way. I don't expect any points here, just giving advice.

Thanks,

PF888
0
 
LVL 5

Expert Comment

by:Painfree888
ID: 16472003

Oops, forgot to add that FIPS is free, while I believe you have to pay for ISO product and updates.
0
 
LVL 2

Author Comment

by:uncle_med
ID: 16473278
Hi guys

Thanks for your contribution.
Some very nice links, but I need a relational database, ie, countrycode, carried over to region file. for example:

CountryCode   Country
10                  France

RegionCode   CountryCode    Region
110               10                   Paris

I've looked at the links provided. The closest one to what I'm looking for is http://www.heavens-above.com/, but its still not in a any data format that I can easily read using a script or a program. The only thing I can do is write a crawler to read the links and even if I manage that, the regions are limited to a maximum of 200 per records search.

The links sent by samb39 are great, but as far as I can see there is just country codes, and there are tens of thousands of regions which is far too much detail. I need this data for a real estate business, that sells property (mostly in European countries) and major towns & cities.

Thanks
med

0
 
LVL 2

Author Comment

by:uncle_med
ID: 16473322
Forgot to mention

smartjen4u countrylist.csv is very good. Its exactly the kind of format I need, but it only has the capital of each country. Do you have a similar file which includes major regions for each country?

Thanks
Med
0
 
LVL 5

Expert Comment

by:Painfree888
ID: 16477978

I use the FIPS 10-4 standard (only the upper most tier - country names and codes), and I know it has more than just country codes. Did you download the files? The NGA site can be a little confusing.

Another source of information may be the CIA World Factbook. It is available online, though the URL escapes me at the moment. Try a google search. Not sure about the breadth of the data, though. For instance, it may not be broken down into major metropolitan areas per country, if that makes sense.

Two other possible sources, at least from an American-centric view, are: US Department of Commerce and the US Department of State. Both would probably maintain the data that you are search for. Of course, by the time you get through to the right person to answer your questions, might have been easier to just by commercial products.

Another thought occurs to me: EU government entities. Have you tried the EU equivelant to the US Department of Commerce?
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This story has been written with permission from the scammed victim, a valued client of mine – identity protected by request.
This article is written by John Gates, CISSP. Gates, the SNUG President-Elect, currently holds the position of Manager of Information Systems at Lake Park High School in Roselle, Illinois.
Notifications on Experts Exchange help you keep track of your activity and updates in one place. Watch this video to learn how to use them on the site to quickly access the content that matters to you.
Saved searches can save you time by quickly referencing commonly searched terms on any topic. Whether you are looking for questions you can answer or hoping to learn about a specific issue, a saved search can help you get the most out of your time o…
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question