20190215
15121800
1.0
FALSE
ssManhole
002
Server=GIS-SVR_SQLEXPRESS; Service=sde:sqlserver:GIS-SVR\SQLEXPRESS; Database=Utilities; Version=dbo.DEFAULT
ArcSDE Connection
2307855.713500
2350925.231500
2200247.662000
2220559.440000
1
CalculateField HydraManholes Hydra_SyName "0" VB #
CalculateField HydraManholes SY_NAME [Hydra_SyName] VB #
CalculateField HydraManholes SY_NAME [Hydra_SyName] VB #
CalculateField HydraManholes SY_NAME 0 VB #
CalculateField HydraManholes ProjectSubdivision [SY_LATERAL] VB #
CalculateField HydraManholes YearInstalled 2010 VB #
AddField "Database Servers\192.168.10.5_SQLEXPRESS.gds\Utilities (VERSION:dbo.DEFAULT)\Utilities.DBO.SanitarySewer\Utilities.DBO.ssManhole" DropManhole_382695 TEXT 0 0 5 "Drop Manhole" NULLABLE NON_REQUIRED YesNo
AssignDomainToField "Database Servers\192.168.10.5_SQLEXPRESS.gds\Utilities (VERSION:dbo.DEFAULT)\Utilities.DBO.SanitarySewer\Utilities.DBO.ssManhole" DropManhole_382695 YesNo #
CalculateField "Database Servers\192.168.10.5_SQLEXPRESS.gds\Utilities (VERSION:dbo.DEFAULT)\Utilities.DBO.SanitarySewer\Utilities.DBO.ssManhole" DropManhole_382695 !DropManhole! PYTHON #
DeleteField "Database Servers\192.168.10.5_SQLEXPRESS.gds\Utilities (VERSION:dbo.DEFAULT)\Utilities.DBO.SanitarySewer\Utilities.DBO.ssManhole" DropManhole
AddField "Database Servers\192.168.10.5_SQLEXPRESS.gds\Utilities (VERSION:dbo.DEFAULT)\Utilities.DBO.SanitarySewer\Utilities.DBO.ssManhole" DropManhole TEXT 0 0 5 "Drop Manhole" NULLABLE NON_REQUIRED YesNo
AssignDomainToField "Database Servers\192.168.10.5_SQLEXPRESS.gds\Utilities (VERSION:dbo.DEFAULT)\Utilities.DBO.SanitarySewer\Utilities.DBO.ssManhole" DropManhole YesNo #
CalculateField "Database Servers\192.168.10.5_SQLEXPRESS.gds\Utilities (VERSION:dbo.DEFAULT)\Utilities.DBO.SanitarySewer\Utilities.DBO.ssManhole" DropManhole !DropManhole_382695! PYTHON #
DeleteField "Database Servers\192.168.10.5_SQLEXPRESS.gds\Utilities (VERSION:dbo.DEFAULT)\Utilities.DBO.SanitarySewer\Utilities.DBO.ssManhole" DropManhole_382695
FeatureClassToFeatureClass "Database Servers\192.168.10.5_SQLEXPRESS.gds\Utilities (VERSION:dbo.DEFAULT)\Utilities.DBO.SanitarySewer\Utilities.DBO.ssManhole" "Database Servers\192.168.10.5_SQLEXPRESS.gds\Utilities (VERSION:dbo.DEFAULT)\Utilities.DBO.SanitarySewer" ssManhole0 # "FacilityId "Manhole Number" true true false 2 Short 0 5 ,First,#,Database Servers\192.168.10.5_SQLEXPRESS.gds\Utilities (VERSION:dbo.DEFAULT)\Utilities.DBO.SanitarySewer\Utilities.DBO.ssManhole,FacilityId,-1,-1;SY_LENGTH "SY_LENGTH" true true false 8 Double 8 38 ,First,#,Database Servers\192.168.10.5_SQLEXPRESS.gds\Utilities (VERSION:dbo.DEFAULT)\Utilities.DBO.SanitarySewer\Utilities.DBO.ssManhole,SY_LENGTH,-1,-1;SY_TYPE "SY_TYPE" true true false 3 Text 0 0 ,First,#,Database Servers\192.168.10.5_SQLEXPRESS.gds\Utilities (VERSION:dbo.DEFAULT)\Utilities.DBO.SanitarySewer\Utilities.DBO.ssManhole,SY_TYPE,-1,-1;SY_SIZE "SY_SIZE" true true false 8 Double 8 38 ,First,#,Database Servers\192.168.10.5_SQLEXPRESS.gds\Utilities (VERSION:dbo.DEFAULT)\Utilities.DBO.SanitarySewer\Utilities.DBO.ssManhole,SY_SIZE,-1,-1;SY_INVUP "SY_INVUP" true true false 8 Double 8 38 ,First,#,Database Servers\192.168.10.5_SQLEXPRESS.gds\Utilities (VERSION:dbo.DEFAULT)\Utilities.DBO.SanitarySewer\Utilities.DBO.ssManhole,SY_INVUP,-1,-1;SY_INVDN "SY_INVDN" true true false 8 Double 8 38 ,First,#,Database Servers\192.168.10.5_SQLEXPRESS.gds\Utilities (VERSION:dbo.DEFAULT)\Utilities.DBO.SanitarySewer\Utilities.DBO.ssManhole,SY_INVDN,-1,-1;SY_SLOPE "SY_SLOPE" true true false 8 Double 8 38 ,First,#,Database Servers\192.168.10.5_SQLEXPRESS.gds\Utilities (VERSION:dbo.DEFAULT)\Utilities.DBO.SanitarySewer\Utilities.DBO.ssManhole,SY_SLOPE,-1,-1;SY_GRUP "SY_GRUP" true true false 8 Double 8 38 ,First,#,Database Servers\192.168.10.5_SQLEXPRESS.gds\Utilities (VERSION:dbo.DEFAULT)\Utilities.DBO.SanitarySewer\Utilities.DBO.ssManhole,SY_GRUP,-1,-1;SY_GRDN "SY_GRDN" true true false 8 Double 8 38 ,First,#,Database Servers\192.168.10.5_SQLEXPRESS.gds\Utilities (VERSION:dbo.DEFAULT)\Utilities.DBO.SanitarySewer\Utilities.DBO.ssManhole,SY_GRDN,-1,-1;SY_LATERAL "SY_LATERAL" true true false 64 Text 0 0 ,First,#,Database Servers\192.168.10.5_SQLEXPRESS.gds\Utilities (VERSION:dbo.DEFAULT)\Utilities.DBO.SanitarySewer\Utilities.DBO.ssManhole,SY_LATERAL,-1,-1;Hydra_SyName "Hydra_SyName" true true false 55 Text 0 0 ,First,#,Database Servers\192.168.10.5_SQLEXPRESS.gds\Utilities (VERSION:dbo.DEFAULT)\Utilities.DBO.SanitarySewer\Utilities.DBO.ssManhole,Hydra_SyName,-1,-1;RimElevation "Rim Elevation" true true false 8 Double 8 38 ,First,#,Database Servers\192.168.10.5_SQLEXPRESS.gds\Utilities (VERSION:dbo.DEFAULT)\Utilities.DBO.SanitarySewer\Utilities.DBO.ssManhole,RimElevation,-1,-1;NInvertElev "N. Invert Elevation" true true false 8 Double 8 38 ,First,#,Database Servers\192.168.10.5_SQLEXPRESS.gds\Utilities (VERSION:dbo.DEFAULT)\Utilities.DBO.SanitarySewer\Utilities.DBO.ssManhole,NInvertElev,-1,-1;SInvertElev "S. Invert Elevation" true true false 8 Double 8 38 ,First,#,Database Servers\192.168.10.5_SQLEXPRESS.gds\Utilities (VERSION:dbo.DEFAULT)\Utilities.DBO.SanitarySewer\Utilities.DBO.ssManhole,SInvertElev,-1,-1;WInvertElev "W. Invert Elevation" true true false 8 Double 8 38 ,First,#,Database Servers\192.168.10.5_SQLEXPRESS.gds\Utilities (VERSION:dbo.DEFAULT)\Utilities.DBO.SanitarySewer\Utilities.DBO.ssManhole,WInvertElev,-1,-1;EInvertElev "E. Invert Elevation" true true false 8 Double 8 38 ,First,#,Database Servers\192.168.10.5_SQLEXPRESS.gds\Utilities (VERSION:dbo.DEFAULT)\Utilities.DBO.SanitarySewer\Utilities.DBO.ssManhole,EInvertElev,-1,-1;Location "Location" true true false 100 Text 0 0 ,First,#,Database Servers\192.168.10.5_SQLEXPRESS.gds\Utilities (VERSION:dbo.DEFAULT)\Utilities.DBO.SanitarySewer\Utilities.DBO.ssManhole,Location,-1,-1;YearInstalled "Year Installed" true true false 2 Short 0 5 ,First,#,Database Servers\192.168.10.5_SQLEXPRESS.gds\Utilities (VERSION:dbo.DEFAULT)\Utilities.DBO.SanitarySewer\Utilities.DBO.ssManhole,YearInstalled,-1,-1;ProjectSubdivision "Project or Subdivision" true true false 190 Text 0 0 ,First,#,Database Servers\192.168.10.5_SQLEXPRESS.gds\Utilities (VERSION:dbo.DEFAULT)\Utilities.DBO.SanitarySewer\Utilities.DBO.ssManhole,ProjectSubdivision,-1,-1;DropManhole "Drop Manhole" true true false 5 Text 0 0 ,First,#,Database Servers\192.168.10.5_SQLEXPRESS.gds\Utilities (VERSION:dbo.DEFAULT)\Utilities.DBO.SanitarySewer\Utilities.DBO.ssManhole,DropManhole,-1,-1;VerticalDatum "Vertical Datum" true true false 50 Text 0 0 ,First,#,Database Servers\192.168.10.5_SQLEXPRESS.gds\Utilities (VERSION:dbo.DEFAULT)\Utilities.DBO.SanitarySewer\Utilities.DBO.ssManhole,VerticalDatum,-1,-1;LastEditor "Last Editor" true true false 20 Text 0 0 ,First,#,Database Servers\192.168.10.5_SQLEXPRESS.gds\Utilities (VERSION:dbo.DEFAULT)\Utilities.DBO.SanitarySewer\Utilities.DBO.ssManhole,LastEditor,-1,-1;UpdateDate "Update Date" true true false 36 Date 0 0 ,First,#,Database Servers\192.168.10.5_SQLEXPRESS.gds\Utilities (VERSION:dbo.DEFAULT)\Utilities.DBO.SanitarySewer\Utilities.DBO.ssManhole,UpdateDate,-1,-1;Comment "Comment" true true false 100 Text 0 0 ,First,#,Database Servers\192.168.10.5_SQLEXPRESS.gds\Utilities (VERSION:dbo.DEFAULT)\Utilities.DBO.SanitarySewer\Utilities.DBO.ssManhole,Comment,-1,-1" #
Rename "Database Servers\192.168.10.5_SQLEXPRESS.gds\Utilities (VERSION:dbo.DEFAULT)\Utilities.DBO.SanitarySewer\ssManhole0" "Database Servers\192.168.10.5_SQLEXPRESS.gds\Utilities (VERSION:dbo.DEFAULT)\Utilities.DBO.SanitarySewer\Utilities.DBO.ssManhole" FeatureClass
CalculateField Utilities.DBO.ssManhole SY_INVUP "[SY_INVUP] + 3.83" VB #
CalculateField Utilities.DBO.ssManhole SY_INVDN "[SY_INVDN] + 3.83" VB #
CalculateField Utilities.DBO.ssManhole SY_GRUP "[SY_GRUP] + 3.83" VB #
CalculateField Utilities.DBO.ssManhole SY_GRDN "[SY_GRDN] + 3.83" VB #
CalculateField Utilities.DBO.ssManhole RimElevation "[RimElevation] + 3.83" VB #
CalculateField Utilities.DBO.ssManhole NInvertElev "[NInvertElev] + 3.83" VB #
CalculateField Utilities.DBO.ssManhole SInvertElev "[SInvertElev] + 3.83" VB #
CalculateField Utilities.DBO.ssManhole WInvertElev "[WInvertElev] + 3.83" VB #
CalculateField Utilities.DBO.ssManhole EInvertElev "[EInvertElev] + 3.83" VB #
CalculateField Utilities.DBO.ssManhole RimElevation "[RimElevation] + 3.83" VB #
CalculateField Utilities.DBO.ssManhole SInvertElev "[SInvertElev] + 3.83" VB #
CalculateField Utilities.DBO.ssManhole RimElevation 2216.17
VB #
CalculateField Utilities.DBO.ssManhole RimElevation "2216.17 + 3.83
" VB #
CalculateField Utilities.DBO.ssManhole RimElevation "[SY_GRUP] " VB #
CalculateField Utilities.DBO.ssManhole Hydra_SyName [FacilityId] VB #
CalculateField Utilities.DBO.ssManhole NInvertElev "[NInvertElev] + 3.83" VB #
CalculateField Utilities.DBO.ssManhole SInvertElev "[SInvertElev] + 3.83" VB #
CalculateField Utilities.DBO.ssManhole SInvertElev "[SInvertElev] + 3.83" VB #
CalculateField Utilities.DBO.ssManhole WInvertElev "[WInvertElev] + 3.83" VB #
CalculateField Utilities.DBO.ssManhole WInvertElev "[WInvertElev] + 3.83" VB #
CalculateField Utilities.DBO.ssManhole EInvertElev "[EInvertElev] + 3.83" VB #
CalculateField Utilities.DBO.ssManhole WInvertElev "[WInvertElev] + 3.83" VB #
CalculateField Utilities.DBO.ssManhole EInvertElev "[EInvertElev] + 3.83" VB #
CalculateField Utilities.DBO.ssManhole RimElevation "[RimElevation] + 3.83" VB #
CalculateField Utilities.DBO.ssManhole WInvertElev "[WInvertElev] + 3.83" VB #
CalculateField Utilities.DBO.ssManhole EInvertElev "[EInvertElev] + 3.83" VB #
CalculateField Utilities.DBO.ssManhole RimElevation "[RimElevation] + 3.83" VB #
CalculateField Utilities.DBO.ssManhole WInvertElev "[WInvertElev] + 3.83" VB #
CalculateField Utilities.DBO.ssManhole EInvertElev "[EInvertElev] + 3.83" VB #
CalculateField Utilities.DBO.ssManhole RimElevation "[RimElevation] + 3.83" VB #
CalculateField Utilities.DBO.ssManhole NInvertElev "[NInvertElev] + 3.83" VB #
CalculateField Utilities.DBO.ssManhole WInvertElev "[EInvertElev] + 3.83" VB #
CalculateField Utilities.DBO.ssManhole EInvertElev "[EInvertElev] + 3.83" VB #
CalculateField Utilities.DBO.ssManhole RimElevation "[RimElevation] + 3.83" VB #
CalculateField Utilities.DBO.ssManhole RimElevation [SY_GRUP] VB #
CalculateField Utilities.DBO.ssManhole SInvertElev [SY_INVUP] VB #
CalculateField Utilities.DBO.ssManhole WInvertElev [SY_INVUP] VB #
CalculateField Utilities.DBO.ssManhole WInvertElev [SY_INVDN] VB #
CalculateField Utilities.DBO.ssManhole RimElevation [SY_GRDN] VB #
CalculateField Utilities.DBO.ssManhole EInvertElev [SY_INVUP] VB #
CalculateField Utilities.DBO.ssManhole Location [SY_INVDN] VB #
CalculateField Utilities.DBO.ssManhole RimElevation [SY_GRUP] VB #
CalculateField Utilities.DBO.ssManhole NInvertElev [SY_INVUP] VB #
CalculateField Utilities.DBO.ssManhole EInvertElev [SY_INVDN] VB #
CalculateField Utilities.DBO.ssManhole Hydra_SyName [FacilityId] VB #
CalculateField Utilities.DBO.ssManhole RimElevation [SY_GRUP] VB #
CalculateField Utilities.DBO.ssManhole Location "TRIUMPH AVENUE" VB #
CalculateField Utilities.DBO.ssManhole YearInstalled 2008 VB #
CalculateField Utilities.DBO.ssManhole ProjectSubdivision "LEGION MANOR (PLAN DATA)" VB #
CalculateField ssManhole LastEditor "RLF" VB #
CalculateField ssManhole FacilityId [Hydra_SyName] VB #
CalculateField Manholes Hydra_SyName [FacilityId] VB #
CalculateField Manholes ProjectSubdivision [SY_LATERAL] VB #
CalculateField Manholes RimElevation [SY_GRDN] VB #
CalculateField Manholes Hydra_SyName [FacilityId] VB #
CalculateField Manholes RimElevation [SY_GRUP] VB #
CalculateField Manholes ProjectSubdivision [SY_LATERAL] VB #
CalculateField Manholes YearInstalled 2007 VB #
CalculateField Manholes FacilityId autoIncrement() PYTHON_9.3 "rec=0 \ndef autoIncrement(): \n global rec \n pStart = 3294\n pInterval = 1 \n if (rec == 0): \n rec = pStart \n else: \n rec += pInterval \n return rec"
CalculateField Manholes Hydra_SyName autoIncrement() PYTHON_9.3 "rec=0 \ndef autoIncrement(): \n global rec \n pStart = 3295\n pInterval = 1 \n if (rec == 0): \n rec = pStart \n else: \n rec += pInterval \n return rec\n"
CalculateField Manholes FacilityId autoIncrement() PYTHON_9.3 "rec=0 \ndef autoIncrement(): \n global rec \n pStart = 3295\n pInterval = 1 \n if (rec == 0): \n rec = pStart \n else: \n rec += pInterval \n return rec\n"
CalculateField Manholes RimElevation !SY_GRUP! PYTHON_9.3 #
CalculateField Manholes ProjectSubdivision !SY_LATERAL! PYTHON_9.3 #
CalculateField Manholes ProjectSubdivision !SY_LATERAL! PYTHON_9.3 #
CalculateField Manholes RimElevation !SY_GRUP! PYTHON_9.3 #
CalculateField Manholes FacilityId autoIncrement() PYTHON_9.3 "rec=0 \ndef autoIncrement(): \n global rec \n pStart = 3303\n pInterval = 1 \n if (rec == 0): \n rec = pStart \n else: \n rec += pInterval \n return rec\n"
CalculateField Manholes Hydra_SyName 0 VB #
CalculateField Manholes ProjectSubdivision [SY_LATERAL] VB #
CalculateField Manholes Hydra_SyName [FacilityId] VB #
CalculateField Manholes RimElevation [SY_GRDN] VB #
CalculateField Manholes Hydra_SyName [FacilityId] VB #
CalculateField Manholes RimElevation [SY_GRUP] VB #
CalculateField Manholes RimElevation [SY_GRUP] VB #
CalculateField Manholes Location "CENTERLINE PARKING LOT" VB #
CalculateField Utilities.DBO.ssManhole LastEditor "RLF" VB #
CalculateField Utilities.DBO.ssManhole RimElevation [SY_GRUP] VB #
CalculateField Utilities.DBO.ssManhole RimElevation [SY_GRDN] VB #
CalculateField Utilities.DBO.ssManhole Location "Charleville Road" VB #
CalculateField Utilities.DBO.ssManhole YearInstalled 2017 VB #
CalculateField Utilities.DBO.ssManhole ProjectSubdivision "Tullamore 5th Addition" VB #
CalculateField Utilities.DBO.ssManhole LastEditor "RLF" VB #
CalculateField Utilities.DBO.ssManhole UpdateDate 11/06/2017 VB #
CalculateField "City Data\C-Manholes" Comment "Bust in asbuilts all inverts had an additional .46 ft to them to match adjoining data" VB #
DeleteField "Database Servers\GIS-SVR_SQLEXPRESS.gds\Utilities (VERSION:dbo.DEFAULT)\Utilities.DBO.SanitarySewer\Utilities.DBO.ssManhole" SY_LENGTH;SY_TYPE;SY_SIZE;SY_INVUP;SY_INVDN;SY_SLOPE;SY_GRUP;SY_GRDN;SY_LATERAL;Hydra_SyName
DeleteFeatures "Database Servers\GIS-SVR_SQLEXPRESS.gds\Utilities (VERSION:dbo.DEFAULT)\Utilities.DBO.SanitarySewer\Utilities.DBO.ssManhole"
DeleteField "Database Servers\GIS-SVR_SQLEXPRESS.gds\Utilities (VERSION:dbo.DEFAULT)\Utilities.DBO.SanitarySewer\Utilities.DBO.ssManhole" VerticalDatum
DeleteFeatures \\gis-svr\gis_shared\UtilityDataUpdate\WastewaterTest\WastewaterTest.gdb\SanitarySewer\ssManhole
AddField \\gis-svr\gis_shared\UtilityDataUpdate\WastewaterTest\WastewaterTest.gdb\SanitarySewer\ssManhole OutInvertElev DOUBLE # # # "Out Invert Elevation" NULLABLE NON_REQUIRED #
FeatureClassToFeatureClass \\gis-svr\gis_shared\UtilityDataUpdate\WastewaterTest\WastewaterTest.gdb\SanitarySewer\ssManhole \\gis-svr\gis_shared\UtilityDataUpdate\WastewaterTest\WastewaterTest.gdb\SanitarySewer ssManhole0 # "FacilityId "Manhole Number" true true false 255 Text 0 0 ,First,#,\\gis-svr\gis_shared\UtilityDataUpdate\WastewaterTest\WastewaterTest.gdb\SanitarySewer\ssManhole,FacilityId,-1,-1;RimElevation "Rim Elevation" true true false 8 Double 0 0 ,First,#,\\gis-svr\gis_shared\UtilityDataUpdate\WastewaterTest\WastewaterTest.gdb\SanitarySewer\ssManhole,RimElevation,-1,-1;NInvertElev "N. Invert Elevation" true true false 8 Double 0 0 ,First,#,\\gis-svr\gis_shared\UtilityDataUpdate\WastewaterTest\WastewaterTest.gdb\SanitarySewer\ssManhole,NInvertElev,-1,-1;SInvertElev "S. Invert Elevation" true true false 8 Double 0 0 ,First,#,\\gis-svr\gis_shared\UtilityDataUpdate\WastewaterTest\WastewaterTest.gdb\SanitarySewer\ssManhole,SInvertElev,-1,-1;WInvertElev "W. Invert Elevation" true true false 8 Double 0 0 ,First,#,\\gis-svr\gis_shared\UtilityDataUpdate\WastewaterTest\WastewaterTest.gdb\SanitarySewer\ssManhole,WInvertElev,-1,-1;EInvertElev "E. Invert Elevation" true true false 8 Double 0 0 ,First,#,\\gis-svr\gis_shared\UtilityDataUpdate\WastewaterTest\WastewaterTest.gdb\SanitarySewer\ssManhole,EInvertElev,-1,-1;OutInvertElev "Out Invert Elevation" true true false 8 Double 0 0 ,First,#,\\gis-svr\gis_shared\UtilityDataUpdate\WastewaterTest\WastewaterTest.gdb\SanitarySewer\ssManhole,OutInvertElev,-1,-1;DropManhole "Drop Manhole" true true false 5 Text 0 0 ,First,#,\\gis-svr\gis_shared\UtilityDataUpdate\WastewaterTest\WastewaterTest.gdb\SanitarySewer\ssManhole,DropManhole,-1,-1;ProjectSubdivision "Project or Subdivision" true true false 190 Text 0 0 ,First,#,\\gis-svr\gis_shared\UtilityDataUpdate\WastewaterTest\WastewaterTest.gdb\SanitarySewer\ssManhole,ProjectSubdivision,-1,-1;YearInstalled "Year Installed" true true false 4 Long 0 0 ,First,#,\\gis-svr\gis_shared\UtilityDataUpdate\WastewaterTest\WastewaterTest.gdb\SanitarySewer\ssManhole,YearInstalled,-1,-1;Location "Location" true true false 100 Text 0 0 ,First,#,\\gis-svr\gis_shared\UtilityDataUpdate\WastewaterTest\WastewaterTest.gdb\SanitarySewer\ssManhole,Location,-1,-1;LastEditor "Last Editor" true true false 20 Text 0 0 ,First,#,\\gis-svr\gis_shared\UtilityDataUpdate\WastewaterTest\WastewaterTest.gdb\SanitarySewer\ssManhole,LastEditor,-1,-1;UpdateDate "Update Date" true true false 8 Date 0 0 ,First,#,\\gis-svr\gis_shared\UtilityDataUpdate\WastewaterTest\WastewaterTest.gdb\SanitarySewer\ssManhole,UpdateDate,-1,-1;Comment "Comment" true true false 256 Text 0 0 ,First,#,\\gis-svr\gis_shared\UtilityDataUpdate\WastewaterTest\WastewaterTest.gdb\SanitarySewer\ssManhole,Comment,-1,-1" #
Rename \\gis-svr\gis_shared\UtilityDataUpdate\WastewaterTest\WastewaterTest.gdb\SanitarySewer\ssManhole0 \\gis-svr\gis_shared\UtilityDataUpdate\WastewaterTest\WastewaterTest.gdb\SanitarySewer\ssManhole FeatureClass
CalculateField ssManhole FacilityId ""MH"& [FacilityId]" VB #
CalculateField ssManhole FacilityId autoIncrement() PYTHON_9.3 "rec=0 \ndef autoIncrement(): \n global rec \n pStart = 3309\n pInterval = 1 \n if (rec == 0): \n rec = pStart \n else: \n rec += pInterval \n return rec\n"
CalculateField ssManhole FacilityId ""MH"& [FacilityId]" VB #
CalculateField ssManhole FacilityId ""MH" & [FacilityId]" VB #
AddField \\gis-svr\gis_shared\UtilityDataUpdate\WastewaterTest\WastewaterTest.gdb\SanitarySewer\ssManhole Temp TEXT # # # # NULLABLE NON_REQUIRED #
AddField ssManhole TempNum TEXT # # 12 "Manhole Number" NULLABLE NON_REQUIRED #
AddField \\gis-svr\gis_shared\UtilityDataUpdate\WastewaterTest\WastewaterTest.gdb\SanitarySewer\ssManhole TempNum TEXT # # 12 "Manhole Number" NULLABLE NON_REQUIRED #
AddField \\gis-svr\gis_shared\UtilityDataUpdate\WastewaterTest\Testing.gdb\SanitarySewer\ssManhole Testin TEXT # # 12 "Manhole Number" NULLABLE NON_REQUIRED #
CalculateField ssManhole Testin Left( [FacilityId],2 ) VB #
CalculateField ssManhole Testin "[Testin] & "-"" VB #
CalculateField ssManhole Testin "[Testin] & Right( [FacilityId],4 )" VB #
CalculateField ssManhole Testin Right( [FacilityId],4 ) VB #
CalculateField ssManhole Testin Replace( [Testin],"H","" ) VB #
CalculateField ssManhole Testin ""MH-"& [Testin]" VB #
DeleteField \\gis-svr\gis_shared\UtilityDataUpdate\WastewaterTest\Testing.gdb\SanitarySewer\ssManhole FacilityId
DeleteField \\gis-svr\gis_shared\UtilityDataUpdate\WastewaterTest\Testing.gdb\SanitarySewer\ssManhole FacilityId
CalculateField ssManhole FacilityId [Testin] VB #
DeleteField ssManhole Testin
CalculateField Sewer\Manholes ProjectSubdivision "NORTHERN PLAINS 2ND ADDITION" "Python 3" #
CalculateField Sewer\Manholes YearInstalled "2017" "Python 3" #
CalculateField Sewer\Manholes Location "Wheatland Ave" "Python 3" #
CalculateField Sewer\Manholes LastEditor "RLF" "Python 3" #
CalculateField Sewer\Manholes UpdateDate "02/20/2019" "Python 3" #
CalculateField Sewer\Utilities.DBO.ssManhole WInvertElev !EInvertElev! "Python 3" #
CalculateField Sewer\Utilities.DBO.ssManhole RimElevation "!RimElevation! - 3.83" "Python 3" # Text
CalculateField Sewer\Utilities.DBO.ssManhole NInvertElev "!NInvertElev! - 3.83" PYTHON3 # Text
CalculateField Sewer\Utilities.DBO.ssManhole SInvertElev "!SInvertElev! - 3.83" "Python 3" # Text
CalculateField Sewer\Utilities.DBO.ssManhole EInvertElev "!EInvertElev! - 3.83" "Python 3" # Text
CalculateField Sewer\Utilities.DBO.ssManhole RimElevation "!RimElevation! - 3.83" PYTHON3 # Text
CalculateField Sewer\Utilities.DBO.ssManhole NInvertElev "!NInvertElev! - 3.83" PYTHON3 # Text
CalculateField Sewer\Utilities.DBO.ssManhole SInvertElev "!SInvertElev! - 3.83" "Python 3" # Text
CalculateField Sewer\Utilities.DBO.ssManhole WInvertElev "!WInvertElev! - 3.83" "Python 3" # Text
CalculateField Sewer\Utilities.DBO.ssManhole EInvertElev "!EInvertElev! - 3.83" "Python 3" # Text
CalculateField Sewer\Utilities.DBO.ssManhole RimElevation "!RimElevation! - 3.83" PYTHON3 # Text
CalculateField Sewer\Utilities.DBO.ssManhole NInvertElev "!NInvertElev! - 4.33" PYTHON3 # Text
CalculateField Sewer\Utilities.DBO.ssManhole SInvertElev "!SInvertElev! - 4.33" "Python 3" # Text
CalculateField Sewer\Utilities.DBO.ssManhole WInvertElev "!WInvertElev! - 4.33" "Python 3" # Text
CalculateField Sewer\Utilities.DBO.ssManhole EInvertElev "!EInvertElev! - 4.33" "Python 3" # Text
CalculateField Sewer\Utilities.DBO.ssManhole NInvertElev "!NInvertElev! - 3.83" "Python 3" # Text
CalculateField Sewer\Utilities.DBO.ssManhole NInvertElev "!NInvertElev! - 3.83" PYTHON3 # Text
CalculateField Sewer\Utilities.DBO.ssManhole SInvertElev "!SInvertElev! - 3.83" PYTHON3 # Text
CalculateField Sewer\Utilities.DBO.ssManhole WInvertElev "!WInvertElev! - 3.83" PYTHON3 # Text
CalculateField Sewer\Utilities.DBO.ssManhole WInvertElev "!WInvertElev! + 3.83" "Python 3" # Text
CalculateField Sewer\Utilities.DBO.ssManhole EInvertElev "!EInvertElev! + 3.83" "Python 3" # Text
CalculateField Sewer\Utilities.DBO.ssManhole OutInvertElev "!OutInvertElev! + 3.83" "Python 3" # Text
CalculateField Sewer\Utilities.DBO.ssManhole RimElevation "!RimElevation! + 3.83" "Python 3" # Text
CalculateField Sewer\Utilities.DBO.ssManhole RimElevation "!RimElevation! + 3.83" "Python 3" # Text
CalculateField Sewer\Utilities.DBO.ssManhole NInvertElev "!NInvertElev! + 3.83" PYTHON3 # Text
CalculateField Sewer\Utilities.DBO.ssManhole SInvertElev "!SInvertElev! + 3.83" PYTHON3 # Text
CalculateField Sewer\Utilities.DBO.ssManhole OutInvertElev "!OutInvertElev! + 3.83" "Python 3" # Text
CalculateField "New Group Layer\Utilities.DBO.ssManhole" FacilityId autoIncrement() "Python 3" "rec=0 def autoIncrement(): global rec pStart = 3765
pInterval = 1 if (rec == 0): rec = pStart else: rec += pInterval return rec" Text
CalculateField "New Group Layer\Utilities.DBO.ssManhole" FacilityId ""MH-" + !FacilityId!" "Python 3" # Text
CalculateField "New Group Layer\Utilities.DBO.ssManhole" Location !Location!.replace("STREET", "ST") "Python 3" # Text
CalculateField "New Group Layer\Utilities.DBO.ssManhole" Location !Location!.replace("AVENUE", "AVE") "Python 3" # Text
CalculateField "New Group Layer\Utilities.DBO.ssManhole" Location !Location!.replace("DRIVE", "DR") "Python 3" # Text
CalculateField "New Group Layer\Utilities.DBO.ssManhole" Location !Location!.replace("LOOP", "LP") "Python 3" # Text
CalculateField "New Group Layer\Utilities.DBO.ssManhole" Location !Location!.replace("COURT", "CT") "Python 3" # Text
CalculateField "New Group Layer\Utilities.DBO.ssManhole" Location !Location!.replace("LANE", "LN") "Python 3" # Text
CalculateField "New Group Layer\Utilities.DBO.ssManhole" Location !Location!.replace("BOULAVARD", "BLVD") "Python 3" # Text
CalculateField "New Group Layer\Utilities.DBO.ssManhole" Location !Location!.replace("ROAD", "RD") "Python 3" # Text
CalculateField "New Group Layer\Utilities.DBO.ssManhole" Location !Location!.replace("PLACE", "PL") "Python 3" # Text
CalculateField "New Group Layer\Utilities.DBO.ssManhole" Location !Location!.replace("TRAIL", "TRL") "Python 3" # Text
CalculateField Sewer\Utilities.DBO.ssManhole FacilityId autoIncrement() "Python 3" "rec=0 def autoIncrement(): global rec pStart = 3774
pInterval = 1 if (rec == 0): rec = pStart else: rec += pInterval return rec" Text
CalculateField Sewer\Utilities.DBO.ssManhole FacilityId ""MH-" + !FacilityId!" "Python 3" # Text
CalculateField "Map Features\Sewer\Manhole" ProjectSubdivision !ProjectSubdivision!.title() "Python 3" # Text
CalculateField "Map Features\Sewer\Manhole" ProjectSubdivision !ProjectSubdivision!.title() "Python 3" # Text
CalculateField "Map Features\Sewer\Manhole" FacilityId autoIncrement() "Python 3" "rec=0 def autoIncrement(): global rec pStart = 1
pInterval = 1 if (rec == 0): rec = pStart else: rec += pInterval return rec" Text
CalculateField "Map Features\Sewer\Manhole" FacilityId ""MH" + !FacilityId!" "Python 3" # Text
CalculateField "Map Features\Sewer\Manhole" FacilityId autoIncrement() "Python 3" "rec=0 def autoIncrement(): global rec pStart = 1
pInterval = 1 if (rec == 0): rec = pStart else: rec += pInterval return rec" Text
CalculateField "Map Features\Sewer\Manhole" FacilityId ""MH-" + !FacilityId!" "Python 3" # Text
CalculateField Sewer\Utilities.DBO.ssManhole FacilityId autoIncrement() "Python 3" "rec=0 def autoIncrement(): global rec pStart = 3667
pInterval = 1 if (rec == 0): rec = pStart else: rec += pInterval return rec" Text
CalculateField Sewer\Utilities.DBO.ssManhole FacilityId autoIncrement() "Python 3" "rec=0 def autoIncrement(): global rec pStart = 3667
pInterval = 1 if (rec == 0): rec = pStart else: rec += pInterval return rec" Text
CalculateField Sewer\Utilities.DBO.ssManhole FacilityId ""MH-" + !FacilityId!" "Python 3" # Text
CalculateField Sewer\Utilities.DBO.ssManhole FacilityId autoIncrement() "Python 3" "rec=0 def autoIncrement(): global rec pStart = 3668
pInterval = 1 if (rec == 0): rec = pStart else: rec += pInterval return rec" Text
CalculateField Sewer\Utilities.DBO.ssManhole FacilityId ""MH" + "-" + !FacilityId!" "Python 3" # Text
CalculateField Sewer\Utilities.DBO.ssManhole NInvertElev "!NInvertElev! + 3.83" "Python 3" # Text
CalculateField Sewer\Utilities.DBO.ssManhole SInvertElev "!SInvertElev! + 3.83" "Python 3" # Text
CalculateField Sewer\Utilities.DBO.ssManhole WInvertElev "!WInvertElev! + 3.83" "Python 3" # Text
CalculateField Sewer\Utilities.DBO.ssManhole EInvertElev "!EInvertElev! + 3.83" "Python 3" # Text
CalculateField Sewer\Utilities.DBO.ssManhole OutInvertElev "!OutInvertElev! + 3.83" "Python 3" # Text
CalculateField Sewer\Utilities.DBO.ssManhole FacilityId autoIncrement() "Python 3" "rec=0 def autoIncrement(): global rec pStart = 3694
pInterval = 1 if (rec == 0): rec = pStart else: rec += pInterval return rec" Text
CalculateField Sewer\Utilities.DBO.ssManhole FacilityId ""MH-" + !FacilityId!" "Python 3" # Text
CalculateField Sewer\Utilities.DBO.ssManhole FacilityId autoIncrement() "Python 3" "rec=0 def autoIncrement(): global rec pStart = 3739
pInterval = 1 if (rec == 0): rec = pStart else: rec += pInterval return rec" Text NO_ENFORCE_DOMAINS
CalculateField Sewer\Utilities.DBO.ssManhole FacilityId ""MH-" + !FacilityId!" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Sewer\Utilities.DBO.ssManhole FacilityId autoIncrement() "Python 3" "rec=0 def autoIncrement(): global rec pStart = 3781
pInterval = 1 if (rec == 0): rec = pStart else: rec += pInterval return rec" Text NO_ENFORCE_DOMAINS
CalculateField Sewer\Utilities.DBO.ssManhole FacilityId ""MH-" + !FacilityId!" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Sewer\Utilities.DBO.ssManhole FacilityId autoIncrement() "Python 3" "rec=0 def autoIncrement(): global rec pStart = 3793
pInterval = 1 if (rec == 0): rec = pStart else: rec += pInterval return rec" Text NO_ENFORCE_DOMAINS
CalculateField Sewer\Utilities.DBO.ssManhole FacilityId ""MH-" + !FacilityId!" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Sewer\Utilities.DBO.ssManhole FacilityId autoIncrement() "Python 3" "rec=0 def autoIncrement(): global rec pStart = 3825
pInterval = 1 if (rec == 0): rec = pStart else: rec += pInterval return rec" Text NO_ENFORCE_DOMAINS
CalculateField Sewer\Utilities.DBO.ssManhole FacilityId ""MH-" + !FacilityId!" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Sewer\Utilities.DBO.ssManhole FacilityId autoIncrement() "Python 3" "rec=0 def autoIncrement(): global rec pStart = 3834
pInterval = 1 if (rec == 0): rec = pStart else: rec += pInterval return rec" Text NO_ENFORCE_DOMAINS
CalculateField Sewer\Utilities.DBO.ssManhole FacilityId ""MH-" + !FacilityId!" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Sewer\Utilities.DBO.ssManhole FacilityId autoIncrement() "Python 3" "rec=0 def autoIncrement(): global rec pStart = 3846
pInterval = 1 if (rec == 0): rec = pStart else: rec += pInterval return rec" Text NO_ENFORCE_DOMAINS
CalculateField Sewer\Utilities.DBO.ssManhole FacilityId ""MH-" + !FacilityId!" "Python 3" # 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/2.9.0'><FeatureDataset>Utilities.DBO.SanitarySewer</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=Utilities;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>Utilities.DBO.ssManhole</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>InspectionDate</field_name><field_type>DATE</field_type><field_precision>0</field_precision><field_alias>Inspection Date</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Condition</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>Asset Condition</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>"
AssignDomainToField C:\Users\bfolsom\AppData\Roaming\Esri\ArcGISPro\Favorites\Utilities.sde\Utilities.DBO.SanitarySewer\Utilities.DBO.ssManhole Condition AssetCondition #
CalculateField Sewer\Utilities.DBO.ssManhole FacilityId autoIncrement() "Python 3" "rec=0 def autoIncrement(): global rec pStart = 3852
pInterval = 1 if (rec == 0): rec = pStart else: rec += pInterval return rec" Text NO_ENFORCE_DOMAINS
CalculateField Sewer\Utilities.DBO.ssManhole FacilityId ""MH-" + !FacilityId!" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Sewer\Utilities.DBO.ssManhole FacilityId autoIncrement() "Python 3" "rec=0 def autoIncrement(): global rec pStart = 3881
pInterval = 1 if (rec == 0): rec = pStart else: rec += pInterval return rec" Text NO_ENFORCE_DOMAINS
CalculateField Sewer\Utilities.DBO.ssManhole FacilityId ""MH-" + !FacilityId!" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Sewer\Utilities.DBO.ssManhole FacilityId autoIncrement() "Python 3" "rec=0 def autoIncrement(): global rec pStart = 3915
pInterval = 1 if (rec == 0): rec = pStart else: rec += pInterval return rec" Text NO_ENFORCE_DOMAINS
CalculateField Sewer\Utilities.DBO.ssManhole FacilityId ""MH-" + !FacilityId!" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Sewer\Utilities.DBO.ssManhole FacilityId autoIncrement() "Python 3" "rec=0 def autoIncrement(): global rec pStart = 3920
pInterval = 1 if (rec == 0): rec = pStart else: rec += pInterval return rec" Text NO_ENFORCE_DOMAINS
CalculateField Sewer\Utilities.DBO.ssManhole FacilityId ""MH-" + !FacilityId!" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Sewer\Utilities.DBO.ssManhole FacilityId autoIncrement() "Python 3" "rec=0 def autoIncrement(): global rec pStart = 3939
pInterval = 1 if (rec == 0): rec = pStart else: rec += pInterval return rec" Text NO_ENFORCE_DOMAINS
CalculateField Sewer\Utilities.DBO.ssManhole FacilityId ""MH-" + !FacilityId!" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Sewer\Utilities.DBO.ssManhole FacilityId autoIncrement() "Python 3" "rec=0 def autoIncrement(): global rec pStart = 3950
pInterval = 1 if (rec == 0): rec = pStart else: rec += pInterval return rec" Text NO_ENFORCE_DOMAINS
CalculateField Sewer\Utilities.DBO.ssManhole FacilityId ""MH" + !FacilityId!" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Sewer\Utilities.DBO.ssManhole FacilityId autoIncrement() "Python 3" "rec=0 def autoIncrement(): global rec pStart = 3956
pInterval = 1 if (rec == 0): rec = pStart else: rec += pInterval return rec" Text NO_ENFORCE_DOMAINS
CalculateField Sewer\Utilities.DBO.ssManhole FacilityId ""MH-" + !FacilityId!" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Sewer\Utilities.DBO.ssManhole FacilityId autoIncrement() "Python 3" "rec=0 def autoIncrement(): global rec pStart = 3976
pInterval = 1 if (rec == 0): rec = pStart else: rec += pInterval return rec" Text NO_ENFORCE_DOMAINS
CalculateField Sewer\Utilities.DBO.ssManhole FacilityId ""MH-" + !FacilityId!" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Sewer\Utilities.DBO.ssManhole FacilityId autoIncrement() "Python 3" "rec=0 def autoIncrement(): global rec pStart = 3999
pInterval = 1 if (rec == 0): rec = pStart else: rec += pInterval return rec" Text NO_ENFORCE_DOMAINS
CalculateField Sewer\Utilities.DBO.ssManhole FacilityId ""MH-" + !FacilityId!" "Python 3" # Text NO_ENFORCE_DOMAINS
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
NAD_1983_StatePlane_Idaho_West_FIPS_1103_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/10.6'><WKT>PROJCS["NAD_1983_StatePlane_Idaho_West_FIPS_1103_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["Transverse_Mercator"],PARAMETER["False_Easting",2624666.666666666],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-115.75],PARAMETER["Scale_Factor",0.9999333333333333],PARAMETER["Latitude_Of_Origin",41.66666666666666],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2243]]</WKT><XOrigin>-15822600</XOrigin><YOrigin>-47951700</YOrigin><XYScale>2000</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102670</WKID><LatestWKID>2243</LatestWKID></ProjectedCoordinateSystem>
20190215
14435700
20190215
14435700
FGDC CSDGM Metadata
500000
5000
FGDC
Version 6.2 (Build 9200) ; Esri ArcGIS 10.6.1.9270
Manholes
1
-117.037885
-116.861652
47.752303
47.694800
For storing the location of sewer manholes in the City wastewater collection system.
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>For storing the location of sewer manholes in the City wastewater collection system. </SPAN><SPAN><SPAN>Manhole features connect two or more pipes and control the flow of water in the network.</SPAN></SPAN></P><P><SPAN /></P></DIV></DIV></DIV>
Post Falls
Sewer Manholes
File Geodatabase Feature Class
dataset
0
Simple
FALSE
0
TRUE
FALSE
ssManhole
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.
FacilityId
Manhole Number
String
255
0
0
For storing internal number of the asset
RimElevation
Rim Elevation
Double
8
0
0
Rim elevation
NInvertElev
N. Invert Elevation
Double
8
0
0
Elevation of pipe entering asset on the north if one exist
SInvertElev
S. Invert Elevation
Double
8
0
0
Elevation of pipe entering asset on the south if one exist
WInvertElev
W. Invert Elevation
Double
8
0
0
Elevation of pipe entering asset on the west if one exist
EInvertElev
E. Invert Elevation
Double
8
0
0
Elevation of pipe entering asset on the east if one exist
OutInvertElev
Out Invert Elevation
Double
8
0
0
Location
Location
String
100
0
0
General location of the asset
YearInstalled
Year Installed
Integer
4
0
0
Year installed or replace of asset
DropManhole
Drop Manhole
String
5
0
0
ProjectSubdivision
Project or Subdivision
String
190
0
0
Capital Improvement or Plat projectasset installed with
LastEditor
Last Editor
String
20
0
0
Last editor of Data
UpdateDate
Update Date
Date
8
0
0
Date asset Edited
Comment
Comment
String
256
0
0
20190215
EPSG
5.3(9.0.0)
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo
ooAKKKKACiiigAoopjOqIWYhVAySegFADqK87v8A4pWMd/Nb2UHmJE+w3DnCEge3OOa7fS74alpV
tehdvnRh8ZzjIrGFaE5OMXdodmXqKKK2EFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQA
UUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAJRVDVtVttHsJLy6bCLwB/ePpXCf8LIvWuLiOOwh
cYIhXzCCDjjJ7/pWFSvTptKTGk2djd+KtFsZnguL+MTJ95FBYj8hXNeMfGdkdBaDTbgTTXDCNsAr
hCCSeR7Y/GvKrpkFxPdTt5k0yMzlXK7CQcfgDTZr6W2hhnbEsiR5Ug7gfY+lebVx05JxilqWolOJ
Zbu6leztRHCQSgd8LheD+or2vwz4t0Oz8Kaal1fpFIlugdSrHBx9K8JlluEzczx+UkgLKhyOD3GP
fNasCpJpttpsXnSXCoVlBcbWHUY4yBj3rKjWdG8ktWNq59FafqtlqkZks7hZlHUgEfzq7Xl/wp1H
7VcahCUkVljQgOwO0DjHSvUa9ihUdSCkzNqzEqCS9tYX2SXMSN6M4BrjfiJ4lv8AQ7FEs3EHmLkz
lc8/3R6GvIItWvJtSa41CY3G85fe2CfSsK+MVJ8qV2NRufSX2mDyjL50fljq+8YH41E+p2CeXvvI
B5hwmZB8x9q+fIvEL2/h+908yShJ3RuXzt55FOsgpvoIYVe4jVQcSt/q8suSvv0/OsXmC0tHcfIf
RtFRQDFtEPRB1+lS16ZAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFF
FABRRRQByfxBa2XwtMJ03uzAQgDJ39q8jnlMkjIHjWVlJkyij5R2Bx1r1L4myNH4TYoF5lVdx6r9
PQ15ZZWd7rFtbxWkdzMIkdZiIyQgOcgHvXjY5OVVRiuhpHYp38IiuftE8byJvCPtOFGOnI46UyG3
iuXeW1gkLxTgt5kmUCkYHFW7e3W1tbdWubeZZWdWjcnKtg4duMZqhHD9qvkkg3oGOx2V/vEZwcdM
VxNW3KJp0afVfJnL3Xkodqj7kZyTjjqtMms5bnUGuU3QTSrwI8hVzwMHpjFWbeMRefdR78IpSYB8
M7E9AO44/Wm3QlS0hYF4MjypI1QncBSv1GTaRf3fhqYNp+orHcS/u5AQGOM8Zz6mtZ/GHiVTM1xr
RjubdhtTy1wwPc4GO1YrCOCZBnzWZAVkdcBT/dwev1qq8ss12dPPlW69ZJMgq5PI9uMGqjUqWspN
fMVkauqeJdW1bQvJvp3uledWKmMbeO+QOPpWtaHSbvwZcmL7I+qu6ReUEUMFBA+X3I71zLELHHC6
wsGUkuAeTkjd+lR2gRo5oVMalT5jzP8AKSw6/rTVV3blq9gsQpaEtPb+S7yRnLMADyD3xV7S2SEw
t5kbGSZQY3jAKrkc5/CoLFPIW3lkd4p5WYSyE4DD04/rU0ENtIxjtrRUmjBaLcgO9T13E9ahaMD0
LWviG73a2GlOhRWEZdPvsQOcZ4xW34L1nWtWBa/QtD8w8wxhcEEgYI4NeOxSgRRGeRMwEyBHjyM9
P6V7x4OjEfhaywu3cpfA9zmvSwtWdWpdsiSSRv0UUV6pAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQ
AUUUUAFFFFABRRRQAUUVG80SHDyIp9CwFAElJXNDxrpX9q3FjJKIxAWDSsflyoyf5GrGkeK9K1mS
SO2mKsnI8zC7x6jnmslVg3ZMdmYnxS3N4WjRQDm5Tj16151pnjm9trF9GaVLeA7wkkUeXbk8E5rq
viOl8dRgnaaOfT2UhIlfBVvXA615xBa211bxARubhZWHmD7gzxj/AOvXk4uo1WfLdaWLitCzHNci
NZbeNUjaf5YmYE7uh/TNOWKZ1itprmFQnmPsKkFW45yK6rwP4bh1eDU7e5iI/dKYHfhkbrnjtmud
u9MawuzBcBBcIHjckMCDkEAc85ArmlSlGCm9mVfoULaX7QPKlZsrHiOSMdOT1zirE8UcrvaR+Yzx
qeTk+Ye+0difeq8EeJYzPIArJlWhXBQhjwc9+/41Z3s63FwLiXzI1EjSxgclh0J9Kx16jKiSJNp6
rFvS82nduXI3D09BjNW7E6hcmKeOOGSdmEcZU4OcHIwf50umQ+TqDKC81uFETKSEaYnjgkHBq5od
raHX7RoFmjkhugHjkkBG09Mcc9DWsI3aXmIrXtjqOgypZaxBJGrR7goIPylicA/XNQxRT6fcxSI8
bXEbLLbw7PMBUndg1698RHso/DchnjRrmQ+XASBnJ9+uK8NEd1aW39oGYxSfMqojen161vXpOlUt
FiTuj07XLWXULay1K302IW0qLJK0W35SR82ckVw73PlXt4LxPKVVTygoDbuT1wcVJ/bUiaW+mQ3T
NbTMj4YEBT3HXpzVC6YGd1m2SRwoq5h4Dc9vzrOrVU9VuNKx6/4W0Dw7rGgwXbaTa+a2Vk2qRyCf
f0wfxrtYoUghSKJQkaAKqjoAK4r4Z6hbS6GbGNXSeEl3VucAnjn6AV3Ne1h7OmpLexk9xaKKK6BB
RRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUVBcXMNpbvcXEqRQxjc7u2Ao9SaAJqr3d9a2EJ
mu544Yx1Z2wK891/4p2kUTx6MyyseFnYZUnvgf415vq2pXVzq8V3fSrfG4gIALZ2NkcVw1sbCDtH
VlKD6npfiP4jBZpLTR0MgTAlnC5Kg/3R/WuHvftt1CZXu5m2yMWe5kO9RnhR6nFc9HNc+XPCjbHx
ukaPjK9gT+FPggNxMk9zvkDgBnzgBscAmvMqYiVR+8/kaJWLkzQTRuvlyqRKB5BXO7g5OTTIQ0to
2wRPPCeYY+Ci+ufyrofD+lSajrdrazuLXcm1TbYYn5TyR9Otd5/wrPR4rForZpI7hmDNPnJf2I9K
dDDVKsXJCckjy55nc2wiQC4IyoExOMdc896itLaW/lbToLRVeZi/7w7FjwMn8PevQL74WRQxCezl
kuLneC65CAj25wKoxfDPV7oSSXNxFFMz7gzSFiBjpxxT+q1lJXV/67hzI5j7dqelSwSWUrwTYMIM
cxdWwOp5qTWLzUrqWO/vkuZZQgVJJI9ihvUYABr1Xwn4ZOix3D3McXnSOCpHzED6+9dO8aSIUdQy
nqCK644KUoWcmvIly1Pm7bcfb4obqUyLuMi7eVLEA9B17D8KkaG4mv7i3e2CEtukiRtgVQcnP4V1
vxEdotd+yPZeXaRQq0TRL0BJ3Nx34x+FcnJJGiPdbpXiB22+5OX9dw6151an7ObjvYtO6I98U1tM
wbMAPyxZy4ZuAc9e9T22pSwNA6/ZGuRt8tx8u0Kec/mOtaFjr8NvoEen26+VIS0s87Njzv7qZH1/
Ssz7USq3MrkTMdu1v7v1pWUbWeoF7VdZn1vVoPtt84jgbBZgCA3XIx1FYfmiSK7+1SfMhkaMImGB
5weO1W4xbwXUE9xDKkfLbmG7cMkcdiOKkEUz2K3dw90kMkjrC4fIIUdAB9KpNybcnf8AEBFhTyYr
XY01t5fnOGwDn/8AXVRVhtopYZVLRk740U9D6A9/p71Dp8dzMjXbRGUbQiNvwBn61egWfzIIy32m
3VWGxvlCscd/w61nrsM29E8WSaJMZbeS1je5j+dTFgbl4C/Wut/4WoItNVptMkF4FXeucLuPHTrX
C6Xape339lF4iVYonmnCITyW3dDya6O7+GOsBhMt3Bekp1DbWGBxgniuyhPEKL5NkS+Xqem6FrCa
1pqXSoY36PGeqmtSud8J6NcaRYzLdZDyyb9pbcV/Guir16Tk4Jy3M2FFFFaiCiiigAooooAKKKKA
CiiigAooooAKKKKAErmfGdzYDSHsb+OZ4rpWB8kgFQBycmunrC8T6ENe0r7ONolRg6M3t2/Gs6vN
yPk3GnZ3PAtU02I3AFjfMsFy7ssk68t3zx0zVyPTLeeSJ4bNIwuGby3LMR04GOT3r2XQfBmnaVaR
/abeO4uVz87jcFz2APFYOvaHr02rv/Z8AW335j8tURduOmduQa8ueGmo3l16JGnPdnG6z4RsLDTb
G4lnliu7xnd4pJNvyDGOMccVjSJHBamKKUBk/eGKRsq2emCPTiu81/wneJoa6lqdy0lxBlXQDfhM
9jXDvA4RY4ioW5kGTOn3F7HcOlc2Ii4yS5baIEeg/DvUNMtJZLaZDDf3DDarLwMDoDXpteW+A9Gu
J9WN5NazR2UK74Wl53ydOvXGCa9Sr1sHzeyXMrES3CiiiuskKKKKAOe8ReF7XxDGGd2iuFXasi9C
PQjuOa8g1jTrrRdRuhKCZbbKxNgbeenH0r3+srVPDula0ytf2ayuvRskH9DXFiMIqvvR0ZSlY8Os
YbP7baxanDi0jcedNAM5z3PpzitHxHocmja2IbLBiWAyxSBOWVuMHJ616gPAnh5FRI7IoisGKiRs
NjpnJ5rS1TQtO1i18i7twyhdqspwyj2Nc8cA/ZuLtfox8+p4K0HmWquNoVYuVD7ipB98UXF9czae
lhqUSskKMII/ulc85JFW9W02Ox1W8tHh329sSAoYhz3GfWukg+Hl9daBDfWtyWurqEeZDOP4WXGA
e3FcUKNSTkodN/kXdHB2dnII0dWijjX94UDEZx7fWrLpNLIyQWbzm7KqrLxhj6+ld8vwwvreC3uL
e8hN5t2yxumUAIwcVE3w01WxRjDqMc0I/eFBmM5Hvz0q1hKt7yiLmRU8ReGrbw1pttNBdsXkUJNb
vhmViBkg54/KsE67f2USPa6lNbtIv+riJbb/AI1Bc+bP/rrh3lVirBySSc9ie1RJOyytcWtiY5U4
jZxkKR14PXPpWdSpefuLlGl3OgPjHX47Zg19KkaqGGXHmMSPXHT2rp/B3jW6uHtrLUt0rXLkRSlv
mHsRS6X4Ga48J3cU6pBeXu1wzjcY8dvbPtUelfD2/s7+1le6hjSEgsyAlmx0xnp3rthTxMZRd20Q
3E9Kooor1iAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAI5I0lRkkUMjDBVhkGuc/wCE
H0P7W1wLd9rEM0PmExkjp8ucY9uldPSVEoRl8SuAiqqKFUAKOAB2p1FFWAUUUUAFFFFABRRRQAUU
UUAZ0uh6ZPei8lsYHuP77ICa0aKKSSWwBTSAylTyCMGnUUwOHu/hzbXF3LOmpXEauCFQIhCAknjI
9Sal0/4e6daagL65uri8lV/MCykBN3rgYBrss0VgsPSTvyjuxaKKK3EFFFFABRRRQAUUUUAFFFFA
BRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAF
FFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUU
UUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRR
QAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFA
BRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAF
FFFABRRRQAUUUUAFFFFABRRRQB//2Q==