Name: MPD Marijuana Arrests

Display Field: TYPE

Type: Table

Geometry Type: N/A

Description: In the District of Columbia, the laws related to the recreational use and possession of marijuana have changed at two milestones: the effective dates of the Marijuana Possession Decriminalization Amendment Act of 2014 on July 17, 2014, and of Initiative 71 on February 26, 2015 (https://mpdc.dc.gov/marijuana).

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: Marijuana Arrest Type, length: 100 )
• ADULT_JUVENILE ( type: esriFieldTypeString, alias: Adult/Juvenile, length: 50 )
• YEAR ( type: esriFieldTypeInteger, alias: Arrest Year )
• DATETIME ( type: esriFieldTypeDate, alias: Arrest Date/Time, length: 8 )
• CCN ( type: esriFieldTypeString, alias: CCN, length: 100 )
• AGE ( type: esriFieldTypeString, alias: Age, length: 15 )
• OFFENSE_DISTRICT ( type: esriFieldTypeString, alias: Offense Location District, length: 10 )
• OFFENSE_PSA ( type: esriFieldTypeString, alias: Offense Location PSA, length: 20 )
• OFFENSE_BLOCKX ( type: esriFieldTypeDouble, alias: Offense Location Block GEOX )
• OFFENSE_BLOCKY ( type: esriFieldTypeDouble, alias: Offense Location Block GEOY )
• DEFENDANT_PSA ( type: esriFieldTypeString, alias: Defendant PSA, length: 15 )
• 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 )
• ADDRESS ( type: esriFieldTypeString, alias: Arrest Location Block Address, length: 300 )
• ARREST_BLOCKX ( type: esriFieldTypeDouble, alias: Arrest Location Block GEOX )
• ARREST_BLOCKY ( type: esriFieldTypeDouble, alias: Arrest Location Block GEOY )
• 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 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )

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

  Iteminfo   Thumbnail   Metadata