parse_oakland_public_art.py

#My Script except where noted#
import json
from pprint import pprint
#################################
#found this via google to help covert unicode string dict to a python dict
import ast
#found these lines and function via google to help covert unicode to string, also had "NoneType"
import sys
reload(sys)
sys.setdefaultencoding("utf-8")

#see comment above
def xstr(s):
    if s is None:
        return ''
    return str(s)
########################

def public_art_data():

    json_data=open('Oakland_Public_Art_raw.json')
    data_python = json.load(json_data)
    data =  data_python.get("data")
    
    public_art_dictionary = {}

    for item in data:
        project_title = xstr(item[8])
        year_install = int(0 if item[11] is None else item[11])
        permanent = xstr(item[12])
        exterior = xstr(item[13])
        media_type = xstr(item[14])
        media_detail = xstr(item[15])
        address_uni = item[16][0]
        address = ast.literal_eval(address_uni).get("address")
        city = ast.literal_eval(address_uni).get("city")
        state_code = ast.literal_eval(address_uni).get("state")
        zip_code = ast.literal_eval(address_uni).get("zip")
        latitude = float(item[16][1])
        longitude = float(item[16][2])

        public_art_dictionary[project_title] = {
            "year_install" : year_install,
            "permanent" : permanent,
            "exterior" : exterior,
            "media_type" : media_type,
            "media_detail" : media_detail,
            "address" : address,
            "city" : city,
            "state_code" : state_code,
            "zip_code" : zip_code,
            "latitude" : latitude,
            "longitude" : longitude,
        } 
    public_art_dictionary_json = json.dumps(public_art_dictionary)
    json_data.close()
    return public_art_dictionary_json