Layer: Ped/Bike Crashes (ID:4)

View In: Map Viewer

Name: Ped/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","uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"0f3a3383c6d830dea18e485a24dacd42","imageData":"iVBORw0KGgoAAAANSUhEUgAAABQAAAAaCAYAAAC3g3x9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAACfklEQVRIie2VS0jUURSHvzuOjtp/pAdaIxZU+DdTsxhxIQqCaClWgxbSQ6IIlxZUIEEotIkgpBaK7qKIwBBSxFYilKHgBFk5YUUaovkayfE5NnNaOIrIzPigVXSW9/7ud3/n3MO5Rv5yGP8DA4aIZAM6YAbsSqn2LQNFxOpaIL/kMSfnF9n2qJgGEXEppexbdZhQ24G11UEiQFUreS8u8w7YHFBEzCyladFjGAhRiEdQB3bxE3D5OxMQKCKxQOH4DPF1HVhbHOgRYXgsZqaqTtAJDG0KCGR3DpBeWM/FiVlMy4tfFth5s4msmjP8EpEEoFkpteLWL9DnTr/yjGLnHKbdGnMj00Qs7zf2kF6eRU/dW05V5XNYRGqUUkPBHOpPujnkGGV7bgL9YSEYW3qJAzAZ8Y64iEy8RznA7VzeANp6Kcf2O4mLCOV3WQbdpU8pArBEMTtYycPKV2R2/WBvaRpd0RpOYHg9YPudPPQb2bTdaqJgfhEDwOQsJpcb790C2nw6O0tNHriGvlbRgL4QA0ca3pO0IxK3QcHEDGG1HaRW5FCvlGr258S4Bnbe60V3ezG45gm530bm2DThuQn0lxyj9+pzCl5+ILkiBysQHCgiViA5tpLrq18U4FIaXWeP8v1aI8ftg+wbmyZURHSlVF8wh8OA+5yVT32jxHgET1Q4i0l7GLqQxmcASxRzX8fRXn/DUpSKOahDpdSQiLRX23DBitjlu0hzzhA/MEmkyYg36yDDrHrZgDX0jaT2tSIRKWvoIXnRg8GWwsdojYHlRg4KDBLTuzWmMvYzUn2aFvxMmc0Cm20pWGwpOIA+f3NwU0Bf4z7YiPYf+qQ2Gn8ACIDrEvWp7JQAAAAASUVORK5CYII=","contentType":"image/png","width":15,"height":19,"angle":0,"xoffset":0,"yoffset":0},"value":"1","label":"Pedestrian"},{"symbol":{"type":"esriPMS","url":"7b275e3212779935d1be00257fa2e86d","imageData":"iVBORw0KGgoAAAANSUhEUgAAACwAAAAsCAYAAAAehFoBAAAACXBIWXMAAA7EAAAOxAGVKw4bAAADgklEQVRYhe2XMUxbVxRAz30YiwEzBzyTeI8I2JZIo26EslU00MlC+OOlDFWnBpWMDFGn2AbElibZUNSOKLQSNcWoXVPIGMeZsYeK+N/b4RurLrRygn+jqD7je+++f959V1fvR/jAiLxvgbelJxw2PeGw6QmHTU84bHrCYdM94Uw6RlSHOHUnbO3Vurbv3+iOcHbCQxpzIINEG98DK13Z9wK6IywIMIrqEo3+nda4l4zjZATfHwHA+c/JH/5+mU91R9hsBJEqkb4KTofwkkPBuHooCwhXEI4wdx94z8JeMg56E2wY9R+2zQkANaCG9H1O/ufyZT/3bsJnV632CvXHcDIKPAF5dcHqz5qHmQfKbbGFUiVc4VxqDNVF0GmUQaCKk7PZKZyb58FfsriYTOB0AWQLLIM3MQw6iRJ0EW/8GNf3TVtM14RzqbHgyqWOsQluF7FbYF+AHIO9RrWIl/yklTnRayB14GWwiU1hfAtuF/NjOLeCapFcKtupdGfCXjLeklWZY33/eTA+cb0pO9gUqoM9wkveoVCqIDINvACbBqmCvUbkNlCgeFDBS5ZBN1B/lUx6tpP+fV44k46dCzQSCMOYLbVks8mPQRdANlE7wkketSWcW0Fslex4BSwO8hvwKWb3MHeI06fAfTLpBQp7FRZvrOMkz4AlgPK/elwofNEpxa4DVcQ9A4LaFM1j/MCbvjwRiYMOEolUgCzqP212iGOMEwQQSeDsI4wXYFP0+/NAAddXBq3h+9fahP8h252VhOoRToZxMgJUaLgKA5rlj8ghW3s1cqkYShXfhiiWdvDGvwLWgFHEloErwBRmdeBXTH7EZDfYmxgOwFU7UelMOMhCHd+fAcrN0wfZ9pJxVL8EQAjK5TSyTbRxBzDUNnBuBewnTiN32zKXSceQRrYttivChVKF7PgmwjLZcRBX4NSdMGAJVG+BTYLca3WHrb1aszZnWT/YZvEGOMnT71fJpB8E88kEzp8BuQn2uNOe3HlbexNZI9qIIXwNdptoo44y2pzdoLCfb1svvAQOAVg/2MabuIrYXaL+LN7EMegkAMZjir90/FjqXDi4ymVyqYf4/gwiVzG+AzmmWNo5t754cNgSBijsr5FLPcP35xAZxGQVk13WSx2VwtsLnxE0+Hd7E1wmtsn/+I/jP6InHDY94bDpCYdNTzhsesJh0xMOmw9O+E8jsHXpg3g5IwAAAABJRU5ErkJggg==","contentType":"image/png","width":33,"height":33,"angle":0,"xoffset":0,"yoffset":0},"value":"2","label":"Bicycle"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,184,201,255],"toColor":[252,184,201,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,252,184,255],"toColor":[179,252,184,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[187,236,252,255],"toColor":[187,236,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[198,184,252,255],"toColor":[198,184,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,241,194,255],"toColor":[252,241,194,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[199,252,229,255],"toColor":[199,252,229,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,187,245,255],"toColor":[252,187,245,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[225,215,252,255],"toColor":[225,215,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,215,207,255],"toColor":[252,215,207,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[223,252,182,255],"toColor":[223,252,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,212,230,255],"toColor":[252,212,230,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,206,252,255],"toColor":[179,206,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[228,252,207,255],"toColor":[228,252,207,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: esriFieldTypeString, alias: INCIDENTID, SQL Type: sqlTypeOther, length: 12, 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: esriFieldTypeString, alias: RTENUMBER, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
LOCALID (type: esriFieldTypeString, alias: LOCALID, SQL Type: sqlTypeOther, length: 23, 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: esriFieldTypeString, alias: CRASH YEAR, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
CRASH_DAYOFWEEK (type: esriFieldTypeString, alias: CRASH DAYOFWEEK, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
CRASH_HOUR (type: esriFieldTypeInteger, alias: CRASH HOUR, SQL Type: sqlTypeOther, nullable: true, editable: true)
DIVIDEDRDWYDIR (type: esriFieldTypeString, alias: DIVIDEDRDWYDIR, SQL Type: sqlTypeOther, length: 5, 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: 60, nullable: true, editable: true)
INTERSECTION_NAME (type: esriFieldTypeString, alias: INTERSECTION NAME, SQL Type: sqlTypeOther, length: 56, 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 Veh ROR], ... 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: 5, 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: 5, 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: 5, 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: 5, 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)
Date_and_Time (type: esriFieldTypeDate, alias: Date and Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)

Types:

Field Name: RTESYSCODE
Inherited
Field Name: CRASH_MONTH
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

BASIC_TYPE: 1

Field Name: RTESYSCODE
Inherited
Field Name: CRASH_MONTH
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

BASIC_TYPE: 2

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/29/2022 3:02:05 AM

Schema Last Edit Date: 9/29/2022 3:02:05 AM

Data Last Edit Date: 9/29/2022 3:02:05 AM

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