JSON to Google Sheets - Coordinate Extraction
Budget: $30 – $250 USD
I have three large JSON files containing lists object with coordinates. I need someone to:
- Extract the attributes of the object,
- Extract the list of Latitude and Longitude
- Format the data coordinates according to the structure: "boundary": [ { "lng": "<double>", "lat": "<double>" } ]
- Create separate sheets in a Google Sheet for each JSON file
Ideal candidates for this project should be proficient with handling JSON files, python and have experience with Google Sheets.
https://datosabiertos.bogota.gov.co/dataset/856cb657-8ca3-4ee8-857f-37211173b1f8/resource/497b8756-0927-4aee-8da9-ca4e32ca3a8a/download/loca.json
https://datosabiertos.bogota.gov.co/dataset/36a80ef3-02c1-4a48-b3c7-c285e1de4323/resource/ba69f395-13ed-4071-802d-3808e2ba9062/download/barriolegalizado.json
https://gist.githubusercontent.com/john-guerra/ee93225ca2c671b3550d62614f4978f3/raw/b1d556c39f3d7b6e495bf26b7fda815765ac110a/bogota_cadastral.json
- Extract the attributes of the object,
- Extract the list of Latitude and Longitude
- Format the data coordinates according to the structure: "boundary": [ { "lng": "<double>", "lat": "<double>" } ]
- Create separate sheets in a Google Sheet for each JSON file
Ideal candidates for this project should be proficient with handling JSON files, python and have experience with Google Sheets.
https://datosabiertos.bogota.gov.co/dataset/856cb657-8ca3-4ee8-857f-37211173b1f8/resource/497b8756-0927-4aee-8da9-ca4e32ca3a8a/download/loca.json
https://datosabiertos.bogota.gov.co/dataset/36a80ef3-02c1-4a48-b3c7-c285e1de4323/resource/ba69f395-13ed-4071-802d-3808e2ba9062/download/barriolegalizado.json
https://gist.githubusercontent.com/john-guerra/ee93225ca2c671b3550d62614f4978f3/raw/b1d556c39f3d7b6e495bf26b7fda815765ac110a/bogota_cadastral.json