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:

Default Visibility: false

MaxRecordCount: 1000

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

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
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:

• TYPE ( type: esriFieldTypeString, alias: Marijuana Arrest Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Marijuana_Arrest_Type )
• ADULT_JUVENILE ( type: esriFieldTypeString, alias: Adult/Juvenile, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ADULT_JUVENILE )
• YEAR ( type: esriFieldTypeInteger, alias: Arrest Year, editable: true, nullable: true, defaultValue: null, modelName: Arrest_Year )
• DATETIME ( type: esriFieldTypeDate, alias: Arrest Date/Time, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATETIME )
• CCN ( type: esriFieldTypeString, alias: CCN, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CCN )
• AGE ( type: esriFieldTypeString, alias: Age, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Age )
• OFFENSE_DISTRICT ( type: esriFieldTypeString, alias: Offense Location District, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Offense_Location_District )
• OFFENSE_PSA ( type: esriFieldTypeString, alias: Offense Location PSA, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Offense_Location_PSA )
• OFFENSE_BLOCKX ( type: esriFieldTypeDouble, alias: Offense Location Block GEOX, editable: true, nullable: true, defaultValue: null, modelName: Offense_Location_Block_GEOX )
• OFFENSE_BLOCKY ( type: esriFieldTypeDouble, alias: Offense Location Block GEOY, editable: true, nullable: true, defaultValue: null, modelName: Offense_Location_Block_GEOY )
• DEFENDANT_PSA ( type: esriFieldTypeString, alias: Defendant PSA, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Defendant_PSA )
• DEFENDANT_DISTRICT ( type: esriFieldTypeString, alias: Defendant District, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Defendant_District )
• RACE ( type: esriFieldTypeString, alias: Defendant Race, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Defendant_Race )
• ETHNICITY ( type: esriFieldTypeString, alias: Defendant Ethnicity, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Defendant_Ethnicity )
• SEX ( type: esriFieldTypeString, alias: Defendant Sex, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Defendant_Sex )
• CATEGORY ( type: esriFieldTypeString, alias: Arrest Category, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Arrest_Category )
• DESCRIPTION ( type: esriFieldTypeString, alias: Charge Description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Charge_Description )
• ADDRESS ( type: esriFieldTypeString, alias: Arrest Location Block Address, editable: true, nullable: true, length: 300, defaultValue: null, modelName: Arrest_Location_Block_Address )
• ARREST_BLOCKX ( type: esriFieldTypeDouble, alias: Arrest Location Block GEOX, editable: true, nullable: true, defaultValue: null, modelName: Arrest_Location_Block_GeoX )
• ARREST_BLOCKY ( type: esriFieldTypeDouble, alias: Arrest Location Block GEOY, editable: true, nullable: true, defaultValue: null, modelName: Arrest_Location_Block_GeoY )
• GIS_ID ( type: esriFieldTypeString, alias: GIS Identifier, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GIS_ID )
• 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 )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )

Templates:

• Name: MPD Marijuana Arrests
  Description:
  Prototype:
  EDITED: null
  TYPE: null
  ADULT_JUVENILE: null
  YEAR: null
  DATETIME: null
  CCN: null
  AGE: null
  OFFENSE_DISTRICT: null
  OFFENSE_PSA: null
  OFFENSE_BLOCKX: null
  OFFENSE_BLOCKY: null
  DEFENDANT_PSA: null
  DEFENDANT_DISTRICT: null
  RACE: null
  ETHNICITY: null
  SEX: null
  CATEGORY: null
  DESCRIPTION: null
  ADDRESS: null
  ARREST_BLOCKX: null
  ARREST_BLOCKY: null
  GIS_ID: 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:   Field Groups   Contingent Values

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