Name: InletInspections

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] )
• InspYear ( type: esriFieldTypeString, alias: InspectionYear, length: 4 , Coded Values: [2022: 2022] , [2023: 2023] , [2024: 2024] , ...6 more... )
• InspDate ( type: esriFieldTypeDate, alias: InspectionDate, length: 8 )
• 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... )
• InspectType ( type: esriFieldTypeString, alias: InspectionType, length: 10 , Coded Values: [Initial: Initial] , [Routine: Routine] , [Special: Special] , ...2 more... )
• InspTypeCamera ( type: esriFieldTypeString, alias: InspTypeCamera, length: 10 , Coded Values: [CCTV: CCTV] , [Pole: Pole] , [Visual: Visual] , ...1 more... )
• InspRef ( type: esriFieldTypeString, alias: InspectionReference, length: 15 , Coded Values: [AASHTO: AASHTO] , [NCDOT: NCDOT MCAP] , [NASSCO PACP: NASSCO PACP] , ...2 more... )
• Blocked50Pct ( type: esriFieldTypeString, alias: Blocked50PctOrMore, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• ErosionThreshold ( type: esriFieldTypeString, alias: ErosionGT6inWithin1ftOfInlet, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• Condition ( type: esriFieldTypeSmallInteger, alias: ConditionRating , Coded Values: [1: No Damage, Like New] , [2: Minimal Damage, Small Chips and Some Weathering] , [3: Some Damage (e.g., Concrete Mortar and Cracking)] , ...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... )
• Notes ( type: esriFieldTypeString, alias: Notes, length: 250 )
• 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:

• swInlet (0) -- Related To: Inlets (0)

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

  Iteminfo   Thumbnail   Metadata