Dispatch Information - Sacramento Police Department

Dispatch Database

The Sacramento Police Department provides downloadable Computer Aided Dispatch (CAD) databases/text files. A CAD system is a highly specialized system that uses telecommunications and geographic display to support police dispatch and response functions. The police department's CAD System provides mission critical mapping capabilities for the 911 call center. The files available below represent annual calls for service received by the Sacramento Police Department, starting in 2006.

Helpful Code Definitions

City of Sacramento Maps

To download city maps showing the major streets, neighborhoods, EDP grids, districts, and beats, go to the Neighborhoods & Beats page

Dispatch Database

To use this database, please follow these instructions:

Click on the link for database you wish to download below.

When you see the following dialogue box, click on "Save."

Select a location on your computer to save the file.

Download any supporting information if desired (code list, definition lists, etc).

Go to the file location on your computer and open the database using the appropriate program from your computer (Microsoft Access or Excel, FoxPro, etc).

**.dbf format**
2010	January February March	April May June
2009	January February March	April May June	July August September	October November December
2008	January February March	April May June	July August September	October November December
2007	January February March	April May June	July August September	October November December
2006	January February March	April May June	July August September	October November December

**.txt format using comma delimited**
2010	January February March	April May June
2009	January February March	April May June	July August September	October November December
2008	January February March	April May June	July August September	October November December
2007	January February March	April May June	July August September	October November December
2006	January February March	April May June	July August September	October November December

Notes about the CAD database:

All calls for service are included in the database with a few exceptions. Calls are removed entirely from the database if they are deemed to be of an extremely sensitive nature. Internal administrative calls are removed as well (i.e., phone messages). Similarly, any calls that originally included confidential information, such as with child abuse, spousal abuse, and sex crimes, have had the confidential information blanked out.
The "Priority" field indicates a call's priority based on the nature of the information received at the time it was dispatched. The lower the priority number, the more urgent the call.
Not all calls require the response of a police officer. In an "All Units Broadcast" call, for example, the dispatcher notifies officers of the information in the call, but usually will not send units to respond.
CAD data does not necessarily equate with criminal activity. Throughout the day, officers respond to calls which don't meet the criteria of a crime report. This can include disturbance calls, keep-the-peace calls, subject stops and ringing alarm calls. Some calls which would indicate a specific crime, petty theft for example, could be cleared without a crime report if the responding officer determines the circumstances don't meet the crime's criteria. For a more detailed analysis of criminal activity, please visit the Crime Report database.
When the letters "UI" are present in the District, Beat, or Grid fields, that indicates the call originated outside of city limits.

Top of Page