Name: PipeInspections

Display Field: FacilityID

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• FacilityID ( type: esriFieldTypeString, alias: FacilityID, length: 20 )
• ReviewFlag ( type: esriFieldTypeSmallInteger, alias: ReviewFlag , Coded Values: [1: True] , [0: False] )
• InspDate ( type: esriFieldTypeDate, alias: InspDate, length: 8 )
• Notes ( type: esriFieldTypeString, alias: Notes, length: 250 )
• InspYear ( type: esriFieldTypeString, alias: InspectionYear, length: 4 , Coded Values: [2022: 2022] , [2023: 2023] , [2024: 2024] , ...6 more... )
• InspBy ( type: esriFieldTypeString, alias: InspectedBy, length: 20 , Coded Values: [TOC: TOC Staff] , [Sungate: Sungate] , [Contractor: Contractor] , ...1 more... )
• Inspector ( type: esriFieldTypeString, alias: LeadInspector, length: 3 , Coded Values: [RD: Randy Dodd] , [HH: Heather Holley] , [DS: Deborah Shoffner] , ...9 more... )
• InspType ( type: esriFieldTypeString, alias: InspectionType, length: 10 , Coded Values: [Initial: Initial] , [Routine: Routine] , [Special: Special] , ...2 more... )
• InspRef ( type: esriFieldTypeString, alias: InspectionReference, length: 15 , Coded Values: [AASHTO: AASHTO] , [NCDOT: NCDOT MCAP] , [NASSCO PACP: NASSCO PACP] , ...2 more... )
• StructureCondition ( type: esriFieldTypeString, alias: StructuralCondition, length: 10 , Coded Values: [Crack: Crack] , [Hole: Hole] , [Deformed: Deformed] , ...4 more... )
• Defects ( type: esriFieldTypeString, alias: Defects, length: 20 , Coded Values: [Deposits: Deposits] , [Roots: Roots] , [Obstruction: Obstruction] , ...3 more... )
• Condition ( type: esriFieldTypeSmallInteger, alias: ConditionRating , Coded Values: [1: Very Good] , [2: Good] , [3: Fair] , ...2 more... )
• MaintRequired ( type: esriFieldTypeSmallInteger, alias: MaintenancePriority , Coded Values: [1: None Required] , [2: Maintenance Required for Debris] , [4: Both Maintenance and Repair Required] , ...2 more... )
• NextAction ( type: esriFieldTypeString, alias: DoNext, length: 10 , Coded Values: [Inspect: Inspect] , [Reinspect: Reinspect] , [Clean: Clean] , ...6 more... )
• RelateID ( type: esriFieldTypeGUID, alias: RelateID, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )

Relationships:

• swGravityMain (3) -- Related To: Pipes (4)

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

  Iteminfo   Thumbnail   Metadata