View In:   ArcGIS Online Map Viewer

Name: Water System Valves

Display Field: ADMINISTRATIVEAREA

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This layer shows the City of Grand Rapids system valves for the entire water service area. System valves consist of in-line valves, hydrant valves, and service valves.

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 1500

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 1.262670160119302E7
YMin: 474474.44350557984
XMax: 1.2829952487910317E7
YMax: 560872.602370061
Spatial Reference: 2253  (2253)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: CHAMBERINDICATOR
Field 2: CURRENTPOSITION
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 1,
  Label: True,
  Description: N/A
  Symbol:
  
• Value: 1,OPTH
  Label: True, Throttled
  Description: N/A
  Symbol:
  
• Value: 0,CLOSE
  Label: Closed Valve
  Description: N/A
  Symbol:
  
• Value: 0,OPEN
  Label: Open Valve
  Description: N/A
  Symbol:
  
• Value: 0,OPIO
  Label: Open Valve
  Description: N/A
  Symbol:
  
• Value: 1,CLOSE
  Label: Closed Valve w/Chamber
  Description: N/A
  Symbol:
  
• Value: 1,CLIO
  Label: Closed Valve w/Chamber
  Description: N/A
  Symbol:
  
• Value: 1,OPEN
  Label: Open Valve w/ Chamber
  Description: N/A
  Symbol:
  
• Value: 1,OPIO
  Label: Open Valve w/ Chamber
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: CHAMBERINDICATOR

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: Object ID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ANCILLARYROLE ( type: esriFieldTypeSmallInteger, alias: Ancillary Role, editable: true, nullable: true, defaultValue: null, modelName: ANCILLARYROLE )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED , Coded Values: [0: False] , [1: True] )
• ADMINISTRATIVEAREA ( type: esriFieldTypeString, alias: Administrative Area, editable: true, nullable: true, length: 60, defaultValue: null, modelName: ADMINISTRATIVEAREA , Coded Values: [RET: Retail] , [WHO: Wholesale] , [OTHER: Other] )
• FACILITYID ( type: esriFieldTypeString, alias: Facility ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• OPERATIONALAREA ( type: esriFieldTypeString, alias: Operational Area, editable: true, nullable: true, length: 60, defaultValue: null, modelName: OPERATIONALAREA , Coded Values: [ALP: Alpine Township] , [CGR: City of Grand Rapids] , [KDP: Kent County DPW] , ...20 more... )
• PRESSURESYSTEM ( type: esriFieldTypeString, alias: Pressure System, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PRESSURESYSTEM , Coded Values: [HI: High Pressure Main] , [LOW: Low Pressure Main] , [MED: Medium Pressure Main] , ...1 more... )
• ROTATION ( type: esriFieldTypeDouble, alias: Rotation, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• LIFECYCLESTATUS ( type: esriFieldTypeString, alias: Life Cycle Status, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LIFECYCLESTATUS , Coded Values: [PRP: Proposed] , [AC: Active] , [AB: Abandoned] , ...5 more... )
• SUBTYPE ( type: esriFieldTypeInteger, alias: Subtype, editable: true, nullable: true, defaultValue: 0, modelName: SubType )
• WORKORDERID ( type: esriFieldTypeString, alias: Work Order ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WORKORDERID )
• DIAMETER ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER , Coded Values: [2: 2 in.] , [3: 3 in.] , [4: 4 in.] , ...26 more... )
• JOINTTYPE1 ( type: esriFieldTypeString, alias: Joint Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: JOINTTYPE1 , Coded Values: [BSP: Bell & Spigot] , [BSPS: Bell & Spigot-Sealed] , [BW: Butt-Welded] , ...23 more... )
• CURRENTPOSITION ( type: esriFieldTypeString, alias: Current Position, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CURRENTPOSITION , Coded Values: [OPEN: Open] , [OPIO: Open Inoperable] , [CLOSE: Closed] , ...3 more... )
• TURNSTOCLOSE ( type: esriFieldTypeInteger, alias: Turns to Close, editable: true, nullable: true, defaultValue: null, modelName: TURNSTOCLOSE )
• CLOCKWISETOCLOSE ( type: esriFieldTypeInteger, alias: Clockwise to Close, editable: true, nullable: true, defaultValue: null, modelName: CLOCKWISETOCLOSE , Coded Values: [0: False] , [1: True] )
• CURRENTLYOPEN ( type: esriFieldTypeInteger, alias: Currently Open, editable: true, nullable: true, defaultValue: null, modelName: CURRENTLYOPEN , Coded Values: [0: False] , [1: True] )
• NORMALLYOPEN ( type: esriFieldTypeInteger, alias: Normally Open, editable: true, nullable: true, defaultValue: null, modelName: NORMALLYOPEN , Coded Values: [0: False] , [1: True] )
• CHAMBERINDICATOR ( type: esriFieldTypeInteger, alias: Chamber Indicator, editable: true, nullable: true, defaultValue: null, modelName: CHAMBERINDICATOR , Coded Values: [0: False] , [1: True] )
• PLANNUMBER ( type: esriFieldTypeString, alias: Plan Number, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PLANNUMBER )
• VALVETYPE ( type: esriFieldTypeString, alias: Valve Type, editable: true, nullable: true, length: 3, defaultValue: null, modelName: VALVETYPE , Coded Values: [BAL: Ball] , [BUT: Butterfly] , [CHK: Check] , ...9 more... )
• DATE_CREATED ( type: esriFieldTypeDate, alias: Date Created, editable: false, nullable: true, length: 8, defaultValue: null, modelName: DATE_CREATED )
• DATE_MODIFIED ( type: esriFieldTypeDate, alias: Date Edited, editable: false, nullable: true, length: 8, defaultValue: null, modelName: DATE_MODIFIED )
• REV_ROTATION ( type: esriFieldTypeSmallInteger, alias: REV_ROTATION, editable: true, nullable: true, defaultValue: null, modelName: REV_ROTATION )
• RULEID ( type: esriFieldTypeInteger, alias: RuleID, editable: true, nullable: true, defaultValue: null, modelName: RuleID , Coded Values: [2: Open Valve] , [4: Closed Valve] )
• ROTATION_REVERSE ( type: esriFieldTypeDouble, alias: ROTATION_REVERSE, editable: true, nullable: true, defaultValue: null, modelName: ROTATION_REVERSE )
• DETAILNUMBER ( type: esriFieldTypeString, alias: Detail Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: DETAILNUMBER )
• CREATOR ( type: esriFieldTypeString, alias: Creator, editable: false, nullable: true, length: 25, defaultValue: null, modelName: CREATOR )
• EDITOR ( type: esriFieldTypeString, alias: Editor, editable: false, nullable: true, length: 25, defaultValue: null, modelName: EDITOR )
• ASSUMEDINSTALLDATE ( type: esriFieldTypeDate, alias: Assumed Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ASSUMEDINSTALLDATE )
• STREET ( type: esriFieldTypeString, alias: STREET, editable: true, nullable: true, length: 60, defaultValue: null, modelName: STREET )
• CROSS_STREET ( type: esriFieldTypeString, alias: CROSS_STREET, editable: true, nullable: true, length: 60, defaultValue: null, modelName: CROSS_STREET )
• LONGITUDE ( type: esriFieldTypeDouble, alias: LONGITUDE, editable: true, nullable: true, defaultValue: null, modelName: LONGITUDE )
• LATITUDE ( type: esriFieldTypeDouble, alias: LATITUDE, editable: true, nullable: true, defaultValue: null, modelName: LATITUDE )
• DISTRICT_NUMBER ( type: esriFieldTypeString, alias: Valve_District, editable: true, nullable: true, length: 6, defaultValue: null, modelName: DISTRICT_NUMBER )
• HIGH_TORQUE ( type: esriFieldTypeSmallInteger, alias: Torque, editable: true, nullable: true, defaultValue: null, modelName: HIGH_TORQUE )
• WACHS_TURNS ( type: esriFieldTypeDouble, alias: Full_Turns, editable: true, nullable: true, defaultValue: null, modelName: WACHS_TURNS )
• DATE_LAST_OPERATED ( type: esriFieldTypeDate, alias: Last_Operation, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE_LAST_OPERATED )
• LAST_OPERATOR_INITIALS ( type: esriFieldTypeString, alias: Last_Operator, editable: true, nullable: true, length: 6, defaultValue: null, modelName: LAST_OPERATOR_INITIALS )
• TRANSMISSIONVLV ( type: esriFieldTypeInteger, alias: Transmission Main Valve, editable: true, nullable: true, defaultValue: null, modelName: TRANSMISSIONVLV , Coded Values: [0: False] , [1: True] )
• PRESSUREDISTRICTVLV ( type: esriFieldTypeInteger, alias: Pressure District Valve, editable: true, nullable: true, defaultValue: null, modelName: PRESSUREDISTRICTVLV , Coded Values: [0: False] , [1: True] )
• UN_Notes ( type: esriFieldTypeString, alias: UN_Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: UN_Notes )

Types:

ID: 1
Name: True,
Domains:
• ENABLED:
  Inherited
• ADMINISTRATIVEAREA:
  Inherited
• OPERATIONALAREA:
  Inherited
• PRESSURESYSTEM:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• DIAMETER:
  Inherited
• JOINTTYPE1:
  Inherited
• CURRENTPOSITION:
  Inherited
• CLOCKWISETOCLOSE:
  Inherited
• CURRENTLYOPEN:
  Inherited
• NORMALLYOPEN:
  Inherited
• CHAMBERINDICATOR:
  Inherited
• VALVETYPE:
  Inherited
• RULEID:
  Inherited
• TRANSMISSIONVLV:
  Inherited
• PRESSUREDISTRICTVLV:
  Inherited
Templates:
• Name: True,
  Description:
  Prototype:
  CURRENTPOSITION: <Null>
  SUBTYPE: 0
  CHAMBERINDICATOR: 1
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: True, Throttled
  Description:
  Prototype:
  CURRENTPOSITION: OPTH
  SUBTYPE: 0
  CHAMBERINDICATOR: 1
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Closed Valve w/Chamber
  Description:
  Prototype:
  CURRENTPOSITION: CLOSE
  SUBTYPE: 0
  CHAMBERINDICATOR: 1
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Open Valve w/ Chamber
  Description:
  Prototype:
  CURRENTPOSITION: OPEN
  SUBTYPE: 0
  CHAMBERINDICATOR: 1
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: 1, CLIO
  Description:
  Prototype:
  PRESSUREDISTRICTVLV: null
  UN_Notes: null
  ANCILLARYROLE: null
  ENABLED: 1
  ADMINISTRATIVEAREA: null
  FACILITYID: null
  INSTALLDATE: null
  OPERATIONALAREA: null
  PRESSURESYSTEM: null
  ROTATION: null
  LIFECYCLESTATUS: null
  SUBTYPE: 0
  WORKORDERID: null
  DIAMETER: null
  JOINTTYPE1: null
  CURRENTPOSITION: CLIO
  TURNSTOCLOSE: null
  CLOCKWISETOCLOSE: null
  CURRENTLYOPEN: null
  NORMALLYOPEN: null
  CHAMBERINDICATOR: 1
  PLANNUMBER: null
  VALVETYPE: null
  TRANSMISSIONVLV: null
  LAST_OPERATOR_INITIALS: null
  REV_ROTATION: null
  RULEID: null
  ROTATION_REVERSE: null
  DETAILNUMBER: null
  DATE_LAST_OPERATED: null
  WACHS_TURNS: null
  ASSUMEDINSTALLDATE: null
  STREET: null
  CROSS_STREET: null
  LONGITUDE: null
  LATITUDE: null
  DISTRICT_NUMBER: null
  HIGH_TORQUE: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: 1, OPIO
  Description:
  Prototype:
  PRESSUREDISTRICTVLV: null
  UN_Notes: null
  ANCILLARYROLE: null
  ENABLED: 1
  ADMINISTRATIVEAREA: null
  FACILITYID: null
  INSTALLDATE: null
  OPERATIONALAREA: null
  PRESSURESYSTEM: null
  ROTATION: null
  LIFECYCLESTATUS: null
  SUBTYPE: 0
  WORKORDERID: null
  DIAMETER: null
  JOINTTYPE1: null
  CURRENTPOSITION: OPIO
  TURNSTOCLOSE: null
  CLOCKWISETOCLOSE: null
  CURRENTLYOPEN: null
  NORMALLYOPEN: null
  CHAMBERINDICATOR: 1
  PLANNUMBER: null
  VALVETYPE: null
  TRANSMISSIONVLV: null
  LAST_OPERATOR_INITIALS: null
  REV_ROTATION: null
  RULEID: null
  ROTATION_REVERSE: null
  DETAILNUMBER: null
  DATE_LAST_OPERATED: null
  WACHS_TURNS: null
  ASSUMEDINSTALLDATE: null
  STREET: null
  CROSS_STREET: null
  LONGITUDE: null
  LATITUDE: null
  DISTRICT_NUMBER: null
  HIGH_TORQUE: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 0
Name: Closed Valve
Domains:
• ENABLED:
  Inherited
• ADMINISTRATIVEAREA:
  Inherited
• OPERATIONALAREA:
  Inherited
• PRESSURESYSTEM:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• DIAMETER:
  Inherited
• JOINTTYPE1:
  Inherited
• CURRENTPOSITION:
  Inherited
• CLOCKWISETOCLOSE:
  Inherited
• CURRENTLYOPEN:
  Inherited
• NORMALLYOPEN:
  Inherited
• CHAMBERINDICATOR:
  Inherited
• VALVETYPE:
  Inherited
• RULEID:
  Inherited
• TRANSMISSIONVLV:
  Inherited
• PRESSUREDISTRICTVLV:
  Inherited
Templates:
• Name: Closed Valve
  Description:
  Prototype:
  CURRENTPOSITION: CLOSE
  SUBTYPE: 0
  CHAMBERINDICATOR: 0
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Open Valve
  Description:
  Prototype:
  CURRENTPOSITION: OPEN
  SUBTYPE: 0
  CHAMBERINDICATOR: 0
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: 0, OPIO
  Description:
  Prototype:
  PRESSUREDISTRICTVLV: null
  UN_Notes: null
  ANCILLARYROLE: null
  ENABLED: 1
  ADMINISTRATIVEAREA: null
  FACILITYID: null
  INSTALLDATE: null
  OPERATIONALAREA: null
  PRESSURESYSTEM: null
  ROTATION: null
  LIFECYCLESTATUS: null
  SUBTYPE: 0
  WORKORDERID: null
  DIAMETER: null
  JOINTTYPE1: null
  CURRENTPOSITION: OPIO
  TURNSTOCLOSE: null
  CLOCKWISETOCLOSE: null
  CURRENTLYOPEN: null
  NORMALLYOPEN: null
  CHAMBERINDICATOR: 0
  PLANNUMBER: null
  VALVETYPE: null
  TRANSMISSIONVLV: null
  LAST_OPERATOR_INITIALS: null
  REV_ROTATION: null
  RULEID: null
  ROTATION_REVERSE: null
  DETAILNUMBER: null
  DATE_LAST_OPERATED: null
  WACHS_TURNS: null
  ASSUMEDINSTALLDATE: null
  STREET: null
  CROSS_STREET: null
  LONGITUDE: null
  LATITUDE: null
  DISTRICT_NUMBER: null
  HIGH_TORQUE: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• ArcGIS.GDBO.WATTACHMENT (0) -- Related To: WAttachment (55)

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: DATE_CREATED
• Creator Field: CREATOR
• Edit Date Field: DATE_MODIFIED
• Editor Field: EDITOR

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata