# Police Department Stop Data

{% hint style="info" %}
Click [here](https://data.sfgov.org/Public-Safety/Police-Stops-Draft-2/ubqf-aqzw) to return to the dataset
{% endhint %}

## Overview

The Racial and Identity Profiling Act (RIPA), or [California Assembly Bill (AB)953](https://leginfo.legislature.ca.gov/faces/billNavClient.xhtml?bill_id=201520160AB953) was signed into law in October 2015. The bill requires law enforcement agencies to collect specific information on each stop, including elements of the stop, circumstances and the perceived identity characteristics of the individual(s) stopped. The information obtained by officers is reported to the California Department of Justice. Collection of these data begun on July 1st 2018 and is ongoing.

## How can this dataset be best used?

This dataset includes information about police stops that occurred, including stop date, time, duration, and general location, as well as some details about the person(s) stopped, why the person was stopped, and what happened during the stop. Each row is a person stopped with a record identifier for the stop and a unique identifier for the person. A single stop may involve multiple people and may produce more than one associated unique identifier for the same record identifier (e.g.: A vehicle stop with a driver and three passengers.) See below for an example of a stop involving 4 persons:

<figure><img src="https://3683435926-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLeAUyzrMeBX0cTZqyoQ0%2Fuploads%2Fgit-blob-3e21d332fd1700cc2feefd8e542a2eaf90470fa4%2Fimage.png?alt=media" alt=""><figcaption><p>An example of a single stop with 4 persons stopped.</p></figcaption></figure>

The information collected by officers can be used to help understand the number, location, reason for and outcomes of stops conducted by the San Francisco Police Department (SFPD). Geographic information is anonymized and provided to help understand stops conducted across neighborhoods, police and supervisorial districts. Provision of date information allows for analysis of data trends over time. Reasons for stop, search, and seizure, along with outcomes of any stop, search, or seizure, allow for additional analysis against time, geographic and perceived demographic data.

## What data is collected?

The department’s stop dataset provides counts of stops by type, date, time, and location. Department officers collect perceived detailed demographic information during pedestrian and traffic stops as required by the Racial and Identity Profiling (RIPA) Act of 2015 and associated stop data regulations. [View the stop data regulations,](https://oag.ca.gov/sites/all/files/agweb/pdfs/ripa/stop-data-reg-final-text-110717.pdf?) which guide data collection and define the elements included in the data set.

Dataset users should review the RIPA stop data [categories of information](https://oag.ca.gov/ab953/regulations#categories) an officer must collect for each stop to help assist with analysis. It is important to note that an officer’s perception of a person’s demographic identifiers (race/ethnicity, gender, LGBTQ, etc.) may differ from how the person self-identifies as officers are prohibited from asking the person stopped to self-identify their characteristics.

## What transformations have been applied to this dataset?

The SFPD conducts several transformations of this data to ensure privacy, accuracy and compliance with State law and regulation. These data transformations occur after data submission and includes data geocoding, PII cleaning processes and data transformations and joins for ease of use and readability.

#### Geocoding

By the end of each shift, officers enter all stop data into a Stop Data Collection System. The address fields are manually cleaned for mapping suitability. Addresses are geocoded to the nearest intersection. Instead of the uncoded free text that makes up the location in raw stops data, the Department has geocoded and added Location and District fields to this dataset. The location field will provide an anonymized location of the stop while the district field provides the police district of the stop location. Users are reminded that geographic information is anonymized and provided to help understand stops conducted across neighborhoods, police and supervisorial districts. A certain percentage of stops have stop information that can’t be geocoded. This may be due to errors in data input at the officer level (typos in entry or providing an address that doesn't exist). More often, this is due to officers providing a level of detail that isn't codable to a geographic coordinate - most often at the Airport (ie: Terminal 3, door 22.) In these cases, the location of the stops is coded as unknown.

#### Personally Identifiable Information

After the geocoding process is complete, the stops data file is formatted, and personally identifiable information is redacted from the narrative fields. Each narrative field is reviewed for names, addresses and juvenile terms.

#### Readability and ease of use

The dataset has also had readability and ease of use transformations applied to make the data easier and more useful to end users. These changes include:

* The dataset itself is 'de-pivoted' and 're-pivoted' to create a dataset that contains a single stopped individual per row. This is unlike the state dataset, in which a single row of data is a stop with all stopped individuals involved in a single row.
* The addition of a person number, unique id, perceived age group, neighborhood, CJIS offence code text, statute and type, traffic violation code text, statute and type, custodial arrest code text, statute and type, lat, long and point geocoding, data load time, data as of, and supervisor district columns.
* Fields in which more than one data element can be entered are delimited with a "|". See below

<figure><img src="https://3683435926-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLeAUyzrMeBX0cTZqyoQ0%2Fuploads%2Fgit-blob-7143ba4d2191c23f316a5c96202cbe109e5c8347%2Fimage%20(1).png?alt=media" alt=""><figcaption><p>3 selected basis for search in one search</p></figcaption></figure>

* The coding from numeral code to English as many columns as practical, to include perceived race/ethnicity, perceived gender, reason for stop, CJIS codes associated with stops, searches, and arrests, and others.
* Numerical coding is included in the data with columns ending in \_code.
* The Agency name field was removed because all stops listed were conducted by SFPD officers.
* A certain percentage of stops have stop information that can’t be geocoded. This may be due to errors in data input at the officer level (typos in entry or providing an address that doesn't exist). More often, this is due to officers providing a level of detail that isn't codeable to a geographic coordinate - most often at the Airport (ie: Terminal 3, door 22.) In these cases, the location of the stops is coded as unknown.

#### Other information

The SFPD seeks to mirror the CA DOJ’s release standards for RIPA data. The Reason for Stop Narrative, Basis for Stop Narrative, and personally identifiable information of officers is not published in the CA DOJ RIPA data and is also not included in this dataset.

The Agency name and the K-12 School name are fields published in the CA DOJ’s RIPA report but are not provided in this dataset. The K-12 School name is a field populated by the K-12 School Code field. Users may search the[ CA Department of Education’s School Directory](https://www.cde.ca.gov/schooldirectory) for a corresponding California school by using the K-12 School Code in the dataset.

## What is not captured in this dataset?

* Most, but not all, stops or individuals stopped are captured in this data. Various exceptions to data entry are outlined in the RIPA regulations, [noted here.](https://oag.ca.gov/sites/all/files/agweb/pdfs/ripa/stop-data-reg-final-text-110717.pdf)
* Demographic information pertaining to individual identity is based on officer perception rather than self-identification, and includes race/ethnicity, gender, age, LGBT identity, English fluency, and disability.
* This dataset does not include any personally identifiable information of officers conducting stops or of suspects stopped.
* The order in which actions are taken are not specifically captured. When multiple reasons for stop, search, etc are selected, these data do not delineate if all reasons occurred at the outset of the stop, or were developed over the course of the stop.
* This dataset does not capture other law enforcement agency stops within San Francisco (BART PD, US Park Police, for example.)

## What privacy controls are this data set subject to?

The release of this data must balance the need for disclosure to the public against the risk of violating the privacy of those individuals present within the dataset. All incident locations are shown at the intersection or 100 block level only. Some stops occur outside SFPD districts. These will be marked as “Out of SF” or “Unknown”. Per AB 953, law enforcement agencies are prohibited from reporting unique identifying information on persons stopped. Per GOV 12525.5, officer badge numbers and other Unique Identifying Information and are withheld from the dataset.

## Juvenile Data

The release of de-identified stop data on juveniles is included and is consistent with CA DOJ RIPA data releases.

## How is a “stop” defined?

The SFPD utilizes the RIPA program definitions under AB953: The Racial and Identity Profiling Act of 2015; a ‘[stop](https://leginfo.legislature.ca.gov/faces/billNavClient.xhtml?bill_id=201520160AB953)’ is defined as 1) any detention, as defined in regulations, by a peace officer of a person or 2) any peace officer interaction with a person in which the officer conducts a search as defined in regulation. Stops include Traffic Stops, Pedestrian Detentions, and may be Self-Initiated or Dispatched. There are some exceptions to this definition, as noted in the regulations.

## Can a stop have more than one person?

Yes. During a single encounter, multiple persons may be stopped. When multiple persons are stopped during one encounter, relevant information will be submitted for each person within the single report only under certain circumstances. For vehicle stops, for example, the following must be met for a passenger to be entered: (A): the passenger is observed or suspected of violating the Vehicle Code or any other applicable law or ordinance; or (B): excluding “Vehicle Impound” and “None”, the passenger is subjected to any data value actions identified in section 999.226, subdivision (a)(12)(A), “[Actions Taken by Officer During Stop](https://oag.ca.gov/sites/all/files/agweb/pdfs/ripa/stop-data-reg-final-text-110717.pdf?#page=10).”

## What are CJIS offense codes?

Criminal Justice Information System (CJIS) offense codes are a table of all state level offenses maintained by the California Department of Justice. These codes are used across multiple criminal justice applications, to standardize data entry for some data fields. Copies of the latest CJIS offense code tables can be found here: [Law Enforcement Code Tables | State of California - Department of Justice - Office of the Attorney General](https://oag.ca.gov/law/code-tables). This dataset utilizes the RIPA code table, posted at the above link.

## Data field definitions

Where data fields contain multiple datapoints due to officers having the option of picking more than one value, data is pipe delimited, ie: "|"

<table data-header-hidden data-full-width="true"><thead><tr><th width="208">Data Field</th><th width="248.33333333333331">Description/ Definition</th><th>Data values</th></tr></thead><tbody><tr><td><strong>Data field</strong></td><td><strong>Description/ Definition</strong></td><td><strong>Data values</strong></td></tr><tr><td>DOJ Record ID</td><td>A unique system- generated incident identification number.</td><td>Alpha-numeric</td></tr><tr><td>Person Number</td><td>System generated person identification number without DOJ record ID appended to it.</td><td>Alpha-numeric</td></tr><tr><td>Unique Identifier</td><td>DOJ Record ID and the system-generated person identification number</td><td>Alpha-numeric</td></tr><tr><td>Stop data record status</td><td>Status of stop data record in SDCS system</td><td><p>1 In-progress</p><p>2 Pending Review</p><p>3 Returned for Edits</p><p>4 Re-submitted to Reviewer</p><p>5 Completed – Successful Submission</p><p>6 Submitted with Errors/Incomplete</p><p>7 No Further Information Available</p><p>8 Deleted</p><p>9 Ready for Submission</p></td></tr><tr><td>lea_record_id</td><td>Local agency system tracking number (not used when utilizing state data system)</td><td>Alpha-numeric</td></tr><tr><td>Agency ORI</td><td>The number for the reporting Agency</td><td>Nine digit alpha-numeric</td></tr><tr><td>NFIA Flag</td><td>No Further Information Available Flag - this flag with “Y” value is only for those records that have been submitted with errors before (status 6) and the user wants to indicate that the records cannot be updated any further. That will change the status of the record to "7" or “No further information available” and no further updates will be applied/accepted to the record.</td><td>Y or blank</td></tr><tr><td>Stop Datetime</td><td>Date and time of stop</td><td>YYYY/MM/DD HH:MM:SS AM/PM</td></tr><tr><td>Duration of Stop</td><td>Duration of stop in minutes</td><td>Minute format</td></tr><tr><td>Is Stop Made in Response to Call for Service</td><td>Stop made in response to a call for Service</td><td>Y/N</td></tr><tr><td>Location</td><td>Location of stop (intersection, 100 block)</td><td>Alpha-numeric</td></tr><tr><td>District</td><td>Location of stop, by police district</td><td>Alpha-numeric</td></tr><tr><td>City</td><td>City location of stop</td><td>Alpha-numeric</td></tr><tr><td>Is Location a K-12 Public School</td><td>Stop on K-12 school grounds</td><td>Yes or Blank</td></tr><tr><td>K-12 School Code</td><td>School code</td><td>Fourteen-digit alpha-numeric<br>Blank</td></tr><tr><td>Perceived Race or Ethnicity</td><td>Perceived Race or Ethnicity of individual</td><td><p>One or more of the following:</p><p>1 = Asian<br>2 = Black/African American<br>3 = Hispanic/Latino(a)<br>4 = Middle Eastern or South Asian<br>5 = Native American<br>6 = Pacific Islander<br>7 = White<br>Any combination = Multi Racial</p><p>Blank = Unknown</p></td></tr><tr><td>Perceived Gender</td><td>Perceived gender description of person stopped.</td><td><p>1 = Male<br>2 = Female<br>3 = Transgender Man/Boy<br>4 = Transgender Woman/Girl</p><p>5 = Gender nonconforming<br>Blank = Unknown</p></td></tr><tr><td>Is LGBT</td><td>Person stopped perceived to be LGBT</td><td>No<br>Yes</td></tr><tr><td>Perceived Age</td><td>Perceived age of person stopped</td><td>Alpha-numeric</td></tr><tr><td>Perceived Age Group</td><td>Perceived age of person stopped categorized into groups</td><td><p>0 - Under 18</p><p>18 - 29</p><p>30 - 39</p><p>40 - 49</p><p>50 - 59</p><p>60 or over</p></td></tr><tr><td>Person had Limited or No English Fluency</td><td>Person stopped has limited or no English fluency</td><td>No<br>Yes</td></tr><tr><td>Perceived or Known Disability</td><td>Perceived or known disability of person stopped.</td><td><p>1 =Deafness or difficulty hearing,</p><p>2 = Speech Impairment or limited use of language,</p><p>3 = Blind or limited vision,</p><p>4 = Mental Health Condition,</p><p>5 = Intellectual or developmental disability, including dementia,</p><p>6 = Other,</p><p>7 = Hyperactivity or impulsive behavior,</p><p>8 = None</p><p>Any combination = Multiple Disability</p></td></tr><tr><td>If K-12 School, Is Stop of a Student</td><td>Stop of student</td><td>No<br>Yes</td></tr><tr><td>Reason for Stop</td><td>Reason for stop: description</td><td><p>1 = Traffic violation</p><p>2 = Reasonable suspicion that the person was engaged in criminal activity</p><p>3 = Known to be on parole/probation/PRCS/mandatory supervision</p><p>4 = Knowledge of outstanding arrest warrant/wanted person</p><p>5 = Investigation to determine if person is truant</p><p>6 = Consensual encounter and search</p><p>7 = Possible conduct warranting discipline under Education Code</p><p>8 = Determine if student violated school policy</p></td></tr><tr><td>Traffic Violation Type</td><td>Type of traffic violation</td><td>1 = Moving<br>2 = Equipment violation<br>3 = Non-moving, including registration<br>Blank</td></tr><tr><td>Traffic Violation - CJIS Offense Code</td><td>CJIS code related to traffic violation</td><td>CJIS offense table code<br>Blank</td></tr><tr><td>Traffic Violation Offense Code Text</td><td>Short text description of the CJIS code</td><td>CJIS offense table description<br>Blank</td></tr><tr><td>Traffic Violation Offense Statute</td><td>Statute linked to the CJIS Code</td><td>CJIS offense table violation statute<br>Blank</td></tr><tr><td>Traffic Violation Offense Type Statute Code</td><td>Traffic Offense Statute Type Code</td><td>2 letter code<br>(PC=Penal Code, VC=Vehicle Code, etc)<br>Blank</td></tr><tr><td>Traffic Violation Offense Type Charge</td><td>Charge Type per Statute Violation</td><td><p>F - Felony<br>M - Misdemeanor</p><p>I - Infraction</p><p>X - Other</p><p>Blank</p></td></tr><tr><td>Suspicion CJIS Offense Code</td><td>If known, code for suspicion</td><td>CJIS offense table code<br>Blank</td></tr><tr><td>Suspicion Offense Code Text</td><td>Short text description of the offense code</td><td>CJIS offense table description<br>Blank</td></tr><tr><td>Suspicion Offense Statute</td><td>Statute linked to the CJIS Code</td><td>CJIS offense table description<br>Blank</td></tr><tr><td>Suspicion Statute Type Code</td><td>Suspicion Statute Type Code</td><td>2 letter code<br>(PC=Penal Code, VC=Vehicle Code, etc)<br>Blank</td></tr><tr><td>Suspicion Type Charge</td><td>Charge Type per Statute Violation</td><td><p>F - Felony<br>M - Misdemeanor</p><p>I - Infraction</p><p>X - Other</p><p>Blank</p></td></tr><tr><td>Suspicion Sub-Type</td><td>Reasonable suspicion/Basis of Suspicion</td><td>1 Officer witnessed commission of a crime<br>2 Matched suspect description<br>3 Witness or victim identification of suspect at the scene<br>4 Carrying suspicious object<br>5 Actions indicative of casing a victim or location<br>6 Suspected of acting as a lookout<br>7 Actions indicative of a drug transaction<br>8 Actions indicative of engaging in a violent crime<br>9 Other reasonable suspicion of a crime<br>Blank</td></tr><tr><td>Education Code section</td><td>Section Code</td><td>1 48900 - Suspension or expulsion (select subsection)<br>2 48900.2 - Suspension or expulsion for sexual harassment<br>3 48900.3 - Suspension or expulsion for hate violence<br>4 48900.4 - Suspension or expulsion for harassment, threats or intimidation<br>5 48900.7 - Suspension or expulsion for terroristic threats<br>Blank</td></tr><tr><td>Education Code Subdivision</td><td>When EC 48900 is selected, specify the subdivision</td><td>1 48900(a)(1) - Caused/ attempted/ threatened to cause injury<br>2 48900(a)(2) - Used force or violence upon person<br>3 48900(b) - Possessed/sold/furnished a firearm, knife, explosive, etc.<br>4 48900(c) - Possessed/used/sold/furnished/under influence of intoxicant<br>5 48900(d) - Offered/arranged/negotiated to sell an intoxicant<br>6 48900(e) - Committed or attempted to commit robbery/extortion<br>7 48900(f) - Caused or attempted to cause damage to property<br>8 48900(g) - Stole or attempted to steal property<br>9 48900(h) - Possessed or used tobacco, or nicotine products<br>10 48900(i) - Committed an obscene act or engaged in profanity<br>11 48900(j) - Possess/offer/arrange/negotiate to sell drug paraphernalia<br>12 48900(k)(1) - Disrupted activities or willfully defied authority<br>13 48900(l) - Knowingly received stolen property<br>14 48900(m) - Possessed an imitation firearm<br>15 48900(n) - Commit/attempt sexual assault or sexual battery<br>16 48900(o) - Harassed, threatened, or intimidated a witness<br>17 48900(p) - Offered/arranged/negotiated to sell, or sold Soma<br>18 48900(q) - Engaged in, or attempted hazing<br>19 48900(r) - Engaged in bullying<br>Blank</td></tr><tr><td>Actions Taken</td><td>Action taken by officer during stop:</td><td><p>1 Person removed from vehicle by order<br>2 Person removed from vehicle by physical contact<br>3 Field sobriety test<br>4 Curbside detention<br>5 Handcuffed or flex cuffed<br>6 Patrol car detention<br>7 Canine removed search<br>8 Firearm pointed at person<br>9 Firearm discharged or used<br>10 Electronic device used<br>11 Impact projectile discharged or used (e.g. blunt impact projectile, rubber bullets, bean bags)<br>12 Canine bit or held person<br>13 Baton or other impact weapon used<br>14 Chemical spray use (pepper spray, mace, tear gas, or other chemical irritants)<br>15 Other physical or vehicle contact<br>16 Person photographed<br>17 Asked for consent to search person,</p><p>Consented or did not consent<br>18 Search of person was conducted<br>19 Asked for consent to search property</p><p>Consented or did not consent</p><p>20 Search of property was conducted<br>21 Property was seized<br>22 Vehicle impound<br>23 Admission or written statement obtained from student<br>24 None</p></td></tr><tr><td>Basis for Search</td><td>Basis of Search Description</td><td>1 Consent given<br>2 Officer safety/safety of others<br>3 Search warrant<br>4 Condition of parole/probation/PRCS/mandatory supervision<br>5 Suspected weapons<br>6 Visible contraband<br>7 Odor of contraband<br>8 Canine detection<br>9 Evidence of crime<br>10 Incident to arrest<br>11 Exigent circumstances<br>12 Vehicle inventory (for search property only)<br>13 Suspected violation of school policy<br>Blank</td></tr><tr><td>Basis for Property Seizure</td><td>Basis for Property Seizure Description</td><td>1 Safekeeping as allowed by law/statute<br>2 Contraband<br>3 Evidence<br>4 Impound of vehicle<br>5 Abandoned property<br>6 Suspected violation of school policy<br>Blank</td></tr><tr><td>Type of Property Seized</td><td>Type of Property Seized Description</td><td>1 Firearm<br>2 Ammunition<br>3 Weapon other than firearm<br>4 Drugs/narcotics<br>5 Alcohol<br>6 Money<br>7 Drug paraphernalia<br>8 Stolen property<br>9 Cellphone<br>10 Vehicle<br>11 Other contraband<br>Blank</td></tr><tr><td>Contraband or Evidence</td><td>Contraband or Evidence Discovered, if any</td><td>1 None<br>2 Firearm<br>3 Ammunition<br>4 Weapon<br>5 Drugs/narcotics<br>6 Alcohol<br>7 Money<br>8 Drug paraphernalia<br>9 Stolen property<br>10 Cell phone or electronic device<br>11 Other contraband or evidence<br>Blank</td></tr><tr><td>Results of Stop</td><td>Results of Stop</td><td>1 No action<br>2 Warning (verbal or written)<br>3 Citation<br>4 In field cite and release<br>5 Custodial pursuant to outstanding warrant<br>6 Custodial arrest without warrant<br>7 Field interview card completed<br>8 Noncriminal transport or caretaking transport (including transport by officer, transport by ambulance, or transport by another agency)<br>9 Contacted parent/legal guardian or other person responsible for minor<br>10 Psychiatric hold<br>11 Referred to US Department of Homeland Security (ICE)<br>12 Referral to school administrator<br>13 Referral to school counselor or other support staff<br>Blank</td></tr><tr><td>Warning CJIS Offense Code(s)</td><td>CJIS code(s) selected for warning</td><td>Five digit alpha-numeric<br>Blank</td></tr><tr><td>Warning Offense Code Text</td><td>Short text description of the offense code</td><td>CJIS offense table description<br>Blank</td></tr><tr><td>Warning Offense Code Statute</td><td>Statute linked to the CJIS Code</td><td>CJIS offense table description<br>Blank</td></tr><tr><td>Warning Offense Type Statute Code</td><td>Warning Statute Type Code</td><td>2 letter code<br>(PC=Penal Code, VC=Vehicle Code, etc)<br>Blank</td></tr><tr><td>Warning Type Charge</td><td>Charge Type per Statute Violation</td><td><p>F - Felony<br>M - Misdemeanor</p><p>I - Infraction</p><p>X - Other</p><p>Blank</p></td></tr><tr><td>Citation CJIS Offense Code(s)</td><td>CJIS code(s) selected for citation</td><td>Five digit alpha-numeric<br>Blank</td></tr><tr><td>Citation Offense Code Text</td><td>Short text description of the offense code</td><td>CJIS offense table description<br>Blank</td></tr><tr><td>Citation Offense Code Statute</td><td>Statute linked to the CJIS Code</td><td>CJIS offense table description<br>Blank</td></tr><tr><td>Citation Offense Type Statute Code</td><td>Citation Statute Type Code</td><td>2 letter code<br>(PC=Penal Code, VC=Vehicle Code, etc)<br>Blank</td></tr><tr><td>Citation Type Charge</td><td>Charge Type per Statute Violation</td><td><p>F - Felony<br>M - Misdemeanor</p><p>I - Infraction</p><p>X - Other</p><p>Blank</p></td></tr><tr><td>In-field cite and release CJIS Offense Code(s)</td><td>CJIS Code(s) selected for cite and release</td><td>Five digit alpha-numeric<br>Blank</td></tr><tr><td>In-field cite and release Offense Code Text</td><td>Short text description of the offense code</td><td>CJIS offense table description<br>Blank</td></tr><tr><td>In-field cite and release Offense Type Statute</td><td>Statute linked to the CJIS Code</td><td>CJIS offense table description<br>Blank</td></tr><tr><td>In-field cite and release Type Statute Code</td><td>In-Field cite and release Statute Type Code</td><td>2 letter code<br>(PC=Penal Code, VC=Vehicle Code, etc)<br>Blank</td></tr><tr><td>In-Field cite and release Type Charge</td><td>Charge Type per Statute Violation</td><td><p>F - Felony<br>M - Misdemeanor</p><p>I - Infraction</p><p>X - Other</p><p>Blank</p></td></tr><tr><td>Custodial arrest CJIS Offense Code(s)</td><td>CJIS code(s) selected for a Custodial Arrest</td><td>Five digit alpha-numeric<br>Blank</td></tr><tr><td>Custodial Arrest Offense Code Text</td><td>Short text description of the offense code</td><td>CJIS offense table description<br>Blank</td></tr><tr><td>Custodial Arrest Offense Type Statute</td><td>Statute linked to the CJIS Code</td><td>CJIS offense table description<br>Blank</td></tr><tr><td>Custodial Arrest Type Statute Code</td><td>Custodial Arrest Statute Type Code</td><td>2 letter code<br>(PC=Penal Code, VC=Vehicle Code, etc)<br>Blank</td></tr><tr><td>Custodial Arrest Type Charge</td><td>Charge Type per Statute Violation</td><td><p>F - Felony<br>M - Misdemeanor</p><p>I - Infraction</p><p>X - Other</p><p>Blank</p></td></tr><tr><td>Data as of</td><td>Date data last changed</td><td>Date<br>Blank</td></tr><tr><td>Data Loaded At</td><td>Date/time data was loaded</td><td>YYYYMMDD HHMMSS AM/PM</td></tr><tr><td>Longitude</td><td>Longitude coordinate</td><td>Numeric<br>Blank</td></tr><tr><td>Latitude</td><td>Latitude coordinate</td><td>Numeric<br>Blank</td></tr><tr><td>Point</td><td>Point coordinate values</td><td>Numeric<br>Blank</td></tr><tr><td>Supervisor District</td><td>Supervisorial district of location</td><td>Numeric (1 - 11)<br>Blank</td></tr><tr><td>Analysis Neighborhoods</td><td>Neighborhood</td><td>Text</td></tr><tr><td>Stop Data Record Status Code</td><td>Code for perceived race or ethnicity of person stopped</td><td><p>1 In-progress</p><p>2 Pending Review</p><p>3 Returned for Edits</p><p>4 Re-submitted to Reviewer</p><p>5 Completed – Successful Submission</p><p>6 Submitted with Errors/Incomplete</p><p>7 No Further Information Available</p><p>8 Deleted</p><p>9 Ready for Submission</p></td></tr><tr><td>Perceived Race Ethnicity Code</td><td>Code for perceived gender description of person stopped</td><td><p>One or more of the following:</p><p>1 = Asian<br>2 = Black/African American<br>3 = Hispanic/Latino(a)<br>4 = Middle Eastern or South Asian<br>5 = Native American<br>6 = Pacific Islander<br>7 = White</p><p>Blank = Unknown</p></td></tr><tr><td>Perceived Gender Code</td><td>Code for perceived gender description of person stopped</td><td><p>1 = Male<br>2 = Female<br>3 = Transgender Man/Boy<br>4 = Transgender Woman/Girl</p><p>5 = Gender nonconforming<br>Blank = Unknown</p></td></tr><tr><td>Perceived or Known Disability Code</td><td>Code for perceived or known disability of person stopped</td><td><p>1 Deafness or difficulty hearing,</p><p>2 Speech Impairment or limited use of language,</p><p>3 Blind or limited vision,</p><p>4 Mental Health Condition,</p><p>5 Intellectual or developmental disability, including dementia,</p><p>6 Other,</p><p>7 Hyperactivity or impulsive behavior,</p><p>8 None</p></td></tr><tr><td>Reason for Stop Code</td><td>Code for reason for stop</td><td><p>1 = Traffic violation</p><p>2 = Reasonable suspicion that the person was engaged in criminal activity</p><p>3 = Known to be on parole/probation/PRCS/mandatory supervision</p><p>4 = Knowledge of outstanding arrest warrant/wanted person</p><p>5 = Investigation to determine if person is truant</p><p>6 = Consensual encounter and search</p><p>7 = Possible conduct warranting discipline under Education Code</p><p>8 = Determine if student violated school policy</p></td></tr><tr><td>Traffic Violation Type Code</td><td>Code for type of traffic violation</td><td>1 = Moving<br>2 = Equipment violation<br>3 = Non-moving, including registration<br>Blank</td></tr><tr><td>Actions Taken Code</td><td>Code for actions taken by an officer during a stop</td><td><p>1 Person removed from vehicle by order<br>2 Person removed from vehicle by physical contact<br>3 Field sobriety test<br>4 Curbside detention<br>5 Handcuffed or flex cuffed<br>6 Patrol car detention<br>7 Canine removed search<br>8 Firearm pointed at person<br>9 Firearm discharged or used<br>10 Electronic device used<br>11 Impact projectile discharged or used (e.g. blunt impact projectile, rubber bullets, bean bags)<br>12 Canine bit or held person<br>13 Baton or other impact weapon used<br>14 Chemical spray use (pepper spray, mace, tear gas, or other chemical irritants)<br>15 Other physical or vehicle contact<br>16 Person photographed<br>17 Asked for consent to search person,</p><p>Y = yes / N = No<br>18 Search of person was conducted<br>19 Asked for consent to search property</p><p>Y = yes / N = No</p><p>20 Search of property was conducted<br>21 Property was seized<br>22 Vehicle impound<br>23 Admission or written statement obtained from student<br>24 None</p></td></tr><tr><td>Basis for Search Code</td><td>Code for basis for property seizure description</td><td>1 Consent given<br>2 Officer safety/safety of others<br>3 Search warrant<br>4 Condition of parole/probation/PRCS/mandatory supervision<br>5 Suspected weapons<br>6 Visible contraband<br>7 Odor of contraband<br>8 Canine detection<br>9 Evidence of crime<br>10 Incident to arrest<br>11 Exigent circumstances<br>12 Vehicle inventory (for search property only)<br>13 Suspected violation of school policy<br>Blank</td></tr><tr><td>Basis for Property Seizure Code</td><td>Code for basis for property seizure description</td><td>1 Safekeeping as allowed by law/statute<br>2 Contraband<br>3 Evidence<br>4 Impound of vehicle<br>5 Abandoned property<br>6 Suspected violation of school policy<br>Blank</td></tr><tr><td>Type of Property Seized Code</td><td>Code for type of property seized description</td><td>1 Firearm<br>2 Ammunition<br>3 Weapon other than firearm<br>4 Drugs/narcotics<br>5 Alcohol<br>6 Money<br>7 Drug paraphernalia<br>8 Stolen property<br>9 Cellphone<br>10 Vehicle<br>11 Other contraband<br>Blank</td></tr><tr><td>Contraband or Evidence Code</td><td>Code for contraband or evidence discovered, if any</td><td>1 None<br>2 Firearm<br>3 Ammunition<br>4 Weapon<br>5 Drugs/narcotics<br>6 Alcohol<br>7 Money<br>8 Drug paraphernalia<br>9 Stolen property<br>10 Cell phone or electronic device<br>11 Other contraband or evidence<br>Blank</td></tr><tr><td>Suspicion Sub Type Code</td><td>Code for reasonable suspicion/ basis of suspicion</td><td>1 Officer witnessed commission of a crime<br>2 Matched suspect description<br>3 Witness or victim identification of suspect at the scene<br>4 Carrying suspicious object<br>5 Actions indicative of casing a victim or location<br>6 Suspected of acting as a lookout<br>7 Actions indicative of a drug transaction<br>8 Actions indicative of engaging in a violent crime<br>9 Other reasonable suspicion of a crime<br>Blank</td></tr><tr><td>Results of Stop Code</td><td>Code for results of stop</td><td>1 No action<br>2 Warning (verbal or written)<br>3 Citation<br>4 In field cite and release<br>5 Custodial pursuant to outstanding warrant<br>6 Custodial arrest without warrant<br>7 Field interview card completed<br>8 Noncriminal transport or caretaking transport (including transport by officer, transport by ambulance, or transport by another agency)<br>9 Contacted parent/legal guardian or other person responsible for minor<br>10 Psychiatric hold<br>11 Referred to US Department of Homeland Security (ICE)<br>12 Referral to school administrator<br>13 Referral to school counselor or other support staff<br>Blank</td></tr></tbody></table>