20180522 17410400 1.0 FALSE Water_Points 002 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.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 11371100 20210601 11371100 Esri ArcGIS 12.7.0.26828 Water_Points 1 -65.722116 -65.602009 47.681426 47.593273 Enterprise Geodatabase Feature Class dataset EPSG 6.2(9.3.0.0) 0 Simple FALSE 0 TRUE FALSE Water_Points 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 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 20210601