View In:   ArcGIS.com Map

Name: Control Valves

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Control valves: check, air release, pressure reducing, gear reduction.</SPAN></P><P><SPAN>System valves: butterfly, gate, double gate, tapping gate, RW gate, tapping RW gate, ball valve.</SPAN></P><P><SPAN>VOB: valve on branch. Related to fire hydrants, the valves on the hydrant leads.</SPAN></P></DIV></DIV></DIV>

Copyright Text: Originally created by Woolpert Inc. in 1997. Edited by Battle Creek DPW Records Division.

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 20000

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: -9497843.875736495
YMin: 5197686.90971143
XMax: -9469960.830163538
YMax: 5216642.092099133
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: VLV_STYLE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Air Release
  Label: Air Release
  Description: N/A
  Symbol:
  
• Value: Check
  Label: Bypass
  Description: N/A
  Symbol:
  
• Value: Check
  Label: Bypass
  Description: N/A
  Symbol:
  
• Value: Presssure Reducing
  Label: Presssure Reducing
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: [VALVE_ID]
Use Coded Values: true
Symbol:
Color: [232, 190, 255, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 2000.0
Max. Scale: 0.0

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: VLV_STYLE

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• VALVE_ID ( type: esriFieldTypeString, alias: VALVE_ID, editable: true, nullable: true, length: 12, defaultValue: null, modelName: VALVE_ID )
• SUB_TYPE ( type: esriFieldTypeInteger, alias: SUB_TYPE, editable: true, nullable: true, defaultValue: 0, modelName: SUB_TYPE )
• VLV_STYLE ( type: esriFieldTypeString, alias: VALVE STYLE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: VLV_STYLE , Coded Values: [Air Release: Air Release] , [Check: Check] , [Presssure Reducing: Presssure Reducing] , ...1 more... )
• DIAMETER ( type: esriFieldTypeDouble, alias: DIAMETER, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER , Coded Values: [2: 2 inch] , [4: 4 inch] , [6: 6 inch] , ...13 more... )
• OVERSIZE ( type: esriFieldTypeString, alias: OVERSIZE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OVERSIZE , Coded Values: [N: No] , [Y: Yes] , [N/A: N/A] )
• MANUFACTURER ( type: esriFieldTypeString, alias: MANUFACTURER, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MANUFACTURER , Coded Values: [American Flow Control: American Flow Control] , [Bibby: Bibby] , [Clow: Clow] , ...9 more... )
• TURNS ( type: esriFieldTypeDouble, alias: TURNS, editable: true, nullable: true, defaultValue: null, modelName: TURNS , Range: [0, 200] )
• RH__LH ( type: esriFieldTypeString, alias: Valve Open Direction, editable: true, nullable: true, length: 2, defaultValue: null, modelName: RH__LH , Coded Values: [RH: Right Handed Valve] , [LH: Left Handed Valve] )
• DEPTH_TO_N ( type: esriFieldTypeDouble, alias: DEPTH TO NUT, editable: true, nullable: true, defaultValue: null, modelName: DEPTH_TO_N , Range: [0, 8] )
• OPERATION ( type: esriFieldTypeString, alias: OPERATION, editable: true, nullable: true, length: 6, defaultValue: Open, modelName: OPERATION , Coded Values: [Open: Open] , [Closed: Closed] )
• CAST_DATE ( type: esriFieldTypeSmallInteger, alias: CAST_DATE, editable: true, nullable: true, defaultValue: null, modelName: CAST_DATE )
• INSTALLMTH ( type: esriFieldTypeSmallInteger, alias: MONTH INSTALLED, editable: true, nullable: true, defaultValue: null, modelName: INSTALLMTH , Coded Values: [1: January] , [2: February] , [3: March] , ...9 more... )
• INSTALL_YR ( type: esriFieldTypeSmallInteger, alias: YEAR INSTALLED, editable: true, nullable: true, defaultValue: null, modelName: INSTALL_YR , Range: [1940, 2030] )
• MUNICIPALITY ( type: esriFieldTypeString, alias: MUNICIPALITY, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MUNICIPALITY , Coded Values: [Bedford Township: Bedford Township] , [City of Battle Creek: City of Battle Creek] , [City of Springfield: City of Springfield] , ...7 more... )
• OWNER ( type: esriFieldTypeString, alias: OWNER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OWNER , Coded Values: [Brownstone Apartments: Brownstone Apartments] , [City of Springfield: City of Springfield] , [Emmett Township: Emmett Township] , ...5 more... )
• CONTRACTOR ( type: esriFieldTypeString, alias: CONTRACTOR, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONTRACTOR , Coded Values: [City of Battle Creek: City of Battle Creek] , [Crest Construction: Crest Construction] , [Hoffman Brothers: Hoffman Brothers] , ...10 more... )
• PUBLIC_PVT ( type: esriFieldTypeString, alias: PUBLIC or PRIVATE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PUBLIC_PVT , Coded Values: [Public: Public] , [Private: Private] , [Unknown: Unknown] )
• ELEVATION ( type: esriFieldTypeDouble, alias: ELEVATION, editable: true, nullable: true, defaultValue: null, modelName: ELEVATION )
• VBorMH ( type: esriFieldTypeSmallInteger, alias: VB or MH, editable: true, nullable: true, defaultValue: null, modelName: VBorMH , Coded Values: [1: VB] , [2: MH] , [3: UNKN] )
• GPS_Date ( type: esriFieldTypeDate, alias: GPS_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GPS_Date )
• VERIFIED ( type: esriFieldTypeString, alias: VERIFIED, editable: true, nullable: true, length: 10, defaultValue: null, modelName: VERIFIED , Coded Values: [N: No] , [Y: Yes] , [N/A: N/A] )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 100, defaultValue: null, modelName: COMMENTS )
• HYPERLINK ( type: esriFieldTypeString, alias: HYPERLINK, editable: true, nullable: true, length: 110, defaultValue: null, modelName: HYPERLINK )
• HIGH_LOW ( type: esriFieldTypeString, alias: HIGH_LOW, editable: true, nullable: true, length: 1, defaultValue: N, modelName: HIGH_LOW , Coded Values: [N: No] , [Y: Yes] , [N/A: N/A] )
• LAST_OPERATED ( type: esriFieldTypeString, alias: LAST_EXERCISED, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LAST_OPERATED )
• OPERATED_BY ( type: esriFieldTypeString, alias: LAST_OPERATED_BY, editable: true, nullable: true, length: 10, defaultValue: null, modelName: OPERATED_BY )
• LAST_CONDITION ( type: esriFieldTypeString, alias: LAST_CONDITION, editable: true, nullable: true, length: 15, defaultValue: null, modelName: LAST_CONDITION )
• LAST_H_TORQUE ( type: esriFieldTypeSmallInteger, alias: LAST_H_TORQUE, editable: true, nullable: true, defaultValue: null, modelName: LAST_H_TORQUE )
• LAST_POSITION ( type: esriFieldTypeString, alias: LAST_POSITION, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LAST_POSITION )
• VITALS_COMMENTS ( type: esriFieldTypeString, alias: VITALS_COMMENTS, editable: true, nullable: true, length: 80, defaultValue: null, modelName: VITALS_COMMENTS )
• IDNO ( type: esriFieldTypeSmallInteger, alias: IDNO, editable: true, nullable: true, defaultValue: null, modelName: IDNO )
• T1COMMENT ( type: esriFieldTypeString, alias: T1COMMENT, editable: true, nullable: true, length: 100, defaultValue: null, modelName: T1COMMENT )
• Oversize_Diameter ( type: esriFieldTypeDouble, alias: Oversize_Diameter, editable: true, nullable: true, defaultValue: null, modelName: Oversize_Diameter )
• Duplicate ( type: esriFieldTypeSmallInteger, alias: Duplicate, editable: true, nullable: true, defaultValue: null, modelName: Duplicate )
• SHEET_S ( type: esriFieldTypeInteger, alias: ORTHO INDEX, editable: true, nullable: true, defaultValue: null, modelName: SHEET_S )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• CreatedBy ( type: esriFieldTypeString, alias: Created By, editable: false, nullable: true, length: 150, defaultValue: null, modelName: CreatedBy )
• CreatedByDate ( type: esriFieldTypeDate, alias: Created By Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreatedByDate )
• EditedBy ( type: esriFieldTypeString, alias: Edited By, editable: false, nullable: true, length: 150, defaultValue: null, modelName: EditedBy )
• EditedByDate ( type: esriFieldTypeDate, alias: Edited By Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: EditedByDate )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• MaintainedBy ( type: esriFieldTypeString, alias: Maintained By, editable: true, nullable: true, length: 75, defaultValue: null, modelName: MaintainedBy , Coded Values: [Bedford Township: Bedford Township] , [City of Battle Creek: City of Battle Creek] , [City of Springfield: City of Springfield] , ...7 more... )
• Latitude ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: Latitude )
• Longitude ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: Longitude )
• Rotation ( type: esriFieldTypeSmallInteger, alias: Rotation, editable: true, nullable: true, defaultValue: null, modelName: Rotation )

Types:

ID: Air Release
Name: Air Release
Domains:
• VLV_STYLE:
  Inherited
• DIAMETER:
  Inherited
• OVERSIZE:
  Inherited
• MANUFACTURER:
  Inherited
• TURNS:
  Inherited
• RH__LH:
  Inherited
• DEPTH_TO_N:
  Inherited
• OPERATION:
  Inherited
• INSTALLMTH:
  Inherited
• INSTALL_YR:
  Inherited
• MUNICIPALITY:
  Inherited
• OWNER:
  Inherited
• CONTRACTOR:
  Inherited
• PUBLIC_PVT:
  Inherited
• VBorMH:
  Inherited
• VERIFIED:
  Inherited
• HIGH_LOW:
  Inherited
• Enabled:
  Inherited
• MaintainedBy:
  Inherited
Templates:
• Name: Air Release
  Description:
  Prototype:
  SUB_TYPE: 0
  Longitude: null
  FACILITYID: null
  VALVE_ID: null
  VLV_STYLE: Air Release
  DIAMETER: null
  OVERSIZE: null
  MANUFACTURER: null
  TURNS: null
  RH__LH: null
  DEPTH_TO_N: null
  OPERATION: Open
  CAST_DATE: null
  INSTALLMTH: null
  INSTALL_YR: null
  MUNICIPALITY: null
  OWNER: null
  CONTRACTOR: null
  PUBLIC_PVT: null
  ELEVATION: null
  VBorMH: null
  GPS_Date: null
  VERIFIED: null
  COMMENTS: null
  HYPERLINK: null
  HIGH_LOW: N
  LAST_OPERATED: null
  OPERATED_BY: null
  LAST_CONDITION: null
  LAST_H_TORQUE: null
  LAST_POSITION: null
  VITALS_COMMENTS: null
  IDNO: null
  T1COMMENT: null
  Oversize_Diameter: null
  Duplicate: null
  SHEET_S: null
  Enabled: 1
  Latitude: null
  MaintainedBy: null
  Rotation: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Check
Name: Bypass
Domains:
• VLV_STYLE:
  Inherited
• DIAMETER:
  Inherited
• OVERSIZE:
  Inherited
• MANUFACTURER:
  Inherited
• TURNS:
  Inherited
• RH__LH:
  Inherited
• DEPTH_TO_N:
  Inherited
• OPERATION:
  Inherited
• INSTALLMTH:
  Inherited
• INSTALL_YR:
  Inherited
• MUNICIPALITY:
  Inherited
• OWNER:
  Inherited
• CONTRACTOR:
  Inherited
• PUBLIC_PVT:
  Inherited
• VBorMH:
  Inherited
• VERIFIED:
  Inherited
• HIGH_LOW:
  Inherited
• Enabled:
  Inherited
• MaintainedBy:
  Inherited
Templates:
• Name: Bypass
  Description:
  Prototype:
  SUB_TYPE: 0
  Longitude: null
  FACILITYID: null
  VALVE_ID: null
  VLV_STYLE: Check
  DIAMETER: null
  OVERSIZE: null
  MANUFACTURER: null
  TURNS: null
  RH__LH: null
  DEPTH_TO_N: null
  OPERATION: Open
  CAST_DATE: null
  INSTALLMTH: null
  INSTALL_YR: null
  MUNICIPALITY: null
  OWNER: null
  CONTRACTOR: null
  PUBLIC_PVT: null
  ELEVATION: null
  VBorMH: null
  GPS_Date: null
  VERIFIED: null
  COMMENTS: null
  HYPERLINK: null
  HIGH_LOW: N
  LAST_OPERATED: null
  OPERATED_BY: null
  LAST_CONDITION: null
  LAST_H_TORQUE: null
  LAST_POSITION: null
  VITALS_COMMENTS: null
  IDNO: null
  T1COMMENT: null
  Oversize_Diameter: null
  Duplicate: null
  SHEET_S: null
  Enabled: 1
  Latitude: null
  MaintainedBy: null
  Rotation: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Presssure Reducing
Name: Presssure Reducing
Domains:
• VLV_STYLE:
  Inherited
• DIAMETER:
  Inherited
• OVERSIZE:
  Inherited
• MANUFACTURER:
  Inherited
• TURNS:
  Inherited
• RH__LH:
  Inherited
• DEPTH_TO_N:
  Inherited
• OPERATION:
  Inherited
• INSTALLMTH:
  Inherited
• INSTALL_YR:
  Inherited
• MUNICIPALITY:
  Inherited
• OWNER:
  Inherited
• CONTRACTOR:
  Inherited
• PUBLIC_PVT:
  Inherited
• VBorMH:
  Inherited
• VERIFIED:
  Inherited
• HIGH_LOW:
  Inherited
• Enabled:
  Inherited
• MaintainedBy:
  Inherited
Templates:
• Name: Presssure Reducing
  Description:
  Prototype:
  SUB_TYPE: 0
  Longitude: null
  FACILITYID: null
  VALVE_ID: null
  VLV_STYLE: Presssure Reducing
  DIAMETER: null
  OVERSIZE: null
  MANUFACTURER: null
  TURNS: null
  RH__LH: null
  DEPTH_TO_N: null
  OPERATION: Open
  CAST_DATE: null
  INSTALLMTH: null
  INSTALL_YR: null
  MUNICIPALITY: null
  OWNER: null
  CONTRACTOR: null
  PUBLIC_PVT: null
  ELEVATION: null
  VBorMH: null
  GPS_Date: null
  VERIFIED: null
  COMMENTS: null
  HYPERLINK: null
  HIGH_LOW: N
  LAST_OPERATED: null
  OPERATED_BY: null
  LAST_CONDITION: null
  LAST_H_TORQUE: null
  LAST_POSITION: null
  VITALS_COMMENTS: null
  IDNO: null
  T1COMMENT: null
  Oversize_Diameter: null
  Duplicate: null
  SHEET_S: null
  Enabled: 1
  Latitude: null
  MaintainedBy: null
  Rotation: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: CreatedByDate
• Creator Field: CreatedBy
• Edit Date Field: EditedByDate
• Editor Field: EditedBy

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

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