Name: System Valve

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: -9816582.18644048
YMin: 5125573.73809855
XMax: -9808616.00340202
YMax: 5130649.25532034
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":[{"labelExpressionInfo":{"expression":"$feature.assetid"},"labelPlacement":"esriServerPointLabelPlacementAboveRight","deconflictionStrategy":"dynamic","allowOverlapOfFeatureInterior":"avoid","stackLabel":true,"stackRowLength":24,"stackAlignment":"dynamic","removeDuplicates":"none","where":"ASSETTYPE IN (8, 9, 10)","useCodedValues":true,"maxScale":0,"minScale":1800,"name":"Class 1","priority":-1,"symbol":{"type":"esriTS","color":[0,0,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[255,255,190,255],"haloSize":1,"font":{"family":"Tahoma","size":8,"style":"normal","weight":"bold","decoration":"none"}}}]}

HasZ: true

HasM: true

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• assetgroup (type: esriFieldTypeInteger, alias: Asset group, SQL Type: sqlTypeOther, nullable: true, editable: true)
• assettype (type: esriFieldTypeSmallInteger, alias: Asset type, SQL Type: sqlTypeOther, nullable: true, editable: true)
• associationstatus (type: esriFieldTypeSmallInteger, alias: Association status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: None], [1: Container], [2: Structure], ... 33 more ...)
• issubnetworkcontroller (type: esriFieldTypeSmallInteger, alias: Is subnetwork controller, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• isconnected (type: esriFieldTypeSmallInteger, alias: Is connected, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True], [2: Unknown])
• subnetworkcontrollername (type: esriFieldTypeString, alias: Subnetwork controller name, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• tiername (type: esriFieldTypeInteger, alias: Tier name, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Water Cathodic Protection], [2: Water System], ... 3 more ...)
• tierrank (type: esriFieldTypeInteger, alias: Tier rank, SQL Type: sqlTypeOther, nullable: true, editable: true)
• terminalconfiguration (type: esriFieldTypeString, alias: Terminal path, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• creationdate (type: esriFieldTypeDate, alias: Creation date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• lastupdate (type: esriFieldTypeDate, alias: Last update, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• updatedby (type: esriFieldTypeString, alias: Updated by, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• globalid (type: esriFieldTypeGUID, alias: Global ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• cpsubnetworkname (type: esriFieldTypeString, alias: CP Subnetwork Name, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• supportedsubnetworkname (type: esriFieldTypeString, alias: Supported subnetwork name, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• systemsubnetworkname (type: esriFieldTypeString, alias: System Subnetwork Name, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• pressuresubnetworkname (type: esriFieldTypeString, alias: Pressure Subnetwork Name, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• isolationsubnetworkname (type: esriFieldTypeString, alias: Isolation Subnetwork Name, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• dmasubnetworkname (type: esriFieldTypeString, alias: DMA Subnetwork Name, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• diameter (type: esriFieldTypeDouble, alias: diameter: Diameter, Diameter 1, Height, Inlet Diameter, Pipe Diameter, Weight, SQL Type: sqlTypeOther, nullable: true, editable: true)
• secondarydiameter (type: esriFieldTypeDouble, alias: secondarydiameter: Diameter 2, Nozzle Diameter, Outlet Diameter, Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pressure (type: esriFieldTypeDouble, alias: pressure: Amperage, Pressure, Rated Pressure, Volume, SQL Type: sqlTypeOther, nullable: true, editable: true)
• designtype (type: esriFieldTypeSmallInteger, alias: designtype: Anode Count, Design Type, Manufacturer, Pump Type, Test Wire Count, Valve Type, Wire Count, 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])
• presentstatus (type: esriFieldTypeSmallInteger, alias: Present Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Closed], [1: Open])
• additionaldetails (type: esriFieldTypeSmallInteger, alias: additionaldetails: Clockwise to Close, Cooling Method, Critical, Material, SQL Type: sqlTypeOther, nullable: true, editable: true)
• designinfo (type: esriFieldTypeDouble, alias: designinfo: Anode Depth, Rated Flow, Turns to Close, Voltage, SQL Type: sqlTypeOther, nullable: true, editable: true)
• operable (type: esriFieldTypeSmallInteger, alias: Operable, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• name (type: esriFieldTypeString, alias: Name, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• installdate (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• assetid (type: esriFieldTypeString, alias: Asset ID, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• accountid (type: esriFieldTypeString, alias: Account ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ownedby (type: esriFieldTypeSmallInteger, alias: Owned By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Our Agency], [2: Private], [100: Other])
• maintby (type: esriFieldTypeSmallInteger, alias: Maintained By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Our Agency], [2: Private], [100: Other])
• additionaldevice (type: esriFieldTypeSmallInteger, alias: additionaldevice: Additional Device, Has Bypass, Internal Meter, Metered, SQL Type: sqlTypeOther, nullable: true, editable: true)
• notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• symbolrotation (type: esriFieldTypeSmallInteger, alias: Symbol Rotation, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 359])
• lastmaint (type: esriFieldTypeDate, alias: Last Maintenance, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• lifecyclestatus (type: esriFieldTypeSmallInteger, alias: Lifecycle Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Proposed], [2: Approved], ... 14 more ...)
• bondedinsulated (type: esriFieldTypeSmallInteger, alias: Bonded/Insulated, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Bonded], [2: Insulated])
• cptraceability (type: esriFieldTypeSmallInteger, alias: Cathodic Protection Traceability, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
• inservicedate (type: esriFieldTypeDate, alias: In-Service Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• retireddate (type: esriFieldTypeDate, alias: Retired Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• spatialsource (type: esriFieldTypeSmallInteger, alias: Spatial Source, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: As-Built], [2: CAD], ... 3 more ...)
• spatialconfidence (type: esriFieldTypeSmallInteger, alias: Spatial Confidence, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: High], [2: Medium], ... 1 more ...)
• cpoverride (type: esriFieldTypeSmallInteger, alias: Cathodic Protection Override, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Traceable], [2: Not Traceable])
• manufacturer (type: esriFieldTypeSmallInteger, alias: Manufacturer, SQL Type: sqlTypeOther, nullable: true, editable: true)
• operator (type: esriFieldTypeSmallInteger, alias: Postindicator Valve, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: Unknown
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• assetgroup: 0
• dmasubnetworkname: Unknown
• lifecyclestatus: 0
• assettype: 0
• associationstatus: 0
• issubnetworkcontroller: 0
• isconnected: 2
• subnetworkcontrollername: Unknown
• tiername: 0
• tierrank: 0
• terminalconfiguration: Default
• cpsubnetworkname: Unknown
• supportedsubnetworkname: Unknown
• systemsubnetworkname: Unknown
• pressuresubnetworkname: Unknown
• isolationsubnetworkname: Unknown
• presentstatus: 0
• operable: 1
• ownedby: 1
• maintby: 1
• cptraceability: 0
Name: Isolation Zone
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• assetgroup: 0
• dmasubnetworkname: Unknown
• lifecyclestatus: 0
• assettype: 167
• associationstatus: 0
• issubnetworkcontroller: 0
• isconnected: 2
• subnetworkcontrollername: Unknown
• tiername: 0
• tierrank: 0
• terminalconfiguration: Default
• cpsubnetworkname: Unknown
• supportedsubnetworkname: Unknown
• systemsubnetworkname: Unknown
• pressuresubnetworkname: Unknown
• isolationsubnetworkname: Unknown
• presentstatus: 0
• operable: 1
• ownedby: 1
• maintby: 1
• cptraceability: 0
Name: Supply
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• assetgroup: 0
• dmasubnetworkname: Unknown
• lifecyclestatus: 0
• assettype: 169
• associationstatus: 0
• issubnetworkcontroller: 0
• isconnected: 2
• subnetworkcontrollername: Unknown
• tiername: 0
• tierrank: 0
• terminalconfiguration: Default
• cpsubnetworkname: Unknown
• supportedsubnetworkname: Unknown
• systemsubnetworkname: Unknown
• pressuresubnetworkname: Unknown
• isolationsubnetworkname: Unknown
• presentstatus: 0
• operable: 1
• ownedby: 1
• maintby: 1
• cptraceability: 0
Name: System
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• assetgroup: 0
• dmasubnetworkname: Unknown
• lifecyclestatus: 0
• assettype: 170
• associationstatus: 0
• issubnetworkcontroller: 0
• isconnected: 2
• subnetworkcontrollername: Unknown
• tiername: 0
• tierrank: 0
• terminalconfiguration: Default
• cpsubnetworkname: Unknown
• supportedsubnetworkname: Unknown
• systemsubnetworkname: Unknown
• pressuresubnetworkname: Unknown
• isolationsubnetworkname: Unknown
• presentstatus: 0
• operable: 1
• ownedby: 1
• maintby: 1
• cptraceability: 0
Name: Pressure Zone
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• assetgroup: 0
• dmasubnetworkname: Unknown
• lifecyclestatus: 0
• assettype: 172
• associationstatus: 0
• issubnetworkcontroller: 0
• isconnected: 2
• subnetworkcontrollername: Unknown
• tiername: 0
• tierrank: 0
• terminalconfiguration: Default
• cpsubnetworkname: Unknown
• supportedsubnetworkname: Unknown
• systemsubnetworkname: Unknown
• pressuresubnetworkname: Unknown
• isolationsubnetworkname: Unknown
• presentstatus: 0
• operable: 1
• ownedby: 1
• maintby: 1
• cptraceability: 0
Name: Bypass
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• assetgroup: 0
• dmasubnetworkname: Unknown
• lifecyclestatus: 0
• assettype: 173
• associationstatus: 0
• issubnetworkcontroller: 0
• isconnected: 2
• subnetworkcontrollername: Unknown
• tiername: 0
• tierrank: 0
• terminalconfiguration: Default
• cpsubnetworkname: Unknown
• supportedsubnetworkname: Unknown
• systemsubnetworkname: Unknown
• pressuresubnetworkname: Unknown
• isolationsubnetworkname: Unknown
• presentstatus: 0
• operable: 1
• ownedby: 1
• maintby: 1
• cptraceability: 0
Name: Interconnect
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• assetgroup: 0
• dmasubnetworkname: Unknown
• lifecyclestatus: 0
• assettype: 175
• associationstatus: 0
• issubnetworkcontroller: 0
• isconnected: 2
• subnetworkcontrollername: Unknown
• tiername: 0
• tierrank: 0
• terminalconfiguration: Default
• cpsubnetworkname: Unknown
• supportedsubnetworkname: Unknown
• systemsubnetworkname: Unknown
• pressuresubnetworkname: Unknown
• isolationsubnetworkname: Unknown
• presentstatus: 0
• operable: 1
• ownedby: 1
• maintby: 1
• cptraceability: 0

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/22/2024 11:00:21 PM

Schema Last Edit Date: 4/22/2024 11:00:21 PM

Data Last Edit Date: 2/1/2023 9:35:06 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Boxplots   Query Attachments   Add Features   Update Features   Delete Features   Apply Edits   Streaming   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat