Converting JSON To Feature Class

Question

I want to use arcpy to download a JSON file form "NoiseTube.net" and convert the file to a feature class. However, i'm finding it difficult to complete this task, since the json file does not contain "geometry" and "type" keys. I want to be assisted to complete my task. Attached, is my script

import arcpy
import os
from urllib import request
import json
import tempfile

url = "http://www.noisetube.net/users/11463/tracks/88383.json"
temp_dir = tempfile.mkdtemp()
filename = os.path.join(temp_dir, "Noise.json")
response = request.urlretrieve(url, filename)
json_file = open(filename)
json_raw = json.load(json_file)

arcpy.management.CreateFileGDB(r"Z:\ARCGIS", "Noisetube.gdb")
arcpy.env.workspace = r"Z:\ARCGIS\Noisetube.gdb"

Example of the JSON:

{"dataset":[{"lat":null,"lng":null,"db":"40.136","date":"2019-12-08T20:19:02Z","id":64386058},{"lat":5.1178671771186535,"lng":-1.2908399999892466,"db":"37.85","date":"2019-12-08T20:19:03Z","id":64386059},{"lat":5.1178671771186535,"lng":-1.2908399999892466,"db":"36.986","date":"2019-12-08T20:19:04Z","id":64386060},{"lat":5.1178671771186535,"lng":-1.2908399999892466,"db":"37.483","date":"2019-12-08T20:19:05Z","id":64386061}]}

Answer 1

Here is a script that reads in the json file and outputs a csv that can be imported into ArcMap. This is something that you will need to do frequently when dealing with json data as many sources won't be in geojson or esrijson.

import json
import csv

#read in json data
with open("data.json","r") as f:
    data = json.load(f)

#open output file
with open("noisedata.csv","w",newline="") as f:
    wtr = csv.writer(f,quoting=csv.QUOTE_NONNUMERIC)
    #build csv header row
    headers = data['dataset'][0].keys()
    wtr.writerow(headers)

    #iterate through items in json file
    for curr_item in data['dataset']:

        #check that all data elements are valid
        if curr_item['lat'] and curr_item['lng'] and curr_item['db'] and curr_item['date'] and curr_item['id']:
            #convert inputs
            curr_row = [float(curr_item['lat']),float(curr_item['lng']),float(curr_item['db']),
                curr_item['date'],curr_item['id']]
            #write current row to output file
            wtr.writerow(curr_row)