20240319
15132100
1.0
FALSE
CalculateField "NG911 Road Centerlines" St_PreMod "Null" VB #
CalculateField "NG911 Road Centerlines" St_PreDir "Null" VB #
CalculateField "NG911 Road Centerlines" St_PosDir "East" VB #
CalculateField "NG911 Road Centerlines" St_PosMod "Rest Area- Closed" VB #
CalculateField "NG911 Road Centerlines" St_PosTyp "<Null>" VB #
CalculateField "NG911 Road Centerlines" FullStNm "Interstate 90 East Rest Area-Closed" VB #
CalculateField "NG911 Road Centerlines" abFullStNm "I 90 E Rest Area-Closed" VB #
CalculateField "NG911 Road Centerlines" St_PreType "Interstate" VB #
CalculateField "NG911 Road Centerlines" St_PosMod "<Null>" VB #
CalculateField "NG911 Road Centerlines" St_PosDir "West" VB #
CalculateField "NG911 Road Centerlines" FullStNm "Interstate 90 West" VB #
CalculateField "NG911 Road Centerlines" abFullStNm "I 90" VB #
CalculateField "NG911 Road Centerlines" St_PosMod "Ramp" VB #
CalculateField "NG911 Road Centerlines" abFullStNm "I90 W Ramp" VB #
CalculateField "NG911 Road Centerlines" abFullStNm "I90 W" VB #
CalculateField "NG911 Road Centerlines" St_PosTyp "<Null>" VB #
CalculateField "NG911 Road Centerlines" St_PosDir "East" VB #
CalculateField "NG911 Road Centerlines" FullStNm "Interstate 90 East Ramp" VB #
CalculateField "NG911 Road Centerlines" abFullStNm "I 90 E Ramp" VB #
CalculateField "NG911 Road Centerlines" abFullStNm "I 90 E" VB #
CalculateField "NG911 Road Centerlines" FullStNm "Interstate 90 East" VB #
CalculateField "NG911 Road Centerlines" RdClass "County Highway" VB #
CalculateField "NG911 Road Centerlines" RdClass "Local Road" VB #
CalculateField "NG911 Road Centerlines" FullStNm "[St_Name]&" "& [St_PosTyp]" VB #
CalculateField "NG911 Road Centerlines" abFullStNm [FullStNm] VB #
CalculateField "NG911 Road Centerlines" FullStNm "[St_Name]&" "& [St_PosTyp]&" "& [St_PosDir]" VB #
CalculateField "NG911 Road Centerlines" FullStNm "[St_Name]&" "& [St_PosTyp]&" "& [St_PosDir]" VB #
CalculateField "NG911 Road Centerlines" FullStNm "[St_PreType]&" "& [St_Name]" VB #
CalculateField "NG911 Road Centerlines" abFullStNm ""Co HWY"&" "& [St_Name]" VB #
CalculateField "NG911 Road Centerlines" abFullStNm ""Co Hwy"&" "& [St_Name]" VB #
CalculateField "NG911 Road Centerlines" FullStNm "[St_PreType]&" "& [St_Name]" VB #
CalculateField "NG911 Road Centerlines" abFullStNm ""US" &" "& [St_Name]" VB #
CalculateField "NG911 Road Centerlines" FullStNm "[St_Name]&" "& [St_PosTyp]&" "& [St_PosDir]" VB #
CalculateField "NG911 Road Centerlines" abFullStNm "[St_Name]&" "& [St_PosTyp]&" "& [St_PosDir]" VB #
CalculateField "NG911 Road Centerlines" FullStNm "[St_PreType]&" "& [St_Name]" VB #
CalculateField "NG911 Road Centerlines" abFullStNm ""US"&" "& [St_Name]" VB #
CalculateField "NG911 Road Centerlines" abFullStNm ""US"&" "& [St_Name]" VB #
CalculateField "NG911 Road Centerlines" FullStNm "[St_PreType]&" "& [St_Name]" VB #
CalculateField "NG911 Road Centerlines" St_PosMod "Ramp" VB #
CalculateField "NG911 Road Centerlines" FullStNm "United States Highway 53 South" VB #
CalculateField "NG911 Road Centerlines" abFullStNm "US 53 S" VB #
CalculateField "NG911 Road Centerlines" St_PosDir "South" VB #
CalculateField "NG911 Road Centerlines" St_PosDir "North" VB #
CalculateField "NG911 Road Centerlines" FullStNm "[St_PreType]&" "& [St_Name]&" "& [St_PosDir]" VB #
CalculateField "NG911 Road Centerlines" abFullStNm "[St_PreType]&" "& [St_Name]&" "& [St_PosDir]" VB #
CalculateField "NG911 Road Centerlines" St_PosMod "Ramp" VB #
CalculateField "NG911 Road Centerlines" St_PosDir "South" VB #
CalculateField "NG911 Road Centerlines" FullStNm "[St_PreType]&" "& [St_Name]&" "& [St_PosDir]&" "& [St_PosMod]" VB #
CalculateField "NG911 Road Centerlines" abFullStNm ""US"&" "& [St_Name]&" "&"S"&" "& [St_PosMod]" VB #
CalculateField "NG911 Road Centerlines" St_PosDir "North" VB #
CalculateField "NG911 Road Centerlines" abFullStNm ""US"&" "& [St_Name]&" "&"N"&" "& [St_PosMod]" VB #
CalculateField "NG911 Road Centerlines" FullStNm "[St_PreType]&" "& [St_Name]&" "& [St_PosDir]&" "& [St_PosMod]" VB #
CalculateField "NG911 Road Centerlines" FullStNm "[St_Name]&" "& [St_PosTyp]&" "& [St_PosDir]" VB #
CalculateField "NG911 Road Centerlines" abFullStNm "[St_Name]&" "& [St_PosTyp]&" "& [St_PosDir]" VB #
CalculateField "NG911 Road Centerlines" FullStNm "[St_Name]&" "& [St_PosTyp]&" "& [St_PosDir]" VB #
CalculateField "NG911 Road Centerlines" abFullStNm "[St_Name]&" "& [St_PosTyp]&" "& [St_PosDir]" VB #
CalculateField "NG911 Road Centerlines" FullStNm "[St_Name]&" "& [St_PosTyp]" VB #
CalculateField "NG911 Road Centerlines" abFullStNm "[St_Name]&" "& [St_PosTyp]" VB #
CalculateField "NG911 Road Centerlines" FullStNm "[St_Name]&" "& [St_PosTyp]" VB #
CalculateField "NG911 Road Centerlines" FullStNm "[St_Name]&" "& [St_PosTyp]" VB #
CalculateField "NG911 Road Centerlines" abFullStNm [FullStNm] VB #
CalculateField "NG911 Road Centerlines" FullStNm "Unnamed Street" VB #
CalculateField "NG911 Road Centerlines" abFullStNm "Unnamed St" VB #
CalculateField "NG911 Road Centerlines" FullStNm "[St_PreType]&" "& [St_Name]" VB #
CalculateField "NG911 Road Centerlines" FullStNm "[St_Name]&" "& [St_PosTyp]&" "& [St_PosDir]" VB #
CalculateField "NG911 Road Centerlines" abFullStNm "[St_Name]&" "& [St_PosTyp]&" "& [St_PosDir]" VB #
CalculateField "NG911 Road Centerlines" abFullStNm "[St_Name]&" "& [St_PosTyp]" VB #
CalculateField "NG911 Road Centerlines" FullStNm "[St_Name]&" "& [St_PosTyp]" VB #
CalculateField "NG911 Road Centerlines" abFullStNm [FullStNm] VB #
CalculateField "NG911 Road Centerlines" CityCode_L "1" VB #
CalculateField "NG911 Road Centerlines" CityCode_R "1" VB #
CalculateField "NG911 Road Centerlines" CityCode_L "111" VB #
CalculateField "NG911 Road Centerlines" CityCode_R "111" VB #
CalculateField "NG911 Road Centerlines" CityCode_R "614" VB #
CalculateField "NG911 Road Centerlines" CityCode_L "623" VB #
CalculateField "NG911 Road Centerlines" CityCode_L "619" VB #
CalculateField "NG911 Road Centerlines" CityCode_R "619" VB #
CalculateField "NG911 Road Centerlines" CityCode_L "614" VB #
CalculateField "NG911 Road Centerlines" CityCode_R "614" VB #
CalculateField "NG911 Road Centerlines" CityCode_L "623" VB #
CalculateField "NG911 Road Centerlines" CityCode_R "623" VB #
CalculateField "NG911 Road Centerlines" PostComm_L "636" VB #
CalculateField "NG911 Road Centerlines" CityCode_R "636" VB #
CalculateField "NG911 Road Centerlines" CityCode_L "636" VB #
CalculateField "NG911 Road Centerlines" PostComm_L "Holmen" VB #
CalculateField "NG911 Road Centerlines" CityCode_L "601" VB #
CalculateField "NG911 Road Centerlines" CityCode_R "601" VB #
CalculateField "NG911 Road Centerlines" CityCode_L "642" VB #
CalculateField "NG911 Road Centerlines" CityCode_R "642" VB #
CalculateField "NG911 Road Centerlines" CityCode_L "644" VB #
CalculateField "NG911 Road Centerlines" CityCode_R "644" VB #
CalculateField "NG911 Road Centerlines" CityCode_L "650" VB #
CalculateField "NG911 Road Centerlines" CityCode_R "650" VB #
CalculateField "NG911 Road Centerlines" CityCode_L "653" VB #
CalculateField "NG911 Road Centerlines" CityCode_R "653" VB #
CalculateField "NG911 Road Centerlines" CityCode_L "656" VB #
CalculateField "NG911 Road Centerlines" CityCode_R "656" VB #
CalculateField "NG911 Road Centerlines" CityCode_L "658" VB #
CalculateField "NG911 Road Centerlines" CityCode_R "658" VB #
CalculateField "NG911 Road Centerlines" CityCode_L "661" VB #
CalculateField "NG911 Road Centerlines" CityCode_R "661" VB #
CalculateField "NG911 Road Centerlines" CityCode_L "669" VB #
CalculateField "NG911 Road Centerlines" CityCode_R "669" VB #
CalculateField "NG911 Road Centerlines" CityCode_L "667" VB #
CalculateField "NG911 Road Centerlines" CityCode_R "667" VB #
CalculateField "NG911 Road Centerlines" CountyCode_L "32" VB #
CalculateField "NG911 Road Centerlines" CountyCode_R "32" VB #
CalculateField "NG911 Road Centerlines" CountyCode_L "41" VB #
CalculateField "NG911 Road Centerlines" CountyCode_R "41" VB #
CalculateField "NG911 Road Centerlines" CountyCode_L "61" VB #
CalculateField "NG911 Road Centerlines" CountyCode_R "61" VB #
CalculateField "NG911 Road Centerlines" CountyCode_L "62" VB #
CalculateField "NG911 Road Centerlines" CountyCode_R "62" VB #
CalculateField "NG911 Road Centerlines" IncMuni_R "Bangor, Village" VB #
CalculateField "NG911 Road Centerlines" IncMuni_L "Bangor, Village" VB #
CalculateField "NG911 Road Centerlines" IncMuni_R "Bangor, Town" VB #
CalculateField "NG911 Road Centerlines" IncMuni_L "Bangor, Town" VB #
CalculateField "NG911 Road Centerlines" IncMuni_L "Barre, Town" VB #
CalculateField "NG911 Road Centerlines" IncMuni_R "Barre, Town" VB #
CalculateField "NG911 Road Centerlines" IncMuni_L "Onalaska, Town" VB #
CalculateField "NG911 Road Centerlines" IncMuni_R "Onalaska, Town" VB #
CalculateField "NG911 Road Centerlines" IncMuni_L "Onalaska, City" VB #
CalculateField "NG911 Road Centerlines" IncMuni_R "Onalaska, City" VB #
CalculateField "NG911 Road Centerlines" IncMuni_L "Bangor, Town" VB #
CalculateField "NG911 Road Centerlines" IncMuni_R "Bangor, Town" VB #
CalculateField "NG911 Road Centerlines" IncMuni_L "La Crosse, City" VB #
CalculateField "NG911 Road Centerlines" IncMuni_R "La Crosse, City" VB #
CalculateField "NG911 Road Centerlines" IncMuni_L "Onalaska, City" VB #
CalculateField "NG911 Road Centerlines" IncMuni_R "Onalaska, City" VB #
CalculateField "NG911 Road Centerlines" IncMuni_L "Burns, Town" VB #
CalculateField "NG911 Road Centerlines" IncMuni_R "Burns, Town" VB #
CalculateField "NG911 Road Centerlines" IncMuni_L "Campbell, Town" VB #
CalculateField "NG911 Road Centerlines" IncMuni_R "Campbell, Town" VB #
CalculateField "NG911 Road Centerlines" IncMuni_L "Farmington, Town" VB #
CalculateField "NG911 Road Centerlines" IncMuni_R "Farmington, Town" VB #
CalculateField "NG911 Road Centerlines" IncMuni_L "Greenfield, Town" VB #
CalculateField "NG911 Road Centerlines" IncMuni_R "Greenfield, Town" VB #
CalculateField "NG911 Road Centerlines" CityCode_L "32002" VB #
CalculateField "NG911 Road Centerlines" CityCode_R "32002" VB #
CalculateField "NG911 Road Centerlines" CityCode_L "32106" VB #
CalculateField "NG911 Road Centerlines" CityCode_R "32106" VB #
CalculateField "NG911 Road Centerlines" CityCode_L "32004" VB #
CalculateField "NG911 Road Centerlines" CityCode_R "32004" VB #
CalculateField "NG911 Road Centerlines" CityCode_R "62002" VB #
CalculateField "NG911 Road Centerlines" CityCode_L "62002" VB #
CalculateField "NG911 Road Centerlines" CityCode_L "32006" VB #
CalculateField "NG911 Road Centerlines" CityCode_R "32006" VB #
CalculateField "NG911 Road Centerlines" CityCode_L "32008" VB #
CalculateField "NG911 Road Centerlines" CityCode_R "32008" VB #
CalculateField "NG911 Road Centerlines" CityCode_L "32010" VB #
CalculateField "NG911 Road Centerlines" CityCode_R "32010" VB #
CalculateField "NG911 Road Centerlines" CityCode_L "32012" VB #
CalculateField "NG911 Road Centerlines" CityCode_R "32012" VB #
CalculateField "NG911 Road Centerlines" CityCode_L "32014" VB #
CalculateField "NG911 Road Centerlines" CityCode_R "32014" VB #
CalculateField "NG911 Road Centerlines" CityCode_L "32016" VB #
CalculateField "NG911 Road Centerlines" CityCode_R "32016" VB #
CalculateField "NG911 Road Centerlines" CityCode_L "32136" VB #
CalculateField "NG911 Road Centerlines" CityCode_R "32136" VB #
CalculateField "NG911 Road Centerlines" CityCode_L "32246" VB #
CalculateField "NG911 Road Centerlines" CityCode_R "32246" VB #
CalculateField "NG911 Road Centerlines" CityCode_L "32018" VB #
CalculateField "NG911 Road Centerlines" CityCode_R "32018" VB #
CalculateField "NG911 Road Centerlines" CityCode_L "32265" VB #
CalculateField "NG911 Road Centerlines" CityCode_R "32265" VB #
CalculateField "NG911 Road Centerlines" CityCode_L "32020" VB #
CalculateField "NG911 Road Centerlines" CityCode_R "32020" VB #
CalculateField "NG911 Road Centerlines" CityCode_L "32176" VB #
CalculateField "NG911 Road Centerlines" CityCode_R "32176" VB #
CalculateField "NG911 Road Centerlines" CityCode_L "32022" VB #
CalculateField "NG911 Road Centerlines" CityCode_R "32022" VB #
CalculateField "NG911 Road Centerlines" CityCode_L "32024" VB #
CalculateField "NG911 Road Centerlines" CityCode_R "32024" VB #
CalculateField "NG911 Road Centerlines" CityCode_L "32191" VB #
CalculateField "NG911 Road Centerlines" CityCode_R "32191" VB #
CalculateField "NG911 Road Centerlines" checks [External_NGuid] VB #
CalculateField "NG911 Road Centerlines" checks "59" VB #
CalculateField "NG911 Road Centerlines" checks "58" VB #
CalculateField "NG911 Road Centerlines" RCL_NGUID "[External_NGuid]+ "@lacrossecounty.org"" VB #
CalculateField "NG911 Road Centerlines" RCL_NGUID ""RCL" +[External_NGuid]+ "@lacrossecounty.org"" VB #
CalculateField "NG911 Road Centerlines" RCL_NGUID ""RCL" + [External_NGuid]+"@lacrossecounty.org"" VB #
CalculateField "NG911 Road Centerlines" RCL_NGUID ""RCL" + [External_NGuid]+"@lacrossecounty.org"" VB #
FeatureClassToFeatureClass O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL M:\ESRISHAR\Geodatabases\NG911\NG911Geodatabase.gdb Road_Centerlines_FinalCS # "External_NGuid "External NG Uniquie ID" true true false 36 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,External_NGuid,-1,-1;RCL_NGUID "Road Centerline NENA Globally Unique ID" true true false 254 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,RCL_NGUID,-1,-1;AdNumPre_L "Left Address Number Prefix" true true false 15 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,AdNumPre_L,-1,-1;FromAddr_L "Left FROM Address" true true false 4 Long 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,FromAddr_L,-1,-1;ToAddr_L "Left TO Address" true true false 4 Long 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,ToAddr_L,-1,-1;AdNumPre_R "Right Address Number Prefix" true true false 15 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,AdNumPre_R,-1,-1;FromAddr_R "Right FROM Address" true true false 4 Long 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,FromAddr_R,-1,-1;ToAddr_R "Right TO Address" true true false 4 Long 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,ToAddr_R,-1,-1;St_PreMod "Street Name Pre Modifier" true true false 15 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,St_PreMod,-1,-1;St_PreDir "Street Name Pre Directional" true true false 9 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,St_PreDir,-1,-1;St_PreType "Street Name Pre Type" true true false 50 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,St_PreType,-1,-1;St_PreSep "Stree Name Pre Type Separator" true true false 20 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,St_PreSep,-1,-1;St_Name "Street Name" true true false 60 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,St_Name,-1,-1;St_PosTyp "Street Name Post Type" true true false 50 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,St_PosTyp,-1,-1;St_PosDir "Street Name Post Directional" true true false 9 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,St_PosDir,-1,-1;St_PosMod "Street Name Post Modifier" true true false 25 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,St_PosMod,-1,-1;FullStNm "Full Street Name" true true false 245 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,FullStNm,-1,-1;abFullStNm "Abbreviated Full Street Name" true true false 150 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,abFullStNm,-1,-1;LSt_PreDir "Legacy Street Name Pre Directional" true true false 2 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,LSt_PreDir,-1,-1;LSt_Name "Legacy Street Name" true true false 75 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,LSt_Name,-1,-1;LSt_Type "Legacy Street Name Type" true true false 4 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,LSt_Type,-1,-1;LSt_PosDir "Legacy Street Name Post Directional" true true false 2 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,LSt_PosDir,-1,-1;PostCode_L "Postal Code Left" true true false 7 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,PostCode_L,-1,-1;PostCode_R "Postal Code Right" true true false 7 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,PostCode_R,-1,-1;PostComm_L "Postal Community Name Left" true true false 40 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,PostComm_L,-1,-1;PostComm_R "Postal Community Name Right" true true false 40 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,PostComm_R,-1,-1;CityCode_L "City Code Left" true true false 10 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,CityCode_L,-1,-1;CityCode_R "City Code Right" true true false 10 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,CityCode_R,-1,-1;Country_L "Country Left" true true false 2 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,Country_L,-1,-1;Country_R "Country Right" true true false 2 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,Country_R,-1,-1;State_L "State Left" true true false 2 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,State_L,-1,-1;State_R "State Right" true true false 2 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,State_R,-1,-1;County_L "County Left" true true false 40 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,County_L,-1,-1;County_R "County Right" true true false 40 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,County_R,-1,-1;CountyCode_L "County Code Left" true true false 5 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,CountyCode_L,-1,-1;CountyCode_R "County Code Right" true true false 5 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,CountyCode_R,-1,-1;IncMuni_L "Incorporated Municipality Left" true true false 100 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,IncMuni_L,-1,-1;IncMuni_R "Incorporated Municipality Right" true true false 100 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,IncMuni_R,-1,-1;UnincCom_L "Unincorporated Community Left" true true false 100 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,UnincCom_L,-1,-1;UnincCom_R "Unincorporated Community Right" true true false 100 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,UnincCom_R,-1,-1;NbrhdCom_L "Neighborhood Community Left" true true false 100 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,NbrhdCom_L,-1,-1;NbrhdCom_R "Neighborhood Community Right" true true false 100 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,NbrhdCom_R,-1,-1;AddCode_L "Additional Code Left" true true false 6 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,AddCode_L,-1,-1;AddCode_R "Additional Code Right" true true false 6 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,AddCode_R,-1,-1;OneWay "One-Way" true true false 2 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,OneWay,-1,-1;SpeedLimit "Speed Limit" true true false 2 Short 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,SpeedLimit,-1,-1;RdCode "Road Code" true true false 3 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,RdCode,-1,-1;RdClass "Road Class" true true false 30 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,RdClass,-1,-1;DateUpdate "Date Updated" false true false 8 Date 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,DateUpdate,-1,-1;Effective "Effective Date" true true false 8 Date 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,Effective,-1,-1;Expire "Expiration Date" true true false 8 Date 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,Expire,-1,-1;DiscrpAgID "Discrepancy Agency ID" true true false 75 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,DiscrpAgID,-1,-1;Parity_L "Parity Left" true true false 1 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,Parity_L,-1,-1;Parity_R "Parity Right" true true false 1 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,Parity_R,-1,-1;ESN_L "ESN Left" true true false 5 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,ESN_L,-1,-1;ESN_R "ESN Right" true true false 5 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,ESN_R,-1,-1;MSAGComm_L "MSAG Community Name Left" true true false 30 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,MSAGComm_L,-1,-1;MSAGComm_R "MSAG Community Name Right" true true false 30 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,MSAGComm_R,-1,-1;Valid_L "Validation Left" true true false 1 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,Valid_L,-1,-1;Valid_R "Validation Right" true true false 1 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,Valid_R,-1,-1;PsapID_L "PSAP ID Left" true true false 100 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,PsapID_L,-1,-1;PsapID_R "PSAP ID Right" true true false 100 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,PsapID_R,-1,-1;FrElev "From Elevation" true true false 2 Short 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,FrElev,-1,-1;ToElev "To Elevation" true true false 2 Short 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,ToElev,-1,-1;AltNmUS "Alternative Name US" true true false 255 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,AltNmUS,-1,-1;AltNmSt "Alternative Name State" true true false 255 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,AltNmSt,-1,-1;AltNmCo "Alternative Name County" true true false 255 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,AltNmCo,-1,-1;AltFlNm "Alternative Full Name" true true false 255 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,AltFlNm,-1,-1;Lst_Edit_User "Last Editor User" false true false 255 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,Lst_Edit_User,-1,-1;Lst_Edit_Date "Last Edit Date" true true false 8 Date 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,Lst_Edit_Date,-1,-1;Creat_Nm "Creator Name" false true false 255 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,Creat_Nm,-1,-1;Creat_Date "Created Date" false true false 8 Date 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,Creat_Date,-1,-1;Data_Source "Data Source" true true false 50 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,Data_Source,-1,-1;Status "Status" true true false 1 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,Status,-1,-1;Notes "Notes" true true false 255 Text 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,Notes,-1,-1;SHAPE_Length "SHAPE_Length" false true true 8 Double 0 0 ,First,#,O:\ESRISHAR\SharProjects\NG9-1-1\Dispatch_CAD_Upgrade\Final_911_CAD_Data.gdb\NG911_RCL,SHAPE_Length,-1,-1" #
CalculateField Road_Centerlines_FinalCS St_PreMod !St_PreDir! "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Road_Centerlines_FinalCS AltNmUS "53" Arcade # Text NO_ENFORCE_DOMAINS
CalculateField Road_Centerlines_FinalCS AltNmCo $feature.St_Name Arcade # Text NO_ENFORCE_DOMAINS
CalculateField Road_Centerlines_FinalCS AltFlNm $feature.St_Name Arcade # Text NO_ENFORCE_DOMAINS
CalculateField Road_Centerlines_FinalCS AltFlNm $feature.St_Name Arcade # Text NO_ENFORCE_DOMAINS
CalculateField Road_Centerlines_FinalCS AltFlNm $feature.abFullStNm Arcade # Text NO_ENFORCE_DOMAINS
CalculateField Road_Centerlines_FinalCS AltFlNm $feature.abFullStNm Arcade # Text NO_ENFORCE_DOMAINS
CalculateField Road_Centerlines_FinalCS AltNmSt $feature.St_Name Arcade # Text NO_ENFORCE_DOMAINS
CalculateField Road_Centerlines_FinalCS AltFlNm $feature.abFullStNm Arcade # Text NO_ENFORCE_DOMAINS
CalculateField Road_Centerlines_FinalCS AltNmCo "B" Arcade # Text NO_ENFORCE_DOMAINS
CalculateField Road_Centerlines_FinalCS FullStNm "!FullStNm! + " " + !St_PosDir!
" PYTHON_9.3 #
CalculateField Road_Centerlines_FinalCS AltFlNm "" "Python 3" # Text NO_ENFORCE_DOMAINS
AddGlobalIDs Road_Centerlines_FinalCS
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=M:\ESRISHAR\Geodatabases\NG911\NG911Geodatabase.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Road_Centerlines_FinalCS</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>UniqueID_RCL</rule_name><rule_type>CALCULATION</rule_type><expression>NextSequenceValue ('UniqueID_RCL')</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><rule_description>New sequential ID when adding a new road centerline segment</rule_description><field_name>External_NGuid</field_name><exclude_from_client_eval>True</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>UniqueID_RCL</rule_name><evaluation_order>1</evaluation_order></ReorderAttributeRule></workflow></operationSequence>"
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=M:\ESRISHAR\Geodatabases\NG911\NG911Geodatabase.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Road_Centerlines_FinalCS</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DisableEditorTracking><creator>TRUE</creator><creation_date>TRUE</creation_date><last_editor>TRUE</last_editor><last_edit_date>TRUE</last_edit_date></DisableEditorTracking></workflow></operationSequence>
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=M:\ESRISHAR\Geodatabases\NG911\NG911Geodatabase.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Road_Centerlines_FinalCS</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><EnableEditorTracking><creator_field>created_user</creator_field><creation_date_field>created_date</creation_date_field><last_editor_field>last_edited_user</last_editor_field><last_edit_date_field>last_edited_date</last_edit_date_field><add_fields>TRUE</add_fields><record_dates_in>UTC</record_dates_in></EnableEditorTracking></workflow></operationSequence>
CalculateField Road_Centerlines_FinalCS AltNmCo $feature.Lst_Edit_Date Arcade # 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=M:\ESRISHAR\Geodatabases\NG911\NG911Geodatabase.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Road_Centerlines_FinalCS</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DisableEditorTracking><creator>TRUE</creator><creation_date>TRUE</creation_date><last_editor>TRUE</last_editor><last_edit_date>TRUE</last_edit_date></DisableEditorTracking></workflow></operationSequence>
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=M:\ESRISHAR\Geodatabases\NG911\NG911Geodatabase.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Road_Centerlines_FinalCS</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><EnableEditorTracking><creator_field>Creat_Nm</creator_field><creation_date_field>Creat_Date</creation_date_field><last_editor_field>Lst_Edit_User</last_editor_field><last_edit_date_field>DateUpdate</last_edit_date_field><add_fields>TRUE</add_fields><record_dates_in>DATABASE_TIME</record_dates_in></EnableEditorTracking></workflow></operationSequence>
CalculateField Road_Centerlines_FinalCS AltNmCo "" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Road_Centerlines_FinalCS AltNmCo "" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Road_Centerlines_FinalCS AltNmCo "ZN" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Road_Centerlines_FinalCS AltNmCo "ZM" "Python 3" # 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=M:\ESRISHAR\Geodatabases\NG911\NG911Geodatabase.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Road_Centerlines_FinalCS</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>LocationName</field_name><field_type>TEXT</field_type><field_length>400</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
DeleteField Road_Centerlines_FinalCS LocationName "Delete Fields"
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=M:\ESRISHAR\Geodatabases\NG911\NG911Geodatabase.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Road_Centerlines_FinalCS</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>HouseNumberPostfix</field_name><field_type>TEXT</field_type><field_length>10</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField Road_Centerlines_FinalCS HouseNumberPostfix !AdNumPre_L! "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Road_Centerlines_FinalCS HouseNumberPostfix !AdNumPre_L! "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Road_Centerlines_FinalCS HouseNumberPostfix !AdNumPre_R! "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Road_Centerlines_FinalCS HouseNumberPostfix !AdNumPre_R! "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Road_Centerlines_FinalCS HouseNumberPostfix '' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Road_Centerlines_FinalCS St_PreType "County Road" Arcade # Text NO_ENFORCE_DOMAINS
CalculateField Road_Centerlines_FinalCS St_PreType "County Highway" Arcade # Text NO_ENFORCE_DOMAINS
CalculateField Road_Centerlines_FinalCS FullStNm "$feature.St_PreType + + + $feature.St_Name" Arcade # Text NO_ENFORCE_DOMAINS
CalculateField Road_Centerlines_FinalCS FullStNm "$feature.St_PreType + ' ' + $feature.St_Name" Arcade # Text NO_ENFORCE_DOMAINS
CalculateField Road_Centerlines_FinalCS FullStNm "$feature.St_PreType + ' ' + $feature.St_Name" Arcade # Text NO_ENFORCE_DOMAINS
CalculateField Road_Centerlines_FinalCS FullStNm "$feature.St_PreType + ' ' + $feature.St_Name" Arcade # Text NO_ENFORCE_DOMAINS
CalculateField Road_Centerlines_FinalCS RCL_NGUID "RCL"+$feature.External_NGuid+"@lacrossecounty.org" Arcade # Text NO_ENFORCE_DOMAINS
ExportFeatures Road_Centerlines_FinalCS O:\ESRISHAR\SharProjects\NG9-1-1\NG911_Grant_1\DataDelivery\Delivery2CloudpointJan11_2024.gdb\LaCrosseCounty_RCL_01_11_24 # NOT_USE_ALIAS "External_NGuid "External NG Uniquie ID" true true false 36 Text 0 0,First,#,Road_Centerlines_FinalCS,External_NGuid,0,35;RCL_NGUID "Road Centerline NENA Globally Unique ID" true true false 254 Text 0 0,First,#,Road_Centerlines_FinalCS,RCL_NGUID,0,253;AdNumPre_L "Left Address Number Prefix" true true false 15 Text 0 0,First,#,Road_Centerlines_FinalCS,AdNumPre_L,0,14;FromAddr_L "Left FROM Address" true true false 4 Long 0 0,First,#,Road_Centerlines_FinalCS,FromAddr_L,-1,-1;ToAddr_L "Left TO Address" true true false 4 Long 0 0,First,#,Road_Centerlines_FinalCS,ToAddr_L,-1,-1;AdNumPre_R "Right Address Number Prefix" true true false 15 Text 0 0,First,#,Road_Centerlines_FinalCS,AdNumPre_R,0,14;FromAddr_R "Right FROM Address" true true false 4 Long 0 0,First,#,Road_Centerlines_FinalCS,FromAddr_R,-1,-1;ToAddr_R "Right TO Address" true true false 4 Long 0 0,First,#,Road_Centerlines_FinalCS,ToAddr_R,-1,-1;St_PreMod "Street Name Pre Modifier" true true false 15 Text 0 0,First,#,Road_Centerlines_FinalCS,St_PreMod,0,14;St_PreDir "Street Name Pre Directional" true true false 9 Text 0 0,First,#,Road_Centerlines_FinalCS,St_PreDir,0,8;St_PreType "Street Name Pre Type" true true false 50 Text 0 0,First,#,Road_Centerlines_FinalCS,St_PreType,0,49;St_PreSep "Stree Name Pre Type Separator" true true false 20 Text 0 0,First,#,Road_Centerlines_FinalCS,St_PreSep,0,19;St_Name "Street Name" true true false 60 Text 0 0,First,#,Road_Centerlines_FinalCS,St_Name,0,59;St_PosTyp "Street Name Post Type" true true false 50 Text 0 0,First,#,Road_Centerlines_FinalCS,St_PosTyp,0,49;St_PosDir "Street Name Post Directional" true true false 9 Text 0 0,First,#,Road_Centerlines_FinalCS,St_PosDir,0,8;St_PosMod "Street Name Post Modifier" true true false 25 Text 0 0,First,#,Road_Centerlines_FinalCS,St_PosMod,0,24;FullStNm "Full Street Name" true true false 245 Text 0 0,First,#,Road_Centerlines_FinalCS,FullStNm,0,244;abFullStNm "Abbreviated Full Street Name" true true false 150 Text 0 0,First,#,Road_Centerlines_FinalCS,abFullStNm,0,149;LSt_PreDir "Legacy Street Name Pre Directional" true true false 2 Text 0 0,First,#,Road_Centerlines_FinalCS,LSt_PreDir,0,1;LSt_Name "Legacy Street Name" true true false 75 Text 0 0,First,#,Road_Centerlines_FinalCS,LSt_Name,0,74;LSt_Type "Legacy Street Name Type" true true false 4 Text 0 0,First,#,Road_Centerlines_FinalCS,LSt_Type,0,3;LSt_PosDir "Legacy Street Name Post Directional" true true false 2 Text 0 0,First,#,Road_Centerlines_FinalCS,LSt_PosDir,0,1;PostCode_L "Postal Code Left" true true false 7 Text 0 0,First,#,Road_Centerlines_FinalCS,PostCode_L,0,6;PostCode_R "Postal Code Right" true true false 7 Text 0 0,First,#,Road_Centerlines_FinalCS,PostCode_R,0,6;PostComm_L "Postal Community Name Left" true true false 40 Text 0 0,First,#,Road_Centerlines_FinalCS,PostComm_L,0,39;PostComm_R "Postal Community Name Right" true true false 40 Text 0 0,First,#,Road_Centerlines_FinalCS,PostComm_R,0,39;CityCode_L "City Code Left" true true false 10 Text 0 0,First,#,Road_Centerlines_FinalCS,CityCode_L,0,9;CityCode_R "City Code Right" true true false 10 Text 0 0,First,#,Road_Centerlines_FinalCS,CityCode_R,0,9;Country_L "Country Left" true true false 2 Text 0 0,First,#,Road_Centerlines_FinalCS,Country_L,0,1;Country_R "Country Right" true true false 2 Text 0 0,First,#,Road_Centerlines_FinalCS,Country_R,0,1;State_L "State Left" true true false 2 Text 0 0,First,#,Road_Centerlines_FinalCS,State_L,0,1;State_R "State Right" true true false 2 Text 0 0,First,#,Road_Centerlines_FinalCS,State_R,0,1;County_L "County Left" true true false 40 Text 0 0,First,#,Road_Centerlines_FinalCS,County_L,0,39;County_R "County Right" true true false 40 Text 0 0,First,#,Road_Centerlines_FinalCS,County_R,0,39;CountyCode_L "County Code Left" true true false 5 Text 0 0,First,#,Road_Centerlines_FinalCS,CountyCode_L,0,4;CountyCode_R "County Code Right" true true false 5 Text 0 0,First,#,Road_Centerlines_FinalCS,CountyCode_R,0,4;IncMuni_L "Incorporated Municipality Left" true true false 100 Text 0 0,First,#,Road_Centerlines_FinalCS,IncMuni_L,0,99;IncMuni_R "Incorporated Municipality Right" true true false 100 Text 0 0,First,#,Road_Centerlines_FinalCS,IncMuni_R,0,99;UnincCom_L "Unincorporated Community Left" true true false 100 Text 0 0,First,#,Road_Centerlines_FinalCS,UnincCom_L,0,99;UnincCom_R "Unincorporated Community Right" true true false 100 Text 0 0,First,#,Road_Centerlines_FinalCS,UnincCom_R,0,99;NbrhdCom_L "Neighborhood Community Left" true true false 100 Text 0 0,First,#,Road_Centerlines_FinalCS,NbrhdCom_L,0,99;NbrhdCom_R "Neighborhood Community Right" true true false 100 Text 0 0,First,#,Road_Centerlines_FinalCS,NbrhdCom_R,0,99;AddCode_L "Additional Code Left" true true false 6 Text 0 0,First,#,Road_Centerlines_FinalCS,AddCode_L,0,5;AddCode_R "Additional Code Right" true true false 6 Text 0 0,First,#,Road_Centerlines_FinalCS,AddCode_R,0,5;OneWay "One-Way" true true false 2 Text 0 0,First,#,Road_Centerlines_FinalCS,OneWay,0,1;SpeedLimit "Speed Limit" true true false 2 Short 0 0,First,#,Road_Centerlines_FinalCS,SpeedLimit,-1,-1;RdCode "Road Code" true true false 3 Text 0 0,First,#,Road_Centerlines_FinalCS,RdCode,0,2;RdClass "Road Class" true true false 30 Text 0 0,First,#,Road_Centerlines_FinalCS,RdClass,0,29;DateUpdate "Date Updated" false true false 8 Date 0 0,First,#,Road_Centerlines_FinalCS,DateUpdate,-1,-1;Effective "Effective Date" true true false 8 Date 0 0,First,#,Road_Centerlines_FinalCS,Effective,-1,-1;Expire "Expiration Date" true true false 8 Date 0 0,First,#,Road_Centerlines_FinalCS,Expire,-1,-1;DiscrpAgID "Discrepancy Agency ID" true true false 75 Text 0 0,First,#,Road_Centerlines_FinalCS,DiscrpAgID,0,74;Parity_L "Parity Left" true true false 1 Text 0 0,First,#,Road_Centerlines_FinalCS,Parity_L,0,0;Parity_R "Parity Right" true true false 1 Text 0 0,First,#,Road_Centerlines_FinalCS,Parity_R,0,0;ESN_L "ESN Left" true true false 5 Text 0 0,First,#,Road_Centerlines_FinalCS,ESN_L,0,4;ESN_R "ESN Right" true true false 5 Text 0 0,First,#,Road_Centerlines_FinalCS,ESN_R,0,4;MSAGComm_L "MSAG Community Name Left" true true false 30 Text 0 0,First,#,Road_Centerlines_FinalCS,MSAGComm_L,0,29;MSAGComm_R "MSAG Community Name Right" true true false 30 Text 0 0,First,#,Road_Centerlines_FinalCS,MSAGComm_R,0,29;Valid_L "Validation Left" true true false 1 Text 0 0,First,#,Road_Centerlines_FinalCS,Valid_L,0,0;Valid_R "Validation Right" true true false 1 Text 0 0,First,#,Road_Centerlines_FinalCS,Valid_R,0,0;PsapID_L "PSAP ID Left" true true false 100 Text 0 0,First,#,Road_Centerlines_FinalCS,PsapID_L,0,99;PsapID_R "PSAP ID Right" true true false 100 Text 0 0,First,#,Road_Centerlines_FinalCS,PsapID_R,0,99;FrElev "From Elevation" true true false 2 Short 0 0,First,#,Road_Centerlines_FinalCS,FrElev,-1,-1;ToElev "To Elevation" true true false 2 Short 0 0,First,#,Road_Centerlines_FinalCS,ToElev,-1,-1;AltNmUS "Alternative Name US" true true false 255 Text 0 0,First,#,Road_Centerlines_FinalCS,AltNmUS,0,254;AltNmSt "Alternative Name State" true true false 255 Text 0 0,First,#,Road_Centerlines_FinalCS,AltNmSt,0,254;AltNmCo "Alternative Name County" true true false 255 Text 0 0,First,#,Road_Centerlines_FinalCS,AltNmCo,0,254;AltFlNm "Alternative Full Name" true true false 255 Text 0 0,First,#,Road_Centerlines_FinalCS,AltFlNm,0,254;Lst_Edit_User "Last Editor User" false true false 255 Text 0 0,First,#,Road_Centerlines_FinalCS,Lst_Edit_User,0,254;Lst_Edit_Date "Last Edit Date" true true false 8 Date 0 0,First,#,Road_Centerlines_FinalCS,Lst_Edit_Date,-1,-1;Creat_Nm "Creator Name" false true false 255 Text 0 0,First,#,Road_Centerlines_FinalCS,Creat_Nm,0,254;Creat_Date "Created Date" false true false 8 Date 0 0,First,#,Road_Centerlines_FinalCS,Creat_Date,-1,-1;Data_Source "Data Source" true true false 50 Text 0 0,First,#,Road_Centerlines_FinalCS,Data_Source,0,49;Status "Status" true true false 1 Text 0 0,First,#,Road_Centerlines_FinalCS,Status,0,0;Notes "Notes" true true false 255 Text 0 0,First,#,Road_Centerlines_FinalCS,Notes,0,254;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,Road_Centerlines_FinalCS,Shape_Length,-1,-1;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#,Road_Centerlines_FinalCS,GlobalID,-1,-1;created_user "created_user" true true false 255 Text 0 0,First,#,Road_Centerlines_FinalCS,created_user,0,254;created_date "created_date" true true false 8 Date 0 0,First,#,Road_Centerlines_FinalCS,created_date,-1,-1;last_edited_user "last_edited_user" true true false 255 Text 0 0,First,#,Road_Centerlines_FinalCS,last_edited_user,0,254;last_edited_date "last_edited_date" true true false 8 Date 0 0,First,#,Road_Centerlines_FinalCS,last_edited_date,-1,-1;HouseNumberPostfix "HouseNumberPostfix" true true false 10 Text 0 0,First,#,Road_Centerlines_FinalCS,HouseNumberPostfix,0,9" #
CopyMultiple "'C:\OneDrive\OneDrive - Cloudpoint Geospatial Inc\Projects\La Crosse County WI\700_Shared with Client\Cloudpoint Geo - La Crosse County Data Share\Delivery2CloudpointJan11_2024.gdb\LaCrosseCounty_RCL_01_11_24' FeatureClass" "C:\OneDrive\OneDrive - Cloudpoint Geospatial Inc\Projects\La Crosse County WI\400_GIS\402_Databases\20240108_LaCrosseCountyRCL\20240108_LaCrosseRCL_Review.gdb" LaCrosseCounty_RCL_01_11_24 "LaCrosseCounty_RCL_01_11_24 FeatureClass LaCrosseCounty_RCL_01_11_24 #"
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.2.0'><WorkspaceConnectionString>DATABASE=C:\OneDrive\OneDrive - Cloudpoint Geospatial Inc\Projects\La Crosse County WI\400_GIS\402_Databases\20240108_LaCrosseCountyRCL\20240108_LaCrosseRCL_Review.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LaCrosseCounty_RCL_01_11_24</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteAttributeRule><rule_name>UniqueID_RCL</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow></operationSequence>
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.2.0'><WorkspaceConnectionString>DATABASE=C:\OneDrive\OneDrive - Cloudpoint Geospatial Inc\Projects\La Crosse County WI\400_GIS\402_Databases\20240108_LaCrosseCountyRCL\20240108_LaCrosseRCL_Review.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LaCrosseCounty_RCL_01_11_24</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>RCL NENA GUID Calculation</rule_name><rule_type>CALCULATION</rule_type><expression>// Project: WI NG911
// Layer: Road Centerlines
// Rule Type: Calculation
// Rule Name: RCL NENA GUID
// Description: Creates a new unique NENA compliant id when a road centerline point is created.
// Note: Must create the database sequence for NextSequenceValue to reference
// This rule will create a new unique id when a site address point is created
// Define the leading text and the delimiter for the ID
var prefix = "RCL"
var suffix = "@co.jackson.wi.us"
var sequenceName = "ROAD_NGUID"
// Ensure the ID is not already set, if it is, return the original id
IIf((IsEmpty($feature.RCL_NGUID)),
(Concatenate([prefix, NextSequenceValue(sequenceName),suffix], "")),
$feature.RCL_NGUID);</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><rule_description>Immediately calculates road centerline's NGUID on insert only.</rule_description><exclude_from_client_eval>True</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>RCL NENA GUID Calculation</rule_name><evaluation_order>1</evaluation_order></ReorderAttributeRule></workflow></operationSequence>"
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.2.0'><WorkspaceConnectionString>DATABASE=C:\OneDrive\OneDrive - Cloudpoint Geospatial Inc\Projects\La Crosse County WI\400_GIS\402_Databases\20240108_LaCrosseCountyRCL\20240108_LaCrosseRCL_Review.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LaCrosseCounty_RCL_01_11_24</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>Legacy StPreDir Calculation</rule_name><rule_type>CALCULATION</rule_type><expression>// Project: WI NG911
// Layer: RoadCenterline
// Field: LST_PREDIR
// Rule Type: Immediate Calculation
// Rule Name: Legacy StPreDir Calculation
// Description: Calculation rule to populate LSt_PreDir based on feature's St_PreDir value.
// Subtypes: All
// Error Number: NA
// Error Message: NA
// Severity: NA
// Trigger: Insert/Update
// Exclude From Client: False
// Disable: False
// Version: 1.1.0
// Status: PRODUCTION
// Notes: Added check for null value before Decode
// If StPreDir is null, return null
if(IsEmpty($feature['st_predir'])){return null}
// Decode function returns the value in the code/value pairs
// If code is not found in pairs, returned (default) value is original value
Decode(Upper($feature['st_predir']),'NORTH','N','SOUTH','S','EAST','E','WEST','W','NORTHEAST','NE','NORTHWEST','NW','SOUTHEAST','SE','SOUTHWEST','SW',null);</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><error_number>0</error_number><rule_description>Calculation rule to populate LSt_PreDir based on feature's St_PreDir value.</rule_description><field_name>LSt_PreDir</field_name><exclude_from_client_eval>True</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>0</category></AddAttributeRule><ReorderAttributeRule><rule_name>Legacy StPreDir Calculation</rule_name><evaluation_order>2</evaluation_order></ReorderAttributeRule></workflow><workflow><AddAttributeRule><rule_name>Legacy St Type Calculation</rule_name><rule_type>CALCULATION</rule_type><expression>// Project: WI NG911
// Layer: RoadCenterline
// Field: LST_TYPE
// Rule Type: Immediate Calculation
// Rule Name: Legacy St Type Calculation
// Description: Calculation rule to populate LST_TYPE based on feature's ST_POSTYP value.
// Subtypes: All
// Error Number: NA
// Error Message: NA
// Severity: NA
// Trigger: Insert/Update
// Exclude From Client: False
// Disable: False
// Version: 1.1.0
// Status: PRODUCTION
// Notes: Added check for null value in StPosTyp
// If StPosTyp is null, return null
if(IsEmpty($feature['st_postyp'])){return Null}
// Decode function returns the value in the code/value pairs
// If code is not found in pairs, returned (default) value is original value
var newVal = Decode(Upper($feature['st_postyp']),'ALLEY','ALY','ANNEX','ANX','ARCADE','ARC','AVENUE','AVE','BAYOU','BYU','BEACH','BCH','BEND','BND','BLUFF','BLF','BLUFFS','BLFS','BOTTOM','BTM','BOULEVARD','BLVD','BRANCH','BR','BRIDGE','BRG','BROOK','BRK','BROOKS','BRKS','BURG','BG','BURGS','BGS','BYPASS','BYP','CAMP','CP','CANYON','CYN','CAPE','CPE','CAUSEWAY','CSWY','CENTER','CTR','CENTERS','CTRS','CIRCLE','CIR','CIRCLES','CIRS','CLIFF','CLF','CLIFFS','CLFS','CLUB','CLB','COMMON','CMN','COMMONS','CMNS','CORNER','COR','CORNERS','CORS','COURSE','CRSE','COURT','CT','COURTS','CTS','COVE','CV','COVES','CVS','CREEK','CRK','CRESCENT','CRES','CREST','CRST','CROSSING','XING','CROSSROAD','XRD','CROSSROADS','XRDS','CURVE','CURV','DALE','DL','DAM','DM','DIVIDE','DV','DRIVE','DR','DRIVES','DRS','ESTATE','EST','ESTATES','ESTS','EXPRESSWAY','EXPY','EXTENSION','EXT','EXTENSIONS','EXTS','FALL','FALL','FALLS','FLS','FERRY','FRY','FIELD','FLD','FIELDS','FLDS','FLAT','FLT','FLATS','FLTS','FORD','FRD','FORDS','FRDS','FOREST','FRST','FORGE','FRG','FORGES','FRGS','FORK','FRK','FORKS','FRKS','FORT','FT','FREEWAY','FWY','GARDEN','GDN','GARDENS','GDNS','GATEWAY','GTWY','GLEN','GLN','GLENS','GLNS','GREEN','GRN','GREENS','GRNS','GROVE','GRV','GROVES','GRVS','HARBOR','HBR','HARBORS','HBRS','HAVEN','HVN','HEIGHTS','HTS','HIGHWAY','HWY','HILL','HL','HILLS','HLS','HOLLOW','HOLW','INLET','INLT','ISLAND','IS','ISLANDS','ISS','ISLE','ISLE','JUNCTION','JCT','JUNCTIONS','JCTS','KEY','KY','KEYS','KYS','KNOLL','KNL','KNOLLS','KNLS','LAKE','LK','LAKES','LKS','LAND','LAND','LANDING','LNDG','LANE','LN','LIGHT','LGT','LIGHTS','LGTS','LOAF','LF','LOCK','LCK','LOCKS','LCKS','LODGE','LDG','LOOP','LOOP','MALL','MALL','MANOR','MNR','MANORS','MNRS','MEADOW','MDW','MEADOWS','MDWS','MEWS','MEWS','MILL','ML','MILLS','MLS','MISSION','MSN','MOTORWAY','MTWY','MOUNT','MT','MOUNTAIN','MTN','MOUNTAINS','MTNS','NECK','NCK','ORCHARD','ORCH','OVAL','OVAL','OVERPASS','OPAS','PARK','PARK','PARKWAY','PKWY','PASS','PASS','PASSAGE','PSGE','PATH','PATH','PIKE','PIKE','PINE','PNE','PINES','PNES','PLACE','PL','PLAIN','PLN','PLAINS','PLNS','PLAZA','PLZ','POINT','PT','POINTS','PTS','PORT','PRT','PORTS','PRTS','PRAIRIE','PR','RADIAL','RADL','RAMP','RAMP','RANCH','RNCH','RAPID','RPD','RAPIDS','RPDS','REST','RST','RIDGE','RDG','RIDGES','RDGS','RIVER','RIV','ROAD','RD','ROADS','RDS','ROUTE','RTE','ROW','ROW','RUE','RUE','RUN','RUN','SHOAL','SHL','SHOALS','SHLS','SHORE','SHR','SHORES','SHRS','SKYWAY','SKWY','SLIP','SPG','SPRING','SPGS','SPUR','SPUR','SQUARE','SQ','SQUARES','SQS','STATION','STA','STRAVENUE','STRA','STREAM','STRM','STREET','ST','STREETS','STS','STRIP','STRP','SUMMIT','SMT','TERRACE','TER','THROUGHWAY','TRWY','TRACE','TRCE','TRACK','TRAK','TRAFFICWAY','TRFY','TRAIL','TRL','TRAILER','TRLR','TUNNEL','TUNL','TURNPIKE','TPKE','UNDERPASS','UPAS','UNION','UN','UNIONS','UNS','VALLEY','VLY','VALLEYS','VLYS','VIADUCT','VIA','VIEW','VW','VIEWS','VWS','VILLAGE','VLG','VILLAGES','VLGS','VILLE','VL','VISTA','VIS','WALK','WALK','WALL','WALL','WAY','WAY','WAYS','WAYS','WELL','WL','WELLS','WLS',null);
// Return the decoded value in Upper casing to match WI domain
IIF(IsEmpty(newVal), Null, Upper(newVal))</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><error_number>0</error_number><rule_description>Calculation rule to populate LST_TYPE based on feature's ST_POSTYP value.</rule_description><field_name>LSt_Type</field_name><exclude_from_client_eval>True</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>0</category></AddAttributeRule><ReorderAttributeRule><rule_name>Legacy St Type Calculation</rule_name><evaluation_order>3</evaluation_order></ReorderAttributeRule></workflow><workflow><AddAttributeRule><rule_name>Legacy StPosDir Calculation</rule_name><rule_type>CALCULATION</rule_type><expression>// Project: WI NG911
// Layer: RoadCenterline
// Field: LST_POSDIR
// Rule Type: Immediate Calculation
// Rule Name: Legacy Street Post Directional Calculation
// Description: Calculation rule to populate LST_POSDIR based on feature's ST_POSDIR value.
// Subtypes: All
// Error Number: NA
// Error Message: NA
// Severity: NA
// Trigger: Insert/Update
// Exclude From Client: False
// Disable: False
// Version: 1.1.0
// Status: PRODUCTION
// Notes: Added check for null value before Decode
// If StPreDir is null, return null
if(IsEmpty($feature['st_posdir'])){return null}
// Decode function returns the value in the code/value pairs
// If code is not found in pairs, returned (default) value is original value
Decode(Upper($feature['st_posdir']),'NORTH','N','SOUTH','S','EAST','E','WEST','W','NORTHEAST','NE','NORTHWEST','NW','SOUTHEAST','SE','SOUTHWEST','SW',null);</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><error_number>0</error_number><rule_description>Calculation rule to populate LSt_PosDir based on feature's St_PosDir value.</rule_description><field_name>LSt_PosDir</field_name><exclude_from_client_eval>True</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>0</category></AddAttributeRule><ReorderAttributeRule><rule_name>Legacy StPosDir Calculation</rule_name><evaluation_order>4</evaluation_order></ReorderAttributeRule></workflow><workflow><AddAttributeRule><rule_name>Full St Name Calculation</rule_name><rule_type>CALCULATION</rule_type><expression>// Project: WI NG911
// Layer: RoadCenterline
// Field: FULLSTNM
// Rule Type: Immediate Calculation
// Rule Name: Full St Name Calculation
// Description: Calculation rule populating 'abfullstnm' with concatenated values.
// Subtypes: All
// Error Number: NA
// Error Message: NA
// Severity: NA
// Trigger: Insert/Update
// Exclude From Client: False
// Disable: False
// Version: 1.1.0
// Status: PRODUCTION
// Notes:
// Initialize index counter and array variables
var i = 0;
var features = [];
// Add value to array if not empty or blank space
function addvalue(feat) {
if (IsEmpty(feat) || feat == ' '){feat = Null}
else if (!IsEmpty(feat)) {
features[i++] = feat;
}
}
// Add your values
addvalue($feature['st_premod']);
addvalue($feature['st_predir']);
addvalue($feature['st_pretype']);
addvalue($feature['st_presep']);
addvalue($feature['st_name']);
addvalue($feature['st_postyp']);
addvalue($feature['st_posdir']);
// Return a concatenated string
var vals = (Concatenate(features, " "));
// If an empty string or a string of blanks is returned, return null
// else return the concatenated FullRoadName string
if (IsEmpty(vals)){return Null}
else{vals}</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><error_number>0</error_number><rule_description>Calculation rule populating 'abfullstnm' with concatenated values.</rule_description><field_name>FullStNm</field_name><exclude_from_client_eval>True</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>0</category></AddAttributeRule><ReorderAttributeRule><rule_name>Full St Name Calculation</rule_name><evaluation_order>5</evaluation_order></ReorderAttributeRule></workflow><workflow><AddAttributeRule><rule_name>Abbreviated Full St Name Calculation</rule_name><rule_type>CALCULATION</rule_type><expression>// Project: WI NG911
// Layer: RoadCenterline
// Field: ABFULLSTNM
// Rule Type: Immediate Calculation
// Rule Name: Abbreviated Full St Name Calculation
// Description: Calculation rule populating ABFULLSTNM with concatenated values.
// Subtypes: All
// Error Number: NA
// Error Message: NA
// Severity: NA
// Trigger: Insert/Update
// Exclude From Client: False
// Disable: False
// Version: 1.1.0
// Status: PRODUCTION
// Notes:
// Initialize index counter and array variables
var i = 0;
var features = [];
// Add value to array if not empty or blank space
function addvalue(feat) {
if (IsEmpty(feat) || feat==' '){feat = Null}
else if (!IsEmpty(feat)) {
features[i++] = feat;
}
}
// Add your values
addvalue($feature['lst_predir']);
addvalue($feature['lst_pretyp']);
addvalue($feature['st_presep']);
addvalue($feature['lst_name']);
addvalue($feature['lst_type']);
addvalue($feature['lst_posdir']);
// Return a concatenated string
var vals = (Concatenate(features, " "));
// If an empty string or a string of blanks is returned, return null
// else return the concatenated FullRoadName string
if (IsEmpty(vals)) {return Null}
else {vals}</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><error_number>0</error_number><rule_description>Calculation rule populating ABFULLSTNM with concatenated values.</rule_description><field_name>abFullStNm</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>0</category></AddAttributeRule><ReorderAttributeRule><rule_name>Abbreviated Full St Name Calculation</rule_name><evaluation_order>6</evaluation_order></ReorderAttributeRule></workflow><workflow><AddAttributeRule><rule_name>Parity Left Calculation</rule_name><rule_type>CALCULATION</rule_type><expression>// Project: WI NG911
// Layer: RoadCenterline
// Field: PARITY_L
// Rule Type: Immediate Calculation
// Rule Name: Parity Left Calculation
// Description: Calculation rule populating 'parity_l' with domain values.
// Subtypes: All
// Error Number: NA
// Error Message: NA
// Severity: NA
// Trigger: Insert/Update
// Exclude From Client: False
// Disable: False
// Version: 1.0.0
// Status: TESTING
// Notes:
var L1 = $feature['fromaddr_l'];
var L2 = $feature['toaddr_l'];
var LP = $feature['parity_l'];
var L1v = '';
var L2v = '';
// Calculate Parity Right
if (L1 == 0 && L2 == 0 || IsEmpty(L1) && IsEmpty(L2)){LP = 'Z'}
else {
if (L1 == 0 || L1 == ''){L1v = ''}
// Modulus (%) returns 0 if no division remainder
// returns 1 if a remainder is present
else if (L1%2 == 0){L1v = 'E'}
else {L1v = 'O'}
if (L2 == 0 || L2 == ''){L2v=''}
else if (L2%2 == 0){L2v = 'E'}
else {L2v = 'O'}
// Combines but removes duplicates
LP = Concatenate(L1v, ',', L2v);
if (LP == 'O,E' || LP == 'E,O'){LP = 'B'}
// L1v will be 'O' or 'E' if LP is 'O,O' or 'E,E'
else {LP = L1v}
}
return LP</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><error_number>0</error_number><rule_description>Calculation rule populating 'parity_l' with domain values.</rule_description><field_name>Parity_L</field_name><exclude_from_client_eval>True</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>0</category></AddAttributeRule><ReorderAttributeRule><rule_name>Parity Left Calculation</rule_name><evaluation_order>7</evaluation_order></ReorderAttributeRule></workflow><workflow><AddAttributeRule><rule_name>Parity Right Calculation</rule_name><rule_type>CALCULATION</rule_type><expression>// Project: WI NG911
// Layer: RoadCenterline
// Field: PARITY_R
// Rule Type: Immediate Calculation
// Rule Name: Parity Right Calculation
// Description: Calculation rule populating 'parity_r' with domain values.
// Subtypes: All
// Error Number: NA
// Error Message: NA
// Severity: NA
// Trigger: Insert/Update
// Exclude From Client: False
// Disable: False
// Version: 1.0.0
// Status: TESTING
// Notes:
var R1 = $feature['fromaddr_r'];
var R2 = $feature['toaddr_r'];
var RP = $feature['parity_r'];
var R1v = '';
var R2v = '';
// Calculate Parity Right
if (R1 == 0 && R2 == 0 || IsEmpty(R1) && IsEmpty(R2)){RP = 'Z'}
else {
if (R1 == 0 || R1 == ''){R1v = ''}
// Modulus (%) returns 0 if no division remainder
// returns 1 if a remainder is present
else if (R1%2 == 0){R1v = 'E'}
else {R1v = 'O'}
if (R2 == 0 || R2 == ''){R2v = ''}
else if (R2%2 == 0){R2v = 'E'}
else {R2v = 'O'}
// Combines but removes duplicates
RP = Concatenate(R1v, ',', R2v);
if (RP == 'O,E' || RP == 'E,O'){RP = 'B'}
// R1v will be 'O' or 'E' if RP is 'O,O' or 'E,E'
else {RP = R1v}
}
return RP</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><error_number>0</error_number><rule_description>Calculation rule populating 'parity_r' with domain values.</rule_description><field_name>Parity_R</field_name><exclude_from_client_eval>True</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>0</category></AddAttributeRule><ReorderAttributeRule><rule_name>Parity Right Calculation</rule_name><evaluation_order>8</evaluation_order></ReorderAttributeRule></workflow><workflow><AddAttributeRule><rule_name>Full St Name Upper Calculation</rule_name><rule_type>CALCULATION</rule_type><expression>// Project: WI NG911
// Layer: RoadCenterline
// Field: FULLSTNM_UPPER
// Rule Type: Immediate Calculation
// Rule Name: Full St Name UPPER Calculation
// Description: Calculation rule populating FULLSTNM_UPPER with uppercase FULLSTNM.
// Subtypes: All
// Error Number: NA
// Error Message: NA
// Severity: NA
// Trigger: Insert/Update
// Exclude From Client: False
// Disable: False
// Version: 1.0.0
// Status: PRODUCTION
// Notes:
var upperVal = Upper($feature['fullstnm']);
IIF(IsEmpty(upperVal), Null, upperVal)</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><error_number>0</error_number><rule_description>Calculation rule populating FULLSTNM_UPPER with uppercase FULLSTNM.</rule_description><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>0</category></AddAttributeRule><ReorderAttributeRule><rule_name>Full St Name Upper Calculation</rule_name><evaluation_order>10</evaluation_order></ReorderAttributeRule></workflow><workflow><AddAttributeRule><rule_name>Full St Name Community Left Calculation</rule_name><rule_type>CALCULATION</rule_type><expression>// Project: WI NG911
// Layer: RoadCenterline
// Field: FULLSTNMCOMM_L
// Rule Type: Immediate Calculation
// Rule Name: Full St Name Community Left Calculation
// Description: Calculation rule populating FULLSTNMCOMM_L with concatenated values.
// Subtypes: All
// Error Number: NA
// Error Message: NA
// Severity: NA
// Trigger: Insert/Update
// Exclude From Client: False
// Disable: False
// Version: 1.1.0
// Status: PRODUCTION
// Notes: Added var for Community field, returns UPPERCASE string
// Create variable for field with community value
var commField = Upper($feature['postcomm_l']);
//var commField = Upper($feature['msagcomm_l']);
// Check for empty value after conversion to Uppercase
commField = IIF(IsEmpty(commField), Null, commField);
// Initialize index counter and array variables
var i = 0;
var features = [];
// Add value to array if not empty or blank space
function addvalue(feat) {
if (IsEmpty(feat) || feat == ' '){feat = Null}
else if (!IsEmpty(feat)) {
features[i++] = feat;
}
}
// Add your values
addvalue(Upper($feature['st_premod']));
addvalue(Upper($feature['st_predir']));
addvalue(Upper($feature['st_pretype']));
addvalue(Upper($feature['st_presep']));
addvalue(Upper($feature['st_name']));
addvalue(Upper($feature['st_postyp']));
addvalue(Upper($feature['st_posdir']));
// Return a concatenated string
var vals = (Concatenate(features, " ") + ", " + commField);
// If an empty string or a string of blanks is returned, return null
// else return the concatenated FullRoadNameCommunityLeft string
if (IsEmpty(vals) || vals == ',' || vals == ', ') {Null}
else {(vals)}</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><error_number>0</error_number><rule_description>Calculation rule populating FULLSTNMCOMM_L with concatenated values.</rule_description><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>0</category></AddAttributeRule><ReorderAttributeRule><rule_name>Full St Name Community Left Calculation</rule_name><evaluation_order>12</evaluation_order></ReorderAttributeRule></workflow><workflow><AddAttributeRule><rule_name>Full St Name Community Right Calculation</rule_name><rule_type>CALCULATION</rule_type><expression>// Project: WI NG911
// Layer: RoadCenterline
// Field: FULLSTNMCOMM_R
// Rule Type: Immediate Calculation
// Rule Name: Full St Name Community Right Calculation
// Description: Calculation rule populating FULLSTNMCOMM_R with concatenated values.
// Subtypes: All
// Error Number: NA
// Error Message: NA
// Severity: NA
// Trigger: Insert/Update
// Exclude From Client: False
// Disable: False
// Version: 1.1.0
// Status: PRODUCTION
// Notes: Added var for Community field, returns UPPERCASE string
// Create variable for field with community value
var commField = upper($feature['postcomm_r']);
//var commField = $feature['msagcomm_r'];
// Check for empty value after conversion to Uppercase
commField = IIF(IsEmpty(commField), Null, commField);
// Initialize index counter and array variables
var i = 0;
var features = [];
// Add value to array if not empty or blank space
function addvalue(feat) {
if (IsEmpty(feat) || feat == ' '){feat = Null}
else if (!IsEmpty(feat)) {
features[i++] = feat;
}
}
// Add your values
addvalue(Upper($feature['st_premod']));
addvalue(Upper($feature['st_predir']));
addvalue(Upper($feature['st_pretype']));
addvalue(Upper($feature['st_presep']));
addvalue(Upper($feature['st_name']));
addvalue(Upper($feature['st_postyp']));
addvalue(Upper($feature['st_posdir']));
// Return a concatenated string
var vals = (Concatenate(features, " ") + ", " + commField);
// If an empty string or a string of blanks is returned, return null
// else return the concatenated FullRoadNameCommunityLeft string
if (IsEmpty(vals) || vals == ',' || vals == ', ') {Null}
else {(vals)}</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><error_number>0</error_number><rule_description>Calculation rule populating FULLSTNMCOMM_R with concatenated values.</rule_description><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>0</category></AddAttributeRule><ReorderAttributeRule><rule_name>Full St Name Community Right Calculation</rule_name><evaluation_order>13</evaluation_order></ReorderAttributeRule></workflow></operationSequence>"
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.2.0'><WorkspaceConnectionString>DATABASE=C:\OneDrive\OneDrive - Cloudpoint Geospatial Inc\Projects\La Crosse County WI\400_GIS\402_Databases\20240108_LaCrosseCountyRCL\20240108_LaCrosseRCL_Review.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LaCrosseCounty_RCL_01_11_24</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>Abbreviated Full St Name Calculation</rule_name><rule_type>CALCULATION</rule_type><expression>// Project: WI NG911
// Layer: RoadCenterline
// Field: ABFULLSTNM
// Rule Type: Immediate Calculation
// Rule Name: Abbreviated Full St Name Calculation
// Description: Calculation rule populating ABFULLSTNM with concatenated values.
// Subtypes: All
// Error Number: NA
// Error Message: NA
// Severity: NA
// Trigger: Insert/Update
// Exclude From Client: False
// Disable: False
// Version: 1.1.0
// Status: PRODUCTION
// Notes:
// Initialize index counter and array variables
var i = 0;
var features = [];
// Add value to array if not empty or blank space
function addvalue(feat) {
if (IsEmpty(feat) || feat==' '){feat = Null}
else if (!IsEmpty(feat)) {
features[i++] = feat;
}
}
// Add your values
addvalue($feature['lst_predir']);
addvalue($feature['st_presep']);
addvalue($feature['lst_name']);
addvalue($feature['lst_type']);
addvalue($feature['lst_posdir']);
// Return a concatenated string
var vals = (Concatenate(features, " "));
// If an empty string or a string of blanks is returned, return null
// else return the concatenated FullRoadName string
if (IsEmpty(vals)) {return Null}
else {vals}</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><error_number>0</error_number><rule_description>Calculation rule populating ABFULLSTNM with concatenated values.</rule_description><field_name>abFullStNm</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>0</category></AddAttributeRule><ReorderAttributeRule><rule_name>Abbreviated Full St Name Calculation</rule_name><evaluation_order>6</evaluation_order></ReorderAttributeRule></workflow></operationSequence>"
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.2.0'><WorkspaceConnectionString>DATABASE=C:\OneDrive\OneDrive - Cloudpoint Geospatial Inc\Projects\La Crosse County WI\400_GIS\402_Databases\20240108_LaCrosseCountyRCL\20240108_LaCrosseRCL_Review.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LaCrosseCounty_RCL_01_11_24</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><DeleteAttributeRule><rule_name>RCL NENA GUID Calculation</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow><workflow><DeleteAttributeRule><rule_name>Full St Name Upper Calculation</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow><workflow><DeleteAttributeRule><rule_name>Full St Name Community Left Calculation</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow><workflow><DeleteAttributeRule><rule_name>Full St Name Community Right Calculation</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow></operationSequence>"
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.2.0'><WorkspaceConnectionString>DATABASE=C:\OneDrive\OneDrive - Cloudpoint Geospatial Inc\Projects\La Crosse County WI\400_GIS\402_Databases\20240108_LaCrosseCountyRCL\20240108_LaCrosseRCL_Review.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LaCrosseCounty_RCL_01_11_24</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>RCL NENA GUID Calculation</rule_name><rule_type>CALCULATION</rule_type><expression>// Project: WI NG911
// Layer: Road Centerlines
// Rule Type: Calculation
// Rule Name: RCL NENA GUID
// Description: Creates a new unique NENA compliant id when a road centerline point is created.
// Note: Must create the database sequence for NextSequenceValue to reference
// This rule will create a new unique id when a site address point is created
// Define the leading text and the delimiter for the ID
var prefix = "RCL"
var suffix = "@co.jackson.wi.us"
var sequenceName = "ROAD_NGUID"
// Ensure the ID is not already set, if it is, return the original id
IIf((IsEmpty($feature.RCL_NGUID)),
(Concatenate([prefix, NextSequenceValue(sequenceName),suffix], "")),
$feature.RCL_NGUID);</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><rule_description>Immediately calculates road centerline's NGUID on insert only.</rule_description><field_name>RCL_NGUID</field_name><exclude_from_client_eval>True</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>RCL NENA GUID Calculation</rule_name><evaluation_order>8</evaluation_order></ReorderAttributeRule></workflow></operationSequence>"
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.2.0'><WorkspaceConnectionString>DATABASE=C:\OneDrive\OneDrive - Cloudpoint Geospatial Inc\Projects\La Crosse County WI\400_GIS\402_Databases\20240108_LaCrosseCountyRCL\20240108_LaCrosseRCL_Review.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LaCrosseCounty_RCL_01_11_24</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AssignDomainToField><field_name>St_PreDir</field_name><domain_name>WLIA_DirectionDomain</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>St_PreType</field_name><domain_name>NENA_StNameTypesDomain</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>St_PreSep</field_name><domain_name>NENA_StNamePreTypeSeparatorsDomain</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>St_PosTyp</field_name><domain_name>NENA_StNameTypesDomain</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>St_PosDir</field_name><domain_name>WLIA_DirectionDomain</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>LSt_PreDir</field_name><domain_name>WLIA_abvDirectionDomain</domain_name></AssignDomainToField></workflow><workflow><RemoveDomainFromField><field_name>LSt_Name</field_name></RemoveDomainFromField></workflow><workflow><AssignDomainToField><field_name>LSt_Type</field_name><domain_name>NENA_LStTypesDomain_Upper</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>LSt_PosDir</field_name><domain_name>WLIA_abvDirectionDomain</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>PostComm_L</field_name><domain_name>USPS_WI_PostalCommunityDomain_Lower</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>PostComm_R</field_name><domain_name>USPS_WI_PostalCommunityDomain_Lower</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>Country_L</field_name><domain_name>NENA_CountryCodeDomain</domain_name></AssignDomainToField><AssignDefaultToField><field_name>Country_L</field_name><default_value>US</default_value></AssignDefaultToField></workflow><workflow><AssignDomainToField><field_name>Country_R</field_name><domain_name>NENA_CountryCodeDomain</domain_name></AssignDomainToField><AssignDefaultToField><field_name>Country_R</field_name><default_value>US</default_value></AssignDefaultToField></workflow><workflow><AssignDomainToField><field_name>State_L</field_name><domain_name>State</domain_name></AssignDomainToField><AssignDefaultToField><field_name>State_L</field_name><default_value>WI</default_value></AssignDefaultToField></workflow><workflow><AssignDomainToField><field_name>State_R</field_name><domain_name>State</domain_name></AssignDomainToField><AssignDefaultToField><field_name>State_R</field_name><default_value>WI</default_value></AssignDefaultToField></workflow><workflow><AssignDomainToField><field_name>County_L</field_name><domain_name>WLIA_NG911CountyDomain</domain_name></AssignDomainToField><AssignDefaultToField><field_name>County_L</field_name><default_value>Jackson County</default_value></AssignDefaultToField></workflow><workflow><AssignDomainToField><field_name>County_R</field_name><domain_name>WLIA_NG911CountyDomain</domain_name></AssignDomainToField><AssignDefaultToField><field_name>County_R</field_name><default_value>Jackson County</default_value></AssignDefaultToField></workflow><workflow><AssignDomainToField><field_name>IncMuni_L</field_name><domain_name>WLIA_FIPsMunicipalityDomain</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>IncMuni_R</field_name><domain_name>WLIA_FIPsMunicipalityDomain</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>OneWay</field_name><domain_name>WLIA_OneWayDomain</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>SpeedLimit</field_name><domain_name>WLIA_SpeedLimitDomain</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>RdCode</field_name><domain_name>WLIA_RoadClassDomain</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>RdClass</field_name><domain_name>WLIA_RoadClassDomain</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>Parity_L</field_name><domain_name>NENA_ParityDomain</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>Parity_R</field_name><domain_name>NENA_ParityDomain</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>MSAGComm_L</field_name><domain_name>USPS_WI_PostalCommunityDomain_Lower</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>MSAGComm_R</field_name><domain_name>USPS_WI_PostalCommunityDomain_Lower</domain_name></AssignDomainToField></workflow></operationSequence>"
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.2.0'><WorkspaceConnectionString>DATABASE=C:\OneDrive\OneDrive - Cloudpoint Geospatial Inc\Projects\La Crosse County WI\400_GIS\402_Databases\20240108_LaCrosseCountyRCL\20240108_LaCrosseRCL_Review.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LaCrosseCounty_RCL_01_11_24</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><RemoveDomainFromField><field_name>RdCode</field_name></RemoveDomainFromField></workflow></operationSequence>
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.2.0'><WorkspaceConnectionString>DATABASE=C:\OneDrive\OneDrive - Cloudpoint Geospatial Inc\Projects\La Crosse County WI\400_GIS\402_Databases\20240108_LaCrosseCountyRCL\20240108_LaCrosseRCL_Review.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LaCrosseCounty_RCL_01_11_24</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><RemoveDomainFromField><field_name>PostComm_L</field_name></RemoveDomainFromField></workflow><workflow><RemoveDomainFromField><field_name>PostComm_R</field_name></RemoveDomainFromField></workflow><workflow><RemoveDomainFromField><field_name>IncMuni_L</field_name></RemoveDomainFromField></workflow><workflow><RemoveDomainFromField><field_name>IncMuni_R</field_name></RemoveDomainFromField></workflow></operationSequence>
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.2.0'><WorkspaceConnectionString>DATABASE=C:\OneDrive\OneDrive - Cloudpoint Geospatial Inc\Projects\La Crosse County WI\400_GIS\402_Databases\20240108_LaCrosseCountyRCL\20240108_LaCrosseRCL_Review.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LaCrosseCounty_RCL_01_11_24</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><RemoveDomainFromField><field_name>RdClass</field_name></RemoveDomainFromField></workflow><workflow><RemoveDomainFromField><field_name>MSAGComm_L</field_name></RemoveDomainFromField></workflow><workflow><RemoveDomainFromField><field_name>MSAGComm_R</field_name></RemoveDomainFromField></workflow></operationSequence>
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.2.0'><WorkspaceConnectionString>DATABASE=C:\OneDrive\OneDrive - Cloudpoint Geospatial Inc\Projects\La Crosse County WI\400_GIS\402_Databases\20240108_LaCrosseCountyRCL\20240108_LaCrosseRCL_Review.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LaCrosseCounty_RCL_01_11_24</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AssignDefaultToField><field_name>County_L</field_name><default_value>La Crosse County</default_value></AssignDefaultToField></workflow><workflow><AssignDefaultToField><field_name>County_R</field_name><default_value>La Crosse County</default_value></AssignDefaultToField></workflow><workflow><AssignDefaultToField><field_name>Lst_Edit_User</field_name><default_value>BMENZEL</default_value></AssignDefaultToField></workflow><workflow><AssignDefaultToField><field_name>created_user</field_name><default_value>BMENZEL</default_value></AssignDefaultToField></workflow><workflow><AssignDefaultToField><field_name>last_edited_user</field_name><default_value>BMENZEL</default_value></AssignDefaultToField></workflow></operationSequence>"
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.2.0'><WorkspaceConnectionString>DATABASE=C:\OneDrive\OneDrive - Cloudpoint Geospatial Inc\Projects\La Crosse County WI\400_GIS\402_Databases\20240108_LaCrosseCountyRCL\20240108_LaCrosseRCL_Review.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LaCrosseCounty_RCL_01_11_24</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Legacy StPreDir Calculation</rule_name><rule_description>Calculation rule to populate LSt_PreDir based on feature's St_PreDir value.</rule_description><error_number>0</error_number><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression>// Project: WI NG911
// Layer: RoadCenterline
// Field: LST_PREDIR
// Rule Type: Immediate Calculation
// Rule Name: Legacy StPreDir Calculation
// Description: Calculation rule to populate LSt_PreDir based on feature's St_PreDir value.
// Subtypes: All
// Error Number: NA
// Error Message: NA
// Severity: NA
// Trigger: Insert/Update
// Exclude From Client: False
// Disable: False
// Version: 1.1.0
// Status: PRODUCTION
// Notes: Added check for null value before Decode
// If StPreDir is null, return null
if(IsEmpty($feature['st_predir'])){return null}
// Decode function returns the value in the code/value pairs
// If code is not found in pairs, returned (default) value is original value
Decode(Upper($feature['st_predir']),'NORTH','N','SOUTH','S','EAST','E','WEST','W','NORTHEAST','NE','NORTHWEST','NW','SOUTHEAST','SE','SOUTHWEST','SW',null);</expression><category>0</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow><workflow><AlterAttributeRule><rule_name>Legacy St Type Calculation</rule_name><rule_description>Calculation rule to populate LST_TYPE based on feature's ST_POSTYP value.</rule_description><error_number>0</error_number><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression>// Project: WI NG911
// Layer: RoadCenterline
// Field: LST_TYPE
// Rule Type: Immediate Calculation
// Rule Name: Legacy St Type Calculation
// Description: Calculation rule to populate LST_TYPE based on feature's ST_POSTYP value.
// Subtypes: All
// Error Number: NA
// Error Message: NA
// Severity: NA
// Trigger: Insert/Update
// Exclude From Client: False
// Disable: False
// Version: 1.1.0
// Status: PRODUCTION
// Notes: Added check for null value in StPosTyp
// If StPosTyp is null, return null
if(IsEmpty($feature['st_postyp'])){return Null}
// Decode function returns the value in the code/value pairs
// If code is not found in pairs, returned (default) value is original value
var newVal = Decode(Upper($feature['st_postyp']),'ALLEY','ALY','ANNEX','ANX','ARCADE','ARC','AVENUE','AVE','BAYOU','BYU','BEACH','BCH','BEND','BND','BLUFF','BLF','BLUFFS','BLFS','BOTTOM','BTM','BOULEVARD','BLVD','BRANCH','BR','BRIDGE','BRG','BROOK','BRK','BROOKS','BRKS','BURG','BG','BURGS','BGS','BYPASS','BYP','CAMP','CP','CANYON','CYN','CAPE','CPE','CAUSEWAY','CSWY','CENTER','CTR','CENTERS','CTRS','CIRCLE','CIR','CIRCLES','CIRS','CLIFF','CLF','CLIFFS','CLFS','CLUB','CLB','COMMON','CMN','COMMONS','CMNS','CORNER','COR','CORNERS','CORS','COURSE','CRSE','COURT','CT','COURTS','CTS','COVE','CV','COVES','CVS','CREEK','CRK','CRESCENT','CRES','CREST','CRST','CROSSING','XING','CROSSROAD','XRD','CROSSROADS','XRDS','CURVE','CURV','DALE','DL','DAM','DM','DIVIDE','DV','DRIVE','DR','DRIVES','DRS','ESTATE','EST','ESTATES','ESTS','EXPRESSWAY','EXPY','EXTENSION','EXT','EXTENSIONS','EXTS','FALL','FALL','FALLS','FLS','FERRY','FRY','FIELD','FLD','FIELDS','FLDS','FLAT','FLT','FLATS','FLTS','FORD','FRD','FORDS','FRDS','FOREST','FRST','FORGE','FRG','FORGES','FRGS','FORK','FRK','FORKS','FRKS','FORT','FT','FREEWAY','FWY','GARDEN','GDN','GARDENS','GDNS','GATEWAY','GTWY','GLEN','GLN','GLENS','GLNS','GREEN','GRN','GREENS','GRNS','GROVE','GRV','GROVES','GRVS','HARBOR','HBR','HARBORS','HBRS','HAVEN','HVN','HEIGHTS','HTS','HIGHWAY','HWY','HILL','HL','HILLS','HLS','HOLLOW','HOLW','INLET','INLT','ISLAND','IS','ISLANDS','ISS','ISLE','ISLE','JUNCTION','JCT','JUNCTIONS','JCTS','KEY','KY','KEYS','KYS','KNOLL','KNL','KNOLLS','KNLS','LAKE','LK','LAKES','LKS','LAND','LAND','LANDING','LNDG','LANE','LN','LIGHT','LGT','LIGHTS','LGTS','LOAF','LF','LOCK','LCK','LOCKS','LCKS','LODGE','LDG','LOOP','LOOP','MALL','MALL','MANOR','MNR','MANORS','MNRS','MEADOW','MDW','MEADOWS','MDWS','MEWS','MEWS','MILL','ML','MILLS','MLS','MISSION','MSN','MOTORWAY','MTWY','MOUNT','MT','MOUNTAIN','MTN','MOUNTAINS','MTNS','NECK','NCK','ORCHARD','ORCH','OVAL','OVAL','OVERPASS','OPAS','PARK','PARK','PARKWAY','PKWY','PASS','PASS','PASSAGE','PSGE','PATH','PATH','PIKE','PIKE','PINE','PNE','PINES','PNES','PLACE','PL','PLAIN','PLN','PLAINS','PLNS','PLAZA','PLZ','POINT','PT','POINTS','PTS','PORT','PRT','PORTS','PRTS','PRAIRIE','PR','RADIAL','RADL','RAMP','RAMP','RANCH','RNCH','RAPID','RPD','RAPIDS','RPDS','REST','RST','RIDGE','RDG','RIDGES','RDGS','RIVER','RIV','ROAD','RD','ROADS','RDS','ROUTE','RTE','ROW','ROW','RUE','RUE','RUN','RUN','SHOAL','SHL','SHOALS','SHLS','SHORE','SHR','SHORES','SHRS','SKYWAY','SKWY','SLIP','SPG','SPRING','SPGS','SPUR','SPUR','SQUARE','SQ','SQUARES','SQS','STATION','STA','STRAVENUE','STRA','STREAM','STRM','STREET','ST','STREETS','STS','STRIP','STRP','SUMMIT','SMT','TERRACE','TER','THROUGHWAY','TRWY','TRACE','TRCE','TRACK','TRAK','TRAFFICWAY','TRFY','TRAIL','TRL','TRAILER','TRLR','TUNNEL','TUNL','TURNPIKE','TPKE','UNDERPASS','UPAS','UNION','UN','UNIONS','UNS','VALLEY','VLY','VALLEYS','VLYS','VIADUCT','VIA','VIEW','VW','VIEWS','VWS','VILLAGE','VLG','VILLAGES','VLGS','VILLE','VL','VISTA','VIS','WALK','WALK','WALL','WALL','WAY','WAY','WAYS','WAYS','WELL','WL','WELLS','WLS',null);
// Return the decoded value in Upper casing to match WI domain
IIF(IsEmpty(newVal), Null, Upper(newVal))</expression><category>0</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow><workflow><AlterAttributeRule><rule_name>Legacy StPosDir Calculation</rule_name><rule_description>Calculation rule to populate LSt_PosDir based on feature's St_PosDir value.</rule_description><error_number>0</error_number><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression>// Project: WI NG911
// Layer: RoadCenterline
// Field: LST_POSDIR
// Rule Type: Immediate Calculation
// Rule Name: Legacy Street Post Directional Calculation
// Description: Calculation rule to populate LST_POSDIR based on feature's ST_POSDIR value.
// Subtypes: All
// Error Number: NA
// Error Message: NA
// Severity: NA
// Trigger: Insert/Update
// Exclude From Client: False
// Disable: False
// Version: 1.1.0
// Status: PRODUCTION
// Notes: Added check for null value before Decode
// If StPreDir is null, return null
if(IsEmpty($feature['st_posdir'])){return null}
// Decode function returns the value in the code/value pairs
// If code is not found in pairs, returned (default) value is original value
Decode(Upper($feature['st_posdir']),'NORTH','N','SOUTH','S','EAST','E','WEST','W','NORTHEAST','NE','NORTHWEST','NW','SOUTHEAST','SE','SOUTHWEST','SW',null);</expression><category>0</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow><workflow><AlterAttributeRule><rule_name>Full St Name Calculation</rule_name><rule_description>Calculation rule populating 'abfullstnm' with concatenated values.</rule_description><error_number>0</error_number><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression>// Project: WI NG911
// Layer: RoadCenterline
// Field: FULLSTNM
// Rule Type: Immediate Calculation
// Rule Name: Full St Name Calculation
// Description: Calculation rule populating 'abfullstnm' with concatenated values.
// Subtypes: All
// Error Number: NA
// Error Message: NA
// Severity: NA
// Trigger: Insert/Update
// Exclude From Client: False
// Disable: False
// Version: 1.1.0
// Status: PRODUCTION
// Notes:
// Initialize index counter and array variables
var i = 0;
var features = [];
// Add value to array if not empty or blank space
function addvalue(feat) {
if (IsEmpty(feat) || feat == ' '){feat = Null}
else if (!IsEmpty(feat)) {
features[i++] = feat;
}
}
// Add your values
addvalue($feature['st_premod']);
addvalue($feature['st_predir']);
addvalue($feature['st_pretype']);
addvalue($feature['st_presep']);
addvalue($feature['st_name']);
addvalue($feature['st_postyp']);
addvalue($feature['st_posdir']);
// Return a concatenated string
var vals = (Concatenate(features, " "));
// If an empty string or a string of blanks is returned, return null
// else return the concatenated FullRoadName string
if (IsEmpty(vals)){return Null}
else{vals}</expression><category>0</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow><workflow><AlterAttributeRule><rule_name>Abbreviated Full St Name Calculation</rule_name><rule_description>Calculation rule populating ABFULLSTNM with concatenated values.</rule_description><error_number>0</error_number><exclude_from_client_eval>False</exclude_from_client_eval><severity>-1</severity><expression>// Project: WI NG911
// Layer: RoadCenterline
// Field: ABFULLSTNM
// Rule Type: Immediate Calculation
// Rule Name: Abbreviated Full St Name Calculation
// Description: Calculation rule populating ABFULLSTNM with concatenated values.
// Subtypes: All
// Error Number: NA
// Error Message: NA
// Severity: NA
// Trigger: Insert/Update
// Exclude From Client: False
// Disable: False
// Version: 1.1.0
// Status: PRODUCTION
// Notes:
// Initialize index counter and array variables
var i = 0;
var features = [];
// Add value to array if not empty or blank space
function addvalue(feat) {
if (IsEmpty(feat) || feat==' '){feat = Null}
else if (!IsEmpty(feat)) {
features[i++] = feat;
}
}
// Add your values
addvalue($feature['lst_predir']);
addvalue($feature['st_presep']);
addvalue($feature['lst_name']);
addvalue($feature['lst_type']);
addvalue($feature['lst_posdir']);
// Return a concatenated string
var vals = (Concatenate(features, " "));
// If an empty string or a string of blanks is returned, return null
// else return the concatenated FullRoadName string
if (IsEmpty(vals)) {return Null}
else {vals}</expression><category>0</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>"
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.2.0'><WorkspaceConnectionString>DATABASE=C:\OneDrive\OneDrive - Cloudpoint Geospatial Inc\Projects\La Crosse County WI\400_GIS\402_Databases\20240108_LaCrosseCountyRCL\20240108_LaCrosseRCL_Review.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LaCrosseCounty_RCL_01_11_24</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddField><field_name>RCL_Addition</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><field_domain>WLIA_YesNoDomain</field_domain><field_default_value>Y</field_default_value></AddField></workflow><workflow><AddField><field_name>Addition_Type</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><field_domain>RCL Addition Type</field_domain></AddField></workflow></operationSequence>"
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.2.0'><WorkspaceConnectionString>DATABASE=C:\OneDrive\OneDrive - Cloudpoint Geospatial Inc\Projects\La Crosse County WI\400_GIS\402_Databases\20240108_LaCrosseCountyRCL\20240108_LaCrosseRCL_Review.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LaCrosseCounty_RCL_01_11_24</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AssignDomainToField><field_name>Addition_Type</field_name><domain_name>RCL Addition Type</domain_name></AssignDomainToField></workflow></operationSequence>"
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.2.0'><WorkspaceConnectionString>DATABASE=C:\OneDrive\OneDrive - Cloudpoint Geospatial Inc\Projects\La Crosse County WI\400_GIS\402_Databases\20240108_LaCrosseCountyRCL\20240108_LaCrosseRCL_Review.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LaCrosseCounty_RCL_01_11_24</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Abbreviated Full St Name Calculation</rule_name><rule_description>Calculation rule populating ABFULLSTNM with concatenated values.</rule_description><error_number>0</error_number><exclude_from_client_eval>False</exclude_from_client_eval><severity>-1</severity><expression>// Project: WI NG911
// Layer: RoadCenterline
// Field: ABFULLSTNM
// Rule Type: Immediate Calculation
// Rule Name: Abbreviated Full St Name Calculation
// Description: Calculation rule populating ABFULLSTNM with concatenated values.
// Subtypes: All
// Error Number: NA
// Error Message: NA
// Severity: NA
// Trigger: Insert/Update
// Exclude From Client: False
// Disable: False
// Version: 1.1.0
// Status: PRODUCTION
// Notes:
// Initialize index counter and array variables
var i = 0;
var features = [];
// Add value to array if not empty or blank space
function addvalue(feat) {
if (IsEmpty(feat) || feat==' '){feat = Null}
else if (!IsEmpty(feat)) {
features[i++] = feat;
}
}
// Add your values
addvalue($feature['lst_predir']);
addvalue($feature['st_presep']);
addvalue($feature['lst_name']);
addvalue($feature['lst_type']);
addvalue($feature['lst_posdir']);
// Return a concatenated string
var vals = (Concatenate(features, " "));
// If an empty string or a string of blanks is returned, return null
// else return the concatenated FullRoadName string
if (IsEmpty(vals)) {return Null}
else {vals}</expression><category>0</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update></AlterAttributeRule></workflow></operationSequence>"
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.2.0'><WorkspaceConnectionString>DATABASE=D:\OneDrive - Cloudpoint Geospatial Inc\Projects\La Crosse County WI\400_GIS\402_Databases\20240108_LaCrosseCountyRCL\20240108_LaCrosseRCL_Review.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LaCrosseCounty_RCL_01_11_24</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><EnableEditorTracking><creator_field>created_user</creator_field><creation_date_field>created_date</creation_date_field><last_editor_field>last_edited_user</last_editor_field><last_edit_date_field>last_edited_date</last_edit_date_field><add_fields>TRUE</add_fields><record_dates_in>UTC</record_dates_in></EnableEditorTracking></workflow></operationSequence>
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.2.0'><WorkspaceConnectionString>DATABASE=D:\OneDrive - Cloudpoint Geospatial Inc\Projects\La Crosse County WI\400_GIS\402_Databases\20240108_LaCrosseCountyRCL\20240108_LaCrosseRCL_Review.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LaCrosseCounty_RCL_01_11_24</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><DeleteAttributeRule><rule_name>Legacy StPreDir Calculation</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow><workflow><DeleteAttributeRule><rule_name>Legacy St Type Calculation</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow><workflow><DeleteAttributeRule><rule_name>Legacy StPosDir Calculation</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow><workflow><DeleteAttributeRule><rule_name>Full St Name Calculation</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow><workflow><DeleteAttributeRule><rule_name>Abbreviated Full St Name Calculation</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow></operationSequence>"
CalculateField LaCrosseCounty_RCL_01_11_24 Lst_Edit_User 'BMENZEL' Python # Text NO_ENFORCE_DOMAINS
CalculateField LaCrosseCounty_RCL_01_11_24 Lst_Edit_Date !last_edited_date! Python # Text NO_ENFORCE_DOMAINS
CalculateField LaCrosseCounty_RCL_01_11_24 Lst_Edit_User 'BMENZEL' Python # Text NO_ENFORCE_DOMAINS
CalculateField LaCrosseCounty_RCL_01_11_24 Lst_Edit_Date !last_edited_date! Python # Text NO_ENFORCE_DOMAINS
CalculateField LaCrosseCounty_RCL_01_11_24 Creat_Nm 'BMENZEL' Python # Text NO_ENFORCE_DOMAINS
CalculateField LaCrosseCounty_RCL_01_11_24 Creat_Date !created_date! Python # Text NO_ENFORCE_DOMAINS
CalculateField LaCrosseCounty_RCL_01_11_24 Creat_Nm 'BMENZEL' Python # Text NO_ENFORCE_DOMAINS
CalculateField LaCrosseCounty_RCL_01_11_24 Creat_Date !created_date! Python # Text NO_ENFORCE_DOMAINS
CalculateField LaCrosseCounty_RCL_01_11_24 Lst_Edit_Date !last_edited_date! "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField LaCrosseCounty_RCL_01_11_24 Lst_Edit_User 'BMENZEL' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField LaCrosseCounty_RCL_01_11_24 Creat_Nm 'BMENZEL' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField LaCrosseCounty_RCL_01_11_24 Creat_Date !created_date! "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField LaCrosseCounty_RCL_01_11_24 Lst_Edit_Date !last_edited_date! "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField LaCrosseCounty_RCL_01_11_24 Lst_Edit_User 'BMENZEL' "Python 3" # 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=D:\OneDrive - Cloudpoint Geospatial Inc\Projects\La Crosse County WI\400_GIS\402_Databases\20240108_LaCrosseCountyRCL\20240108_LaCrosseRCL_Review.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LaCrosseCounty_RCL_01_11_24</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>RCL NENA GUID Calculation</rule_name><rule_description>Immediately calculates road centerline's NGUID on insert only.</rule_description><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression>// Project: WI NG911
// Layer: Road Centerlines
// Rule Type: Calculation
// Rule Name: RCL NENA GUID
// Description: Creates a new unique NENA compliant id when a road centerline point is created.
// Note: Must create the database sequence for NextSequenceValue to reference
// This rule will create a new unique id when a site address point is created
// Define the leading text and the delimiter for the ID
var prefix = "RCL"
var suffix = "@lacrossecounty.org"
var sequenceName = "ROAD_NGUID"
// Ensure the ID is not already set, if it is, return the original id
IIf((IsEmpty($feature.RCL_NGUID)),
(Concatenate([prefix, NextSequenceValue(sequenceName),suffix], "")),
$feature.RCL_NGUID);</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update></AlterAttributeRule></workflow></operationSequence>"
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=D:\OneDrive - Cloudpoint Geospatial Inc\Projects\La Crosse County WI\400_GIS\402_Databases\20240108_LaCrosseCountyRCL\20240108_LaCrosseRCL_Review.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LaCrosseCounty_RCL_01_11_24</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>Adjacent RCL Ranges Must Not Overlap</rule_name><rule_type>VALIDATION</rule_type><expression>// Project: WI NG911
// Layer: RoadCenterline
// Field: NA
// Rule Type: Validation
// Rule Name: Adjacent RCL Ranges Must Not Overlap
// Description: Checks Left and Right To/From for overlap with adjacent road.
// ErrorNumber: 301
// ErrorMessage: Range cannot overlap adjacent feature's range.
// Severity: 4
// Trigger: NA
// Exclude From Client: False
// Disable: False
// Version: 1.2.0
// Status: PRODUCTION
// Notes: polylines must be drawn in the from > to order correctly,
// polyline must be single part (only one line per row)
// Edited to add exclusion for comment "outside provisioning boundary" and certain road types
// Get first and last points from the feature.
var paths = Geometry($feature).paths;
var f_point = paths[0][0];
var l_point = paths[0][Count(paths[0]) - 1];
// Set line id
var globalid = $feature["globalid"];
// Set the lines range
var LL = $feature["fromaddr_l"];
var LU = $feature["toaddr_l"];
var RL = $feature["fromaddr_r"];
var RU = $feature["toaddr_r"];
// get the prefix info.
var PreL = $feature["adnumpre_l"];
var PreR = $feature["adnumpre_r"];
// Assign variable for Full Street Name value
var fullname = $feature["fullstnm"];
// If all values zero return true
if (LU == 0 && LL == 0 && RU == 0 && RL == 0) {
return true;
}
// If all null values return true
else if (
isempty(LU) &&
isempty(LL) &&
isempty(RU) &&
isempty(RL) &&
isempty(PreL) &&
isempty(PreR)
) {
return true;
} else {
// Create feature set
var fsRCL = FeatureSetByName(
$datastore,
"LaCrosseCounty_RCL_01_11_24",
[
"globalid",
"adnumpre_l",
"adnumpre_r",
"fromaddr_l",
"toaddr_l",
"fromaddr_r",
"toaddr_r",
"fullstnm",
],
false
);
// Filter it by fullname and remove current segment
// also the address Prefix must match
if (isempty(PreL) || isempty(PreR)) {
var fsRCLFilt = Filter(
fsRCL,
"fullstnm = @fullname and globalid <> @globalid and (adnumpre_l is null OR adnumpre_r is null)"
);
} else {
var fsRCLFilt = Filter(
fsRCL,
"fullstnm = @fullname and globalid <> @globalid and (adnumpre_l = @PreL OR adnumpre_r = @PreR)"
);
}
// Intersect the first point with the streets
var f_int = Intersects(fsRCLFilt, f_point);
// Count results
var f_cnt = Count(f_int);
// Intersect the last point with the streets
var l_int = Intersects(fsRCLFilt, l_point);
// Count results
var l_cnt = Count(l_int);
// If no streets returned
if (f_cnt == 0 && l_cnt == 0) {
return true;
}
// If more than one something is funky
else if (f_cnt > 1 || l_cnt > 1) {
return false;
}
// Start checking the ranges
else {
// Check first point
if (f_cnt == 1) {
for (var f in f_int) {
// Set the lines range
var fLU = f.toaddr_l;
var fRU = f.toaddr_r;
var fpreL = f.adnumpre_l;
var fpreR = f.adnumpre_r;
if (fLU > LL && fpreL == PreL) {
return false;
} else if (fRU > RL && fpreR == PreR) {
return false;
}
}
}
// Check last point
if (l_cnt == 1) {
for (var l in l_int) {
// Set the lines range
var lLL = l.fromaddr_l;
var lRL = l.fromaddr_r;
var lpreL = l.adnumpre_l;
var lpreR = l.adnumpre_r;
if (lLL < LU && lpreL == PreL) {
return false;
} else if (lRL < RU && lpreR == PreR) {
return false;
}
}
}
return true;
}
}</expression><is_editable>True</is_editable><triggering_events_insert>False</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><error_number>301</error_number><error_message>Range cannot overlap adjacent feature's range.</error_message><rule_description>Checks Left and Right To/From for overlap with adjacent road.</rule_description><exclude_from_client_eval>False</exclude_from_client_eval><batch>True</batch><severity>5</severity><category>-1</category></AddAttributeRule></workflow></operationSequence>"
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=D:\OneDrive - Cloudpoint Geospatial Inc\Projects\La Crosse County WI\400_GIS\402_Databases\20240108_LaCrosseCountyRCL\20240108_LaCrosseRCL_Review.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LaCrosseCounty_RCL_01_11_24</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Adjacent RCL Ranges Must Not Overlap</rule_name><rule_description>Checks Left and Right To/From for overlap with adjacent road.</rule_description><error_number>301</error_number><error_message>Range cannot overlap adjacent feature's range.</error_message><exclude_from_client_eval>False</exclude_from_client_eval><severity>5</severity><expression>// Project: WI NG911
// Layer: RoadCenterline
// Field: NA
// Rule Type: Validation
// Rule Name: Adjacent RCL Ranges Must Not Overlap
// Description: Checks Left and Right To/From for overlap with adjacent road.
// ErrorNumber: 301
// ErrorMessage: Range cannot overlap adjacent feature's range.
// Severity: 4
// Trigger: NA
// Exclude From Client: False
// Disable: False
// Version: 1.3.0
// Status: PRODUCTION
// Notes: Added custom error message to return the conflicting rcl_nguids
// Get first and last points from the feature.
var paths = Geometry($feature).paths;
var f_point = paths[0][0];
var l_point = paths[0][Count(paths[0]) - 1];
// Set line id
var globalid = $feature["globalid"];
var nguid = $feature["rcl_nguid"];
// Set the lines range
var LL = $feature["fromaddr_l"];
var LU = $feature["toaddr_l"];
var RL = $feature["fromaddr_r"];
var RU = $feature["toaddr_r"];
// get the prefix info.
var PreL = $feature["adnumpre_l"];
var PreR = $feature["adnumpre_r"];
// Assign variable for Full Street Name value
var fullname = $feature["fullstnm"];
// Initialize empty array to hold conflicting rcl nguids
var ids = [];
// If all values zero return true
if (LU == 0 && LL == 0 && RU == 0 && RL == 0) {
return true;
}
// If all null values return true
else if (
isempty(LU) &&
isempty(LL) &&
isempty(RU) &&
isempty(RL) &&
isempty(PreL) &&
isempty(PreR)
) {
return true;
} else {
// Create feature set
var fsRCL = FeatureSetByName(
$datastore,
"LacrosseCounty_RCL_01_11_24",
[
"globalid",
"rcl_nguid",
"adnumpre_l",
"adnumpre_r",
"fromaddr_l",
"toaddr_l",
"fromaddr_r",
"toaddr_r",
"fullstnm",
],
false
);
// Filter it by fullname and remove current segment
// also the address Prefix must match
if (isempty(PreL) || isempty(PreR)) {
var sql = "fullstnm = @fullname and globalid <> @globalid and (adnumpre_l is null OR adnumpre_r is null)";
} else {
var sql = "fullstnm = @fullname and globalid <> @globalid and (adnumpre_l = @PreL OR adnumpre_r = @PreR)";
}
// Create filtered feature set using sql expression
var fsRCLFilt = Filter(fsRCL, sql);
// Intersect the first point with the streets
var f_int = Intersects(fsRCLFilt, f_point);
// Count results
var f_cnt = Count(f_int);
// Intersect the last point with the streets
var l_int = Intersects(fsRCLFilt, l_point);
// Count results
var l_cnt = Count(l_int);
// If no streets returned
if (f_cnt == 0 && l_cnt == 0) {
return true;
}
// If more than one something is funky
else if (f_cnt > 1 || l_cnt > 1) {
return false;
}
// Start checking the ranges
else {
// Check first point
if (f_cnt == 1) {
for (var f in f_int) {
// Get the lines nguid
var fnguid = f.rcl_nguid;
// Set the lines range
var fLU = f.toaddr_l;
var fRU = f.toaddr_r;
var fpreL = f.adnumpre_l;
var fpreR = f.adnumpre_r;
if (fLU > LL && fpreL == PreL) {
// return false;
Push(ids, fnguid)
} else if (fRU > RL && fpreR == PreR) {
// return false;
Push(ids, fnguid)
}
}
}
// Check last point
if (l_cnt == 1) {
for (var l in l_int) {
// Get the lines nguid
var fnguid = f.rcl_nguild;
// Set the lines range
var lLL = l.fromaddr_l;
var lRL = l.fromaddr_r;
var lpreL = l.adnumpre_l;
var lpreR = l.adnumpre_r;
if (lLL < LU && lpreL == PreL) {
// return false;
Push(ids, fnguid)
} else if (lRL < RU && lpreR == PreR) {
// return false;
Push(ids, fnguid)
}
}
}
}
// If one or more rcl_nguids identified as conflicts,
// return a custom error message
// else return no error
if (Count(ids) > 0) {
return { "errorMessage": `(${Concatenate(ids, ", ")})` }
} else {
return true;
}
}</expression><category>4294967295</category><triggering_events_insert>False</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update></AlterAttributeRule></workflow></operationSequence>"
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=D:\OneDrive - Cloudpoint Geospatial Inc\Projects\La Crosse County WI\400_GIS\402_Databases\20240108_LaCrosseCountyRCL\20240108_LaCrosseRCL_Review.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LaCrosseCounty_RCL_01_11_24</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Adjacent RCL Ranges Must Not Overlap</rule_name><rule_description>Checks Left and Right To/From for overlap with adjacent road.</rule_description><error_number>301</error_number><error_message>Range cannot overlap adjacent feature's range.</error_message><exclude_from_client_eval>False</exclude_from_client_eval><severity>5</severity><expression>// Project: WI NG911
// Layer: RoadCenterline
// Field: NA
// Rule Type: Validation
// Rule Name: Adjacent RCL Ranges Must Not Overlap
// Description: Checks Left and Right To/From for overlap with adjacent road.
// ErrorNumber: 301
// ErrorMessage: Range cannot overlap adjacent feature's range.
// Severity: 4
// Trigger: NA
// Exclude From Client: False
// Disable: False
// Version: 1.2.0
// Status: PRODUCTION
// Notes: polylines must be drawn in the from > to order correctly,
// polyline must be single part (only one line per row)
// Edited to add exclusion for comment "outside provisioning boundary" and certain road types
// Get first and last points from the feature.
var paths = Geometry($feature).paths;
var f_point = paths[0][0];
var l_point = paths[0][Count(paths[0]) - 1];
// Set line id
var globalid = $feature["globalid"];
// Set the lines range
var LL = $feature["fromaddr_l"];
var LU = $feature["toaddr_l"];
var RL = $feature["fromaddr_r"];
var RU = $feature["toaddr_r"];
// get the prefix info.
var PreL = $feature["adnumpre_l"];
var PreR = $feature["adnumpre_r"];
// Assign variable for Full Street Name value
var fullname = $feature["fullstnm"];
// If all values zero return true
if (LU == 0 && LL == 0 && RU == 0 && RL == 0) {
return true;
}
// If all null values return true
else if (
isempty(LU) &&
isempty(LL) &&
isempty(RU) &&
isempty(RL) &&
isempty(PreL) &&
isempty(PreR)
) {
return true;
} else {
// Create feature set
var fsRCL = FeatureSetByName(
$datastore,
"LaCrosseCounty_RCL_01_11_24",
[
"globalid",
"adnumpre_l",
"adnumpre_r",
"fromaddr_l",
"toaddr_l",
"fromaddr_r",
"toaddr_r",
"fullstnm",
],
false
);
// Filter it by fullname and remove current segment
// also the address Prefix must match
if (isempty(PreL) || isempty(PreR)) {
var fsRCLFilt = Filter(
fsRCL,
"fullstnm = @fullname and globalid <> @globalid and (adnumpre_l is null OR adnumpre_r is null)"
);
} else {
var fsRCLFilt = Filter(
fsRCL,
"fullstnm = @fullname and globalid <> @globalid and (adnumpre_l = @PreL OR adnumpre_r = @PreR)"
);
}
// Intersect the first point with the streets
var f_int = Intersects(fsRCLFilt, f_point);
// Count results
var f_cnt = Count(f_int);
// Intersect the last point with the streets
var l_int = Intersects(fsRCLFilt, l_point);
// Count results
var l_cnt = Count(l_int);
// If no streets returned
if (f_cnt == 0 && l_cnt == 0) {
return true;
}
// If more than one something is funky
else if (f_cnt > 1 || l_cnt > 1) {
return false;
}
// Start checking the ranges
else {
// Check first point
if (f_cnt == 1) {
for (var f in f_int) {
// Set the lines range
var fLU = f.toaddr_l;
var fRU = f.toaddr_r;
var fpreL = f.adnumpre_l;
var fpreR = f.adnumpre_r;
if (fLU > LL && fpreL == PreL) {
return false;
} else if (fRU > RL && fpreR == PreR) {
return false;
}
}
}
// Check last point
if (l_cnt == 1) {
for (var l in l_int) {
// Set the lines range
var lLL = l.fromaddr_l;
var lRL = l.fromaddr_r;
var lpreL = l.adnumpre_l;
var lpreR = l.adnumpre_r;
if (lLL < LU && lpreL == PreL) {
return false;
} else if (lRL < RU && lpreR == PreR) {
return false;
}
}
}
return true;
}
}</expression><category>4294967295</category><triggering_events_insert>False</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update></AlterAttributeRule></workflow></operationSequence>"
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=D:\OneDrive - Cloudpoint Geospatial Inc\Projects\La Crosse County WI\400_GIS\402_Databases\20240108_LaCrosseCountyRCL\20240108_LaCrosseRCL_Review.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LaCrosseCounty_RCL_01_11_24</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>C_From_L</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><workflow><AddField><field_name>C_To_L</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><workflow><AddField><field_name>C_From_R</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><workflow><AddField><field_name>C_To_R</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 "LaCrosseCounty_RCL_01_11_24 selection" C_From_L ConcatenateFields(!AdNumPre_L!,str(!FromAddr_L!)) "Python 3" "# Joins two or more fields into a single string value
# More calculator examples at esriurl.com/CalculatorExamples
def ConcatenateFields(*args):
sep = ""
return sep.join([i for i in args if i])" Text NO_ENFORCE_DOMAINS
CalculateField "LaCrosseCounty_RCL_01_11_24 selection" C_To_L ConcatenateFields(!AdNumPre_L!,str(!ToAddr_L!)) "Python 3" "# Joins two or more fields into a single string value
# More calculator examples at esriurl.com/CalculatorExamples
def ConcatenateFields(*args):
sep = ""
return sep.join([i for i in args if i])" Text NO_ENFORCE_DOMAINS
CalculateField "LaCrosseCounty_RCL_01_11_24 selection" C_From_R ConcatenateFields(!AdNumPre_R!,str(!FromAddr_R!)) "Python 3" "# Joins two or more fields into a single string value
# More calculator examples at esriurl.com/CalculatorExamples
def ConcatenateFields(*args):
sep = ""
return sep.join([i for i in args if i])" Text NO_ENFORCE_DOMAINS
CalculateField "LaCrosseCounty_RCL_01_11_24 selection" C_To_R ConcatenateFields(!AdNumPre_R!,str(!ToAddr_R!)) "Python 3" "# Joins two or more fields into a single string value
# More calculator examples at esriurl.com/CalculatorExamples
def ConcatenateFields(*args):
sep = ""
return sep.join([i for i in args if i])" Text NO_ENFORCE_DOMAINS
CalculateField LaCrosseCounty_RCL_01_11_24 C_From_L ConcatenateFields(!AdNumPre_L!,str(!FromAddr_L!)) "Python 3" "# Joins two or more fields into a single string value
# More calculator examples at esriurl.com/CalculatorExamples
def ConcatenateFields(*args):
sep = ""
return sep.join([i for i in args if i])" Text NO_ENFORCE_DOMAINS
CalculateField LaCrosseCounty_RCL_01_11_24 C_To_L ConcatenateFields(!AdNumPre_L!,str(!ToAddr_L!)) "Python 3" "# Joins two or more fields into a single string value
# More calculator examples at esriurl.com/CalculatorExamples
def ConcatenateFields(*args):
sep = ""
return sep.join([i for i in args if i])" Text NO_ENFORCE_DOMAINS
CalculateField LaCrosseCounty_RCL_01_11_24 C_From_R ConcatenateFields(!AdNumPre_R!,str(!FromAddr_R!)) "Python 3" "# Joins two or more fields into a single string value
# More calculator examples at esriurl.com/CalculatorExamples
def ConcatenateFields(*args):
sep = ""
return sep.join([i for i in args if i])" Text NO_ENFORCE_DOMAINS
CalculateField LaCrosseCounty_RCL_01_11_24 C_To_R ConcatenateFields(!AdNumPre_R!,str(!ToAddr_R!)) "Python 3" "# Joins two or more fields into a single string value
# More calculator examples at esriurl.com/CalculatorExamples
def ConcatenateFields(*args):
sep = ""
return sep.join([i for i in args if i])" Text NO_ENFORCE_DOMAINS
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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'><FeatureDataset>TopologyCheck</FeatureDataset><WorkspaceConnectionString>DATABASE=D:\OneDrive - Cloudpoint Geospatial Inc\Projects\La Crosse County WI\400_GIS\402_Databases\20240108_LaCrosseCountyRCL\20240108_LaCrosseRCL_Review.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LaCrosseCounty_RCL_01_11_24</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>Edited</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>
ExportFeatures LaCrosseCounty_RCL_01_11_24 "D:\Users\dbishop\OneDrive - Cloudpoint Geospatial Inc\La Crosse County WI\600_Deliverables\20240215_RCL_Digitization\20240215_LaCrosseCounty_roadcenterline.shp" # NOT_USE_ALIAS "RCL_Addition "RCL_Addition" true true false 255 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,RCL_Addition,0,255;Addition_Type "Addition_Type" true true false 255 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,Addition_Type,0,255;External_NGuid "External NG Uniquie ID" true true false 36 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,External_NGuid,0,36;RCL_NGUID "Road Centerline NENA Globally Unique ID" true true false 254 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,RCL_NGUID,0,254;AdNumPre_L "Left Address Number Prefix" true true false 15 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,AdNumPre_L,0,15;FromAddr_L "Left FROM Address" true true false 4 Long 0 0,First,#,LaCrosseCounty_RCL_01_11_24,FromAddr_L,-1,-1;ToAddr_L "Left TO Address" true true false 4 Long 0 0,First,#,LaCrosseCounty_RCL_01_11_24,ToAddr_L,-1,-1;AdNumPre_R "Right Address Number Prefix" true true false 15 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,AdNumPre_R,0,15;FromAddr_R "Right FROM Address" true true false 4 Long 0 0,First,#,LaCrosseCounty_RCL_01_11_24,FromAddr_R,-1,-1;ToAddr_R "Right TO Address" true true false 4 Long 0 0,First,#,LaCrosseCounty_RCL_01_11_24,ToAddr_R,-1,-1;St_PreMod "Street Name Pre Modifier" true true false 15 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,St_PreMod,0,15;St_PreDir "Street Name Pre Directional" true true false 9 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,St_PreDir,0,9;St_PreType "Street Name Pre Type" true true false 50 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,St_PreType,0,50;St_PreSep "Stree Name Pre Type Separator" true true false 20 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,St_PreSep,0,20;St_Name "Street Name" true true false 60 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,St_Name,0,60;St_PosTyp "Street Name Post Type" true true false 50 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,St_PosTyp,0,50;St_PosDir "Street Name Post Directional" true true false 9 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,St_PosDir,0,9;St_PosMod "Street Name Post Modifier" true true false 25 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,St_PosMod,0,25;FullStNm "Full Street Name" true true false 245 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,FullStNm,0,245;abFullStNm "Abbreviated Full Street Name" true true false 150 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,abFullStNm,0,150;LSt_PreDir "Legacy Street Name Pre Directional" true true false 2 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,LSt_PreDir,0,2;LSt_Name "Legacy Street Name" true true false 75 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,LSt_Name,0,75;LSt_Type "Legacy Street Name Type" true true false 4 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,LSt_Type,0,4;LSt_PosDir "Legacy Street Name Post Directional" true true false 2 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,LSt_PosDir,0,2;PostCode_L "Postal Code Left" true true false 7 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,PostCode_L,0,7;PostCode_R "Postal Code Right" true true false 7 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,PostCode_R,0,7;PostComm_L "Postal Community Name Left" true true false 40 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,PostComm_L,0,40;PostComm_R "Postal Community Name Right" true true false 40 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,PostComm_R,0,40;CityCode_L "City Code Left" true true false 10 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,CityCode_L,0,10;CityCode_R "City Code Right" true true false 10 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,CityCode_R,0,10;Country_L "Country Left" true true false 2 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,Country_L,0,2;Country_R "Country Right" true true false 2 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,Country_R,0,2;State_L "State Left" true true false 2 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,State_L,0,2;State_R "State Right" true true false 2 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,State_R,0,2;County_L "County Left" true true false 40 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,County_L,0,40;County_R "County Right" true true false 40 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,County_R,0,40;CountyCode_L "County Code Left" true true false 5 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,CountyCode_L,0,5;CountyCode_R "County Code Right" true true false 5 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,CountyCode_R,0,5;IncMuni_L "Incorporated Municipality Left" true true false 100 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,IncMuni_L,0,100;IncMuni_R "Incorporated Municipality Right" true true false 100 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,IncMuni_R,0,100;UnincCom_L "Unincorporated Community Left" true true false 100 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,UnincCom_L,0,100;UnincCom_R "Unincorporated Community Right" true true false 100 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,UnincCom_R,0,100;NbrhdCom_L "Neighborhood Community Left" true true false 100 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,NbrhdCom_L,0,100;NbrhdCom_R "Neighborhood Community Right" true true false 100 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,NbrhdCom_R,0,100;AddCode_L "Additional Code Left" true true false 6 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,AddCode_L,0,6;AddCode_R "Additional Code Right" true true false 6 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,AddCode_R,0,6;OneWay "One-Way" true true false 2 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,OneWay,0,2;SpeedLimit "Speed Limit" true true false 2 Short 0 0,First,#,LaCrosseCounty_RCL_01_11_24,SpeedLimit,-1,-1;RdCode "Road Code" true true false 3 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,RdCode,0,3;RdClass "Road Class" true true false 30 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,RdClass,0,30;DiscrpAgID "Discrepancy Agency ID" true true false 75 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,DiscrpAgID,0,75;Parity_L "Parity Left" true true false 1 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,Parity_L,0,1;Parity_R "Parity Right" true true false 1 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,Parity_R,0,1;ESN_L "ESN Left" true true false 5 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,ESN_L,0,5;ESN_R "ESN Right" true true false 5 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,ESN_R,0,5;MSAGComm_L "MSAG Community Name Left" true true false 30 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,MSAGComm_L,0,30;MSAGComm_R "MSAG Community Name Right" true true false 30 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,MSAGComm_R,0,30;Valid_L "Validation Left" true true false 1 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,Valid_L,0,1;Valid_R "Validation Right" true true false 1 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,Valid_R,0,1;PsapID_L "PSAP ID Left" true true false 100 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,PsapID_L,0,100;PsapID_R "PSAP ID Right" true true false 100 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,PsapID_R,0,100;FrElev "From Elevation" true true false 2 Short 0 0,First,#,LaCrosseCounty_RCL_01_11_24,FrElev,-1,-1;ToElev "To Elevation" true true false 2 Short 0 0,First,#,LaCrosseCounty_RCL_01_11_24,ToElev,-1,-1;AltNmUS "Alternative Name US" true true false 255 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,AltNmUS,0,255;AltNmSt "Alternative Name State" true true false 255 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,AltNmSt,0,255;AltNmCo "Alternative Name County" true true false 255 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,AltNmCo,0,255;AltFlNm "Alternative Full Name" true true false 255 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,AltFlNm,0,255;DateUpdate "Date Updated" true true false 8 Date 0 0,First,#,LaCrosseCounty_RCL_01_11_24,DateUpdate,-1,-1;Effective "Effective Date" true true false 8 Date 0 0,First,#,LaCrosseCounty_RCL_01_11_24,Effective,-1,-1;Expire "Expiration Date" true true false 8 Date 0 0,First,#,LaCrosseCounty_RCL_01_11_24,Expire,-1,-1;Lst_Edit_User "Last Editor User" true true false 255 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,Lst_Edit_User,0,255;Lst_Edit_Date "Last Edit Date" true true false 8 Date 0 0,First,#,LaCrosseCounty_RCL_01_11_24,Lst_Edit_Date,-1,-1;Creat_Nm "Creator Name" true true false 255 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,Creat_Nm,0,255;Creat_Date "Created Date" true true false 8 Date 0 0,First,#,LaCrosseCounty_RCL_01_11_24,Creat_Date,-1,-1;Data_Source "Data Source" true true false 50 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,Data_Source,0,50;Status "Status" true true false 1 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,Status,0,1;Notes "Notes" true true false 255 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,Notes,0,255;GlobalID "GlobalID" false false true 38 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,GlobalID,-1,-1;created_user "created_user" false true false 255 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,created_user,0,255;created_date "created_date" false true false 8 Date 0 0,First,#,LaCrosseCounty_RCL_01_11_24,created_date,-1,-1;last_edited_user "last_edited_user" false true false 255 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,last_edited_user,0,255;last_edited_date "last_edited_date" false true false 8 Date 0 0,First,#,LaCrosseCounty_RCL_01_11_24,last_edited_date,-1,-1;HouseNumberPostfix "HouseNumberPostfix" true true false 10 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,HouseNumberPostfix,0,10;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,LaCrosseCounty_RCL_01_11_24,Shape_Length,-1,-1;VALIDATIONSTATUS "Validation status" false true true 2 Short 0 0,First,#,LaCrosseCounty_RCL_01_11_24,VALIDATIONSTATUS,-1,-1;C_From_L "C_From_L" true true false 255 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,C_From_L,0,255;C_To_L "C_To_L" true true false 255 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,C_To_L,0,255;C_From_R "C_From_R" true true false 255 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,C_From_R,0,255;C_To_R "C_To_R" true true false 255 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,C_To_R,0,255;Edited "Edited" true true false 255 Text 0 0,First,#,LaCrosseCounty_RCL_01_11_24,Edited,0,255" #
DeleteField 20240215_LaCrosseCounty_roadcenterline.shp VALIDATION;C_From_L;C_To_L;C_From_R;C_To_R;Edited "Delete Fields"
CopyFeatures O:\ESRISHAR\SharProjects\NG9-1-1\NG911_Grant_1\FinalDeliverables\20240215_RCL_Digitization\20240215_LaCrosseCounty_roadcenterline.shp M:\ESRISHAR\Geodatabases\NG911\NG911Geodatabase.gdb\T20240215_LaCrosseCounty_roadcenterline # # # #
Rename M:\ESRISHAR\Geodatabases\NG911\NG911Geodatabase.gdb\T20240215_LaCrosseCounty_roadcenterline M:\ESRISHAR\Geodatabases\NG911\NG911Geodatabase.gdb\Road_Centerlines_CS FeatureClass
Rename M:\ESRISHAR\Geodatabases\NG911\NG911Geodatabase.gdb\Road_Centerlines_CS M:\ESRISHAR\Geodatabases\NG911\NG911Geodatabase.gdb\Road_Centerlines_FinalCS FeatureClass
CopyMultiple "M:\ESRISHAR\Geodatabases\NG911\NG911Geodatabase.gdb\Road_Centerlines_FinalCS FeatureClass" C:\Users\arcgis\Documents\ArcGIS\Projects\MyProject\MyProject.gdb Road_Centerlines_FinalCS "Road_Centerlines_FinalCS FeatureClass Road_Centerlines_FinalCS #"
Rename C:\Users\arcgis\Documents\ArcGIS\Projects\MyProject\MyProject.gdb\Road_Centerlines_FinalCS C:\Users\arcgis\Documents\ArcGIS\Projects\MyProject\MyProject.gdb\RCL_NG911style FeatureClass
CopyMultiple "C:\Users\arcgis\Documents\ArcGIS\Projects\MyProject\MyProject.gdb\RCL_NG911style FeatureClass" "C:\Users\arcgis\Documents\ArcGIS\Projects\MyProject\PFU con on laxsql2016.sde\PARCELFABRICUSER.NG911" RCL_NG911style "RCL_NG911style FeatureClass PARCELFABRICUSER.RCL_NG911style #"
T20240215_LaCrosseCounty_roadcenterline
002
Server=laxsql2016; Service=sde:sqlserver:laxsql2016; Database=LAXVEC; User=ParcelFabricUser; Version=sde.DEFAULT
ArcSDE Connection
0.000
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
NAD_1983_StatePlane_Wisconsin_South_FIPS_4803_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.2.0'><WKT>PROJCS["NAD_1983_StatePlane_Wisconsin_South_FIPS_4803_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",-90.0],PARAMETER["Standard_Parallel_1",42.73333333333333],PARAMETER["Standard_Parallel_2",44.06666666666667],PARAMETER["Latitude_Of_Origin",42.0],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2289]]</WKT><XOrigin>-118121300</XOrigin><YOrigin>-97418300</YOrigin><XYScale>3048.0060960121918</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>102754</WKID><LatestWKID>2289</LatestWKID></ProjectedCoordinateSystem>
20240220
07070500
20240220
07070500
150000000
5000
ItemDescription
Microsoft Windows 10 Version 10.0 (Build 19045) ; Esri ArcGIS 13.2.0.49743
RCL_NG911style
This is the site road centerline (RCL) data for La Crosse County. The attributes were adopted from a combination of State NG911 (Next Generation 9-1-1) standards and the 9-1-1 CAD vendor, Central Square, schemas.
<div style='text-align:Left;'><div><div><p style='margin:0 0 0 0;'><span><span>La Crosse County adopted the NG911 Wisconsin state standard for road centerlines in 2022. La Crosse County is in the process of switching road types from legacy to new state standard types. The data has attribute names with "Legacy” fields, which is where past road type designations will be listed. These are referencing the way the data is/was in the Master Street Address Guide (MSAG) and may differ that what is currently and commonly used as the authoritative road centerline data. For example, when La Crosse County adopted the state NG 9-1-1 standards the road types such as County Highway may have previously been known as County Road or County Trunk. State Highway may have been known previously as State Road. The key field attribute information to be utilized for labeling by anyone downloading the data would be as follows.</span></span></p><p style='margin:0 0 0 0;'><span><span>FullStNm – Full Street Name Or abFullStNm – Abbreviated Full Street name</span></span></p><p style='margin:0 0 0 0;'><span><span>Info regarding the details of any of the other attribute fields that are not self-evident can be found at the Wisconsin State Next Generation 911 website included in the credits or through the La Crosse County Land Information Department staff by referencing the RCL, NG911 or the Central Square CAD product.</span></span></p><p style='margin:0 0 0 0;'><span /></p></div></div></div>
La Crosse County WI Zoning Planning and Land Information Department212 6th St N, Suite 1300La Crosse, WI 54601https://lacrossecounty.org/zoning 608-785-9722 Wisconsin Office of Emergency Communications: https://oec.wi.gov/https://oec.wi.gov/wp-content/library/2020/WI_NG911_GIS_Data_Standard_and_Best_Practices_FINAL.pdf Wisconsin Land Information Association (WLIA) standards https://www.wlia.org/wlia-standards
NG911
La Crosse County Wisconsin
Road Centerlines
<div style='text-align:Left;'><div><div><p style='margin:0 0 11 0;'><span><span>"LA CROSSE COUNTY ZONING, PLANNING & LAND INFORMATION</span></span></p><p style='margin:0 0 11 0;'><span><span> LEGAL NOTICES, DISCLAIMERS AND TERMS OF USE"</span></span></p><p style='margin:0 0 11 0;'><span><span>DISCLAIMER OF LIABILITY</span></span></p><p style='margin:0 0 11 0;'><span><span>Neither the County of La Crosse, Department of Zoning Planning & Land Information nor any of its employees shall be held liable for any improper or incorrect use of the information described and/or contained herein and assumes no responsibility for anyone's use of the information. In no event shall the County, Department or its employees be liable for any direct, indirect, incidental, special, exemplary, or consequential damages (including, but not limited to, procurement or substitute goods or services; loss of use, data, or profits; or business interruption) however caused and on any theory of liability, whether in contract, strict liability, or tort (including negligence or otherwise) arising in any way out of the use of this data, even if advised of the possibility of such damage. This disclaimer of liability applies to any damages or injury, including but not limited to those caused by any failure of performance, error, omission, interruption, deletion, defect, delay in operation or transmission, computer virus, communication line failure, theft or destruction or unauthorized access to, alteration of, or use of record, whether for breach of contract, tortious behavior, negligence or under any other cause of action. </span></span></p><p style='margin:0 0 11 0;'><span><span>DISCLAIMER OF WARRANTIES AND ACCURACY OF DATA</span></span></p><p style='margin:0 0 11 0;'><span>Although the data found or produced by this Department or its employees has been produced or processed from sources believed to be reliable, no warranty, expressed or implied, is made regarding accuracy, adequacy, completeness, legality, reliability, or usefulness of any information. This disclaimer applies to both isolated and aggregate uses of the information. The Zoning, Planning & Land Information Department provides this information on an "as is" basis. All warranties of any kind, express or implied, including but not limited to the implied warranties of merchantability, fitness for a particular purpose, freedom from contamination by computer viruses and non-infringement of proprietary rights are disclaimed. Changes may be periodically made to the information herein; these changes may or may not be incorporated in any new version of the publication. If you have obtained information from the Zoning & Land Information Department or from a source other than this Department, be aware that electronic data can be altered subsequent to original distribution. Data can also quickly become out-of-date. It is recommended that careful attention be paid to the contents of any data associated with a file, and that the originator of the data or information be contacted with any questions regarding appropriate use. </span></p></div></div></div>
File Geodatabase Feature Class
0.000
dataset
EPSG
5.3(9.0.0)
0
Simple
FALSE
0
TRUE
FALSE
T20240215_LaCrosseCounty_roadcenterline
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.
RCL_Additi
RCL_Additi
String
254
0
0
Addition_T
Addition_T
String
254
0
0
External_N
External_N
String
36
0
0
RCL_NGUID
RCL_NGUID
String
254
0
0
AdNumPre_L
AdNumPre_L
String
15
0
0
FromAddr_L
FromAddr_L
Integer
4
0
0
ToAddr_L
ToAddr_L
Integer
4
0
0
AdNumPre_R
AdNumPre_R
String
15
0
0
FromAddr_R
FromAddr_R
Integer
4
0
0
ToAddr_R
ToAddr_R
Integer
4
0
0
St_PreMod
St_PreMod
String
15
0
0
St_PreDir
St_PreDir
String
9
0
0
St_PreType
St_PreType
String
50
0
0
St_PreSep
St_PreSep
String
20
0
0
St_Name
St_Name
String
60
0
0
St_PosTyp
St_PosTyp
String
50
0
0
St_PosDir
St_PosDir
String
9
0
0
St_PosMod
St_PosMod
String
25
0
0
FullStNm
FullStNm
String
245
0
0
abFullStNm
abFullStNm
String
150
0
0
LSt_PreDir
LSt_PreDir
String
2
0
0
LSt_Name
LSt_Name
String
75
0
0
LSt_Type
LSt_Type
String
4
0
0
LSt_PosDir
LSt_PosDir
String
2
0
0
PostCode_L
PostCode_L
String
7
0
0
PostCode_R
PostCode_R
String
7
0
0
PostComm_L
PostComm_L
String
40
0
0
PostComm_R
PostComm_R
String
40
0
0
CityCode_L
CityCode_L
String
10
0
0
CityCode_R
CityCode_R
String
10
0
0
Country_L
Country_L
String
2
0
0
Country_R
Country_R
String
2
0
0
State_L
State_L
String
2
0
0
State_R
State_R
String
2
0
0
County_L
County_L
String
40
0
0
County_R
County_R
String
40
0
0
CountyCode
CountyCode
String
5
0
0
CountyCo_1
CountyCo_1
String
5
0
0
IncMuni_L
IncMuni_L
String
100
0
0
IncMuni_R
IncMuni_R
String
100
0
0
UnincCom_L
UnincCom_L
String
100
0
0
UnincCom_R
UnincCom_R
String
100
0
0
NbrhdCom_L
NbrhdCom_L
String
100
0
0
NbrhdCom_R
NbrhdCom_R
String
100
0
0
AddCode_L
AddCode_L
String
6
0
0
AddCode_R
AddCode_R
String
6
0
0
OneWay
OneWay
String
2
0
0
SpeedLimit
SpeedLimit
Integer
4
0
0
RdCode
RdCode
String
3
0
0
RdClass
RdClass
String
30
0
0
DateUpdate
DateUpdate
Date
8
0
0
Effective
Effective
Date
8
0
0
Expire
Expire
Date
8
0
0
DiscrpAgID
DiscrpAgID
String
75
0
0
Parity_L
Parity_L
String
1
0
0
Parity_R
Parity_R
String
1
0
0
ESN_L
ESN_L
String
5
0
0
ESN_R
ESN_R
String
5
0
0
MSAGComm_L
MSAGComm_L
String
30
0
0
MSAGComm_R
MSAGComm_R
String
30
0
0
Valid_L
Valid_L
String
1
0
0
Valid_R
Valid_R
String
1
0
0
PsapID_L
PsapID_L
String
100
0
0
PsapID_R
PsapID_R
String
100
0
0
FrElev
FrElev
Integer
4
0
0
ToElev
ToElev
Integer
4
0
0
AltNmUS
AltNmUS
String
254
0
0
AltNmSt
AltNmSt
String
254
0
0
AltNmCo
AltNmCo
String
254
0
0
AltFlNm
AltFlNm
String
254
0
0
Lst_Edit_U
Lst_Edit_U
String
254
0
0
Lst_Edit_D
Lst_Edit_D
Date
8
0
0
Creat_Nm
Creat_Nm
String
254
0
0
Creat_Date
Creat_Date
Date
8
0
0
Data_Sourc
Data_Sourc
String
50
0
0
Status
Status
String
1
0
0
Notes
Notes
String
254
0
0
GlobalID
GlobalID
String
38
0
0
created_us
created_us
String
254
0
0
created_da
created_da
Date
8
0
0
last_edite
last_edite
String
254
0
0
last_edi_1
last_edi_1
Date
8
0
0
HouseNumbe
HouseNumbe
String
10
0
0
Shape_Leng
Shape_Leng
Double
8
0
0
Shape_Length
Shape_Length
Double
8
0
0
Length of feature in internal units.
Esri
Positive real numbers that are automatically generated.
20240220
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwDnEjmu
rdGd4tq9Av3lrMnEs92kcILKTzmrSXAVCY/kyMcdan0eWKzvBNJ8xJwpI71ypWM1qSfY4VtPKEM4
utx6cKPwp9nHBaA/a4ZWYHIIHT3rd88yu0khVS4yAp4YdaoafeyXxxM6KrMVH4VmzXkSdxs629+7
lJGDEcbuM0W9q0ZME7nbj5dmCav3MGxEO3Cg4LDvVi3sWI8wgAMuQRyaDVRT3MOCNknktTBI0RPy
bx0qrf8Alw3DKVYgDAx0BrrYUj/eMsgJUd+9Z9zpcerD90pR88t2pESpaaGbaROII4/vkglecY4p
5kkiijRDjK4C1pJbLZQ7HIlKHA9veszVJXhu0LhDGBxjmqRHLZEdqv2WGZWY7yPlOOKZJdRyw7hO
Y5l425wDSPrc0h8sRIVx0xVJ1GA88YXPKkdKG7szbtsamnw3Oo/PIgMWcF261rjQrFYzH8qSdQ+7
vXP6VrMUDC2nfyYc5BHc1b1jWlRI5baYfPnIzmlY1hy8upLdCa3E9qrL8yj5gOtULiLdAI4pAVQZ
J7cVQXVZZiVYgucgHuDUc00ZgAWRwQMEN3NMhtFmGKVIDOJgOCRk1X/tGdQCuFCnIxx+dV/NzFsD
d6ga5kSKfyig2puwT0wRnr145oQQXMa39qzyyZcb0I6Hk/WpwsF9HtilEDgZIZsbjXPicRAB5WXb
2PJBq9HMkiLDK6LKw4o3HKMo76mml8NPbAKvKowwDZVhVKXVrll2k7RzlVGM1XOIONhkJyOuBmqs
eqTwt+7gRgfkY9Sme3PendbAoyl6Fx7t52Rpiz7egHYVs211bGRJI5BEQuGRxnJ9elc7DMY1LSAq
+cqG43LVhpll/eogA6FV9e1NrQS0djQuLyaaeVotxZ25b0FUwWkdQXJfd90d6q2Gv3Fkrk20Tuw+
VDnccg/y6VreH9csre4me7skdoxmNiuGLen4VJp7N9SW9gmtbhLeSPYxUEKrZ61fTT57G+thfwlI
ZBxk5z7Z7U648T2d1aTtc2QM5H7sjt6c1hzaxcXSL9snkkji+YKT+BxQtR6RN2R7UXZgCuoyeQc8
VBAiwzPPaSjjpvFYcl2CweFiDnBTOcVILqQW/nIu7BxjPTmjcp36l+8vJrqRIJWVQrYLdjWnpl7C
tjNbzvF5qAlWf5gR7Vmo8d1ZBpLfbcOTyp6en+NVFtJFfJUuwGeO1GxN3uaqYu4wXVQFBKEcVNZ6
Swn3XMixhkJjYc5PpUVhdGCBJJPLMSHlBy1W/wC3LO7nME6MsI+6SOc0DsuplXNxGjui+YueMe1W
rXVnWJYnY4QfI4OGH41cj0+Dabi4TzLckhWB+bBrOmis4blUhlzHnkEc4pBZrUcYbGaZ1a4cMx3K
XXofrWYZJSzdRgkcVrXEdrdKj+aqZwAvp9ary6XIkhCsMeuetO5L5jlDcq7t5bgY6Cr1tMJUKHDY
5IzWEYSsox82eRsOc05pCs2V3L7d66ZRTMFodbY3YsZQszF4CepPKZrXhgtfKkWKLGRlcfxVwpuX
MvzOQNvIHPP410Gm323ykkBCAcnNYzg0aQmtjpLJmFmkN0GYD5gADx7GtKOSOJFCLtHfnsazL29a
DTWuY0VnIGAehH0qvpmpTtECYD5T5G+QcA+grM6LpaGvNEmSsb/M46jHFJal7BjE6FkJ5YECmWzN
cCT5I4HjIO4Dr+FMlvo2k8y4QxRKQoYdCaAunqSmONZWPkjEjldx7cZqG7sLcosckeeeMYH/AOup
rp45JFjjfcVwyL2JI61SdpVkDMArDggHigW5g6jaiwn2khsHOMciq11cx3EQYHdKTjaBwFrZ1xtt
lkMSzEAgiuegQgM+3O0ZwTVJGE4pOxQvAzXcIjPzIC2PX6e4qise5oQsoxg790gPPrU17czSXqso
RIyQFZgSORnqDx9KbHEkpMe6QMrHzNp2An0yMZ/GpZ0QVo7DZBDDclpHXfKAE6qFXH3vY9adFPPu
AM8UqE8bTlgPU1agS2mgaKWORRgqIuiHP071E29w6Cac+YADufBAz1GOvHrTTt1JbU9LCtI0zrFC
8e8thsnt9KdNazKsltcBF+U9CcqMc/iRxT5bQpDtS5YFVxuKDp+GKqyXDtHHIMO8cmCDncPzJxnr
ntSYQ5be6SzwCGO0KXBMsjFdpAzhRxz0pq7jcJMEUsoyGj6g9geMGkuS0ypuYlgcojqODnJJOORz
1q+LgSQG0dY1jGCxxx+fWjcbcoqzKUtxIwVbiWVvn/eADGC3GMflSO096RNNHI8u4kmNlBJzySP5
VZmjWG3WFU3vIOpOQcniprScxREoCjuGV8HIAyeBzwBQxc9ot2KscTSOzkoAeN74XOO3oDTIftMg
MSEIj/f8s54PAB44P0qUJLLJu2AoeGcjB57HIP51owyQ2cas0KSuowd4zkdMUlpsN1F1MaIFUgSR
QWAIReWc4xkjp7n86fZvI10XV/3isMAHHHuPWr6/ZTfyziCNUKkMi8DjpjHb8aBaIlizhmHzHCtj
BHp7/rT2HKStqZ9zPItyxj28D5t5IBOfp/OhWaV0USAiQncVxhTnAPfI46VNtKlVBYhWxvZj8oI7
ccdKY6SIoWVjhXJcoT24H9fz5pJg7Xuhs4JkOSSN2U2Nzkemexqxa3QFoJHJjeRsKjAnHPr0xVhV
hKI6bH4yWKcg96S9+y3KLi3jBUZwE4J9cCghVk3ZjbG9uGvG3vjCliNpABzjA9Rjv71s6dcvDcMS
pkSRSNucYrJs/MjV2VguQFBB+8BnnPvV9JpFUBiC3bIHFFzOcrSsjbtlt4Um/dCLeOd3OBWVFaef
fSQyOgjHIkHSrUE0jlpJAWt9pVmxVKNlN0IVCsv+yaAcjcmt547CI2c/mGHIZR/GvrVYPBfRmbb5
cqjay7ev0qA3q2rI8WQASrKeMioJpXgn86NuGO5RuzigbmS3caW8aSPvVZMhflxlhTxJMyKYWk2Y
/u1ZhuLXU7GQXoIUAAMF+63rWQ+22cxJIWUHgqTVXHzpK5mGxtSWIB+QZDIcc1Tk055G3Bm9yR0r
dmTapYgKmMAd2qWMRyaa7OjxMrAFgM7qpTkjnOWltJY/mJDY5461ahuSqhSTuHfFX1GB+7G5j95v
Sq95bRbwFyH7lTV+0TVmK5PNeXE8aRtMWRegrRs9TeYC0nAMWf4Bg/54rBNu6L5iyHjqO4qSzu9k
oL5yDyy1PJfVFqTWtz0HcrtA8Y2BwMr3P1qgt4FnkSVHeIPknqtVoNUjihQPKyox64zxWpbW0Mtq
4j3eU+cbVz+tJwaOhVFIssbdvNlhZdpA2kdsVC7GQiJVU4ydx71Tt7eSynaOPLIxJKleQKV5VjZz
JNtJPyjGOKnkfYFOKRk65OJXjhAG5euKzbjEVrxjcQcn0p92ssly0iqxw2QcdRVC8l8yzuCVbOwn
pjj1+lUlbcyb53oZUkEUcMm5GELsrj5ssPwq5Aqvb7IjgZ3A9fxNUXUCWExK2ChYLI42vxgtnPWr
9sxSAom07cAkHhvxFQb1Fp2E3JDncxMkjA/IOmeMj3xVVZViiX7UGR0yFOOTzx+NWmVZNsRU4YZJ
Ud+eSBzgU35JpnhkQ/K4PlnuOx6fjQFnHUiYhpYy6neeclsg56cetWoJRZqYiwM1ySWyoGAMn8KS
a2aQMYyYscn0PpUSoJPNJUjJB+bBIHTH86CVJSV+iH24KbnALykDDP6CkuZTPOUMUeMcuRxmlMrK
n76f90o+XI2n6Af1qNhIJNz4Z9pGA+Bx+lBUbN3JpbWQMjf6tpFyWxyAe30rPjuQlxMpjSNkAHzL
ywHBxWxaaqEicIvmK2FBYHaOOnNUJRI8zHzGICY2AbcjrwT6H86AUnflZPaurkuk2FbAO7I5/ClY
zgBnbcxbgkYA9v5VEFHlgqhPqF6fiKmfLRiPDsp5PPII5/ycUMScZPUmhktpHGHImUkEN/Dz6VI9
xgNvTzFUZUAVSeN4X2yj5ASuc8jrjPc/WniJmZwGBVjkhQR+ANBPLFO7YPPDJsHkjfkHO7A+lMln
ml8soUQs+Qp747j071Y+WCFjKQSW6MuAvpmqc80ErYYAt1YEHjrycenNA42voiUCZYinIzx8vpnr
TGDqSxwzFgFI+XrVmEMApfJB6Ed/z5qG6keW7SIAEKDxnofXijqSpNO1i/AkKwBmJ3A9D+tWZFjQ
LIuSO4zVeELKQud+eFK1anlRNsWAMH5hQYrXViJO0rGNNwXHC+9QIsytLOoAKcH8anWUJcsY2GGH
UdqUjdiHJXsc9KBMjEzzKI2UnA4z2NSM4aJSy4K8EjuKnkQRSRbBlwMHFRXKsJcMUEZ6AEZoCzJJ
GKWymMfu26AHkfWo1tTMC6OACemaZaktgsuVzzjtWlHZFFwpVgecqaRSjzFSytRPMz3K7V24UngL
702R5VlFrBI7Kg5x396fK8lwxj37YVGSc9qiF5bRsTFGzbRw7jqe1UIjnljtpMctMPvfWoI4pJ2D
ycKOOKH82WYzyAIJDjGKmmJ+0bVxtUAgAcE0iSGdowhSPerBgAp7++ajNvCU3Of3p67R0+tWm2yy
kEjft6DtVby9oPl5cEYJHY002tgIULQuUYgxP029ver1lr0lnJ5SvJIg4BBI/I96qPHujwMl17VW
RljcHq2OeM4zWt+ZK44u2p1v/CTxsRIVLyxg7NwAPPrise8v5L29a5ZQoPbPSqEMYPQZ96lfaARn
B9KlpJlubY5jvz796yNRuUjjFuNuZCAd3QAnH4da1RIUiIAHzcc1l6ppyT7JHBVhgDb165H16Uk7
bjhq7FJvImMi3SLHCTjdCgJLLxhW6CtGCXBi8svgLklhjI+ucmseeBoruOSCSTZ5xPksuNp9fStG
3O0tIShaTO4Bhxz+lS9kdNr3LTvPJMgkkJmyQqsFweD+S/WkuCqzYV0dlO90Ugjp6nPHtWTfX6Sy
Fo5E80bkICZYADqD+Na0cBSy86aQKHUDaQASB60mtBbMVbnMGGfyy394flTbJZRM55C7d5DsGZie
uPX+dOZo5MRlR06Buue4FNheATBAWyG+6O2eP8aCeW0bCzlGkRg3zoR9wjCn6HrTJ4Y2RkYAENwQ
MYP16Um5vMkMa+WpfcGPJII64/PFCwt5i5eQOrdQB8xP86Vxxjaw6GIh12Kyn+JSSc/7WT1pZ4pT
CsjqBEMjc53IeOcA/wAX6VLbB1mU5IIbGCOw9akvXMrBWVSoOdrDqD/KmRzWnqVouVAik3AD5VwA
Rx3IFMLFm2liOBgyPnHPUKDyOKdFP9ml4kUqOAq849aW5t4tytsiRXIO89+e39aLFJ+/r1LDyNcQ
KGXbldy4PT0NVIJ5sM+woM8BWO1h3Oeo/MVYX94hDKAMkrxwBwf61UhjZpiXQoVOVweMH+dBMI7o
uSXPmwhioJVcg9j/AFqBYUeQZV1ZXZgHILKxHIPcnHf3qzbwOsbyTOXx1y2RyeMegpsqqwRoweBw
PQnk/hQ731Ki90ixHNItuVKnGPlDD5h6dKzVi86VpmePBUrwmDn8c81beeIxnI3ScbRnHPpVcMNq
mIbQGIYDr15+lFyYrS+1zY0mVsyOUG/O5c8kH645p6lZZGLZLZ796q6V+6nBWPgAEp19f8/hWzc2
6Pb4t0bex3N7UkRNe8zM8oi7+6uO2elal7p8v2a3niU7Cu0kdM1QVlRjubG0Y6d61rWSX7KD5olT
uD2oM9Ca0ZWto45IlJA5wMEYrNvLQwgykA7znGOlbFqiuSWyAON3SqV8l1JKYCz+X7gYNM0Ubxuy
lZJPHhzGPLBw2RWw6hSPLIKkZ65qS2iEVhhQFX+MP2NQPcQptEsjFsfwjikWoWW5iMBbwsCQJHHy
jdwfwp8dmrWaSShmdDwqd6hEHmiWRiWlGPmFWo5IbOAwM7GWT7zL1qjBkSMXvFMsTIkY57ikglhV
nbfIxPHI4A+lMVHknYHe0adcjrzTpx59p5ihgEOMDgf40gIntXtz5iuCSeMHqKktmaJpWjVBEvDg
9cfSnOIxp/3DJzkE9FqK1uBFN5skBKS8HJyCKAQwSqzoFyoLHPHaqVzFHJKRG+GJPzdM1rXdtIx8
6L7rj5dvYVRa22rvkByei7smmnbYTuija3Ygl8m4wkiHHJ6g+laKRxzurZI3Vm31mblA0aFZox8p
z1FXdK1ASQIoxvXhw3Y1q9VdCK167wXwjGEhAzvbnJqxZ6jbyuY3CC42kBXPH1HrWkc/M6rvmzwB
yDXF3E0sJIvUPmB3VbdCFYA8ghup56Cs0mzenZrzNo2DwXD3F1iS2zuRS4wpx39652bbHqQhjjNw
WOWEXb0Fblhez/aHtWDy24k8pvNPzqe/I4IqHXNMRJ1dJn8tY8wmNuSfQ46fWmtDW/QqiOOOykng
hMErHk7c4DfLjJ7d6eyPCXi8qWRcZEu4M449uMVX84R20EbJtdRhUlXcrc5LbiB0pkbeWYC0QlCg
l2LEZBHTacDH86VmUyyPKnjWJZCGQZfbzn8RViSYWyLIdhKjs33hg8Z7daktotyDeQileqr1B6ZF
MCMk6EuoY9dygKMdiO44qXYSldtEdozLEVifzYCcI7cY6HnGeBzV61m3QiVAe+GA4/DNRxq9sN8A
jAIy21SA3TjHb1J6VIiBEeRnAGRnPygevT/CjQhrm3LjTeVarI6AMxAGO+arTLJIjSDIRiBkkYXs
efSopbxXgVI2ZXALF2U856D8elWIkY275BQOp+VQML6cdKDOygrmS8xE6rGyhSTuVVLbR61atxI0
yxFWRcBVPPB9efbPFOSKWGbdI0aAr8wQABvTjvVpFim1BpyMKilnYN6DuOn/AOug2b6ojmgeGURo
AEK/L/ePPOPfFNSSOFmcRrsOOc8j3p9u24TCaMh3GSrgHknsef8AOabKpiUZkCyNzkH8yRjGPbFF
+xnonysuRsIlJWMlSvIPIAqisZKOqR4w20ozcL3P+NS2sTyQsxmOFBOCx6ev/wBao45ViuCqhApk
wBGeccZJ5x3xRfoOEXd2EiQvLtfL/wAShRnAA9RUyRSyLktsYHpu4z+VMe+uIZ3kgDKjDG7IBPPG
etTRRS3bYEkauuc7j0bt26+2KWhcr3uzX0q1kQB2iVUAwrZ59v61rTRKVO6QIrDJI4/Cuf0VZGuZ
LZnPlIoYZbI44yDjuc/lV7VyiEocs55wGOPrQZy0d2VryO2VUeJ8qTtI759at2CyupiwDGeQR2xU
dhamK3kklhUsF3DLDBqK0lkt3AUljKflAGRTM7dTVaQwBIjkhjz7VYmDG+jaRsbFGAB1o2CRQxBM
px1AqwGSFgl0rbnGECjJNNLQ0i7FO7dbm7h059qwygs7A/Mcfy6VX1O1gtLwxC58sBRgMpPFVVgu
mvXmtoWyrYwedvfqajvYdVe5LyQyuzDJIGaY5PS5JEJFAgKI3yZDetVZ4nmuAild7nDN2WtxPskk
fmnfuIwFyOKqSm1s0OFbnrjtUmNilZwsLho0dmjAw2DxmtCG1NuGWZo0gbsRyacL21giRkUbDw5H
X/8AXWfJMZvkJLLv+Ut6UBaxfNnbMMrIPLY5APFQxaWp2qZl2B853dKLmWKO1ARhgf3fWorFQiJu
yG78UA0F64tohEmCATkiqYjiuIyCTFKem44zV29D7nlMIKA9Sev4VnOYGYyyB2kBwEP+elAmWjp0
nkgGVAx5LDqR6Vg3dpJYakk3KLKMkHoTWtbq8twz3LGJQo6dvTin6lbLqdk6RttkgkG0nvVweoaM
it3bPmbiAO5OK5u+1GN71nEIZo2+SRhkj/61a9jcPcRy2/lo0iHBJ/nisDU4hb3XlgY9c+tbJdGC
bQQXNu6bW+STdvY45IrVs2gV4Y2gE0MvCgnJ57/T2rntvfOPpV3T52eVLcouc5Dhtp9hUSg1qjeN
RSVmTS28lnPJp+/ls/O4wFTn5QewqAuZQsLiTaUCM5bOSvQ+1W79J3uIxJFJJKD8qu2Qwxz061XM
m0zxtE8EZQbVkHD+2fxzWbVmaRfMi6j+UilnXcOioc//AFqnSTEEayYLnBBY/eGay4l+yWzLAwmk
z8zdVX2z6Gp/MfcFWKMBuJFR/mI5JUZ6damzBqLsmXIrlohjy94xgluSBzgfgKiYKFbzU3KRghTu
D0NcSJJ5LRtsjwDIBwD7+uM0tuq8nyhsbdkE8n0zjpR5kpbprUWAtFLx8o+8BknoOBVos99PLtZV
WJSzHkADOMc/nVa3lZHbbIk0vI4Bb5f6YxVSS7Mct1HJMFjONu4FdwI+770JXKaNQSedGkrONq4w
GHOPXNRtmfUSzE7WGSufp1HpVae7jm00C3QErgsFPJ9gKz4NQVL03AikG5l++3Kep96ai3sLRI6q
O1CFUVMKOCB1Puaq3CCW6dIgCY12se4FSW02oTB7lJFILsMjBDDPGPbFUka4+1XKGMhUX72wjj6d
6VrkRjZ3vqXWiaGyUB3JbBdup9qpW6ysZJxbBtvOeuc9M+nAqGz1RrTZIXjlBJ+RyRge9TvqUpkU
xRqRKx+SE4zjOc07WKSklZFmK3ilYsYgoP3jtxVGWSK3lcqWXaSRIQTu+lXYLu5khmgWIAKeWUFg
Rj1qJIreWAtM4Ew4RFySW+nakEFbVmj4WRJWnmhK+ayKCGOcZJzx2PFbNzDBFKJJW3OOB6EVieGZ
1nS6FqFMxkLOSMEjNdC1qzxxzPKnmK2Cp5xRaw3qN+3wPAPMRhGoIIC9Kfp99pTXSxsojijUlXI4
DU1oltbwFwsobkCQ4B/CtR7uCS0DfZ7cdmVU/KhaCsSnVLHYtvbL50rfe+XhaguZfJjVwvmrk7WA
5B9Paqgnt7O3eWJTvc8kdhWW2rTTXUuEYQRAkIDgE+pqrk+purKhtjcSjIAOT6//AKq5O7nmkuXe
Wd97HJAY8Vs2gP2cbSxjkBOxz0Pesa8gvY7lgsLODyGIpIctjZh3SjMiCJeoIbNFxaxTHJOV7npV
Kdj5iwwuScY2nvVsIzWio5wxGOlIwuQXItorhC8LELgjB4pzlHDSL92P+AL1+tV7qDy0DR729SDw
ajdJY1zIqhSMnBxQFmJt8+WNTjYckIvBz+NWp38l444sM44YMc/rVVOJ0mRGIK4H1pkE/ktNJjMm
7gkZPv8AhQNmxM0q20TKm6TqykZAFUPtMM1zsNsI2ORuwcipWu7lbYSOmACAcGqfmOytKygbGyW7
0hDWtpp9xDh4k+b5D8x/CqzyK0SQxhwu75sgfMfrVu3IgzOx27hkKO496QyNLKsQRMMODtAwKYjO
vIJLW7iuY7cnzIyHCkdRWZqaR6hbrcW0REyf6xQAMDHWuie2uEgdTGuB8wkU/drBeV7S+MsgUBlI
YDjNbwlcDCUkgZHy1LbwG4mO1jHtG7dtJx+VN81Ski4wrHIHoat6WB++lKlwhUbQcfrTnKyNIRvK
xLrenapbwxzTtuDJuSWNu1VI44rsbLaOHG1GcNIQcDjJz0PfivQNXhsLjQbadiiymEEIrY3dSR7D
rXCJKlrHG0UaCRcRv8g+Zex9c1nJ3WhrCPLoxsUqz3Dxxw4ZWA3K26NR3zU0bnzG8qGVIE3HdD82
Tg4LMSPQ/hUssDSTfaImRXCglSgP4+lQRxmGykhJ8xjKVDxnkMRwSPTrUXTNLWJFlEm0S3DMFjBd
YmGAnUZPTr2xT2hD2zSRxKqNje0abt4zznniozatHE9vGBGmB5juB830/WtGJFtoCiSBtx+92ov2
IldeZSitpbeJyPMS28wspCE5HGAM5x3rNk1G6u5GhWFnDuNoY4JOMc+/vmuq/tDZprBlL4PyEnaO
OPyrKeZ752kxuQhV/wBWFwOpK/Smn1Y1d6FFiI4wLCWRD5gjdAACPXgZP41elSyi0yZATHKCAGZM
leRweOv0pV0z7OHvICxl5LZQGrlvbW8iZnZ/LIBJfjJByCfX6UXs9BNxtqGiataw2q2ckiOAu8Th
Cqnnoc9xW5JfWoi3fa4kYDON3OPaub+wyPNK1tJmNhlkKgBuTyP89avW+mJ1aZolI3eXgZOOn0o3
ZLUUineanaX0LSCKTI+XMi4yCeo5z9eKviWzSxUJ5UrPg7sZUMT6HnscCsee2up5JEjkDJJjO4+/
H49aIbVILiJJD80W5QWTaW75J9qNCrdDVF9LLCkLKQwPLKuN47dzgY+tR6lb2clvHJDNJ5qsrHHD
OBxgE802MPc4UsFycoxUdPX2zSLaMscrfIqrwV52j3qdtR6LTYk0VHt55bpopIYlxEY/NGSDzuA/
z1rpxcxSyBYXKJjPPJH41i2K2tzbBCPLbruA4z3GO3NTEm1kVX3FRzkc5pvsZSk07k0ls11clhdY
A5J6H6Vq+QdkYQkoVwQG5rD8yNldkbAbt71pWm9II3V/nUgkYzSYRd2U7+JYG2bnJUjOTxg9qZ9l
lVvkQckNg8mt6aS2kgYzIHJPII6GqU8u6KY28O0quA4bJoBwQ2zuVuJAsgyYkOQPrnirAlFwqyox
UMOhzXOhjCyyRFw4OSTxmr0VzO0S4kOAMAAdKCVO2jI7I7r9gv3VTG6rEU5lMsEjljjCHoaq2c8U
UDqsREjjAANNtkbeyO5Qqd2887frQZ7k8U08JWAAcydW560t1KjXP7xdxB4G7imI0v2bzVXLCcMM
DrxUL20t25lhfgnBXdgj/GgByzyxynyjtUnutOukEUgUHc33tvYe5qMJdWkqq03yZ7tkCrFxbSlZ
rlGDbgAwB5A9aBh9oxGipzkEMAOtPkhIt4QfmUZZj2/GnJDA9nFOJRG2cFj60+KKCK3k868UiQYV
fX6UAhsWGKmZMlIi20DqOwqrbzRx3W+dCoxhFznFWLqL7NZsVPmNJ8q4OTg+pFRCJLeJfOCliPkj
AALH39KBsfuVDNGWJhwSB61Q1DSoLuJFj3qWBKEjOD6VbfY53t838O1MgKf61ZjaSVpYWYArHkAd
vxpp2dyTk4NJtpUO7zEdc7ge2Pao2sUs5JFZ8QSYcE8E/StW6nuYrqOcyNtlHTOMkdap3xcG3min
YRuxDCU7x9D7VrJpxKpSamipLH5ts0D3ClkI2srDp6Z9MU2As7CW1ido3O1zKMbecf061JsMrFgk
xMX+rKn5CQRgKOpOefypIjcC6YG2dwGOZlbkk/7Oemc5rG91Y67WdyvLL5KzOI2BRtodZOMfTvV2
1FmsMs80s1urOJAI0OAfWoERpZzDFITg7/MXdt9wBj9afH8twFLySSuTlFcEOccDg9PensLfS5am
jR/JbS2NyEGZImb5sHnIB7/41ds9MLwma+ZUAJYozY2j0rBUGGWKW4uEV4E3IYyN23sPfpyD+tW7
rVvtBjhMwYsOsiBVP5EHP509OgrPa5JcmKfzymPIAx5cgxs6dD+tRWZThYj/AKOkhCMzZwOeBn+t
OV2k3plN5ypWVyPM/wA9qgtbbyW2lTheQuxgP5duRnHak9dxqy0RqgTWRAYCSMjhQ33vYYqC5fzm
jDI2wn7hBAz7+mDU8Z8uEyzgG3J+UiTIz+QNNN+ixuEQuqkBjnn6YPPcUrGbeuiuTWrwQQgNl3Iw
ct6VEkyC584lnJH3BznHc04LAzqJ/wB3gHqMHPTp+lJIYEkUS7XI5B3hSBT0Ii3zWZMq27QSXSqF
cnAznAHtVSSBmJHms+Tyq4AwQM+/aobt7i6fYh8tSNyxrkM49M9MH2qxAqSRBkdyu7C7TuyBwOvO
RyOaTaLakveRLDtMbMwQFCNvXINRS3CNE6xvhcEM3QE+nv8ASmq5ljdYdx4yQMZB9D/9bNRxoDID
K24oScJnn3J9qBKOvM+hpQlGtioYnJyxI5DfSpIZZPN8pwWU8Y9qp2RdYmGHAZmLOOSDnjP4fWrw
XzfMYtubA56ZFBnPcaVSVmRNqEZ6nrWhZfuYWCksc/N7GqU1v5aAoseAO7EmprOCUH76knkjdnFD
FF26F13MoEb/AMXfpmo7nTL+yVJUz5ZP0q2IVkTLnbz8oPOBVq+s7q8t4Y5wojiXiRZM5H0pXNGr
oxBsvYftEqhcNt4OAaovI0DsgbjORg8VvPpkaQHylZ8ngZ4GawHs1jba6/N36nFMzkmgt7besYCO
HxnLDINX5o0tyss6DZKNjgHpVESSeUE3PHB2fGS1X9PktZx9jkLSKehIwR7igSRNd2Nva2DFW8xH
w+AelZ9pHuuQQxWCLoCeTVjVb8wv9nMYZNuMn8s1VJUxxSrwgX5jnvQOXkaF1AlxtktWXeT8yE8k
1VWNrWMzSkqwfaVJzkemKWEzfaVmMUuz2XrV6+uFSOMyRDe3YjOKQmzKnne8WOOOHy4VPHGck1Yk
aK2jELx5fP3sZOKf9slwhiRE9Ao498064lA2R3Cly3Vu4+lVcdyGG+BbCKcq2I1UZOPU1oJDay3H
nJJG0+MmPvVKXTpIwvlklcEsy9dvXH1qrv2sYoFMbMMEk849TSC5opaSwrM23eQd6A1LoxC3E6zA
OzDDjGc561RhmK4Ju02rxjBzW1p1qkgFxEwLAfMc9eaa3GrMy/EFmBFHHjHGVA/hz0rl5APs7RyE
gowbAPpXWatcOdRlkKLtB2jcM9K5vU/I81C+1GYcn0A9K00sJK8jOhuJiZ8KcBSw2nAyzd+3HFX9
GJa8ikIBYD98wG3Zx0xWcFd7V1Rto3NGjseAD7fXvU8Nw6QTq0pRFIUuh69jx3rPRM6ndqxa0u8W
x1KTFwpiCkr3xntVW6+1ywkBo2U8EA8nryKZZxje0irswAFJH3sfxZp9vfRRTOpwzF9qoe5Pp7U2
Rte25CLbaWSNEaRlCsRjjnPB+lTmXhnYEPuA2Ak/mTUwjV51Maqmx2JCjGTnke9Nug8rqEJVX+8V
XJGPap3HzPmsRzW89sshe3RgXVlXfxjpgjqafZSvbMywxuseSrq3KkD0z3znioIjKZI/3b/Pw0jA
k/UemK1IX32LWsy5YZbPQMc/n/8AroY9bajLu5We0VZLbGwhxtbHPp0pipEd52AscFz1znHU9a0L
S5U2wt5BGccA9f1rPO5rh1DjamTlxgdQevej0J0d0yVPs0GccP1OR0FIrRXPHDMfuj0qqwkhMkjJ
8zAEc4GPb17GnBYoXRt4OeDJ90Z9h601cXIl8LH3djHFIkcaq5cBiW5YYqxNHHHujhwsYO3bxx6n
p602dxHcqsTEsMEFlznPXHvioInulnkMqk5ztyRgDPOff2okKPNZFqzaI2zYKLkEAKMA1Vntxbzi
QTblfoBjA9R60+dVhmREl3K/AGzBBpZFCziNT+8KjIYAY564palaXv3NGG8JGxT+7ccAjv6mrVqS
rMGO4gEn0FNsbBRYqNyhs7mX06f5/Grcdo0bsm/Csp69qDF2vYreX5pMjEAE4IPB/Cn3FxHZ26JD
zuOd3tTBamKYeYxKj3qK6McuNqkpjqpoFqie1nZlVGdgrHJJPJq6+qCErGHfI4HPH41Qtwd6Ozoo
VSAvfFVZSZ7g9doHOKCr2RutIbh/OjdtnXHYmmiOJM/uiCTk49apW080c0aRj91gDBFXZ52EpGwE
jg0ilruYNvG7OsSZTI6sSefpXRJHbBC0kIaeLo6DArPsiYoPPQJJFux85+b/AOvWoJV8vJidS3Y0
2Qkc/f3he5m8pVbCBWLD36CmxK5tY54tpKE5QA/yNbElpYzuWYshxkkDqapR2kdtO0iyMVC5C5pg
1Ygg1OYykcFgMfewq1avLea9dZYVyVwGO7g1AssGoRsqwiOUfNkDrWj9piWJI+SgX5j6H2pCUbmX
LG/mGMqdsa8AnAz/AFprhmRM43OeCvOAK2JpLW+gjZB5TpkZ7ge9VZndIo4bdg7nq2OQKAsVUuJU
CANtRgAD1J57CpJ5CJSEhiLYyT1yO9RyLi43vNtdR90DHFOhaTznaK3Eisf4hyPpQIimggdgUHCg
Eqc4P4iomvZY2PlN9nVPuovU/jWl9gBuN0QeNlGcEjAq0LO3eJGmjDOTliq44FAKJVmbzIFlY73K
gmsXVMG0LooynOehrdvre4gjO10MRONoXoKwrnSpEjfJkLMOAx4xVxt1KbtojEtG+0sm8JIZJGLR
s43A4znjn0pBF9ptdsbYZgDIWOSvHLbQTntzTJEeTdaguLnny2wOgHTpVtI4pJUdysrquF3gZGOM
E9D9KiWjOuL5kQyNsQfu2cwrukZyUG3tjpTYUhuLtDNJ5oKbVUnDE4yMKOtSNAYreZtrliMMzsCM
ewpsVgkl4ALZRKpDLIJCnGOPwP8AShMma01GSyyvGRAYh5agu2NshbHOBnPHenabLEWlk8pYd+MB
1bBPrmmpDseSMkRpJLwBls9mwT+VSKlxNfPFGzpIRiPaRhAPXNUuwn3HEuybpopFZZAAPmAweCQC
Mfiab9oXzM5cFUYb3+ZgBn05NT7ZGjdnYKfmDFR1GCOh4/GqsLIJHZX/AHcobcFUY74B/IVK8h20
1LkEnmW4eKNmYKMkEZP5cUyQM6q0sMjKxJaLPzLjucZpWiMliYSrSRsQV4GT/hT0CGyRUVFdgVCZ
5B7inpYh3vccYgJY/Lkjk2DChFbCk8g8Zwe1WbUQxqrsNp5yX/iNUopzHMYUG5JMLHhf4ee3U9+T
UskzzIGLZCH5QAR06cdDS03CSk9Cx5bySlgQoAJywJ49QO1WJ1iaBz5+ZAQcMmFJ471Wivd8w+Uo
xXJYoF3f481beZktJHmiT5hjcR8x6dvrQS7p6mUtwks6rcyGJBhVdm4OOuMDBFWZEgF3hZfNViF3
RgZI/Ec/nVZlEm9UQq3ILgDGOpAHTFPSJpZFTBbhdpycDnrjtn0pGr7mzZRzAbGkPljkEjr/AJ9K
1LmRNhUylCVwBtLZ/KqduE0/eqksZCATgDnr/WtJRG0Qdmy/T6UHPJoyI0lk5Yu8Sd8YzTFhEgUL
gKMk5H6mrqxmKTewHlk4OTUk4MKusewxlPlx1PsadySmxij2iVVUuOWBNRLArFhFLhD1JNT/AOkJ
80uC6jhV7Cnq0cwYMWCAZO4dKBkltFMkqAlmKDjsPzoe6cSMBLAOedx5z+VRi9iWRUhYBTy3oPSm
yRrvO63BPqDjNA/Q0La1a3uuFAGehHAo1NpreFpd6EDJBIpbOa58sfaZEMsvLADpWVq9wkl7HAxy
kfLBR0NO4myG01GV5t8kG6IYDc849q0RfwxW8rmAlFHDdifSqDWzvLlWALHAUHk/4UXULQRfYY8O
zHcQWHy0XEhIbq0uXGFeF/8AZ6VoTW7/AGPyojuY45HYVlwLFFcoZCVOdo28ZPvWosBj1BpVUhdg
AweM0rji+5WhHzbZGZWzgEj71XIp905VCI3I5JXqKp6q5e7EUXms+ATgcfhVSOWZZDCsSmRuTvOC
Ka8wdkzVFjbq+95S7Mc1ZgcRkqke1APzrJgtZ53XzLxFbGdvcD3xV8Pb2tv5jTiUK33gcD6daLIa
HXl/bREKXxJ0OBVaXVdlsjxuXBbaeMcCqd60F7cGaKSHJ6Kev8qZHH5r+Xl4ucDIyv0x/Wi9iW2j
RN+J1KRZfA+f2rPmvGO5ZWKP2zQ1uLTLLcx+ajYwnO761NqFg88yyHABHPNCYtzA1WBfKjeJmW5J
GCD1NV5PPtBHBFAZA4+bjB3Vd8pTqax7j+6BYt2Fa7wRPbFZ9xUrhH9PQ1o0mhwm4nHlr2yXLhHj
ZuC7Z2n2FaNgv2S5Iu5Y5Cw+Ug4z3xzVe6glFzJ9rMiW6dHTgE+wqNSkbsJUCXCAvucbvkP8TDp0
9Ki+nmdNub0HNJZktNCZYxIcKdpIDHsPrUsiSv5SRboCFzI6ryp9KinSPPl+ajQcOERj8zccBhkd
KSPzHjkUbmLOCqswBOOgJI/rQ79ASWw1UniXyGd2Vfm3hMgJnJJqzaR3MtwVKK4Viq7eC4Ock0jK
LjerMfkw58pSB9CfQY5PetVdSjtbdEji+Z85bOeR1z34+lS7A3JbEU1v9khRGKhuyZxz71E9rsKr
MojjkA4x+RPpRNNE8plaVmaMZYgEjBPqeB+VMN4Dcw/amYxuCRgZ27eh9CB1o6iV7CoiQswild5F
TanqiDtVnCoUDFZSTlgvT6D3pyW6qpY7ZI3yFY8fe6H36elVprP7N5bRjbtYN8h5PbpmjzZN03ZM
t3Fqou1MAIZ8YDHODnr9KhtrWdmcyytgEb2c9TnoD6dDTJC8koznKkYRR83c456e9TMsjlUL+UCc
h+3TrggZ/wDrUJjs0tS6xt7eCSPCKWQgsapwWvkWKSiQeSzfKCeuBUCWM8gym4ohBLP1/D/9dWYS
ZYvIuC8apnLMvXn1/GmhbeZsg2b6cXjZmkCgbj1zjrT408yL5gQcbiM0kWnQQwKPMb5uc561bt7Y
K5jf97GV4BHI/Gk9NzJ2bKTxyXEG1W6fdqOOJ5IgWJZUBJzxzjitLEFtIqLkluQR0FOkRAwR5Fjj
fnzCcCkKxnQkg5dSWbhO5pLkyiN0kQcc8HGa0LKNLIyPIouCDlOcYrPuzM02WQIzHIC9fxpoaegy
KzDxAKFByS3PHHanEvLyI2bHBKnANW7VJkiY+Qh49cE1YjB2nKBDnpzSuGxn394sNwDsLZO3Ge1U
t0QuVcxkKDknGQTUtxEtvqRa+5Rvu7Dniovsm6cNbzHym6H0+tMRPdRI1wGhkZY2QuxXgVExhXZK
WLPIQdvPGPer0sG/T41QlfLyJAD1rOJkjjDrGMKSQ2en4UCI7iIx3KyNlwwLLj+EVopq8cu6NIXY
8fd6+9T2ZFxAZ5I1DouAW7j3rN+1eVK0fkKm8nLjuKA2JY5PsytK/mCeTOOclfwpsVw07lTCpdh1
aPBP41GFiLZleR2X+Id6kinlml8qOMxJyWbqxAoKXmWTbG1tZnyFLrjhsn6UkLo4a18mMRrz8xJx
9aqBo574uGkwuDgDsKZPczGGULFtaU9QOcUBew9onL+WqQqScggnBHtV+3tY1i824UxlR1B96z7W
xnnkj8xyEAwMGta6tJFshGI9yr8z4bmkJamXdwSPdmSALtYbg3HIpbq5wqySfeyF25qNjGuxmSZQ
Bgn0pLm3ilhjdH+TO4k9eKumtRPTYpWEK3Wq3G/sQD9K1WuIBczQuwba2EVRkCs/TCII5r9kOx5D
z6gVcgtoZhLMhKzEFmB9a22dyX2KOtwCSEGJgjAEEsoOQfwrFtoP3DxxM4VgVL5VSxx09lz2rR1b
7RFZRGBXkZn/AHgXqoqla2bq0gjhlMYBKs6nK59u/NZSR0U2rbhAsu9iAIsHaIwC4PTPP1yauSMy
OQ2xVJw25OVz+lVAHtDs3S+b8ihW4I9cVNIs88juoMr5G0LnnHeos2zTRCbB5jEQhW+/KwGCcduK
V7fbFG0e3CHaq46c5Pbn8aVQzyKCVfLAdwQOp5/SnT20sNuVSUSNnh8ncMnrQrg7dx0UdvIWeXhg
nOF6H8qWWA2+JSAd2GXHQHPY9f50i2sotVDq25T94dDUotZ57dxjhc7STkY9vSgV1uLDOsLDzQpO
fUruyev49aebm1uoXW4jj5J2EAgg1Xms3EZRgQJBuGWz36ZqaztSsOZFHTHy8A0LQUlF6kqJaW0S
HYkife2lcqD60y8nnuYlCEhkzwR+nX8fwp8OnzynBPyk8Ejpjnn8qTyp/tfkohwCQCBnv1P5mjUV
le63GtNKsBCJ8+OSuRz36U+3t4pFLTllbd6fL+tV4pZYrqUOQCP4F7DP608TyyyFGI29RtOSTTfY
aVlobFrG7KI4mCxpg7uoq9LfFV2ozMw4LNVKz2C38z7qquCAck1Ad9wx8s4QcBO9J67GOq3JrorN
IpG4+pXpSyMyFHY4H8IAyKjt7RGXDvtOelWWQQPswJATwvpQBag/1Al3FznkelN+ytcEuiAtjv2q
zBuEWfK59TSgutrvyQWOSBSC3UkawWGAzHPm4xgH0qmzXGclsE84Aqw88kjAhs5AXFPZTIciMjAx
1oE3fY5u9u1NyyyRtHIpODnrRbymaQL9oCbhnCrnH40UUxPc17xmt4U8pVfA/u53GswQ3V7ZvMEM
g7qo5AoopDtrYvaZuSPcls4jYcs3Tj61BetamQqYmZiN27tRRRcRUlDgiGJCZc8AnOPqanLJa3MR
YBZz98BuBRRTHcLWPzdVmhkJwwILKOgqW70sxzwr57NLKTwDwBRRQPqSxQNp1vNKXHmLyqlv6VI2
qk2SMJdjSg9V4oopCZUM8hPlSIJAxwR0H4Gs64UTTx2+xo4Wk2uqnnFFFXD4hdLl2SBbazETqVjJ
2xg9M9M1EysL/aSGQDLMp6UUVuthMWR1uGYkARJgMOhNEsAe4VYnCggAL0IFFFYSepS2CQSOgQqF
kPK8ZOPSp4bdCI45CQB8xO39KKKkdrluGxiWfMYV4jgYJwaG02C2k8yQjaT8oBzRRSBK6JHmhlJD
o3lr/EOKptEjSSxKxCyDK54oooBbkJkUSCZUA2koQeg96abeZ2jjEZG45Y0UUyjRaZoIBDHLCHB6
NVN/tUxy4Cxg5JWiigUhqWolXcuxhu52HFItt5kkn7vDAHa3TGKKKVybsbFzO3lkkKv3j3x/OrCE
582IgOMEx55oopjWpL9sI+SRR5uec4GKnjh8+MTghZQMe3WiigF1LECSRQAhw4Pr600hnO07hnii
ipYdSKIFDIjZLA4GKkWaUZBt2bB67qKKBLRn/9k=