20230104 15391000 1.0 FALSE WaterDevice 002 Projected GCS_WGS_1984 Linear Unit: Meter (1.000000) WGS_1984_Web_Mercator_Auxiliary_Sphere <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/3.0.0'><WKT>PROJCS[&quot;WGS_1984_Web_Mercator_Auxiliary_Sphere&quot;,GEOGCS[&quot;GCS_WGS_1984&quot;,DATUM[&quot;D_WGS_1984&quot;,SPHEROID[&quot;WGS_1984&quot;,6378137.0,298.257223563]],PRIMEM[&quot;Greenwich&quot;,0.0],UNIT[&quot;Degree&quot;,0.0174532925199433]],PROJECTION[&quot;Mercator_Auxiliary_Sphere&quot;],PARAMETER[&quot;False_Easting&quot;,0.0],PARAMETER[&quot;False_Northing&quot;,0.0],PARAMETER[&quot;Central_Meridian&quot;,0.0],PARAMETER[&quot;Standard_Parallel_1&quot;,0.0],PARAMETER[&quot;Auxiliary_Sphere_Type&quot;,0.0],UNIT[&quot;Meter&quot;,1.0],AUTHORITY[&quot;EPSG&quot;,3857]]</WKT><XOrigin>-20037700</XOrigin><YOrigin>-30241100</YOrigin><XYScale>10000</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102100</WKID><LatestWKID>3857</LatestWKID></ProjectedCoordinateSystem> 20230429 10371800 20230429 10371800 Esri ArcGIS 13.0.0.36056 WaterDevice Enterprise Geodatabase Feature Class dataset EPSG 6.18.3(9.3.1.2) 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. Shape Shape Geometry 8 0 0 Feature geometry. Esri Coordinates defining the features. 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 tiername: Tier name Integer 4 10 0 TIERRANK Tier rank Integer 4 10 0 TERMINALCONFIGURATION terminalconfiguration: Terminal path String 128 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 cpsubnetworkname 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 systemsubnetworkname: System Subnetwork Name String 2000 0 0 PressureSubnetworkName pressuresubnetworkname: Pressure Subnetwork Name String 2000 0 0 IsolationSubnetworkName isolationsubnetworkname: Isolation Subnetwork Name String 2000 0 0 DMASubnetworkName dmasubnetworkname: DMA Subnetwork Name String 2000 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: Design Type, Manufacturer, Pump Type, Test Wire Count, Valve Type, Wire Count SmallInteger 2 5 0 normalstatus normalstatus: Normal Status SmallInteger 2 5 0 presentstatus presentstatus: Present Status SmallInteger 2 5 0 additionaldetails additionaldetails: Clockwise to Close, Cooling Method, Critical, Material SmallInteger 2 5 0 designinfo designinfo: Rated Flow, Turns to Close, Voltage Double 8 38 8 operable operable: Operable SmallInteger 2 5 0 name name: Name String 64 0 0 installdate installdate: Install Date Date 8 0 0 assetid assetid: Asset ID String 64 0 0 accountid accountid: Account ID String 50 0 0 ownedby ownedby: Owned By SmallInteger 2 5 0 maintby maintby: Maintained By SmallInteger 2 5 0 additionaldevice additionaldevice: Additional Device, Has Bypass, Internal Meter, Metered SmallInteger 2 5 0 notes notes: Notes String 2000 0 0 symbolrotation symbolrotation: Symbol Rotation SmallInteger 2 5 0 lastmaint lastmaint: Last Maintenance Date 8 0 0 lifecyclestatus lifecyclestatus: Lifecycle Status SmallInteger 2 5 0 bondedinsulated bondedinsulated: Bonded/Insulated SmallInteger 2 5 0 cptraceability cptraceability: Cathodic Protection Traceability SmallInteger 2 5 0 inservicedate inservicedate: In-Service Date Date 8 0 0 retireddate retireddate: Retired Date Date 8 0 0 spatialsource spatialsource: Spatial Source SmallInteger 2 5 0 spatialconfidence spatialconfidence: Spatial Confidence SmallInteger 2 5 0 cpoverride cpoverride: Cathodic Protection Override SmallInteger 2 5 0 adminarea Administrative Area String 60 0 0 opsarea Operational Area String 60 0 0 watersystem Water System String 25 0 0 planidinstall PlanID (installed) Integer 4 10 0 planidretire PlanID (retired) Integer 4 10 0 mapcorrectid Map CorrectionID String 20 0 0 Unknown 0 ASSETTYPE 0 Water_UN_324_UnknownAssetType The AssetType domain for the Unknown AssetGroup. Coded Value Default value Default value DBO SmallInteger ASSOCIATIONSTATUS 0 Water_UN_324_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 Water_UN_324_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 Water_UN_324_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_UN_324_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown normalstatus 1 324_Pipeline_Valve_Status The status of a water device Coded Value Default value Duplicate DBO SmallInteger presentstatus 1 324_Pipeline_Valve_Status The status of a water device Coded Value Default value Duplicate DBO SmallInteger operable 1 324_Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 324_Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 324_Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation 324_Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger bondedinsulated 324_Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate DBO SmallInteger cptraceability 0 324_Yes_No Valid Yes, No values Coded Value Default value Duplicate DBO SmallInteger adminarea 324_Admin_Area Detailed list of asset owners and managers Coded Value Default value Duplicate DBO String opsarea 324_Ops_Area List of LCPW operation areas Coded Value Default value Duplicate DBO String watersystem 324_Water_System Water systems that LCPW operates within or connects to. Coded Value Default value Duplicate DBO String Flow Valve 1 ASSETTYPE 0 324_Asset_Type_Water_Device_Flow_Valve The Asset Types for the Water Device's Asset Group Flow Valve Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 Water_UN_324_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 Water_UN_324_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 Water_UN_324_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_UN_324_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown diameter 0 324_Water_Diameter General domain for the diameter of water assets, in Imperial units Coded Value Default value Duplicate DBO Double normalstatus 3 324_Pipeline_Device_Status Status of device Coded Value Default value Duplicate DBO SmallInteger presentstatus 3 324_Pipeline_Device_Status Status of device Coded Value Default value Duplicate DBO SmallInteger operable 1 324_Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 324_Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 324_Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation 324_Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 324_Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger bondedinsulated 324_Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate DBO SmallInteger cptraceability 0 324_Yes_No Valid Yes, No values Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 324_Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 324_Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger cpoverride 324_CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate DBO SmallInteger adminarea 324_Admin_Area Detailed list of asset owners and managers Coded Value Default value Duplicate DBO String opsarea 324_Ops_Area List of LCPW operation areas Coded Value Default value Duplicate DBO String watersystem 324_Water_System Water systems that LCPW operates within or connects to. Coded Value Default value Duplicate DBO String Meter 10 ASSETTYPE 0 324_Asset_Type_Water_Device_Meter The Asset Types for the Water Device's Asset Group Meter Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 Water_UN_324_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 Water_UN_324_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 Water_UN_324_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_UN_324_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown diameter 0 324_Water_Meter_Diameter General list of service sizes, in Imperial units Coded Value Default value Duplicate DBO Double normalstatus 3 324_Pipeline_Device_Status Status of device Coded Value Default value Duplicate DBO SmallInteger presentstatus 3 324_Pipeline_Device_Status Status of device Coded Value Default value Duplicate DBO SmallInteger operable 1 324_Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 324_Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 324_Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation 324_Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 324_Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger bondedinsulated 324_Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate DBO SmallInteger cptraceability 0 324_Yes_No Valid Yes, No values Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 324_Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 324_Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger cpoverride 324_CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate DBO SmallInteger adminarea 324_Admin_Area Detailed list of asset owners and managers Coded Value Default value Duplicate DBO String opsarea 324_Ops_Area List of LCPW operation areas Coded Value Default value Duplicate DBO String watersystem 324_Water_System Water systems that LCPW operates within or connects to. Coded Value Default value Duplicate DBO String Filter 17 ASSETTYPE 0 324_Asset_Type_Water_Device_Filter The Asset Types for the Water Device's Asset Group Filter Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 Water_UN_324_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 Water_UN_324_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 Water_UN_324_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_UN_324_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown normalstatus 3 324_Pipeline_Device_Status Status of device Coded Value Default value Duplicate DBO SmallInteger presentstatus 3 324_Pipeline_Device_Status Status of device Coded Value Default value Duplicate DBO SmallInteger operable 1 324_Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 324_Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 324_Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation 324_Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 324_Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger bondedinsulated 324_Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate DBO SmallInteger cptraceability 0 324_Yes_No Valid Yes, No values Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 324_Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 324_Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger cpoverride 324_CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate DBO SmallInteger adminarea 324_Admin_Area Detailed list of asset owners and managers Coded Value Default value Duplicate DBO String opsarea 324_Ops_Area List of LCPW operation areas Coded Value Default value Duplicate DBO String watersystem 324_Water_System Water systems that LCPW operates within or connects to. Coded Value Default value Duplicate DBO String Controller 18 ASSETTYPE 0 324_Asset_Type_Water_Device_Controller The Asset Types for the Water Device's Asset Group Controller Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 Water_UN_324_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 Water_UN_324_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 Water_UN_324_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_UN_324_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown normalstatus 3 324_Pipeline_Device_Status Status of device Coded Value Default value Duplicate DBO SmallInteger presentstatus 3 324_Pipeline_Device_Status Status of device Coded Value Default value Duplicate DBO SmallInteger operable 1 324_Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 324_Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 324_Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation 324_Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 324_Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger bondedinsulated 324_Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate DBO SmallInteger cptraceability 0 324_Yes_No Valid Yes, No values Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 324_Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 324_Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger cpoverride 324_CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate DBO SmallInteger adminarea 324_Admin_Area Detailed list of asset owners and managers Coded Value Default value Duplicate DBO String opsarea 324_Ops_Area List of LCPW operation areas Coded Value Default value Duplicate DBO String watersystem 324_Water_System Water systems that LCPW operates within or connects to. Coded Value Default value Duplicate DBO String Controllable Valve 2 ASSETTYPE 0 324_Asset_Type_Water_Device_Controllable_Valve The Asset Types for the Water Device's Asset Group Controllable Valve Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 Water_UN_324_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 Water_UN_324_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 Water_UN_324_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_UN_324_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown diameter 0 324_Water_Diameter General domain for the diameter of water assets, in Imperial units Coded Value Default value Duplicate DBO Double designtype 324_Water_Valve_Type Types of controllable water valves Coded Value Default value Duplicate DBO SmallInteger normalstatus 1 324_Pipeline_Valve_Status The status of a water device Coded Value Default value Duplicate DBO SmallInteger presentstatus 1 324_Pipeline_Valve_Status The status of a water device Coded Value Default value Duplicate DBO SmallInteger additionaldetails 1 324_Pipeline_Valve_Close_Direction The close direction of a valve Coded Value Default value Duplicate DBO SmallInteger operable 324_Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 324_Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 324_Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger additionaldevice 0 324_Yes_No Valid Yes, No values Coded Value Default value Duplicate DBO SmallInteger symbolrotation 324_Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 324_Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger bondedinsulated 324_Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate DBO SmallInteger cptraceability 0 324_Yes_No Valid Yes, No values Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 324_Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 324_Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger cpoverride 324_CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate DBO SmallInteger adminarea 324_Admin_Area Detailed list of asset owners and managers Coded Value Default value Duplicate DBO String opsarea 324_Ops_Area List of LCPW operation areas Coded Value Default value Duplicate DBO String watersystem 324_Water_System Water systems that LCPW operates within or connects to. Coded Value Default value Duplicate DBO String Station 4 ASSETTYPE 0 324_Asset_Type_Water_Device_Station The Asset Types for the Water Device's Asset Group Station Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 Water_UN_324_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 Water_UN_324_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 Water_UN_324_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_UN_324_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown normalstatus 3 324_Pipeline_Device_Status Status of device Coded Value Default value Duplicate DBO SmallInteger presentstatus 3 324_Pipeline_Device_Status Status of device Coded Value Default value Duplicate DBO SmallInteger operable 1 324_Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 324_Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 324_Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation 324_Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 324_Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger bondedinsulated 324_Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate DBO SmallInteger cptraceability 0 324_Yes_No Valid Yes, No values Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 324_Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 324_Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger cpoverride 324_CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate DBO SmallInteger adminarea 324_Admin_Area Detailed list of asset owners and managers Coded Value Default value Duplicate DBO String opsarea 324_Ops_Area List of LCPW operation areas Coded Value Default value Duplicate DBO String watersystem 324_Water_System Water systems that LCPW operates within or connects to. Coded Value Default value Duplicate DBO String Pump 5 ASSETTYPE 0 324_Asset_Type_Water_Device_Pump The Asset Types for the Water Device's Asset Group Pump Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 Water_UN_324_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 Water_UN_324_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 Water_UN_324_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_UN_324_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown diameter 0 324_Water_Pump_Diameter Sizes of pumps Coded Value Default value Duplicate DBO Double secondarydiameter 0 324_Water_Pump_Diameter Sizes of pumps Coded Value Default value Duplicate DBO Double designtype 0 324_Water_Pump_Type The different types of pump designs. Coded Value Default value Duplicate DBO SmallInteger normalstatus 3 324_Pipeline_Device_Status Status of device Coded Value Default value Duplicate DBO SmallInteger presentstatus 3 324_Pipeline_Device_Status Status of device Coded Value Default value Duplicate DBO SmallInteger operable 1 324_Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 324_Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 324_Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger additionaldevice 0 324_Yes_No Valid Yes, No values Coded Value Default value Duplicate DBO SmallInteger symbolrotation 324_Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 324_Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger bondedinsulated 324_Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate DBO SmallInteger cptraceability 0 324_Yes_No Valid Yes, No values Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 324_Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 324_Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger cpoverride 324_CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate DBO SmallInteger adminarea 324_Admin_Area Detailed list of asset owners and managers Coded Value Default value Duplicate DBO String opsarea 324_Ops_Area List of LCPW operation areas Coded Value Default value Duplicate DBO String watersystem 324_Water_System Water systems that LCPW operates within or connects to. Coded Value Default value Duplicate DBO String Fire Hydrant 7 ASSETTYPE 0 324_Asset_Type_Water_Device_Fire_Hydrant The Asset Types for the Water Device's Asset Group Fire Hydrant Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 Water_UN_324_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 Water_UN_324_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 Water_UN_324_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_UN_324_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown diameter 0 324_Water_Hydrant_Service_Diameter List of hydrant service sizes, in Imperial units Coded Value Default value Duplicate DBO Double secondarydiameter 0 324_Water_Hydrant_Nozzle_Diameter Sizes of a fire hydrants nozzle, in Imperial units Coded Value Default value Duplicate DBO Double designtype 0 324_Water_Fire_Hydrant_Manufacturer The valid hydrant manufacturers Coded Value Default value Duplicate DBO SmallInteger normalstatus 3 324_Pipeline_Device_Status Status of device Coded Value Default value Duplicate DBO SmallInteger presentstatus 3 324_Pipeline_Device_Status Status of device Coded Value Default value Duplicate DBO SmallInteger operable 1 324_Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 324_Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 324_Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger additionaldevice 0 324_Yes_No Valid Yes, No values Coded Value Default value Duplicate DBO SmallInteger symbolrotation 324_Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 324_Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger bondedinsulated 324_Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate DBO SmallInteger cptraceability 0 324_Yes_No Valid Yes, No values Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 324_Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 324_Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger cpoverride 324_CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate DBO SmallInteger adminarea 324_Admin_Area Detailed list of asset owners and managers Coded Value Default value Duplicate DBO String opsarea 324_Ops_Area List of LCPW operation areas Coded Value Default value Duplicate DBO String watersystem 324_Water_System Water systems that LCPW operates within or connects to. Coded Value Default value Duplicate DBO String Flushing and Blow Off 9 ASSETTYPE 0 324_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 DBO SmallInteger ASSOCIATIONSTATUS 0 Water_UN_324_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 Water_UN_324_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 Water_UN_324_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_UN_324_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown normalstatus 0 324_Pipeline_Valve_Status The status of a water device Coded Value Default value Duplicate DBO SmallInteger presentstatus 0 324_Pipeline_Valve_Status The status of a water device Coded Value Default value Duplicate DBO SmallInteger operable 1 324_Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 324_Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 324_Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation 324_Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 324_Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger bondedinsulated 324_Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate DBO SmallInteger cptraceability 0 324_Yes_No Valid Yes, No values Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 324_Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 324_Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger cpoverride 324_CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate DBO SmallInteger adminarea 324_Admin_Area Detailed list of asset owners and managers Coded Value Default value Duplicate DBO String opsarea 324_Ops_Area List of LCPW operation areas Coded Value Default value Duplicate DBO String watersystem 324_Water_System Water systems that LCPW operates within or connects to. Coded Value Default value Duplicate DBO String Injection Facility 19 ASSETTYPE 0 324_Asset_Type_Water_Device_Injection_Facility The Asset Types for the Water Device's Asset Group Injection Facility Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 Water_UN_324_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 Water_UN_324_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 Water_UN_324_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_UN_324_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown normalstatus 3 324_Pipeline_Device_Status Status of device Coded Value Default value Duplicate DBO SmallInteger presentstatus 3 324_Pipeline_Device_Status Status of device Coded Value Default value Duplicate DBO SmallInteger operable 1 324_Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 324_Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 324_Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation 324_Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 324_Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger bondedinsulated 324_Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate DBO SmallInteger cptraceability 0 324_Yes_No Valid Yes, No values Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 324_Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 324_Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger cpoverride 324_CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate DBO SmallInteger adminarea 324_Admin_Area Detailed list of asset owners and managers Coded Value Default value Duplicate DBO String opsarea 324_Ops_Area List of LCPW operation areas Coded Value Default value Duplicate DBO String watersystem 324_Water_System Water systems that LCPW operates within or connects to. Coded Value Default value Duplicate DBO String Anode 50 ASSETTYPE 0 324_Asset_Type_Water_Device_Anode The Asset Types for the Water Device's Asset Group Anode Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 Water_UN_324_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 Water_UN_324_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 Water_UN_324_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_UN_324_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown diameter 0 324_CP_Anode_Weight List of valid anode weights Coded Value Default value Duplicate DBO Double normalstatus 3 324_Pipeline_Device_Status Status of device Coded Value Default value Duplicate DBO SmallInteger presentstatus 3 324_Pipeline_Device_Status Status of device Coded Value Default value Duplicate DBO SmallInteger additionaldetails 0 324_CP_Anode_Material List of materials used for Anodes Coded Value Default value Duplicate DBO SmallInteger operable 1 324_Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 324_Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 324_Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation 324_Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 324_Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger bondedinsulated 324_Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate DBO SmallInteger cptraceability 1 324_Yes_No Valid Yes, No values Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 324_Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 324_Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger cpoverride 324_CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate DBO SmallInteger adminarea 324_Admin_Area Detailed list of asset owners and managers Coded Value Default value Duplicate DBO String opsarea 324_Ops_Area List of LCPW operation areas Coded Value Default value Duplicate DBO String watersystem 324_Water_System Water systems that LCPW operates within or connects to. Coded Value Default value Duplicate DBO String Rectifier 51 ASSETTYPE 0 324_Asset_Type_Water_Device_Rectifier The Asset Types for the Water Device Asset Group Rectifier Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 Water_UN_324_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 Water_UN_324_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 Water_UN_324_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_UN_324_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown designtype 0 324_CP_Rectifier_Manufacturer List of manufacturers for rectifiers Coded Value Default value Duplicate DBO SmallInteger normalstatus 3 324_Pipeline_Device_Status Status of device Coded Value Default value Duplicate DBO SmallInteger presentstatus 3 324_Pipeline_Device_Status Status of device Coded Value Default value Duplicate DBO SmallInteger additionaldetails 0 324_CP_Rectifier_Cooling_Method List of rectifier cooling methods Coded Value Default value Duplicate DBO SmallInteger operable 1 324_Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 324_Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 324_Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger additionaldevice 0 324_Yes_No Valid Yes, No values Coded Value Default value Duplicate DBO SmallInteger symbolrotation 324_Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 324_Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger bondedinsulated 324_Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate DBO SmallInteger cptraceability 1 324_Yes_No Valid Yes, No values Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 324_Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 324_Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger cpoverride 324_CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate DBO SmallInteger adminarea 324_Admin_Area Detailed list of asset owners and managers Coded Value Default value Duplicate DBO String opsarea 324_Ops_Area List of LCPW operation areas Coded Value Default value Duplicate DBO String watersystem 324_Water_System Water systems that LCPW operates within or connects to. Coded Value Default value Duplicate DBO String Test Point 52 ASSETTYPE 0 324_Asset_Type_Water_Device_Test_Point The Asset Types for the Water Device's Asset Group Test Point Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 Water_UN_324_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 Water_UN_324_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 Water_UN_324_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_UN_324_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown designtype 324_CP_Test_Point_Wire_Count Number of wires on a test point Coded Value Default value Duplicate DBO SmallInteger normalstatus 3 324_Pipeline_Device_Status Status of device Coded Value Default value Duplicate DBO SmallInteger presentstatus 3 324_Pipeline_Device_Status Status of device Coded Value Default value Duplicate DBO SmallInteger operable 1 324_Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 324_Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 324_Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation 324_Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 324_Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger bondedinsulated 324_Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate DBO SmallInteger cptraceability 1 324_Yes_No Valid Yes, No values Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 324_Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 324_Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger cpoverride 324_CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate DBO SmallInteger adminarea 324_Admin_Area Detailed list of asset owners and managers Coded Value Default value Duplicate DBO String opsarea 324_Ops_Area List of LCPW operation areas Coded Value Default value Duplicate DBO String watersystem 324_Water_System Water systems that LCPW operates within or connects to. Coded Value Default value Duplicate DBO String Storage 20 ASSETTYPE 0 324_Asset_Type_Water_Device_Storage The Asset Types for the Water Device's Asset Group Storage Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 Water_UN_324_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 Water_UN_324_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 Water_UN_324_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_UN_324_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown normalstatus 3 324_Pipeline_Device_Status Status of device Coded Value Default value Duplicate DBO SmallInteger presentstatus 3 324_Pipeline_Device_Status Status of device Coded Value Default value Duplicate DBO SmallInteger operable 1 324_Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 324_Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 324_Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation 324_Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 324_Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger bondedinsulated 324_Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate DBO SmallInteger cptraceability 0 324_Yes_No Valid Yes, No values Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 324_Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 324_Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger cpoverride 324_CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate DBO SmallInteger adminarea 324_Admin_Area Detailed list of asset owners and managers Coded Value Default value Duplicate DBO String opsarea 324_Ops_Area List of LCPW operation areas Coded Value Default value Duplicate DBO String watersystem 324_Water_System Water systems that LCPW operates within or connects to. Coded Value Default value Duplicate DBO String Supply 15 ASSETTYPE 0 324_Asset_Type_Water_Device_Supply The Asset Types for the Water Device's Asset Group Supply Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 Water_UN_324_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 Water_UN_324_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 Water_UN_324_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_UN_324_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown diameter 0 324_Water_Well_Diameter General list of well sizes Coded Value Default value Duplicate DBO Double normalstatus 3 324_Pipeline_Device_Status Status of device Coded Value Default value Duplicate DBO SmallInteger presentstatus 3 324_Pipeline_Device_Status Status of device Coded Value Default value Duplicate DBO SmallInteger operable 1 324_Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 324_Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 324_Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation 324_Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 324_Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger bondedinsulated 324_Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate DBO SmallInteger cptraceability 0 324_Yes_No Valid Yes, No values Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 324_Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 324_Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger cpoverride 324_CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate DBO SmallInteger adminarea 324_Admin_Area Detailed list of asset owners and managers Coded Value Default value Duplicate DBO String opsarea 324_Ops_Area List of LCPW operation areas Coded Value Default value Duplicate DBO String watersystem 324_Water_System Water systems that LCPW operates within or connects to. Coded Value Default value Duplicate DBO String Outlet 8 ASSETTYPE 0 324_Asset_Type_Water_Device_Outlet The Asset Types for the Water Device's Asset Group Outlet Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 Water_UN_324_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 Water_UN_324_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 Water_UN_324_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_UN_324_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown normalstatus 3 324_Pipeline_Device_Status Status of device Coded Value Default value Duplicate DBO SmallInteger presentstatus 3 324_Pipeline_Device_Status Status of device Coded Value Default value Duplicate DBO SmallInteger operable 1 324_Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 324_Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 324_Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation 324_Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 324_Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger bondedinsulated 324_Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate DBO SmallInteger cptraceability 0 324_Yes_No Valid Yes, No values Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 324_Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 324_Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger cpoverride 324_CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate DBO SmallInteger adminarea 324_Admin_Area Detailed list of asset owners and managers Coded Value Default value Duplicate DBO String opsarea 324_Ops_Area List of LCPW operation areas Coded Value Default value Duplicate DBO String watersystem 324_Water_System Water systems that LCPW operates within or connects to. Coded Value Default value Duplicate DBO String Pressure Valve 3 ASSETTYPE 0 324_Asset_Type_Water_Device_Pressure_Valve The Asset Types for the Water Device's Asset Group Pressure Valve Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 Water_UN_324_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 Water_UN_324_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 Water_UN_324_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_UN_324_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown diameter 0 324_Water_Diameter General domain for the diameter of water assets, in Imperial units Coded Value Default value Duplicate DBO Double normalstatus 3 324_Pipeline_Device_Status Status of device Coded Value Default value Duplicate DBO SmallInteger presentstatus 3 324_Pipeline_Device_Status Status of device Coded Value Default value Duplicate DBO SmallInteger operable 1 324_Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 324_Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 324_Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation 324_Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 324_Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger bondedinsulated 324_Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate DBO SmallInteger cptraceability 0 324_Yes_No Valid Yes, No values Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 324_Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 324_Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger cpoverride 324_CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate DBO SmallInteger adminarea 324_Admin_Area Detailed list of asset owners and managers Coded Value Default value Duplicate DBO String opsarea 324_Ops_Area List of LCPW operation areas Coded Value Default value Duplicate DBO String watersystem 324_Water_System Water systems that LCPW operates within or connects to. Coded Value Default value Duplicate DBO String Monitoring 11 ASSETTYPE 0 324_Asset_Type_Water_Device_Monitoring The Asset Types for the Water Device's Asset Group Monitoring Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 Water_UN_324_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 Water_UN_324_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 Water_UN_324_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_UN_324_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown normalstatus 3 324_Pipeline_Device_Status Status of device Coded Value Default value Duplicate DBO SmallInteger presentstatus 3 324_Pipeline_Device_Status Status of device Coded Value Default value Duplicate DBO SmallInteger operable 324_Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 324_Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 324_Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation 324_Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 324_Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger bondedinsulated 324_Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate DBO SmallInteger cptraceability 0 324_Yes_No Valid Yes, No values Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 324_Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 324_Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger cpoverride 324_CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate DBO SmallInteger adminarea 324_Admin_Area Detailed list of asset owners and managers Coded Value Default value Duplicate DBO String opsarea 324_Ops_Area List of LCPW operation areas Coded Value Default value Duplicate DBO String watersystem 324_Water_System Water systems that LCPW operates within or connects to. Coded Value Default value Duplicate DBO String Service Connection 12 ASSETTYPE 0 324_Asset_Type_Water_Device_Service_Connection The Asset Types for the Water Junction's Asset Group Service Connection Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 Water_UN_324_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 Water_UN_324_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 Water_UN_324_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Water_UN_324_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default cpsubnetworkname Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown SystemSubnetworkName Unknown PressureSubnetworkName Unknown IsolationSubnetworkName Unknown DMASubnetworkName Unknown normalstatus 3 324_Pipeline_Device_Status Status of device Coded Value Default value Duplicate DBO SmallInteger presentstatus 3 324_Pipeline_Device_Status Status of device Coded Value Default value Duplicate DBO SmallInteger additionaldetails 2 324_Yes_No Valid Yes, No values Coded Value Default value Duplicate DBO SmallInteger operable 1 324_Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 324_Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 324_Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger additionaldevice 2 324_Yes_No Valid Yes, No values Coded Value Default value Duplicate DBO SmallInteger symbolrotation 324_Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 324_Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger bondedinsulated 324_Bonded_Insulated Values to indicate if a feature is bonded or insulated Coded Value Default value Duplicate DBO SmallInteger cptraceability 0 324_Yes_No Valid Yes, No values Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 324_Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 324_Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger cpoverride 324_CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate DBO SmallInteger adminarea 324_Admin_Area Detailed list of asset owners and managers Coded Value Default value Duplicate DBO String opsarea 324_Ops_Area List of LCPW operation areas Coded Value Default value Duplicate DBO String watersystem 324_Water_System Water systems that LCPW operates within or connects to. Coded Value Default value Duplicate DBO String 20230429