20161028
08365700
1.0
FALSE
CalculateField Indiana2014clean HighwayNum int(filter(str.isdigit, str(!Roadway_Number! ))) PYTHON_9.3 #
CalculateField Indiana2014clean HighwayNum -9999 VB #
CalculateField Indiana2014clean HighwayNum -9999 VB #
CalculateField Indiana2014clean QC "y" VB #
CalculateField Indiana2014clean QC "y" VB #
CalculateField Indiana2014clean QC "y" VB #
CalculateField Indiana2014clean QC "y" VB #
CalculateField Indiana2014clean QC "y" VB #
CalculateField Indiana2014clean QC "y" VB #
CalculateField Indiana2014clean QC "y" VB #
CalculateField Indiana2014clean QC "y" VB #
CalculateField Indiana2014clean QC "y" VB #
CalculateField Indiana2014clean QC "y" VB #
CalculateField Indiana2014clean QC "y" VB #
CalculateField Indiana2014clean QC "y" VB #
CalculateField Indiana2014clean QC "y" VB #
CalculateField Indiana2014clean QC "y" VB #
CalculateField Indiana2014clean QC "y" VB #
CalculateField Indiana2014clean QC "y" VB #
CalculateField Indiana2014clean QC "y" VB #
CalculateField Indiana2014clean QC "y" VB #
CalculateField Indiana2014clean QC "y" VB #
CalculateField Indiana2014clean QC "y" VB #
CalculateField Indiana2014clean QC "y" VB #
CalculateField Indiana2014clean QC "y" VB #
CalculateField Indiana2014clean QC "y" VB #
CalculateField Indiana2014clean QC 'y' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'y' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'y' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'y' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'y' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'y' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'y' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'y' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'y' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'y' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'y' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'y' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'y' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'y' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'y' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'y' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'y' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'y' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'y' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'y' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'y' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'y' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'y' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'y' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'y' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'y' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'y' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'y' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'y' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'y' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'y' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'y' PYTHON_9.3 #
CalculateField Indiana2014clean Pretype "SR" VB #
CalculateField Indiana2014clean Pretype "I" VB #
CalculateField Indiana2014clean Pretype "US" VB #
CalculateField Indiana2014clean Pretype "SR" VB #
CalculateField Indiana2014clean HighwayNum "" VB #
CalculateField Indiana2014clean HighwayNum None PYTHON_9.3 #
CalculateField Indiana2014clean QC "c" VB #
CalculateField Indiana2014clean QC "c" VB #
CalculateField Indiana2014clean QC "c" VB #
CalculateField Indiana2014clean QC "c" VB #
CalculateField Indiana2014clean QC 'c' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'c' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'c' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'c' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'c' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'c' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'c' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'c' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'c' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'c' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'c' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'c' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'c' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'c' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'c' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'c' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'c' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'c' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'c' PYTHON_9.3 #
CalculateField Indiana2014clean QC 'c' PYTHON_9.3 #
CalculateField Indiana2014cleanSnapped_Proj Pretype "US" VB #
AddField Indiana2014cleanSnapped_Proj County String # # # # NULLABLE NON_REQUIRED #
CalculateField Indiana2014cleanSnapped_Proj State "Indiana" VB #
CalculateField Indiana2014cleanSnapped_Proj Year 2014 VB #
CalculateField Indiana2014cleanSnapped_Proj Weather !Weather_Conditions! PYTHON_9.3 #
CalculateField Indiana2014cleanSnapped_Proj RoadCondition !Surface_Condition! PYTHON_9.3 #
CalculateField Indiana2014cleanSnapped_Proj FATLS !Number_Dead! PYTHON_9.3 #
CalculateField Indiana2014cleanSnapped_Proj INJS !Number_Injured! PYTHON_9.3 #
CalculateField Indiana2014cleanSnapped_Proj INJACC 1 PYTHON_9.3 #
CalculateField Indiana2014cleanSnapped_Proj INJACC 0 PYTHON_9.3 #
CalculateField Indiana2014cleanSnapped_Proj FATACC 1 PYTHON_9.3 #
CalculateField Indiana2014cleanSnapped_Proj FATACC 0 PYTHON_9.3 #
CalculateField Indiana2014cleanSnapped_Proj FATACC 1 PYTHON_9.3 #
CalculateField Indiana2014cleanSnapped_Proj FATACC 0 PYTHON_9.3 #
CalculateField Indiana2014cleanSnapped_Proj Time !Time_Notified! PYTHON_9.3 #
CalculateField Indiana2014cleanSnapped_Proj Time !Collision_Time! PYTHON_9.3 #
CalculateField Indiana2014cleanSnapped_Proj Time !Collision_Time! PYTHON_9.3 #
CalculateField Indiana2014cleanSnapped_Proj Date !COLLDTE! PYTHON_9.3 #
CalculateField Indiana2014cleanSnapped_Proj Date_prep !Date! PYTHON_9.3 #
CalculateField Indiana2014cleanSnapped_Proj Date "f (!Date_prep!)" PYTHON_9.3 "def f(x):\n a = x.split('/')\n if len(a[0]) == 1:\n month = '0' + a[0]\n else:\n month = a[0]\n if len(a[1]) == 1:\n day = '0' + a[1]\n else:\n day = a[1]\n return a[2] + day + month\n"
CalculateField Indiana2014cleanSnapped_Proj Date "f (!Date_prep!)" PYTHON_9.3 "def f(x):\n a = x.split('/')\n if len(a[0]) == 1:\n month = '0' + a[0]\n else:\n month = a[0]\n if len(a[1]) == 1:\n day = '0' + a[1]\n else:\n day = a[1]\n return a[2] + month+ day \n"
CalculateField Indiana2014cleanSnapped_Proj RoadCharacter !Road_Character! PYTHON_9.3 #
CalculateField Indiana2014cleanSnapped_Proj StreetName !Roadway_Name! PYTHON_9.3 #
CalculateField Indiana2014cleanSnapped_Proj StreetSuffix !Roadway_Suffix! PYTHON_9.3 #
CalculateField Indiana2014cleanSnapped_Proj StreetName !HighwayNum! PYTHON_9.3 #
CalculateField Indiana2014cleanSnapped_Proj StreetPrefix !Pretype! PYTHON_9.3 #
CalculateField Indiana2014cleanSnapped_Proj StreetPrefix "IN" PYTHON_9.3 #
CalculateField Indiana2014cleanSnapped_Proj AnimalInvolved "Yes" PYTHON_9.3 #
CalculateField Indiana2014cleanSnapped_Proj AnimalInvolved "No" PYTHON_9.3 #
CalculateField Indiana2014cleanSnapped_Proj MannerCollision !Manner_of_Collision! PYTHON_9.3 #
CalculateField Indiana2014cleanSnapped_Proj BicycleInvolved 0 PYTHON_9.3 #
CalculateField Indiana2014cleanSnapped_Proj PedestrianInvolved 0 PYTHON_9.3 #
CalculateField Indiana2014cleanSnapped_Proj Reference !Mile_Marker! PYTHON_9.3 #
CalculateField Indiana2014cleanSnapped_Proj ReferenceType "Mile Post" VB #
CalculateField Indiana2014cleanSnapped_Proj Reference [House_Number] VB #
CalculateField Indiana2014cleanSnapped_Proj ReferenceType "House Number" VB #
CalculateField Indiana2014cleanSnapped_Proj ReferenceType "Intersection" VB #
CalculateField Indiana2014cleanSnapped_Proj Reference ""@ " + !Intersecting_Road!" PYTHON_9.3 #
CalculateField Indiana2014cleanSnapped_Proj Reference ""@ " + !Intersecting_Road_Number!" PYTHON_9.3 #
CalculateField Indiana2014cleanSnapped_Proj ReferenceType "Interchange" PYTHON_9.3 #
CalculateField Indiana2014cleanSnapped_Proj Reference "!Roadway_Interchange! + ' ' + !Roadway_Ramp!" PYTHON_9.3 #
CalculateField Indiana2014cleanSnapped_Proj Reference !Unique_Location_Id! PYTHON_9.3 #
CalculateField Indiana2014cleanSnapped_Proj Reference "str(!Feet_From!) + ' ' + !Direction! + ' of ' + !Intersecting_Road!" PYTHON_9.3 #
CalculateField Indiana2014cleanSnapped_Proj Reference "str(!Feet_From!) + ' ' + !Direction! + ' of ' + !Intersecting_Road_Number!" PYTHON_9.3 #
CalculateField Indiana2014cleanSnapped_Proj Reference !Reference!.replace('.0', '') PYTHON_9.3 #
CalculateField Indiana2014cleanSnapped_Proj Reference "str(!Feet_From!) + ' ' + !Direction! + ' of ' + !Unique_Location_Id!" PYTHON_9.3 #
CalculateField Indiana2014cleanSnapped_Proj Reference !Reference!.replace('.0', '') PYTHON_9.3 #
Merge Indiana2014cleanSnapped_Proj;Kentucky2014cleanSnapped_Pro;Ohio2014cleanSnapped T:\GIS\Staff\Flessner\CrashRates2014\CrashData2014.gdb\OKI_Crashes2014 "FATACC "FATACC" true true false 8 Double 0 0 ,First,#,Indiana2014cleanSnapped_Proj,FATACC,-1,-1,Kentucky2014cleanSnapped_Pro,FATACC,-1,-1,Ohio2014cleanSnapped,FATACC,-1,-1;INJACC "INJACC" true true false 8 Double 0 0 ,First,#,Indiana2014cleanSnapped_Proj,INJACC,-1,-1,Kentucky2014cleanSnapped_Pro,INJACC,-1,-1,Ohio2014cleanSnapped,INJACC,-1,-1;FATLS "FATLS" true true false 8 Double 0 0 ,First,#,Indiana2014cleanSnapped_Proj,FATLS,-1,-1,Kentucky2014cleanSnapped_Pro,FATLS,-1,-1,Ohio2014cleanSnapped,FATLS,-1,-1;INJS "INJS" true true false 8 Double 0 0 ,First,#,Indiana2014cleanSnapped_Proj,INJS,-1,-1,Kentucky2014cleanSnapped_Pro,INJS,-1,-1,Ohio2014cleanSnapped,INJS,-1,-1;INJS_INCAP "INJS_INCAP" true true false 2 Short 0 0 ,First,#,Indiana2014cleanSnapped_Proj,INJS_INCAP,-1,-1,Kentucky2014cleanSnapped_Pro,INJS_INCAP,-1,-1,Ohio2014cleanSnapped,INJS_INCAP,-1,-1;Year "Year" true true false 2 Short 0 0 ,First,#,Indiana2014cleanSnapped_Proj,Year,-1,-1,Kentucky2014cleanSnapped_Pro,Year,-1,-1,Ohio2014cleanSnapped,YEAR,-1,-1;Time "Time" true true false 2 Short 0 0 ,First,#,Indiana2014cleanSnapped_Proj,Time,-1,-1,Kentucky2014cleanSnapped_Pro,Time,-1,-1,Ohio2014cleanSnapped,Time,-1,-1;Date "Date" true true false 255 Text 0 0 ,First,#,Indiana2014cleanSnapped_Proj,Date,-1,-1,Kentucky2014cleanSnapped_Pro,Date,-1,-1,Ohio2014cleanSnapped,Date,-1,-1;StreetPrefix "StreetPrefix" true true false 255 Text 0 0 ,First,#,Indiana2014cleanSnapped_Proj,StreetPrefix,-1,-1,Kentucky2014cleanSnapped_Pro,StreetPrefix,-1,-1,Ohio2014cleanSnapped,StreetPrefix,-1,-1;StreetName "StreetName" true true false 255 Text 0 0 ,First,#,Indiana2014cleanSnapped_Proj,StreetName,-1,-1,Kentucky2014cleanSnapped_Pro,StreetName,-1,-1,Ohio2014cleanSnapped,StreetName,-1,-1;StreetSuffix "StreetSuffix" true true false 255 Text 0 0 ,First,#,Indiana2014cleanSnapped_Proj,StreetSuffix,-1,-1,Kentucky2014cleanSnapped_Pro,StreetSuffix,-1,-1,Ohio2014cleanSnapped,StreetSuffix,-1,-1;MannerCollision "MannerCollision" true true false 255 Text 0 0 ,First,#,Indiana2014cleanSnapped_Proj,MannerCollision,-1,-1,Kentucky2014cleanSnapped_Pro,MannerCollision,-1,-1,Ohio2014cleanSnapped,MannerCollision,-1,-1;AnimalInvolved "AnimalInvolved" true true false 255 Text 0 0 ,First,#,Indiana2014cleanSnapped_Proj,AnimalInvolved,-1,-1,Kentucky2014cleanSnapped_Pro,AnimalInvolved,-1,-1,Ohio2014cleanSnapped,AnimalInvolved,-1,-1;Weather "Weather" true true false 255 Text 0 0 ,First,#,Indiana2014cleanSnapped_Proj,Weather,-1,-1,Kentucky2014cleanSnapped_Pro,WEATHER,-1,-1,Ohio2014cleanSnapped,WEATHER,-1,-1;RoadCondition "RoadCondition" true true false 255 Text 0 0 ,First,#,Indiana2014cleanSnapped_Proj,RoadCondition,-1,-1,Kentucky2014cleanSnapped_Pro,RoadCondition,-1,-1,Ohio2014cleanSnapped,RoadCondition,-1,-1;RoadCharacter "RoadCharacter" true true false 255 Text 0 0 ,First,#,Indiana2014cleanSnapped_Proj,RoadCharacter,-1,-1,Kentucky2014cleanSnapped_Pro,RoadCharacter,-1,-1,Ohio2014cleanSnapped,RoadCharacter,-1,-1;State "State" true true false 255 Text 0 0 ,First,#,Indiana2014cleanSnapped_Proj,State,-1,-1,Kentucky2014cleanSnapped_Pro,State,-1,-1,Ohio2014cleanSnapped,State,-1,-1;Reference "Reference" true true false 255 Text 0 0 ,First,#,Indiana2014cleanSnapped_Proj,Reference,-1,-1,Kentucky2014cleanSnapped_Pro,Reference,-1,-1,Ohio2014cleanSnapped,Reference,-1,-1;ReferenceType "ReferenceType" true true false 255 Text 0 0 ,First,#,Indiana2014cleanSnapped_Proj,ReferenceType,-1,-1,Kentucky2014cleanSnapped_Pro,ReferenceType,-1,-1,Ohio2014cleanSnapped,ReferenceType,-1,-1;BicycleInvolved "BicycleInvolved" true true false 2 Short 0 0 ,First,#,Indiana2014cleanSnapped_Proj,BicycleInvolved,-1,-1,Kentucky2014cleanSnapped_Pro,BicycleInvolved,-1,-1,Ohio2014cleanSnapped,BicycleInvolved,-1,-1;PedestrianInvolved "PedestrianInvolved" true true false 2 Short 0 0 ,First,#,Indiana2014cleanSnapped_Proj,PedestrianInvolved,-1,-1,Kentucky2014cleanSnapped_Pro,PedestrianInvolved,-1,-1,Ohio2014cleanSnapped,PedestrianInvolved,-1,-1"
CalculateField OKI_Crashes2014 County "Dearborn" VB #
CalculateField OKI_Crashes2014 County "Hamilton" VB #
CalculateField OKI_Crashes2014 County "Campbell" VB #
CalculateField OKI_Crashes2014 County "Kenton" VB #
CalculateField OKI_Crashes2014 County "Butler" VB #
CalculateField OKI_Crashes2014 County "Clermont" VB #
CalculateField OKI_Crashes2014 County "Warren" VB #
CalculateField OKI_Crashes2014 County "Boone" VB #
CalculateField OKI_Crashes2014 County "Butler" VB #
CalculateField OKI_Crashes2014 County "Hamilton" VB #
CalculateField OKI_Crashes2014 County "Clermont" VB #
Snap OKI_Crashes2014 "OKI_TrafficVolume EDGE '5 Feet'"
Snap OKI_Crashes2014 "OKI_TrafficVolume EDGE '5 Feet'"
Snap OKI_Crashes2014 "OKI_TrafficVolume EDGE '5 Feet'"
Snap OKI_Crashes2014 "OKI_TrafficVolume EDGE '5 Feet'"
CalculateField OKI_Crashes2014 intersect 1 VB #
CalculateField OKI_Crashes2014 intersect 2 VB #
CalculateField OKI_Crashes2014 intersect 3 VB #
CalculateField OKI_Crashes2014 intersect 1 VB #
CalculateField OKI_Crashes2014 intersect 3 VB #
CalculateField OKI_Crashes2014 intersect 1 VB #
CalculateField OKI_Crashes2014 intersect 1 VB #
CalculateField OKI_Crashes2014 intersect 1 VB #
CalculateField OKI_Crashes2014 intersect 1 VB #
CalculateField OKI_Crashes2010_2014 County "Butler" VB #
CalculateField OKI_Crashes2010_2014 County "Kenton" VB #
CalculateField OKI_Crashes2010_2014 County "Campbell" VB #
CalculateField OKI_Crashes2010_2014 County "Hamilton" VB #
CalculateField OKI_Crashes2010_2014 County "Clermont" VB #
CalculateField OKI_Crashes2010_2014 County "Boone" VB #
Append KY1017extract OKI_Crashes2014 NO_TEST "FATACC "FATACC" true true false 8 Double 0 0 ,First,#,KY1017extract,FATACC,-1,-1;INJACC "INJACC" true true false 8 Double 0 0 ,First,#,KY1017extract,INJACC,-1,-1;FATLS "FATLS" true true false 8 Double 0 0 ,First,#,KY1017extract,FATLS,-1,-1;INJS "INJS" true true false 8 Double 0 0 ,First,#,KY1017extract,INJS,-1,-1;INJS_INCAP "INJS_INCAP" true true false 2 Short 0 0 ,First,#,KY1017extract,INJS_INCAP,-1,-1;Year "Year" true true false 2 Short 0 0 ,First,#,KY1017extract,Year,-1,-1;Time "Time" true true false 2 Short 0 0 ,First,#,KY1017extract,Time,-1,-1;Date "Date" true true false 255 Text 0 0 ,First,#,KY1017extract,Date,-1,-1;StreetPrefix "StreetPrefix" true true false 255 Text 0 0 ,First,#,KY1017extract,StreetPrefix,-1,-1;StreetName "StreetName" true true false 255 Text 0 0 ,First,#,KY1017extract,StreetName,-1,-1;StreetSuffix "StreetSuffix" true true false 255 Text 0 0 ,First,#,KY1017extract,StreetSuffix,-1,-1;MannerCollision "MannerCollision" true true false 255 Text 0 0 ,First,#,KY1017extract,MannerCollision,-1,-1;AnimalInvolved "AnimalInvolved" true true false 255 Text 0 0 ,First,#,KY1017extract,AnimalInvolved,-1,-1;Weather "Weather" true true false 255 Text 0 0 ,First,#,KY1017extract,WEATHER,-1,-1;RoadCondition "RoadCondition" true true false 255 Text 0 0 ,First,#,KY1017extract,RoadCondition,-1,-1;RoadCharacter "RoadCharacter" true true false 255 Text 0 0 ,First,#,KY1017extract,RoadCharacter,-1,-1;State "State" true true false 255 Text 0 0 ,First,#,KY1017extract,State,-1,-1;Reference "Reference" true true false 255 Text 0 0 ,First,#,KY1017extract,Reference,-1,-1;ReferenceType "ReferenceType" true true false 255 Text 0 0 ,First,#,KY1017extract,ReferenceType,-1,-1;BicycleInvolved "BicycleInvolved" true true false 2 Short 0 0 ,First,#,KY1017extract,BicycleInvolved,-1,-1;PedestrianInvolved "PedestrianInvolved" true true false 2 Short 0 0 ,First,#,KY1017extract,PedestrianInvolved,-1,-1;County "County" true true false 50 Text 0 0 ,First,#,KY1017extract,COUNTY,-1,-1" #
Snap OKI_Crashes2015 "'Functional Class Streets' EDGE '50 Feet'"
Snap OKI_Crashes2015 "'Functional Class Streets' EDGE '500 Feet'"
Snap OKI_Crashes2015 "'Functional Class Streets' EDGE '500 Feet'"
CalculateField OKI_Crashes2015 check 1 VB #
CalculateField OKI_Crashes2015 County !County!.replace('BUT', 'BUTLER').replace('CLE', 'CLERMONT').replace('HAM', 'HAMILTON').replace('WAR', 'WARREN') PYTHON_9.3 #
CalculateField OKI_Crashes2015 County !County!.title() PYTHON_9.3 #
FeatureClassToFeatureClass OKI_Crashes2015 "Database Connections\sde.sde" Crashes_2015 # "FATACC "FATACC" true true false 8 Double 0 0 ,First,#,OKI_Crashes2015,FATACC,-1,-1;INJACC "INJACC" true true false 8 Double 0 0 ,First,#,OKI_Crashes2015,INJACC,-1,-1;FATLS "FATLS" true true false 8 Double 0 0 ,First,#,OKI_Crashes2015,FATLS,-1,-1;INJS "INJS" true true false 8 Double 0 0 ,First,#,OKI_Crashes2015,INJS,-1,-1;INJS_INCAP "INJS_INCAP" true true false 2 Short 0 0 ,First,#,OKI_Crashes2015,INJS_INCAP,-1,-1;Year "Year" true true false 2 Short 0 0 ,First,#,OKI_Crashes2015,Year,-1,-1;Time "Time" true true false 2 Short 0 0 ,First,#,OKI_Crashes2015,Time,-1,-1;Date "Date" true true false 255 Text 0 0 ,First,#,OKI_Crashes2015,Date,-1,-1;StreetPrefix "StreetPrefix" true true false 255 Text 0 0 ,First,#,OKI_Crashes2015,StreetPrefix,-1,-1;StreetName "StreetName" true true false 255 Text 0 0 ,First,#,OKI_Crashes2015,StreetName,-1,-1;StreetSuffix "StreetSuffix" true true false 255 Text 0 0 ,First,#,OKI_Crashes2015,StreetSuffix,-1,-1;MannerCollision "MannerCollision" true true false 255 Text 0 0 ,First,#,OKI_Crashes2015,MannerCollision,-1,-1;AnimalInvolved "AnimalInvolved" true true false 255 Text 0 0 ,First,#,OKI_Crashes2015,AnimalInvolved,-1,-1;Weather "Weather" true true false 255 Text 0 0 ,First,#,OKI_Crashes2015,Weather,-1,-1;RoadCondition "RoadCondition" true true false 255 Text 0 0 ,First,#,OKI_Crashes2015,RoadCondition,-1,-1;RoadCharacter "RoadCharacter" true true false 255 Text 0 0 ,First,#,OKI_Crashes2015,RoadCharacter,-1,-1;State "State" true true false 255 Text 0 0 ,First,#,OKI_Crashes2015,State,-1,-1;Reference "Reference" true true false 255 Text 0 0 ,First,#,OKI_Crashes2015,Reference,-1,-1;ReferenceType "ReferenceType" true true false 255 Text 0 0 ,First,#,OKI_Crashes2015,ReferenceType,-1,-1;BicycleInvolved "BicycleInvolved" true true false 2 Short 0 0 ,First,#,OKI_Crashes2015,BicycleInvolved,-1,-1;PedestrianInvolved "PedestrianInvolved" true true false 2 Short 0 0 ,First,#,OKI_Crashes2015,PedestrianInvolved,-1,-1;County "County" true true false 50 Text 0 0 ,First,#,OKI_Crashes2015,County,-1,-1" #
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' 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/2.4.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68363069796f31316678334e7455664b77725a776e6f513d3d2a00;SERVER=okisql2;INSTANCE=sde:postgresql:okisql2;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=okisql2;DATABASE=oki;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>oki.sde.Crashes_2015</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>pedestrianfatal</field_name><field_type>SHORT</field_type><field_precision>5</field_precision><field_alias>pedestrianfatal</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>bicyclefatal</field_name><field_type>SHORT</field_type><field_precision>5</field_precision><field_alias>bicyclefatal</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>pedestrianincapinjs</field_name><field_type>SHORT</field_type><field_precision>5</field_precision><field_alias>pedestrianincapinjs</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>bicycleincapinjs</field_name><field_type>SHORT</field_type><field_precision>5</field_precision><field_alias>bicycleincapinjs</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField Crashes\oki.sde.Crashes_2015 pedestrianfatal 1 "Python 3" #
CalculateField Crashes\oki.sde.Crashes_2015 pedestrianfatal 0 "Python 3" #
CalculateField Crashes\oki.sde.Crashes_2015 pedestrianincapinjs 1 "Python 3" #
CalculateField Crashes\oki.sde.Crashes_2015 pedestrianincapinjs 0 "Python 3" #
CalculateField Crashes\oki.sde.Crashes_2015 bicyclefatal 1 "Python 3" #
CalculateField Crashes\oki.sde.Crashes_2015 bicycleincapinjs 1 "Python 3" #
CalculateField Crashes\oki.sde.Crashes_2015 bicycleincapinjs 0 "Python 3" #
CalculateField Crashes\oki.sde.Crashes_2015 bicyclefatal 0 "Python 3" #
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' 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/2.6.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e682b7159623547516c736f4f3847492b667968684870773d3d2a00;SERVER=okisql2;INSTANCE=sde:postgresql:okisql2;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=okisql2;DATABASE=oki;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>oki.sde.Crashes_2015</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>intersectionindicated</field_name><field_type>SHORT</field_type><field_precision>5</field_precision><field_alias>intersectionindicated</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
AddField oki.sde.Crashes_2015 unittype1 Text # # # # NULLABLE NON_REQUIRED #
AddField oki.sde.Crashes_2015 unittype2 Text # # # # NULLABLE NON_REQUIRED #
AddField oki.sde.Crashes_2015 roadwaydeparture "Short (small integer)" # # # # NULLABLE NON_REQUIRED #
AddField oki.sde.Crashes_2015 speedrelated "Short (small integer)" # # # # NULLABLE NON_REQUIRED #
AddField oki.sde.Crashes_2015 workzonerelated "Short (small integer)" # # # # NULLABLE NON_REQUIRED #
AddField oki.sde.Crashes_2015 traininvolved "Short (small integer)" # # # # NULLABLE NON_REQUIRED #
AddField oki.sde.Crashes_2015 secondarycrash "Short (small integer)" # # # # NULLABLE NON_REQUIRED #
TruncateTable oki.sde.Crashes_2015
Append Crashes2015redo oki.sde.Crashes_2015 "Use the field map to reconcile field differences" "fatacc "fatacc" true true false 8 Double 8 38,First,#,Crashes2015redo,fatacc,-1,-1;injacc "injacc" true true false 8 Double 8 38,First,#,Crashes2015redo,injacc,-1,-1;fatls "fatls" true true false 8 Double 8 38,First,#,Crashes2015redo,fatls,-1,-1;injs "injs" true true false 8 Double 8 38,First,#,Crashes2015redo,injs,-1,-1;injs_incap "injs_incap" true true false 2 Short 0 5,First,#,Crashes2015redo,injs_incap,-1,-1;year "year" true true false 2 Short 0 5,First,#,Crashes2015redo,year,-1,-1;time "time" true true false 2 Short 0 5,First,#,Crashes2015redo,time,-1,-1;date "date" true true false 255 Text 0 0,First,#,Crashes2015redo,date,0,255;streetprefix "streetprefix" true true false 255 Text 0 0,First,#,Crashes2015redo,streetprefix,0,255;streetname "streetname" true true false 255 Text 0 0,First,#,Crashes2015redo,streetname,0,255;streetsuffix "streetsuffix" true true false 255 Text 0 0,First,#,Crashes2015redo,streetsuffix,0,255;mannercollision "mannercollision" true true false 255 Text 0 0,First,#,Crashes2015redo,mannercollision,0,255;animalinvolved "animalinvolved" true true false 255 Text 0 0,First,#,Crashes2015redo,animalinvolved,0,255;weather "weather" true true false 255 Text 0 0,First,#,Crashes2015redo,weather,0,255;roadcondition "roadcondition" true true false 255 Text 0 0,First,#,Crashes2015redo,roadcondition,0,255;roadcharacter "roadcharacter" true true false 255 Text 0 0,First,#,Crashes2015redo,roadcharacter,0,255;state "state" true true false 255 Text 0 0,First,#,Crashes2015redo,state,0,255;reference "reference" true true false 255 Text 0 0,First,#,Crashes2015redo,reference,0,255;referencetype "referencetype" true true false 255 Text 0 0,First,#,Crashes2015redo,referencetype,0,255;bicycleinvolved "bicycleinvolved" true true false 2 Short 0 5,First,#,Crashes2015redo,bicycleinvolved,-1,-1;pedestrianinvolved "pedestrianinvolved" true true false 2 Short 0 5,First,#,Crashes2015redo,pedestrianinvolved,-1,-1;county "county" true true false 50 Text 0 0,First,#,Crashes2015redo,county,0,50;pedestrianfatal "pedestrianfatal" true true false 2 Short 0 5,First,#,Crashes2015redo,pedestrianfatal,-1,-1;bicyclefatal "bicyclefatal" true true false 2 Short 0 5,First,#,Crashes2015redo,bicyclefatal,-1,-1;pedestrianincapinjs "pedestrianincapinjs" true true false 2 Short 0 5,First,#,Crashes2015redo,pedestrianincapinjs,-1,-1;bicycleincapinjs "bicycleincapinjs" true true false 2 Short 0 5,First,#,Crashes2015redo,bicycleincapinjs,-1,-1;intersectionindicated "intersectionindicated" true true false 2 Short 0 5,First,#,Crashes2015redo,intersectionindicated,-1,-1;unittype1 "unittype1" true true false 0 Text 0 0,First,#,Crashes2015redo,unittype1,0,255;unittype2 "unittype2" true true false 0 Text 0 0,First,#,Crashes2015redo,unittype2,0,255;roadwaydeparture "roadwaydeparture" true true false 0 Short 0 0,First,#,Crashes2015redo,roadwaydeparture,-1,-1;speedrelated "speedrelated" true true false 0 Short 0 0,First,#,Crashes2015redo,speedrelated,-1,-1;workzonerelated "workzonerelated" true true false 0 Short 0 0,First,#,Crashes2015redo,workzonerelated,-1,-1;traininvolved "traininvolved" true true false 0 Short 0 0,First,#,Crashes2015redo,traininvolved,-1,-1;secondarycrash "secondarycrash" true true false 0 Short 0 0,First,#,Crashes2015redo,secondarycrash,-1,-1" # #
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' 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/2.7.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e682b7159623547516c736f4f3847492b667968684870773d3d2a00;SERVER=okisql2;INSTANCE=sde:postgresql:okisql2;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=okisql2;DATABASE=oki;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>oki.sde.Crashes_2015</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>stateidentifier</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>stateidentifier</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
TruncateTable oki.sde.Crashes_2015
Append Crashes2015redo oki.sde.Crashes_2015 "Use the field map to reconcile field differences" "fatacc "fatacc" true true false 8 Double 8 38,First,#,Crashes2015redo,fatacc,-1,-1;injacc "injacc" true true false 8 Double 8 38,First,#,Crashes2015redo,injacc,-1,-1;fatls "fatls" true true false 8 Double 8 38,First,#,Crashes2015redo,fatls,-1,-1;injs "injs" true true false 8 Double 8 38,First,#,Crashes2015redo,injs,-1,-1;injs_incap "injs_incap" true true false 2 Short 0 5,First,#,Crashes2015redo,injs_incap,-1,-1;year "year" true true false 2 Short 0 5,First,#,Crashes2015redo,year,-1,-1;time "time" true true false 2 Short 0 5,First,#,Crashes2015redo,time,-1,-1;date "date" true true false 255 Text 0 0,First,#,Crashes2015redo,date,0,255;streetprefix "streetprefix" true true false 255 Text 0 0,First,#,Crashes2015redo,streetprefix,0,255;streetname "streetname" true true false 255 Text 0 0,First,#,Crashes2015redo,streetname,0,255;streetsuffix "streetsuffix" true true false 255 Text 0 0,First,#,Crashes2015redo,streetsuffix,0,255;mannercollision "mannercollision" true true false 255 Text 0 0,First,#,Crashes2015redo,mannercollision,0,255;animalinvolved "animalinvolved" true true false 255 Text 0 0,First,#,Crashes2015redo,animalinvolved,0,255;weather "weather" true true false 255 Text 0 0,First,#,Crashes2015redo,weather,0,255;roadcondition "roadcondition" true true false 255 Text 0 0,First,#,Crashes2015redo,roadcondition,0,255;roadcharacter "roadcharacter" true true false 255 Text 0 0,First,#,Crashes2015redo,roadcharacter,0,255;state "state" true true false 255 Text 0 0,First,#,Crashes2015redo,state,0,255;reference "reference" true true false 255 Text 0 0,First,#,Crashes2015redo,reference,0,255;referencetype "referencetype" true true false 255 Text 0 0,First,#,Crashes2015redo,referencetype,0,255;bicycleinvolved "bicycleinvolved" true true false 2 Short 0 5,First,#,Crashes2015redo,bicycleinvolved,-1,-1;pedestrianinvolved "pedestrianinvolved" true true false 2 Short 0 5,First,#,Crashes2015redo,pedestrianinvolved,-1,-1;county "county" true true false 50 Text 0 0,First,#,Crashes2015redo,county,0,50;pedestrianfatal "pedestrianfatal" true true false 2 Short 0 5,First,#,Crashes2015redo,pedestrianfatal,-1,-1;bicyclefatal "bicyclefatal" true true false 2 Short 0 5,First,#,Crashes2015redo,bicyclefatal,-1,-1;pedestrianincapinjs "pedestrianincapinjs" true true false 2 Short 0 5,First,#,Crashes2015redo,pedestrianincapinjs,-1,-1;bicycleincapinjs "bicycleincapinjs" true true false 2 Short 0 5,First,#,Crashes2015redo,bicycleincapinjs,-1,-1;intersectionindicated "intersectionindicated" true true false 2 Short 0 5,First,#,Crashes2015redo,intersectionindicated,-1,-1;unittype1 "unittype1" true true false 255 Text 0 0,First,#,Crashes2015redo,unittype1,0,255;unittype2 "unittype2" true true false 255 Text 0 0,First,#,Crashes2015redo,unittype2,0,255;roadwaydeparture "roadwaydeparture" true true false 2 Short 0 5,First,#,Crashes2015redo,roadwaydeparture,-1,-1;speedrelated "speedrelated" true true false 2 Short 0 5,First,#,Crashes2015redo,speedrelated,-1,-1;workzonerelated "workzonerelated" true true false 2 Short 0 5,First,#,Crashes2015redo,workzonerelated,-1,-1;traininvolved "traininvolved" true true false 2 Short 0 5,First,#,Crashes2015redo,traininvolved,-1,-1;secondarycrash "secondarycrash" true true false 2 Short 0 5,First,#,Crashes2015redo,secondarycrash,-1,-1;stateidentifier "stateidentifier" true true false 255 Text 0 0,First,#,Crashes2015redo,stateidentifier,0,50" # #
AddIndex oki.sde.Crashes_2015 stateidentifier stateid UNIQUE NON_ASCENDING
CalculateField oki.sde.Crashes_2015 traininvolved 1 "Python 3" # Text
CalculateField oki.sde.Crashes_2015 traininvolved 0 "Python 3" # Text
AddField oki.sde.Crashes_2015 latitude "Double (double precision)" # # # # NULLABLE NON_REQUIRED #
AddField oki.sde.Crashes_2015 longitude "Double (double precision)" # # # # NULLABLE NON_REQUIRED #
CalculateGeometryAttributes oki.sde.Crashes_2015 "latitude POINT_Y" # # # "Decimal Degrees"
CalculateGeometryAttributes oki.sde.Crashes_2015 "longitude POINT_X" # # # "Decimal Degrees"
ExportFeatures oki.sde.Crashes_2015 "T:\GIS\Staff\Niese\Crash Dashboard\Crash Dashboard.gdb\crashes_2015" # NOT_USE_ALIAS "fatacc "fatacc" true true false 8 Double 8 38,First,#,oki.sde.Crashes_2015,fatacc,-1,-1;injacc "injacc" true true false 8 Double 8 38,First,#,oki.sde.Crashes_2015,injacc,-1,-1;fatls "fatls" true true false 8 Double 8 38,First,#,oki.sde.Crashes_2015,fatls,-1,-1;injs "injs" true true false 8 Double 8 38,First,#,oki.sde.Crashes_2015,injs,-1,-1;injs_incap "injs_incap" true true false 2 Short 0 5,First,#,oki.sde.Crashes_2015,injs_incap,-1,-1;year "year" true true false 2 Short 0 5,First,#,oki.sde.Crashes_2015,year,-1,-1;time "time" true true false 2 Short 0 5,First,#,oki.sde.Crashes_2015,time,-1,-1;date "date" true true false 255 Text 0 0,First,#,oki.sde.Crashes_2015,date,0,255;streetprefix "streetprefix" true true false 255 Text 0 0,First,#,oki.sde.Crashes_2015,streetprefix,0,255;streetname "streetname" true true false 255 Text 0 0,First,#,oki.sde.Crashes_2015,streetname,0,255;streetsuffix "streetsuffix" true true false 255 Text 0 0,First,#,oki.sde.Crashes_2015,streetsuffix,0,255;mannercollision "mannercollision" true true false 255 Text 0 0,First,#,oki.sde.Crashes_2015,mannercollision,0,255;animalinvolved "animalinvolved" true true false 255 Text 0 0,First,#,oki.sde.Crashes_2015,animalinvolved,0,255;weather "weather" true true false 255 Text 0 0,First,#,oki.sde.Crashes_2015,weather,0,255;roadcondition "roadcondition" true true false 255 Text 0 0,First,#,oki.sde.Crashes_2015,roadcondition,0,255;roadcharacter "roadcharacter" true true false 255 Text 0 0,First,#,oki.sde.Crashes_2015,roadcharacter,0,255;state "state" true true false 255 Text 0 0,First,#,oki.sde.Crashes_2015,state,0,255;reference "reference" true true false 255 Text 0 0,First,#,oki.sde.Crashes_2015,reference,0,255;referencetype "referencetype" true true false 255 Text 0 0,First,#,oki.sde.Crashes_2015,referencetype,0,255;bicycleinvolved "bicycleinvolved" true true false 2 Short 0 5,First,#,oki.sde.Crashes_2015,bicycleinvolved,-1,-1;pedestrianinvolved "pedestrianinvolved" true true false 2 Short 0 5,First,#,oki.sde.Crashes_2015,pedestrianinvolved,-1,-1;county "county" true true false 50 Text 0 0,First,#,oki.sde.Crashes_2015,county,0,50;pedestrianfatal "pedestrianfatal" true true false 2 Short 0 5,First,#,oki.sde.Crashes_2015,pedestrianfatal,-1,-1;bicyclefatal "bicyclefatal" true true false 2 Short 0 5,First,#,oki.sde.Crashes_2015,bicyclefatal,-1,-1;pedestrianincapinjs "pedestrianincapinjs" true true false 2 Short 0 5,First,#,oki.sde.Crashes_2015,pedestrianincapinjs,-1,-1;bicycleincapinjs "bicycleincapinjs" true true false 2 Short 0 5,First,#,oki.sde.Crashes_2015,bicycleincapinjs,-1,-1;intersectionindicated "intersectionindicated" true true false 2 Short 0 5,First,#,oki.sde.Crashes_2015,intersectionindicated,-1,-1;unittype1 "unittype1" true true false 255 Text 0 0,First,#,oki.sde.Crashes_2015,unittype1,0,255;unittype2 "unittype2" true true false 255 Text 0 0,First,#,oki.sde.Crashes_2015,unittype2,0,255;roadwaydeparture "roadwaydeparture" true true false 2 Short 0 5,First,#,oki.sde.Crashes_2015,roadwaydeparture,-1,-1;speedrelated "speedrelated" true true false 2 Short 0 5,First,#,oki.sde.Crashes_2015,speedrelated,-1,-1;workzonerelated "workzonerelated" true true false 2 Short 0 5,First,#,oki.sde.Crashes_2015,workzonerelated,-1,-1;traininvolved "traininvolved" true true false 2 Short 0 5,First,#,oki.sde.Crashes_2015,traininvolved,-1,-1;secondarycrash "secondarycrash" true true false 2 Short 0 5,First,#,oki.sde.Crashes_2015,secondarycrash,-1,-1;stateidentifier "stateidentifier" true true false 255 Text 0 0,First,#,oki.sde.Crashes_2015,stateidentifier,0,255;latitude "latitude" true true false 8 Double 8 38,First,#,oki.sde.Crashes_2015,latitude,-1,-1;longitude "longitude" true true false 8 Double 8 38,First,#,oki.sde.Crashes_2015,longitude,-1,-1" #
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' 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.1.0'><WorkspaceConnectionString>DATABASE=T:\GIS\Staff\Niese\Crash Dashboard\Crash Dashboard.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>crashes_2015</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>crashtype</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField crashes_2015 crashtype crashtype(!fatls!,!injs_incap!,!injs!) "Python 3" "def crashtype(fatal,incap,inj):
if fatal>0:
return "Fatal"
elif incap>0:
return "Serious injury"
elif inj>0:
return "Minor injury"
else:
return "Prop damage only"" Text NO_ENFORCE_DOMAINS
CalculateField crashes_2015 mannercrash mannercol(!mannercollision!) "Python 3" "def mannercol(mc):
if mc=="Rear End" or mc=="REAR-END" or mc=="REAR END":
return "REAR END"
elif mc=="HEAD ON" or mc=="Head On" or mc=="HEAD-ON" or mc=="HEAD ON BETWEEN TWO MOTOR VEHICLES":
return "HEAD ON"
elif mc=="ANGLE" or mc=="Angle" or mc=="RIGHT ANGLE":
return "ANGLE"
elif mc=="Backing" or mc=="Backing Crash" or mc=="BACKING" or mc=="BACKING CRASH" or mc=="REAR TO REAR":
return "BACKING"
elif mc=="Sideswipe - Passing" or mc=="Sideswipe Passing" or mc=="SIDESWIPE-SAME DIRECTION" or mc =="SAME DIRECTION SIDESWIPE" or mc =="SIDESWIPE,SAME DIRECITON" or mc=="SIDESWIPE,SAME DIRECTION" or mc=="Same Direction Sideswipe":
return "SIDESWIPE SAME DIRECTION"
elif mc=="SIDESWIP-OPPOSITION DIRECTION" or mc=="Sideswipe Meeting" or mc=="OPPOSITE DIRECTION SIDESWIPE" or mc=="Sideswipe - Meeting" or mc=="SIDESWIPE, OPPOSITE DIRECTION" or mc=="Opposite Direction Sideswipe":
return "SIDESWIPE OPPOSITE DIRECTION"
elif mc=="RIGHT TURN" or mc=="LEFT/RIGHT TURN" or mc=="LEFT TURN" or mc=="OPPOSING LEFT TURN" or mc=="Left Turn" or mc=="Left/Right Turn" or mc=="Right Turn":
return "TURNING"
elif mc=="Collision with animal other" or mc=="COLLISION WITH ANIMAL OTHER" or mc=="COLLISION WITH DEER" or mc=="Animal" or mc=="Collision with deer" or mc=="ANIMAL/OBJECT IN ROADWAY":
return "ANIMAL"
elif mc=="Pedestrian" or mc=="Pedalcycles" or mc=="Other Non-Vehicle":
return "NON-VEHICLE"
elif mc=="Collision with object in road" or mc=="COLLISION WITH OBJECT IN ROAD" or mc=="Other Object" or mc=="Fixed Object":
return "COLLISION WITH OBJECT"
elif mc=="Run off road left" or mc=="Run off road right" or mc=="Ran off Road" or mc=="RAN OFF ROAD":
return "RAN OFF ROAD"
else:
return "OTHER/UNKNOWN"" Text NO_ENFORCE_DOMAINS
CalculateField crashes_2015 incapinjacc incap(!injs_incap!) "Python 3" "def incap(ic):
if ic>0:
return 1
else:
return 0" "Long (32-bit integer)" NO_ENFORCE_DOMAINS
Merge crashes_2015;crashes_2016;crashes_2017;crashes_2018;crashes_2019;crashes_2020;crashes_2021 "T:\GIS\Staff\Niese\Crash Dashboard\Crash Dashboard.gdb\crashes_2015_2021" "fatacc "fatacc" true true false 8 Double 0 0,First,#,crashes_2015,fatacc,-1,-1,crashes_2016,fatacc,-1,-1,crashes_2017,fatacc,-1,-1,crashes_2018,fatacc,-1,-1,crashes_2019,fatacc,-1,-1,crashes_2020,fatacc,-1,-1,crashes_2021,fatacc,-1,-1;incapinjacc "incapinjacc" true true false 4 Long 0 0,First,#,crashes_2015,incapinjacc,-1,-1,crashes_2016,incapinjacc,-1,-1,crashes_2017,incapinjacc,-1,-1,crashes_2018,incapinjacc,-1,-1,crashes_2019,incapinjacc,-1,-1,crashes_2020,incapinjacc,-1,-1,crashes_2021,incapinjacc,-1,-1;injacc "injacc" true true false 8 Double 0 0,First,#,crashes_2015,injacc,-1,-1,crashes_2016,injacc,-1,-1,crashes_2017,injacc,-1,-1,crashes_2018,injacc,-1,-1,crashes_2019,injacc,-1,-1,crashes_2020,injacc,-1,-1,crashes_2021,injacc,-1,-1;fatls "fatls" true true false 8 Double 0 0,First,#,crashes_2015,fatls,-1,-1,crashes_2016,fatls,-1,-1,crashes_2017,fatls,-1,-1,crashes_2018,fatls,-1,-1,crashes_2019,fatls,-1,-1,crashes_2020,fatls,-1,-1,crashes_2021,fatls,-1,-1;injs_incap "injs_incap" true true false 2 Short 0 0,First,#,crashes_2015,injs_incap,-1,-1,crashes_2016,injs_incap,-1,-1,crashes_2017,injs_incap,-1,-1,crashes_2018,injs_incap,-1,-1,crashes_2019,injs_incap,-1,-1,crashes_2020,injs_incap,-1,-1,crashes_2021,injs_incap,-1,-1;injs "injs" true true false 8 Double 0 0,First,#,crashes_2015,injs,-1,-1,crashes_2016,injs,-1,-1,crashes_2017,injs,-1,-1,crashes_2018,injs,-1,-1,crashes_2019,injs,-1,-1,crashes_2020,injs,-1,-1,crashes_2021,injs,-1,-1;year "year" true true false 2 Short 0 0,First,#,crashes_2015,year,-1,-1,crashes_2016,year,-1,-1,crashes_2017,year,-1,-1,crashes_2018,year,-1,-1,crashes_2019,year,-1,-1,crashes_2020,year,-1,-1,crashes_2021,year,-1,-1;time "time" true true false 2 Short 0 0,First,#,crashes_2015,time,-1,-1,crashes_2016,time,-1,-1,crashes_2017,time,-1,-1,crashes_2018,time,-1,-1,crashes_2019,time,-1,-1,crashes_2020,time,-1,-1,crashes_2021,time,-1,-1;date "date" true true false 255 Text 0 0,First,#,crashes_2015,date,0,255,crashes_2016,date,0,255,crashes_2017,date,0,255,crashes_2018,date,0,255,crashes_2019,date,0,255,crashes_2020,date,0,255,crashes_2021,date,0,255;streetprefix "streetprefix" true true false 255 Text 0 0,First,#,crashes_2015,streetprefix,0,255,crashes_2016,streetprefix,0,255,crashes_2017,streetprefix,0,255,crashes_2018,streetprefix,0,255,crashes_2019,streetprefix,0,255,crashes_2020,streetprefix,0,255,crashes_2021,streetprefix,0,255;streetname "streetname" true true false 255 Text 0 0,First,#,crashes_2015,streetname,0,255,crashes_2016,streetname,0,255,crashes_2017,streetname,0,255,crashes_2018,streetname,0,255,crashes_2019,streetname,0,255,crashes_2020,streetname,0,255,crashes_2021,streetname,0,255;streetsuffix "streetsuffix" true true false 255 Text 0 0,First,#,crashes_2015,streetsuffix,0,255,crashes_2016,streetsuffix,0,255,crashes_2017,streetsuffix,0,255,crashes_2018,streetsuffix,0,255,crashes_2019,streetsuffix,0,255,crashes_2020,streetsuffix,0,255,crashes_2021,streetsuffix,0,255;state "state" true true false 255 Text 0 0,First,#,crashes_2015,state,0,255,crashes_2016,state,0,255,crashes_2017,state,0,255,crashes_2018,state,0,255,crashes_2019,state,0,255,crashes_2020,state,0,255,crashes_2021,state,0,255;bicycleinvolved "bicycleinvolved" true true false 2 Short 0 0,First,#,crashes_2015,bicycleinvolved,-1,-1,crashes_2016,bicycleinvolved,-1,-1,crashes_2017,bicycleinvolved,-1,-1,crashes_2018,bicycleinvolved,-1,-1,crashes_2019,bicycleinvolved,-1,-1,crashes_2020,bicycleinvolved,-1,-1,crashes_2021,bicycleinvolved,-1,-1;pedestrianinvolved "pedestrianinvolved" true true false 2 Short 0 0,First,#,crashes_2015,pedestrianinvolved,-1,-1,crashes_2016,pedestrianinvolved,-1,-1,crashes_2017,pedestrianinvolved,-1,-1,crashes_2018,pedestrianinvolved,-1,-1,crashes_2019,pedestrianinvolved,-1,-1,crashes_2020,pedestrianinvolved,-1,-1,crashes_2021,pedestrianinvolved,-1,-1;county "county" true true false 50 Text 0 0,First,#,crashes_2015,county,0,50,crashes_2016,county,0,50,crashes_2017,county,0,50,crashes_2018,county,0,50,crashes_2019,county,0,50,crashes_2020,county,0,50,crashes_2021,county,0,50;pedestrianfatal "pedestrianfatal" true true false 2 Short 0 0,First,#,crashes_2015,pedestrianfatal,-1,-1,crashes_2016,pedestrianfatal,-1,-1,crashes_2017,pedestrianfatal,-1,-1,crashes_2018,pedestrianfatal,-1,-1,crashes_2019,pedestrianfatal,-1,-1,crashes_2020,pedestrianfatal,-1,-1,crashes_2021,pedestrianfatal,-1,-1;bicyclefatal "bicyclefatal" true true false 2 Short 0 0,First,#,crashes_2015,bicyclefatal,-1,-1,crashes_2016,bicyclefatal,-1,-1,crashes_2017,bicyclefatal,-1,-1,crashes_2018,bicyclefatal,-1,-1,crashes_2019,bicyclefatal,-1,-1,crashes_2020,bicyclefatal,-1,-1,crashes_2021,bicyclefatal,-1,-1;pedestrianincapinjs "pedestrianincapinjs" true true false 2 Short 0 0,First,#,crashes_2015,pedestrianincapinjs,-1,-1,crashes_2016,pedestrianincapinjs,-1,-1,crashes_2018,pedestrianincapinjs,-1,-1,crashes_2019,pedestrianincapinjs,-1,-1,crashes_2020,pedestrianincapinjs,-1,-1,crashes_2021,pedestrianincapinjs,-1,-1,crashes_2017,pedestrainincapinjs,-1,-1;bicycleincapinjs "bicycleincapinjs" true true false 2 Short 0 0,First,#,crashes_2015,bicycleincapinjs,-1,-1,crashes_2016,bicycleincapinjs,-1,-1,crashes_2017,bicycleincapinjs,-1,-1,crashes_2018,bicycleincapinjs,-1,-1,crashes_2019,bicycleincapinjs,-1,-1,crashes_2020,bicycleincapinjs,-1,-1,crashes_2021,bicycleincapinjs,-1,-1;intersectionindicated "intersectionindicated" true true false 2 Short 0 0,First,#,crashes_2015,intersectionindicated,-1,-1,crashes_2017,intersectionindicated,-1,-1,crashes_2018,intersectionindicated,-1,-1,crashes_2019,intersectionindicated,-1,-1,crashes_2020,intersectionindicated,-1,-1,crashes_2021,intersectionindicated,-1,-1,crashes_2016,intersetionindicated,-1,-1;roadwaydeparture "roadwaydeparture" true true false 2 Short 0 0,First,#,crashes_2015,roadwaydeparture,-1,-1,crashes_2016,roadwaydeparture,-1,-1,crashes_2017,roadwaydeparture,-1,-1,crashes_2018,roadwaydeparture,-1,-1,crashes_2019,roadwaydeparture,-1,-1,crashes_2020,roadwaydeparture,-1,-1,crashes_2021,roadwaydeparture,-1,-1;speedrelated "speedrelated" true true false 2 Short 0 0,First,#,crashes_2015,speedrelated,-1,-1,crashes_2016,speedrelated,-1,-1,crashes_2017,speedrelated,-1,-1,crashes_2018,speedrelated,-1,-1,crashes_2019,speedrelated,-1,-1,crashes_2020,speedrelated,-1,-1,crashes_2021,speedrelated,-1,-1;workzonerelated "workzonerelated" true true false 2 Short 0 0,First,#,crashes_2015,workzonerelated,-1,-1,crashes_2016,workzonerelated,-1,-1,crashes_2017,workzonerelated,-1,-1,crashes_2018,workzonerelated,-1,-1,crashes_2019,workzonerelated,-1,-1,crashes_2020,workzonerelated,-1,-1,crashes_2021,workzonerelated,-1,-1;traininvolved "traininvolved" true true false 2 Short 0 0,First,#,crashes_2015,traininvolved,-1,-1,crashes_2016,traininvolved,-1,-1,crashes_2017,traininvolved,-1,-1,crashes_2018,traininvolved,-1,-1,crashes_2019,traininvolved,-1,-1,crashes_2020,traininvolved,-1,-1,crashes_2021,traininvolved,-1,-1;latitude "latitude" true true false 8 Double 0 0,First,#,crashes_2015,latitude,-1,-1,crashes_2016,latitude,-1,-1,crashes_2017,latitude,-1,-1,crashes_2018,latitude,-1,-1,crashes_2019,latitude,-1,-1,crashes_2020,latitude,-1,-1,crashes_2021,latitude,-1,-1;longitude "longitude" true true false 8 Double 0 0,First,#,crashes_2015,longitude,-1,-1,crashes_2016,longitude,-1,-1,crashes_2017,longitude,-1,-1,crashes_2018,longitude,-1,-1,crashes_2019,longitude,-1,-1,crashes_2020,longitude,-1,-1,crashes_2021,longitude,-1,-1;crashtype "crashtype" true true false 255 Text 0 0,First,#,crashes_2015,crashtype,0,255,crashes_2016,crashtype,0,512,crashes_2017,crashtype,0,512,crashes_2018,crashtype,0,512,crashes_2019,crashtype,0,512,crashes_2020,crashtype,0,512,crashes_2021,crashtype,0,512;mannercrash "mannercrash" true true false 512 Text 0 0,First,#,crashes_2015,mannercrash,0,512,crashes_2016,mannercrash,0,512,crashes_2017,mannercrash,0,512,crashes_2018,mannercrash,0,512,crashes_2019,mannercrash,0,512,crashes_2020,mannercrash,0,512,crashes_2021,mannercrash,0,512" NO_SOURCE_INFO
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' 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.1.0'><WorkspaceConnectionString>DATABASE=T:\GIS\Staff\Niese\Crash Dashboard\Crash Dashboard.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>crashes_2015_2021</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>date_formatted</field_name><field_type>DATE</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField crashes_2015_2021 date_formatted fixed_dates(!date!,!year!) "Python 3" "def fixed_dates(ds,year):
if '\/' not in ds:
y=year
m=ds[4:5]
d=ds[6:7]
datestring=str(m+'\/'+d+'\/'+str(year))
return(datestring)
else:
return(ds)
" Text NO_ENFORCE_DOMAINS
CalculateField crashes_2015_2021 date_formatted fixed_dates(!date!,!year!) "Python 3" "def fixed_dates(ds,year):
if '\/' not in ds:
y=year
m=ds[4:5]
d=ds[6:7]
datestring=str(m+'/'+d+'/'+str(year))
return(datestring)
else:
return(ds)
" Text NO_ENFORCE_DOMAINS
CalculateField crashes_2015_2021 date_formatted fixed_dates(!date!,!year!) "Python 3" "def fixed_dates(ds,year):
if '\/' not in ds:
y=year
m=ds[4:5]
d=ds[6:7]
datestring=str(m+'/'+d+'/'+str(year))
return(datestring)
else:
return(ds)
" Text NO_ENFORCE_DOMAINS
CalculateField crashes_2015_2021 date_formatted fixed_dates(!date!,!year!) "Python 3" "def fixed_dates(ds,year):
if '/' not in ds:
y=year
m=ds[4:5]
d=ds[6:7]
datestring=str(m+'/'+d+'/'+str(year))
return(datestring)
else:
return(ds)
" Text NO_ENFORCE_DOMAINS
CalculateField crashes_2015_2021 date_formatted fixed_dates(!date!,!year!) "Python 3" "def fixed_dates(ds,year):
if '/' not in ds:
y=year
m=ds[4:6]
d=ds[6:8]
datestring=str(m+'/'+d+'/'+str(year))
return(datestring)
else:
return(ds)
" Text NO_ENFORCE_DOMAINS
CalculateField crashes_2015_2021 date_formatted fixed_dates(!date!,!year!) "Python 3" "def fixed_dates(ds,year):
if '/' not in ds:
y=year
m=ds[4:6]
d=ds[6:8]
datestring=str(m+'/'+d+'/'+str(year))
return(datestring)
else:
return(ds)
" Text NO_ENFORCE_DOMAINS
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' 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.1.0'><WorkspaceConnectionString>DATABASE=T:\GIS\Staff\Niese\Crash Dashboard\Crash Dashboard.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>crashes_2015_2021</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>bike_ped_inv</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField crashes_2015_2021 bike_ped_inv bike_ped(!bicycleinvolved!,!pedestrianinvolved!) "Python 3" "def bike_ped(bike,ped):
if ped==1:
return "Pedestrian"
elif bike==1:
return "Bicycle"
" Text NO_ENFORCE_DOMAINS
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' 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.1.0'><WorkspaceConnectionString>DATABASE=T:\GIS\Staff\Niese\Crash Dashboard\Crash Dashboard.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>crashes_2015_2021</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>crash_factors</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
crashes_2015_2021
002
1226708.637442
1549845.654552
286512.425201
584126.937582
1
file://\\okigis.oki.org\data1\GIS\Staff\Niese\Crash Dashboard\Crash Dashboard.gdb
Local Area Network
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
<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.1.0'><WKT>PROJCS["NAD_1983_StatePlane_Ohio_South_FIPS_3402_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",1968500.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-82.5],PARAMETER["Standard_Parallel_1",38.73333333333333],PARAMETER["Standard_Parallel_2",40.03333333333333],PARAMETER["Latitude_Of_Origin",38.0],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",3735]]</WKT><XOrigin>-119670700</XOrigin><YOrigin>-95612900</YOrigin><XYScale>3048.0060960121928</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102723</WKID><LatestWKID>3735</LatestWKID></ProjectedCoordinateSystem>
NAD_1983_StatePlane_Ohio_South_FIPS_3402_Feet
20230623
13520600
20230623
13520600
Microsoft Windows 10 Version 10.0 (Build 19044) ; Esri ArcGIS 13.1.0.41833
Crashes 2015_2021_WFL1
1
-85.131965
-83.968547
39.594328
38.757307
Safety
Vehicle crashes in the OKI region between 2015 and 2021. Original data from ODOT, KYTC, and INDOT.
File Geodatabase Feature Class
dataset
EPSG
6.13(9.3.0.0)
0
Simple
FALSE
0
TRUE
TRUE
crashes_2015_2021
Feature Class
0
OBJECTID
OBJECTID
OID
4
0
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
Shape
Shape
Geometry
0
0
0
Feature geometry.
Esri
Coordinates defining the features.
FATACC
fatacc
Double
8
0
0
incapinjacc
incapinjacc
Integer
4
0
0
INJACC
injacc
Double
8
0
0
FATLS
fatls
Double
8
0
0
INJS
injs
Double
8
0
0
INJS_INCAP
injs_incap
SmallInteger
2
0
0
Year
year
SmallInteger
2
0
0
Time
time
SmallInteger
2
0
0
Date
date
String
255
0
0
StreetPrefix
streetprefix
String
255
0
0
StreetName
streetname
String
255
0
0
StreetSuffix
streetsuffix
String
255
0
0
State
state
String
255
0
0
BicycleInvolved
bicycleinvolved
SmallInteger
2
0
0
PedestrianInvolved
pedestrianinvolved
SmallInteger
2
0
0
pedestrianfatal
pedestrianfatal
SmallInteger
2
0
0
bicyclefatal
bicyclefatal
SmallInteger
2
0
0
pedestrianincapinjs
pedestrianincapinjs
SmallInteger
2
0
0
bicycleincapinjs
bicycleincapinjs
SmallInteger
2
0
0
County
county
String
50
0
0
intersectionindicated
intersectionindicated
SmallInteger
2
0
0
roadwaydeparture
roadwaydeparture
SmallInteger
2
0
0
speedrelated
speedrelated
SmallInteger
2
0
0
workzonerelated
workzonerelated
SmallInteger
2
0
0
traininvolved
traininvolved
SmallInteger
2
0
0
latitude
latitude
Double
8
0
0
longitude
longitude
Double
8
0
0
crashtype
crashtype
String
255
0
0
mannercrash
mannercrash
String
512
0
0
20230623
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCACFAMgDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwCx458N
ePJfFg123k060uVdrGC8t51iklhYl1fa2SuxdwYg7iqntknD8M6x4rtrnTdb8R+ILjT9L1AGC11p
raGRmCSA+XMWG5VYI2MngtnkZr2jx7Z6Fq+hT6Tq91BbzzW08ts7QrLKgRP3jxoQSSFPO3nB4IPI
yLLTfDlv8J9C8P63Nu06/hhto5BC8W6Rh5itjkocjOTgZ+uKANC48caSdUSA6dPd282nm+sbm3iE
32raQzxoo5DjCNg459MDMPibTTpemaG3hrUU0S5t5/KsbF1K212XBbyZEHTO0/N1Bz3NYng/VbLQ
bm58ERC8uppJDPb6nbGNmngmXd9pZhgfKcKWO4k7TznAqXkEujJpk918QbbVbO4mJ0g6lYJcqkyr
8shmVgcj5huJxlhQBr2Hjiw8MadbvqOnraaXc311HLf216byGGfeThjjcAzb+3GB68dj/wASPxh4
fkSOS21HS7oFS0ThlPPOCOjA9+oNc5onie/v/AVvrt5HpGn/AGu4MqxXjGFFtjLyWJzlyuWz0JYf
jyGq6b4atIbzXtalsNKSQOkc/h/VpIxc3CtICuwADcAFyfUnPHQA47xDpd34M8War4dtbu61XUdX
Nld2c2WJhaO4OxJcsSygAc5zwvSvR/EGiW2mWxhufE1xHp1xLDbjQbWKEwrJK3yR8IG8onfnjLAE
8kYPn/g3SPD3jJLVPF+pakviG/ukmt21FWYXFshOIYpGGCGzyQQc4wODnt9d+Hfg/R79p9R1rVrG
61S4jgslsJGRlVFRI4wFDZ2gD5mHfnnmgDjPhr40s/hnZ6zpmu2UbBJW8q+s4t3nyqCDCz4BIyGC
sflyH5wK6u08B+HvGPg7xF4isXvbCfxAHnEt6qx+QoYOFIGR5ZdA24clSOfXzjxX4F1KAXJayu1v
dRVrqC0n1BJZwkQdnlmAUZbYvA3HlzyTkV1ui674Us/CVxb6Z4lc3N40kt6dXt5Vhvl8sqYmcKcF
QwBZMMxX3BoA5Pxnpup6h4XsNa1zUZ768F3HY6VPaKvl3dvtDK4HBDA7uoBy2O3HMadoo8OePbex
8QRx2yW05aWK+QlWVVJUsoyGU46A/MDgda+g/jH4fs7n4X+db28ajRmhntkjwAIwQhQN1C7Tnjn5
RXT+GPCmk6TC17bpLPJdrFIJLzEskYCIAocjdj5FPJPIoA8t8U+D/A/hX4Z26XtpbzavdQme1kCP
G0rj94yKwXcFAYgB+cYBOQMemaJpGneGfDMmmeE7Szh1EWq3C21xJh3crhWlx83JGM4HQgYrK8S6
FpD6roQ8S3WpXV1PPdW1pfwsLdIPNGVRmQjB2jYvduc1xfhbSdb8OfHuTS1uZ9QtVswDd3uGmFps
JVVy33Q4VSyjqoyBnFAHrd1pDa7b6Pc6hGtpdWsq3MkKrHMAxQq0e5lPHzEErgnHWuA8cfFRvDY+
x6Np81rHp99HaT3N1Z/6KVCkmOPDAk4wQAOg7Dmt/W9Rv/8AhPNMm8P6adRNujW+qTCUrHHCzD5V
YsE8xWG4qRuxivLviBqmmeJoNXgN/otvp2m6i94j2rlP7TYw8IOPnlBIVmB4D5waAOVufG/ib4me
KdHiEi2epxI0Fl9hYxAysRlmYklRgZOM5C4A5zS+JWvvCen3eieJNLsNW1AXbsLz+0XbG8ByXiRg
ck8hnwTg9QBXRfDX4Ype6zI8+uta3kGnxzJJpV2TLG0pO1t+zaPkDIVBPTPcGq3ja2sbT4oyWviK
5l1fTLRY47ua4McUgklV2jZtmxpFQMOhyAMAgYFAHR/BaDUPDytJHoV3fW2oxxYu7O5ikgjCg7t3
z/f3FsjqBgY9fWbjxZa2Wn2d1e2GqQNdW7TiAWTyyRhduVcIGCt8w4J9aPBOjDQPB2m6f58VwyR7
3mhdnSRnJcspYkkEsTn+XSqnjvxVqXhTR2vdO8P3GqlUZ5HRwEgAK8v1YjkngH7pzjrQA7wRLJqm
jnW71bSTUbmWaNriCAoTEkrhEJZVYhRxyBWw+oLfQajb6Rd2kmoWuYiHO5YpiuVDgc45Gfxrzr4b
eI7HTPDesaPr11Dpk+nXLyyLJKsSrDP+8RkwqEA7/TOcdMgDhLHxdJo0tvonhTUb22S6j2R6zrzM
kMgaYkSRxbTknO3e3YY4xQBX1ZvHknxHS3j8TzT3EOow2ouXzBbRymMuyiLoygDJ9cdDure1+wl0
XxnqWqxyz3941q01pdaDDGJ1a4LRFpIg37xUIwGAySwyc4xk6ZpQ8a+OimvPd63psH2lbq/vLoxR
QyIF3vGsRKImNmAT83U4FdDY+FLPXNVsfCnh3xBe/wBg6fpQi1a7sJgqTuzMyKpGV3FnZm68cUAe
b+DbfxFqst94OsBa2/8AbE6W+ohkZp4IoNu5zk4UDJGCeWJA9ivWNB0Ox8PfCvWdU8HXd5aSpNcz
i7mhgaaRImZdmTkbPkyCeepxziigDu/Ht5Fp/gTWr5oLWdo7ORUW5x5bbhtwc9iSOO9Yela5o2sa
ZZm8k0zU9Gd4LWGOCx/dWVwkZLeYWJCqTtC8DG4DnOa52/0y5HhXxFpmmatf61C8KN/Zuo72vgY5
tksi7mUlCEJUAct+R9Sa10290pFubKH7JNskaG5hAG7gruVv4gQOvORQB5B4xjsPDniS81fQrXTr
LVfDSwXKQW0Dj7VayKsTRykLgEcBcHgH1yR0NlBo97bxeNdJ0q11HQpLKaaW0eEyXMMihfkhUkoP
9XgoMcgkE5Aq54Qnvrj4oeOoNQkjuFgFpHG6IyqsZV2VMHIyA3OOp57muB8e3t58OrfWYPB0kH9h
38nk3aW7EPpl0UH3Sp+Xcu0/UEcGgD0/SPDWheIbDS9Y1Hw5pyPBGy2EagskduTmP5CAAduDgjgk
9K2o10TWtBmNmLe40+bzhutVDAsSyyFcfxZLcjkkn1ry7R/ip4kt/Dmky3WkW+oyyXS2W5Lki4vC
FcMyxbAUwygEkY6/Wqkv7QFneeHdXXTdDvLS8ihYwOjxsqFiQJGB7AlSeDyce9AFrwJpekeJPBel
2Wu6HcTybJtLkubicKLbypCY12kgq/z4G1d3y88Vr+G9F8UajbR6R4o1zUYLiwntrhY4lAE0SbiE
88AGRidm8jpgc5Jxj+CbO+1bwzpUMOi6Vq1s2vTXF9qUzlgGUgmcRsqfM3zAYyAAMg5OOk8RfD7V
LrVzqmialDZyWRa709HDOTdO+ZfMY5PlsoC7F456ccgFnQvDOu3Ems+IdRa203XdXaOMReWLhbW2
jIAjPOGLKDuIwMkelY3g+zs7i513wHdXUt5oax+bZW93DJbzxp5rq6A4UsgZRhh/ex7Cxp2v+I9X
g1FtG1qyMt87CytdTTybm0mSRRNHsx8yImSMgnJGe9dL4q0nSf7Q0zxJe3osb3STI8cwcJ5ybGLx
NwSVIBOACQAcUAcX8YNRvLH4cp4auLw3usX0ZdpVtWRZY4SJJMYyAQACQT0BPGRXZeG/E7yeANO1
zXIJLVnjjWTZGXD7mCq6qpY7WyD6814J4v8AiZd/EfUNC0m1xpaHfFdN56qheTMZO9sfJsPQ4zuI
54Nd54I+IumQ+DtE8IWU9xDr7wm1EkNq06WsnmFFdw5HGcNjoM44GBQBrfFbS7jS/C/iXVIY5ry3
1LyTOglVDZmNdokTcDnJ2KQMEAkj25jU/E0us6n4e8Y6NYSRGGSTRb2CS7AuGhdgkb5H+rG9n+c4
w2BkjFdn8a76G2+GF7ZT31tFc3RiQCQkFwJELFVXJwOp6jHHevFfDieGtL8V3nkX2m3dnbWwubm4
nt2w6oqtJFbI7fMzNwGYAqBkUAez+JNZ0f4d6La+GPD6wnWNRlSJIvPCSsXIVpnfs5zwT35wQCK8
58QaB/Z3iDSvBFjqml6zYacxvJbO+8q1IYucRNMOWd9ygr32qSMVky2eoQ3L6iviC6tLoCK51jyk
MgsI1TEYklZh5lwcL8owd+ehHHYeC/Cd5e/DNdTPhvw/rt7dOZYzfRFLhj5j+YZZGyWbIGMEcE/i
Acf4M8X33hP4nanbafpWnOl1I8DWdtOiRkJnYElJwCMHJJO7PriuQ8S+J18TePb3XrhGgS5fBj8w
nYgj2Y3KRngduv41p3mlW0+ianqkGki1uJr15beGO8haNYCdoQRkiTejjGVUHDc8dZb3wXDo/gn7
XqtvqdtqyX0UD2Vw6QoyOu7ejEHcTsI5+6eCDt5APSfBuq+Erf4anUpvEGo6OI78yvFaXrtJGquU
jQR5chCrKCDnPGSQBUutfEm8m8T29l4O1ye+kN7I8q30USWjI0akRK52nIIOAcEsSDXjfh1tJm1e
40+/hsNLguywe8vVeb7JEOcRL034BAZgcnAGMnPu0kHhS2+EdtHda+39hwW9xZv5Fiqfa5egcI6k
71K5DAjJ5JFAHC+B/C+oaz8WXm8cTWp1NNly9lqKhmuN6sQEUMB8oAOMEL0xxitO88caxp/izxJr
8GnaVrGiiMafcNbq3luwEjRFgQWBA+Rv4Txz0IqeMvEl14G8Zab4j0aC0vY7nR7eC2uNRZXlZVAL
PtVgykjCksM53AelW/A+v+IfFumaroEFtoOoJPPLNcJqEszNIm5AP3iDkDIClzuOB2FAHRal4g1D
S/hPqV1JpdnZ22rWaPZNbeWsUPngRiHC8uVT5t5Ht2r0bSNL0rwV4RS2txDbWdlb75ZgnDFV+aRs
cknGT3NePafb+J/FPioJ4iisY4ra5s7tfDrXXlrwrLuCuWI2IC5QAA5z2wfSNX8baJqFhpiWH2HW
rDUtQi0+7UyArEkgbl1IPdcbSBmgBZNQ8Ww+A9JvtMista1SZo2nBiaBJYpM/MASCuNyk5HY8UVu
LbW8niWVksbyC4t7ERR3gOISjsTsRclSylATleMjtRQBg3PxE0CG7uJrXTtQvp7WRrbUHtrFjJaI
u8gyAgNsJViMZHPYnBh+JPiL7B4d0l4dHXWLXUL2FZLd7dpGaP8A1mVTA+f5cjdjGORWl421rUNC
j0uaxjlEMl9GL2eO188LD0KkbgQWJVQeep9qq634t8M6p4dvLHUbi/sre8hlhdntZomVTJ5BbO3g
bmHXseR1FAHg3iOXxdptlcXF3qmorq+qvBdXv2JgqRRmNhEkxjG7ftQnbgDHPJ6W/HGna14a0ZdG
gubnUNJ1i1gvnlv1ZlhmWN2cI0igqxCAjkMAACDVzwNovw51HQZBr2vPY3YmcRIdV24RflDj5QAx
G5cEdOQORWB43tLmC3Lar4mu9Uinlmm0xYLgXELKXCxneXJjyA5K8/cAzkHaAPV9S8a6tFqkviOw
0/UNPgtrSzPkSRrKWjd8FiDjo25m+U5OcDrysnirW5vD82mSSR/2e6JblY7SIKFRg+AwUHO4Bjzy
Tk12uq2OtLHovgyXTLmDUdNV5DFbrCRekhhHMu4AsAu1XBJG1TkDaa428tbuKC4up9RnQSyOdq7S
k3lbVDZVsMN52ggEcEjODQB23wx8a6toN696hmudMeRpNVtvtEcksjtuPmwxcNkDBbGeA2QOMe5e
MfiDp3h3w1bahZ3EF3dahgabEoaQXBOOmznGD+ZA718vW+s+JNE061tJ7iaO2hZLu1t5ICwRiFeN
g2BtDex5w2Rzz2i6fqnh3StN8XDT7TxVpmoW4877baSFrNk3O0aKOETcpwwXA244HUAn1rxP4juP
EI8e+H/D+o2sU4FvHuf7RG0y5Vy6ryny/LtPBIz1GKpW+syXev2tn8SL3Vr+VLqV5bEOYEsXRc7y
4xnjkBCABg55xW9r/wAbdI1Tw2uh6Xop01b5yl609qkscKOSWZEUjexzu5xzn61F4C0qx8X+MNbT
Uryw8QwRxx3Nqk4NmZJ0VVB8gDhSBtbg/dUkHIoA881600XdeXGhR3d1FJHDe/apXcyWDNndFIVB
V9xIw3BBwCc5qn4X8LeIfFF4ZtAgkuryCZHcggeUTkh2ZsAcqe5z/P1Lw/omveK4/Hti1hotkk12
tteXDsSIDE6/JENuNqKrdSOduMYrj/hcl/Drj3GgXFy2u2lxFut4yjR3VmW2SjBIBIyp69ORjbkA
HoFh8NtTspYrvxr4iu1urqOVZZLBWeRo403YluWyEUKDxwDgcnHGL4a+HXhXWfAWs+Jm/teytrR7
h7JrieMFlVMq7AJ1zgYyRxx1rp/GHjKa18C6uY/H2janLMPsqwJbeXIcKySBdj7gSSGDH5ePQ159
rniTxXqOliCLVLXVdA061skvYLPPlMn3l8zOWz8oDnsTigCbSfC194i8EQXt/wCJby00y8ucyGO1
89ZrmWUhkZIm3lgY42y4/iGMcZ7LwV4ztvhr4dgstXaOXRbyOe60u6iiaOaQqTuSSJuVLH7rfd5x
nHTita+Kcq21vpvhnRtP0G0Fx9pPkTEea6vsQnbtHCqMg5Bxn0rkpP7N1L+1PPlaxi0+2zZWSSPc
LI+8ZAkOQq5JORgEY56tQB2fiLX7bxbqfhzxEdIn0corS6hqEOlGaNpVJKbc/fxtJOT35zivPNa1
NtV8RXurTR20xnmaR1iRxESTycEhgDknr19K9m8LeP8ASL/xnZanq+vzaLZQ228aPK0vlGdo/Lbb
8uxYQoBVSep9zXlWty2ut+MZ7XTZ3l0wXcjRXP2NWlMbEZZlRQXx2B6DA4oAqadFpdjdbPEGm301
vuaAG0byX3AglgzggnDAFSo4YHI7+pR+BvBlxrOn6DbTSQWdhF/aWtahqMohmhRwvlwdQqHJG7jI
z1zweM/4RszX8k/g271fWdQtXiuFvIrULFt2hySdxKOrYGDnOD9Kq2d1cTaI72moxarezs+oalZ3
Fvjy/KYnc8jEebkHOz5h7ZAoA3fiTo3ha1lsX8N2flaQbNmguV3j7VOzYADuTvCgc4AwcgnmvQYv
A/iOSztdYXQrDTri5aC11DS1jWcTxK6FZmwyBXBBLAHkAZ7ivNrDwhJDps+qrObmex1azUyWj4tp
HdvmijwAN6llJYYUZIHbPpHiLw3q3gzTdLuovGmojWVupo7aJTJcvdw7mdIhF0dsldxOAN3J4WgD
jtRj8X2N94l8Wa9pdk0kUqWMjzyTwuCdqhrcq3yhhjJyBgkdDiub03WfEsHipdalhEqtqUd68Uax
P5jtIUzCDkO3DqCucHnqM1s67qPio2t5quq26LFqWoFJreeALHdvbIq4lKuMKMOcDjcpGTgY09M8
WTWnhbTbJILK/wDskc9nbXVpd3EUsCHf5kpLJsGAIyvUrwf90A9d8KePV8e6bH/ZU0OnanFKsl3Z
zo0rLAJGUhT8oJIX7wyATgiivPvhmuu6Khvf7Kj1GPSHlsZfsk0clzLHLiYMMjJUErhQwzvJxkHJ
QB3fgXR7rW/B11c6/dXd5HqzCS3jvHEpghUARHDIFD8bidvJweTXc2lubPT4Ld5prkwRqhlmIaSQ
qPvMe7HGfrVjIzjPNZ1/NcPe2lnb/YZEkLNdxXDneYNpGUUA5+YqDnjBNAHmXgFdAt/AdzqvinRd
PhkuLl7mVprRXkmiklIjlaMKSq5YgcYwM9DXM+K4fh1rnjTQILG709NFtY5Hvk060UBAMSDc6gHY
27acZweOCTXs0Nrp+k31nb6No1q7RhbOeS3aNWs4QpdQ2fmIJx8v+1muM1fwt4fu/iciR6wmkm30
4M9rYk28gke4BD7wNp3nCkHk5HHIIAOI+KPhnwlaXtlpPh3T5bnWHcxPFaXjyS225R5fyMxAUtIv
pxwCM15b/Y2qWdhq8N1Z6zEdNjEV3GgxFC7Pkb/RTheMHJ5zwM+52vjO78IaP4k0PW5ZZtb02FzZ
6gJI5JbkSPthXLcuwOM/LwFwRxz5b4r1a48Q+FrfWTe2b6pdQmPWUiuUV5hHKBEzQYBDAFeR2zxw
1AGpoJ0m+8M3ugX+uvbQHVC0mnbI4JGXYoDylwuFjKHKJk8cdAa2ovhv4ju/Dl1eyeIL9oP7NN2l
9a3slxHeqYuITGcOOc9myrYwDwV8J+AdH1/4aQz6prIhutQvp1tPJeMC4myNineuS37tsDI4c9Mm
uk8K2XxB8BeHLCBY9OudKeITSpqM7JLYHbmRPlzleCwCgnrx6gHM/DTxpFY+N7zStV0EW0dz9nTy
ltdn2WZAka/J/CMs5Ln5jx9K3fixpUS/ELSdVu5xbRxwpLbzSXH2eN3ictJCZAmVdkwVJfqpHGRX
I2LW3jTXp9Tn8C6rq9/FH5+pQnUP3bJIu6MpuG9QOqopzt7nFcnrfiuXzLnRY4riLR7C4lNhp2qq
ZWtyylCrDIwVGSoIbaePUkA7n4b+JhpviHxZo0Vtd3K6tbSX1usJDSKfKaTbuOcnDBQQrbjg4xXl
FvrE+haza3ujvLbz2mxkd0Cvu2rvDYPK53Dnqp564rotEvLCTV/D11pgj/t1Lq2jW3ih8iGMIwy7
PnLMwUbskAbm9sbfxrSJPibImkFWN6kMkqxyK6STqSg+XGAwxgg55J9aAOK1CT+3byzna00/TLSR
/s8bWwZYt24FyzOxbgSZyxwAABxW54pu49D8d3CaZ4pmvbEWn2eO/tpVeRofLK+USmFOSNue3yt2
rGa/Sw1Ky0nWNMt/sum6iXuVgVGmdd48xC4+V+FwOwxVn4ga/oXiPXLe78O6Kmk2MVqsLQrCke6Q
MxLHZwSQQMnnigDJt0lOrQ2cSfbZWjFvBHHLuBZ1xgEY7u3HTPqOsEVrMtzHAQMxzlS8K7zuyBtB
HDHjIwSOetVIX8uVHEjoc4LIOQPbnr1roPC+sxeGtXGt296wubdZo7ZPKy4Zo2VHIPy4y3I3ZHvQ
BqWNg/iXx1JpEXiiSGynheFL68uHlzCFLhGJC4zt5UgYwevez4D8G6LrX9uTa3rUUFlpaea4jTHn
AbgpErDCgnGAOWz04zV7wFrfhe5tH0zVPC1tqGqmOWWKee8MbXE27KxhjgINpbJzyR3JFdi/gLV9
Zksru40yyj8LaQfOj0jS79rma4QoJOGOQ7E7QMlfl4HGCQDirfx7d23gyDQIbVtMtBARey2cfk3F
8QvGXKkKNuBnktt98Vx2lxafdabcwXUssd088UdntOQm9sSMwHJG0AYA5J68YP19b3mgazrqiS1u
hfvbz2nk3VvKsbRI6+YCpHlkZK8857E15v8AEf4dpdWuoanM8Vhdw2c1xJqFvCkVrKqyZjhdSxYS
YwN469PmoA5jxfqekaFbaNonhk2l/aaBePc3Ed5O0UqziYZTy3I3Ln2Y479Se+s1+KviOSTWEksd
C2lVj069iEoJQKdysBkK+5we4wB3yPMrDR/CHiW0sLu8vBpR1XUShjOrJM8R8sFpZAyFss6sAHYf
6zP1+ifDsWn6F4V0+wj1KC4t7KNLT7QGVQ7jC4wDgMTgY65Pc0Aec+Ar22tfDt/p17oqar4n8PX1
xutoYEjlk81yGkTdgYKsfwAGOlc94G+G3iDUpYlu71vDqabO04gtrZhODMASBKwx/q9q8FtuBkA5
r0zwnpaarrl94tv/AA1b6ZdSysli7RlLlocbS8ozgFscDGQO56129AHn+sfCHQ9Z1C4vJdS1qJri
R5ZI470lDI2PmwQcYKrgdPlUYwKK9AooAx9d0H+1liuLW5+w6pbhltb5YhI0IYrvAVuDuC456ZrC
8X2U2k2ms+LbHVGiv49PWKAyWyzpEEfcQAq7vnOAecDr2GOmTTBJeWl/dSyPeQW7Qt5bskT7tpY+
XkjqvGc49TTdF0nS9B03+z9Jgjt7SF2PloxIVidxySSc855oA5GwstUtvHOl6k+uRRpq9qZLrTk0
woJWSJAT5mAwwxyPM5AO3uareMdH1Cx1jUfEDajBJa3kVtZ21lLprXKxTiQeXIRu7MzHIH8Q4JAz
2S6J5Oo6pfW+o3scl/EqGNpN8cLqpUSIrfdOMZHQ7RxXAfDDw7LpMmoSX+v6k7R3cum2UE2qJLGy
qoJYIpIEmVc7eSo6g9aAI/F/he28L/DHVtWvdN0fVtdVhPNdSWCxh2edWIwvJAz3POOeMivKfEq3
nxEvfP0rQ1/tW81CTz/9Ltyx2IoREzh1G3cSD1POTj5e68W6d4j8OjW7DT/EN9fWpitFW01iJL1r
yWaQqTHuyQFwDgLjIPpmrFt8PZdb0m20fTr9dGms5xc6i82nq9x9pk/eDZMuFYAFVwmOF59KAPIf
CzW9r4nsoJL8aTDaXkkn2+UNPEsm0GNXU7VyGTrjnk9AK0/iFqVlI8lu39sW9zCyG2t1ufNs4ydz
SBXPzPzJuDjP38dACVm8N+JrSXxBper212+gWN60+otp8cahZWQ7JFB2llAYNsGAB/dzmuAWETSs
HuQPk/du6sQ5GAF6cccenFAHovw3vfFviXxi76fqF3HfyxJDc6kEWZoYFCqCUchT91ck5bjgZzn1
HUPDOjvbxeBtEk0m81ebzZdR1TUoVuJYy2RIwP8Az3JbIUkYH5181obnTLhDJA8co+YK5dDggjsQ
a2NEkudB1tdWiMEl7ZLHfwFp0dGG4EhhyWJBxgEMDzxgkAHssPwy8Li6tfB1np93qdxHetNqGtKF
j+yKoDCIkggkqyDb0+YnsQOF+NWiWPhb4hQ/2KI7JJLZLkR2wKGJ9zcjHTJGRjp+Ar2H4S+MrTxA
l8bppI9b1G4kvpLcRS7EiG1Ewx+X7oXkYz6Zry741yWcnxH1Jbq3kuJ1Szit1imyQuCzgjPBOcAY
7578gHk8Jg+0r9pVvJH3hEQCcDscEc+vNdRLd2Z+HGjafHbgNJq00l26yDzXIVAu1cZC7WIHUbs+
tckcZ4BH1Oas2Oo3emTedZztDLxh1AyCGDAg9iCAcjmgAs7K81G4WzsrSW4uMO4jijLOQBluBzwF
J/Ot3w5psc/iS1sLzS5L5ljec2lqQJJCsXmBMnOclcMMEgE454pvhvXbXT9aXUNcGqXHmDPn2t15
c44KhlcjdxzxkA4APSvdtBbSPAvhe48fa7Gj6jfwRvY20rh7iOIKESNZHYliVZSzDHX7vagCK8+A
+k6/fDUIi2iWdxbQuLOFS7xyli0gO/oMEKAMY9OMHcu/gvplvPPe+GNX1HQL55VkRreQmJcD7uzI
yCecE+3TivHU8feJPG3izzLvXn8P2Fyj2rzweYYo4yC6x4BwXOCAeGOSM9APSPhyNVtotPurnxvq
TaVJcJaQxXtlhbyXBJWJpMuI+CuSAcqenFAFq5174gfDl4J/ECP4m0QRA3V1awKkluxb2OWAA6lQ
OQMiovEHiqz+Juqad4Z0IXN7okipcatNauIpFVmConzMOATucYPbHNexEAjBGQa+Yde8Pf8ACE/E
bUL2/QR6FLdxzT21gEYfZDKrLujzlV3qFzjhlwPvCgDpfEnwz0ObwHd6vZI2jjT7cLH9vsxHKfKZ
g0jbCCxl2pjcDjkgZbin4G1C98Wa1ovhpdNtoLTR54r+9h+xrbgMsIVi687n8w8cD/4nq7aDwt43
1nxRPpty2takWhmtxcO8dsfLVSkQYHDIHwWGOpHHGa7vTPDVpYsdU+xQf25Ijs88kjTbHkwzIrt8
3lhugGMDOAMmgDfpruI42chiFBOFGSfoO9cbq3ibX9MttJ0aCwsr7xZfws7IjslrEEA3yMT823JA
A6mpfCmp6m1/d2/iG2vrXVJQJGjJ8yzCoFQtC4GFDE52sd2c/UgE5v8AXfE3h15dGjn8P3TTKI5N
UtQ7mLAJYRhuDzwG9DwM5BWpda9a2F9LBfpJaQIItt5PtWGR5GKhFbOS2RyMcZFFAEWkaRqOmXsx
n1y5v7JowIobmNS6PvZmYyADIwwAGOAorJ8T3Xhvw5YXEGq6RKulau7tf3EFuTErNtUtMV5XdkfN
7V19MlijnheKWNZInUq6OMhgeCCO4oA4i91qXwjbaHbaLatrGlXcLQWkcc5knklwXRjK7Y8sjjPO
MjtgU3w74V0vU5rTXxdTusWoXd7BBHEbdBLIxUl1PLMuGXdkA+lael+FF0bxNDLZWemx6Lb2TRW0
axkT28rSbn2tzlGz0zxgYHJz0V7Zw6hY3FncKzQXEbRSBWKkqwwRkcjg9qAPEPil4Ym1vxBFe6pf
f2e8mrW+nWDywqIzAU3l8jcSwYtyxUfyGzLoHw08NDTJrG88PRXsN/D5lxc3bNlo+WICvhHwc8/K
CRkcis7xZ8JrW91TStBi1+6tNPYH+z4Lu7e4AYA+YiR4GNqAMGL9flxg8Y974HsvD5m8G6daad4m
1K6kkm8krHBd2MBVQrCUqRnlSd34LgkgA6bTtGsPFfgnxhrWqahaK+oTTLJfRkywRQRbSjKgkIyA
gYZwwJ6evPaRpXg3wB8RBfateXEOnsizaNLskkiYSINzPKFGc84U5AGcmk8GeE7DUfEM+iXsDaB9
muWN3o63E7i9iWNN2WL7Cu8qeF5XocV7hbyaNq/h9GtzZ3Wjyw7V2hWhaMcYx0wMYx2xQB5P8etT
itNG0yaysbOd76OUSX5tEnIhCjaA5U4BaRSCCOQMV5LYRw6hctZRaYhvdUSd9Nt7e1UMGl2Rpu3Z
wu1ZG6/L94HmvTNM1fw54K8VaroAVfEXh+8K3dpbWJN6bJ4z9wxknHJGGz2Hvht4NJ+F2jXfjOPQ
kste1h2j0zT35FmjDOWU8ocfeAJ5wowCcAGp4D+Hfi7wFFc/Y7nw/c3Fw0Kzwkyh2jyxbEnG04Jx
8pzjPbnzD4heCdd02/nu57DVlsJFJi+13a3UmY1OSSmflC5POMDPJxXb+H/AN94u0m+8beLTd6jq
L20jW1paskIuRsDRFXiOT1K4IyMAYIXBrab8W5dH0GPwv4x0a+1S5cCK5+3ARFULEMrArltqhSDy
WJOSMCgDxa/sbmztbVrhI4xIGMaYAk25+8eOQc8N3wcHjiiFLZwCcDJxXq+uah4K1H4jweXdakdN
ZI1SaU7jZSGZi6mOVTlACflIOOvPSqtzqHw90Xxhas9tdeIdOWxKzOyeQZLjcdh2/KNmzbjtgg84
oAq+HfBraFo9n408U6JHqHhqVgpiS78uVQSAsm3I3DORtzk9Tgc1U8deLZviHfzX7Pb2kNgDHaWR
2piDnncT8z5CjaB34GAam+I3jq61zUbzTNO1ea48ONMk1vbtbrEkW1doRMZO1enYEgnHc8xp2pSe
Y2LeD7SGjeG7H7t4HjUhNpGFHbOQdxA780AepfCjUNTh8MX8sep6Db2dtcC6e2ubAySziJU3MFTB
IQbGBAJ3dcZzXsFlql1E11a+FNC+12UFyzSXF3dtGHleRWlEe4MSAHfnIwysuOMHwH4Y+GbnUvHF
zb30t7b3FtM0Esen3SQTwuS25x8w+RSpDbQeoGK73ULbxDpuleKPB9sdRvNPt3tnjksYM3EqTSlp
AZAo3SMpbOF2jHLcEMAe13N+ttfWdqbe5kN0zKJI4iyR7VLZduig4wM9TXD/ABQslTS4vE1paRXk
1jutrpMFzJbSHZKoAyCynDDcrAFTxXE+HNb8Qf23e6Z4fu9QMVtZ3cR0a/uoWurWdQNjgvkyAtj2
Ulh0xu9Y8NRxLpl1psenT6dJA22dtsaeZLIgd5F2Ejq55wBkccCgCj4T+G/hvwmbW5sbVpb2CExJ
d3H+s2kkngAAH5sZwDjg11ruI42chiFBOFGSfoO9c/oEElrfy6emq6ldQadbRWrpew58yTG7zfOK
jeSpAIBwMV0VAHEap4TXxXPbeKdM1PVtB1eSzSKN9oUrHkttkiYdcnnnsPSuet7zxXrcn/CC+M9L
0ue4vrX7S1zb3IXyYwSAzR5y7CRUPy4Bz14Nek6hHqRlt57CeMJCJGltXQf6T8p2Lv8A4MNg5wa8
N1nxN4iuPjlp0sGkW9jqNvZCyS3vrpkimdhuYK64DcyDA5B2g9SMAHa6/H4u8EeCVeDVBrkcEsb3
dzewBpbWBQu50VSPMwQzfM2QMdcE0VH4i0HxXqUkd/qF94ftZmsLqzubMiaaOeEjdkLnJZSAcKM+
54AKAN5PiBDb+OH8LarYSWk8r4sJ4pBOlwv+0F5jPXhhjg8+unH4z0S5ljisbh752vfsMi2kZkME
nzcyAcqvyn5jx+HNYfh34Y6f4diuLuG8mTW7iCaGfUoCY9+9shzGSU3DjtjIzivMfEfhbxHN4o8P
TaXqEGvPcNJcRatpsaW10wQYbzJlym3kKCc+mOxAPeNU1uw0iWwivpWi+33AtYW2nb5hBIBYcLnG
BnqaxLGHUvBto8NxcahremiSWb7RKQ89pEqbgp53TEsCBgZGQOwrD8IG28e6Nex+Jnnk1aENZalp
sjmNYGEjMrBFPDYIAkGCdv1rv7qRrHTZpYLaW5eCIskCMN8hA4UFj1PTk0AcL/wkfg3x/daadN1i
KDXbeZmsnkgxPCQAZAEcYOUyO47jlagl8TeE9H8Z6x4ih8UQSRG1ijv7WGATbnDbItkiDO77wKZJ
PXgDjqotSu5rS/1Kbwvcx3VluFtE7RNNONik7SGIXJ+Xrzt/Cm6YdCur+5s7HRbcRhhczzxQxGIX
CtgoxUn98pAJ9OOelAFeHxT/AMJBqFvb+G3jmtWScXF+8EhSFk+UKvABfeQSpIyoyOorG8PeEfEe
pTrc+Ory0uYrdJra3061iCQlWGwyPg4bcpI2kYAPY5A6rU/+EgaSeDSI9Ohj8pGiubks/wC9L/OD
GuMjbyDu6n8axv7K1jSdMt7W68S6veX99qMTPdwWiMsQGCyhMERxEIQTzgt3ycgEMeh+HPD+rapq
Hhjw4kuvWFmsf2S3H2dHVyWADEbMnHLcnCge1Ylh4F1PXb27vfG2mW1zeaoJYmmiuATpcKgCJYQV
PzMSx3DpxnnOer0nQdS05rlf7UkghfVnu0UzG4MsDL/qiZBlMtk/LnHrzml03xDcav471XTbQxnT
NKgSO4bZ8zXTnOA2eiqOeOp68UARaNPr2narqWhyaRD/AGfbwh9HuYfkhMYUKIZDklWBxzjkZOOK
XUdfv7WxIl0B31ZBbxx5Vmt3mlyCFkVWYKvzAsVA5HrUvj28vdP8JXF3ZeaDFLE8zw3KwOkQkUuQ
zAj7oOc9ifpVTUPGSujxrouoHS5Nyy6o08VvbiEqMSpKXGQdw24wTyR0oA+ZvizpI0f4l6xCqwIk
0v2hUhfcFDjdg8DBzk49+9cvZyGwu7G/dFljSUOIxNhjtYEjjlfY+/evQPiZ4G07w3qegXRM+mwa
vGXuoJ5vtMls4K7zlfv/AHuOeTnp287uTHiSOHZ5MczeWeC7A9MtgEgBR2HU8DNAHU/ECTQtV8RQ
X3htJVgvohNMJZD5cc7fM8allUALu55I57dKj0G9vfDGr21tBqX2Ox1lYlnuxGnmJAZNrMrHdsIK
tyD2B9K6L4eXU3iSGTR5oIdRk0m2NzYWtzbRMrx8+fDk/MC5K7WAYgjtXs2h6dF47+HRe68M6Zps
qi4j0uKW0JjijYEK6qdp5B6jGeuKAPJ4rzQ/h98T7TUPDst5fWzNPBqFtd2vmzwKjDzGU8ZyoLA9
Quc8HFeqeGtMsrDRLnSfAmq+Yb+V7wanEI5lss7WijlRm3EFflHGeD0rwuceJvC2lWdhbm4MAvUv
be7QLttrsbo2QyAsoOcZG7sMjrXV+EtN8XRweJNR8OypY30VxLFqdvZrH5aGMghIUAfLHc5DDj5S
oHOaALdm2q6b441S58X6zrEPiYSQxQwaRbrI13aknPlDHyrlFY8DgEHJY4+gbfT7K2u7q8t7WKK4
uyrXEqphpSowu498DivH7aTw14S+IOm3tpqswdo5xrtze3Q+0bmSNoxOr42rkgDZj5sDqMV7QkiS
FgjqxU4bBzg4B5/Ag/jQBn30enprGm3V1eGG6BkhtYzclFlZhkjZnDnC5GQccmsq/wBS1PR9Tgut
VvoI9LaeZcQ2rFEi8sMjTSlsR7SrAnGDuH4O8RL5viTwyivqSOl1JKGt7USw4EZBErEfJkMQGHqf
qOhmgiuYJIJ4klhkUq8bqGVgeoIPUUAVtKlvJdNt21H7IL1k3SC0ctH7FSeSMYrwPQNB0v4gah4g
u77XrG3jW6vplXzCZYS7xiOcZICgbAMjr0/i49Z8V+GrcXP/AAlVhNe2esWMXMljGZWuYVOTC0XR
we3Qg4OeK5TUNV8UaXZWOgapoOialqmsTqEn8ho7a4jADMkmV4l4OARjAz1GKAG21mkPjWHwh4ov
4r3UobU3Gga2QFuYgdy7GzwzjaWGc52k9ehWXotn4m1f4ga23jPQUuopLAwCKxuIS9ijK7og2sHB
I3oGyCSe4NFAHuJzjjrXing6XWD8Xbq3lvYJjpyCya3a1htWFuULGSMKD8m9VIVTk79xwM17S6LJ
GyOoZGBDA9wa5zSfh94T0O/gv9N0O2t7uBSsUwyWUEYPJJ5wSM9ccUAZmvT3/g2+uvESWlheWl7d
xLfyBBBNb2wUIpLZxJtO4knGAcdBkU9a8f6frnw/1LWfCviS2tJrKRC0s8RyuHACshBID9Acd/Y4
7DVPDmk63eWV1qdkl1JZMWgEhJVGJBztzgn5R1HFeZ/EWwHiKDUtA8IaZHDcnyZNXv47UojQAF1Q
OozI33TtAJIIxnnAB6DZiNJIbvS7R5oNbP2i6vYbrckX7obHUP1BAUDaB6kVifDa/uTpV1Z32oWV
2sN/Na210qmOW8ZCd7ODwzf7QJyASeck4fw61XURr9t4f16S9+02WnGTTbgs0Ud7asVwzxED94gC
jnkfNnkZPod7omn3N/YalJbs1zprSy24jYr8zqQ/GQCTnv3oA4PxrrWrvqupf2bq+NG06KKHVbO3
DLdDeHZ3hcJncEIfhj9w5wM16RY3FvdWFvcWs3nW8savFLuzvUjIOe+RXlt74R1O88Na/daPaReZ
fyRz6Zpt1Eol06SVdtwWJbCuRIxxnjA47V5xP4g1b4W67cW9lNq0tnp9wLe2hld3tJ4x/rVYNjY+
WVgUGPm6YoA9B+IHhbxDq3iLS50u9H1C9W4P2SwnJhUQhmcs6mQ78KEBKKG/AV1el+FNbsLS7vxq
0UOtXly19PHFEv2dpDDsWJjt3GMMAc8N+PNeZah8X/Dd5Jo/iC50+6l1+OxmhaOxKbbbzDtz5jpu
DjAxjIG89c862j/Gy9gsore78J38otrRJJJGv0kuXj2bvNMZVSQV+YsOMc9KAOz8QyWXh3whLr3i
/wCz6hfxWDWc6xsY4rrec+WsbHGSQOcZ4JwBwPAtB8Qvb+FzYJfanqMduyXkel6dbEQo/mB2Fw7L
yuBjaFK5P1J7zw/4O1L4nX0njTx1cvDoZDSWWntIUQRY4YnI2oBzngtjJ460/hXrL+FdV1XQrSCX
Vor1FOmXMUQjjuNj7GIB5ZAzsSwJO1CcccAGo41Tx21x48mOl6XHDZvaaHa6jIhUls7pZd2RnbvI
GOcA9BlvLPFHgNtDuNTlvdTEzOjXGnXEKiSG/CsBL8ynKsuSduMfKecDJ9W8Y+DPCfhfQI7q/wBD
1UmZVubux0dnNo00YIIZiCY1JlPORwvHofL/ABV44ute8Nx6ZDY6Npem2TRva2NrF5j7XVst5nIB
BPP3TlhnkGgD0D9n3QzLq1/4iVVSBLKOzARCqtJ8pYjnqAi54OS55Hf0q+Gn6P4snuNUuZ5YdXjN
obia6CR2uFBWAKuCNw8x9/UevNc/8CI7qx+Gy/arPyYWke5ikWYSNMpJBOwDK424AJJOD0rJ8PWv
iHxIdb1KKPRGg16Zbm40i+Li5NoT5SBmX7gKBmDYPt14AKvjPX/DNn4Ih8KeAk0+RtadIjCkTZdW
zGHDMu3fujHLHOASOcNVzS/Cni34WWFp/YNjoerC4kWC6k+zTJcNuckFmBKhFBxuOAOMg4zW98VL
AWGmeGdVt7M/2doWrW91cpbpzFboeSFHUDj6fmR19zq+harotr5ky3enaz/o0RjRnWXep4JUfLwG
yTjGOcUAeVaddQ/EP4p2Os2Phe2soNKLJqdzqKK3mykKqxgLwZFxwSeO+MAH1HSY0tPFWu26xxKZ
zDdZismjzldh3y/dkbKHpjA9eceX6RdaH4O8U+IrTxDYXdhpSyxahpGmSwiaNWV2TzIgpba5ccDI
4Pp0raxe+O9duZ/F1xe3nhnwtHCUj2JuuRA5QFvLU9cgHcSMDJHQUAd/f+Kf7D+KQ0/UtVt4dJu9
LEiLPKiCGdZCO/PzK3c87fbjqNWmvH0WWTR0W5uJAFiKTKnDEAuGIYZAJYZBziuQ8T/C/RNf8OXS
6dBaLq85S5i1KZQ7SygD5pCBhlYZyMFfmJ2muX8L+GvFPhXVUsNMW4065uS080EiG60p8SclHGGh
YqCApB42gnNAHZ+JvD2uLoWjPoU/2/WNIcPHLfXTxmceWVbdswGLHH3sDrk8nPQajZia3g1N9Ohu
NVsInltYzLtCyshBUOR0PTJHvXnt5498etJe6VpfhjTdQ1S3iil+02d55luFbIJw20n5kkUDdkEe
3N/w8PGnjGyOpX2sf2KEuP8AR00+INHKgddyusq7sqUdc5AOcgYHzAGr4C1a11uTV9QMto9/POHZ
YZIZGSDGIgXjGWXh8bvmoqxrNpqtxpd7pzaDaXcV1K8MQtrowBIVQtGZW4YHeNpCZwG785KAOroo
ooA5nx9qC6V4UkvnW4cQ3NudlvcGBm/eoMFgD8pzyMcjIrdsNPs9KsYrGwtora1hGI4ol2qozngf
U0UUAeZfEzxDdz+Io/CNo8tjIdOk1JNQglKyJJFudVwOqnyiCCe4P8PPQeE/E+p+KfBvhzWFaC1m
up9l2rRmQSKu8Nt5XaSVznnHTBoooA62006zsGuWtLWKBrmYzzmNQPMkIALH1JwOa8B8deLzrHir
WfBNrp8Vp/aN+sF3eySNOXWNF2lY2+VDkdR6DvzRRQB59o2s3A0jS/DoitlVb5LyK7WFfNV32KAc
5DqN5OGBzgDjAr06+1Kz1H4Do0Gk21vcW80ejxTsqu6A7VeQHAwWVmBHueTRRQB6xqS2/hH4d3SQ
263VtpWmMqwy9JVjjxtb6gc/WqXhjwroDaNoGpWthJb+SDf2sQuXZbdp0BdF5xt56Yxx05NFFAHC
ah4juNR+OD2s0Sm0tc6QsJYkESxPI8mD8pJ2BcFSCAPSsX4h/DDw54J+HlzLZwzXN/LNbx/ariQ/
ISzZZVXAGRkYOePzoooA5X4DtN/wsi2EczpEUcOgZsOuxyAcEA8jPIPNe86bdPa/FzWdMeSa4+1a
ZDeq8jLiFVdkEagKDjJLZJ7/AI0UUActqPjNPDvgzXfFaWVxeLf6nJZNp15eGWBGVnQuuVyFYKMp
07DFeUeA/D2oazbTajYeILzR45tRt7R4bPK/LJJgYYMPu7iQMUUUAepweCrTwR4+8NQwXl7e3OrX
s7S31zM3niKKHcsRIIDKW5ORzhfSu28d6xcaPb6G0DZju9Yt7OeMhSJIpNysp3A8fTB96KKAI08R
6hbfE+48PXDRT2U9nHdW5CbGg5KspPO8ErnPGM4rsKKKAOYv/h94ZvrW6gTTUsWudpeawP2eTKkl
TlcdCxPOQeM5wKr6Dd6yvjTVdKudRjuNNs41ECNAfNGUiI3Sbju6nORkkk56CiigDr6KKKAP/9k=