Name: SystemValve
Display Field: SUBTYPENAME
Type: Feature Layer
Geometry Type: esriGeometryPoint
Is View: true
Is Updatable View: true
Source Schema Changes Allowed: true
Sources
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: 6225466.33766177
YMin: 1895061.27445827
XMax: 6260463.53374335
YMax: 1915581.15172552
Spatial Reference: 102645 (2229)
Drawing Info:
{"renderer":{"type":"uniqueValue","field1":"SUBTYPE","field2":null,"field3":null,"defaultSymbol":{"type":"esriSMS","style":"esriSMSCircle","color":[138,126,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"defaultLabel":"","uniqueValueInfos":[{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[68,150,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"value":"5","label":"Altitude","description":""},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,143,81,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"value":"6","label":"AngleMeterStop","description":""},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,148,86,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"value":"2","label":"Butterfly","description":""},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[148,0,42,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"value":"7","label":"Clay","description":""},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,110,133,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"value":"1","label":"Gate","description":""},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,148,54,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"value":"4","label":"SwingCheck","description":""},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,168,115,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"value":"3","label":"Tapping","description":""}],"fieldDelimiter":","},"transparency":0,"labelingInfo":null}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field: GlobalID
Type ID Field: SUBTYPE
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- ANCILLARYROLE (type: esriFieldTypeSmallInteger, alias: ANCILLARYROLE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ENABLED (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- FACILITYID (type: esriFieldTypeString, alias: FACILITYID, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
- GRIDNO (type: esriFieldTypeString, alias: GRIDNO, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- SUBTYPE (type: esriFieldTypeInteger, alias: Subtype, SQL Type: sqlTypeOther, nullable: true, editable: true)
- SUBTYPENAME (type: esriFieldTypeString, alias: SUBTYPENAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- ASBUILT (type: esriFieldTypeSmallInteger, alias: Asbuilt, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- INSTALLDATE (type: esriFieldTypeDate, alias: INSTALLDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- STATUS (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Proposed: Proposed], [Active: Active], [Abandoned: Abandoned], ... 2 more ...)
- SOURCE (type: esriFieldTypeString, alias: Source, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [AsBuilt: AsBuilt], [Atlas: Atlas], [GPS: GPS], ... 1 more ...)
- OWNER (type: esriFieldTypeString, alias: Owner, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Public: Public], [Private: Private], [CAM: Cal American], ... 7 more ...)
- DWGNO (type: esriFieldTypeString, alias: DWGNO, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
- LASTEXERCISED (type: esriFieldTypeDate, alias: LASTEXERCISED, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- ANGLE (type: esriFieldTypeDouble, alias: Angle, SQL Type: sqlTypeOther, nullable: true, editable: true)
- GPS (type: esriFieldTypeSmallInteger, alias: GPS, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- MANUFACTURER (type: esriFieldTypeString, alias: MANUFACTURER, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- SERVICEDATE (type: esriFieldTypeDate, alias: SERVICEDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- VALVE_NO (type: esriFieldTypeString, alias: VALVE_NO, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- DIAMETER (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.625: 5/8 inch], [0.75: 3/4 inch], [1: 1 inch], ... 30 more ...)
- LOCATION (type: esriFieldTypeString, alias: LOCATION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- CLOCKWISETOCLOSE (type: esriFieldTypeSmallInteger, alias: ClockwiseToClose, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- CURRENTLYOPEN (type: esriFieldTypeSmallInteger, alias: CurrentlyOpen, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- MOTORIZED (type: esriFieldTypeSmallInteger, alias: Motorized, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- NORMALLYOPEN (type: esriFieldTypeSmallInteger, alias: NormallyOpen, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- PERCENTOPEN (type: esriFieldTypeInteger, alias: PercentOpen, SQL Type: sqlTypeOther, nullable: true, editable: true)
- PRESSURESETTING (type: esriFieldTypeString, alias: PRESSURESETTING, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- TURNSTOCLOSE (type: esriFieldTypeDouble, alias: TURNSTOCLOSE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- VALVEPURPOSE (type: esriFieldTypeString, alias: ValvePurpose, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Zone: ZoneValve], [Reservoir: ReservoirValve], [Hydrant: HydrantValve], ... 8 more ...)
- OPERATIONALSTATUS (type: esriFieldTypeString, alias: OPERATIONALSTATUS, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [OK: OK], [NRPR: Needs Repair], [INOP: Inoperable], ... 5 more ...)
- DEPTHTONUT (type: esriFieldTypeSmallInteger, alias: DEPTHTONUT, SQL Type: sqlTypeOther, nullable: true, editable: true)
- OPERATIONCOMMENTS (type: esriFieldTypeString, alias: OPERATIONCOMMENTS, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- NOTES (type: esriFieldTypeString, alias: NOTES, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
- LASTACTIVITY (type: esriFieldTypeString, alias: LASTACTIVITY, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [INST: Installation], [UPDT: Update Info], [EXE: Exercise Valve], ... 4 more ...)
- TRAFFICLANE (type: esriFieldTypeString, alias: TRAFFICLANE, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [1: Lane #1], [2: Lane #2], [3: Lane #3], ... 5 more ...)
- IWATERID (type: esriFieldTypeString, alias: IWATERID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- ADDRESSNUMBER (type: esriFieldTypeString, alias: ADDRESSNUMBER, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
- STREETPREFIX (type: esriFieldTypeString, alias: STREETPREFIX, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [N: N], [S: S], [E: E], ... 5 more ...)
- STREET (type: esriFieldTypeString, alias: STREET, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- STREETSUFFIX (type: esriFieldTypeString, alias: STREETSUFFIX, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [Ave: Ave], [Blvd: Blvd], [Cir: Cir], ... 13 more ...)
- CROSSSTREET (type: esriFieldTypeString, alias: CROSSSTREET, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- HIGHTORQUE (type: esriFieldTypeSmallInteger, alias: HIGHTORQUE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- OPTIME (type: esriFieldTypeString, alias: OPTIME, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- OPERATEDBY (type: esriFieldTypeString, alias: OPERATEDBY, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- COMPUTERNAME (type: esriFieldTypeString, alias: COMPUTERNAME, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
- ID (type: esriFieldTypeInteger, alias: ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- BoxRepair (type: esriFieldTypeSmallInteger, alias: BoxRepair, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- ValveModel (type: esriFieldTypeString, alias: ValveModel, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- ValveManufacDate (type: esriFieldTypeDate, alias: ValveManufacDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- AsbuiltDate (type: esriFieldTypeDate, alias: AsbuiltDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
- EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
Types:
ID: 5
Name: Altitude
Domains:
- Field Name: ENABLED
Inherited
- Field Name: ASBUILT
Inherited
- Field Name: STATUS
Inherited
- Field Name: SOURCE
Inherited
- Field Name: OWNER
Inherited
- Field Name: GPS
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: CLOCKWISETOCLOSE
Inherited
- Field Name: CURRENTLYOPEN
Inherited
- Field Name: MOTORIZED
Inherited
- Field Name: NORMALLYOPEN
Inherited
- Field Name: VALVEPURPOSE
Inherited
- Field Name: OPERATIONALSTATUS
Inherited
- Field Name: LASTACTIVITY
Inherited
- Field Name: TRAFFICLANE
Inherited
- Field Name: STREETPREFIX
Inherited
- Field Name: STREETSUFFIX
Inherited
Templates:
Name: Altitude
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- ENABLED: 1
- SUBTYPE: 5
- ASBUILT: 1
- STATUS: Active
- SOURCE: AsBuilt
- OWNER: Public
- ANGLE: 0
- GPS: 1
- DIAMETER: 6
- CLOCKWISETOCLOSE: 1
- CURRENTLYOPEN: 1
- MOTORIZED: 0
- NORMALLYOPEN: 1
- PERCENTOPEN: 100
ID: 6
Name: AngleMeterStop
Domains:
- Field Name: ENABLED
Inherited
- Field Name: ASBUILT
Inherited
- Field Name: STATUS
Inherited
- Field Name: SOURCE
Inherited
- Field Name: OWNER
Inherited
- Field Name: GPS
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: CLOCKWISETOCLOSE
Inherited
- Field Name: CURRENTLYOPEN
Inherited
- Field Name: MOTORIZED
Inherited
- Field Name: NORMALLYOPEN
Inherited
- Field Name: VALVEPURPOSE
Inherited
- Field Name: OPERATIONALSTATUS
Inherited
- Field Name: LASTACTIVITY
Inherited
- Field Name: TRAFFICLANE
Inherited
- Field Name: STREETPREFIX
Inherited
- Field Name: STREETSUFFIX
Inherited
Templates:
Name: AngleMeterStop
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- ENABLED: 1
- SUBTYPE: 6
- ASBUILT: 1
- STATUS: Active
- SOURCE: AsBuilt
- OWNER: Public
- ANGLE: 0
- GPS: 1
- DIAMETER: 6
- CLOCKWISETOCLOSE: 1
- CURRENTLYOPEN: 1
- MOTORIZED: 0
- NORMALLYOPEN: 1
- PERCENTOPEN: 100
ID: 2
Name: Butterfly
Domains:
- Field Name: ENABLED
Inherited
- Field Name: ASBUILT
Inherited
- Field Name: STATUS
Inherited
- Field Name: SOURCE
Inherited
- Field Name: OWNER
Inherited
- Field Name: GPS
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: CLOCKWISETOCLOSE
Inherited
- Field Name: CURRENTLYOPEN
Inherited
- Field Name: MOTORIZED
Inherited
- Field Name: NORMALLYOPEN
Inherited
- Field Name: VALVEPURPOSE
Inherited
- Field Name: OPERATIONALSTATUS
Inherited
- Field Name: LASTACTIVITY
Inherited
- Field Name: TRAFFICLANE
Inherited
- Field Name: STREETPREFIX
Inherited
- Field Name: STREETSUFFIX
Inherited
Templates:
Name: Butterfly
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- ENABLED: 1
- SUBTYPE: 2
- ASBUILT: 1
- STATUS: Active
- SOURCE: AsBuilt
- OWNER: Public
- ANGLE: 0
- GPS: 1
- DIAMETER: 6
- CLOCKWISETOCLOSE: 1
- CURRENTLYOPEN: 1
- MOTORIZED: 0
- NORMALLYOPEN: 1
- PERCENTOPEN: 100
ID: 7
Name: Clay
Domains:
- Field Name: ENABLED
Inherited
- Field Name: ASBUILT
Inherited
- Field Name: STATUS
Inherited
- Field Name: SOURCE
Inherited
- Field Name: OWNER
Inherited
- Field Name: GPS
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: CLOCKWISETOCLOSE
Inherited
- Field Name: CURRENTLYOPEN
Inherited
- Field Name: MOTORIZED
Inherited
- Field Name: NORMALLYOPEN
Inherited
- Field Name: VALVEPURPOSE
Inherited
- Field Name: OPERATIONALSTATUS
Inherited
- Field Name: LASTACTIVITY
Inherited
- Field Name: TRAFFICLANE
Inherited
- Field Name: STREETPREFIX
Inherited
- Field Name: STREETSUFFIX
Inherited
Templates:
Name: Clay
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- ENABLED: 1
- SUBTYPE: 7
- ASBUILT: 1
- STATUS: Active
- SOURCE: AsBuilt
- OWNER: Public
- ANGLE: 0
- GPS: 1
- DIAMETER: 6
- CLOCKWISETOCLOSE: 1
- CURRENTLYOPEN: 1
- MOTORIZED: 0
- NORMALLYOPEN: 1
- PERCENTOPEN: 100
ID: 1
Name: Gate
Domains:
- Field Name: ENABLED
Inherited
- Field Name: ASBUILT
Inherited
- Field Name: STATUS
Inherited
- Field Name: SOURCE
Inherited
- Field Name: OWNER
Inherited
- Field Name: GPS
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: CLOCKWISETOCLOSE
Inherited
- Field Name: CURRENTLYOPEN
Inherited
- Field Name: MOTORIZED
Inherited
- Field Name: NORMALLYOPEN
Inherited
- Field Name: VALVEPURPOSE
Inherited
- Field Name: OPERATIONALSTATUS
Inherited
- Field Name: LASTACTIVITY
Inherited
- Field Name: TRAFFICLANE
Inherited
- Field Name: STREETPREFIX
Inherited
- Field Name: STREETSUFFIX
Inherited
Templates:
Name: Gate
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- ENABLED: 1
- SUBTYPE: 1
- ASBUILT: 1
- STATUS: Active
- SOURCE: AsBuilt
- OWNER: Public
- ANGLE: 0
- GPS: 0
- DIAMETER: 6
- CLOCKWISETOCLOSE: 1
- CURRENTLYOPEN: 1
- MOTORIZED: 0
- NORMALLYOPEN: 1
- PERCENTOPEN: 100
ID: 4
Name: SwingCheck
Domains:
- Field Name: ENABLED
Inherited
- Field Name: ASBUILT
Inherited
- Field Name: STATUS
Inherited
- Field Name: SOURCE
Inherited
- Field Name: OWNER
Inherited
- Field Name: GPS
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: CLOCKWISETOCLOSE
Inherited
- Field Name: CURRENTLYOPEN
Inherited
- Field Name: MOTORIZED
Inherited
- Field Name: NORMALLYOPEN
Inherited
- Field Name: VALVEPURPOSE
Inherited
- Field Name: OPERATIONALSTATUS
Inherited
- Field Name: LASTACTIVITY
Inherited
- Field Name: TRAFFICLANE
Inherited
- Field Name: STREETPREFIX
Inherited
- Field Name: STREETSUFFIX
Inherited
Templates:
Name: SwingCheck
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- ENABLED: 1
- SUBTYPE: 4
- ASBUILT: 1
- STATUS: Active
- SOURCE: AsBuilt
- OWNER: Public
- ANGLE: 0
- GPS: 1
- DIAMETER: 6
- CLOCKWISETOCLOSE: 1
- CURRENTLYOPEN: 1
- MOTORIZED: 0
- NORMALLYOPEN: 1
- PERCENTOPEN: 100
ID: 3
Name: Tapping
Domains:
- Field Name: ENABLED
Inherited
- Field Name: ASBUILT
Inherited
- Field Name: STATUS
Inherited
- Field Name: SOURCE
Inherited
- Field Name: OWNER
Inherited
- Field Name: GPS
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: CLOCKWISETOCLOSE
Inherited
- Field Name: CURRENTLYOPEN
Inherited
- Field Name: MOTORIZED
Inherited
- Field Name: NORMALLYOPEN
Inherited
- Field Name: VALVEPURPOSE
Inherited
- Field Name: OPERATIONALSTATUS
Inherited
- Field Name: LASTACTIVITY
Inherited
- Field Name: TRAFFICLANE
Inherited
- Field Name: STREETPREFIX
Inherited
- Field Name: STREETSUFFIX
Inherited
Templates:
Name: Tapping
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- ENABLED: 1
- SUBTYPE: 3
- ASBUILT: 1
- STATUS: Active
- SOURCE: AsBuilt
- OWNER: Public
- ANGLE: 0
- GPS: 1
- DIAMETER: 6
- CLOCKWISETOCLOSE: 1
- CURRENTLYOPEN: 1
- MOTORIZED: 0
- NORMALLYOPEN: 1
- PERCENTOPEN: 100
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 2/8/2026 3:05:53 AM
Schema Last Edit Date: 12/18/2025 9:28:30 PM
Data Last Edit Date: 2/8/2026 3:05:53 AM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat