Name: sedaManholeHistory

Display Field: assetkey

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• assetkey ( type: esriFieldTypeString, alias: ManholeID, length: 30 )
• workby ( type: esriFieldTypeString, alias: WorkBy, length: 30 , Coded Values: [Staff: Staff] , [Contractor: Contractor] )
• workdate ( type: esriFieldTypeDate, alias: DateStamp, length: 8 )
• mhdepth ( type: esriFieldTypeDouble, alias: mhdepth )
• dropmanhole ( type: esriFieldTypeString, alias: dropmanhole, length: 10 , Coded Values: [Inside: Inside] , [Outside: Outside] , [No: No] )
• comments ( type: esriFieldTypeString, alias: comments, length: 1000 )
• worktype ( type: esriFieldTypeString, alias: worktype, length: 50 )
• attachmentid01 ( type: esriFieldTypeInteger, alias: attachmentid01 )
• attachmentid02 ( type: esriFieldTypeInteger, alias: attachmentid02 )
• waterway ( type: esriFieldTypeString, alias: waterway, length: 50 )
• mhcovercondition ( type: esriFieldTypeString, alias: mhcovercondition, length: 30 , Coded Values: [Worn: Worn] , [Sound: Sound] , [Cracked: Cracked] , ...6 more... )
• mhcovertype ( type: esriFieldTypeString, alias: mhcovertype, length: 50 , Coded Values: [Standard - 1 hole in center: Standard - 1 hole in center] , [Standard – No hole: Standard – No hole] , [Standard – Many holes: Standard – Many holes] , ...6 more... )
• mhcoversize ( type: esriFieldTypeString, alias: mhcoversize, length: 10 , Coded Values: [24: 24] , [30: 30] , [36: 36] , ...1 more... )
• locking ( type: esriFieldTypeString, alias: locking, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• mhcoverlabel ( type: esriFieldTypeInteger, alias: mhcoverlable , Coded Values: [1: WSD] , [2: WSS] , [3: Storm] , ...6 more... )
• ringframecond ( type: esriFieldTypeString, alias: ringframecond, length: 30 , Coded Values: [Serviceable: Serviceable] , [Unsafe: Unsafe] , [Missing: Missing] , ...1 more... )
• ringframegrade ( type: esriFieldTypeString, alias: ringframegrade, length: 30 , Coded Values: [Good: Good] , [Needs Raising: Needs Raising] , [Needs Lowering: Needs Lowering] )
• mhmaterial ( type: esriFieldTypeString, alias: mhmaterial, length: 30 , Coded Values: [Brick: Brick] , [Concrete Block: Concrete Block] , [Asbestos Cement: Asbestos Cement] , ...13 more... )
• interceptor ( type: esriFieldTypeString, alias: interceptor, length: 30 )
• location ( type: esriFieldTypeString, alias: location, length: 100 , Coded Values: [Roadway: Roadway] , [Gutter: Gutter] , [Paved Alley: Paved Alley] , ...5 more... )
• mhlining ( type: esriFieldTypeString, alias: mhlining, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• stepconditon ( type: esriFieldTypeString, alias: stepconditon, length: 30 , Coded Values: [Serviceable: Serviceable] , [Unsafe: Unsafe] , [Missing: Missing] , ...1 more... )
• conecondition ( type: esriFieldTypeString, alias: conecondition, length: 30 , Coded Values: [Serviceable: Serviceable] , [Broken: Broken] , [Sulfided: Sulfided] , ...2 more... )
• risercondition ( type: esriFieldTypeString, alias: risercondition, length: 30 , Coded Values: [Serviceable: Serviceable] , [Broken: Broken] , [Sulfided: Sulfided] , ...3 more... )
• shelftype ( type: esriFieldTypeString, alias: shelftype, length: 30 , Coded Values: [Brick: Brick] , [Concrete/PreCast: Concrete/PreCast] )
• shelfcondition ( type: esriFieldTypeString, alias: shelfcondition, length: 30 , Coded Values: [Serviceable: Serviceable] , [Broken: Broken] , [Dirty: Dirty] , ...2 more... )
• channelcondition ( type: esriFieldTypeString, alias: channelcondition, length: 30 , Coded Values: [Serviceable: Serviceable] , [Obstructed: Obstructed] , [Sulfided: Sulfided] , ...2 more... )
• flow ( type: esriFieldTypeString, alias: flow, length: 30 , Coded Values: [Steady: Steady] , [Pulsing: Pulsing] , [Turbulent: Turbulent] , ...4 more... )
• ini ( type: esriFieldTypeString, alias: ini, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• flowdepth ( type: esriFieldTypeDouble, alias: flowdepth )
• weather ( type: esriFieldTypeString, alias: weather, length: 30 , Coded Values: [Dry: Dry] , [Heavy Rain: Heavy Rain] , [Light Rain: Light Rain] , ...4 more... )
• surchargeevidence ( type: esriFieldTypeString, alias: surchargeevidence, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• depthstatus ( type: esriFieldTypeString, alias: depthstatus, length: 20 , Coded Values: [Changed: Changed] , [Verified: Verified] )
• ssodate ( type: esriFieldTypeDate, alias: ssodate, length: 8 )
• ssoasset ( type: esriFieldTypeString, alias: ssoasset, length: 30 , Coded Values: [Manhole: Manhole] , [Sanitary Sewer: Sanitary Sewer] , [Pump Station: Pump Station] , ...4 more... )
• bypass_cause ( type: esriFieldTypeString, alias: bypass_cuase, length: 250 , Coded Values: [Construction/Repairs: Construction/Repairs] , [Obstruction: Obstruction] , [Grease: Grease] , ...3 more... )
• ssoblockage_type ( type: esriFieldTypeString, alias: blockage_type, length: 50 , Coded Values: [Grease: Grease] , [Debris: Debris] , [Collapse: Collapse] , ...2 more... )
• substandardcond ( type: esriFieldTypeString, alias: substandardcond, length: 30 , Coded Values: [Electrical: Electrical] , [Mechanical: Mechanical] , [Structural: Structural] , ...4 more... )
• substandard_practice ( type: esriFieldTypeString, alias: substandard_practice, length: 50 )
• sso_spill_loc ( type: esriFieldTypeString, alias: sso_spill_loc, length: 30 , Coded Values: [Ground: Ground] , [Street: Street] , [Surface Water: Surface Water] , ...1 more... )
• spill_locname ( type: esriFieldTypeString, alias: spill_locname, length: 100 )
• sso_duration ( type: esriFieldTypeDouble, alias: sso_duration )
• sso_galsreleased ( type: esriFieldTypeDouble, alias: sso_galsreleased )
• sso_cleanmethod ( type: esriFieldTypeString, alias: sso_cleanmethod, length: 50 , Coded Values: [Jetting: Jetting] , [Clamming: Clamming] )
• sso_lastevent ( type: esriFieldTypeDate, alias: sso_lastevent, length: 8 )
• sso_preventaction ( type: esriFieldTypeString, alias: ss0_preventaction, length: 50 , Coded Values: [CCTV: CCTV] , [CIPP: CIPP] , [Dig and Replace: Dig and Replace] , ...2 more... )
• sso_volume_estmeth ( type: esriFieldTypeString, alias: sso_volume_est, length: 30 , Coded Values: [Visual: Visual] , [Calculated: Calculated] , [Measured: Measured] )
• discovered ( type: esriFieldTypeDate, alias: discovered, length: 8 )
• stopped ( type: esriFieldTypeDate, alias: stopped, length: 8 )
• howdiscovered ( type: esriFieldTypeString, alias: howdiscovered, length: 30 )
• sso_resp_party ( type: esriFieldTypeString, alias: sso_resp_party, length: 250 )
• sso_investigatedby ( type: esriFieldTypeString, alias: sso_investigatedby, length: 50 , Coded Values: [Maurice Fortier: Maurice Fortier] , [Ken Ferreira: Ken Ferreira] , [Denis Cuevas: Denis Cuevas] , ...6 more... )
• address ( type: esriFieldTypeString, alias: address, length: 250 )
• sso_disinfectmethod ( type: esriFieldTypeString, alias: sso_disinfectmethod, length: 30 , Coded Values: [Sodium Hypochlorite: Sodium Hypochlorite] , [Lime: Lime] , [None: None] )
• sso_correctiveaction ( type: esriFieldTypeString, alias: sso_correctiveaction, length: 50 , Coded Values: [Change in Conveyance: Change in Conveyance] , [Dig and Replace: Dig and Replace] , [Jet or Vac Line: Jet or Vac Line] , ...1 more... )
• notify_deep2hr ( type: esriFieldTypeString, alias: notify_deep2hr, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• notify_deep5day ( type: esriFieldTypeString, alias: notify_deep5day, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• chimneymaterial ( type: esriFieldTypeString, alias: chimneymaterial, length: 30 , Coded Values: [Brick: Brick] , [Plastic: Plastic] , [Concrete/Precast: Concrete/Precast] , ...1 more... )
• chimneycondition ( type: esriFieldTypeString, alias: chimneycondition, length: 30 , Coded Values: [Serviceable: Serviceable] , [Broken: Broken] , [Sulfided: Sulfided] , ...2 more... )
• wallcondition ( type: esriFieldTypeString, alias: wallcondition, length: 30 , Coded Values: [Serviceable: Serviceable] , [Broken: Broken] , [Sulfided: Sulfided] , ...3 more... )
• datescheduled ( type: esriFieldTypeDate, alias: datescheduled, length: 8 )
• datecompleted ( type: esriFieldTypeDate, alias: datecompleted, length: 8 )
• crewcontractor ( type: esriFieldTypeString, alias: crewcontractor, length: 50 )
• hoursworked ( type: esriFieldTypeDouble, alias: hoursworked )
• totalcost ( type: esriFieldTypeDouble, alias: totalcost )
• sectionrepaired ( type: esriFieldTypeString, alias: sectionrepaired, length: 50 , Coded Values: [Ring: Ring] , [Chimney: Chimney] , [Bench: Bench] , ...9 more... )
• repairsize ( type: esriFieldTypeDouble, alias: repairsize )
• quoteattached ( type: esriFieldTypeString, alias: quoteattached, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• equipment ( type: esriFieldTypeString, alias: equipment, length: 250 )
• material ( type: esriFieldTypeString, alias: material, length: 250 )
• ringcondition ( type: esriFieldTypeString, alias: ringcondition, length: 50 , Coded Values: [Sound: Sound] , [Worn: Worn] , [Cracked: Cracked] , ...5 more... )
• framecondition ( type: esriFieldTypeString, alias: framecondition, length: 50 , Coded Values: [Serviceable: Serviceable] , [Worn: Worn] , [Loose: Loose] , ...4 more... )
• numberofrings ( type: esriFieldTypeSmallInteger, alias: numberofrings )
• repairtype ( type: esriFieldTypeString, alias: repairtype, length: 30 , Coded Values: [Corrective Maintenance: Corrective Maintenance] , [Preventative Maintenance: Preventative Maintenance] )
• ringrepair ( type: esriFieldTypeString, alias: ringrepair, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• chimneyrepair ( type: esriFieldTypeString, alias: chimneyrepair, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• benchrepair ( type: esriFieldTypeString, alias: benchrepair, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• steprepair ( type: esriFieldTypeString, alias: steprepair, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• conerepair ( type: esriFieldTypeString, alias: conrepair, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• wallrepair ( type: esriFieldTypeString, alias: wallrepair, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• shelfrepair ( type: esriFieldTypeString, alias: shelfrepair, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• coverrepair ( type: esriFieldTypeString, alias: coverrepair, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• channelrepair ( type: esriFieldTypeString, alias: channelrepair, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• dropinletrepair ( type: esriFieldTypeString, alias: dropinletrepair, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• cert_no ( type: esriFieldTypeString, alias: cert_no, length: 20 , Coded Values: [U-313-17671: U-313-17671] , [U-313-17662: U-313-17662] , [U-313-17659: U-313-17659] , ...1 more... )
• insp_status ( type: esriFieldTypeString, alias: insp_status, length: 50 , Coded Values: [Internal Inspection: Internal Inspection] , [Surface Inspection: Surface Inspection] , [Not Found: Not Found] , ...6 more... )
• insp_purpose ( type: esriFieldTypeString, alias: insp_purpose, length: 50 , Coded Values: [Maintenance Related: Maintenance Related] , [I/I Study: I/I Study] , [Pre Rehab Survey: Pre Rehab Survey] , ...7 more... )
• loc_code ( type: esriFieldTypeString, alias: loc_code, length: 30 , Coded Values: [Main Hwy/4-Lane: Main Hwy/4-Lane] , [Main Hwy/2-Lane: Main Hwy/2-Lane] , [Local Roads: Local Roads] , ...12 more... )
• surf_type ( type: esriFieldTypeString, alias: surf_type, length: 30 , Coded Values: [Asphalt: Asphalt] , [Concrete/Pavement: Concrete/Pavement] , [Concrete Collar: Concrete Collar] , ...3 more... )
• runoff ( type: esriFieldTypeString, alias: runoff, length: 20 , Coded Values: [None: None] , [Sheeting: Sheeting] , [Ponding: Ponding] , ...1 more... )
• coverfit ( type: esriFieldTypeString, alias: coverfit, length: 30 , Coded Values: [Good: Good] , [Oversized - too tight: Oversized - too tight] , [Undersized - too loose: Undersized - too loose] , ...1 more... )
• frameoffset ( type: esriFieldTypeString, alias: frameoffset, length: 30 , Coded Values: [On Center: On Center] , [Off Center by 2-3": Off Center by 2-3"] , [Off Center by >3": Off Center by >3"] )
• framedepth ( type: esriFieldTypeString, alias: framedepth, length: 10 , Coded Values: [8": 8"] , [6": 6"] , [4": 4"] , ...1 more... )
• sealcondition ( type: esriFieldTypeString, alias: sealcondition, length: 30 , Coded Values: [Sound: Sound] , [Cracked: Cracked] , [Loose: Loose (Not Attached)] , ...3 more... )
• rungcondition ( type: esriFieldTypeString, alias: rungcondition, length: 30 , Coded Values: [Serviceable: Serviceable] , [None/Missing: None/Missing] , [Unsafe: Unsafe] , ...2 more... )
• surchevidence ( type: esriFieldTypeString, alias: surchevidence, length: 30 , Coded Values: [None: None] , [Grease/Debris on Shelf: Grease/Debris on Shelf] , [Grease/Debris on sides/Rungs: Grease/Debris on sides/Rungs] )
• mhmaterial2 ( type: esriFieldTypeString, alias: mhmaterial2, length: 30 , Coded Values: [None - No Coating: None - No Coating] , [Cementitious: Cementitious] , [Epoxy: Epoxy] , ...7 more... )
• chimneyi ( type: esriFieldTypeString, alias: chimneyi, length: 20 , Coded Values: [None: None] , [Weeper: Weeper] , [Dripper: Dripper] , ...3 more... )
• structurecondition ( type: esriFieldTypeString, alias: structurecondition, length: 30 , Coded Values: [Serviceable: Serviceable] , [Broken/Cracked: Broken/Cracked] , [Sulfided: Sulfided] , ...2 more... )
• conetype ( type: esriFieldTypeString, alias: conetype, length: 30 , Coded Values: [Flattop: Flattop] , [Conical - Centered: Conical - Centered] , [Conical - One Side: Conical - One Side] )
• structurecond2 ( type: esriFieldTypeString, alias: structurecond2, length: 30 , Coded Values: [Serviceable: Serviceable] , [Broken/Cracked: Broken/Cracked] , [Dirty: Dirty] , ...4 more... )
• chan_exposure ( type: esriFieldTypeString, alias: chan_exposure, length: 50 , Coded Values: [Open - > 50% visible: Open - > 50% visible] , [Partially Open - < 50% visible: Partially Open - < 50% visible] , [Closed – channel completely covered: Closed – channel completely covered] )
• structurecond3 ( type: esriFieldTypeString, alias: structurecond3, length: 50 , Coded Values: [Serviceable: Serviceable] , [Obstructed: Obstructed] , [Sulfided: Sulfided] , ...4 more... )
• channelconstruct ( type: esriFieldTypeString, alias: channelconstruct, length: 30 , Coded Values: [Sweeping 90: Sweeping 90] , [Sweeping Tee: Sweeping Tee] , [Sweeping Cross: Sweeping Cross] , ...5 more... )
• addl_pipes ( type: esriFieldTypeString, alias: addl_pipes, length: 10 , Coded Values: [0: 0] , [1: 1] , [2: 2] , ...2 more... )
• flowclarity ( type: esriFieldTypeString, alias: flowclarity, length: 50 , Coded Values: [Turbid Sewage Appearance: Turbid Sewage Appearance] , [Clear Water Appearance: Clear Water Appearance] , [No Flow: No Flow] , ...1 more... )
• dropinlet ( type: esriFieldTypeString, alias: dropinlet, length: 50 , Coded Values: [Interior Drop - Serviceable: Interior Drop - Serviceable] , [Interior Drop - Not Serviceable: Interior Drop - Not Serviceable] , [Exterior Drop - Serviceable: Exterior Drop - Serviceable] , ...2 more... )
• distance_ft ( type: esriFieldTypeDouble, alias: distance_ft )
• subarea ( type: esriFieldTypeString, alias: subarea, length: 10 )
• conematerial ( type: esriFieldTypeString, alias: conematerial, length: 30 , Coded Values: [Brick: Brick] , [Concrete Block: Concrete Block] , [Asbestos Cement: Asbestos Cement] , ...13 more... )
• conecond ( type: esriFieldTypeString, alias: conecond, length: 30 , Coded Values: [Serviceable: Serviceable] , [Broken: Broken] , [Sulfided: Sulfided] , ...2 more... )
• coneii ( type: esriFieldTypeString, alias: coneii, length: 30 , Coded Values: [None: None] , [Weeper: Weeper] , [Dripper: Dripper] , ...3 more... )
• wallcond ( type: esriFieldTypeString, alias: wallcond, length: 30 , Coded Values: [Serviceable: Serviceable] , [Broken: Broken] , [Sulfided: Sulfided] , ...2 more... )
• wallmaterial ( type: esriFieldTypeString, alias: wallmaterial, length: 50 , Coded Values: [Brick: Brick] , [Concrete Block: Concrete Block] , [Asbestos Cement: Asbestos Cement] , ...13 more... )
• wallii ( type: esriFieldTypeString, alias: wallii, length: 30 , Coded Values: [None: None] , [Weeper: Weeper] , [Dripper: Dripper] , ...3 more... )
• benchmaterial ( type: esriFieldTypeString, alias: benchmaterial, length: 50 , Coded Values: [Brick: Brick] , [Concrete Block: Concrete Block] , [Asbestos Cement: Asbestos Cement] , ...13 more... )
• benchcond ( type: esriFieldTypeString, alias: benchcond, length: 50 , Coded Values: [Serviceable: Serviceable] , [Broken/Cracked: Broken/Cracked] , [Dirty: Dirty] , ...3 more... )
• benchii ( type: esriFieldTypeString, alias: benchii, length: 30 , Coded Values: [None: None] , [Weeper: Weeper] , [Dripper: Dripper] , ...3 more... )
• channelmaterial ( type: esriFieldTypeString, alias: channelmaterial, length: 30 , Coded Values: [Brick: Brick] , [Concrete Block: Concrete Block] , [Asbestos Cement: Asbestos Cement] , ...13 more... )
• rimtoinvert ( type: esriFieldTypeDouble, alias: rimtoinvert )
• gradetoinvert ( type: esriFieldTypeDouble, alias: gradetoinvert )
• pavedover ( type: esriFieldTypeString, alias: pavedover, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• wocomments ( type: esriFieldTypeString, alias: wocomments, length: 1073741822 )
• wodescription ( type: esriFieldTypeString, alias: wodescription, length: 255 )
• MH_Aerial_Photo ( type: esriFieldTypeInteger, alias: MH_Aerial_Photo )
• MH_Interior_Photo ( type: esriFieldTypeInteger, alias: MH_Interior_Photo )
• MH_Defect_1 ( type: esriFieldTypeInteger, alias: MH_Defect_1 )
• MH_Defect_2 ( type: esriFieldTypeInteger, alias: MH_Defect_2 )
• MH_Defect_3 ( type: esriFieldTypeInteger, alias: MH_Defect_3 )
• Pipe_1_Seal_Condition ( type: esriFieldTypeString, alias: Pipe_1_Seal_Condition, length: 50 , Coded Values: [Poor: Poor] , [Fair: Fair] , [Good: Good] , ...1 more... )
• Pipe_2_Seal_Condition ( type: esriFieldTypeString, alias: Pipe_2_Seal_Condition, length: 50 , Coded Values: [Poor: Poor] , [Fair: Fair] , [Good: Good] , ...1 more... )
• Pipe_3_Seal_Condition ( type: esriFieldTypeString, alias: Pipe_3_Seal_Condition, length: 50 , Coded Values: [Poor: Poor] , [Fair: Fair] , [Good: Good] , ...1 more... )
• Pipe_4_Seal_Condition ( type: esriFieldTypeString, alias: Pipe_4_Seal_Condition, length: 50 , Coded Values: [Poor: Poor] , [Fair: Fair] , [Good: Good] , ...1 more... )
• Pipe_5_Seal_Condition ( type: esriFieldTypeString, alias: Pipe_5_Seal_Condition, length: 50 , Coded Values: [Poor: Poor] , [Fair: Fair] , [Good: Good] , ...1 more... )
• Interior_Pipe_1_Photo ( type: esriFieldTypeInteger, alias: Interior_Pipe_1_Photo )
• Interior_Pipe_2_Photo ( type: esriFieldTypeInteger, alias: Interior_Pipe_2_Photo )
• Interior_Pipe_3_Photo ( type: esriFieldTypeInteger, alias: Interior_Pipe_3_Photo )
• Interior_Pipe_4_Photo ( type: esriFieldTypeInteger, alias: Interior_Pipe_4_Photo )
• Interior_Pipe_5_Photo ( type: esriFieldTypeInteger, alias: Interior_Pipe_5_Photo )
• MH_Sketch ( type: esriFieldTypeInteger, alias: MH_Sketch )

Supported Operations:   Query   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata