20230512 14075300 1.0 FALSE MACP_InspRatingsCombined 002 20230522 09173400 20230522 09173400 Esri ArcGIS 13.1.0.41833 MACP_InspRatingsCombined Enterprise Geodatabase Table dataset MACP_InspRatingsCombined Table 0 OBJECTID InspectionID OID 4 10 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. Surveyed_By Surveyed_By String 25 0 0 Certificate_Number Certificate_Number String 15 0 0 Reviewed_By Reviewed_By String 25 0 0 Reviewer_Certificate_Number Reviewer_Certificate_Number String 15 0 0 Owner Owner String 30 0 0 Customer Customer String 30 0 0 PO_Number PO_Number String 15 0 0 WorkOrder WorkOrder String 20 0 0 Media_Label Media_Label String 64 0 0 Project Project String 64 0 0 Inspection_Date Inspection_Date Date 8 0 0 Inspection_Time Inspection_Time Date 8 0 0 Sheet_Number Sheet_Number Integer 4 10 0 Weather Weather String 1 0 0 PreCleaning PreCleaning String 1 0 0 Date_Cleaned Date_Cleaned Date 8 0 0 Purpose Purpose String 1 0 0 InspectionLevel InspectionLevel String 1 0 0 Inspection_Status Inspection_Status String 2 0 0 Consequence_Of_Failure Consequence_Of_Failure String 4 0 0 Drainage_Area Drainage_Area String 15 0 0 Manhole_Number Manhole_Number String 25 0 0 Street Street String 64 0 0 City City String 64 0 0 Location_Code Location_Code String 1 0 0 Surface_Type_Asphalt Surface_Type_Asphalt SmallInteger 2 5 0 Surface_Type_ConcretePavement Surface_Type_ConcretePavement SmallInteger 2 5 0 Surface_Type_ConcreteCollar Surface_Type_ConcreteCollar SmallInteger 2 5 0 Surface_Type_GrassDirt Surface_Type_GrassDirt SmallInteger 2 5 0 Surface_Type_Gravel Surface_Type_Gravel SmallInteger 2 5 0 Surface_Type_Other Surface_Type_Other SmallInteger 2 5 0 Inflow_Potential_from_Runoff Inflow_Potential_from_Runoff String 1 0 0 Location_Details Location_Details String 255 0 0 MH_Use MH_Use String 2 0 0 Access_Type Access_Type String 4 0 0 Year_Constructed Year_Constructed SmallInteger 2 5 0 Year_Renewed Year_Renewed SmallInteger 2 5 0 Evidence_Surcharge Evidence_Surcharge String 1 0 0 Rim_to_Invert Rim_to_Invert Double 8 38 8 Grade_to_Invert Grade_to_Invert Double 8 38 8 Rim_to_Grade Rim_to_Grade Double 8 38 8 Rim_to_Grade_Exposed Rim_to_Grade_Exposed Double 8 38 8 Northing Northing String 50 0 0 Easting Easting String 50 0 0 Elevation Elevation String 50 0 0 Coordinate_System Coordinate_System String 50 0 0 Vertical_Datum Vertical_Datum String 50 0 0 GPS_Accuracy GPS_Accuracy String 1 0 0 Additional_Info Additional_Info String 255 0 0 Cover_Type_Bolted Cover_Type_Bolted SmallInteger 2 5 0 Cover_Type_Gasketed Cover_Type_Gasketed SmallInteger 2 5 0 Cover_Type_Hatch_Double Cover_Type_Hatch_Double SmallInteger 2 5 0 Cover_Type_Hatch_Single Cover_Type_Hatch_Single SmallInteger 2 5 0 Cover_Type_Inner_Cover Cover_Type_Inner_Cover SmallInteger 2 5 0 Cover_Type_Lamphole Cover_Type_Lamphole SmallInteger 2 5 0 Cover_Type_Locking Cover_Type_Locking SmallInteger 2 5 0 Cover_Type_Removable_Center Cover_Type_Removable_Center SmallInteger 2 5 0 Cover_Type_Solid Cover_Type_Solid SmallInteger 2 5 0 Cover_Type_Vented Cover_Type_Vented SmallInteger 2 5 0 Cover_Shape Cover_Shape String 1 0 0 Cover_Size Cover_Size Double 8 38 8 Center_Cover_Size Center_Cover_Size Double 8 38 8 Cover_Size_Width Cover_Size_Width Double 8 38 8 Cover_Material Cover_Material String 3 0 0 Hole_Diameter Hole_Diameter String 1 0 0 Hole_Number Hole_Number SmallInteger 2 5 0 Cover_Bearing_Surface_Dia Cover_Bearing_Surface_Dia Double 8 38 8 Cover_Bearing_Surface_Width Cover_Bearing_Surface_Width Double 8 38 8 Cover_Frame_Fit Cover_Frame_Fit String 1 0 0 Cover_Condition_BoltsMissing Cover_Condition_BoltsMissing SmallInteger 2 5 0 Cover_Condition_Broken Cover_Condition_Broken SmallInteger 2 5 0 Cover_Condition_Corroded Cover_Condition_Corroded SmallInteger 2 5 0 Cover_Condition_Cracked Cover_Condition_Cracked SmallInteger 2 5 0 Cover_Condition_Missing Cover_Condition_Missing SmallInteger 2 5 0 Cover_Condition_Restraint_Defec Cover_Condition_Restraint_Defective SmallInteger 2 5 0 Cover_Condition_Restraint_Missi Cover_Condition_Restraint_Missing SmallInteger 2 5 0 Cover_Condition_Sound Cover_Condition_Sound SmallInteger 2 5 0 Cover_Insert_Type Cover_Insert_Type String 1 0 0 Insert_Condition_Cracked Insert_Condition_Cracked SmallInteger 2 5 0 Insert_Condition_Corroded Insert_Condition_Corroded SmallInteger 2 5 0 Insert_Condition_InsertFell Insert_Condition_InsertFell SmallInteger 2 5 0 Insert_Condition_Leaking Insert_Condition_Leaking SmallInteger 2 5 0 Insert_Condition_PoorlyFitting Insert_Condition_PoorlyFitting SmallInteger 2 5 0 Insert_Condition_Sound Insert_Condition_Sound SmallInteger 2 5 0 Adjustment_Ring_Type Adjustment_Ring_Type String 1 0 0 Adjustment_Ring_Material Adjustment_Ring_Material String 3 0 0 Ring_Condition_Broken Ring_Condition_Broken SmallInteger 2 5 0 Ring_Condition_Corroded Ring_Condition_Corroded SmallInteger 2 5 0 Ring_Condition_Cracked Ring_Condition_Cracked SmallInteger 2 5 0 Ring_Condition_Leaking Ring_Condition_Leaking SmallInteger 2 5 0 Ring_Condition_PoorInstall Ring_Condition_PoorInstall SmallInteger 2 5 0 Ring_Condition_Sound Ring_Condition_Sound SmallInteger 2 5 0 Adjustment_Ring_Height Adjustment_Ring_Height Double 8 38 8 Frame_Material Frame_Material String 3 0 0 Frame_Bearing_Surface_Width Frame_Bearing_Surface_Width Double 8 38 8 Frame_Bearing_Surface_Depth Frame_Bearing_Surface_Depth Double 8 38 8 Frame_Clear_Open_Diam Frame_Clear_Open_Diam Double 8 38 8 Frame_Clear_Open_Width Frame_Clear_Open_Width Double 8 38 8 Frame_Condition_Broken Frame_Condition_Broken SmallInteger 2 5 0 Frame_Condition_Coated Frame_Condition_Coated SmallInteger 2 5 0 Frame_Condition_Corroded Frame_Condition_Corroded SmallInteger 2 5 0 Frame_Condition_Cracked Frame_Condition_Cracked SmallInteger 2 5 0 Frame_Condition_Missing Frame_Condition_Missing SmallInteger 2 5 0 Frame_Condition_Sound Frame_Condition_Sound SmallInteger 2 5 0 Seal_Condition_Cracked Seal_Condition_Cracked SmallInteger 2 5 0 Seal_Condition_Loose Seal_Condition_Loose SmallInteger 2 5 0 Seal_Condition_Missing Seal_Condition_Missing SmallInteger 2 5 0 Seal_Condition_Offset Seal_Condition_Offset SmallInteger 2 5 0 Seal_Condition_Sound Seal_Condition_Sound SmallInteger 2 5 0 Frame_Offset_Distance Frame_Offset_Distance Double 8 38 8 Frame_Seal_Inflow Frame_Seal_Inflow String 2 0 0 Frame_Depth Frame_Depth Double 8 38 8 Chimney_Present Chimney_Present String 1 0 0 Chimney_Material1 Chimney_Material1 String 3 0 0 Chimney_Material2 Chimney_Material2 String 3 0 0 Chimney_InI Chimney_InI String 2 0 0 Chimney_Clear_Opening Chimney_Clear_Opening Double 8 38 8 Chimney_Depth Chimney_Depth Double 8 38 8 Chimney_Lining_Interior Chimney_Lining_Interior String 3 0 0 Chimney_Lining_Exterior Chimney_Lining_Exterior String 3 0 0 Chimney_Condition Chimney_Condition String 1 0 0 Cone_Type Cone_Type String 2 0 0 Cone_Material Cone_Material String 3 0 0 Cone_Depth Cone_Depth Double 8 38 8 Cone_Lining_Interior Cone_Lining_Interior String 3 0 0 Cone_Lining_Exterior Cone_Lining_Exterior String 3 0 0 Cone_Condition Cone_Condition String 1 0 0 Wall_Diam Wall_Diam SmallInteger 2 5 0 Wall_BySize Wall_BySize SmallInteger 2 5 0 Wall_Material Wall_Material String 3 0 0 Wall_Depth Wall_Depth Double 8 38 8 Wall_Lining_Interior Wall_Lining_Interior String 3 0 0 Wall_Lining_Exterior Wall_Lining_Exterior String 3 0 0 Wall_Condition Wall_Condition String 1 0 0 Bench_Present Bench_Present String 1 0 0 Bench_Material Bench_Material String 3 0 0 Bench_Lining Bench_Lining String 3 0 0 Bench_Condition Bench_Condition String 1 0 0 Channel_Installed Channel_Installed String 50 0 0 Channel_Material Channel_Material String 3 0 0 Channel_Type Channel_Type String 1 0 0 Channel_Exposure Channel_Exposure String 1 0 0 Channel_Condition Channel_Condition String 1 0 0 Step_Number Step_Number SmallInteger 2 5 0 Step_Material Step_Material String 1 0 0 AdditionalComponentInfo AdditionalComponentInfo String 255 0 0 IsImperial IsImperial SmallInteger 2 5 0 OBJECTID_1 RatingID Integer 4 10 0 InspectionID InspectionID Integer 4 10 0 STGradeScore1 STGradeScore1 Double 8 38 8 STGradeScore2 STGradeScore2 Double 8 38 8 STGradeScore3 STGradeScore3 Double 8 38 8 STGradeScore4 STGradeScore4 Double 8 38 8 STGradeScore5 STGradeScore5 Double 8 38 8 OMGradeScore1 OMGradeScore1 Double 8 38 8 OMGradeScore2 OMGradeScore2 Double 8 38 8 OMGradeScore3 OMGradeScore3 Double 8 38 8 OMGradeScore4 OMGradeScore4 Double 8 38 8 OMGradeScore5 OMGradeScore5 Double 8 38 8 STMHRating STMHRating Double 8 38 8 OMMHRating OMMHRating Double 8 38 8 OverallMHRating OverallMHRating Double 8 38 8 STQuickRating STQuickRating String 4 0 0 OMQuickRating OMQuickRating String 4 0 0 MACPQuickRating MACPQuickRating String 4 0 0 STMHRatingsIndex STMHRatingsIndex Double 8 38 8 OMMHRatingsIndex OMMHRatingsIndex Double 8 38 8 OverallMHRatingsIndex OverallMHRatingsIndex Double 8 38 8 LoFMACP LoFMACP Double 8 38 8 Risk Risk Double 8 38 8 CoverType CoverType String 255 0 0 CoverCondition CoverCondition String 255 0 0 InsertCondition InsertCondition String 255 0 0 RingCondition RingCondition String 255 0 0 FrameCondition FrameCondition String 255 0 0 SealCondition SealCondition String 255 0 0 SurfaceType SurfaceType String 255 0 0 20230522