sdot_json_to_csv.py

import os
import glob
import csv
import json

directory = 'Street Parking Category'
base = 'C:\\Users\\Avery\\Downloads\\'
working_path = os.path.join(base, directory)
csv_path =  os.path.join(base, directory + '.csv')
json_paths = glob.glob(os.path.join(working_path, '*.json'))
with open(csv_path, 'w', newline='') as csv_file:
    csv_writer = None
    for json_path in json_paths:
        json_root = None
        with open(json_path, 'r') as json_file:
            json_root = json.load(json_file)
        if (csv_writer is None):
            fields = json_root['fields']
            fieldnames = [field['name'] for field in fields]
            csv_writer = csv.DictWriter(csv_file, fieldnames)
            csv_writer.writeheader()
        features = json_root['features']
        for feature in features:
            attributes = feature['attributes']
            csv_writer.writerow(attributes)