View In:   ArcGIS Online Map Viewer

Name: Bike Crashes - Sept 2020 thru Aug 2025

Display Field: incident_id

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Traffic accidents in the City and County of Denver. The data is based on the National Incident Based Reporting System (NIBRS). The data is dynamic, which allows for additions, deletions and/or modifications at any time, resulting in more accurate information in the database. Due to continuous data entry, the number of records in subsequent extractions are subject to change. Accident data is updated Monday through Friday.

Service Item Id: e5a6111ac1ac4b899882c036bfb29cd5

Copyright Text: City and County of Denver, Denver Police Department / Data Analysis Unit and Technology Services / Business Applications Support

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 3114370.0000643893
YMin: 1653551.0001091284
XMax: 3214434.000067234
YMax: 1726723.0000903069
Spatial Reference: 103013  (6428)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [53, 84, 147, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: object_id, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• incident_id ( type: esriFieldTypeString, alias: incident_id, editable: true, nullable: true, length: 20, defaultValue: null, modelName: incident_id )
• offense_id ( type: esriFieldTypeString, alias: offense_id, editable: true, nullable: true, length: 20, defaultValue: null, modelName: offense_id )
• offense_code ( type: esriFieldTypeString, alias: offense_code, editable: true, nullable: true, length: 4, defaultValue: null, modelName: offense_code )
• offense_code_extension ( type: esriFieldTypeString, alias: offense_code_extension, editable: true, nullable: true, length: 4, defaultValue: null, modelName: offense_code_extension )
• top_traffic_accident_offense ( type: esriFieldTypeString, alias: top_traffic_accident_offense, editable: true, nullable: true, length: 30, defaultValue: null, modelName: top_traffic_accident_offense )
• first_occurrence_date ( type: esriFieldTypeDate, alias: first_occurrence_date, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: first_occurrence_date )
• last_occurrence_date ( type: esriFieldTypeDate, alias: last_occurrence_date, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: last_occurrence_date )
• reported_date ( type: esriFieldTypeDate, alias: reported_date, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: reported_date )
• incident_address ( type: esriFieldTypeString, alias: incident_address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: incident_address )
• geo_x ( type: esriFieldTypeInteger, alias: geo_x, editable: true, nullable: true, defaultValue: null, modelName: geo_x )
• geo_y ( type: esriFieldTypeInteger, alias: geo_y, editable: true, nullable: true, defaultValue: null, modelName: geo_y )
• geo_lon ( type: esriFieldTypeDouble, alias: geo_lon, editable: true, nullable: true, defaultValue: null, modelName: geo_lon )
• geo_lat ( type: esriFieldTypeDouble, alias: geo_lat, editable: true, nullable: true, defaultValue: null, modelName: geo_lat )
• district_id ( type: esriFieldTypeString, alias: district_id, editable: true, nullable: true, length: 10, defaultValue: null, modelName: district_id )
• precinct_id ( type: esriFieldTypeString, alias: precinct_id, editable: true, nullable: true, length: 4, defaultValue: null, modelName: precinct_id )
• neighborhood_id ( type: esriFieldTypeString, alias: neighborhood_id, editable: true, nullable: true, length: 100, defaultValue: null, modelName: neighborhood_id )
• bicycle_ind ( type: esriFieldTypeInteger, alias: bicycle_ind, editable: true, nullable: true, defaultValue: null, modelName: bicycle_ind )
• pedestrian_ind ( type: esriFieldTypeInteger, alias: pedestrian_ind, editable: true, nullable: true, defaultValue: null, modelName: pedestrian_ind )
• HARMFUL_EVENT_SEQ_1 ( type: esriFieldTypeString, alias: HARMFUL_EVENT_SEQ_1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: HARMFUL_EVENT_SEQ_1 )
• HARMFUL_EVENT_SEQ_2 ( type: esriFieldTypeString, alias: HARMFUL_EVENT_SEQ_2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: HARMFUL_EVENT_SEQ_2 )
• HARMFUL_EVENT_SEQ_3 ( type: esriFieldTypeString, alias: HARMFUL_EVENT_SEQ_3, editable: true, nullable: true, length: 255, defaultValue: null, modelName: HARMFUL_EVENT_SEQ_3 )
• road_location ( type: esriFieldTypeString, alias: road_location, editable: true, nullable: true, length: 255, defaultValue: null, modelName: road_location )
• ROAD_DESCRIPTION ( type: esriFieldTypeString, alias: ROAD_DESCRIPTION, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ROAD_DESCRIPTION )
• ROAD_CONTOUR ( type: esriFieldTypeString, alias: ROAD_CONTOUR, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ROAD_CONTOUR )
• ROAD_CONDITION ( type: esriFieldTypeString, alias: ROAD_CONDITION, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ROAD_CONDITION )
• LIGHT_CONDITION ( type: esriFieldTypeString, alias: LIGHT_CONDITION, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LIGHT_CONDITION )
• TU1_VEHICLE_TYPE ( type: esriFieldTypeString, alias: TU1_VEHICLE_TYPE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TU1_VEHICLE_TYPE )
• TU1_TRAVEL_DIRECTION ( type: esriFieldTypeString, alias: TU1_TRAVEL_DIRECTION, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TU1_TRAVEL_DIRECTION )
• TU1_VEHICLE_MOVEMENT ( type: esriFieldTypeString, alias: TU1_VEHICLE_MOVEMENT, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TU1_VEHICLE_MOVEMENT )
• TU1_DRIVER_ACTION ( type: esriFieldTypeString, alias: TU1_DRIVER_ACTION, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TU1_DRIVER_ACTION )
• TU1_DRIVER_HUMANCONTRIBFACTOR ( type: esriFieldTypeString, alias: TU1_DRIVER_HUMANCONTRIBFACTOR, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TU1_DRIVER_HUMANCONTRIBFACTOR )
• TU1_PEDESTRIAN_ACTION ( type: esriFieldTypeString, alias: TU1_PEDESTRIAN_ACTION, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TU1_PEDESTRIAN_ACTION )
• TU2_VEHICLE_TYPE ( type: esriFieldTypeString, alias: TU2_VEHICLE_TYPE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TU2_VEHICLE_TYPE )
• TU2_TRAVEL_DIRECTION ( type: esriFieldTypeString, alias: TU2_TRAVEL_DIRECTION, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TU2_TRAVEL_DIRECTION )
• TU2_VEHICLE_MOVEMENT ( type: esriFieldTypeString, alias: TU2_VEHICLE_MOVEMENT, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TU2_VEHICLE_MOVEMENT )
• TU2_DRIVER_ACTION ( type: esriFieldTypeString, alias: TU2_DRIVER_ACTION, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TU2_DRIVER_ACTION )
• TU2_DRIVER_HUMANCONTRIBFACTOR ( type: esriFieldTypeString, alias: TU2_DRIVER_HUMANCONTRIBFACTOR, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TU2_DRIVER_HUMANCONTRIBFACTOR )
• TU2_PEDESTRIAN_ACTION ( type: esriFieldTypeString, alias: TU2_PEDESTRIAN_ACTION, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TU2_PEDESTRIAN_ACTION )
• SERIOUSLY_INJURED ( type: esriFieldTypeInteger, alias: SERIOUSLY_INJURED, editable: true, nullable: true, defaultValue: null, modelName: SERIOUSLY_INJURED )
• FATALITIES ( type: esriFieldTypeInteger, alias: FATALITIES, editable: true, nullable: true, defaultValue: null, modelName: FATALITIES )
• FATALITY_MODE_1 ( type: esriFieldTypeString, alias: FATALITY_MODE_1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FATALITY_MODE_1 )
• FATALITY_MODE_2 ( type: esriFieldTypeString, alias: FATALITY_MODE_2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FATALITY_MODE_2 )
• SERIOUSLY_INJURED_MODE_1 ( type: esriFieldTypeString, alias: SERIOUSLY_INJURED_MODE_1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SERIOUSLY_INJURED_MODE_1 )
• SERIOUSLY_INJURED_MODE_2 ( type: esriFieldTypeString, alias: SERIOUSLY_INJURED_MODE_2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SERIOUSLY_INJURED_MODE_2 )
• POINT_X ( type: esriFieldTypeDouble, alias: POINT_X, editable: true, nullable: true, defaultValue: null, modelName: POINT_X )
• POINT_Y ( type: esriFieldTypeDouble, alias: POINT_Y, editable: true, nullable: true, defaultValue: null, modelName: POINT_Y )

Templates:

• Name: Bike Crashes - Sept 2020 thru Aug 2025
  Description:
  Prototype:
  POINT_X: null
  POINT_Y: null
  incident_id: null
  offense_id: null
  offense_code: null
  offense_code_extension: null
  top_traffic_accident_offense: null
  first_occurrence_date: null
  last_occurrence_date: null
  reported_date: null
  incident_address: null
  geo_x: null
  geo_y: null
  geo_lon: null
  geo_lat: null
  district_id: null
  precinct_id: null
  neighborhood_id: null
  bicycle_ind: null
  pedestrian_ind: null
  HARMFUL_EVENT_SEQ_1: null
  HARMFUL_EVENT_SEQ_2: null
  HARMFUL_EVENT_SEQ_3: null
  road_location: null
  ROAD_DESCRIPTION: null
  ROAD_CONTOUR: null
  ROAD_CONDITION: null
  LIGHT_CONDITION: null
  TU1_VEHICLE_TYPE: null
  TU1_TRAVEL_DIRECTION: null
  TU1_VEHICLE_MOVEMENT: null
  TU1_DRIVER_ACTION: null
  TU1_DRIVER_HUMANCONTRIBFACTOR: null
  TU1_PEDESTRIAN_ACTION: null
  TU2_VEHICLE_TYPE: null
  TU2_TRAVEL_DIRECTION: null
  TU2_VEHICLE_MOVEMENT: null
  TU2_DRIVER_ACTION: null
  TU2_DRIVER_HUMANCONTRIBFACTOR: null
  TU2_PEDESTRIAN_ACTION: null
  SERIOUSLY_INJURED: null
  FATALITIES: null
  FATALITY_MODE_1: null
  FATALITY_MODE_2: null
  SERIOUSLY_INJURED_MODE_1: null
  SERIOUSLY_INJURED_MODE_2: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata