20220317 09105800 1.0 FALSE wHydrant 002 Projected GCS_North_American_1983 Linear Unit: Foot_US (0.304801) NAD_1983_StatePlane_Illinois_East_FIPS_1201_Feet <ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.0.0'><WKT>PROJCS[&quot;NAD_1983_StatePlane_Illinois_East_FIPS_1201_Feet&quot;,GEOGCS[&quot;GCS_North_American_1983&quot;,DATUM[&quot;D_North_American_1983&quot;,SPHEROID[&quot;GRS_1980&quot;,6378137.0,298.257222101]],PRIMEM[&quot;Greenwich&quot;,0.0],UNIT[&quot;Degree&quot;,0.0174532925199433]],PROJECTION[&quot;Transverse_Mercator&quot;],PARAMETER[&quot;False_Easting&quot;,984250.0],PARAMETER[&quot;False_Northing&quot;,0.0],PARAMETER[&quot;Central_Meridian&quot;,-88.33333333333333],PARAMETER[&quot;Scale_Factor&quot;,0.999975],PARAMETER[&quot;Latitude_Of_Origin&quot;,36.66666666666666],UNIT[&quot;Foot_US&quot;,0.3048006096012192],AUTHORITY[&quot;EPSG&quot;,3435]]</WKT><XOrigin>-17463800</XOrigin><YOrigin>-46132600</YOrigin><XYScale>3048.0060960121928</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>2</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102671</WKID><LatestWKID>3435</LatestWKID></ProjectedCoordinateSystem> 20230907 10045700 20230907 10045700 Esri ArcGIS 13.0.2.36056 wHydrant Enterprise Geodatabase Feature Class dataset EPSG 8.9.3(9.3.0.0) 0 Simple FALSE 0 TRUE TRUE wHydrant Feature Class 0 OBJECTID OBJECTID OID 4 10 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. ASSETGROUP Asset group Integer 4 10 0 ASSETTYPE Asset type SmallInteger 2 5 0 ASSOCIATIONSTATUS Association status SmallInteger 2 5 0 ISSUBNETWORKCONTROLLER Is subnetwork controller SmallInteger 2 5 0 ISCONNECTED Is connected SmallInteger 2 5 0 SUBNETWORKCONTROLLERNAME Subnetwork controller name String 2000 0 0 TIERNAME Tier name Integer 4 10 0 TIERRANK Tier rank Integer 4 10 0 TERMINALCONFIGURATION Terminal path String 128 0 0 GLOBALID Global ID GlobalID 38 0 0 SystemSubnetworkName System Subnetwork Name String 2000 0 0 SUPPORTEDSUBNETWORKNAME Supported subnetwork name String 2000 0 0 SUPPORTINGSUBNETWORKNAME Supporting subnetwork name String 2000 0 0 creationdate Creation date Date 8 0 0 creator Creator String 255 0 0 lastupdate Last update Date 8 0 0 updatedby Updated by String 255 0 0 diameter diameter: Diameter, Diameter 1, Height, Inlet Diameter, Pipe Diameter, Weight Double 8 38 8 secondarydiameter secondarydiameter: Diameter 2, Nozzle Diameter, Outlet Diameter, Width Double 8 38 8 pressure pressure: Amperage, Pressure, Rated Pressure, Volume Double 8 38 8 designtype designtype: Anode Count, Design Type, Manufacturer, Pump Type, Test Wire Count, Valve Type, Wire Count SmallInteger 2 5 0 normalstatus Normal Status SmallInteger 2 5 0 presentstatus Present Status SmallInteger 2 5 0 additionaldetails additionaldetails: Clockwise to Close, Cooling Method, Critical, Material SmallInteger 2 5 0 designinfo designinfo: Anode Depth, Rated Flow, Turns to Close, Voltage Double 8 38 8 operable Operable SmallInteger 2 5 0 name Name String 64 0 0 installdate Install Date Date 8 0 0 assetid Asset ID String 64 0 0 accountid Account ID String 50 0 0 ownedby Owned By SmallInteger 2 5 0 maintby Maintained By SmallInteger 2 5 0 additionaldevice additionaldevice: Additional Device, Has Bypass, Internal Meter, Metered SmallInteger 2 5 0 notes Notes String 2000 0 0 symbolrotation Symbol Rotation SmallInteger 2 5 0 lastmaint Last Maintenance Date 8 0 0 lifecyclestatus Lifecycle Status SmallInteger 2 5 0 inservicedate In-Service Date Date 8 0 0 retireddate Retired Date Date 8 0 0 spatialsource Spatial Source SmallInteger 2 5 0 spatialconfidence Spatial Confidence SmallInteger 2 5 0 manufacturer Manufacturer SmallInteger 2 5 0 operator Postindicator Valve SmallInteger 2 5 0 locationvop Location String 255 0 0 enclosurevop Enclosure SmallInteger 2 5 0 materialvop Material SmallInteger 2 5 0 pdopvop PDOP Double 8 38 8 datasourcevop Data Source SmallInteger 2 5 0 sectioncodevop Section Code String 64 0 0 objectnumbervop Object Number String 64 0 0 eamidvop EAM ID String 64 0 0 eamdescvop EAM Description String 64 0 0 dqualityvop D Quality Double 8 38 8 nodeidvop NODE ID String 64 0 0 makevop Make String 64 0 0 breakawayvop Breakaway SmallInteger 2 5 0 lastpaintvop Year Constructed SmallInteger 2 5 0 nutdepthvop Nut Depth SmallInteger 2 5 0 yearabandonedvop Year Abandoned SmallInteger 2 5 0 capacityvop Capacity (Gal) Double 8 38 8 pinvop PIN String 13 0 0 elevationvop TOF Elevation Double 8 38 8 yearconstructedvop Year Constructed SmallInteger 2 5 0 contractvop I Contract Num String 64 0 0 cathodicprotectionsysnumvop Cathodic Protection System Num String 64 0 0 tanknovop Tank No String 64 0 0 apiwellvop API Double 8 38 8 longwestwellvop LONG_WEST Double 8 38 8 lamxwellvop LAMX Integer 4 10 0 lamywellvop LAMY Integer 4 10 0 tdwellvop TD Integer 4 10 0 sectwellvop SECT Integer 4 10 0 twpwellvop TWP Integer 4 10 0 tdirwellvop TDIR String 9 0 0 rngwellvop RNG Integer 4 10 0 rdirwellvop RDIR String 9 0 0 nsfwellvop NSF String 9 0 0 nsdirwellvop NSDIR String 9 0 0 ewfwellvop EWF String 9 0 0 ewdirwellvop EWDIR String 9 0 0 cornerwellvop CORNER String 9 0 0 quarterswellvop QUARTERS String 9 0 0 elevwellvop ELEV Integer 4 10 0 elevrefwellvop ELEVREF String 9 0 0 cdatewellvop CDATE Integer 4 10 0 stwellvop ST String 9 0 0 fnamewellvop FNAME String 9 0 0 fnumwellvop FNUM String 9 0 0 cnamewellvop CNAME String 9 0 0 permitnumwellvop PERMITNUM Integer 4 10 0 permitdatewellvop PERMITDATE String 9 0 0 welltypewellvop WELLTYPE String 9 0 0 wformationwellvop WFORMATION String 9 0 0 wfmfromwellvop WFMFROM String 9 0 0 wfmtowellvop WFMTO String 9 0 0 scrndiamwellvop SCRNDIAM String 9 0 0 scrnlgthwellvop SCRNLGTH String 9 0 0 slotwellvop SLOT String 9 0 0 caseholewellvop CASEHOLE String 9 0 0 statlevlwellvop STATLEVL String 9 0 0 pumplevlwellvop PUMPLEVL String 9 0 0 pumpgpmwellvop PUMPGPM String 9 0 0 pumphrswellvop PUMPHRS String 9 0 0 heightvop Overall Height Span String 64 0 0 Shape Shape Geometry 8 0 0 Feature geometry. Esri Coordinates defining the features. Unknown 0 ASSETTYPE 0 UtilityNetwork_111_UnknownAssetType The AssetType domain for the Unknown AssetGroup. Coded Value Default value Default value DBO SmallInteger ASSOCIATIONSTATUS 0 UtilityNetwork_111_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 UtilityNetwork_111_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 UtilityNetwork_111_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 UtilityNetwork_111_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default SystemSubnetworkName Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown operable 1 Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger Flow Valve 1 ASSETTYPE 0 Asset_Type_Water_Device_Flow_Valve The Asset Types for the Water Device's Asset Group Flow Valve Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 UtilityNetwork_111_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 UtilityNetwork_111_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 UtilityNetwork_111_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 UtilityNetwork_111_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default SystemSubnetworkName Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown diameter 0 Water_Diameter General domain for the diameter of water assets, in Imperial units Coded Value Default value Duplicate DBO Double operable 1 Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger System Valve 2 ASSETTYPE 0 Asset_Type_Water_Device_System_Valve The Asset Types for the Water Device's Asset Group System Valve Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 UtilityNetwork_111_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 UtilityNetwork_111_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 UtilityNetwork_111_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 UtilityNetwork_111_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default SystemSubnetworkName Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown diameter Water_Diameter General domain for the diameter of water assets, in Imperial units Coded Value Default value Duplicate DBO Double designtype Water_Valve_Type Types of controllable water valves Coded Value Default value Duplicate DBO SmallInteger normalstatus 1 Pipeline_Valve_Status The status of a water device Coded Value Default value Duplicate DBO SmallInteger presentstatus 1 Pipeline_Valve_Status The status of a water device Coded Value Default value Duplicate DBO SmallInteger additionaldetails Pipeline_Valve_Close_Direction The close direction of a valve Coded Value Default value Duplicate DBO SmallInteger operable 1 Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger additionaldevice Yes_No Valid Yes, No values Coded Value Default value Duplicate DBO SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger spatialsource Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger enclosurevop Water_Enclosure_VOP Valves enclosure types Coded Value Default value Duplicate DBO SmallInteger Pressure Valve 3 ASSETTYPE 0 Asset_Type_Water_Device_Pressure_Valve The Asset Types for the Water Device's Asset Group Pressure Valve Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 UtilityNetwork_111_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 UtilityNetwork_111_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 UtilityNetwork_111_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 UtilityNetwork_111_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default SystemSubnetworkName Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown diameter 0 Water_Diameter General domain for the diameter of water assets, in Imperial units Coded Value Default value Duplicate DBO Double operable 1 Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger Station 4 ASSETTYPE 0 Asset_Type_Water_Device_Station The Asset Types for the Water Device's Asset Group Station Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 UtilityNetwork_111_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 UtilityNetwork_111_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 UtilityNetwork_111_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 UtilityNetwork_111_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default SystemSubnetworkName Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown operable 1 Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger Pump 5 ASSETTYPE 0 Asset_Type_Water_Device_Pump The Asset Types for the Water Device's Asset Group Pump Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 UtilityNetwork_111_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 UtilityNetwork_111_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 UtilityNetwork_111_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 UtilityNetwork_111_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default SystemSubnetworkName Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown diameter 0 Water_Pump_Diameter Sizes of pumps Coded Value Default value Duplicate DBO Double secondarydiameter 0 Water_Pump_Diameter Sizes of pumps Coded Value Default value Duplicate DBO Double designtype 0 Water_Pump_Type The different types of pump designs. Coded Value Default value Duplicate DBO SmallInteger operable 1 Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger additionaldevice 0 Yes_No Valid Yes, No values Coded Value Default value Duplicate DBO SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger Service Valve 6 ASSETTYPE 0 Asset_Type_Water_Device_Service_Valve The Asset Types for the Water Device's Asset Group Service Valve Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 UtilityNetwork_111_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 UtilityNetwork_111_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 UtilityNetwork_111_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 UtilityNetwork_111_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default SystemSubnetworkName Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown diameter Water_Diameter General domain for the diameter of water assets, in Imperial units Coded Value Default value Duplicate DBO Double designtype Water_Valve_Type Types of controllable water valves Coded Value Default value Duplicate DBO SmallInteger normalstatus 1 Pipeline_Valve_Status The status of a water device Coded Value Default value Duplicate DBO SmallInteger presentstatus 1 Pipeline_Valve_Status The status of a water device Coded Value Default value Duplicate DBO SmallInteger additionaldetails Pipeline_Valve_Close_Direction The close direction of a valve Coded Value Default value Duplicate DBO SmallInteger operable 1 Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger spatialsource Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger operator Yes_No Valid Yes, No values Coded Value Default value Duplicate DBO SmallInteger enclosurevop Water_Enclosure_VOP Valves enclosure types Coded Value Default value Duplicate DBO SmallInteger materialvop Water_Service_Material Materials for water service lines Coded Value Default value Duplicate DBO SmallInteger datasourcevop Water_DataSource_VOP Data Source Coded Value Default value Duplicate DBO SmallInteger Fire Hydrant 7 ASSETTYPE 0 Asset_Type_Water_Device_Fire_Hydrant The Asset Types for the Water Device's Asset Group Fire Hydrant Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 UtilityNetwork_111_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 UtilityNetwork_111_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 UtilityNetwork_111_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 UtilityNetwork_111_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default SystemSubnetworkName Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown diameter 0 Water_Hydrant_Service_Diameter List of hydrant service sizes, in Imperial units Coded Value Default value Duplicate DBO Double secondarydiameter 0 Water_Hydrant_Nozzle_Diameter Sizes of a fire hydrants nozzle, in Imperial units Coded Value Default value Duplicate DBO Double operable 1 Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger additionaldevice 0 Yes_No Valid Yes, No values Coded Value Default value Duplicate DBO SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger manufacturer Water_Fire_Hydrant_Manufacturer The valid hydrant manufacturers Coded Value Default value Duplicate DBO SmallInteger breakawayvop Yes_No Valid Yes, No values Coded Value Default value Duplicate DBO SmallInteger Outlet 8 ASSETTYPE 0 Asset_Type_Water_Device_Outlet The Asset Types for the Water Device's Asset Group Outlet Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 UtilityNetwork_111_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 UtilityNetwork_111_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 UtilityNetwork_111_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 UtilityNetwork_111_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default SystemSubnetworkName Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown operable 1 Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger Flushing and Blow Off 9 ASSETTYPE 0 Asset_Type_Water_Device_Flushing_and_Blow_Off The Asset Types for the Water Device's Asset Group Flushing and Blow Off Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 UtilityNetwork_111_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 UtilityNetwork_111_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 UtilityNetwork_111_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 UtilityNetwork_111_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default SystemSubnetworkName Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown normalstatus 0 Pipeline_Valve_Status The status of a water device Coded Value Default value Duplicate DBO SmallInteger presentstatus 0 Pipeline_Valve_Status The status of a water device Coded Value Default value Duplicate DBO SmallInteger operable 1 Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger Service Meter 10 ASSETTYPE 0 Asset_Type_Water_Device_Service_Meter The Asset Types for the Water Device's Asset Group Service Meter Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 UtilityNetwork_111_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 UtilityNetwork_111_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 UtilityNetwork_111_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 UtilityNetwork_111_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default SystemSubnetworkName Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown diameter Water_Meter_Diameter General list of service sizes, in Imperial units Coded Value Default value Duplicate DBO Double operable 1 Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger spatialsource Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger Monitoring 11 ASSETTYPE 0 Asset_Type_Water_Device_Monitoring The Asset Types for the Water Device's Asset Group Monitoring Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 UtilityNetwork_111_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 UtilityNetwork_111_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 UtilityNetwork_111_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 UtilityNetwork_111_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default SystemSubnetworkName Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown operable Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger Service Connection 12 ASSETTYPE 0 Asset_Type_Water_Device_Service_Connection The Asset Types for the Water Junction's Asset Group Service Connection Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 UtilityNetwork_111_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 UtilityNetwork_111_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 UtilityNetwork_111_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 UtilityNetwork_111_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default SystemSubnetworkName Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown additionaldetails 2 Yes_No Valid Yes, No values Coded Value Default value Duplicate DBO SmallInteger operable 1 Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger additionaldevice 2 Yes_No Valid Yes, No values Coded Value Default value Duplicate DBO SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger System Meter 13 ASSETTYPE 0 Asset_Type_Water_Device_System_Meter The Asset Types for the Water Device's Asset Group System Meter Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 UtilityNetwork_111_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 UtilityNetwork_111_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 UtilityNetwork_111_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 UtilityNetwork_111_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default SystemSubnetworkName Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown diameter Water_Meter_Diameter General list of service sizes, in Imperial units Coded Value Default value Duplicate DBO Double operable 1 Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger spatialsource Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger Supply 15 ASSETTYPE 0 Asset_Type_Water_Device_Supply The Asset Types for the Water Device's Asset Group Supply Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 UtilityNetwork_111_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 UtilityNetwork_111_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 UtilityNetwork_111_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 UtilityNetwork_111_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default SystemSubnetworkName Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown diameter 0 Water_Well_Diameter General list of well sizes Coded Value Default value Duplicate DBO Double operable 1 Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger Filter 17 ASSETTYPE 0 Asset_Type_Water_Device_Filter The Asset Types for the Water Device's Asset Group Filter Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 UtilityNetwork_111_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 UtilityNetwork_111_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 UtilityNetwork_111_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 UtilityNetwork_111_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default SystemSubnetworkName Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown operable 1 Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger Controller 18 ASSETTYPE 0 Asset_Type_Water_Device_Controller The Asset Types for the Water Device's Asset Group Controller Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 UtilityNetwork_111_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 UtilityNetwork_111_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 UtilityNetwork_111_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 UtilityNetwork_111_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default SystemSubnetworkName Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown operable 1 Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger Injection Facility 19 ASSETTYPE 0 Asset_Type_Water_Device_Injection_Facility The Asset Types for the Water Device's Asset Group Injection Facility Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 UtilityNetwork_111_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 UtilityNetwork_111_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 UtilityNetwork_111_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 UtilityNetwork_111_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default SystemSubnetworkName Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown operable 1 Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger Storage 20 ASSETTYPE 0 Asset_Type_Water_Device_Storage The Asset Types for the Water Device's Asset Group Storage Coded Value Default value Duplicate DBO SmallInteger ASSOCIATIONSTATUS 0 UtilityNetwork_111_AssociationStatus Indicates how the feature participates in associations. Coded Value Default value Duplicate DBO SmallInteger ISSUBNETWORKCONTROLLER 0 UtilityNetwork_111_IsSubnetworkController Indicates if a device feature is a subnetwork controller. Coded Value Default value Default value DBO SmallInteger ISCONNECTED 2 UtilityNetwork_111_IsConnected Indicates if the feature is connected to a subnetwork controller. Coded Value Default value Duplicate DBO SmallInteger SUBNETWORKCONTROLLERNAME Unknown TIERNAME 0 UtilityNetwork_111_TierName The tier names in the utility network. Coded Value Default value Default value DBO SmallInteger TIERRANK 0 TERMINALCONFIGURATION Default SystemSubnetworkName Unknown SUPPORTEDSUBNETWORKNAME Unknown SUPPORTINGSUBNETWORKNAME Unknown operable 1 Boolean True or False Coded Value Default value Duplicate DBO SmallInteger ownedby 1 Asset_Owner The owner of the asset. Coded Value Default value Duplicate DBO SmallInteger maintby 1 Asset_Manager The manager of the asset. Coded Value Default value Duplicate DBO SmallInteger symbolrotation Symbol_Rotation Valid rotation values Range Default value Duplicate DBO SmallInteger lifecyclestatus 8 Lifecycle_Status Valid lifecycle states for the assets. Coded Value Default value Duplicate DBO SmallInteger spatialsource 0 Spatial_Source Source of the data Coded Value Default value Duplicate DBO SmallInteger spatialconfidence 0 Spatial_Confidence Confidence values for the data Coded Value Default value Duplicate DBO SmallInteger created_user created_user String 255 0 0 created_date created_date Date 8 0 0 last_edited_user last_edited_user String 255 0 0 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_diameter d_diameter String 255 0 0 d_secondarydiameter d_secondarydiameter String 255 0 0 d_designtype d_designtype String 255 0 0 d_normalstatus d_normalstatus String 255 0 0 d_presentstatus d_presentstatus String 255 0 0 d_additionaldetails d_additionaldetails String 255 0 0 d_operable d_operable 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_lifecyclestatus d_lifecyclestatus String 255 0 0 d_spatialsource d_spatialsource String 255 0 0 d_spatialconfidence d_spatialconfidence String 255 0 0 d_manufacturer d_manufacturer String 255 0 0 d_operator d_operator String 255 0 0 d_enclosurevop d_enclosurevop String 255 0 0 d_materialvop d_materialvop String 255 0 0 d_datasourcevop d_datasourcevop String 255 0 0 d_breakawayvop d_breakawayvop String 255 0 0 last_edited_date last_edited_date Date 8 0 0 20230907