Name: manhole_inspection_manhole_inspection

Display Field:

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: objectid

Unique ID Field:

Name : objectid

IsSystemMaintained : True

Global ID Field: globalid

Type ID Field:

Fields:

• objectid (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• inspectionid (type: esriFieldTypeString, alias: Inspection ID, SQL Type: sqlTypeOther, length: 35, nullable: false, editable: true)
• surveyedby (type: esriFieldTypeString, alias: Surveyed By, SQL Type: sqlTypeOther, length: 25, nullable: false, editable: true)
• certificatenumber (type: esriFieldTypeString, alias: Certificate Number, SQL Type: sqlTypeOther, length: 15, nullable: false, editable: true)
• owner (type: esriFieldTypeString, alias: Owner, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• customer (type: esriFieldTypeString, alias: Customer, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• drainagearea (type: esriFieldTypeString, alias: Drainage Area, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• ponumber (type: esriFieldTypeString, alias: Purchase Order Number, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• datetime (type: esriFieldTypeDate, alias: Inspection Date and Time, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: true)
• streetnameno (type: esriFieldTypeString, alias: Street Name and Number, SQL Type: sqlTypeOther, length: 100, nullable: false, editable: true)
• city (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 64, nullable: false, editable: true)
• locationdetails (type: esriFieldTypeString, alias: Location Details, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• manholenumber (type: esriFieldTypeString, alias: Manhole Number, SQL Type: sqlTypeOther, length: 25, nullable: false, editable: true)
• rimtoinvert (type: esriFieldTypeDouble, alias: Rim to Invert, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 99.9899978637695])
• gradetoinvert (type: esriFieldTypeDouble, alias: Grade to Invert, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 99.9899978637695])
• rimtograde (type: esriFieldTypeDouble, alias: Rim to Grade, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [-999 - 999])
• mhuse (type: esriFieldTypeString, alias: MH Use, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [CB: Combined], [FM: Force Main], [ZZ: Other], ... 3 more ...)
• yearbuilt (type: esriFieldTypeSmallInteger, alias: Year Built, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [1800 - 2200])
• yearrenewed (type: esriFieldTypeSmallInteger, alias: Year Renewed, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [1800 - 2200])
• purpose (type: esriFieldTypeString, alias: Purpose, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true, Coded Values: [G: Capital Improvement Program Assessment], [B: Infiltration/Inflow Investigation], [A: Maintenance Related], ... 7 more ...)
• category (type: esriFieldTypeString, alias: Sewer Category Code, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• precleaning (type: esriFieldTypeString, alias: Pre Cleaning, SQL Type: sqlTypeOther, length: 15, nullable: false, editable: true, Coded Values: [J: Jetting], [H: Heavy Cleaning], [N: No Pre-Cleaning], ... 1 more ...)
• datecleaned (type: esriFieldTypeDate, alias: Date Cleaned, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• weather (type: esriFieldTypeString, alias: Weather, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true, Coded Values: [6: Damp], [1: Dry], [2: Heavy Rain], ... 4 more ...)
• locationcode (type: esriFieldTypeString, alias: Location Code, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [M: Airport], [H: Alley], [J: Building], ... 12 more ...)
• additionalinfo (type: esriFieldTypeString, alias: Additional Info, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• surfacetype (type: esriFieldTypeString, alias: Surface Type, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Asphalt: Asphalt], [Concrete Pavement: Concrete Pavement], [Concrete Collar: Concrete Collar], ... 3 more ...)
• surfacetypeadditional (type: esriFieldTypeString, alias: Additional Surface Type, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• potentialforrunoff (type: esriFieldTypeString, alias: Potential for Runoff, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [I: Inundated], [N: None], [P: Ponding], ... 1 more ...)
• accesstype (type: esriFieldTypeString, alias: Access Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [ACB: Catch Basin], [ACOH: Clean Out House], [ACOM: Clean Out Mainline], ... 7 more ...)
• northing (type: esriFieldTypeString, alias: Northing, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• easting (type: esriFieldTypeString, alias: Easting, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• elevation (type: esriFieldTypeString, alias: Elevation, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• coordinatesystem (type: esriFieldTypeString, alias: Coordinate System, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• gpsaccuracy (type: esriFieldTypeString, alias: GPS Accuracy, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [N: Nearest meter], [M: Sub-Meter], [L: Survey level])
• inspectionstatus (type: esriFieldTypeString, alias: Inspection Status, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true, Coded Values: [BM: Buried or Marked], [NI: NI Traffic], [NA: No Access], ... 6 more ...)
• evidencesurcharge (type: esriFieldTypeSmallInteger, alias: Evidence Surcharge, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• covershape (type: esriFieldTypeString, alias: Cover Shape, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [A: Arched], [B: Barrel], [C: Circular], ... 8 more ...)
• coversize (type: esriFieldTypeDouble, alias: Cover Size, SQL Type: sqlTypeOther, nullable: true, editable: true)
• coversizewidth (type: esriFieldTypeDouble, alias: Cover Size Width(For Non Circular), SQL Type: sqlTypeOther, nullable: true, editable: true)
• covermaterial (type: esriFieldTypeString, alias: Cover Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [AC: Asbestos Cement], [BR: Brick], [CAS: Cast Iron], ... 23 more ...)
• covertypesolidvented (type: esriFieldTypeString, alias: Cover Type Solid or Vented, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Solid: Solid], [Vented: Vented/Slots])
• covertype (type: esriFieldTypeString, alias: Cover Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Gasketed: Gasketed], [Bolted: Bolted], [Inner Cover: Inner Cover], ... 7 more ...)
• covertypeadditional (type: esriFieldTypeString, alias: Additional Cover Attributes, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• holediameter (type: esriFieldTypeString, alias: Hole Diameter, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [A: <= 1/2 inch (13mm)], [D: > 1 1/2 inch (38mm) <= 2 inch(50mm)], [C: > 1 inch (25mm) <= 1 1/2 inch (38mm)], ... 2 more ...)
• holenumber (type: esriFieldTypeSmallInteger, alias: Number of Hole Vents, SQL Type: sqlTypeOther, nullable: true, editable: true)
• coverbearingsurfdia (type: esriFieldTypeDouble, alias: Cover Bearing Surface Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• coverbearingsurfdiawidth (type: esriFieldTypeDouble, alias: Cover Bearing Surface Diameter Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
• coverframefit (type: esriFieldTypeString, alias: Cover Frame Fit, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [G: Good], [O: Oversized], [R: Rocks/Wobbles], ... 1 more ...)
• covercondition (type: esriFieldTypeString, alias: Cover Condition, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Sound: Sound], [Cracked: Cracked], [Broken: Broken], ... 3 more ...)
• coverconditionadditional (type: esriFieldTypeString, alias: Additional Cover Conditions, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• coverinserttype (type: esriFieldTypeString, alias: Cover Insert Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [M: Metal], [Z: Other], [P: Plastic])
• insertcondition (type: esriFieldTypeString, alias: Insert Conditions, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Sound: Sound], [Poorly Fitted: Poorly Fitted], [Cracked/Torn/Holes: Cracked/Torn/Holes], ... 2 more ...)
• insertconditionadditional (type: esriFieldTypeString, alias: Additional Insert Conditions, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• adjustmentringtype (type: esriFieldTypeString, alias: Adjustment Ring Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [A: Adjustable], [S: Solid])
• ringcondition (type: esriFieldTypeString, alias: Ring Condition, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Sound: Sound], [Cracked: Cracked], [Broken: Broken], ... 2 more ...)
• ringconditionadditional (type: esriFieldTypeString, alias: Additional Ring Conditions, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• adjustmentringheight (type: esriFieldTypeDouble, alias: Adjustment Ring Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
• framematerial (type: esriFieldTypeString, alias: Frame Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [AC: Asbestos Cement], [BR: Brick], [CAS: Cast Iron], ... 23 more ...)
• framebearingsurfacewidth (type: esriFieldTypeDouble, alias: Frame Bearing Surface Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
• framebearingsurfacedepth (type: esriFieldTypeDouble, alias: Frame Bearing Surface Depth, SQL Type: sqlTypeOther, nullable: true, editable: true)
• frameclearopendiam (type: esriFieldTypeDouble, alias: Frame Clear Open Diam, SQL Type: sqlTypeOther, nullable: true, editable: true)
• framecondition (type: esriFieldTypeString, alias: Frame Condition, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Sound: Sound], [Cracked: Cracked], [Broken: Broken], ... 3 more ...)
• frameconditionadditional (type: esriFieldTypeString, alias: Additional Frame Conditions, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• sealcondition (type: esriFieldTypeString, alias: Seal Condition, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Sound: Sound], [Cracked: Cracked], [Loose/Not Attached: Loose/Not Attached], ... 1 more ...)
• sealconditionadditional (type: esriFieldTypeString, alias: Additional Seal Conditions, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• frameoffsetdistance (type: esriFieldTypeInteger, alias: Frame Offset Distance, SQL Type: sqlTypeOther, nullable: true, editable: true)
• framesealinflow (type: esriFieldTypeString, alias: Frame Seal Inflow, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [ID: Infil Dripper], [IG: Infil Gusher], [IR: Infil Runner], ... 3 more ...)
• framedepth (type: esriFieldTypeDouble, alias: Frame Depth, SQL Type: sqlTypeOther, nullable: true, editable: true)
• chimneymaterial1 (type: esriFieldTypeString, alias: Chimney Material1, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [AC: Asbestos Cement], [BR: Brick], [CAS: Cast Iron], ... 23 more ...)
• chimneymaterial2 (type: esriFieldTypeString, alias: Chimney Material2, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [AC: Asbestos Cement], [BR: Brick], [CAS: Cast Iron], ... 23 more ...)
• chimneyini (type: esriFieldTypeString, alias: Chimney InI, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [ID: Infil Dripper], [IG: Infil Gusher], [IR: Infil Runner], ... 3 more ...)
• chimneyclearopening (type: esriFieldTypeSmallInteger, alias: Chimney Clear Opening, SQL Type: sqlTypeOther, nullable: true, editable: true)
• chimneydepth (type: esriFieldTypeDouble, alias: Chimney Depth, SQL Type: sqlTypeOther, nullable: true, editable: true)
• chimneylininginterior (type: esriFieldTypeString, alias: Chimney Lining Interior, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [B: Bitumastic], [C: Cementitious], [CP: Cured in Place], ... 7 more ...)
• chimneyliningexterior (type: esriFieldTypeString, alias: Chimney Lining Exterior, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [B: Bitumastic], [C: Cementitious], [CP: Cured in Place], ... 7 more ...)
• conetype (type: esriFieldTypeString, alias: Cone Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [CC: Conical centered], [CO: Conical off centered], [FT: Flattop])
• conematerial (type: esriFieldTypeString, alias: Cone Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [AC: Asbestos Cement], [BR: Brick], [CAS: Cast Iron], ... 23 more ...)
• conedepth (type: esriFieldTypeDouble, alias: Cone Depth, SQL Type: sqlTypeOther, nullable: true, editable: true)
• conelininginterior (type: esriFieldTypeString, alias: Cone Lining Interior, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [B: Bitumastic], [C: Cementitious], [CP: Cured in Place], ... 7 more ...)
• coneliningexterior (type: esriFieldTypeString, alias: Cone Lining Exterior, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [B: Bitumastic], [C: Cementitious], [CP: Cured in Place], ... 7 more ...)
• walldiam (type: esriFieldTypeSmallInteger, alias: Wall Diam, SQL Type: sqlTypeOther, nullable: true, editable: true)
• wallbysize (type: esriFieldTypeSmallInteger, alias: Wall By Size, SQL Type: sqlTypeOther, nullable: true, editable: true)
• wallmaterial (type: esriFieldTypeString, alias: Wall Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [AC: Asbestos Cement], [BR: Brick], [CAS: Cast Iron], ... 23 more ...)
• walldepth (type: esriFieldTypeDouble, alias: Wall Depth, SQL Type: sqlTypeOther, nullable: true, editable: true)
• walllininginterior (type: esriFieldTypeString, alias: Wall Lining Interior, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [B: Bitumastic], [C: Cementitious], [CP: Cured in Place], ... 7 more ...)
• wallliningexterior (type: esriFieldTypeString, alias: Wall Lining Exterior, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [B: Bitumastic], [C: Cementitious], [CP: Cured in Place], ... 7 more ...)
• benchpresent (type: esriFieldTypeString, alias: Bench Present, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [N: None], [P: Partial], [Y: Yes])
• benchmaterial (type: esriFieldTypeString, alias: Bench Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [AC: Asbestos Cement], [BR: Brick], [CAS: Cast Iron], ... 23 more ...)
• benchlining (type: esriFieldTypeString, alias: Bench Lining, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [B: Bitumastic], [C: Cementitious], [CP: Cured in Place], ... 7 more ...)
• channelinstalled (type: esriFieldTypeSmallInteger, alias: Channel Installed, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• channelmaterial (type: esriFieldTypeString, alias: Channel Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• channeltype (type: esriFieldTypeString, alias: Channel Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [F: Formed], [I: Insert], [P: Pipe], ... 1 more ...)
• channelexposure (type: esriFieldTypeString, alias: Channel Exposure, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [C: Closed], [F: Fully Opened], [P: Partially Opened])
• stepnumber (type: esriFieldTypeSmallInteger, alias: Number of Manhole Steps, SQL Type: sqlTypeOther, nullable: true, editable: true)
• stepmaterial (type: esriFieldTypeString, alias: Step Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [B: Brick], [M: Metal], [Z: Other], ... 1 more ...)
• workorder (type: esriFieldTypeString, alias: WorkOrder, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• project (type: esriFieldTypeString, alias: Project, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• pressurevalue (type: esriFieldTypeDouble, alias: Pressure Value, SQL Type: sqlTypeOther, nullable: true, editable: true)
• assetguid (type: esriFieldTypeGUID, alias: Asset GUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Relationships:

• manhole_inspection_0_1 (0) -- Related To: manhole_inspection_sewer_manhole (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/20/2022 7:51:06 PM

Schema Last Edit Date: 10/20/2022 7:51:06 PM

Data Last Edit Date: 10/20/2022 7:51:06 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Boxplots   Query Related Records   Query Attachments   Add Features   Update Features   Delete Features   Apply Edits   Streaming   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat