Name: MPD Adult Arrests

Display Field: TYPE

Type: Table

Geometry Type: N/A

Description: This data includes adult arrests made by the Metropolitan Police Department (MPD). The information within this report pertains to reports entered into MPD’s 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.

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• TYPE ( type: esriFieldTypeString, alias: Arrestee Type, length: 15 )
• YEAR ( type: esriFieldTypeInteger, alias: Arrest Year )
• DATE_ ( type: esriFieldTypeDate, alias: Arrest Date, length: 8 )
• HOUR ( type: esriFieldTypeInteger, alias: Arrest Hour )
• CCN ( type: esriFieldTypeString, alias: CCN, length: 100 )
• ARREST_NUMBER ( type: esriFieldTypeString, alias: Arrest Number, length: 100 )
• AGE ( type: esriFieldTypeInteger, alias: Age )
• DEFENDANT_PSA ( type: esriFieldTypeString, alias: Defendant PSA, length: 20 )
• DEFENDANT_DISTRICT ( type: esriFieldTypeString, alias: Defendant District, length: 20 )
• RACE ( type: esriFieldTypeString, alias: Defendant Race, length: 20 )
• ETHNICITY ( type: esriFieldTypeString, alias: Defendant Ethnicity, length: 20 )
• SEX ( type: esriFieldTypeString, alias: Defendant Sex, length: 10 )
• CATEGORY ( type: esriFieldTypeString, alias: Arrest Category, length: 50 )
• DESCRIPTION ( type: esriFieldTypeString, alias: Charge Description, length: 200 )
• ARREST_PSA ( type: esriFieldTypeString, alias: Arrest Location PSA, length: 20 )
• ARREST_DISTRICT ( type: esriFieldTypeString, alias: Arrest Location District, length: 10 )
• ARREST_BLOCKX ( type: esriFieldTypeDouble, alias: Arrest Block GEOX )
• ARREST_BLOCKY ( type: esriFieldTypeDouble, alias: Arrest Block GEOY )
• OFFENSE_BLOCKY ( type: esriFieldTypeDouble, alias: Offense Block GEOY )
• OFFENSE_BLOCKX ( type: esriFieldTypeDouble, alias: Offense Block GEOX )
• OFFENSE_PSA ( type: esriFieldTypeString, alias: Offense Location PSA, length: 10 )
• OFFENSE_DISTRICT ( type: esriFieldTypeString, alias: Offense Location District, length: 10 )
• ARREST_LATITUDE ( type: esriFieldTypeDouble, alias: Arrest Latitude )
• ARREST_LONGITUDE ( type: esriFieldTypeDouble, alias: Arrest Longitude )
• OFFENSE_LATITUDE ( type: esriFieldTypeDouble, alias: Offense Latitude )
• OFFENSE_LONGITUDE ( type: esriFieldTypeDouble, alias: Offense Longitude )
• GIS_ID ( type: esriFieldTypeString, alias: GIS Identifier, length: 50 )
• CREATOR ( type: esriFieldTypeString, alias: CREATOR, length: 255 )
• CREATED ( type: esriFieldTypeDate, alias: CREATED, length: 8 )
• EDITOR ( type: esriFieldTypeString, alias: EDITOR, length: 255 )
• EDITED ( type: esriFieldTypeDate, alias: EDITED, length: 8 )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata