Name: Manhole_Inspection

Display Field: Location

Type: Table

Has Views: true

Source Schema Changes Allowed: true

Views

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)
• DateofInspection (type: esriFieldTypeDate, alias: Date of Inspection, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• ManholeID (type: esriFieldTypeString, alias: Manhole ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• SurfaceCover (type: esriFieldTypeString, alias: Surface Cover, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true, Coded Values: [Asphalt: Asphalt], [Brick: Brick], [Concrete: Concrete], ... 3 more ...)
• GradetoManhole (type: esriFieldTypeString, alias: Grade to Manhole, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [Flush: Flush], [Above: Above Grade], [Below: Below Grade])
• CoverDiam (type: esriFieldTypeDouble, alias: Cover Diameter (in), SQL Type: sqlTypeOther, nullable: true, editable: true)
• CoverCond (type: esriFieldTypeString, alias: Cover Condition, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Good: Good], [Fair: Fair], [Poor: Poor])
• CastingConditon (type: esriFieldTypeString, alias: Casting Condition, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Good: Good], [Fair: Fair], [Poor: Poor])
• NumRiserRing (type: esriFieldTypeSmallInteger, alias: Number of Riser Rings, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RiserRingAlign (type: esriFieldTypeString, alias: Alignment of Riser Rings, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Excellent: Excellent], [Very Good: Very Good], [Good: Good], ... 4 more ...)
• WallMaterial (type: esriFieldTypeString, alias: Wall Material, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [ABS: ABS Plastic], [AC: Asbestos Cement], [ASP: Asphalt], ... 33 more ...)
• BarrelCond (type: esriFieldTypeString, alias: Barrel Condition, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Good: Good], [Fair: Fair], [Poor: Poor])
• StepMaterial (type: esriFieldTypeString, alias: Step Material, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Re-Rod: Re-Rod], [Cast: Cast], [ReinforcedPlastic: Reinforced Plastic], ... 5 more ...)
• StepCondition (type: esriFieldTypeString, alias: Step Condition, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Good: Good], [Fair: Fair], [Poor: Poor])
• MHBenchCond (type: esriFieldTypeString, alias: Bench Condtion, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Good: Good], [Fair: Fair], [Poor: Poor])
• MHChannelCond (type: esriFieldTypeString, alias: Channel Condition, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Good: Good], [Fair: Fair], [Poor: Poor])
• DropManhole (type: esriFieldTypeString, alias: Drop Manhole, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• TypeofDrop (type: esriFieldTypeString, alias: Type of Drop, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true, Coded Values: [Inside: Inside Drop], [Outside: Outside Drop])
• InfilitrationCast (type: esriFieldTypeString, alias: Infiltration @ Casting, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• InfiltrationChimney (type: esriFieldTypeString, alias: Infiltration @ Chimney, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• InfiltrationCone (type: esriFieldTypeString, alias: Infiltration @ Cone, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• InfiltrationBarrel (type: esriFieldTypeString, alias: Infiltration @ Barrel, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• InfiltrationBenchChannel (type: esriFieldTypeString, alias: Infiltration @ Bench/Channel, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Notes (type: esriFieldTypeString, alias: Inspection Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• 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)
• ChimneyCond (type: esriFieldTypeString, alias: Chimney Condition, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Good: Good], [Fair: Fair], [Poor: Poor])
• ConeCond (type: esriFieldTypeString, alias: Cone Condition, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Good: Good], [Fair: Fair], [Poor: Poor])
• StructureCond (type: esriFieldTypeString, alias: Structure Condition, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Excellent: Excellent], [Very Good: Very Good], [Good: Good], ... 4 more ...)
• MHGUID (type: esriFieldTypeGUID, alias: MH GUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)

Templates:

Name: Manhole_Inspection
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• ssManhole (0) -- Related To: ssManhole (9)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/16/2025 8:03:30 PM

Schema Last Edit Date: 8/4/2023 3:38:13 PM

Data Last Edit Date: 5/16/2025 8:03:30 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