Name: Stop Data

Display Field: CCN_ANONYMIZED

Type: Table

Geometry Type: N/A

Description: In July 2019, the Metropolitan Police Department (MPD) implemented new data collection methods that enabled officers to collect more comprehensive information about each police stop in an aggregated manner. More specifically, these changes have allowed for more detailed data collection on stops, protective pat down (PPDs), searches, and arrests. (For a complete list of terms, see the glossary on page 2.) These changes support data collection requirements in the Neighborhood Engagement Achieves Results Amendment Act of 2016 (NEAR Act).The accompanying data cover all MPD stops including vehicle, pedestrian, bicycle, and harbor stops for the period from July 22, 2019 to December 31, 2019. A stop may involve a ticket (actual or warning), investigatory stop, protective pat down, search, or arrest.

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:

• CCN_ANONYMIZED ( type: esriFieldTypeString, alias: CCN Anonymized, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CCN_ANONYMIZED )
• STOP_TYPE ( type: esriFieldTypeString, alias: Stop Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: STOP_TYPE )
• STOP_LOCATION_BLOCK ( type: esriFieldTypeString, alias: Stop Location Block, editable: true, nullable: true, length: 255, defaultValue: null, modelName: STOP_LOCATION_BLOCK )
• DATETIME ( type: esriFieldTypeDate, alias: Stop Date/Time, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATETIME )
• STOP_DISTRICT ( type: esriFieldTypeString, alias: Stop District, editable: true, nullable: true, length: 255, defaultValue: null, modelName: STOP_DISTRICT )
• STOP_DURATION_MINS ( type: esriFieldTypeDouble, alias: Stop Duration Minutes, editable: true, nullable: true, defaultValue: null, modelName: STOP_DURATION_MINS )
• STOP_REASON_NONTICKET ( type: esriFieldTypeString, alias: Stop Reason Nonticket, editable: true, nullable: true, length: 500, defaultValue: null, modelName: STOP_REASON_NONTICKET )
• STOP_REASON_HARBOR ( type: esriFieldTypeString, alias: Stop Reason Harbor, editable: true, nullable: true, length: 500, defaultValue: null, modelName: STOP_REASON_HARBOR )
• STOP_REASON_TICKET ( type: esriFieldTypeString, alias: Stop Reason Ticket, editable: true, nullable: true, length: 500, defaultValue: null, modelName: STOP_REASON_TICKET )
• PERSON_SEARCH_PAT_DOWN ( type: esriFieldTypeDouble, alias: Person Search or Protective Pat Down, editable: true, nullable: true, defaultValue: null, modelName: PERSON_SEARCH_PAT_DOWN )
• PROPERTY_SEARCH_PAT_DOWN ( type: esriFieldTypeDouble, alias: Property Search or Protective Pat Down, editable: true, nullable: true, defaultValue: null, modelName: PROPERTY_SEARCH_PAT_DOWN )
• PERSON_SEARCH_CONSENT ( type: esriFieldTypeDouble, alias: Person Search Consent, editable: true, nullable: true, defaultValue: null, modelName: PERSON_SEARCH_CONSENT )
• PERSON_SEARCH_PROB_CAUSE ( type: esriFieldTypeDouble, alias: Person Search Probable Cause, editable: true, nullable: true, defaultValue: null, modelName: PERSON_SEARCH_PROB_CAUSE )
• PERSON_PROT_PAT_DOWN ( type: esriFieldTypeDouble, alias: Person Protective Pat Down, editable: true, nullable: true, defaultValue: null, modelName: PERSON_PROT_PAT_DOWN )
• PERSON_SEARCH_WARRANT ( type: esriFieldTypeDouble, alias: Person Search Warrant, editable: true, nullable: true, defaultValue: null, modelName: PERSON_SEARCH_WARRANT )
• PROPERTY_SEARCH_CONSENT ( type: esriFieldTypeDouble, alias: Property Search Consent, editable: true, nullable: true, defaultValue: null, modelName: PROPERTY_SEARCH_CONSENT )
• PROPERTY_SEARCH_PROB_CAUSE ( type: esriFieldTypeDouble, alias: Property Search Probable Cause, editable: true, nullable: true, defaultValue: null, modelName: PROPERTY_SEARCH_PROB_CAUSE )
• PROPERTY_PROT_PAT_DOWN ( type: esriFieldTypeDouble, alias: Property Protective Pat Down, editable: true, nullable: true, defaultValue: null, modelName: PROPERTY_PROT_PAT_DOWN )
• PROPERTY_SEARCH_WARRANT ( type: esriFieldTypeDouble, alias: Property Search Warrant, editable: true, nullable: true, defaultValue: null, modelName: PROPERTY_SEARCH_WARRANT )
• PERSON_SEARCH_REA_CONSENT ( type: esriFieldTypeString, alias: Person Search Reason Consent, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PERSON_SEARCH_REA_CONSENT )
• PERSON_SRCH_PROB_CAUSE ( type: esriFieldTypeString, alias: Person Search Reason Probable Cause, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PERSON_SRCH_PROB_CAUSE )
• PERSON_PAT_DOWN_REASON ( type: esriFieldTypeString, alias: Person Protective Pat Down Reason, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PERSON_PAT_DOWN_REASON )
• PERSON_SRCH_REASON_WARRANT ( type: esriFieldTypeString, alias: Person Search Reason Warrant, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PERSON_SRCH_REASON_WARRANT )
• PROP_SRCH_REASON_CONSENT ( type: esriFieldTypeString, alias: Property Search Reason Consent, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PROP_SRCH_REASON_CONSENT )
• PROP_SRCH_PROB_CAUSE ( type: esriFieldTypeString, alias: Property Search Reason Probable Cause, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PROP_SRCH_PROB_CAUSE )
• PROP_PAT_DOWN_REASON ( type: esriFieldTypeString, alias: Property Protective Pat Down Reason, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PROP_PAT_DOWN_REASON )
• PROP_SRCH_REASON_WARRANT ( type: esriFieldTypeString, alias: Property Search Reason Warrant, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PROP_SRCH_REASON_WARRANT )
• PROPERTY_SRCH_OBJ_CONSENT ( type: esriFieldTypeString, alias: Property Search Object Consent, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PROPERTY_SRCH_OBJ_CONSENT )
• PROP_SRCH_OBJ_PROB_CAUSE ( type: esriFieldTypeString, alias: Property Search Object Probable Cause, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PROP_SRCH_OBJ_PROB_CAUSE )
• PROP_PAT_DOWN_OBJ ( type: esriFieldTypeString, alias: Property Protective Pat Down Object, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PROP_PAT_DOWN_OBJ )
• PROP_SRCH_OBJ_WARRANT ( type: esriFieldTypeString, alias: Property Search Object Warrant, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PROP_SRCH_OBJ_WARRANT )
• PERSON_SRCH_OBJ_SEIZED_CON ( type: esriFieldTypeString, alias: Person Search Object Seized Consent, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PERSON_SRCH_OBJ_SEIZED_CON )
• PERSON_SRCH_OBJ_PROB_CAUSE ( type: esriFieldTypeString, alias: Person Search Object Seized Probable Cause, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PERSON_SRCH_OBJ_PROB_CAUSE )
• PER_PRO_PAT_DOWN_OBJ_SEIZE ( type: esriFieldTypeString, alias: Person Protective Pat Down Object Seized, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PER_PRO_PAT_DOWN_OBJ_SEIZE )
• PERSON_SRCH_OBJ_SEIZED_WAR ( type: esriFieldTypeString, alias: Person Search Object Seized Warrant, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PERSON_SRCH_OBJ_SEIZED_WAR )
• PROP_SRCH_OBJ_SEIZE_CON ( type: esriFieldTypeString, alias: Property Search Object Seized Consent, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PROP_SRCH_OBJ_SEIZE_CON )
• PROP_SRCH_OBJ_SEIZE_CAUSE ( type: esriFieldTypeString, alias: Property Search Object Seized Probable Cause, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PROP_SRCH_OBJ_SEIZE_CAUSE )
• PROP_PAT_DOWN_OBJ_SEIZED ( type: esriFieldTypeString, alias: Property Protective Pat Down Object Seized, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PROP_PAT_DOWN_OBJ_SEIZED )
• PROP_SEARCH_OBJ_WARRANT ( type: esriFieldTypeString, alias: Property Search Object Seized Warrant, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PROP_SEARCH_OBJ_WARRANT )
• TICKETS_ISSUED ( type: esriFieldTypeString, alias: Tickets Issued, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TICKETS_ISSUED )
• WARNINGS_ISSUED ( type: esriFieldTypeString, alias: Warnings Issued, editable: true, nullable: true, length: 255, defaultValue: null, modelName: WARNINGS_ISSUED )
• VOIDED_TICKETS ( type: esriFieldTypeString, alias: Voided Tickets, editable: true, nullable: true, length: 255, defaultValue: null, modelName: VOIDED_TICKETS )
• TICKET_COUNT ( type: esriFieldTypeString, alias: Ticket Count, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TICKET_COUNT )
• WARNING_COUNT ( type: esriFieldTypeString, alias: Warning Count, editable: true, nullable: true, length: 255, defaultValue: null, modelName: WARNING_COUNT )
• VOID_COUNT ( type: esriFieldTypeString, alias: Void Count, editable: true, nullable: true, length: 255, defaultValue: null, modelName: VOID_COUNT )
• ARREST_CHARGES ( type: esriFieldTypeString, alias: Arrest Charges, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: ARREST_CHARGES )
• ARREST_CHARGES_CATEGORY ( type: esriFieldTypeString, alias: Arrest Charges Category, editable: true, nullable: true, length: 500, defaultValue: null, modelName: ARREST_CHARGES_CATEGORY )
• ARREST_DATE ( type: esriFieldTypeString, alias: Arrest Date, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ARREST_DATE )
• GENDER ( type: esriFieldTypeString, alias: Gender, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GENDER )
• ETHNICITY ( type: esriFieldTypeString, alias: Race Ethnicity, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ETHNICITY )
• AGE ( type: esriFieldTypeString, alias: Age, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AGE )
• VEHICLE ( type: esriFieldTypeDouble, alias: Vehicle Involved, editable: true, nullable: true, defaultValue: null, modelName: VEHICLE )
• BICYCLE_PMD ( type: esriFieldTypeDouble, alias: Bicycle/Personal Mobility Device Involved, editable: true, nullable: true, defaultValue: null, modelName: BICYCLE_PMD )
• PEDESTRIAN ( type: esriFieldTypeDouble, alias: Pedestrian Involved, editable: true, nullable: true, defaultValue: null, modelName: PEDESTRIAN )
• HARBOR ( type: esriFieldTypeDouble, alias: Initiated By Harbor Patrol, editable: true, nullable: true, defaultValue: null, modelName: HARBOR )
• INVESTIGATIVE ( type: esriFieldTypeDouble, alias: Temporary Investigative Detention, editable: true, nullable: true, defaultValue: null, modelName: INVESTIGATIVE )
• TRAFFIC_INVOLVED ( type: esriFieldTypeDouble, alias: Traffic Involved, editable: true, nullable: true, defaultValue: null, modelName: TRAFFIC_INVOLVED )
• TRAFFIC_ARREST ( type: esriFieldTypeInteger, alias: Traffic Arrest, editable: true, nullable: true, defaultValue: null, modelName: TRAFFIC_ARREST )
• NOI_REPORT_TYPE ( type: esriFieldTypeString, alias: Notice of Infraction Report Type, editable: true, nullable: true, length: 500, defaultValue: null, modelName: NOI_REPORT_TYPE )
• NOI_OFFICER_BUREAUS_TMA ( type: esriFieldTypeString, alias: The Bureau assignment of the officer issuing the Notice of Infraction , editable: true, nullable: true, length: 1000, defaultValue: null, modelName: NOI_OFFICER_BUREAUS_TMA )
• NOI_OFFICER_DIVISIONS_TMA ( type: esriFieldTypeString, alias: The Division assignment of the officer issuing the Notice of Infraction , editable: true, nullable: true, length: 1000, defaultValue: null, modelName: NOI_OFFICER_DIVISIONS_TMA )
• NOI_OFFICER_UNITS_TMA ( type: esriFieldTypeString, alias: The Unit assignment of the officer issuing the Notice of Infraction , editable: true, nullable: true, length: 1000, defaultValue: null, modelName: NOI_OFFICER_UNITS_TMA )
• NOI_OFFICER_PSAS_TMA ( type: esriFieldTypeString, alias: The PSA assignment of the officer issuing the Notice of Infraction , editable: true, nullable: true, length: 1000, defaultValue: null, modelName: NOI_OFFICER_PSAS_TMA )
• RMS_OFFICER_BUREAUS_TMA ( type: esriFieldTypeString, alias: The Bureau assignment of the report author, responding officer, assisting officer, and/or arresting officer(s) , editable: true, nullable: true, length: 1000, defaultValue: null, modelName: RMS_OFFICER_BUREAUS_TMA )
• RMS_OFFICER_DIVISONS_TMA ( type: esriFieldTypeString, alias: The Division assignment of the report author, responding officer, assisting officer, and/or arresting officer(s), editable: true, nullable: true, length: 1000, defaultValue: null, modelName: RMS_OFFICER_DIVISONS_TMA )
• RMS_OFFICER_UNITS_TMA ( type: esriFieldTypeString, alias: The Unit assignment of the report author, responding officer, assisting officer, and/or arresting officer(s), editable: true, nullable: true, length: 1000, defaultValue: null, modelName: RMS_OFFICER_UNITS_TMA )
• RMS_OFFICER_PSAS_TMA ( type: esriFieldTypeString, alias: The PSA assignment, if applicable, of the report author, responding officer, assisting officer, and/or arresting officer(s), editable: true, nullable: true, length: 1000, defaultValue: null, modelName: RMS_OFFICER_PSAS_TMA )
• 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 )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CREATED_DATE )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LAST_EDITED_DATE )

Templates:

• Name: Stop Data
  Description:
  Prototype:
  RMS_OFFICER_PSAS_TMA: null
  CCN_ANONYMIZED: null
  STOP_TYPE: null
  STOP_LOCATION_BLOCK: null
  DATETIME: null
  STOP_DISTRICT: null
  STOP_DURATION_MINS: null
  STOP_REASON_NONTICKET: null
  STOP_REASON_HARBOR: null
  STOP_REASON_TICKET: null
  PERSON_SEARCH_PAT_DOWN: null
  PROPERTY_SEARCH_PAT_DOWN: null
  PERSON_SEARCH_CONSENT: null
  PERSON_SEARCH_PROB_CAUSE: null
  PERSON_PROT_PAT_DOWN: null
  PERSON_SEARCH_WARRANT: null
  PROPERTY_SEARCH_CONSENT: null
  PROPERTY_SEARCH_PROB_CAUSE: null
  PROPERTY_PROT_PAT_DOWN: null
  PROPERTY_SEARCH_WARRANT: null
  PERSON_SEARCH_REA_CONSENT: null
  PERSON_SRCH_PROB_CAUSE: null
  PERSON_PAT_DOWN_REASON: null
  PERSON_SRCH_REASON_WARRANT: null
  PROP_SRCH_REASON_CONSENT: null
  PROP_SRCH_PROB_CAUSE: null
  PROP_PAT_DOWN_REASON: null
  PROP_SRCH_REASON_WARRANT: null
  PROPERTY_SRCH_OBJ_CONSENT: null
  PROP_SRCH_OBJ_PROB_CAUSE: null
  PROP_PAT_DOWN_OBJ: null
  PROP_SRCH_OBJ_WARRANT: null
  PERSON_SRCH_OBJ_SEIZED_CON: null
  PERSON_SRCH_OBJ_PROB_CAUSE: null
  PER_PRO_PAT_DOWN_OBJ_SEIZE: null
  PERSON_SRCH_OBJ_SEIZED_WAR: null
  PROP_SRCH_OBJ_SEIZE_CON: null
  PROP_SRCH_OBJ_SEIZE_CAUSE: null
  PROP_PAT_DOWN_OBJ_SEIZED: null
  PROP_SEARCH_OBJ_WARRANT: null
  TICKETS_ISSUED: null
  WARNINGS_ISSUED: null
  VOIDED_TICKETS: null
  TICKET_COUNT: null
  WARNING_COUNT: null
  VOID_COUNT: null
  ARREST_CHARGES: null
  ARREST_CHARGES_CATEGORY: null
  ARREST_DATE: null
  GENDER: null
  ETHNICITY: null
  AGE: null
  VEHICLE: null
  BICYCLE_PMD: null
  PEDESTRIAN: null
  HARBOR: null
  INVESTIGATIVE: null
  TRAFFIC_INVOLVED: null
  TRAFFIC_ARREST: null
  NOI_REPORT_TYPE: null
  NOI_OFFICER_BUREAUS_TMA: null
  NOI_OFFICER_DIVISIONS_TMA: null
  NOI_OFFICER_UNITS_TMA: null
  NOI_OFFICER_PSAS_TMA: null
  RMS_OFFICER_BUREAUS_TMA: null
  RMS_OFFICER_DIVISONS_TMA: null
  RMS_OFFICER_UNITS_TMA: 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