Welcome to WebmasterWorld Guest from

Forum Moderators: Webwork & skibum

Message Too Old, No Replies

Finding Lists of Counties and Their Main Cities: UK, US, Global

Even better if they are In a format that you can easily import in a db

7:45 pm on Dec 13, 2006 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Mar 14, 2003
votes: 1

do you know of any free listing that is quite complete with

* all the counties in the UK
* 5 cities or more per county depending on the cities' sizes
* in a fomat that can be easily imported in a db

3:47 pm on Dec 14, 2006 (gmt 0)

Moderator This Forum

WebmasterWorld Administrator webwork is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

joined:June 2, 2003
votes: 101

For U.S. States I find that the U.S. Census Bureau does a nice job of listing States+Counties+Cities by population. It may take a little effort to cleanse the data but not that much.

Does the UK have a Census Bureau or like agency that surveys population and other demographic data?

4:04 pm on Dec 14, 2006 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Oct 9, 2004
votes: 0

The UK does have an office of national statistics that handle the census data but it's not in a format that is handy in this circumstance.

Also, UK counties are a bit of a problem as they can be different depending on who you ask. Should you use ceremonial (Lieutenancies Act 1997) or historic counties? should you add administrative areas too?

Probably the best way forward here is to make your mind up on which definition of county you are going to use then gather the information from public domain sources (the UK is a real pain when it comes to getting your hands on postcode/geo data that should be public).

A good starting point may be Wikipedia if you do not want to pay for the data, try pages like [en.wikipedia.org...]

1:21 pm on Dec 15, 2006 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Mar 14, 2003
votes: 1

Thanks Webwork and Inbound, I was indeed thinking of Wikipedia or Dmoz to get my 'inspiration'.
4:16 am on Dec 20, 2006 (gmt 0)

New User

10+ Year Member

joined:Nov 25, 2003
votes: 0

The governments of some countries provide this information free like the US or New Zealand. While the UK ordnance survey charge huge fees and have a restrictive license.

The US military National Geospatial-Intelligence Agency ( [earth-info.nga.mil...] ) provide free data for most (all?) countries around the world.

Countries where they have an interest get covered a lot better than other countries. For example there are a lot more records for Afghanistan or Iran than for the UK. But still most countries are covered reasonably well although some are out of date.

For the UK the NGA does list counties for some places but a lot of places have no county information (counties are listed under ADM1) is incomplete.

I think there is a free web based project that builds on this data, but I can't remember what it is called.

Also you might want to check out [gazetteer.co.uk...]


Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members