Ultimate Definitive World List? Regions, Cities, Towns - does anyone have one?

We encourage users to post events happening in the community to the community events group on https://www.drupal.org.
spessex's picture

Hi

Does anyone out there have a definitive world list of all the countries, their regions, cities and towns etc that they might be able to pass to me?

I've been trying to create my own and its a hell of a task, and there's so much conflicting information.

A full definitive list would be the ideal, but failing that I would easily settle for:

  1. UK & Ireland
  2. United States
  3. Canada
  4. Australia
  5. New Zealand
  6. Germany
  7. Spain
  8. France
  9. Italy

Any help would be greatly appreciated as the Location module just doesn't appear to be definitive.

Thank you

Stephen

Comments

Have u checked addresfield

bapi_22's picture

Have u checked addresfield module?

Thanks for this. I've just

spessex's picture

Thanks for this. I've just checked it but unfortunately it doesn't go to the level required and instead relies on the user input. For example 'United Kingdom' has no supporting county, city, town etc drops down. Similarly United States only goes down to a State Level. It's important I have most countries local area level i.e. city or town, as it's a system that displays job requirements on a local level basis, so needs to be searchable by hierarchical drop list by country, then sub area and then another sub area so it's very precise :) For example someone could find job adverts in United Kingdom, West Midlands, Sutton Coldfield, Mere Green.

Ultimate world list

iaine's picture

Unless some one is very kind, has done the work and open sourced it, such a list is highly unlikely to exist in one format or place.

You will also need to know the address rules for each country (for example post code towns in the UK that do not technically take counties although they may be given (e.g. Oxford, Cambridge, Bristol, London and so on)), alternative and older names for counties/admin regions), boundary changes if a new region is set up.

You might want to take a look at the data sources used by the Geonames website (http://www.geonames.org/data-sources.html and post links off there) and there are data dumps off their main page that you will need to manipulate yourself.

Or you could take a look at the GeoNames module (https://drupal.org/project/geonames) which may help you. I've not used it so YMMV.

Thank you Iain. It's final

spessex's picture

Thank you Iain. It's final use is for Hierarchical Select, so it takes the country, then the next viable area1, then area2 etc.

ISO codes

Two sources...

alarcombe's picture

Yahoo's geoplanet is, I believe, available as a free download. Failing that try geonames. Will try to find and post links later today.

Thanks everyone

spessex's picture

Thanks everyone