20230512 11452400 1.0 FALSE PACP_InspRatingsCombined 002 20230522 09112900 20230522 09112900 Esri ArcGIS 13.1.0.41833 PACP_InspRatingsCombined Enterprise Geodatabase Table dataset PACP_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 Flow_Control Flow_Control String 1 0 0 Purpose Purpose String 1 0 0 Direction Direction String 1 0 0 Inspection_Technology_Used_CCTV Inspection_Technology_Used_CCTV SmallInteger 2 5 0 Inspection_Technology_Used_Lase Inspection_Technology_Used_Laser SmallInteger 2 5 0 Inspection_Technology_Used_Sona Inspection_Technology_Used_Sonar SmallInteger 2 5 0 Inspection_Technology_Used_Side Inspection_Technology_Used_Sidewall SmallInteger 2 5 0 Inspection_Technology_Used_Zoom Inspection_Technology_Used_Zoom SmallInteger 2 5 0 Inspection_Technology_Used_Othe Inspection_Technology_Used_Other SmallInteger 2 5 0 Inspection_Status Inspection_Status String 2 0 0 Consequence_Of_Failure Consequence_Of_Failure String 4 0 0 Pressure_Value Pressure_Value Double 8 38 8 Drainage_Area Drainage_Area String 15 0 0 Pipe_Segment_Reference Pipe_Segment_Reference String 51 0 0 Street Street String 64 0 0 City City String 64 0 0 Location_Code Location_Code String 1 0 0 Location_Details Location_Details String 255 0 0 Pipe_Use Pipe_Use String 2 0 0 Height Height Integer 4 10 0 Width Width Integer 4 10 0 Shape Shape String 1 0 0 Feature geometry. Esri Coordinates defining the features. Material Material String 4 0 0 Lining_Method Lining_Method String 3 0 0 Coating_Method Coating_Method String 3 0 0 Pipe_Joint_Length Pipe_Joint_Length Double 8 38 8 Total_Length Total_Length Double 8 38 8 Length_Surveyed Length_Surveyed Double 8 38 8 Year_Constructed Year_Constructed Integer 4 10 0 Year_Renewed Year_Renewed Integer 4 10 0 Upstream_MH Upstream_MH String 25 0 0 Up_Rim_to_Invert Up_Rim_to_Invert Double 8 38 8 Up_Grade_to_Invert Up_Grade_to_Invert Double 8 38 8 Up_Rim_to_Grade Up_Rim_to_Grade Double 8 38 8 Up_Northing Up_Northing String 50 0 0 Up_Easting Up_Easting String 50 0 0 Up_Elevation Up_Elevation String 50 0 0 Downstream_MH Downstream_MH String 25 0 0 Down_Rim_to_Invert Down_Rim_to_Invert Double 8 38 8 Down_Grade_to_Invert Down_Grade_to_Invert Double 8 38 8 Down_Rim_to_Grade Down_Rim_to_Grade Double 8 38 8 Down_Northing Down_Northing String 50 0 0 Down_Easting Down_Easting String 50 0 0 Down_Elevation Down_Elevation String 50 0 0 MH_Coordinate_System MH_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 Reverse_Setup Reverse_Setup Integer 4 10 0 IsImperial IsImperial SmallInteger 2 5 0 OBJECTID_1 OBJECTID_1 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 STPipeRating STPipeRating Double 8 38 8 OMPipeRating OMPipeRating Double 8 38 8 OverallPipeRating OverallPipeRating Double 8 38 8 STQuickRating STQuickRating String 4 0 0 OMQuickRating OMQuickRating String 4 0 0 PACPQuickRating PACPQuickRating String 4 0 0 STPipeRatingsIndex STPipeRatingsIndex Double 8 38 8 OMPipeRatingsIndex OMPipeRatingsIndex Double 8 38 8 OverallPipeRatingsIndex OverallPipeRatingsIndex Double 8 38 8 LoFPACP LoFPACP Double 8 38 8 Risk Risk Double 8 38 8 20230522