hierarchical location data - country, state, city/town

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.

Habilidades: Processamento de Dados, Processamento de dados

Veja mais: csv file country city town, hierarchy database country state city, australia country state city hierarchy, location data country state, united data processing data entry, sydney new south wales, new south wales sydney, new south wales australia, new south wales, all state, country state town county, state country world csv, sydney data entry, Wales, united state, united kingdom, towns, state, South Australia , scotland, parent, numerical solution, longitude, latitude, kingdom

Acerca do Empregador:
( 14 comentários ) London, United Kingdom

ID do Projeto: #173970

7 freelancers estão ofertando em média $37 para esse trabalho


Dear Sir, Greetings!!! We are ready to this job right now. Please refer PM for more details. Regards, Shrinivas.P. Uniiverse Soft Tech, India.

$30 USD em 1 dia
(7 Comentários)

dear sir/madam, please have a glance at pmb.

$30 USD in 2 dias
(2 Comentários)

I am available in any moment at your service. Thanks. I bid for your minimum ammount per hour. I can work 8 hours per day. I'd do my best. Thanks.

$30 USD in 100 dias
(0 Comentários)

Sir, I am ready to start on this project. gnvlavanya.

$30 USD in 6 dias
(0 Comentários)

Sir , I am interesting this type of job , I will do with in turn around time with Quality .

$30 USD in 5 dias
(0 Comentários)

I can do this

$50 USD in 7 dias
(0 Comentários)

Hi, I'm good at research and dataentry and can give quality work.

$60 USD in 7 dias
(0 Comentários)