Name: SewerManholeInspection

Display Field: condition

Type: Table

Description: The Sewer Manhole Inspection Table holds related Inspection info generated from Maximo.

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

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: 8, nullable: false, editable: false)
• wonum (type: esriFieldTypeString, alias: Work Order Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• inspector (type: esriFieldTypeString, alias: Inspector, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• inspectdt (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• inspectpurp (type: esriFieldTypeSmallInteger, alias: Inspection Purpose, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Maintenance Required], [2: I&I Investigation], ... 6 more ...)
• precleaning (type: esriFieldTypeSmallInteger, alias: Pre-Cleaning, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Jetting], [2: Heavy Cleaning], ... 1 more ...)
• precleaningdt (type: esriFieldTypeDate, alias: Pre-Cleaning Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• weather (type: esriFieldTypeSmallInteger, alias: Weather, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Very Dry], [2: Dry], ... 5 more ...)
• runoff (type: esriFieldTypeSmallInteger, alias: Runoff Potential, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Sheeting], [2: Pounding], ... 1 more ...)
• inspectionstatus (type: esriFieldTypeSmallInteger, alias: Inspection Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Surface Inspection], [2: Descent Inspection], ... 7 more ...)
• evidsurcharge (type: esriFieldTypeSmallInteger, alias: Evidence of Surcharge, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
• coverfit (type: esriFieldTypeSmallInteger, alias: Cover Fit, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Oversized], [2: Undersized], ... 2 more ...)
• covercondition (type: esriFieldTypeSmallInteger, alias: Cover Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Sound], [2: Cracked], ... 4 more ...)
• coverinsertcondition (type: esriFieldTypeSmallInteger, alias: Cover Insert Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Sound], [2: Poorly Fitting], ... 4 more ...)
• coverringcondition (type: esriFieldTypeSmallInteger, alias: Cover Ring Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Sound], [2: Cracked], ... 4 more ...)
• framecondition (type: esriFieldTypeSmallInteger, alias: Frame Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Sound], [2: Cracked], ... 4 more ...)
• framesealcondition (type: esriFieldTypeSmallInteger, alias: Frame Seal Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Sound], [2: Cracked], ... 2 more ...)
• framesealinflow (type: esriFieldTypeSmallInteger, alias: Evidence of Frame Seal Inflow, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: None], [2: Stains], ... 5 more ...)
• highgas (type: esriFieldTypeSmallInteger, alias: High Gas, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
• notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• editdate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• condition (type: esriFieldTypeSmallInteger, alias: Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Excellent], [2: Very Good], ... 4 more ...)
• assetguid (type: esriFieldTypeGUID, alias: Asset Guid, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: SewerManholeInspection
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• Get Sewer Manhole Vault (0) -- Related To: SewerManholeVault (900209)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/17/2026 10:02:11 PM

Schema Last Edit Date: 1/17/2026 10:02:11 PM

Data Last Edit Date: 1/17/2026 9:59:47 PM

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