Name: Manhole Inspection

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)
• 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: Purpose of Inspection, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Maintenance Related], [2: Infiltration/Inflow Investigation], ... 7 more ...)
• precleaning (type: esriFieldTypeSmallInteger, alias: Pre-Cleaning, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Heavy Cleaning], [2: Jetting ], ... 1 more ...)
• precleaningdate (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: Dry], [2: Light Rain], ... 2 more ...)
• runoff (type: esriFieldTypeSmallInteger, alias: Runoff Potential, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Inundated], [2: Ponding], [3: Sheeting], ... 1 more ...)
• inspectionstatus (type: esriFieldTypeSmallInteger, alias: Inspection Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Buried or Marked], [2: Descent Inspection], [3: Not Inspected due to Traffic], ... 6 more ...)
• evidsurcharge (type: esriFieldTypeSmallInteger, alias: Evidence of Surchage, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
• coverfit (type: esriFieldTypeSmallInteger, alias: Cover Fit, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Good], [2: Oversized], [3: Rocks/Wobbles], ... 1 more ...)
• covercondition (type: esriFieldTypeSmallInteger, alias: Cover Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Bolts Missing], [2: Broken], [3: Corroded/Pitted], ... 3 more ...)
• coverinsertcondition (type: esriFieldTypeSmallInteger, alias: Cover Insert Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Cracked/Torn/Holes], [2: Insert Fell], [3: Leaking], ... 2 more ...)
• coverringcondition (type: esriFieldTypeSmallInteger, alias: Cover Ring Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Broken], [2: Corroded/Pitted/Worn], [3: Cracked], ... 2 more ...)
• framecondition (type: esriFieldTypeSmallInteger, alias: Frame Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Broken], [2: Coated], [3: Corroded/Pitted/Worn], ... 3 more ...)
• framesealcondition (type: esriFieldTypeSmallInteger, alias: Frame Seal Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Cracked ], [2: Loose/Not Attached], [3: Offset], ... 1 more ...)
• framesealinflow (type: esriFieldTypeSmallInteger, alias: Evidence of Frame Seal Inflow, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
• notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• 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)
• created_date (type: esriFieldTypeDate, alias: Creation date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• created_user (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: Last update, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: Updated by, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)

Templates:

Name: Manhole Inspection
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• Manhole (0) -- Related To: Manhole (900208)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/13/2025 5:55:27 PM

Schema Last Edit Date: 2/11/2025 4:21:13 PM

Data Last Edit Date: 2/11/2025 4:21:13 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