Name: Structure_Inspections

Display Field: Inspection_InspectorName

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Inspection_FeatureID (type: esriFieldTypeString, alias: Feature ID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Parent_FeatureID (type: esriFieldTypeString, alias: Parent FeatureID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Parent_ClosestAddress (type: esriFieldTypeString, alias: Closest Address, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Parent_Watershed (type: esriFieldTypeString, alias: Watershed, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Big Creek - Bagley Creek: Big Creek - Bagley Creek], [Big Creek - Long Indian Creek: Big Creek - Long Indian Creek], [Cauley Creek: Cauley Creek], ... 3 more ...)
• Parent_Ownership (type: esriFieldTypeString, alias: Asset Ownership, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [City: City], [Private: Private], [State: State])
• Parent_Maintainer (type: esriFieldTypeString, alias: Maintainer, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [City: City], [EOS Eligible: EOS Eligible], [Private: Private], ... 1 more ...)
• Parent_StructureType (type: esriFieldTypeString, alias: Structure Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Best Management Practice: Best Management Practice], [Box Culvert End: Box Culvert End], [Bridge: Bridge], ... 18 more ...)
• Parent_Outfall (type: esriFieldTypeString, alias: Outfall?, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Not an Outfall: Not an Outfall], [Outfall: Outfall], [Discharge: Discharge], ... 1 more ...)
• Parent_DateConstructed (type: esriFieldTypeDate, alias: Date Originally Constructed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Parent_AgeOfAssetCurrently (type: esriFieldTypeSmallInteger, alias: Age of Asset (years), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Inspection_DateInspected (type: esriFieldTypeDate, alias: Date Inspected, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Inspection_InspectorName (type: esriFieldTypeString, alias: Inspector Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [(Contractor): (Contractor)], [Bailey Monette: Bailey Monette], [Danh Nguyen: Danh Nguyen], ... 10 more ...)
• Inspection_WeatherConditions (type: esriFieldTypeString, alias: Weather Conditions, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true, Coded Values: [Sunny: Sunny], [Cloudy: Cloudy], [Rain: Rain], ... 6 more ...)
• Inspection_InspectionType (type: esriFieldTypeString, alias: Inspection Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Maintenance Inspection: Maintenance Inspection], [Complaint Investigation: Complaint Investigation], [Wet Weather Investigation: Wet Weather Investigation], ... 4 more ...)
• Inspection_InspectionTypeOther (type: esriFieldTypeString, alias: Other Inspection Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Inspection_ConditionScore (type: esriFieldTypeSmallInteger, alias: Condition Score, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [1 - 5])
• Inspection_Condition (type: esriFieldTypeString, alias: Condition, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [(unknown): (unknown)], [Functional: Functional], [Fair: Fair], ... 3 more ...)
• Inspection_SiltationScore (type: esriFieldTypeSmallInteger, alias: Siltation Score, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [1 - 10])
• Inspection_MaintenanceRequired (type: esriFieldTypeSmallInteger, alias: Maintenance Required, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [1 - 5])
• Inspection_ConsequenceOfNoActio (type: esriFieldTypeSmallInteger, alias: Consequence of No Action, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [1 - 5])
• Inspection_RiskOfFailure (type: esriFieldTypeSmallInteger, alias: Risk of Failure, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [1 - 5])
• Inspection_ConsequenceOfFailure (type: esriFieldTypeSmallInteger, alias: Consequence of Failure, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [1 - 5])
• Inspection_Recommendation (type: esriFieldTypeString, alias: Inspection Recommendation(s), SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Inspection_Functional (type: esriFieldTypeString, alias: Functional?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Inspection_ConditionComments (type: esriFieldTypeString, alias: Inspection Condition Comments, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true, Coded Values: [Full of water: Full of water], [Missing grout around pipe: Missing grout around pipe], [Missing manhole cover: Missing manhole cover], ... 9 more ...)
• Inspection_ConditionCommentsOth (type: esriFieldTypeString, alias: Other Inspection Condition Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Inspection_Comments (type: esriFieldTypeString, alias: Inspection Comments, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• Inspection_AssetScore (type: esriFieldTypeDouble, alias: Asset's Maintenance Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Inspection_MgrQC (type: esriFieldTypeDate, alias: Stormwater Mgr. QC Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: Structure_Inspections
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• Inspection_ConditionScore: 1
• Inspection_Condition: Functional
• Inspection_MaintenanceRequired: 1
• Inspection_ConsequenceOfNoActio: 1
• Inspection_RiskOfFailure: 1
• Inspection_ConsequenceOfFailure: 1
• Inspection_Functional: Yes

Relationships:

• (0) -- Related To: Structures (1)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/24/2026 8:04:50 PM

Schema Last Edit Date: 4/24/2026 8:04:50 PM

Data Last Edit Date: 4/24/2026 8:04:50 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Query Attachments   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat