Name: Manhole Inspections

Display Field: StreetNameNo

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 21dbed1f1fc24274971f8831044fe09e

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• InspectionID ( type: esriFieldTypeString, alias: Inspection ID, length: 35 )
• Surveyed_By ( type: esriFieldTypeString, alias: Surveyed By, length: 25 )
• Certificate_Number ( type: esriFieldTypeString, alias: Certificate Number, length: 15 )
• Owner ( type: esriFieldTypeString, alias: Owner, length: 30 )
• Customer ( type: esriFieldTypeString, alias: Customer, length: 30 )
• Drainage_Area ( type: esriFieldTypeString, alias: Drainage Area, length: 15 )
• PO_Number ( type: esriFieldTypeString, alias: Purchase Order Number, length: 15 )
• Date_Time ( type: esriFieldTypeDate, alias: Inspection Date and Time, length: 8 )
• StreetNameNo ( type: esriFieldTypeString, alias: Street Name and Number, length: 100 )
• City ( type: esriFieldTypeString, alias: City, length: 64 )
• Location_Details ( type: esriFieldTypeString, alias: Location Details, length: 255 )
• Manhole_Number ( type: esriFieldTypeString, alias: Manhole Number, length: 25 )
• Rim_to_Invert ( type: esriFieldTypeDouble, alias: Rim to Invert )
• Grade_to_Invert ( type: esriFieldTypeDouble, alias: Grade to Invert )
• Rim_to_Grade ( type: esriFieldTypeDouble, alias: Rim to Grade )
• MH_Use ( type: esriFieldTypeString, alias: MH Use, length: 15 )
• Year_Built ( type: esriFieldTypeSmallInteger, alias: Year Built )
• Year_Renewed ( type: esriFieldTypeSmallInteger, alias: Year Renewed )
• Purpose ( type: esriFieldTypeString, alias: Purpose, length: 64 )
• Category ( type: esriFieldTypeString, alias: Sewer Category Code, length: 2 )
• Pre_Cleaning ( type: esriFieldTypeString, alias: Pre Cleaning, length: 15 )
• Date_Cleaned ( type: esriFieldTypeDate, alias: Date Cleaned, length: 8 )
• Weather ( type: esriFieldTypeString, alias: Weather, length: 12 )
• Location_Code ( type: esriFieldTypeString, alias: Location Code, length: 30 )
• Additional_Info ( type: esriFieldTypeString, alias: Additional Info, length: 255 )
• Surface_Type ( type: esriFieldTypeString, alias: Surface Type, length: 100 )
• Surface_Type_Additional ( type: esriFieldTypeString, alias: Additional Surface Type, length: 250 )
• Potential_for_Runoff ( type: esriFieldTypeString, alias: Potential for Runoff, length: 50 )
• Access_Type ( type: esriFieldTypeString, alias: Access Type, length: 50 )
• Northing ( type: esriFieldTypeString, alias: Northing, length: 50 )
• Easting ( type: esriFieldTypeString, alias: Easting, length: 50 )
• Elevation ( type: esriFieldTypeString, alias: Elevation, length: 50 )
• Coordinate_System ( type: esriFieldTypeString, alias: Coordinate System, length: 50 )
• GPS_Accuracy ( type: esriFieldTypeString, alias: GPS Accuracy, length: 50 )
• Inspection_Status ( type: esriFieldTypeString, alias: Inspection Status, length: 50 )
• Evidence_Surcharge ( type: esriFieldTypeSmallInteger, alias: Evidence Surcharge )
• Cover_Shape ( type: esriFieldTypeString, alias: Cover Shape, length: 50 )
• Cover_Size ( type: esriFieldTypeDouble, alias: Cover Size )
• Cover_Size_Width ( type: esriFieldTypeDouble, alias: Cover Size Width(For Non Circular) )
• Cover_Material ( type: esriFieldTypeString, alias: Cover Material, length: 50 )
• Cover_Type_Solid_Vented ( type: esriFieldTypeString, alias: Cover Type Solid or Vented, length: 10 )
• Cover_Type ( type: esriFieldTypeString, alias: Cover Type, length: 50 )
• Cover_Type_Additional ( type: esriFieldTypeString, alias: Additional Cover Attributes, length: 100 )
• Hole_Diameter ( type: esriFieldTypeString, alias: Hole Diameter, length: 5 )
• Hole_Number ( type: esriFieldTypeSmallInteger, alias: Number of Hole Vents )
• Cover_Bearing_Surf_Dia ( type: esriFieldTypeDouble, alias: Cover Bearing Surface Dia )
• Cover_Bearing_Surf_Dia_Width ( type: esriFieldTypeDouble, alias: Cover Bearing Surface Dia Width )
• Cover_Frame_Fit ( type: esriFieldTypeString, alias: Cover Frame Fit, length: 5 )
• Cover_Condition ( type: esriFieldTypeString, alias: Cover Condition, length: 50 )
• Cover_Condition_Additional ( type: esriFieldTypeString, alias: Additional Cover Conditions, length: 50 )
• Cover_Insert_Type ( type: esriFieldTypeString, alias: Cover Insert Type, length: 50 )
• Insert_Condition ( type: esriFieldTypeString, alias: Insert Conditions, length: 50 )
• Insert_Condition_Additional ( type: esriFieldTypeString, alias: Additional Insert Conditions, length: 50 )
• Adjustment_Ring_Type ( type: esriFieldTypeString, alias: Adjustment Ring Type, length: 50 )
• Ring_Condition ( type: esriFieldTypeString, alias: Ring Condition, length: 50 )
• Ring_Condition_Additional ( type: esriFieldTypeString, alias: Additional Ring Conditions, length: 50 )
• Adjustment_Ring_Height ( type: esriFieldTypeDouble, alias: Adjustment Ring Height )
• Frame_Material ( type: esriFieldTypeString, alias: Frame Material, length: 50 )
• Frame_Bearing_Surface_Width ( type: esriFieldTypeDouble, alias: Frame Bearing Surface Width )
• Frame_Bearing_Surface_Depth ( type: esriFieldTypeDouble, alias: Frame Bearing Surface Depth )
• Frame_Clear_Open_Diam ( type: esriFieldTypeDouble, alias: Frame Clear Open Diam )
• Frame_Condition ( type: esriFieldTypeString, alias: Frame Condition, length: 50 )
• Frame_Condition_Additional ( type: esriFieldTypeString, alias: Additional Frame Conditions, length: 50 )
• Seal_Condition ( type: esriFieldTypeString, alias: Seal Condition, length: 50 )
• Seal_Condition_Additional ( type: esriFieldTypeString, alias: Additional Seal Conditions, length: 50 )
• Frame_Offset_Distance ( type: esriFieldTypeInteger, alias: Frame Offset Distance )
• Frame_Seal_Inflow ( type: esriFieldTypeString, alias: Frame Seal Inflow, length: 50 )
• Frame_Depth ( type: esriFieldTypeDouble, alias: Frame Depth )
• Chimney_Material1 ( type: esriFieldTypeString, alias: Chimney Material1, length: 50 )
• Chimney_Material2 ( type: esriFieldTypeString, alias: Chimney Material2, length: 50 )
• Chimney_InI ( type: esriFieldTypeString, alias: Chimney InI, length: 50 )
• Chimney_Clear_Opening ( type: esriFieldTypeSmallInteger, alias: Chimney Clear Opening )
• Chimney_Depth ( type: esriFieldTypeDouble, alias: Chimney Depth )
• Chimney_Lining_Interior ( type: esriFieldTypeString, alias: Chimney Lining Interior, length: 50 )
• Chimney_Lining_Exterior ( type: esriFieldTypeString, alias: Chimney Lining Exterior, length: 50 )
• Cone_Type ( type: esriFieldTypeString, alias: Cone Type, length: 50 )
• Cone_Material ( type: esriFieldTypeString, alias: Cone Material, length: 50 )
• Cone_Depth ( type: esriFieldTypeDouble, alias: Cone Depth )
• Cone_Lining_Interior ( type: esriFieldTypeString, alias: Cone Lining Interior, length: 50 )
• Cone_Lining_Exterior ( type: esriFieldTypeString, alias: Cone Lining Exterior, length: 50 )
• Wall_Diam ( type: esriFieldTypeSmallInteger, alias: Wall Diam )
• Wall_BySize ( type: esriFieldTypeSmallInteger, alias: Wall By Size )
• Wall_Material ( type: esriFieldTypeString, alias: Wall Material, length: 50 )
• Wall_Depth ( type: esriFieldTypeDouble, alias: Wall Depth )
• Wall_Lining_Interior ( type: esriFieldTypeString, alias: Wall Lining Interior, length: 50 )
• Wall_Lining_Exterior ( type: esriFieldTypeString, alias: Wall Lining Exterior, length: 50 )
• Bench_Present ( type: esriFieldTypeString, alias: Bench Present, length: 5 )
• Bench_Material ( type: esriFieldTypeString, alias: Bench Material, length: 50 )
• Bench_Lining ( type: esriFieldTypeString, alias: Bench Lining, length: 50 )
• Channel_Installed ( type: esriFieldTypeSmallInteger, alias: Channel Installed )
• Channel_Material ( type: esriFieldTypeString, alias: Channel Material, length: 50 )
• Channel_Type ( type: esriFieldTypeString, alias: Channel Type, length: 50 )
• Channel_Exposure ( type: esriFieldTypeString, alias: Channel Exposure, length: 50 )
• Step_Number ( type: esriFieldTypeSmallInteger, alias: Number of Manhole Steps )
• Step_Material ( type: esriFieldTypeString, alias: Step Material, length: 50 )
• WorkOrder ( type: esriFieldTypeString, alias: WorkOrder, length: 20 )
• Project ( type: esriFieldTypeString, alias: Project, length: 64 )
• PressureValue ( type: esriFieldTypeDouble, alias: Pressure Value )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• 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 )
• ManholeID ( type: esriFieldTypeGUID, alias: Manhole ID, length: 38 )

Relationships:

• ssManhole (0) -- Related To: Manholes (6)

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

  Iteminfo   Thumbnail   Metadata