hierarchical location data - country, state, city/town

  • Status Closed
  • Budget $30 - $100 USD
  • Total Bids 7

Project 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.

Get free quotes for a project like this
Skills Required

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online