Name: Juvenile Arrest

Display Field: TOP_CHARGE_DESC

Type: Table

Geometry Type: N/A

Description: This juvenile arrest report contains all arrests made by MPD and other law enforcement agencies of individuals 17 and under, excluding any arrests that have been expunged. Only the top charge (most serious charge) is reported for each arrest.The "Home PSA" of all arrests for which a valid District of Columbia address was given are provided. For all cases where the home address was outside the District of Columbia, the home address field was manually reviewed and marked as "OUT OF STATE". "UNKNOWN" is provided for cases where no address was reported.The "Crime/Arrest PSA" field contains the PSA associated with the original crime where the arrest record could be matched against the original crime report. For cases where the DC Moultrie Courthouse was indicated as the crime address (e.g., for Juvenile Custody Order, Failure to Appear, Fugitive from Justice, and Booking Order), "COURT" was listed as the crime PSA instead of PSA 102. For cases for which the Juvenile Processing Center (JPC) was indicated as the crime address, or for cases where other processing locations were listed as the crime address (e.g., District station or MPD Headquarters), "DISTRICT/JPC" was listed as the crime PSA . For arrest cases without proper crime incident address, it was assumed that the arrest was made at the site of the crime, and the PSA associated with the arrest location was provided.

Copyright Text: Metropolitan Police Department

Default Visibility: false

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Feature Draw Order:

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: true
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: false
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:

Fields:

• ARREST_DATE ( type: esriFieldTypeDate, alias: Arrest Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ARREST_DATE )
• TOP_CHARGE_DESC ( type: esriFieldTypeString, alias: Top Charge Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TOP_CHARGE_DESC )
• HOME_PSA ( type: esriFieldTypeString, alias: Home Police Service Area, editable: true, nullable: true, length: 255, defaultValue: null, modelName: HOME_PSA )
• CRIME_PSA ( type: esriFieldTypeString, alias: Crime Police Service Area, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CRIME_PSA )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )
• CREATED ( type: esriFieldTypeDate, alias: CREATED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CREATED )
• EDITED ( type: esriFieldTypeDate, alias: EDITED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EDITED )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )

Templates:

• Name: Juvenile Arrest
  Description:
  Prototype:
  EDITED: null
  ARREST_DATE: null
  TOP_CHARGE_DESC: null
  HOME_PSA: null
  CRIME_PSA: null
  CREATED: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:

Supported Operations:   Query   Query Analytic   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata