{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 3, "name": "Use of Force", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "incidentId", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "incidentId", "type": "esriFieldTypeString", "alias": "incidentId", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "incidentId" }, { "name": "handcuffsOnly", "type": "esriFieldTypeString", "alias": "handcuffsOnly", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "handcuffsOnly" }, { "name": "incidentType", "type": "esriFieldTypeString", "alias": "incidentType", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "incidentType" }, { "name": "incidentDate", "type": "esriFieldTypeDate", "alias": "incidentDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "incidentDate" }, { "name": "reasonForceEffectArrest", "type": "esriFieldTypeSmallInteger", "alias": "reasonForceEffectArrest", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "reasonForceEffectArrest" }, { "name": "reasonForceProtectSelf", "type": "esriFieldTypeSmallInteger", "alias": "reasonForceProtectSelf", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "reasonForceProtectSelf" }, { "name": "reasonForceProtectPublic", "type": "esriFieldTypeSmallInteger", "alias": "reasonForceProtectPublic", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "reasonForceProtectPublic" }, { "name": "reasonForcePreventEscape", "type": "esriFieldTypeSmallInteger", "alias": "reasonForcePreventEscape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "reasonForcePreventEscape" }, { "name": "reasonForceSeriousnessOfCrime", "type": "esriFieldTypeSmallInteger", "alias": "reasonForceSeriousnessOfCrime", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "reasonForceSeriousnessOfCrime" }, { "name": "reasonForcePrevCommOfOffense", "type": "esriFieldTypeSmallInteger", "alias": "reasonForcePrevCommOfOffense", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "reasonForcePrevCommOfOffense" }, { "name": "reasonForceArrest", "type": "esriFieldTypeSmallInteger", "alias": "reasonForceArrest", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "reasonForceArrest" }, { "name": "reasonForceAssaultingOfficer", "type": "esriFieldTypeSmallInteger", "alias": "reasonForceAssaultingOfficer", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "reasonForceAssaultingOfficer" }, { "name": "reasonForceCaretakerRole", "type": "esriFieldTypeSmallInteger", "alias": "reasonForceCaretakerRole", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "reasonForceCaretakerRole" }, { "name": "reasonForceOther", "type": "esriFieldTypeSmallInteger", "alias": "reasonForceOther", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "reasonForceOther" }, { "name": "reasonForceAssaultingCitizen", "type": "esriFieldTypeSmallInteger", "alias": "reasonForceAssaultingCitizen", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "reasonForceAssaultingCitizen" }, { "name": "suspectCount", "type": "esriFieldTypeSmallInteger", "alias": "suspectCount", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "suspectCount" }, { "name": "suspectId", "type": "esriFieldTypeString", "alias": "suspectId", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "suspectId" }, { "name": "suspectOrdinal", "type": "esriFieldTypeSmallInteger", "alias": "suspectOrdinal", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "suspectOrdinal" }, { "name": "officerResponse", "type": "esriFieldTypeString", "alias": "officerResponse", "domain": null, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "officerResponse" }, { "name": "officerResponseRank", "type": "esriFieldTypeSmallInteger", "alias": "officerResponseRank", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "officerResponseRank" }, { "name": "city", "type": "esriFieldTypeString", "alias": "city", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "city" }, { "name": "state", "type": "esriFieldTypeString", "alias": "state", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "state" }, { "name": "zip", "type": "esriFieldTypeString", "alias": "zip", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "zip" }, { "name": "label", "type": "esriFieldTypeString", "alias": "label", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "label" }, { "name": "fips", "type": "esriFieldTypeString", "alias": "fips", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "fips" }, { "name": "censusTract", "type": "esriFieldTypeString", "alias": "censusTract", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "censusTract" }, { "name": "beat", "type": "esriFieldTypeString", "alias": "beat", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "beat" }, { "name": "pin", "type": "esriFieldTypeString", "alias": "pin", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "pin" }, { "name": "year", "type": "esriFieldTypeSmallInteger", "alias": "year", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "year" }, { "name": "month", "type": "esriFieldTypeSmallInteger", "alias": "month", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "month" }, { "name": "day", "type": "esriFieldTypeSmallInteger", "alias": "day", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "day" }, { "name": "time", "type": "esriFieldTypeSmallInteger", "alias": "time", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "time" }, { "name": "suspectRace", "type": "esriFieldTypeString", "alias": "suspectRace", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "suspectRace" }, { "name": "suspectGender", "type": "esriFieldTypeString", "alias": "suspectGender", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "suspectGender" }, { "name": "suspectInjured", "type": "esriFieldTypeString", "alias": "suspectInjured", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "suspectInjured" }, { "name": "suspectActPres", "type": "esriFieldTypeSmallInteger", "alias": "suspectActPres", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "suspectActPres" }, { "name": "suspectActPasvRes", "type": "esriFieldTypeSmallInteger", "alias": "suspectActPasvRes", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "suspectActPasvRes" }, { "name": "suspectActVerbRes", "type": "esriFieldTypeSmallInteger", "alias": "suspectActVerbRes", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "suspectActVerbRes" }, { "name": "suspectActActAggr", "type": "esriFieldTypeSmallInteger", "alias": "suspectActActAggr", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "suspectActActAggr" }, { "name": "suspectActAggrPhys", "type": "esriFieldTypeSmallInteger", "alias": "suspectActAggrPhys", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "suspectActAggrPhys" }, { "name": "suspectActAgvdPhys", "type": "esriFieldTypeSmallInteger", "alias": "suspectActAgvdPhys", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "suspectActAgvdPhys" } ], "indexes": [ { "name": "R29_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "respectsDaylightSaving": false }, "preferredTimeReference": { "timeZone": "Central Standard Time", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Use of Force", "description": "", "prototype": { "attributes": { "suspectActAggrPhys": null, "suspectActAgvdPhys": null, "incidentId": null, "handcuffsOnly": null, "incidentType": null, "incidentDate": null, "reasonForceEffectArrest": null, "reasonForceProtectSelf": null, "reasonForceProtectPublic": null, "reasonForcePreventEscape": null, "reasonForceSeriousnessOfCrime": null, "reasonForcePrevCommOfOffense": null, "reasonForceArrest": null, "reasonForceAssaultingOfficer": null, "reasonForceCaretakerRole": null, "reasonForceOther": null, "reasonForceAssaultingCitizen": null, "suspectCount": null, "suspectId": null, "suspectOrdinal": null, "officerResponse": null, "officerResponseRank": null, "city": null, "state": null, "zip": null, "label": null, "fips": null, "censusTract": null, "beat": null, "pin": null, "year": null, "month": null, "day": null, "time": null, "suspectRace": null, "suspectGender": null, "suspectInjured": null, "suspectActPres": null, "suspectActPasvRes": null, "suspectActVerbRes": null, "suspectActActAggr": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "96175f6241f14c6c8583f7ea8b9d7918" }