20180522 17403200 1.0 FALSE Water_Lines 002 2558503.315700 2567425.899100 7621903.704000 7631616.352200 1 Projected GCS_North_American_1983_CSRS Linear Unit: Meter (1.000000) NAD_1983_CSRS_New_Brunswick_Stereographic <ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.7.0'><WKT>PROJCS[&quot;NAD_1983_CSRS_New_Brunswick_Stereographic&quot;,GEOGCS[&quot;GCS_North_American_1983_CSRS&quot;,DATUM[&quot;D_North_American_1983_CSRS&quot;,SPHEROID[&quot;GRS_1980&quot;,6378137.0,298.257222101]],PRIMEM[&quot;Greenwich&quot;,0.0],UNIT[&quot;Degree&quot;,0.0174532925199433]],PROJECTION[&quot;Double_Stereographic&quot;],PARAMETER[&quot;False_Easting&quot;,2500000.0],PARAMETER[&quot;False_Northing&quot;,7500000.0],PARAMETER[&quot;Central_Meridian&quot;,-66.5],PARAMETER[&quot;Scale_Factor&quot;,0.999912],PARAMETER[&quot;Latitude_Of_Origin&quot;,46.5],UNIT[&quot;Meter&quot;,1.0],AUTHORITY[&quot;EPSG&quot;,2953]],VERTCS[&quot;CGVD2013_height&quot;,VDATUM[&quot;Canadian_Geodetic_Vertical_Datum_of_2013&quot;],PARAMETER[&quot;Vertical_Shift&quot;,0.0],PARAMETER[&quot;Direction&quot;,1.0],UNIT[&quot;Meter&quot;,1.0],AUTHORITY[&quot;EPSG&quot;,6647]]</WKT><XOrigin>-28216700</XOrigin><YOrigin>-23260100</YOrigin><XYScale>1000</XYScale><ZOrigin>0</ZOrigin><ZScale>1000</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.002</XYTolerance><ZTolerance>0.002</ZTolerance><MTolerance>2</MTolerance><HighPrecision>true</HighPrecision><WKID>2036</WKID><LatestWKID>2953</LatestWKID><VCSWKID>6647</VCSWKID><LatestVCSWKID>6647</LatestVCSWKID></ProjectedCoordinateSystem> 20210601 12235300 20210601 12235300 Esri ArcGIS 12.7.0.26828 Water_Lines 1 -65.722119 -65.602010 47.681333 47.593125 Enterprise Geodatabase Feature Class dataset EPSG 6.2(9.3.0.0) 0 Simple FALSE 0 TRUE FALSE Water_Lines Feature Class 0 OBJECTID objectid OID 4 10 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. Shape shape Geometry 8 0 0 Feature geometry. Esri Coordinates defining the features. Related_PID Related PID String 50 0 0 Closest_Civic_Address Closest Civic Address String 50 0 0 Related_Civic_Number Related Civic Number String 50 0 0 Related_Street_Name Related Street Name SmallInteger 2 5 0 GlobalID GlobalID GlobalID 38 0 0 Related_Street_Section Related Street Section Double 8 38 8 Asset_Type Asset Type SmallInteger 2 5 0 Asset_Subtype Asset Subtype SmallInteger 2 5 0 Asset_ID Asset ID String 50 0 0 Grid_Reference Grid Reference String 6 0 0 Installation_Year Installation Year (Finance) SmallInteger 2 5 0 Diameter Diameter SmallInteger 2 5 0 Material Material SmallInteger 2 5 0 Pipe_Class Pipe Class SmallInteger 2 5 0 Last_Maintenance_Inspection_Dat Last Maintenance Inspection Date SmallInteger 2 5 0 Lateral_With_DBH Lateral With DBH SmallInteger 2 5 0 Depth Depth SmallInteger 2 5 0 Comments Comments String 60 0 0 TTYYPPEE TTYYPPEE String 50 0 0 PSAB_2016_Comments PSAB 2016 Comments SmallInteger 2 5 0 PSAB_2017_Comments PSAB 2017 Comments SmallInteger 2 5 0 Link_to_As_Built Link to As-Built String 250 0 0 GeoLocation GeoLocation SmallInteger 2 5 0 Asset_Group Asset Group SmallInteger 2 5 0 Jurisdiction Jurisdiction SmallInteger 2 5 0 Tangible_Capital_Asset Tangible Capital Asset SmallInteger 2 5 0 Expected_Life_Years Expected Life Years SmallInteger 2 5 0 Feature_Creator Feature Creator String 150 0 0 Creation_Date Creation Date Date 8 0 0 Last_Editor Last Editor String 255 0 0 Last_Edit_Date Last Edit Date Date 8 0 0 End_of_Life_Date End of Life Date SmallInteger 2 5 0 Remaining_Life_Years Remaining Life Years SmallInteger 2 5 0 Remaining_Life_Percent Remaining Life Percent Double 8 38 8 Condition_Rating Condition Rating (1 to 5) SmallInteger 2 5 0 Cost_per_Unit Cost_per_Unit Double 8 38 8 Asset_Replacement_Value Asset Replacement Value Double 8 38 8 Emergency_Asset_Replacement_Val Emergency Asset Replacement Value Double 8 38 8 Remaining_Value Remaining Value Double 8 38 8 Infrastructure_Deficit__Backlog Infrastructure Deficit (Backlog) Double 8 38 8 Link_to_Ti_Ins Link to Ti-Ins String 250 0 0 Show_When_Page_Name_Is_Not Show When Page Name Is Not String 50 0 0 Water - Main 101 asset_group COB_Asset Group Assets Group Coded Value Default value Duplicate sde SmallInteger 1 asset_type COB_Asset Type Assets Type Coded Value Default value Default value sde SmallInteger 1 related_street_name COB_Street Index Street Index Coded Value Default value Default value sde SmallInteger related_street_section COB_Street Sections Street Sections Coded Value Default value Default value sde Double geolocation COB_GeoLocation GeoLocation Coded Value Default value Default value sde SmallInteger grid_reference COB_Grid_Reference Grid Reference Coded Value Default value Default value sde String installation_year COB_Year Year Coded Value Default value Default value sde SmallInteger diameter COB_Diameter Diameter Coded Value Default value Default value sde SmallInteger material COB_Material Material Coded Value Default value Default value sde SmallInteger pipe_class COB_Pipe_Class Pipe Class Coded Value Default value Default value sde SmallInteger lateral_with_dbh 1 COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger jurisdiction COB_Jurisdiction Jurisdiction Coded Value Default value Default value sde SmallInteger 1 tangible_capital_asset COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger 1 condition_rating 1 COB_Condition_Rating Condition Rating Coded Value Default value Default value sde SmallInteger enabled EnabledDomain Coded Value Default value Default value sde SmallInteger 1 psab_2018_comments COB_PSAB_Comment PSAB Comment Coded Value Default value Default value sde SmallInteger asset_category 3 COB_Asset_Category Asset Category Coded Value Default value Default value sde SmallInteger asset_class 7 COB_Asset_Class Asset Class Coded Value Default value Default value sde SmallInteger asset_subclass 608 COB_Asset_SubClass Asset SubClass Coded Value Default value Default value sde SmallInteger residual_value 0 condition_method 1 COB_Conditon_Method Conditon Method Coded Value Default value Default value sde SmallInteger asset_totally_depreciated COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger salvage_value 0 lifecycle_maintenance_source COB_Funding_Sources Source of Funding Coded Value Default value Default value sde SmallInteger lifecycle_operation_source COB_Funding_Sources Source of Funding Coded Value Default value Default value sde SmallInteger lifecycle_renewal_source COB_Funding_Sources Source of Funding Coded Value Default value Default value sde SmallInteger lifecycle_replacement_source COB_Funding_Sources Source of Funding Coded Value Default value Default value sde SmallInteger climate_change_risk 2 COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger climate_change_risk_type 0 COB_Climate_Change_Risk_Type Climate Change Risk Type Coded Value Default value Default value sde SmallInteger climate_change_risk_probability 0 COB_Climate_Change_Risk_Probability Climate Change Risk Probability Coded Value Default value Default value sde SmallInteger climate_change_risk_impact 0 COB_Climate_Change_Risk_Impact Climate Change Risk Impact Coded Value Default value Default value sde SmallInteger priority_failure 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_health_security 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_climate_change 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_essential_asset 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_high_value_asset 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_positive_finance 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_strategic_plan 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_perceived_value 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_pertinence_need 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger Water - Lateral 102 asset_group COB_Asset Group Assets Group Coded Value Default value Duplicate sde SmallInteger 1 asset_type COB_Asset Type Assets Type Coded Value Default value Default value sde SmallInteger 1 related_street_name COB_Street Index Street Index Coded Value Default value Default value sde SmallInteger related_street_section COB_Street Sections Street Sections Coded Value Default value Default value sde Double geolocation COB_GeoLocation GeoLocation Coded Value Default value Default value sde SmallInteger grid_reference COB_Grid_Reference Grid Reference Coded Value Default value Default value sde String installation_year COB_Year Year Coded Value Default value Default value sde SmallInteger diameter COB_Diameter Diameter Coded Value Default value Default value sde SmallInteger material COB_Material Material Coded Value Default value Default value sde SmallInteger pipe_class COB_Pipe_Class Pipe Class Coded Value Default value Default value sde SmallInteger lateral_with_dbh COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger jurisdiction COB_Jurisdiction Jurisdiction Coded Value Default value Default value sde SmallInteger 1 tangible_capital_asset COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger 2 condition_rating 1 COB_Condition_Rating Condition Rating Coded Value Default value Default value sde SmallInteger enabled EnabledDomain Coded Value Default value Default value sde SmallInteger 1 psab_2018_comments COB_PSAB_Comment PSAB Comment Coded Value Default value Default value sde SmallInteger asset_category 4 COB_Asset_Category Asset Category Coded Value Default value Default value sde SmallInteger asset_class 7 COB_Asset_Class Asset Class Coded Value Default value Default value sde SmallInteger asset_subclass 608 COB_Asset_SubClass Asset SubClass Coded Value Default value Default value sde SmallInteger residual_value 0 condition_method 1 COB_Conditon_Method Conditon Method Coded Value Default value Default value sde SmallInteger asset_totally_depreciated COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger salvage_value 0 lifecycle_maintenance_source COB_Funding_Sources Source of Funding Coded Value Default value Default value sde SmallInteger lifecycle_operation_source COB_Funding_Sources Source of Funding Coded Value Default value Default value sde SmallInteger lifecycle_renewal_source COB_Funding_Sources Source of Funding Coded Value Default value Default value sde SmallInteger lifecycle_replacement_source COB_Funding_Sources Source of Funding Coded Value Default value Default value sde SmallInteger climate_change_risk 2 COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger climate_change_risk_type 0 COB_Climate_Change_Risk_Type Climate Change Risk Type Coded Value Default value Default value sde SmallInteger climate_change_risk_probability 0 COB_Climate_Change_Risk_Probability Climate Change Risk Probability Coded Value Default value Default value sde SmallInteger climate_change_risk_impact 0 COB_Climate_Change_Risk_Impact Climate Change Risk Impact Coded Value Default value Default value sde SmallInteger priority_failure 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_health_security 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_climate_change 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_essential_asset 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_high_value_asset 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_positive_finance 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_strategic_plan 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_perceived_value 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_pertinence_need 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger Water - Fire Hydrant - Lateral 105 asset_group COB_Asset Group Assets Group Coded Value Default value Duplicate sde SmallInteger 1 asset_type COB_Asset Type Assets Type Coded Value Default value Default value sde SmallInteger 1 related_street_name COB_Street Index Street Index Coded Value Default value Default value sde SmallInteger related_street_section COB_Street Sections Street Sections Coded Value Default value Default value sde Double geolocation COB_GeoLocation GeoLocation Coded Value Default value Default value sde SmallInteger grid_reference COB_Grid_Reference Grid Reference Coded Value Default value Default value sde String installation_year COB_Year Year Coded Value Default value Default value sde SmallInteger diameter COB_Diameter Diameter Coded Value Default value Default value sde SmallInteger material COB_Material Material Coded Value Default value Default value sde SmallInteger pipe_class COB_Pipe_Class Pipe Class Coded Value Default value Default value sde SmallInteger lateral_with_dbh COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger jurisdiction COB_Jurisdiction Jurisdiction Coded Value Default value Default value sde SmallInteger 1 tangible_capital_asset COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger 2 condition_rating 1 COB_Condition_Rating Condition Rating Coded Value Default value Default value sde SmallInteger enabled EnabledDomain Coded Value Default value Default value sde SmallInteger 1 psab_2018_comments COB_PSAB_Comment PSAB Comment Coded Value Default value Default value sde SmallInteger asset_category 4 COB_Asset_Category Asset Category Coded Value Default value Default value sde SmallInteger asset_class 7 COB_Asset_Class Asset Class Coded Value Default value Default value sde SmallInteger asset_subclass 608 COB_Asset_SubClass Asset SubClass Coded Value Default value Default value sde SmallInteger residual_value 0 condition_method 1 COB_Conditon_Method Conditon Method Coded Value Default value Default value sde SmallInteger asset_totally_depreciated COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger salvage_value 0 lifecycle_maintenance_source COB_Funding_Sources Source of Funding Coded Value Default value Default value sde SmallInteger lifecycle_operation_source COB_Funding_Sources Source of Funding Coded Value Default value Default value sde SmallInteger lifecycle_renewal_source COB_Funding_Sources Source of Funding Coded Value Default value Default value sde SmallInteger lifecycle_replacement_source COB_Funding_Sources Source of Funding Coded Value Default value Default value sde SmallInteger climate_change_risk 2 COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger climate_change_risk_type 0 COB_Climate_Change_Risk_Type Climate Change Risk Type Coded Value Default value Default value sde SmallInteger climate_change_risk_probability 0 COB_Climate_Change_Risk_Probability Climate Change Risk Probability Coded Value Default value Default value sde SmallInteger climate_change_risk_impact 0 COB_Climate_Change_Risk_Impact Climate Change Risk Impact Coded Value Default value Default value sde SmallInteger priority_failure 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_health_security 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_climate_change 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_essential_asset 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_high_value_asset 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_positive_finance 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_strategic_plan 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_perceived_value 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_pertinence_need 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger Water - Private Lateral 109 asset_group COB_Asset Group Assets Group Coded Value Default value Duplicate sde SmallInteger 1 asset_type COB_Asset Type Assets Type Coded Value Default value Default value sde SmallInteger 1 related_street_name COB_Street Index Street Index Coded Value Default value Default value sde SmallInteger related_street_section COB_Street Sections Street Sections Coded Value Default value Default value sde Double geolocation COB_GeoLocation GeoLocation Coded Value Default value Default value sde SmallInteger grid_reference COB_Grid_Reference Grid Reference Coded Value Default value Default value sde String installation_year COB_Year Year Coded Value Default value Default value sde SmallInteger diameter COB_Diameter Diameter Coded Value Default value Default value sde SmallInteger material COB_Material Material Coded Value Default value Default value sde SmallInteger pipe_class COB_Pipe_Class Pipe Class Coded Value Default value Default value sde SmallInteger lateral_with_dbh COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger jurisdiction COB_Jurisdiction Jurisdiction Coded Value Default value Default value sde SmallInteger 3 tangible_capital_asset COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger 2 condition_rating 1 COB_Condition_Rating Condition Rating Coded Value Default value Default value sde SmallInteger enabled EnabledDomain Coded Value Default value Default value sde SmallInteger 1 psab_2018_comments COB_PSAB_Comment PSAB Comment Coded Value Default value Default value sde SmallInteger asset_category 4 COB_Asset_Category Asset Category Coded Value Default value Default value sde SmallInteger asset_class 7 COB_Asset_Class Asset Class Coded Value Default value Default value sde SmallInteger asset_subclass 608 COB_Asset_SubClass Asset SubClass Coded Value Default value Default value sde SmallInteger residual_value 0 condition_method 1 COB_Conditon_Method Conditon Method Coded Value Default value Default value sde SmallInteger asset_totally_depreciated COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger salvage_value 0 lifecycle_maintenance_source COB_Funding_Sources Source of Funding Coded Value Default value Default value sde SmallInteger lifecycle_operation_source COB_Funding_Sources Source of Funding Coded Value Default value Default value sde SmallInteger lifecycle_renewal_source COB_Funding_Sources Source of Funding Coded Value Default value Default value sde SmallInteger lifecycle_replacement_source COB_Funding_Sources Source of Funding Coded Value Default value Default value sde SmallInteger climate_change_risk 2 COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value sde SmallInteger climate_change_risk_type 0 COB_Climate_Change_Risk_Type Climate Change Risk Type Coded Value Default value Default value sde SmallInteger climate_change_risk_probability 0 COB_Climate_Change_Risk_Probability Climate Change Risk Probability Coded Value Default value Default value sde SmallInteger climate_change_risk_impact 0 COB_Climate_Change_Risk_Impact Climate Change Risk Impact Coded Value Default value Default value sde SmallInteger priority_failure 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_health_security 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_climate_change 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_essential_asset 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_high_value_asset 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_positive_finance 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_strategic_plan 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_perceived_value 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger priority_pertinence_need 0 COB_Priority Priorization Scale Coded Value Default value Default value sde SmallInteger Transportation System 4 Asset_Group COB_Asset Group City's Assets by Group Coded Value Default value Duplicate DBO SmallInteger -1 Related_Street_Name COB_Street Index Street Index Coded Value Default value Default value DBO SmallInteger Related_Street_Section COB_Street Sections Street Sections Coded Value Default value Default value DBO Double GeoLocation COB_GeoLocation GeoLocation Coded Value Default value Default value DBO SmallInteger Grid_Reference COB_Grid_Reference Grid Reference Coded Value Default value Default value DBO String Installation_Year COB_Year Year Coded Value Default value Default value DBO SmallInteger Diameter COB_Diameter Diameter Coded Value Default value Default value DBO SmallInteger Material COB_Material Material Coded Value Default value Default value DBO SmallInteger Pipe_Class COB_Pipe_Class Pipe Class Coded Value Default value Default value DBO SmallInteger Lateral_With_DBH COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value DBO SmallInteger Enabled EnabledDomain Coded Value Default value Default value DBO SmallInteger PSAB_2017_Comments COB_PSAB_Comments PSAB Comments Coded Value Default value Default value DBO SmallInteger GeoLocation COB_Eng_GeoLocation GeoLocation Coded Value Default value Duplicate DBO SmallInteger Land 4 Asset_Type COB_Asset Type City Assets by Type Coded Value Default value Default value DBO SmallInteger Related_Street_Name COB_Street Index Street Index Coded Value Default value Default value DBO SmallInteger Related_Street_Section COB_Street Sections Street Sections Coded Value Default value Default value DBO Double GeoLocation COB_GeoLocation GeoLocation Coded Value Default value Default value DBO SmallInteger Grid_Reference COB_Grid_Reference Grid Reference Coded Value Default value Default value DBO String Installation_Year COB_Year Year Coded Value Default value Default value DBO SmallInteger Diameter COB_Diameter Diameter Coded Value Default value Default value DBO SmallInteger Material COB_Material Material Coded Value Default value Default value DBO SmallInteger Pipe_Class COB_Pipe_Class Pipe Class Coded Value Default value Default value DBO SmallInteger Lateral_With_DBH COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value DBO SmallInteger Enabled Enabled SmallInteger 2 5 0 PSAB_2018_Comments PSAB 2018 Comments SmallInteger 2 5 0 TempField TempField String 255 0 0 Cost_For_Length Cost For Length Double 8 38 8 Asset_Category Asset Category SmallInteger 2 5 0 Related_Service Related Service SmallInteger 2 5 0 Asset_Class Asset Class SmallInteger 2 5 0 Asset_SubClass Asset SubClass SmallInteger 2 5 0 Asset_Name Asset Name String 255 0 0 Historical_Acquisition_Cost2 Historical Acquisition Cost (Previous 2x) Double 8 38 8 Historical_Acquisition_Cost1 Historical Acquisition Cost (Previous 1x) Double 8 38 8 Cost_per_Unit_Readjustment Cost per Unit Readjustment String 255 0 0 Residual_Value Residual Value Double 8 38 8 Condition_Method Condition Method SmallInteger 2 5 0 Opening_Book_Value Opening Book Value Double 8 38 8 Closing_Book_Value Closing Book Value Double 8 38 8 Asset_Totally_Depreciated Asset Totally Depreciated SmallInteger 2 5 0 Salvage_Value Salvage Value Double 8 38 8 LifeCycle_Maintenance_Cost LifeCycle Maintenance Cost Double 8 38 8 LifeCycle_Maintenance_Source LifeCycle Maintenance Source of Funding SmallInteger 2 5 0 LifeCycle_Operation_Cost LifeCycle Operation Cost Double 8 38 8 LifeCycle_Operation_Source LifeCycle Operation Source of Funding SmallInteger 2 5 0 LifeCycle_Renewal_Cost LifeCycle Renewal Cost Double 8 38 8 LifeCycle_Renewal_Source LifeCycle Renewal Source SmallInteger 2 5 0 LifeCycle_End_of_Life_Cost LifeCycle End of Life Cost Double 8 38 8 LifeCycle_Replacement_Cost LifeCycle Replacement Cost Double 8 38 8 LifeCycle_EmgReplacement_Cost LifeCycle Emergency Replacement Cost Double 8 38 8 LifeCycle_Replacement_Source LifeCycle Replacement Source of Funding SmallInteger 2 5 0 LifeCycle_Admin_Cost LifeCycle Administrative Cost Double 8 38 8 LifeCycle_Total_Cost LifeCycle Total Cost Double 8 38 8 LifeCycle_Cost_Annual LifeCycle_Cost_Annual Double 8 38 8 Climate_Change_Risk Climate Change Risk SmallInteger 2 5 0 Climate_Change_Risk_Type Climate Change Risk Type SmallInteger 2 5 0 Climate_Change_Risk_Probability Climate Change Risk Probability SmallInteger 2 5 0 Climate_Change_Risk_Impact Climate Change Risk Impact SmallInteger 2 5 0 Priority_Failure Priority Failure SmallInteger 2 5 0 Priority_Health_Security Priority Health Security SmallInteger 2 5 0 Priority_Climate_Change Priority Climate Change SmallInteger 2 5 0 Priority_Essential_Asset Priority Essential Asset SmallInteger 2 5 0 Priority_High_Value_Asset Priority High Value Asset SmallInteger 2 5 0 Priority_Positive_Finance Priority Positive Finance SmallInteger 2 5 0 Priority_Strategic_Plan Priority Strategic Plan SmallInteger 2 5 0 Priority_Perceived_Value Priority Perceived Value SmallInteger 2 5 0 Priority_Pertinence_Need Priority Pertinence Need SmallInteger 2 5 0 Priority_Final_Index Priority Final Index SmallInteger 2 5 0 Asset_Description Asset Description String 255 0 0 Replacement_Cost_per_Unit Replacement Cost per Unit Double 8 38 8 TempField3 TempField3 Double 8 38 8 TempField2 TempField2 String 255 0 0 FA_CLASS_CODE FA_CLASS_CODE String 6 0 0 FA_ASSET_CODE FA_ASSET_CODE String 10 0 0 SCHED_NAME SCHED_NAME String 50 0 0 FA_SCHED_STATUS FA_SCHED_STATUS String 6 0 0 DEPREC_VALUE DEPREC_VALUE Double 8 38 8 LIFE_EXPECTANCY LIFE_EXPECTANCY Integer 4 10 0 START_DATE START_DATE Date 8 0 0 Loss_in_Value_Year Loss in Value (This Year) Double 8 38 8 Loss_In_Value_Total Loss in Value (Since Acquisition) Double 8 38 8 Installation_Year_Ground Installation Year (Ground) SmallInteger 2 5 0 PSAB_2019_Comment PSAB 2019 Comment SmallInteger 2 5 0 Project_Name Project Name String 255 0 0 Project_Description Project Description String 255 0 0 Project_Start_Date Project Start Date Date 8 0 0 Project_End_Date Project End Date Date 8 0 0 Project_Status Project Status SmallInteger 2 5 0 TempField4 TempField4 String 255 0 0 Park & Signs 5 Asset_Type COB_Asset Type City Assets by Type Coded Value Default value Default value DBO SmallInteger Related_Street_Name COB_Street Index Street Index Coded Value Default value Default value DBO SmallInteger Related_Street_Section COB_Street Sections Street Sections Coded Value Default value Default value DBO Double GeoLocation COB_GeoLocation GeoLocation Coded Value Default value Default value DBO SmallInteger Grid_Reference COB_Grid_Reference Grid Reference Coded Value Default value Default value DBO String Installation_Year COB_Year Year Coded Value Default value Default value DBO SmallInteger Diameter COB_Diameter Diameter Coded Value Default value Default value DBO SmallInteger Material COB_Material Material Coded Value Default value Default value DBO SmallInteger Pipe_Class COB_Pipe_Class Pipe Class Coded Value Default value Default value DBO SmallInteger Lateral_With_DBH COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value DBO SmallInteger Machinery & Equipment 6 Asset_Type COB_Asset Type City Assets by Type Coded Value Default value Default value DBO SmallInteger Related_Street_Name COB_Street Index Street Index Coded Value Default value Default value DBO SmallInteger Related_Street_Section COB_Street Sections Street Sections Coded Value Default value Default value DBO Double GeoLocation COB_GeoLocation GeoLocation Coded Value Default value Default value DBO SmallInteger Grid_Reference COB_Grid_Reference Grid Reference Coded Value Default value Default value DBO String Installation_Year COB_Year Year Coded Value Default value Default value DBO SmallInteger Diameter COB_Diameter Diameter Coded Value Default value Default value DBO SmallInteger Material COB_Material Material Coded Value Default value Default value DBO SmallInteger Pipe_Class COB_Pipe_Class Pipe Class Coded Value Default value Default value DBO SmallInteger Lateral_With_DBH COB_Yes No NA Unknown Yes No NA Unknown Coded Value Default value Default value DBO SmallInteger st_length(shape) st_length(shape) Double 0 0 0 20210601