20180522 17410400 1.0 FALSE gis_vector.sde.hydrants_test 002 Server=srv-ch-arcgispg; Service=sde:postgresql:srv-ch-arcgispg; Database=gis_vector; User=sde ArcSDE Connection 2558503.315700 2567425.899100 7621920.115300 7631626.664700 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.8.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]]</WKT><XOrigin>-28216700</XOrigin><YOrigin>-23260100</YOrigin><XYScale>10000</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>2036</WKID><LatestWKID>2953</LatestWKID></ProjectedCoordinateSystem> CopyFeatures QueryTable4 "C:\GIS\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points_ReOrdered" # 0 0 0 CalculateField Engineering\Engineering_Combined_Points Link_to_As_Built " " VB # CalculateField Engineering\Engineering_Combined_Points Link_to_Ti_ins " " VB # CalculateField Engineering\Engineering_Combined_Points Comments " " VB # CalculateField Engineering\Engineering_Combined_Points Related_Civic_Number " " VB # JoinField Engineering\Engineering_Combined_Points OBJECTID point_temps TARGET_FID Civic_Address CalculateField Engineering\Engineering_Combined_Points Closest_Civic_Address [Civic_Address] VB # CalculateField Engineering\Engineering_Combined_Points Closest_Civic_Address [Civic_Address] VB # CalculateField Engineering\Engineering_Combined_Points Related_PID " " VB # CalculateField "Engineering\Engineering Divided\Clean Water\Clean Water - Valves" GeoLocation 3 VB # CalculateField "Engineering\Engineering Divided\Clean Water\Clean Water - Valves" GeoLocation 3 VB # CalculateField "Engineering\Engineering Divided\Clean Water\Clean Water - Valves" GeoLocation 3 VB # CalculateField Engineering\Engineering_Combined_Points GeoLocation 2 VB # CalculateField Engineering\Engineering_Combined_Points GeoLocation 0 VB # CalculateField "Engineering\Engineering Divided\Clean Water\Fire Hydrants\Fire Hydrants - Locations" Link_to_Ti_ins "X:\Plans\Tie-Ins\Tie-Ins - Hydrant Valves (HVL)\"&[Entity_ID]&".pdf" VB # CalculateField "Engineering\Engineering Divided\Clean Water\Clean Water - Lateral\Clean Water - Water Meters" Entity_ID [OBJECTID] VB # JoinField "Engineering\Engineering Divided\Clean Water\Clean Water - Lateral\Clean Water - Water Meters" Entity_ID "Engineering\Engineering Divided\Clean Water\Clean Water - Lateral\Clean Water - Water Meters" Entity_ID Related_PID JoinField "Engineering\Engineering Divided\Clean Water\Clean Water - Lateral\Clean Water - Water Meters" Entity_ID "Engineering\Engineering Divided\Clean Water\Clean Water - Lateral\Clean Water - Water Meters Updated" Entity_ID PID CalculateField "Engineering\Engineering Divided\Clean Water\Clean Water - Lateral\Clean Water - Water Meters" Related_PID [PID] VB # CalculateField "Engineering\Engineering Divided\Clean Water\Clean Water - Lateral\Clean Water - Water Meters" PID2 [PID] VB # CalculateField "Engineering\Engineering Divided\Clean Water\Clean Water - Lateral\Clean Water - Water Meters" PID3 [PID] VB # CalculateField "Engineering\Engineering Divided\Clean Water\Clean Water - Lateral\Clean Water - Water Meters" Duplicate isDuplicate(!Related_PID!) PYTHON_9.3 "uniqueList = []\ndef isDuplicate(inValue):\n if inValue in uniqueList:\n return 1\n else:\n uniqueList.append(inValue)\n return 0\n" CalculateField "Engineering\Engineering Divided\Clean Water\Clean Water - Lateral\Clean Water - Water Meters" Entity_ID [Related_PID]&".01LVL" VB # CalculateField "Engineering\Engineering Divided\Clean Water\Clean Water - Lateral\Clean Water - Water Meters" Entity_ID "..." VB # CalculateField "Engineering\Engineering Divided\Clean Water\Clean Water - Lateral\Clean Water - Water Meters" Entity_ID [Related_PID]&".02LVL" VB # CalculateField "Engineering\Engineering Divided\Clean Water\Clean Water - Lateral\Clean Water - Water Meters" Entity_ID "..." VB # CalculateField "Engineering\Engineering Divided\Clean Water\Clean Water - Lateral\Clean Water - Water Meters" Entity_ID [Related_PID] VB # CalculateField "Engineering\Engineering Divided\Clean Water\Clean Water - Lateral\Clean Water - Water Meters" Related_PID "20811121" VB # CalculateField "Engineering\Engineering Divided\Clean Water\Clean Water - Lateral\Clean Water - Water Meters" Entity_ID "20811121" VB # CalculateField "Engineering\Engineering Divided\Clean Water\Clean Water - Lateral\Clean Water - Water Meters" Duplicate 999 VB # CalculateField "Engineering\Engineering Divided\Clean Water\Clean Water - Lateral\Clean Water - Water Meters" Duplicate isDuplicate(!Duplicate!) PYTHON_9.3 "uniqueList = []\ndef isDuplicate(inValue):\n if inValue in uniqueList:\n return 1\n else:\n uniqueList.append(inValue)\n return 0\n" CalculateField "Engineering\Engineering Divided\Clean Water\Clean Water - Lateral\Clean Water - Water Meters" Duplicate isDuplicate(!Entity_ID!) PYTHON_9.3 "uniqueList = []\ndef isDuplicate(inValue):\n if inValue in uniqueList:\n return 1\n else:\n uniqueList.append(inValue)\n return 0\n" CalculateField "Engineering\Engineering Divided\Clean Water\Clean Water - Lateral\Clean Water - Water Meters" Duplicate isDuplicate(!Entity_ID!) PYTHON_9.3 "uniqueList = []\ndef isDuplicate(inValue):\n if inValue in uniqueList:\n return 1\n else:\n uniqueList.append(inValue)\n return 0\n" CalculateField "Engineering\Engineering Divided\Clean Water\Clean Water - Lateral\Clean Water - Water Meters" Link_to_Ti_ins [Entity_ID] VB # CalculateField "Engineering\Engineering Divided\Clean Water\Clean Water - Lateral\Clean Water - Water Meters" Link_to_Ti_ins "j"&[Entity_ID] VB # CalculateField "Engineering\Engineering Divided\Clean Water\Clean Water - Lateral\Clean Water - Water Meters" Link_to_Ti_ins "X:\Plans\Tie-Ins\Tie-Ins - Laterals Valves (PID.Valve#.LVL)\"&[Entity_ID] VB # CalculateField "Engineering\Engineering Divided\Clean Water\Clean Water - Lateral\Clean Water - Water Meters" 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_Points" Asset_Group SHORT # # # "Asset Group" NULLABLE NON_REQUIRED # AddField "X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points" Jurisdiction SHORT # # # Jurisdiction NULLABLE NON_REQUIRED # AddField "X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points" "Asset is Tangible Capital Asset (TCA)" SHORT # # # "Asset is Tangible Capital Asset (TCA)" NULLABLE NON_REQUIRED # AddField "X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points" "Expected Life (Years)" SHORT # # # "Expected Life (Years)" NULLABLE NON_REQUIRED # DeleteField "X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points" Asset_is_Tangible_Capital_Asset__TCA_;Expected_Life__Years_ AddField "X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points" "Tangible Capital Asset" SHORT # # # "Tangible Capital Asset" NULLABLE NON_REQUIRED # AddField "X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points" "Expected Life Years" SHORT # # # "Expected Life Years" NULLABLE NON_REQUIRED # AddField "X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points" "End of Life Date" SHORT # # # "End of Life Date" NULLABLE NON_REQUIRED # AddField "X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points" "Remaining Life Years" SHORT # # # "Remaining Life Years" NULLABLE NON_REQUIRED # AddField "X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points" "Remaining Life Percent" FLOAT # # # "Remaining Life Percent" NULLABLE NON_REQUIRED # AddField "X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points" "Condition Rating" SHORT # # # "Condition Rating (1 to 5)" NULLABLE NON_REQUIRED # AddField "X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points" "Cost per Unit" FLOAT # # # "Cost per Unit" NULLABLE NON_REQUIRED # AddField "X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points" "Asset Replacement Value" FLOAT # # # "Asset Replacement Value" NULLABLE NON_REQUIRED # AddField "X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points" "Emergency Asset Replacement Value" FLOAT # # # "Emergency Asset Replacement Value" NULLABLE NON_REQUIRED # AddField "X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points" "Loss in Value" FLOAT # # # "Loss in Value" NULLABLE NON_REQUIRED # AddField "X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points" "Remaining Value" FLOAT # # # "Remaining Value" NULLABLE NON_REQUIRED # AddField "X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points" "Infrastructure Deficit (Backlog)" FLOAT # # # "Infrastructure Deficit (Backlog)" NULLABLE NON_REQUIRED # FeatureClassToFeatureClass "X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points" "Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets" City_Asset_Clean_Water_Fire_Hydrant_Location "Entity_Type = 1 AND Entity = 104" "Entity_Type "Entity Type" true true false 2 Short 0 0 ,First,#,X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points,Entity_Type,-1,-1;Entity "Entity" true true false 2 Short 0 0 ,First,#,X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points,Entity,-1,-1;Entity_ID "Entity_ID" true true false 50 Text 0 0 ,First,#,X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points,Entity_ID,-1,-1;Related_PID "Related_PID" true true false 16 Text 0 0 ,First,#,X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points,Related_PID,-1,-1;Closest_Civic_Address "/\Closest_Civic_Address/\" true true false 50 Text 0 0 ,First,#,X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points,Closest_Civic_Address,-1,-1;Related_Civic_Number "Related_Civic_Number" true true false 50 Text 0 0 ,First,#,X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points,Related_Civic_Number,-1,-1;Related_Street_Name "Related Street Name" true true false 2 Short 0 0 ,First,#,X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points,Related_Street_Name,-1,-1;Related_Street_Section "Related_Street_Section" true true false 4 Float 0 0 ,First,#,X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points,Related_Street_Section,-1,-1;Installation_Year "Installation Year" true true false 2 Short 0 0 ,First,#,X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points,Installation_Year,-1,-1;Diameter "Diameter" true true false 2 Short 0 0 ,First,#,X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points,Diameter,-1,-1;Grid_Reference "Grid Reference" true true false 6 Text 0 0 ,First,#,X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points,Grid_Reference,-1,-1;Type "Type" true true false 65 Text 0 0 ,First,#,X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points,Type,-1,-1;Last_Maintenance_Inspection_Dat "Last Maintenance Inspection Date" true true false 2 Short 0 0 ,First,#,X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points,Last_Maintenance_Inspection_Date,-1,-1;Comments "Comments" true true false 50 Text 0 0 ,First,#,X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points,Comments,-1,-1;Link_to_As_Built "Link_to_As_Built" true true false 250 Text 0 0 ,First,#,X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points,Link_to_As_Built,-1,-1;Link_to_Ti_ins "Link_to_Ti_ins" true true false 250 Text 0 0 ,First,#,X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points,Link_to_Ti_ins,-1,-1;GeoLocation "GeoLocation" true true false 2 Short 0 0 ,First,#,X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points,GeoLocation,-1,-1;Serial_Number "Serial Number" true true false 4 Long 0 0 ,First,#,X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points,Serial_Number,-1,-1;Duplicate "Duplicate" true true false 2 Short 0 0 ,First,#,X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points,Duplicate,-1,-1;Asset_Group "Asset Group" true true false 2 Short 0 0 ,First,#,X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points,Asset_Group,-1,-1;Jurisdiction "Jurisdiction" true true false 2 Short 0 0 ,First,#,X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points,Jurisdiction,-1,-1;Tangible_Capital_Asset "Tangible Capital Asset" true true false 2 Short 0 0 ,First,#,X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points,Tangible_Capital_Asset,-1,-1;Expected_Life_Years "Expected Life Years" true true false 2 Short 0 0 ,First,#,X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points,Expected_Life_Years,-1,-1;End_of_Life_Date "End of Life Date" true true false 2 Short 0 0 ,First,#,X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points,End_of_Life_Date,-1,-1;Remaining_Life_Years "Remaining Life Years" true true false 2 Short 0 0 ,First,#,X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points,Remaining_Life_Years,-1,-1;Remaining_Life_Percent "Remaining Life Percent" true true false 4 Float 0 0 ,First,#,X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points,Remaining_Life_Percent,-1,-1;Condition_Rating "Condition Rating (1 to 5)" true true false 2 Short 0 0 ,First,#,X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points,Condition_Rating,-1,-1;Cost_per_Unit "Cost per Unit" true true false 4 Float 0 0 ,First,#,X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points,Cost_per_Unit,-1,-1;Asset_Replacement_Value "Asset Replacement Value" true true false 4 Float 0 0 ,First,#,X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points,Asset_Replacement_Value,-1,-1;Emergency_Asset_Replacement_Val "Emergency Asset Replacement Value" true true false 4 Float 0 0 ,First,#,X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points,Emergency_Asset_Replacement_Value,-1,-1;Loss_in_Value "Loss in Value" true true false 4 Float 0 0 ,First,#,X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points,Loss_in_Value,-1,-1;Remaining_Value "Remaining Value" true true false 4 Float 0 0 ,First,#,X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points,Remaining_Value,-1,-1;Infrastructure_Deficit__Backlog "Infrastructure Deficit (Backlog)" true true false 4 Float 0 0 ,First,#,X:\Master Geodatabase.gdb\Engineering\Engineering_Combined_Points,Infrastructure_Deficit__Backlog_,-1,-1" # CalculateField "Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Location" 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_Location" 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_Location" 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_Location" -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_Location" -1 RemoveDomainFromField "Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Location" 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_Location" Entity_Type Asset_Type "Asset Type" SHORT 3 NULLABLE false AlterField "Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Location" Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Location.Entity Asset_Subtype "Asset Subtype" 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_Location" 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_Location" 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_Location" 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_Location" "Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets" City_Asset_Clean_Water_Fire_Hydrant_Location2 # "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_Location,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_Location,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_Location,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_Location,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_Location,Asset_ID,-1,-1;Serial_Number "Serial Number" true true false 4 Long 0 10 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Location,Serial_Number,-1,-1;Related_PID "Related_PID" true true false 16 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_Location,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_Location,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_Location,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_Location,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_Location,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_Location,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_Location,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_Location,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_Location,Diameter,-1,-1;Type "Type" true true false 65 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_Location,Type,-1,-1;Comments "Comments" 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_Location,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_Location,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_Location,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_Location,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_Location,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_Location,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_Location,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_Location,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_Location,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_Location,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_Location,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_Location,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_Location,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_Location,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_Location,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_Location,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_Location,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_Location,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_Location,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_Location,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_Location,Infrastructure_Deficit__Backlog,-1,-1;Duplicate "Duplicate" 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_Location,Duplicate,-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_Location" 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_Location" "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets" Fire_Hydrant_Location # "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_Location,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_Location,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_Location,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_Location,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_Location,Asset_ID,-1,-1;Serial_Number "Serial Number" true true false 4 Long 0 10 ,First,#,Database Connections\Master_Enterprise_Geodatabase.sde\Master_Enterprise_Geodatabase.DBO.City_Assets\Master_Enterprise_Geodatabase.DBO.City_Asset_Clean_Water_Fire_Hydrant_Location,Serial_Number,-1,-1;Related_PID "Related_PID" true true false 16 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_Location,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_Location,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_Location,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_Location,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_Location,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_Location,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_Location,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_Location,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_Location,Diameter,-1,-1;Type "Type" true true false 65 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_Location,Type,-1,-1;Comments "Comments" 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_Location,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_Location,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_Location,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_Location,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_Location,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_Location,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_Location,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_Location,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_Location,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_Location,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_Location,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_Location,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_Location,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_Location,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_Location,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_Location,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_Location,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_Location,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_Location,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_Location,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_Location,Infrastructure_Deficit__Backlog,-1,-1;Duplicate "Duplicate" 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_Location,Duplicate,-1,-1" # EnableEditorTracking "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Location" 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_Location" Asset_Type false AddSubtype "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Location" 0 "What Kind of Entity Am I?" AddSubtype "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Location" 1 "Water Distribution System" AddSubtype "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Location" 2 "Sanitary Sewer System" AddSubtype "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Location" 3 "Storm Sewer System" AddSubtype "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Location" 4 "Transportation System" SetDefaultSubtype "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Location" 1 Merge 'Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Location';'Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Valve';'Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_DBH';'Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Meter';'Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Shut_Off_Valve';'Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Valve' "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water_Points" "GlobalID "GlobalID" false false false 38 GlobalID 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Location,GlobalID,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Valve,GlobalID,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_DBH,GlobalID,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Meter,GlobalID,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Shut_Off_Valve,GlobalID,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Valve,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_Location,Asset_Group,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Valve,Asset_Group,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_DBH,Asset_Group,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Meter,Asset_Group,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Shut_Off_Valve,Asset_Group,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Valve,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_Location,Asset_Type,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Valve,Asset_Type,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_DBH,Asset_Type,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Meter,Asset_Type,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Shut_Off_Valve,Asset_Type,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Valve,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_Location,Asset_Subtype,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Valve,Asset_Subtype,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_DBH,Asset_Subtype,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Meter,Asset_Subtype,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Shut_Off_Valve,Asset_Subtype,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Valve,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_Location,Asset_ID,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Valve,Asset_ID,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_DBH,Asset_ID,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Meter,Asset_ID,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Shut_Off_Valve,Asset_ID,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Valve,Asset_ID,-1,-1;Serial_Number "Serial Number" true true false 4 Long 0 10 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Location,Serial_Number,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Valve,Serial_Number,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_DBH,Serial_Number,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Meter,Serial_Number,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Shut_Off_Valve,Serial_Number,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Valve,Serial_Number,-1,-1;Related_PID "Related_PID" true true false 16 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Location,Related_PID,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Valve,Related_PID,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_DBH,Related_PID,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Meter,Related_PID,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Shut_Off_Valve,Related_PID,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Valve,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_Location,Closest_Civic_Address,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Valve,Closest_Civic_Address,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_DBH,Closest_Civic_Address,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Meter,Closest_Civic_Address,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Shut_Off_Valve,Closest_Civic_Address,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Valve,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_Location,Related_Civic_Number,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Valve,Related_Civic_Number,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_DBH,Related_Civic_Number,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Meter,Related_Civic_Number,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Shut_Off_Valve,Related_Civic_Number,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Valve,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_Location,Related_Street_Name,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Valve,Related_Street_Name,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_DBH,Related_Street_Name,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Meter,Related_Street_Name,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Shut_Off_Valve,Related_Street_Name,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Valve,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_Location,Related_Street_Section,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Valve,Related_Street_Section,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_DBH,Related_Street_Section,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Meter,Related_Street_Section,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Shut_Off_Valve,Related_Street_Section,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Valve,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_Location,GeoLocation,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Valve,GeoLocation,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_DBH,GeoLocation,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Meter,GeoLocation,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Shut_Off_Valve,GeoLocation,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Valve,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_Location,Grid_Reference,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Valve,Grid_Reference,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_DBH,Grid_Reference,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Meter,Grid_Reference,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Shut_Off_Valve,Grid_Reference,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Valve,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_Location,Installation_Year,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Valve,Installation_Year,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_DBH,Installation_Year,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Meter,Installation_Year,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Shut_Off_Valve,Installation_Year,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Valve,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_Location,Diameter,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Valve,Diameter,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_DBH,Diameter,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Meter,Diameter,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Shut_Off_Valve,Diameter,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Valve,Diameter,-1,-1;Type "Type" true true false 65 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Location,Type,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Valve,Type,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_DBH,Type,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Meter,Type,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Shut_Off_Valve,Type,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Valve,Type,-1,-1;Comments "Comments" true true false 50 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Location,Comments,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Valve,Comments,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_DBH,Comments,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Meter,Comments,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Shut_Off_Valve,Comments,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Valve,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_Location,Last_Maintenance_Inspection_Dat,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Valve,Last_Maintenance_Inspection_Dat,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_DBH,Last_Maintenance_Inspection_Dat,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Meter,Last_Maintenance_Inspection_Dat,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Shut_Off_Valve,Last_Maintenance_Inspection_Dat,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Valve,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_Location,Link_to_As_Built,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Valve,Link_to_As_Built,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_DBH,Link_to_As_Built,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Meter,Link_to_As_Built,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Shut_Off_Valve,Link_to_As_Built,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Valve,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_Location,Link_to_Ti_ins,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Valve,Link_to_Ti_ins,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_DBH,Link_to_Ti_ins,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Meter,Link_to_Ti_ins,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Shut_Off_Valve,Link_to_Ti_ins,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Valve,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_Location,Feature_Creator,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Valve,Feature_Creator,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_DBH,Feature_Creator,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Meter,Feature_Creator,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Shut_Off_Valve,Feature_Creator,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Valve,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_Location,Creation_Date,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Valve,Creation_Date,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_DBH,Creation_Date,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Meter,Creation_Date,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Shut_Off_Valve,Creation_Date,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Valve,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_Location,Last_Editor,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Valve,Last_Editor,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_DBH,Last_Editor,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Meter,Last_Editor,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Shut_Off_Valve,Last_Editor,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Valve,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_Location,Last_Edit_Date,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Valve,Last_Edit_Date,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_DBH,Last_Edit_Date,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Meter,Last_Edit_Date,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Shut_Off_Valve,Last_Edit_Date,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Valve,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_Location,Jurisdiction,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Valve,Jurisdiction,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_DBH,Jurisdiction,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Meter,Jurisdiction,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Shut_Off_Valve,Jurisdiction,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Valve,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_Location,Tangible_Capital_Asset,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Valve,Tangible_Capital_Asset,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_DBH,Tangible_Capital_Asset,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Meter,Tangible_Capital_Asset,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Shut_Off_Valve,Tangible_Capital_Asset,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Valve,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_Location,Expected_Life_Years,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Valve,Expected_Life_Years,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_DBH,Expected_Life_Years,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Meter,Expected_Life_Years,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Shut_Off_Valve,Expected_Life_Years,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Valve,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_Location,End_of_Life_Date,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Valve,End_of_Life_Date,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_DBH,End_of_Life_Date,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Meter,End_of_Life_Date,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Shut_Off_Valve,End_of_Life_Date,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Valve,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_Location,Remaining_Life_Years,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Valve,Remaining_Life_Years,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_DBH,Remaining_Life_Years,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Meter,Remaining_Life_Years,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Shut_Off_Valve,Remaining_Life_Years,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Valve,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_Location,Remaining_Life_Percent,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Valve,Remaining_Life_Percent,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_DBH,Remaining_Life_Percent,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Meter,Remaining_Life_Percent,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Shut_Off_Valve,Remaining_Life_Percent,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Valve,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_Location,Condition_Rating,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Valve,Condition_Rating,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_DBH,Condition_Rating,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Meter,Condition_Rating,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Shut_Off_Valve,Condition_Rating,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Valve,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_Location,Cost_per_Unit,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Valve,Cost_per_Unit,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_DBH,Cost_per_Unit,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Meter,Cost_per_Unit,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Shut_Off_Valve,Cost_per_Unit,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Valve,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_Location,Asset_Replacement_Value,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Valve,Asset_Replacement_Value,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_DBH,Asset_Replacement_Value,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Meter,Asset_Replacement_Value,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Shut_Off_Valve,Asset_Replacement_Value,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Valve,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_Location,Emergency_Asset_Replacement_Val,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Valve,Emergency_Asset_Replacement_Val,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_DBH,Emergency_Asset_Replacement_Val,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Meter,Emergency_Asset_Replacement_Val,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Shut_Off_Valve,Emergency_Asset_Replacement_Val,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Valve,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_Location,Loss_in_Value,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Valve,Loss_in_Value,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_DBH,Loss_in_Value,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Meter,Loss_in_Value,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Shut_Off_Valve,Loss_in_Value,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Valve,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_Location,Remaining_Value,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Valve,Remaining_Value,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_DBH,Remaining_Value,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Meter,Remaining_Value,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Shut_Off_Valve,Remaining_Value,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Valve,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_Location,Infrastructure_Deficit__Backlog,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Valve,Infrastructure_Deficit__Backlog,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_DBH,Infrastructure_Deficit__Backlog,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Meter,Infrastructure_Deficit__Backlog,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Shut_Off_Valve,Infrastructure_Deficit__Backlog,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Valve,Infrastructure_Deficit__Backlog,-1,-1;Duplicate "Duplicate" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Location,Duplicate,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Fire_Hydrant_Valve,Duplicate,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_DBH,Duplicate,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Meter,Duplicate,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Shut_Off_Valve,Duplicate,-1,-1,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Valve,Duplicate,-1,-1;Enabled "Enabled" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Meter,Enabled,-1,-1;AncillaryRole "AncillaryRole" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.City_Assets\MasterEGDB.DBO.Water_Lateral_Meter,AncillaryRole,-1,-1" SetSubtypeField "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water_Points" Asset_Subtype false AddSubtype "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water_Points" 103 "Water - Main Valve" AddSubtype "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water_Points" 104 "Water - Fire Hydrant - Location" AddSubtype "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water_Points" 106 "Water - Fire Hydrant - Valve" AddSubtype "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water_Points" 107 "Water - Lateral - Shut Off Valve" AddSubtype "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water_Points" 108 "Water - Lateral - Meter" AddSubtype "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water_Points" 110 "Water - Lateral - DBH" EnableEditorTracking "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points" Feature_Creator Creation_Date Last_Editor Last_Edit_Date # DATABASE_TIME AddField "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points" Plowing_Status SHORT # # # "Plowing Status" NULLABLE NON_REQUIRED # AssignDomainToField "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.0.0'><FeatureDataset>MasterEGDB.DBO.Water</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68366b58556e4d51376f6d4231702b637648544d626769497445766147336f6b61614e7470746f352b6144343d2a00;SERVER=SRV-CH-SQLARCGIS;INSTANCE=sde:sqlserver:SRV-CH-SQLARCGIS;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SRV-CH-SQLARCGIS;DATABASE=MasterEGDB;USER=arcgissql_svc;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>MasterEGDB.DBO.Water_Points</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" Plowing_Status COB_FireHydrantPlowing # AssignDefaultToField "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.0.0'><FeatureDataset>MasterEGDB.DBO.Water</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68366b58556e4d51376f6d4231702b637648544d626769497445766147336f6b61614e7470746f352b6144343d2a00;SERVER=SRV-CH-SQLARCGIS;INSTANCE=sde:sqlserver:SRV-CH-SQLARCGIS;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SRV-CH-SQLARCGIS;DATABASE=MasterEGDB;USER=arcgissql_svc;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>MasterEGDB.DBO.Water_Points</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" Plowing_Status 0 # false AssignDomainToField "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.0.0'><FeatureDataset>MasterEGDB.DBO.Water</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68556d71435a59395847717858634737582b6a4b704c6e4178464b355847416332467651654a7057766c62593d2a00;SERVER=SRV-CH-SQLARCGIS;INSTANCE=sde:sqlserver:SRV-CH-SQLARCGIS;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SRV-CH-SQLARCGIS;DATABASE=MasterEGDB;USER=arcgissql_svc;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>MasterEGDB.DBO.Water_Points</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" Plowing_Status COB_FireHydrantPlowing # AssignDefaultToField "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.0.0'><FeatureDataset>MasterEGDB.DBO.Water</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68556d71435a59395847717858634737582b6a4b704c6e4178464b355847416332467651654a7057766c62593d2a00;SERVER=SRV-CH-SQLARCGIS;INSTANCE=sde:sqlserver:SRV-CH-SQLARCGIS;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SRV-CH-SQLARCGIS;DATABASE=MasterEGDB;USER=arcgissql_svc;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>MasterEGDB.DBO.Water_Points</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" Plowing_Status 0 # false DeleteField "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points" Plowing_Status AddField "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points" Plowing_Status SHORT # # # "Plowing Status" NULLABLE NON_REQUIRED COB_FireHydrantPlowing CalculateField "Public Works\Snow Plowing\Fire Hydrants" Plowing_Status 0 "Python 3" # AssignDefaultToField "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.1.0'><FeatureDataset>MasterEGDB.DBO.Water</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6868656d4767695244515a68614d4e48786839795a5a3164676e6a364a784b707a694a63374336536e52454d3d2a00;SERVER=SRV-CH-SQLARCGIS;INSTANCE=sde:sqlserver:SRV-CH-SQLARCGIS;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SRV-CH-SQLARCGIS;DATABASE=MasterEGDB;USER=arcgissql_svc;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>MasterEGDB.DBO.Water_Points</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" Plowing_Status 0 # false AddField "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points" E_Coder_Serial LONG 12 # # "E-Coder Serial" NULLABLE NON_REQUIRED # AlterField "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.1.0'><FeatureDataset>MasterEGDB.DBO.Water</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68393547796e41434a704a58335551614267636244645734344b56366566387450435a2b33645a50584b616f3d2a00;SERVER=SRV-CH-SQLARCGIS;INSTANCE=sde:sqlserver:SRV-CH-SQLARCGIS;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SRV-CH-SQLARCGIS;DATABASE=MasterEGDB;USER=arcgissql_svc;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>MasterEGDB.DBO.Water_Points</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" Asset_Subtype # "Asset Subtype" "Short (small integer)" 2 NULLABLE false AlterField "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.1.0'><FeatureDataset>MasterEGDB.DBO.Water</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68393547796e41434a704a58335551614267636244645734344b56366566387450435a2b33645a50584b616f3d2a00;SERVER=SRV-CH-SQLARCGIS;INSTANCE=sde:sqlserver:SRV-CH-SQLARCGIS;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SRV-CH-SQLARCGIS;DATABASE=MasterEGDB;USER=arcgissql_svc;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>MasterEGDB.DBO.Water_Points</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" Asset_ID # "Asset ID" Text 50 NULLABLE false AlterField "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.1.0'><FeatureDataset>MasterEGDB.DBO.Water</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68393547796e41434a704a58335551614267636244645734344b56366566387450435a2b33645a50584b616f3d2a00;SERVER=SRV-CH-SQLARCGIS;INSTANCE=sde:sqlserver:SRV-CH-SQLARCGIS;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SRV-CH-SQLARCGIS;DATABASE=MasterEGDB;USER=arcgissql_svc;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>MasterEGDB.DBO.Water_Points</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" Related_PID # "Related PID" Text 16 NULLABLE false AlterField "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.1.0'><FeatureDataset>MasterEGDB.DBO.Water</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68393547796e41434a704a58335551614267636244645734344b56366566387450435a2b33645a50584b616f3d2a00;SERVER=SRV-CH-SQLARCGIS;INSTANCE=sde:sqlserver:SRV-CH-SQLARCGIS;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SRV-CH-SQLARCGIS;DATABASE=MasterEGDB;USER=arcgissql_svc;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>MasterEGDB.DBO.Water_Points</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" Closest_Civic_Address # "Closest Civic Address" Text 50 NULLABLE false AlterField "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.1.0'><FeatureDataset>MasterEGDB.DBO.Water</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68393547796e41434a704a58335551614267636244645734344b56366566387450435a2b33645a50584b616f3d2a00;SERVER=SRV-CH-SQLARCGIS;INSTANCE=sde:sqlserver:SRV-CH-SQLARCGIS;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SRV-CH-SQLARCGIS;DATABASE=MasterEGDB;USER=arcgissql_svc;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>MasterEGDB.DBO.Water_Points</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" Related_Civic_Number # "Related Civic Number" Text 50 NULLABLE false AlterField "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.1.0'><FeatureDataset>MasterEGDB.DBO.Water</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68393547796e41434a704a58335551614267636244645734344b56366566387450435a2b33645a50584b616f3d2a00;SERVER=SRV-CH-SQLARCGIS;INSTANCE=sde:sqlserver:SRV-CH-SQLARCGIS;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SRV-CH-SQLARCGIS;DATABASE=MasterEGDB;USER=arcgissql_svc;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>MasterEGDB.DBO.Water_Points</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" Related_Street_Section # "Related Street Section" "Double (double precision)" 8 NULLABLE false AlterField "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.1.0'><FeatureDataset>MasterEGDB.DBO.Water</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68393547796e41434a704a58335551614267636244645734344b56366566387450435a2b33645a50584b616f3d2a00;SERVER=SRV-CH-SQLARCGIS;INSTANCE=sde:sqlserver:SRV-CH-SQLARCGIS;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SRV-CH-SQLARCGIS;DATABASE=MasterEGDB;USER=arcgissql_svc;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>MasterEGDB.DBO.Water_Points</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" GeoLocation # GeoLocation "Short (small integer)" 2 NULLABLE false AlterField "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.1.0'><FeatureDataset>MasterEGDB.DBO.Water</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68393547796e41434a704a58335551614267636244645734344b56366566387450435a2b33645a50584b616f3d2a00;SERVER=SRV-CH-SQLARCGIS;INSTANCE=sde:sqlserver:SRV-CH-SQLARCGIS;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SRV-CH-SQLARCGIS;DATABASE=MasterEGDB;USER=arcgissql_svc;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>MasterEGDB.DBO.Water_Points</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" Link_to_As_Built # "Link to As-Built" Text 250 NULLABLE false AlterField "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.1.0'><FeatureDataset>MasterEGDB.DBO.Water</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68393547796e41434a704a58335551614267636244645734344b56366566387450435a2b33645a50584b616f3d2a00;SERVER=SRV-CH-SQLARCGIS;INSTANCE=sde:sqlserver:SRV-CH-SQLARCGIS;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SRV-CH-SQLARCGIS;DATABASE=MasterEGDB;USER=arcgissql_svc;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>MasterEGDB.DBO.Water_Points</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" Link_to_Ti_ins # "Link to Ti-ins" Text 250 NULLABLE false AssignDomainToField "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.1.0'><FeatureDataset>MasterEGDB.DBO.Water</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6868656d4767695244515a68614d4e48786839795a5a3164676e6a364a784b707a694a63374336536e52454d3d2a00;SERVER=SRV-CH-SQLARCGIS;INSTANCE=sde:sqlserver:SRV-CH-SQLARCGIS;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SRV-CH-SQLARCGIS;DATABASE=MasterEGDB;USER=arcgissql_svc;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>MasterEGDB.DBO.Water_Points</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" Plowing_Status COB_GeoLocation # AssignDomainToField "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.1.0'><FeatureDataset>MasterEGDB.DBO.Water</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6868656d4767695244515a68614d4e48786839795a5a3164676e6a364a784b707a694a63374336536e52454d3d2a00;SERVER=SRV-CH-SQLARCGIS;INSTANCE=sde:sqlserver:SRV-CH-SQLARCGIS;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SRV-CH-SQLARCGIS;DATABASE=MasterEGDB;USER=arcgissql_svc;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>MasterEGDB.DBO.Water_Points</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" Plowing_Status COB_FireHydrantPlowing # RemoveDomainFromField "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.1.0'><FeatureDataset>MasterEGDB.DBO.Water</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68393547796e41434a704a58335551614267636244645734344b56366566387450435a2b33645a50584b616f3d2a00;SERVER=SRV-CH-SQLARCGIS;INSTANCE=sde:sqlserver:SRV-CH-SQLARCGIS;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SRV-CH-SQLARCGIS;DATABASE=MasterEGDB;USER=arcgissql_svc;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>MasterEGDB.DBO.Water_Points</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" Plowing_Status # AssignDefaultToField "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.1.0'><FeatureDataset>MasterEGDB.DBO.Water</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68393547796e41434a704a58335551614267636244645734344b56366566387450435a2b33645a50584b616f3d2a00;SERVER=SRV-CH-SQLARCGIS;INSTANCE=sde:sqlserver:SRV-CH-SQLARCGIS;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SRV-CH-SQLARCGIS;DATABASE=MasterEGDB;USER=arcgissql_svc;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>MasterEGDB.DBO.Water_Points</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" Plowing_Status # # true AssignDomainToField "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.1.0'><FeatureDataset>MasterEGDB.DBO.Water</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68393547796e41434a704a58335551614267636244645734344b56366566387450435a2b33645a50584b616f3d2a00;SERVER=SRV-CH-SQLARCGIS;INSTANCE=sde:sqlserver:SRV-CH-SQLARCGIS;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SRV-CH-SQLARCGIS;DATABASE=MasterEGDB;USER=arcgissql_svc;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>MasterEGDB.DBO.Water_Points</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" Plowing_Status COB_FireHydrantPlowing # AssignDefaultToField "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.1.0'><FeatureDataset>MasterEGDB.DBO.Water</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68393547796e41434a704a58335551614267636244645734344b56366566387450435a2b33645a50584b616f3d2a00;SERVER=SRV-CH-SQLARCGIS;INSTANCE=sde:sqlserver:SRV-CH-SQLARCGIS;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SRV-CH-SQLARCGIS;DATABASE=MasterEGDB;USER=arcgissql_svc;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>MasterEGDB.DBO.Water_Points</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" Plowing_Status 0 # false RemoveDomainFromField "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.1.0'><FeatureDataset>MasterEGDB.DBO.Water</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68393547796e41434a704a58335551614267636244645734344b56366566387450435a2b33645a50584b616f3d2a00;SERVER=SRV-CH-SQLARCGIS;INSTANCE=sde:sqlserver:SRV-CH-SQLARCGIS;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SRV-CH-SQLARCGIS;DATABASE=MasterEGDB;USER=arcgissql_svc;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>MasterEGDB.DBO.Water_Points</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" Plowing_Status # AssignDomainToField "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points" Plowing_Status COB_FireHydrantSnowRemoval # CalculateField MasterEGDB.DBO.Water_Points deletemetest !Plowing_Status! "Python 3" # AddField "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points" Snow_Plowing_Status TEXT # # 50 "Snow Plowing Status" NULLABLE NON_REQUIRED # AssignDomainToField "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.1.0'><FeatureDataset>MasterEGDB.DBO.Water</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6876312b6946595172583651636e5159686d676148506c4d72747a4f2b747531496d586e6175434d7a3147303d2a00;SERVER=SRV-CH-SQLARCGIS;INSTANCE=sde:sqlserver:SRV-CH-SQLARCGIS;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SRV-CH-SQLARCGIS;DATABASE=MasterEGDB;USER=arcgissql_svc;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>MasterEGDB.DBO.Water_Points</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" Snow_Plowing_Status COB_FireHydrantPlowing # FeatureClassToFeatureClass "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points" "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water" Water_Points2 # "GlobalID "GlobalID" false false false 38 GlobalID 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points,GlobalID,-1,-1;Asset_Group "Asset Group" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points,Asset_Group,-1,-1;Asset_Type "Asset Type" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points,Asset_Type,-1,-1;Asset_Subtype "Asset Subtype" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points,Asset_Subtype,-1,-1;Asset_ID "Asset ID" true true false 50 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points,Asset_ID,-1,-1;Serial_Number "Serial Number" true true false 4 Long 0 10 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points,Serial_Number,-1,-1;E_Coder_Serial "E-Coder Serial" true true false 8 Double 8 38 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points,E_Coder_Serial,-1,-1;Related_PID "Related PID" true true false 16 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points,Related_PID,-1,-1;Closest_Civic_Address "Closest Civic Address" true true false 50 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points,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.Water\MasterEGDB.DBO.Water_Points,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.Water\MasterEGDB.DBO.Water_Points,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.Water\MasterEGDB.DBO.Water_Points,Related_Street_Section,-1,-1;GeoLocation "GeoLocation" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points,GeoLocation,-1,-1;Grid_Reference "Grid Reference" true true false 6 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points,Grid_Reference,-1,-1;Installation_Year "Installation Year" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points,Installation_Year,-1,-1;Diameter "Diameter" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points,Diameter,-1,-1;Type "Type" true true false 65 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points,Type,-1,-1;Comments "Comments" true true false 50 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points,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.Water\MasterEGDB.DBO.Water_Points,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.Water\MasterEGDB.DBO.Water_Points,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.Water\MasterEGDB.DBO.Water_Points,Link_to_Ti_ins,-1,-1;Feature_Creator "Feature Creator" false true false 150 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points,Feature_Creator,-1,-1;Creation_Date "Creation_Date" false true false 8 Date 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points,Creation_Date,-1,-1;Last_Editor "Last_Editor" false true false 255 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points,Last_Editor,-1,-1;Last_Edit_Date "Last_Edit_Date" false true false 8 Date 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points,Last_Edit_Date,-1,-1;Jurisdiction "Jurisdiction" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points,Jurisdiction,-1,-1;Tangible_Capital_Asset "Tangible Capital Asset" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points,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.Water\MasterEGDB.DBO.Water_Points,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.Water\MasterEGDB.DBO.Water_Points,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.Water\MasterEGDB.DBO.Water_Points,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.Water\MasterEGDB.DBO.Water_Points,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.Water\MasterEGDB.DBO.Water_Points,Condition_Rating,-1,-1;Cost_per_Unit "Cost per Unit" true true false 8 Double 8 38 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points,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.Water\MasterEGDB.DBO.Water_Points,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.Water\MasterEGDB.DBO.Water_Points,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.Water\MasterEGDB.DBO.Water_Points,Loss_in_Value,-1,-1;Remaining_Value "Remaining Value" true true false 8 Double 8 38 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points,Remaining_Value,-1,-1;Infrastructure_Deficit__Backlog "Infrastructure Deficit (Backlog)" true true false 8 Double 8 38 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points,Infrastructure_Deficit__Backlog,-1,-1;Duplicate "Duplicate" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points,Duplicate,-1,-1;Enabled "Enabled" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points,Enabled,-1,-1;AncillaryRole "AncillaryRole" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points,AncillaryRole,-1,-1;Plowing_Status "Plowing Status" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points,Plowing_Status,-1,-1;deletemetest "deletemetest" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points,deletemetest,-1,-1;Snow_Plowing_Status "Snow Plowing Status" true true false 50 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points,Snow_Plowing_Status,-1,-1" # RemoveDomainFromField "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2" Plowing_Status # RemoveDomainFromField "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2" Snow_Plowing_Status # AddSubtype "C:\GIS\ArcGIS Pro Layouts\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2" 111 "Water - Main Fitting - Tee" AddSubtype "C:\GIS\ArcGIS Pro Layouts\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2" 112 "Water - Main Fitting - Elbow" AssignDefaultToField "Engineering\Engineering - Divided\Water Distribution System\Water - Main Valve" Plowing_Status -1 103 false AssignDefaultToField "Engineering\Engineering - Divided\Water Distribution System\Water - Main Valve" Plowing_Status -1 106 false AssignDefaultToField "Engineering\Engineering - Divided\Water Distribution System\Water - Main Valve" Plowing_Status -1 107 false AssignDefaultToField "Engineering\Engineering - Divided\Water Distribution System\Water - Main Valve" Plowing_Status -1 108 false AssignDefaultToField "Engineering\Engineering - Divided\Water Distribution System\Water - Main Valve" Plowing_Status -1 110 false AssignDefaultToField "Engineering\Engineering - Divided\Water Distribution System\Water - Main Valve" Plowing_Status -1 111 false AssignDefaultToField "Engineering\Engineering - Divided\Water Distribution System\Water - Main Valve" Plowing_Status -1 112 false CalculateField "Engineering\Water Distribution Network\Water Points" Jurisdiction NULL "Python 3" # AssignDomainToField "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.1.0'><FeatureDataset>MasterEGDB.DBO.Water</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68736c3251382f4231317a7242624f794f36777676514a533378516c4a59336570446b724a2b504161797a553d2a00;SERVER=SRV-CH-SQLARCGIS;INSTANCE=sde:sqlserver:SRV-CH-SQLARCGIS;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SRV-CH-SQLARCGIS;DATABASE=MasterEGDB;USER=arcgissql_svc;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>MasterEGDB.DBO.Water_Points2</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" Tangible_Capital_Asset "COB_Yes No NA Unknown" # JoinField MasterEGDB.DBO.Water_Points2 OBJECTID WorkEGDB.DBO.Spatial_Join_From_PrivateLateral_To_ShutOffValve1 TARGET_FID Asset_ID;Related_PID;Related_Street_Name;Related_Street_Section;Link_to_Ti_ins CalculateField MasterEGDB.DBO.Water_Points2 Asset_ID [Asset_ID_1] VB # CalculateField MasterEGDB.DBO.Water_Points2 Related_PID [Related_PID_1] VB # CalculateField MasterEGDB.DBO.Water_Points2 Related_PID [Asset_ID] VB # CalculateField MasterEGDB.DBO.Water_Points2 Link_to_Ti_ins [Link_to_Ti_ins_1] VB # CalculateField MasterEGDB.DBO.Water_Points2 Related_Street_Name [Related_Street_Name_1] VB # JoinField MasterEGDB.DBO.Water_Points2 OBJECTID WorkEGDB.DBO.Spatial_Join_From_ShutOff_To_DBH1 TARGET_FID Asset_ID;Related_PID;Related_Street_Name;Related_Street_Section;Link_to_Ti_ins DeleteField MasterEGDB.DBO.Water_Points2 Asset_ID_1;Related_PID_1;Related_Street_Name_1;Related_Street_Section_1;Link_to_Ti_ins_1;Asset_ID_12;Related_PID_12;Related_Street_Name_12;Related_Street_Section_12;Link_to_Ti_ins_12 JoinField MasterEGDB.DBO.Water_Points2 OBJECTID WorkEGDB.DBO.Spatial_Join_From_ShutOff_To_DBH2 TARGET_FID Asset_ID;Related_PID;Related_Street_Name;Link_to_Ti_ins CalculateField MasterEGDB.DBO.Water_Points2 Asset_ID [Asset_ID_1] VB # CalculateField MasterEGDB.DBO.Water_Points2 Asset_ID [Asset_ID_1] VB # CalculateField MasterEGDB.DBO.Water_Points2 Related_PID [Related_PID_1] VB # CalculateField MasterEGDB.DBO.Water_Points2 Related_PID [Asset_ID] VB # CalculateField MasterEGDB.DBO.Water_Points2 Related_Street_Name [Related_Street_Name_1] VB # CalculateField MasterEGDB.DBO.Water_Points2 Link_to_Ti_ins [Link_to_Ti_ins_1] VB # DeleteField "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2" Asset_ID_1;Related_PID_1;Related_Street_Name_1;Link_to_Ti_ins_1 EnableEditorTracking "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2" Feature_Creator Creation_Date Last_Editor Last_Edit_Date # DATABASE_TIME DeleteField "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2" created_user;created_date;last_edited_user;last_edited_date EnableEditorTracking "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2" Feature_Creator Creation_Date Last_Editor Last_Edit_Date # DATABASE_TIME AddAttachments MasterEGDB.DBO.Water_Points2 OBJECTID TEMPEGDB.DBO.ATTACHMENT_MATCH_TABLE_LVL9 MatchID Filename # AddAttachments MasterEGDB.DBO.Water_Points2 OBJECTID TEMPEGDB.DBO.ATTACHMENT_MATCH_TABLE_LVL9 MatchID Filename # AddAttachments MasterEGDB.DBO.Water_Points2 OBJECTID TEMPEGDB.DBO.ATTACHMENT_MATCH_TABLE_LVL9 MatchID Filename # AddField "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2" TempField2 TEXT # # 250 # NULLABLE NON_REQUIRED # DeleteField "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2" TempField2 AddField "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2" TempField2 TEXT # # 250 # NULLABLE NON_REQUIRED # CalculateField MasterEGDB.DBO.Water_Points2 TempField2 [Link_to_Ti_ins] VB # AddAttachments MasterEGDB.DBO.Water_Points2 TempField2 TEMPEGDB.DBO.ATTACHMENT_MATCH_TABLE_LVL10 MatchID Filename "X:\Plans\Tie-Ins\Tie-Ins - Laterals Valves (PID.Valve#.LVL)" FeatureClassToFeatureClass "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2" "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water" Water_Points3 # "GlobalID "GlobalID" false false false 38 GlobalID 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2,GlobalID,-1,-1;Asset_Group "Asset Group" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2,Asset_Group,-1,-1;Asset_Type "Asset Type" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2,Asset_Type,-1,-1;Asset_Subtype "Asset Subtype" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2,Asset_Subtype,-1,-1;Asset_ID "Asset ID" true true false 50 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2,Asset_ID,-1,-1;Serial_Number "Serial Number" true true false 4 Long 0 10 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2,Serial_Number,-1,-1;E_Coder_Serial "E-Coder Serial" true true false 8 Double 8 38 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2,E_Coder_Serial,-1,-1;Related_PID "Related PID" true true false 16 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2,Related_PID,-1,-1;Closest_Civic_Address "Closest Civic Address" true true false 50 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2,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.Water\MasterEGDB.DBO.Water_Points2,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.Water\MasterEGDB.DBO.Water_Points2,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.Water\MasterEGDB.DBO.Water_Points2,Related_Street_Section,-1,-1;GeoLocation "GeoLocation" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2,GeoLocation,-1,-1;Grid_Reference "Grid Reference" true true false 6 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2,Grid_Reference,-1,-1;Installation_Year "Installation Year" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2,Installation_Year,-1,-1;Diameter "Diameter" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2,Diameter,-1,-1;Type "Type" true true false 65 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2,Type,-1,-1;Comments "Comments" true true false 50 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2,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.Water\MasterEGDB.DBO.Water_Points2,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.Water\MasterEGDB.DBO.Water_Points2,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.Water\MasterEGDB.DBO.Water_Points2,Link_to_Ti_ins,-1,-1;Feature_Creator "Feature Creator" false true false 150 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2,Feature_Creator,-1,-1;Creation_Date "Creation_Date" false true false 8 Date 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2,Creation_Date,-1,-1;Last_Editor "Last_Editor" false true false 255 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2,Last_Editor,-1,-1;Last_Edit_Date "Last_Edit_Date" false true false 8 Date 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2,Last_Edit_Date,-1,-1;Jurisdiction "Jurisdiction" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2,Jurisdiction,-1,-1;Tangible_Capital_Asset "Tangible Capital Asset" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2,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.Water\MasterEGDB.DBO.Water_Points2,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.Water\MasterEGDB.DBO.Water_Points2,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.Water\MasterEGDB.DBO.Water_Points2,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.Water\MasterEGDB.DBO.Water_Points2,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.Water\MasterEGDB.DBO.Water_Points2,Condition_Rating,-1,-1;Cost_per_Unit "Cost per Unit" true true false 8 Double 8 38 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2,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.Water\MasterEGDB.DBO.Water_Points2,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.Water\MasterEGDB.DBO.Water_Points2,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.Water\MasterEGDB.DBO.Water_Points2,Loss_in_Value,-1,-1;Remaining_Value "Remaining Value" true true false 8 Double 8 38 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2,Remaining_Value,-1,-1;Infrastructure_Deficit__Backlog "Infrastructure Deficit (Backlog)" true true false 8 Double 8 38 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2,Infrastructure_Deficit__Backlog,-1,-1;Duplicate "Duplicate" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2,Duplicate,-1,-1;Enabled "Enabled" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2,Enabled,-1,-1;AncillaryRole "AncillaryRole" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2,AncillaryRole,-1,-1;Plowing_Status "Plowing Status" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2,Plowing_Status,-1,-1;deletemetest "deletemetest" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2,deletemetest,-1,-1;Snow_Plowing_Status "Snow Plowing Status" true true false 50 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2,Snow_Plowing_Status,-1,-1;TempField "TempField" true true false 255 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2,TempField,-1,-1;TempField2 "TempField2" true true false 250 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points2,TempField2,-1,-1" # EnableEditorTracking "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3" Feature_Creator Creation_Date Last_Editor Last_Edit_Date # DATABASE_TIME CalculateField "Water - Points\Water - Lateral - Meter" TempField2 !Asset_ID! "Python 3" # CalculateField "Water - Points\Water - Lateral - Meter" TempField2 replace(!TempField2!) "Python 3" "import re\ndef replace(val):\n return re.sub ('WMT', 'LVL', val)" AddAttachments "Water - Points\Water - Lateral - Meter" TempField2 WorkEGDB.DBO.Match_Table_01 MatchID Filename "X:\Plans\Tie-Ins\Tie-Ins - Laterals Valves (PID.Valve#.LVL)" AddAttachments "Water - Points\Water - Lateral - Meter" OBJECTID WorkEGDB.DBO.Match_Table_01 MatchID Filename "X:\Plans\Tie-Ins\Tie-Ins - Laterals Valves (PID.Valve#.LVL)" AddAttachments "Water - Points\Water - Fire Hydrant - Valve" OBJECTID WORKEGDB.DBO.MATCH_TABLE_02 MatchID Filename # AddAttachments "Water - Points\Water - Fire Hydrant - Valve" OBJECTID WORKEGDB.DBO.MATCH_TABLE_02 MatchID Filename "X:\Plans\Tie-Ins\Tie-Ins - Hydrant Valves (HVL)" AddSubtype "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3" 113 "Water - Main Fitting - Union" AddSubtype "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3" 114 "Water - Main Fitting - Cap" AddAttachments "Water - Points\Water - Main Valve" OBJECTID WORKEGDB.DBO.MATCH_TABLE_03 MatchID Filename "X:\Plans\Tie-Ins\Tie-Ins - Water Valves (WVL)" 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_Points3</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>Jurisdiction</field_name><domain_name>COB_Jurisdiction</domain_name></AssignDomainToField><AssignDefaultToField><field_name>Jurisdiction</field_name><default_value>1</default_value></AssignDefaultToField></workflow></operationSequence> AddRelate "Hydrant Inspection Status" Asset_ID "Hydrant Inspections" Asset_ID "Hydrant Relating to Inspection table" "One to many" RemoveRelate "Hydrant Inspection Status" # AddField "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3" Inspection_Status SHORT # # # "Inspection Status" NULLABLE NON_REQUIRED COB_Inspection_Status 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=00022e685a337062342b4a684544465750636b676a744b6158696a74756e71304d6c6a4f6d4f676a4d532b2b6333493d2a00;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_Points3</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AssignDefaultToField><field_name>Inspection_Status</field_name><default_value>1</default_value></AssignDefaultToField></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=00022e685a337062342b4a684544465750636b676a744b6158696a74756e71304d6c6a4f6d4f676a4d532b2b6333493d2a00;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_Points3</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><RemoveDomainFromField><field_name>Inspection_Status</field_name></RemoveDomainFromField></workflow></operationSequence> CalculateField "Hydrant Inspection Status" MasterEGDB.DBO.Water_Points3.Inspection_Status $feature['MasterEGDB.DBO.Water_Points3.GeoLocation'] Arcade # CalculateField "Hydrant Location" Inspection_Status $feature.GeoLocation Arcade # CalculateField "Hydrant Location" Inspection_Status 1 Arcade # CalculateField "Hydrant Location" Inspection_Status 1 Arcade # CalculateField "Hydrant Location" Inspection_Status DateDiff(Now(),$feature.Creation_Date, 'days') Arcade # CalculateField "Hydrant Location" Inspection_Status 5 Arcade # CalculateField "Hydrant Location" Inspection_Status DateDiff(Now(),$feature.Creation_Date, 'days') Arcade # CalculateField "Hydrant Location" Inspection_Status DateDiff(Now(), $feature.Creation_Date, 'Days') Arcade # CalculateField "Hydrant Location" Inspection_Status 8 Arcade # CalculateField "Hydrant Location" Inspection_Status DateDiff(Now(),$feature.Last_Edit_Date, 'days') Arcade # CalculateField "Hydrant Location" Inspection_Status 5 Arcade # CalculateField "Hydrant Location" Inspection_Status 11 Arcade # AddRelate "Hydrant Location" Asset_ID "Hydrant Inspections" Asset_ID "Relate Hydrant FC to Hydrant Inspection table" "One to many" CalculateField MasterEGDB.DBO.Water_Points3 Inspection_Status 3 Arcade # CalculateField MasterEGDB.DBO.Water_Points3 Inspection_Status 4 Arcade # 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=00022e686f526e796f6c7330364e4a6d437565356f792b306664463671596f6a755559765461347231756d6e557a593d2a00;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_Points3</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><RemoveDomainFromField><field_name>deletemetest</field_name></RemoveDomainFromField></workflow></operationSequence> DeleteField "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3" Inspection_Status AddField "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3" InspectionStatus SHORT # # # "Inspection Status" NULLABLE NON_REQUIRED COB_Inspection_Status JoinField "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3" Asset_ID "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water_Points_Inspections" Asset_ID Inspection_Status 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_Points3</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><RemoveDomainFromField><field_name>Inspection_Status</field_name></RemoveDomainFromField></workflow></operationSequence> CalculateField "Hydrant Location" InspectionStatus 3 Arcade # 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_Points3</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><RemoveDomainFromField><field_name>InspectionStatus</field_name></RemoveDomainFromField></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_Points3</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>InspectionStatus</field_name><domain_name>COB_Inspection_Status</domain_name></AssignDomainToField></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_Points3</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>InspectionStatus</field_name><domain_name>COB_PAC_App_Decision</domain_name></AssignDomainToField></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_Points3</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><RemoveDomainFromField><field_name>InspectionStatus</field_name></RemoveDomainFromField></workflow><workflow><AssignDomainToField><field_name>Inspection_Status</field_name><domain_name>COB_Inspection_Status</domain_name></AssignDomainToField></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_Points3</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>InspectionStatus</field_name><domain_name>COB_InspectionStatus</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>Inspection_Status</field_name><domain_name>COB_InspectionStatus</domain_name></AssignDomainToField></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_Points3</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>deletemetest</field_name><domain_name>COB_Inspection_Status</domain_name></AssignDomainToField></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_Points3</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>deletemetest</field_name><domain_name>COB_InspectionStatus</domain_name></AssignDomainToField></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_Points3</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>deletemetest</field_name><domain_name>COB_Services_Gov</domain_name></AssignDomainToField></workflow></operationSequence> DeleteField "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3" deletemetest;InspectionStatus;Inspection_Status AddField "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3" Asset_Inspection_Statut SHORT # # # "Asset Inspection Statut" NULLABLE NON_REQUIRED COB_Asset_Inspection FeatureClassToFeatureClass "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3" "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water" Water_Points4 # "GlobalID "GlobalID" false false false 38 GlobalID 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3,GlobalID,-1,-1;Asset_Group "Asset Group" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3,Asset_Group,-1,-1;Asset_Type "Asset Type" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3,Asset_Type,-1,-1;Asset_Subtype "Asset Subtype" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3,Asset_Subtype,-1,-1;Asset_ID "Asset ID" true true false 50 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3,Asset_ID,-1,-1;Serial_Number "Serial Number" true true false 4 Long 0 10 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3,Serial_Number,-1,-1;E_Coder_Serial "E-Coder Serial" true true false 8 Double 8 38 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3,E_Coder_Serial,-1,-1;Related_PID "Related PID" true true false 16 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3,Related_PID,-1,-1;Closest_Civic_Address "Closest Civic Address" true true false 50 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3,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.Water\MasterEGDB.DBO.Water_Points3,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.Water\MasterEGDB.DBO.Water_Points3,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.Water\MasterEGDB.DBO.Water_Points3,Related_Street_Section,-1,-1;GeoLocation "GeoLocation" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3,GeoLocation,-1,-1;Grid_Reference "Grid Reference" true true false 6 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3,Grid_Reference,-1,-1;Installation_Year "Installation Year" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3,Installation_Year,-1,-1;Diameter "Diameter" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3,Diameter,-1,-1;Type "Type" true true false 65 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3,Type,-1,-1;Comments "Comments" true true false 50 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3,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.Water\MasterEGDB.DBO.Water_Points3,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.Water\MasterEGDB.DBO.Water_Points3,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.Water\MasterEGDB.DBO.Water_Points3,Link_to_Ti_ins,-1,-1;Feature_Creator "Feature Creator" false true false 150 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3,Feature_Creator,-1,-1;Creation_Date "Creation_Date" false true false 8 Date 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3,Creation_Date,-1,-1;Last_Editor "Last_Editor" false true false 255 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3,Last_Editor,-1,-1;Last_Edit_Date "Last_Edit_Date" false true false 8 Date 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3,Last_Edit_Date,-1,-1;Jurisdiction "Jurisdiction" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3,Jurisdiction,-1,-1;Tangible_Capital_Asset "Tangible Capital Asset" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3,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.Water\MasterEGDB.DBO.Water_Points3,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.Water\MasterEGDB.DBO.Water_Points3,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.Water\MasterEGDB.DBO.Water_Points3,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.Water\MasterEGDB.DBO.Water_Points3,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.Water\MasterEGDB.DBO.Water_Points3,Condition_Rating,-1,-1;Cost_per_Unit "Cost per Unit" true true false 8 Double 8 38 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3,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.Water\MasterEGDB.DBO.Water_Points3,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.Water\MasterEGDB.DBO.Water_Points3,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.Water\MasterEGDB.DBO.Water_Points3,Loss_in_Value,-1,-1;Remaining_Value "Remaining Value" true true false 8 Double 8 38 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3,Remaining_Value,-1,-1;Infrastructure_Deficit__Backlog "Infrastructure Deficit (Backlog)" true true false 8 Double 8 38 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3,Infrastructure_Deficit__Backlog,-1,-1;Duplicate "Duplicate" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3,Duplicate,-1,-1;Enabled "Enabled" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3,Enabled,-1,-1;AncillaryRole "AncillaryRole" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3,AncillaryRole,-1,-1;Plowing_Status "Plowing Status" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3,Plowing_Status,-1,-1;Snow_Plowing_Status "Snow Plowing Status" true true false 50 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3,Snow_Plowing_Status,-1,-1;TempField "TempField" true true false 255 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3,TempField,-1,-1;TempField2 "TempField2" true true false 250 Text 0 0 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3,TempField2,-1,-1;Asset_Inspection_Statut "Asset Inspection Statut" true true false 2 Short 0 5 ,First,#,Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3,Asset_Inspection_Statut,-1,-1" # Rename "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points4" "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3" FeatureClass EnableEditorTracking "Database Connections\MasterEGDB.sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3" Feature_Creator Creation_Date Last_Editor Last_Edit_Date # DATABASE_TIME AddAttachments MasterEGDB.DBO.Water_Points3 Asset_ID tempattmatchtableHVL MATCHID FILENAME # AddAttachments MasterEGDB.DBO.Water_Points3 Asset_ID tempattmatchtableHVL MATCHID FILENAME # AddAttachments MasterEGDB.DBO.Water_Points3 Asset_ID C:\GIS\tempattmatchtablehvl MATCHID FILENAME # AddAttachments "Engineering\Water - Points" OBJECTID deletemehvl MATCHID FILENAME # AddAttachments "Engineering\Water - Points" OBJECTID deletemematchhlv MATCHID FILENAME # AddAttachments "Engineering\Water - Points" OBJECTID deletemematchhlv MATCHID FILENAME # AddAttachments MasterEGDB.DBO.Water_Points3 OBJECTID deletemehvl MATCHID FILENAME # AddAttachments MasterEGDB.DBO.Water_Points3 OBJECTID deletemehvlxxx MATCHID FILENAME # AddAttachments MasterEGDB.DBO.Water_Points3 OBJECTID deletemehWVLxxx MATCHID FILENAME # AddAttachments MasterEGDB.DBO.Water_Points3 OBJECTID deletemehWVLxxx MATCHID FILENAME # AddAttachments MasterEGDB.DBO.Water_Points3 OBJECTID deletemehWVLxxx2 MATCHID FILENAME # AddAttachments MasterEGDB.DBO.Water_Points3 OBJECTID deletemeLVLonMetersxxx MATCHID FILENAME # CalculateField MasterEGDB.DBO.Water_Points3 TempField 5 Arcade # CalculateField MasterEGDB.DBO.Water_Points3 TempField 5 Arcade # AddField MasterEGDB.DBO.Water_Points3 Cost_For_Length "Double (double precision)" # # # "Cost For Length" NULLABLE NON_REQUIRED # DeleteField MasterEGDB.DBO.Water_Points3 Cost_For_Length AlterField MasterEGDB.DBO.Water_Points3 Related_Civic_Number # "Related Civic Number" Text 50 NULLABLE DO_NOT_CLEAR AlterField MasterEGDB.DBO.Water_Points3 Creation_Date # "Creation Date" Date 8 NULLABLE DO_NOT_CLEAR AlterField MasterEGDB.DBO.Water_Points3 Last_Editor # "Last Editor" Text 255 NULLABLE DO_NOT_CLEAR AlterField MasterEGDB.DBO.Water_Points3 Last_Edit_Date # "Last Edit Date" Date 8 NULLABLE 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>SERVER=srv-ch-sqlarcgis;INSTANCE=sde:sqlserver:srv-ch-sqlarcgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=srv-ch-sqlarcgis;DATABASE=MasterEGDB;VERSION=DBO.First_Child;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>MasterEGDB.DBO.Water_Points3</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>Plowing_Status</field_name><domain_name>COB_Snow_Removal_Fire_Hydrant</domain_name></AssignDomainToField></workflow></operationSequence> AddField "C:\Users\Michael.St-Pierre\AppData\Roaming\Esri\ArcGISPro\Favorites\MasterEGDB (Admin).sde\MasterEGDB.DBO.Water\MasterEGDB.DBO.Water_Points3" PSAB_2019_Comment "Short (small integer)" # # # "PSAB 2019 Comment" NULLABLE NON_REQUIRED COB_PSAB_Comment 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.3.0'><FeatureDataset>MasterEGDB.DBO.Water</FeatureDataset><WorkspaceConnectionString>SERVER=srv-ch-sqlarcgis;INSTANCE=sde:sqlserver:srv-ch-sqlarcgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=srv-ch-sqlarcgis;DATABASE=MasterEGDB;VERSION=DBO.First_Child;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>MasterEGDB.DBO.Water_Points3</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>PSAB_2019_Comment</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.4.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_Points3</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>ROTATE</field_name><field_type>DOUBLE</field_type><field_precision>7</field_precision><field_scale>1</field_scale><field_alias>Symbol Rotation</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></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.4.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_Points3</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>ROTATE</field_name><field_type>DOUBLE</field_type><field_precision>7</field_precision><field_scale>1</field_scale><field_alias>Symbol Rotation</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></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.4.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_Points3</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>ROTATE</field_name><field_type>DOUBLE</field_type><field_precision>7</field_precision><field_scale>1</field_scale><field_alias>Symbol Rotation</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></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.4.0'><FeatureDataset>MasterEGDB.DBO.Water</FeatureDataset><WorkspaceConnectionString>SERVER=172.20.251.11;INSTANCE=sde:sqlserver:172.20.251.11;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=172.20.251.11;DATABASE=MasterEGDB;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>MasterEGDB.DBO.Water_Points3</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>Rotate</field_name><field_type>FLOAT</field_type><field_precision>4</field_precision><field_scale>1</field_scale><field_alias>Symbol Rotate</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></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.4.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_Points3</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>Rot</field_name><field_type>DOUBLE</field_type><field_precision>7</field_precision><field_scale>1</field_scale><field_alias>Rotate Symbol</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></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.4.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_Points3</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>Rot</field_name><field_type>DOUBLE</field_type><field_precision>7</field_precision><field_scale>1</field_scale><field_alias>Rotate Symbol</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></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.4.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_Points3</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>Rot</field_name><field_type>DOUBLE</field_type><field_precision>7</field_precision><field_scale>1</field_scale><field_alias>Rotation Angle</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></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.4.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_Points3</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>Rotate</field_name><field_type>DOUBLE</field_type><field_precision>7</field_precision><field_scale>1</field_scale><field_alias>Rotate</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></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.4.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_Points3</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>Rotate</field_name><field_type>DOUBLE</field_type><field_precision>7</field_precision><field_scale>1</field_scale><field_alias>Rotation</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></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.4.0'><FeatureDataset>MasterEGDB.DBO.Water</FeatureDataset><WorkspaceConnectionString>SERVER=172.20.251.11;INSTANCE=sde:sqlserver:172.20.251.11;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=172.20.251.11;DATABASE=MasterEGDB;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>MasterEGDB.DBO.Water_Points3</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AlterField><field_name>Rot</field_name><field_alias>Rotation</field_alias><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></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.4.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_Points3</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>Rot</field_name><field_type>DOUBLE</field_type><field_precision>7</field_precision><field_scale>1</field_scale><field_alias>Rotate</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></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.3.0'><FeatureDataset>MasterEGDB.DBO.Water</FeatureDataset><WorkspaceConnectionString>SERVER=172.20.251.11;INSTANCE=sde:sqlserver:172.20.251.11;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=172.20.251.11;DATABASE=MasterEGDB;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>MasterEGDB.DBO.Water_Points3</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>Rotate</field_name><field_type>DOUBLE</field_type><field_precision>7</field_precision><field_scale>1</field_scale><field_alias>Rotate</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></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.3.0'><FeatureDataset>MasterEGDB.DBO.Water</FeatureDataset><WorkspaceConnectionString>SERVER=172.20.251.11;INSTANCE=sde:sqlserver:172.20.251.11;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=172.20.251.11;DATABASE=MasterEGDB;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>MasterEGDB.DBO.Water_Points3</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>Rotate</field_name><field_type>DOUBLE</field_type><field_precision>7</field_precision><field_scale>1</field_scale><field_alias>Symbol Rotation</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>" AlignMarkerToStrokeOrFill "Engineering\Water - Points\Water - Fire Hydrant - Valve" "Engineering\Water - Lines\Water - Fire Hydrant - Lateral" "0.5 Meters" Perpendicular AlignMarkerToStrokeOrFill "Engineering\Water - Points\Water - Main Valve" "Engineering\Water - Lines\Water - Main" "0.5 Meters" Perpendicular AlignMarkerToStrokeOrFill "Engineering\Water - Points\Water - Main Valve" "Engineering\Water - Lines\Water - Main" "0.25 Meters" Parallel AlignMarkerToStrokeOrFill "Engineering\Water - Points\Water - Fire Hydrant - Valve" "Engineering\Water - Lines\Water - Fire Hydrant - Lateral" "0.25 Meters" Parallel CalculateField "Engineering\Water - Points\Water - Main Valve" Rotate None "Python 3" # CalculateField "Engineering\Water - Points\Water - Fire Hydrant - Valve" Rotate None "Python 3" # AlignMarkerToStrokeOrFill "Engineering\Water - Points\Water - Main Valve" "Engineering\Water - Lines\Water - Main" "0.25 Meters" Parallel AlignMarkerToStrokeOrFill "Engineering\Water - Points\Water - Fire Hydrant - Valve" "Engineering\Water - Lines\Water - Fire Hydrant - Lateral" "0.25 Meters" Parallel AlignMarkerToStrokeOrFill Water_points Water_lines "0.25 Meters" Parallel AlignMarkerToStrokeOrFill Water_points Water_lines "0.25 Meters" Parallel AlignMarkerToStrokeOrFill Water_points Water_lines "0.25 Meters" Perpendicular AlignMarkerToStrokeOrFill "Engineering\Water - Points\Water - Main Valve" "Engineering\Water - Lines\Water - Main" "0.25 Meters" Parallel AlignMarkerToStrokeOrFill "Engineering\Water - Points\Water - Main Valve" "Engineering\Water - Lines\Water - Main" "0.25 Meters" Parallel CalculateField "Engineering\Water - Points\Water - Lateral - Shut Off Valve" Asset_Group 1 "Python 3" # CalculateField "Engineering\Water - Points\Water - Lateral - Shut Off Valve" GeoLocation 5 "Python 3" # CalculateField "Engineering\Water - Points\Water - Lateral - Shut Off Valve" GeoLocation 2 "Python 3" # CalculateField "Engineering\Water - Points\Water - Lateral - Shut Off Valve" Grid_Reference "28Q-C0" "Python 3" # CalculateField "Engineering\Water - Points\Water - Lateral - Shut Off Valve" Installation_Year 2019 "Python 3" # CalculateField "Engineering\Water - Points\Water - Lateral - Shut Off Valve" Diameter 100 "Python 3" # CalculateField "Engineering\Water - Points\Water - Lateral - Shut Off Valve" Type "Mueller" "Python 3" # CalculateField "Engineering\Water - Points\Water - Lateral - Shut Off Valve" Asset_Group 1 "Python 3" # CalculateField "Engineering\Water - Points\Water - Lateral - Shut Off Valve" Related_Street_Name 599 "Python 3" # CalculateField "Engineering\Water - Points\Water - Lateral - Shut Off Valve" Grid_Reference "28Q-D1" "Python 3" # CalculateField "Engineering\Water - Points\Water - Lateral - Shut Off Valve" Installation_Year 2019 "Python 3" # CalculateField "Engineering\Water - Points\Water - Lateral - Shut Off Valve" Diameter 19 "Python 3" # CalculateField "Engineering\Water - Points\Water - Lateral - Shut Off Valve" Expected_Life_Years 60 "Python 3" # FeatureClassToFeatureClass "Engineering\Water - Points" X:\ArcGisProjects\Engineering\Master.sde\MasterEGDB.DBO.Public_Works Water_Points # "GlobalID "GlobalID" false false false 38 GlobalID 0 0,First,#,Engineering\Water - Points,GlobalID,-1,-1;Asset_Group "Asset Group" true true false 2 Short 0 5,First,#,Engineering\Water - Points,Asset_Group,-1,-1;Asset_Type "Asset Type" true true false 2 Short 0 5,First,#,Engineering\Water - Points,Asset_Type,-1,-1;Asset_Subtype "Asset Subtype" true true false 2 Short 0 5,First,#,Engineering\Water - Points,Asset_Subtype,-1,-1;Asset_ID "Asset ID" true true false 50 Text 0 0,First,#,Engineering\Water - Points,Asset_ID,0,50;Serial_Number "Serial Number" true true false 4 Long 0 10,First,#,Engineering\Water - Points,Serial_Number,-1,-1;E_Coder_Serial "E-Coder Serial" true true false 8 Double 8 38,First,#,Engineering\Water - Points,E_Coder_Serial,-1,-1;Related_PID "Related PID" true true false 16 Text 0 0,First,#,Engineering\Water - Points,Related_PID,0,16;Closest_Civic_Address "Closest Civic Address" true true false 50 Text 0 0,First,#,Engineering\Water - Points,Closest_Civic_Address,0,50;Related_Civic_Number "Related Civic Number" true true false 50 Text 0 0,First,#,Engineering\Water - Points,Related_Civic_Number,0,50;Related_Street_Name "Related Street Name" true true false 2 Short 0 5,First,#,Engineering\Water - Points,Related_Street_Name,-1,-1;Related_Street_Section "Related Street Section" true true false 8 Double 8 38,First,#,Engineering\Water - Points,Related_Street_Section,-1,-1;GeoLocation "GeoLocation" true true false 2 Short 0 5,First,#,Engineering\Water - Points,GeoLocation,-1,-1;Grid_Reference "Grid Reference" true true false 6 Text 0 0,First,#,Engineering\Water - Points,Grid_Reference,0,6;Installation_Year "Installation Year" true true false 2 Short 0 5,First,#,Engineering\Water - Points,Installation_Year,-1,-1;Diameter "Diameter" true true false 2 Short 0 5,First,#,Engineering\Water - Points,Diameter,-1,-1;Type "Type" true true false 65 Text 0 0,First,#,Engineering\Water - Points,Type,0,65;Comments "Comments" true true false 50 Text 0 0,First,#,Engineering\Water - Points,Comments,0,50;Last_Maintenance_Inspection_Dat "Last Maintenance Inspection Date" true true false 2 Short 0 5,First,#,Engineering\Water - Points,Last_Maintenance_Inspection_Dat,-1,-1;Link_to_As_Built "Link to As-Built" true true false 250 Text 0 0,First,#,Engineering\Water - Points,Link_to_As_Built,0,250;Link_to_Ti_ins "Link to Ti-ins" true true false 250 Text 0 0,First,#,Engineering\Water - Points,Link_to_Ti_ins,0,250;Feature_Creator "Feature Creator" false true false 150 Text 0 0,First,#,Engineering\Water - Points,Feature_Creator,0,150;Creation_Date "Creation Date" false true false 8 Date 0 0,First,#,Engineering\Water - Points,Creation_Date,-1,-1;Last_Editor "Last Editor" false true false 255 Text 0 0,First,#,Engineering\Water - Points,Last_Editor,0,255;Last_Edit_Date "Last Edit Date" false true false 8 Date 0 0,First,#,Engineering\Water - Points,Last_Edit_Date,-1,-1;Jurisdiction "Jurisdiction" true true false 2 Short 0 5,First,#,Engineering\Water - Points,Jurisdiction,-1,-1;Tangible_Capital_Asset "Tangible Capital Asset" true true false 2 Short 0 5,First,#,Engineering\Water - Points,Tangible_Capital_Asset,-1,-1;Expected_Life_Years "Expected Life Years" true true false 2 Short 0 5,First,#,Engineering\Water - Points,Expected_Life_Years,-1,-1;End_of_Life_Date "End of Life Date" true true false 2 Short 0 5,First,#,Engineering\Water - Points,End_of_Life_Date,-1,-1;Remaining_Life_Years "Remaining Life Years" true true false 2 Short 0 5,First,#,Engineering\Water - Points,Remaining_Life_Years,-1,-1;Remaining_Life_Percent "Remaining Life Percent" true true false 8 Double 8 38,First,#,Engineering\Water - Points,Remaining_Life_Percent,-1,-1;Condition_Rating "Condition Rating (1 to 5)" true true false 2 Short 0 5,First,#,Engineering\Water - Points,Condition_Rating,-1,-1;Cost_per_Unit "Cost per Unit" true true false 8 Double 8 38,First,#,Engineering\Water - Points,Cost_per_Unit,-1,-1;Asset_Replacement_Value "Asset Replacement Value" true true false 8 Double 8 38,First,#,Engineering\Water - Points,Asset_Replacement_Value,-1,-1;Emergency_Asset_Replacement_Val "Emergency Asset Replacement Value" true true false 8 Double 8 38,First,#,Engineering\Water - Points,Emergency_Asset_Replacement_Val,-1,-1;Loss_in_Value "Loss in Value" true true false 8 Double 8 38,First,#,Engineering\Water - Points,Loss_in_Value,-1,-1;Remaining_Value "Remaining Value" true true false 8 Double 8 38,First,#,Engineering\Water - Points,Remaining_Value,-1,-1;Infrastructure_Deficit__Backlog "Infrastructure Deficit (Backlog)" true true false 8 Double 8 38,First,#,Engineering\Water - Points,Infrastructure_Deficit__Backlog,-1,-1;Duplicate "Duplicate" true true false 2 Short 0 5,First,#,Engineering\Water - Points,Duplicate,-1,-1;Enabled "Enabled" true true false 2 Short 0 5,First,#,Engineering\Water - Points,Enabled,-1,-1;AncillaryRole "AncillaryRole" true true false 2 Short 0 5,First,#,Engineering\Water - Points,AncillaryRole,-1,-1;Plowing_Status "Plowing Status" true true false 2 Short 0 5,First,#,Engineering\Water - Points,Plowing_Status,-1,-1;Snow_Plowing_Status "Snow Plowing Status" true true false 50 Text 0 0,First,#,Engineering\Water - Points,Snow_Plowing_Status,0,50;TempField "TempField" true true false 255 Text 0 0,First,#,Engineering\Water - Points,TempField,0,255;TempField2 "TempField2" true true false 250 Text 0 0,First,#,Engineering\Water - Points,TempField2,0,250;Asset_Inspection_Statut "Asset Inspection Statut" true true false 2 Short 0 5,First,#,Engineering\Water - Points,Asset_Inspection_Statut,-1,-1;Rotate "Symbol Rotation" true true false 8 Double 1 7,First,#,Engineering\Water - Points,Rotate,-1,-1" # AlignMarkerToStrokeOrFill Water_Points Water_Lines "0.025 Meters" Parallel AddAttachments Water_Points OBJECTID match_hydrant_valves MATCHID FILENAME C:\Downloads AddAttachments Water_Points OBJECTID match_hydrant_valves MATCHID FILENAME "X:\Plans\Tie-Ins\Tie-Ins - Hydrant Valves (HVL)" RemoveAttachments Water_Points OBJECTID match_hydrant_valves MATCHID FILENAME RemoveAttachments Water_Points OBJECTID match_hydrant_valves MATCHID FILENAME AddAttachments Water_Points OBJECTID match_hydrant_valves MATCHID FILENAME "X:\Plans\Tie-Ins\Tie-Ins - Hydrant Valves (HVL)" RemoveAttachments Water_Points OBJECTID Match_water_valves MatchID Filename AddAttachments Water_Points OBJECTID Match_water_valves MatchID Filename "X:\Plans\Tie-Ins\Tie-Ins - Water Valves (WVL)" AddAttachments Water_Points OBJECTID Match_curbstops MatchID Filename "X:\Plans\Tie-Ins\Tie-Ins - Laterals Valves (PID.Valve#.LVL)" AlignMarkerToStrokeOrFill Water_Points Water_Lines "0.25 Meters" Parallel AlignMarkerToStrokeOrFill Water_Points Water_Lines "5 Meters" Parallel AlignMarkerToStrokeOrFill Water_Points Water_Lines "0.25 Meters" Parallel AlignMarkerToStrokeOrFill Water_Points Water_Lines "0.25 Meters" Parallel AlignMarkerToStrokeOrFill Water_Points Water_Lines "0.5 Meters" Parallel AlignMarkerToStrokeOrFill Water_Points Water_Lines "0.5 Meters" Parallel AddRelate Water_Points OBJECTID Water_Points_SpatialJoin TARGET_FID Relate1 "One to one" RemoveRelate Water_Points Relate1 CalculateField Water_Points Rotate "$feature.Rotate + 90" ARCADE # Text CalculateField Water_Points Rotate "$feature.Rotate - 360" ARCADE # Text AlignMarkerToStrokeOrFill Water_Points Water_Lines "0.01 Meters" Parallel CalculateField Water_Points Rotate "$feature.Rotate - 90" Arcade # Text AlignMarkerToStrokeOrFill Water_Points Water_Lines "0.01 Meters" Perpendicular UpdateSchema Water_Points "<operationSequence><workflow><AssignDefaultToField><field_name>Asset_Subtype</field_name><default_value>115</default_value></AssignDefaultToField></workflow><workflow><AddSubtype><subtype_code>115</subtype_code><subtype_description>Water - Flushing Unit - Location</subtype_description></AddSubtype></workflow><workflow><SetDefaultSubtype><subtype_code>115</subtype_code></SetDefaultSubtype></workflow></operationSequence>" UpdateSchema Water_Points "<operationSequence><workflow><AssignDefaultToField><field_name>Asset_Subtype</field_name><default_value>116</default_value></AssignDefaultToField></workflow><workflow><AddSubtype><subtype_code>116</subtype_code><subtype_description>Water - Pressure Reducing Valve - Location</subtype_description></AddSubtype></workflow><workflow><SetDefaultSubtype><subtype_code>116</subtype_code></SetDefaultSubtype></workflow></operationSequence>" UpdateSchema Water_Points "<operationSequence><workflow><AssignDefaultToField><field_name>Asset_Subtype</field_name><default_value>117</default_value></AssignDefaultToField></workflow><workflow><AddSubtype><subtype_code>117</subtype_code><subtype_description>Water - Check Valve - Location</subtype_description></AddSubtype></workflow><workflow><SetDefaultSubtype><subtype_code>117</subtype_code></SetDefaultSubtype></workflow></operationSequence>" FeatureClassToFeatureClass MasterEGDB.DBO.Water_Points X:\ArcGisProjects\Postgres\gis-vector.sde\gis_vector.sde.PW Water_Points # "GlobalID "GlobalID" false false false 38 GlobalID 0 0,First,#,MasterEGDB.DBO.Water_Points,GlobalID,-1,-1;Asset_Group "Asset Group" true true false 2 Short 0 5,First,#,MasterEGDB.DBO.Water_Points,Asset_Group,-1,-1;Asset_Type "Asset Type" true true false 2 Short 0 5,First,#,MasterEGDB.DBO.Water_Points,Asset_Type,-1,-1;Asset_Subtype "Asset Subtype" true true false 2 Short 0 5,First,#,MasterEGDB.DBO.Water_Points,Asset_Subtype,-1,-1;Asset_ID "Asset ID" true true false 50 Text 0 0,First,#,MasterEGDB.DBO.Water_Points,Asset_ID,0,50;Serial_Number "Serial Number" true true false 4 Long 0 10,First,#,MasterEGDB.DBO.Water_Points,Serial_Number,-1,-1;E_Coder_Serial "E-Coder Serial" true true false 8 Double 8 38,First,#,MasterEGDB.DBO.Water_Points,E_Coder_Serial,-1,-1;Related_PID "Related PID" true true false 16 Text 0 0,First,#,MasterEGDB.DBO.Water_Points,Related_PID,0,16;Closest_Civic_Address "Closest Civic Address" true true false 50 Text 0 0,First,#,MasterEGDB.DBO.Water_Points,Closest_Civic_Address,0,50;Related_Civic_Number "Related Civic Number" true true false 50 Text 0 0,First,#,MasterEGDB.DBO.Water_Points,Related_Civic_Number,0,50;Related_Street_Name "Related Street Name" true true false 2 Short 0 5,First,#,MasterEGDB.DBO.Water_Points,Related_Street_Name,-1,-1;Related_Street_Section "Related Street Section" true true false 8 Double 8 38,First,#,MasterEGDB.DBO.Water_Points,Related_Street_Section,-1,-1;GeoLocation "GeoLocation" true true false 2 Short 0 5,First,#,MasterEGDB.DBO.Water_Points,GeoLocation,-1,-1;Grid_Reference "Grid Reference" true true false 6 Text 0 0,First,#,MasterEGDB.DBO.Water_Points,Grid_Reference,0,6;Installation_Year "Installation Year" true true false 2 Short 0 5,First,#,MasterEGDB.DBO.Water_Points,Installation_Year,-1,-1;Diameter "Diameter" true true false 2 Short 0 5,First,#,MasterEGDB.DBO.Water_Points,Diameter,-1,-1;Type "Type" true true false 65 Text 0 0,First,#,MasterEGDB.DBO.Water_Points,Type,0,65;Comments "Comments" true true false 50 Text 0 0,First,#,MasterEGDB.DBO.Water_Points,Comments,0,50;Last_Maintenance_Inspection_Dat "Last Maintenance Inspection Date" true true false 2 Short 0 5,First,#,MasterEGDB.DBO.Water_Points,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_Points,Link_to_As_Built,0,250;Link_to_Ti_ins "Link to Ti-ins" true true false 250 Text 0 0,First,#,MasterEGDB.DBO.Water_Points,Link_to_Ti_ins,0,250;Feature_Creator "Feature Creator" true true false 150 Text 0 0,First,#,MasterEGDB.DBO.Water_Points,Feature_Creator,0,150;Creation_Date "Creation Date" true true false 8 Date 0 0,First,#,MasterEGDB.DBO.Water_Points,Creation_Date,-1,-1;Last_Editor "Last Editor" true true false 255 Text 0 0,First,#,MasterEGDB.DBO.Water_Points,Last_Editor,0,255;Last_Edit_Date "Last Edit Date" true true false 8 Date 0 0,First,#,MasterEGDB.DBO.Water_Points,Last_Edit_Date,-1,-1;Jurisdiction "Jurisdiction" true true false 2 Short 0 5,First,#,MasterEGDB.DBO.Water_Points,Jurisdiction,-1,-1;Tangible_Capital_Asset "Tangible Capital Asset" true true false 2 Short 0 5,First,#,MasterEGDB.DBO.Water_Points,Tangible_Capital_Asset,-1,-1;Expected_Life_Years "Expected Life Years" true true false 2 Short 0 5,First,#,MasterEGDB.DBO.Water_Points,Expected_Life_Years,-1,-1;End_of_Life_Date "End of Life Date" true true false 2 Short 0 5,First,#,MasterEGDB.DBO.Water_Points,End_of_Life_Date,-1,-1;Remaining_Life_Years "Remaining Life Years" true true false 2 Short 0 5,First,#,MasterEGDB.DBO.Water_Points,Remaining_Life_Years,-1,-1;Remaining_Life_Percent "Remaining Life Percent" true true false 8 Double 8 38,First,#,MasterEGDB.DBO.Water_Points,Remaining_Life_Percent,-1,-1;Condition_Rating "Condition Rating (1 to 5)" true true false 2 Short 0 5,First,#,MasterEGDB.DBO.Water_Points,Condition_Rating,-1,-1;Cost_per_Unit "Cost per Unit" true true false 8 Double 8 38,First,#,MasterEGDB.DBO.Water_Points,Cost_per_Unit,-1,-1;Asset_Replacement_Value "Asset Replacement Value" true true false 8 Double 8 38,First,#,MasterEGDB.DBO.Water_Points,Asset_Replacement_Value,-1,-1;Emergency_Asset_Replacement_Val "Emergency Asset Replacement Value" true true false 8 Double 8 38,First,#,MasterEGDB.DBO.Water_Points,Emergency_Asset_Replacement_Val,-1,-1;Loss_in_Value "Loss in Value" true true false 8 Double 8 38,First,#,MasterEGDB.DBO.Water_Points,Loss_in_Value,-1,-1;Remaining_Value "Remaining Value" true true false 8 Double 8 38,First,#,MasterEGDB.DBO.Water_Points,Remaining_Value,-1,-1;Infrastructure_Deficit__Backlog "Infrastructure Deficit (Backlog)" true true false 8 Double 8 38,First,#,MasterEGDB.DBO.Water_Points,Infrastructure_Deficit__Backlog,-1,-1;Duplicate "Duplicate" true true false 2 Short 0 5,First,#,MasterEGDB.DBO.Water_Points,Duplicate,-1,-1;Enabled "Enabled" true true false 2 Short 0 5,First,#,MasterEGDB.DBO.Water_Points,Enabled,-1,-1;AncillaryRole "AncillaryRole" true true false 2 Short 0 5,First,#,MasterEGDB.DBO.Water_Points,AncillaryRole,-1,-1;Plowing_Status "Plowing Status" true true false 2 Short 0 5,First,#,MasterEGDB.DBO.Water_Points,Plowing_Status,-1,-1;Snow_Plowing_Status "Snow Plowing Status" true true false 50 Text 0 0,First,#,MasterEGDB.DBO.Water_Points,Snow_Plowing_Status,0,50;TempField "TempField" true true false 255 Text 0 0,First,#,MasterEGDB.DBO.Water_Points,TempField,0,255;TempField2 "TempField2" true true false 250 Text 0 0,First,#,MasterEGDB.DBO.Water_Points,TempField2,0,250;Asset_Inspection_Statut "Asset Inspection Statut" true true false 2 Short 0 5,First,#,MasterEGDB.DBO.Water_Points,Asset_Inspection_Statut,-1,-1;Rotate "Symbol Rotation" true true false 8 Double 1 7,First,#,MasterEGDB.DBO.Water_Points,Rotate,-1,-1" # FeatureClassToFeatureClass Hydrants X:\ArcGisProjects\Editing\gis_vector.sde\gis_vector.sde.WMS Test_hydrants # "globalid "GlobalID" false false false 38 GlobalID 0 0,First,#,Hydrants,globalid,-1,-1;asset_group "Asset Group" true true false 2 Short 0 5,First,#,Hydrants,asset_group,-1,-1;asset_type "Asset Type" true true false 2 Short 0 5,First,#,Hydrants,asset_type,-1,-1;asset_subtype "Asset Subtype" true true false 2 Short 0 5,First,#,Hydrants,asset_subtype,-1,-1;asset_id "Asset ID" true true false 50 Text 0 0,First,#,Hydrants,asset_id,0,50;serial_number "Serial Number" true true false 4 Long 0 10,First,#,Hydrants,serial_number,-1,-1;e_coder_serial "E-Coder Serial" true true false 8 Double 8 38,First,#,Hydrants,e_coder_serial,-1,-1;related_pid "Related PID" true true false 16 Text 0 0,First,#,Hydrants,related_pid,0,16;closest_civic_address "Closest Civic Address" true true false 50 Text 0 0,First,#,Hydrants,closest_civic_address,0,50;related_civic_number "Related Civic Number" true true false 50 Text 0 0,First,#,Hydrants,related_civic_number,0,50;related_street_name "Related Street Name" true true false 2 Short 0 5,First,#,Hydrants,related_street_name,-1,-1;related_street_section "Related Street Section" true true false 8 Double 8 38,First,#,Hydrants,related_street_section,-1,-1;geolocation "GeoLocation" true true false 2 Short 0 5,First,#,Hydrants,geolocation,-1,-1;grid_reference "Grid Reference" true true false 6 Text 0 0,First,#,Hydrants,grid_reference,0,6;installation_year "Installation Year" true true false 2 Short 0 5,First,#,Hydrants,installation_year,-1,-1;diameter "Diameter" true true false 2 Short 0 5,First,#,Hydrants,diameter,-1,-1;type "Type" true true false 65 Text 0 0,First,#,Hydrants,type,0,65;comments "Comments" true true false 50 Text 0 0,First,#,Hydrants,comments,0,50;last_maintenance_inspection_dat "Last Maintenance Inspection Date" true true false 2 Short 0 5,First,#,Hydrants,last_maintenance_inspection_dat,-1,-1;link_to_as_built "Link to As-Built" true true false 250 Text 0 0,First,#,Hydrants,link_to_as_built,0,250;link_to_ti_ins "Link to Ti-ins" true true false 250 Text 0 0,First,#,Hydrants,link_to_ti_ins,0,250;feature_creator "Feature Creator" true true false 150 Text 0 0,First,#,Hydrants,feature_creator,0,150;creation_date "Creation Date" true true false 8 Date 0 0,First,#,Hydrants,creation_date,-1,-1;last_editor "Last Editor" true true false 255 Text 0 0,First,#,Hydrants,last_editor,0,255;last_edit_date "Last Edit Date" true true false 8 Date 0 0,First,#,Hydrants,last_edit_date,-1,-1;jurisdiction "Jurisdiction" true true false 2 Short 0 5,First,#,Hydrants,jurisdiction,-1,-1;tangible_capital_asset "Tangible Capital Asset" true true false 2 Short 0 5,First,#,Hydrants,tangible_capital_asset,-1,-1;expected_life_years "Expected Life Years" true true false 2 Short 0 5,First,#,Hydrants,expected_life_years,-1,-1;end_of_life_date "End of Life Date" true true false 2 Short 0 5,First,#,Hydrants,end_of_life_date,-1,-1;remaining_life_years "Remaining Life Years" true true false 2 Short 0 5,First,#,Hydrants,remaining_life_years,-1,-1;remaining_life_percent "Remaining Life Percent" true true false 8 Double 8 38,First,#,Hydrants,remaining_life_percent,-1,-1;condition_rating "Condition Rating (1 to 5)" true true false 2 Short 0 5,First,#,Hydrants,condition_rating,-1,-1;cost_per_unit "Cost per Unit" true true false 8 Double 8 38,First,#,Hydrants,cost_per_unit,-1,-1;asset_replacement_value "Asset Replacement Value" true true false 8 Double 8 38,First,#,Hydrants,asset_replacement_value,-1,-1;emergency_asset_replacement_val "Emergency Asset Replacement Value" true true false 8 Double 8 38,First,#,Hydrants,emergency_asset_replacement_val,-1,-1;loss_in_value "Loss in Value" true true false 8 Double 8 38,First,#,Hydrants,loss_in_value,-1,-1;remaining_value "Remaining Value" true true false 8 Double 8 38,First,#,Hydrants,remaining_value,-1,-1;infrastructure_deficit__backlog "Infrastructure Deficit (Backlog)" true true false 8 Double 8 38,First,#,Hydrants,infrastructure_deficit__backlog,-1,-1;duplicate "Duplicate" true true false 2 Short 0 5,First,#,Hydrants,duplicate,-1,-1;enabled "Enabled" true true false 2 Short 0 5,First,#,Hydrants,enabled,-1,-1;ancillaryrole "AncillaryRole" true true false 2 Short 0 5,First,#,Hydrants,ancillaryrole,-1,-1;plowing_status "Plowing Status" true true false 2 Short 0 5,First,#,Hydrants,plowing_status,-1,-1;snow_plowing_status "Snow Plowing Status" true true false 50 Text 0 0,First,#,Hydrants,snow_plowing_status,0,50;tempfield "TempField" true true false 255 Text 0 0,First,#,Hydrants,tempfield,0,255;tempfield2 "TempField2" true true false 250 Text 0 0,First,#,Hydrants,tempfield2,0,250;asset_inspection_statut "Asset Inspection Statut" true true false 2 Short 0 5,First,#,Hydrants,asset_inspection_statut,-1,-1;rotate "Symbol Rotation" true true false 8 Double 1 7,First,#,Hydrants,rotate,-1,-1;created_user "created_user" false true true 255 Text 0 0,First,#,Hydrants,created_user,0,255;created_date "created_date" false true true 8 Date 0 0,First,#,Hydrants,created_date,-1,-1;last_edited_user "last_edited_user" false true true 255 Text 0 0,First,#,Hydrants,last_edited_user,0,255;last_edited_date "last_edited_date" false true true 8 Date 0 0,First,#,Hydrants,last_edited_date,-1,-1" # FeatureClassToFeatureClass Test_hydrants X:\ArcGisProjects\Editing\gis_vector.sde\gis_vector.sde.Testing hydrants_test # "globalid "GlobalID" false false false 38 GlobalID 0 0,First,#,Test_hydrants,globalid,-1,-1;asset_group "Asset Group" true true false 2 Short 0 5,First,#,Test_hydrants,asset_group,-1,-1;asset_type "Asset Type" true true false 2 Short 0 5,First,#,Test_hydrants,asset_type,-1,-1;asset_subtype "Asset Subtype" true true false 2 Short 0 5,First,#,Test_hydrants,asset_subtype,-1,-1;asset_id "Asset ID" true true false 50 Text 0 0,First,#,Test_hydrants,asset_id,0,50;serial_number "Serial Number" true true false 4 Long 0 10,First,#,Test_hydrants,serial_number,-1,-1;e_coder_serial "E-Coder Serial" true true false 8 Double 8 38,First,#,Test_hydrants,e_coder_serial,-1,-1;related_pid "Related PID" true true false 16 Text 0 0,First,#,Test_hydrants,related_pid,0,16;closest_civic_address "Closest Civic Address" true true false 50 Text 0 0,First,#,Test_hydrants,closest_civic_address,0,50;related_civic_number "Related Civic Number" true true false 50 Text 0 0,First,#,Test_hydrants,related_civic_number,0,50;related_street_name "Related Street Name" true true false 2 Short 0 5,First,#,Test_hydrants,related_street_name,-1,-1;related_street_section "Related Street Section" true true false 8 Double 8 38,First,#,Test_hydrants,related_street_section,-1,-1;geolocation "GeoLocation" true true false 2 Short 0 5,First,#,Test_hydrants,geolocation,-1,-1;grid_reference "Grid Reference" true true false 6 Text 0 0,First,#,Test_hydrants,grid_reference,0,6;installation_year "Installation Year" true true false 2 Short 0 5,First,#,Test_hydrants,installation_year,-1,-1;diameter "Diameter" true true false 2 Short 0 5,First,#,Test_hydrants,diameter,-1,-1;type "Type" true true false 65 Text 0 0,First,#,Test_hydrants,type,0,65;comments "Comments" true true false 50 Text 0 0,First,#,Test_hydrants,comments,0,50;last_maintenance_inspection_dat "Last Maintenance Inspection Date" true true false 2 Short 0 5,First,#,Test_hydrants,last_maintenance_inspection_dat,-1,-1;link_to_as_built "Link to As-Built" true true false 250 Text 0 0,First,#,Test_hydrants,link_to_as_built,0,250;link_to_ti_ins "Link to Ti-ins" true true false 250 Text 0 0,First,#,Test_hydrants,link_to_ti_ins,0,250;feature_creator "Feature Creator" true true false 150 Text 0 0,First,#,Test_hydrants,feature_creator,0,150;creation_date "Creation Date" true true false 8 Date 0 0,First,#,Test_hydrants,creation_date,-1,-1;last_editor "Last Editor" true true false 255 Text 0 0,First,#,Test_hydrants,last_editor,0,255;last_edit_date "Last Edit Date" true true false 8 Date 0 0,First,#,Test_hydrants,last_edit_date,-1,-1;jurisdiction "Jurisdiction" true true false 2 Short 0 5,First,#,Test_hydrants,jurisdiction,-1,-1;tangible_capital_asset "Tangible Capital Asset" true true false 2 Short 0 5,First,#,Test_hydrants,tangible_capital_asset,-1,-1;expected_life_years "Expected Life Years" true true false 2 Short 0 5,First,#,Test_hydrants,expected_life_years,-1,-1;end_of_life_date "End of Life Date" true true false 2 Short 0 5,First,#,Test_hydrants,end_of_life_date,-1,-1;remaining_life_years "Remaining Life Years" true true false 2 Short 0 5,First,#,Test_hydrants,remaining_life_years,-1,-1;remaining_life_percent "Remaining Life Percent" true true false 8 Double 8 38,First,#,Test_hydrants,remaining_life_percent,-1,-1;condition_rating "Condition Rating (1 to 5)" true true false 2 Short 0 5,First,#,Test_hydrants,condition_rating,-1,-1;cost_per_unit "Cost per Unit" true true false 8 Double 8 38,First,#,Test_hydrants,cost_per_unit,-1,-1;asset_replacement_value "Asset Replacement Value" true true false 8 Double 8 38,First,#,Test_hydrants,asset_replacement_value,-1,-1;emergency_asset_replacement_val "Emergency Asset Replacement Value" true true false 8 Double 8 38,First,#,Test_hydrants,emergency_asset_replacement_val,-1,-1;loss_in_value "Loss in Value" true true false 8 Double 8 38,First,#,Test_hydrants,loss_in_value,-1,-1;remaining_value "Remaining Value" true true false 8 Double 8 38,First,#,Test_hydrants,remaining_value,-1,-1;infrastructure_deficit__backlog "Infrastructure Deficit (Backlog)" true true false 8 Double 8 38,First,#,Test_hydrants,infrastructure_deficit__backlog,-1,-1;duplicate "Duplicate" true true false 2 Short 0 5,First,#,Test_hydrants,duplicate,-1,-1;enabled "Enabled" true true false 2 Short 0 5,First,#,Test_hydrants,enabled,-1,-1;ancillaryrole "AncillaryRole" true true false 2 Short 0 5,First,#,Test_hydrants,ancillaryrole,-1,-1;plowing_status "Plowing Status" true true false 2 Short 0 5,First,#,Test_hydrants,plowing_status,-1,-1;snow_plowing_status "Snow Plowing Status" true true false 50 Text 0 0,First,#,Test_hydrants,snow_plowing_status,0,50;tempfield "TempField" true true false 255 Text 0 0,First,#,Test_hydrants,tempfield,0,255;tempfield2 "TempField2" true true false 250 Text 0 0,First,#,Test_hydrants,tempfield2,0,250;asset_inspection_statut "Asset Inspection Statut" true true false 2 Short 0 5,First,#,Test_hydrants,asset_inspection_statut,-1,-1;rotate "Symbol Rotation" true true false 8 Double 1 7,First,#,Test_hydrants,rotate,-1,-1;created_user "created_user" true true false 255 Text 0 0,First,#,Test_hydrants,created_user,0,255;created_date "created_date" true true false 8 Date 0 0,First,#,Test_hydrants,created_date,-1,-1;last_edited_user "last_edited_user" true true false 255 Text 0 0,First,#,Test_hydrants,last_edited_user,0,255;last_edited_date "last_edited_date" true true false 8 Date 0 0,First,#,Test_hydrants,last_edited_date,-1,-1" # AddGlobalIDs X:\ArcGisProjects\Editing\gis_vector.sde\gis_vector.sde.Testing\gis_vector.sde.hydrants_test EnableEditorTracking X:\ArcGisProjects\Editing\gis_vector.sde\gis_vector.sde.Testing\gis_vector.sde.hydrants_test created_user created_date last_edited_user last_edited_date ADD_FIELDS "UTC (Coordinated Universal Time)" 20210910 09401600 20210910 09401600 Microsoft Windows 10 Version 10.0 (Build 19043) ; Esri ArcGIS 12.8.0.29751 hydrants_test_wms 1 -65.722116 -65.602009 47.681426 47.593273 test hydrants_test_wms Enterprise Geodatabase Feature Class dataset EPSG 6.2(9.3.0.0) 0 Simple FALSE 0 TRUE FALSE gis_vector.sde.hydrants_test 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 16 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 Installation_Year Installation Year SmallInteger 2 5 0 Diameter Diameter SmallInteger 2 5 0 Grid_Reference Grid Reference String 6 0 0 Last_Maintenance_Inspection_Dat Last Maintenance Inspection Date SmallInteger 2 5 0 E_Coder_Serial E-Coder Serial Double 8 38 8 Type Type String 65 0 0 Comments Comments String 50 0 0 Link_to_As_Built Link to As-Built String 250 0 0 GeoLocation GeoLocation SmallInteger 2 5 0 Serial_Number Serial Number Integer 4 10 0 Duplicate Duplicate 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 End_of_Life_Date End of Life Date 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 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 Loss_in_Value Loss in 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 Water - Main Valve 103 asset_group -1 COB_Asset Group Assets Group Coded Value Default value Duplicate sde SmallInteger asset_type 1 COB_Asset Type Assets Type Coded Value Default value Default value sde SmallInteger related_pid COB_Street Index Street Index Coded Value Default value Default value DBO SmallInteger To Be Determined 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 1 COB_Diameter Diameter Coded Value Default value Default value sde SmallInteger jurisdiction 1 COB_Jurisdiction Jurisdiction Coded Value Default value Default value sde SmallInteger tangible_capital_asset 1 COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger enabled 1 EnabledDomain Coded Value Default value Default value sde SmallInteger ancillaryrole AncillaryRoleDomain Coded Value Default value Default value sde SmallInteger 0 plowing_status COB_FireHydrantSnowRemoval Fire Hydrant Plowing Status Coded Value Default value Default value sde SmallInteger -1 snow_plowing_status COB_FireHydrantPlowing Fire Hydrant Snow Removal Coded Value Default value Default value sde String asset_inspection_statut COB_Asset_Inspection Asset Inspeciton Status Coded Value Default value Default value sde SmallInteger Water - Fire Hydrant - Location 104 asset_group -1 COB_Asset Group Assets Group Coded Value Default value Duplicate sde SmallInteger asset_type COB_Asset Type Assets Type Coded Value Default value Default value sde SmallInteger 1 related_pid COB_Street Index Street Index Coded Value Default value Default value DBO SmallInteger To Be Determined 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 jurisdiction 1 COB_Jurisdiction Jurisdiction Coded Value Default value Default value sde SmallInteger tangible_capital_asset 1 COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger enabled EnabledDomain Coded Value Default value Default value sde SmallInteger 1 ancillaryrole AncillaryRoleDomain Coded Value Default value Default value sde SmallInteger 0 plowing_status COB_FireHydrantSnowRemoval Fire Hydrant Plowing Status Coded Value Default value Default value sde SmallInteger 0 snow_plowing_status COB_FireHydrantPlowing Fire Hydrant Snow Removal Coded Value Default value Default value sde String asset_inspection_statut COB_Asset_Inspection Asset Inspeciton Status Coded Value Default value Default value sde SmallInteger Water - Fire Hydrant - Valve 106 asset_group -1 COB_Asset Group Assets Group Coded Value Default value Duplicate sde SmallInteger asset_type COB_Asset Type Assets Type Coded Value Default value Default value sde SmallInteger 1 related_pid COB_Street Index Street Index Coded Value Default value Default value DBO SmallInteger To Be Determined 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 jurisdiction 1 COB_Jurisdiction Jurisdiction Coded Value Default value Default value sde SmallInteger tangible_capital_asset 1 COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger enabled EnabledDomain Coded Value Default value Default value sde SmallInteger 1 ancillaryrole AncillaryRoleDomain Coded Value Default value Default value sde SmallInteger 0 plowing_status COB_FireHydrantSnowRemoval Fire Hydrant Plowing Status Coded Value Default value Default value sde SmallInteger -1 snow_plowing_status COB_FireHydrantPlowing Fire Hydrant Snow Removal Coded Value Default value Default value sde String asset_inspection_statut COB_Asset_Inspection Asset Inspeciton Status Coded Value Default value Default value sde SmallInteger Water - Lateral - Shut Off Valve 107 asset_group -1 COB_Asset Group Assets Group Coded Value Default value Duplicate sde SmallInteger asset_type COB_Asset Type Assets Type Coded Value Default value Default value sde SmallInteger 1 related_pid COB_Street Index Street Index Coded Value Default value Default value DBO SmallInteger To Be Determined 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 jurisdiction 1 COB_Jurisdiction Jurisdiction Coded Value Default value Default value sde SmallInteger tangible_capital_asset 1 COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger enabled EnabledDomain Coded Value Default value Default value sde SmallInteger 1 ancillaryrole AncillaryRoleDomain Coded Value Default value Default value sde SmallInteger 0 plowing_status COB_FireHydrantSnowRemoval Fire Hydrant Plowing Status Coded Value Default value Default value sde SmallInteger -1 snow_plowing_status COB_FireHydrantPlowing Fire Hydrant Snow Removal Coded Value Default value Default value sde String asset_inspection_statut COB_Asset_Inspection Asset Inspeciton Status Coded Value Default value Default value sde SmallInteger Water - Lateral - Meter 108 asset_group -1 COB_Asset Group Assets Group Coded Value Default value Duplicate sde SmallInteger asset_type COB_Asset Type Assets Type Coded Value Default value Default value sde SmallInteger 1 related_pid COB_Street Index Street Index Coded Value Default value Default value DBO SmallInteger To Be Determined 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 jurisdiction 1 COB_Jurisdiction Jurisdiction Coded Value Default value Default value sde SmallInteger tangible_capital_asset 1 COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger enabled EnabledDomain Coded Value Default value Default value sde SmallInteger 1 ancillaryrole AncillaryRoleDomain Coded Value Default value Default value sde SmallInteger 0 plowing_status COB_FireHydrantSnowRemoval Fire Hydrant Plowing Status Coded Value Default value Default value sde SmallInteger -1 snow_plowing_status COB_FireHydrantPlowing Fire Hydrant Snow Removal Coded Value Default value Default value sde String asset_inspection_statut COB_Asset_Inspection Asset Inspeciton Status Coded Value Default value Default value sde SmallInteger Water - Lateral - DBH 110 asset_group -1 COB_Asset Group Assets Group Coded Value Default value Duplicate sde SmallInteger asset_type 1 COB_Asset Type Assets Type Coded Value Default value Default value sde SmallInteger related_pid COB_Street Index Street Index Coded Value Default value Default value DBO SmallInteger To Be Determined 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 jurisdiction 1 COB_Jurisdiction Jurisdiction Coded Value Default value Default value sde SmallInteger tangible_capital_asset 1 COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger enabled EnabledDomain Coded Value Default value Default value sde SmallInteger 1 ancillaryrole AncillaryRoleDomain Coded Value Default value Default value sde SmallInteger 0 plowing_status COB_FireHydrantSnowRemoval Fire Hydrant Plowing Status Coded Value Default value Default value sde SmallInteger -1 snow_plowing_status COB_FireHydrantPlowing Fire Hydrant Snow Removal Coded Value Default value Default value sde String asset_inspection_statut COB_Asset_Inspection Asset Inspeciton Status Coded Value Default value Default value sde SmallInteger Water - Main Fitting - Tee 111 asset_group -1 COB_Asset Group Assets Group Coded Value Default value Duplicate sde SmallInteger asset_type 1 COB_Asset Type Assets Type Coded Value Default value Default value sde SmallInteger related_pid COB_Street Index Street Index Coded Value Default value Default value DBO SmallInteger To Be Determined 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 jurisdiction 1 COB_Jurisdiction Jurisdiction Coded Value Default value Default value sde SmallInteger tangible_capital_asset 1 COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger enabled 1 EnabledDomain Coded Value Default value Default value sde SmallInteger ancillaryrole AncillaryRoleDomain Coded Value Default value Default value sde SmallInteger 0 plowing_status COB_FireHydrantSnowRemoval Fire Hydrant Plowing Status Coded Value Default value Default value sde SmallInteger -1 snow_plowing_status COB_FireHydrantPlowing Fire Hydrant Snow Removal Coded Value Default value Default value sde String asset_inspection_statut COB_Asset_Inspection Asset Inspeciton Status Coded Value Default value Default value sde SmallInteger Enabled Enabled SmallInteger 2 5 0 AncillaryRole AncillaryRole SmallInteger 2 5 0 Plowing_Status Plowing Status SmallInteger 2 5 0 Snow_Plowing_Status Snow Plowing Status String 50 0 0 Water - Main Fitting - Elbow 112 asset_group -1 COB_Asset Group Assets Group Coded Value Default value Duplicate sde SmallInteger asset_type 1 COB_Asset Type Assets Type Coded Value Default value Default value sde SmallInteger related_pid COB_Street Index Street Index Coded Value Default value Default value DBO SmallInteger To Be Determined 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 jurisdiction 1 COB_Jurisdiction Jurisdiction Coded Value Default value Default value sde SmallInteger tangible_capital_asset 1 COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger enabled 1 EnabledDomain Coded Value Default value Default value sde SmallInteger ancillaryrole AncillaryRoleDomain Coded Value Default value Default value sde SmallInteger 0 plowing_status COB_FireHydrantSnowRemoval Fire Hydrant Plowing Status Coded Value Default value Default value sde SmallInteger -1 snow_plowing_status COB_FireHydrantPlowing Fire Hydrant Snow Removal Coded Value Default value Default value sde String asset_inspection_statut COB_Asset_Inspection Asset Inspeciton Status Coded Value Default value Default value sde SmallInteger TempField2 TempField2 String 250 0 0 Asset_Inspection_Statut Asset Inspection Statut SmallInteger 2 5 0 TempField TempField String 255 0 0 Water - Main Fitting - Union 113 asset_group -1 COB_Asset Group Assets Group Coded Value Default value Duplicate sde SmallInteger asset_type 1 COB_Asset Type Assets Type Coded Value Default value Default value sde SmallInteger related_pid To Be Determined 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 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 enabled 1 EnabledDomain Coded Value Default value Default value sde SmallInteger ancillaryrole 0 AncillaryRoleDomain Coded Value Default value Default value sde SmallInteger plowing_status 0 COB_FireHydrantSnowRemoval Fire Hydrant Plowing Status Coded Value Default value Default value sde SmallInteger snow_plowing_status COB_FireHydrantPlowing Fire Hydrant Snow Removal Coded Value Default value Default value sde String asset_inspection_statut COB_Asset_Inspection Asset Inspeciton Status Coded Value Default value Default value sde SmallInteger Rotate Symbol Rotation Double 8 7 1 Water - Main Fitting - Cap 114 asset_group -1 COB_Asset Group Assets Group Coded Value Default value Duplicate sde SmallInteger asset_type 1 COB_Asset Type Assets Type Coded Value Default value Default value sde SmallInteger related_pid To Be Determined 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 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 enabled 1 EnabledDomain Coded Value Default value Default value sde SmallInteger ancillaryrole 0 AncillaryRoleDomain Coded Value Default value Default value sde SmallInteger plowing_status 0 COB_FireHydrantSnowRemoval Fire Hydrant Plowing Status Coded Value Default value Default value sde SmallInteger snow_plowing_status COB_FireHydrantPlowing Fire Hydrant Snow Removal Coded Value Default value Default value sde String asset_inspection_statut COB_Asset_Inspection Asset Inspeciton Status Coded Value Default value Default value sde SmallInteger Water - Flushing Unit - Location 115 asset_group COB_Asset Group Assets Group Coded Value Default value Duplicate sde SmallInteger asset_type COB_Asset Type Assets Type Coded Value Default value Default value sde SmallInteger 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 jurisdiction COB_Jurisdiction Jurisdiction Coded Value Default value Default value sde SmallInteger tangible_capital_asset COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger enabled EnabledDomain Coded Value Default value Default value sde SmallInteger ancillaryrole AncillaryRoleDomain Coded Value Default value Default value sde SmallInteger plowing_status COB_Snow_Removal_Fire_Hydrant Coded Value Default value Default value sde SmallInteger snow_plowing_status COB_FireHydrantPlowing Fire Hydrant Snow Removal Coded Value Default value Default value sde String asset_inspection_statut COB_Asset_Inspection Asset Inspeciton Status Coded Value Default value Default value sde SmallInteger Water - Pressure Reducing Valve - Location 116 asset_group COB_Asset Group Assets Group Coded Value Default value Duplicate sde SmallInteger asset_type COB_Asset Type Assets Type Coded Value Default value Default value sde SmallInteger 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 jurisdiction COB_Jurisdiction Jurisdiction Coded Value Default value Default value sde SmallInteger tangible_capital_asset COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger enabled EnabledDomain Coded Value Default value Default value sde SmallInteger ancillaryrole AncillaryRoleDomain Coded Value Default value Default value sde SmallInteger plowing_status COB_Snow_Removal_Fire_Hydrant Coded Value Default value Default value sde SmallInteger snow_plowing_status COB_FireHydrantPlowing Fire Hydrant Snow Removal Coded Value Default value Default value sde String asset_inspection_statut COB_Asset_Inspection Asset Inspeciton Status Coded Value Default value Default value sde SmallInteger created_user created_user String 255 0 0 created_date created_date Date 8 0 0 last_edited_user last_edited_user String 255 0 0 last_edited_date last_edited_date Date 8 0 0 Water - Check Valve - Location 117 asset_group COB_Asset Group Assets Group Coded Value Default value Duplicate sde SmallInteger asset_type COB_Asset Type Assets Type Coded Value Default value Default value sde SmallInteger 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 jurisdiction COB_Jurisdiction Jurisdiction Coded Value Default value Default value sde SmallInteger tangible_capital_asset COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger enabled EnabledDomain Coded Value Default value Default value sde SmallInteger ancillaryrole AncillaryRoleDomain Coded Value Default value Default value sde SmallInteger plowing_status COB_Snow_Removal_Fire_Hydrant Coded Value Default value Default value sde SmallInteger snow_plowing_status COB_FireHydrantPlowing Fire Hydrant Snow Removal Coded Value Default value Default value sde String asset_inspection_statut COB_Asset_Inspection Asset Inspeciton Status Coded Value Default value Default value sde SmallInteger 20210910 /9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwDi9Rjb 7fIpTcuDkjsKoiJYiHEcu1ifmTA4HtxXURWc39oN5+x4QOMgZ/MCud1aCT7XcRiSRl3EIuc/TrXN bQ3otRV4/Fftfpp17/5rUSS0VkT5EViRnzXGRjpwRz9KheERpIn2iNVLfdCEfL6DHHrSsjq4J2EY 7n8M4/ClghdgDG2d/UIOnqanR7HW04pe0vZO3bRr87PXXyZCC0T/ACzNmPoVTjHtir82qSyXInW3 keQptE2ePoaz5oJYHkVUkVyu4L0/z0pyqzSIzbFAGdrHOTT9B0oKSTqa/f3s7X02/QSS/ae4S7e3 O4gDOeeMDB5+lT3flCKSKKPLEhuFAwvccH8PwNbGk6BHq1gGRu589OF2EdNpPWqmu6eun3UdskrF VTkEgt6HOPpVbbozvGXwy6J6aWurS0sld9+3cWO5gs7Sxjt7mRJSf37Mm0KD2zjP64rVsLjVrvVE bTL+ViB9xXJ2qPXtj865SO2WKYpKXOfU+oz2q7pd5cadMZI5XiJyp+lUp2dzP2KmuR30/Bpa302d tNdEj0DxDrX2fw/ejUXtpJiwCR+ZudXwPbivM/MP2aOeM5nik3iQknoeMZ6dP1qymmtf6rM3nRrE VJkMzHKg+nvUl3ZrZjEcqzL93ewxuGAcfzFOVTW5nToXbjLR+d9Nnf7vw87GlbX8epWhc4DdHXup qhI0ls/3gykYxms1ZHgkW7QbQTyPUYzitBwkqiReVcZBrSEkZtuWj3X9X+ZWZlkG3JX2NMEThh3F Iw+bpT45CvBPFdC20M/UnCgLVeVSTwPyqfzFI7VG8gweKEDKrcnnrSDpQeXp4GetaPYy3ZJDEWfA 9M1OZ5bQZOClOiAUZBqlfzh22L0FZr3pWKeiK81w88mTyalRvLXadueuagQcbulKxJNavsQTiTJz mh5Ow61CCaVeX5pco+a+g8Ak8nipVCqc1GzZGBTkG6k9hdSYzEHP9KUXDAVFjccDrS425yee1Z2R oTxzLEOeWPJoa7ZjsjBGajitpbhiI4ncgZYqM4FdHo/h4x/6XcFenyD7wH19KznUhHV7mkISkzM/ syWONWmfZIw3CNgQxH4jFQQ27XBIUE4xkZAPPpnrW5qFwJ5iJQxRSVG7kD6UxtPiimhtoJVa3I3s z9h3OaxVaVtTR049ChdW48xYozuZEyyN8rAn09e1QxxtI6pGrMzHADDBqS/lFxqDNA2BwFDnkYGO DUOSp5YkjnD8H8DXK+7OeVuYH2l2Rl+YcEEcg+tWLea6SPY0g+U4GYN5x9RUL37eUY3iWTsofhl+ hFaNhrV1pdsIDaRvk7wZotx5989OKq2mpUY3dkak10LWJpZD1y2PQVyF5dG6uTJI/wDrG3fL/D+F ad5ctdRv50gUO+TnuB0ArFEblvlZkGScIhwPxrTZI6qFrOTfbrbqt9Vo/wCu49pCzYyWIbGNvY1r aJdRWEnnyRkRshjKvjk9c/pVKGxmupfIhjkZnbaCSF3Zq1q+hXemRLb3afvDhlCSbioz1P4elQ7b GznBq9r2V/PST06208/MdrV3FfXaTK0ISOLawBOOvGaxjIXYqpj3DlSozmrv2GF3jcMVJXLLnH8q i+w2sJyIxkd6pNPqcyxDjBe7o/XXv+j8h0d1cwwmQSupLYby2Az71At2810ZJAzTHO5mPUnnitER wtChARUGevb8ahLRNyJE+XIAzz6Z/WktdGhTxT5uan973vvv+pWnkAkRVjyoPVhk+1MYOJSY9obO cjoc9qsTMkgk+VunGV6ipbW9lS2aPaGC9Vx7cH1qkrDjWnVV76qz2103/DXXsbMXh7fpgvIZAzXA +8Dwp9DWM2kJYrJNfyyM8GC6FhnDEDj16ippNRSPSpITZEZxiVXIG7HuKWGW61WxTTFijlkDHYoY fMSCTkn1+tNPZs1avKUFHRX1tdrf87b9LaGMyiZCmGGD1zxgdK1bBC1t5bgbT/qz6e1VptNuY0RU t3Qbf3aAH5j3H5/zpLeW5ilS2YNCq5DGRehHp/8AXpc+tjOdGSanHsr+b20tf89fwJZo9mRiqbKe 3FavnQ3CAyMFm7jHDe4IqpcReUTxXZTkmYyXUqruUcc0FsipI0dx8oJPoKmWz5zKNi+hrS6M7Mol gvzDn1p+c1YuZLXymjQrn/ZFUBNt7dKpaonZlmaTyYsDqelUkHmNj86WaQyNk/hTouBgd+tUlyoT d2TSRgr8o6CoCCOxroo9Eul0w3hiKwgdT3rBdsnHNZwnzbFTjYQDihcZzSUAH72OM1oQlqO5zUqn C1Du59acHqWh7Mm7A9xUZY7smjJpDk1NizV03WFsYWj8s7mbJkU84xwMVsafqgkfET7WI6JwSfcV x5OKlgmaKVJFJBU54rGph1LVGsarWh0hhaSeeSQhSo3bkGccdxTVnSKGZ0fKvHsBUcE8HkdqL+WK WPzIJt0rRqzEDBAPY1nO7t8vDY4ynDflXJJ2jqVJ2GsWZBvUHvuHIpyr+7XnKk9GGRTQjA+YpLY6 heCPqKmVwyDaOe7Lzj6isr3RhYrOmFzIQo/utyPwNTi4uWUA78INqhj0HpzVe5nxKD8roOAfU9/8 K1rbTFlt0dwwYjJ+YinJ2Wp1YSaptzfTyT38n/SKcrMqICueTimrJJxjZjPTcP6ZqZy21sIp+YdT 7VJA7kBWlVTzwEzn9a0k30OWyLel6rcaZqHnG2jZcD5miLEEZ6Zx6irut67ea39nmMCxyxgjPlgA qen8R96ig06W/DP9oZcDJ3YAPoKRdFLWzTtK7NknbuOMD6Vim7WNYSlHZaamHcWk5dGaUAjqN+M+ 3AFUpYI0LF7gHj7vJ/ma2LmxbarJAMA9SKqTW7RRCULhD3HQ1rTkZuL5b20K0HkrnJdgBwVjHB/K nFozINkUxUfey/r360qSHfjbQxPnknOGA5/E5/nWlm3ci5ZWCJ49/kKxAxtPX9BVWaKRWV3DIU4C qcjHbNWhvjCsMH6Hg1clkSS12Mqhm7AdfapScWOL1Mh7rzA0UgAK4B44Ye3/ANfNPs7MTXSsJTZu RuLohboRgEDnoPWo5IUijXJYzjJAx19D9K17HS7+90m5nslKyRHL/vACf90fTvU2sem6yqJrR79d dbvdrvo7WT+dxq+ddxuTcOs8R3rM0hwwHTr61e/s+TX7u3XVb0WUhA2usIJYepOev1Fc/cWd1pzr Fcb2d4vMCk8J1xz+B4qT+076R0TepiUBiVwTmqi1s0JyqSbnGe9r+V9bbJaW6W7GzNoWkw3UttZ6 pLLIFbeZoDjIGeMYx3qheWTRRvA7b3hbG8DG5T0P9K1bfW4ZraMSxksBhlH3pfb8afq9m4ha+DBA jKro52k57fStlZK8TllzKb53fz7+Zk6dbpGdx5J/SsrVrtp75oUOEQ4OO5q0Zp4i4RyEAzuAxWLA SwLtkseSTW9JdTOo+hqQWcUkQ4Gccmo5tNQchmqWxm52E9elXGPO09aTlJMSimc5LEY2ZT606Lgq R1Bq/qFsWG9R061nIcNj1reMuaJk1Znodn4ihvNGa1laKOTZtO/owrirsRLKRHyPX1pI1ZkwDior hSmAfWsadNRlobTk2iLdk4H41ISAoqIHHSk3npW9rmWxKGzS4qNWwamAzSeghOn0o6UuM03kUh6j WpM4pT1pvXiqSHc1Y7tZLaNZIVcrxuBwQP8AP0p2/wAuYlQXGDgEYYVUtIjKr4jD7F3Yzgj3FTsS 7BAd3s3DCvLxCSlyo0buiferRAj5nPUAbWFIJUZVjwTIe4+Vx/jSMokjCMckcgNwRUEZRpmWbIYc Lu6/nWVkQyVlBnYbgzAZJ5DD6jvWxb3lw1pC0Wx1KA/fwV9ulYTkjczJu44JbBI6U+fTlmdXQqFK jG4kUnyr4jtp0as4KFKLk92l/X9XNSS3LXE5xtRG4JHv0pZLC5itxM0TBTzn0HrW158UjmEoMo4y MdfQn2pL6c3SvC95HBGODFj5lHp9K1scnKkZZu2jiBYAxhcbc4p6a6IYQiKsgJG4E/Wo7ezF7fxQ Bt8YDN6ZAIAP61oQ6BbhY1JZnMJ3KMYBGP8AE1EIX2GlK10ZOp6hK+IxGFjJzkd6zpL1wghRiI8Z 2ZzzVm7QhI1Y7mwPump9NgmihLQWi3EjsFVT17npWkFEzbetyhbxXKWIv3gHkeZs5PJ/D8K2La1u tfuIEkiW0hSNvLO377YB/kK17eGNpsTQKZHQOiZ7jg8e3H51S1CPUFvDdxkW1tHIiIN2OWJXOPqa 3lTaZUbF3UbC3s7G18tQp4SQ5ABPrVZrKYReeIQUZ9g5BNU5ZLm7ikhurkOidB2Lc81Cl1NBYLEL 35A+ducYNZSVpeR28tOVCyXvX7Pr53t+Ay88r+0Fji2hSPmLdCe4/XP51oxaHqTwM0MsanrhSQSD WKYDcRMXzuUlkYOvX3PU1aXxRf2tpEpnZlhZOB0xu6GkuXqcqg7tPf7tijcSS2t9NFO3mYQL82e3 /wCupbu+Qfvbaxt1V12hQDtX1NV57yTVbr7bHbHBY7lJxxnPen3V/OlkyTLEkYYFAvbjFSu/UunT ndx5tH218xZbhglvOPKW4jwzlWA3L2AHtW1pthL4vu2a5vVijXlU6E4Hy/qRXGhhJkpMvGASq59u DVqCaSydvLlx5u3ZyR+P04x+NJs6oKUI+zk1dq2601em9rO2r037b9FbNCzNptzaLM43hZVJyM+3 tg/nXHwDEI/Ku18MT6a+rRXVwWtQqurNKOrEdvz/AJVxczLDfXMSOHjWVgrDoRniunCOTTTOfEJK MFZJpa99+vZmhZKjAEH5h1p087ic5+lVLZ8TKc4FLM7GQknPNdNtdTmuWTcgpg1mSkCUlelWM5HS oZRxVQSTFLVE0UrKAR3qS4hcw72IqCI5UZ9a3ontm0OeOWMvKHG0qeRkVE3yu5cVzI5xAMdeaTbz 1qSRSONuOetMYZNbJmbVhVUZzmrSoWXIBP0qnyK2LN1awbB+ZOTWGIqezjzWuEVcoE9qjyc1pXqI YY5cBZG6joSOx/nWcwzinRqKcVIclqJTT1p+3AqW3sZrqMyIVABwATgn6Vo5KOrBK4tm374KSQH+ XIOKvXUJSdoHJMkZwQeGFUbaFlnXzV+UHketabmG6PmI2HJ5ViT/APXFedi7c6aLexA7hgVC7sdn 6iqqwrLulEuSMfu261YuEcKcjIXr3/X/ABqbT9PWZSWYMB1jLYYD2rFSSRVKDm7vZb/5er6EQjV7 iNEfe5zhQO/t+v5Ul6J/NUFTkIODnjk9KJZH+0bUBCrwiOeQPY1J5hP3pJAfRlzVN26GksRNv3Xa 3/AX6HY+INYtL3WYLrT7I28bR4aPCg598Vn6pEklqJ2RhKnIbGPl7g1SvHa2tzEuHuYcB9vfPeqp u3jKbpVMoRchxkKfaqte92Zpxi9VdFzRtRNnfLcrbSXCgMhRBnrkdRnuKlu/EMt1CsCxPbfPI27d j5XJJFZcdzdQSi4hum8wP5m1V4zu3Y/Otqxu4tRsZrGa3dryQMqkKBxzjk9OKmLS2ZrGpBx5FH77 9vXqV7+xne1tJ5ZoCsiDb5ZJOAM81l6ffTLcxIJjFH5mN3Xb26VoWemz26zvNbhAoKAlsdTXPv5l vfTRsyx4bgdetNLmehEqsuyXyXa39eeu529tozX2rMILqaaQA4lU7Tt4zx2rSk8OC409mS3Mdwjl GaSQ5yD1weO/6GuR0LVrm1vH2XkwMgwpiXJz+Oa7A3sj6YEmN1JLIhk379oALkk4yOc/zqoqK0mx +3qS203/AB3OdlsRaz2kTsJEdissm3lhkHIB6cZpdft9G0/S5LeyujK5lyZXIzt9M8e1ReLdl1p9 tcJCI2jkwWLkk5HpmuUDmTcuI9393b27/SjmVtNioU/aS5W9f8lp+Vi19riSBEEjsuN2wAn8akWK acvsjYErk5AOcc4/ED9BVKOT94jZ3FVIUKpyfTmrAeVVI2tgsMMeDnj+tFmZSnFvnjvp0SGGacSK qRszbsn94Nq/T1/Cms1zJbh225fPyY3Z59KbcKlzKqp0wrggYx1yB7f41ZjeSF8NMrxrkLuH3c9u fxo5VrodMZu8Zxlq97aP8lr536lIRPBGdzMwwGKhMD6dKmba7MRFt3L8yHuPQGrFu0DBsu2Rndhh jHtiqlzN5CN5ZzzhaapOozeNdULtLpp5fi/O62faxLJCbXT4rwsXydjD+6QScD8D1rHMnmSlhxk1 NazkTtHOxaOYbH9vQ/gafJZPZXDwyqRIvFd8IKnoeZKTk7j4244pxY1EpINPPrmmSKWIFI/+rzSM 3HvTMllOTVIQ6Fq0Y5V9CPXFZKOFfAIq2kjLyMUqkblQZacBlPH51ntw3Aqx+8fqRk1G8ZDY9OtK Gg5akQznmnrI0ZyjEH2ppBHejaTVtJ7mew8u8jbnYsfU07NM6Cte20yL7NHJI5MrDdtHYdqznKNN alpNmWQSpI5xWlpVuZ7Z8KSVfH0zSXbypGsO0MHYL8o549qvWMaQw+b5gKJ3Q4b8R3rmnVUoGkY2 Yl4n2Z3S0ijeJGG91HzEntVYtFcOR91hnaTwadBM/neaVEka5Y7eD9SO9XJEsp4V2FWlYEsegQe/ vXA23qwjF1JWRjxMI5Cr5aR2IG717+lJ5UYkMiTASdyM4H+FOltZY5W3Sb0I4ZRyAe4/Ko9si4bm QLzuUYI+tXp1O2nKHuwpuz9Hu93dP7unle4A3Jk2y7WT+HcP5GrIYoAGmkQ/3SmcfjVSOR2iRpm+ UknkYz6VdUxAY850/wBn/wDXVLVHHXgqc7Lsn9+ps2McIuXiePy5ZB+8UtnPoRWZfq0OrXA+UKSG XA7Vevn84LPbwFGQBlbp0pupAs0N3GQwlUd+3/66NeUiWq0IMyumAznPomKbbF4rkMd6kqQCW75H 9AanzKy43oM+1IsZLAu+4qc9KzWxBbgkDviRgTtOC2TzWDqFkyXpIYqdoYkrjFa8nEJbn6imqYrp GE6lpVHynrla0heOoX6GXayLGdxnfIYcqemeK0rnU3ES+SgD7iGIyfzzVMW5ify8hN7EDvipSFZv LMhXcRk/j/8AX/Wqkru4k2ie71AXlqkZiIwyliQBiktfC17fyvJF86j722luLWWS3mlijxGgw+fW tjRNWkgaSNbxbeAgO7MOTgdBWcro6aFaUXZ+vzRnDwxdWMkccVwhuc7irD7nNaEug3g0X7e8mWjb cq4HXP8Aj/Orz3SS3S3fmkmVdw3kZAH0q/q+s6faeHGdPKneRiGCt2BJBP5CtI2fxGilN6Q1+S8/ Lz/qx5/DbxJt2SAzldxUe3/1sj8qv2ei2t9p00ylQAej4BHPvVW1C3EibWRZGZVCgc4+v5flVeTz LddkuHAJYMAeCeo/CpdrWbNaCek07PrslZflst+pnFfJicRyCL5ipPUsM4p81r5seAfpVj7PcXSi cWf7tD87Y4pV3EnarMSScKvrXRRlZaGFVLmce1vy9EYTxSRtyCCPStme+j1PTkklb/Toflb/AG17 GpBp2oXgHkWr4PdsAfrVObTJ9OvQt4iL6gODmumc+aN+qMFHW1wTTb2RA4QBW6HNa0PhSf7KJruZ 40O7DIAcY5P9aqpqNzFAqfOgUYXC849c1p6hHf29yobzDBLGSFZiVGRjIz35rieIqXfY9FYShKnD ln7z+537dfv/AOHyZ/D12lqLqFhcW+M7l4OM46fgagj0q7Ynbaue/SupttWs7VLmyureVVk+40ZI CDGcAH6k/jUsF4qXsF1b+WqpafMkhyrHB7ep4rRYiSOeWFaipR1/TRX9Pmcdqelz6dDbTyK22UZ5 XG0+lV0c13mpWkms+GIgi5mjYnaDx9BXnrK8MrRuCGU4INdOHqKpE5akeRl+J2YEDr60/YwRiVOT 3pmmlWu41flSRnmt+6gVY8BMbuAPQ0qk+SVioq6uc0eDzSgZFX3siW5X9KfbadJcy+XEhbHJC1ft I2uRyPYp2ls1zcpGO5rtGtog6bTiNFIAz2ArARBbuI7UBpjwzdh61px3cMMkgnb5o13Ipb5Tn/6+ a8+vU9pPyRtBKKsQXIgSMXc0YWZs+TGOuPU1z8rS/aRcAnzmbOxcDaO31qxqFzLdzPPnhjt4BBx6 Cq5iBeRTI5YAEAduMZNRzXN5JUlaUbt/d8vM0raZ7qKW38td4UFGAwxz1qSKHzF2siSKvLfNhiem KyrWOaJJHWUKY8lju59OPerSSRs+N2115HODUNJPQzqVUm1FWvv/AJehpWNsoMibWkJHIP3h/jUk 8atCse4KF5wRhhUMd6GgVHJ4I/ep1HNWJ7VLxfPiuTckfwtwwFT6mKfWJjzW0kU5k8wso5wfSrEU CXCeZLL5bHovoKhYu9x5Zywj6qepNWzLCfvYz/tcVpFtIjrqbultZvKbeYu285UgYwfSrF1pttGr 2wB2OC8eT0P/AOusJGZX3KSGHII7Vpefc3kSyGY74m6Hofb8akqElazKcBUrtZRvX5WHvSbepAHv ntU13GsJ+0xEGJ1ySO3/AOqqizoR1Zv91Sc1FmiXGzsOmAEZJzUMLn5sABlH506aQlGUxNyPYfzq lExJKs0a4HVnramuZNEvyNGOCKRDPHhz91g3VCaozrucqy7WP3WB49etPiuntSTHLHlupVC35Gkl Es0YaS4TBfBUYVh3z0zimou+gNXRIl3N5RtmJyeh/vVJZPApj+2xF4wh+VTjkVVa0XCM7Egd97DH 0pilckL5K4PB25NW431BXOtl/sVLKP7PcWsbsSxVxuO3jj1z/jXJyrDJdv5azEPIVZwPlEZPYY9B 3NQPcxSMCLn96pI2bcAj61ZxHMhLvJ5o/wCWbuAMfnUSi46s39vJR5Vt/X9Lt0LIhigv7WJQskh5 BXO4gZ/pisi8mmEcUUhJjVjhWXqx4zWrpKw7pZCirsQsWAJIHI/rU+oPFaWpiRxL5xA3GIKBj03G hrqbQqzhD2atrZ9P6+/0M21uLiJzblSYxjD+/vVo3lyuQGQf8AHH+eKooXnupDaWzO0jfcHPTvmr EmccjFa0l0NMRq02tf8AgsjlubuTINy6j0Q7R+lZF9CWO9nJY9ycmtF3AbFUbxtzKldVNWOOWxvt qlvcafaIkJS4VNrSHBB47Cob25vbq3tTOGdbdD5bMduQxGOvX+lS6Bp8l/ItssrBNhLKxJUHtxUt 3YTQK8crBUx8km7gEHnivNm0pM9Gk24RjL4uml9H0S73vv8AgUYtQvJNQMjxR3sgOFD5bGACM4x2 4rPa5lSF0e4lCyEq6ryMZyBwfpU9u586O5tZ3tihZQd2Tx6nuSeKrzedp0skYkxI6iRt/B5JPJ9a FZf1+prUk5Pmaun0vp5JRTT7K99LP5bOmX1xp+zbcmF1xmORcNk+zDmsvxPaXEGqedcXMdw9wvmb 0I/XHANTpcT3DG4kzI7hdjKcnj2I5FXNUjjvfDTSyllurQjYrYGVPUAYz15rfDzUKnqc2IhKpTvL ePla66evTz1XQ5i3kMUykdiDXa2xhuIH824jILAgye4BAHuK4UMdvBwa6XTQ7aEjyYcGRhjbyeB3 rpxqtFSOCnKyaNOVNMjcI7u5PBMY6fjW9Zx6dDaD+z4jMUUll53N71x9pbz3chFvImR1SU4xWtZ6 kNNt5od6rNIMM+Og/wBn1+tefzTe5rCb6oyb7Pnv5aMhzgqOxqurOCTLkk4GQMjAqw8yszbeh6nu aUs2AkS9RksoyR+FQnchRc37o24cKI/skiMpOCCMgH1xSWds7zOu/wC+w3yleAfTmqyxJMFIDxsw 5kxy3v8ASrXm3ds0axtmFG43DKn3NaXtsaOfIuXf8tV27+ZcGlyB/Kt7lR5WSS4BGM5/OqkkLQXZ 847ZXA3ZAwe45/pVxUYsJkQHngc4q9DPDdzql1F5gB+ZsY4xzn1qU5dGL2jlHkf9f5bmO1vLCnyg sAejD+tJLJkJGsbRSngA8H61s3jpYSSPbOpiJ4ifkA+g7iqK25lVrq9wJpfuow+VV7YNJbambjYr qPLHluA6jpnrTwluRk3QQ/3ZByKZ5TqflZXA7Mf5GlEijh1ZT6YzTWpN2Izvu+Xc2RzlsUW9xJHK XAjxyCrEsDUZRgF4APfNKMqMCRSD0wc1clbYlbm5a4IMUmPJnOVKrgI3/wBest7f7NcPFK0irk7N rYAqxay+agi3ll6cL71aurV7qBllyLiPkn+8OzVma/EtDn540aTPLj3YmoJyPJKbQM9ML71fly8k eEC44YFu9V5BksWMYJ7emK2i7GRXtg8AKgsVbt1//VVg7y6kRlmIyd2Tg/5NSLIuz/W/N/silVHl OI0lYjmqc7hcidJZGJPJ9wKQRhV2vNtyOSD0qZ4mgbDxbQRj5j1qJmCggmJc8c01J9AvqZ82ksv3 ZVfPTg9M0ttLLYsFmid4hnjOCPcGtRnIMY8zzE4z5YzgUy/spY2Bj8ySEgZ44PPSr9u5aTV0LUuR S26ac97E2Q6PEUblsnHWs+e7E86pgxqOWwmBT7eGMWDwMGRgS2Byc5H+FRkOrptVyrLghhgZ9qzb XQ6owXNBd7f1p/w5VthKJo5IGnOWJyhwOtX3dio3DnHrVFZHjlPASOFcY3ctV44ZQcYBHSnQ1dzp xMYxsl08v62aa9StKPlLVQBzcBmPetGQhlKjpWbtw5U12LVOxxPc77w5CsNmZOQXPBB5xV65tbaV RFcBnjcsAF6hiOCfapfDunCXwza3KsZbiQFUjHQe1RXztb6XMQEEiYbex6Y7V5MlKMrnVHllLVWX 4fqcrq/hmXQ7WJ5WRfMkLLEjcjjNZV1fS6m63U2JmVeCRyQD/ganv9Ru9Tu43u5EdYSyhuoGOw+u BVZGRYPLkQqy4Xl8L6mrlo7/AKndRjCpG1rafy+jX43Wu9je0q8Mdo0SwgyjkDZnj61c02I6hqtw sgRsxcjb045FZGnXUbSBYn3BlPXjgV23gGGF9XvXcgjygqg9+ef6UlrLY4pOVOo4p7r13R5Zqulz 6RfNbT46blI6Fe1b+jIP+EejmSTdtuWR4u/IBBH41v8AxR0Yosd9Gvyo2Djsrf8A1x+teawTPDMj IxG05HPevUcfrFCz3OJrlnY65YftbsYlJA64GCKrM2XkDtGyxjDB+w9Aa1riZpdIgktx5cpizJIv cZ71zcMckkuJQwhByZOx9zXlKL2On2F0nF6dfL9beZelure2t0EMqukqAkOMbDn1q9ZJ8yFJCgZd rbT1z2rCSFhIxZN+4/KB91s/0rUgZtPthHHy+7jHr7e1OSUSJSXL7m34/fbr2NbUdPtxEh3MjYON nQfWs4NKqANyTwWHNRre7iPPdsKOh71ZWRWnMkOdmBRb3b2Mm7jIogxCRuVJODjp+Vamj366I009 1AJGlVY42C5CjOTn3rMuY1W5PlEr3D560XdzIlqqSoCc7A6jmhahF2eg+8ml1S8a9igWO2VvlAHy 5oN60vlie3OzcN5HQj09q1NPt9PvNMvVtS8U0aBlCnBJx82RWQbfybISM7uxIGQ2cfUUNjd9xlwu y6KxEIuM7c5A9qPM/vwsT6r0qJURm3q2CepWngyqMYU++cVNrme457VjLEEgAZlB5NST28kIEe+N GxyQM4qpZ3czW+1BLwSA+4Aqvp14qTyVb70IfPXzHyf61tJu9mJuxZFxFBCi/aY1C46EDp9anj1C 0O2Vbl3lHYKWHuDgdKpJboFzHDBGOhAGf8Klg85ZQu8Kp67VA4/GsropTsafizwtLo1ta6l5kcsV wAwReOCM5z3Fc7BZXN0GMSRLgAjL5z+lbSu+42k0rTQsP3W85A9vaqFtaOuoNaSSmIlP3II4z6Gt L6aA49Qgtp5XxNcxRYHGxBk89Kg1mzvbG6jV5LkIyZDIRz6dO1TS27Qt5cgQOR9/kgn2pHabaCGY gAAn0xwf6UkwjLl1sZ8bvbSBryHzwAG8uV+3qDWpYf2bqjR/ZNLlNyTnarDb+YrPv9xs7VTCksjM ZCWGTg9Bn6Gr2n3MWneXJaMvmkZk59eook7nQ3TdNSat0/Lv+nkaRuUsla2eCKMsdnynp9fXmqV8 tyNDgkM2I0l2MABnGcfn1ptzIJrVljhwxbft6557dxVtbOx1JSFeVSesTOQOfbPrUtpWbOe5mX0c K285t5XDLsCc8t1z/Os223p80hdggPDNnrWzd6fE0/2UNGNmdwJPtj+Z/Ks57FIppEt/nIIBA4Br RtNWOvDJJ8zkl+fe60/W72IhBHIxjEhZm6kpg+vrU03yLgVYjjMMByoQk/d6Y9ao3Mp3bFxuPP0F dNKOmhm3pd/5EUkgTg9fSoFTLbjUiRc5OfxpeAa6NjM7bQdU8iwt7W3XBVRIGzjHr+tWdVurf7Os MsRmeU722eg7Y+uOa5K01T7OLcRxEyR/LnOAc+9bWp3V1qERMFtAJuOQ53D2U9h+ea8qopKbcjWN paN2Oc1ixNjfspi2xzIssahs89+ntj86atiFupGuEXAUHb/e7nn8RV3UrfU1tUuLqePbExEYxkkH jH6D8qyo7VrsI3nBlYg+WM5B/POOP0qlqtDohUUFbf0svz1e7W2mjvY09GhN9ehI2VX5IBIztHYf hXceGENlfvHbqzurLIEyCSp4bp6cH8Kx7Rk1Oz0+GVorVbPcqtbwncc9dxJ5roLe3/sTUvNiuPtl yIfvSDK7T2296UZRTFUakrt+8vnf531vrrqW/Gdxpr2r2ssxkmdSskaDOPrXiTQQW8hE8xLjqiL0 +pNeqakk8zkzYAc7jsXCn6D0rynVI2TU7lW6iRv513YKd5uJx1buzZvQXs7aescMmyH7uGwSR6U+ a1C2Jaz1A7F/1qyrjbnuPWqmmRJNppLHLr92tOxmgnVoZNqPMwDhvuMB6965aulWUTejOXNFX033 t+PQyNPultYiJDukBO1uqAdz7f8A16mt5cS+fcS4LLlVYYxmrl9aJDeTxRrH9kA4G7C+4HOe+fan 2em2l58st0qzDlovu47Ag++M96i3U1fs3HVa2er02XZX+T0u9X5VtwmvFiIxGOS38qsTgwRhxIGJ xhexqle2J0+cQxyGbjO1z0FTi0ma1WUApBFnDdBk84odrWuY/V+dXprrbX+rF20uY7gCKfKDOA+M 4P19Kc0UktwsQXItgWOPU/8A1qW31O7l06TT0tYI0IXzHC5IA5601Ua0m3W0oYZ5B5Gfr2qFs2Yy hyO0tyzsWYZ+eOQD76cMP8arvHLaMNzmSNuNwHP4ip31KJpF8xDFKPU5yPrUM0qzXTKGLIOQB0qU 3azJZC6ROweLg92U9/pSfvx0VG984qedU2RqPvEE7wcfhUDeYGIAVvc8U0JkET/Znk86MoGbOVGV q1uSUCSORWB9O1M2y4yZBnv8tN+xo5Lh3WTHUHFbNJ6k6MuRfNGR+ucUwFcn5sH61Baou5oJ+ZBy rZI3CrUUEe4nYPyrGStoFioLhBKYWkwG5U9cGrc/majablbE8XPvkd6gni/fjjHcEVaQucSxjLRj 58dxW0dUVDrFliBlv9N8ydgSPlkx1Vh3FYd1b3FtdCNmkZXPynPUfhU532OqxTRybbeRhvPbHvU1 zMbK+eMSebhleJW5C5roUUtkYyunYq6jby6elv5wYM4LELjOPeqsExDqGLeUR1HX8auyOJbtDdEt 5pO4uf8AOKSayk8kCJhtXjYSK59Op1wqLlcHs/6/4cd5kcLR+Yzqn8LY4zTliaW8QQkCZjmOQNwB 6YqkXluIVtkRmG8KeOmeOtdFpWkmzV7i5Khwm1VznaKmUklpuCoqF3Jp9rP119NPUZFa3N5dtOki FtwV8BlG4ZGMj6VljT7hLm4FxIInV92OTn8avWesy2tnJbxMzCSUSgqvIZlB/rU1rPbvbSzXTf6Q 5OdwyeBTlfYqmlaT8vzMm6mVI0XGCq4J9TWWMvNuPpird9t85cZ29yfWonGJgB6dq74WSE10F28V CsZLYqaR1jHJyfTPJpkUkjeblAuzlh3AqZVFETVlzdDRstISW3MszmP+43amLdTWbeVHIuGPDBeM Y71OXlOngeTw4HzA8jHTislo5WIwCiuw3EnqOuPauGT55Ntm9HktzWvbWzva2nYv3FxFcBlvZmZg N6RgcF/Qn2Hf2q5osllHdtPHI9vOrFVYkEEdOOMZrnnUqzGE/eGCSfft7EGiIRxx7AWKxv8AKxb7 xP8ATNS4u3YtqDTjT/pq/wB6Su720vY7fTWEbuOWBkPzEdRWjb2/2udX3Mgyc4PNcNaX8sRCosiO T94E4xW3pd1cXjNFKwGT8rjggiotZ3MpwcUnumdHeaql5fCzs3VktlZQuCDnoTn0rzXxTavb6xI0 ilTIA1eh21sLU56tJwT7muc8eWReKC828geWxFdeGqWrJvqZ1I3jc5jSZdvyhiArZIz1FW5ZvNtZ CYQRg5ZTwaytPkWK7XcMqeDWt5gWaWHny2HCDkGqxdNKtc1oJOMZLdPy7ab6dytGks8MaGVyqfMq EfX/AOvSQXjPElm4KZYYGeoHQn2qZVHmgRRkqwALZ5zUdsiXFwk8kZ2KuGPbAOB+PtWGqN2qbja6 Tej3s1fv0W2wGSTh3DFgdmWYnzP881tDVzBZQ6XdWxREPmsM/MxPT6CoZbiBpN/lLiTiMJ/AR3rO uN4mdwfMZ/vMw5o5YsznecFbSK62627b9l+PU6P7G/2ZBbRs833yqngDOeBWYNQ2KWnRkLsTntnN NsNYurAeWrFhIu3k5K/T04zUgkikibBU47H+VQ1bQznOUYpP3l/Wie+l9V3CILK7yldyHPy+vp/j Vd3ls5cQMQMcqakTc9tHJEoQq3AHpnn/AD7UkNw0U6rLGTvbOcZ3elCM1CnL4HZ+fyJWvDlUnUpl cgHpUodsDpUSILu9ja5KxxMxzk8BR2qWc2skzOsciqxyqxngD/PP40rIzlCUXqOPXHepI2CnnmqU t0yDMcW9uwXcf6U9WuHYblIz6ADH5k/yrZp2uZ2NA2i3EJc/LtOVYHkVCtzc2sirPAzqRw8Yzn8O 1NWO6a1mxJwvON/+AFILdiwLyZ9sZ/mTWT03K2K9zeRSzn96EbGSrfKf1p1vetasXViykfwgmo72 zgDguckj2H8sVnPHGpZIpkAIztb5vy9K2glJaEPc2I5Ib1HtxyjDeuf4TWcLlbS6ihuYPMMbbVO4 g49Pel04Os6K3miT/llsX5HI7cgVsT6bb6tEZVDpPHgMp7MOQK1clHQFBta7iHUYVdSLOLcn3TIc 4/WoJNUlkbcPJ/3UUH+lSC4sVt/KjsohL/EZFLFT+X9ahW4BUruQLngIgU/qa5uVdinfYs26PPGz bJhk5KouAcdzzirBt53QEQnghiXYDgc9vpVKKeZX/cmUg9VPGfyFSzfazaO+yRVZG5ZiwA/76/pT Q7lANOYpCkaiEScEjGeo4PtirIcSwk4yoO0YHfuapGBiQ8cDEFdwbg578fnWzZWsjWUTMxL8nHp6 /jWkVeR0wTjTTfX9Pw7lK7tN1qzgbVUZAPU/WsxHLuWC5K4G315rf1ErHpsjsT04BrK0mzkuZ1iT HmhTIVbjPTp6mtnLlhcmTtsWjoYZTMjZYrkMeQfUCs0pJbFWkVggbAG3O7611scsVsiQyxtFLkd8 g5HX27dcVpTrpVnaD7Rs80nLoELfy4rijzSbLhWcYqNlbr5+vc45dRlWRHmCSRx87cfeHoKjEc+o 3DLbBeeVB67c84/AcUusR26S4sZX5blBGefz4qexayhESXNqxZ8Z2g7gM9B2P04oS01R01KsI3lS fktGu2nZ2SV+t31KVjZQPeNb3c8cVsD82Qfm9h6fj6VqX2mQQxlYwjRsvyZGcD1FUnEZmbymYoD8 oIwQvbPcevcc1NAv2pkhjLo2DkkdR67f8Klts4Zz53p8v8hx0e4trJLssSGwsYk4DE8ZGOtQ2zDT 51hjkHn7ujHHP1P9a0Xu7q20sIXEoglIHIeMDHY9j7EVFaWyalLsuFiDynIDdF9AMciqTin7xVSp Kpa+6Oltr6K52RNsjuGAfYzDNZPiSzmks5tzuyNyAeikelakPh60SBSD5UmCylT1A9PzNP1mGCOF lWQOvlnbhyQTj0p6rVBq1ZnkX3JB7Gtfy0jhaWNg/GRjORWVOQZWI6ZrdS3kfToWjY4dfmH9K78c 9IsjDJOaT/T9dPvIbYxiPzcYKDO0Z5Pp+tatlO2nSxwy2WZEDKisDtDH+Lng4J/WoLSB7DUdPlv7 QpAzhwzDKtjkdOo6ZFar3TPb3aRzRpFPKcmKMmNeD8oyAQThTwehri06m9JTcbLz0fpq/wABllY6 RfWybpJIr7zlUNnC467vT1p8VpDBezW14wu7eNixnRfuZ+lVPOs47KZl8kzY2pCxOVGeqk9fpx1q G3WIGSSV5mjYDd5IIBb+7nv+VFzaMFBuydvLp137pLyGXOng2815aO8luH27SMOg7En+lZcW5gSw CyZCqScN/wDqrqWuF0+0Fk0sM1vKnmyeUMlT6E+orBjitrifdeCYRDhAmM/U023fUwlU5fd0a1/H 1Q6GVZF8uAkBAOo69P8AGnxXRhvYJJEyqnI4zmoPJMcplDeYBx0AJH+cf4022LOGdz8q52g/rUHN JQXwv8P+Cy20iT383l5I6g9O3Sq/2kKSAu3nJB9fyp9laXFwzPbsETrJK5wi1baXTrYiI2st0QOZ T8oP0HpVJF+0ly8r2/r/ADIpLsRkMVAwRwWFSG4Z5M4VR24LVo6jpVssBVCiYGTvY5JrKjmgU4ZU 3D0GaqUbKxk1Ymimcbh5hyey4H+NSLvlYjY7P0B3MP8AAU6OdApcK2OnC8U1ZWL7kQ5PA+YfyrDV sZUuo3EyKYhuPAOBn88mqrpL5zD5TKELNlsdPTGK07l5FZAwQH8SatT6LbyL5jX+2UDcF2hcfUmu mm1ZBa5jQwtc3CkswiTBIx1P45rXh22SLcRZyDtkH95fXHr3rIM00TsPMaaMHnb29+O1LbTxybyz ZCuRu5IIwD3+tKd3sK7TuauqWkO5L2PayScMcZx71AsscQwjbtvdRnNWLCaEA2jkNFJnYeMD29qr 3Nu1rOY3UlD9xsn8qgcop+8iVtRU8bGLHrxj+dEt5/oToFjCyFR875ZeecAVD9m8xgFQY7lgFP5m q9ycA/OyIoK7X5BOPUfWqiriiEp3wwpHGmVQbmUHJ5x1P0/StG4vZLG2MrxlX4yM5BB4zWTDI8cU YNwihj8wVOB/j1qS7S4mtgk8vyAhVYpjJB6ZrWEUtzZTdrNk8k/9pywQsnlw53F3OC2PSiEqN7FD Ijn5GAAKYPGf89qhiInuVZFA24ABJ4x3FTx3BtYZgkXmZbK5OSvHf8TUVW3oi70rXnf0X+YNf3Ak ZWdpZG+Q5+Zlx79x06+tOkt5RMPOkkQ4xtDMoYfyqWeW3uERYFAd+WdOCAeoP6VqRaosum/YdQsx PChys0SnelYpdL2IVVRtypX08/z019DFvLawaOIq0q3O7DBnLKV9c0kOnq8v7q5Ee4EDe5K+vB7c 801onmdl2q1tuwC+Nw5GKuW/nwAPEkZCnJiK5x+B5oba3ZU4xsmlpd9fTp/VzasotNS3jt3tZIy4 CqSTnI7q2aoX2nT4kFsrSeXjBY4fPbHr/OkGpl2jjY5WLpG/QfSpYtSE+oBW3mKA+YUdsEt0ADe3 X8qztfcScXoZkSXVgzKSS44kVxtcnv8AX8afbTRLMjkGF1bIJUlPxHUfhxWnqskd3Kpl3CYj+LqB 2warCJoUKEefb/eKkYYH1FJyV7Ml7mzY+JLSOcRXYVSv3ZFOUJPvWL4o1gCCXynG1vkGO5NZ0xit 4WlaVQvdTw35d65m9uzcy5AxGPur2rrwtGVaSvshSqOxAMMwAUknsK1I53hVI9g2tkjHVf8APvVb T4SS05OAo4+taVtbb23I4UEkZcZUn+ldGNqKT5V0LwsVe7V/6/H0OhkvD/ZukTXkUclrHIwc4znc McqPp2qzqFrp/wBkSTT2nSKU7gjIdhJ44J6HFVtbe4Xw1DaC2+WPDb0Hy8fT2qbVHvYNPtrYxSw2 xRSpaQMoGK4tLXN1Z1En5f1roQWmladZa1HHqMLRRqvzhsFS3bkdqs3jwWLSSxRxy2U/7uNT8zRq OrLSiwC6cLu/lWZyN4YHOPQVkXEN64E8UP8Ao5wdqNkKPcVS01RnKWi0tf8Ar5Fm0eJ9DvQXMbq6 gcAsxPQ568cmqgsre7ETeZIi4YOy4wTn0xxxj86q3MFwl1EsoOwrlGYcHpVrTfMN15XOxwd2Oxxw alPXUirJyqNPv/WwR2tpMJEiNy5TjG4c/pTp7KxtotzhmkUj9znjnscVO0ctmjJbgKWblx3+lRXk bJaW7TDbNK53epx0qtiLFGSaZ8M7rsB4iXhR9KRXBGWIU+jCrDQFYlcjIJpBkDFRzGb31LUsqzLs 2tyO6gfrVBAjOyrnIPQtRRV8zk9R3uy5DaXDJhYNpPQgDn8zVxLLUmQAkKFGQVIH8qKKzcmnoaRi VtT8mGSGK7mBkwdxUHI+tVFXT2Kl5Z5FI/hUD9aKK2WyZnJ6jWmht5FgNmxDnauZSO3U006fFao7 XYjV5yWVUBwvI/wooouLoXLdIIYAqGSRX44A61dM6yxiG4QgN8qOe596KKlvUpaaFSS2ktwYkijY hGbLcnFVrS3tr2W1to2lkjLZlBwMAsoP8zRRVIbSUrFnWrNLDTmAjVV2hR68HAqhDfhhHbM5dk5R W7Njk0UUWvEcKjhPlsn6lpYkkuEiHLbSSe4yajvLSSCfaCZEXAJJwfWiik+wqjcm5PcltrJ7iN3h G+SM4fHDr/Q1bsvtCFZ0kIhHV1OOfcelFFZi5epJqjTG7FztjVFiBMkYwHBOM4pkYWYB1PuDRRTm tLhUb0RXvUmgMlyHyAuSG74/nUFo5gjkWTBIO6QEcAn+VFFStUJElzfxW8AeRuCOI35yPY1kXPiG TBS1DIuOrHJH0oorvweGpzXNJXCTa2MaSaSaQvIxZj3JrT0bRxqN7DHcTi3hkPDkZz7UUV04qo6c UoaEQV3qaF5bx2zm1R1IU481O6/SrGnzKY2kEIkiPQnrx3oorw5ydmehOCp0ISj9q9/lsaFrqtxb wTrblXt5kKtGwyuCO3pWlrGrM/hnS7ZoFBeCNvM9wMf0NFFNO0WThHKdWMb21X5mXYaa+oXUlrHM YxIu/g8HHtWouo6FY2zWd3byJchSjMQcbh6YNFFVB3IfuarucvELi+vEiDbgmUQn61bkuAFktLLl lOJJfUjrRRVdGZ1HeTl3ZVhu7myJWYh4u/t71Le3LXIW7GHjjX5iTjH0FFFC1RKfQWG6S6iHkM3y jkGo34Y46HmiijZkzdkf/9k=