20230911 10324300 1.0 FALSE WaterDevice 002 Projected GCS_North_American_1983 Linear Unit: Foot_US (0.304801) NAD_1983_StatePlane_Texas_South_Central_FIPS_4204_Feet <ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WKT>PROJCS[&quot;NAD_1983_StatePlane_Texas_South_Central_FIPS_4204_Feet&quot;,GEOGCS[&quot;GCS_North_American_1983&quot;,DATUM[&quot;D_North_American_1983&quot;,SPHEROID[&quot;GRS_1980&quot;,6378137.0,298.257222101]],PRIMEM[&quot;Greenwich&quot;,0.0],UNIT[&quot;Degree&quot;,0.0174532925199433]],PROJECTION[&quot;Lambert_Conformal_Conic&quot;],PARAMETER[&quot;False_Easting&quot;,1968500.0],PARAMETER[&quot;False_Northing&quot;,13123333.33333333],PARAMETER[&quot;Central_Meridian&quot;,-99.0],PARAMETER[&quot;Standard_Parallel_1&quot;,28.38333333333333],PARAMETER[&quot;Standard_Parallel_2&quot;,30.28333333333333],PARAMETER[&quot;Latitude_Of_Origin&quot;,27.83333333333333],UNIT[&quot;Foot_US&quot;,0.3048006096012192],AUTHORITY[&quot;EPSG&quot;,2278]]</WKT><XOrigin>-126725700</XOrigin><YOrigin>-77828800</YOrigin><XYScale>34994581.165044703</XYScale><ZOrigin>0</ZOrigin><ZScale>99999.999999999985</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.10000000000000001</XYTolerance><ZTolerance>2.0000000000000002e-05</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102740</WKID><LatestWKID>2278</LatestWKID></ProjectedCoordinateSystem> 20240327 11561800 20240327 11561800 Esri ArcGIS 12.9.4.32739 WaterDevice Enterprise Geodatabase Feature Class dataset EPSG 6.11(9.0.0) 0 Simple FALSE 0 TRUE TRUE WaterDevice Feature Class 0 OBJECTID OBJECTID OID 4 10 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. ASSETGROUP Asset group Integer 4 10 0 ASSETTYPE Asset type SmallInteger 2 5 0 ASSOCIATIONSTATUS Association status SmallInteger 2 5 0 ISSUBNETWORKCONTROLLER Is subnetwork controller SmallInteger 2 5 0 ISCONNECTED Is connected SmallInteger 2 5 0 SUBNETWORKCONTROLLERNAME Subnetwork controller name String 2000 0 0 TIERNAME Tier name Integer 4 10 0 TIERRANK Tier rank Integer 4 10 0 TERMINALCONFIGURATION Terminal path String 128 0 0 GLOBALID Global ID GlobalID 38 0 0 cpsubnetworkname CP Subnetwork Name String 2000 0 0 SUPPORTEDSUBNETWORKNAME Supported subnetwork name String 2000 0 0 SUPPORTINGSUBNETWORKNAME Supporting subnetwork name String 2000 0 0 SystemSubnetworkName System Subnetwork Name String 2000 0 0 PressureSubnetworkName Pressure Subnetwork Name String 2000 0 0 IsolationSubnetworkName Isolation Subnetwork Name String 2000 0 0 DMASubnetworkName DMA Subnetwork Name String 2000 0 0 CREATIONDATE Creation date Date 8 0 0 CREATOR Creator String 255 0 0 LASTUPDATE Last update Date 8 0 0 UPDATEDBY Updated by String 255 0 0 diameter diameter: Diameter, Diameter 1, Height, Inlet Diameter, Pipe Diameter, Weight Double 8 38 8 secondarydiameter secondarydiameter: Diameter 2, Nozzle Diameter, Outlet Diameter, Width Double 8 38 8 pressure pressure: Amperage, Pressure, Rated Pressure, Volume Double 8 38 8 designtype designtype: Anode Count, Design Type, Manufacturer, Pump Type, Test Wire Count, Valve Type, Wire Count SmallInteger 2 5 0 normalstatus Normal Status SmallInteger 2 5 0 presentstatus Present Status SmallInteger 2 5 0 additionaldetails additionaldetails: Clockwise to Close, Cooling Method, Critical, Material SmallInteger 2 5 0 designinfo designinfo: Anode Depth, Rated Flow, Turns to Close, Voltage Double 8 38 8 operable Operable SmallInteger 2 5 0 name Name String 64 0 0 installdate Install Date Date 8 0 0 assetid Asset ID String 64 0 0 accountid Account ID String 50 0 0 ownedby Owned By SmallInteger 2 5 0 maintby Maintained By SmallInteger 2 5 0 additionaldevice additionaldevice: Additional Device, Has Bypass, Internal Meter, Metered SmallInteger 2 5 0 notes Notes String 2000 0 0 symbolrotation Symbol Rotation SmallInteger 2 5 0 lastmaint Last Maintenance Date 8 0 0 lifecyclestatus Lifecycle Status SmallInteger 2 5 0 bondedinsulated Bonded/Insulated SmallInteger 2 5 0 cptraceability Cathodic Protection Traceability SmallInteger 2 5 0 inservicedate In-Service Date Date 8 0 0 retireddate Retired Date Date 8 0 0 spatialsource Spatial Source SmallInteger 2 5 0 spatialconfidence Spatial Confidence SmallInteger 2 5 0 cpoverride Cathodic Protection Override SmallInteger 2 5 0 manufacturer Manufacturer SmallInteger 2 5 0 operator Postindicator Valve SmallInteger 2 5 0 ufid UFID Integer 4 10 0 plandate Plan Date Date 8 0 0 datasourcerefnum Field Verified Number Integer 4 10 0 financialassettype Financial Asset Type String 20 0 0 facilityname Facility Name String 20 0 0 facilityaddress Facility Address String 30 0 0 ilmsnumber ILMS Number String 30 0 0 compkey COMPKEY Integer 4 10 0 keymap Key Map String 14 0 0 councildistrict Council District String 10 0 0 plannumber Plan Number String 10 0 0 projectnumber Project Number String 24 0 0 ipssubtype IPS Subtype Code String 10 0 0 zone Zone String 10 0 0 address ADDRESS String 100 0 0 plantype Plan Type String 30 0 0 projectype Project Type String 30 0 0 largemaindiameter Large Main Diameter Double 8 38 8 smallmaindiameter Small Main Diameter Double 8 38 8 address_id ADDRESS_ID Double 8 38 8 gfsorwbs GFS or WBS String 5 0 0 gfswbsnumber GFS-WBS Number String 24 0 0 unitid UNITID String 20 0 0 comptype COMPTYPE SmallInteger 2 5 0 latitude Latitude Double 8 38 8 longitude Longitude Double 8 38 8 condition Condition String 20 0 0 conditiondate Condition Date Date 8 0 0 fiscal_year Fiscal Year String 10 0 0 gps_positioned GPS Positioned String 10 0 0 spatialadjustnote Spatial Adjustment Notes String 255 0 0 lastvendor Last Valve Vendor String 10 0 0 maindiameter Main Size Double 8 38 8 serviceaddress Service Address String 50 0 0 serialnumber Serial Number String 15 0 0 offset Offset String 50 0 0 stationnumber Station Number String 50 0 0 mainufid Main UFID Integer 4 10 0 surveyid Survey ID String 50 0 0 rectifierorder Rectifier Order Integer 4 10 0 lastsurveydate Last Survey Date Date 8 0 0 rectifierid Rectifier Unique ID String 50 0 0 operational Operational String 50 0 0 troubleshooting Troubleshooting Needed String 50 0 0 run Run String 10 0 0 servicearea ServiceArea String 25 0 0 disinfectant Disinfectant String 15 0 0 score Score Double 8 38 8 siteid SiteID String 25 0 0 lifelinevlv Lifeline Valve String 5 0 0 insertionvlv Insertion Valve String 5 0 0 replacementprojtype Replacement Project Type String 30 0 0 workordernumber Work Order Number String 25 0 0 replacementprojnum Replacement Project Number String 24 0 0 replacementdate Replacement Date Date 8 0 0 imsno IMS Number Integer 4 10 0 nozzlecolor Nozzle Color String 5 0 0 bonnetcolor Bonnet Color String 5 0 0 barreldiameter Barrel Diameter Double 8 38 8 nozzlediameter1 Nozzle Diameter 1 Double 8 38 8 nozzlediameter2 Nozzle Diameter 2 Double 8 38 8 nozzlediameter3 Nozzle Diameter 3 Double 8 38 8 hfd_delivery HFD Delivery Date 8 0 0 demevel2018 DEM Elevation 2018 Double 8 38 8 demevel2008 DEM Elevation 2008 Double 8 38 8 modellabel Model Label String 8 0 0 stocknumber Stock Number String 30 0 0 constructionpackage Construction Package String 30 0 0 prvid PRV ID String 8 0 0 modelnumber Model Number String 30 0 0 pressuresettinginipsi Pressure Setting (Initial) (PSI) Integer 4 10 0 modelid Model ID Integer 4 10 0 xft X (ft) Double 8 38 8 yft Y (ft) Double 8 38 8 elevationft Elevation (ft) Double 8 38 8 generatedby GENERATEDBY GUID 38 0 0 oldglobalid OLDGLOBALID GUID 38 0 0 location Location String 100 0 0 gpsdate GPS Date Date 8 0 0 gpsreceiver GPS Reciever String 20 0 0 valvemake Valve Make String 20 0 0 valvemodel Valve Model String 20 0 0 valveactuatortype Valve Actuator Type String 20 0 0 valveactuatormake Valve Actuator Make String 20 0 0 valveactuatormodel Valve Actuator Model String 20 0 0 ipsexpiredate IPS Expire Date Date 8 0 0 ipsexpiredby IPS Expired By String 20 0 0 addrkey ADDRKEY Integer 4 10 0 inspectiondate Inspection Date Date 8 0 0 site Site String 50 0 0 watershed Watershed String 50 0 0 wirenumber Wire Number SmallInteger 2 5 0 teststationorder Test Station Order SmallInteger 2 5 0 teststationid Test Station ID String 50 0 0 teststationtype Test Station Type String 100 0 0 meet850 Potential over 850mV String 50 0 0 cpassetid CP Asset ID GUID 38 0 0 side Side String 2 0 0 facilityid Facility ID String 11 0 0 surfacewater Surface Water SmallInteger 2 5 0 boxcolor Box Color String 10 0 0 contractnum Contract Number String 20 0 0 contractor Contractor String 75 0 0 datereceivedbypm Date Received by PM Date 8 0 0 datetime Date Time String 20 0 0 fieldphotofilename Field Photo File Name String 20 0 0 filenum File Num String 20 0 0 samplingidbtlims BTLIMS Sampling ID String 25 0 0 samplingidcontracted Contracted Sampling ID String 10 0 0 workorderauthnum Work Order Authorization Number String 10 0 0 public_share Public String 2 0 0 disinfectant_type Disinfectant Type String 20 0 0 VALIDATIONSTATUS Validation status SmallInteger 2 5 0 ZIPCODE ZIP Code String 10 0 0 Shape Shape Geometry 8 0 0 Feature geometry. Esri Coordinates defining the features. Unknown 0 ASSETTYPE 0 Water_189_UnknownAssetType The AssetType domain for the Unknown AssetGroup. Coded Value Default value Default value UNMETL SmallInteger ASSOCIATIONSTATUS 0 Water_189_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate UNMETL SmallInteger ISSUBNETWORKCONTROLLER 0 Water_189_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value UNMETL SmallInteger ISCONNECTED 2 Water_189_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate UNMETL SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_189_TierName The tier names in the utility network. Coded Value Default value Default value UNMETL SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown secondarydiameter 4 operable 1 Boolean True or False Coded Value Default value Duplicate UNMETL SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate UNMETL SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate UNMETL SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate UNMETL SmallInteger bondedinsulated Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate UNMETL SmallInteger cptraceability 0 Yes_No_1 Valid Yes, No values Coded Value Default value Duplicate UNMETL SmallInteger financialassettype Financial_Asset_Type_1 Coded Value Default value Default value UNMETL String maindiameter Water_Main_Diameter List of transmission main sizes, in Imperial units Coded Value Default value Duplicate UNMETL Double nozzlediameter1 4 Water_Hydrant_Nozzle_Diameter Sizes of a fire hydrants nozzle, in Imperial units Coded Value Default value Duplicate UNMETL Double nozzlediameter2 2.5 Water_Hydrant_Nozzle_Diameter Sizes of a fire hydrants nozzle, in Imperial units Coded Value Default value Duplicate UNMETL Double nozzlediameter3 2.5 Water_Hydrant_Nozzle_Diameter Sizes of a fire hydrants nozzle, in Imperial units Coded Value Default value Duplicate UNMETL Double VALIDATIONSTATUS 6 Validation Status_1 The current record's validation status. Coded Value Default value Default value UNMETL SmallInteger Flow Valve 1 ASSETTYPE 0 Asset_Type_Water_Device_Flow_Valve The Asset Types for the Water Device's Asset Group Flow Valve Coded Value Default value Duplicate UNMETL SmallInteger ASSOCIATIONSTATUS 0 Water_189_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate UNMETL SmallInteger ISSUBNETWORKCONTROLLER 0 Water_189_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value UNMETL SmallInteger ISCONNECTED 2 Water_189_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate UNMETL SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_189_TierName The tier names in the utility network. Coded Value Default value Default value UNMETL SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown diameter 0 Water_Diameter_1 General domain for the diameter of water assets, in Imperial units Coded Value Default value Duplicate UNMETL Double designtype Water_Valve_Type Types of controllable water valves Coded Value Default value Duplicate UNMETL SmallInteger normalstatus Pipeline_Valve_Status The status of a water device Coded Value Default value Duplicate UNMETL SmallInteger presentstatus Pipeline_Valve_Status The status of a water device Coded Value Default value Duplicate UNMETL SmallInteger additionaldetails Pipeline_Valve_Close_Direction The close direction of a valve Coded Value Default value Duplicate UNMETL SmallInteger operable 1 Boolean True or False Coded Value Default value Duplicate UNMETL SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate UNMETL SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate UNMETL SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate UNMETL SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate UNMETL SmallInteger bondedinsulated Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate UNMETL SmallInteger cptraceability 0 Yes_No_1 Valid Yes, No values Coded Value Default value Duplicate UNMETL SmallInteger spatialsource 0 Spatial_Source_1 Source of the data Coded Value Default value Duplicate UNMETL SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate UNMETL SmallInteger cpoverride CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate UNMETL SmallInteger financialassettype Financial_Asset_Type_1 Coded Value Default value Default value UNMETL String councildistrict COH_Council_District_1 City Council Districts Coded Value Default value Default value UNMETL String zone UM_Zones Utility Maintenance Zones Coded Value Default value Default value UNMETL String plantype Plan_Type_1 The type of plans used for digitizing Coded Value Default value Default value UNMETL String projectype Project_Type_1 The type of project Coded Value Default value Default value UNMETL String gfsorwbs Project_Type_2 Project type is GFS or WBS Coded Value Default value Default value UNMETL String condition System_Valve_Condition Condition Rating for Water System Valves Coded Value Default value Default value UNMETL String fiscal_year Fiscal_Year_1 Coded Value Default value Default value UNMETL String gps_positioned GPS_Verified Coded Value Default value Default value UNMETL String lastvendor Valve_Vendor Identifies the last known water valve vendor who worked on a valve. Coded Value Default value Default value UNMETL String maindiameter Water_Main_Diameter List of transmission main sizes, in Imperial units Coded Value Default value Duplicate UNMETL Double lifelinevlv Lifeline_Valve_Ind Lifeline Valve Indicator Yes/No Coded Value Default value Default value UNMETL String insertionvlv Insert_Valve_Ind Insertion Valve Indicator Yes/No Coded Value Default value Default value UNMETL String replacementprojtype Project_Type_1 The type of project Coded Value Default value Default value UNMETL String public_share Y Yes_No_Indicator Valid Y, N Coded Value Default value Default value UNMETL String VALIDATIONSTATUS 6 Validation Status_1 The current record's validation status. Coded Value Default value Default value UNMETL SmallInteger System Valve 2 ASSETTYPE 0 Asset_Type_Water_Device_System_Valve The Asset Types for the Water Device's Asset Group System Valve Coded Value Default value Duplicate UNMETL SmallInteger ASSOCIATIONSTATUS 0 Water_189_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate UNMETL SmallInteger ISSUBNETWORKCONTROLLER 0 Water_189_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value UNMETL SmallInteger ISCONNECTED 2 Water_189_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate UNMETL SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_189_TierName The tier names in the utility network. Coded Value Default value Default value UNMETL SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown diameter Water_Diameter_1 General domain for the diameter of water assets, in Imperial units Coded Value Default value Duplicate UNMETL Double designtype Water_Valve_Type Types of controllable water valves Coded Value Default value Duplicate UNMETL SmallInteger normalstatus 1 Pipeline_Valve_Status The status of a water device Coded Value Default value Duplicate UNMETL SmallInteger presentstatus 1 Pipeline_Valve_Status The status of a water device Coded Value Default value Duplicate UNMETL SmallInteger additionaldetails Pipeline_Valve_Close_Direction The close direction of a valve Coded Value Default value Duplicate UNMETL SmallInteger operable 1 Boolean True or False Coded Value Default value Duplicate UNMETL SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate UNMETL SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate UNMETL SmallInteger additionaldevice Yes_No_1 Valid Yes, No values Coded Value Default value Duplicate UNMETL SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate UNMETL SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate UNMETL SmallInteger bondedinsulated Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate UNMETL SmallInteger cptraceability 0 Yes_No_1 Valid Yes, No values Coded Value Default value Duplicate UNMETL SmallInteger spatialsource Spatial_Source_1 Source of the data Coded Value Default value Duplicate UNMETL SmallInteger spatialconfidence Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate UNMETL SmallInteger cpoverride CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate UNMETL SmallInteger financialassettype Financial_Asset_Type_1 Coded Value Default value Default value UNMETL String councildistrict COH_Council_District_1 City Council Districts Coded Value Default value Default value UNMETL String zone UM_Zones Utility Maintenance Zones Coded Value Default value Default value UNMETL String plantype Plan_Type_1 The type of plans used for digitizing Coded Value Default value Default value UNMETL String projectype Project_Type_1 The type of project Coded Value Default value Default value UNMETL String gfsorwbs Project_Type_2 Project type is GFS or WBS Coded Value Default value Default value UNMETL String condition System_Valve_Condition Condition Rating for Water System Valves Coded Value Default value Default value UNMETL String fiscal_year Fiscal_Year_1 Coded Value Default value Default value UNMETL String gps_positioned GPS_Verified Coded Value Default value Default value UNMETL String lastvendor Valve_Vendor Identifies the last known water valve vendor who worked on a valve. Coded Value Default value Default value UNMETL String maindiameter Water_Main_Diameter List of transmission main sizes, in Imperial units Coded Value Default value Duplicate UNMETL Double lifelinevlv Lifeline_Valve_Ind Lifeline Valve Indicator Yes/No Coded Value Default value Default value UNMETL String insertionvlv Insert_Valve_Ind Insertion Valve Indicator Yes/No Coded Value Default value Default value UNMETL String replacementprojtype Project_Type_1 The type of project Coded Value Default value Default value UNMETL String gpsreceiver Valve_GPS_Receiver Water valve contract GPS receiver Coded Value Default value Default value UNMETL String valvemake Valve_Manufacturer Valve manufacturers Coded Value Default value Default value UNMETL String valveactuatortype Valve_Actuator_Type Valve actuator types Coded Value Default value Default value UNMETL String valveactuatormake Valve_Actuator_Manufacturer Valve actuator manufacturers Coded Value Default value Default value UNMETL String valveactuatormodel Valve_Actuator_Model Valve actuator models Coded Value Default value Default value UNMETL String public_share Y Yes_No_Indicator Valid Y, N Coded Value Default value Default value UNMETL String VALIDATIONSTATUS 6 Validation Status_1 The current record's validation status. Coded Value Default value Default value UNMETL SmallInteger Pressure Valve 3 ASSETTYPE 0 Asset_Type_Water_Device_Pressure_Valve The Asset Types for the Water Device's Asset Group Pressure Valve Coded Value Default value Duplicate UNMETL SmallInteger ASSOCIATIONSTATUS 0 Water_189_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate UNMETL SmallInteger ISSUBNETWORKCONTROLLER 0 Water_189_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value UNMETL SmallInteger ISCONNECTED 2 Water_189_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate UNMETL SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_189_TierName The tier names in the utility network. Coded Value Default value Default value UNMETL SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown diameter Water_Main_Diameter List of transmission main sizes, in Imperial units Coded Value Default value Duplicate UNMETL Double normalstatus Pipeline_Valve_Status The status of a water device Coded Value Default value Duplicate UNMETL SmallInteger presentstatus Pipeline_Valve_Status The status of a water device Coded Value Default value Duplicate UNMETL SmallInteger operable 1 Boolean True or False Coded Value Default value Duplicate UNMETL SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate UNMETL SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate UNMETL SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate UNMETL SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate UNMETL SmallInteger bondedinsulated Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate UNMETL SmallInteger cptraceability 0 Yes_No_1 Valid Yes, No values Coded Value Default value Duplicate UNMETL SmallInteger spatialsource 0 Spatial_Source_1 Source of the data Coded Value Default value Duplicate UNMETL SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate UNMETL SmallInteger cpoverride CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate UNMETL SmallInteger financialassettype Financial_Asset_Type_1 Coded Value Default value Default value UNMETL String councildistrict COH_Council_District_1 City Council Districts Coded Value Default value Default value UNMETL String zone UM_Zones Utility Maintenance Zones Coded Value Default value Default value UNMETL String plantype Plan_Type_1 The type of plans used for digitizing Coded Value Default value Default value UNMETL String projectype Project_Type_1 The type of project Coded Value Default value Default value UNMETL String gfsorwbs Project_Type_2 Project type is GFS or WBS Coded Value Default value Default value UNMETL String fiscal_year Fiscal_Year_1 Coded Value Default value Default value UNMETL String gps_positioned GPS_Verified Coded Value Default value Default value UNMETL String lastvendor Valve_Vendor Identifies the last known water valve vendor who worked on a valve. Coded Value Default value Default value UNMETL String maindiameter Water_Main_Diameter List of transmission main sizes, in Imperial units Coded Value Default value Duplicate UNMETL Double public_share Y Yes_No_Indicator Valid Y, N Coded Value Default value Default value UNMETL String VALIDATIONSTATUS 6 Validation Status_1 The current record's validation status. Coded Value Default value Default value UNMETL SmallInteger Station 4 ASSETTYPE 0 Asset_Type_Water_Device_Station The Asset Types for the Water Device's Asset Group Station Coded Value Default value Duplicate UNMETL SmallInteger ASSOCIATIONSTATUS 0 Water_189_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate UNMETL SmallInteger ISSUBNETWORKCONTROLLER 0 Water_189_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value UNMETL SmallInteger ISCONNECTED 2 Water_189_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate UNMETL SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_189_TierName The tier names in the utility network. Coded Value Default value Default value UNMETL SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown designtype Water_Type List of water types Coded Value Default value Duplicate UNMETL SmallInteger operable 1 Boolean True or False Coded Value Default value Duplicate UNMETL SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate UNMETL SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate UNMETL SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate UNMETL SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate UNMETL SmallInteger bondedinsulated Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate UNMETL SmallInteger cptraceability 0 Yes_No_1 Valid Yes, No values Coded Value Default value Duplicate UNMETL SmallInteger spatialsource 0 Spatial_Source_1 Source of the data Coded Value Default value Duplicate UNMETL SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate UNMETL SmallInteger cpoverride CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate UNMETL SmallInteger financialassettype Financial_Asset_Type_1 Coded Value Default value Default value UNMETL String councildistrict COH_Council_District_1 City Council Districts Coded Value Default value Default value UNMETL String zone UM_Zones Utility Maintenance Zones Coded Value Default value Default value UNMETL String plantype Plan_Type_1 The type of plans used for digitizing Coded Value Default value Default value UNMETL String projectype Project_Type_1 The type of project Coded Value Default value Default value UNMETL String largemaindiameter Water_Main_Diameter List of transmission main sizes, in Imperial units Coded Value Default value Duplicate UNMETL Double smallmaindiameter Water_Main_Diameter List of transmission main sizes, in Imperial units Coded Value Default value Duplicate UNMETL Double gfsorwbs Project_Type_2 Project type is GFS or WBS Coded Value Default value Default value UNMETL String fiscal_year Fiscal_Year_1 Coded Value Default value Default value UNMETL String gps_positioned GPS_Verified Coded Value Default value Default value UNMETL String maindiameter Water_Main_Diameter List of transmission main sizes, in Imperial units Coded Value Default value Duplicate UNMETL Double disinfectant Unknown Disinfectant Disinfectant types for Sampling Stations Coded Value Default value Default value UNMETL String public_share Y Yes_No_Indicator Valid Y, N Coded Value Default value Default value UNMETL String VALIDATIONSTATUS 6 Validation Status_1 The current record's validation status. Coded Value Default value Default value UNMETL SmallInteger Pump 5 ASSETTYPE 0 Asset_Type_Water_Device_Pump The Asset Types for the Water Device's Asset Group Pump Coded Value Default value Duplicate UNMETL SmallInteger ASSOCIATIONSTATUS 0 Water_189_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate UNMETL SmallInteger ISSUBNETWORKCONTROLLER 0 Water_189_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value UNMETL SmallInteger ISCONNECTED 2 Water_189_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate UNMETL SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_189_TierName The tier names in the utility network. Coded Value Default value Default value UNMETL SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown diameter 0 Water_Pump_Diameter Sizes of pumps Coded Value Default value Duplicate UNMETL Double secondarydiameter 0 Water_Pump_Diameter Sizes of pumps Coded Value Default value Duplicate UNMETL Double designtype 0 Water_Pump_Type The different types of pump designs. Coded Value Default value Duplicate UNMETL SmallInteger operable 1 Boolean True or False Coded Value Default value Duplicate UNMETL SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate UNMETL SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate UNMETL SmallInteger additionaldevice 0 Yes_No_1 Valid Yes, No values Coded Value Default value Duplicate UNMETL SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate UNMETL SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate UNMETL SmallInteger bondedinsulated Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate UNMETL SmallInteger cptraceability 0 Yes_No_1 Valid Yes, No values Coded Value Default value Duplicate UNMETL SmallInteger spatialsource 0 Spatial_Source_1 Source of the data Coded Value Default value Duplicate UNMETL SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate UNMETL SmallInteger cpoverride CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate UNMETL SmallInteger financialassettype Financial_Asset_Type_1 Coded Value Default value Default value UNMETL String councildistrict COH_Council_District_1 City Council Districts Coded Value Default value Default value UNMETL String zone UM_Zones Utility Maintenance Zones Coded Value Default value Default value UNMETL String plantype Plan_Type_1 The type of plans used for digitizing Coded Value Default value Default value UNMETL String projectype Project_Type_1 The type of project Coded Value Default value Default value UNMETL String largemaindiameter Water_Main_Diameter List of transmission main sizes, in Imperial units Coded Value Default value Duplicate UNMETL Double smallmaindiameter Water_Main_Diameter List of transmission main sizes, in Imperial units Coded Value Default value Duplicate UNMETL Double gfsorwbs Project_Type_2 Project type is GFS or WBS Coded Value Default value Default value UNMETL String fiscal_year Fiscal_Year_1 Coded Value Default value Default value UNMETL String gps_positioned GPS_Verified Coded Value Default value Default value UNMETL String maindiameter Water_Main_Diameter List of transmission main sizes, in Imperial units Coded Value Default value Duplicate UNMETL Double public_share Y Yes_No_Indicator Valid Y, N Coded Value Default value Default value UNMETL String VALIDATIONSTATUS 6 Validation Status_1 The current record's validation status. Coded Value Default value Default value UNMETL SmallInteger Service Valve 6 ASSETTYPE 0 Asset_Type_Water_Device_Service_Valve The Asset Types for the Water Device's Asset Group Service Valve Coded Value Default value Duplicate UNMETL SmallInteger ASSOCIATIONSTATUS 0 Water_189_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate UNMETL SmallInteger ISSUBNETWORKCONTROLLER 0 Water_189_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value UNMETL SmallInteger ISCONNECTED 2 Water_189_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate UNMETL SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_189_TierName The tier names in the utility network. Coded Value Default value Default value UNMETL SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown diameter Water_Diameter_1 General domain for the diameter of water assets, in Imperial units Coded Value Default value Duplicate UNMETL Double designtype Water_Valve_Type Types of controllable water valves Coded Value Default value Duplicate UNMETL SmallInteger normalstatus 1 Pipeline_Valve_Status The status of a water device Coded Value Default value Duplicate UNMETL SmallInteger presentstatus 1 Pipeline_Valve_Status The status of a water device Coded Value Default value Duplicate UNMETL SmallInteger additionaldetails Pipeline_Valve_Close_Direction The close direction of a valve Coded Value Default value Duplicate UNMETL SmallInteger operable 1 Boolean True or False Coded Value Default value Duplicate UNMETL SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate UNMETL SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate UNMETL SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate UNMETL SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate UNMETL SmallInteger bondedinsulated Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate UNMETL SmallInteger cptraceability Yes_No_1 Valid Yes, No values Coded Value Default value Duplicate UNMETL SmallInteger spatialsource Spatial_Source_1 Source of the data Coded Value Default value Duplicate UNMETL SmallInteger spatialconfidence Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate UNMETL SmallInteger cpoverride CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate UNMETL SmallInteger operator Yes_No_1 Valid Yes, No values Coded Value Default value Duplicate UNMETL SmallInteger financialassettype Financial_Asset_Type_1 Coded Value Default value Default value UNMETL String councildistrict COH_Council_District_1 City Council Districts Coded Value Default value Default value UNMETL String zone UM_Zones Utility Maintenance Zones Coded Value Default value Default value UNMETL String plantype Plan_Type_1 The type of plans used for digitizing Coded Value Default value Default value UNMETL String projectype Project_Type_1 The type of project Coded Value Default value Default value UNMETL String gfsorwbs Project_Type_2 Project type is GFS or WBS Coded Value Default value Default value UNMETL String condition System_Valve_Condition Condition Rating for Water System Valves Coded Value Default value Default value UNMETL String fiscal_year Fiscal_Year_1 Coded Value Default value Default value UNMETL String gps_positioned GPS_Verified Coded Value Default value Default value UNMETL String lastvendor Valve_Vendor Identifies the last known water valve vendor who worked on a valve. Coded Value Default value Default value UNMETL String maindiameter Water_Main_Diameter List of transmission main sizes, in Imperial units Coded Value Default value Duplicate UNMETL Double lifelinevlv Lifeline_Valve_Ind Lifeline Valve Indicator Yes/No Coded Value Default value Default value UNMETL String insertionvlv Insert_Valve_Ind Insertion Valve Indicator Yes/No Coded Value Default value Default value UNMETL String replacementprojtype Project_Type_1 The type of project Coded Value Default value Default value UNMETL String public_share Y Yes_No_Indicator Valid Y, N Coded Value Default value Default value UNMETL String VALIDATIONSTATUS 6 Validation Status_1 The current record's validation status. Coded Value Default value Default value UNMETL SmallInteger Fire Hydrant 7 ASSETTYPE 0 Asset_Type_Water_Device_Fire_Hydrant The Asset Types for the Water Device's Asset Group Fire Hydrant Coded Value Default value Duplicate UNMETL SmallInteger ASSOCIATIONSTATUS 0 Water_189_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate UNMETL SmallInteger ISSUBNETWORKCONTROLLER 0 Water_189_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value UNMETL SmallInteger ISCONNECTED 2 Water_189_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate UNMETL SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_189_TierName The tier names in the utility network. Coded Value Default value Default value UNMETL SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown diameter 0 Water_Hydrant_Service_Diameter List of hydrant service sizes, in Imperial units Coded Value Default value Duplicate UNMETL Double secondarydiameter 4 Water_Hydrant_Nozzle_Diameter Sizes of a fire hydrants nozzle, in Imperial units Coded Value Default value Duplicate UNMETL Double operable 1 Boolean True or False Coded Value Default value Duplicate UNMETL SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate UNMETL SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate UNMETL SmallInteger additionaldevice 0 Yes_No_1 Valid Yes, No values Coded Value Default value Duplicate UNMETL SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate UNMETL SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate UNMETL SmallInteger bondedinsulated Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate UNMETL SmallInteger cptraceability 0 Yes_No_1 Valid Yes, No values Coded Value Default value Duplicate UNMETL SmallInteger spatialsource 0 Spatial_Source_1 Source of the data Coded Value Default value Duplicate UNMETL SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate UNMETL SmallInteger cpoverride CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate UNMETL SmallInteger manufacturer Water_Fire_Hydrant_Manufacturer The valid hydrant manufacturers Coded Value Default value Duplicate UNMETL SmallInteger financialassettype Financial_Asset_Type_1 Coded Value Default value Default value UNMETL String councildistrict COH_Council_District_1 City Council Districts Coded Value Default value Default value UNMETL String zone UM_Zones Utility Maintenance Zones Coded Value Default value Default value UNMETL String plantype Plan_Type_1 The type of plans used for digitizing Coded Value Default value Default value UNMETL String projectype Project_Type_1 The type of project Coded Value Default value Default value UNMETL String gfsorwbs Project_Type_2 Project type is GFS or WBS Coded Value Default value Default value UNMETL String fiscal_year Fiscal_Year_1 Coded Value Default value Default value UNMETL String gps_positioned GPS_Verified Coded Value Default value Default value UNMETL String maindiameter Water_Main_Diameter List of transmission main sizes, in Imperial units Coded Value Default value Duplicate UNMETL Double replacementprojtype Project_Type_1 The type of project Coded Value Default value Default value UNMETL String nozzlecolor Hydrant_Noz_Color Fire Hydrant Nozzle Color Coded Value Default value Default value UNMETL String bonnetcolor Hydrant_Bon_Color Fire Hydrant Bonnet Color Coded Value Default value Default value UNMETL String barreldiameter Hydrant_Barrel_Diam Barrel Diameter for Fire Hydrants Coded Value Default value Default value UNMETL Double nozzlediameter1 4 Water_Hydrant_Nozzle_Diameter Sizes of a fire hydrants nozzle, in Imperial units Coded Value Default value Duplicate UNMETL Double nozzlediameter2 2.5 Water_Hydrant_Nozzle_Diameter Sizes of a fire hydrants nozzle, in Imperial units Coded Value Default value Duplicate UNMETL Double nozzlediameter3 2.5 Water_Hydrant_Nozzle_Diameter Sizes of a fire hydrants nozzle, in Imperial units Coded Value Default value Duplicate UNMETL Double public_share Y Yes_No_Indicator Valid Y, N Coded Value Default value Default value UNMETL String VALIDATIONSTATUS 6 Validation Status_1 The current record's validation status. Coded Value Default value Default value UNMETL SmallInteger Outlet 8 ASSETTYPE 0 Asset_Type_Water_Device_Outlet The Asset Types for the Water Device's Asset Group Outlet Coded Value Default value Duplicate UNMETL SmallInteger ASSOCIATIONSTATUS 0 Water_189_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate UNMETL SmallInteger ISSUBNETWORKCONTROLLER 0 Water_189_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value UNMETL SmallInteger ISCONNECTED 2 Water_189_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate UNMETL SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_189_TierName The tier names in the utility network. Coded Value Default value Default value UNMETL SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown operable 1 Boolean True or False Coded Value Default value Duplicate UNMETL SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate UNMETL SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate UNMETL SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate UNMETL SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate UNMETL SmallInteger bondedinsulated Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate UNMETL SmallInteger cptraceability 0 Yes_No_1 Valid Yes, No values Coded Value Default value Duplicate UNMETL SmallInteger spatialsource 0 Spatial_Source_1 Source of the data Coded Value Default value Duplicate UNMETL SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate UNMETL SmallInteger cpoverride CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate UNMETL SmallInteger financialassettype Financial_Asset_Type_1 Coded Value Default value Default value UNMETL String councildistrict COH_Council_District_1 City Council Districts Coded Value Default value Default value UNMETL String zone UM_Zones Utility Maintenance Zones Coded Value Default value Default value UNMETL String plantype Plan_Type_1 The type of plans used for digitizing Coded Value Default value Default value UNMETL String projectype Project_Type_1 The type of project Coded Value Default value Default value UNMETL String gfsorwbs Project_Type_2 Project type is GFS or WBS Coded Value Default value Default value UNMETL String fiscal_year Fiscal_Year_1 Coded Value Default value Default value UNMETL String gps_positioned GPS_Verified Coded Value Default value Default value UNMETL String maindiameter Water_Main_Diameter List of transmission main sizes, in Imperial units Coded Value Default value Duplicate UNMETL Double public_share Y Yes_No_Indicator Valid Y, N Coded Value Default value Default value UNMETL String VALIDATIONSTATUS 6 Validation Status_1 The current record's validation status. Coded Value Default value Default value UNMETL SmallInteger Flushing and Blow Off 9 ASSETTYPE 0 Asset_Type_Water_Device_Flushing_and_Blow_Off The Asset Types for the Water Device's Asset Group Flushing and Blow Off Coded Value Default value Duplicate UNMETL SmallInteger ASSOCIATIONSTATUS 0 Water_189_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate UNMETL SmallInteger ISSUBNETWORKCONTROLLER 0 Water_189_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value UNMETL SmallInteger ISCONNECTED 2 Water_189_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate UNMETL SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_189_TierName The tier names in the utility network. Coded Value Default value Default value UNMETL SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown diameter Water_Main_Diameter List of transmission main sizes, in Imperial units Coded Value Default value Duplicate UNMETL Double normalstatus 0 Pipeline_Valve_Status The status of a water device Coded Value Default value Duplicate UNMETL SmallInteger presentstatus 0 Pipeline_Valve_Status The status of a water device Coded Value Default value Duplicate UNMETL SmallInteger operable 1 Boolean True or False Coded Value Default value Duplicate UNMETL SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate UNMETL SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate UNMETL SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate UNMETL SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate UNMETL SmallInteger bondedinsulated Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate UNMETL SmallInteger cptraceability 0 Yes_No_1 Valid Yes, No values Coded Value Default value Duplicate UNMETL SmallInteger spatialsource 0 Spatial_Source_1 Source of the data Coded Value Default value Duplicate UNMETL SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate UNMETL SmallInteger cpoverride CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate UNMETL SmallInteger financialassettype Financial_Asset_Type_1 Coded Value Default value Default value UNMETL String councildistrict COH_Council_District_1 City Council Districts Coded Value Default value Default value UNMETL String zone UM_Zones Utility Maintenance Zones Coded Value Default value Default value UNMETL String plantype Plan_Type_1 The type of plans used for digitizing Coded Value Default value Default value UNMETL String projectype Project_Type_1 The type of project Coded Value Default value Default value UNMETL String gfsorwbs Project_Type_2 Project type is GFS or WBS Coded Value Default value Default value UNMETL String fiscal_year Fiscal_Year_1 Coded Value Default value Default value UNMETL String gps_positioned GPS_Verified Coded Value Default value Default value UNMETL String lastvendor Valve_Vendor Identifies the last known water valve vendor who worked on a valve. Coded Value Default value Default value UNMETL String maindiameter Water_Main_Diameter List of transmission main sizes, in Imperial units Coded Value Default value Duplicate UNMETL Double public_share Y Yes_No_Indicator Valid Y, N Coded Value Default value Default value UNMETL String VALIDATIONSTATUS 6 Validation Status_1 The current record's validation status. Coded Value Default value Default value UNMETL SmallInteger Service Meter 10 ASSETTYPE 0 Asset_Type_Water_Device_Service_Meter The Asset Types for the Water Device's Asset Group Service Meter Coded Value Default value Duplicate UNMETL SmallInteger ASSOCIATIONSTATUS 0 Water_189_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate UNMETL SmallInteger ISSUBNETWORKCONTROLLER 0 Water_189_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value UNMETL SmallInteger ISCONNECTED 2 Water_189_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate UNMETL SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_189_TierName The tier names in the utility network. Coded Value Default value Default value UNMETL SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown diameter Water_Meter_Diameter General list of service sizes, in Imperial units Coded Value Default value Duplicate UNMETL Double designtype Water_Meter_Type Coded Value Default value Default value UNMETL SmallInteger operable 1 Boolean True or False Coded Value Default value Duplicate UNMETL SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate UNMETL SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate UNMETL SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate UNMETL SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate UNMETL SmallInteger bondedinsulated Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate UNMETL SmallInteger cptraceability Yes_No_1 Valid Yes, No values Coded Value Default value Duplicate UNMETL SmallInteger spatialsource Spatial_Source_1 Source of the data Coded Value Default value Duplicate UNMETL SmallInteger spatialconfidence Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate UNMETL SmallInteger cpoverride CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate UNMETL SmallInteger financialassettype Financial_Asset_Type_1 Coded Value Default value Default value UNMETL String councildistrict COH_Council_District_1 City Council Districts Coded Value Default value Default value UNMETL String zone UM_Zones Utility Maintenance Zones Coded Value Default value Default value UNMETL String plantype Plan_Type_1 The type of plans used for digitizing Coded Value Default value Default value UNMETL String projectype Project_Type_1 The type of project Coded Value Default value Default value UNMETL String gfsorwbs Project_Type_2 Project type is GFS or WBS Coded Value Default value Default value UNMETL String fiscal_year Fiscal_Year_1 Coded Value Default value Default value UNMETL String gps_positioned GPS_Verified Coded Value Default value Default value UNMETL String maindiameter Water_Main_Diameter List of transmission main sizes, in Imperial units Coded Value Default value Duplicate UNMETL Double public_share Y Yes_No_Indicator Valid Y, N Coded Value Default value Default value UNMETL String VALIDATIONSTATUS 6 Validation Status_1 The current record's validation status. Coded Value Default value Default value UNMETL SmallInteger Monitoring 11 ASSETTYPE 0 Asset_Type_Water_Device_Monitoring The Asset Types for the Water Device's Asset Group Monitoring Coded Value Default value Duplicate UNMETL SmallInteger ASSOCIATIONSTATUS 0 Water_189_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate UNMETL SmallInteger ISSUBNETWORKCONTROLLER 0 Water_189_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value UNMETL SmallInteger ISCONNECTED 2 Water_189_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate UNMETL SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_189_TierName The tier names in the utility network. Coded Value Default value Default value UNMETL SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown operable Boolean True or False Coded Value Default value Duplicate UNMETL SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate UNMETL SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate UNMETL SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate UNMETL SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate UNMETL SmallInteger bondedinsulated Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate UNMETL SmallInteger cptraceability 0 Yes_No_1 Valid Yes, No values Coded Value Default value Duplicate UNMETL SmallInteger spatialsource 0 Spatial_Source_1 Source of the data Coded Value Default value Duplicate UNMETL SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate UNMETL SmallInteger cpoverride CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate UNMETL SmallInteger financialassettype Financial_Asset_Type_1 Coded Value Default value Default value UNMETL String councildistrict COH_Council_District_1 City Council Districts Coded Value Default value Default value UNMETL String zone UM_Zones Utility Maintenance Zones Coded Value Default value Default value UNMETL String plantype Plan_Type_1 The type of plans used for digitizing Coded Value Default value Default value UNMETL String projectype Project_Type_1 The type of project Coded Value Default value Default value UNMETL String gfsorwbs Project_Type_2 Project type is GFS or WBS Coded Value Default value Default value UNMETL String fiscal_year Fiscal_Year_1 Coded Value Default value Default value UNMETL String gps_positioned GPS_Verified Coded Value Default value Default value UNMETL String maindiameter Water_Main_Diameter List of transmission main sizes, in Imperial units Coded Value Default value Duplicate UNMETL Double public_share Y Yes_No_Indicator Valid Y, N Coded Value Default value Default value UNMETL String VALIDATIONSTATUS 6 Validation Status_1 The current record's validation status. Coded Value Default value Default value UNMETL SmallInteger Service Connection 12 ASSETTYPE 0 Asset_Type_Water_Device_Service_Connection The Asset Types for the Water Junction's Asset Group Service Connection Coded Value Default value Duplicate UNMETL SmallInteger ASSOCIATIONSTATUS 0 Water_189_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate UNMETL SmallInteger ISSUBNETWORKCONTROLLER 0 Water_189_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value UNMETL SmallInteger ISCONNECTED 2 Water_189_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate UNMETL SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_189_TierName The tier names in the utility network. Coded Value Default value Default value UNMETL SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown additionaldetails 2 Yes_No_1 Valid Yes, No values Coded Value Default value Duplicate UNMETL SmallInteger operable 1 Boolean True or False Coded Value Default value Duplicate UNMETL SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate UNMETL SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate UNMETL SmallInteger additionaldevice 2 Yes_No_1 Valid Yes, No values Coded Value Default value Duplicate UNMETL SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate UNMETL SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate UNMETL SmallInteger bondedinsulated Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate UNMETL SmallInteger cptraceability 0 Yes_No_1 Valid Yes, No values Coded Value Default value Duplicate UNMETL SmallInteger spatialsource 0 Spatial_Source_1 Source of the data Coded Value Default value Duplicate UNMETL SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate UNMETL SmallInteger cpoverride CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate UNMETL SmallInteger financialassettype Financial_Asset_Type_1 Coded Value Default value Default value UNMETL String councildistrict COH_Council_District_1 City Council Districts Coded Value Default value Default value UNMETL String zone UM_Zones Utility Maintenance Zones Coded Value Default value Default value UNMETL String plantype Plan_Type_1 The type of plans used for digitizing Coded Value Default value Default value UNMETL String projectype Project_Type_1 The type of project Coded Value Default value Default value UNMETL String gfsorwbs Project_Type_2 Project type is GFS or WBS Coded Value Default value Default value UNMETL String fiscal_year Fiscal_Year_1 Coded Value Default value Default value UNMETL String gps_positioned GPS_Verified Coded Value Default value Default value UNMETL String maindiameter Water_Main_Diameter List of transmission main sizes, in Imperial units Coded Value Default value Duplicate UNMETL Double public_share Y Yes_No_Indicator Valid Y, N Coded Value Default value Default value UNMETL String VALIDATIONSTATUS 6 Validation Status_1 The current record's validation status. Coded Value Default value Default value UNMETL SmallInteger System Meter 13 ASSETTYPE 0 Asset_Type_Water_Device_System_Meter The Asset Types for the Water Device's Asset Group System Meter Coded Value Default value Duplicate UNMETL SmallInteger ASSOCIATIONSTATUS 0 Water_189_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate UNMETL SmallInteger ISSUBNETWORKCONTROLLER 0 Water_189_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value UNMETL SmallInteger ISCONNECTED 2 Water_189_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate UNMETL SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_189_TierName The tier names in the utility network. Coded Value Default value Default value UNMETL SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown diameter Water_Meter_Diameter General list of service sizes, in Imperial units Coded Value Default value Duplicate UNMETL Double operable 1 Boolean True or False Coded Value Default value Duplicate UNMETL SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate UNMETL SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate UNMETL SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate UNMETL SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate UNMETL SmallInteger bondedinsulated Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate UNMETL SmallInteger cptraceability Yes_No_1 Valid Yes, No values Coded Value Default value Duplicate UNMETL SmallInteger spatialsource Spatial_Source_1 Source of the data Coded Value Default value Duplicate UNMETL SmallInteger spatialconfidence Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate UNMETL SmallInteger cpoverride CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate UNMETL SmallInteger financialassettype Financial_Asset_Type_1 Coded Value Default value Default value UNMETL String councildistrict COH_Council_District_1 City Council Districts Coded Value Default value Default value UNMETL String zone UM_Zones Utility Maintenance Zones Coded Value Default value Default value UNMETL String plantype Plan_Type_1 The type of plans used for digitizing Coded Value Default value Default value UNMETL String projectype Project_Type_1 The type of project Coded Value Default value Default value UNMETL String gfsorwbs Project_Type_2 Project type is GFS or WBS Coded Value Default value Default value UNMETL String fiscal_year Fiscal_Year_1 Coded Value Default value Default value UNMETL String gps_positioned GPS_Verified Coded Value Default value Default value UNMETL String maindiameter Water_Main_Diameter List of transmission main sizes, in Imperial units Coded Value Default value Duplicate UNMETL Double public_share Y Yes_No_Indicator Valid Y, N Coded Value Default value Default value UNMETL String VALIDATIONSTATUS 6 Validation Status_1 The current record's validation status. Coded Value Default value Default value UNMETL SmallInteger Supply 15 ASSETTYPE 0 Asset_Type_Water_Device_Supply The Asset Types for the Water Device's Asset Group Supply Coded Value Default value Duplicate UNMETL SmallInteger ASSOCIATIONSTATUS 0 Water_189_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate UNMETL SmallInteger ISSUBNETWORKCONTROLLER 0 Water_189_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value UNMETL SmallInteger ISCONNECTED 2 Water_189_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate UNMETL SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_189_TierName The tier names in the utility network. Coded Value Default value Default value UNMETL SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown diameter 0 Water_Well_Diameter General list of well sizes Coded Value Default value Duplicate UNMETL Double designtype Water_Type List of water types Coded Value Default value Duplicate UNMETL SmallInteger operable 1 Boolean True or False Coded Value Default value Duplicate UNMETL SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate UNMETL SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate UNMETL SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate UNMETL SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate UNMETL SmallInteger bondedinsulated Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate UNMETL SmallInteger cptraceability 0 Yes_No_1 Valid Yes, No values Coded Value Default value Duplicate UNMETL SmallInteger spatialsource 0 Spatial_Source_1 Source of the data Coded Value Default value Duplicate UNMETL SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate UNMETL SmallInteger cpoverride CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate UNMETL SmallInteger financialassettype Financial_Asset_Type_1 Coded Value Default value Default value UNMETL String councildistrict COH_Council_District_1 City Council Districts Coded Value Default value Default value UNMETL String zone UM_Zones Utility Maintenance Zones Coded Value Default value Default value UNMETL String plantype Plan_Type_1 The type of plans used for digitizing Coded Value Default value Default value UNMETL String projectype Project_Type_1 The type of project Coded Value Default value Default value UNMETL String largemaindiameter Water_Main_Diameter List of transmission main sizes, in Imperial units Coded Value Default value Duplicate UNMETL Double smallmaindiameter Water_Main_Diameter List of transmission main sizes, in Imperial units Coded Value Default value Duplicate UNMETL Double gfsorwbs Project_Type_2 Project type is GFS or WBS Coded Value Default value Default value UNMETL String fiscal_year Fiscal_Year_1 Coded Value Default value Default value UNMETL String gps_positioned GPS_Verified Coded Value Default value Default value UNMETL String maindiameter Water_Main_Diameter List of transmission main sizes, in Imperial units Coded Value Default value Duplicate UNMETL Double public_share Y Yes_No_Indicator Valid Y, N Coded Value Default value Default value UNMETL String VALIDATIONSTATUS 6 Validation Status_1 The current record's validation status. Coded Value Default value Default value UNMETL SmallInteger Filter 17 ASSETTYPE 0 Asset_Type_Water_Device_Filter The Asset Types for the Water Device's Asset Group Filter Coded Value Default value Duplicate UNMETL SmallInteger ASSOCIATIONSTATUS 0 Water_189_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate UNMETL SmallInteger ISSUBNETWORKCONTROLLER 0 Water_189_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value UNMETL SmallInteger ISCONNECTED 2 Water_189_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate UNMETL SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_189_TierName The tier names in the utility network. Coded Value Default value Default value UNMETL SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown operable 1 Boolean True or False Coded Value Default value Duplicate UNMETL SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate UNMETL SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate UNMETL SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate UNMETL SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate UNMETL SmallInteger bondedinsulated Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate UNMETL SmallInteger cptraceability 0 Yes_No_1 Valid Yes, No values Coded Value Default value Duplicate UNMETL SmallInteger spatialsource 0 Spatial_Source_1 Source of the data Coded Value Default value Duplicate UNMETL SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate UNMETL SmallInteger cpoverride CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate UNMETL SmallInteger financialassettype Financial_Asset_Type_1 Coded Value Default value Default value UNMETL String councildistrict COH_Council_District_1 City Council Districts Coded Value Default value Default value UNMETL String zone UM_Zones Utility Maintenance Zones Coded Value Default value Default value UNMETL String plantype Plan_Type_1 The type of plans used for digitizing Coded Value Default value Default value UNMETL String projectype Project_Type_1 The type of project Coded Value Default value Default value UNMETL String gfsorwbs Project_Type_2 Project type is GFS or WBS Coded Value Default value Default value UNMETL String fiscal_year Fiscal_Year_1 Coded Value Default value Default value UNMETL String gps_positioned GPS_Verified Coded Value Default value Default value UNMETL String maindiameter Water_Main_Diameter List of transmission main sizes, in Imperial units Coded Value Default value Duplicate UNMETL Double public_share Y Yes_No_Indicator Valid Y, N Coded Value Default value Default value UNMETL String VALIDATIONSTATUS 6 Validation Status_1 The current record's validation status. Coded Value Default value Default value UNMETL SmallInteger Controller 18 ASSETTYPE 0 Asset_Type_Water_Device_Controller The Asset Types for the Water Device's Asset Group Controller Coded Value Default value Duplicate UNMETL SmallInteger ASSOCIATIONSTATUS 0 Water_189_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate UNMETL SmallInteger ISSUBNETWORKCONTROLLER 0 Water_189_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value UNMETL SmallInteger ISCONNECTED 2 Water_189_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate UNMETL SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_189_TierName The tier names in the utility network. Coded Value Default value Default value UNMETL SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown operable 1 Boolean True or False Coded Value Default value Duplicate UNMETL SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate UNMETL SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate UNMETL SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate UNMETL SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate UNMETL SmallInteger bondedinsulated Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate UNMETL SmallInteger cptraceability 0 Yes_No_1 Valid Yes, No values Coded Value Default value Duplicate UNMETL SmallInteger spatialsource 0 Spatial_Source_1 Source of the data Coded Value Default value Duplicate UNMETL SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate UNMETL SmallInteger cpoverride CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate UNMETL SmallInteger financialassettype Financial_Asset_Type_1 Coded Value Default value Default value UNMETL String councildistrict COH_Council_District_1 City Council Districts Coded Value Default value Default value UNMETL String zone UM_Zones Utility Maintenance Zones Coded Value Default value Default value UNMETL String plantype Plan_Type_1 The type of plans used for digitizing Coded Value Default value Default value UNMETL String projectype Project_Type_1 The type of project Coded Value Default value Default value UNMETL String gfsorwbs Project_Type_2 Project type is GFS or WBS Coded Value Default value Default value UNMETL String fiscal_year Fiscal_Year_1 Coded Value Default value Default value UNMETL String gps_positioned GPS_Verified Coded Value Default value Default value UNMETL String maindiameter Water_Main_Diameter List of transmission main sizes, in Imperial units Coded Value Default value Duplicate UNMETL Double public_share Y Yes_No_Indicator Valid Y, N Coded Value Default value Default value UNMETL String VALIDATIONSTATUS 6 Validation Status_1 The current record's validation status. Coded Value Default value Default value UNMETL SmallInteger Injection Facility 19 ASSETTYPE 0 Asset_Type_Water_Device_Injection_Facility The Asset Types for the Water Device's Asset Group Injection Facility Coded Value Default value Duplicate UNMETL SmallInteger ASSOCIATIONSTATUS 0 Water_189_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate UNMETL SmallInteger ISSUBNETWORKCONTROLLER 0 Water_189_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value UNMETL SmallInteger ISCONNECTED 2 Water_189_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate UNMETL SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_189_TierName The tier names in the utility network. Coded Value Default value Default value UNMETL SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown operable 1 Boolean True or False Coded Value Default value Duplicate UNMETL SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate UNMETL SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate UNMETL SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate UNMETL SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate UNMETL SmallInteger bondedinsulated Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate UNMETL SmallInteger cptraceability 0 Yes_No_1 Valid Yes, No values Coded Value Default value Duplicate UNMETL SmallInteger spatialsource 0 Spatial_Source_1 Source of the data Coded Value Default value Duplicate UNMETL SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate UNMETL SmallInteger cpoverride CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate UNMETL SmallInteger financialassettype Financial_Asset_Type_1 Coded Value Default value Default value UNMETL String councildistrict COH_Council_District_1 City Council Districts Coded Value Default value Default value UNMETL String zone UM_Zones Utility Maintenance Zones Coded Value Default value Default value UNMETL String plantype Plan_Type_1 The type of plans used for digitizing Coded Value Default value Default value UNMETL String projectype Project_Type_1 The type of project Coded Value Default value Default value UNMETL String gfsorwbs Project_Type_2 Project type is GFS or WBS Coded Value Default value Default value UNMETL String fiscal_year Fiscal_Year_1 Coded Value Default value Default value UNMETL String gps_positioned GPS_Verified Coded Value Default value Default value UNMETL String maindiameter Water_Main_Diameter List of transmission main sizes, in Imperial units Coded Value Default value Duplicate UNMETL Double public_share Y Yes_No_Indicator Valid Y, N Coded Value Default value Default value UNMETL String VALIDATIONSTATUS 6 Validation Status_1 The current record's validation status. Coded Value Default value Default value UNMETL SmallInteger Storage 20 ASSETTYPE 0 Asset_Type_Water_Device_Storage The Asset Types for the Water Device's Asset Group Storage Coded Value Default value Duplicate UNMETL SmallInteger ASSOCIATIONSTATUS 0 Water_189_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate UNMETL SmallInteger ISSUBNETWORKCONTROLLER 0 Water_189_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value UNMETL SmallInteger ISCONNECTED 2 Water_189_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate UNMETL SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_189_TierName The tier names in the utility network. Coded Value Default value Default value UNMETL SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown designtype Water_Type List of water types Coded Value Default value Duplicate UNMETL SmallInteger operable 1 Boolean True or False Coded Value Default value Duplicate UNMETL SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate UNMETL SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate UNMETL SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate UNMETL SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate UNMETL SmallInteger bondedinsulated Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate UNMETL SmallInteger cptraceability 0 Yes_No_1 Valid Yes, No values Coded Value Default value Duplicate UNMETL SmallInteger spatialsource 0 Spatial_Source_1 Source of the data Coded Value Default value Duplicate UNMETL SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate UNMETL SmallInteger cpoverride CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate UNMETL SmallInteger financialassettype Financial_Asset_Type_1 Coded Value Default value Default value UNMETL String councildistrict COH_Council_District_1 City Council Districts Coded Value Default value Default value UNMETL String zone UM_Zones Utility Maintenance Zones Coded Value Default value Default value UNMETL String plantype Plan_Type_1 The type of plans used for digitizing Coded Value Default value Default value UNMETL String projectype Project_Type_1 The type of project Coded Value Default value Default value UNMETL String largemaindiameter Water_Main_Diameter List of transmission main sizes, in Imperial units Coded Value Default value Duplicate UNMETL Double smallmaindiameter Water_Main_Diameter List of transmission main sizes, in Imperial units Coded Value Default value Duplicate UNMETL Double gfsorwbs Project_Type_2 Project type is GFS or WBS Coded Value Default value Default value UNMETL String fiscal_year Fiscal_Year_1 Coded Value Default value Default value UNMETL String gps_positioned GPS_Verified Coded Value Default value Default value UNMETL String maindiameter Water_Main_Diameter List of transmission main sizes, in Imperial units Coded Value Default value Duplicate UNMETL Double public_share Y Yes_No_Indicator Valid Y, N Coded Value Default value Default value UNMETL String VALIDATIONSTATUS 6 Validation Status_1 The current record's validation status. Coded Value Default value Default value UNMETL SmallInteger Anode 50 ASSETTYPE 0 Asset_Type_Water_Device_Anode The Asset Types for the Water Device's Asset Group Anode Coded Value Default value Duplicate UNMETL SmallInteger ASSOCIATIONSTATUS 0 Water_189_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate UNMETL SmallInteger ISSUBNETWORKCONTROLLER 0 Water_189_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value UNMETL SmallInteger ISCONNECTED 2 Water_189_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate UNMETL SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_189_TierName The tier names in the utility network. Coded Value Default value Default value UNMETL SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown diameter 0 CP_Anode_Weight List of valid anode weights Coded Value Default value Duplicate UNMETL Double additionaldetails 0 CP_Anode_Material_short List of materials used for Anodes Coded Value Default value Duplicate UNMETL SmallInteger operable 1 Boolean True or False Coded Value Default value Duplicate UNMETL SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate UNMETL SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate UNMETL SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate UNMETL SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate UNMETL SmallInteger bondedinsulated Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate UNMETL SmallInteger cptraceability 1 Yes_No_1 Valid Yes, No values Coded Value Default value Duplicate UNMETL SmallInteger spatialsource 0 Spatial_Source_1 Source of the data Coded Value Default value Duplicate UNMETL SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate UNMETL SmallInteger cpoverride CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate UNMETL SmallInteger financialassettype Financial_Asset_Type_1 Coded Value Default value Default value UNMETL String councildistrict COH_Council_District_1 City Council Districts Coded Value Default value Default value UNMETL String zone UM_Zones Utility Maintenance Zones Coded Value Default value Default value UNMETL String plantype Plan_Type_1 The type of plans used for digitizing Coded Value Default value Default value UNMETL String projectype Project_Type_1 The type of project Coded Value Default value Default value UNMETL String gfsorwbs Project_Type_2 Project type is GFS or WBS Coded Value Default value Default value UNMETL String fiscal_year Fiscal_Year_1 Coded Value Default value Default value UNMETL String gps_positioned GPS_Verified Coded Value Default value Default value UNMETL String maindiameter Water_Main_Diameter List of transmission main sizes, in Imperial units Coded Value Default value Duplicate UNMETL Double public_share Y Yes_No_Indicator Valid Y, N Coded Value Default value Default value UNMETL String VALIDATIONSTATUS 6 Validation Status_1 The current record's validation status. Coded Value Default value Default value UNMETL SmallInteger Rectifier 51 ASSETTYPE 0 Asset_Type_Water_Device_Rectifier The Asset Types for the Water Device Asset Group Rectifier Coded Value Default value Duplicate UNMETL SmallInteger ASSOCIATIONSTATUS 0 Water_189_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate UNMETL SmallInteger ISSUBNETWORKCONTROLLER 0 Water_189_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value UNMETL SmallInteger ISCONNECTED 2 Water_189_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate UNMETL SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_189_TierName The tier names in the utility network. Coded Value Default value Default value UNMETL SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown designtype Water_Rectifier_Type Design type for rectifier Coded Value Default value Default value UNMETL SmallInteger additionaldetails 0 CP_Rectifier_Cooling_Method List of rectifier cooling methods Coded Value Default value Duplicate UNMETL SmallInteger operable 1 Boolean True or False Coded Value Default value Duplicate UNMETL SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate UNMETL SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate UNMETL SmallInteger additionaldevice 0 Yes_No_1 Valid Yes, No values Coded Value Default value Duplicate UNMETL SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate UNMETL SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate UNMETL SmallInteger bondedinsulated Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate UNMETL SmallInteger cptraceability 1 Yes_No_1 Valid Yes, No values Coded Value Default value Duplicate UNMETL SmallInteger spatialsource 0 Spatial_Source_1 Source of the data Coded Value Default value Duplicate UNMETL SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate UNMETL SmallInteger cpoverride CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate UNMETL SmallInteger manufacturer CP_Rectifier_Manufacturer_int List of manufacturers for rectifiers Coded Value Default value Duplicate UNMETL SmallInteger financialassettype Financial_Asset_Type_1 Coded Value Default value Default value UNMETL String councildistrict COH_Council_District_1 City Council Districts Coded Value Default value Default value UNMETL String zone UM_Zones Utility Maintenance Zones Coded Value Default value Default value UNMETL String plantype Plan_Type_1 The type of plans used for digitizing Coded Value Default value Default value UNMETL String projectype Project_Type_1 The type of project Coded Value Default value Default value UNMETL String gfsorwbs Project_Type_2 Project type is GFS or WBS Coded Value Default value Default value UNMETL String fiscal_year Fiscal_Year_1 Coded Value Default value Default value UNMETL String gps_positioned GPS_Verified Coded Value Default value Default value UNMETL String maindiameter Water_Main_Diameter List of transmission main sizes, in Imperial units Coded Value Default value Duplicate UNMETL Double public_share Y Yes_No_Indicator Valid Y, N Coded Value Default value Default value UNMETL String VALIDATIONSTATUS 6 Validation Status_1 The current record's validation status. Coded Value Default value Default value UNMETL SmallInteger Test Point 52 ASSETTYPE 0 Asset_Type_Water_Device_Test_Point The Asset Types for the Water Device's Asset Group Test Point Coded Value Default value Duplicate UNMETL SmallInteger ASSOCIATIONSTATUS 0 Water_189_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate UNMETL SmallInteger ISSUBNETWORKCONTROLLER 0 Water_189_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value UNMETL SmallInteger ISCONNECTED 2 Water_189_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate UNMETL SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_189_TierName The tier names in the utility network. Coded Value Default value Default value UNMETL SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown designtype CP_Test_Point_Wire_Count Number of wires on a test point Coded Value Default value Duplicate UNMETL SmallInteger operable 1 Boolean True or False Coded Value Default value Duplicate UNMETL SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate UNMETL SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate UNMETL SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate UNMETL SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate UNMETL SmallInteger bondedinsulated Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate UNMETL SmallInteger cptraceability 1 Yes_No_1 Valid Yes, No values Coded Value Default value Duplicate UNMETL SmallInteger spatialsource 0 Spatial_Source_1 Source of the data Coded Value Default value Duplicate UNMETL SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate UNMETL SmallInteger cpoverride CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate UNMETL SmallInteger financialassettype Financial_Asset_Type_1 Coded Value Default value Default value UNMETL String councildistrict COH_Council_District_1 City Council Districts Coded Value Default value Default value UNMETL String zone UM_Zones Utility Maintenance Zones Coded Value Default value Default value UNMETL String plantype Plan_Type_1 The type of plans used for digitizing Coded Value Default value Default value UNMETL String projectype Project_Type_1 The type of project Coded Value Default value Default value UNMETL String gfsorwbs Project_Type_2 Project type is GFS or WBS Coded Value Default value Default value UNMETL String fiscal_year Fiscal_Year_1 Coded Value Default value Default value UNMETL String gps_positioned GPS_Verified Coded Value Default value Default value UNMETL String maindiameter Water_Main_Diameter List of transmission main sizes, in Imperial units Coded Value Default value Duplicate UNMETL Double public_share Y Yes_No_Indicator Valid Y, N Coded Value Default value Default value UNMETL String VALIDATIONSTATUS 6 Validation Status_1 The current record's validation status. Coded Value Default value Default value UNMETL SmallInteger Groundbed 53 ASSETTYPE 0 Asset_Type_Water_Device_Groundbed The AssetType domain for the Groundbed AssetGroup. Coded Value Default value Duplicate UNMETL SmallInteger ASSOCIATIONSTATUS 0 Water_189_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate UNMETL SmallInteger ISSUBNETWORKCONTROLLER 0 Water_189_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value UNMETL SmallInteger ISCONNECTED 2 Water_189_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate UNMETL SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_189_TierName The tier names in the utility network. Coded Value Default value Default value UNMETL SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown additionaldetails Groundbed_Depth The depth of bed. Coded Value Default value Duplicate UNMETL SmallInteger operable 1 Boolean True or False Coded Value Default value Duplicate UNMETL SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate UNMETL SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate UNMETL SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate UNMETL SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate UNMETL SmallInteger bondedinsulated Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate UNMETL SmallInteger cptraceability 0 Yes_No_1 Valid Yes, No values Coded Value Default value Duplicate UNMETL SmallInteger spatialsource Spatial_Source_1 Source of the data Coded Value Default value Duplicate UNMETL SmallInteger spatialconfidence Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate UNMETL SmallInteger cpoverride CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate UNMETL SmallInteger financialassettype Financial_Asset_Type_1 Coded Value Default value Default value UNMETL String councildistrict COH_Council_District_1 City Council Districts Coded Value Default value Default value UNMETL String zone UM_Zones Utility Maintenance Zones Coded Value Default value Default value UNMETL String plantype Plan_Type_1 The type of plans used for digitizing Coded Value Default value Default value UNMETL String projectype Project_Type_1 The type of project Coded Value Default value Default value UNMETL String gfsorwbs Project_Type_2 Project type is GFS or WBS Coded Value Default value Default value UNMETL String fiscal_year Fiscal_Year_1 Coded Value Default value Default value UNMETL String gps_positioned GPS_Verified Coded Value Default value Default value UNMETL String maindiameter Water_Main_Diameter List of transmission main sizes, in Imperial units Coded Value Default value Duplicate UNMETL Double VALIDATIONSTATUS 6 Validation Status_1 The current record's validation status. Coded Value Default value Default value UNMETL SmallInteger 20240327