View In:   ArcGIS Online Map Viewer

Name: wSystemValve

Display Field: pressurezonename

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 1ef21aa1ab6643ffbbf91948b770ca0a

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 5000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -1.2707145772411773E7
YMin: 3630241.927770056
XMax: -1.2453767884672489E7
YMax: 4012702.9966063276
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [0, 0, 0, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: true
Supports Query With LOD Spatial Reference: true
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: System-maintained ObjectID, alias: OBJECTID )
• facilityid ( modelName: FACILITYID, nullable: true, editable: true, defaultValue: null, length: 20, alias: Valve ID, type: esriFieldTypeString )
• serialnum ( modelName: SERIALNUM, nullable: true, editable: true, defaultValue: null, length: 20, alias: Serial Number, type: esriFieldTypeString )
• modelnum ( modelName: MODELNUM, nullable: true, editable: true, defaultValue: null, length: 20, alias: Model Number, type: esriFieldTypeString )
• installdate ( modelName: INSTALLDATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Install Date, type: esriFieldTypeDate )
• warrantydate ( modelName: WARRANTYDATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Warranty Date, type: esriFieldTypeDate )
• location ( modelName: LOCATION, nullable: true, editable: true, defaultValue: null, length: 200, alias: Location, type: esriFieldTypeString )
• diameter ( modelName: DIAMETER, nullable: true, editable: true, defaultValue: null, alias: Diameter, type: esriFieldTypeDouble , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...32 more... )
• valvetype ( modelName: VALVETYPE, nullable: true, editable: true, defaultValue: null, length: 30, alias: Valve Type, type: esriFieldTypeString , Coded Values: [Ball: Ball] , [Butterfly: Butterfly] , [Cone: Cone] , ...5 more... )
• valvefunction ( modelName: VALVEFUNCTION, nullable: true, editable: true, defaultValue: null, length: 30, alias: Valve Function, type: esriFieldTypeString , Coded Values: [Distribution in Grid: Distribution in Grid] , [Dist Dead End: Dist Dead End] , [Blow-off: Blow-off] , ...11 more... )
• bypassvalve ( modelName: BYPASSVALVE, nullable: true, editable: true, defaultValue: 0, alias: Bypass Valve, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] )
• clocktoclose ( modelName: CLOCKTOCLOSE, nullable: true, editable: true, defaultValue: 1, alias: Clockwise To Close, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] )
• turnstoclose ( modelName: TURNSTOCLOSE, nullable: true, editable: true, defaultValue: null, alias: Turns To Close, type: esriFieldTypeInteger )
• normalposition ( modelName: NORMALPOSITION, nullable: true, editable: true, defaultValue: Opened, length: 6, alias: Normal Position, type: esriFieldTypeString , Coded Values: [Opened: Opened] , [Closed: Closed] )
• currentposition ( modelName: CURRENTPOSITION, nullable: true, editable: true, defaultValue: null, length: 6, alias: Current Position, type: esriFieldTypeString , Coded Values: [Opened: Opened] , [Closed: Closed] )
• vault ( modelName: VAULT, nullable: true, editable: true, defaultValue: null, length: 4, alias: In Vault, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• operable ( modelName: OPERABLE, nullable: true, editable: true, defaultValue: 1, alias: Operable, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] )
• manufacturer ( modelName: MANUFACTURER, nullable: true, editable: true, defaultValue: null, length: 20, alias: Manufacturer, type: esriFieldTypeString , Coded Values: [Unknown: Unknown] )
• depthtonut ( modelName: DEPTHTONUT, nullable: true, editable: true, defaultValue: null, alias: DepthToNut, type: esriFieldTypeDouble )
• hydrflag ( modelName: HYDRFLAG, nullable: true, editable: true, defaultValue: 0, alias: Hydrant Valve, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] )
• activeflag ( modelName: ACTIVEFLAG, nullable: true, editable: true, defaultValue: Active, length: 20, alias: Status, type: esriFieldTypeString , Coded Values: [Abandoned: Abandoned] , [Active: Active] , [Cancelled: Cancelled] , ...7 more... )
• ownedby ( modelName: OWNEDBY, nullable: true, editable: true, defaultValue: 1, alias: Owned By, type: esriFieldTypeSmallInteger , Coded Values: [-1: Unknown] , [1: Town of Cave Creek] , [2: City Of Phoenix] , ...3 more... )
• maintby ( modelName: MAINTBY, nullable: true, editable: true, defaultValue: 1, alias: Managed By, type: esriFieldTypeSmallInteger , Coded Values: [-1: Private] , [-2: Unknown] , [1: Cave Creek Utilities] , ...3 more... )
• operatingcompany ( modelName: OPERATINGCOMPANY, nullable: true, editable: true, defaultValue: null, length: 32, alias: OperatingCompany, type: esriFieldTypeString , Coded Values: [-1: Unknown] , [2: Liberty Utilities] , [1: Cave Creek Utilities] , ...3 more... )
• operatingdivision ( modelName: OPERATINGDIVISION, nullable: true, editable: true, defaultValue: null, length: 32, alias: OperatingDivision, type: esriFieldTypeString , Coded Values: [-1: Unknown] , [1: Cave Creek] , [2: Desert Hills] , ...1 more... )
• operatingdistrict ( modelName: OPERATINGDISTRICT, nullable: true, editable: true, defaultValue: null, length: 32, alias: OperatingDistrict, type: esriFieldTypeString , Coded Values: [CC: Cave Creek] , [DH: Desert Hills] , [CS: Cahava Springs] , ...2 more... )
• qsec ( modelName: QUARTERSECTION, nullable: true, editable: true, defaultValue: null, length: 20, alias: Quartersection, type: esriFieldTypeString )
• system ( modelName: SYSTEM, nullable: true, editable: true, defaultValue: null, length: 20, alias: System, type: esriFieldTypeString , Coded Values: )
• lifecyclestatuschangedate ( modelName: LIFECYCLESTATUSCHANGEDATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: LifeCycleStatusChangeDate, type: esriFieldTypeDate )
• projectid ( modelName: PROJECTID, nullable: true, editable: true, defaultValue: null, length: 15, alias: Project ID, type: esriFieldTypeString )
• watertype ( modelName: WATERTYPE, nullable: true, editable: true, defaultValue: Potable, length: 50, alias: Water Type, type: esriFieldTypeString , Coded Values: [Potable: Potable Water] , [Raw: Raw Water] , [Reclaimed: Reclaimed Water] , ...3 more... )
• datasourcetype ( modelName: DATASOURCETYPE, nullable: true, editable: true, defaultValue: null, length: 20, alias: DataSourceType, type: esriFieldTypeString , Coded Values: [Asbuilt: As-built Record Plan] , [Construction: Construction Plan] , [Conventional Survey: Conventional Survey] , ...16 more... )
• datasourcereference ( modelName: DATASOURCEREFERENCE, nullable: true, editable: true, defaultValue: null, length: 50, alias: DataSourceReference, type: esriFieldTypeString )
• elevation ( modelName: ELEVATION, nullable: true, editable: true, defaultValue: null, alias: Elevation, type: esriFieldTypeDouble )
• pressurezonename ( modelName: PRESSUREZONENAME, nullable: true, editable: true, defaultValue: null, length: 50, alias: PressureZoneName, type: esriFieldTypeString )
• pressurezonehgl ( modelName: PRESSUREZONEHGL, nullable: true, editable: true, defaultValue: null, alias: PressureZoneHGL, type: esriFieldTypeInteger )
• staticpressure ( modelName: STATICPRESSURE, nullable: true, editable: true, defaultValue: null, alias: Static Pressure, type: esriFieldTypeInteger )
• legacyid ( modelName: LEGACYID, nullable: true, editable: true, defaultValue: null, length: 20, alias: LEGACYID, type: esriFieldTypeString )
• legacyid2 ( modelName: LEGACYID2, nullable: true, editable: true, defaultValue: null, length: 20, alias: LegacyID2, type: esriFieldTypeString )
• gpscollectiontype ( modelName: GPSCOLLECTIONTYPE, nullable: true, editable: true, defaultValue: null, length: 25, alias: GPSCollectionType, type: esriFieldTypeString )
• gpsdate ( modelName: GPSDATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: GPS_Date, type: esriFieldTypeDate )
• gpsestacc ( modelName: GPSESTACC, nullable: true, editable: true, defaultValue: null, alias: GPSEstAcc, type: esriFieldTypeDouble )
• gpsfieldnotes ( modelName: GPSFIELDNOTES, nullable: true, editable: true, defaultValue: null, length: 100, alias: GPSFieldNotes, type: esriFieldTypeString )
• operatingnuttype ( modelName: OPERATINGNUTTYPE, nullable: true, editable: true, defaultValue: null, length: 12, alias: OperatingNutType, type: esriFieldTypeString )
• inmodel ( modelName: INMODEL, nullable: true, editable: true, defaultValue: null, length: 4, alias: InModel, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• operationsmaintained ( modelName: OPERATIONSMAINTAINED, nullable: true, editable: true, defaultValue: 0, alias: Operations Maintained, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] )
• safetyrequirements ( modelName: SAFETYREQUIREMENTS, nullable: true, editable: true, defaultValue: null, length: 30, alias: Safety Requirements, type: esriFieldTypeString )
• cof ( modelName: COF, nullable: true, editable: true, defaultValue: null, alias: Consequence of Failure, type: esriFieldTypeInteger )
• pof ( modelName: POF, nullable: true, editable: true, defaultValue: null, alias: Probability of Failure, type: esriFieldTypeInteger )
• bre ( modelName: BRE, nullable: true, editable: true, defaultValue: null, alias: Business Risk Exposure, type: esriFieldTypeInteger )
• createeditor ( modelName: CREATEEDITOR, nullable: true, editable: false, defaultValue: null, length: 20, alias: Creation User, type: esriFieldTypeString )
• createdate ( modelName: CREATEDATE, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: Date Created, type: esriFieldTypeDate )
• lastupdate ( modelName: LASTUPDATE, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: Last Update Date, type: esriFieldTypeDate )
• lasteditor ( modelName: LASTEDITOR, nullable: true, editable: false, defaultValue: null, length: 50, alias: Last Editor, type: esriFieldTypeString )
• enabled ( modelName: Enabled, nullable: true, editable: true, defaultValue: 1, alias: Enabled, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] )
• cflink ( modelName: CFLink, nullable: true, editable: true, defaultValue: null, alias: CFLink, type: esriFieldTypeSmallInteger )

Templates:

• Name: Hydrant Valve
  Description:
  Prototype:
  operable: 1
  pressurezonehgl: null
  facilityid: null
  installdate: null
  legacyid2: null
  diameter: null
  bre: null
  safetyrequirements: null
  watertype: Potable
  gpsdate: null
  ownedby: 1
  vault: null
  modelnum: null
  currentposition: null
  hydrflag: 0
  turnstoclose: null
  activeflag: Active
  valvefunction: Hyd Aux
  system: AZ0407017
  operatingnuttype: null
  datasourcereference: null
  gpsestacc: null
  legacyid: null
  operationsmaintained: 0
  operatingdistrict: Chaparral Water
  datasourcetype: Asbuilt
  serialnum: null
  staticpressure: null
  pof: null
  normalposition: Opened
  enabled: 1
  manufacturer: null
  operatingcompany: EPCOR AZ
  gpscollectiontype: null
  valvetype: Gate
  warrantydate: null
  depthtonut: null
  projectid: null
  elevation: null
  cflink: null
  lifecyclestatuschangedate: null
  gpsfieldnotes: null
  clocktoclose: 1
  inmodel: null
  bypassvalve: 0
  qsec: null
  pressurezonename: null
  maintby: 1
  location: null
  cof: null
  operatingdivision: Eastern
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Blow Off
  Description:
  Prototype:
  operable: 1
  pressurezonehgl: null
  facilityid: null
  installdate: null
  legacyid2: null
  diameter: null
  bre: null
  safetyrequirements: null
  watertype: Potable
  gpsdate: null
  ownedby: 1
  vault: null
  modelnum: null
  currentposition: null
  hydrflag: 0
  turnstoclose: null
  activeflag: Active
  valvefunction: Blow-off
  system: null
  operatingnuttype: null
  datasourcereference: null
  gpsestacc: null
  legacyid: null
  operationsmaintained: 0
  operatingdistrict: null
  datasourcetype: null
  serialnum: null
  staticpressure: null
  pof: null
  normalposition: Opened
  enabled: 1
  manufacturer: null
  operatingcompany: EPCOR AZ
  gpscollectiontype: null
  valvetype: Gate
  warrantydate: null
  depthtonut: null
  projectid: null
  elevation: null
  cflink: null
  lifecyclestatuschangedate: null
  gpsfieldnotes: null
  clocktoclose: 1
  inmodel: null
  bypassvalve: 0
  qsec: null
  pressurezonename: null
  maintby: 1
  location: null
  cof: null
  operatingdivision: Eastern
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Gate 8"
  Description:
  Prototype:
  operable: 1
  pressurezonehgl: null
  facilityid: null
  installdate: null
  legacyid2: null
  diameter: 8
  bre: null
  safetyrequirements: null
  watertype: Potable
  gpsdate: null
  ownedby: 1
  vault: null
  modelnum: null
  currentposition: null
  hydrflag: 0
  turnstoclose: null
  activeflag: Active
  valvefunction: null
  system: AZ0407099
  operatingnuttype: null
  datasourcereference: null
  gpsestacc: null
  legacyid: null
  operationsmaintained: 0
  operatingdistrict: Sun City Water
  datasourcetype: Asbuilt
  serialnum: null
  staticpressure: null
  pof: null
  normalposition: Opened
  enabled: 1
  manufacturer: null
  operatingcompany: EPCOR AZ
  gpscollectiontype: null
  valvetype: Gate
  warrantydate: null
  depthtonut: null
  projectid: null
  elevation: null
  cflink: null
  lifecyclestatuschangedate: null
  gpsfieldnotes: null
  clocktoclose: 1
  inmodel: null
  bypassvalve: 0
  qsec: null
  pressurezonename: null
  location: null
  maintby: 1
  cof: null
  operatingdivision: Central
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Gate 12"
  Description:
  Prototype:
  operable: 1
  pressurezonehgl: null
  facilityid: null
  installdate: null
  legacyid2: null
  diameter: 12
  bre: null
  safetyrequirements: null
  watertype: Potable
  gpsdate: null
  ownedby: 1
  vault: null
  modelnum: null
  currentposition: null
  hydrflag: 0
  turnstoclose: null
  activeflag: Active
  valvefunction: null
  system: AZ0407017
  operatingnuttype: null
  datasourcereference: null
  gpsestacc: null
  legacyid: null
  operationsmaintained: 0
  operatingdistrict: Chaparral Water
  datasourcetype: Asbuilt
  serialnum: null
  staticpressure: null
  pof: null
  normalposition: Opened
  enabled: 1
  manufacturer: null
  operatingcompany: EPCOR AZ
  gpscollectiontype: null
  valvetype: Gate
  warrantydate: null
  depthtonut: null
  projectid: null
  elevation: null
  cflink: null
  lifecyclestatuschangedate: null
  gpsfieldnotes: null
  clocktoclose: 1
  inmodel: null
  bypassvalve: 0
  qsec: null
  pressurezonename: null
  location: null
  maintby: 1
  cof: null
  operatingdivision: Eastern
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Gate 4"
  Description:
  Prototype:
  operable: 1
  pressurezonehgl: null
  facilityid: null
  installdate: null
  legacyid2: null
  diameter: 4
  bre: null
  safetyrequirements: null
  watertype: Potable
  gpsdate: null
  ownedby: null
  vault: null
  modelnum: null
  currentposition: null
  hydrflag: 0
  turnstoclose: null
  activeflag: Active
  valvefunction: null
  system: null
  operatingnuttype: null
  datasourcereference: null
  gpsestacc: null
  legacyid: null
  operationsmaintained: 0
  operatingdistrict: null
  datasourcetype: null
  serialnum: null
  staticpressure: null
  pof: null
  normalposition: Opened
  enabled: 1
  manufacturer: null
  operatingcompany: null
  gpscollectiontype: null
  valvetype: Gate
  warrantydate: null
  depthtonut: null
  projectid: null
  elevation: null
  cflink: null
  lifecyclestatuschangedate: null
  gpsfieldnotes: null
  clocktoclose: 1
  inmodel: null
  bypassvalve: 0
  qsec: null
  pressurezonename: null
  location: null
  maintby: null
  cof: null
  operatingdivision: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Gate 6"
  Description:
  Prototype:
  operable: 1
  pressurezonehgl: null
  facilityid: null
  installdate: null
  legacyid2: null
  diameter: 6
  bre: null
  safetyrequirements: null
  watertype: Potable
  gpsdate: null
  ownedby: null
  vault: null
  modelnum: null
  currentposition: null
  hydrflag: 0
  turnstoclose: null
  activeflag: Active
  valvefunction: null
  system: null
  operatingnuttype: null
  datasourcereference: null
  gpsestacc: null
  legacyid: null
  operationsmaintained: 0
  operatingdistrict: null
  datasourcetype: null
  serialnum: null
  staticpressure: null
  pof: null
  normalposition: Opened
  enabled: 1
  manufacturer: null
  operatingcompany: null
  gpscollectiontype: null
  valvetype: Gate
  warrantydate: null
  depthtonut: null
  projectid: null
  elevation: null
  cflink: null
  lifecyclestatuschangedate: null
  gpsfieldnotes: null
  clocktoclose: 1
  inmodel: null
  bypassvalve: 0
  qsec: null
  pressurezonename: null
  location: null
  maintby: null
  cof: null
  operatingdivision: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: 10" GATE
  Description:
  Prototype:
  operable: 1
  pressurezonehgl: null
  facilityid: null
  installdate: null
  legacyid2: null
  diameter: 10
  bre: null
  safetyrequirements: null
  watertype: Potable
  gpsdate: null
  ownedby: 1
  vault: null
  modelnum: null
  currentposition: null
  hydrflag: 0
  turnstoclose: null
  activeflag: Active
  valvefunction: null
  system: AZ0407017
  operatingnuttype: null
  datasourcereference: null
  gpsestacc: null
  legacyid: null
  operationsmaintained: 0
  operatingdistrict: Chaparral Water
  datasourcetype: Asbuilt
  serialnum: null
  staticpressure: null
  pof: null
  normalposition: Opened
  enabled: 1
  manufacturer: null
  operatingcompany: EPCOR AZ
  gpscollectiontype: null
  valvetype: Gate
  warrantydate: null
  depthtonut: null
  projectid: null
  elevation: null
  cflink: null
  lifecyclestatuschangedate: null
  gpsfieldnotes: null
  clocktoclose: 1
  inmodel: null
  bypassvalve: 0
  qsec: null
  pressurezonename: null
  location: null
  maintby: 1
  cof: null
  operatingdivision: Eastern
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Gate 16"
  Description:
  Prototype:
  operable: 1
  pressurezonehgl: null
  facilityid: null
  installdate: null
  legacyid2: null
  diameter: 16
  bre: null
  safetyrequirements: null
  watertype: Potable
  gpsdate: null
  ownedby: 1
  vault: null
  modelnum: null
  currentposition: null
  hydrflag: 0
  turnstoclose: null
  activeflag: Active
  valvefunction: null
  system: AZ0407017
  operatingnuttype: null
  datasourcereference: null
  gpsestacc: null
  legacyid: null
  operationsmaintained: 0
  operatingdistrict: Chaparral Water
  datasourcetype: Asbuilt
  serialnum: null
  staticpressure: null
  pof: null
  normalposition: Opened
  enabled: 1
  manufacturer: null
  operatingcompany: EPCOR AZ
  gpscollectiontype: null
  valvetype: Gate
  warrantydate: null
  depthtonut: null
  projectid: null
  elevation: null
  cflink: null
  lifecyclestatuschangedate: null
  gpsfieldnotes: null
  clocktoclose: 1
  inmodel: null
  bypassvalve: 0
  qsec: null
  pressurezonename: null
  location: null
  maintby: 1
  cof: null
  operatingdivision: Eastern
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: createdate
• Creator Field: createeditor
• Edit Date Field: lastupdate
• Editor Field: lasteditor

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata