Layer: Ped Bike Crashes 2005-2021 (ID:0)

View In: Map Viewer

Name: Ped Bike Crashes 2005-2021

Display Field: CID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"KABCO","uniqueValueInfos":[{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,0,0,255],"size":10,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"K","label":"K"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,170,0,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"A","label":"A"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,255,115,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"B","label":"B"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[163,255,115,255],"size":2,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"C","label":"C"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[85,255,0,255],"size":1,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"O","label":"O"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[227,252,210,255],"toColor":[227,252,210,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[233,179,252,255],"toColor":[233,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,184,182,255],"toColor":[252,184,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,228,252,255],"toColor":[182,228,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,212,243,255],"toColor":[252,212,243,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[187,197,252,255],"toColor":[187,197,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,252,244,255],"toColor":[182,252,244,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,225,192,255],"toColor":[252,225,192,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,252,209,255],"toColor":[182,252,209,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[180,252,179,255],"toColor":[180,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,248,184,255],"toColor":[252,248,184,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,187,235,255],"toColor":[252,187,235,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,212,213,255],"toColor":[252,212,213,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field:

Type ID Field: KABCO

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
CID (type: esriFieldTypeString, alias: Crash ID, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
NO_VEH (type: esriFieldTypeInteger, alias: Number Of Vehicles, SQL Type: sqlTypeOther, nullable: true, editable: true)
YEAR (type: esriFieldTypeInteger, alias: Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
DAYOFWEEK (type: esriFieldTypeString, alias: Day Of Week, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
KABCO (type: esriFieldTypeString, alias: KABCO, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
K (type: esriFieldTypeInteger, alias: Number Of Fatalities, SQL Type: sqlTypeOther, nullable: true, editable: true)
A (type: esriFieldTypeInteger, alias: Number of A Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
B (type: esriFieldTypeInteger, alias: Number of B Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
C (type: esriFieldTypeInteger, alias: Number of C Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
O (type: esriFieldTypeInteger, alias: Number of Persons with No Injury, SQL Type: sqlTypeOther, nullable: true, editable: true)
RT_NBR (type: esriFieldTypeString, alias: Route Number, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
INT_REL (type: esriFieldTypeInteger, alias: Intersection Related, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
FUNC_CLASS (type: esriFieldTypeInteger, alias: Functional Class, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Interstate], [2: Freeway and Expressway], [3: Other Principal Arterial], ... 15 more ...)
TWAY_CLASS (type: esriFieldTypeInteger, alias: Traffic Way Class, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unmarked Highway rural], [1: Controlled rural], [2: State numbered rural], ... 7 more ...)
TWAY_DESC (type: esriFieldTypeInteger, alias: Traffic Way Description, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Two Way: Not divided], [2: Two Way: Divided, with median barrier (not raised)], [3: Two Way: Divided, with median barrier], ... 20 more ...)
TCONT_DEV (type: esriFieldTypeInteger, alias: Traffic Control Device, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: No controls], [2: Stop sign], [3: Traffic signal], ... 17 more ...)
TCONT_CON (type: esriFieldTypeInteger, alias: Traffic Control Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: No controls], [2: Not functioning], [3: Functioning improperly], ... 6 more ...)
ALIGN (type: esriFieldTypeInteger, alias: Alignment Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Straight and level], [2: Straight on grade], [3: Straight on hillcrest], ... 5 more ...)
SURF_CON (type: esriFieldTypeInteger, alias: Surface Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Dry], [2: Wet], [3: Snow or slush], ... 5 more ...)
DEFECT (type: esriFieldTypeInteger, alias: Road Defects, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: No defects], [2: Construction zone], [3: Maintenance zone], ... 9 more ...)
LIGHT (type: esriFieldTypeInteger, alias: Light Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Daylight], [2: Dawn], [3: Dusk], ... 4 more ...)
WEATHER (type: esriFieldTypeInteger, alias: Weather Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Clear], [2: Rain], [3: Snow], ... 8 more ...)
COL_TYPE (type: esriFieldTypeInteger, alias: Collision Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Pedestrian], [2: Pedalcyclist], [3: Railway Train], ... 16 more ...)
CAUSE_1 (type: esriFieldTypeInteger, alias: Primary Cause, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Exceeding authorized speed limit], [2: Failing to yield right-of way], [3: Following too closely], ... 38 more ...)
CAUSE_2 (type: esriFieldTypeInteger, alias: Secondary Cause, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Exceeding authorized speed limit], [2: Failing to yield right-of way], [3: Following too closely], ... 38 more ...)
HIT_RUN (type: esriFieldTypeInteger, alias: Is Hit and Run, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
PROP_DESC1 (type: esriFieldTypeString, alias: Property Description 1, SQL Type: sqlTypeOther, length: 320, nullable: true, editable: true)
PROP_DESC2 (type: esriFieldTypeString, alias: Property Description 2, SQL Type: sqlTypeOther, length: 174, nullable: true, editable: true)
WZ_TYPE (type: esriFieldTypeInteger, alias: Work Zone Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Blank (Crash in Designated Work Zone was "No")], [2: Construction], [3: Maintenance], ... 3 more ...)
WZ_WORKER (type: esriFieldTypeInteger, alias: Workers Present, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
WZ_RELATED (type: esriFieldTypeInteger, alias: Work Zone Related, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
Pedestrian (type: esriFieldTypeInteger, alias: Pedestrian, SQL Type: sqlTypeOther, nullable: true, editable: true)
Pedalcyclist (type: esriFieldTypeInteger, alias: Pedalcyclist, SQL Type: sqlTypeOther, nullable: true, editable: true)
Younger_Driver__16_20_ (type: esriFieldTypeInteger, alias: Younger_Driver__16_20_, SQL Type: sqlTypeOther, nullable: true, editable: true)
Older_Driver__65__ (type: esriFieldTypeInteger, alias: Older_Driver__65__, SQL Type: sqlTypeOther, nullable: true, editable: true)
Unrestrained_Occupants (type: esriFieldTypeInteger, alias: Unrestrained_Occupants, SQL Type: sqlTypeOther, nullable: true, editable: true)
Impaired_Driver (type: esriFieldTypeInteger, alias: Impaired_Driver, SQL Type: sqlTypeOther, nullable: true, editable: true)
Distracted (type: esriFieldTypeInteger, alias: Distracted, SQL Type: sqlTypeOther, nullable: true, editable: true)
Fatigued_Driver (type: esriFieldTypeInteger, alias: Fatigued_Driver, SQL Type: sqlTypeOther, nullable: true, editable: true)
Distracted_Fatigued_Drowsy_Driv (type: esriFieldTypeInteger, alias: Distracted_Fatigued_Drowsy_Driver, SQL Type: sqlTypeOther, nullable: true, editable: true)
Speeding_Aggressive_Driver (type: esriFieldTypeInteger, alias: Speeding_Aggressive_Driver, SQL Type: sqlTypeOther, nullable: true, editable: true)
Speeding (type: esriFieldTypeInteger, alias: Speeding, SQL Type: sqlTypeOther, nullable: true, editable: true)
Aggressive_Driver (type: esriFieldTypeInteger, alias: Aggressive_Driver, SQL Type: sqlTypeOther, nullable: true, editable: true)
Wrong_Way_Driving (type: esriFieldTypeInteger, alias: Wrong_Way_Driving, SQL Type: sqlTypeOther, nullable: true, editable: true)
Roadway_Departure (type: esriFieldTypeInteger, alias: Roadway_Departure, SQL Type: sqlTypeOther, nullable: true, editable: true)
Highway_Railroad_Grade_Crossing (type: esriFieldTypeInteger, alias: Highway_Railroad_Grade_Crossings, SQL Type: sqlTypeOther, nullable: true, editable: true)
Work_Zone (type: esriFieldTypeInteger, alias: Work_Zone, SQL Type: sqlTypeOther, nullable: true, editable: true)
Animal (type: esriFieldTypeInteger, alias: Animal, SQL Type: sqlTypeOther, nullable: true, editable: true)
Heavy_Vehicle (type: esriFieldTypeInteger, alias: Heavy_Vehicle, SQL Type: sqlTypeOther, nullable: true, editable: true)
Motorcycle (type: esriFieldTypeInteger, alias: Motorcycle, SQL Type: sqlTypeOther, nullable: true, editable: true)
Intersection_Related (type: esriFieldTypeInteger, alias: Intersection_Related, SQL Type: sqlTypeOther, nullable: true, editable: true)
DATE (type: esriFieldTypeDate, alias: Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)

Types:

Field Name: INT_REL
Inherited
Field Name: FUNC_CLASS
Inherited
Field Name: TWAY_CLASS
Inherited
Field Name: TWAY_DESC
Inherited
Field Name: TCONT_DEV
Inherited
Field Name: TCONT_CON
Inherited
Field Name: ALIGN
Inherited
Field Name: SURF_CON
Inherited
Field Name: DEFECT
Inherited
Field Name: LIGHT
Inherited
Field Name: WEATHER
Inherited
Field Name: COL_TYPE
Inherited
Field Name: CAUSE_1
Inherited
Field Name: CAUSE_2
Inherited
Field Name: HIT_RUN
Inherited
Field Name: WZ_TYPE
Inherited
Field Name: WZ_WORKER
Inherited
Field Name: WZ_RELATED
Inherited

KABCO: K

Field Name: INT_REL
Inherited
Field Name: FUNC_CLASS
Inherited
Field Name: TWAY_CLASS
Inherited
Field Name: TWAY_DESC
Inherited
Field Name: TCONT_DEV
Inherited
Field Name: TCONT_CON
Inherited
Field Name: ALIGN
Inherited
Field Name: SURF_CON
Inherited
Field Name: DEFECT
Inherited
Field Name: LIGHT
Inherited
Field Name: WEATHER
Inherited
Field Name: COL_TYPE
Inherited
Field Name: CAUSE_1
Inherited
Field Name: CAUSE_2
Inherited
Field Name: HIT_RUN
Inherited
Field Name: WZ_TYPE
Inherited
Field Name: WZ_WORKER
Inherited
Field Name: WZ_RELATED
Inherited

KABCO: A

Field Name: INT_REL
Inherited
Field Name: FUNC_CLASS
Inherited
Field Name: TWAY_CLASS
Inherited
Field Name: TWAY_DESC
Inherited
Field Name: TCONT_DEV
Inherited
Field Name: TCONT_CON
Inherited
Field Name: ALIGN
Inherited
Field Name: SURF_CON
Inherited
Field Name: DEFECT
Inherited
Field Name: LIGHT
Inherited
Field Name: WEATHER
Inherited
Field Name: COL_TYPE
Inherited
Field Name: CAUSE_1
Inherited
Field Name: CAUSE_2
Inherited
Field Name: HIT_RUN
Inherited
Field Name: WZ_TYPE
Inherited
Field Name: WZ_WORKER
Inherited
Field Name: WZ_RELATED
Inherited

KABCO: B

Field Name: INT_REL
Inherited
Field Name: FUNC_CLASS
Inherited
Field Name: TWAY_CLASS
Inherited
Field Name: TWAY_DESC
Inherited
Field Name: TCONT_DEV
Inherited
Field Name: TCONT_CON
Inherited
Field Name: ALIGN
Inherited
Field Name: SURF_CON
Inherited
Field Name: DEFECT
Inherited
Field Name: LIGHT
Inherited
Field Name: WEATHER
Inherited
Field Name: COL_TYPE
Inherited
Field Name: CAUSE_1
Inherited
Field Name: CAUSE_2
Inherited
Field Name: HIT_RUN
Inherited
Field Name: WZ_TYPE
Inherited
Field Name: WZ_WORKER
Inherited
Field Name: WZ_RELATED
Inherited

KABCO: C

Field Name: INT_REL
Inherited
Field Name: FUNC_CLASS
Inherited
Field Name: TWAY_CLASS
Inherited
Field Name: TWAY_DESC
Inherited
Field Name: TCONT_DEV
Inherited
Field Name: TCONT_CON
Inherited
Field Name: ALIGN
Inherited
Field Name: SURF_CON
Inherited
Field Name: DEFECT
Inherited
Field Name: LIGHT
Inherited
Field Name: WEATHER
Inherited
Field Name: COL_TYPE
Inherited
Field Name: CAUSE_1
Inherited
Field Name: CAUSE_2
Inherited
Field Name: HIT_RUN
Inherited
Field Name: WZ_TYPE
Inherited
Field Name: WZ_WORKER
Inherited
Field Name: WZ_RELATED
Inherited

KABCO: O

Relationships:

Vehicle (0) -- Related To: Vehicle (7)
Person (1) -- Related To: Person (8)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/9/2023 5:55:58 PM

Schema Last Edit Date: 3/9/2023 5:55:58 PM

Data Last Edit Date: 3/9/2023 5:55:58 PM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Query Related Records Generate Renderer Validate SQL Get Estimates ConvertFormat