homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Search Engines / Directories
Forum Library, Charter, Moderators: Webwork & skibum

Directories Forum

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

WebmasterWorld Senior Member 10+ Year Member

Msg#: 3187843 posted 7:45 pm on Dec 13, 2006 (gmt 0)

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



WebmasterWorld Administrator webwork us a WebmasterWorld Top Contributor of All Time 10+ Year Member

Msg#: 3187843 posted 3:47 pm on Dec 14, 2006 (gmt 0)

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?


WebmasterWorld Senior Member 10+ Year Member

Msg#: 3187843 posted 4:04 pm on Dec 14, 2006 (gmt 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...]


WebmasterWorld Senior Member 10+ Year Member

Msg#: 3187843 posted 1:21 pm on Dec 15, 2006 (gmt 0)

Thanks Webwork and Inbound, I was indeed thinking of Wikipedia or Dmoz to get my 'inspiration'.


10+ Year Member

Msg#: 3187843 posted 4:16 am on Dec 20, 2006 (gmt 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...]

Global Options:
 top home search open messages active posts  

Home / Forums Index / Search Engines / Directories
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved