{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 38, "name": "MPD Adult Arrests", "type": "Table", "description": "This data includes adult arrests made by the Metropolitan Police Department (MPD). The information within this report pertains to reports entered into MPD\u2019s Record Management System (Cobalt) whereby an arrest occurred. Totals are based on the most serious arrest charge (i.e., each row denotes one arrest, not one charge), and one person may be booked on more than one arrest charge.", "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "TYPE", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "TYPE", "type": "esriFieldTypeString", "alias": "Arrestee Type", "length": 15, "domain": null }, { "name": "YEAR", "type": "esriFieldTypeInteger", "alias": "Arrest Year", "domain": null }, { "name": "DATE_", "type": "esriFieldTypeDate", "alias": "Arrest Date", "length": 8, "domain": null }, { "name": "HOUR", "type": "esriFieldTypeInteger", "alias": "Arrest Hour", "domain": null }, { "name": "CCN", "type": "esriFieldTypeString", "alias": "CCN", "length": 100, "domain": null }, { "name": "ARREST_NUMBER", "type": "esriFieldTypeString", "alias": "Arrest Number", "length": 100, "domain": null }, { "name": "AGE", "type": "esriFieldTypeInteger", "alias": "Age", "domain": null }, { "name": "DEFENDANT_PSA", "type": "esriFieldTypeString", "alias": "Defendant PSA", "length": 20, "domain": null }, { "name": "DEFENDANT_DISTRICT", "type": "esriFieldTypeString", "alias": "Defendant District", "length": 20, "domain": null }, { "name": "RACE", "type": "esriFieldTypeString", "alias": "Defendant Race", "length": 20, "domain": null }, { "name": "ETHNICITY", "type": "esriFieldTypeString", "alias": "Defendant Ethnicity", "length": 20, "domain": null }, { "name": "SEX", "type": "esriFieldTypeString", "alias": "Defendant Sex", "length": 10, "domain": null }, { "name": "CATEGORY", "type": "esriFieldTypeString", "alias": "Arrest Category", "length": 50, "domain": null }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "Charge Description", "length": 200, "domain": null }, { "name": "ARREST_PSA", "type": "esriFieldTypeString", "alias": "Arrest Location PSA", "length": 20, "domain": null }, { "name": "ARREST_DISTRICT", "type": "esriFieldTypeString", "alias": "Arrest Location District", "length": 10, "domain": null }, { "name": "ARREST_BLOCKX", "type": "esriFieldTypeDouble", "alias": "Arrest Block GEOX", "domain": null }, { "name": "ARREST_BLOCKY", "type": "esriFieldTypeDouble", "alias": "Arrest Block GEOY", "domain": null }, { "name": "OFFENSE_BLOCKY", "type": "esriFieldTypeDouble", "alias": "Offense Block GEOY", "domain": null }, { "name": "OFFENSE_BLOCKX", "type": "esriFieldTypeDouble", "alias": "Offense Block GEOX", "domain": null }, { "name": "OFFENSE_PSA", "type": "esriFieldTypeString", "alias": "Offense Location PSA", "length": 10, "domain": null }, { "name": "OFFENSE_DISTRICT", "type": "esriFieldTypeString", "alias": "Offense Location District", "length": 10, "domain": null }, { "name": "ARREST_LATITUDE", "type": "esriFieldTypeDouble", "alias": "Arrest Latitude", "domain": null }, { "name": "ARREST_LONGITUDE", "type": "esriFieldTypeDouble", "alias": "Arrest Longitude", "domain": null }, { "name": "OFFENSE_LATITUDE", "type": "esriFieldTypeDouble", "alias": "Offense Latitude", "domain": null }, { "name": "OFFENSE_LONGITUDE", "type": "esriFieldTypeDouble", "alias": "Offense Longitude", "domain": null }, { "name": "GIS_ID", "type": "esriFieldTypeString", "alias": "GIS Identifier", "length": 50, "domain": null }, { "name": "CREATOR", "type": "esriFieldTypeString", "alias": "CREATOR", "length": 255, "domain": null }, { "name": "CREATED", "type": "esriFieldTypeDate", "alias": "CREATED", "length": 8, "domain": null }, { "name": "EDITOR", "type": "esriFieldTypeString", "alias": "EDITOR", "length": 255, "domain": null }, { "name": "EDITED", "type": "esriFieldTypeDate", "alias": "EDITED", "length": 8, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null } ], "indexes": [ { "name": "R53769_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_53769", "fields": "GLOBALID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Data,Map,Query", "maxRecordCount": 1000, "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": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }