Name: CulvertInspections

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: InspectionDate, length: 8 )
• 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: PW.Stormwater.InspectRef, length: 15 )
• ApproachRoad ( type: esriFieldTypeSmallInteger, alias: ApproachRoadwayCondition , Coded Values: [1: Very Good] , [2: Good] , [3: Fair] , ...2 more... )
• Embankment ( type: esriFieldTypeSmallInteger, alias: EmbankmentCondition , Coded Values: [1: Very Good] , [2: Good] , [3: Fair] , ...2 more... )
• Channel ( type: esriFieldTypeSmallInteger, alias: ChannelCondition , Coded Values: [1: Very Good] , [2: Good] , [3: Fair] , ...2 more... )
• EndTreatment ( type: esriFieldTypeSmallInteger, alias: EndTreatmentCondition , Coded Values: [1: Very Good] , [2: Good] , [3: Fair] , ...2 more... )
• Footing ( type: esriFieldTypeSmallInteger, alias: ConcreteSlabFootingCondition , Coded Values: [1: Very Good] , [2: Good] , [3: Fair] , ...2 more... )
• Barrel ( type: esriFieldTypeSmallInteger, alias: BarrelAlignmentCondition , Coded Values: [1: Very Good] , [2: Good] , [3: Fair] , ...2 more... )
• AquaticOrganism ( type: esriFieldTypeSmallInteger, alias: AquaticOrganismPassage , Coded Values: [1: Very Good] , [2: Good] , [3: Fair] , ...2 more... )
• CulvertRating ( type: esriFieldTypeSmallInteger, alias: CulvertRating , Coded Values: [1: 1 or fewer indicators fair and no indicators poor or failing] , [2: 3 or fewer indicators fair and no indicators poor or failing] , [3: 4 or fewer indicators fair amd 1 or fewer indicators poor, no indicators failing] , ...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:

• swCulvert (4) -- Related To: Culverts (5)

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

  Iteminfo   Thumbnail   Metadata