Name: Structure Inspections

Display Field: INSPECTOR

Type: Table

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)
• INSPECTED_DATE (type: esriFieldTypeDate, alias: Inspected Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• INSPECTOR (type: esriFieldTypeString, alias: Inspector's Name, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Bill Egan: Bill Egan], [Bob Gieseke: Bob Gieseke], [Brian Theis: Brian Theis], ... 25 more ...)
• COVERFRAME_CONDITION (type: esriFieldTypeString, alias: Coverframe Condition, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Satisfactory: Satisfactory], [Unsatisfactory: Unsatisfactory])
• DEBRIS_CONDITION (type: esriFieldTypeString, alias: Debris Condition, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Satisfactory: Satisfactory], [Unsatisfactory: Unsatisfactory])
• EROSION_CONDITION (type: esriFieldTypeString, alias: Erosion Condition, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Satisfactory: Satisfactory], [Unsatisfactory: Unsatisfactory])
• RINGS_CONDITION (type: esriFieldTypeString, alias: Rings Condition, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Satisfactory: Satisfactory], [Unsatisfactory: Unsatisfactory])
• RIPRAP_CONDITION (type: esriFieldTypeString, alias: Riprap Condition, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Satisfactory: Satisfactory], [Unsatisfactory: Unsatisfactory])
• SERVICEABILITY (type: esriFieldTypeString, alias: Serviceability, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Satisfactory: Satisfactory], [Unsatisfactory: Unsatisfactory])
• STEPS_CONDITION (type: esriFieldTypeString, alias: Steps Condition, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Satisfactory: Satisfactory], [Unsatisfactory: Unsatisfactory])
• STRUCTURAL_CONDITION (type: esriFieldTypeString, alias: Structural Condition, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Satisfactory: Satisfactory], [Unsatisfactory: Unsatisfactory])
• TRASH (type: esriFieldTypeString, alias: Trash, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Satisfactory: Satisfactory], [Unsatisfactory: Unsatisfactory])
• OTHER (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Satisfactory: Satisfactory], [Unsatisfactory: Unsatisfactory])
• NOTES (type: esriFieldTypeString, alias: Inspection Notes, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• REPAIRED_DATE (type: esriFieldTypeDate, alias: Repaired Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• REPAIR_NOTES (type: esriFieldTypeString, alias: Repair Notes, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• SUMP_BASKET (type: esriFieldTypeString, alias: Sump Basket, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• MAINT_NEEDED (type: esriFieldTypeString, alias: Maintenance Needed, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Reconstruct: Reconstruct], [Tuck Point: Tuck Point], [Missing Manhole: Missing Manhole], ... 11 more ...)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• swStructureGUID (type: esriFieldTypeGUID, alias: swStructureGUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• REPAIR_COMPLETED (type: esriFieldTypeString, alias: Repair Completed, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Barrel Fixed: Barrel Fixed], [Casting Fixed / Replaced Cover: Casting Fixed / Replaced Cover], [Erosion Fixed: Erosion Fixed], ... 10 more ...)
• FLEXSEAL (type: esriFieldTypeString, alias: Flex Seal, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• MAINBY (type: esriFieldTypeString, alias: Repaired By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Bill Egan: Bill Egan], [Bob Gieseke: Bob Gieseke], [Brian Theis: Brian Theis], ... 25 more ...)
• MAINPERF (type: esriFieldTypeString, alias: Repair Performed, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Barrel Fixed: Barrel Fixed], [Casting Fixed / Replaced Cover: Casting Fixed / Replaced Cover], [Erosion Fixed: Erosion Fixed], ... 10 more ...)
• PASSFAIL (type: esriFieldTypeString, alias: PASS / FAIL, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Pass: Pass], [Fail: Fail])

Templates:

Name: Structure Inspections
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• COVERFRAME_CONDITION: Satisfactory
• DEBRIS_CONDITION: Satisfactory
• EROSION_CONDITION: Satisfactory
• RINGS_CONDITION: Satisfactory
• RIPRAP_CONDITION: Satisfactory
• SERVICEABILITY: Satisfactory
• STEPS_CONDITION: Satisfactory
• STRUCTURAL_CONDITION: Satisfactory
• TRASH: Satisfactory
• OTHER: Satisfactory

Relationships:

• swManhole (2) -- Related To: Storm Manholes (3)
• swInlet (1) -- Related To: Storm Inlets (2)
• swDischargePoint (0) -- Related To: Storm Discharge Points (1)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/21/2025 2:26:34 PM

Schema Last Edit Date: 10/21/2025 2:26:34 PM

Data Last Edit Date: 10/21/2025 2:26:34 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