Name: Manhole Inspection

Display Field: FACILITYID

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

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: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility ID, length: 10 )
• STARTDATETIME ( type: esriFieldTypeDate, alias: Start Date Time, length: 8 )
• WORKKEY ( type: esriFieldTypeString, alias: Work Order #, length: 50 )
• PURPOSE ( type: esriFieldTypeString, alias: Purpose of Inspection, length: 50 , Coded Values: [Inflitration/Inflow Investigation: Inflitration/Inflow Investigation] , [Post Rehabilitation Survey: Post Rehabilitation Survey] , [Pre-Rehabilitation Survey: Pre-Rehabilitation Survey] , ...6 more... )
• GROUNDCONDITION ( type: esriFieldTypeString, alias: Ground Condition, length: 10 , Coded Values: [Damp: Damp] , [Dry: Dry] , [Heavy Rain: Heavy Rain] , ...3 more... )
• MANHOLELOCATION ( type: esriFieldTypeString, alias: Manhole Location, length: 50 , Coded Values: [Main Highway - Urban: Main Highway - Urban] , [Main Highway - Suburban/Rural: Main Highway - Suburban/Rural] , [Light Highway: Light Highway] , ...13 more... )
• SURFACETYPE ( type: esriFieldTypeString, alias: Surface Type, length: 50 , Coded Values: [Asphalt: Asphalt] , [Concrete Collar: Concrete Collar] , [Grass/Dirt: Grass/Dirt] , ...4 more... )
• RUNOFF ( type: esriFieldTypeString, alias: Potential for Runoff, length: 50 , Coded Values: [Inundated: Inundated] , [None: None] , [Ponding: Ponding] , ...1 more... )
• INSSTATUS ( type: esriFieldTypeString, alias: Inspection Status, length: 50 , Coded Values: [Buried or Marked: Buried or Marked] , [In Traffic: In Traffic] , [No Access No Found: No Access No Found] , ...5 more... )
• MHSURFALIGN ( type: esriFieldTypeString, alias: Manhole Even with Surface, length: 50 , Coded Values: [Even: Even] , [Above: Above] , [Below: Below] , ...1 more... )
• MHHEIGHT ( type: esriFieldTypeDouble, alias: Inches Above or Below )
• COVERTYPE ( type: esriFieldTypeString, alias: Cover Type, length: 50 , Coded Values: [Double Cover: Double Cover] , [Lamp: Lamp] , [Mascotte: Mascotte] , ...4 more... )
• COVERSIZE ( type: esriFieldTypeString, alias: Cover Size, length: 5 )
• COVERFIT ( type: esriFieldTypeString, alias: Cover Rim Fit, length: 50 , Coded Values: [Good: Good] , [Oversized: Oversized] , [Rocks/Wobbles: Rocks/Wobbles] , ...1 more... )
• COVERCOND ( type: esriFieldTypeString, alias: Cover Condition, length: 50 , Coded Values: [Sound: Sound] , [Cracked: Cracked] , [Broken: Broken] , ...3 more... )
• INVERTRIMDIST ( type: esriFieldTypeString, alias: Invert Rim Distance (Feet to Nearest Tenth), length: 30 )
• COVERCOND2 ( type: esriFieldTypeString, alias: Additional Cover Conditions, length: 50 )
• INSERTTYPE ( type: esriFieldTypeString, alias: Rain Dish Identifier, length: 50 , Coded Values: [None: None] , [Metal: Metal] , [Other: Other] , ...1 more... )
• INSERTCOND ( type: esriFieldTypeString, alias: Insert Conditions, length: 50 , Coded Values: [None: None] , [Sound: Sound] , [Poorly Fitted: Poorly Fitted] , ...3 more... )
• INSERTCOND2 ( type: esriFieldTypeString, alias: Additional Insert Conditions, length: 50 )
• SURCHARGE ( type: esriFieldTypeString, alias: Evidence of Surcharge, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• SURCHARGEHEIGHT ( type: esriFieldTypeString, alias: Height Surcharge from Invert, length: 50 )
• FRAMEADJ ( type: esriFieldTypeString, alias: Adjustment Ring Type, length: 50 , Coded Values: [No Value: No Value] , [Adjustable: Adjustable] , [Solid: Solid] , ...1 more... )
• ADJRINGCOND ( type: esriFieldTypeString, alias: Adjustment Ring Condition, length: 50 , Coded Values: [N/A: N/A] , [Broken: Broken] , [Corroded/Pitted/Worn: Corroded/Pitted/Worn] , ...3 more... )
• ADJRINGCOND2 ( type: esriFieldTypeString, alias: Additional Ring Conditions, length: 50 )
• FRAMETYPE ( type: esriFieldTypeString, alias: Frame Material, length: 50 , Coded Values: [Cast Iron: Cast Iron] , [Ductile Iron: Ductile Iron] , [Plastic/Steel Composite: Plastic/Steel Composite] , ...3 more... )
• FRAMECOND ( type: esriFieldTypeString, alias: Frame Condition, length: 50 , Coded Values: [Sound: Sound] , [Cracked: Cracked] , [Broken: Broken] , ...3 more... )
• FRAMECOND2 ( type: esriFieldTypeString, alias: Additional Frame Conditions, length: 50 )
• FRAMESEALCOND ( type: esriFieldTypeString, alias: Frame to Manhole Seal, length: 50 , Coded Values: [Sound: Sound] , [Cracked: Cracked] , [Loose/Not Attached: Loose/Not Attached] , ...2 more... )
• FRAMEOFFSET ( type: esriFieldTypeDouble, alias: Frame Offset )
• FRAMESEALCOND2 ( type: esriFieldTypeString, alias: Additional Seal Conditions, length: 50 )
• SEALINFLOW ( type: esriFieldTypeString, alias: Frame Seal Inflow, length: 50 , Coded Values: [None: None] , [Infil Stained: Infil Stained] , [Infil Weeper: Infil Weeper] , ...3 more... )
• CHIMNEYTYPE ( type: esriFieldTypeString, alias: Chimney Material, length: 50 , Coded Values: [None: None] , [Brick: Brick] , [Cast Iron: Cast Iron] , ...6 more... )
• CHIMNEYLINETYPE ( type: esriFieldTypeString, alias: Chimney Lining Material, length: 50 , Coded Values: [Bitumastic: Bitumastic] , [Cementitious: Cementitious] , [Cured in Place: Cured in Place] , ...7 more... )
• CHIMNEYCOND ( type: esriFieldTypeString, alias: Chimney Condition, length: 50 , Coded Values: [No Defects Observed: No Defects Observed] , [Crack: Crack] , [Fracture: Fracture] , ...15 more... )
• CHIMNEYINFILTRATE ( type: esriFieldTypeString, alias: Chimney Infiltration, length: 50 , Coded Values: [None: None] , [Infil Stained: Infil Stained] , [Infil Weeper: Infil Weeper] , ...3 more... )
• CONEMATERIAL ( type: esriFieldTypeString, alias: Cone Material, length: 50 , Coded Values: [None: None] , [Brick: Brick] , [Fiberglass Reinforced Pipe: Fiberglass Reinforced Pipe] , ...7 more... )
• CONETYPE ( type: esriFieldTypeString, alias: Cone Type, length: 50 , Coded Values: [None: None] , [Conical Centered: Conical Centered] , [Conical Off Centered: Conical Off Centered] , ...1 more... )
• CONELINETYPE ( type: esriFieldTypeString, alias: Cone Lining Material, length: 50 , Coded Values: [Bitumastic: Bitumastic] , [Cementitious: Cementitious] , [Cured in Place: Cured in Place] , ...7 more... )
• CONECOND ( type: esriFieldTypeString, alias: Cone Condition, length: 50 , Coded Values: [No Defects Observed: No Defects Observed] , [Crack: Crack] , [Fracture: Fracture] , ...15 more... )
• CONEINFILTRATE ( type: esriFieldTypeString, alias: Cone Infiltration, length: 50 , Coded Values: [None: None] , [Infil Stained: Infil Stained] , [Infil Weeper: Infil Weeper] , ...3 more... )
• BARRELTYPE ( type: esriFieldTypeString, alias: Wall Material, length: 50 , Coded Values: [Brick: Brick] , [Fiberglass Reinforced Pipe: Fiberglass Reinforced Pipe] , [Glass Reinforced Cement: Glass Reinforced Cement] , ...6 more... )
• BARRELLINETYPE ( type: esriFieldTypeString, alias: Wall Lining Material, length: 50 , Coded Values: [Bitumastic: Bitumastic] , [Cementitious: Cementitious] , [Cured in Place: Cured in Place] , ...7 more... )
• BARRELCOND ( type: esriFieldTypeString, alias: Wall Condition, length: 50 , Coded Values: [No Defects Observed: No Defects Observed] , [Crack: Crack] , [Fracture: Fracture] , ...15 more... )
• BARRELINFILTRATE ( type: esriFieldTypeString, alias: Wall Infiltration, length: 50 , Coded Values: [None: None] , [Infil Stained: Infil Stained] , [Infil Weeper: Infil Weeper] , ...3 more... )
• BENCHTYPE ( type: esriFieldTypeString, alias: Bench Material, length: 50 , Coded Values: [Brick: Brick] , [Vitirified Clay Pipe: Vitirified Clay Pipe] , [Other: Other] , ...4 more... )
• BENCHLINETYPE ( type: esriFieldTypeString, alias: Bench Lining Material, length: 50 , Coded Values: [Bitumastic: Bitumastic] , [Cementitious: Cementitious] , [Cured in Place: Cured in Place] , ...7 more... )
• BENCHCOND ( type: esriFieldTypeString, alias: Bench Condition, length: 50 , Coded Values: [No Defects Observed: No Defects Observed] , [Crack: Crack] , [Fracture: Fracture] , ...15 more... )
• BENCHDEPOSITS ( type: esriFieldTypeString, alias: Bench Deposits, length: 50 , Coded Values: [Deposits - encrustation: Deposits - encrustation] , [Deposits - grease: Deposits - grease] , [Deposits settled- ragging/sanitary: Deposits settled- ragging/sanitary] , ...7 more... )
• BENCHDEPOSITSDEPTH ( type: esriFieldTypeDouble, alias: Depth of Deposits )
• BENCHINFILTRATE ( type: esriFieldTypeString, alias: Bench Infiltration, length: 50 , Coded Values: [None: None] , [Infil Stained: Infil Stained] , [Infil Weeper: Infil Weeper] , ...3 more... )
• CHANNELTYPE ( type: esriFieldTypeString, alias: Channel Material, length: 50 , Coded Values: [Brick: Brick] , [Cast Iron: Cast Iron] , [Ductile Iron: Ductile Iron] , ...9 more... )
• CHANNELLINETYPE ( type: esriFieldTypeString, alias: Channel Lining Material, length: 50 , Coded Values: [Bitumastic: Bitumastic] , [Cementitious: Cementitious] , [Cured in Place: Cured in Place] , ...7 more... )
• CHANNELCOND ( type: esriFieldTypeString, alias: Channel Condition, length: 50 , Coded Values: [No Defects Observed: No Defects Observed] , [Crack: Crack] , [Fracture: Fracture] , ...6 more... )
• CHANNELDEPOSITS ( type: esriFieldTypeString, alias: Flow Channel Deposits, length: 50 , Coded Values: [Deposits - encrustation: Deposits - encrustation] , [Deposits - grease: Deposits - grease] , [Deposits settled - ragging/sanitary: Deposits settled - ragging/sanitary] , ...7 more... )
• CHANNELDEPOSITSDEPTH ( type: esriFieldTypeDouble, alias: Depth of Deposits )
• CHANNELINFILTRATE ( type: esriFieldTypeString, alias: Channel Infiltration, length: 50 , Coded Values: [None: None] , [Infil Stained: Infil Stained] , [Infil Weeper: Infil Weeper] , ...3 more... )
• SEALCOND ( type: esriFieldTypeString, alias: Pipe Seal Condition, length: 50 , Coded Values: [No Seal: No Seal] , [Sound: Sound] , [Sand/Water Infiltration: Sand/Water Infiltration] , ...1 more... )
• PROJECT2 ( type: esriFieldTypeString, alias: Additional Project Information, length: 50 )
• WORKREQUEST ( type: esriFieldTypeString, alias: Work Request Submitted, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• PROJECT ( type: esriFieldTypeString, alias: Purpose of Work Request, length: 50 , Coded Values: [Access: Access] , [Cleaning: Cleaning] , [Rehabilitation: Rehabilitation] , ...2 more... )
• COMPINSPECT ( type: esriFieldTypeString, alias: Inspection Complete, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• ID ( type: esriFieldTypeString, alias: Legacy Access ID, length: 50 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• ENDDATETIME ( type: esriFieldTypeDate, alias: ENDDATETIME, length: 8 )
• INSPECTID ( type: esriFieldTypeString, alias: INSPECTID, length: 10 )
• UFV ( type: esriFieldTypeString, alias: Unable to Inspect, length: 50 , Coded Values: [Paved Over: Paved Over] , [No Access: No Access] , [Obstruction: Obstruction] )
• CANNOTLOCATE ( type: esriFieldTypeString, alias: Cannot Locate, length: 15 , Coded Values: [Cannot Locate: Cannot Locate] , [No Value: No Value] )
• UFVCOMMENTS ( type: esriFieldTypeString, alias: Addition Comments, length: 300 )
• 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 )

Relationships:

• SewerDevice (0) -- Related To: Wastewater Pump Station (0)
• SewerDevice (1) -- Related To: Wastewater Controllable Valves (1)
• SewerDevice (2) -- Related To: Wastewater Relief Valves (2)
• SewerDevice (3) -- Related To: Wastewater Cleanouts (3)
• SewerDevice (4) -- Related To: Wastewater Manholes (4)

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

  Iteminfo   Thumbnail   Metadata