View In:   ArcGIS Online Map Viewer

Name: Water Control Valve

Display Field: assetname

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 01aa6ac981e34e0b8b2008e54ca4fb60

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 700

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.7401318395863324E7
YMin: 137937.39226272778
XMax: 1780028.8647578224
YMax: 1.8697085475303084E7
Spatial Reference: 103180  (6597)

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

HasZ: true

HasM: true

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• diameter ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: diameter , Coded Values: [0: Unknown] , [0.25: 1/4"] , [0.375: 3/8"] , ...121 more... )
• ASSETGROUP ( type: esriFieldTypeInteger, alias: Valve Type, editable: true, required: true, nullable: false, defaultValue: 0, modelName: ASSETGROUP )
• installdate ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: installdate )
• ASSETTYPE ( type: esriFieldTypeSmallInteger, alias: Asset Type, editable: true, required: true, nullable: false, defaultValue: 0, modelName: ASSETTYPE )
• designtype ( type: esriFieldTypeSmallInteger, alias: Design Type, editable: true, nullable: true, defaultValue: null, modelName: designtype )
• locdesc ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: locdesc )
• lifecyclestatus ( type: esriFieldTypeSmallInteger, alias: Lifecycle Status, editable: true, nullable: false, defaultValue: 0, modelName: lifecyclestatus , Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...14 more... )
• spatialconfidence ( type: esriFieldTypeSmallInteger, alias: Spatial Confidence, editable: true, nullable: true, defaultValue: null, modelName: spatialconfidence , Coded Values: [0: Unknown] , [1: High] , [2: Medium] , ...1 more... )
• facilityid ( type: esriFieldTypeString, alias: Facility ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: facilityid )
• notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: notes )
• ownedby ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: ownedby , Coded Values: [1: Our Agency] , [2: Private] , [3: City of Wenatchee] , ...6 more... )
• maintby ( type: esriFieldTypeSmallInteger, alias: Maintained By, editable: true, nullable: true, defaultValue: 1, modelName: maintby , Coded Values: [1: Our Agency] , [2: Private] , [3: City of Wenatchee] , ...6 more... )
• flmetacode ( type: esriFieldTypeString, alias: Validation Code, editable: true, nullable: true, length: 255, defaultValue: null, modelName: flmetacode )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last update, editable: false, required: true, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• UPDATEDBY ( type: esriFieldTypeString, alias: Updated by, editable: false, required: true, nullable: true, length: 255, defaultValue: null, modelName: UPDATEDBY )
• OBJECTID ( type: esriFieldTypeOID, alias: Object ID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ASSOCIATIONSTATUS ( type: esriFieldTypeSmallInteger, alias: Association status, editable: false, required: true, nullable: false, defaultValue: 0, modelName: ASSOCIATIONSTATUS , Coded Values: [0: None] , [1: Container] , [2: Structure] , ...33 more... )
• ISSUBNETWORKCONTROLLER ( type: esriFieldTypeSmallInteger, alias: Is subnetwork controller, editable: false, required: true, nullable: false, defaultValue: 0, modelName: ISSUBNETWORKCONTROLLER , Coded Values: [0: False] , [1: True] )
• ISCONNECTED ( type: esriFieldTypeSmallInteger, alias: Is connected, editable: false, required: true, nullable: false, defaultValue: 2, modelName: ISCONNECTED , Coded Values: [0: False] , [1: True] , [2: Unknown] )
• SUBNETWORKCONTROLLERNAME ( type: esriFieldTypeString, alias: Subnetwork controller name, editable: false, required: true, nullable: false, length: 2000, defaultValue: Unknown, modelName: SUBNETWORKCONTROLLERNAME )
• TIERNAME ( type: esriFieldTypeInteger, alias: Tier name, editable: false, required: true, nullable: false, defaultValue: 0, modelName: TIERNAME , Coded Values: [0: Unknown] , [1: Water Cathodic Protection] , [2: Water System] , ...3 more... )
• TIERRANK ( type: esriFieldTypeInteger, alias: Tier rank, editable: false, required: true, nullable: false, defaultValue: 0, modelName: TIERRANK )
• TERMINALCONFIGURATION ( type: esriFieldTypeString, alias: Terminal path, editable: true, required: true, nullable: false, length: 128, defaultValue: Default, modelName: TERMINALCONFIGURATION )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: Global ID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )
• cpsubnetworkname ( type: esriFieldTypeString, alias: CP Subnetwork Name, editable: false, required: true, nullable: false, length: 2000, defaultValue: Unknown, modelName: cpsubnetworkname )
• SystemSubnetworkName ( type: esriFieldTypeString, alias: System Subnetwork Name, editable: false, required: true, nullable: false, length: 2000, defaultValue: Unknown, modelName: SystemSubnetworkName )
• PressureSubnetworkName ( type: esriFieldTypeString, alias: Pressure Subnetwork Name, editable: false, required: true, nullable: false, length: 2000, defaultValue: Unknown, modelName: PressureSubnetworkName )
• IsolationSubnetworkName ( type: esriFieldTypeString, alias: Isolation Subnetwork Name, editable: false, required: true, nullable: false, length: 2000, defaultValue: Unknown, modelName: IsolationSubnetworkName )
• DMASubnetworkName ( type: esriFieldTypeString, alias: DMA Subnetwork Name, editable: false, required: true, nullable: false, length: 2000, defaultValue: Unknown, modelName: DMASubnetworkName )
• secondarydiameter ( type: esriFieldTypeDouble, alias: Outlet Diameter, editable: true, nullable: true, defaultValue: null, modelName: secondarydiameter )
• pressure ( type: esriFieldTypeDouble, alias: Pressure, editable: true, nullable: true, defaultValue: null, modelName: pressure )
• normalstatus ( type: esriFieldTypeSmallInteger, alias: Normal Status, editable: true, nullable: false, defaultValue: null, modelName: normalstatus , Coded Values: [0: Closed] , [1: Open] , [2: Inactive] , ...1 more... )
• presentstatus ( type: esriFieldTypeSmallInteger, alias: Present Status, editable: true, nullable: false, defaultValue: null, modelName: presentstatus , Coded Values: [0: Closed] , [1: Open] , [2: Inactive] , ...1 more... )
• additionaldetails ( type: esriFieldTypeSmallInteger, alias: Clockwise to Close, editable: true, nullable: true, defaultValue: null, modelName: additionaldetails )
• designinfo ( type: esriFieldTypeDouble, alias: Turns to Close, editable: true, nullable: true, defaultValue: null, modelName: designinfo )
• operable ( type: esriFieldTypeSmallInteger, alias: Operable, editable: true, nullable: false, defaultValue: 1, modelName: operable , Coded Values: [0: False] , [1: True] )
• name ( type: esriFieldTypeString, alias: Name, editable: true, nullable: true, length: 64, defaultValue: null, modelName: name )
• assetid ( type: esriFieldTypeString, alias: Asset ID, editable: true, nullable: true, length: 64, defaultValue: null, modelName: assetid )
• accountid ( type: esriFieldTypeString, alias: Account ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: accountid )
• additionaldevice ( type: esriFieldTypeSmallInteger, alias: Has Bypass, editable: true, nullable: true, defaultValue: null, modelName: additionaldevice )
• symbolrotation ( type: esriFieldTypeSmallInteger, alias: Symbol Rotation, editable: true, nullable: true, defaultValue: null, modelName: symbolrotation )
• lastmaint ( type: esriFieldTypeDate, alias: Last Maintenance, editable: true, nullable: true, length: 8, defaultValue: null, modelName: lastmaint )
• bondedinsulated ( type: esriFieldTypeSmallInteger, alias: Bonded/Insulated, editable: true, nullable: true, defaultValue: null, modelName: bondedinsulated , Coded Values: [1: Bonded] , [2: Insulated] )
• cptraceability ( type: esriFieldTypeSmallInteger, alias: Cathodic Protection Traceability, editable: true, nullable: true, defaultValue: 0, modelName: cptraceability , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
• inservicedate ( type: esriFieldTypeDate, alias: In-Service Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: inservicedate )
• retireddate ( type: esriFieldTypeDate, alias: Retired Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: retireddate )
• spatialsource ( type: esriFieldTypeSmallInteger, alias: Spatial Source, editable: true, nullable: true, defaultValue: null, modelName: spatialsource , Coded Values: [0: Unknown] , [1: As-Built] , [2: CAD] , ...8 more... )
• cpoverride ( type: esriFieldTypeSmallInteger, alias: Cathodic Protection Override, editable: true, nullable: true, defaultValue: null, modelName: cpoverride , Coded Values: [1: Traceable] , [2: Not Traceable] )
• LeadFreeCompliant ( type: esriFieldTypeSmallInteger, alias: LeadFree Compliant, editable: true, nullable: true, defaultValue: null, modelName: LeadFreeCompliant , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
• BuryDepth ( type: esriFieldTypeDouble, alias: Bury Depth, editable: true, nullable: true, defaultValue: null, modelName: BuryDepth )
• Stortz ( type: esriFieldTypeSmallInteger, alias: Stortz, editable: true, nullable: true, defaultValue: null, modelName: Stortz , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
• nearaddress ( type: esriFieldTypeString, alias: Nearest Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: nearaddress )
• nearparcel ( type: esriFieldTypeString, alias: Nearest Parcel, editable: true, nullable: true, length: 255, defaultValue: null, modelName: nearparcel )
• elevation ( type: esriFieldTypeDouble, alias: Ground Elevation, editable: true, nullable: true, defaultValue: null, modelName: elevation )
• Port_ID ( type: esriFieldTypeString, alias: Port ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Port_ID )
• Radio_ID ( type: esriFieldTypeString, alias: Radio ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Radio_ID )
• Serial__ ( type: esriFieldTypeString, alias: Serial Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Serial__ )
• Device_Type ( type: esriFieldTypeString, alias: Device Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Device_Type )
• operationaldate ( type: esriFieldTypeDate, alias: Operational Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: operationaldate )
• assetname ( type: esriFieldTypeString, alias: Asset Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: assetname )
• aandefirm ( type: esriFieldTypeString, alias: A and E Firm, editable: true, nullable: true, length: 255, defaultValue: null, modelName: aandefirm )
• projecttitle ( type: esriFieldTypeString, alias: Project Title, editable: true, nullable: true, length: 255, defaultValue: null, modelName: projecttitle )
• vertdatum ( type: esriFieldTypeString, alias: Vertical Datum, editable: true, nullable: true, length: 255, defaultValue: null, modelName: vertdatum )
• label ( type: esriFieldTypeString, alias: Map Label, editable: true, nullable: true, length: 255, defaultValue: null, modelName: label )
• UID ( type: esriFieldTypeInteger, alias: UID, editable: true, nullable: true, defaultValue: null, modelName: UID )
• SUPPORTEDSUBNETWORKNAME ( type: esriFieldTypeString, alias: Supported subnetwork name, editable: false, required: true, nullable: true, length: 2000, defaultValue: Unknown, modelName: SUPPORTEDSUBNETWORKNAME )
• CREATIONDATE ( type: esriFieldTypeDate, alias: Creation date, editable: false, required: true, nullable: true, length: 8, defaultValue: null, modelName: CREATIONDATE )
• CREATOR ( type: esriFieldTypeString, alias: Creator, editable: false, required: true, nullable: true, length: 255, defaultValue: null, modelName: CREATOR )
• inspectdate ( type: esriFieldTypeDate, alias: Last Inspect Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: inspectdate )
• cleaneddate ( type: esriFieldTypeDate, alias: Last Cleaned Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: cleaneddate )

Templates:

• Name: Water Control Valve
  Description:
  Prototype:
  diameter: null
  inspectdate: null
  ASSETGROUP: 0
  installdate: null
  ASSETTYPE: 0
  designtype: null
  locdesc: null
  lifecyclestatus: 8
  spatialconfidence: 3
  facilityid: null
  notes: null
  ownedby: null
  maintby: null
  flmetacode: null
  nearparcel: null
  elevation: null
  Port_ID: null
  UID: null
  label: null
  vertdatum: null
  projecttitle: null
  aandefirm: null
  TERMINALCONFIGURATION: Default
  cleaneddate: null
  assetname: null
  operationaldate: null
  Device_Type: null
  Serial__: null
  Radio_ID: null
  secondarydiameter: null
  pressure: null
  normalstatus: 1
  presentstatus: 1
  additionaldetails: null
  designinfo: null
  operable: 1
  name: null
  assetid: null
  accountid: null
  additionaldevice: null
  symbolrotation: 0
  lastmaint: null
  bondedinsulated: null
  cptraceability: 0
  inservicedate: null
  retireddate: null
  spatialsource: null
  cpoverride: null
  LeadFreeCompliant: null
  BuryDepth: null
  Stortz: null
  nearaddress: null
  
  Drawing Tool: esriFeatureEditToolPoint

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Supports OidReservation: true

Edit Fields Info:

• Creation Date Field: CREATIONDATE
• Creator Field: CREATOR
• Edit Date Field: LASTUPDATE
• Editor Field: UPDATEDBY

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

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