Layer: Crash Data minus 1 Year (ID: 20)

Name: Crash Data minus 1 Year

Display Field: CRASH_ID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><DIV><DIV>The metadata for this data was largely pulled (almost exclusively) from the ODOT 2017 Code Manual under their supporting files found here:https://www.oregon.gov/ODOT/Data/documents/CDS_Code_Manual.pdfThere are also some illustrations in there that might be useful.Please see the indivudual fields for an explanation for the values.This may not be the best place for this but...these are some query statements that can be used as create query layers in arcmap that pull out common types of crash data:Crashes -- Fatal/Severe (5 years):selectOBJECTID,CRASH_ID,CRASH_DT,CRASH_HR_NO,CRASH_SVRTY_LONG_DESC,TOT_FATAL_CNT,TOT_INJ_LVL_A_CNT,TOT_INJ_LVL_B_CNT,TOT_INJ_LVL_C_CNT,COLLIS_TYP_LONG_DESC,CRASH_TYP_LONG_DESC,CRASH_CAUSE_1_LONG_DESC,CRASH_CAUSE_2_LONG_DESC,CRASH_CAUSE_3_LONG_DESC,TRAF_CNTL_DEVICE_LONG_DESC,LGT_COND_LONG_DESC,RD_SURF_MED_DESC,WTHR_COND_LONG_DESC,TOT_PDO_CNT,EFFECTV_DT,SHAPEfrom distribution.transpor.CRASHMULTIYEAR WHERE ((DATEPART(YEAR, CRASH_DT) in (SELECT max(DATEPART(year, CRASH_DT)) FROM distribution.TRANSPOR.CrashMultiYear)) OR(DATEPART(YEAR, CRASH_DT) in (SELECT (max(DATEPART(year, CRASH_DT))-1) FROM distribution.TRANSPOR.CrashMultiYear)) OR(DATEPART(YEAR, CRASH_DT) in (SELECT (max(DATEPART(year, CRASH_DT))-2) FROM distribution.TRANSPOR.CrashMultiYear)) OR(DATEPART(YEAR, CRASH_DT) in (SELECT (max(DATEPART(year, CRASH_DT))-3) FROM distribution.TRANSPOR.CrashMultiYear)) OR(DATEPART(YEAR, CRASH_DT) in (SELECT (max(DATEPART(year, CRASH_DT))-4) FROM distribution.TRANSPOR.CrashMultiYear))) AND (TOT_INJ_LVL_B_CNT > 0 OR TOT_INJ_LVL_C_CNT > 0) AND (TOT_FATAL_CNT > 0 OR TOT_INJ_LVL_A_CNT > 0)Crashes -- Minor Injury (5 years):selectOBJECTID,CRASH_ID,CRASH_DT,CRASH_HR_NO,CRASH_SVRTY_LONG_DESC,TOT_FATAL_CNT,TOT_INJ_LVL_A_CNT,TOT_INJ_LVL_B_CNT,TOT_INJ_LVL_C_CNT,COLLIS_TYP_LONG_DESC,CRASH_TYP_LONG_DESC,CRASH_CAUSE_1_LONG_DESC,CRASH_CAUSE_2_LONG_DESC,CRASH_CAUSE_3_LONG_DESC,TRAF_CNTL_DEVICE_LONG_DESC,LGT_COND_LONG_DESC,RD_SURF_MED_DESC,WTHR_COND_LONG_DESC,TOT_PDO_CNT,EFFECTV_DT,SHAPEfrom distribution.transpor.CRASHMULTIYEAR WHERE ((DATEPART(YEAR, CRASH_DT) in (SELECT max(DATEPART(year, CRASH_DT)) FROM distribution.TRANSPOR.CrashMultiYear)) OR(DATEPART(YEAR, CRASH_DT) in (SELECT (max(DATEPART(year, CRASH_DT))-1) FROM distribution.TRANSPOR.CrashMultiYear)) OR(DATEPART(YEAR, CRASH_DT) in (SELECT (max(DATEPART(year, CRASH_DT))-2) FROM distribution.TRANSPOR.CrashMultiYear)) OR(DATEPART(YEAR, CRASH_DT) in (SELECT (max(DATEPART(year, CRASH_DT))-3) FROM distribution.TRANSPOR.CrashMultiYear)) OR(DATEPART(YEAR, CRASH_DT) in (SELECT (max(DATEPART(year, CRASH_DT))-4) FROM distribution.TRANSPOR.CrashMultiYear))) AND (TOT_INJ_LVL_B_CNT > 0 OR TOT_INJ_LVL_C_CNT > 0) and (TOT_FATAL_CNT = 0 and TOT_INJ_LVL_A_CNT = 0)Crashes -- Property Damage Only (5 years):selectOBJECTID,CRASH_ID,CRASH_DT,CRASH_HR_NO,CRASH_SVRTY_LONG_DESC,TOT_FATAL_CNT,TOT_INJ_LVL_A_CNT,TOT_INJ_LVL_B_CNT,TOT_INJ_LVL_C_CNT,COLLIS_TYP_LONG_DESC,CRASH_TYP_LONG_DESC,CRASH_CAUSE_1_LONG_DESC,CRASH_CAUSE_2_LONG_DESC,CRASH_CAUSE_3_LONG_DESC,TRAF_CNTL_DEVICE_LONG_DESC,LGT_COND_LONG_DESC,RD_SURF_MED_DESC,WTHR_COND_LONG_DESC,TOT_PDO_CNT,EFFECTV_DT,SHAPEfrom distribution.transpor.CRASHMULTIYEAR WHERE ((DATEPART(YEAR, CRASH_DT) in (SELECT max(DATEPART(year, CRASH_DT)) FROM distribution.TRANSPOR.CrashMultiYear)) OR(DATEPART(YEAR, CRASH_DT) in (SELECT (max(DATEPART(year, CRASH_DT))-1) FROM distribution.TRANSPOR.CrashMultiYear)) OR(DATEPART(YEAR, CRASH_DT) in (SELECT (max(DATEPART(year, CRASH_DT))-2) FROM distribution.TRANSPOR.CrashMultiYear)) OR(DATEPART(YEAR, CRASH_DT) in (SELECT (max(DATEPART(year, CRASH_DT))-3) FROM distribution.TRANSPOR.CrashMultiYear)) OR(DATEPART(YEAR, CRASH_DT) in (SELECT (max(DATEPART(year, CRASH_DT))-4) FROM distribution.TRANSPOR.CrashMultiYear))) AND (CRASH_SVRTY_LONG_DESC = 'Property Damage Only')Crashes 2016 (most recent):selectOBJECTID,CRASH_ID,CRASH_DT,CRASH_HR_NO,CRASH_SVRTY_LONG_DESC,TOT_FATAL_CNT,TOT_INJ_LVL_A_CNT,TOT_INJ_LVL_B_CNT,TOT_INJ_LVL_C_CNT,COLLIS_TYP_LONG_DESC,CRASH_TYP_LONG_DESC,CRASH_CAUSE_1_LONG_DESC,CRASH_CAUSE_2_LONG_DESC,CRASH_CAUSE_3_LONG_DESC,TRAF_CNTL_DEVICE_LONG_DESC,LGT_COND_LONG_DESC,RD_SURF_MED_DESC,WTHR_COND_LONG_DESC,TOT_PDO_CNT,EFFECTV_DT,SHAPEfrom distribution.transpor.CRASHMULTIYEARWHERE DATEPART(YEAR, CRASH_DT) in (SELECT max(DATEPART(year, CRASH_DT)) FROM distribution.TRANSPOR.CrashMultiYear)Crashes -- 2015 (most recent -1):selectOBJECTID,CRASH_ID,CRASH_DT,CRASH_HR_NO,CRASH_SVRTY_LONG_DESC,TOT_FATAL_CNT,TOT_INJ_LVL_A_CNT,TOT_INJ_LVL_B_CNT,TOT_INJ_LVL_C_CNT,COLLIS_TYP_LONG_DESC,CRASH_TYP_LONG_DESC,CRASH_CAUSE_1_LONG_DESC,CRASH_CAUSE_2_LONG_DESC,CRASH_CAUSE_3_LONG_DESC,TRAF_CNTL_DEVICE_LONG_DESC,LGT_COND_LONG_DESC,RD_SURF_MED_DESC,WTHR_COND_LONG_DESC,TOT_PDO_CNT,EFFECTV_DT,SHAPEfromdistribution.transpor.CRASHMULTIYEARwheredatepart(YEAR,CRASH_DT)in(SELECT (max(DATEPART(year,CRASH_DT))-1)FROM distribution.TRANSPOR.CrashMultiYear)Crashes -- 2014 (most recent -2):selectOBJECTID,CRASH_ID,CRASH_DT,CRASH_HR_NO,CRASH_SVRTY_LONG_DESC,TOT_FATAL_CNT,TOT_INJ_LVL_A_CNT,TOT_INJ_LVL_B_CNT,TOT_INJ_LVL_C_CNT,COLLIS_TYP_LONG_DESC,CRASH_TYP_LONG_DESC,CRASH_CAUSE_1_LONG_DESC,CRASH_CAUSE_2_LONG_DESC,CRASH_CAUSE_3_LONG_DESC,TRAF_CNTL_DEVICE_LONG_DESC,LGT_COND_LONG_DESC,RD_SURF_MED_DESC,WTHR_COND_LONG_DESC,TOT_PDO_CNT,EFFECTV_DT,SHAPEfromdistribution.transpor.CRASHMULTIYEARwheredatepart(YEAR,CRASH_DT)in(SELECT (max(DATEPART(year,CRASH_DT))-2)FROM distribution.TRANSPOR.CrashMultiYear)Crashes -- 2013 (most recent -3):selectOBJECTID,CRASH_ID,CRASH_DT,CRASH_HR_NO,CRASH_SVRTY_LONG_DESC,TOT_FATAL_CNT,TOT_INJ_LVL_A_CNT,TOT_INJ_LVL_B_CNT,TOT_INJ_LVL_C_CNT,COLLIS_TYP_LONG_DESC,CRASH_TYP_LONG_DESC,CRASH_CAUSE_1_LONG_DESC,CRASH_CAUSE_2_LONG_DESC,CRASH_CAUSE_3_LONG_DESC,TRAF_CNTL_DEVICE_LONG_DESC,LGT_COND_LONG_DESC,RD_SURF_MED_DESC,WTHR_COND_LONG_DESC,TOT_PDO_CNT,EFFECTV_DT,SHAPEfromdistribution.transpor.CRASHMULTIYEARwheredatepart(YEAR,CRASH_DT)in(SELECT (max(DATEPART(year,CRASH_DT))-3)FROM distribution.TRANSPOR.CrashMultiYear)Also As part of the SPIS analysis, one must normalize the data into fatal, injury a, injury b, injury c, and pdo crashes counting the highest level in the crash as '1' for that incident this is the query to produce that:selectOBJECTID,CRASH_ID,SER_NO,CRASH_DT,IIF(TOT_FATAL_CNT >=1,1,0)asFATAL,IIF((TOT_INJ_LVL_A_CNT >=1 AND TOT_FATAL_CNT =0),1,0)as INJ_LVL_A,IIF((TOT_INJ_LVL_B_CNT >=1 ANDTOT_INJ_LVL_A_CNT =0 AND TOT_FATAL_CNT =0),1,0)as INJ_LVL_B,IIF((TOT_INJ_LVL_C_CNT >=1 AND TOT_INJ_LVL_B_CNT =0 AND TOT_INJ_LVL_A_CNT =0 ANDTOT_FATAL_CNT =0),1,0)as INJ_LVL_C,IIF((TOT_PDO_CNT >=1 AND TOT_INJ_LVL_C_CNT =0 AND TOT_INJ_LVL_B_CNT =0 AND TOT_INJ_LVL_A_CNT =0 AND TOT_FATAL_CNT =0),1,0)as PDO,Shapefrom distribution.transpor.CRASHMULTIYEARwheredatepart(YEAR,CRASH_DT)in(2014,2015,2016)</DIV></DIV></DIV>

Service Item Id: 7629e3d9aed943988d3e570e0687c4b9

Copyright Text: ODOT

Default Visibility: false

MaxRecordCount: 5000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 100000.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: false

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

Drawing Info:

Renderer:

Simple Renderer:

Symbol:

Style:

Color:

Size:

Angle:

XOffset:

YOffset:

Outline:

Width:

Label:

Description:

Transparency:

Labeling Info:

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
CRASH_ID ( type: esriFieldTypeInteger, alias: CRASH ID )
CRASH_DT ( type: esriFieldTypeDate, alias: CRASH Date, length: 8 )
CRASH_HR_NO ( type: esriFieldTypeString, alias: CRASH Hour, length: 2 )
CRASH_SVRTY_LONG_DESC ( type: esriFieldTypeString, alias: Crash Severity Desc, length: 25 )
TOT_FATAL_CNT ( type: esriFieldTypeInteger, alias: Total Deaths )
TOT_INJ_LVL_A_CNT ( type: esriFieldTypeInteger, alias: Total Serious Injuries )
TOT_INJ_LVL_B_CNT ( type: esriFieldTypeInteger, alias: Total Moderate Injuries )
TOT_INJ_LVL_C_CNT ( type: esriFieldTypeInteger, alias: Total Minor Injuries )
TOT_PDO_CNT ( type: esriFieldTypeInteger, alias: Total Property Damage Only )
COLLIS_TYP_LONG_DESC ( type: esriFieldTypeString, alias: Collison Type Desc, length: 30 )
CRASH_TYP_LONG_DESC ( type: esriFieldTypeString, alias: Crash Type Desc, length: 75 )
CRASH_CAUSE_1_LONG_DESC ( type: esriFieldTypeString, alias: Crash Cause 1 Desc, length: 50 )
CRASH_CAUSE_2_LONG_DESC ( type: esriFieldTypeString, alias: Crash Cause 2 Desc, length: 50 )
CRASH_CAUSE_3_LONG_DESC ( type: esriFieldTypeString, alias: Crash Cause 3 Desc, length: 50 )
TRAF_CNTL_DEVICE_LONG_DESC ( type: esriFieldTypeString, alias: Traffic Control Device Desc, length: 50 )
LGT_COND_LONG_DESC ( type: esriFieldTypeString, alias: Light Condition Desc, length: 30 )
RD_SURF_MED_DESC ( type: esriFieldTypeString, alias: Road Surface Condition Desc, length: 10 )
WTHR_COND_LONG_DESC ( type: esriFieldTypeString, alias: Weather Desc, length: 10 )
EFFECTV_DT ( type: esriFieldTypeString, alias: Effective Date, length: 4 )

Supported Operations: Query Query Attachments Query Analytic Generate Renderer Return Updates

Iteminfo Thumbnail Metadata