Name: Crashes

Display Field: SER_NO

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description: Motor vehicle traffic crash points for 2007-2017 throughout the Metro region provided by ODOT. Includes injuries by severity. Additional attributes have been derived.

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: false

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 7455695.7474
YMin: 449544.0455
XMax: 7897072.2967
YMax: 783191.3108
Spatial Reference: 2913 (2913)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"HIGHEST_INJ_SVRTY_DESC","uniqueValueInfos":[{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[168,0,0,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"value":"Fatal Injury (K)","label":"Fatal Injury (K)"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,0,0,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"value":"Suspected Serious Injury (A)","label":"Suspected Serious Injury (A)"},{"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":1}},"value":"Suspected Minor Injury Crash (B)","label":"Suspected Minor Injury Crash (B)"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,255,0,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"value":"Possible Injury Crash (C)","label":"Possible Injury Crash (C)"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,255,255,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"value":"No Apparent Injury/PDO Crash (O)","label":"No Apparent Injury/PDO Crash (O)"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriHSVAlgorithm","fromColor":[56,168,0,255],"toColor":[255,255,0,255]},{"type":"algorithmic","algorithm":"esriHSVAlgorithm","fromColor":[255,255,0,255],"toColor":[255,0,0,255]}]}}},"scaleSymbols":false,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Time Info:

Start Time Field: CRASH_DT
End Time Field: null
Track ID Field: null
Time Extent
[1/1/2007 8:00:00 AM UTC, 12/31/2022 8:00:00 AM UTC]

Time Reference: UTC
Time Interval: 5
Time Interval Units: esriTimeUnitsMinutes
Has Live Data: true
Export Options:

Use Time: true
Time Data Cumulative: false
Time Offset: 0
Time Offset Units: esriTimeUnitsCenturies

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field: HIGHEST_INJ_SVRTY_DESC

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• ALCHL_INVLV_FLG (type: esriFieldTypeSmallInteger, alias: Alcohol Involved Flag, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CNTY_NM (type: esriFieldTypeString, alias: County Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• COLLIS_TYP_LONG_DESC (type: esriFieldTypeString, alias: Collison Type Desc, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• CRASH_CAUSE_1_LONG_DESC (type: esriFieldTypeString, alias: Crash Cause 1 Desc, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• CRASH_HIT_RUN_FLG (type: esriFieldTypeSmallInteger, alias: Hit and Run Flag, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CRASH_HR_NO (type: esriFieldTypeString, alias: CRASH Hour, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• CRASH_ID (type: esriFieldTypeInteger, alias: CRASH ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CRASH_MO_NO (type: esriFieldTypeString, alias: Crash Month, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• CRASH_SPEED_INVLV_FLG (type: esriFieldTypeSmallInteger, alias: Speed Involved Flag, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CRASH_SVRTY_LONG_DESC (type: esriFieldTypeString, alias: Crash Severity Desc, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CRASH_TYP_LONG_DESC (type: esriFieldTypeString, alias: Crash Type Desc, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CRASH_WK_DAY_CD (type: esriFieldTypeString, alias: Day of Week, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• CRASH_YR_NO (type: esriFieldTypeString, alias: Crash Year, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• DRUG_INVLV_FLG (type: esriFieldTypeSmallInteger, alias: Drug Involved Flag, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DRVWY_REL_FLG (type: esriFieldTypeSmallInteger, alias: Driveway Related Flag, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FC_DESC (type: esriFieldTypeString, alias: Functional Class Desc, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• HIGHEST_INJ_SVRTY_DESC (type: esriFieldTypeString, alias: Highest Injury Severity Description, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• HWY_COMPNT_CD (type: esriFieldTypeString, alias: HWY Component Code, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• INVSTG_AGY_LONG_DESC (type: esriFieldTypeString, alias: Investigating Agency Desc, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ISECT_REL_FLG (type: esriFieldTypeSmallInteger, alias: Intersection Related Flag, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ISECT_TYP_SHORT_DESC (type: esriFieldTypeString, alias: Intersection Type Desc, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
• LGT_COND_LONG_DESC (type: esriFieldTypeString, alias: Light Condition Desc, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LN_QTY (type: esriFieldTypeSmallInteger, alias: Number of Lanes, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MEDN_TYP_LONG_DESC (type: esriFieldTypeString, alias: Median Type Desc, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MJ_INVLV_FLG (type: esriFieldTypeSmallInteger, alias: Marijuana Involved Flag, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NHS_FLG (type: esriFieldTypeSmallInteger, alias: NHS Flag, SQL Type: sqlTypeOther, nullable: true, editable: true)
• POST_SPEED_LMT_VAL (type: esriFieldTypeString, alias: Posted Speed, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• RD_CHAR_LONG_DESC (type: esriFieldTypeString, alias: Rd Character Desc, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• RD_SURF_MED_DESC (type: esriFieldTypeString, alias: Road Surface Condition Desc, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• RNDABT_FLG (type: esriFieldTypeSmallInteger, alias: Roundabout Flag, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SCHL_ZONE_IND (type: esriFieldTypeString, alias: School Zone Indicator, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• TOT_FATAL_CNT (type: esriFieldTypeInteger, alias: Total Deaths, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOT_INJ_CNT (type: esriFieldTypeInteger, alias: Total Non-Fatal Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOT_INJ_LVL_A_CNT (type: esriFieldTypeInteger, alias: Total Serious Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOT_INJ_LVL_B_CNT (type: esriFieldTypeInteger, alias: Total Moderate Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOT_INJ_LVL_C_CNT (type: esriFieldTypeInteger, alias: Total Minor Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOT_MOTOR_FATAL_CNT (type: esriFieldTypeInteger, alias: Total Motorized Fatal Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOT_MOTOR_INJ_A_CNT (type: esriFieldTypeInteger, alias: Total Motorized Serious Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOT_MOTOR_INJ_CNT (type: esriFieldTypeInteger, alias: Total Motorist Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOT_MTRCYCL_FATAL_CNT (type: esriFieldTypeInteger, alias: Total Motorcycle Fatalities, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOT_MTRCYCL_INJ_A_CNT (type: esriFieldTypeInteger, alias: Total Motorcycle Serious Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOT_MTRCYCL_INJ_CNT (type: esriFieldTypeInteger, alias: Total Motorcyclist Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOT_PEDCYCL_FATAL_CNT (type: esriFieldTypeInteger, alias: Total Pedal-cyclist Deaths, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOT_PEDCYCL_INJ_A_CNT (type: esriFieldTypeInteger, alias: Total Pedal-cyclist Serious Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOT_PEDCYCL_INJ_CNT (type: esriFieldTypeInteger, alias: Total Pedal-cyclist Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOT_PED_FATAL_CNT (type: esriFieldTypeInteger, alias: Total Pedestrian Deaths, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOT_PED_INJ_A_CNT (type: esriFieldTypeInteger, alias: Total Pedestrian Serious Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOT_PED_INJ_CNT (type: esriFieldTypeInteger, alias: Total Pedestrian Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOT_PER_INVLV_CNT (type: esriFieldTypeInteger, alias: Total Persons Involved, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOT_SFTY_EQUIP_UNUSED_QTY (type: esriFieldTypeInteger, alias: Total Safety Equip Un-used, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOT_SFTY_EQUIP_USED_QTY (type: esriFieldTypeInteger, alias: Total Safety Equip Used, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOT_SFTY_EQUIP_USE_UNKNWN_QTY (type: esriFieldTypeInteger, alias: Total Safety Equip Unknown if Used, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOT_UNINJD_AGE00_04_CNT (type: esriFieldTypeInteger, alias: Total Un-injured Age 00-04, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOT_UNINJD_PER_CNT (type: esriFieldTypeInteger, alias: Total Un-injured Persons, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOT_VHCL_CNT (type: esriFieldTypeInteger, alias: Total Vehicles, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TRAF_CNTL_DEVICE_LONG_DESC (type: esriFieldTypeString, alias: Traffic Control Device Desc, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• TURNG_LEG_QTY (type: esriFieldTypeInteger, alias: Number of Turning Legs, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UNLOCT_FLG (type: esriFieldTypeSmallInteger, alias: Unlocatable Flag, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WRK_ZONE_IND (type: esriFieldTypeString, alias: Work Zone Indicator, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• WTHR_COND_LONG_DESC (type: esriFieldTypeString, alias: Weather Desc, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
• UGB (type: esriFieldTypeSmallInteger, alias: UGB, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MPA (type: esriFieldTypeSmallInteger, alias: MPA, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GIS_JURIS (type: esriFieldTypeString, alias: GIS_Jurisdiction, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Types:

ID: Fatal Injury (K)
Name: Fatal Injury (K)
Domains:

Templates:

Name: Fatal Injury (K)
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• HIGHEST_INJ_SVRTY_DESC: Fatal Injury (K)

---

ID: Suspected Serious Injury (A)
Name: Suspected Serious Injury (A)
Domains:

Templates:

Name: Suspected Serious Injury (A)
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• HIGHEST_INJ_SVRTY_DESC: Suspected Serious Injury (A)

---

ID: Suspected Minor Injury Crash (B)
Name: Suspected Minor Injury Crash (B)
Domains:

Templates:

Name: Suspected Minor Injury Crash (B)
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• HIGHEST_INJ_SVRTY_DESC: Suspected Minor Injury Crash (B)

---

ID: Possible Injury Crash (C)
Name: Possible Injury Crash (C)
Domains:

Templates:

Name: Possible Injury Crash (C)
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• HIGHEST_INJ_SVRTY_DESC: Possible Injury Crash (C)

---

ID: No Apparent Injury/PDO Crash (O)
Name: No Apparent Injury/PDO Crash (O)
Domains:

Templates:

Name: No Apparent Injury/PDO Crash (O)
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• HIGHEST_INJ_SVRTY_DESC: No Apparent Injury/PDO Crash (O)

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/23/2025 7:34:26 PM

Schema Last Edit Date: 1/23/2025 12:45:06 AM

Data Last Edit Date: 1/23/2025 12:45:06 AM

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