I require a spreadsheet (csv) that contains all of the countries in the world, states/counties/regions of those countries, and cities/towns within those states/counties with a population of over 20,000 - plus the latitude/longitude of those towns/cities
Further drill-down is required for United Kingdom - to include the towns in the attached .csv file, their longitude/latitude details but their population isn't required.
the spreadsheet should be in the following format
column 1: id
column 2: name
column 4: population
column 5: latitude (for city/town)
column 6: longitude (for city/town)
column 7: parent id
id should be numerical and increase sequentially from 1. Entries should be added alphabetically.
All cities/towns should ensure they are put into the right state/county/region.
the parent ID is used to indicate the hierarchy e.g. if Australia has the ID= 13 and New South Wales has the ID=57 then Sydney's parent ID is 13.
United Kingdom should be split into its three countries: england, scotland, northern ireland.
Data should be checked carefully for errors, I would prefer a solution that takes the data from a geo-database, please mention this in your bid.