View In:   ArcGIS Online Map Viewer

Name: rwSystemValve

Display Field: pressurezonename

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 4d0f7d7a5b394c64b4a8f30bb89fbfb5

Copyright Text:

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

Extent:

XMin: 678285.0390638299
YMin: 1018344.2509752363
XMax: 688542.4719609953
YMax: 1030686.5297683254
Spatial Reference: 102649  (102649)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
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 )
• location ( modelName: LOCATION, nullable: true, editable: true, defaultValue: null, length: 200, alias: Location Description, 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] , ...13 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 )
• operable ( modelName: OPERABLE, nullable: true, editable: true, defaultValue: 1, alias: Operable, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] )
• normalposition ( modelName: NORMALPOSITION, nullable: true, editable: true, defaultValue: null, 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] )
• 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: [Active: Active] , [Out of Service: Out of Service] , [Inactive: Inactive] , ...2 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] , ...4 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... )
• quartersection ( 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: [Anthem: Anthem] , [Arizona Gateway: Arizona Gateway] , [Fort Mohave: Fort Mohave] , ...7 more... )
• 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: null, 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 )
• 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] )
• valveuse ( modelName: VALVEUSE, nullable: true, editable: true, defaultValue: null, length: 15, alias: Valve Use, type: esriFieldTypeString )
• pressuresetting ( modelName: PRESSURESETTING, nullable: true, editable: true, defaultValue: null, length: 20, alias: PressureSetting, type: esriFieldTypeString )
• meterroute ( modelName: METERROUTE, nullable: true, editable: true, defaultValue: null, length: 20, alias: MeterRoute, type: esriFieldTypeString )
• 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 )

Templates:

• Name: rwSystemValve
  Description:
  Prototype:
  operatingdistrict: null
  operable: 1
  datasourcetype: null
  pressurezonehgl: null
  facilityid: null
  serialnum: null
  installdate: null
  meterroute: null
  normalposition: null
  manufacturer: null
  quartersection: null
  operatingcompany: null
  diameter: null
  valvetype: null
  pressuresetting: null
  depthtonut: null
  watertype: null
  ownedby: 1
  projectid: null
  vault: null
  elevation: null
  lifecyclestatuschangedate: null
  modelnum: null
  currentposition: null
  hydrflag: 0
  turnstoclose: null
  activeflag: Active
  valvefunction: null
  clocktoclose: 1
  bypassvalve: 0
  system: null
  operatingnuttype: null
  inmodel: null
  valveuse: null
  datasourcereference: null
  pressurezonename: null
  location: null
  maintby: 1
  operatingdivision: null
  
  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