View In:   ArcGIS Online Map Viewer

Name: FPGISAcademy.DBO.sprovan_bikecollisions2022

Display Field: incident_id

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>All bike crashes recorded in the City of Denver in 2022.</SPAN></P></DIV></DIV></DIV>

Service Item Id: e698a8ceb3524a08b7ae2217cf213a7d

Copyright Text: Derivative of City and County of Denver Open Data - CRIME_TRAFFICACCIDENTS5YR_P

Default Visibility: true

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: 3117783.00012806
YMin: 1654049.0000973043
XMax: 3208830.0001202957
YMax: 1717779.9999316481
Spatial Reference: 103013  (6428)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [47, 175, 71, 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: OBJECTID, 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, modelName: first_occurrence_date )
• last_occurrence_date ( type: esriFieldTypeDate, alias: last_occurrence_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_occurrence_date )
• reported_date ( type: esriFieldTypeDate, alias: reported_date, editable: true, nullable: true, length: 8, defaultValue: null, 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: FPGISAcademy.DBO.sprovan_bikecollisions2022
  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