View In:   ArcGIS Online Map Viewer

Name: Water System Valves

Display Field: ANCILLARYROLE

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>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. Also a Cityworks map layer in Cityworks_Water and in Cityworks_Utility. </SPAN><SPAN><SPAN>Managed by the Water/ESD GIS Administrator.</SPAN></SPAN></P><P><SPAN /></P></DIV></DIV></DIV>

Copyright Text: City of Grand Rapids

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

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: SUBTYPE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [130, 130, 130, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Default Label:
UniqueValueInfos:
• Value: 0
  Label: WValve
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [239, 252, 197, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: 1
  Label: WValveChamber
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [246, 179, 252, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: 2
  Label: WServiceValveChamber
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [179, 227, 252, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: 3
  Label: WServiceValve
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [252, 200, 199, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: 4
  Label: WHydrantValveChamber
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [179, 252, 228, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: 5
  Label: WHydrantValve
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [239, 215, 252, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
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: SUBTYPE

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] )
• OVERRIDE ( type: esriFieldTypeBlob, alias: Override, editable: true, nullable: true, defaultValue: null, modelName: Override )
• 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: 0
Name: WValve
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: WValve
  Description:
  Prototype:
  SUBTYPE: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 1
Name: WValveChamber
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: WValveChamber
  Description:
  Prototype:
  SUBTYPE: 1
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 2
Name: WServiceValveChamber
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: WServiceValveChamber
  Description:
  Prototype:
  SUBTYPE: 2
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 3
Name: WServiceValve
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: WServiceValve
  Description:
  Prototype:
  SUBTYPE: 3
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 4
Name: WHydrantValveChamber
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: WHydrantValveChamber
  Description:
  Prototype:
  SUBTYPE: 4
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 5
Name: WHydrantValve
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: WHydrantValve
  Description:
  Prototype:
  SUBTYPE: 5
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• ArcGIS.GDBO.WATTACHMENT (2) -- 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