20221215 13204700 1.0 FALSE SewerDevice 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> 20230428 15415100 20230428 15415100 Esri ArcGIS 13.0.0.36056 SewerDevice Enterprise Geodatabase Feature Class dataset EPSG 6.18.3(9.3.1.2) 0 Simple FALSE 0 TRUE TRUE SewerDevice 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 Tier name Integer 4 10 0 TIERRANK Tier rank Integer 4 10 0 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 GLOBALID Global ID GlobalID 38 0 0 cpsubnetworkname cpsubnetworkname: cpsubnetworkname String 2000 0 0 SUPPORTEDSUBNETWORKNAME Supported subnetwork name String 2000 0 0 SUPPORTINGSUBNETWORKNAME Supporting subnetwork name String 2000 0 0 systemsubnetworkname systemsubnetworkname: systemsubnetworkname String 2000 0 0 sewershedsubnetworkname sewershedsubnetworkname: sewershedsubnetworkname String 2000 0 0 presentstatus presentstatus: Present Status SmallInteger 2 5 0 activevol activevol: Activate Volume SmallInteger 2 5 0 currentvol currentvol: Current Volume SmallInteger 2 5 0 designtype designtype: Pump Type, Valve Type SmallInteger 2 5 0 diameter diameter: Diameter, Inlet Diameter Double 8 38 8 secondarydiameter secondarydiameter: Discharge Diameter Double 8 38 8 designinfo designinfo: Rated Flow Double 8 38 8 pressure pressure: Rated Pressure Double 8 38 8 normalstatus normalstatus: Normal Status SmallInteger 2 5 0 additionaldetails additionaldetails: Clockwise to Close SmallInteger 2 5 0 operable operable: Operable SmallInteger 2 5 0 name name: Name String 64 0 0 lifecyclestatus lifecyclestatus: Lifecycle Status SmallInteger 2 5 0 installdate installdate: Install Date Date 8 0 0 assetid assetid: Asset ID String 64 0 0 ownedby ownedby: Owned By SmallInteger 2 5 0 maintby maintby: Maintained By SmallInteger 2 5 0 additionaldevice additionaldevice: Has Bypass Valve SmallInteger 2 5 0 symbolrotation symbolrotation: Symbol Rotation SmallInteger 2 5 0 notes notes: Notes String 2000 0 0 accountid accountid: Account ID String 50 0 0 material material: Cleanout Material SmallInteger 2 5 0 spatialsource spatialsource: Spatial Source SmallInteger 2 5 0 spatialconfidence spatialconfidence: Spatial Confidence SmallInteger 2 5 0 cptraceability cptraceability: Cathodic Protection Traceability 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 sewersystem Sewer System String 60 0 0 planidinstall PlanID (installed) Integer 4 10 0 planidretire PlanID (retired) Integer 4 10 0 mapcorrectid Map CorrectionID String 20 0 0 internalseal Internal Seal SmallInteger 2 5 0 externalseal External Seal SmallInteger 2 5 0 sealtitelid Seal-Tite Lid SmallInteger 2 5 0 installyear Install Year SmallInteger 2 5 0 Unknown 0 ASSETTYPE 0 Sewer_UN_6_UnknownAssetType The AssetType domain for the Unknown AssetGroup. Coded Value Default value Default value DBO SmallInteger ASSOCIATIONSTATUS 0 Sewer_UN_6_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 Sewer_UN_6_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 Sewer_UN_6_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Sewer_UN_6_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 sewershedsubnetworkname Unknown operable 1 6_Yes_No A yes/no indicator Coded Value Default value Duplicate DBO SmallInteger lifecyclestatus 8 6_Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger ownedby 1 6_Sewer_Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 6_Sewer_Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation 6_Sewer_Symbol_Rotation The rotation of an asset's symbol Range Default value Duplicate DBO SmallInteger cptraceability 0 6_Yes_No A yes/no indicator Coded Value Default value Duplicate DBO SmallInteger cpoverride 6_CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate DBO SmallInteger adminarea 6_Admin_Area Detailed list of asset owners and managers Coded Value Default value Duplicate DBO String opsarea 6_Ops_Area List of LCPW operation areas Coded Value Default value Duplicate DBO String sewersystem 6_Sewer_System Regional sewer systems that LCPW operate within. Coded Value Default value Duplicate DBO String Pump 5 ASSETTYPE 0 6_Asset_Type_Sewer_Device_Pump The asset type for the sewer device's asset group pump. Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 Sewer_UN_6_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 Sewer_UN_6_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 Sewer_UN_6_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Sewer_UN_6_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 sewershedsubnetworkname Unknown presentstatus 1 6_Pipeline_Valve_Status The state of a device Coded Value Default value Duplicate DBO SmallInteger activevol 0 6_Rainfall_Intensity The current/activate value of a stormwater or sewer device. Coded Value Default value Duplicate DBO SmallInteger currentvol 0 6_Rainfall_Intensity The current/activate value of a stormwater or sewer device. Coded Value Default value Duplicate DBO SmallInteger designtype 6_Sewer_Pump_Type The type of sewer pumps. Coded Value Default value Duplicate DBO SmallInteger diameter 6_Sewer_Pump_Inlet_Diameter The inlet diameter of sewer pumps. Coded Value Default value Duplicate DBO Double secondarydiameter 6_Sewer_Pump_Discharge_Diameter The discharge diameter of sewer pumps. Coded Value Default value Duplicate DBO Double normalstatus 1 6_Pipeline_Valve_Status The state of a device Coded Value Default value Duplicate DBO SmallInteger operable 1 6_Yes_No A yes/no indicator Coded Value Default value Duplicate DBO SmallInteger lifecyclestatus 8 6_Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger ownedby 1 6_Sewer_Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 6_Sewer_Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation 6_Sewer_Symbol_Rotation The rotation of an asset's symbol Range Default value Duplicate DBO SmallInteger spatialsource 0 6_Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 6_Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger cptraceability 0 6_Yes_No A yes/no indicator Coded Value Default value Duplicate DBO SmallInteger cpoverride 6_CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate DBO SmallInteger adminarea 6_Admin_Area Detailed list of asset owners and managers Coded Value Default value Duplicate DBO String opsarea 6_Ops_Area List of LCPW operation areas Coded Value Default value Duplicate DBO String sewersystem 6_Sewer_System Regional sewer systems that LCPW operate within. Coded Value Default value Duplicate DBO String Flow Valve 1 ASSETTYPE 0 6_Asset_Type_Sewer_Device_Flow_Valve The asset type for the sewer device's asset group flow valve. Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 Sewer_UN_6_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 Sewer_UN_6_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 Sewer_UN_6_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Sewer_UN_6_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 sewershedsubnetworkname Unknown presentstatus 1 6_Pipeline_Valve_Status The state of a device Coded Value Default value Duplicate DBO SmallInteger activevol 0 6_Rainfall_Intensity The current/activate value of a stormwater or sewer device. Coded Value Default value Duplicate DBO SmallInteger currentvol 0 6_Rainfall_Intensity The current/activate value of a stormwater or sewer device. Coded Value Default value Duplicate DBO SmallInteger diameter 6_Sewer_Flow_Valve_Diameter The diameter of a sewer flow valve. Coded Value Default value Duplicate DBO Double operable 1 6_Yes_No A yes/no indicator Coded Value Default value Duplicate DBO SmallInteger lifecyclestatus 8 6_Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger ownedby 1 6_Sewer_Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 6_Sewer_Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation 6_Sewer_Symbol_Rotation The rotation of an asset's symbol Range Default value Duplicate DBO SmallInteger spatialsource 0 6_Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 6_Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger cptraceability 0 6_Yes_No A yes/no indicator Coded Value Default value Duplicate DBO SmallInteger cpoverride 6_CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate DBO SmallInteger adminarea 6_Admin_Area Detailed list of asset owners and managers Coded Value Default value Duplicate DBO String opsarea 6_Ops_Area List of LCPW operation areas Coded Value Default value Duplicate DBO String sewersystem 6_Sewer_System Regional sewer systems that LCPW operate within. Coded Value Default value Duplicate DBO String Controllable Valve 2 ASSETTYPE 0 6_Asset_Type_Sewer_Device_Controllable_Valve The asset type for the sewer device's asset group controllable valve Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 Sewer_UN_6_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 Sewer_UN_6_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 Sewer_UN_6_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Sewer_UN_6_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 sewershedsubnetworkname Unknown presentstatus 1 6_Pipeline_Valve_Status The state of a device Coded Value Default value Duplicate DBO SmallInteger activevol 0 6_Rainfall_Intensity The current/activate value of a stormwater or sewer device. Coded Value Default value Duplicate DBO SmallInteger currentvol 0 6_Rainfall_Intensity The current/activate value of a stormwater or sewer device. Coded Value Default value Duplicate DBO SmallInteger designtype 0 6_Sewer_Controllable_Valve_Type The types of sewer controllable valves. Coded Value Default value Duplicate DBO SmallInteger diameter 0 6_Sewer_Controllable_Valve_Diameter The diameter of sewer controllable valves. Coded Value Default value Duplicate DBO Double normalstatus 1 6_Pipeline_Valve_Status The state of a device Coded Value Default value Duplicate DBO SmallInteger additionaldetails 1 6_Pipeline_Valve_Close_Direction The close direction of a valve Coded Value Default value Duplicate DBO SmallInteger operable 1 6_Yes_No A yes/no indicator Coded Value Default value Duplicate DBO SmallInteger lifecyclestatus 8 6_Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger ownedby 1 6_Sewer_Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 6_Sewer_Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger additionaldevice 6_Yes_No A yes/no indicator Coded Value Default value Duplicate DBO SmallInteger symbolrotation 6_Sewer_Symbol_Rotation The rotation of an asset's symbol Range Default value Duplicate DBO SmallInteger spatialsource 0 6_Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 6_Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger cptraceability 0 6_Yes_No A yes/no indicator Coded Value Default value Duplicate DBO SmallInteger cpoverride 6_CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate DBO SmallInteger adminarea 6_Admin_Area Detailed list of asset owners and managers Coded Value Default value Duplicate DBO String opsarea 6_Ops_Area List of LCPW operation areas Coded Value Default value Duplicate DBO String sewersystem 6_Sewer_System Regional sewer systems that LCPW operate within. Coded Value Default value Duplicate DBO String Relief Valve 3 ASSETTYPE 0 6_Asset_Type_Sewer_Device_Relief_Valve The asset type for the sewer device's asset group relief valve. Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 Sewer_UN_6_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 Sewer_UN_6_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 Sewer_UN_6_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Sewer_UN_6_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 sewershedsubnetworkname Unknown activevol 0 6_Rainfall_Intensity The current/activate value of a stormwater or sewer device. Coded Value Default value Duplicate DBO SmallInteger currentvol 0 6_Rainfall_Intensity The current/activate value of a stormwater or sewer device. Coded Value Default value Duplicate DBO SmallInteger diameter 0 6_Sewer_Relief_Valve_Diameter The diameter of sewer relief valves. Coded Value Default value Duplicate DBO Double operable 1 6_Yes_No A yes/no indicator Coded Value Default value Duplicate DBO SmallInteger lifecyclestatus 8 6_Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger ownedby 1 6_Sewer_Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 6_Sewer_Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation 6_Sewer_Symbol_Rotation The rotation of an asset's symbol Range Default value Duplicate DBO SmallInteger spatialsource 0 6_Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 6_Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger cptraceability 0 6_Yes_No A yes/no indicator Coded Value Default value Duplicate DBO SmallInteger cpoverride 6_CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate DBO SmallInteger adminarea 6_Admin_Area Detailed list of asset owners and managers Coded Value Default value Duplicate DBO String opsarea 6_Ops_Area List of LCPW operation areas Coded Value Default value Duplicate DBO String sewersystem 6_Sewer_System Regional sewer systems that LCPW operate within. Coded Value Default value Duplicate DBO String Meter 10 ASSETTYPE 0 6_Asset_Type_Sewer_Device_Meter The asset type for the sewer device's asset group meter. Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 Sewer_UN_6_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 Sewer_UN_6_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 Sewer_UN_6_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Sewer_UN_6_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 sewershedsubnetworkname Unknown presentstatus 3 6_Pipeline_Device_Status The status of a device Coded Value Default value Duplicate DBO SmallInteger activevol 0 6_Rainfall_Intensity The current/activate value of a stormwater or sewer device. Coded Value Default value Duplicate DBO SmallInteger currentvol 0 6_Rainfall_Intensity The current/activate value of a stormwater or sewer device. Coded Value Default value Duplicate DBO SmallInteger normalstatus 3 6_Pipeline_Device_Status The status of a device Coded Value Default value Duplicate DBO SmallInteger operable 1 6_Yes_No A yes/no indicator Coded Value Default value Duplicate DBO SmallInteger lifecyclestatus 8 6_Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger ownedby 1 6_Sewer_Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 6_Sewer_Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation 6_Sewer_Symbol_Rotation The rotation of an asset's symbol Range Default value Duplicate DBO SmallInteger spatialsource 0 6_Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 6_Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger cptraceability 0 6_Yes_No A yes/no indicator Coded Value Default value Duplicate DBO SmallInteger cpoverride 6_CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate DBO SmallInteger adminarea 6_Admin_Area Detailed list of asset owners and managers Coded Value Default value Duplicate DBO String opsarea 6_Ops_Area List of LCPW operation areas Coded Value Default value Duplicate DBO String sewersystem 6_Sewer_System Regional sewer systems that LCPW operate within. Coded Value Default value Duplicate DBO String Treatment 15 ASSETTYPE 0 6_Asset_Type_Sewer_Device_Treatment The asset type for the sewer device's asset group treatment. Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 Sewer_UN_6_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 Sewer_UN_6_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 Sewer_UN_6_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Sewer_UN_6_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 sewershedsubnetworkname Unknown activevol 0 6_Rainfall_Intensity The current/activate value of a stormwater or sewer device. Coded Value Default value Duplicate DBO SmallInteger currentvol 0 6_Rainfall_Intensity The current/activate value of a stormwater or sewer device. Coded Value Default value Duplicate DBO SmallInteger lifecyclestatus 8 6_Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger ownedby 1 6_Sewer_Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 6_Sewer_Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation 6_Sewer_Symbol_Rotation The rotation of an asset's symbol Range Default value Duplicate DBO SmallInteger spatialsource 0 6_Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 6_Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger cptraceability 0 6_Yes_No A yes/no indicator Coded Value Default value Duplicate DBO SmallInteger cpoverride 6_CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate DBO SmallInteger adminarea 6_Admin_Area Detailed list of asset owners and managers Coded Value Default value Duplicate DBO String opsarea 6_Ops_Area List of LCPW operation areas Coded Value Default value Duplicate DBO String sewersystem 6_Sewer_System Regional sewer systems that LCPW operate within. Coded Value Default value Duplicate DBO String Weir 26 ASSETTYPE 0 6_Asset_Type_Sewer_Device_Weir The asset type for the sewer device's asset group weir. Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 Sewer_UN_6_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 Sewer_UN_6_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 Sewer_UN_6_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Sewer_UN_6_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 sewershedsubnetworkname Unknown activevol 0 6_Rainfall_Intensity The current/activate value of a stormwater or sewer device. Coded Value Default value Duplicate DBO SmallInteger currentvol 0 6_Rainfall_Intensity The current/activate value of a stormwater or sewer device. Coded Value Default value Duplicate DBO SmallInteger lifecyclestatus 8 6_Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger ownedby 1 6_Sewer_Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 6_Sewer_Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation 6_Sewer_Symbol_Rotation The rotation of an asset's symbol Range Default value Duplicate DBO SmallInteger spatialsource 0 6_Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 6_Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger cptraceability 0 6_Yes_No A yes/no indicator Coded Value Default value Duplicate DBO SmallInteger cpoverride 6_CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate DBO SmallInteger adminarea 6_Admin_Area Detailed list of asset owners and managers Coded Value Default value Duplicate DBO String opsarea 6_Ops_Area List of LCPW operation areas Coded Value Default value Duplicate DBO String sewersystem 6_Sewer_System Regional sewer systems that LCPW operate within. Coded Value Default value Duplicate DBO String Pipe Connection 23 ASSETTYPE 0 6_Asset_Type_Sewer_Device_Pipe_Connection The asset type for the sewer device's asset group connection point. Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 Sewer_UN_6_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 Sewer_UN_6_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 Sewer_UN_6_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Sewer_UN_6_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 sewershedsubnetworkname Unknown activevol 0 6_Rainfall_Intensity The current/activate value of a stormwater or sewer device. Coded Value Default value Duplicate DBO SmallInteger currentvol 0 6_Rainfall_Intensity The current/activate value of a stormwater or sewer device. Coded Value Default value Duplicate DBO SmallInteger lifecyclestatus 8 6_Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger ownedby 1 6_Sewer_Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 6_Sewer_Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation 6_Sewer_Symbol_Rotation The rotation of an asset's symbol Range Default value Duplicate DBO SmallInteger spatialsource 0 6_Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 6_Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger cptraceability 0 6_Yes_No A yes/no indicator Coded Value Default value Duplicate DBO SmallInteger cpoverride 6_CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate DBO SmallInteger adminarea 6_Admin_Area Detailed list of asset owners and managers Coded Value Default value Duplicate DBO String opsarea 6_Ops_Area List of LCPW operation areas Coded Value Default value Duplicate DBO String sewersystem 6_Sewer_System Regional sewer systems that LCPW operate within. Coded Value Default value Duplicate DBO String internalseal 0 6_Yes_No A yes/no indicator Coded Value Default value Duplicate DBO SmallInteger externalseal 0 6_Yes_No A yes/no indicator Coded Value Default value Duplicate DBO SmallInteger sealtitelid 0 6_Yes_No A yes/no indicator Coded Value Default value Duplicate DBO SmallInteger Monitoring 25 ASSETTYPE 0 6_Asset_Type_Sewer_Device_Monitoring The asset type for the sewer junction's asset group monitoring Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 Sewer_UN_6_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 Sewer_UN_6_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 Sewer_UN_6_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Sewer_UN_6_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 sewershedsubnetworkname Unknown activevol 0 6_Rainfall_Intensity The current/activate value of a stormwater or sewer device. Coded Value Default value Duplicate DBO SmallInteger currentvol 0 6_Rainfall_Intensity The current/activate value of a stormwater or sewer device. Coded Value Default value Duplicate DBO SmallInteger lifecyclestatus 8 6_Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger ownedby 1 6_Sewer_Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 6_Sewer_Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation 6_Sewer_Symbol_Rotation The rotation of an asset's symbol Range Default value Duplicate DBO SmallInteger spatialsource 0 6_Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 6_Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger cptraceability 0 6_Yes_No A yes/no indicator Coded Value Default value Duplicate DBO SmallInteger cpoverride 6_CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate DBO SmallInteger adminarea 6_Admin_Area Detailed list of asset owners and managers Coded Value Default value Duplicate DBO String opsarea 6_Ops_Area List of LCPW operation areas Coded Value Default value Duplicate DBO String sewersystem 6_Sewer_System Regional sewer systems that LCPW operate within. Coded Value Default value Duplicate DBO String Gate 27 ASSETTYPE 0 6_Asset_Type_Sewer_Device_Gate The asset type for the sewer device's asset group gate. Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 Sewer_UN_6_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 Sewer_UN_6_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 Sewer_UN_6_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Sewer_UN_6_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 sewershedsubnetworkname Unknown presentstatus 1 6_Pipeline_Valve_Status The state of a device Coded Value Default value Duplicate DBO SmallInteger activevol 0 6_Rainfall_Intensity The current/activate value of a stormwater or sewer device. Coded Value Default value Duplicate DBO SmallInteger currentvol 0 6_Rainfall_Intensity The current/activate value of a stormwater or sewer device. Coded Value Default value Duplicate DBO SmallInteger normalstatus 1 6_Pipeline_Valve_Status The state of a device Coded Value Default value Duplicate DBO SmallInteger lifecyclestatus 8 6_Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger ownedby 1 6_Sewer_Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 6_Sewer_Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation 6_Sewer_Symbol_Rotation The rotation of an asset's symbol Range Default value Duplicate DBO SmallInteger spatialsource 0 6_Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 6_Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger cptraceability 0 6_Yes_No A yes/no indicator Coded Value Default value Duplicate DBO SmallInteger cpoverride 6_CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate DBO SmallInteger adminarea 6_Admin_Area Detailed list of asset owners and managers Coded Value Default value Duplicate DBO String opsarea 6_Ops_Area List of LCPW operation areas Coded Value Default value Duplicate DBO String sewersystem 6_Sewer_System Regional sewer systems that LCPW operate within. Coded Value Default value Duplicate DBO String Service Connection 7 ASSETTYPE 0 6_Asset_Type_Sewer_Device_Service_Connection The asset type for the sewer device's asset group service connection. Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 Sewer_UN_6_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 Sewer_UN_6_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 Sewer_UN_6_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Sewer_UN_6_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 sewershedsubnetworkname Unknown activevol 0 6_Rainfall_Intensity The current/activate value of a stormwater or sewer device. Coded Value Default value Duplicate DBO SmallInteger currentvol 0 6_Rainfall_Intensity The current/activate value of a stormwater or sewer device. Coded Value Default value Duplicate DBO SmallInteger lifecyclestatus 8 6_Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger ownedby 1 6_Sewer_Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 6_Sewer_Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation 6_Sewer_Symbol_Rotation The rotation of an asset's symbol Range Default value Duplicate DBO SmallInteger spatialsource 0 6_Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 6_Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger cptraceability 0 6_Yes_No A yes/no indicator Coded Value Default value Duplicate DBO SmallInteger cpoverride 6_CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate DBO SmallInteger adminarea 6_Admin_Area Detailed list of asset owners and managers Coded Value Default value Duplicate DBO String opsarea 6_Ops_Area List of LCPW operation areas Coded Value Default value Duplicate DBO String sewersystem 6_Sewer_System Regional sewer systems that LCPW operate within. Coded Value Default value Duplicate DBO String Cleanout 21 ASSETTYPE 0 6_Asset_Type_Sewer_Device_Cleanout The asset type for the sewer device's asset group cleanout. Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 Sewer_UN_6_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 Sewer_UN_6_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 Sewer_UN_6_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Sewer_UN_6_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 sewershedsubnetworkname Unknown activevol 0 6_Rainfall_Intensity The current/activate value of a stormwater or sewer device. Coded Value Default value Duplicate DBO SmallInteger currentvol 0 6_Rainfall_Intensity The current/activate value of a stormwater or sewer device. Coded Value Default value Duplicate DBO SmallInteger diameter 0 6_Sewer_Cleanout_Access_Diameter The access diameter of sewer cleanouts. Coded Value Default value Duplicate DBO Double lifecyclestatus 8 6_Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger ownedby 1 6_Sewer_Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 6_Sewer_Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation 6_Sewer_Symbol_Rotation The rotation of an asset's symbol Range Default value Duplicate DBO SmallInteger material 0 6_Sewer_Cleanout_Material The material of sewer cleanouts. Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 6_Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 6_Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger cptraceability 0 6_Yes_No A yes/no indicator Coded Value Default value Duplicate DBO SmallInteger cpoverride 6_CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate DBO SmallInteger adminarea 6_Admin_Area Detailed list of asset owners and managers Coded Value Default value Duplicate DBO String opsarea 6_Ops_Area List of LCPW operation areas Coded Value Default value Duplicate DBO String sewersystem 6_Sewer_System Regional sewer systems that LCPW operate within. Coded Value Default value Duplicate DBO String Anode 50 ASSETTYPE 0 6_Asset_Type_Sewer_Device_Anode The Asset Types for the Sewer Device's Asset Group Anode Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 Sewer_UN_6_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 Sewer_UN_6_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 Sewer_UN_6_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Sewer_UN_6_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 sewershedsubnetworkname Unknown presentstatus 3 6_Pipeline_Device_Status The status of a device Coded Value Default value Duplicate DBO SmallInteger activevol 0 6_Rainfall_Intensity The current/activate value of a stormwater or sewer device. Coded Value Default value Duplicate DBO SmallInteger currentvol 0 6_Rainfall_Intensity The current/activate value of a stormwater or sewer device. Coded Value Default value Duplicate DBO SmallInteger diameter 0 6_CP_Anode_Weight List of valid anode weights Coded Value Default value Duplicate DBO Double normalstatus 3 6_Pipeline_Device_Status The status of a device Coded Value Default value Duplicate DBO SmallInteger additionaldetails 0 6_CP_Anode_Material List of materials used for Anodes Coded Value Default value Duplicate DBO SmallInteger lifecyclestatus 8 6_Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger ownedby 1 6_Sewer_Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 6_Sewer_Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation 6_Sewer_Symbol_Rotation The rotation of an asset's symbol Range Default value Duplicate DBO SmallInteger spatialsource 0 6_Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 6_Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger cptraceability 1 6_Yes_No A yes/no indicator Coded Value Default value Duplicate DBO SmallInteger cpoverride 6_CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate DBO SmallInteger adminarea 6_Admin_Area Detailed list of asset owners and managers Coded Value Default value Duplicate DBO String opsarea 6_Ops_Area List of LCPW operation areas Coded Value Default value Duplicate DBO String sewersystem 6_Sewer_System Regional sewer systems that LCPW operate within. Coded Value Default value Duplicate DBO String Rectifier 51 ASSETTYPE 0 6_Asset_Type_Sewer_Device_Rectifier The Asset Types for the Sewer Device Asset Group Rectifier Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 Sewer_UN_6_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 Sewer_UN_6_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 Sewer_UN_6_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Sewer_UN_6_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 sewershedsubnetworkname Unknown presentstatus 3 6_Pipeline_Device_Status The status of a device Coded Value Default value Duplicate DBO SmallInteger activevol 0 6_Rainfall_Intensity The current/activate value of a stormwater or sewer device. Coded Value Default value Duplicate DBO SmallInteger currentvol 0 6_Rainfall_Intensity The current/activate value of a stormwater or sewer device. Coded Value Default value Duplicate DBO SmallInteger designtype 0 6_CP_Rectifier_Manufacturer List of manufacturers for rectifiers Coded Value Default value Duplicate DBO SmallInteger normalstatus 3 6_Pipeline_Device_Status The status of a device Coded Value Default value Duplicate DBO SmallInteger additionaldetails 0 6_CP_Rectifier_Cooling_Method List of rectifier cooling methods Coded Value Default value Duplicate DBO SmallInteger lifecyclestatus 8 6_Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger ownedby 1 6_Sewer_Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 6_Sewer_Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation 6_Sewer_Symbol_Rotation The rotation of an asset's symbol Range Default value Duplicate DBO SmallInteger spatialsource 0 6_Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 6_Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger cptraceability 1 6_Yes_No A yes/no indicator Coded Value Default value Duplicate DBO SmallInteger cpoverride 6_CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate DBO SmallInteger adminarea 6_Admin_Area Detailed list of asset owners and managers Coded Value Default value Duplicate DBO String opsarea 6_Ops_Area List of LCPW operation areas Coded Value Default value Duplicate DBO String sewersystem 6_Sewer_System Regional sewer systems that LCPW operate within. Coded Value Default value Duplicate DBO String Test Point 52 ASSETTYPE 0 6_Asset_Type_Sewer_Device_Test_Point The Asset Types for the Sewer Device's Asset Group Test Point Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 Sewer_UN_6_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 Sewer_UN_6_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 Sewer_UN_6_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Sewer_UN_6_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 sewershedsubnetworkname Unknown presentstatus 3 6_Pipeline_Device_Status The status of a device Coded Value Default value Duplicate DBO SmallInteger activevol 0 6_Rainfall_Intensity The current/activate value of a stormwater or sewer device. Coded Value Default value Duplicate DBO SmallInteger currentvol 0 6_Rainfall_Intensity The current/activate value of a stormwater or sewer device. Coded Value Default value Duplicate DBO SmallInteger designtype 0 6_CP_Test_Point_Wire_Count Number of wires on a test point Coded Value Default value Duplicate DBO SmallInteger normalstatus 3 6_Pipeline_Device_Status The status of a device Coded Value Default value Duplicate DBO SmallInteger lifecyclestatus 8 6_Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger ownedby 1 6_Sewer_Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 6_Sewer_Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation 6_Sewer_Symbol_Rotation The rotation of an asset's symbol Range Default value Duplicate DBO SmallInteger spatialsource 0 6_Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 6_Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger cptraceability 1 6_Yes_No A yes/no indicator Coded Value Default value Duplicate DBO SmallInteger cpoverride 6_CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate DBO SmallInteger adminarea 6_Admin_Area Detailed list of asset owners and managers Coded Value Default value Duplicate DBO String opsarea 6_Ops_Area List of LCPW operation areas Coded Value Default value Duplicate DBO String sewersystem 6_Sewer_System Regional sewer systems that LCPW operate within. Coded Value Default value Duplicate DBO String d_ASSETGROUP d_ASSETGROUP String 255 0 0 d_ASSETTYPE d_ASSETTYPE String 255 0 0 d_ASSOCIATIONSTATUS d_ASSOCIATIONSTATUS String 255 0 0 d_ISSUBNETWORKCONTROLLER d_ISSUBNETWORKCONTROLLER String 255 0 0 d_ISCONNECTED d_ISCONNECTED String 255 0 0 d_TIERNAME d_TIERNAME String 255 0 0 d_presentstatus d_presentstatus String 255 0 0 d_activevol d_activevol String 255 0 0 d_currentvol d_currentvol String 255 0 0 d_designtype d_designtype String 255 0 0 d_diameter d_diameter String 255 0 0 d_secondarydiameter d_secondarydiameter String 255 0 0 d_normalstatus d_normalstatus String 255 0 0 d_additionaldetails d_additionaldetails String 255 0 0 d_operable d_operable String 255 0 0 d_lifecyclestatus d_lifecyclestatus String 255 0 0 d_ownedby d_ownedby String 255 0 0 d_maintby d_maintby String 255 0 0 d_additionaldevice d_additionaldevice String 255 0 0 d_symbolrotation d_symbolrotation String 255 0 0 d_material d_material String 255 0 0 d_spatialsource d_spatialsource String 255 0 0 d_spatialconfidence d_spatialconfidence String 255 0 0 d_cptraceability d_cptraceability String 255 0 0 d_cpoverride d_cpoverride String 255 0 0 d_adminarea d_adminarea String 255 0 0 d_opsarea d_opsarea String 255 0 0 d_sewersystem d_sewersystem String 255 0 0 d_internalseal d_internalseal String 255 0 0 d_externalseal d_externalseal String 255 0 0 d_sealtitelid d_sealtitelid String 255 0 0 Discharge 22 ASSETTYPE 0 6_Asset_Type_Sewer_Device_Discharge The Asset Types for the Sewer Device Asset Group Effluent Discharge Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 Sewer_UN_6_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 Sewer_UN_6_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 Sewer_UN_6_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 Sewer_UN_6_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 sewershedsubnetworkname Unknown presentstatus 3 6_Pipeline_Device_Status The status of a device Coded Value Default value Duplicate DBO SmallInteger activevol 0 6_Rainfall_Intensity The current/activate value of a stormwater or sewer device. Coded Value Default value Duplicate DBO SmallInteger currentvol 0 6_Rainfall_Intensity The current/activate value of a stormwater or sewer device. Coded Value Default value Duplicate DBO SmallInteger normalstatus 3 6_Pipe_Device_Status_Combined The status or state of a device. Coded Value Default value Duplicate DBO SmallInteger lifecyclestatus 8 6_Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger ownedby 1 6_Sewer_Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 6_Sewer_Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation 6_Sewer_Symbol_Rotation The rotation of an asset's symbol Range Default value Duplicate DBO SmallInteger spatialsource 0 6_Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 6_Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger cptraceability 0 6_Yes_No A yes/no indicator Coded Value Default value Duplicate DBO SmallInteger cpoverride 6_CP_Traceability Valid cathodic protection status values Coded Value Default value Duplicate DBO SmallInteger adminarea 6_Admin_Area Detailed list of asset owners and managers Coded Value Default value Duplicate DBO String opsarea 6_Ops_Area List of LCPW operation areas Coded Value Default value Duplicate DBO String sewersystem 6_Sewer_System Regional sewer systems that LCPW operate within. Coded Value Default value Duplicate DBO String 20230428