20180522 17403200 1.0 FALSE gis_vector.sde.Water_Lines 002 Server=srv-ch-arcgispg; Service=sde:postgresql:srv-ch-arcgispg; Database=gis_vector; User=sde ArcSDE Connection 2558503.315700 2567425.899100 7621903.704000 7631616.352200 1 Projected GCS_North_American_1983_CSRS Linear Unit: Meter (1.000000) NAD_1983_CSRS_New_Brunswick_Stereographic <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/2.7.0'><WKT>PROJCS[&quot;NAD_1983_CSRS_New_Brunswick_Stereographic&quot;,GEOGCS[&quot;GCS_North_American_1983_CSRS&quot;,DATUM[&quot;D_North_American_1983_CSRS&quot;,SPHEROID[&quot;GRS_1980&quot;,6378137.0,298.257222101]],PRIMEM[&quot;Greenwich&quot;,0.0],UNIT[&quot;Degree&quot;,0.0174532925199433]],PROJECTION[&quot;Double_Stereographic&quot;],PARAMETER[&quot;False_Easting&quot;,2500000.0],PARAMETER[&quot;False_Northing&quot;,7500000.0],PARAMETER[&quot;Central_Meridian&quot;,-66.5],PARAMETER[&quot;Scale_Factor&quot;,0.999912],PARAMETER[&quot;Latitude_Of_Origin&quot;,46.5],UNIT[&quot;Meter&quot;,1.0],AUTHORITY[&quot;EPSG&quot;,2953]],VERTCS[&quot;CGVD2013_height&quot;,VDATUM[&quot;Canadian_Geodetic_Vertical_Datum_of_2013&quot;],PARAMETER[&quot;Vertical_Shift&quot;,0.0],PARAMETER[&quot;Direction&quot;,1.0],UNIT[&quot;Meter&quot;,1.0],AUTHORITY[&quot;EPSG&quot;,6647]]</WKT><XOrigin>-28216700</XOrigin><YOrigin>-23260100</YOrigin><XYScale>1000</XYScale><ZOrigin>0</ZOrigin><ZScale>1000</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.002</XYTolerance><ZTolerance>0.002</ZTolerance><MTolerance>2</MTolerance><HighPrecision>true</HighPrecision><WKID>2036</WKID><LatestWKID>2953</LatestWKID><VCSWKID>6647</VCSWKID><LatestVCSWKID>6647</LatestVCSWKID></ProjectedCoordinateSystem> CopyFeatures QueryTable2 "C:\GIS\Master Geodatabase.gdb\Engineering\Engineering_Combined_Lines_ReOrdered" # 0 0 0 CalculateField Engineering\Engineering_Combined_Lines Link_to_As_Built " " VB # CalculateField Engineering\Engineering_Combined_Lines Link_to_Ti_Ins " " VB # CalculateField Engineering\Engineering_Combined_Lines GeoLocation 2 VB # CalculateField Engineering\Engineering_Combined_Lines GeoLocation 0 VB # CalculateField "Engineering\Engineering Divided\Clean Water\Clean Water - Lateral\Clean Water - Lateral" Link_to_Ti_Ins ""X:\Plans\Tie-Ins\Tie-Ins - Laterals Valves (PID.Valve#.LVL)\"+ [Entity_ID]+".pdf"" VB # AddField "X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Lines" Asset_Group SHORT # # # "Asset Group" NULLABLE NON_REQUIRED # AddField "X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Lines" Jurisdiction SHORT # # # Jurisdiction NULLABLE NON_REQUIRED # AddField "X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Lines" "Asset is Tangible Capital Asset (TCA)" SHORT # # # "Asset is Tangible Capital Asset (TCA)" NULLABLE NON_REQUIRED # AddField "X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Lines" "Expected Life (Years)" SHORT # # # "Expected Life (Years)" NULLABLE NON_REQUIRED # AddField "X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Lines" "End of Life Date" DATE # # # "End of Life Date" NULLABLE NON_REQUIRED # DeleteField "X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Lines" Asset_is_Tangible_Capital_Asset__TCA_;Expected_Life__Years_ AddField "X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Lines" "Tangible Capital Asset" SHORT # # # "Tangible Capital Asset" NULLABLE NON_REQUIRED # AddField "X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Lines" "Expected Life Years" SHORT # # # "Expected Life Years" NULLABLE NON_REQUIRED # AddField "X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Lines" "End of Life Date" SHORT # # # "End of Life Date" NULLABLE NON_REQUIRED # AddField "X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Lines" "Remaining Life Years" SHORT # # # "Remaining Life Years" NULLABLE NON_REQUIRED # AddField "X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Lines" "Remaining Life Percent" FLOAT # # # "Remaining Life Percent" NULLABLE NON_REQUIRED # AddField "X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Lines" "Condition Rating" SHORT # # # "Condition Rating (1 to 5)" NULLABLE NON_REQUIRED # AddField "X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Lines" "Cost per Unit" FLOAT # # # "Cost per Unit" NULLABLE NON_REQUIRED # AddField "X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Lines" "Asset Replacement Value" FLOAT # # # "Asset Replacement Value" NULLABLE NON_REQUIRED # AddField "X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Lines" "Emergency Asset Replacement Value" FLOAT # # # "Emergency Asset Replacement Value" NULLABLE NON_REQUIRED # AddField "X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Lines" "Loss in Value" FLOAT # # # "Loss in Value" NULLABLE NON_REQUIRED # AddField "X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Lines" "Remaining Value" FLOAT # # # "Remaining Value" NULLABLE NON_REQUIRED # AddField "X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Lines" "Infrastructure Deficit (Backlog)" FLOAT # # # "Infrastructure Deficit (Backlog)" NULLABLE NON_REQUIRED # CalculateField "Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral" Asset_Group 1 VB # AssignDomainToField "Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral" Asset_Group COB_Asset_Group # SetSubtypeField "Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral" Asset_Group false AddSubtype "Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral" -1 "What is my Asset Group?" SetDefaultSubtype "Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral" -1 RemoveDomainFromField "Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral" Entity_Type '-1: What is my Asset Group?';'0: Unknown';'1: Roads';'2: Buildings';'3: Fleet';'4: Land';'5: Park & Signs';'6: Machinery & Equipment' AlterField "Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral" Entity_Type Asset_Type "Asset Type" SHORT 3 NULLABLE false AssignDomainToField "Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral" Asset_Subtype "COB_Water Distribution System" '1: Roads' AssignDomainToField "Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral" Material COB_Material # AssignDomainToField "Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral" Asset_Type "COB_Asset Type" # EnableEditorTracking "Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral" Feature_Creator # # # ADD_FIELDS DATABASE_TIME AddGlobalIDs 'Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral';'Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Location';'Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Valve';'Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Lateral';'Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Lateral_DBH';'Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Lateral_Private_Section';'Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Lateral_Shut_Off_Valve';'Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Main';'Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Meter';'Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Valve';'Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Sanitary_Sewer_Forcemain';'Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Sanitary_Sewer_Forcemain_Valve';'Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Sanitary_Sewer_Lateral';'Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Sanitary_Sewer_Lift_Station';'Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Sanitary_Sewer_Main';'Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Sanitary_Sewer_Manhole';'Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Storm_Sewer_Catch_Basin';'Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Storm_Sewer_Catch_Basin_Lateral';'Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Storm_Sewer_Lateral';'Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Storm_Sewer_Main';'Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Storm_Sewer_Manhole';'Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Storm_Sewer_Sluice_Box';'Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Transportation_Street_Painting_Arrow_Left';'Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Transportation_Street_Painting_Arrow_Right';'Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Transportation_Street_Painting_Arrow_Straight';'Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Transportation_Street_Painting_Arrow_Straight_Left';'Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Transportation_Street_Painting_Arrow_Straight_Right';'Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Transportation_Street_Painting_Stop_Bar' FeatureClassToFeatureClass "Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral" "Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets" City_Asset_Clean_Water_Fire_Hydrant_Lateral2 # "GlobalID "GlobalID" false false false 38 GlobalID 0 0 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,GlobalID,-1,-1;Asset_Group "Asset Group" true true false 2 Short 0 5 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Asset_Group,-1,-1;Asset_Type "Asset_Type" true true false 2 Short 0 5 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Asset_Type,-1,-1;Asset_Subtype "Asset Subtype" true true false 2 Short 0 5 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Asset_Subtype,-1,-1;Asset_ID "Asset_ID" true true false 50 Text 0 0 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Asset_ID,-1,-1;Related_PID "Related_PID" true true false 50 Text 0 0 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Related_PID,-1,-1;Closest_Civic_Address "Closest_Civic_Address" true true false 50 Text 0 0 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Closest_Civic_Address,-1,-1;Related_Civic_Number "Related_Civic_Number" true true false 50 Text 0 0 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Related_Civic_Number,-1,-1;Related_Street_Name "Related Street Name" true true false 2 Short 0 5 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Related_Street_Name,-1,-1;Related_Street_Section "Related_Street_Section" true true false 8 Double 8 38 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Related_Street_Section,-1,-1;GeoLocation "GeoLocation" true true false 2 Short 0 5 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,GeoLocation,-1,-1;Grid_Reference "Grid_Reference" true true false 6 Text 0 0 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Grid_Reference,-1,-1;Installation_Year "Installation Year" true true false 2 Short 0 5 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Installation_Year,-1,-1;Diameter "Diameter" true true false 2 Short 0 5 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Diameter,-1,-1;Material "Material" true true false 2 Short 0 5 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Material,-1,-1;Pipe_Class "Pipe Class" true true false 2 Short 0 5 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Pipe_Class,-1,-1;Lateral_With_DBH "Lateral With DBH" true true false 2 Short 0 5 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Lateral_With_DBH,-1,-1;Depth "Depth" true true false 2 Short 0 5 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Depth,-1,-1;TTYYPPEE "TTYYPPEE" true true false 50 Text 0 0 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,TTYYPPEE,-1,-1;Comments "Comments" true true false 60 Text 0 0 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Comments,-1,-1;Last_Maintenance_Inspection_Dat "Last Maintenance Inspection Date" true true false 2 Short 0 5 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Last_Maintenance_Inspection_Dat,-1,-1;Link_to_As_Built "Link to As-Built" true true false 250 Text 0 0 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Link_to_As_Built,-1,-1;Link_to_Ti_Ins "Link to Ti-Ins" true true false 250 Text 0 0 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Link_to_Ti_Ins,-1,-1;Feature_Creator "Feature Creator" false true false 150 Text 0 0 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Feature_Creator,-1,-1;Creation_Date "Creation_Date" false true false 8 Date 0 0 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Creation_Date,-1,-1;Last_Editor "Last_Editor" false true false 255 Text 0 0 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Last_Editor,-1,-1;Last_Edit_Date "Last_Edit_Date" false true false 8 Date 0 0 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Last_Edit_Date,-1,-1;Jurisdiction "Jurisdiction" true true false 2 Short 0 5 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Jurisdiction,-1,-1;Tangible_Capital_Asset "Tangible Capital Asset" true true false 2 Short 0 5 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Tangible_Capital_Asset,-1,-1;Expected_Life_Years "Expected Life Years" true true false 2 Short 0 5 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Expected_Life_Years,-1,-1;End_of_Life_Date "End of Life Date" true true false 2 Short 0 5 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,End_of_Life_Date,-1,-1;Remaining_Life_Years "Remaining Life Years" true true false 2 Short 0 5 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Remaining_Life_Years,-1,-1;Remaining_Life_Percent "Remaining Life Percent" true true false 8 Double 8 38 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Remaining_Life_Percent,-1,-1;Condition_Rating "Condition Rating (1 to 5)" true true false 2 Short 0 5 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Condition_Rating,-1,-1;Cost_per_Unit "Cost per Unit" true true false 8 Double 8 38 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Cost_per_Unit,-1,-1;Asset_Replacement_Value "Asset Replacement Value" true true false 8 Double 8 38 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Asset_Replacement_Value,-1,-1;Emergency_Asset_Replacement_Val "Emergency Asset Replacement Value" true true false 8 Double 8 38 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Emergency_Asset_Replacement_Val,-1,-1;Loss_in_Value "Loss in Value" true true false 8 Double 8 38 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Loss_in_Value,-1,-1;Remaining_Value "Remaining Value" true true false 8 Double 8 38 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Remaining_Value,-1,-1;Infrastructure_Deficit__Backlog "Infrastructure Deficit (Backlog)" true true false 8 Double 8 38 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Infrastructure_Deficit__Backlog,-1,-1;Shape_STLength__ "Shape_STLength__" false false true 0 Double 0 0 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Shape.STLength(),-1,-1;Show_When_Page_Name_Is_Not "Show_When_Page_Name_Is_Not" true true false 50 Text 0 0 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Show_When_Page_Name_Is_Not,-1,-1;PSAB_2016_Comments "PSAB 2016 Comments" true true false 2 Short 0 5 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,PSAB_2016_Comments,-1,-1;PSAB_2017_Comments "PSAb 2017 Comments" true true false 2 Short 0 5 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,PSAB_2017_Comments,-1,-1" # EnableEditorTracking "Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral" Feature_Creator Creation_Date Last_Editor Last_Edit_Date # DATABASE_TIME FeatureClassToFeatureClass "Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral" "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets" Fire_Hydrant_Lateral # "GlobalID "GlobalID" false false false 38 GlobalID 0 0 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,GlobalID,-1,-1;Asset_Group "Asset Group" true true false 2 Short 0 5 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Asset_Group,-1,-1;Asset_Type "Asset_Type" true true false 2 Short 0 5 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Asset_Type,-1,-1;Asset_Subtype "Asset Subtype" true true false 2 Short 0 5 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Asset_Subtype,-1,-1;Asset_ID "Asset_ID" true true false 50 Text 0 0 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Asset_ID,-1,-1;Related_PID "Related_PID" true true false 50 Text 0 0 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Related_PID,-1,-1;Closest_Civic_Address "Closest_Civic_Address" true true false 50 Text 0 0 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Closest_Civic_Address,-1,-1;Related_Civic_Number "Related_Civic_Number" true true false 50 Text 0 0 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Related_Civic_Number,-1,-1;Related_Street_Name "Related Street Name" true true false 2 Short 0 5 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Related_Street_Name,-1,-1;Related_Street_Section "Related_Street_Section" true true false 8 Double 8 38 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Related_Street_Section,-1,-1;GeoLocation "GeoLocation" true true false 2 Short 0 5 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,GeoLocation,-1,-1;Grid_Reference "Grid_Reference" true true false 6 Text 0 0 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Grid_Reference,-1,-1;Installation_Year "Installation Year" true true false 2 Short 0 5 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Installation_Year,-1,-1;Diameter "Diameter" true true false 2 Short 0 5 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Diameter,-1,-1;Material "Material" true true false 2 Short 0 5 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Material,-1,-1;Pipe_Class "Pipe Class" true true false 2 Short 0 5 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Pipe_Class,-1,-1;Lateral_With_DBH "Lateral With DBH" true true false 2 Short 0 5 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Lateral_With_DBH,-1,-1;Depth "Depth" true true false 2 Short 0 5 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Depth,-1,-1;TTYYPPEE "TTYYPPEE" true true false 50 Text 0 0 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,TTYYPPEE,-1,-1;Comments "Comments" true true false 60 Text 0 0 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Comments,-1,-1;Last_Maintenance_Inspection_Dat "Last Maintenance Inspection Date" true true false 2 Short 0 5 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Last_Maintenance_Inspection_Dat,-1,-1;Link_to_As_Built "Link to As-Built" true true false 250 Text 0 0 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Link_to_As_Built,-1,-1;Link_to_Ti_Ins "Link to Ti-Ins" true true false 250 Text 0 0 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Link_to_Ti_Ins,-1,-1;Feature_Creator "Feature Creator" false true false 150 Text 0 0 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Feature_Creator,-1,-1;Creation_Date "Creation_Date" false true false 8 Date 0 0 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Creation_Date,-1,-1;Last_Editor "Last_Editor" false true false 255 Text 0 0 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Last_Editor,-1,-1;Last_Edit_Date "Last_Edit_Date" false true false 8 Date 0 0 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Last_Edit_Date,-1,-1;Jurisdiction "Jurisdiction" true true false 2 Short 0 5 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Jurisdiction,-1,-1;Tangible_Capital_Asset "Tangible Capital Asset" true true false 2 Short 0 5 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Tangible_Capital_Asset,-1,-1;Expected_Life_Years "Expected Life Years" true true false 2 Short 0 5 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Expected_Life_Years,-1,-1;End_of_Life_Date "End of Life Date" true true false 2 Short 0 5 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,End_of_Life_Date,-1,-1;Remaining_Life_Years "Remaining Life Years" true true false 2 Short 0 5 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Remaining_Life_Years,-1,-1;Remaining_Life_Percent "Remaining Life Percent" true true false 8 Double 8 38 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Remaining_Life_Percent,-1,-1;Condition_Rating "Condition Rating (1 to 5)" true true false 2 Short 0 5 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Condition_Rating,-1,-1;Cost_per_Unit "Cost per Unit" true true false 8 Double 8 38 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Cost_per_Unit,-1,-1;Asset_Replacement_Value "Asset Replacement Value" true true false 8 Double 8 38 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Asset_Replacement_Value,-1,-1;Emergency_Asset_Replacement_Val "Emergency Asset Replacement Value" true true false 8 Double 8 38 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Emergency_Asset_Replacement_Val,-1,-1;Loss_in_Value "Loss in Value" true true false 8 Double 8 38 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Loss_in_Value,-1,-1;Remaining_Value "Remaining Value" true true false 8 Double 8 38 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Remaining_Value,-1,-1;Infrastructure_Deficit__Backlog "Infrastructure Deficit (Backlog)" true true false 8 Double 8 38 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Infrastructure_Deficit__Backlog,-1,-1;Show_When_Page_Name_Is_Not "Show_When_Page_Name_Is_Not" true true false 50 Text 0 0 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Show_When_Page_Name_Is_Not,-1,-1;PSAB_2016_Comments "PSAB 2016 Comments" true true false 2 Short 0 5 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,PSAB_2016_Comments,-1,-1;PSAB_2017_Comments "PSAb 2017 Comments" true true false 2 Short 0 5 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,PSAB_2017_Comments,-1,-1;Shape_STLength__ "Shape_STLength__" false false true 0 Double 0 0 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Lateral,Shape.STLength(),-1,-1" # EnableEditorTracking "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral" Feature_Creator Creation_Date Last_Editor Last_Edit_Date # DATABASE_TIME SetSubtypeField "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral" Asset_Type false AddSubtype "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral" 0 "What Kind of Entity Am I?" AddSubtype "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral" 1 "Water Distribution System" AddSubtype "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral" 2 "Sanitary Sewer System" AddSubtype "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral" 3 "Storm Sewer System" AddSubtype "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral" 4 "Transportation System" SetDefaultSubtype "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral" 1 Merge 'Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral';'Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral';'Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section';'Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main' "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water_Lines" "GlobalID "GlobalID" false false false 38 GlobalID 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,GlobalID,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,GlobalID,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,GlobalID,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,GlobalID,-1,-1;Asset_Group "Asset Group" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,Asset_Group,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,Asset_Group,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,Asset_Group,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,Asset_Group,-1,-1;Asset_Type "Asset_Type" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,Asset_Type,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,Asset_Type,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,Asset_Type,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,Asset_Type,-1,-1;Asset_Subtype "Asset Subtype" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,Asset_Subtype,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,Asset_Subtype,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,Asset_Subtype,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,Asset_Subtype,-1,-1;Asset_ID "Asset_ID" true true false 50 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,Asset_ID,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,Asset_ID,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,Asset_ID,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,Asset_ID,-1,-1;Related_PID "Related_PID" true true false 50 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,Related_PID,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,Related_PID,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,Related_PID,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,Related_PID,-1,-1;Closest_Civic_Address "Closest_Civic_Address" true true false 50 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,Closest_Civic_Address,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,Closest_Civic_Address,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,Closest_Civic_Address,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,Closest_Civic_Address,-1,-1;Related_Civic_Number "Related_Civic_Number" true true false 50 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,Related_Civic_Number,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,Related_Civic_Number,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,Related_Civic_Number,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,Related_Civic_Number,-1,-1;Related_Street_Name "Related Street Name" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,Related_Street_Name,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,Related_Street_Name,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,Related_Street_Name,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,Related_Street_Name,-1,-1;Related_Street_Section "Related_Street_Section" true true false 8 Double 8 38 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,Related_Street_Section,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,Related_Street_Section,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,Related_Street_Section,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,Related_Street_Section,-1,-1;GeoLocation "GeoLocation" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,GeoLocation,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,GeoLocation,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,GeoLocation,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,GeoLocation,-1,-1;Grid_Reference "Grid_Reference" true true false 6 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,Grid_Reference,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,Grid_Reference,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,Grid_Reference,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,Grid_Reference,-1,-1;Installation_Year "Installation Year" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,Installation_Year,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,Installation_Year,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,Installation_Year,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,Installation_Year,-1,-1;Diameter "Diameter" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,Diameter,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,Diameter,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,Diameter,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,Diameter,-1,-1;Material "Material" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,Material,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,Material,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,Material,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,Material,-1,-1;Pipe_Class "Pipe Class" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,Pipe_Class,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,Pipe_Class,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,Pipe_Class,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,Pipe_Class,-1,-1;Lateral_With_DBH "Lateral With DBH" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,Lateral_With_DBH,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,Lateral_With_DBH,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,Lateral_With_DBH,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,Lateral_With_DBH,-1,-1;Depth "Depth" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,Depth,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,Depth,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,Depth,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,Depth,-1,-1;TTYYPPEE "TTYYPPEE" true true false 50 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,TTYYPPEE,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,TTYYPPEE,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,TTYYPPEE,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,TTYYPPEE,-1,-1;Comments "Comments" true true false 60 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,Comments,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,Comments,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,Comments,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,Comments,-1,-1;Last_Maintenance_Inspection_Dat "Last Maintenance Inspection Date" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,Last_Maintenance_Inspection_Dat,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,Last_Maintenance_Inspection_Dat,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,Last_Maintenance_Inspection_Dat,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,Last_Maintenance_Inspection_Dat,-1,-1;Link_to_As_Built "Link to As-Built" true true false 250 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,Link_to_As_Built,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,Link_to_As_Built,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,Link_to_As_Built,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,Link_to_As_Built,-1,-1;Link_to_Ti_Ins "Link to Ti-Ins" true true false 250 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,Link_to_Ti_Ins,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,Link_to_Ti_Ins,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,Link_to_Ti_Ins,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,Link_to_Ti_Ins,-1,-1;Feature_Creator "Feature Creator" false true false 150 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,Feature_Creator,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,Feature_Creator,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,Feature_Creator,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,Feature_Creator,-1,-1;Creation_Date "Creation_Date" false true false 8 Date 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,Creation_Date,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,Creation_Date,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,Creation_Date,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,Creation_Date,-1,-1;Last_Editor "Last_Editor" false true false 255 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,Last_Editor,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,Last_Editor,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,Last_Editor,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,Last_Editor,-1,-1;Last_Edit_Date "Last_Edit_Date" false true false 8 Date 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,Last_Edit_Date,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,Last_Edit_Date,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,Last_Edit_Date,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,Last_Edit_Date,-1,-1;Jurisdiction "Jurisdiction" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,Jurisdiction,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,Jurisdiction,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,Jurisdiction,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,Jurisdiction,-1,-1;Tangible_Capital_Asset "Tangible Capital Asset" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,Tangible_Capital_Asset,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,Tangible_Capital_Asset,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,Tangible_Capital_Asset,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,Tangible_Capital_Asset,-1,-1;Expected_Life_Years "Expected Life Years" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,Expected_Life_Years,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,Expected_Life_Years,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,Expected_Life_Years,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,Expected_Life_Years,-1,-1;End_of_Life_Date "End of Life Date" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,End_of_Life_Date,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,End_of_Life_Date,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,End_of_Life_Date,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,End_of_Life_Date,-1,-1;Remaining_Life_Years "Remaining Life Years" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,Remaining_Life_Years,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,Remaining_Life_Years,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,Remaining_Life_Years,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,Remaining_Life_Years,-1,-1;Remaining_Life_Percent "Remaining Life Percent" true true false 8 Double 8 38 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,Remaining_Life_Percent,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,Remaining_Life_Percent,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,Remaining_Life_Percent,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,Remaining_Life_Percent,-1,-1;Condition_Rating "Condition Rating (1 to 5)" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,Condition_Rating,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,Condition_Rating,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,Condition_Rating,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,Condition_Rating,-1,-1;Cost_per_Unit "Cost per Unit" true true false 8 Double 8 38 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,Cost_per_Unit,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,Cost_per_Unit,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,Cost_per_Unit,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,Cost_per_Unit,-1,-1;Asset_Replacement_Value "Asset Replacement Value" true true false 8 Double 8 38 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,Asset_Replacement_Value,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,Asset_Replacement_Value,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,Asset_Replacement_Value,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,Asset_Replacement_Value,-1,-1;Emergency_Asset_Replacement_Val "Emergency Asset Replacement Value" true true false 8 Double 8 38 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,Emergency_Asset_Replacement_Val,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,Emergency_Asset_Replacement_Val,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,Emergency_Asset_Replacement_Val,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,Emergency_Asset_Replacement_Val,-1,-1;Loss_in_Value "Loss in Value" true true false 8 Double 8 38 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,Loss_in_Value,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,Loss_in_Value,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,Loss_in_Value,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,Loss_in_Value,-1,-1;Remaining_Value "Remaining Value" true true false 8 Double 8 38 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,Remaining_Value,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,Remaining_Value,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,Remaining_Value,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,Remaining_Value,-1,-1;Infrastructure_Deficit__Backlog "Infrastructure Deficit (Backlog)" true true false 8 Double 8 38 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,Infrastructure_Deficit__Backlog,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,Infrastructure_Deficit__Backlog,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,Infrastructure_Deficit__Backlog,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,Infrastructure_Deficit__Backlog,-1,-1;Show_When_Page_Name_Is_Not "Show_When_Page_Name_Is_Not" true true false 50 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,Show_When_Page_Name_Is_Not,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,Show_When_Page_Name_Is_Not,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,Show_When_Page_Name_Is_Not,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,Show_When_Page_Name_Is_Not,-1,-1;PSAB_2016_Comments "PSAB 2016 Comments" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,PSAB_2016_Comments,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,PSAB_2016_Comments,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,PSAB_2016_Comments,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,PSAB_2016_Comments,-1,-1;PSAB_2017_Comments "PSAb 2017 Comments" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,PSAB_2017_Comments,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,PSAB_2017_Comments,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,PSAB_2017_Comments,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,PSAB_2017_Comments,-1,-1;Shape_STLength__ "Shape_STLength__" false false true 0 Double 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Lateral,Shape.STLength(),-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral,Shape.STLength(),-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,Shape.STLength(),-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Main,Shape.STLength(),-1,-1;Enabled "Enabled" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Private_Section,Enabled,-1,-1" SetSubtypeField "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water_Lines" Asset_Subtype false AddSubtype "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water_Lines" 101 "Water - Main" AddSubtype "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water_Lines" 102 "Water - Lateral" AddSubtype "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water_Lines" 105 "Water - Fire Hydrant - Lateral" AddSubtype "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water_Lines" 109 "Water - Private Lateral" CalculateField "Water Distribution Network\Water Lines" Expected_Life_Years 40 VB # CalculateField "Water Distribution Network\Water Lines" Cost_per_Unit 350 VB # CalculateField "Water Distribution Network\Water Lines" Expected_Life_Years 40 VB # CalculateField "Water Distribution Network\Water Lines" Cost_per_Unit 450 VB # CalculateField "Water Distribution Network\Water Lines" Cost_per_Unit 550 VB # CalculateField "Water Distribution Network\Water Lines" Expected_Life_Years 40 VB # CalculateField "Water Distribution Network\Water Lines" Expected_Life_Years 40 VB # CalculateField "Water Distribution Network\Water Lines" Cost_per_Unit 650 VB # CalculateField "Water Distribution Network\Water Lines" Expected_Life_Years 40 VB # CalculateField "Water Distribution Network\Water Lines" Cost_per_Unit 750 VB # CalculateField "Water Distribution Network\Water Lines" Expected_Life_Years 40 VB # CalculateField "Water Distribution Network\Water Lines" Cost_per_Unit 850 VB # CalculateField "Water Distribution Network\Water Lines" Expected_Life_Years 40 VB # CalculateField "Water Distribution Network\Water Lines" Cost_per_Unit 50 VB # CalculateField "Water Distribution Network\Water Lines" Expected_Life_Years 40 VB # CalculateField "Water Distribution Network\Water Lines" Cost_per_Unit 350 VB # CalculateField "Water Distribution Network\Water Lines" Cost_per_Unit 450 VB # CalculateField "Water Distribution Network\Water Lines" Cost_per_Unit 550 VB # CalculateField "Water Distribution Network\Water Lines" Cost_per_Unit 650 VB # CalculateField "Water Distribution Network\Water Lines" Cost_per_Unit 750 VB # CalculateField "Water Distribution Network\Water Lines" Cost_per_Unit 850 VB # CalculateField "Water Distribution Network\Water Lines" Cost_per_Unit 950 VB # CalculateField "Water Distribution Network\Water Lines" Cost_per_Unit 1250 VB # CalculateField "Water Distribution Network\Water Lines" Expected_Life_Years 40 VB # CalculateField "Water Distribution Network\Water Lines" Cost_per_Unit 550 VB # CalculateField "Water Distribution Network\Water Lines" Cost_per_Unit 750 VB # CalculateField "Water Distribution Network\Water Lines" Expected_Life_Years 60 VB # CalculateField "Water Distribution Network\Water Lines" Cost_per_Unit 250 VB # CalculateField "Water Distribution Network\Water Lines" Cost_per_Unit 350 VB # CalculateField "Water Distribution Network\Water Lines" Cost_per_Unit 450 VB # CalculateField "Water Distribution Network\Water Lines" Cost_per_Unit 550 VB # CalculateField "Water Distribution Network\Water Lines" Cost_per_Unit 650 VB # CalculateField "Water Distribution Network\Water Lines" Cost_per_Unit 750 VB # CalculateField "Water Distribution Network\Water Lines" Cost_per_Unit 850 VB # CalculateField "Water Distribution Network\Water Lines" Cost_per_Unit 950 VB # CalculateField "Water Distribution Network\Water Lines" Expected_Life_Years 60 VB # CalculateField "Water Distribution Network\Water Lines" Cost_per_Unit 1550 VB # CalculateField "Water Distribution Network\Water Lines" Cost_per_Unit 1850 VB # CalculateField "Water Distribution Network\Water Lines" Expected_Life_Years 40 VB # CalculateField "Water Distribution Network\Water Lines" Cost_per_Unit 850 VB # CalculateField "Water Distribution Network\Water Lines" Cost_per_Unit 950 VB # CalculateField "Water Distribution Network\Water Lines" Tangible_Capital_Asset 2 VB # AddField "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Sanitary_Sewer\MasterEGDB.DBO.Sanitary_Sewer_Lines" PSAB_2018_Comments SHORT # # # "PSAB 2018 Comments" NULLABLE NON_REQUIRED COB_PSAB_Comment AddField "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Storm_Sewer\MasterEGDB.DBO.Storm_Sewer_Lines" PSAB_2018_Comments SHORT # # # "PSAB 2018 Comments" NULLABLE NON_REQUIRED COB_PSAB_Comment AddField "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines" PSAB_2018_Comments SHORT # # # "PSAB 2018 Comments" NULLABLE NON_REQUIRED COB_PSAB_Comment AssignDomainToField "Engineering\Water Distribution Network\Water Lines" Tangible_Capital_Asset "COB_Yes No NA Unknown" '101: Water - Main';'102: Water - Lateral';'105: Water - Fire Hydrant - Lateral';'109: Water - Private Lateral' CalculateField "Engineering\Water Distribution Network\Water Lines" Asset_Replacement_Value "!Cost_per_Unit! * !Shape.STLength()!" "Python 3" # CalculateField "Engineering\Water Distribution Network\Water Lines" Asset_Replacement_Value "$feature.Cost_per_Unit * $feature['Shape.STLength()']" Arcade # CalculateField "Engineering\Water Distribution Network\Water Lines" Loss_in_Value "$feature.Asset_Replacement_Value * .025" Arcade # CalculateField "Engineering\Water Distribution Network\Water Lines" Remaining_Value "$feature.Asset_Replacement_Value * .975" Arcade # CalculateField "Engineering\Water Distribution Network\Water Lines" Asset_Replacement_Value "$feature.Cost_per_Unit * $feature['Shape.STLength()']" Arcade # CalculateField "Engineering\Water Distribution Network\Water Lines" Loss_in_Value "$feature.Asset_Replacement_Value * .0166" Arcade # CalculateField "Engineering\Water Distribution Network\Water Lines" Remaining_Value "$feature.Asset_Replacement_Value - $feature.Loss_in_Value" Arcade # JoinField "Engineering\Water Distribution Network\Water Lines" OBJECTID "C:\GIS\ArcGIS Pro Layouts\WorkEGDB.sde\WorkEGDB.DBO.Spatial_Join_From_PIDWMeter_To_PrivateLateral4" TARGET_FID Related_PID_1;Related_PID CalculateField "Engineering\Water Distribution Network\Water Lines" Related_PID !Related_PID_1! "Python 3" # CalculateField "Engineering\Water Distribution Network\Water Lines" Asset_ID " !Related_PID_1! +".01LPV"" "Python 3" # DeleteField MasterEGDB.DBO.Water_Lines Related_PID_12;Related_PID_1;Related_PID_12_13;Related_PID_12_13_14;Related_PID_12_13_14_15;Related_PID_12_13_14_15_16;MeterRelated_PID_12_13_14;MeterRelated_Street_Name_1;MeterRelated_Street_Section_1;MeterLink_to_Ti_ins_1;Related_PID_12_13_14_15_16_17;Related_PID_12_13_14_15_16_1_18;Related_PID_12_13_14_15_16_1_19;MeterRelated_PID_12_13_14_15;MeterRelated_Street_Name_12;MeterRelated_Street_Section_12;MeterLink_to_Ti_ins_12;Related_PID_12_13_14_15_16_1_20;Related_PID_12_13_14_15_16_1_21;Related_PID_12_13_14_15_16_1_22;MeterRelated_PID_12_13_14_15_16;MeterRelated_Street_Name_12_13;MeterRelated_Street_Section__13;MeterLink_to_Ti_ins_12_13;MeterRelated_PID_12_13_14_15_17;MeterRelated_Street_Name_12__14;MeterRelated_Street_Section__14;MeterLink_to_Ti_ins_12_13_14 JoinField MasterEGDB.DBO.Water_Lines OBJECTID WorkEGDB.DBO.Spatial_Join_From_PIDWMeter_To_PrivateLateral9 TARGET_FID Related_PID_1;Related_Street_Name_1;Related_Street_Section_1;Link_to_As_Built_1;Link_to_Ti_ins_1 CalculateField MasterEGDB.DBO.Water_Lines Related_PID [Related_PID_1] VB # DeleteField MasterEGDB.DBO.Water_Lines Related_PID_1;Related_Street_Name_1;Related_Street_Section_1;Link_to_As_Built_1;Link_to_Ti_ins_1 FeatureClassToFeatureClass MasterEGDB.DBO.Water_Lines "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water" Water_Lines2 # "GlobalID "GlobalID" false false false 38 GlobalID 0 0 ,First,#,MasterEGDB.DBO.Water_Lines,GlobalID,-1,-1;Asset_Group "Asset Group" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines,Asset_Group,-1,-1;Asset_Type "Asset_Type" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines,Asset_Type,-1,-1;Asset_Subtype "Asset Subtype" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines,Asset_Subtype,-1,-1;Asset_ID "Asset_ID" true true false 50 Text 0 0 ,First,#,MasterEGDB.DBO.Water_Lines,Asset_ID,-1,-1;Related_PID "Related_PID" true true false 50 Text 0 0 ,First,#,MasterEGDB.DBO.Water_Lines,Related_PID,-1,-1;Closest_Civic_Address "Closest_Civic_Address" true true false 50 Text 0 0 ,First,#,MasterEGDB.DBO.Water_Lines,Closest_Civic_Address,-1,-1;Related_Civic_Number "Related_Civic_Number" true true false 50 Text 0 0 ,First,#,MasterEGDB.DBO.Water_Lines,Related_Civic_Number,-1,-1;Related_Street_Name "Related Street Name" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines,Related_Street_Name,-1,-1;Related_Street_Section "Related_Street_Section" true true false 8 Double 8 38 ,First,#,MasterEGDB.DBO.Water_Lines,Related_Street_Section,-1,-1;GeoLocation "GeoLocation" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines,GeoLocation,-1,-1;Grid_Reference "Grid_Reference" true true false 6 Text 0 0 ,First,#,MasterEGDB.DBO.Water_Lines,Grid_Reference,-1,-1;Installation_Year "Installation Year" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines,Installation_Year,-1,-1;Diameter "Diameter" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines,Diameter,-1,-1;Material "Material" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines,Material,-1,-1;Pipe_Class "Pipe Class" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines,Pipe_Class,-1,-1;Lateral_With_DBH "Lateral With DBH" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines,Lateral_With_DBH,-1,-1;Depth "Depth" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines,Depth,-1,-1;TTYYPPEE "TTYYPPEE" true true false 50 Text 0 0 ,First,#,MasterEGDB.DBO.Water_Lines,TTYYPPEE,-1,-1;Comments "Comments" true true false 60 Text 0 0 ,First,#,MasterEGDB.DBO.Water_Lines,Comments,-1,-1;Last_Maintenance_Inspection_Dat "Last Maintenance Inspection Date" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines,Last_Maintenance_Inspection_Dat,-1,-1;Link_to_As_Built "Link to As-Built" true true false 250 Text 0 0 ,First,#,MasterEGDB.DBO.Water_Lines,Link_to_As_Built,-1,-1;Link_to_Ti_Ins "Link to Ti-Ins" true true false 250 Text 0 0 ,First,#,MasterEGDB.DBO.Water_Lines,Link_to_Ti_Ins,-1,-1;Feature_Creator "Feature Creator" false true false 150 Text 0 0 ,First,#,MasterEGDB.DBO.Water_Lines,Feature_Creator,-1,-1;Creation_Date "Creation_Date" false true false 8 Date 0 0 ,First,#,MasterEGDB.DBO.Water_Lines,Creation_Date,-1,-1;Last_Editor "Last_Editor" false true false 255 Text 0 0 ,First,#,MasterEGDB.DBO.Water_Lines,Last_Editor,-1,-1;Last_Edit_Date "Last_Edit_Date" false true false 8 Date 0 0 ,First,#,MasterEGDB.DBO.Water_Lines,Last_Edit_Date,-1,-1;Jurisdiction "Jurisdiction" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines,Jurisdiction,-1,-1;Tangible_Capital_Asset "Tangible Capital Asset" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines,Tangible_Capital_Asset,-1,-1;Expected_Life_Years "Expected Life Years" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines,Expected_Life_Years,-1,-1;End_of_Life_Date "End of Life Date" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines,End_of_Life_Date,-1,-1;Remaining_Life_Years "Remaining Life Years" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines,Remaining_Life_Years,-1,-1;Remaining_Life_Percent "Remaining Life Percent" true true false 8 Double 8 38 ,First,#,MasterEGDB.DBO.Water_Lines,Remaining_Life_Percent,-1,-1;Condition_Rating "Condition Rating (1 to 5)" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines,Condition_Rating,-1,-1;Cost_per_Unit "Cost per Unit" true true false 8 Double 8 38 ,First,#,MasterEGDB.DBO.Water_Lines,Cost_per_Unit,-1,-1;Asset_Replacement_Value "Asset Replacement Value" true true false 8 Double 8 38 ,First,#,MasterEGDB.DBO.Water_Lines,Asset_Replacement_Value,-1,-1;Emergency_Asset_Replacement_Val "Emergency Asset Replacement Value" true true false 8 Double 8 38 ,First,#,MasterEGDB.DBO.Water_Lines,Emergency_Asset_Replacement_Val,-1,-1;Loss_in_Value "Loss in Value" true true false 8 Double 8 38 ,First,#,MasterEGDB.DBO.Water_Lines,Loss_in_Value,-1,-1;Remaining_Value "Remaining Value" true true false 8 Double 8 38 ,First,#,MasterEGDB.DBO.Water_Lines,Remaining_Value,-1,-1;Infrastructure_Deficit__Backlog "Infrastructure Deficit (Backlog)" true true false 8 Double 8 38 ,First,#,MasterEGDB.DBO.Water_Lines,Infrastructure_Deficit__Backlog,-1,-1;Show_When_Page_Name_Is_Not "Show_When_Page_Name_Is_Not" true true false 50 Text 0 0 ,First,#,MasterEGDB.DBO.Water_Lines,Show_When_Page_Name_Is_Not,-1,-1;PSAB_2016_Comments "PSAB 2016 Comments" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines,PSAB_2016_Comments,-1,-1;PSAB_2017_Comments "PSAb 2017 Comments" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines,PSAB_2017_Comments,-1,-1;Enabled "Enabled" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines,Enabled,-1,-1;PSAB_2018_Comments "PSAB 2018 Comments" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines,PSAB_2018_Comments,-1,-1;TempField "TempField" true true false 255 Text 0 0 ,First,#,MasterEGDB.DBO.Water_Lines,TempField,-1,-1;Shape_STLength__ "Shape_STLength__" false true true 0 Double 0 0 ,First,#,MasterEGDB.DBO.Water_Lines,Shape.STLength(),-1,-1" # JoinField MasterEGDB.DBO.Water_Lines2 OBJECTID WorkEGDB.DBO.Spatial_Join_From_PIDWMeter_To_PrivateLateral14 TARGET_FID Asset_ID_1;Related_PID_1;Related_Street_Name_1;Related_Street_Section_1;Link_to_As_Built_1;Link_to_Ti_ins_1 CalculateField MasterEGDB.DBO.Water_Lines2 Related_PID [Related_PID_1] VB # CalculateField MasterEGDB.DBO.Water_Lines2 Asset_ID [Related_PID]&".LPV" VB # CalculateField "Engineering\Water Distribution Network\Water Lines" Asset_ID $feature.Related_PID+".01LPV" Arcade # CalculateField MasterEGDB.DBO.Water_Lines2 Link_to_Ti_Ins ""X:\Plans\Tie-Ins\Tie-Ins - Laterals Valves (PID.Valve#.LVL)\"& [Asset_ID] &".pdf"" VB # DeleteField MasterEGDB.DBO.Water_Lines2 Asset_ID_1;Related_PID_1;Related_Street_Name_1;Related_Street_Section_1;Link_to_As_Built_1;Link_to_Ti_ins_1 JoinField MasterEGDB.DBO.Water_Lines2 OBJECTID WorkEGDB.DBO.Spatial_Join_From_ShutOffValve_To_WaterServiceLateral1 TARGET_FID Asset_ID;Related_PID;Link_to_Ti_Ins CalculateField MasterEGDB.DBO.Water_Lines2 Asset_ID [Asset_ID_1] VB # CalculateField MasterEGDB.DBO.Water_Lines2 Related_PID [Related_PID_1] VB # CalculateField MasterEGDB.DBO.Water_Lines2 Link_to_Ti_Ins [Link_to_Ti_Ins_1] VB # FeatureClassToFeatureClass MasterEGDB.DBO.Water_Lines2 "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water" Water_Lines3 # "GlobalID "GlobalID" false false false 38 GlobalID 0 0 ,First,#,MasterEGDB.DBO.Water_Lines2,GlobalID,-1,-1;Asset_Group "Asset Group" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines2,Asset_Group,-1,-1;Asset_Type "Asset_Type" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines2,Asset_Type,-1,-1;Asset_Subtype "Asset Subtype" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines2,Asset_Subtype,-1,-1;Asset_ID "Asset_ID" true true false 50 Text 0 0 ,First,#,MasterEGDB.DBO.Water_Lines2,Asset_ID,-1,-1;Related_PID "Related_PID" true true false 50 Text 0 0 ,First,#,MasterEGDB.DBO.Water_Lines2,Related_PID,-1,-1;Closest_Civic_Address "Closest_Civic_Address" true true false 50 Text 0 0 ,First,#,MasterEGDB.DBO.Water_Lines2,Closest_Civic_Address,-1,-1;Related_Civic_Number "Related_Civic_Number" true true false 50 Text 0 0 ,First,#,MasterEGDB.DBO.Water_Lines2,Related_Civic_Number,-1,-1;Related_Street_Name "Related Street Name" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines2,Related_Street_Name,-1,-1;Related_Street_Section "Related_Street_Section" true true false 8 Double 8 38 ,First,#,MasterEGDB.DBO.Water_Lines2,Related_Street_Section,-1,-1;GeoLocation "GeoLocation" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines2,GeoLocation,-1,-1;Grid_Reference "Grid_Reference" true true false 6 Text 0 0 ,First,#,MasterEGDB.DBO.Water_Lines2,Grid_Reference,-1,-1;Installation_Year "Installation Year" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines2,Installation_Year,-1,-1;Diameter "Diameter" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines2,Diameter,-1,-1;Material "Material" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines2,Material,-1,-1;Pipe_Class "Pipe Class" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines2,Pipe_Class,-1,-1;Lateral_With_DBH "Lateral With DBH" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines2,Lateral_With_DBH,-1,-1;Depth "Depth" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines2,Depth,-1,-1;TTYYPPEE "TTYYPPEE" true true false 50 Text 0 0 ,First,#,MasterEGDB.DBO.Water_Lines2,TTYYPPEE,-1,-1;Comments "Comments" true true false 60 Text 0 0 ,First,#,MasterEGDB.DBO.Water_Lines2,Comments,-1,-1;Last_Maintenance_Inspection_Dat "Last Maintenance Inspection Date" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines2,Last_Maintenance_Inspection_Dat,-1,-1;Link_to_As_Built "Link to As-Built" true true false 250 Text 0 0 ,First,#,MasterEGDB.DBO.Water_Lines2,Link_to_As_Built,-1,-1;Link_to_Ti_Ins "Link to Ti-Ins" true true false 250 Text 0 0 ,First,#,MasterEGDB.DBO.Water_Lines2,Link_to_Ti_Ins,-1,-1;Feature_Creator "Feature Creator" true true false 150 Text 0 0 ,First,#,MasterEGDB.DBO.Water_Lines2,Feature_Creator,-1,-1;Creation_Date "Creation_Date" true true false 8 Date 0 0 ,First,#,MasterEGDB.DBO.Water_Lines2,Creation_Date,-1,-1;Last_Editor "Last_Editor" true true false 255 Text 0 0 ,First,#,MasterEGDB.DBO.Water_Lines2,Last_Editor,-1,-1;Last_Edit_Date "Last_Edit_Date" true true false 8 Date 0 0 ,First,#,MasterEGDB.DBO.Water_Lines2,Last_Edit_Date,-1,-1;Jurisdiction "Jurisdiction" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines2,Jurisdiction,-1,-1;Tangible_Capital_Asset "Tangible Capital Asset" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines2,Tangible_Capital_Asset,-1,-1;Expected_Life_Years "Expected Life Years" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines2,Expected_Life_Years,-1,-1;End_of_Life_Date "End of Life Date" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines2,End_of_Life_Date,-1,-1;Remaining_Life_Years "Remaining Life Years" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines2,Remaining_Life_Years,-1,-1;Remaining_Life_Percent "Remaining Life Percent" true true false 8 Double 8 38 ,First,#,MasterEGDB.DBO.Water_Lines2,Remaining_Life_Percent,-1,-1;Condition_Rating "Condition Rating (1 to 5)" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines2,Condition_Rating,-1,-1;Cost_per_Unit "Cost per Unit" true true false 8 Double 8 38 ,First,#,MasterEGDB.DBO.Water_Lines2,Cost_per_Unit,-1,-1;Asset_Replacement_Value "Asset Replacement Value" true true false 8 Double 8 38 ,First,#,MasterEGDB.DBO.Water_Lines2,Asset_Replacement_Value,-1,-1;Emergency_Asset_Replacement_Val "Emergency Asset Replacement Value" true true false 8 Double 8 38 ,First,#,MasterEGDB.DBO.Water_Lines2,Emergency_Asset_Replacement_Val,-1,-1;Loss_in_Value "Loss in Value" true true false 8 Double 8 38 ,First,#,MasterEGDB.DBO.Water_Lines2,Loss_in_Value,-1,-1;Remaining_Value "Remaining Value" true true false 8 Double 8 38 ,First,#,MasterEGDB.DBO.Water_Lines2,Remaining_Value,-1,-1;Infrastructure_Deficit__Backlog "Infrastructure Deficit (Backlog)" true true false 8 Double 8 38 ,First,#,MasterEGDB.DBO.Water_Lines2,Infrastructure_Deficit__Backlog,-1,-1;Show_When_Page_Name_Is_Not "Show_When_Page_Name_Is_Not" true true false 50 Text 0 0 ,First,#,MasterEGDB.DBO.Water_Lines2,Show_When_Page_Name_Is_Not,-1,-1;PSAB_2016_Comments "PSAB 2016 Comments" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines2,PSAB_2016_Comments,-1,-1;PSAB_2017_Comments "PSAb 2017 Comments" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines2,PSAB_2017_Comments,-1,-1;Enabled "Enabled" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines2,Enabled,-1,-1;PSAB_2018_Comments "PSAB 2018 Comments" true true false 2 Short 0 5 ,First,#,MasterEGDB.DBO.Water_Lines2,PSAB_2018_Comments,-1,-1;TempField "TempField" true true false 255 Text 0 0 ,First,#,MasterEGDB.DBO.Water_Lines2,TempField,-1,-1;Shape_STLength__ "Shape_STLength__" false true true 0 Double 0 0 ,First,#,MasterEGDB.DBO.Water_Lines2,Shape.STLength(),-1,-1" # EnableEditorTracking "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" Feature_Creator Creation_Date Last_Editor Last_Edit_Date # DATABASE_TIME EnableAttachments "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" CalculateField MasterEGDB.DBO.Water_Lines3 TempField "$feature.Cost_per_Unit * $feature['Shape.STLength()']" Arcade # AddField MasterEGDB.DBO.Water_Lines3 Cost_For_Length "Double (double precision)" # # # "Cost For Length" NULLABLE NON_REQUIRED # JoinField MasterEGDB.DBO.Water_Lines3 OBJECTID "Asset Management\MasterEGDB.DBO.Asset_Equipments" OBJECTID Asset_Category;Asset_Class;Asset_Description;Asset_Name;Asset_SubClass;Asset_Totally_Depreciated;Climate_Change_Risk;Climate_Change_Risk_Impact;Climate_Change_Risk_Probability;Climate_Change_Risk_Type;Closing_Book_Value;Condition_Method;Cost_per_Unit_Readjustment;Historical_Acquisition_Cost1;Historical_Acquisition_Cost2;LifeCycle_Admin_Cost;LifeCycle_EmgReplacement_Cost;LifeCycle_End_of_Life_Cost;LifeCycle_Maintenance_Cost;LifeCycle_Maintenance_Source;LifeCycle_Operation_Cost;LifeCycle_Operation_Source;LifeCycle_Renewal_Cost;LifeCycle_Renewal_Source;LifeCycle_Replacement_Cost;LifeCycle_Replacement_Source;LifeCycle_Total_Cost;LifeCycle_Cost_Annual;Opening_Book_Value;Priority_Climate_Change;Priority_Essential_Asset;Priority_Failure;Priority_Final_Index;Priority_Health_Security;Priority_High_Value_Asset;Priority_Perceived_Value;Priority_Pertinence_Need;Priority_Positive_Finance;Priority_Strategic_Plan;Related_Service;Residual_Value;Salvage_Value AlterField MasterEGDB.DBO.Water_Lines3 Related_Civic_Number # "Related Civic Number" Text 50 NULLABLE DO_NOT_CLEAR AlterField MasterEGDB.DBO.Water_Lines3 Creation_Date # "Creation Date" Date 8 NULLABLE DO_NOT_CLEAR AlterField MasterEGDB.DBO.Water_Lines3 Last_Editor # "Last Editor" Text 255 NULLABLE DO_NOT_CLEAR AlterField MasterEGDB.DBO.Water_Lines3 Last_Edit_Date # "Last Edit Date" Date 8 NULLABLE DO_NOT_CLEAR AlterField MasterEGDB.DBO.Water_Lines3 Asset_ID # "Asset ID" Text 50 NULLABLE DO_NOT_CLEAR AlterField MasterEGDB.DBO.Water_Lines3 Related_PID # "Related PID" Text 50 NULLABLE DO_NOT_CLEAR AlterField MasterEGDB.DBO.Water_Lines3 Closest_Civic_Address # "Closest Civic Address" Text 50 NULLABLE DO_NOT_CLEAR AlterField MasterEGDB.DBO.Water_Lines3 Related_Street_Section # "Related Street Section" "Double (double precision)" 8 NULLABLE DO_NOT_CLEAR AlterField MasterEGDB.DBO.Water_Lines3 Link_to_As_Built # "Link to As-Built" Text 250 NULLABLE DO_NOT_CLEAR AlterField MasterEGDB.DBO.Water_Lines3 Link_to_Ti_Ins # "Link to Ti-Ins" Text 250 NULLABLE DO_NOT_CLEAR AlterField MasterEGDB.DBO.Water_Lines3 Grid_Reference # "Grid Reference" Text 6 NULLABLE DO_NOT_CLEAR AlterField MasterEGDB.DBO.Water_Lines3 Show_When_Page_Name_Is_Not # "Show When Page Name Is Not" Text 50 NULLABLE DO_NOT_CLEAR AlterField MasterEGDB.DBO.Water_Lines3 PSAB_2017_Comments # "PSAB 2017 Comments" "Short (small integer)" 2 NULLABLE DO_NOT_CLEAR AlterField MasterEGDB.DBO.Water_Lines3 Asset_Type # "Asset Type" "Short (small integer)" 2 NULLABLE DO_NOT_CLEAR CalculateField "Engineering\Water - Lines" Cost_For_Length "$feature.Cost_per_Unit * $feature['Shape.STLength()']" Arcade # CalculateField "Engineering\Water - Lines" TempField $feature.Asset_ID Arcade # CalculateField "Engineering\Water - Lines" TempField replace(!TempField!) "Python 3" "import re\ndef replace(val) :\n return re.sub('WMN', '', val)" AssignDomainToField C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3 Asset_Category COB_Asset_Category # AssignDomainToField MasterEGDB.DBO.Water_Lines3 Asset_Category COB_Asset_Category '101: Water - Main';'102: Water - Lateral';'105: Water - Fire Hydrant - Lateral';'109: Water - Private Lateral' AssignDomainToField C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3 Asset_Class COB_Asset_Class '101: Water - Main';'102: Water - Lateral';'105: Water - Fire Hydrant - Lateral';'109: Water - Private Lateral' AssignDomainToField C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3 Asset_SubClass COB_Asset_SubClass '101: Water - Main';'102: Water - Lateral';'105: Water - Fire Hydrant - Lateral';'109: Water - Private Lateral' AssignDomainToField C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3 Condition_Method COB_Conditon_Method '101: Water - Main';'102: Water - Lateral';'105: Water - Fire Hydrant - Lateral';'109: Water - Private Lateral' AssignDomainToField C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3 Condition_Rating COB_Condition_Rating '101: Water - Main';'102: Water - Lateral';'105: Water - Fire Hydrant - Lateral';'109: Water - Private Lateral' AssignDomainToField C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3 Asset_Totally_Depreciated "COB_Yes No NA Unknown" '101: Water - Main';'102: Water - Lateral';'105: Water - Fire Hydrant - Lateral';'109: Water - Private Lateral' AssignDomainToField C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3 LifeCycle_Maintenance_Source COB_Funding_Sources '101: Water - Main';'102: Water - Lateral';'105: Water - Fire Hydrant - Lateral';'109: Water - Private Lateral' AssignDomainToField C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3 LifeCycle_Operation_Source COB_Funding_Sources '101: Water - Main';'102: Water - Lateral';'105: Water - Fire Hydrant - Lateral';'109: Water - Private Lateral' AssignDomainToField C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3 LifeCycle_Renewal_Source COB_Funding_Sources '101: Water - Main';'102: Water - Lateral';'105: Water - Fire Hydrant - Lateral';'109: Water - Private Lateral' AssignDomainToField C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3 LifeCycle_Replacement_Source COB_Funding_Sources '101: Water - Main';'102: Water - Lateral';'105: Water - Fire Hydrant - Lateral';'109: Water - Private Lateral' AssignDomainToField C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3 Climate_Change_Risk "COB_Yes No NA Unknown" '101: Water - Main';'102: Water - Lateral';'105: Water - Fire Hydrant - Lateral';'109: Water - Private Lateral' AssignDomainToField C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3 Climate_Change_Risk_Type COB_Climate_Change_Risk_Type '101: Water - Main';'102: Water - Lateral';'105: Water - Fire Hydrant - Lateral';'109: Water - Private Lateral' AssignDomainToField C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3 Climate_Change_Risk_Probability COB_Climate_Change_Risk_Probability '101: Water - Main';'102: Water - Lateral';'105: Water - Fire Hydrant - Lateral';'109: Water - Private Lateral' AssignDomainToField C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3 Climate_Change_Risk_Impact COB_Climate_Change_Risk_Impact '101: Water - Main';'102: Water - Lateral';'105: Water - Fire Hydrant - Lateral';'109: Water - Private Lateral' UpdateSchema MasterEGDB.DBO.Water_Lines3 <operationSequence><workflow><AssignDefaultToField><field_name>Asset_Group</field_name><default_value>1</default_value><subtype_code>101</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>Jurisdiction</field_name><default_value>1</default_value><subtype_code>101</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>Tangible_Capital_Asset</field_name><default_value>1</default_value><subtype_code>101</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>Condition_Rating</field_name><clear_value>True</clear_value><subtype_code>101</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>Asset_Category</field_name><default_value>3</default_value><subtype_code>101</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>Asset_Class</field_name><default_value>7</default_value><subtype_code>101</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>Asset_SubClass</field_name><clear_value>True</clear_value><subtype_code>101</subtype_code></AssignDefaultToField></workflow><workflow><AssignDefaultToField><field_name>Asset_Group</field_name><default_value>1</default_value><subtype_code>102</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>Jurisdiction</field_name><default_value>1</default_value><subtype_code>102</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>Tangible_Capital_Asset</field_name><default_value>2</default_value><subtype_code>102</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>Asset_Category</field_name><default_value>4</default_value><subtype_code>102</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>Asset_Class</field_name><default_value>7</default_value><subtype_code>102</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>Asset_SubClass</field_name><clear_value>True</clear_value><subtype_code>102</subtype_code></AssignDefaultToField></workflow><workflow><AssignDefaultToField><field_name>Asset_Group</field_name><default_value>1</default_value><subtype_code>105</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>Jurisdiction</field_name><default_value>1</default_value><subtype_code>105</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>Tangible_Capital_Asset</field_name><default_value>2</default_value><subtype_code>105</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>Asset_Category</field_name><default_value>4</default_value><subtype_code>105</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>Asset_Class</field_name><default_value>7</default_value><subtype_code>105</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>Asset_SubClass</field_name><clear_value>True</clear_value><subtype_code>105</subtype_code></AssignDefaultToField></workflow><workflow><AssignDefaultToField><field_name>Asset_Group</field_name><default_value>1</default_value><subtype_code>109</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>Jurisdiction</field_name><default_value>3</default_value><subtype_code>109</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>Tangible_Capital_Asset</field_name><default_value>2</default_value><subtype_code>109</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>Asset_Category</field_name><default_value>4</default_value><subtype_code>109</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>Asset_Class</field_name><default_value>7</default_value><subtype_code>109</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>Asset_SubClass</field_name><clear_value>True</clear_value><subtype_code>109</subtype_code></AssignDefaultToField></workflow></operationSequence> UpdateSchema MasterEGDB.DBO.Water_Lines3 "<operationSequence><workflow><DeleteCodedValueFromDomain><domain_name>COB_Asset_SubClass</domain_name><code>508</code><code>509</code><code>600</code></DeleteCodedValueFromDomain><AddCodedValueToDomain><domain_name>COB_Asset_SubClass</domain_name><code>508</code><code_description>WasteWater - Storm Sewer Collection Network</code_description></AddCodedValueToDomain><AddCodedValueToDomain><domain_name>COB_Asset_SubClass</domain_name><code>509</code><code_description>WasteWater - Sanitary Sewer Collection Netwotk</code_description></AddCodedValueToDomain><AddCodedValueToDomain><domain_name>COB_Asset_SubClass</domain_name><code>608</code><code_description>Water - Distribution Network</code_description></AddCodedValueToDomain><SortCodedValueDomain><domain_name>COB_Asset_SubClass</domain_name><descending>ASCENDING</descending><sortByDescription>CODE</sortByDescription></SortCodedValueDomain></workflow><workflow><AssignDefaultToField><field_name>Asset_SubClass</field_name><clear_value>True</clear_value><subtype_code>101</subtype_code></AssignDefaultToField></workflow><workflow><AssignDefaultToField><field_name>Asset_SubClass</field_name><clear_value>True</clear_value><subtype_code>102</subtype_code></AssignDefaultToField></workflow><workflow><AssignDefaultToField><field_name>Asset_SubClass</field_name><clear_value>True</clear_value><subtype_code>105</subtype_code></AssignDefaultToField></workflow><workflow><AssignDefaultToField><field_name>Asset_SubClass</field_name><clear_value>True</clear_value><subtype_code>109</subtype_code></AssignDefaultToField></workflow></operationSequence>" UpdateSchema MasterEGDB.DBO.Water_Lines3 <operationSequence><workflow><AssignDefaultToField><field_name>Asset_SubClass</field_name><default_value>608</default_value><subtype_code>101</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>residual_value</field_name><default_value>0</default_value><subtype_code>101</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>Condition_Method</field_name><default_value>1</default_value><subtype_code>101</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>salvage_value</field_name><default_value>0</default_value><subtype_code>101</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>Climate_Change_Risk</field_name><default_value>2</default_value><subtype_code>101</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>Climate_Change_Risk_Type</field_name><default_value>0</default_value><subtype_code>101</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>Climate_Change_Risk_Probability</field_name><default_value>0</default_value><subtype_code>101</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>Climate_Change_Risk_Impact</field_name><default_value>0</default_value><subtype_code>101</subtype_code></AssignDefaultToField></workflow><workflow><AssignDefaultToField><field_name>Asset_SubClass</field_name><default_value>608</default_value><subtype_code>102</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>residual_value</field_name><default_value>0</default_value><subtype_code>102</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>Condition_Method</field_name><default_value>1</default_value><subtype_code>102</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>salvage_value</field_name><default_value>0</default_value><subtype_code>102</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>Climate_Change_Risk</field_name><default_value>2</default_value><subtype_code>102</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>Climate_Change_Risk_Type</field_name><default_value>0</default_value><subtype_code>102</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>Climate_Change_Risk_Probability</field_name><default_value>0</default_value><subtype_code>102</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>Climate_Change_Risk_Impact</field_name><default_value>0</default_value><subtype_code>102</subtype_code></AssignDefaultToField></workflow><workflow><AssignDefaultToField><field_name>Asset_SubClass</field_name><default_value>608</default_value><subtype_code>105</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>residual_value</field_name><default_value>0</default_value><subtype_code>105</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>Condition_Method</field_name><default_value>1</default_value><subtype_code>105</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>salvage_value</field_name><default_value>0</default_value><subtype_code>105</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>Climate_Change_Risk</field_name><default_value>2</default_value><subtype_code>105</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>Climate_Change_Risk_Type</field_name><default_value>0</default_value><subtype_code>105</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>Climate_Change_Risk_Probability</field_name><default_value>0</default_value><subtype_code>105</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>Climate_Change_Risk_Impact</field_name><default_value>0</default_value><subtype_code>105</subtype_code></AssignDefaultToField></workflow><workflow><AssignDefaultToField><field_name>Asset_SubClass</field_name><default_value>608</default_value><subtype_code>109</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>residual_value</field_name><default_value>0</default_value><subtype_code>109</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>Condition_Method</field_name><default_value>1</default_value><subtype_code>109</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>salvage_value</field_name><default_value>0</default_value><subtype_code>109</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>Climate_Change_Risk</field_name><default_value>2</default_value><subtype_code>109</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>Climate_Change_Risk_Type</field_name><default_value>0</default_value><subtype_code>109</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>Climate_Change_Risk_Probability</field_name><default_value>0</default_value><subtype_code>109</subtype_code></AssignDefaultToField><AssignDefaultToField><field_name>Climate_Change_Risk_Impact</field_name><default_value>0</default_value><subtype_code>109</subtype_code></AssignDefaultToField></workflow></operationSequence> AssignDomainToField C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3 Priority_Failure COB_Priority '101: Water - Main';'102: Water - Lateral';'105: Water - Fire Hydrant - Lateral';'109: Water - Private Lateral' AssignDomainToField C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3 Priority_Health_Security COB_Priority '101: Water - Main';'102: Water - Lateral';'105: Water - Fire Hydrant - Lateral';'109: Water - Private Lateral' AssignDomainToField C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3 Priority_Climate_Change COB_Priority '101: Water - Main';'102: Water - Lateral';'105: Water - Fire Hydrant - Lateral';'109: Water - Private Lateral' AssignDomainToField C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3 Priority_Essential_Asset COB_Priority '101: Water - Main';'102: Water - Lateral';'105: Water - Fire Hydrant - Lateral';'109: Water - Private Lateral' AssignDomainToField C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3 Priority_High_Value_Asset COB_Priority '101: Water - Main';'102: Water - Lateral';'105: Water - Fire Hydrant - Lateral';'109: Water - Private Lateral' AssignDomainToField C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3 Priority_Positive_Finance COB_Priority '101: Water - Main';'102: Water - Lateral';'105: Water - Fire Hydrant - Lateral';'109: Water - Private Lateral' AssignDomainToField C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3 Priority_Strategic_Plan COB_Priority '101: Water - Main';'102: Water - Lateral';'105: Water - Fire Hydrant - Lateral';'109: Water - Private Lateral' AssignDomainToField C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3 Priority_Perceived_Value COB_Priority '101: Water - Main';'102: Water - Lateral';'105: Water - Fire Hydrant - Lateral';'109: Water - Private Lateral' AssignDomainToField C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3 Priority_Pertinence_Need COB_Priority '101: Water - Main';'102: Water - Lateral';'105: Water - Fire Hydrant - Lateral';'109: Water - Private Lateral' UpdateSchema MasterEGDB.DBO.Water_Lines3 <operationSequence><workflow><AssignDomainToField><field_name>priority_failure</field_name><domain_name>COB_Priority</domain_name><subtype_code>101</subtype_code></AssignDomainToField><AssignDefaultToField><field_name>priority_failure</field_name><default_value>0</default_value><subtype_code>101</subtype_code></AssignDefaultToField><AssignDomainToField><field_name>priority_health_security</field_name><domain_name>COB_Priority</domain_name><subtype_code>101</subtype_code></AssignDomainToField><AssignDefaultToField><field_name>priority_health_security</field_name><default_value>0</default_value><subtype_code>101</subtype_code></AssignDefaultToField><AssignDomainToField><field_name>priority_climate_change</field_name><domain_name>COB_Priority</domain_name><subtype_code>101</subtype_code></AssignDomainToField><AssignDefaultToField><field_name>priority_climate_change</field_name><default_value>0</default_value><subtype_code>101</subtype_code></AssignDefaultToField><AssignDomainToField><field_name>priority_essential_asset</field_name><domain_name>COB_Priority</domain_name><subtype_code>101</subtype_code></AssignDomainToField><AssignDefaultToField><field_name>priority_essential_asset</field_name><default_value>0</default_value><subtype_code>101</subtype_code></AssignDefaultToField><AssignDomainToField><field_name>priority_high_value_asset</field_name><domain_name>COB_Priority</domain_name><subtype_code>101</subtype_code></AssignDomainToField><AssignDefaultToField><field_name>priority_high_value_asset</field_name><default_value>0</default_value><subtype_code>101</subtype_code></AssignDefaultToField><AssignDomainToField><field_name>priority_positive_finance</field_name><domain_name>COB_Priority</domain_name><subtype_code>101</subtype_code></AssignDomainToField><AssignDefaultToField><field_name>priority_positive_finance</field_name><default_value>0</default_value><subtype_code>101</subtype_code></AssignDefaultToField><AssignDomainToField><field_name>priority_strategic_plan</field_name><domain_name>COB_Priority</domain_name><subtype_code>101</subtype_code></AssignDomainToField><AssignDefaultToField><field_name>priority_strategic_plan</field_name><default_value>0</default_value><subtype_code>101</subtype_code></AssignDefaultToField><AssignDomainToField><field_name>priority_perceived_value</field_name><domain_name>COB_Priority</domain_name><subtype_code>101</subtype_code></AssignDomainToField><AssignDefaultToField><field_name>priority_perceived_value</field_name><default_value>0</default_value><subtype_code>101</subtype_code></AssignDefaultToField><AssignDomainToField><field_name>priority_pertinence_need</field_name><domain_name>COB_Priority</domain_name><subtype_code>101</subtype_code></AssignDomainToField><AssignDefaultToField><field_name>priority_pertinence_need</field_name><default_value>0</default_value><subtype_code>101</subtype_code></AssignDefaultToField></workflow><workflow><AssignDomainToField><field_name>priority_failure</field_name><domain_name>COB_Priority</domain_name><subtype_code>102</subtype_code></AssignDomainToField><AssignDefaultToField><field_name>priority_failure</field_name><default_value>0</default_value><subtype_code>102</subtype_code></AssignDefaultToField><AssignDomainToField><field_name>priority_health_security</field_name><domain_name>COB_Priority</domain_name><subtype_code>102</subtype_code></AssignDomainToField><AssignDefaultToField><field_name>priority_health_security</field_name><default_value>0</default_value><subtype_code>102</subtype_code></AssignDefaultToField><AssignDomainToField><field_name>priority_climate_change</field_name><domain_name>COB_Priority</domain_name><subtype_code>102</subtype_code></AssignDomainToField><AssignDefaultToField><field_name>priority_climate_change</field_name><default_value>0</default_value><subtype_code>102</subtype_code></AssignDefaultToField><AssignDomainToField><field_name>priority_essential_asset</field_name><domain_name>COB_Priority</domain_name><subtype_code>102</subtype_code></AssignDomainToField><AssignDefaultToField><field_name>priority_essential_asset</field_name><default_value>0</default_value><subtype_code>102</subtype_code></AssignDefaultToField><AssignDomainToField><field_name>priority_high_value_asset</field_name><domain_name>COB_Priority</domain_name><subtype_code>102</subtype_code></AssignDomainToField><AssignDefaultToField><field_name>priority_high_value_asset</field_name><default_value>0</default_value><subtype_code>102</subtype_code></AssignDefaultToField><AssignDomainToField><field_name>priority_positive_finance</field_name><domain_name>COB_Priority</domain_name><subtype_code>102</subtype_code></AssignDomainToField><AssignDefaultToField><field_name>priority_positive_finance</field_name><default_value>0</default_value><subtype_code>102</subtype_code></AssignDefaultToField><AssignDomainToField><field_name>priority_strategic_plan</field_name><domain_name>COB_Priority</domain_name><subtype_code>102</subtype_code></AssignDomainToField><AssignDefaultToField><field_name>priority_strategic_plan</field_name><default_value>0</default_value><subtype_code>102</subtype_code></AssignDefaultToField><AssignDomainToField><field_name>priority_perceived_value</field_name><domain_name>COB_Priority</domain_name><subtype_code>102</subtype_code></AssignDomainToField><AssignDefaultToField><field_name>priority_perceived_value</field_name><default_value>0</default_value><subtype_code>102</subtype_code></AssignDefaultToField><AssignDomainToField><field_name>priority_pertinence_need</field_name><domain_name>COB_Priority</domain_name><subtype_code>102</subtype_code></AssignDomainToField><AssignDefaultToField><field_name>priority_pertinence_need</field_name><default_value>0</default_value><subtype_code>102</subtype_code></AssignDefaultToField></workflow><workflow><AssignDomainToField><field_name>priority_failure</field_name><domain_name>COB_Priority</domain_name><subtype_code>105</subtype_code></AssignDomainToField><AssignDefaultToField><field_name>priority_failure</field_name><default_value>0</default_value><subtype_code>105</subtype_code></AssignDefaultToField><AssignDomainToField><field_name>priority_health_security</field_name><domain_name>COB_Priority</domain_name><subtype_code>105</subtype_code></AssignDomainToField><AssignDefaultToField><field_name>priority_health_security</field_name><default_value>0</default_value><subtype_code>105</subtype_code></AssignDefaultToField><AssignDomainToField><field_name>priority_climate_change</field_name><domain_name>COB_Priority</domain_name><subtype_code>105</subtype_code></AssignDomainToField><AssignDefaultToField><field_name>priority_climate_change</field_name><default_value>0</default_value><subtype_code>105</subtype_code></AssignDefaultToField><AssignDomainToField><field_name>priority_essential_asset</field_name><domain_name>COB_Priority</domain_name><subtype_code>105</subtype_code></AssignDomainToField><AssignDefaultToField><field_name>priority_essential_asset</field_name><default_value>0</default_value><subtype_code>105</subtype_code></AssignDefaultToField><AssignDomainToField><field_name>priority_high_value_asset</field_name><domain_name>COB_Priority</domain_name><subtype_code>105</subtype_code></AssignDomainToField><AssignDefaultToField><field_name>priority_high_value_asset</field_name><default_value>0</default_value><subtype_code>105</subtype_code></AssignDefaultToField><AssignDomainToField><field_name>priority_positive_finance</field_name><domain_name>COB_Priority</domain_name><subtype_code>105</subtype_code></AssignDomainToField><AssignDefaultToField><field_name>priority_positive_finance</field_name><default_value>0</default_value><subtype_code>105</subtype_code></AssignDefaultToField><AssignDomainToField><field_name>priority_strategic_plan</field_name><domain_name>COB_Priority</domain_name><subtype_code>105</subtype_code></AssignDomainToField><AssignDefaultToField><field_name>priority_strategic_plan</field_name><default_value>0</default_value><subtype_code>105</subtype_code></AssignDefaultToField><AssignDomainToField><field_name>priority_perceived_value</field_name><domain_name>COB_Priority</domain_name><subtype_code>105</subtype_code></AssignDomainToField><AssignDefaultToField><field_name>priority_perceived_value</field_name><default_value>0</default_value><subtype_code>105</subtype_code></AssignDefaultToField><AssignDomainToField><field_name>priority_pertinence_need</field_name><domain_name>COB_Priority</domain_name><subtype_code>105</subtype_code></AssignDomainToField><AssignDefaultToField><field_name>priority_pertinence_need</field_name><default_value>0</default_value><subtype_code>105</subtype_code></AssignDefaultToField></workflow><workflow><AssignDomainToField><field_name>priority_failure</field_name><domain_name>COB_Priority</domain_name><subtype_code>109</subtype_code></AssignDomainToField><AssignDefaultToField><field_name>priority_failure</field_name><default_value>0</default_value><subtype_code>109</subtype_code></AssignDefaultToField><AssignDomainToField><field_name>priority_health_security</field_name><domain_name>COB_Priority</domain_name><subtype_code>109</subtype_code></AssignDomainToField><AssignDefaultToField><field_name>priority_health_security</field_name><default_value>0</default_value><subtype_code>109</subtype_code></AssignDefaultToField><AssignDomainToField><field_name>priority_climate_change</field_name><domain_name>COB_Priority</domain_name><subtype_code>109</subtype_code></AssignDomainToField><AssignDefaultToField><field_name>priority_climate_change</field_name><default_value>0</default_value><subtype_code>109</subtype_code></AssignDefaultToField><AssignDomainToField><field_name>priority_essential_asset</field_name><domain_name>COB_Priority</domain_name><subtype_code>109</subtype_code></AssignDomainToField><AssignDefaultToField><field_name>priority_essential_asset</field_name><default_value>0</default_value><subtype_code>109</subtype_code></AssignDefaultToField><AssignDomainToField><field_name>priority_high_value_asset</field_name><domain_name>COB_Priority</domain_name><subtype_code>109</subtype_code></AssignDomainToField><AssignDefaultToField><field_name>priority_high_value_asset</field_name><default_value>0</default_value><subtype_code>109</subtype_code></AssignDefaultToField><AssignDomainToField><field_name>priority_positive_finance</field_name><domain_name>COB_Priority</domain_name><subtype_code>109</subtype_code></AssignDomainToField><AssignDefaultToField><field_name>priority_positive_finance</field_name><default_value>0</default_value><subtype_code>109</subtype_code></AssignDefaultToField><AssignDomainToField><field_name>priority_strategic_plan</field_name><domain_name>COB_Priority</domain_name><subtype_code>109</subtype_code></AssignDomainToField><AssignDefaultToField><field_name>priority_strategic_plan</field_name><default_value>0</default_value><subtype_code>109</subtype_code></AssignDefaultToField><AssignDomainToField><field_name>priority_perceived_value</field_name><domain_name>COB_Priority</domain_name><subtype_code>109</subtype_code></AssignDomainToField><AssignDefaultToField><field_name>priority_perceived_value</field_name><default_value>0</default_value><subtype_code>109</subtype_code></AssignDefaultToField><AssignDomainToField><field_name>priority_pertinence_need</field_name><domain_name>COB_Priority</domain_name><subtype_code>109</subtype_code></AssignDomainToField><AssignDefaultToField><field_name>priority_pertinence_need</field_name><default_value>0</default_value><subtype_code>109</subtype_code></AssignDefaultToField></workflow></operationSequence> AddField C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3 Replacement_Cost_per_Unit "Double (double precision)" # # # "Replacement Cost per Unit" NULLABLE NON_REQUIRED # AddField C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3 TempField3 Text # # # "Replacement Cost per Unit" NULLABLE NON_REQUIRED # AlterField C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3 Replacement_Cost_per_Unit # TempField3 "Double (double precision)" 8 NULLABLE DO_NOT_CLEAR AlterField C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3 Replacement_Cost_per_Unit # TempField3 "Double (double precision)" 8 NULLABLE DO_NOT_CLEAR DeleteField C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3 TempField3;Replacement_Cost_per_Unit AddField C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3 Replacement_Cost_per_Unit "Double (double precision)" # # # "Replacement Cost per Unit" NULLABLE NON_REQUIRED # 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.2.0'><FeatureDataset>MasterEGDB.DBO.Water</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e682b616f54534847334d43747532724d45566831356132366f7659576866622f3030374747523175466347633d2a00;SERVER=SRV-CH-SQLARCGIS;INSTANCE=sde:sqlserver:SRV-CH-SQLARCGIS;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SRV-CH-SQLARCGIS;DATABASE=MasterEGDB;USER=arcgissql_svc;VERSION=DBO.First_Child;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>MasterEGDB.DBO.Water_Lines3</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>Replacement_Cost_per_Unit</field_name></DeleteField></workflow></operationSequence> AddField C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3 Replacement_Cost_per_Unit "Double (double precision)" # # # "Replacement Cost per Unit" NULLABLE NON_REQUIRED # AddField C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3 TempField3 "Double (double precision)" # # # TempField3 NULLABLE NON_REQUIRED # AddField C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3 TempField2 Text # # # TempField2 NULLABLE NON_REQUIRED # CalculateField C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3 Replacement_Cost_per_Unit $feature.Cost_per_Unit Arcade # CalculateField C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3 Cost_per_Unit Null Arcade # JoinField C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3 TempField WorkEGDB.DBO.Water_Deprec FA_ASSET_CODE FA_ASSET_CODE;FA_CLASS_CODE;FA_SCHED_STATUS;LIFE_EXPECTANCY;SCHED_NAME;START_DATE;DEPREC_VALUE CalculateField C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3 Cost_per_Unit $feature.DEPREC_VALUE Arcade # AssignDefaultToField C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3 Asset_Group 1 # DO_NOT_CLEAR 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.2.0'><FeatureDataset>MasterEGDB.DBO.Water</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e682b616f54534847334d43747532724d45566831356132366f7659576866622f3030374747523175466347633d2a00;SERVER=SRV-CH-SQLARCGIS;INSTANCE=sde:sqlserver:SRV-CH-SQLARCGIS;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SRV-CH-SQLARCGIS;DATABASE=MasterEGDB;USER=arcgissql_svc;VERSION=DBO.First_Child;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>MasterEGDB.DBO.Water_Lines3</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>Loss_in_Value</field_name></DeleteField></workflow></operationSequence> 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.2.0'><FeatureDataset>MasterEGDB.DBO.Water</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e682b616f54534847334d43747532724d45566831356132366f7659576866622f3030374747523175466347633d2a00;SERVER=SRV-CH-SQLARCGIS;INSTANCE=sde:sqlserver:SRV-CH-SQLARCGIS;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SRV-CH-SQLARCGIS;DATABASE=MasterEGDB;USER=arcgissql_svc;VERSION=DBO.First_Child;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>MasterEGDB.DBO.Water_Lines3</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>Cost_per_Unit</field_name></DeleteField></workflow></operationSequence> DeleteField "C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB (Admin).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" Loss_in_Value AddField "C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB (Admin).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" Loss_in_Value_Year "Double (double precision)" 38 8 # "Loss in Value (This Year)" NULLABLE NON_REQUIRED # AddField "C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB (Admin).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" Loss_In_Value_Total "Double (double precision)" 38 8 # "Loss in Value (Since Acquisition)" NULLABLE NON_REQUIRED # AddAttributeRule "C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB (Admin).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" "Water - Remaining Life Years" Calculation "var RemainingLife = ($feature.Installation_Year + $feature.Expected_Life_Years) - Year(now()) if (RemainingLife<0) { 0 } else { RemainingLife }" NONEDITABLE UPDATE # # "Water - Remaining Life Years" ALL Remaining_Life_Years INCLUDE AddAttributeRule "C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB (Admin).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" "Water - Remaining Life Percent" Calculation "var RemainingLife = ($feature.Installation_Year + $feature.Expected_Life_Years) - Year(now()) var RemainingLifePercent = (RemainingLife / $feature.Expected_Life_Years) * 100 if (RemainingLife<0) { 0 } else { RemainingLifePercent }" NONEDITABLE UPDATE # # "Water - Remaining Life Percent" ALL Remaining_Life_Percent INCLUDE AddAttributeRule "C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB (Admin).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" "Water - Asset Replacement Value" Calculation "$feature.Replacement_Cost_per_Unit * $feature['Shape.STLength()']" NONEDITABLE UPDATE # # "Water - Asset Replacement Value" ALL Asset_Replacement_Value INCLUDE AddAttributeRule "C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB (Admin).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" "Water - Remaining Value" Calculation "var DepreciableValue = ($feature.Cost_per_Unit - $feature.Residual_Value) Var OpeningBookYearsOfDepreciation = ((Year(Now())-2) - ($feature.Installation_Year)) var AnnualDepreciationLost = (DepreciableValue / $feature.Expected_Life_Years) var RemainingAssetYears = ( $feature.Expected_Life_Years - OpeningBookYearsOfDepreciation ) var OpeningBookValue = RemainingAssetYears * AnnualDepreciationLost if (RemainingAssetYears<=0) { 0 + $feature.Residual_Value } else { OpeningBookValue - AnnualDepreciationLost + $feature.Residual_Value }" NONEDITABLE UPDATE # # "Water - Remaining Value" ALL Remaining_Value INCLUDE AddAttributeRule "C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB (Admin).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" "Water - Opening Book Value" Calculation "var DepreciableValue = ($feature.Cost_per_Unit - $feature.Residual_Value) Var OpeningBookYearsOfDepreciation = ((Year(Now())-2) - ($feature.Installation_Year)) var AnnualDepreciationLost = (DepreciableValue / $feature.Expected_Life_Years) var RemainingAssetYears = ( $feature.Expected_Life_Years - OpeningBookYearsOfDepreciation ) var OpeningBookValue = RemainingAssetYears * AnnualDepreciationLost if (RemainingAssetYears==1) { AnnualDepreciationLost } else if (RemainingAssetYears<1) { 0 } else { RemainingAssetYears * AnnualDepreciationLost }" NONEDITABLE UPDATE # # "Water - Opening Book Value" ALL Opening_Book_Value INCLUDE AddAttributeRule "C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB (Admin).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" "Water - Closing Book Value" Calculation "var DepreciableValue = ($feature.Cost_per_Unit - $feature.Residual_Value) Var OpeningBookYearsOfDepreciation = ((Year(Now())-2) - ($feature.Installation_Year)) var AnnualDepreciationLost = (DepreciableValue / $feature.Expected_Life_Years) var RemainingAssetYears = ( $feature.Expected_Life_Years - OpeningBookYearsOfDepreciation ) var OpeningBookValue = RemainingAssetYears * AnnualDepreciationLost if (RemainingAssetYears<=0) { 0 } else { OpeningBookValue - AnnualDepreciationLost }" NONEDITABLE UPDATE # # "Water - Closing Book Value" ALL Closing_Book_Value INCLUDE AddAttributeRule "C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB (Admin).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" "Water - Loss in Value This Year" Calculation "var DepreciableValue = ($feature.Cost_per_Unit - $feature.Residual_Value) Var RemainingYears =($feature.Installation_Year + $feature.Expected_Life_Years)-Year(Now()) var LostThisYear = (DepreciableValue / $feature.Expected_Life_Years) if ((RemainingYears + 1)<0) { 0 } else { LostThisYear }" NONEDITABLE UPDATE # # "Water - Loss in Value This Year" ALL Loss_in_Value_Year INCLUDE AddAttributeRule "C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB (Admin).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" "Water - Loss in Value Total" Calculation "var PreviousBookYear = (Year(Now())-1) var AnnualDepreciationLost = ($feature.Cost_per_Unit / $feature.Expected_Life_Years) Var AssetIsTotalyDepreciated = ($feature.Cost_per_Unit) Var ThisYearBookDepreciability = (($feature.Installation_Year + $feature.Expected_Life_Years) - (Year(Now())-1)) Var YearsOfDepreciation = ((Year(Now())-1) - ($feature.Installation_Year)) If (ThisYearBookDepreciability<0) { AssetIsTotalyDepreciated } else { AnnualDepreciationLost * YearsOfDepreciation }" NONEDITABLE UPDATE # # "Water - Loss in Value Total" ALL Loss_In_Value_Total INCLUDE AddAttributeRule "C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB (Admin).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" "Water - Condition Rating" Calculation "var PercentRemaining = (((($feature.Installation_Year + $feature.Expected_Life_Years)-Year(now()))/$feature.Expected_Life_Years) * 100) if (PercentRemaining<20) { 5 } else if ((PercentRemaining>=20) && (PercentRemaining<40)) { 4 } else if ((PercentRemaining>=40) && (PercentRemaining<60)) { 3 } else if ((PercentRemaining>=60) && (PercentRemaining<80)) { 2 } else if (PercentRemaining>=80) { 1 }" NONEDITABLE UPDATE # # "Water - Condition Rating" ALL Condition_Rating INCLUDE AddAttributeRule "C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB (Admin).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" "Water - Asset Totaly Depreciated" Calculation "Var OpeningBookYearsOfDepreciation = ((Year(Now())-2) - ($feature.Installation_Year)) var RemainingAssetYears = ( $feature.Expected_Life_Years - OpeningBookYearsOfDepreciation ) if (RemainingAssetYears<=0) { 1 } else { 2 }" NONEDITABLE UPDATE # # "Water - Asset Totaly Depreciated" ALL Asset_Totally_Depreciated INCLUDE AddAttributeRule "C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB (Admin).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" "Water - End of Life Date" Calculation "$feature.Installation_Year + $feature.Expected_Life_Years" NONEDITABLE UPDATE # # "Water - End of Life Date" ALL End_of_Life_Date INCLUDE AddAttributeRule "C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB (Admin).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" "Water - LifeCycle Maintenance Cost" Calculation "$feature.Cost_per_Unit * 40 / 20" NONEDITABLE UPDATE # # "Water - LifeCycle Maintenance Cost" ALL LifeCycle_Maintenance_Cost INCLUDE AddAttributeRule "C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB (Admin).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" "Water - LifeCycle Administrative Cost" Calculation "$feature.Cost_per_Unit / 20" NONEDITABLE UPDATE # # "Water - LifeCycle Administrative Cost" ALL LifeCycle_Admin_Cost INCLUDE AddAttributeRule "C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB (Admin).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" "Water - LifeCycle Annual Cost" Calculation "(($feature.Cost_per_Unit * 100 / 20) + $feature.LifeCycle_Renewal_Cost) / $feature.Expected_Life_Years" NONEDITABLE UPDATE # # "Water - LifeCycle Annual Cost" ALL LifeCycle_Cost_Annual INCLUDE AddAttributeRule "C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB (Admin).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" "Water - LifeCycle End of Life Cost" Calculation "$feature.Cost_per_Unit * 5 / 20" NONEDITABLE UPDATE # # "Water - LifeCycle End of Life Cost" ALL LifeCycle_End_of_Life_Cost INCLUDE AddAttributeRule "C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB (Admin).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" "Water - LifeCycle Operation Cost" Calculation "$feature.Cost_per_Unit * 35 / 20" NONEDITABLE UPDATE # # "Water - LifeCycle Operation Cost" ALL LifeCycle_Operation_Cost INCLUDE AddAttributeRule "C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB (Admin).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" "Water - LifeCycle Total Cost" Calculation "($feature.Cost_per_Unit * 100 / 20) + $feature.LifeCycle_Renewal_Cost" NONEDITABLE UPDATE # # "Water - LifeCycle Total Cost" ALL LifeCycle_Total_Cost INCLUDE AddAttributeRule "C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB (Admin).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" "Water - LifeCycle Replacement Cost" Calculation "$feature.Replacement_Cost_per_Unit * $feature['Shape.STLength()']" NONEDITABLE UPDATE # # "Water - LifeCycle Replacement Cost" ALL LifeCycle_Replacement_Cost INCLUDE AddAttributeRule "C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB (Admin).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" "Water - Priority Final Index" Calculation "$feature.Priority_Failure + $feature.Priority_Health_Security + $feature.Priority_Climate_Change + $feature.Priority_Essential_Asset + $feature.Priority_High_Value_Asset + $feature.Priority_Positive_Finance + $feature.Priority_Strategic_Plan + $feature.Priority_Perceived_Value + $feature.Priority_Pertinence_Need" NONEDITABLE UPDATE # # "Water - Priority Final Index" ALL Priority_Final_Index INCLUDE CalculateField "Asset Management\Engineering (Combined)\Water Lines" TempField2 $feature.START_DATE Arcade # CalculateField "Asset Management\Engineering (Combined)\Water Lines" TempField2 replace(!TempField2!) "Python 3" "import re\ndef replace(val):\n return re.sub ('01/01/', '', val)" CalculateField "Asset Management\Engineering (Combined)\Water Lines" Installation_Year !TempField2! "Python 3" # CalculateField "Asset Management\Engineering (Combined)\Water Lines" Installation_Year !TempField2! "Python 3" # CalculateField "Asset Management\Engineering (Combined)\Water Lines" Expected_Life_Years !LIFE_EXPECTANCY! "Python 3" # CalculateField "Asset Management\Engineering (Combined)\Water Lines" Installation_Year !TempField2! "Python 3" # CalculateField "Asset Management\Engineering (Combined)\Water Lines" TempField2 !START_DATE! "Python 3" # CalculateField "Asset Management\Engineering (Combined)\Water Lines" TempField2 replace(!TempField2!) "Python 3" "import re\ndef replace(val):\n return re.sub ('01/01/', '', val)" CalculateField "Asset Management\Engineering (Combined)\Water Lines" TempField3 "$feature.TempField2 - $feature.Installation_Year" Arcade # CalculateField "Asset Management\Engineering (Combined)\Water Lines" TempField $feature.FA_ASSET_CODE+"WMN" Arcade # CalculateField "Asset Management\Engineering (Combined)\Water Lines" Cost_For_Length $feature.DEPREC_VALUE Arcade # CalculateField "Asset Management\Engineering (Combined)\Water Lines" Cost_per_Unit "$feature.DEPREC_VALUE / $feature['Shape.STLength()']" Arcade # CalculateField "Asset Management\Engineering (Combined)\Water Lines" TempField "$feature.Expected_Life_Years - $feature.LIFE_EXPECTANCY" Arcade # CalculateField "Asset Management\Engineering (Combined)\Water Lines" Cost_per_Unit $feature.Cost_For_Length Arcade # DeleteAttributeRule "C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB (Admin).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" 'Water - LifeCycle Annual Cost' Calculation AddAttributeRule "C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB (Admin).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" "Water - LifeCycle Cost Annual" Calculation "Var LCAnnualCost = (($feature.Cost_per_Unit * 100 / 20) + $feature.LifeCycle_Renewal_Cost) / $feature.Expected_Life_Years if ($feature.Cost_per_Unit == NULL) { 0 } else if ($feature.LifeCycle_Renewal_Cost == NULL) { 0 } else if ($feature.Expected_Life_Years == NULL) { 0 } else LCAnnualCost" NONEDITABLE UPDATE # # "Water - LifeCycle Cost Annual" ALL LifeCycle_Cost_Annual INCLUDE NOT_BATCH # # AddField "C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB (Admin).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" Installation_Year_Ground "Short (small integer)" # # # "Installation Year (Ground)" NULLABLE NON_REQUIRED COB_Year AlterField "C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB (Admin).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" Installation_Year # "Installation Year (Finance)" "Short (small integer)" 2 NULLABLE DO_NOT_CLEAR AddField "C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB (Admin).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" PSAB_2019_Comment "Short (small integer)" # # # "PSAB 2019 Comment" NULLABLE NON_REQUIRED COB_PSAB_Comment CalculateField "Asset Management\Engineering (Combined)\Water Lines" Installation_Year_Ground $feature.Installation_Year Arcade # AddField "C:\GIS\ArcGIS Pro\MasterEGDB (User).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" Project_Name Text # # # "Project Name" NULLABLE NON_REQUIRED # AddField "C:\GIS\ArcGIS Pro\MasterEGDB (User).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" Project_Description Text # # # "Project Description" NULLABLE NON_REQUIRED # AddField "C:\GIS\ArcGIS Pro\MasterEGDB (User).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" Project_Start_Date Date # # # "Project Start Date" NULLABLE NON_REQUIRED # AddField "C:\GIS\ArcGIS Pro\MasterEGDB (User).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" Project_End_Date Date # # # "Project End Date" NULLABLE NON_REQUIRED # AddField "C:\GIS\ArcGIS Pro\MasterEGDB (User).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" Project_Status "Short (small integer)" # # # "Project Status" NULLABLE NON_REQUIRED COB_Project_Status_ AssignDefaultToField "C:\GIS\ArcGIS Pro\MasterEGDB (User).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" Project_Status 0 # DO_NOT_CLEAR AssignDefaultToField "C:\GIS\ArcGIS Pro\MasterEGDB (User).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" Project_Name N/A # DO_NOT_CLEAR AssignDefaultToField "C:\GIS\ArcGIS Pro\MasterEGDB (User).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" Project_Description N/A # DO_NOT_CLEAR AddField "C:\GIS\ArcGIS Pro\MasterEGDB (User).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" TempField4 Text # # # # NULLABLE NON_REQUIRED # CalculateField "C:\GIS\ArcGIS Pro\MasterEGDB (User).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" Project_Name "N/A" "Python 3" # CalculateField "C:\GIS\ArcGIS Pro\MasterEGDB (User).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" Project_Description "N/A" "Python 3" # CalculateField "C:\GIS\ArcGIS Pro\MasterEGDB (User).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" Project_Status 0 "Python 3" # DeleteAttributeRule "C:\GIS\ArcGIS Pro\MasterEGDB (User).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" 'Water - Closing Book Value';'Water - Loss in Value This Year';'Water - Loss in Value Total';'Water - Opening Book Value';'Water - Remaining Value' Calculation AddAttributeRule "C:\GIS\ArcGIS Pro\MasterEGDB (User).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" "Water - Opening Book Value" Calculation "var DepreciableValue = ($feature.Cost_per_Unit - $feature.Residual_Value) var AnnualDepreciationLost = (DepreciableValue / $feature.Expected_Life_Years) var RemainingAssetYears = ( $feature.Expected_Life_Years - (Year(Now())-$feature.Installation_Year)) if (Year(Now())==$feature.Installation_Year) { DepreciableValue } else if (RemainingAssetYears<=(-1)) { 0 } else { (RemainingAssetYears * AnnualDepreciationLost)+ AnnualDepreciationLost }" NONEDITABLE UPDATE # # "Water - Opening Book Value" ALL Opening_Book_Value INCLUDE NOT_BATCH # # AddAttributeRule "C:\GIS\ArcGIS Pro\MasterEGDB (User).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" "Water - Loss In Value Year" Calculation "var DepreciableValue = ($feature.Cost_per_Unit - $feature.Residual_Value) var AnnualDepreciationLost = (DepreciableValue / $feature.Expected_Life_Years) var RemainingAssetYears = ( $feature.Expected_Life_Years - (Year(Now())-$feature.Installation_Year)) if (Year(Now())==$feature.Installation_Year) { 0 } else if (RemainingAssetYears>=(0)) { AnnualDepreciationLost } else { 0 }" NONEDITABLE UPDATE # # "Water - Loss In Value Year" ALL Loss_in_Value_Year INCLUDE NOT_BATCH # # AddAttributeRule "C:\GIS\ArcGIS Pro\MasterEGDB (User).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" "Water - Closing Book Value" Calculation "var DepreciableValue = ($feature.Cost_per_Unit - $feature.Residual_Value) var AnnualDepreciationLost = (DepreciableValue / $feature.Expected_Life_Years) var RemainingAssetYears = ( $feature.Expected_Life_Years - (Year(Now())-$feature.Installation_Year)) if (Year(Now())==$feature.Installation_Year) { DepreciableValue } else if (RemainingAssetYears>=1) { RemainingAssetYears*AnnualDepreciationLost } else { 0 }" NONEDITABLE UPDATE # # "Water - Closing Book Value" ALL Closing_Book_Value INCLUDE NOT_BATCH # # AddAttributeRule "C:\GIS\ArcGIS Pro\MasterEGDB (User).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" "Water - Lost in Value Total" Calculation "var DepreciableValue = ($feature.Cost_per_Unit - $feature.Residual_Value) var AnnualDepreciationLost = (DepreciableValue / $feature.Expected_Life_Years) var RemainingAssetYears = ( $feature.Expected_Life_Years - (Year(Now())-$feature.Installation_Year)) if (Year(Now())==$feature.Installation_Year) { 0 } else if (RemainingAssetYears>=1) { $feature.Expected_Life_Years-(RemainingAssetYears*AnnualDepreciationLost) } else { DepreciableValue }" NONEDITABLE UPDATE # # "Water - Lost in Value Total" ALL Loss_In_Value_Total INCLUDE NOT_BATCH # # AddAttributeRule "C:\GIS\ArcGIS Pro\MasterEGDB (User).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" "Water - Remaining Value" Calculation "var DepreciableValue = ($feature.Cost_per_Unit - $feature.Residual_Value) var AnnualDepreciationLost = (DepreciableValue / $feature.Expected_Life_Years) var RemainingAssetYears = ( $feature.Expected_Life_Years - (Year(Now())-$feature.Installation_Year)) if (Year(Now())==$feature.Installation_Year) { DepreciableValue + $feature.Residual_Value } else if (RemainingAssetYears>=1) { (RemainingAssetYears*AnnualDepreciationLost) + $feature.Residual_Value } else { 0 + $feature.Residual_Value }" NONEDITABLE UPDATE # # "Water - Remaining Value" ALL Remaining_Value INCLUDE NOT_BATCH # # DeleteAttributeRule "C:\GIS\ArcGIS Pro\MasterEGDB (User).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" 'Water - Lost in Value Total' Calculation AddAttributeRule "C:\GIS\ArcGIS Pro\MasterEGDB (User).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" "Water - Lost in Value Total" Calculation "var DepreciableValue = ($feature.Cost_per_Unit - $feature.Residual_Value) var AnnualDepreciationLost = (DepreciableValue / $feature.Expected_Life_Years) var RemainingAssetYears = ( $feature.Expected_Life_Years - (Year(Now())-$feature.Installation_Year)) if (Year(Now())==$feature.Installation_Year) { 0 } else if (RemainingAssetYears==0) { DepreciableValue } else if (RemainingAssetYears>0) { (RemainingAssetYears*AnnualDepreciationLost) } else { DepreciableValue }" NONEDITABLE UPDATE # # "Water - Lost in Value Total" ALL Loss_In_Value_Total INCLUDE NOT_BATCH # # DeleteAttributeRule "C:\GIS\ArcGIS Pro\MasterEGDB (User).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" 'Water - Lost in Value Total' Calculation AddAttributeRule "C:\GIS\ArcGIS Pro\MasterEGDB (User).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Lines3" "Water - Lost in Value Total" Calculation "var DepreciableValue = ($feature.Cost_per_Unit - $feature.Residual_Value) var AnnualDepreciationLost = (DepreciableValue / $feature.Expected_Life_Years) var RemainingAssetYears = ( $feature.Expected_Life_Years - (Year(Now())-$feature.Installation_Year)) if (Year(Now())==$feature.Installation_Year) { 0 } else if (RemainingAssetYears==0) { DepreciableValue } else if (RemainingAssetYears>0) { ($feature.Expected_Life_Years-RemainingAssetYears)*AnnualDepreciationLost } else { DepreciableValue }" NONEDITABLE UPDATE # # "Water - Lost in Value Total" ALL Loss_In_Value_Total INCLUDE NOT_BATCH # # CalculateField "Engineering\Water - Lines\Water - Lateral" Installation_Year 2019 "Python 3" # CalculateField "Engineering\Water - Lines\Water - Lateral" GeoLocation 5 "Python 3" # CalculateField "Engineering\Water - Lines\Water - Lateral" Grid_Reference "28Q-C0" "Python 3" # CalculateField "Engineering\Water - Lines\Water - Lateral" Installation_Year 2019 "Python 3" # CalculateField "Engineering\Water - Lines\Water - Lateral" Material 14 "Python 3" # CalculateField "Engineering\Water - Lines\Water - Lateral" Diameter 19 "Python 3" # CalculateField "Engineering\Water - Lines\Water - Lateral" Diameter 25 "Python 3" # CalculateField "Engineering\Water - Lines\Water - Fire Hydrant - Lateral" Related_Street_Name 453 "Python 3" # CalculateField "Engineering\Water - Lines\Water - Lateral" Related_Street_Name 453 "Python 3" # CalculateField "Engineering\Water - Lines\Water - Lateral" Expected_Life_Years 60 "Python 3" # CalculateField "Engineering\Water - Lines\Water - Lateral" Related_Street_Name 599 "Python 3" # CalculateField "Engineering\Water - Lines\Water - Lateral" Diameter 19 "Python 3" # CalculateField "Engineering\Water - Lines\Water - Lateral" Material 11 "Python 3" # CalculateField "Engineering\Water - Lines\Water - Lateral" Grid_Reference "28Q-D1" "Python 3" # CalculateField "Engineering\Water - Lines\Water - Lateral" Expected_Life_Years 60 "Python 3" # FeatureClassToFeatureClass "Engineering\Water - Lines" X:\ArcGisProjects\Engineering\Master.sde\MasterEGDB.DBO.Public_Works Water_Lines # "GlobalID "GlobalID" false false false 38 GlobalID 0 0,First,#,Engineering\Water - Lines,GlobalID,-1,-1;Asset_Group "Asset Group" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,Asset_Group,-1,-1;Asset_Type "Asset Type" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,Asset_Type,-1,-1;Asset_Subtype "Asset Subtype" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,Asset_Subtype,-1,-1;Asset_ID "Asset ID" true true false 50 Text 0 0,First,#,Engineering\Water - Lines,Asset_ID,0,50;Related_PID "Related PID" true true false 50 Text 0 0,First,#,Engineering\Water - Lines,Related_PID,0,50;Closest_Civic_Address "Closest Civic Address" true true false 50 Text 0 0,First,#,Engineering\Water - Lines,Closest_Civic_Address,0,50;Related_Civic_Number "Related Civic Number" true true false 50 Text 0 0,First,#,Engineering\Water - Lines,Related_Civic_Number,0,50;Related_Street_Name "Related Street Name" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,Related_Street_Name,-1,-1;Related_Street_Section "Related Street Section" true true false 8 Double 8 38,First,#,Engineering\Water - Lines,Related_Street_Section,-1,-1;GeoLocation "GeoLocation" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,GeoLocation,-1,-1;Grid_Reference "Grid Reference" true true false 6 Text 0 0,First,#,Engineering\Water - Lines,Grid_Reference,0,6;Installation_Year "Installation Year (Finance)" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,Installation_Year,-1,-1;Diameter "Diameter" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,Diameter,-1,-1;Material "Material" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,Material,-1,-1;Pipe_Class "Pipe Class" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,Pipe_Class,-1,-1;Lateral_With_DBH "Lateral With DBH" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,Lateral_With_DBH,-1,-1;Depth "Depth" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,Depth,-1,-1;TTYYPPEE "TTYYPPEE" true true false 50 Text 0 0,First,#,Engineering\Water - Lines,TTYYPPEE,0,50;Comments "Comments" true true false 60 Text 0 0,First,#,Engineering\Water - Lines,Comments,0,60;Last_Maintenance_Inspection_Dat "Last Maintenance Inspection Date" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,Last_Maintenance_Inspection_Dat,-1,-1;Link_to_As_Built "Link to As-Built" true true false 250 Text 0 0,First,#,Engineering\Water - Lines,Link_to_As_Built,0,250;Link_to_Ti_Ins "Link to Ti-Ins" true true false 250 Text 0 0,First,#,Engineering\Water - Lines,Link_to_Ti_Ins,0,250;Feature_Creator "Feature Creator" false true false 150 Text 0 0,First,#,Engineering\Water - Lines,Feature_Creator,0,150;Creation_Date "Creation Date" false true false 8 Date 0 0,First,#,Engineering\Water - Lines,Creation_Date,-1,-1;Last_Editor "Last Editor" false true false 255 Text 0 0,First,#,Engineering\Water - Lines,Last_Editor,0,255;Last_Edit_Date "Last Edit Date" false true false 8 Date 0 0,First,#,Engineering\Water - Lines,Last_Edit_Date,-1,-1;Jurisdiction "Jurisdiction" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,Jurisdiction,-1,-1;Tangible_Capital_Asset "Tangible Capital Asset" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,Tangible_Capital_Asset,-1,-1;Expected_Life_Years "Expected Life Years" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,Expected_Life_Years,-1,-1;End_of_Life_Date "End of Life Date" false true false 2 Short 0 5,First,#,Engineering\Water - Lines,End_of_Life_Date,-1,-1;Remaining_Life_Years "Remaining Life Years" false true false 2 Short 0 5,First,#,Engineering\Water - Lines,Remaining_Life_Years,-1,-1;Remaining_Life_Percent "Remaining Life Percent" false true false 8 Double 8 38,First,#,Engineering\Water - Lines,Remaining_Life_Percent,-1,-1;Condition_Rating "Condition Rating (1 to 5)" false true false 2 Short 0 5,First,#,Engineering\Water - Lines,Condition_Rating,-1,-1;Cost_per_Unit "Cost_per_Unit" true true false 8 Double 8 38,First,#,Engineering\Water - Lines,Cost_per_Unit,-1,-1;Asset_Replacement_Value "Asset Replacement Value" false true false 8 Double 8 38,First,#,Engineering\Water - Lines,Asset_Replacement_Value,-1,-1;Emergency_Asset_Replacement_Val "Emergency Asset Replacement Value" true true false 8 Double 8 38,First,#,Engineering\Water - Lines,Emergency_Asset_Replacement_Val,-1,-1;Remaining_Value "Remaining Value" false true false 8 Double 8 38,First,#,Engineering\Water - Lines,Remaining_Value,-1,-1;Infrastructure_Deficit__Backlog "Infrastructure Deficit (Backlog)" true true false 8 Double 8 38,First,#,Engineering\Water - Lines,Infrastructure_Deficit__Backlog,-1,-1;Show_When_Page_Name_Is_Not "Show When Page Name Is Not" true true false 50 Text 0 0,First,#,Engineering\Water - Lines,Show_When_Page_Name_Is_Not,0,50;PSAB_2016_Comments "PSAB 2016 Comments" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,PSAB_2016_Comments,-1,-1;PSAB_2017_Comments "PSAB 2017 Comments" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,PSAB_2017_Comments,-1,-1;Enabled "Enabled" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,Enabled,-1,-1;PSAB_2018_Comments "PSAB 2018 Comments" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,PSAB_2018_Comments,-1,-1;TempField "TempField" true true false 255 Text 0 0,First,#,Engineering\Water - Lines,TempField,0,255;Cost_For_Length "Cost For Length" true true false 8 Double 8 38,First,#,Engineering\Water - Lines,Cost_For_Length,-1,-1;Asset_Category "Asset Category" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,Asset_Category,-1,-1;Related_Service "Related Service" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,Related_Service,-1,-1;Asset_Class "Asset Class" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,Asset_Class,-1,-1;Asset_SubClass "Asset SubClass" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,Asset_SubClass,-1,-1;Asset_Name "Asset Name" true true false 255 Text 0 0,First,#,Engineering\Water - Lines,Asset_Name,0,255;Historical_Acquisition_Cost2 "Historical Acquisition Cost (Previous 2x)" true true false 8 Double 8 38,First,#,Engineering\Water - Lines,Historical_Acquisition_Cost2,-1,-1;Historical_Acquisition_Cost1 "Historical Acquisition Cost (Previous 1x)" true true false 8 Double 8 38,First,#,Engineering\Water - Lines,Historical_Acquisition_Cost1,-1,-1;Cost_per_Unit_Readjustment "Cost per Unit Readjustment" true true false 255 Text 0 0,First,#,Engineering\Water - Lines,Cost_per_Unit_Readjustment,0,255;Residual_Value "Residual Value" true true false 8 Double 8 38,First,#,Engineering\Water - Lines,Residual_Value,-1,-1;Condition_Method "Condition Method" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,Condition_Method,-1,-1;Opening_Book_Value "Opening Book Value" false true false 8 Double 8 38,First,#,Engineering\Water - Lines,Opening_Book_Value,-1,-1;Closing_Book_Value "Closing Book Value" false true false 8 Double 8 38,First,#,Engineering\Water - Lines,Closing_Book_Value,-1,-1;Asset_Totally_Depreciated "Asset Totally Depreciated" false true false 2 Short 0 5,First,#,Engineering\Water - Lines,Asset_Totally_Depreciated,-1,-1;Salvage_Value "Salvage Value" true true false 8 Double 8 38,First,#,Engineering\Water - Lines,Salvage_Value,-1,-1;LifeCycle_Maintenance_Cost "LifeCycle Maintenance Cost" false true false 8 Double 8 38,First,#,Engineering\Water - Lines,LifeCycle_Maintenance_Cost,-1,-1;LifeCycle_Maintenance_Source "LifeCycle Maintenance Source of Funding" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,LifeCycle_Maintenance_Source,-1,-1;LifeCycle_Operation_Cost "LifeCycle Operation Cost" false true false 8 Double 8 38,First,#,Engineering\Water - Lines,LifeCycle_Operation_Cost,-1,-1;LifeCycle_Operation_Source "LifeCycle Operation Source of Funding" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,LifeCycle_Operation_Source,-1,-1;LifeCycle_Renewal_Cost "LifeCycle Renewal Cost" true true false 8 Double 8 38,First,#,Engineering\Water - Lines,LifeCycle_Renewal_Cost,-1,-1;LifeCycle_Renewal_Source "LifeCycle Renewal Source" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,LifeCycle_Renewal_Source,-1,-1;LifeCycle_End_of_Life_Cost "LifeCycle End of Life Cost" false true false 8 Double 8 38,First,#,Engineering\Water - Lines,LifeCycle_End_of_Life_Cost,-1,-1;LifeCycle_Replacement_Cost "LifeCycle Replacement Cost" false true false 8 Double 8 38,First,#,Engineering\Water - Lines,LifeCycle_Replacement_Cost,-1,-1;LifeCycle_EmgReplacement_Cost "LifeCycle Emergency Replacement Cost" true true false 8 Double 8 38,First,#,Engineering\Water - Lines,LifeCycle_EmgReplacement_Cost,-1,-1;LifeCycle_Replacement_Source "LifeCycle Replacement Source of Funding" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,LifeCycle_Replacement_Source,-1,-1;LifeCycle_Admin_Cost "LifeCycle Administrative Cost" false true false 8 Double 8 38,First,#,Engineering\Water - Lines,LifeCycle_Admin_Cost,-1,-1;LifeCycle_Total_Cost "LifeCycle Total Cost" false true false 8 Double 8 38,First,#,Engineering\Water - Lines,LifeCycle_Total_Cost,-1,-1;LifeCycle_Cost_Annual "LifeCycle_Cost_Annual" false true false 8 Double 8 38,First,#,Engineering\Water - Lines,LifeCycle_Cost_Annual,-1,-1;Climate_Change_Risk "Climate Change Risk" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,Climate_Change_Risk,-1,-1;Climate_Change_Risk_Type "Climate Change Risk Type" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,Climate_Change_Risk_Type,-1,-1;Climate_Change_Risk_Probability "Climate Change Risk Probability" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,Climate_Change_Risk_Probability,-1,-1;Climate_Change_Risk_Impact "Climate Change Risk Impact" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,Climate_Change_Risk_Impact,-1,-1;Priority_Failure "Priority Failure" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,Priority_Failure,-1,-1;Priority_Health_Security "Priority Health Security" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,Priority_Health_Security,-1,-1;Priority_Climate_Change "Priority Climate Change" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,Priority_Climate_Change,-1,-1;Priority_Essential_Asset "Priority Essential Asset" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,Priority_Essential_Asset,-1,-1;Priority_High_Value_Asset "Priority High Value Asset" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,Priority_High_Value_Asset,-1,-1;Priority_Positive_Finance "Priority Positive Finance" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,Priority_Positive_Finance,-1,-1;Priority_Strategic_Plan "Priority Strategic Plan" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,Priority_Strategic_Plan,-1,-1;Priority_Perceived_Value "Priority Perceived Value" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,Priority_Perceived_Value,-1,-1;Priority_Pertinence_Need "Priority Pertinence Need" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,Priority_Pertinence_Need,-1,-1;Priority_Final_Index "Priority Final Index" false true false 2 Short 0 5,First,#,Engineering\Water - Lines,Priority_Final_Index,-1,-1;Asset_Description "Asset Description" true true false 255 Text 0 0,First,#,Engineering\Water - Lines,Asset_Description,0,255;Replacement_Cost_per_Unit "Replacement Cost per Unit" true true false 8 Double 8 38,First,#,Engineering\Water - Lines,Replacement_Cost_per_Unit,-1,-1;TempField3 "TempField3" true true false 8 Double 8 38,First,#,Engineering\Water - Lines,TempField3,-1,-1;TempField2 "TempField2" true true false 255 Text 0 0,First,#,Engineering\Water - Lines,TempField2,0,255;FA_CLASS_CODE "FA_CLASS_CODE" true true false 6 Text 0 0,First,#,Engineering\Water - Lines,FA_CLASS_CODE,0,6;FA_ASSET_CODE "FA_ASSET_CODE" true true false 10 Text 0 0,First,#,Engineering\Water - Lines,FA_ASSET_CODE,0,10;SCHED_NAME "SCHED_NAME" true true false 50 Text 0 0,First,#,Engineering\Water - Lines,SCHED_NAME,0,50;FA_SCHED_STATUS "FA_SCHED_STATUS" true true false 6 Text 0 0,First,#,Engineering\Water - Lines,FA_SCHED_STATUS,0,6;DEPREC_VALUE "DEPREC_VALUE" true true false 8 Double 8 38,First,#,Engineering\Water - Lines,DEPREC_VALUE,-1,-1;LIFE_EXPECTANCY "LIFE_EXPECTANCY" true true false 4 Long 0 10,First,#,Engineering\Water - Lines,LIFE_EXPECTANCY,-1,-1;START_DATE "START_DATE" true true false 8 Date 0 0,First,#,Engineering\Water - Lines,START_DATE,-1,-1;Loss_in_Value_Year "Loss in Value (This Year)" false true false 8 Double 8 38,First,#,Engineering\Water - Lines,Loss_in_Value_Year,-1,-1;Loss_In_Value_Total "Loss in Value (Since Acquisition)" false true false 8 Double 8 38,First,#,Engineering\Water - Lines,Loss_In_Value_Total,-1,-1;Installation_Year_Ground "Installation Year (Ground)" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,Installation_Year_Ground,-1,-1;PSAB_2019_Comment "PSAB 2019 Comment" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,PSAB_2019_Comment,-1,-1;Project_Name "Project Name" true true false 255 Text 0 0,First,#,Engineering\Water - Lines,Project_Name,0,255;Project_Description "Project Description" true true false 255 Text 0 0,First,#,Engineering\Water - Lines,Project_Description,0,255;Project_Start_Date "Project Start Date" true true false 8 Date 0 0,First,#,Engineering\Water - Lines,Project_Start_Date,-1,-1;Project_End_Date "Project End Date" true true false 8 Date 0 0,First,#,Engineering\Water - Lines,Project_End_Date,-1,-1;Project_Status "Project Status" true true false 2 Short 0 5,First,#,Engineering\Water - Lines,Project_Status,-1,-1;TempField4 "TempField4" true true false 255 Text 0 0,First,#,Engineering\Water - Lines,TempField4,0,255" # CalculateField Water_Lines Installation_Year_Ground 2019 Arcade # Text FeatureClassToFeatureClass Water_Lines X:\ArcGisProjects\Postgres\gis-vector.sde\gis_vector.sde.PW Water_Lines # "GlobalID "GlobalID" false false false 38 GlobalID 0 0,First,#,Water_Lines,GlobalID,-1,-1;Asset_Group "Asset Group" true true false 2 Short 0 5,First,#,Water_Lines,Asset_Group,-1,-1;Asset_Type "Asset Type" true true false 2 Short 0 5,First,#,Water_Lines,Asset_Type,-1,-1;Asset_Subtype "Asset Subtype" true true false 2 Short 0 5,First,#,Water_Lines,Asset_Subtype,-1,-1;Asset_ID "Asset ID" true true false 50 Text 0 0,First,#,Water_Lines,Asset_ID,0,50;Related_PID "Related PID" true true false 50 Text 0 0,First,#,Water_Lines,Related_PID,0,50;Closest_Civic_Address "Closest Civic Address" true true false 50 Text 0 0,First,#,Water_Lines,Closest_Civic_Address,0,50;Related_Civic_Number "Related Civic Number" true true false 50 Text 0 0,First,#,Water_Lines,Related_Civic_Number,0,50;Related_Street_Name "Related Street Name" true true false 2 Short 0 5,First,#,Water_Lines,Related_Street_Name,-1,-1;Related_Street_Section "Related Street Section" true true false 8 Double 8 38,First,#,Water_Lines,Related_Street_Section,-1,-1;GeoLocation "GeoLocation" true true false 2 Short 0 5,First,#,Water_Lines,GeoLocation,-1,-1;Grid_Reference "Grid Reference" true true false 6 Text 0 0,First,#,Water_Lines,Grid_Reference,0,6;Installation_Year "Installation Year (Finance)" true true false 2 Short 0 5,First,#,Water_Lines,Installation_Year,-1,-1;Diameter "Diameter" true true false 2 Short 0 5,First,#,Water_Lines,Diameter,-1,-1;Material "Material" true true false 2 Short 0 5,First,#,Water_Lines,Material,-1,-1;Pipe_Class "Pipe Class" true true false 2 Short 0 5,First,#,Water_Lines,Pipe_Class,-1,-1;Lateral_With_DBH "Lateral With DBH" true true false 2 Short 0 5,First,#,Water_Lines,Lateral_With_DBH,-1,-1;Depth "Depth" true true false 2 Short 0 5,First,#,Water_Lines,Depth,-1,-1;TTYYPPEE "TTYYPPEE" true true false 50 Text 0 0,First,#,Water_Lines,TTYYPPEE,0,50;Comments "Comments" true true false 60 Text 0 0,First,#,Water_Lines,Comments,0,60;Last_Maintenance_Inspection_Dat "Last Maintenance Inspection Date" true true false 2 Short 0 5,First,#,Water_Lines,Last_Maintenance_Inspection_Dat,-1,-1;Link_to_As_Built "Link to As-Built" true true false 250 Text 0 0,First,#,Water_Lines,Link_to_As_Built,0,250;Link_to_Ti_Ins "Link to Ti-Ins" true true false 250 Text 0 0,First,#,Water_Lines,Link_to_Ti_Ins,0,250;Feature_Creator "Feature Creator" true true false 150 Text 0 0,First,#,Water_Lines,Feature_Creator,0,150;Creation_Date "Creation Date" true true false 8 Date 0 0,First,#,Water_Lines,Creation_Date,-1,-1;Last_Editor "Last Editor" true true false 255 Text 0 0,First,#,Water_Lines,Last_Editor,0,255;Last_Edit_Date "Last Edit Date" true true false 8 Date 0 0,First,#,Water_Lines,Last_Edit_Date,-1,-1;Jurisdiction "Jurisdiction" true true false 2 Short 0 5,First,#,Water_Lines,Jurisdiction,-1,-1;Tangible_Capital_Asset "Tangible Capital Asset" true true false 2 Short 0 5,First,#,Water_Lines,Tangible_Capital_Asset,-1,-1;Expected_Life_Years "Expected Life Years" true true false 2 Short 0 5,First,#,Water_Lines,Expected_Life_Years,-1,-1;End_of_Life_Date "End of Life Date" true true false 2 Short 0 5,First,#,Water_Lines,End_of_Life_Date,-1,-1;Remaining_Life_Years "Remaining Life Years" true true false 2 Short 0 5,First,#,Water_Lines,Remaining_Life_Years,-1,-1;Remaining_Life_Percent "Remaining Life Percent" true true false 8 Double 8 38,First,#,Water_Lines,Remaining_Life_Percent,-1,-1;Condition_Rating "Condition Rating (1 to 5)" true true false 2 Short 0 5,First,#,Water_Lines,Condition_Rating,-1,-1;Cost_per_Unit "Cost_per_Unit" true true false 8 Double 8 38,First,#,Water_Lines,Cost_per_Unit,-1,-1;Asset_Replacement_Value "Asset Replacement Value" true true false 8 Double 8 38,First,#,Water_Lines,Asset_Replacement_Value,-1,-1;Emergency_Asset_Replacement_Val "Emergency Asset Replacement Value" true true false 8 Double 8 38,First,#,Water_Lines,Emergency_Asset_Replacement_Val,-1,-1;Remaining_Value "Remaining Value" true true false 8 Double 8 38,First,#,Water_Lines,Remaining_Value,-1,-1;Infrastructure_Deficit__Backlog "Infrastructure Deficit (Backlog)" true true false 8 Double 8 38,First,#,Water_Lines,Infrastructure_Deficit__Backlog,-1,-1;Show_When_Page_Name_Is_Not "Show When Page Name Is Not" true true false 50 Text 0 0,First,#,Water_Lines,Show_When_Page_Name_Is_Not,0,50;PSAB_2016_Comments "PSAB 2016 Comments" true true false 2 Short 0 5,First,#,Water_Lines,PSAB_2016_Comments,-1,-1;PSAB_2017_Comments "PSAB 2017 Comments" true true false 2 Short 0 5,First,#,Water_Lines,PSAB_2017_Comments,-1,-1;Enabled "Enabled" true true false 2 Short 0 5,First,#,Water_Lines,Enabled,-1,-1;PSAB_2018_Comments "PSAB 2018 Comments" true true false 2 Short 0 5,First,#,Water_Lines,PSAB_2018_Comments,-1,-1;TempField "TempField" true true false 255 Text 0 0,First,#,Water_Lines,TempField,0,255;Cost_For_Length "Cost For Length" true true false 8 Double 8 38,First,#,Water_Lines,Cost_For_Length,-1,-1;Asset_Category "Asset Category" true true false 2 Short 0 5,First,#,Water_Lines,Asset_Category,-1,-1;Related_Service "Related Service" true true false 2 Short 0 5,First,#,Water_Lines,Related_Service,-1,-1;Asset_Class "Asset Class" true true false 2 Short 0 5,First,#,Water_Lines,Asset_Class,-1,-1;Asset_SubClass "Asset SubClass" true true false 2 Short 0 5,First,#,Water_Lines,Asset_SubClass,-1,-1;Asset_Name "Asset Name" true true false 255 Text 0 0,First,#,Water_Lines,Asset_Name,0,255;Historical_Acquisition_Cost2 "Historical Acquisition Cost (Previous 2x)" true true false 8 Double 8 38,First,#,Water_Lines,Historical_Acquisition_Cost2,-1,-1;Historical_Acquisition_Cost1 "Historical Acquisition Cost (Previous 1x)" true true false 8 Double 8 38,First,#,Water_Lines,Historical_Acquisition_Cost1,-1,-1;Cost_per_Unit_Readjustment "Cost per Unit Readjustment" true true false 255 Text 0 0,First,#,Water_Lines,Cost_per_Unit_Readjustment,0,255;Residual_Value "Residual Value" true true false 8 Double 8 38,First,#,Water_Lines,Residual_Value,-1,-1;Condition_Method "Condition Method" true true false 2 Short 0 5,First,#,Water_Lines,Condition_Method,-1,-1;Opening_Book_Value "Opening Book Value" true true false 8 Double 8 38,First,#,Water_Lines,Opening_Book_Value,-1,-1;Closing_Book_Value "Closing Book Value" true true false 8 Double 8 38,First,#,Water_Lines,Closing_Book_Value,-1,-1;Asset_Totally_Depreciated "Asset Totally Depreciated" true true false 2 Short 0 5,First,#,Water_Lines,Asset_Totally_Depreciated,-1,-1;Salvage_Value "Salvage Value" true true false 8 Double 8 38,First,#,Water_Lines,Salvage_Value,-1,-1;LifeCycle_Maintenance_Cost "LifeCycle Maintenance Cost" true true false 8 Double 8 38,First,#,Water_Lines,LifeCycle_Maintenance_Cost,-1,-1;LifeCycle_Maintenance_Source "LifeCycle Maintenance Source of Funding" true true false 2 Short 0 5,First,#,Water_Lines,LifeCycle_Maintenance_Source,-1,-1;LifeCycle_Operation_Cost "LifeCycle Operation Cost" true true false 8 Double 8 38,First,#,Water_Lines,LifeCycle_Operation_Cost,-1,-1;LifeCycle_Operation_Source "LifeCycle Operation Source of Funding" true true false 2 Short 0 5,First,#,Water_Lines,LifeCycle_Operation_Source,-1,-1;LifeCycle_Renewal_Cost "LifeCycle Renewal Cost" true true false 8 Double 8 38,First,#,Water_Lines,LifeCycle_Renewal_Cost,-1,-1;LifeCycle_Renewal_Source "LifeCycle Renewal Source" true true false 2 Short 0 5,First,#,Water_Lines,LifeCycle_Renewal_Source,-1,-1;LifeCycle_End_of_Life_Cost "LifeCycle End of Life Cost" true true false 8 Double 8 38,First,#,Water_Lines,LifeCycle_End_of_Life_Cost,-1,-1;LifeCycle_Replacement_Cost "LifeCycle Replacement Cost" true true false 8 Double 8 38,First,#,Water_Lines,LifeCycle_Replacement_Cost,-1,-1;LifeCycle_EmgReplacement_Cost "LifeCycle Emergency Replacement Cost" true true false 8 Double 8 38,First,#,Water_Lines,LifeCycle_EmgReplacement_Cost,-1,-1;LifeCycle_Replacement_Source "LifeCycle Replacement Source of Funding" true true false 2 Short 0 5,First,#,Water_Lines,LifeCycle_Replacement_Source,-1,-1;LifeCycle_Admin_Cost "LifeCycle Administrative Cost" true true false 8 Double 8 38,First,#,Water_Lines,LifeCycle_Admin_Cost,-1,-1;LifeCycle_Total_Cost "LifeCycle Total Cost" true true false 8 Double 8 38,First,#,Water_Lines,LifeCycle_Total_Cost,-1,-1;LifeCycle_Cost_Annual "LifeCycle_Cost_Annual" true true false 8 Double 8 38,First,#,Water_Lines,LifeCycle_Cost_Annual,-1,-1;Climate_Change_Risk "Climate Change Risk" true true false 2 Short 0 5,First,#,Water_Lines,Climate_Change_Risk,-1,-1;Climate_Change_Risk_Type "Climate Change Risk Type" true true false 2 Short 0 5,First,#,Water_Lines,Climate_Change_Risk_Type,-1,-1;Climate_Change_Risk_Probability "Climate Change Risk Probability" true true false 2 Short 0 5,First,#,Water_Lines,Climate_Change_Risk_Probability,-1,-1;Climate_Change_Risk_Impact "Climate Change Risk Impact" true true false 2 Short 0 5,First,#,Water_Lines,Climate_Change_Risk_Impact,-1,-1;Priority_Failure "Priority Failure" true true false 2 Short 0 5,First,#,Water_Lines,Priority_Failure,-1,-1;Priority_Health_Security "Priority Health Security" true true false 2 Short 0 5,First,#,Water_Lines,Priority_Health_Security,-1,-1;Priority_Climate_Change "Priority Climate Change" true true false 2 Short 0 5,First,#,Water_Lines,Priority_Climate_Change,-1,-1;Priority_Essential_Asset "Priority Essential Asset" true true false 2 Short 0 5,First,#,Water_Lines,Priority_Essential_Asset,-1,-1;Priority_High_Value_Asset "Priority High Value Asset" true true false 2 Short 0 5,First,#,Water_Lines,Priority_High_Value_Asset,-1,-1;Priority_Positive_Finance "Priority Positive Finance" true true false 2 Short 0 5,First,#,Water_Lines,Priority_Positive_Finance,-1,-1;Priority_Strategic_Plan "Priority Strategic Plan" true true false 2 Short 0 5,First,#,Water_Lines,Priority_Strategic_Plan,-1,-1;Priority_Perceived_Value "Priority Perceived Value" true true false 2 Short 0 5,First,#,Water_Lines,Priority_Perceived_Value,-1,-1;Priority_Pertinence_Need "Priority Pertinence Need" true true false 2 Short 0 5,First,#,Water_Lines,Priority_Pertinence_Need,-1,-1;Priority_Final_Index "Priority Final Index" true true false 2 Short 0 5,First,#,Water_Lines,Priority_Final_Index,-1,-1;Asset_Description "Asset Description" true true false 255 Text 0 0,First,#,Water_Lines,Asset_Description,0,255;Replacement_Cost_per_Unit "Replacement Cost per Unit" true true false 8 Double 8 38,First,#,Water_Lines,Replacement_Cost_per_Unit,-1,-1;TempField3 "TempField3" true true false 8 Double 8 38,First,#,Water_Lines,TempField3,-1,-1;TempField2 "TempField2" true true false 255 Text 0 0,First,#,Water_Lines,TempField2,0,255;FA_CLASS_CODE "FA_CLASS_CODE" true true false 6 Text 0 0,First,#,Water_Lines,FA_CLASS_CODE,0,6;FA_ASSET_CODE "FA_ASSET_CODE" true true false 10 Text 0 0,First,#,Water_Lines,FA_ASSET_CODE,0,10;SCHED_NAME "SCHED_NAME" true true false 50 Text 0 0,First,#,Water_Lines,SCHED_NAME,0,50;FA_SCHED_STATUS "FA_SCHED_STATUS" true true false 6 Text 0 0,First,#,Water_Lines,FA_SCHED_STATUS,0,6;DEPREC_VALUE "DEPREC_VALUE" true true false 8 Double 8 38,First,#,Water_Lines,DEPREC_VALUE,-1,-1;LIFE_EXPECTANCY "LIFE_EXPECTANCY" true true false 4 Long 0 10,First,#,Water_Lines,LIFE_EXPECTANCY,-1,-1;START_DATE "START_DATE" true true false 8 Date 0 0,First,#,Water_Lines,START_DATE,-1,-1;Loss_in_Value_Year "Loss in Value (This Year)" true true false 8 Double 8 38,First,#,Water_Lines,Loss_in_Value_Year,-1,-1;Loss_In_Value_Total "Loss in Value (Since Acquisition)" true true false 8 Double 8 38,First,#,Water_Lines,Loss_In_Value_Total,-1,-1;Installation_Year_Ground "Installation Year (Ground)" true true false 2 Short 0 5,First,#,Water_Lines,Installation_Year_Ground,-1,-1;PSAB_2019_Comment "PSAB 2019 Comment" true true false 2 Short 0 5,First,#,Water_Lines,PSAB_2019_Comment,-1,-1;Project_Name "Project Name" true true false 255 Text 0 0,First,#,Water_Lines,Project_Name,0,255;Project_Description "Project Description" true true false 255 Text 0 0,First,#,Water_Lines,Project_Description,0,255;Project_Start_Date "Project Start Date" true true false 8 Date 0 0,First,#,Water_Lines,Project_Start_Date,-1,-1;Project_End_Date "Project End Date" true true false 8 Date 0 0,First,#,Water_Lines,Project_End_Date,-1,-1;Project_Status "Project Status" true true false 2 Short 0 5,First,#,Water_Lines,Project_Status,-1,-1;TempField4 "TempField4" true true false 255 Text 0 0,First,#,Water_Lines,TempField4,0,255" # {"type":"CIMLayerDocument","version":"2.7.0","build":26828,"layers":["CIMPATH=Map/7fd9bacfbb584b77b925afe946d4eb59.xml"],"layerDefinitions":[{"type":"CIMFeatureLayer","name":"gis_vector.sde.Water_Lines","uRI":"CIMPATH=Map/7fd9bacfbb584b77b925afe946d4eb59.xml","sourceModifiedTime":{"type":"TimeInstant"},"useSourceMetadata":true,"description":"MasterEGDB.DBO.Water_Lines","layerElevation":{"type":"CIMLayerElevationSurface","mapElevationID":"{5BE86979-AB78-4A3F-8D3D-ED4B54EA7B4B}"},"expanded":true,"layerType":"Operational","showLegends":true,"visibility":true,"displayCacheType":"Permanent","maxDisplayCacheAge":5,"popupInfo":{"type":"CIMPopupInfo","title":"{Asset_ID}","mediaInfos":[{"type":"CIMTableMediaInfo","row":1,"column":1,"refreshRateUnit":"esriTimeUnitsSeconds","rowSpan":1,"columnSpan":1,"fields":["GlobalID","OBJECTID","Asset_Category","Related_Service","Asset_Class","Asset_SubClass","Asset_Group","Asset_Type","Asset_Subtype","Asset_ID","Asset_Name","Asset_Description","Related_PID","Closest_Civic_Address","Related_Civic_Number","Related_Street_Name","Related_Street_Section","GeoLocation","Grid_Reference","Diameter","Material","Pipe_Class","Lateral_With_DBH","Comments","Link_to_As_Built","Link_to_Ti_Ins","Jurisdiction","Installation_Year","Expected_Life_Years","End_of_Life_Date","Remaining_Life_Years","Remaining_Life_Percent","Condition_Rating","Condition_Method","Historical_Acquisition_Cost2","Historical_Acquisition_Cost1","Cost_per_Unit","Cost_For_Length","Cost_per_Unit_Readjustment","Residual_Value","Opening_Book_Value","Loss_in_Value_Year","Closing_Book_Value","Loss_In_Value_Total","Remaining_Value","Asset_Totally_Depreciated","Infrastructure_Deficit__Backlog","Salvage_Value","LifeCycle_Maintenance_Cost","LifeCycle_Maintenance_Source","LifeCycle_Operation_Cost","LifeCycle_Operation_Source","LifeCycle_Renewal_Cost","LifeCycle_Renewal_Source","LifeCycle_End_of_Life_Cost","LifeCycle_Replacement_Cost","LifeCycle_EmgReplacement_Cost","LifeCycle_Replacement_Source","LifeCycle_Admin_Cost","LifeCycle_Total_Cost","LifeCycle_Cost_Annual","Climate_Change_Risk","Climate_Change_Risk_Type","Climate_Change_Risk_Probability","Climate_Change_Risk_Impact","Priority_Failure","Priority_Health_Security","Priority_Climate_Change","Priority_Essential_Asset","Priority_High_Value_Asset","Priority_Positive_Finance","Priority_Strategic_Plan","Priority_Perceived_Value","Priority_Pertinence_Need","Priority_Final_Index","PSAB_2016_Comments","PSAB_2017_Comments","PSAB_2018_Comments","TempField","TempField2","TempField3","Feature_Creator","Creation_Date","Last_Editor","Last_Edit_Date","Shape.STLength()"]},{"type":"CIMAttachmentsMediaInfo","row":2,"column":1,"refreshRateUnit":"esriTimeUnitsSeconds","rowSpan":1,"columnSpan":1,"title":"{MasterEGDB.DBO.Water_Lines3__ATTACHREL\\ATT_NAME}","contentType":"image/*","displayType":"PreviewAll"}]},"showPopups":true,"serviceLayerID":-1,"refreshRate":-1,"refreshRateUnit":"esriTimeUnitsSeconds","blendingMode":"Alpha","autoGenerateFeatureTemplates":true,"featureElevationExpression":"0","featureTable":{"type":"CIMFeatureTable","displayField":"Show_When_Page_Name_Is_Not","editable":true,"dataConnection":{"type":"CIMFeatureDatasetDataConnection","featureDataset":"gis_vector.sde.PW","workspaceConnectionString":"ENCRYPTED_PASSWORD=00022e682b79466b6a5069766e7a634630435953485a435644634b365a5365707434452b72743534723664343053773d2a00;SERVER=srv-ch-arcgispg;INSTANCE=sde:postgresql:srv-ch-arcgispg;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=srv-ch-arcgispg;DATABASE=gis_vector;USER=sde;AUTHENTICATION_MODE=DBMS;BRANCH=sde.DEFAULT","workspaceFactory":"SDE","dataset":"gis_vector.sde.Water_Lines","datasetType":"esriDTFeatureClass"},"studyAreaSpatialRel":"esriSpatialRelUndefined","searchOrder":"esriSearchOrderSpatial"},"htmlPopupEnabled":true,"selectable":true,"featureCacheType":"Session","displayFiltersType":"ByScale","featureBlendingMode":"Alpha","labelClasses":[{"type":"CIMLabelClass","expression":"$feature.Show_When_Page_Name_Is_Not","expressionEngine":"Arcade","featuresToLabel":"AllVisibleFeatures","maplexLabelPlacementProperties":{"type":"CIMMaplexLabelPlacementProperties","featureType":"Line","avoidPolygonHoles":true,"canOverrunFeature":true,"canPlaceLabelOutsidePolygon":true,"canRemoveOverlappingLabel":true,"canStackLabel":true,"connectionType":"MinimizeLabels","constrainOffset":"AboveLine","contourAlignmentType":"Page","contourLadderType":"Straight","contourMaximumAngle":90,"enableConnection":true,"featureWeight":0,"fontHeightReductionLimit":4,"fontHeightReductionStep":0.5,"fontWidthReductionLimit":90,"fontWidthReductionStep":5,"graticuleAlignmentType":"Straight","keyNumberGroupName":"Default","labelBuffer":15,"labelLargestPolygon":true,"labelPriority":-1,"labelStackingProperties":{"type":"CIMMaplexLabelStackingProperties","stackAlignment":"ChooseBest","maximumNumberOfLines":3,"minimumNumberOfCharsPerLine":3,"maximumNumberOfCharsPerLine":24,"separators":[{"type":"CIMMaplexStackingSeparator","separator":" ","splitAfter":true},{"type":"CIMMaplexStackingSeparator","separator":",","visible":true,"splitAfter":true}]},"lineFeatureType":"General","linePlacementMethod":"OffsetStraightFromLine","maximumLabelOverrun":16,"maximumLabelOverrunUnit":"Point","minimumFeatureSizeUnit":"Map","multiPartOption":"OneLabelPerFeature","offsetAlongLineProperties":{"type":"CIMMaplexOffsetAlongLineProperties","placementMethod":"BestPositionAlongLine","labelAnchorPoint":"CenterOfLabel","distanceUnit":"Map","useLineDirection":true},"pointExternalZonePriorities":{"type":"CIMMaplexExternalZonePriorities","aboveLeft":4,"aboveCenter":2,"aboveRight":1,"centerRight":3,"belowRight":5,"belowCenter":7,"belowLeft":8,"centerLeft":6},"pointPlacementMethod":"AroundPoint","polygonAnchorPointType":"GeometricCenter","polygonBoundaryWeight":0,"polygonExternalZones":{"type":"CIMMaplexExternalZonePriorities","aboveLeft":4,"aboveCenter":2,"aboveRight":1,"centerRight":3,"belowRight":5,"belowCenter":7,"belowLeft":8,"centerLeft":6},"polygonFeatureType":"General","polygonInternalZones":{"type":"CIMMaplexInternalZonePriorities","center":1},"polygonPlacementMethod":"CurvedInPolygon","primaryOffset":1,"primaryOffsetUnit":"Point","removeExtraWhiteSpace":true,"repetitionIntervalUnit":"Map","rotationProperties":{"type":"CIMMaplexRotationProperties","rotationType":"Arithmetic","alignmentType":"Straight"},"secondaryOffset":100,"strategyPriorities":{"type":"CIMMaplexStrategyPriorities","stacking":1,"overrun":2,"fontCompression":3,"fontReduction":4,"abbreviation":5},"thinningDistanceUnit":"Point","truncationMarkerCharacter":".","truncationMinimumLength":1,"truncationPreferredCharacters":"aeiou","polygonAnchorPointPerimeterInsetUnit":"Point"},"name":"Class 1","priority":-1,"standardLabelPlacementProperties":{"type":"CIMStandardLabelPlacementProperties","featureType":"Line","featureWeight":"None","labelWeight":"High","numLabelsOption":"OneLabelPerName","lineLabelPosition":{"type":"CIMStandardLineLabelPosition","above":true,"inLine":true,"parallel":true},"lineLabelPriorities":{"type":"CIMStandardLineLabelPriorities","aboveStart":3,"aboveAlong":3,"aboveEnd":3,"centerStart":3,"centerAlong":3,"centerEnd":3,"belowStart":3,"belowAlong":3,"belowEnd":3},"pointPlacementMethod":"AroundPoint","pointPlacementPriorities":{"type":"CIMStandardPointPlacementPriorities","aboveLeft":2,"aboveCenter":2,"aboveRight":1,"centerLeft":3,"centerRight":2,"belowLeft":3,"belowCenter":3,"belowRight":2},"rotationType":"Arithmetic","polygonPlacementMethod":"AlwaysHorizontal"},"textSymbol":{"type":"CIMSymbolReference","symbol":{"type":"CIMTextSymbol","blockProgression":"TTB","depth3D":1,"extrapolateBaselines":true,"fontEffects":"Normal","fontEncoding":"Unicode","fontFamilyName":"Tahoma","fontStyleName":"Regular","fontType":"Unspecified","haloSize":1,"height":10,"hinting":"Default","horizontalAlignment":"Left","kerning":true,"letterWidth":100,"ligatures":true,"lineGapType":"ExtraLeading","symbol":{"type":"CIMPolygonSymbol","symbolLayers":[{"type":"CIMSolidFill","enable":true,"color":{"type":"CIMRGBColor","values":[0,0,0,100]}}]},"textCase":"Normal","textDirection":"LTR","verticalAlignment":"Bottom","verticalGlyphOrientation":"Right","wordSpacing":100,"billboardMode3D":"FaceNearPlane"}},"useCodedValue":true,"visibility":true,"iD":-1}],"renderer":{"type":"CIMUniqueValueRenderer","colorRamp":{"type":"CIMFixedColorRamp","colorSpace":{"type":"CIMICCColorSpace","url":"Default RGB"},"colors":[{"type":"CIMRGBColor","colorSpace":{"type":"CIMICCColorSpace","url":"Default RGB"},"values":[253,127,111,100]},{"type":"CIMRGBColor","colorSpace":{"type":"CIMICCColorSpace","url":"Default RGB"},"values":[126,176,213,100]},{"type":"CIMRGBColor","colorSpace":{"type":"CIMICCColorSpace","url":"Default RGB"},"values":[178,224,97,100]},{"type":"CIMRGBColor","colorSpace":{"type":"CIMICCColorSpace","url":"Default RGB"},"values":[189,126,190,100]},{"type":"CIMRGBColor","colorSpace":{"type":"CIMICCColorSpace","url":"Default RGB"},"values":[255,181,90,100]},{"type":"CIMRGBColor","colorSpace":{"type":"CIMICCColorSpace","url":"Default RGB"},"values":[255,238,101,100]},{"type":"CIMRGBColor","colorSpace":{"type":"CIMICCColorSpace","url":"Default RGB"},"values":[190,185,219,100]},{"type":"CIMRGBColor","colorSpace":{"type":"CIMICCColorSpace","url":"Default RGB"},"values":[253,204,229,100]},{"type":"CIMRGBColor","colorSpace":{"type":"CIMICCColorSpace","url":"Default RGB"},"values":[139,211,199,100]},{"type":"CIMRGBColor","colorSpace":{"type":"CIMICCColorSpace","url":"Default RGB"},"values":[203,236,196,100]}],"arrangement":"Default"},"defaultLabel":"\u003call other values\u003e","defaultSymbol":{"type":"CIMSymbolReference","symbol":{"type":"CIMLineSymbol","symbolLayers":[{"type":"CIMSolidStroke","enable":true,"capStyle":"Round","joinStyle":"Round","lineStyle3D":"Strip","miterLimit":10,"width":1.5,"color":{"type":"CIMRGBColor","values":[130,130,130,100]}}]},"symbolName":"Level_1"},"defaultSymbolPatch":"Default","fields":["Asset_Subtype"],"groups":[{"type":"CIMUniqueValueGroup","classes":[{"type":"CIMUniqueValueClass","label":"Water - Main","patch":"Default","symbol":{"type":"CIMSymbolReference","symbol":{"type":"CIMLineSymbol","symbolLayers":[{"type":"CIMSolidStroke","enable":true,"capStyle":"Round","joinStyle":"Round","lineStyle3D":"Strip","miterLimit":10,"width":1.25,"color":{"type":"CIMRGBColor","values":[0,0,255,100]}}]}},"values":[{"type":"CIMUniqueValue","fieldValues":["101"]}],"visible":true},{"type":"CIMUniqueValueClass","label":"Water - Lateral","patch":"Default","symbol":{"type":"CIMSymbolReference","symbol":{"type":"CIMLineSymbol","symbolLayers":[{"type":"CIMSolidStroke","enable":true,"capStyle":"Round","joinStyle":"Round","lineStyle3D":"Strip","miterLimit":10,"width":1,"color":{"type":"CIMRGBColor","values":[0,0,255,100]}}]}},"values":[{"type":"CIMUniqueValue","fieldValues":["102"]}],"visible":true},{"type":"CIMUniqueValueClass","label":"Water - Fire Hydrant - Latera","patch":"Default","symbol":{"type":"CIMSymbolReference","symbol":{"type":"CIMLineSymbol","symbolLayers":[{"type":"CIMSolidStroke","enable":true,"capStyle":"Round","joinStyle":"Round","lineStyle3D":"Strip","miterLimit":10,"width":1,"color":{"type":"CIMRGBColor","values":[255,0,0,100]}}]}},"values":[{"type":"CIMUniqueValue","fieldValues":["105"]}],"visible":true},{"type":"CIMUniqueValueClass","label":"Water - Private Lateral","patch":"Default","symbol":{"type":"CIMSymbolReference","symbol":{"type":"CIMLineSymbol","symbolLayers":[{"type":"CIMSolidStroke","enable":true,"capStyle":"Round","joinStyle":"Round","lineStyle3D":"Strip","miterLimit":10,"width":1,"color":{"type":"CIMRGBColor","values":[115,178,255,100]}}]}},"values":[{"type":"CIMUniqueValue","fieldValues":["109"]}],"visible":true}]}],"polygonSymbolColorTarget":"Fill"},"scaleSymbols":true,"snappable":true}]} 20210601 12235300 20210601 12235300 Microsoft Windows 10 Version 10.0 (Build 19043) ; Esri ArcGIS 12.7.0.26828 Water_Lines 1 -65.722119 -65.602010 47.681333 47.593125 Water_Lines Water_Lines Enterprise Geodatabase Feature Class dataset EPSG 6.2(9.3.0.0) 0 Simple FALSE 0 TRUE FALSE gis_vector.sde.Water_Lines Feature Class 0 OBJECTID objectid OID 4 10 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. Shape shape Geometry 8 0 0 Feature geometry. Esri Coordinates defining the features. Related_PID Related PID String 50 0 0 Closest_Civic_Address Closest Civic Address String 50 0 0 Related_Civic_Number Related Civic Number String 50 0 0 Related_Street_Name Related Street Name SmallInteger 2 5 0 GlobalID GlobalID GlobalID 38 0 0 Related_Street_Section Related Street Section Double 8 38 8 Asset_Type Asset Type SmallInteger 2 5 0 Asset_Subtype Asset Subtype SmallInteger 2 5 0 Asset_ID Asset ID String 50 0 0 Grid_Reference Grid Reference String 6 0 0 Installation_Year Installation Year (Finance) SmallInteger 2 5 0 Diameter Diameter SmallInteger 2 5 0 Material Material SmallInteger 2 5 0 Pipe_Class Pipe Class SmallInteger 2 5 0 Last_Maintenance_Inspection_Dat Last Maintenance Inspection Date SmallInteger 2 5 0 Lateral_With_DBH Lateral With DBH SmallInteger 2 5 0 Depth Depth SmallInteger 2 5 0 Comments Comments String 60 0 0 TTYYPPEE TTYYPPEE String 50 0 0 PSAB_2016_Comments PSAB 2016 Comments SmallInteger 2 5 0 PSAB_2017_Comments PSAB 2017 Comments SmallInteger 2 5 0 Link_to_As_Built Link to As-Built String 250 0 0 GeoLocation GeoLocation SmallInteger 2 5 0 Asset_Group Asset Group SmallInteger 2 5 0 Jurisdiction Jurisdiction SmallInteger 2 5 0 Tangible_Capital_Asset Tangible Capital Asset SmallInteger 2 5 0 Expected_Life_Years Expected Life Years SmallInteger 2 5 0 Feature_Creator Feature Creator String 150 0 0 Creation_Date Creation Date Date 8 0 0 Last_Editor Last Editor String 255 0 0 Last_Edit_Date Last Edit Date Date 8 0 0 End_of_Life_Date End of Life Date SmallInteger 2 5 0 Remaining_Life_Years Remaining Life Years SmallInteger 2 5 0 Remaining_Life_Percent Remaining Life Percent Double 8 38 8 Condition_Rating Condition Rating (1 to 5) SmallInteger 2 5 0 Cost_per_Unit Cost_per_Unit Double 8 38 8 Asset_Replacement_Value Asset Replacement Value Double 8 38 8 Emergency_Asset_Replacement_Val Emergency Asset Replacement Value Double 8 38 8 Remaining_Value Remaining Value Double 8 38 8 Infrastructure_Deficit__Backlog Infrastructure Deficit (Backlog) Double 8 38 8 Link_to_Ti_Ins Link to Ti-Ins String 250 0 0 Show_When_Page_Name_Is_Not Show When Page Name Is Not String 50 0 0 Water - Main 101 asset_group COB_Asset Group Assets Group Coded Value Default value Duplicate sde SmallInteger 1 asset_type COB_Asset Type Assets Type Coded Value Default value Default value sde SmallInteger 1 related_street_name COB_Street Index Street Index Coded Value Default value Default value sde SmallInteger related_street_section COB_Street Sections Street Sections Coded Value Default value Default value sde Double geolocation COB_GeoLocation GeoLocation Coded Value Default value Default value sde SmallInteger grid_reference COB_Grid_Reference Grid Reference Coded Value Default value Default value sde String installation_year COB_Year Year Coded Value Default value Default value sde SmallInteger diameter COB_Diameter Diameter Coded Value Default value Default value sde SmallInteger material COB_Material Material Coded Value Default value Default value sde SmallInteger pipe_class COB_Pipe_Class Pipe Class Coded Value Default value Default value sde SmallInteger lateral_with_dbh 1 COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger jurisdiction COB_Jurisdiction Jurisdiction Coded Value Default value Default value sde SmallInteger 1 tangible_capital_asset COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger 1 condition_rating 1 COB_Condition_Rating Condition Rating Coded Value Default value Default value sde SmallInteger enabled EnabledDomain Coded Value Default value Default value sde SmallInteger 1 psab_2018_comments COB_PSAB_Comment PSAB Comment Coded Value Default value Default value sde SmallInteger asset_category 3 COB_Asset_Category Asset Category Coded Value Default value Default value sde SmallInteger asset_class 7 COB_Asset_Class Asset Class Coded Value Default value Default value sde SmallInteger asset_subclass 608 COB_Asset_SubClass Asset SubClass Coded Value Default value Default value sde SmallInteger residual_value 0 condition_method 1 COB_Conditon_Method Conditon Method Coded Value Default value Default value sde SmallInteger asset_totally_depreciated COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger salvage_value 0 lifecycle_maintenance_source COB_Funding_Sources Source of Funding Coded Value Default value Default value sde SmallInteger lifecycle_operation_source COB_Funding_Sources Source of Funding Coded Value Default value Default value sde SmallInteger lifecycle_renewal_source COB_Funding_Sources Source of Funding Coded Value Default value Default value sde SmallInteger lifecycle_replacement_source COB_Funding_Sources Source of Funding Coded Value Default value Default value sde SmallInteger climate_change_risk 2 COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger climate_change_risk_type 0 COB_Climate_Change_Risk_Type Climate Change Risk Type Coded Value Default value Default value sde SmallInteger climate_change_risk_probability 0 COB_Climate_Change_Risk_Probability Climate Change Risk Probability Coded Value Default value Default value sde SmallInteger climate_change_risk_impact 0 COB_Climate_Change_Risk_Impact Climate Change Risk Impact Coded Value Default value Default value sde SmallInteger priority_failure 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_health_security 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_climate_change 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_essential_asset 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_high_value_asset 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_positive_finance 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_strategic_plan 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_perceived_value 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_pertinence_need 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger Water - Lateral 102 asset_group COB_Asset Group Assets Group Coded Value Default value Duplicate sde SmallInteger 1 asset_type COB_Asset Type Assets Type Coded Value Default value Default value sde SmallInteger 1 related_street_name COB_Street Index Street Index Coded Value Default value Default value sde SmallInteger related_street_section COB_Street Sections Street Sections Coded Value Default value Default value sde Double geolocation COB_GeoLocation GeoLocation Coded Value Default value Default value sde SmallInteger grid_reference COB_Grid_Reference Grid Reference Coded Value Default value Default value sde String installation_year COB_Year Year Coded Value Default value Default value sde SmallInteger diameter COB_Diameter Diameter Coded Value Default value Default value sde SmallInteger material COB_Material Material Coded Value Default value Default value sde SmallInteger pipe_class COB_Pipe_Class Pipe Class Coded Value Default value Default value sde SmallInteger lateral_with_dbh COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger jurisdiction COB_Jurisdiction Jurisdiction Coded Value Default value Default value sde SmallInteger 1 tangible_capital_asset COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger 2 condition_rating 1 COB_Condition_Rating Condition Rating Coded Value Default value Default value sde SmallInteger enabled EnabledDomain Coded Value Default value Default value sde SmallInteger 1 psab_2018_comments COB_PSAB_Comment PSAB Comment Coded Value Default value Default value sde SmallInteger asset_category 4 COB_Asset_Category Asset Category Coded Value Default value Default value sde SmallInteger asset_class 7 COB_Asset_Class Asset Class Coded Value Default value Default value sde SmallInteger asset_subclass 608 COB_Asset_SubClass Asset SubClass Coded Value Default value Default value sde SmallInteger residual_value 0 condition_method 1 COB_Conditon_Method Conditon Method Coded Value Default value Default value sde SmallInteger asset_totally_depreciated COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger salvage_value 0 lifecycle_maintenance_source COB_Funding_Sources Source of Funding Coded Value Default value Default value sde SmallInteger lifecycle_operation_source COB_Funding_Sources Source of Funding Coded Value Default value Default value sde SmallInteger lifecycle_renewal_source COB_Funding_Sources Source of Funding Coded Value Default value Default value sde SmallInteger lifecycle_replacement_source COB_Funding_Sources Source of Funding Coded Value Default value Default value sde SmallInteger climate_change_risk 2 COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger climate_change_risk_type 0 COB_Climate_Change_Risk_Type Climate Change Risk Type Coded Value Default value Default value sde SmallInteger climate_change_risk_probability 0 COB_Climate_Change_Risk_Probability Climate Change Risk Probability Coded Value Default value Default value sde SmallInteger climate_change_risk_impact 0 COB_Climate_Change_Risk_Impact Climate Change Risk Impact Coded Value Default value Default value sde SmallInteger priority_failure 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_health_security 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_climate_change 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_essential_asset 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_high_value_asset 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_positive_finance 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_strategic_plan 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_perceived_value 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_pertinence_need 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger Water - Fire Hydrant - Lateral 105 asset_group COB_Asset Group Assets Group Coded Value Default value Duplicate sde SmallInteger 1 asset_type COB_Asset Type Assets Type Coded Value Default value Default value sde SmallInteger 1 related_street_name COB_Street Index Street Index Coded Value Default value Default value sde SmallInteger related_street_section COB_Street Sections Street Sections Coded Value Default value Default value sde Double geolocation COB_GeoLocation GeoLocation Coded Value Default value Default value sde SmallInteger grid_reference COB_Grid_Reference Grid Reference Coded Value Default value Default value sde String installation_year COB_Year Year Coded Value Default value Default value sde SmallInteger diameter COB_Diameter Diameter Coded Value Default value Default value sde SmallInteger material COB_Material Material Coded Value Default value Default value sde SmallInteger pipe_class COB_Pipe_Class Pipe Class Coded Value Default value Default value sde SmallInteger lateral_with_dbh COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger jurisdiction COB_Jurisdiction Jurisdiction Coded Value Default value Default value sde SmallInteger 1 tangible_capital_asset COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger 2 condition_rating 1 COB_Condition_Rating Condition Rating Coded Value Default value Default value sde SmallInteger enabled EnabledDomain Coded Value Default value Default value sde SmallInteger 1 psab_2018_comments COB_PSAB_Comment PSAB Comment Coded Value Default value Default value sde SmallInteger asset_category 4 COB_Asset_Category Asset Category Coded Value Default value Default value sde SmallInteger asset_class 7 COB_Asset_Class Asset Class Coded Value Default value Default value sde SmallInteger asset_subclass 608 COB_Asset_SubClass Asset SubClass Coded Value Default value Default value sde SmallInteger residual_value 0 condition_method 1 COB_Conditon_Method Conditon Method Coded Value Default value Default value sde SmallInteger asset_totally_depreciated COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger salvage_value 0 lifecycle_maintenance_source COB_Funding_Sources Source of Funding Coded Value Default value Default value sde SmallInteger lifecycle_operation_source COB_Funding_Sources Source of Funding Coded Value Default value Default value sde SmallInteger lifecycle_renewal_source COB_Funding_Sources Source of Funding Coded Value Default value Default value sde SmallInteger lifecycle_replacement_source COB_Funding_Sources Source of Funding Coded Value Default value Default value sde SmallInteger climate_change_risk 2 COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger climate_change_risk_type 0 COB_Climate_Change_Risk_Type Climate Change Risk Type Coded Value Default value Default value sde SmallInteger climate_change_risk_probability 0 COB_Climate_Change_Risk_Probability Climate Change Risk Probability Coded Value Default value Default value sde SmallInteger climate_change_risk_impact 0 COB_Climate_Change_Risk_Impact Climate Change Risk Impact Coded Value Default value Default value sde SmallInteger priority_failure 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_health_security 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_climate_change 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_essential_asset 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_high_value_asset 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_positive_finance 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_strategic_plan 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_perceived_value 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_pertinence_need 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger Water - Private Lateral 109 asset_group COB_Asset Group Assets Group Coded Value Default value Duplicate sde SmallInteger 1 asset_type COB_Asset Type Assets Type Coded Value Default value Default value sde SmallInteger 1 related_street_name COB_Street Index Street Index Coded Value Default value Default value sde SmallInteger related_street_section COB_Street Sections Street Sections Coded Value Default value Default value sde Double geolocation COB_GeoLocation GeoLocation Coded Value Default value Default value sde SmallInteger grid_reference COB_Grid_Reference Grid Reference Coded Value Default value Default value sde String installation_year COB_Year Year Coded Value Default value Default value sde SmallInteger diameter COB_Diameter Diameter Coded Value Default value Default value sde SmallInteger material COB_Material Material Coded Value Default value Default value sde SmallInteger pipe_class COB_Pipe_Class Pipe Class Coded Value Default value Default value sde SmallInteger lateral_with_dbh COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger jurisdiction COB_Jurisdiction Jurisdiction Coded Value Default value Default value sde SmallInteger 3 tangible_capital_asset COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger 2 condition_rating 1 COB_Condition_Rating Condition Rating Coded Value Default value Default value sde SmallInteger enabled EnabledDomain Coded Value Default value Default value sde SmallInteger 1 psab_2018_comments COB_PSAB_Comment PSAB Comment Coded Value Default value Default value sde SmallInteger asset_category 4 COB_Asset_Category Asset Category Coded Value Default value Default value sde SmallInteger asset_class 7 COB_Asset_Class Asset Class Coded Value Default value Default value sde SmallInteger asset_subclass 608 COB_Asset_SubClass Asset SubClass Coded Value Default value Default value sde SmallInteger residual_value 0 condition_method 1 COB_Conditon_Method Conditon Method Coded Value Default value Default value sde SmallInteger asset_totally_depreciated COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger salvage_value 0 lifecycle_maintenance_source COB_Funding_Sources Source of Funding Coded Value Default value Default value sde SmallInteger lifecycle_operation_source COB_Funding_Sources Source of Funding Coded Value Default value Default value sde SmallInteger lifecycle_renewal_source COB_Funding_Sources Source of Funding Coded Value Default value Default value sde SmallInteger lifecycle_replacement_source COB_Funding_Sources Source of Funding Coded Value Default value Default value sde SmallInteger climate_change_risk 2 COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger climate_change_risk_type 0 COB_Climate_Change_Risk_Type Climate Change Risk Type Coded Value Default value Default value sde SmallInteger climate_change_risk_probability 0 COB_Climate_Change_Risk_Probability Climate Change Risk Probability Coded Value Default value Default value sde SmallInteger climate_change_risk_impact 0 COB_Climate_Change_Risk_Impact Climate Change Risk Impact Coded Value Default value Default value sde SmallInteger priority_failure 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_health_security 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_climate_change 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_essential_asset 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_high_value_asset 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_positive_finance 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_strategic_plan 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_perceived_value 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_pertinence_need 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger Transportation System 4 Asset_Group COB_Asset Group City's Assets by Group Coded Value Default value Duplicate DBO SmallInteger -1 Related_Street_Name COB_Street Index Street Index Coded Value Default value Default value DBO SmallInteger Related_Street_Section COB_Street Sections Street Sections Coded Value Default value Default value DBO Double GeoLocation COB_GeoLocation GeoLocation Coded Value Default value Default value DBO SmallInteger Grid_Reference COB_Grid_Reference Grid Reference Coded Value Default value Default value DBO String Installation_Year COB_Year Year Coded Value Default value Default value DBO SmallInteger Diameter COB_Diameter Diameter Coded Value Default value Default value DBO SmallInteger Material COB_Material Material Coded Value Default value Default value DBO SmallInteger Pipe_Class COB_Pipe_Class Pipe Class Coded Value Default value Default value DBO SmallInteger Lateral_With_DBH COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value DBO SmallInteger Enabled EnabledDomain Coded Value Default value Default value DBO SmallInteger PSAB_2017_Comments COB_PSAB_Comments PSAB Comments Coded Value Default value Default value DBO SmallInteger GeoLocation COB_Eng_GeoLocation GeoLocation Coded Value Default value Duplicate DBO SmallInteger Land 4 Asset_Type COB_Asset Type City Assets by Type Coded Value Default value Default value DBO SmallInteger Related_Street_Name COB_Street Index Street Index Coded Value Default value Default value DBO SmallInteger Related_Street_Section COB_Street Sections Street Sections Coded Value Default value Default value DBO Double GeoLocation COB_GeoLocation GeoLocation Coded Value Default value Default value DBO SmallInteger Grid_Reference COB_Grid_Reference Grid Reference Coded Value Default value Default value DBO String Installation_Year COB_Year Year Coded Value Default value Default value DBO SmallInteger Diameter COB_Diameter Diameter Coded Value Default value Default value DBO SmallInteger Material COB_Material Material Coded Value Default value Default value DBO SmallInteger Pipe_Class COB_Pipe_Class Pipe Class Coded Value Default value Default value DBO SmallInteger Lateral_With_DBH COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value DBO SmallInteger Enabled Enabled SmallInteger 2 5 0 PSAB_2018_Comments PSAB 2018 Comments SmallInteger 2 5 0 TempField TempField String 255 0 0 Cost_For_Length Cost For Length Double 8 38 8 Asset_Category Asset Category SmallInteger 2 5 0 Related_Service Related Service SmallInteger 2 5 0 Asset_Class Asset Class SmallInteger 2 5 0 Asset_SubClass Asset SubClass SmallInteger 2 5 0 Asset_Name Asset Name String 255 0 0 Historical_Acquisition_Cost2 Historical Acquisition Cost (Previous 2x) Double 8 38 8 Historical_Acquisition_Cost1 Historical Acquisition Cost (Previous 1x) Double 8 38 8 Cost_per_Unit_Readjustment Cost per Unit Readjustment String 255 0 0 Residual_Value Residual Value Double 8 38 8 Condition_Method Condition Method SmallInteger 2 5 0 Opening_Book_Value Opening Book Value Double 8 38 8 Closing_Book_Value Closing Book Value Double 8 38 8 Asset_Totally_Depreciated Asset Totally Depreciated SmallInteger 2 5 0 Salvage_Value Salvage Value Double 8 38 8 LifeCycle_Maintenance_Cost LifeCycle Maintenance Cost Double 8 38 8 LifeCycle_Maintenance_Source LifeCycle Maintenance Source of Funding SmallInteger 2 5 0 LifeCycle_Operation_Cost LifeCycle Operation Cost Double 8 38 8 LifeCycle_Operation_Source LifeCycle Operation Source of Funding SmallInteger 2 5 0 LifeCycle_Renewal_Cost LifeCycle Renewal Cost Double 8 38 8 LifeCycle_Renewal_Source LifeCycle Renewal Source SmallInteger 2 5 0 LifeCycle_End_of_Life_Cost LifeCycle End of Life Cost Double 8 38 8 LifeCycle_Replacement_Cost LifeCycle Replacement Cost Double 8 38 8 LifeCycle_EmgReplacement_Cost LifeCycle Emergency Replacement Cost Double 8 38 8 LifeCycle_Replacement_Source LifeCycle Replacement Source of Funding SmallInteger 2 5 0 LifeCycle_Admin_Cost LifeCycle Administrative Cost Double 8 38 8 LifeCycle_Total_Cost LifeCycle Total Cost Double 8 38 8 LifeCycle_Cost_Annual LifeCycle_Cost_Annual Double 8 38 8 Climate_Change_Risk Climate Change Risk SmallInteger 2 5 0 Climate_Change_Risk_Type Climate Change Risk Type SmallInteger 2 5 0 Climate_Change_Risk_Probability Climate Change Risk Probability SmallInteger 2 5 0 Climate_Change_Risk_Impact Climate Change Risk Impact SmallInteger 2 5 0 Priority_Failure Priority Failure SmallInteger 2 5 0 Priority_Health_Security Priority Health Security SmallInteger 2 5 0 Priority_Climate_Change Priority Climate Change SmallInteger 2 5 0 Priority_Essential_Asset Priority Essential Asset SmallInteger 2 5 0 Priority_High_Value_Asset Priority High Value Asset SmallInteger 2 5 0 Priority_Positive_Finance Priority Positive Finance SmallInteger 2 5 0 Priority_Strategic_Plan Priority Strategic Plan SmallInteger 2 5 0 Priority_Perceived_Value Priority Perceived Value SmallInteger 2 5 0 Priority_Pertinence_Need Priority Pertinence Need SmallInteger 2 5 0 Priority_Final_Index Priority Final Index SmallInteger 2 5 0 Asset_Description Asset Description String 255 0 0 Replacement_Cost_per_Unit Replacement Cost per Unit Double 8 38 8 TempField3 TempField3 Double 8 38 8 TempField2 TempField2 String 255 0 0 FA_CLASS_CODE FA_CLASS_CODE String 6 0 0 FA_ASSET_CODE FA_ASSET_CODE String 10 0 0 SCHED_NAME SCHED_NAME String 50 0 0 FA_SCHED_STATUS FA_SCHED_STATUS String 6 0 0 DEPREC_VALUE DEPREC_VALUE Double 8 38 8 LIFE_EXPECTANCY LIFE_EXPECTANCY Integer 4 10 0 START_DATE START_DATE Date 8 0 0 Loss_in_Value_Year Loss in Value (This Year) Double 8 38 8 Loss_In_Value_Total Loss in Value (Since Acquisition) Double 8 38 8 Installation_Year_Ground Installation Year (Ground) SmallInteger 2 5 0 PSAB_2019_Comment PSAB 2019 Comment SmallInteger 2 5 0 Project_Name Project Name String 255 0 0 Project_Description Project Description String 255 0 0 Project_Start_Date Project Start Date Date 8 0 0 Project_End_Date Project End Date Date 8 0 0 Project_Status Project Status SmallInteger 2 5 0 TempField4 TempField4 String 255 0 0 Park & Signs 5 Asset_Type COB_Asset Type City Assets by Type Coded Value Default value Default value DBO SmallInteger Related_Street_Name COB_Street Index Street Index Coded Value Default value Default value DBO SmallInteger Related_Street_Section COB_Street Sections Street Sections Coded Value Default value Default value DBO Double GeoLocation COB_GeoLocation GeoLocation Coded Value Default value Default value DBO SmallInteger Grid_Reference COB_Grid_Reference Grid Reference Coded Value Default value Default value DBO String Installation_Year COB_Year Year Coded Value Default value Default value DBO SmallInteger Diameter COB_Diameter Diameter Coded Value Default value Default value DBO SmallInteger Material COB_Material Material Coded Value Default value Default value DBO SmallInteger Pipe_Class COB_Pipe_Class Pipe Class Coded Value Default value Default value DBO SmallInteger Lateral_With_DBH COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value DBO SmallInteger Machinery & Equipment 6 Asset_Type COB_Asset Type City Assets by Type Coded Value Default value Default value DBO SmallInteger Related_Street_Name COB_Street Index Street Index Coded Value Default value Default value DBO SmallInteger Related_Street_Section COB_Street Sections Street Sections Coded Value Default value Default value DBO Double GeoLocation COB_GeoLocation GeoLocation Coded Value Default value Default value DBO SmallInteger Grid_Reference COB_Grid_Reference Grid Reference Coded Value Default value Default value DBO String Installation_Year COB_Year Year Coded Value Default value Default value DBO SmallInteger Diameter COB_Diameter Diameter Coded Value Default value Default value DBO SmallInteger Material COB_Material Material Coded Value Default value Default value DBO SmallInteger Pipe_Class COB_Pipe_Class Pipe Class Coded Value Default value Default value DBO SmallInteger Lateral_With_DBH COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value DBO SmallInteger st_length(shape) st_length(shape) Double 0 0 0 20210601 /9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD26iii oAa5xGx9jSqMKB7Ukn+qf/dNUX1rT4tVj0t7lReSLlY+5qkm1oJtJ6mhRRS7TUjEopkk0EJAmmRC egZgM1Ui1myuGkW0LXTRNtkES5KH0PpVcrtcTaW5epcH0qgt3qEuoJarYGFGQv58hyv04xzSajd2 mmQebqWq+WhYLtiAByfTHNJONm3JKwoSU/hGavrVroqxG53nzGCgIuce5q293bggCUOSOAvOfyqj f21rPaNNa2Bu7lV3RNcMQGPbNEesy2zWdpdRJaT3PAWKPcu7HIzSc6cXu3+H4lqMmX1e4k/1VnKf UvhP51x+uaHqV/4ttNRN2beGyXdiKTcH9tvUmuxMbSf6yaR/UZwPyqK1060slYW8CJubce5J/Gq5 5fY0M5w5ramNJqdi/wBkWe/vBJdOUjiMRQls49jWgumQEHdZq5IwWnbOR+FXpbeGZ0eSNXaM5QsM 7T7VLUe+78z0K5IdvvM5dNljEKWdwtlBGfmitoVXcPTPan3WkWt5JBJch5HgkEiMznhh+lX160rd KHFNWZSbWwyjFKelFMQUDpQOlAoAKO9FBoAx55Es9RMkjhEEinnphuP55NbHesLxFpq6jGkLMypI CGx/FjkA/gWrajbdDGwGAVBx6cU5fF6/8MTHdofRRRSKCiiigA70d6BRQAVSnuH/ALSgtRBIY2Bd pQPlGOgq7RUyTatcmcXJWTsFFFFUUJ61AbG0JJNtDk9fkFWO9FUpNbMCnb29+mo3Us1yr2rhfJiC YKcc5Peru0+tUUj1K6ldpri3s7bAMXlOJJG9d2Rgfhn61Xv/AOx7C0e4vZp7xVI3JuL5PsvSo92C 1Yryk9EN1nXLfTYdqFJ5myvlrIARx3rldX/tO68UaRq+kaNE6AbbiecgYwQMA/TPP0rvoI9Pms4z HZReUyhlWSMcfgak2QhsiNAe2F6fT0rojVjGPurUycJuV29DCN9r907rb2UECK+Nzkvle5U9PzqW 9lt7AW39p3d673D+WqRDjPuF4rZMmfU/Wmsc81z3ko2T17/8NYuMLK0m3/XkZ1oYfMmjh0OSJUbA kuWQLJ7qAWP5gVdUzjOxooQeSIo+fzP+FPxS0NX1ZSSjsiFod/MrySeu5uD+HSlNtCU2GJCuc42i peooo5UVdiYoKgkEgZHSlopiCiiigAoHSiigAzjmgkkUUUAFA6UDpRQAUd6O9FABQelBOBk9KZHN HMpaORXGcZU5pgcj4o8ZafYRKltPDPdRSncm8AKQp4JJHXp+NdFo2oR6npUVyhXJ++Ac7WIDEfhu x+FUh4Q0Tz7qZrJGkuTmQv8ANz6jPSqGjWslreSQzadEdPZVkE27IR+jBlPAO4NyOwFVVcFytPTb 8/6d9vvMYxqe0vpa39fqbdvrFrc372cZfzE/iI+U9eh/A/lV8kDqcVnMNKtNQjRlhjubkHYMctj0 rF8ZeFb3xFHaCyv5LUQsSyrIyg+h49PSqXs5ysnYp+0jG7VzrKDUNrE0FpDC8hkdEClz1YgdabfX 1tp1pJd3kywwRDc7seAKztrZF30uyxQOlVNO1Kz1ayS8sZ0nt3+66Hg1boaadmCaeqCiiikMKKKK AENLRSAcdaAK1np9rYWkVrBCojiXau75iB9TVo8jHb0oopJJaIbbe4UHpQKKYgNFA6UCgAFFHeig AFFHejvQAUUUUAFFFFABR3ooNABQKxvFGsz6DoU19b2puZUIATOBz3PtWU+vazqPgT+1NOsDHqLg YhIzjnBI9eOa1jSlJKXTYzlUinY60kDJJwOuTSI6yDcjBh6g5ri5L3UrvwIINaWS21C8V4g0eFIG cK3seR+davg3w+3h7Q/IluzMJG80E5woI6DNVKlyxbb1JjV5pWSOhNcfovibWNQ8XXmmXWmeVZxB 9kvORg4Gfr1FdRcXKCCT7OfMl2naFG7n8Kx9J1HVnvIILmxDRyF/MnyAU29sd+aiMoqEpPXoVJSc 0kbN7am8sZ7YO0fmoU3jqMjrWF4N8JP4Ws54XvGuDKwPOcDH9a6Z5EjQu7BVHUk8Cuf1HWNUTVbS HTrBp7WQ4eRkIBPsew96cHNxcVsE1FNTZqalfRaXYyXkyuyJjIQZNZQ11bJ/KjtJJDdtuijb5eHw ck/XzDVvWftkdrEst1Z2xmmjVVYZONwzgngnGe1Jquiw3VlN5V/N9r2qVcNxhDuxgccjI/GsnHVp zS28+v8AkOrfkvHRlW3i+261bXKy2k1mqOoQDcUfvgnpWstlb2SyyxyvCpO9y0hKj356CoJbPSns IbhLSOJDtfK8bQeSf1rm7GK91PW3e1uxd6bbkoTI/BP90rj9ahwUJOMd2/T+rDnUqJJqN0b7Xmpi 8TyLeG7s3GRKh2sP6VhrFJr6XdjraTR2k+VVGXGGU9iPoa6YXN3boqvZ7gv/ADzIIA/T+VR2eo2q WqLcMYJGJZlkGPmY5PB7ZNdFOFSCbTu/vsZSpuT1l/kM0PR7LRNNWzsCDCrFic5JJ61b+2232k23 nJ5wGSmeabJYWV+VdfvochomKsPyrFk0K6OpyX9hd4kjYgRzruV+OcnqKhNybdQv3opKKNu5uDDa zSRIZZEQsqD+IgdK5zwT4h1bX7e7bVNPFq0TgIQDhgR057itO+1S+sbqxtzYeabiTazxZKoOP8e9 Lc+ItO062aW+L2eGI2TJgk+23Oc0U6sZpwUdSXL3rt2sa9FQWc4urOG4UhllUOCvTB6VDquqWuja bLf3jlIIh8xAyfoKOV3sa3SVy52pawbTxjoV3ptvf/b44YZ3McfnHYS4OCMHvW6CGAIOQeQaJQlH dCUlLZiiijvRUlB3ooooAKO9HejvQAd6KpnVLH+0PsH2qL7Xjd5O4bsfSrlNprcSaewUUGuMmfxV /wAJ8ixyINHwPkwOVxyfXOauEOe+uxM58tjs6KCMDJwB71mz6/pkFylubkPK8gi2xgthjzg46Vk5 KKuzRJvY0WJCkgZOOK8qvdX+I9/d3UNnZ+Skc3yGOIAgc4BLHBHTJHrXqQlZvuQOfduP51FJFqcl 1EyTwRQLnenll2b6HIx+RrWlWUL+7cyqU3O2tiSzFwbOH7VtE+weZjpuxzUjvFGMySKo9zioJ2tr eMvdXZ2j+9JjH5VXTUbNTm0tpZmPGY4sZ/4EetQ1N62sXeMVZsdqWoC1sZJobKa9K/8ALNFPI+p4 rC1aLVTremX8eox6fp4IV4JGHJwTgjp+tSyXfiObWnQWZj054yPnVTt9STnJPtVD+wovHGi2y6tP cqbSXGAnl7iOM4pwkoVLSlv0J5lOOkTotZ0htUsCs13Im35wYgqDI9yCQPoaljutLMaSLIsuQCCo MpHtkZxUiaXZoiqyGXaAFMrFiPoTU1tbW1mhS2gSJSSxCjGSepofJa1r/wBfMFzb2sRi7mf/AFFh IfeVwgP0xn+lc8bjU5fGf2OFxAqwmSQ+XlQG25wTkFuB6d66vf7VzPjWw1vUtKii0S6aCUShpNjB WZcHgE++KcbykoppfL/MHeKbev8AX3l+1inhvZp7m4N2CR5SyqP3XrjtVx76U8GQL7Dis3Toby20 22hv5RLdpEomcdGbHJqZ4o5CC6BiOmRXJJyTcb3sRBcsbIZeWtrqDxG6QStE+9Nx+63rVpXZCGjw WHTPSoDDGRgov5VKoCqAoAHoKhaO5d3sY2jQazcaRqVhqEi28i/JGQAxQ9Tj1XkY6enauhs4I4Ld fLjjRnAZyihdx7niq63Kx68kJVv9Ktt+7HBZDjGfoatwcRle6sVrrlq0+4Ulywt2Jtx9aRtrgh0B B45GaKKZZAun2iPvhQwt6wsU/Qdfxp8UNzbpsiuQ69SJ4wx/NcfrmpKAT61ftZdXcLDfOmH+ts8+ 8EgbH1DbT+Wax9X0nSfEV3Da3yCRNpZopQULYIwCpwe5P4Vt7jQ+yVCkiq6HqrDIqo1Ene1vQmUV JWZQvNHf7BHbabOdP8srtaNcjaO2KZqWmy6hALSdLa6s5BiZJgVY+hBHGc+1XhbKn+olkh9kbK/k cgfhil3XSfeWKcf7PyN+XI/Ws1Tjzc0Hr93/AAAcVa1jivEXgnQJdJhSW3nt4rXcAseG3hyNwJ56 kdetdZplzDd6dDLAGEe0BQ3UAUX8sU1qYJo3jErBGEi8YzzhunTNWEt7NEColuFHTGK1qOp7NKWr uZRpuMrx2H1T1PVbLR7Q3V/cJBCDjc3rWP4N07V9L0l7bWLs3E5kLR7n3sq+hPfnNaGveHrPxHYL aXqtsVw6lTggjvU8sYz5ZPQ05pON0tS9bXMN7apcW8iyQyDcrKeCKmqjp9rY6PYQ2Fu4EcK7VQHL fl1q15pP+rgkb3b5R+vP6VlKUbuxcU7akhoPAyeB6mq0zXDjyUngt5nHyA/O31A4z+VVb2xjk0tr PUtRLyOmCxcRlj9Bij3mvdVxq19WZb+DNNHi0eInmK3Gd20nqcY/LHaty71BbaEvFbXF03TZCnP6 4qtpl9YSafA9nbzyqUHAjwR9d2Knmu9SzGtvp6YZgC7yZCr6kcH+dW3OduZozi6cbqJaDTt92JU9 2NcF4lutP0jxzp11qF9dJLKhASJTtFdz9nupP9bdsoP8MYC4+hHNQyaJp8zb7iBZ5AMb5OTinTlG Du22KblJe6itp+r6VqFuJ4nkcn+GRG3H8DWdf6/aR6eLjT7A+WsoJlaMIilTzn+Wa37HTrLTIDDZ wJFGW3EKOpqSe3t7i3a3lgR4W+8jDg/hWTX8qW34/wBeo4+0uuZ6f1/WxDDLeXcKSxywJG43KyLu 3D8ac1h5gInuZpB/v4x9MVNGiwxLHGoRFGFVRgAU6qUpdw5F1ZWtNNtLGPZGm45JLP8AMxyc8mrQ IAwoAFJRS63KUUthdxpKKKBh3ooNFAB3ooNFAFS5XEgPqKjWJ26KavEcisrxJq8mhaFcahFbNcvE BiMHGfr7VKo88rLqTKyV2W1tm/iIFQ6iZrPTpZ7W2a6nXG2IHG7nmqvhnXJtf0SK+kszbuxIKFuO O4PcU7WotUla3+xFlUE7xG+DnjBPqOtWsMuZwbt5k+0SjzpXH3ovnsLO7AjtvJdXkTG5gCMEenep rKwNnqF3IbmWXz8SBXPC9uKmNmXsXF3NLKxjw2DgZx6DAqG2uk+w2tzK6oF/duWOMduT+H60pQSS s7tFRlaTXc0M0c0isrKGVgynoQc5paZQYoopKQC0UUUAFLk+tJRQA4ORUD2VnI257eIn/dxUtFUp NbMDjNbtrTS/FVnrupa4bZZP3SxKcLnHvnP5V0U1tpIu47q4n82dF+UNOz8H0QHH6Vyen6b4fvtF 0yXXAZrmd8xiYYIfpjHp9a7uG3t7ZAsUSRgdNoxVVJU37q1a0/rczi5tKSVrlN9UjiaKK10+7lEh 2qyxbUX/AHj2H4Uo/ticHd9ktVOR8uZGHuCeP0rQ3Ck3H0qea2yt/XmVyt7s5268JLfarBf3eozS yRcEGKMbh6A4yo+mM9617LSrPT43SCM7WYufMcvyfqTj6CrWT61zPjSx1y/0lI9DuWgnD5cqQGI+ ppxXO+VvRkOEYJtK5qaTHf2Vvcf2ncQyKJGaIxjARPQ8CpdO1vT9Xjkk066iuFjba5Rs4PpUVlaX D6FFaak4lnaHZOw7kjBql4Z8J2HhaKdLIyN5xBYuewGAKIwhCDV9VsU5Sck0tCj411vxBpIs/wCx LJbjzHxKTGW49OOmfWunt3kkt4nlTZIygsuehx0qUdKD0pyknFK2wKLUm7hRRUVzMLa2lnKlhGpb A6nFQlfQt6EtFcz4R8XDxSt0fsUlqYCPvnO4Hp/+qumqpwcHyyJjJSV0FFFFQUFFFFABQOlFFABQ KKO9AAaQqGUhgCD1BpaQUACqqKFUBQOgAxUdyzrbSGIjzNp2Z9e1ZniHxJp/hmyS6vy+122qEXJJ q9Y3UWoWkN7C26KVA8f0NWotLnexHMm+VblTSYtVlgcX87R5Y7dqrux9eR6dq4yfwRfXut3kH9tX I0/YxNuzFiST27da9KWqF4osr+C9JJSUmNgBzyOK0jVlze7pclx5UtdhNH0+LS9JtrSGRpEjQAM3 U1ermNS1y6sZooreL92HwQw5xnge3UfnW899bx2Ru5JVSEJvLMcYGM1EoTspPqUpxu49izRVHStY sNatTc6fcrPEG2kr2NXqhpp2ZSaaugHSiiikMKKKKACiikJOeKAM3SbS1l02BJLeMvasYxleVKnj 9MGtKRhGrsRwoJqlYw/Y9TvIFGI5gJ0yckno5P8A47+VXZjgcdTwKppc1+5MW3HU5jwt40h8T3l3 bx2csBgOQX/iGcfgeOldRUFvZW1puMEEcZc5YqoG4+9T06ji5e6rIUFJL3nqFFFFQWB6UUYoHSgB KWkNLQADpQQCMHpRRQBFBbQWwYQQpGGOTsXGTUtFFNu+4JWCiiikAUUUUAFHeig0AFFFBoAKKTNK OO1AFHVNHsdZt1gv7dZo1O4A9jVuC3jtoEhhQJFGoVVHQAVJk0lVzO1uguVXuZWrawdLmgRYhJ5n Uk4HUcfXmnatLdXHh+aUWuQgWURglnbkHHHStF40kxvRWwcjIzirMWCSp6MMVfPFJWWqI5ZNu70M lLWzuvKYwRtHLGGHHQj/APX+lS31hbahYS2VwgMMqFGUelUs3VvarHbojSWl2EdWOB5RODz7K2fw rG8X+Hta1fWdOn03UmtoYTl0Dlecg7sD73GRj3ogrzs5W6ilL3OZK9za0Dw9ZeHLOS2sVfbI+92c 5JPStakUEKATkgcn1paiUnJ3ZokkrISloNFSMKKKKACkpaKAKF8s8GqWl4j7ogDE8IAy5YgKck8A c/5FQWP9rNqc5vFxAPuDjA+laN/H5tlKvIOM8danik8+COXgb1BIHY9x+daxnaFrf1/VzLlvLcbR RRWRqFFFFABRiiigAoozSCgBaKKKACiiigAooooAKKKKACiiigBMUtAooAKKKKACijNHNABS+ake C7qvPc4pKpajpNrq0SRXQYojh12tjkUpXtpuNWvqRXd3aw61NAZAxubfcY0OWyODx6kH9KztN1y+ 1G+gJsXigZCD5iEHIOCfTqDWpqdjDF9i1GMFGs3IYLwCjYBLeuBVuP5ZZo+2RIv0P/1wfzqk+VqT 7NGfLdcqezuSUUZo5pFhSdKXFGKADNHNFFACUuaKTigCTqv1qho1zHPaTRxn/j3maPB6gZ7/AK1b knit4GlmkWONerMcAVBAVTVGCkbLmPcMfxMO/wCVOLV3EhtKSLLfepKrW5vjPcfakhWIPiEoSSV9 6s4qYu6uOMuZXCjNFFMoOaMUUUAFHeig0AFFFFABRRRQAUUUUAFFFFABRRRQAlLQaKACjFRi4hMx hEqGUDJTcMj8KcZFBxnJ9ByadmK6HUUzc56Jj3Y0bGP3nP0HFFguOLKvUgVnavd3VvYmSyjZpM4J 25wPpWgqKvQAU6qjJRd7XFJOStexlhNV1PQJk3RJPJGQqlMbvrmo7LUJbm10e7iQTxzZhnkUjC/K fm9/nUD/AIFW5E2GU1x2reJdK8LatNo06vG02biARR5VeM446cjP40NOo3yr5EKPJJNt7W+7W/5l /wAW+JF8LaV9tNq9wS4QIpx+ZrQ0fUl1fSba/SNo1nQNsbqKzbDxHpHiWKFY1Z0kJOyaPuK31RUU KihVHAAHAqppRik1qOLbk3fQWiijNZGgUUc0YoAKQgHsaWigDB8WjU30Yx6Xax3MruAySDI2/Ssr Q4PFFreyXetyw/Z0kXyY4wMhTxt9hXZg4Oag1O2e802e3jlMTuuA4GSK0jNRWy9TKVNN83X+v6+8 uSLyw/KoqSzlM1hbyH72za3sRxSkYJFRJWdjVO6uFFFFIAooooAKKKKAAUUd6KACiiigAooooAKK KKACiiigAoFFHegDkrbwPFb+NZ/EX2x2MpJ8r6gDBPp7V1gAUYAAHtS5oq51JT+ImMIx2CiijFQU GaztV1zTtFWJtQuo7cSttTeeprRrE8QeFtO8SrCt8r/uSdpU44PUVcOXm9/YmfNb3dzbhkWSMOjB lYZBHcVma3pVjealp15dWySEboCzDkZHHP1/nVKSz1O31OCKzkZLJFVV5BCgY6jv3/StDVtPmm0m U28xNzEyyo0pJA2sCeB7A1okqbUlIzb50+ZbDLLRtPtZS8NsiSRMQu3jg8/5+ladVkuYvtEDbgv2 uP5Ae5Azj8s1ZrFuT+I1UUtgxRRRSGFFFFABRRRQAU8HIpnNKpxxQBTsXeG7uLFlAUEyx+pB6/rm rrdapXg8nUbO5ztUkxP15B5H9avOOD7GrktExRVlYZRRRUDCiiigAooooAKKKKACiiigAooooAKK KKACiiigApMUtFACGloo7UAFFGaSgBaKMUUAJUoYhWwAcqeDUdOXpg0AY1pHFLZxmWNWkspiyEjk A9x6cHFaN9dxWFnPdzE+VChkbAzwBms+OaKDxFNYs2GuIS6r6gen51ooBLbBJFDDBRlPSm9JJvqT G/JbqjG8L+K7TxVb3EtrDNC1vIEdJRg8jIP5Gt6qtjptlpkTRWVrFbox3FY1xk+tWqqbi5e7sEFJ L3twoooqCgooox7UAFHeiigCvqkfmadKR1Qbxjrxz/LIq0hZ4I3ZSCyAkGlGCMHkGo7E505Iz96B jEc9cA4B/EYP41a1h6ALRSt96kqACiiigAooozQAUCik70ALRRSd6AFoooFABRRRQAUUUUAFJS0U AFJ3pe9FABQKRnVBlmCj1JxR3pgLRSF1U4LAfU03zF7ZP0FFmFx9KvWo97Hoh/E4rL1qLUpYofsR Iw/zqjYJH1/OqhDmdm7Eylyq6VyLxTdf2ZHaahBaGW4WUJvA6Kex9Aa07OYzJvZDGZUWXYf4c9RW VpyatqFhcxarZMHGVRfNAD+hwKi+2aqy6TNBYklXMNygcHAxjk+2KiUo8t108gjFqbXc6OiqE081 qZJr66tba1+URn+IH3J4Pao5W00XCTS3LTSquEQOTnPoB1o16IblFbstT39tbNGsko3SNtUKCcn8 KjsNVtNSuLmGAuXt22yblIwabaXtxcoxt9KniG4qplwgPv61hXF34itPEH2ZbNDbzkkvCgIUepbj n2pONTmSsROtGPRs61mSJdzsqD1JxXOaitpqdz58OtTRKF2bYdxUkd+PrW/BBZtGsixiYkffk5J+ oqwjCJAkaqiDoqrgCiUIy0kXGU1qtPxIqKKKYxy1HbfJf3MPQTIJV92Hyt+mz86KKunu15AwjJaF CTkj5SfUjinUUVnH4UTD4UGaOaKKZQYo7UUUAFBoooAKDRRQAUd6KKACiiigAooooAKO9FFACHjm uU0fxvDq/ii70VbKWMwbsSkj5sdcjtRRXRRhGUZN9DGpJqSS/rVEvjTwvc+KLGCC2vzatG+45zhu PbuK3LKz+yWEFvJI0zRIFLuc7sDrRRWbqScVHoi1CPM5FoIAPlUflTtpoorO5Yu0UvAIHGT0HrRR QgCSaK1KtPLHECeN7AZ+nrXOWNhdz6lcwtqk8UKy+emIjGWDfXH8iKKK6FRiqaqdfwMZpOcW/wCt C5qfhix1O2Ec1zdmVW3CZXwQfp0/HGanu1ttJ0MxwRBEiUBMDJz2P1ooqKcvfQ5RUIuUUWLLUY9S tEuYy21uzdRU5f2ooqZpKTSLg24psxLpNTi1mJ7X5bNyPMAIxnPPH+e1bNFFOcuZIUY2b1P/2Q==