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.

Penal codes can easily be referenced and cited in records/reports as charges.
Sonoran CAD - Penal Code Reference Window
Sonoran CAD - Charges Section

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

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

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

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

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.

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

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.

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

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.

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.

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.

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

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.
Copy link
Edit on GitHub
On this page
What are penal codes?
1. Charge Types
2. Bond Types
3. Penal Codes
4. My locality doesn't call them "Penal Codes"
Import from Spreadsheet (CSV)
1. Copy the Google Sheet
2. Add Your Penal Codes
3. Download the CSV
4. Import the CSV File
Troubleshooting
Import from JSON
1. Format the JSON Structure
2. Import the JSON Structure