hierarchical location data - country, state, city/town

Cancelled

Description

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.

Skills: Data Entry, Data Processing

See more: 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

Project ID: #173970

7 freelancers are bidding on average $37 for this job

uniiversesoft

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 in 1 day
(7 Reviews)
3.6
sejalshah

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

$30 USD in 2 days
(2 Reviews)
2.7
kalpsadit

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

$60 USD in 7 days
(0 Reviews)
0.0
NikolinaJ

I can do this

$50 USD in 7 days
(0 Reviews)
0.0
gnvlavanya

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

$30 USD in 6 days
(0 Reviews)
0.0
blajovan

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 days
(0 Reviews)
0.0
earnnavas

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

$30 USD in 5 days
(0 Reviews)
0.0