JSON Files and How to Edit them

The .json files are located under the config folder.

Use any text editor of your choice. I use Atom

A .json file might look something like this:

{
    "header": [
        "Month",
        "Calendar Year",
        "Land Class",
        "Land Category",
        "Commodity",
        "Volume"
    ],
    "unit_dict": {
        "Gas Prod Vol": [
            "mcf"
        ],
        "Oil Prod Vol": [
            "bbl"
        ],
        "Coal Prod Vol": [
            "ton"
        ],
        "Geothermal - Electrical Generation": [
            "Kilowatt Hours",
            "Other",
            "Thousands of Pounds"
        ]
    },
    "field_dict": {
        "Land Class": [
            "Native American",
            "Federal"
        ],
        "Land Category": [
            "Onshore",
            "Offshore"
        ]
    },
    "replace_dict": {
        "Mining-Unspecified": "Humate"
    },
    "na_check": [
        "Calendar Year",
        "Corperate Name",
        "Ficsal Year",
        "Mineral Lease Type",
        "Month",
        "Onshore/Offshore",
        "Volume"
    ],
    "threshold": {
        "Coal Prod Vol (ton)": [
            -31596802.14262197,
            66350921.44337984
        ],
        "Gas Prod Vol (mcf)": [
            -194287369.27883062,
            502825436.1639794
        ],
        "Oil Prod Vol (bbl)": [
            -35782517.023709275,
            77050385.9023059
        ]
    }
}

Notes:

• Separate each entry by a comma
• Words are always in quotes

header -- Put Field Names you want it to check for. Order matters

"header": [
    "Month", 
    "Calendar Year",
    "Land Class", 
    "Land Category", 
    "Commodity", 
    "Volume"
]

unit_dict -- Name of Item first, then a list of units enclosed in square brackets

"unit_dict": {
    "Geothermal - Electrical Generation": [
        "Kilowatt Hours",
        "Other",
        "Thousands of Pounds"
    ],
    "Gas": [
        "mcf"
    ]
}

field_dict -- Name of the field and any acceptable entries enclosed in square brackets

"field_dict": {
    "Offshore Region": [
        "Offshore Gulf",
        "Offshore Alaska",
        "Offshore Pacific"
    ],
}

replace_dict -- (Commodity Only) The Item you want to replace followed by the entry to replace it with

["Item_to_replace": "Replacement_Value"]

na_check -- Put columns you want to check for Blank Entries. Can be in any order

threshold -- Minimum and maximum values for threshold