Name: TubeCondition

Display Field: InfiltrationDesc

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 9d1245fb8e0941acb6508ae15532b6c7

Copyright Text:

Default Visibility: false

MaxRecordCount: 9000

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: 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: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• DamageCode ( type: esriFieldTypeInteger, alias: Damage, editable: true, nullable: true, defaultValue: null, modelName: DamageCode , Coded Values: [0: None] , [1: Mild] , [2: Moderate] , ...2 more... )
• CrushedCode ( type: esriFieldTypeInteger, alias: Crushed, editable: true, nullable: true, defaultValue: null, modelName: CrushedCode , Coded Values: [0: None] , [1: Mild] , [2: Moderate] , ...2 more... )
• PluggedCode ( type: esriFieldTypeInteger, alias: Plugged, editable: true, nullable: true, defaultValue: null, modelName: PluggedCode , Coded Values: [0: None] , [1: Less than 25%] , [2: 25-50%] , ...4 more... )
• InfiltrationDesc ( type: esriFieldTypeString, alias: Infiltration Description, editable: true, nullable: true, length: 30, defaultValue: null, modelName: InfiltrationDesc )
• TubeSeparatedCode ( type: esriFieldTypeInteger, alias: Joint Separated Severity, editable: true, nullable: true, defaultValue: null, modelName: TubeSeparatedCode , Coded Values: [0: None] , [1: Mild] , [2: Moderate] , ...2 more... )
• TubeSeparatedDesc ( type: esriFieldTypeString, alias: Joint Separated Location, editable: true, nullable: true, length: 30, defaultValue: null, modelName: TubeSeparatedDesc )
• RoadwayStressCode ( type: esriFieldTypeInteger, alias: Roadway Stress, editable: true, nullable: true, defaultValue: null, modelName: RoadwayStressCode , Coded Values: [0: No] , [1: Yes] , [2: Unknown] )
• RoadwayVoidCode ( type: esriFieldTypeInteger, alias: Roadway Void, editable: true, nullable: true, defaultValue: null, modelName: RoadwayVoidCode , Coded Values: [0: No] , [1: Yes] , [2: Unknown] )
• MisalignmentCode ( type: esriFieldTypeInteger, alias: Misalignment, editable: true, nullable: true, defaultValue: null, modelName: MisalignmentCode , Coded Values: [0: None] , [1: Mild] , [2: Moderate] , ...2 more... )
• PipingCode ( type: esriFieldTypeInteger, alias: Piping, editable: true, nullable: true, defaultValue: null, modelName: PipingCode , Coded Values: [0: None] , [1: Mild] , [2: Moderate] , ...2 more... )
• MaterialDistressCode ( type: esriFieldTypeInteger, alias: Material Distress, editable: true, nullable: true, defaultValue: null, modelName: MaterialDistressCode , Coded Values: [0: None] , [1: Mild] , [2: Moderate] , ...2 more... )
• WaterLevelCode ( type: esriFieldTypeInteger, alias: Water Level, editable: true, nullable: true, defaultValue: null, modelName: WaterLevelCode , Coded Values: [0: None] , [1: Below Culvert] , [2: Culvert Partly Filled] , ...2 more... )
• CommentDesc ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 500, defaultValue: null, modelName: CommentDesc )
• TubeGuid ( type: esriFieldTypeGUID, alias: TubeGuid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: TubeGuid )
• CreateDate ( type: esriFieldTypeDate, alias: CreateDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreateDate )
• CreateUser ( type: esriFieldTypeString, alias: CreateUser, editable: false, nullable: true, length: 50, defaultValue: null, modelName: CreateUser )
• LastUpdateDate ( type: esriFieldTypeDate, alias: LastUpdateDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LastUpdateDate )
• LastUpdateUser ( type: esriFieldTypeString, alias: LastUpdateUser, editable: false, nullable: true, length: 50, defaultValue: null, modelName: LastUpdateUser )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• TubeGlobalID ( type: esriFieldTypeGUID, alias: TubeGlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: TubeGlobalID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )

Templates:

• Name: TubeCondition
  Description:
  Prototype:
  TubeGlobalID: null
  DamageCode: null
  CrushedCode: null
  PluggedCode: null
  InfiltrationDesc: null
  TubeSeparatedCode: null
  TubeSeparatedDesc: null
  RoadwayStressCode: null
  RoadwayVoidCode: null
  MisalignmentCode: null
  PipingCode: null
  MaterialDistressCode: null
  WaterLevelCode: null
  CommentDesc: null
  TubeGuid: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• ConditionBelongsToTube (4) -- Related To: CulvertTube (2)

Capabilities: Query,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: CreateDate
• Creator Field: CreateUser
• Edit Date Field: LastUpdateDate
• Editor Field: LastUpdateUser

Supports Query With Historic Moment: true

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata