Layer: Bike Crashes (ID:1)

View In: Map Viewer

Name: Bike Crashes

Display Field: ROADWAY_NAME

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":"BASIC_TYPE","uniqueValueGroups":[{"heading":"BASIC TYPE","classes":[{"label":"Bicycle Crash","description":"Bicycle Crash","symbol":{"type":"esriPMS","url":"5a9ef44ab3755a3829d746e0cc9b5b57","imageData":"iVBORw0KGgoAAAANSUhEUgAAABgAAAAQCAYAAAAMJL+VAAAACXBIWXMAAA7EAAAOxAGVKw4bAAACFklEQVQ4jcWUK1AbURSGv7ObBwVRQwWmNTWYmKgKmGkRLDNgajDdgAqmoogYajA1GCpAgGg7SU0MCDKTjWCYKaI1MTGpwNSWVmDyIMmezr0JhJDSaadletzex/nO+c9/N8ItR+T/A/zCJOIugkTJei//PYDIE+AFyKvLpeVgio7eQ5wo2dn8XwI0AVJDOGOplLZLoWYQeQhU8QsVcvPVPwcYaUyIzAKjqG7QjyjQAso2efponN3H3/gtQCowUpikd4ExmxxqiKwTto67UPcNyDjoAqliQL2RxC+ajXVy3vbNAL+4AywCh4iUUF3rgc5RzQDH3Bk7pdGcsNAuLYGwCSSBDfxgkpz3fBhgBhfKFBrmyc2t4BefIhJD9RMiRq4YRHaoN/OIvWFkyyOygOKR86ZZCgwojV/YvphLH2BdwQNcWelpvwUEuPKWkANbHbqKyCboV5DvgBn0OULSzixs74L7DFxT0DUAnar9NCAb6pGdq/Q6qaHtfXA/AzkQxyYXAdUSIl+6d2ziG4ZsWkoFZ7by5eCUWLzaS7516RZTVaqYATEdPQLuQ+c12flqV2LWQCuMjHz4+ZC1PYNEDgkJaDQNbBS0jCN9i6q8B/cEmvv2rEQ+kgpOCK1cNRxZvWrZQYCp0i/M9FqdxXHKxON7Ax6/asP0UYJ6YxpkAkda1sbvBh/d8Du4kAL2hvauRxf8y3O3/jf9AZNqwyHO9B+OAAAAAElFTkSuQmCC","contentType":"image/png","width":18,"height":12,"angle":0,"xoffset":0,"yoffset":0},"values":[["2"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"5a9ef44ab3755a3829d746e0cc9b5b57","imageData":"iVBORw0KGgoAAAANSUhEUgAAABgAAAAQCAYAAAAMJL+VAAAACXBIWXMAAA7EAAAOxAGVKw4bAAACFklEQVQ4jcWUK1AbURSGv7ObBwVRQwWmNTWYmKgKmGkRLDNgajDdgAqmoogYajA1GCpAgGg7SU0MCDKTjWCYKaI1MTGpwNSWVmDyIMmezr0JhJDSaadletzex/nO+c9/N8ItR+T/A/zCJOIugkTJei//PYDIE+AFyKvLpeVgio7eQ5wo2dn8XwI0AVJDOGOplLZLoWYQeQhU8QsVcvPVPwcYaUyIzAKjqG7QjyjQAso2efponN3H3/gtQCowUpikd4ExmxxqiKwTto67UPcNyDjoAqliQL2RxC+ajXVy3vbNAL+4AywCh4iUUF3rgc5RzQDH3Bk7pdGcsNAuLYGwCSSBDfxgkpz3fBhgBhfKFBrmyc2t4BefIhJD9RMiRq4YRHaoN/OIvWFkyyOygOKR86ZZCgwojV/YvphLH2BdwQNcWelpvwUEuPKWkANbHbqKyCboV5DvgBn0OULSzixs74L7DFxT0DUAnar9NCAb6pGdq/Q6qaHtfXA/AzkQxyYXAdUSIl+6d2ziG4ZsWkoFZ7by5eCUWLzaS7516RZTVaqYATEdPQLuQ+c12flqV2LWQCuMjHz4+ZC1PYNEDgkJaDQNbBS0jCN9i6q8B/cEmvv2rEQ+kgpOCK1cNRxZvWrZQYCp0i/M9FqdxXHKxON7Ax6/asP0UYJ6YxpkAkda1sbvBh/d8Du4kAL2hvauRxf8y3O3/jf9AZNqwyHO9B+OAAAAAElFTkSuQmCC","contentType":"image/png","width":18,"height":12,"angle":0,"xoffset":0,"yoffset":0},"value":"2","label":"Bicycle Crash"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,234,197,255],"toColor":[252,234,197,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[224,182,252,255],"toColor":[224,182,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,238,252,255],"toColor":[179,238,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,252,204,255],"toColor":[182,252,204,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,182,184,255],"toColor":[252,182,184,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,202,252,255],"toColor":[182,202,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,215,239,255],"toColor":[252,215,239,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[227,252,179,255],"toColor":[227,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[212,252,235,255],"toColor":[212,252,235,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,230,255],"toColor":[252,179,230,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,212,207,255],"toColor":[252,212,207,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[233,252,212,255],"toColor":[233,252,212,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[226,212,252,255],"toColor":[226,212,252,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: BASIC_TYPE

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
INCIDENTID (type: esriFieldTypeInteger, alias: INCIDENTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
RTESYSCODE (type: esriFieldTypeInteger, alias: RTESYSCODE, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 01-ISTH], [2: 02-USTH], [3: 03-MNTH], ... 38 more ...)
RTENUMBER (type: esriFieldTypeDouble, alias: RTENUMBER, SQL Type: sqlTypeOther, nullable: true, editable: true)
LOCALID (type: esriFieldTypeString, alias: LOCALID, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
CRASH_MONTH (type: esriFieldTypeInteger, alias: CRASH MONTH, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: January], [2: February], ... 11 more ...)
CRASH_DAY (type: esriFieldTypeInteger, alias: CRASH DAY, SQL Type: sqlTypeOther, nullable: true, editable: true)
CRASH_YEAR (type: esriFieldTypeInteger, alias: CRASH YEAR, SQL Type: sqlTypeOther, nullable: true, editable: true)
CRASH_DAYOFWEEK (type: esriFieldTypeInteger, alias: CRASH DAYOFWEEK, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: Sunday], [2: Monday], ... 6 more ...)
CRASH_HOUR (type: esriFieldTypeInteger, alias: CRASH HOUR, SQL Type: sqlTypeOther, nullable: true, editable: true)
DIVIDEDRDWYDIR (type: esriFieldTypeString, alias: DIVIDEDRDWYDIR, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [0: N/A], [98: Not Applicable], [E: East], ... 3 more ...)
CRASHSEVERITY (type: esriFieldTypeInteger, alias: CRASHSEVERITY, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Fatal], [2: Serious Injury], ... 4 more ...)
NUMBERKILLED (type: esriFieldTypeInteger, alias: NUMBERKILLED, SQL Type: sqlTypeOther, nullable: true, editable: true)
NUMBEROFVEHICLES (type: esriFieldTypeInteger, alias: NUMBEROFVEHICLES, SQL Type: sqlTypeOther, nullable: true, editable: true)
MANNEROFCOLLISION (type: esriFieldTypeInteger, alias: MANNEROFCOLLISION, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Not Applicable], [1: Front to Rear], [3: Angle], ... 14 more ...)
FIRSTHARMFULEVENT (type: esriFieldTypeInteger, alias: FIRSTHARMFULEVENT, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Other - Non Fixed Object], [2: Other - Non Fixed Object], ... 77 more ...)
RELATIONTOINTERSECTION (type: esriFieldTypeInteger, alias: RELATIONTOINTERSECTION, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: Roundabout], [2: Not at Intersection or Interchange], ... 21 more ...)
LIGHTCONDITION (type: esriFieldTypeInteger, alias: LIGHTCONDITION, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: Daylight], [2: Sunrise], ... 7 more ...)
WEATHERPRIMARY (type: esriFieldTypeInteger, alias: WEATHERPRIMARY, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: Clear], [2: Cloudy], ... 9 more ...)
WEATHERSECONDARY (type: esriFieldTypeInteger, alias: WEATHERSECONDARY, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: Clear], [2: Cloudy], ... 9 more ...)
RDWYSURFACE (type: esriFieldTypeInteger, alias: RDWYSURFACE, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: Dry], [2: Wet], ... 11 more ...)
WORKZONETYPE (type: esriFieldTypeInteger, alias: WORKZONETYPE, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: Lane Closure], [2: Lane Shift/Crossover], ... 5 more ...)
ROADWAY_NAME (type: esriFieldTypeString, alias: ROADWAY NAME, SQL Type: sqlTypeOther, length: 47, nullable: true, editable: true)
INTERSECTION_NAME (type: esriFieldTypeString, alias: INTERSECTION NAME, SQL Type: sqlTypeOther, length: 45, nullable: true, editable: true)
ROUTE_ID (type: esriFieldTypeString, alias: ROUTE ID, SQL Type: sqlTypeOther, length: 27, nullable: true, editable: true)
BASIC_TYPE (type: esriFieldTypeInteger, alias: BASIC TYPE, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Pedestrian], [2: Bicycle], [3: Single Vehicle Run Off Road], ... 8 more ...)
UNITTYPEU1 (type: esriFieldTypeInteger, alias: UNITTYPEU1, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: Hit-And-Run Vehicle or Unknown Driver], [2: Motor Vehicle in Transport], ... 7 more ...)
VEHICLETYPEU1 (type: esriFieldTypeInteger, alias: VEHICLETYPEU1, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: Passenger Van (Seats Behind Driver)], [2: Passenger Car], ... 37 more ...)
DIRECTIONU1 (type: esriFieldTypeInteger, alias: DIRECTIONU1, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: Northbound], [2: Southbound], ... 10 more ...)
PRECRASHMANEUVERU1 (type: esriFieldTypeInteger, alias: PRECRASHMANEUVERU1, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: Parked, Entering or Leaving a Parked stall], [2: Parked, Entering or Leaving a Parked stall], ... 26 more ...)
AGEU1 (type: esriFieldTypeInteger, alias: AGEU1, SQL Type: sqlTypeOther, nullable: true, editable: true)
SEXU1 (type: esriFieldTypeString, alias: SEXU1, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [0: N/A], [99: Unknown], [F: Female], ... 1 more ...)
PHYSICALCONDITIONU1 (type: esriFieldTypeInteger, alias: PHYSICALCONDITIONU1, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Has Been Drinking Alcohol], [2: Has Been Taking Illicit Drugs], [4: Has Been Drinking Alcohol], ... 11 more ...)
CONTRIBFACTOR1U1 (type: esriFieldTypeInteger, alias: CONTRIBFACTOR1U1, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: No Clear Contributing Action], [2: Failure to Yield Right-of-Way], [3: Driver Speeding], ... 41 more ...)
CONTRIBFACTOR2U1 (type: esriFieldTypeInteger, alias: CONTRIBFACTOR2U1, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: No Clear Contributing Action], [2: Failure to Yield Right-of-Way], [3: Driver Speeding], ... 41 more ...)
NONMOTORISTMANEUVERU1 (type: esriFieldTypeInteger, alias: NONMOTORISTMANEUVERU1, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: Walk/Cycle Across Traffic (X-ing Road)], [2: Walk/Cycle Across Traffic (X-ing Road)], ... 40 more ...)
NONMOTORISTLOCATIONU1 (type: esriFieldTypeInteger, alias: NONMOTORISTLOCATIONU1, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: Intersection - Marked Crosswalk], [2: Intersection - Unmarked Crosswalk], ... 12 more ...)
RDWYDESIGNU1 (type: esriFieldTypeInteger, alias: RDWYDESIGNU1, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: Two-Way, Divided, No Median Barrier], [2: One Way Trafficway], ... 14 more ...)
TRAFFICCONTROLDEVICEU1 (type: esriFieldTypeInteger, alias: TRAFFICCONTROLDEVICEU1, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: Stop Sign], [2: Stop Sign], ... 21 more ...)
SPEEDLIMITU1 (type: esriFieldTypeInteger, alias: SPEEDLIMITU1, SQL Type: sqlTypeOther, nullable: true, editable: true)
ALIGNMENTU1 (type: esriFieldTypeInteger, alias: ALIGNMENTU1, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [10: CURVE (pre 2016)], [11: Straight], ... 4 more ...)
GRADEU1 (type: esriFieldTypeInteger, alias: GRADEU1, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [20: GRADE (pre 2016)], [21: Level], ... 5 more ...)
UNITTYPEU2 (type: esriFieldTypeInteger, alias: UNITTYPEU2, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: Hit-And-Run Vehicle or Unknown Driver], [2: Motor Vehicle in Transport], ... 7 more ...)
VEHICLETYPEU2 (type: esriFieldTypeInteger, alias: VEHICLETYPEU2, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: Passenger Van (Seats Behind Driver)], [2: Passenger Car], ... 37 more ...)
DIRECTIONU2 (type: esriFieldTypeInteger, alias: DIRECTIONU2, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: Northbound], [2: Southbound], ... 10 more ...)
PRECRASHMANEUVERU2 (type: esriFieldTypeInteger, alias: PRECRASHMANEUVERU2, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: Parked, Entering or Leaving a Parked stall], [2: Parked, Entering or Leaving a Parked stall], ... 26 more ...)
AGEU2 (type: esriFieldTypeInteger, alias: AGEU2, SQL Type: sqlTypeOther, nullable: true, editable: true)
SEXU2 (type: esriFieldTypeString, alias: SEXU2, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [0: N/A], [99: Unknown], [F: Female], ... 1 more ...)
PHYSICALCONDITIONU2 (type: esriFieldTypeInteger, alias: PHYSICALCONDITIONU2, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Has Been Drinking Alcohol], [2: Has Been Taking Illicit Drugs], [4: Has Been Drinking Alcohol], ... 11 more ...)
CONTRIBFACTOR1U2 (type: esriFieldTypeInteger, alias: CONTRIBFACTOR1U2, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: No Clear Contributing Action], [2: Failure to Yield Right-of-Way], [3: Driver Speeding], ... 41 more ...)
CONTRIBFACTOR2U2 (type: esriFieldTypeInteger, alias: CONTRIBFACTOR2U2, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: No Clear Contributing Action], [2: Failure to Yield Right-of-Way], [3: Driver Speeding], ... 41 more ...)
NONMOTORISTMANEUVERU2 (type: esriFieldTypeInteger, alias: NONMOTORISTMANEUVERU2, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: Walk/Cycle Across Traffic (X-ing Road)], [2: Walk/Cycle Across Traffic (X-ing Road)], ... 40 more ...)
NONMOTORISTLOCATIONU2 (type: esriFieldTypeInteger, alias: NONMOTORISTLOCATIONU2, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: Intersection - Marked Crosswalk], [2: Intersection - Unmarked Crosswalk], ... 12 more ...)
RDWYDESIGNU2 (type: esriFieldTypeInteger, alias: RDWYDESIGNU2, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: Two-Way, Divided, No Median Barrier], [2: One Way Trafficway], ... 14 more ...)
TRAFFICCONTROLDEVICEU2 (type: esriFieldTypeInteger, alias: TRAFFICCONTROLDEVICEU2, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: Stop Sign], [2: Stop Sign], ... 21 more ...)
SPEEDLIMITU2 (type: esriFieldTypeInteger, alias: SPEEDLIMITU2, SQL Type: sqlTypeOther, nullable: true, editable: true)
ALIGNMENTU2 (type: esriFieldTypeInteger, alias: ALIGNMENTU2, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [10: CURVE (pre 2016)], [11: Straight], ... 4 more ...)
GRADEU2 (type: esriFieldTypeInteger, alias: GRADEU2, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [20: GRADE (pre 2016)], [21: Level], ... 5 more ...)
UNITTYPEU3 (type: esriFieldTypeInteger, alias: UNITTYPEU3, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: Hit-And-Run Vehicle or Unknown Driver], [2: Motor Vehicle in Transport], ... 7 more ...)
VEHICLETYPEU3 (type: esriFieldTypeInteger, alias: VEHICLETYPEU3, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: Passenger Van (Seats Behind Driver)], [2: Passenger Car], ... 37 more ...)
DIRECTIONU3 (type: esriFieldTypeInteger, alias: DIRECTIONU3, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: Northbound], [2: Southbound], ... 10 more ...)
PRECRASHMANEUVERU3 (type: esriFieldTypeInteger, alias: PRECRASHMANEUVERU3, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: Parked, Entering or Leaving a Parked stall], [2: Parked, Entering or Leaving a Parked stall], ... 26 more ...)
AGEU3 (type: esriFieldTypeInteger, alias: AGEU3, SQL Type: sqlTypeOther, nullable: true, editable: true)
SEXU3 (type: esriFieldTypeString, alias: SEXU3, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [0: N/A], [99: Unknown], [F: Female], ... 1 more ...)
PHYSICALCONDITIONU3 (type: esriFieldTypeInteger, alias: PHYSICALCONDITIONU3, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Has Been Drinking Alcohol], [2: Has Been Taking Illicit Drugs], [4: Has Been Drinking Alcohol], ... 11 more ...)
CONTRIBFACTOR1U3 (type: esriFieldTypeInteger, alias: CONTRIBFACTOR1U3, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: No Clear Contributing Action], [2: Failure to Yield Right-of-Way], [3: Driver Speeding], ... 41 more ...)
CONTRIBFACTOR2U3 (type: esriFieldTypeInteger, alias: CONTRIBFACTOR2U3, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: No Clear Contributing Action], [2: Failure to Yield Right-of-Way], [3: Driver Speeding], ... 41 more ...)
NONMOTORISTMANEUVERU3 (type: esriFieldTypeInteger, alias: NONMOTORISTMANEUVERU3, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: Walk/Cycle Across Traffic (X-ing Road)], [2: Walk/Cycle Across Traffic (X-ing Road)], ... 40 more ...)
NONMOTORISTLOCATIONU3 (type: esriFieldTypeInteger, alias: NONMOTORISTLOCATIONU3, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: Intersection - Marked Crosswalk], [2: Intersection - Unmarked Crosswalk], ... 12 more ...)
RDWYDESIGNU3 (type: esriFieldTypeInteger, alias: RDWYDESIGNU3, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: Two-Way, Divided, No Median Barrier], [2: One Way Trafficway], ... 14 more ...)
TRAFFICCONTROLDEVICEU3 (type: esriFieldTypeInteger, alias: TRAFFICCONTROLDEVICEU3, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: Stop Sign], [2: Stop Sign], ... 21 more ...)
SPEEDLIMITU3 (type: esriFieldTypeInteger, alias: SPEEDLIMITU3, SQL Type: sqlTypeOther, nullable: true, editable: true)
ALIGNMENTU3 (type: esriFieldTypeInteger, alias: ALIGNMENTU3, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [10: CURVE (pre 2016)], [11: Straight], ... 4 more ...)
GRADEU3 (type: esriFieldTypeInteger, alias: GRADEU3, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [20: GRADE (pre 2016)], [21: Level], ... 5 more ...)
UNITTYPEU4 (type: esriFieldTypeInteger, alias: UNITTYPEU4, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: Hit-And-Run Vehicle or Unknown Driver], [2: Motor Vehicle in Transport], ... 7 more ...)
VEHICLETYPEU4 (type: esriFieldTypeInteger, alias: VEHICLETYPEU4, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: Passenger Van (Seats Behind Driver)], [2: Passenger Car], ... 37 more ...)
DIRECTIONU4 (type: esriFieldTypeInteger, alias: DIRECTIONU4, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: Northbound], [2: Southbound], ... 10 more ...)
PRECRASHMANEUVERU4 (type: esriFieldTypeInteger, alias: PRECRASHMANEUVERU4, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: Parked, Entering or Leaving a Parked stall], [2: Parked, Entering or Leaving a Parked stall], ... 26 more ...)
AGEU4 (type: esriFieldTypeInteger, alias: AGEU4, SQL Type: sqlTypeOther, nullable: true, editable: true)
SEXU4 (type: esriFieldTypeString, alias: SEXU4, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [0: N/A], [99: Unknown], [F: Female], ... 1 more ...)
PHYSICALCONDITIONU4 (type: esriFieldTypeInteger, alias: PHYSICALCONDITIONU4, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Has Been Drinking Alcohol], [2: Has Been Taking Illicit Drugs], [4: Has Been Drinking Alcohol], ... 11 more ...)
CONTRIBFACTOR1U4 (type: esriFieldTypeInteger, alias: CONTRIBFACTOR1U4, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: No Clear Contributing Action], [2: Failure to Yield Right-of-Way], [3: Driver Speeding], ... 41 more ...)
CONTRIBFACTOR2U4 (type: esriFieldTypeInteger, alias: CONTRIBFACTOR2U4, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: No Clear Contributing Action], [2: Failure to Yield Right-of-Way], [3: Driver Speeding], ... 41 more ...)
NONMOTORISTMANEUVERU4 (type: esriFieldTypeInteger, alias: NONMOTORISTMANEUVERU4, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: Walk/Cycle Across Traffic (X-ing Road)], [2: Walk/Cycle Across Traffic (X-ing Road)], ... 40 more ...)
NONMOTORISTLOCATIONU4 (type: esriFieldTypeInteger, alias: NONMOTORISTLOCATIONU4, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: Intersection - Marked Crosswalk], [2: Intersection - Unmarked Crosswalk], ... 12 more ...)
RDWYDESIGNU4 (type: esriFieldTypeInteger, alias: RDWYDESIGNU4, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: Two-Way, Divided, No Median Barrier], [2: One Way Trafficway], ... 14 more ...)
TRAFFICCONTROLDEVICEU4 (type: esriFieldTypeInteger, alias: TRAFFICCONTROLDEVICEU4, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [1: Stop Sign], [2: Stop Sign], ... 21 more ...)
SPEEDLIMITU4 (type: esriFieldTypeInteger, alias: SPEEDLIMITU4, SQL Type: sqlTypeOther, nullable: true, editable: true)
ALIGNMENTU4 (type: esriFieldTypeInteger, alias: ALIGNMENTU4, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [10: CURVE (pre 2016)], [11: Straight], ... 4 more ...)
GRADEU4 (type: esriFieldTypeInteger, alias: GRADEU4, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [20: GRADE (pre 2016)], [21: Level], ... 5 more ...)
LATITUDE (type: esriFieldTypeDouble, alias: LATITUDE, SQL Type: sqlTypeOther, nullable: true, editable: true)
LONGITUDE (type: esriFieldTypeDouble, alias: LONGITUDE, SQL Type: sqlTypeOther, nullable: true, editable: true)
CRASH_DATE_TIME (type: esriFieldTypeString, alias: CRASH DATE TIME, SQL Type: sqlTypeOther, length: 33, nullable: true, editable: true)
NARRATIVE (type: esriFieldTypeString, alias: NARRATIVE, SQL Type: sqlTypeOther, length: 9719, nullable: true, editable: true)
Date_and_Time (type: esriFieldTypeDate, alias: Date and Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Direction (type: esriFieldTypeString, alias: Direction, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Moved (type: esriFieldTypeInteger, alias: Moved, SQL Type: sqlTypeOther, nullable: true, editable: true)
Iteris_ID (type: esriFieldTypeInteger, alias: Iteris ID, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Full Route], [1: Urban], [2: Rural], ... 25 more ...)
Iteris_ID_FullRoute (type: esriFieldTypeInteger, alias: Iteris ID FullRoute, SQL Type: sqlTypeOther, nullable: true, editable: true)
M (type: esriFieldTypeDouble, alias: M, SQL Type: sqlTypeOther, nullable: true, editable: true)
cluster_id (type: esriFieldTypeString, alias: cluster_id, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
initial (type: esriFieldTypeSmallInteger, alias: initial, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
secondary (type: esriFieldTypeSmallInteger, alias: secondary, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
multivehicle (type: esriFieldTypeSmallInteger, alias: multivehicle, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
SpeedingCrash (type: esriFieldTypeSmallInteger, alias: Is Workzone Crash, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
Inclement_Crash (type: esriFieldTypeSmallInteger, alias: Inclement Road/Weather, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
Inclement_Surface (type: esriFieldTypeSmallInteger, alias: Inclement Surface, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
Inclement_Conditions (type: esriFieldTypeSmallInteger, alias: Inclement Conditions, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
WorkzoneCrash (type: esriFieldTypeSmallInteger, alias: Is Workzone Crash, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
FatalSeriousCrash (type: esriFieldTypeSmallInteger, alias: Fatal/Serious Crash, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
Inclement_RWIS_Weather (type: esriFieldTypeSmallInteger, alias: Inclement Weather Crash (RWIS), SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
Weather_Category (type: esriFieldTypeString, alias: Weather Category, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
StudyCrash (type: esriFieldTypeSmallInteger, alias: StudyCrash, SQL Type: sqlTypeOther, nullable: true, editable: true)
Iteris_ID_Combined (type: esriFieldTypeInteger, alias: Iteris ID Combined, SQL Type: sqlTypeOther, nullable: true, editable: true)
Iteris_ID_FullRoute_Combined (type: esriFieldTypeInteger, alias: Iteris ID FullRoute Combined, SQL Type: sqlTypeOther, nullable: true, editable: true)
TTR (type: esriFieldTypeString, alias: TTR, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
SpeedCategory (type: esriFieldTypeSmallInteger, alias: SpeedCategory, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: 20+ below SL], [1: 10%-20% below SL], [2: SL to 10% Below SL], ... 2 more ...)
is_inclement_weather (type: esriFieldTypeSmallInteger, alias: is_inclement_weather, SQL Type: sqlTypeOther, nullable: true, editable: true)
Intersection_Crashes_5Years (type: esriFieldTypeSmallInteger, alias: Intersection_Crashes_5Years, SQL Type: sqlTypeOther, nullable: true, editable: true)
Study_Crash_Intersection (type: esriFieldTypeInteger, alias: Study Crash Intersection, SQL Type: sqlTypeOther, nullable: true, editable: true)

Types:

Field Name: RTESYSCODE
Inherited
Field Name: CRASH_MONTH
Inherited
Field Name: CRASH_DAYOFWEEK
Inherited
Field Name: DIVIDEDRDWYDIR
Inherited
Field Name: CRASHSEVERITY
Inherited
Field Name: MANNEROFCOLLISION
Inherited
Field Name: FIRSTHARMFULEVENT
Inherited
Field Name: RELATIONTOINTERSECTION
Inherited
Field Name: LIGHTCONDITION
Inherited
Field Name: WEATHERPRIMARY
Inherited
Field Name: WEATHERSECONDARY
Inherited
Field Name: RDWYSURFACE
Inherited
Field Name: WORKZONETYPE
Inherited
Field Name: BASIC_TYPE
Inherited
Field Name: UNITTYPEU1
Inherited
Field Name: VEHICLETYPEU1
Inherited
Field Name: DIRECTIONU1
Inherited
Field Name: PRECRASHMANEUVERU1
Inherited
Field Name: SEXU1
Inherited
Field Name: PHYSICALCONDITIONU1
Inherited
Field Name: CONTRIBFACTOR1U1
Inherited
Field Name: CONTRIBFACTOR2U1
Inherited
Field Name: NONMOTORISTMANEUVERU1
Inherited
Field Name: NONMOTORISTLOCATIONU1
Inherited
Field Name: RDWYDESIGNU1
Inherited
Field Name: TRAFFICCONTROLDEVICEU1
Inherited
Field Name: ALIGNMENTU1
Inherited
Field Name: GRADEU1
Inherited
Field Name: UNITTYPEU2
Inherited
Field Name: VEHICLETYPEU2
Inherited
Field Name: DIRECTIONU2
Inherited
Field Name: PRECRASHMANEUVERU2
Inherited
Field Name: SEXU2
Inherited
Field Name: PHYSICALCONDITIONU2
Inherited
Field Name: CONTRIBFACTOR1U2
Inherited
Field Name: CONTRIBFACTOR2U2
Inherited
Field Name: NONMOTORISTMANEUVERU2
Inherited
Field Name: NONMOTORISTLOCATIONU2
Inherited
Field Name: RDWYDESIGNU2
Inherited
Field Name: TRAFFICCONTROLDEVICEU2
Inherited
Field Name: ALIGNMENTU2
Inherited
Field Name: GRADEU2
Inherited
Field Name: UNITTYPEU3
Inherited
Field Name: VEHICLETYPEU3
Inherited
Field Name: DIRECTIONU3
Inherited
Field Name: PRECRASHMANEUVERU3
Inherited
Field Name: SEXU3
Inherited
Field Name: PHYSICALCONDITIONU3
Inherited
Field Name: CONTRIBFACTOR1U3
Inherited
Field Name: CONTRIBFACTOR2U3
Inherited
Field Name: NONMOTORISTMANEUVERU3
Inherited
Field Name: NONMOTORISTLOCATIONU3
Inherited
Field Name: RDWYDESIGNU3
Inherited
Field Name: TRAFFICCONTROLDEVICEU3
Inherited
Field Name: ALIGNMENTU3
Inherited
Field Name: GRADEU3
Inherited
Field Name: UNITTYPEU4
Inherited
Field Name: VEHICLETYPEU4
Inherited
Field Name: DIRECTIONU4
Inherited
Field Name: PRECRASHMANEUVERU4
Inherited
Field Name: SEXU4
Inherited
Field Name: PHYSICALCONDITIONU4
Inherited
Field Name: CONTRIBFACTOR1U4
Inherited
Field Name: CONTRIBFACTOR2U4
Inherited
Field Name: NONMOTORISTMANEUVERU4
Inherited
Field Name: NONMOTORISTLOCATIONU4
Inherited
Field Name: RDWYDESIGNU4
Inherited
Field Name: TRAFFICCONTROLDEVICEU4
Inherited
Field Name: ALIGNMENTU4
Inherited
Field Name: GRADEU4
Inherited
Field Name: Iteris_ID
Inherited
Field Name: initial
Inherited
Field Name: secondary
Inherited
Field Name: multivehicle
Inherited
Field Name: SpeedingCrash
Inherited
Field Name: Inclement_Crash
Inherited
Field Name: Inclement_Surface
Inherited
Field Name: Inclement_Conditions
Inherited
Field Name: WorkzoneCrash
Inherited
Field Name: FatalSeriousCrash
Inherited
Field Name: Inclement_RWIS_Weather
Inherited
Field Name: SpeedCategory
Inherited

BASIC_TYPE: 2

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/23/2025 8:38:50 PM

Schema Last Edit Date: 7/23/2025 8:38:50 PM

Data Last Edit Date: 7/23/2025 8:38:50 PM

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