{
 "currentVersion": 11.1,
 "cimVersion": "3.1.0",
 "id": 17,
 "name": "Minor Injury Crashes - 5 yrs",
 "type": "Feature Layer",
 "description": "<DIV STYLE=\"text-align:Left;\"><DIV><DIV><P><SPAN>The metadata for this data was largely pulled (almost exclusively) from the ODOT 2017 Code Manual under their supporting files found here:<\/SPAN><\/P><P><SPAN>https://www.oregon.gov/ODOT/Data/documents/CDS_Code_Manual.pdf<\/SPAN><\/P><P><SPAN>There are also some illustrations in there that might be useful.<\/SPAN><\/P><P><SPAN>Please see the indivudual fields for an explanation for the values.<\/SPAN><\/P><P><SPAN /><\/P><P><SPAN>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><P><SPAN>Crashes -- Fatal/Severe (5 years):<\/SPAN><\/P><P><SPAN>select<\/SPAN><\/P><P><SPAN>OBJECTID,<\/SPAN><\/P><P><SPAN>CRASH_ID,<\/SPAN><\/P><P><SPAN>CRASH_DT,<\/SPAN><\/P><P><SPAN>CRASH_HR_NO,<\/SPAN><\/P><P><SPAN>CRASH_SVRTY_LONG_DESC,<\/SPAN><\/P><P><SPAN>TOT_FATAL_CNT,<\/SPAN><\/P><P><SPAN>TOT_INJ_LVL_A_CNT,<\/SPAN><\/P><P><SPAN>TOT_INJ_LVL_B_CNT,<\/SPAN><\/P><P><SPAN>TOT_INJ_LVL_C_CNT,<\/SPAN><\/P><P><SPAN>COLLIS_TYP_LONG_DESC,<\/SPAN><\/P><P><SPAN>CRASH_TYP_LONG_DESC,<\/SPAN><\/P><P><SPAN>CRASH_CAUSE_1_LONG_DESC,<\/SPAN><\/P><P><SPAN>CRASH_CAUSE_2_LONG_DESC,<\/SPAN><\/P><P><SPAN>CRASH_CAUSE_3_LONG_DESC,<\/SPAN><\/P><P><SPAN>TRAF_CNTL_DEVICE_LONG_DESC,<\/SPAN><\/P><P><SPAN>LGT_COND_LONG_DESC,<\/SPAN><\/P><P><SPAN>RD_SURF_MED_DESC,<\/SPAN><\/P><P><SPAN>WTHR_COND_LONG_DESC,<\/SPAN><\/P><P><SPAN>TOT_PDO_CNT,<\/SPAN><\/P><P><SPAN>EFFECTV_DT,<\/SPAN><\/P><P><SPAN>SHAPE<\/SPAN><\/P><P><SPAN>from distribution.transpor.CRASHMULTIYEAR WHERE ((DATEPART(YEAR, CRASH_DT) in (SELECT max(DATEPART(year, CRASH_DT)) FROM distribution.TRANSPOR.CrashMultiYear)) OR<\/SPAN><\/P><P><SPAN>(DATEPART(YEAR, CRASH_DT) in (SELECT (max(DATEPART(year, CRASH_DT))-1) FROM distribution.TRANSPOR.CrashMultiYear)) OR<\/SPAN><\/P><P><SPAN>(DATEPART(YEAR, CRASH_DT) in (SELECT (max(DATEPART(year, CRASH_DT))-2) FROM distribution.TRANSPOR.CrashMultiYear)) OR<\/SPAN><\/P><P><SPAN>(DATEPART(YEAR, CRASH_DT) in (SELECT (max(DATEPART(year, CRASH_DT))-3) FROM distribution.TRANSPOR.CrashMultiYear)) OR<\/SPAN><\/P><P><SPAN>(DATEPART(YEAR, CRASH_DT) in (SELECT (max(DATEPART(year, CRASH_DT))-4) FROM distribution.TRANSPOR.CrashMultiYear))) AND (TOT_INJ_LVL_B_CNT &gt; 0 OR TOT_INJ_LVL_C_CNT &gt; 0) AND (TOT_FATAL_CNT &gt; 0 OR TOT_INJ_LVL_A_CNT &gt; 0)<\/SPAN><\/P><P><SPAN /><\/P><P><SPAN>Crashes -- Minor Injury (5 years):<\/SPAN><\/P><P><SPAN>select<\/SPAN><\/P><P><SPAN>OBJECTID,<\/SPAN><\/P><P><SPAN>CRASH_ID,<\/SPAN><\/P><P><SPAN>CRASH_DT,<\/SPAN><\/P><P><SPAN>CRASH_HR_NO,<\/SPAN><\/P><P><SPAN>CRASH_SVRTY_LONG_DESC,<\/SPAN><\/P><P><SPAN>TOT_FATAL_CNT,<\/SPAN><\/P><P><SPAN>TOT_INJ_LVL_A_CNT,<\/SPAN><\/P><P><SPAN>TOT_INJ_LVL_B_CNT,<\/SPAN><\/P><P><SPAN>TOT_INJ_LVL_C_CNT,<\/SPAN><\/P><P><SPAN>COLLIS_TYP_LONG_DESC,<\/SPAN><\/P><P><SPAN>CRASH_TYP_LONG_DESC,<\/SPAN><\/P><P><SPAN>CRASH_CAUSE_1_LONG_DESC,<\/SPAN><\/P><P><SPAN>CRASH_CAUSE_2_LONG_DESC,<\/SPAN><\/P><P><SPAN>CRASH_CAUSE_3_LONG_DESC,<\/SPAN><\/P><P><SPAN>TRAF_CNTL_DEVICE_LONG_DESC,<\/SPAN><\/P><P><SPAN>LGT_COND_LONG_DESC,<\/SPAN><\/P><P><SPAN>RD_SURF_MED_DESC,<\/SPAN><\/P><P><SPAN>WTHR_COND_LONG_DESC,<\/SPAN><\/P><P><SPAN>TOT_PDO_CNT,<\/SPAN><\/P><P><SPAN>EFFECTV_DT,<\/SPAN><\/P><P><SPAN>SHAPE<\/SPAN><\/P><P><SPAN>from distribution.transpor.CRASHMULTIYEAR WHERE ((DATEPART(YEAR, CRASH_DT) in (SELECT max(DATEPART(year, CRASH_DT)) FROM distribution.TRANSPOR.CrashMultiYear)) OR<\/SPAN><\/P><P><SPAN>(DATEPART(YEAR, CRASH_DT) in (SELECT (max(DATEPART(year, CRASH_DT))-1) FROM distribution.TRANSPOR.CrashMultiYear)) OR<\/SPAN><\/P><P><SPAN>(DATEPART(YEAR, CRASH_DT) in (SELECT (max(DATEPART(year, CRASH_DT))-2) FROM distribution.TRANSPOR.CrashMultiYear)) OR<\/SPAN><\/P><P><SPAN>(DATEPART(YEAR, CRASH_DT) in (SELECT (max(DATEPART(year, CRASH_DT))-3) FROM distribution.TRANSPOR.CrashMultiYear)) OR<\/SPAN><\/P><P><SPAN>(DATEPART(YEAR, CRASH_DT) in (SELECT (max(DATEPART(year, CRASH_DT))-4) FROM distribution.TRANSPOR.CrashMultiYear))) AND (TOT_INJ_LVL_B_CNT &gt; 0 OR TOT_INJ_LVL_C_CNT &gt; 0) and (TOT_FATAL_CNT = 0 and TOT_INJ_LVL_A_CNT = 0)<\/SPAN><\/P><P><SPAN /><\/P><P><SPAN>Crashes -- Property Damage Only (5 years):<\/SPAN><\/P><P><SPAN>select<\/SPAN><\/P><P><SPAN>OBJECTID,<\/SPAN><\/P><P><SPAN>CRASH_ID,<\/SPAN><\/P><P><SPAN>CRASH_DT,<\/SPAN><\/P><P><SPAN>CRASH_HR_NO,<\/SPAN><\/P><P><SPAN>CRASH_SVRTY_LONG_DESC,<\/SPAN><\/P><P><SPAN>TOT_FATAL_CNT,<\/SPAN><\/P><P><SPAN>TOT_INJ_LVL_A_CNT,<\/SPAN><\/P><P><SPAN>TOT_INJ_LVL_B_CNT,<\/SPAN><\/P><P><SPAN>TOT_INJ_LVL_C_CNT,<\/SPAN><\/P><P><SPAN>COLLIS_TYP_LONG_DESC,<\/SPAN><\/P><P><SPAN>CRASH_TYP_LONG_DESC,<\/SPAN><\/P><P><SPAN>CRASH_CAUSE_1_LONG_DESC,<\/SPAN><\/P><P><SPAN>CRASH_CAUSE_2_LONG_DESC,<\/SPAN><\/P><P><SPAN>CRASH_CAUSE_3_LONG_DESC,<\/SPAN><\/P><P><SPAN>TRAF_CNTL_DEVICE_LONG_DESC,<\/SPAN><\/P><P><SPAN>LGT_COND_LONG_DESC,<\/SPAN><\/P><P><SPAN>RD_SURF_MED_DESC,<\/SPAN><\/P><P><SPAN>WTHR_COND_LONG_DESC,<\/SPAN><\/P><P><SPAN>TOT_PDO_CNT,<\/SPAN><\/P><P><SPAN>EFFECTV_DT,<\/SPAN><\/P><P><SPAN>SHAPE<\/SPAN><\/P><P><SPAN>from distribution.transpor.CRASHMULTIYEAR WHERE ((DATEPART(YEAR, CRASH_DT) in (SELECT max(DATEPART(year, CRASH_DT)) FROM distribution.TRANSPOR.CrashMultiYear)) OR<\/SPAN><\/P><P><SPAN>(DATEPART(YEAR, CRASH_DT) in (SELECT (max(DATEPART(year, CRASH_DT))-1) FROM distribution.TRANSPOR.CrashMultiYear)) OR<\/SPAN><\/P><P><SPAN>(DATEPART(YEAR, CRASH_DT) in (SELECT (max(DATEPART(year, CRASH_DT))-2) FROM distribution.TRANSPOR.CrashMultiYear)) OR<\/SPAN><\/P><P><SPAN>(DATEPART(YEAR, CRASH_DT) in (SELECT (max(DATEPART(year, CRASH_DT))-3) FROM distribution.TRANSPOR.CrashMultiYear)) OR<\/SPAN><\/P><P><SPAN>(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><SPAN /><\/P><P><SPAN>Crashes 2016 (most recent):<\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>select<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>OBJECTID<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>CRASH_ID<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>CRASH_DT<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>CRASH_HR_NO<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>CRASH_SVRTY_LONG_DESC<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>TOT_FATAL_CNT<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>TOT_INJ_LVL_A_CNT<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>TOT_INJ_LVL_B_CNT<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>TOT_INJ_LVL_C_CNT<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>COLLIS_TYP_LONG_DESC<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>CRASH_TYP_LONG_DESC<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>CRASH_CAUSE_1_LONG_DESC<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>CRASH_CAUSE_2_LONG_DESC<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>CRASH_CAUSE_3_LONG_DESC<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>TRAF_CNTL_DEVICE_LONG_DESC<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>LGT_COND_LONG_DESC<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>RD_SURF_MED_DESC<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>WTHR_COND_LONG_DESC<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>TOT_PDO_CNT<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>EFFECTV_DT<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>SHAPE<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>from <\/SPAN><\/SPAN><SPAN /><SPAN /><SPAN><SPAN>distribution<\/SPAN><\/SPAN><SPAN><SPAN>.<\/SPAN><\/SPAN><SPAN><SPAN>transpor<\/SPAN><\/SPAN><SPAN><SPAN>.<\/SPAN><\/SPAN><SPAN><SPAN>CRASHMULTIYEAR<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN>WHERE DATEPART(YEAR, CRASH_DT) in (SELECT max(DATEPART(year, CRASH_DT)) FROM distribution.TRANSPOR.CrashMultiYear)<\/SPAN><\/P><P><SPAN /><\/P><P><SPAN>Crashes -- 2015 (most recent -1):<\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>select<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>OBJECTID<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>CRASH_ID<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>CRASH_DT<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>CRASH_HR_NO<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>CRASH_SVRTY_LONG_DESC<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>TOT_FATAL_CNT<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>TOT_INJ_LVL_A_CNT<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>TOT_INJ_LVL_B_CNT<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>TOT_INJ_LVL_C_CNT<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>COLLIS_TYP_LONG_DESC<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>CRASH_TYP_LONG_DESC<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>CRASH_CAUSE_1_LONG_DESC<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>CRASH_CAUSE_2_LONG_DESC<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>CRASH_CAUSE_3_LONG_DESC<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>TRAF_CNTL_DEVICE_LONG_DESC<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>LGT_COND_LONG_DESC<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>RD_SURF_MED_DESC<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>WTHR_COND_LONG_DESC<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>TOT_PDO_CNT<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>EFFECTV_DT<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>SHAPE<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>from<\/SPAN><\/SPAN><SPAN /><SPAN /><SPAN><SPAN>distribution<\/SPAN><\/SPAN><SPAN><SPAN>.<\/SPAN><\/SPAN><SPAN><SPAN>transpor<\/SPAN><\/SPAN><SPAN><SPAN>.<\/SPAN><\/SPAN><SPAN><SPAN>CRASHMULTIYEAR<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>where<\/SPAN><\/SPAN><SPAN /><SPAN /><SPAN>datepart(<\/SPAN><SPAN><SPAN>YEAR<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><SPAN><SPAN>CRASH_DT<\/SPAN><\/SPAN><SPAN><SPAN>)<\/SPAN><\/SPAN><SPAN /><SPAN /><SPAN><SPAN>in<\/SPAN><\/SPAN><SPAN /><SPAN /><SPAN><SPAN>(<\/SPAN><\/SPAN><SPAN><SPAN>SELECT <\/SPAN><\/SPAN><SPAN><SPAN>(<\/SPAN><\/SPAN><SPAN><SPAN>max<\/SPAN><\/SPAN><SPAN><SPAN>(<\/SPAN><\/SPAN><SPAN><SPAN>DATEPART<\/SPAN><\/SPAN><SPAN><SPAN>(<\/SPAN><\/SPAN><SPAN><SPAN>year<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><SPAN><SPAN>CRASH_DT<\/SPAN><\/SPAN><SPAN>))-1)<\/SPAN><SPAN /><SPAN /><SPAN><SPAN>FROM <\/SPAN><\/SPAN><SPAN /><SPAN /><SPAN><SPAN>distribution<\/SPAN><\/SPAN><SPAN><SPAN>.<\/SPAN><\/SPAN><SPAN><SPAN>TRANSPOR<\/SPAN><\/SPAN><SPAN><SPAN>.<\/SPAN><\/SPAN><SPAN><SPAN>CrashMultiYear<\/SPAN><\/SPAN><SPAN><SPAN>)<\/SPAN><\/SPAN><\/P><P><SPAN /><\/P><P><SPAN>Crashes -- 2014 (most recent -2):<\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>select<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>OBJECTID<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>CRASH_ID<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>CRASH_DT<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>CRASH_HR_NO<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>CRASH_SVRTY_LONG_DESC<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>TOT_FATAL_CNT<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>TOT_INJ_LVL_A_CNT<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>TOT_INJ_LVL_B_CNT<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>TOT_INJ_LVL_C_CNT<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>COLLIS_TYP_LONG_DESC<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>CRASH_TYP_LONG_DESC<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>CRASH_CAUSE_1_LONG_DESC<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>CRASH_CAUSE_2_LONG_DESC<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>CRASH_CAUSE_3_LONG_DESC<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>TRAF_CNTL_DEVICE_LONG_DESC<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>LGT_COND_LONG_DESC<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>RD_SURF_MED_DESC<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>WTHR_COND_LONG_DESC<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>TOT_PDO_CNT<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>EFFECTV_DT<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>SHAPE<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>from<\/SPAN><\/SPAN><SPAN /><SPAN /><SPAN><SPAN>distribution<\/SPAN><\/SPAN><SPAN><SPAN>.<\/SPAN><\/SPAN><SPAN><SPAN>transpor<\/SPAN><\/SPAN><SPAN><SPAN>.<\/SPAN><\/SPAN><SPAN><SPAN>CRASHMULTIYEAR<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>where<\/SPAN><\/SPAN><SPAN /><SPAN /><SPAN>datepart(<\/SPAN><SPAN><SPAN>YEAR<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><SPAN><SPAN>CRASH_DT<\/SPAN><\/SPAN><SPAN><SPAN>)<\/SPAN><\/SPAN><SPAN /><SPAN /><SPAN><SPAN>in<\/SPAN><\/SPAN><SPAN /><SPAN /><SPAN><SPAN>(<\/SPAN><\/SPAN><SPAN><SPAN>SELECT <\/SPAN><\/SPAN><SPAN><SPAN>(<\/SPAN><\/SPAN><SPAN><SPAN>max<\/SPAN><\/SPAN><SPAN><SPAN>(<\/SPAN><\/SPAN><SPAN><SPAN>DATEPART<\/SPAN><\/SPAN><SPAN><SPAN>(<\/SPAN><\/SPAN><SPAN><SPAN>year<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><SPAN><SPAN>CRASH_DT<\/SPAN><\/SPAN><SPAN>))-2)<\/SPAN><SPAN /><SPAN /><SPAN><SPAN>FROM <\/SPAN><\/SPAN><SPAN /><SPAN /><SPAN><SPAN>distribution<\/SPAN><\/SPAN><SPAN><SPAN>.<\/SPAN><\/SPAN><SPAN><SPAN>TRANSPOR<\/SPAN><\/SPAN><SPAN><SPAN>.<\/SPAN><\/SPAN><SPAN><SPAN>CrashMultiYear<\/SPAN><\/SPAN><SPAN><SPAN>)<\/SPAN><\/SPAN><\/P><P><SPAN /><\/P><P><SPAN>Crashes -- 2013 (most recent -3):<\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>select<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>OBJECTID<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>CRASH_ID<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>CRASH_DT<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>CRASH_HR_NO<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>CRASH_SVRTY_LONG_DESC<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>TOT_FATAL_CNT<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>TOT_INJ_LVL_A_CNT<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>TOT_INJ_LVL_B_CNT<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>TOT_INJ_LVL_C_CNT<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>COLLIS_TYP_LONG_DESC<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>CRASH_TYP_LONG_DESC<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>CRASH_CAUSE_1_LONG_DESC<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>CRASH_CAUSE_2_LONG_DESC<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>CRASH_CAUSE_3_LONG_DESC<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>TRAF_CNTL_DEVICE_LONG_DESC<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>LGT_COND_LONG_DESC<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>RD_SURF_MED_DESC<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>WTHR_COND_LONG_DESC<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>TOT_PDO_CNT<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>EFFECTV_DT<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>SHAPE<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>from<\/SPAN><\/SPAN><SPAN /><SPAN /><SPAN><SPAN>distribution<\/SPAN><\/SPAN><SPAN><SPAN>.<\/SPAN><\/SPAN><SPAN><SPAN>transpor<\/SPAN><\/SPAN><SPAN><SPAN>.<\/SPAN><\/SPAN><SPAN><SPAN>CRASHMULTIYEAR<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>where<\/SPAN><\/SPAN><SPAN /><SPAN /><SPAN>datepart(<\/SPAN><SPAN><SPAN>YEAR<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><SPAN><SPAN>CRASH_DT<\/SPAN><\/SPAN><SPAN><SPAN>)<\/SPAN><\/SPAN><SPAN /><SPAN /><SPAN><SPAN>in<\/SPAN><\/SPAN><SPAN /><SPAN /><SPAN><SPAN>(<\/SPAN><\/SPAN><SPAN><SPAN>SELECT <\/SPAN><\/SPAN><SPAN><SPAN>(<\/SPAN><\/SPAN><SPAN><SPAN>max<\/SPAN><\/SPAN><SPAN><SPAN>(<\/SPAN><\/SPAN><SPAN><SPAN>DATEPART<\/SPAN><\/SPAN><SPAN><SPAN>(<\/SPAN><\/SPAN><SPAN><SPAN>year<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><SPAN><SPAN>CRASH_DT<\/SPAN><\/SPAN><SPAN><SPAN>))-<\/SPAN><\/SPAN><SPAN><SPAN>3<\/SPAN><\/SPAN><SPAN><SPAN>)<\/SPAN><\/SPAN><SPAN /><SPAN /><SPAN><SPAN>FROM <\/SPAN><\/SPAN><SPAN /><SPAN /><SPAN><SPAN>distribution<\/SPAN><\/SPAN><SPAN><SPAN>.<\/SPAN><\/SPAN><SPAN><SPAN>TRANSPOR<\/SPAN><\/SPAN><SPAN><SPAN>.<\/SPAN><\/SPAN><SPAN><SPAN>CrashMultiYear<\/SPAN><\/SPAN><SPAN><SPAN>)<\/SPAN><\/SPAN><\/P><P><SPAN /><\/P><P><SPAN>Also <\/SPAN><\/P><P><SPAN>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><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>select<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>OBJECTID<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>CRASH_ID<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>SER_NO<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>CRASH_DT<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>IIF<\/SPAN><\/SPAN><SPAN><SPAN>(<\/SPAN><\/SPAN><SPAN><SPAN>TOT_FATAL_CNT <\/SPAN><\/SPAN><SPAN><SPAN>&gt;=<\/SPAN><\/SPAN><SPAN><SPAN>1<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><SPAN><SPAN>1<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><SPAN><SPAN>0<\/SPAN><\/SPAN><SPAN><SPAN>)<\/SPAN><\/SPAN><SPAN /><SPAN /><SPAN><SPAN>as<\/SPAN><\/SPAN><SPAN><SPAN>FATAL<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>IIF<\/SPAN><\/SPAN><SPAN><SPAN>((<\/SPAN><\/SPAN><SPAN><SPAN>TOT_INJ_LVL_A_CNT <\/SPAN><\/SPAN><SPAN><SPAN>&gt;=<\/SPAN><\/SPAN><SPAN><SPAN>1 <\/SPAN><\/SPAN><SPAN><SPAN>AND <\/SPAN><\/SPAN><SPAN><SPAN>TOT_FATAL_CNT <\/SPAN><\/SPAN><SPAN><SPAN>=<\/SPAN><\/SPAN><SPAN><SPAN>0<\/SPAN><\/SPAN><SPAN><SPAN>),<\/SPAN><\/SPAN><SPAN><SPAN>1<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><SPAN><SPAN>0<\/SPAN><\/SPAN><SPAN><SPAN>)<\/SPAN><\/SPAN><SPAN /><SPAN /><SPAN><SPAN>as <\/SPAN><\/SPAN><SPAN><SPAN>INJ_LVL_A<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>IIF<\/SPAN><\/SPAN><SPAN><SPAN>((<\/SPAN><\/SPAN><SPAN><SPAN>TOT_INJ_LVL_B_CNT <\/SPAN><\/SPAN><SPAN><SPAN>&gt;=<\/SPAN><\/SPAN><SPAN><SPAN>1 <\/SPAN><\/SPAN><SPAN><SPAN>AND<\/SPAN><\/SPAN><SPAN><SPAN>TOT_INJ_LVL_A_CNT <\/SPAN><\/SPAN><SPAN><SPAN>=<\/SPAN><\/SPAN><SPAN><SPAN>0 <\/SPAN><\/SPAN><SPAN><SPAN>AND <\/SPAN><\/SPAN><SPAN><SPAN>TOT_FATAL_CNT <\/SPAN><\/SPAN><SPAN><SPAN>=<\/SPAN><\/SPAN><SPAN><SPAN>0<\/SPAN><\/SPAN><SPAN><SPAN>),<\/SPAN><\/SPAN><SPAN><SPAN>1<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><SPAN><SPAN>0<\/SPAN><\/SPAN><SPAN><SPAN>)<\/SPAN><\/SPAN><SPAN /><SPAN /><SPAN><SPAN>as <\/SPAN><\/SPAN><SPAN><SPAN>INJ_LVL_B<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>IIF<\/SPAN><\/SPAN><SPAN><SPAN>((<\/SPAN><\/SPAN><SPAN><SPAN>TOT_INJ_LVL_C_CNT <\/SPAN><\/SPAN><SPAN><SPAN>&gt;=<\/SPAN><\/SPAN><SPAN><SPAN>1 <\/SPAN><\/SPAN><SPAN><SPAN>AND <\/SPAN><\/SPAN><SPAN><SPAN>TOT_INJ_LVL_B_CNT <\/SPAN><\/SPAN><SPAN><SPAN>=<\/SPAN><\/SPAN><SPAN><SPAN>0 <\/SPAN><\/SPAN><SPAN><SPAN>AND <\/SPAN><\/SPAN><SPAN><SPAN>TOT_INJ_LVL_A_CNT <\/SPAN><\/SPAN><SPAN><SPAN>=<\/SPAN><\/SPAN><SPAN><SPAN>0 <\/SPAN><\/SPAN><SPAN><SPAN>AND<\/SPAN><\/SPAN><SPAN><SPAN>TOT_FATAL_CNT <\/SPAN><\/SPAN><SPAN><SPAN>=<\/SPAN><\/SPAN><SPAN><SPAN>0<\/SPAN><\/SPAN><SPAN><SPAN>),<\/SPAN><\/SPAN><SPAN><SPAN>1<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><SPAN><SPAN>0<\/SPAN><\/SPAN><SPAN><SPAN>)<\/SPAN><\/SPAN><SPAN /><SPAN /><SPAN><SPAN>as <\/SPAN><\/SPAN><SPAN><SPAN>INJ_LVL_C<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>IIF<\/SPAN><\/SPAN><SPAN><SPAN>((<\/SPAN><\/SPAN><SPAN><SPAN>TOT_PDO_CNT <\/SPAN><\/SPAN><SPAN><SPAN>&gt;=<\/SPAN><\/SPAN><SPAN><SPAN>1 <\/SPAN><\/SPAN><SPAN><SPAN>AND <\/SPAN><\/SPAN><SPAN><SPAN>TOT_INJ_LVL_C_CNT <\/SPAN><\/SPAN><SPAN><SPAN>=<\/SPAN><\/SPAN><SPAN><SPAN>0 <\/SPAN><\/SPAN><SPAN><SPAN>AND <\/SPAN><\/SPAN><SPAN><SPAN>TOT_INJ_LVL_B_CNT <\/SPAN><\/SPAN><SPAN><SPAN>=<\/SPAN><\/SPAN><SPAN><SPAN>0 <\/SPAN><\/SPAN><SPAN><SPAN>AND <\/SPAN><\/SPAN><SPAN><SPAN>TOT_INJ_LVL_A_CNT <\/SPAN><\/SPAN><SPAN><SPAN>=<\/SPAN><\/SPAN><SPAN><SPAN>0 <\/SPAN><\/SPAN><SPAN><SPAN>AND <\/SPAN><\/SPAN><SPAN><SPAN>TOT_FATAL_CNT <\/SPAN><\/SPAN><SPAN><SPAN>=<\/SPAN><\/SPAN><SPAN><SPAN>0<\/SPAN><\/SPAN><SPAN><SPAN>),<\/SPAN><\/SPAN><SPAN><SPAN>1<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><SPAN><SPAN>0<\/SPAN><\/SPAN><SPAN><SPAN>)<\/SPAN><\/SPAN><SPAN /><SPAN /><SPAN><SPAN>as <\/SPAN><\/SPAN><SPAN><SPAN>PDO<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>Shape<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>from <\/SPAN><\/SPAN><SPAN /><SPAN /><SPAN><SPAN>distribution<\/SPAN><\/SPAN><SPAN><SPAN>.<\/SPAN><\/SPAN><SPAN><SPAN>transpor<\/SPAN><\/SPAN><SPAN><SPAN>.<\/SPAN><\/SPAN><SPAN><SPAN>CRASHMULTIYEAR<\/SPAN><\/SPAN><\/P><P STYLE=\"margin:0 0 0 0;\"><SPAN><SPAN>where<\/SPAN><\/SPAN><SPAN /><SPAN /><SPAN><SPAN>datepart<\/SPAN><\/SPAN><SPAN>(YEAR,<\/SPAN><SPAN><SPAN>CRASH_DT<\/SPAN><\/SPAN><SPAN><SPAN>)<\/SPAN><\/SPAN><SPAN /><SPAN /><SPAN><SPAN>in<\/SPAN><\/SPAN><SPAN /><SPAN /><SPAN><SPAN>(<\/SPAN><\/SPAN><SPAN><SPAN>2014<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><SPAN><SPAN>2015<\/SPAN><\/SPAN><SPAN><SPAN>,<\/SPAN><\/SPAN><SPAN>2016<\/SPAN><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": "esriPMS",
    "url": "6257c845dd3fb603e16e2476a7eaa17a",
    "imageData": "iVBORw0KGgoAAAANSUhEUgAAAAwAAAALCAYAAABLcGxfAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAiklEQVQokWNhIBGwYBP8v4ohDUQzhjHMIkoDAwNYgzEDAxEa/q+CKwaxZzKGMaTj1PB/FVhhA7JN/1cxzGIMYziLywaQYkksYr4YGqCm+2Dxjw9IDmYLsg3ITkEHmxkYGKTgGqAexWY6DEiC1ICCmeX/crBOcLgTACAXzGJhjGR49n8VatDhAiDDAcgwJbbZR1U+AAAAAElFTkSuQmCC",
    "contentType": "image/png",
    "width": 9,
    "height": 8,
    "angle": 0,
    "xoffset": 0,
    "yoffset": 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"
}