{ "culture": "en-US", "name": "", "guid": "", "catalogPath": "", "snippet": "Oregon Department of Transportation's (ODOT) crash database from the year 2009-2016 (most recent year relased by ODOT).", "description": "

The metadata for this data was largely pulled (almost exclusively) from the ODOT 2017 Code Manual under their supporting files found here:<\/SPAN><\/P>

https://www.oregon.gov/ODOT/Data/documents/CDS_Code_Manual.pdf<\/SPAN><\/P>

There are also some illustrations in there that might be useful.<\/SPAN><\/P>

Please see the indivudual fields for an explanation for the values.<\/SPAN><\/P>

<\/P>

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:<\/SPAN><\/P>

Crashes -- Fatal/Severe (5 years):<\/SPAN><\/P>

select<\/SPAN><\/P>

OBJECTID,<\/SPAN><\/P>

CRASH_ID,<\/SPAN><\/P>

CRASH_DT,<\/SPAN><\/P>

CRASH_HR_NO,<\/SPAN><\/P>

CRASH_SVRTY_LONG_DESC,<\/SPAN><\/P>

TOT_FATAL_CNT,<\/SPAN><\/P>

TOT_INJ_LVL_A_CNT,<\/SPAN><\/P>

TOT_INJ_LVL_B_CNT,<\/SPAN><\/P>

TOT_INJ_LVL_C_CNT,<\/SPAN><\/P>

COLLIS_TYP_LONG_DESC,<\/SPAN><\/P>

CRASH_TYP_LONG_DESC,<\/SPAN><\/P>

CRASH_CAUSE_1_LONG_DESC,<\/SPAN><\/P>

CRASH_CAUSE_2_LONG_DESC,<\/SPAN><\/P>

CRASH_CAUSE_3_LONG_DESC,<\/SPAN><\/P>

TRAF_CNTL_DEVICE_LONG_DESC,<\/SPAN><\/P>

LGT_COND_LONG_DESC,<\/SPAN><\/P>

RD_SURF_MED_DESC,<\/SPAN><\/P>

WTHR_COND_LONG_DESC,<\/SPAN><\/P>

TOT_PDO_CNT,<\/SPAN><\/P>

EFFECTV_DT,<\/SPAN><\/P>

SHAPE<\/SPAN><\/P>

from distribution.transpor.CRASHMULTIYEAR WHERE ((DATEPART(YEAR, CRASH_DT) in (SELECT max(DATEPART(year, CRASH_DT)) FROM distribution.TRANSPOR.CrashMultiYear)) OR<\/SPAN><\/P>

(DATEPART(YEAR, CRASH_DT) in (SELECT (max(DATEPART(year, CRASH_DT))-1) FROM distribution.TRANSPOR.CrashMultiYear)) OR<\/SPAN><\/P>

(DATEPART(YEAR, CRASH_DT) in (SELECT (max(DATEPART(year, CRASH_DT))-2) FROM distribution.TRANSPOR.CrashMultiYear)) OR<\/SPAN><\/P>

(DATEPART(YEAR, CRASH_DT) in (SELECT (max(DATEPART(year, CRASH_DT))-3) FROM distribution.TRANSPOR.CrashMultiYear)) OR<\/SPAN><\/P>

(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)<\/SPAN><\/P>

<\/P>

Crashes -- Minor Injury (5 years):<\/SPAN><\/P>

select<\/SPAN><\/P>

OBJECTID,<\/SPAN><\/P>

CRASH_ID,<\/SPAN><\/P>

CRASH_DT,<\/SPAN><\/P>

CRASH_HR_NO,<\/SPAN><\/P>

CRASH_SVRTY_LONG_DESC,<\/SPAN><\/P>

TOT_FATAL_CNT,<\/SPAN><\/P>

TOT_INJ_LVL_A_CNT,<\/SPAN><\/P>

TOT_INJ_LVL_B_CNT,<\/SPAN><\/P>

TOT_INJ_LVL_C_CNT,<\/SPAN><\/P>

COLLIS_TYP_LONG_DESC,<\/SPAN><\/P>

CRASH_TYP_LONG_DESC,<\/SPAN><\/P>

CRASH_CAUSE_1_LONG_DESC,<\/SPAN><\/P>

CRASH_CAUSE_2_LONG_DESC,<\/SPAN><\/P>

CRASH_CAUSE_3_LONG_DESC,<\/SPAN><\/P>

TRAF_CNTL_DEVICE_LONG_DESC,<\/SPAN><\/P>

LGT_COND_LONG_DESC,<\/SPAN><\/P>

RD_SURF_MED_DESC,<\/SPAN><\/P>

WTHR_COND_LONG_DESC,<\/SPAN><\/P>

TOT_PDO_CNT,<\/SPAN><\/P>

EFFECTV_DT,<\/SPAN><\/P>

SHAPE<\/SPAN><\/P>

from distribution.transpor.CRASHMULTIYEAR WHERE ((DATEPART(YEAR, CRASH_DT) in (SELECT max(DATEPART(year, CRASH_DT)) FROM distribution.TRANSPOR.CrashMultiYear)) OR<\/SPAN><\/P>

(DATEPART(YEAR, CRASH_DT) in (SELECT (max(DATEPART(year, CRASH_DT))-1) FROM distribution.TRANSPOR.CrashMultiYear)) OR<\/SPAN><\/P>

(DATEPART(YEAR, CRASH_DT) in (SELECT (max(DATEPART(year, CRASH_DT))-2) FROM distribution.TRANSPOR.CrashMultiYear)) OR<\/SPAN><\/P>

(DATEPART(YEAR, CRASH_DT) in (SELECT (max(DATEPART(year, CRASH_DT))-3) FROM distribution.TRANSPOR.CrashMultiYear)) OR<\/SPAN><\/P>

(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)<\/SPAN><\/P>

<\/P>

Crashes -- Property Damage Only (5 years):<\/SPAN><\/P>

select<\/SPAN><\/P>

OBJECTID,<\/SPAN><\/P>

CRASH_ID,<\/SPAN><\/P>

CRASH_DT,<\/SPAN><\/P>

CRASH_HR_NO,<\/SPAN><\/P>

CRASH_SVRTY_LONG_DESC,<\/SPAN><\/P>

TOT_FATAL_CNT,<\/SPAN><\/P>

TOT_INJ_LVL_A_CNT,<\/SPAN><\/P>

TOT_INJ_LVL_B_CNT,<\/SPAN><\/P>

TOT_INJ_LVL_C_CNT,<\/SPAN><\/P>

COLLIS_TYP_LONG_DESC,<\/SPAN><\/P>

CRASH_TYP_LONG_DESC,<\/SPAN><\/P>

CRASH_CAUSE_1_LONG_DESC,<\/SPAN><\/P>

CRASH_CAUSE_2_LONG_DESC,<\/SPAN><\/P>

CRASH_CAUSE_3_LONG_DESC,<\/SPAN><\/P>

TRAF_CNTL_DEVICE_LONG_DESC,<\/SPAN><\/P>

LGT_COND_LONG_DESC,<\/SPAN><\/P>

RD_SURF_MED_DESC,<\/SPAN><\/P>

WTHR_COND_LONG_DESC,<\/SPAN><\/P>

TOT_PDO_CNT,<\/SPAN><\/P>

EFFECTV_DT,<\/SPAN><\/P>

SHAPE<\/SPAN><\/P>

from distribution.transpor.CRASHMULTIYEAR WHERE ((DATEPART(YEAR, CRASH_DT) in (SELECT max(DATEPART(year, CRASH_DT)) FROM distribution.TRANSPOR.CrashMultiYear)) OR<\/SPAN><\/P>

(DATEPART(YEAR, CRASH_DT) in (SELECT (max(DATEPART(year, CRASH_DT))-1) FROM distribution.TRANSPOR.CrashMultiYear)) OR<\/SPAN><\/P>

(DATEPART(YEAR, CRASH_DT) in (SELECT (max(DATEPART(year, CRASH_DT))-2) FROM distribution.TRANSPOR.CrashMultiYear)) OR<\/SPAN><\/P>

(DATEPART(YEAR, CRASH_DT) in (SELECT (max(DATEPART(year, CRASH_DT))-3) FROM distribution.TRANSPOR.CrashMultiYear)) OR<\/SPAN><\/P>

(DATEPART(YEAR, CRASH_DT) in (SELECT (max(DATEPART(year, CRASH_DT))-4) FROM distribution.TRANSPOR.CrashMultiYear))) AND (CRASH_SVRTY_LONG_DESC = 'Property Damage Only')<\/SPAN><\/P>

<\/P>

Crashes 2016 (most recent):<\/SPAN><\/P>

select<\/SPAN><\/SPAN><\/P>

OBJECTID<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

CRASH_ID<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

CRASH_DT<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

CRASH_HR_NO<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

CRASH_SVRTY_LONG_DESC<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

TOT_FATAL_CNT<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

TOT_INJ_LVL_A_CNT<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

TOT_INJ_LVL_B_CNT<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

TOT_INJ_LVL_C_CNT<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

COLLIS_TYP_LONG_DESC<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

CRASH_TYP_LONG_DESC<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

CRASH_CAUSE_1_LONG_DESC<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

CRASH_CAUSE_2_LONG_DESC<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

CRASH_CAUSE_3_LONG_DESC<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

TRAF_CNTL_DEVICE_LONG_DESC<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

LGT_COND_LONG_DESC<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

RD_SURF_MED_DESC<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

WTHR_COND_LONG_DESC<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

TOT_PDO_CNT<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

EFFECTV_DT<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

SHAPE<\/SPAN><\/SPAN><\/P>

from <\/SPAN><\/SPAN>distribution<\/SPAN><\/SPAN>.<\/SPAN><\/SPAN>transpor<\/SPAN><\/SPAN>.<\/SPAN><\/SPAN>CRASHMULTIYEAR<\/SPAN><\/SPAN><\/P>

WHERE DATEPART(YEAR, CRASH_DT) in (SELECT max(DATEPART(year, CRASH_DT)) FROM distribution.TRANSPOR.CrashMultiYear)<\/SPAN><\/P>

<\/P>

Crashes -- 2015 (most recent -1):<\/SPAN><\/P>

select<\/SPAN><\/SPAN><\/P>

OBJECTID<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

CRASH_ID<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

CRASH_DT<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

CRASH_HR_NO<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

CRASH_SVRTY_LONG_DESC<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

TOT_FATAL_CNT<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

TOT_INJ_LVL_A_CNT<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

TOT_INJ_LVL_B_CNT<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

TOT_INJ_LVL_C_CNT<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

COLLIS_TYP_LONG_DESC<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

CRASH_TYP_LONG_DESC<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

CRASH_CAUSE_1_LONG_DESC<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

CRASH_CAUSE_2_LONG_DESC<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

CRASH_CAUSE_3_LONG_DESC<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

TRAF_CNTL_DEVICE_LONG_DESC<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

LGT_COND_LONG_DESC<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

RD_SURF_MED_DESC<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

WTHR_COND_LONG_DESC<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

TOT_PDO_CNT<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

EFFECTV_DT<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

SHAPE<\/SPAN><\/SPAN><\/P>

from<\/SPAN><\/SPAN>distribution<\/SPAN><\/SPAN>.<\/SPAN><\/SPAN>transpor<\/SPAN><\/SPAN>.<\/SPAN><\/SPAN>CRASHMULTIYEAR<\/SPAN><\/SPAN><\/P>

where<\/SPAN><\/SPAN>datepart(<\/SPAN>YEAR<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN>CRASH_DT<\/SPAN><\/SPAN>)<\/SPAN><\/SPAN>in<\/SPAN><\/SPAN>(<\/SPAN><\/SPAN>SELECT <\/SPAN><\/SPAN>(<\/SPAN><\/SPAN>max<\/SPAN><\/SPAN>(<\/SPAN><\/SPAN>DATEPART<\/SPAN><\/SPAN>(<\/SPAN><\/SPAN>year<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN>CRASH_DT<\/SPAN><\/SPAN>))-1)<\/SPAN>FROM <\/SPAN><\/SPAN>distribution<\/SPAN><\/SPAN>.<\/SPAN><\/SPAN>TRANSPOR<\/SPAN><\/SPAN>.<\/SPAN><\/SPAN>CrashMultiYear<\/SPAN><\/SPAN>)<\/SPAN><\/SPAN><\/P>

<\/P>

Crashes -- 2014 (most recent -2):<\/SPAN><\/P>

select<\/SPAN><\/SPAN><\/P>

OBJECTID<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

CRASH_ID<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

CRASH_DT<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

CRASH_HR_NO<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

CRASH_SVRTY_LONG_DESC<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

TOT_FATAL_CNT<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

TOT_INJ_LVL_A_CNT<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

TOT_INJ_LVL_B_CNT<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

TOT_INJ_LVL_C_CNT<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

COLLIS_TYP_LONG_DESC<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

CRASH_TYP_LONG_DESC<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

CRASH_CAUSE_1_LONG_DESC<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

CRASH_CAUSE_2_LONG_DESC<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

CRASH_CAUSE_3_LONG_DESC<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

TRAF_CNTL_DEVICE_LONG_DESC<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

LGT_COND_LONG_DESC<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

RD_SURF_MED_DESC<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

WTHR_COND_LONG_DESC<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

TOT_PDO_CNT<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

EFFECTV_DT<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

SHAPE<\/SPAN><\/SPAN><\/P>

from<\/SPAN><\/SPAN>distribution<\/SPAN><\/SPAN>.<\/SPAN><\/SPAN>transpor<\/SPAN><\/SPAN>.<\/SPAN><\/SPAN>CRASHMULTIYEAR<\/SPAN><\/SPAN><\/P>

where<\/SPAN><\/SPAN>datepart(<\/SPAN>YEAR<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN>CRASH_DT<\/SPAN><\/SPAN>)<\/SPAN><\/SPAN>in<\/SPAN><\/SPAN>(<\/SPAN><\/SPAN>SELECT <\/SPAN><\/SPAN>(<\/SPAN><\/SPAN>max<\/SPAN><\/SPAN>(<\/SPAN><\/SPAN>DATEPART<\/SPAN><\/SPAN>(<\/SPAN><\/SPAN>year<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN>CRASH_DT<\/SPAN><\/SPAN>))-2)<\/SPAN>FROM <\/SPAN><\/SPAN>distribution<\/SPAN><\/SPAN>.<\/SPAN><\/SPAN>TRANSPOR<\/SPAN><\/SPAN>.<\/SPAN><\/SPAN>CrashMultiYear<\/SPAN><\/SPAN>)<\/SPAN><\/SPAN><\/P>

<\/P>

Crashes -- 2013 (most recent -3):<\/SPAN><\/P>

select<\/SPAN><\/SPAN><\/P>

OBJECTID<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

CRASH_ID<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

CRASH_DT<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

CRASH_HR_NO<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

CRASH_SVRTY_LONG_DESC<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

TOT_FATAL_CNT<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

TOT_INJ_LVL_A_CNT<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

TOT_INJ_LVL_B_CNT<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

TOT_INJ_LVL_C_CNT<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

COLLIS_TYP_LONG_DESC<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

CRASH_TYP_LONG_DESC<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

CRASH_CAUSE_1_LONG_DESC<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

CRASH_CAUSE_2_LONG_DESC<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

CRASH_CAUSE_3_LONG_DESC<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

TRAF_CNTL_DEVICE_LONG_DESC<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

LGT_COND_LONG_DESC<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

RD_SURF_MED_DESC<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

WTHR_COND_LONG_DESC<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

TOT_PDO_CNT<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

EFFECTV_DT<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

SHAPE<\/SPAN><\/SPAN><\/P>

from<\/SPAN><\/SPAN>distribution<\/SPAN><\/SPAN>.<\/SPAN><\/SPAN>transpor<\/SPAN><\/SPAN>.<\/SPAN><\/SPAN>CRASHMULTIYEAR<\/SPAN><\/SPAN><\/P>

where<\/SPAN><\/SPAN>datepart(<\/SPAN>YEAR<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN>CRASH_DT<\/SPAN><\/SPAN>)<\/SPAN><\/SPAN>in<\/SPAN><\/SPAN>(<\/SPAN><\/SPAN>SELECT <\/SPAN><\/SPAN>(<\/SPAN><\/SPAN>max<\/SPAN><\/SPAN>(<\/SPAN><\/SPAN>DATEPART<\/SPAN><\/SPAN>(<\/SPAN><\/SPAN>year<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN>CRASH_DT<\/SPAN><\/SPAN>))-<\/SPAN><\/SPAN>3<\/SPAN><\/SPAN>)<\/SPAN><\/SPAN>FROM <\/SPAN><\/SPAN>distribution<\/SPAN><\/SPAN>.<\/SPAN><\/SPAN>TRANSPOR<\/SPAN><\/SPAN>.<\/SPAN><\/SPAN>CrashMultiYear<\/SPAN><\/SPAN>)<\/SPAN><\/SPAN><\/P>

<\/P>

Also <\/SPAN><\/P>

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:<\/SPAN><\/P>

select<\/SPAN><\/SPAN><\/P>

OBJECTID<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

CRASH_ID<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

SER_NO<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

CRASH_DT<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

IIF<\/SPAN><\/SPAN>(<\/SPAN><\/SPAN>TOT_FATAL_CNT <\/SPAN><\/SPAN>>=<\/SPAN><\/SPAN>1<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN>1<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN>0<\/SPAN><\/SPAN>)<\/SPAN><\/SPAN>as<\/SPAN><\/SPAN>FATAL<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

IIF<\/SPAN><\/SPAN>((<\/SPAN><\/SPAN>TOT_INJ_LVL_A_CNT <\/SPAN><\/SPAN>>=<\/SPAN><\/SPAN>1 <\/SPAN><\/SPAN>AND <\/SPAN><\/SPAN>TOT_FATAL_CNT <\/SPAN><\/SPAN>=<\/SPAN><\/SPAN>0<\/SPAN><\/SPAN>),<\/SPAN><\/SPAN>1<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN>0<\/SPAN><\/SPAN>)<\/SPAN><\/SPAN>as <\/SPAN><\/SPAN>INJ_LVL_A<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

IIF<\/SPAN><\/SPAN>((<\/SPAN><\/SPAN>TOT_INJ_LVL_B_CNT <\/SPAN><\/SPAN>>=<\/SPAN><\/SPAN>1 <\/SPAN><\/SPAN>AND<\/SPAN><\/SPAN>TOT_INJ_LVL_A_CNT <\/SPAN><\/SPAN>=<\/SPAN><\/SPAN>0 <\/SPAN><\/SPAN>AND <\/SPAN><\/SPAN>TOT_FATAL_CNT <\/SPAN><\/SPAN>=<\/SPAN><\/SPAN>0<\/SPAN><\/SPAN>),<\/SPAN><\/SPAN>1<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN>0<\/SPAN><\/SPAN>)<\/SPAN><\/SPAN>as <\/SPAN><\/SPAN>INJ_LVL_B<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

IIF<\/SPAN><\/SPAN>((<\/SPAN><\/SPAN>TOT_INJ_LVL_C_CNT <\/SPAN><\/SPAN>>=<\/SPAN><\/SPAN>1 <\/SPAN><\/SPAN>AND <\/SPAN><\/SPAN>TOT_INJ_LVL_B_CNT <\/SPAN><\/SPAN>=<\/SPAN><\/SPAN>0 <\/SPAN><\/SPAN>AND <\/SPAN><\/SPAN>TOT_INJ_LVL_A_CNT <\/SPAN><\/SPAN>=<\/SPAN><\/SPAN>0 <\/SPAN><\/SPAN>AND<\/SPAN><\/SPAN>TOT_FATAL_CNT <\/SPAN><\/SPAN>=<\/SPAN><\/SPAN>0<\/SPAN><\/SPAN>),<\/SPAN><\/SPAN>1<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN>0<\/SPAN><\/SPAN>)<\/SPAN><\/SPAN>as <\/SPAN><\/SPAN>INJ_LVL_C<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

IIF<\/SPAN><\/SPAN>((<\/SPAN><\/SPAN>TOT_PDO_CNT <\/SPAN><\/SPAN>>=<\/SPAN><\/SPAN>1 <\/SPAN><\/SPAN>AND <\/SPAN><\/SPAN>TOT_INJ_LVL_C_CNT <\/SPAN><\/SPAN>=<\/SPAN><\/SPAN>0 <\/SPAN><\/SPAN>AND <\/SPAN><\/SPAN>TOT_INJ_LVL_B_CNT <\/SPAN><\/SPAN>=<\/SPAN><\/SPAN>0 <\/SPAN><\/SPAN>AND <\/SPAN><\/SPAN>TOT_INJ_LVL_A_CNT <\/SPAN><\/SPAN>=<\/SPAN><\/SPAN>0 <\/SPAN><\/SPAN>AND <\/SPAN><\/SPAN>TOT_FATAL_CNT <\/SPAN><\/SPAN>=<\/SPAN><\/SPAN>0<\/SPAN><\/SPAN>),<\/SPAN><\/SPAN>1<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN>0<\/SPAN><\/SPAN>)<\/SPAN><\/SPAN>as <\/SPAN><\/SPAN>PDO<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN><\/P>

Shape<\/SPAN><\/SPAN><\/P>

from <\/SPAN><\/SPAN>distribution<\/SPAN><\/SPAN>.<\/SPAN><\/SPAN>transpor<\/SPAN><\/SPAN>.<\/SPAN><\/SPAN>CRASHMULTIYEAR<\/SPAN><\/SPAN><\/P>

where<\/SPAN><\/SPAN>datepart<\/SPAN><\/SPAN>(YEAR,<\/SPAN>CRASH_DT<\/SPAN><\/SPAN>)<\/SPAN><\/SPAN>in<\/SPAN><\/SPAN>(<\/SPAN><\/SPAN>2014<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN>2015<\/SPAN><\/SPAN>,<\/SPAN><\/SPAN>2016<\/SPAN>)<\/SPAN><\/P><\/DIV><\/DIV><\/DIV>", "summary": "Oregon Department of Transportation's (ODOT) crash database from the year 2009-2016 (most recent year relased by ODOT).", "title": "distribution.TRANSPOR.CrashMultiYear", "tags": [ "crashes", "vehicle", "Oregon", "department", "transportation", "ODOT", "Washington", "County" ], "type": "", "typeKeywords": [], "thumbnail": "", "url": "", "minScale": 150000000, "maxScale": 5000, "spatialReference": "", "accessInformation": "ODOT", "licenseInfo": "" }