Name: Water Device
Display Field: name
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description:
Copyright Text:
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: -9816618.24123208
YMin: 5125573.73809855
XMax: -9808616.00340202
YMax: 5130649.31824437
Spatial Reference: 102100 (3857)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,0,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: true
HasM: true
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: Object ID, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)
- ASSETGROUP (type: esriFieldTypeInteger, alias: Asset group, SQL Type: sqlTypeOther, nullable: false, editable: true)
- ASSETTYPE (type: esriFieldTypeSmallInteger, alias: Asset type, SQL Type: sqlTypeOther, nullable: false, editable: true)
- ASSOCIATIONSTATUS (type: esriFieldTypeSmallInteger, alias: Association status, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: None], [1: Container], [2: Structure], ... 33 more ...)
- ISSUBNETWORKCONTROLLER (type: esriFieldTypeSmallInteger, alias: Is subnetwork controller, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: False], [1: True])
- ISCONNECTED (type: esriFieldTypeSmallInteger, alias: Is connected, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: False], [1: True], [2: Unknown])
- SUBNETWORKCONTROLLERNAME (type: esriFieldTypeString, alias: Subnetwork controller name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: true)
- TIERNAME (type: esriFieldTypeSmallInteger, alias: Tier name, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: Unknown], [1: Water System], [2: Water Pressure])
- TIERRANK (type: esriFieldTypeInteger, alias: Tier rank, SQL Type: sqlTypeOther, nullable: false, editable: true)
- TERMINALCONFIGURATION (type: esriFieldTypeString, alias: Terminal path, SQL Type: sqlTypeOther, length: 128, nullable: false, editable: true)
- GLOBALID (type: esriFieldTypeGUID, alias: Global ID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: true)
- SystemSubnetworkName (type: esriFieldTypeString, alias: System Subnetwork Name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: true)
- SUPPORTEDSUBNETWORKNAME (type: esriFieldTypeString, alias: Supported subnetwork name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: true)
- SUPPORTINGSUBNETWORKNAME (type: esriFieldTypeString, alias: Supporting subnetwork name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: true)
- PressureSubnetworkName (type: esriFieldTypeString, alias: Pressure Subnetwork Name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: true)
- diameter (type: esriFieldTypeDouble, alias: Diameter - Imperial, SQL Type: sqlTypeOther, nullable: true, editable: true)
- pressure (type: esriFieldTypeDouble, alias: Pressure, SQL Type: sqlTypeOther, nullable: true, editable: true)
- designtype (type: esriFieldTypeSmallInteger, alias: Design Type, SQL Type: sqlTypeOther, nullable: true, editable: true)
- normalstatus (type: esriFieldTypeSmallInteger, alias: Normal Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Closed], [1: Open])
- operable (type: esriFieldTypeSmallInteger, alias: Closeable, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
- name (type: esriFieldTypeString, alias: Name, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
- assetid (type: esriFieldTypeString, alias: Asset ID, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
- symbolrotation (type: esriFieldTypeSmallInteger, alias: Symbol Rotation, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 359])
- lifecyclestatus (type: esriFieldTypeSmallInteger, alias: Lifecycle Status, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: Out of Service], [1: Proposed], [2: In Service], ... 3 more ...)
- created_user (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- created_date (type: esriFieldTypeDate, alias: Creation Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- last_edited_user (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- last_edited_date (type: esriFieldTypeDate, alias: Edit Date Potato, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- constructionstatus (type: esriFieldTypeSmallInteger, alias: Construction Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Warehouse], [1: Abandoned], [2: Removed], ... 5 more ...)
- diameter_metric (type: esriFieldTypeDouble, alias: Diameter - Metric, SQL Type: sqlTypeOther, nullable: true, editable: true)
- VALIDATIONSTATUS (type: esriFieldTypeSmallInteger, alias: Validation status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No calculation required, no validation required, no error], [1: No calculation required, no validation required, has error(s)], [2: No calculation required, validation required, no error], ... 5 more ...)
Templates:
Name: Flow Valve
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- constructionstatus: 6
- lifecyclestatus: 2
- VALIDATIONSTATUS: 6
- ASSETGROUP: 1
- PressureSubnetworkName: Unknown
- diameter: 0
- TIERRANK: 0
- ASSETTYPE: 3
- ASSOCIATIONSTATUS: 0
- ISSUBNETWORKCONTROLLER: 0
- ISCONNECTED: 2
- SUBNETWORKCONTROLLERNAME: Unknown
- TIERNAME: 0
- GLOBALID: {00000000-0000-0000-0000-000000000000}
- SystemSubnetworkName: Unknown
- SUPPORTEDSUBNETWORKNAME: Unknown
- SUPPORTINGSUBNETWORKNAME: Unknown
- diameter_metric: 0
- TERMINALCONFIGURATION: Default
Name: System Valve
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- constructionstatus: 6
- lifecyclestatus: 2
- VALIDATIONSTATUS: 6
- ASSETGROUP: 2
- PressureSubnetworkName: Unknown
- diameter: 0
- TIERRANK: 0
- normalstatus: 1
- operable: 1
- ASSETTYPE: 170
- ASSOCIATIONSTATUS: 0
- ISSUBNETWORKCONTROLLER: 0
- ISCONNECTED: 2
- SUBNETWORKCONTROLLERNAME: Unknown
- TIERNAME: 0
- GLOBALID: {00000000-0000-0000-0000-000000000000}
- SystemSubnetworkName: Unknown
- SUPPORTEDSUBNETWORKNAME: Unknown
- SUPPORTINGSUBNETWORKNAME: Unknown
- diameter_metric: 0
- TERMINALCONFIGURATION: Default
Name: Pressure Valve
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- constructionstatus: 6
- lifecyclestatus: 2
- VALIDATIONSTATUS: 6
- ASSETGROUP: 3
- PressureSubnetworkName: Unknown
- diameter: 0
- TIERRANK: 0
- ASSETTYPE: 205
- ASSOCIATIONSTATUS: 0
- ISSUBNETWORKCONTROLLER: 0
- ISCONNECTED: 2
- SUBNETWORKCONTROLLERNAME: Unknown
- TIERNAME: 0
- GLOBALID: {00000000-0000-0000-0000-000000000000}
- SystemSubnetworkName: Unknown
- SUPPORTEDSUBNETWORKNAME: Unknown
- SUPPORTINGSUBNETWORKNAME: Unknown
- diameter_metric: 0
- TERMINALCONFIGURATION: Default
Name: Station
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- constructionstatus: 6
- lifecyclestatus: 2
- VALIDATIONSTATUS: 6
- ASSETGROUP: 4
- PressureSubnetworkName: Unknown
- TIERRANK: 0
- ASSETTYPE: 242
- ASSOCIATIONSTATUS: 0
- ISSUBNETWORKCONTROLLER: 0
- ISCONNECTED: 2
- SUBNETWORKCONTROLLERNAME: Unknown
- TIERNAME: 0
- GLOBALID: {00000000-0000-0000-0000-000000000000}
- SystemSubnetworkName: Unknown
- SUPPORTEDSUBNETWORKNAME: Unknown
- SUPPORTINGSUBNETWORKNAME: Unknown
- TERMINALCONFIGURATION: Default
Name: Service Valve
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- constructionstatus: 6
- lifecyclestatus: 2
- VALIDATIONSTATUS: 6
- ASSETGROUP: 6
- PressureSubnetworkName: Unknown
- diameter: 0
- TIERRANK: 0
- normalstatus: 1
- operable: 1
- ASSETTYPE: 176
- ASSOCIATIONSTATUS: 0
- ISSUBNETWORKCONTROLLER: 0
- ISCONNECTED: 2
- SUBNETWORKCONTROLLERNAME: Unknown
- TIERNAME: 0
- GLOBALID: {00000000-0000-0000-0000-000000000000}
- SystemSubnetworkName: Unknown
- SUPPORTEDSUBNETWORKNAME: Unknown
- SUPPORTINGSUBNETWORKNAME: Unknown
- diameter_metric: 0
- TERMINALCONFIGURATION: Default
Name: Hydrant
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- constructionstatus: 6
- lifecyclestatus: 2
- VALIDATIONSTATUS: 6
- ASSETGROUP: 7
- PressureSubnetworkName: Unknown
- diameter: 0
- TIERRANK: 0
- ASSETTYPE: 321
- ASSOCIATIONSTATUS: 0
- ISSUBNETWORKCONTROLLER: 0
- ISCONNECTED: 2
- SUBNETWORKCONTROLLERNAME: Unknown
- TIERNAME: 0
- GLOBALID: {00000000-0000-0000-0000-000000000000}
- SystemSubnetworkName: Unknown
- SUPPORTEDSUBNETWORKNAME: Unknown
- SUPPORTINGSUBNETWORKNAME: Unknown
- diameter_metric: 0
- TERMINALCONFIGURATION: Default
Name: Service Meter
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- constructionstatus: 6
- lifecyclestatus: 2
- VALIDATIONSTATUS: 6
- ASSETGROUP: 10
- PressureSubnetworkName: Unknown
- diameter: 0
- TIERRANK: 0
- ASSETTYPE: 51
- ASSOCIATIONSTATUS: 0
- ISSUBNETWORKCONTROLLER: 0
- ISCONNECTED: 2
- SUBNETWORKCONTROLLERNAME: Unknown
- TIERNAME: 0
- GLOBALID: {00000000-0000-0000-0000-000000000000}
- SystemSubnetworkName: Unknown
- SUPPORTEDSUBNETWORKNAME: Unknown
- SUPPORTINGSUBNETWORKNAME: Unknown
- diameter_metric: 0
- TERMINALCONFIGURATION: Default
Name: Service Connection
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- constructionstatus: 6
- lifecyclestatus: 2
- VALIDATIONSTATUS: 6
- ASSETGROUP: 12
- PressureSubnetworkName: Unknown
- TIERRANK: 0
- ASSETTYPE: 65
- ASSOCIATIONSTATUS: 0
- ISSUBNETWORKCONTROLLER: 0
- ISCONNECTED: 2
- SUBNETWORKCONTROLLERNAME: Unknown
- TIERNAME: 0
- GLOBALID: {00000000-0000-0000-0000-000000000000}
- SystemSubnetworkName: Unknown
- SUPPORTEDSUBNETWORKNAME: Unknown
- SUPPORTINGSUBNETWORKNAME: Unknown
- TERMINALCONFIGURATION: Default
Name: System Meter
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- constructionstatus: 6
- lifecyclestatus: 2
- VALIDATIONSTATUS: 6
- ASSETGROUP: 13
- PressureSubnetworkName: Unknown
- diameter: 0
- TIERRANK: 0
- ASSETTYPE: 41
- ASSOCIATIONSTATUS: 0
- ISSUBNETWORKCONTROLLER: 0
- ISCONNECTED: 2
- SUBNETWORKCONTROLLERNAME: Unknown
- TIERNAME: 0
- GLOBALID: {00000000-0000-0000-0000-000000000000}
- SystemSubnetworkName: Unknown
- SUPPORTEDSUBNETWORKNAME: Unknown
- SUPPORTINGSUBNETWORKNAME: Unknown
- diameter_metric: 0
- TERMINALCONFIGURATION: Default
Name: Supply
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- constructionstatus: 6
- lifecyclestatus: 2
- VALIDATIONSTATUS: 6
- ASSETGROUP: 15
- PressureSubnetworkName: Unknown
- TIERRANK: 0
- ASSETTYPE: 601
- ASSOCIATIONSTATUS: 0
- ISSUBNETWORKCONTROLLER: 0
- ISCONNECTED: 2
- SUBNETWORKCONTROLLERNAME: Unknown
- TIERNAME: 0
- GLOBALID: {00000000-0000-0000-0000-000000000000}
- SystemSubnetworkName: Unknown
- SUPPORTEDSUBNETWORKNAME: Unknown
- SUPPORTINGSUBNETWORKNAME: Unknown
- diameter_metric: 0
- TERMINALCONFIGURATION: Default
Name: Storage
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- constructionstatus: 6
- lifecyclestatus: 2
- VALIDATIONSTATUS: 6
- ASSETGROUP: 20
- PressureSubnetworkName: Unknown
- TIERRANK: 0
- ASSETTYPE: 563
- ASSOCIATIONSTATUS: 0
- ISSUBNETWORKCONTROLLER: 0
- ISCONNECTED: 2
- SUBNETWORKCONTROLLERNAME: Unknown
- TIERNAME: 0
- GLOBALID: {00000000-0000-0000-0000-000000000000}
- SystemSubnetworkName: Unknown
- SUPPORTEDSUBNETWORKNAME: Unknown
- SUPPORTINGSUBNETWORKNAME: Unknown
- TERMINALCONFIGURATION: Default
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 10/24/2025 11:11:53 AM
Schema Last Edit Date: 10/24/2025 11:11:53 AM
Data Last Edit Date: 9/8/2025 12:58:48 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Query Boxplots
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat