hierarchical location data - country, state, city/town
- Status Closed
- Budget $30 - $100 USD
- Total Bids 7
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.Get free quotes for a project like this
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online