{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 7, "name": "CMPD Officer-Involved Shootings - Individuals Table", "type": "Table", "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\nThe following is a complete list of OIS tables posted on the Charlotte Open Data Portal: 1) Officer Involved Shootings \u2013 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 \u2013 Individuals: contains INCIDENT_ID (for joining to other OIS tables) as well as individual\u2019s race, gender, age, and injury type 3) Officer Involved Shootings \u2013 Officers: contains INCIDENT_ID (for joining to other OIS tables) as well as officer\u2019s race, gender, years of service, and CMPD policy violation status \nPlease 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.", "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "INCIDENT_ID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ObjectID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "INCIDENT_ID", "type": "esriFieldTypeDouble", "alias": "Incident ID", "domain": null }, { "name": "INDIVIDUAL_RACE", "type": "esriFieldTypeString", "alias": "Individual Race", "length": 30, "domain": null }, { "name": "INDIVIDUAL_GENDER", "type": "esriFieldTypeString", "alias": "Individual Gender", "length": 10, "domain": null }, { "name": "INDIVIDUAL_AGE", "type": "esriFieldTypeDouble", "alias": "Individual Age", "domain": null }, { "name": "INDIVIDUAL_INJURY_TYPE", "type": "esriFieldTypeString", "alias": "Individual Injury Type", "length": 20, "domain": null }, { "name": "YR", "type": "esriFieldTypeInteger", "alias": "Year", "domain": null }, { "name": "Latitude", "type": "esriFieldTypeDouble", "alias": "Latitude", "domain": null }, { "name": "Longitude", "type": "esriFieldTypeDouble", "alias": "Longitude", "domain": null } ], "indexes": [ { "name": "R24_SDE_ROWID_UK", "fields": "ObjectID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }