Skip to main content

​
What are penal codes?

Penal codes can easily be referenced and cited in records/reports as charges.Sonoran CAD - Penal Code Reference WindowSonoran 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

  1. 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

  1. 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 ManagementSonoran CAD - Penal Code Editor

  1. 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 Premade Spreadsheet (CSV)

We’ve compiled realistic, roleplay-focused penal code spreadsheets for all 50 US states and several popular international jurisdictions. Select a direct download below, then import the CSV into the CAD.
Australia and the United Kingdom do not have one uniform nationwide penal code. The premade Australian file is for New South Wales, and the UK file is for England and Wales.International files use local charge classifications and a Court Determined bail type. Review your Charge Types and Bond Types after importing.

​
Import from Customized 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

  1. 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.

  1. Download the CSV

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

  1. Import the CSV File

In Sonoran CAD, navigate to Admin > Customization > Penal CodesIn the penal codes section, select the “Import” button.
Then, select “CSV” as the import type and select your downloaded CSV file.Sonoran CAD - Import DataFile Selector - Select FileAfter selecting the CSV file, your penal codes will be imported into the CAD and saved automatically.
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.

  1. Import the JSON Structure

In Sonoran CAD, navigate to Admin > Customization > Penal CodesIn the penal codes section, select the “Import” button.
Then, select “JSON” and paste the JSON object array of penal codes.Sonoran CAD - Import DataSonoran CAD - Paste JSON ContentAfter pasting the JSON content, your penal codes will be imported into the CAD and saved automatically.