View In:   ArcGIS Online Map Viewer

Name: Water Control 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 control valves for the entire water service area. Control valves constitute Backflow Preventers, Air Release Valves, Blow Off Valves, &amp; Control 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.2623095162213666E7
YMin: 495931.56141356693
XMax: 1.2827261740515815E7
YMax: 560058.3472652935
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: WControlValve_Point
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [252, 204, 235, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: 1
  Label: WBlowOffValve
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [179, 252, 179, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: 2
  Label: WAirReleaseValve
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [179, 246, 252, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: 3
  Label: WBackFlowPreventor
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [252, 236, 189, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: 4
  Label: WInterconnect
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [179, 206, 252, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: 5
  Label: WAccessManhole
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [243, 179, 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 )
• LOCATION ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LOCATION )
• 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 )
• 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... )
• VALVETYPE ( type: esriFieldTypeString, alias: Valve Type, editable: true, nullable: true, length: 3, defaultValue: null, modelName: VALVETYPE )
• DISCHARGEPRESSURE ( type: esriFieldTypeInteger, alias: Discharge Pressure, editable: true, nullable: true, defaultValue: null, modelName: DISCHARGEPRESSURE , Range: [40, 100] )
• MAXFLOWRATE ( type: esriFieldTypeString, alias: Maximum Flow Rate, editable: true, nullable: true, length: 3, defaultValue: null, modelName: MAXFLOWRATE )
• OPERATIONMODE ( type: esriFieldTypeString, alias: Operation Mode, editable: true, nullable: true, length: 3, defaultValue: null, modelName: OPERATIONMODE , Coded Values: [AUT: Automatic] , [MAN: Manual] )
• 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 )
• PLANNUMBER ( type: esriFieldTypeString, alias: Plan Number, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PLANNUMBER )
• 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: [3: Control 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 )
• DETAILTYPE ( type: esriFieldTypeString, alias: Detail Type, editable: true, nullable: true, length: 10, defaultValue: null, modelName: DETAILTYPE )
• ASSUMEDINSTALLDATE ( type: esriFieldTypeDate, alias: Assumed Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ASSUMEDINSTALLDATE )
• TransmissionConnection ( type: esriFieldTypeString, alias: Transmission Connection, editable: true, nullable: true, length: 1, defaultValue: null, modelName: TransmissionConnection , Coded Values: [Y: Yes] , [N: No] )
• UN_Notes ( type: esriFieldTypeString, alias: UN_Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: UN_Notes )

Types:

ID: 0
Name: WControlValve_Point
Domains:
• ENABLED:
  Inherited
• ADMINISTRATIVEAREA:
  Inherited
• OPERATIONALAREA:
  Inherited
• PRESSURESYSTEM:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• DIAMETER:
  Coded Values: [2: 2 in.] , [3: 3 in.] , [4: 4 in.] , ...24 more...
• CURRENTPOSITION:
  Inherited
• VALVETYPE:
  Coded Values: [ALT: Altitude] , [FLW: Flow Control] , [PRV: Pressure Regulating Valve]
• DISCHARGEPRESSURE:
  Inherited
• OPERATIONMODE:
  Inherited
• RULEID:
  Inherited
• TransmissionConnection:
  Inherited
Templates:
• Name: WControlValve_Point
  Description:
  Prototype:
  SUBTYPE: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 1
Name: WBlowOffValve
Domains:
• ENABLED:
  Inherited
• ADMINISTRATIVEAREA:
  Inherited
• OPERATIONALAREA:
  Inherited
• PRESSURESYSTEM:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• DIAMETER:
  Coded Values: [1: 1 in.] , [2: 2 in.] , [3: 3 in.] , ...12 more...
• CURRENTPOSITION:
  Inherited
• VALVETYPE:
  Coded Values: [CRB: Curb] , [GAT: Gate] , [STP: Stop]
• DISCHARGEPRESSURE:
  Inherited
• OPERATIONMODE:
  Inherited
• RULEID:
  Inherited
• TransmissionConnection:
  Inherited
Templates:
• Name: WBlowOffValve
  Description:
  Prototype:
  SUBTYPE: 1
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 2
Name: WAirReleaseValve
Domains:
• ENABLED:
  Inherited
• ADMINISTRATIVEAREA:
  Inherited
• OPERATIONALAREA:
  Inherited
• PRESSURESYSTEM:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• DIAMETER:
  Coded Values: [2: 2 in.] , [3: 3 in.] , [4: 4 in.] , ...24 more...
• CURRENTPOSITION:
  Inherited
• VALVETYPE:
  Coded Values: [AUT: Automatic] , [MAN: Manual] , [VAC: Vacuum]
• DISCHARGEPRESSURE:
  Inherited
• OPERATIONMODE:
  Inherited
• RULEID:
  Inherited
• TransmissionConnection:
  Inherited
Templates:
• Name: WAirReleaseValve
  Description:
  Prototype:
  SUBTYPE: 2
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 3
Name: WBackFlowPreventor
Domains:
• ENABLED:
  Inherited
• ADMINISTRATIVEAREA:
  Inherited
• OPERATIONALAREA:
  Inherited
• PRESSURESYSTEM:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• DIAMETER:
  Coded Values: [2: 2 in.] , [3: 3 in.] , [4: 4 in.] , ...24 more...
• CURRENTPOSITION:
  Inherited
• VALVETYPE:
  Coded Values: [ALT: Altitude] , [FLW: Flow Control] , [PRV: Pressure Regulating Valve]
• DISCHARGEPRESSURE:
  Inherited
• OPERATIONMODE:
  Inherited
• RULEID:
  Inherited
• TransmissionConnection:
  Inherited
Templates:
• Name: WBackFlowPreventor
  Description:
  Prototype:
  SUBTYPE: 3
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 4
Name: WInterconnect
Domains:
• ENABLED:
  Inherited
• ADMINISTRATIVEAREA:
  Inherited
• OPERATIONALAREA:
  Inherited
• PRESSURESYSTEM:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• DIAMETER:
  Coded Values: [2: 2 in.] , [3: 3 in.] , [4: 4 in.] , ...24 more...
• CURRENTPOSITION:
  Inherited
• DISCHARGEPRESSURE:
  Inherited
• OPERATIONMODE:
  Inherited
• RULEID:
  Inherited
• TransmissionConnection:
  Inherited
Templates:
• Name: WInterconnect
  Description:
  Prototype:
  SUBTYPE: 4
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 5
Name: WAccessManhole
Domains:
• ENABLED:
  Inherited
• ADMINISTRATIVEAREA:
  Inherited
• OPERATIONALAREA:
  Inherited
• PRESSURESYSTEM:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• DIAMETER:
  Coded Values: [2: 2 in.] , [3: 3 in.] , [4: 4 in.] , ...24 more...
• CURRENTPOSITION:
  Inherited
• DISCHARGEPRESSURE:
  Inherited
• OPERATIONMODE:
  Inherited
• RULEID:
  Inherited
• TransmissionConnection:
  Inherited
Templates:
• Name: WAccessManhole
  Description:
  Prototype:
  SUBTYPE: 5
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

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