{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 19, "name": "Crash Data Most Recent", "type": "Feature Layer", "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>", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 2913, "latestWkid": 2913, "xyTolerance": 0.0032808398950131233, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -111333600, "falseY": -98152500, "xyUnits": 3048, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "ODOT", "parentLayer": null, "subLayers": [], "minScale": 100000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 197, 0, 255, 255 ], "size": 6, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": -1.3739723321947252E7, "ymin": 5669586.156394371, "xmax": -1.3662211059743213E7, "ymax": 5747235.814170351, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 1.4892314192838538E8, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "CRASH_ID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CRASH_ID", "type": "esriFieldTypeInteger", "alias": "CRASH ID", "domain": null }, { "name": "CRASH_DT", "type": "esriFieldTypeDate", "alias": "CRASH Date", "length": 8, "domain": null }, { "name": "CRASH_HR_NO", "type": "esriFieldTypeString", "alias": "CRASH Hour", "length": 2, "domain": null }, { "name": "CRASH_SVRTY_LONG_DESC", "type": "esriFieldTypeString", "alias": "Crash Severity Desc", "length": 25, "domain": null }, { "name": "TOT_FATAL_CNT", "type": "esriFieldTypeInteger", "alias": "Total Deaths", "domain": null }, { "name": "TOT_INJ_LVL_A_CNT", "type": "esriFieldTypeInteger", "alias": "Total Serious Injuries", "domain": null }, { "name": "TOT_INJ_LVL_B_CNT", "type": "esriFieldTypeInteger", "alias": "Total Moderate Injuries", "domain": null }, { "name": "TOT_INJ_LVL_C_CNT", "type": "esriFieldTypeInteger", "alias": "Total Minor Injuries", "domain": null }, { "name": "TOT_PDO_CNT", "type": "esriFieldTypeInteger", "alias": "Total Property Damage Only", "domain": null }, { "name": "COLLIS_TYP_LONG_DESC", "type": "esriFieldTypeString", "alias": "Collison Type Desc", "length": 30, "domain": null }, { "name": "CRASH_TYP_LONG_DESC", "type": "esriFieldTypeString", "alias": "Crash Type Desc", "length": 75, "domain": null }, { "name": "CRASH_CAUSE_1_LONG_DESC", "type": "esriFieldTypeString", "alias": "Crash Cause 1 Desc", "length": 50, "domain": null }, { "name": "CRASH_CAUSE_2_LONG_DESC", "type": "esriFieldTypeString", "alias": "Crash Cause 2 Desc", "length": 50, "domain": null }, { "name": "CRASH_CAUSE_3_LONG_DESC", "type": "esriFieldTypeString", "alias": "Crash Cause 3 Desc", "length": 50, "domain": null }, { "name": "TRAF_CNTL_DEVICE_LONG_DESC", "type": "esriFieldTypeString", "alias": "Traffic Control Device Desc", "length": 50, "domain": null }, { "name": "LGT_COND_LONG_DESC", "type": "esriFieldTypeString", "alias": "Light Condition Desc", "length": 30, "domain": null }, { "name": "RD_SURF_MED_DESC", "type": "esriFieldTypeString", "alias": "Road Surface Condition Desc", "length": 10, "domain": null }, { "name": "WTHR_COND_LONG_DESC", "type": "esriFieldTypeString", "alias": "Weather Desc", "length": 10, "domain": null }, { "name": "EFFECTV_DT", "type": "esriFieldTypeString", "alias": "Effective Date", "length": 4, "domain": null } ], "geometryField": {}, "indexes": [ { "name": "R30184_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "IDX_CrashData", "fields": "CRASH_DT,TOT_FATAL_CNT,TOT_INJ_LVL_A_CNT,TOT_INJ_LVL_B_CNT,TOT_INJ_LVL_C_CNT,TOT_PDO_CNT", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IDX_4AB", "fields": "CRASH_ID,EFFECTV_DT", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": false, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 5000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "7629e3d9aed943988d3e570e0687c4b9" }