Name: CMPD Officer-Involved Shootings - Incidents Table
Display Field: INCIDENT_ID
Type: Table
Geometry Type: N/A
Description: An Officer Involved Shooting (OIS) is the discharge of a firearm, whether accidental or intentional, by a police officer, whether on or off duty. For the purposes of this posting, an OIS will only refer to the instances in which an officer discharged a firearm at a person. CMPD posts Officer Involved Shootings in an effort to create greater transparency of the actions of our employees. It is important to us that members of the community are informed whenever an officer discharges his/her firearm at a person and whether the shooting follows department policies and procedures. We believe that your trust and confidence in the Charlotte-Mecklenburg Police Department will increase as you understand what our officers encounter and how we hold them accountable for their actions. The CMPD is continuously reviewing and improving our practices to reduce the likelihood of deadly force incidents. For more information, please visit http://charlottenc.gov/CMPD/Pages/Resources/CMPD-OpenData.aspx
The following is a complete list of OIS tables posted on the Charlotte Open Data Portal: 1) Officer Involved Shootings – Incidents: contains INCIDENT_ID (for joining to other OIS tables), year and month recorded, location, district attorney legal review status, descriptive narrative of incident 2) Officer Involved Shootings – Individuals: contains INCIDENT_ID (for joining to other OIS tables) as well as individual’s race, gender, age, and injury type 3) Officer Involved Shootings – Officers: contains INCIDENT_ID (for joining to other OIS tables) as well as officer’s race, gender, years of service, and CMPD policy violation status
Please note that the relationship of the Incidents table to the Individuals table is one-to-many, and the relationship of the Incidents table to the Officers table is one-to-many.
Copyright Text: N/A
Default Visibility: false
MaxRecordCount: 2000
Supported Query Formats: JSON, PBF
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Extent:
Drawing Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field: null
Fields:
-
ObjectID
(
type: esriFieldTypeOID, alias: OBJECTID
)
-
INCIDENT_ID
(
type: esriFieldTypeDouble, alias: Incident ID
)
-
YEAR_MONTH
(
type: esriFieldTypeString, alias: Year - Month, length: 7
)
-
LOCATION
(
type: esriFieldTypeString, alias: Location, length: 100
)
-
DA_LEGAL_REVIEW
(
type: esriFieldTypeString, alias: DA Legal Review, length: 60
)
-
NARRATIVE
(
type: esriFieldTypeString, alias: Narrative, length: 2000
)
-
YR
(
type: esriFieldTypeInteger, alias: Year
)
-
MN
(
type: esriFieldTypeInteger, alias: Month
)
-
Latitude
(
type: esriFieldTypeDouble, alias: Latitude
)
-
Longitude
(
type: esriFieldTypeDouble, alias: Longitude
)
Supported Operations:
Query
Query Attachments
Query Analytic
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata