Name: wControlValve

Display Field: NAMENUMBER

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: 483720.378325593
YMin: 5449767.81600418
XMax: 498310.0039662
YMax: 5462265.80424486
Spatial Reference: 26910 (26910)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[26,127,55,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: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• FACILITYID (type: esriFieldTypeString, alias: Facility Identifier, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• INSTALLDATE (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LOCDESC (type: esriFieldTypeString, alias: Location description, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true, Coded Values: [Acrss: Across], [AtLn: Lane - At], [BLKE: BLKE], ... 62 more ...)
• ROTATION (type: esriFieldTypeDouble, alias: Rotation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DIAMETER (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [13: 13], [4: 4 mm], [15: 15 mm], ... 37 more ...)
• VALVETYPE (type: esriFieldTypeString, alias: Valve Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Altitude: Altitude], [Blowoff: Blowoff], [Combination: Combination], ... 18 more ...)
• ENABLED (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• ACTIVEFLAG (type: esriFieldTypeSmallInteger, alias: Active Flag, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• MAINTBY (type: esriFieldTypeSmallInteger, alias: Managed By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Our Agency], [-1: Private], [-2: Other], ... 52 more ...)
• TBFID (type: esriFieldTypeInteger, alias: FID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ORACLEID (type: esriFieldTypeString, alias: Oracle ID, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• REMARKS (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• SERVICESTATUS (type: esriFieldTypeString, alias: Service Status, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [OSP_VOID: OSP_VOID], [OST_INSTAL: OST_INSTAL], [OST_REMOVD: OST_REMOVD], ... 8 more ...)
• OWNEDBY (type: esriFieldTypeString, alias: Owner, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [BCH: B.C. Hydro], [BCHSG: B.C. Housing Commission], [COVAV: COV Asset Valuation in Hansen], ... 25 more ...)
• ANGULARDES (type: esriFieldTypeSmallInteger, alias: Angular Design, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CADASTRALI (type: esriFieldTypeString, alias: Cadastral Info, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CERTIFICAT (type: esriFieldTypeString, alias: Certificate, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• CONTINUOUS (type: esriFieldTypeSmallInteger, alias: Continuous Adjustment, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ADDRKEY (type: esriFieldTypeInteger, alias: ADDRKEY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CLOSEDIND (type: esriFieldTypeString, alias: Closed Indicator, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• COMPKEY (type: esriFieldTypeInteger, alias: COMPKEY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COMPTYPE (type: esriFieldTypeInteger, alias: COMPTYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LOCKIND (type: esriFieldTypeString, alias: Locked, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• REGULATORA (type: esriFieldTypeString, alias: Regulator Size A, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [13: 13], [4: 4 mm], [15: 15 mm], ... 37 more ...)
• REGULATORB (type: esriFieldTypeString, alias: Regulator Size B, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [13: 13], [4: 4 mm], [15: 15 mm], ... 37 more ...)
• REGULATORC (type: esriFieldTypeString, alias: Regulator Size C, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [13: 13], [4: 4 mm], [15: 15 mm], ... 37 more ...)
• REMOTECONA (type: esriFieldTypeString, alias: Remote Control A, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Manual: Manual], [Remote: Remote Control])
• REMOTECONB (type: esriFieldTypeString, alias: Remote Control B, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Manual: Manual], [Remote: Remote Control])
• REMOTECONC (type: esriFieldTypeString, alias: Remote Control C, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Manual: Manual], [Remote: Remote Control])
• SUBAREA (type: esriFieldTypeString, alias: Subarea, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• VALVEKIND (type: esriFieldTypeString, alias: Valve Kind, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [BFLY: BFLY], [Cone: Cone], [Butterfly: Butterfly], ... 4 more ...)
• VALVESTATA (type: esriFieldTypeString, alias: Valve Status A, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [NotWorking: Not Working], [Standby: Stand-by], [StndbyPeak: Stand-by Peak Hour], ... 2 more ...)
• VALVESTATB (type: esriFieldTypeString, alias: Valve Status B, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [NotWorking: Not Working], [Standby: Stand-by], [StndbyPeak: Stand-by Peak Hour], ... 2 more ...)
• VALVESTATC (type: esriFieldTypeString, alias: Valve Status C, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [NotWorking: Not Working], [Standby: Stand-by], [StndbyPeak: Stand-by Peak Hour], ... 2 more ...)
• WATERSUBSY (type: esriFieldTypeString, alias: Water Subsystem, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [DSTR: Distribution], [DFPS: Dedicated Fire Protection Sys], [TRNS: Transmission])
• AIRVALVEID (type: esriFieldTypeString, alias: Legacy Air Valve ID, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• BLOWOFFID (type: esriFieldTypeString, alias: Legacy Blowoff ID, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CHAMBERID (type: esriFieldTypeString, alias: Legacy Chamber ID, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CTLVALVEID (type: esriFieldTypeString, alias: Legacy Control Valve ID, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• OPERATION (type: esriFieldTypeString, alias: Operation, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• RESTRAINTT (type: esriFieldTypeString, alias: Restraint Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [R: Rodded to a Deadman], [TB: Thrust Block], [WA: Wedge Action (uniflange/mega lug)])
• TURNS (type: esriFieldTypeString, alias: Turns, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• UNITDESC (type: esriFieldTypeString, alias: Unit Description, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
• XOFFSETDIR (type: esriFieldTypeString, alias: X Offset Direction, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• XOFFSETFRO (type: esriFieldTypeDouble, alias: X Offset From Property Line, SQL Type: sqlTypeOther, nullable: true, editable: true)
• YOFFSETDIR (type: esriFieldTypeString, alias: Y Offset Direction, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• YOFFSETFRO (type: esriFieldTypeDouble, alias: Y Offset From Property Line, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DATATRANSM (type: esriFieldTypeSmallInteger, alias: Data Transmission, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DATEACQUIR (type: esriFieldTypeDate, alias: Date Acquired, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DATECREATI (type: esriFieldTypeDate, alias: Date Creation, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DATESTARTU (type: esriFieldTypeDate, alias: Date Startup, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CONCESSION (type: esriFieldTypeString, alias: Concessionaire, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [BCH: B.C. Hydro], [BCHSG: B.C. Housing Commission], [COVAV: COV Asset Valuation in Hansen], ... 25 more ...)
• INSTALLER (type: esriFieldTypeString, alias: Installer, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [BCH: B.C. Hydro], [BCHSG: B.C. Housing Commission], [COVAV: COV Asset Valuation in Hansen], ... 25 more ...)
• MANUFACTUR (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [ACE: ACE], [ACIPCO: ACIPCO], [AVK: AVK], ... 56 more ...)
• OPERATOR (type: esriFieldTypeString, alias: Operator, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [BCH: B.C. Hydro], [BCHSG: B.C. Housing Commission], [COVAV: COV Asset Valuation in Hansen], ... 25 more ...)
• GROUNDELEV (type: esriFieldTypeDouble, alias: Ground Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HOUSE (type: esriFieldTypeString, alias: House, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• HOUSESUPPL (type: esriFieldTypeString, alias: House Supplement, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ACCURACY (type: esriFieldTypeString, alias: Accuracy, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [dig: digitized], [unk: unknown], [tbd: to be determined], ... 8 more ...)
• CLOSEDIREC (type: esriFieldTypeString, alias: Close Direction, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Right: Right], [Left: Left])
• COATINGINS (type: esriFieldTypeString, alias: Coating Inside, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [CTAR: Coal Tar], [Epoxy: Epoxy], [CL: Cement Lined], ... 10 more ...)
• COATINGOUT (type: esriFieldTypeString, alias: Coating Outside, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [CTAR: Coal Tar], [Epoxy: Epoxy], [CL: Cement Lined], ... 10 more ...)
• CONDITION (type: esriFieldTypeString, alias: Condition, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [lp: leak-proof], [u: unknown], [l: leaking], ... 3 more ...)
• CONNECTION (type: esriFieldTypeString, alias: Connection Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Domestic: Domestic Service], [Dummy Rcrd: Dummy Record], [Fire/Dmstc: Fire / Domestic], ... 1 more ...)
• FOUNDATION (type: esriFieldTypeString, alias: Foundation Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [bs: concrete sand], [so: soil], [gs: gravel sand], ... 1 more ...)
• FUNCTION_ (type: esriFieldTypeString, alias: Function, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Hydrant: Hydrant], [Air: Air Valve], [Large: Large Valve], ... 4 more ...)
• LAYINGTYPE (type: esriFieldTypeString, alias: Laying Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [u: unknown], [unc: uncovered], [o: other], ... 4 more ...)
• MARKERTYPE (type: esriFieldTypeString, alias: Marker Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [u: unknown], [mt: magnetic tape], [t: tape], ... 2 more ...)
• MATERIAL (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [HDPE: High Density Polyethylene], [PE: Polyethylene], [ERDIP: Earthquake Resistant Ductile Iron], ... 13 more ...)
• OWNERSHIPT (type: esriFieldTypeString, alias: Ownership Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [u: unknown], [o: other], [wa: water authority], ... 2 more ...)
• TYPE (type: esriFieldTypeString, alias: Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [BFLY: BFLY], [Cone: Cone], [Butterfly: Butterfly], ... 4 more ...)
• VALVEACTUA (type: esriFieldTypeString, alias: Valve Actuator, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [hc: hand control], [u: unknown], [ed: electric drive], ... 3 more ...)
• VALVESTATU (type: esriFieldTypeString, alias: Valve Status, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [NotWorking: Not Working], [Standby: Stand-by], [StndbyPeak: Stand-by Peak Hour], ... 2 more ...)
• LOCATION (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LOCKABLE (type: esriFieldTypeString, alias: Lockable, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown], ... 1 more ...)
• MODELNUMBE (type: esriFieldTypeString, alias: Model Number, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• NAMENUMBER (type: esriFieldTypeString, alias: Name Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PRESSUREMA (type: esriFieldTypeDouble, alias: Pressure Max, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PRESSUREOP (type: esriFieldTypeDouble, alias: Pressure Operating, SQL Type: sqlTypeOther, nullable: true, editable: true)
• REMOTECONT (type: esriFieldTypeSmallInteger, alias: Remote Controlled, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SERIALNUMB (type: esriFieldTypeString, alias: Serial Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USERFLAG (type: esriFieldTypeString, alias: User Flag, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• VALUE (type: esriFieldTypeString, alias: Value, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• VALVELENGT (type: esriFieldTypeDouble, alias: Valve Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FIDPRESSUR (type: esriFieldTypeString, alias: Pressure Zone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [407: 407], [440: 440], [442: 442], ... 6 more ...)
• WATERVALVE (type: esriFieldTypeInteger, alias: Water Valve Key, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ORIENTATIO (type: esriFieldTypeDouble, alias: Orientation, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: wControlValve
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• ENABLED: 1
• ACTIVEFLAG: 1
• MAINTBY: 1

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/13/2026 9:37:29 AM

Schema Last Edit Date: 8/13/2026 9:31:09 AM

Data Last Edit Date: 8/13/2026 9:37:29 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat