Name: Manhole Inspection Table

Display Field: streetnameno

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: ee1f5c626cf14884a8c3eba3f496b275

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: true
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 )
• surveyedby ( type: esriFieldTypeString, alias: Surveyed By, length: 100 )
• certificateno ( type: esriFieldTypeString, alias: Certificate #, length: 100 )
• reviewedby ( type: esriFieldTypeString, alias: Reviewed By, length: 100 )
• owner ( type: esriFieldTypeString, alias: Owner (Public or Private), length: 20 , Coded Values: [PUBLIC: PUBLIC] , [PRIVATE: PRIVATE] )
• ifpublic ( type: esriFieldTypeString, alias: IF PUBLIC, length: 25 , Coded Values: [COH: COH] , [STATE: STATE] , [COUNTY: COUNTY] )
• ifprivate ( type: esriFieldTypeString, alias: IF PRIVATE, length: 25 , Coded Values: [COMMERCIAL: COMMERCIAL] , [RESIDENTIAL: RESIDENTIAL] , [HOA/COLLECTIVE: HOA/COLLECTIVE] )
• project ( type: esriFieldTypeString, alias: Project, length: 100 , Coded Values: [2025 STORMWATER ASSET INVENTORY: 2025 STORMWATER ASSET INVENTORY] )
• inspectiondate ( type: esriFieldTypeDate, alias: Inspection Date, length: 8 )
• weather ( type: esriFieldTypeString, alias: Weather, length: 50 , Coded Values: [DRY: DRY] , [HEAVY RAIN: HEAVY RAIN] , [LIGHT RAIN: LIGHT RAIN] , ...2 more... )
• precleaning ( type: esriFieldTypeString, alias: Pre-Cleaning?, length: 50 , Coded Values: [HEAVY CLEANING: HEAVY CLEANING] , [LIGHT CLEANING (JETTING): LIGHT CLEANING (JETTING)] , [NO PRE-CLEAN: NO PRE-CLEAN] , ...3 more... )
• lastmaintenancedate ( type: esriFieldTypeDate, alias: Date Last Maintained, length: 8 )
• inspectionstatus ( type: esriFieldTypeString, alias: Inspection status, length: 50 , Coded Values: [COMPLETED INSPECTION: COMPLETED INSPECTION] , [BURIED AND MARKED: BURIED AND MARKED] , [NO ACCESS: NO ACCESS] , ...6 more... )
• consequenceoffailure ( type: esriFieldTypeString, alias: Consequence of failure , length: 255 )
• drainagearea ( type: esriFieldTypeString, alias: Drainage Area, length: 10 , Coded Values: [TUR: TUR] , [DER: DER] , [DUC: DUC] , ...3 more... )
• assetid ( type: esriFieldTypeString, alias: Asset ID, length: 100 )
• streetnameno ( type: esriFieldTypeString, alias: Street (Name & Number), length: 255 )
• city ( type: esriFieldTypeString, alias: City, length: 20 , Coded Values: [HOBART: HOBART] , [MERRILLVILLE: MERRILLVILLE] )
• locationcode ( type: esriFieldTypeString, alias: Location Code, length: 50 , Coded Values: [PRIMARY MAJOR ARTERIAL ROAD: PRIMARY MAJOR ARTERIAL ROAD] , [SECONDARY ROAD: SECONDARY ROAD] , [LOCAL/RURAL STREET: LOCAL/RURAL STREET] , ...15 more... )
• surfacetype ( type: esriFieldTypeString, alias: Surface Type, length: 25 , Coded Values: [ASPHALT: ASPHALT] , [CONCRETE/PAVEMENT: CONCRETE/PAVEMENT] , [CONCRETE COLLAR: CONCRETE COLLAR] , ...3 more... )
• accesstype ( type: esriFieldTypeString, alias: Access Type, length: 50 , Coded Values: [ACCESS CATCH BASIN: ACCESS CATCH BASIN] , [ACCESS CATCH BASIN W/ SUMP: ACCESS CATCH BASIN W/ SUMP] , [ACCESS CLEANOUT HOUSE: ACCESS CLEANOUT HOUSE] , ...8 more... )
• assettype ( type: esriFieldTypeString, alias: Asset Type, length: 25 , Coded Values: [MANHOLE: MANHOLE] )
• assetsubtype ( type: esriFieldTypeString, alias: Asset Subtype, length: 50 , Coded Values: [DIVERSION/JUNCTION: DIVERSION/JUNCTION] , [SEDIMENT TRAP/SETTLING BASIN: SEDIMENT TRAP/SETTLING BASIN] , [DROP: DROP] , ...4 more... )
• floodingevidence ( type: esriFieldTypeString, alias: Evidence of Flooding? , length: 10 , Coded Values: [YES: YES] , [NO: NO] )
• cracksordamage ( type: esriFieldTypeString, alias: Presence of Cracks or Damage, length: 10 , Coded Values: [YES: YES] , [NO: NO] )
• sedimentdebris ( type: esriFieldTypeString, alias: Sediment & Debris Build-Up?, length: 20 , Coded Values: [NONE: NONE] , [LOW: LOW] , [MEDIUM: MEDIUM] , ...1 more... )
• typeofdebris ( type: esriFieldTypeString, alias: Type of Debris (e.g., leaves, trash), length: 255 )
• flowcontrol ( type: esriFieldTypeString, alias: Flow Control , length: 10 , Coded Values: [YES: YES] , [NO: NO] )
• flowobservations ( type: esriFieldTypeString, alias: Flow Observations, length: 255 )
• rimtoinvert ( type: esriFieldTypeDouble, alias: Rim to Invert )
• rimtolp ( type: esriFieldTypeDouble, alias: Rim to lowest point )
• rimtograde ( type: esriFieldTypeDouble, alias: Rim to grade )
• gradetoinvert ( type: esriFieldTypeDouble, alias: Grade to invert )
• northing ( type: esriFieldTypeDouble, alias: Northing )
• easting ( type: esriFieldTypeDouble, alias: Easting )
• elevation ( type: esriFieldTypeDouble, alias: Elevation )
• coordinatesystem ( type: esriFieldTypeString, alias: Coordinate System, length: 100 )
• verticaldatum ( type: esriFieldTypeString, alias: Vertical Datum, length: 100 )
• gpsaccuracy ( type: esriFieldTypeString, alias: GPS Accuracy, length: 25 , Coded Values: [SURVEY GRADE: SURVEY GRADE] )
• covertype ( type: esriFieldTypeString, alias: Cover Type, length: 50 , Coded Values: [GRATE INLET/SLOTTED DRAIN: GRATE INLET/SLOTTED DRAIN] , [COMBINATION INLET: COMBINATION INLET] , [TRENCH DRAIN: TRENCH DRAIN] , ...1 more... )
• featureshape ( type: esriFieldTypeString, alias: Feature Shape, length: 25 , Coded Values: [CIRCULAR: CIRCULAR] , [OVAL OR ELLIPTICAL: OVAL OR ELLIPTICAL] , [RECTANGULAR: RECTANGULAR] , ...2 more... )
• coversize ( type: esriFieldTypeDouble, alias: Size )
• coverwidth ( type: esriFieldTypeDouble, alias: Size Width )
• covermaterial ( type: esriFieldTypeString, alias: Cover Material, length: 50 , Coded Values: [ALUMINUM: ALUMINUM] , [CAST IRON: CAST IRON] , [CAST-IN-PLACE CONCRETE: CAST-IN-PLACE CONCRETE] , ...8 more... )
• coverholediameter ( type: esriFieldTypeDouble, alias: Vent Hole Diameter )
• coverholeno ( type: esriFieldTypeSmallInteger, alias: Hole Number )
• coverfit ( type: esriFieldTypeString, alias: Cover/Frame Fit, length: 25 , Coded Values: [GOOD: GOOD] , [OVERSIZED: OVERSIZED] , [ROCKS/WOBBLES: ROCKS/WOBBLES] , ...1 more... )
• covercondition ( type: esriFieldTypeString, alias: Cover Condition, length: 25 , Coded Values: [BOLTS MISSING: BOLTS MISSING] , [BROKEN: BROKEN] , [CORRODED/PITTED: CORRODED/PITTED] , ...5 more... )
• insertmaterial ( type: esriFieldTypeString, alias: Insert Material, length: 25 , Coded Values: [METAL: METAL] , [PLASTIC: PLASTIC] , [NONE: NONE] )
• insertcondition ( type: esriFieldTypeString, alias: Cover Insert Condition, length: 25 , Coded Values: [CORRODED/PITTED: CORRODED/PITTED] , [CRACKED: CRACKED] , [INSERT FELL: INSERT FELL] , ...3 more... )
• ringtype ( type: esriFieldTypeString, alias: Ring Type, length: 25 , Coded Values: [ADJUSTABLE: ADJUSTABLE] , [SOLID: SOLID] , [NONE: NONE] )
• ringmaterial ( type: esriFieldTypeString, alias: Ring Material, length: 50 , Coded Values: [CAST IRON: CAST IRON] , [CAST-IN-PLACE CONCRETE: CAST-IN-PLACE CONCRETE] , [PRECAST CONCRETE: PRECAST CONCRETE] , ...7 more... )
• ringcondition ( type: esriFieldTypeString, alias: Ring Condition, length: 25 , Coded Values: [BROKEN: BROKEN] , [CORRODED/PITTED: CORRODED/PITTED] , [CRACKED: CRACKED] , ...3 more... )
• ringdepth ( type: esriFieldTypeDouble, alias: Ring Depth )
• framematerial ( type: esriFieldTypeString, alias: Frame Material, length: 50 , Coded Values: [CAST IRON: CAST IRON] , [CAST-IN-PLACE CONCRETE: CAST-IN-PLACE CONCRETE] , [PRECAST CONCRETE: PRECAST CONCRETE] , ...7 more... )
• frameopeningdiameter ( type: esriFieldTypeDouble, alias: Clear Opening Diameter )
• frameopeningwidth ( type: esriFieldTypeDouble, alias: Clear Opening Width )
• framecondition ( type: esriFieldTypeString, alias: Frame Condition, length: 25 , Coded Values: [BROKEN: BROKEN] , [COATED: COATED] , [CORRODED/PITTED: CORRODED/PITTED] , ...4 more... )
• sealcondition ( type: esriFieldTypeString, alias: Seal Condition, length: 25 , Coded Values: [CRACKED: CRACKED] , [LOOSE: LOOSE] , [MISSING: MISSING] , ...3 more... )
• offsetdistance ( type: esriFieldTypeDouble, alias: Offset Distance )
• framedepth ( type: esriFieldTypeDouble, alias: Frame Depth )
• chimneypresent ( type: esriFieldTypeString, alias: Chimney Present, length: 10 , Coded Values: [YES: YES] , [NO: NO] )
• chimneyfirstmaterial ( type: esriFieldTypeString, alias: First Material, length: 50 , Coded Values: [ASBESTOS CEMENT: ASBESTOS CEMENT] , [BRICK: BRICK] , [CORRUGATED METAL: CORRUGATED METAL] , ...13 more... )
• chimneysecondmaterial ( type: esriFieldTypeString, alias: Second Material, length: 50 , Coded Values: [ASBESTOS CEMENT: ASBESTOS CEMENT] , [BRICK: BRICK] , [CORRUGATED METAL: CORRUGATED METAL] , ...13 more... )
• chimneyinflow ( type: esriFieldTypeString, alias: Chimney I/I, length: 25 , Coded Values: [NONE: NONE] , [STAINS: STAINS] , [WEEPER: WEEPER] , ...3 more... )
• chimneyopening ( type: esriFieldTypeDouble, alias: Clear Opening )
• chimneydepth ( type: esriFieldTypeDouble, alias: Chimney Depth )
• chimneylininginterior ( type: esriFieldTypeString, alias: Lining Interior, length: 25 , Coded Values: [BITUMASTIC: BITUMASTIC] , [CEMENTITIOUS: CEMENTITIOUS] , [CURED IN PLACE: CURED IN PLACE] , ...7 more... )
• chimneycondition ( type: esriFieldTypeString, alias: Chimney Condition, length: 25 , Coded Values: [DEFECTIVE: DEFECTIVE] , [GREAT: GREAT] , [UNK: UNK] )
• conetype ( type: esriFieldTypeString, alias: Cone Type, length: 50 , Coded Values: [CONICAL CENTERED (CONCENTRIC): CONICAL CENTERED (CONCENTRIC)] , [CONICAL OFF-CENTERED (ECCENTRIC): CONICAL OFF-CENTERED (ECCENTRIC)] , [FLAT TOP: FLAT TOP] , ...1 more... )
• conematerial ( type: esriFieldTypeString, alias: Cone Material, length: 50 , Coded Values: [ASBESTOS CEMENT: ASBESTOS CEMENT] , [BRICK: BRICK] , [CORRUGATED METAL: CORRUGATED METAL] , ...12 more... )
• conedepth ( type: esriFieldTypeDouble, alias: Cone Depth )
• conelininginterior ( type: esriFieldTypeString, alias: Cone Lining Interior, length: 25 , Coded Values: [BITUMASTIC: BITUMASTIC] , [CEMENTITIOUS: CEMENTITIOUS] , [CURED IN PLACE: CURED IN PLACE] , ...7 more... )
• coneliningexterior ( type: esriFieldTypeString, alias: Cone Lining Exterior, length: 25 , Coded Values: [BITUMASTIC: BITUMASTIC] , [CEMENTITIOUS: CEMENTITIOUS] , [CURED IN PLACE: CURED IN PLACE] , ...7 more... )
• conecondition ( type: esriFieldTypeString, alias: Cone Condition, length: 25 , Coded Values: [DEFECTIVE: DEFECTIVE] , [GREAT: GREAT] , [UNK: UNK] )
• wallmaterial ( type: esriFieldTypeString, alias: Wall Material, length: 50 , Coded Values: [ASBESTOS CEMENT: ASBESTOS CEMENT] , [BRICK: BRICK] , [CORRUGATED METAL: CORRUGATED METAL] , ...12 more... )
• walldepth ( type: esriFieldTypeDouble, alias: Wall Depth )
• walllining ( type: esriFieldTypeString, alias: Wall Lining, length: 25 , Coded Values: [BITUMASTIC: BITUMASTIC] , [CEMENTITIOUS: CEMENTITIOUS] , [CURED IN PLACE: CURED IN PLACE] , ...7 more... )
• wallcondition ( type: esriFieldTypeString, alias: Wall Condition, length: 25 , Coded Values: [DEFECTIVE: DEFECTIVE] , [GREAT: GREAT] , [UNK: UNK] )
• benchpresent ( type: esriFieldTypeString, alias: Bench Present, length: 25 , Coded Values: [PARTIAL: PARTIAL] , [NONE: NONE] , [YES: YES] )
• benchmaterial ( type: esriFieldTypeString, alias: Bench Material, length: 50 , Coded Values: [ASBESTOS CEMENT: ASBESTOS CEMENT] , [ALUMINUM: ALUMINUM] , [BRICK: BRICK] , ...13 more... )
• benchlining ( type: esriFieldTypeString, alias: Bench Lining, length: 25 , Coded Values: [BITUMASTIC: BITUMASTIC] , [CEMENTITIOUS: CEMENTITIOUS] , [CURED IN PLACE: CURED IN PLACE] , ...7 more... )
• benchcondition ( type: esriFieldTypeString, alias: Bench Condition, length: 25 , Coded Values: [DEFECTIVE: DEFECTIVE] , [GREAT: GREAT] , [UNK: UNK] )
• channelpresent ( type: esriFieldTypeString, alias: Channel Present, length: 10 , Coded Values: [YES: YES] , [NO: NO] )
• channelmaterial ( type: esriFieldTypeString, alias: Channel Material, length: 50 , Coded Values: [ASBESTOS CEMENT: ASBESTOS CEMENT] , [BRICK: BRICK] , [CORRUGATED METAL: CORRUGATED METAL] , ...12 more... )
• channeltype ( type: esriFieldTypeString, alias: Channel Type, length: 25 , Coded Values: [FORMED: FORMED] , [INSERT: INSERT] , [PIPE: PIPE] , ...1 more... )
• channelexposure ( type: esriFieldTypeString, alias: Channel Exposure, length: 25 , Coded Values: [CLOSED: CLOSED] , [FULLY OPEN: FULLY OPEN] , [PARTIALLY OPEN: PARTIALLY OPEN] )
• channelcondition ( type: esriFieldTypeString, alias: Channel Condition, length: 25 , Coded Values: [DEFECTIVE: DEFECTIVE] , [GREAT: GREAT] , [UNK: UNK] )
• stepsno ( type: esriFieldTypeSmallInteger, alias: Number of Steps )
• stepsmaterial ( type: esriFieldTypeString, alias: Steps Material, length: 25 , Coded Values: [BRICK: BRICK] , [METAL: METAL] , [PLASTIC: PLASTIC] , ...1 more... )
• additionalinfo ( type: esriFieldTypeString, alias: Additional Component Information, length: 255 )
• globalid ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• invertelevation ( type: esriFieldTypeDouble, alias: Invert Elevation )

Relationships:

• geohub.GIS.Manhole (1) -- Related To: Manholes (1)

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

  Iteminfo   Thumbnail   Metadata