Penal Codes

Sonoran CAD allows you to customize your community's penal codes, charge type names, bond type names, and more!

Community customization is not included with the free version. For more information, see our pricing or view how to check your community limits.

What are penal codes?

Penal codes can easily be referenced and cited in records/reports as charges.

Sonoran CAD - Penal Code Reference Window

Sonoran CAD - Charges Section

1. Charge Types

You can create your own "Charge Type" options for penal codes. If your country does not have "felonies" you can edit or remove this option.

You can also use the "Auto Sort" feature to quickly format the order of these charge types.

Be sure to hit "Save" before exiting the page.

Sonoran CAD - Custom Charge Types

2. Bond Types

You can create your own "Bond'/Bail Type" options for penal codes. Again, if your country does not use these, you can edit or remove them as needed.

You can also use the "Auto Sort" feature to quickly format the order of these charge types.

Sonoran CAD - Custom Bond & Bail Types

3. Penal Codes

Adding, editing, or removing a penal code is easy. Simply click on the existing code to edit it, or press "New Penal Code" to create a new one.

Sonoran CAD - Penal Code Management

Sonoran CAD - Penal Code Editor

4. My locality doesn't call them "Penal Codes"

Sonoran CAD allows you to change the naming of "Penal Codes" to anything else you'd like. Learn more about our geographical customization.

Import from Spreadsheet (CSV)

Sonoran CAD allows you to easily import your penal codes from a spreadsheet (.CSV) file.

Spreadsheet (CSV) importing is only supported directly from Google sheets.

Support will not be provided to users modifying their spreadsheets with Excel, or any other program. The official Google sheet includes specific safety checks preventing invalid formats, blank spaces, etc.

1. Copy the Google Sheet

Navigate to our official penal code Google sheet and make a copy. Using a copy of our official sheet ensures your penal codes are formatted correctly.

You may ONLY use the Google sheet directly. Editing this via Excel or any other program is NOT supported.

Penal Codes - Copy Sheet

2. Add Your Penal Codes

Now that you have copied this sheet into your Google Drive, you can add new rows and format your penal codes.

Do NOT modify the very first row. These names must remain the same to properly format the penal code structure.

Additionally, the bondAmount column must be kept as a number. All other columns must be formatted as text.

3. Download the CSV

In Google Sheets, navigate to File > Download > Comma Separated Values (.csv) to download the file.

Google Sheets - Download CSV

4. Import the CSV File

In Sonoran CAD, navigate to Admin > Customization > Penal Codes

In the penal codes section, select the "Import" button. Then, select "CSV" as the import type and select your downloaded CSV file.

Sonoran CAD - Import Data

File Selector - Select File

After selecting the CSV file, your penal codes will be imported into the CAD and saved automatically.

Troubleshooting

Having issues importing your CSV? Be sure you are using and editing our Google Sheet with the Google Sheets program only.

Our Google sheet includes specific error checking and validation to handle common mistakes. Support is not provided if you are using Excel, or any other program.

Import from JSON

You can also build and format your penal codes directly into JSON. These JSON formatted penal codes can be sent via our API endpoint, or pasted directly into the UI for a more user-friendly experience.

1. Format the JSON Structure

The JSON structure is an object array. Be sure to strictly follow the format. All keys are strings, with the exception of bondAmount being a number.

[
        {
            "code": "(2)06",
            "type": "Felony",
            "title": "Armed Robbery",
            "bondType": "Federal Bail Bond",
            "jailTime": "5-10 Years",
            "bondAmount": 20000
        },
        {
            "code": "(2)07",
            "type": "Felony",
            "title": "Murder",
            "bondType": "Federal Bail Bond",
            "jailTime": "5-50 Years",
            "bondAmount": 100000
        }
    ]

2. Import the JSON Structure

In Sonoran CAD, navigate to Admin > Customization > Penal Codes

In the penal codes section, select the "Import" button. Then, select "JSON" and paste the JSON object array of penal codes.

Sonoran CAD - Import Data

Sonoran CAD - Paste JSON Content

After pasting the JSON content, your penal codes will be imported into the CAD and saved automatically.