Welcome to WebmasterWorld Guest from 54.160.131.144

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

     

le_gber

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

WebmasterWorld Senior Member 10+ Year Member



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

Webwork

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

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



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?

inbound

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

WebmasterWorld Senior Member 10+ Year Member



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...]

le_gber

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

WebmasterWorld Senior Member 10+ Year Member



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

racer_x

4:16 am on Dec 20, 2006 (gmt 0)

10+ Year Member



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...]

 

Featured Threads

Hot Threads This Week

Hot Threads This Month