Name: Water Junction Object

Display Field: subnetworkcontrollername

Type: Table

Geometry Type: N/A

Description:

Service Item Id: cc39b86a1b8945cca91d695638024530

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

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: false
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: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: Object ID )
• assetgroup ( modelName: assetgroup, nullable: false, editable: true, defaultValue: 0, alias: Asset group, type: esriFieldTypeInteger )
• assettype ( modelName: assettype, nullable: false, editable: true, defaultValue: 0, alias: Asset type, type: esriFieldTypeSmallInteger )
• associationstatus ( modelName: associationstatus, nullable: false, editable: true, defaultValue: 0, alias: Association status, type: esriFieldTypeSmallInteger , Coded Values: [0: None] , [1: Container] , [2: Structure] , ...33 more... )
• issubnetworkcontroller ( modelName: issubnetworkcontroller, nullable: false, editable: true, defaultValue: 0, alias: Is subnetwork controller, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] )
• isconnected ( modelName: isconnected, nullable: false, editable: true, defaultValue: 2, alias: Is connected, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] , [2: Unknown] )
• subnetworkcontrollername ( modelName: subnetworkcontrollername, nullable: false, editable: true, defaultValue: Unknown, length: 2000, alias: Subnetwork controller name, type: esriFieldTypeString )
• tiername ( modelName: tiername, nullable: false, editable: true, defaultValue: 0, alias: Tier name, type: esriFieldTypeInteger , Coded Values: [0: Unknown] , [1: Water Cathodic Protection] , [2: Water System] , ...3 more... )
• tierrank ( modelName: tierrank, nullable: false, editable: true, defaultValue: 0, alias: Tier rank, type: esriFieldTypeInteger )
• terminalconfiguration ( modelName: terminalconfiguration, nullable: false, editable: true, defaultValue: Default, length: 128, alias: Terminal path, type: esriFieldTypeString )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: globalid, alias: Global ID )
• cpsubnetworkname ( modelName: cpsubnetworkname, nullable: false, editable: true, defaultValue: Unknown, length: 2000, alias: CP subnetwork name, type: esriFieldTypeString )
• supportedsubnetworkname ( modelName: supportedsubnetworkname, nullable: false, editable: true, defaultValue: Unknown, length: 2000, alias: Supported subnetwork name, type: esriFieldTypeString )
• supportingsubnetworkname ( modelName: supportingsubnetworkname, nullable: false, editable: true, defaultValue: Unknown, length: 2000, alias: Supporting subnetwork name, type: esriFieldTypeString )
• systemsubnetworkname ( modelName: systemsubnetworkname, nullable: false, editable: true, defaultValue: Unknown, length: 2000, alias: System subnetwork name, type: esriFieldTypeString )
• pressuresubnetworkname ( modelName: pressuresubnetworkname, nullable: false, editable: true, defaultValue: Unknown, length: 2000, alias: Pressure subnetwork name, type: esriFieldTypeString )
• isolationsubnetworkname ( modelName: isolationsubnetworkname, nullable: false, editable: true, defaultValue: Unknown, length: 2000, alias: Isolation subnetwork name, type: esriFieldTypeString )
• dmasubnetworkname ( modelName: dmasubnetworkname, nullable: false, editable: true, defaultValue: Unknown, length: 2000, alias: DMA subnetwork name, type: esriFieldTypeString )
• creationdate ( modelName: creationdate, nullable: true, editable: false, defaultValue: null, length: 29, alias: Creation date, type: esriFieldTypeDate )
• creator ( modelName: creator, nullable: true, editable: false, defaultValue: null, length: 255, alias: Creator, type: esriFieldTypeString )
• lastupdate ( modelName: lastupdate, nullable: true, editable: false, defaultValue: null, length: 29, alias: Last update, type: esriFieldTypeDate )
• updatedby ( modelName: updatedby, nullable: true, editable: false, defaultValue: null, length: 255, alias: Updated by, type: esriFieldTypeString )
• display ( modelName: display, nullable: true, editable: true, defaultValue: null, length: 255, alias: Display Name, type: esriFieldTypeString )
• opstatus ( modelName: opstatus, nullable: true, editable: true, defaultValue: null, length: 255, alias: Operational Status, type: esriFieldTypeString , Coded Values: [InService: In Service] , [OutofService: Out of Service] , [Inventory: Inventory] , ...2 more... )
• lifecyclestatus ( modelName: lifecyclestatus, nullable: true, editable: true, defaultValue: null, length: 255, alias: Lifecycle Status, type: esriFieldTypeString , Coded Values: [Commission: Commission] , [O&M: Operation & Maintenance] , [Planning: Planning] , ...2 more... )
• location ( modelName: location, nullable: true, editable: true, defaultValue: null, length: 255, alias: Location Description, type: esriFieldTypeString )
• address ( modelName: address, nullable: true, editable: true, defaultValue: null, length: 255, alias: Address, type: esriFieldTypeString )
• primaryimage ( modelName: primaryimage, nullable: true, editable: true, defaultValue: null, length: 255, alias: Primary Image, type: esriFieldTypeString )
• condinspscore ( modelName: condinspscore, nullable: true, editable: true, defaultValue: null, alias: Condition Score, type: esriFieldTypeSmallInteger )
• condinspdate ( modelName: condinspdate, nullable: true, editable: true, defaultValue: null, length: 29, alias: Condition Date, type: esriFieldTypeDate )
• warrantydate ( modelName: warrantydate, nullable: true, editable: true, defaultValue: null, length: 29, alias: Warranty Date, type: esriFieldTypeDate )
• installdate ( modelName: installdate, nullable: true, editable: true, defaultValue: null, length: 29, alias: Install Date, type: esriFieldTypeDate )
• installcost ( modelName: installcost, nullable: true, editable: true, defaultValue: null, alias: Install Cost, type: esriFieldTypeDouble )
• expreplacedate ( modelName: expreplacedate, nullable: true, editable: true, defaultValue: null, length: 29, alias: Exp Replace Date, type: esriFieldTypeDate )
• expreplacecost ( modelName: expreplacecost, nullable: true, editable: true, defaultValue: null, alias: Exp Replace Cost, type: esriFieldTypeDouble )
• age ( modelName: age, nullable: true, editable: true, defaultValue: null, alias: Age, type: esriFieldTypeDouble )
• criticality ( modelName: criticality, nullable: true, editable: true, defaultValue: null, length: 255, alias: Criticality, type: esriFieldTypeString , Coded Values: [Critical: Critical Asset] , [NonCritical: NonCritical Asset] )
• ipof ( modelName: ipof, nullable: true, editable: true, defaultValue: null, alias: Failure Probability, type: esriFieldTypeDouble )
• icof ( modelName: icof, nullable: true, editable: true, defaultValue: null, alias: Failure Consequence, type: esriFieldTypeDouble )
• ibre ( modelName: ibre, nullable: true, editable: true, defaultValue: null, alias: Business Risk, type: esriFieldTypeDouble )
• imspu ( modelName: imspu, nullable: true, editable: true, defaultValue: null, alias: Maint Under Perform, type: esriFieldTypeDouble )
• imspo ( modelName: imspo, nullable: true, editable: true, defaultValue: null, alias: Maint Over Perform, type: esriFieldTypeDouble )
• imsr ( modelName: imsr, nullable: true, editable: true, defaultValue: null, alias: Maint Score, type: esriFieldTypeDouble )

Types:

ID: 0
Name: Unknown
Domains:
• associationstatus:
  Inherited
• tiername:
  Inherited
• isconnected:
  Inherited
• issubnetworkcontroller:
  Inherited
• assettype:
  Coded Values: [0: Unknown]
Templates:
• Name: Unknown
  Description:
  Prototype:
  assetgroup: 0
  
  Drawing Tool: esriFeatureEditToolNone

---

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: creationdate
• Creator Field: creator
• Edit Date Field: lastupdate
• Editor Field: updatedby

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

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