Open

Convert Large GeoJson file to mysql table -- 2

This project is ending today and has an average bid price of $28 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$10 - $30 USD
Total Bids
18
Project Description

There is a large geojson file that I need converted to a mysql table.

The file is here:

[url removed, login to view]

I would like the file converted to a mysql table with 3 columnns. The format of the table is as follows:

Column 1: auto-number, primary key (this data is not in the JSON file)

Column 2: zip code name - this is the value of the property ZCTA5CE10

Column 3: a TEXT field containing the entire GEOJSON element for that zip code, beginning with { "type": "Feature", and ending at the of the row: example: [ [url removed, login to view], [url removed, login to view] ] ] ] } }

The goal of this is to be able to use this mysql table to dynamically generate maps in Google maps using a subset of zipcodes of the entire GeoJson file.

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