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}]}