Name: Manhole Inspection

Display Field: FACILITYID

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
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: false
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:

Fields:

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

Templates:

• Name: Manhole Inspection
  Description:
  Prototype:
  CANNOTLOCATE: null
  UFVCOMMENTS: null
  FACILITYID: null
  STARTDATETIME: null
  WORKKEY: null
  PURPOSE: null
  GROUNDCONDITION: null
  MANHOLELOCATION: null
  SURFACETYPE: null
  RUNOFF: null
  INSSTATUS: null
  MHSURFALIGN: null
  MHHEIGHT: null
  COVERTYPE: null
  COVERSIZE: null
  COVERFIT: null
  COVERCOND: null
  INVERTRIMDIST: null
  COVERCOND2: null
  INSERTTYPE: null
  INSERTCOND: null
  INSERTCOND2: null
  SURCHARGE: null
  SURCHARGEHEIGHT: null
  FRAMEADJ: null
  ADJRINGCOND: null
  ADJRINGCOND2: null
  FRAMETYPE: null
  FRAMECOND: null
  FRAMECOND2: null
  FRAMESEALCOND: null
  FRAMEOFFSET: null
  FRAMESEALCOND2: null
  SEALINFLOW: null
  CHIMNEYTYPE: null
  CHIMNEYLINETYPE: null
  CHIMNEYCOND: null
  CHIMNEYINFILTRATE: null
  CONEMATERIAL: null
  CONETYPE: null
  CONELINETYPE: null
  CONECOND: null
  CONEINFILTRATE: null
  BARRELTYPE: null
  BARRELLINETYPE: null
  BARRELCOND: null
  BARRELINFILTRATE: null
  BENCHTYPE: null
  BENCHLINETYPE: null
  BENCHCOND: null
  BENCHDEPOSITS: null
  BENCHDEPOSITSDEPTH: null
  BENCHINFILTRATE: null
  CHANNELTYPE: null
  CHANNELLINETYPE: null
  CHANNELCOND: null
  CHANNELDEPOSITS: null
  CHANNELDEPOSITSDEPTH: null
  CHANNELINFILTRATE: null
  SEALCOND: null
  PROJECT2: null
  WORKREQUEST: null
  PROJECT: null
  COMPINSPECT: null
  ID: null
  UFV: null
  ENDDATETIME: null
  INSPECTID: null
  
  Drawing Tool: esriFeatureEditToolNone

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)

Capabilities: Query,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Supports OidReservation: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: true

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Related Records   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata