Name: Linear Treatment Inspections

Display Field: ReviewerName

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 02d09fe5f6794803b3449ba1df1d8162

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: 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: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
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: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• InspectionDate ( type: esriFieldTypeDate, alias: InspectionDate, length: 8 )
• PrimaryInspector ( type: esriFieldTypeString, alias: PrimaryInspector, length: 50 , Coded Values: [Robert Potts: Robert Potts] , [Andrew Allan: Andrew Allan] , [Craig Eudell: Craig Eudell] , ...12 more... )
• SecondaryInspector ( type: esriFieldTypeString, alias: SecondaryInspector, length: 50 , Coded Values: [Robert Potts: Robert Potts] , [Andrew Allan: Andrew Allan] , [Craig Eudell: Craig Eudell] , ...12 more... )
• InspectionType ( type: esriFieldTypeString, alias: InspectionType, length: 50 , Coded Values: [Routine: Routine] , [Annual: Annual] , [Return - Field Inspection: Return - Field Inspection] , ...1 more... )
• DateLastPrecipitation ( type: esriFieldTypeDate, alias: DateLastPrecipitation, length: 8 )
• QuantityLastPrecipitation ( type: esriFieldTypeDouble, alias: QuantityLastPrecipitation )
• AestheticsCondition ( type: esriFieldTypeString, alias: AestheticsCondition, length: 50 , Coded Values: [Good: Good] , [Fair: Fair] , [Poor: Poor] , ...1 more... )
• AestheticsComments ( type: esriFieldTypeString, alias: AestheticsComments, length: 1073741822 )
• HydraulicRecoveryCondition ( type: esriFieldTypeString, alias: HydraulicRecoveryCondition, length: 50 , Coded Values: [Good: Good] , [Fair: Fair] , [Poor: Poor] , ...1 more... )
• HydraulicRecoveryComments ( type: esriFieldTypeString, alias: HydraulicRecoveryComments, length: 1073741822 )
• VegetationCondition ( type: esriFieldTypeString, alias: VegetationCondition, length: 50 , Coded Values: [Good: Good] , [Fair: Fair] , [Poor: Poor] , ...1 more... )
• VegetationComments ( type: esriFieldTypeString, alias: VegetationComments, length: 1073741822 )
• StructuralCondition ( type: esriFieldTypeString, alias: StructuralCondition, length: 50 , Coded Values: [Good: Good] , [Fair: Fair] , [Poor: Poor] , ...1 more... )
• StructuralComments ( type: esriFieldTypeString, alias: StructuralComments, length: 1073741822 )
• WaterCondition ( type: esriFieldTypeString, alias: WaterCondition, length: 50 , Coded Values: [Good: Good] , [Fair: Fair] , [Poor: Poor] , ...1 more... )
• WaterComments ( type: esriFieldTypeString, alias: WaterComments, length: 1073741822 )
• ErosionCondition ( type: esriFieldTypeString, alias: ErosionCondition, length: 50 , Coded Values: [Good: Good] , [Fair: Fair] , [Poor: Poor] , ...1 more... )
• ErosionComments ( type: esriFieldTypeString, alias: ErosionComments, length: 1073741822 )
• OverallPondCondition ( type: esriFieldTypeString, alias: OverallPondCondition, length: 50 , Coded Values: [Good: Good] , [Fair: Fair] , [Poor: Poor] , ...1 more... )
• OverallPondComments ( type: esriFieldTypeString, alias: OverallPondComments, length: 1073741822 )
• PublicSafetyHazards ( type: esriFieldTypeString, alias: PublicSafetyHazards, length: 4 , Coded Values: [Yes: Yes] , [No: No] )
• PublicSafetyComments ( type: esriFieldTypeString, alias: PublicSafetyComments, length: 1073741822 )
• SuspectedIDDE ( type: esriFieldTypeString, alias: SuspectedIDDE, length: 4 , Coded Values: [Yes: Yes] , [No: No] )
• SuspectedIDDEComments ( type: esriFieldTypeString, alias: SuspectedIDDEComments, length: 1073741822 )
• InspectionResult ( type: esriFieldTypeString, alias: InspectionResult, length: 50 , Coded Values: [Performing as designed and permitted: Performing as designed and permitted] , [Not performing as designed and permitted: Not performing as designed and permitted] , [Not Applicable: Not Applicable] )
• InspectionResultComments ( type: esriFieldTypeString, alias: InspectionResultComments, length: 1073741822 )
• ReviewerName ( type: esriFieldTypeString, alias: ReviewerName, length: 50 )
• ReviewDate ( type: esriFieldTypeDate, alias: ReviewDate, length: 8 )
• QAStatus ( type: esriFieldTypeString, alias: QAStatus, length: 20 , Coded Values: [Passed: Passed] , [Requires Edits: Requires Edits] )
• QAComments ( type: esriFieldTypeString, alias: QAComments, length: 1073741822 )
• InspectionReviewNeeded ( type: esriFieldTypeString, alias: InspectionReviewNeeded, length: 4 )
• MaintenanceReviewNeeded ( type: esriFieldTypeString, alias: MaintenanceReviewNeeded, length: 4 )
• Report ( type: esriFieldTypeString, alias: Report, length: 1073741822 )
• Created_User ( type: esriFieldTypeString, alias: Created_User, length: 255 )
• Created_Date ( type: esriFieldTypeDate, alias: Created_Date, length: 8 )
• Last_Editor ( type: esriFieldTypeString, alias: Last_Editor, length: 255 )
• Last_Edited_Date ( type: esriFieldTypeDate, alias: Last_Edited_Date, length: 8 )
• MaintenanceRequired ( type: esriFieldTypeString, alias: MaintenanceRequired, length: 4 )
• OrigParentGUIDText ( type: esriFieldTypeString, alias: OrigParentGUIDText, length: 1073741822 )
• OrigInspectionGUIDText ( type: esriFieldTypeString, alias: OrigInspectionGUIDText, length: 1073741822 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• ParentGUID ( type: esriFieldTypeGUID, alias: ParentGUID, length: 38 )

Relationships:

• D5LTreatmentMaintenanceNeeds (6) -- Related To: Linear Treatment Maintenance Needs (9)
• D5LinearTreatment (3) -- Related To: Linear Treatment (4)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata