20230418
17013500
1.0
FALSE
HighCrashCorridors.DBO.HCCs
002
Server=52.152.170.15; Service=sde:sqlserver:52.152.170.15; Database=HighCrashCorridors; User=calipper; Version=sde.DEFAULT
ArcSDE Connection
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
NAD_1983_StatePlane_North_Carolina_FIPS_3200_Feet
<ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.0.0'><WKT>PROJCS["NAD_1983_StatePlane_North_Carolina_FIPS_3200_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",2000000.002616666],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-79.0],PARAMETER["Standard_Parallel_1",34.33333333333334],PARAMETER["Standard_Parallel_2",36.16666666666666],PARAMETER["Latitude_Of_Origin",33.75],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2264]]</WKT><XOrigin>-121841900</XOrigin><YOrigin>-93659000</YOrigin><XYScale>3048.0060960121928</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102719</WKID><LatestWKID>2264</LatestWKID></ProjectedCoordinateSystem>
MultipartToSinglepart memory\hcc_temp C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC
DeleteField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC ORIG_FID "Delete Fields"
AddSpatialIndex C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC 0 0 0
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC County Text # # # County NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC Troop Text # # # Troop NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC LEL_Region Text # # # "LEL Region" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC StCorCMV Text # # # "State Corridors CMV" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC CntyCorCMV Text # # # "County Corridors CMV" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC TrpCorCMV Text # # # "Troop Corridors CMV" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC StCorVeh Text # # # "State Corridors Veh" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC CntyCorVeh Text # # # "County Corridors Veh" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC TrpCorVeh Text # # # "Troop Corridors Veh" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC IntCorTroop Text # # # "Interstate Corridors Troop" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC IntCorCnty Text # # # "Interstate Corridors County" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC IntCorSt Text # # # "Interstate Corridors State" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC CntySpdCor Text # # # "County Speeding Corridors" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC TrpSpdCor Text # # # "Troop Speeding Corridors" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC StSpdCor Text # # # "State Speeding Corridors" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC LELCor Text # # # "All Vehicle LEL Corridors" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC CrashKCMV "Long (32-bit integer)" # # # "K CMV Crashes" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC CrashACMV "Long (32-bit integer)" # # # "A CMV Crashes" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC CrashBCMV "Long (32-bit integer)" # # # "B CMV Crashes" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC CrashCCMV "Long (32-bit integer)" # # # "C CMV Crashes" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC CrashOCMV "Long (32-bit integer)" # # # "O CMV Crashes" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC CrashUnkCMV "Long (32-bit integer)" # # # "Unk CMV Crashes" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC CrashCMVTot "Long (32-bit integer)" # # # "Total CMV Crashes" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC CrashKVeh "Long (32-bit integer)" # # # "K Veh Crashes" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC CrashAVeh "Long (32-bit integer)" # # # "A Veh Crashes" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC CrashBVeh "Long (32-bit integer)" # # # "B Veh Crashes" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC CrashCVeh "Long (32-bit integer)" # # # "C Veh Crashes" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC CrashOVeh "Long (32-bit integer)" # # # "O Veh Crashes" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC CrashUnkVeh "Long (32-bit integer)" # # # "Unk Veh Crashes" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC CrashVehTot "Long (32-bit integer)" # # # "Total Veh Crashes" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC CrashKSpd "Long (32-bit integer)" # # # "K Spd Crashes" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC CrashASpd "Long (32-bit integer)" # # # "A Spd Crashes" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC CrashBSpd "Long (32-bit integer)" # # # "B Spd Crashes" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC CrashCSpd "Long (32-bit integer)" # # # "C Spd Crashes" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC CrashOSpd "Long (32-bit integer)" # # # "O Spd Crashes" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC CrashUnkSpd "Long (32-bit integer)" # # # "Unk Spd Crashes" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC CrashSpdTot "Long (32-bit integer)" # # # "Total Speed Crashes" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC SeverityScoreCMV "Double (64-bit floating point)" # # # "Severity Score CMV" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC SeverityScoreVeh "Double (64-bit floating point)" # # # "Severity Score Veh" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC SeverityScoreSpd "Double (64-bit floating point)" # # # "Severity Score Spd" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC SeverityScoreInt "Double (64-bit floating point)" # # # "Severity Score Int" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC SeverityScoreLEL "Double (64-bit floating point)" # # # "Severity Score LEL" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC LengthMiles "Double (64-bit floating point)" # # # "Length Miles" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC StRankCMV "Long (32-bit integer)" # # # "State Rank CMV" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC StRankVeh "Long (32-bit integer)" # # # "State Rank Veh" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC StRankSpd "Long (32-bit integer)" # # # "State Rank Spd" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC StRankInt "Long (32-bit integer)" # # # "State Rank Int" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC TrpRankCMV "Long (32-bit integer)" # # # "Troop Rank CMV" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC TrpRankVeh "Long (32-bit integer)" # # # "Troop Rank Veh" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC TrpRankSpd "Long (32-bit integer)" # # # "State Rank Spd" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC TrpRankInt "Long (32-bit integer)" # # # "State Rank Int" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC CntyRankCMV "Long (32-bit integer)" # # # "County Rank CMV" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC CntyRankVeh "Long (32-bit integer)" # # # "County Rank Veh" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC CntyRankSpd "Long (32-bit integer)" # # # "County Rank Spd" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC CntyRankInt "Long (32-bit integer)" # # # "County Rank Int" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC LELRank "Long (32-bit integer)" # # # "LEL Rank" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC AvgSpeedLimit "Long (32-bit integer)" # # # "Average Speed Limit" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC SpeedLimitClasses Text # # # "Speed Limit Classes" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC SpeedLimitClassesInt "Long (32-bit integer)" # # # "Speed Limit Classes (Integer)" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC NumCitations "Long (32-bit integer)" # # # "Number of Citations" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC NumInspections "Long (32-bit integer)" # # # "Number of Inspections" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC CrashDateStart Text # # # "Crash Start Date" NULLABLE NON_REQUIRED #
AddField C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCC.gdb\HCC CrashDateEnd Text # # # "Crash End Date" NULLABLE NON_REQUIRED #
CalculateField HCC_Layer2 Troop "A" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField HCC_Layer5 Troop "B" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField HCC_Layer8 Troop "C" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField HCC_Layer11 Troop "D" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField HCC_Layer14 Troop "E" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField HCC_Layer17 Troop "F" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField HCC_Layer20 Troop "G" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField HCC_Layer23 Troop "H" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField HCC_Layer26 LEL_Region 1 "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField HCC_Layer29 LEL_Region 2 "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField HCC_Layer32 LEL_Region 3 "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField HCC_Layer35 LEL_Region 4 "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField HCC_Layer38 LEL_Region 5 "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField HCC_Layer41 LEL_Region 6 "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField HCC_Layer44 LEL_Region 7 "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField HCC_Layer47 LEL_Region 8 "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField HCC_Layer50 LEL_Region 9 "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField HCC_Layer53 LEL_Region 10 "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField HCC_Layer56 LEL_Region 11 "Python 3" # Text NO_ENFORCE_DOMAINS
ExportFeatures HCC C:\Users\Colleen\Documents\ArcGIS\Projects\HCCs\HCCs.sde\HighCrashCorridors.DBO.HCCs # NOT_USE_ALIAS "Division "Division" true true false 2 Short 0 0,First,#,HCC,Division,-1,-1;MaintCntyCode "MaintCntyCode" true true false 3 Text 0 0,First,#,HCC,MaintCntyCode,0,3;RouteID "RouteID" true true false 15 Text 0 0,First,#,HCC,RouteID,0,15;RouteClass "RouteClass" true true false 5 Text 0 0,First,#,HCC,RouteClass,0,5;RouteNumber "RouteNumber" true true false 5 Text 0 0,First,#,HCC,RouteNumber,0,5;RouteName "RouteName" true true false 20 Text 0 0,First,#,HCC,RouteName,0,20;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,HCC,Shape_Length,-1,-1;County "County" true true false 255 Text 0 0,First,#,HCC,County,0,255;Troop "Troop" true true false 255 Text 0 0,First,#,HCC,Troop,0,255;LEL_Region "LEL Region" true true false 255 Text 0 0,First,#,HCC,LEL_Region,0,255;StCorCMV "State Corridors CMV" true true false 255 Text 0 0,First,#,HCC,StCorCMV,0,255;CntyCorCMV "County Corridors CMV" true true false 255 Text 0 0,First,#,HCC,CntyCorCMV,0,255;TrpCorCMV "Troop Corridors CMV" true true false 255 Text 0 0,First,#,HCC,TrpCorCMV,0,255;StCorVeh "State Corridors Veh" true true false 255 Text 0 0,First,#,HCC,StCorVeh,0,255;CntyCorVeh "County Corridors Veh" true true false 255 Text 0 0,First,#,HCC,CntyCorVeh,0,255;TrpCorVeh "Troop Corridors Veh" true true false 255 Text 0 0,First,#,HCC,TrpCorVeh,0,255;IntCorTroop "Interstate Corridors Troop" true true false 255 Text 0 0,First,#,HCC,IntCorTroop,0,255;IntCorCnty "Interstate Corridors County" true true false 255 Text 0 0,First,#,HCC,IntCorCnty,0,255;IntCorSt "Interstate Corridors State" true true false 255 Text 0 0,First,#,HCC,IntCorSt,0,255;CntySpdCor "County Speeding Corridors" true true false 255 Text 0 0,First,#,HCC,CntySpdCor,0,255;TrpSpdCor "Troop Speeding Corridors" true true false 255 Text 0 0,First,#,HCC,TrpSpdCor,0,255;StSpdCor "State Speeding Corridors" true true false 255 Text 0 0,First,#,HCC,StSpdCor,0,255;LELCor "All Vehicle LEL Corridors" true true false 255 Text 0 0,First,#,HCC,LELCor,0,255;CrashKCMV "K CMV Crashes" true true false 4 Long 0 0,First,#,HCC,CrashKCMV,-1,-1;CrashACMV "A CMV Crashes" true true false 4 Long 0 0,First,#,HCC,CrashACMV,-1,-1;CrashBCMV "B CMV Crashes" true true false 4 Long 0 0,First,#,HCC,CrashBCMV,-1,-1;CrashCCMV "C CMV Crashes" true true false 4 Long 0 0,First,#,HCC,CrashCCMV,-1,-1;CrashOCMV "O CMV Crashes" true true false 4 Long 0 0,First,#,HCC,CrashOCMV,-1,-1;CrashUnkCMV "Unk CMV Crashes" true true false 4 Long 0 0,First,#,HCC,CrashUnkCMV,-1,-1;CrashCMVTot "Total CMV Crashes" true true false 4 Long 0 0,First,#,HCC,CrashCMVTot,-1,-1;CrashKVeh "K Veh Crashes" true true false 4 Long 0 0,First,#,HCC,CrashKVeh,-1,-1;CrashAVeh "A Veh Crashes" true true false 4 Long 0 0,First,#,HCC,CrashAVeh,-1,-1;CrashBVeh "B Veh Crashes" true true false 4 Long 0 0,First,#,HCC,CrashBVeh,-1,-1;CrashCVeh "C Veh Crashes" true true false 4 Long 0 0,First,#,HCC,CrashCVeh,-1,-1;CrashOVeh "O Veh Crashes" true true false 4 Long 0 0,First,#,HCC,CrashOVeh,-1,-1;CrashUnkVeh "Unk Veh Crashes" true true false 4 Long 0 0,First,#,HCC,CrashUnkVeh,-1,-1;CrashVehTot "Total Veh Crashes" true true false 4 Long 0 0,First,#,HCC,CrashVehTot,-1,-1;CrashKSpd "K Spd Crashes" true true false 4 Long 0 0,First,#,HCC,CrashKSpd,-1,-1;CrashASpd "A Spd Crashes" true true false 4 Long 0 0,First,#,HCC,CrashASpd,-1,-1;CrashBSpd "B Spd Crashes" true true false 4 Long 0 0,First,#,HCC,CrashBSpd,-1,-1;CrashCSpd "C Spd Crashes" true true false 4 Long 0 0,First,#,HCC,CrashCSpd,-1,-1;CrashOSpd "O Spd Crashes" true true false 4 Long 0 0,First,#,HCC,CrashOSpd,-1,-1;CrashUnkSpd "Unk Spd Crashes" true true false 4 Long 0 0,First,#,HCC,CrashUnkSpd,-1,-1;CrashSpdTot "Total Speed Crashes" true true false 4 Long 0 0,First,#,HCC,CrashSpdTot,-1,-1;SeverityScoreCMV "Severity Score CMV" true true false 8 Double 0 0,First,#,HCC,SeverityScoreCMV,-1,-1;SeverityScoreVeh "Severity Score Veh" true true false 8 Double 0 0,First,#,HCC,SeverityScoreVeh,-1,-1;SeverityScoreSpd "Severity Score Spd" true true false 8 Double 0 0,First,#,HCC,SeverityScoreSpd,-1,-1;SeverityScoreInt "Severity Score Int" true true false 8 Double 0 0,First,#,HCC,SeverityScoreInt,-1,-1;SeverityScoreLEL "Severity Score LEL" true true false 8 Double 0 0,First,#,HCC,SeverityScoreLEL,-1,-1;LengthMiles "Length Miles" true true false 8 Double 0 0,First,#,HCC,LengthMiles,-1,-1;StRankCMV "State Rank CMV" true true false 4 Long 0 0,First,#,HCC,StRankCMV,-1,-1;StRankVeh "State Rank Veh" true true false 4 Long 0 0,First,#,HCC,StRankVeh,-1,-1;StRankSpd "State Rank Spd" true true false 4 Long 0 0,First,#,HCC,StRankSpd,-1,-1;StRankInt "State Rank Int" true true false 4 Long 0 0,First,#,HCC,StRankInt,-1,-1;TrpRankCMV "Troop Rank CMV" true true false 4 Long 0 0,First,#,HCC,TrpRankCMV,-1,-1;TrpRankVeh "Troop Rank Veh" true true false 4 Long 0 0,First,#,HCC,TrpRankVeh,-1,-1;TrpRankSpd "State Rank Spd" true true false 4 Long 0 0,First,#,HCC,TrpRankSpd,-1,-1;TrpRankInt "State Rank Int" true true false 4 Long 0 0,First,#,HCC,TrpRankInt,-1,-1;CntyRankCMV "County Rank CMV" true true false 4 Long 0 0,First,#,HCC,CntyRankCMV,-1,-1;CntyRankVeh "County Rank Veh" true true false 4 Long 0 0,First,#,HCC,CntyRankVeh,-1,-1;CntyRankSpd "County Rank Spd" true true false 4 Long 0 0,First,#,HCC,CntyRankSpd,-1,-1;CntyRankInt "County Rank Int" true true false 4 Long 0 0,First,#,HCC,CntyRankInt,-1,-1;LELRank "LEL Rank" true true false 4 Long 0 0,First,#,HCC,LELRank,-1,-1;AvgSpeedLimit "Average Speed Limit" true true false 4 Long 0 0,First,#,HCC,AvgSpeedLimit,-1,-1;SpeedLimitClasses "Speed Limit Classes" true true false 255 Text 0 0,First,#,HCC,SpeedLimitClasses,0,255;SpeedLimitClassesInt "Speed Limit Classes (Integer)" true true false 4 Long 0 0,First,#,HCC,SpeedLimitClassesInt,-1,-1;NumCitations "Number of Citations" true true false 4 Long 0 0,First,#,HCC,NumCitations,-1,-1;NumInspections "Number of Inspections" true true false 4 Long 0 0,First,#,HCC,NumInspections,-1,-1;CrashDateStart "Crash Start Date" true true false 255 Text 0 0,First,#,HCC,CrashDateStart,0,255;CrashDateEnd "Crash End Date" true true false 255 Text 0 0,First,#,HCC,CrashDateEnd,0,255" #
AlterField HighCrashCorridors.DBO.HCCs TrpRankSpd # "Troop Rank Spd" "Long (32-bit integer)" 4 NULLABLE DO_NOT_CLEAR
AlterField HighCrashCorridors.DBO.HCCs TrpRankInt # "Troop Rank Int" "Long (32-bit integer)" 4 NULLABLE DO_NOT_CLEAR
20230419
13594000
20230419
13594000
Microsoft Windows 10 Version 10.0 (Build 22621) ; Esri ArcGIS 13.0.3.36057
HCCs
HCCs
High Crash Corridors for CMVs and Vehicles. Includes State, Troop, and County high crash corridors geographies.
Enterprise Geodatabase Feature Class
dataset
EPSG
6.12(9.0.0)
0
Simple
FALSE
0
TRUE
FALSE
HighCrashCorridors.DBO.HCCs
Feature Class
0
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
Shape
Shape
Geometry
8
0
0
Feature geometry.
Esri
Coordinates defining the features.
Division
Division
SmallInteger
2
5
0
MaintCntyCode
MaintCntyCode
String
3
0
0
RouteID
RouteID
String
15
0
0
RouteClass
RouteClass
String
5
0
0
RouteNumber
RouteNumber
String
5
0
0
County
County
String
255
0
0
Troop
Troop
String
255
0
0
LEL_Region
LEL Region
String
255
0
0
StCorCMV
State Corridors CMV
String
255
0
0
CntyCorCMV
County Corridors CMV
String
255
0
0
TrpCorCMV
Troop Corridors CMV
String
255
0
0
StCorVeh
State Corridors Veh
String
255
0
0
CntyCorVeh
County Corridors Veh
String
255
0
0
TrpCorVeh
Troop Corridors Veh
String
255
0
0
IntCorTroop
Interstate Corridors Troop
String
255
0
0
IntCorCnty
Interstate Corridors County
String
255
0
0
IntCorSt
Interstate Corridors State
String
255
0
0
CntySpdCor
County Speeding Corridors
String
255
0
0
TrpSpdCor
Troop Speeding Corridors
String
255
0
0
StSpdCor
State Speeding Corridors
String
255
0
0
LELCor
All Vehicle LEL Corridors
String
255
0
0
CrashKCMV
K CMV Crashes
Integer
4
10
0
CrashACMV
A CMV Crashes
Integer
4
10
0
CrashBCMV
B CMV Crashes
Integer
4
10
0
CrashCCMV
C CMV Crashes
Integer
4
10
0
CrashOCMV
O CMV Crashes
Integer
4
10
0
CrashUnkCMV
Unk CMV Crashes
Integer
4
10
0
CrashCMVTot
Total CMV Crashes
Integer
4
10
0
CrashKVeh
K Veh Crashes
Integer
4
10
0
CrashAVeh
A Veh Crashes
Integer
4
10
0
CrashBVeh
B Veh Crashes
Integer
4
10
0
CrashCVeh
C Veh Crashes
Integer
4
10
0
CrashOVeh
O Veh Crashes
Integer
4
10
0
CrashUnkVeh
Unk Veh Crashes
Integer
4
10
0
CrashVehTot
Total Veh Crashes
Integer
4
10
0
CrashKSpd
K Spd Crashes
Integer
4
10
0
CrashASpd
A Spd Crashes
Integer
4
10
0
CrashBSpd
B Spd Crashes
Integer
4
10
0
CrashCSpd
C Spd Crashes
Integer
4
10
0
CrashOSpd
O Spd Crashes
Integer
4
10
0
CrashUnkSpd
Unk Spd Crashes
Integer
4
10
0
CrashSpdTot
Total Speed Crashes
Integer
4
10
0
SeverityScoreCMV
Severity Score CMV
Double
8
38
8
SeverityScoreVeh
Severity Score Veh
Double
8
38
8
SeverityScoreSpd
Severity Score Spd
Double
8
38
8
SeverityScoreInt
Severity Score Int
Double
8
38
8
SeverityScoreLEL
Severity Score LEL
Double
8
38
8
LengthMiles
Length Miles
Double
8
38
8
StRankCMV
State Rank CMV
Integer
4
10
0
StRankVeh
State Rank Veh
Integer
4
10
0
StRankSpd
State Rank Spd
Integer
4
10
0
StRankInt
State Rank Int
Integer
4
10
0
TrpRankCMV
Troop Rank CMV
Integer
4
10
0
TrpRankVeh
Troop Rank Veh
Integer
4
10
0
TrpRankSpd
State Rank Spd
Integer
4
10
0
TrpRankInt
State Rank Int
Integer
4
10
0
CntyRankCMV
County Rank CMV
Integer
4
10
0
CntyRankVeh
County Rank Veh
Integer
4
10
0
CntyRankSpd
County Rank Spd
Integer
4
10
0
CntyRankInt
County Rank Int
Integer
4
10
0
LELRank
LEL Rank
Integer
4
10
0
AvgSpeedLimit
Average Speed Limit
Integer
4
10
0
SpeedLimitClasses
Speed Limit Classes
String
255
0
0
SpeedLimitClassesInt
Speed Limit Classes (Integer)
Integer
4
10
0
NumCitations
Number of Citations
Integer
4
10
0
NumInspections
Number of Inspections
Integer
4
10
0
CrashDateStart
Crash Start Date
String
255
0
0
CrashDateEnd
Crash End Date
String
255
0
0
RouteName
RouteName
String
20
0
0
Shape.STLength()
Shape.STLength()
Double
0
0
0
20230419
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD27zmb
7kTEdj2pd82ceWM+ueKlorzAITJKQQIsN6k8UkYlkQN5uD3AXoanqK3+43++386AEMMhdW87lc4+
Wl2S/wDPb/x2paKQEDtNHtwVbJA54p2Z/wC7H/30f8KJP9dEO2T/ACqWgCvKs7rjbHwQfvH/AApy
O6viXHPTH8qmpkqF0wKYD6KgUyy5y3l4OMDk07yn/wCe7/kP8KAD7RH/AHj+RpxkTacMOnrSogSM
IDkAY5qOaJPJk+QfdPQUtAHQjEK1JTYxiNR7U6gAooooAKil+9H/AL1S1FJ/rIx70AS0UUUART/6
sD1IqWopuif71S0AFRzHELe4x+dSVFPyir3Zhj+dAEijCKPQUModSp6GlooArYdJPLaY7NuRxg/n
Um2ROVbePQ9aWbb5TFlB44Bp0a7Y1Gc4HegCGaVWiwcq25eD9RVikZFcYZQfrUflsn+rbj+6aYEt
FNR94ORhh1FOpAFRyktiMdW6/SpCcDJqKL5syH+Lp9KAJAMAAdqWiigAoqLzHP3Yz9SaQvKjLv2b
ScEj9KYD5W2RMaWNdkar6Cmf62X/AGF5+pqWkAUUUUARP/r4vx/lUtV3iWeZslgEGODjBpx86LkZ
lHpwCKYE1NdwiFjnA9KFcOuV6+h7Gq6meYFSVUA4LDvQBJCdzyNggEjGampkaeXGFznFPoAKZN/q
JP8AdP8AKn1HMf3L+4xSAaiTbF/er0/uf/Xpdsw/5aKfbbipF+4PpS0wIt0/9xD/AMC/+tRun/55
J/33/wDWqWigCLzJR96L/vk5phkLTxjYy9eoqxUEu7z4tmM4PX8KAJ6Ki/f/APTP9aP3/wD0z/Wk
AT8KrdlYE1IGB6EGoXSaRCp8vB+tOFum0DGDjkrxTAlqKTmaIDsST+VH2df70n/fZpPsse7dmTOM
ffNAE1RysVT5fvE4FRSQLuRQ0mSc/fPQVKsCKwbLEjpliaQCCJiwMj7gOgAxUtFFABRRRQBG8W75
gSrY6g0kch4RwQ2OvY1LUcygxnkAjkE9jQAkp3FYx/FyfpUtQ2x8xPOI5f8AlU1ABRQSAMk4FRGd
M/xn3UHFMCWkZQwwRkUtFICGL92TEeg5B9qmpjxJIQWUHHrTV/dSBP4G+77UAS0hOASegpajnJEJ
x7D9aACAfu9x6sc5/lUlIAAAB0FLQBFJCHyQSjf3lqO2JjZonboeM9/erNIyK4wygj0NMBcj1oqv
JEse1kQDB5I7CpwQQCOhoAWorj/VD/eUfrUtQ3P+qH++v8xSAmooooAKKKKACon/AOPiL6N/Spai
f/j4j+jf0oAlooooAKKKKACiikJABJ6CgCNfmuGPZRj8alqOEYTcerHJqSgAooooAKKKjJaQ4Q4U
dT60AK0gU7QNzegpFjJO6Q5PYdhTkRUHA+p9adQBAjiElH4HJB7Yp3ml/wDVrn/aPSnvGkq7XUMP
emQZCFSeVJHPp2oABFk5kbcfTtUu0UUUAFFReQg+7lfoaPJ/6aSf99UAS1FcHEfH3u1HkkdJX/E5
qKQSLND8wf5umMdqALK/dGeuKbMu6Jh+P5U37REDjd+lL5sbqRvHIoAep3IreozS1DBIpiGWHHHW
pd6/3h+dMBaKTev94fnRuX+8PzpALUODDyGJTPIPapdw9R+dGR6imAoIIyKiuPuqP9ofzpIGAQoS
MocfWiVlLxDI5Pr7UdQJqKTev94fnRvX+8PzpALRSb1/vD86Tev94fnQA6outyPZak3r/eH51CrL
9qf5h90d/rTAnopu9f7w/OkMqKMlhSAfTXcIpY//AK6gWaV84jwp+6QadFCysGkfeQMCmA7fKBuK
Aj0HUUSMXhJTJzjp6d6lqHmEn5cpnPHakA+ORGG1TyO3cU+oAizt5jD5R93/ABp2yRPuPuHo3+NM
CWiovOC/6xSvv2oB87kH93/OkAcynjhPX1qUAAYFAGBxRQAUUUUAFRMfKlLEHaw5PoalprsEQse1
MBn2mE/8tF+uaXz4v+ei/nRFGFjGQMnk0/avoKQC0VF9nj7Aj6GjyfSWQfjQBLUFwocxg927cU7y
T/z1k/Mf4VAXK3SiR8InOSOvFNAXAABgDAqCZF8xJCoPOCSO1T9RUcyF4io69aQC+TF/zzT/AL5F
Hkxf880/75FKjh1yPxFOoAZ5MX/PNP8AvkUnkx/3B+AqSigCCWOMKFCjc3Apy28YUDGce9EfzuZO
3RfpUtMCu1sA5dFU5HINLHHFIN3lgEHGD2qeoc+VKxP3XI59DQA/yYv+ea/lR5MX/PNP++RT6KQD
PJi/55p/3yKigij8oAxpleD8verFRR/LLIvbhvzoAd5MX/PNP++RR5MX/PNP++RT6KAGeTF/zzT/
AL5FRTxoEGEUc8tjp71YpGAZSD0NMBR0oqKMlG8pueMqfUVLSAKib942wfdH3j6+1K7EnYvU9T6C
nqoVcDpQAo4GKKKKACoSvkncmdhPzKB+tTUUwEBBAIOQaWoov3bGM/VfpUtABRRRSAKif55VTsPm
NS1FEcySn360wJaKKKQBRRRQAE4GagjjWU+a6gluVz2FSTf6puvTtTk+4vTp2oAWiiigCKT5JUfo
CcH39KlproHXB47g+lM8xk4kHH94dKYEtRyknEY6t19hTyQFLHoBmmRAnMjdW/QUgHgAAADAFLRR
QAVEw3zqp6KN1S1EnE8gPU4I/KgCWiiigAqJ/luEbsQV/GpajlUkKVGSrZx60ASUU1HDruFOoAKK
KKAGSRliGU4YUwzEfIVIkPQdjU1QkmORncZB7jtTQEiJtHqTyTTqOoopAFFIzKgyxAHqaj81nGY0
yPU8UwJaKi/f/wDTP8jR5kijLRHHsc0AJOyBck4ccrjrmpEO5FPqKZCN5MpH3unsKNjoT5ZXb1wa
AJaY8gQdCSegHem/vX4wE9+ppDCQQ4Ys47nvSAMyydP3Y9wCTT44/LUjJOTk0qOHGR+I9KdTAKKK
KQEAuHHWB/8AgODR9p9YZR9QP8an7U04rrdGIEP2qJiYwTvI+7jmpYgVhQHqFGagHzXZYYUIOT65
pWuWZsQrux1J7/SsZU/e5YgWaKajB1DDoadWYBUbMWOxfxPpQWLkqh+rU9VCjApAQPAyqBGcqOqE
9aeJmwB5L/pUtFMCHzJmGBFg/wC0eKiQupEruSMkHAq3UVv/AKkfU/zoAabkMAI1ZmI6Y6Uze2Y9
+PNVunqKs7V3bsDPrioZodzrIFyQMHBwcUASPKiHDNim+ep+5lj6AU1GUfLEh3HqWB/WnxuxLK+N
y+lIBPMkHWI/gaPNb/nk/wClS0UAVY5lifYwYBm4yOhPrVqkZQ4wwyKZCSY+Tnng0ASUjMFUknAF
KTgZNRAGVgx+4Og9aAEy8p4O1PXuaRklVSAfMXuD1xU9FMCmkjmVY03qCD98Zxip/JJ5aRyfY4FD
cXCk9CCPpUtAEawxqc7QT6mpKKKQBUN0SLdiDj14qaoJyXdYV7nLfSmBMAAAB0FLRRSAKKKKAGNE
jnJXn1qGFp9p4DAMRktz1qzUVv8A6s/7x/nQAfvn5BCD3Gc0CWQDDRnP+z0qWimAHkU3GRRk9qUj
KkV6G4FZ4D5m48jHr1qRcbiR0xSMWXgmiIHBx60nqK1hpbyHLH/Vt19jUn7yT/YX9aGG5SpGQaIW
IJjY5Ze/qK5qsftIZIAFGAOKWiisACiiigBsnEbfQ0kX+qT6CkmOIm/KnqNqAegxQAtFFFABUL8T
Ls+83Ue1TVFPwm8feBHP40wJaKO1FIAqB0RP42BPQKanqKAbgZD95j+Q9KYEOXDASbvKPc9c+9Wx
04oIBGDyDUS/unCfwt932oAlooopARTcBW7KwJqXrQenNQQSLlos/dPHuPagCeiiigAqKQYnjbty
v51LTJU3rwcEHIPvTAfRTEkDcHhh1FPpAFFFFABUUXDyL6HP51LUUf8Ar5vqP5UAS0UUUANFPHrS
YFBOBXogMkx1xSLlRjt3obl1pam4AKji/wCPiY/7tSVD5cquxRxhjnkVFROUbICzRVfNz6oaC1yB
9yM/8CP+FYeymBYoqur3LDPlxf8AfZ/wpd11/wA84v8Avs/4UvZT7AOuP9Vj1I/nUtVZDclkzGmF
OT8x9PpTvOl7w/kaPZzXQCxRUHnt3gk/DH+NL57f88JfyH+NL2cuwE1MlYBCp6twB60zz2/54Sfk
P8aiWb96zmKTnheBRyS7AWUBVFB6gU6oftI/uP8AlSG6UAna/wBMUuSXYCVmCDJpsSlVOeMnOPSo
wzzSxOq4jBOcnnpVik0AVFPwEP8AtipahuASiqDgMwBOM0gJqKi2S/8APYf98UeW54eTcPQLigA5
lPHCfzp7IrDBAxTulFMCJSySBGOQfumpaimVim5Pvr0pFj8xQ3mvz6HFAE1FReSP77/99UeQP77/
APfVIBZY94BU7XHQ0scm8HswOCKb5C+rfnTGiMRMseWbGCCeooAsUUisHUMOh5paACoo/wDXS/Uf
yqQnAJ9KjgH7rd/eJb86AJaKKKAGnpmkO70xQODQTmvQbAZzvHPY0+mn76/Q06kAgOSVp4HeokOQ
WPepVPFO1nYSdx2BSN0paa3rmmxjBw31qQe1RkZFCvggN/8ArpIRJxTSvpT6ha4VXx27mh26juSA
HpSe1G7PIPFLjuaAAc0wrgin4xTSwY4HagBcEH2p2KarZODT6YETIyHeg+q+tPVg65HSnVE6FG8x
P+BL61jVpc2qAkqKX5/3Q6nqfQUplXYCvJPAFKibRzyx5JrlAfRRRSAKKKKACoo/kdo/fIqWorjA
j3fxAjBoAlooooAKKKKAIf8AUOoH3HOMehqamyIJEKn9KbG7bij43DnI7igBZQxibZ97FNWWNY+u
0DjB4qWoNizsHYfKD8vv70AO+0J6MfopNH2mL/nqo9qlwKbsT+6PypgJRSA8Zpa7gI5JFVlBYA5p
6srjKkEe1Vby2E3zbc9M84NS28P2eEJnoSaAJEULkD1p1MQD5m9TT6ctyVsOySMU2il6CjcoUcjp
Va7hLRiSPiROVqypoxnvTQmrjIJxPbrLjqOR6VTfBYketOw8E8ygHY4yvoKQIT05qKm+giWGUIhy
OlSNOu3jOaZFASct0pTb8nn6UlzWHqIJmcFOBnvTkjCEEHOT1qORFUYB+apYxtiwRg9aa31AfnkC
pO1RAjk09W3DirGh9IRkUdqTcKAIJEMb+aqjPcDvUqOHUMp4pJDk4qBQyMXQZH8S+tY1afNqtwLV
FNRg6hlOQadXKAUUUUgCoX+adE64+Y1NUMeBcSDvwaYE1FFFIAooooAKhlDJIJQCwAwwHpU1FMCF
nEuFQ8Hkn0FTAADA4AqC2ChW7OWO761PQAUUUUgGY4pMUtKK7xDH+4aCN2Bkj6UP900vU0AxiMFO
0nIB4NPBBzzmmsgbgjimDdGTtA2ntV+7L1Iu4+hN6UoNNVg4BFOAqNi0FKDS0hGKYxpG48jtTgBj
GKaxytAPFAh4HWl70gPHApRVDGtGr/eFDAU6kz83PalYBhUZ5pEOMn1p7D0qNwc5HFTsLYmPTimU
iE7acRgZzT3GLtDc0zgfKvQ9TQNzD0H86fwAAPWqAjKeUdyD5f4l/rTwQwyDkU6omUxEsoyp6j+t
c9Wlf3kMkopAQwBByDUczsu1Fxuc4GenSuYQhmdjiKMn/aPApFikjJZSGLcndxUsalIwpOSKdQBF
mf8Auxj/AIEf8KQmZSDgOO4HGKmooAYsit3wfQ9afTWjR+qjPr3pm2SP7p3r6HrSAloqLziv343H
0Gf5UeaW4RGz/tDGKACZV+8OJOxHWpE3bBuxuxzioAxjlJmxz0YdB7U/7TFnAbPqQMgfjTAlopFY
MMqQR6iq8t7HDIUYnI9qQE1LnAFFFeggGOMj6U7GKKKkQUmBRRTGCgDgcVIBgUUU0JBnrTSeMUUU
2MSlHDD3oopIB+KBRRTGFIfvfWiigBAeeTSN79KKKQiMMW4UZp20/wARyaKKQkPU5GD1pSOMUUVR
QnzD0NKCCKKKBEEhMBLKCy91H9KIV3sZmUAt05zgUUVy1kk9AJ6KKKwAKKKKACiiigAooooAZIQq
EkZ9BRFGEjxgZPJ+tFFHQCKS34Zo5GRj6dKLYK0CtncTyT70UU+gH//Z