Name: Manhole Inspection Form

Display Field: Uniq_ID

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: false
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Uniq_ID ( type: esriFieldTypeString, alias: Manhole Number, length: 7 , Coded Values: [SMH001: SMH001] , [SMH002: SMH002] , [SMH003: SMH003] , ...518 more... )
• Location ( type: esriFieldTypeString, alias: Location, length: 255 )
• Date ( type: esriFieldTypeDate, alias: Date, length: 8 )
• Time ( type: esriFieldTypeDate, alias: Time, length: 8 )
• Inspector ( type: esriFieldTypeString, alias: Inspector, length: 255 )
• Weather ( type: esriFieldTypeString, alias: Weather, length: 255 )
• Buried ( type: esriFieldTypeString, alias: Buried, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• DepthBuried ( type: esriFieldTypeDouble, alias: Depth Buried (in) )
• CoverType ( type: esriFieldTypeString, alias: Cover Type, length: 255 , Coded Values: [Round: Round] , [Square: Square (Silent Night)] )
• NoOfHolesCover ( type: esriFieldTypeDouble, alias: Number of Holes in Cover )
• NoOfHolesCoverDia ( type: esriFieldTypeDouble, alias: Number of Holes in Cover Diameter (in) )
• ConditionOfCover ( type: esriFieldTypeString, alias: Condition Of Cover, length: 255 , Coded Values: [Good: Good] , [Fair: Fair] , [Poor: Poor] )
• ConditionOfCoverCom ( type: esriFieldTypeString, alias: Condition Of Cover Comments, length: 255 )
• ConditionOfFrame ( type: esriFieldTypeString, alias: Condition Of Frame, length: 255 , Coded Values: [Good: Good] , [Fair: Fair] , [Poor: Poor] )
• ConditionOfFramCom ( type: esriFieldTypeString, alias: Condition Of Frame Comments, length: 255 )
• Ladder ( type: esriFieldTypeString, alias: Ladder, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• GradeRingRep ( type: esriFieldTypeString, alias: Grade Ring Repairs Required, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• GradeRingRepCom ( type: esriFieldTypeString, alias: Grade Ring Repairs Comments, length: 255 )
• MHRingRep ( type: esriFieldTypeString, alias: Manhole Ring Repairs Required, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• BenchingRep ( type: esriFieldTypeString, alias: Benching Repairs Required, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• PondLeakTTofCov ( type: esriFieldTypeString, alias: Ponding or Leaking Through Top Cover, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• PondLeakTTofCovCom ( type: esriFieldTypeString, alias: Ponding or Leaking Through Top Cover Comments, length: 255 )
• GradeRingLeak ( type: esriFieldTypeString, alias: Grade Rings Leaking, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• GradeRingLeakCom ( type: esriFieldTypeString, alias: Grade Rings Leaking Comments, length: 255 )
• JointsBetRingLeak ( type: esriFieldTypeString, alias: Joints Between Rings Leaking, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• JointsBetRingLeakCom ( type: esriFieldTypeString, alias: Joints Between Rings Leaking Comments, length: 255 )
• LiftHoleLeak ( type: esriFieldTypeString, alias: Lift Holes Leaking, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• LiftHoleLeakCom ( type: esriFieldTypeString, alias: Lift Holes Leaking Comments, length: 255 )
• LeakAroundSewer ( type: esriFieldTypeString, alias: Leak Around Sewer, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• LeakAroundSewerCom ( type: esriFieldTypeString, alias: Leak Around Sewer Comments, length: 255 )
• OtherLeak ( type: esriFieldTypeString, alias: Other Leakage, length: 255 )
• HighWaterMarks ( type: esriFieldTypeString, alias: High Water Marks, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• HighWaterMarksHtAboveSewer ( type: esriFieldTypeDouble, alias: High Water Marks Height (in) Above Sewer )
• MNRequireClean ( type: esriFieldTypeString, alias: Manhole Requires Cleaning, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• MNRequireCleanCom ( type: esriFieldTypeString, alias: Manhole Requires Cleaning Comments, length: 255 )
• ServiceConIntoMH ( type: esriFieldTypeString, alias: Service Connection Into Manhole, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• ServiceConIntoMHNum ( type: esriFieldTypeDouble, alias: Service Connection Into Manhole Number )
• InvertDepth1 ( type: esriFieldTypeDouble, alias: Invert Depth 1 (in) )
• InvertDepth2 ( type: esriFieldTypeDouble, alias: Invert Depth 2 (in) )
• InvertDepth3 ( type: esriFieldTypeDouble, alias: Invert Depth 3 (in) )
• InvertDepth4 ( type: esriFieldTypeDouble, alias: Invert Depth 4 (in) )
• Flow ( type: esriFieldTypeString, alias: Flow, length: 255 , Coded Values: [Full: Full] , [3/4: 3/4] , [1/2: 1/2] , ...3 more... )
• MHDia ( type: esriFieldTypeString, alias: Manhole Diameter (mm), length: 255 , Coded Values: [1050: 1050mm (42")] , [1200: 1200mm (48")] , [1500: 1500mm (60")] , ...3 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• ServiceConIntoMHCom ( type: esriFieldTypeString, alias: Service Connections Into Manhole Comments, length: 255 )
• MHRingRepCom ( type: esriFieldTypeString, alias: Manhole Ring Repairs Comments, length: 255 )
• BenchingRepCom ( type: esriFieldTypeString, alias: Benching Repairs Comments, length: 255 )

Relationships:

• DBO.SanitaryMaintenanceHole_Municipal_MODC (0) -- Related To: SanitaryMaintenanceHole_Municipal_MODC (10)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata