{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Bridge Scour Site Inspection","Bridge Scour Site Inspection 2","Bridge Scour Site Inspection 3","Bridge Scour Required Photos","Bridge Scour Office Infor","Sheet1","COUNTIES"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":7,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Bridge Scour Site Inspection","index":0,"n_rows":30,"n_cols":36,"rows_kept":30,"cut":false,"hidden":false,"merged":[[16,12,16,13],[14,12,14,13],[15,12,15,13],[22,12,22,13],[28,12,28,13],[29,1,30,13],[31,1,31,13],[32,1,32,13],[16,4,16,7],[23,1,23,3],[23,4,23,11],[24,1,24,4],[24,5,24,8],[25,5,25,8],[23,12,23,13],[24,12,24,13],[25,12,25,13],[26,12,26,13],[27,12,27,13],[16,8,16,11],[1,1,1,13],[2,1,2,13],[3,12,3,13],[4,12,4,13],[5,12,5,13],[11,2,11,3],[6,12,6,13],[7,1,7,13],[8,1,8,13],[9,12,9,13],[10,12,10,13],[12,2,12,3],[12,4,12,11],[13,2,13,3],[2,34,3,36],[4,4,4,6],[4,7,4,8],[4,9,4,11],[12,12,12,13],[13,12,13,13],[9,2,9,3],[9,9,9,10],[10,2,10,3],[11,12,11,13],[3,4,3,6],[3,7,3,8],[3,9,3,11],[14,2,14,3],[14,4,14,11],[15,2,15,3],[15,4,15,11],[22,2,22,3],[22,9,22,11],[0,22,0,25],[0,26,0,31],[34,14,34,17],[34,18,34,23],[28,1,28,3],[28,4,28,11],[13,17,13,19],[27,2,27,3],[27,9,27,11],[13,9,13,11],[5,4,5,6],[5,7,5,8],[5,9,5,11],[6,4,6,6],[6,7,6,8],[6,9,6,11]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"END ABUTMENT TYPES"]
[null,"BRIDGE SCOUR SITE INSPECTION FORM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VERTICAL"]
[null,"PROJECT DESCRIPTION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VERTICAL W/ WINGWALLS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"This data is required for drop down menu."]
[null,null,null,"County:",null,null,null,"Rt. / Rd. No.:",null,null,null,null,null,null,null,null,null,"VERTICAL W/ MSE WALLS"]
[null,null,null,"Stream:",null,null,null,"Asset ID:",null,null,null,null,null,null,null,null,null,"SPILL-THROUGH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ü"]
[null,null,null,"Structure No:",null,null,null,"Flood Zone:",null,null,null,null,null,null,null,null,null,"OTHER"]
[null,null,null,"By:",null,null,null,"Date:"]
[null,"  Note: All references to left and right are looking in the direction of flow."]
[null,"EXISTING BRIDGE"]
[null,null,"Length:",null,null,"ft.","Width:",null,"ft.","Max. Span Length:",null,null,"ft."]
[null,null,"Alignment:",null,"Tangent ",null,"Curved"]
[null,null,"Bridge skewed:",null,"Yes",null,"No",null,null,"Skew Angle:",null,"degrees"]
[null,null,"End Abutment Type:"]
[null,null,"Riprap on Fills:",null,"Yes",null,"No",null,"Condition:"]
[null,null,"Superstructure Type:"]
[null,null,"Substructure Type:",null,"FILL OUT TABLE 1 BELOW"]
[null,null,null,"TABLE 1","MATERIAL",null,null,null,"SHAPE",null,null,null,"SIZE"]
[null,null,null,"LOCATION","NO. PIERS / BENTS","CONCRETE","STEEL","TIMBER","SQUARE","ROUND","TRIANGULAR","OTHER","LENGTH","DIAMETER"]
[null,null,null,"LEFT OVERBANK"]
[null,null,null,"MAIN CHANNEL"]
[null,null,null,"RIGHT OVERBANK"]
[]
[null,null,"Utilities Present:",null,"Yes",null,"No",null,"Describe:"]
[]
[null,"Debris Accumulations on Bridge:",null,null,null,"Percent Blocked (Horizontal):",null,null,null,null,"%"]
[null,null,null,null,null,"Percent Blocked (Vertical):",null,null,null,null,"%"]
[]
[null,null,"Hydraulic Problems?",null,"Yes",null,"No",null,"Describe:"]
[]
[null,"     Draw Sketch of Representative Pier/Bent"]

{"sheet":"Bridge Scour Site Inspection 2","index":1,"n_rows":48,"n_cols":25,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,13,0,14],[0,15,0,20],[2,23,3,25],[34,1,34,14],[4,4,4,6],[4,7,4,8],[4,9,4,11],[5,4,5,6],[5,7,5,8],[5,9,5,11],[7,4,7,6],[7,7,7,8],[7,9,7,11],[8,1,8,12],[10,2,10,3],[10,9,10,10],[15,2,15,3],[15,4,15,11],[16,2,16,3],[16,4,16,11],[11,2,11,3],[12,2,12,3],[13,2,13,3],[13,4,13,11],[14,2,14,3],[14,9,14,11],[18,2,18,3],[18,9,18,11],[19,1,19,3],[19,4,19,11],[20,1,20,4],[20,5,20,8],[3,4,3,6],[28,1,28,12],[27,2,27,11],[1,1,1,14],[2,1,2,14],[9,1,9,14],[3,9,3,11],[3,7,3,8],[24,1,24,3],[24,4,24,11],[25,1,26,12],[21,5,21,8],[22,2,22,3],[22,9,22,11],[23,1,23,3],[23,4,23,11]]}
[]
[null,"BRIDGE SCOUR SITE INSPECTION FORM"]
[null,"PROJECT DESCRIPTION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"This data is required for drop down menu."]
[null,null,null,"County:",null,null,null,"Rt. / Rd. No.:"]
[null,null,null,"Stream:",null,null,null,"Asset ID:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ü"]
[null,null,null,"Structure No:",null,null,null,"Flood Zone:"]
[]
[null,null,null,"By:",null,null,null,"Date:"]
[null,"  Note: All references to left and right are looking in the direction of flow."]
[null,"EXISTING BRIDGE PLAN VIEW SKETCH "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"PLAN VIEW SKETCH CHECKLIST"]
[null,null,null,"North Arrow",null,null,null,null,"Mid-Channel Bars (extent, vegetation)"]
[null,null,null,"Flow Direction",null,null,null,null,"Downstream Blow-Hole (banks impacted, dimensions)"]
[null,null,null,"Streambanks",null,null,null,null,"Debris (accumulation, type, horiz & vert pos, trapping potential)"]
[null,null,null,"Bridge Deck",null,null,null,null,"Location of Cross Sections"]
[null,null,null,"Angle of Approach",null,null,null,null,"Scour Holes"]
[null,null,null,"Piers & Columns",null,null,null,null,"Riprap (note quality & gradation)"]
[null,null,null,"Footings or Encasements",null,null,null,null,"Filter fabric or geotextile"]
[null,null,null,"Abutments",null,null,null,null,"Photo/Video Locations & Directions"]
[null,null,null,"Wing Walls",null,null,null,null,"Countermeasures (type, dimensions, locations, condition)"]
[null,null,null,"Tributary Confluences"]
[null,null,null,"Meander Impacts/Cutbanks"]
[null,null,null,"Bank Erosion"]
[null,null,null,"Point Bars (extent, vegetation)"]

{"sheet":"Bridge Scour Site Inspection 3","index":2,"n_rows":45,"n_cols":23,"rows_kept":45,"cut":false,"hidden":false,"merged":[[1,3,1,16],[2,3,2,16],[8,3,8,8],[9,3,9,16],[10,3,11,16],[5,4,5,6],[5,7,5,8],[5,9,5,11],[7,4,7,6],[7,7,7,8],[7,9,7,11],[12,3,12,16],[45,2,45,16],[41,4,41,16],[43,8,43,10],[44,2,44,4],[34,2,34,16],[35,2,35,16],[24,3,24,16],[36,2,36,16],[37,2,37,16],[15,4,15,7],[13,1,13,16],[26,2,26,16],[25,2,25,16],[14,3,14,16],[15,3,16,3],[2,21,3,23],[3,4,3,6],[3,7,3,8],[3,9,3,11],[4,4,4,6],[4,7,4,8],[4,9,4,11],[15,8,15,10],[15,11,15,13],[15,14,15,15],[15,16,16,16],[23,2,23,16],[22,2,22,16],[27,2,27,16],[28,2,28,16],[29,2,29,16],[30,2,30,16],[31,2,31,16],[41,2,41,3],[32,2,32,16],[33,2,33,16],[38,2,38,4],[38,9,38,12],[40,2,40,4]]}
[]
[null,null,null,"BRIDGE SCOUR SITE INSPECTION FORM"]
[null,null,null,"PROJECT DESCRIPTION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"This data is required for drop down menu."]
[null,null,null,"County:",null,null,null,"Rt. / Rd. No.:"]
[null,null,null,"Stream:",null,null,null,"Asset ID:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ü"]
[null,null,null,"Structure No:",null,null,null,"Flood Zone:"]
[]
[null,null,null,"By:",null,null,null,"Date:"]
[null,null,null,"  Note: All references to left and right are looking in the direction of flow."]
[null,null,null,"DESCRIPTION OF FLOODPLAIN"]
[null,null,null,"Describe General Topography of FloodPlain"]
[]
[]
[]
[null,null,null,"Floodplain conditions at Bridge Site:"]
[null,null,null,"Floodplain","Developed",null,null,null,"Forest/Wetlands",null,null,"Undergrowth/Shrubs",null,null,"Planted/Cultivated",null,"Other"]
[null,null,null,null,"Open","Low","Medium","High","Thin","Moderate","Thick","Thin","Moderate","Thick","Pasture","Crops"]
[null,null,null,"Upstream/Left"]
[null,null,null,"Upstream/Right"]
[null,null,null,"Downstream/left"]
[null,null,null,"Downstream/right"]
[]
[null,null,"Other Floodplain Comments:"]
[]
[]
[null,null,"COMMENTS"]
[null,null,"COUNTERMEASURES"]
[]
[]
[null,null,"IN THE UPSTREAM CHANNEL"]
[]
[]
[null,null,"IN THE DOWNSTREAM CHANNEL"]
[]
[]
[null,null,"UNDER THE BRIDGE"]
[]
[]
[null,null,"Is there Evidence of Roadway Over-Topping?",null,null,"NO",null,"YES",null,"Is pressure flow indicated by debris or waterline located higher than the low chord of the bridge?",null,null,null,"NO",null,"YES"]
[]
[null,null,"Bend in Channel at Bridge:",null,null,null,"None",null,"Mild-30o",null,"Moderate -30o to 60o",null,"Severe - over 60o"]
[null,null,"Describe:"]
[]
[null,null,"Debris Accumulaton:",null,"NO",null,"YES",null,"Debris Trapping Potential:",null,null,"Low",null,"Medium",null,"High"]
[null,null,"Describe Type & Location:"]

{"sheet":"Bridge Scour Required Photos","index":3,"n_rows":44,"n_cols":22,"rows_kept":44,"cut":false,"hidden":false,"merged":[[39,11,39,18],[40,11,40,18],[39,7,39,10],[40,7,40,10],[41,7,41,10],[41,11,41,18],[37,7,37,10],[38,7,38,10],[29,11,29,18],[32,11,32,18],[33,11,33,18],[34,11,34,18],[35,11,35,18],[37,11,37,18],[38,11,38,18],[35,7,35,10],[36,7,36,10],[36,11,36,18],[28,11,28,18],[29,7,29,10],[32,7,32,10],[34,7,34,10],[28,7,28,10],[33,7,33,10],[26,7,26,10],[27,7,27,10],[26,11,26,18],[23,7,23,10],[27,11,27,18],[22,7,22,10],[24,7,24,10],[25,11,25,18],[21,11,21,18],[18,7,18,10],[18,11,18,18],[19,7,19,10],[20,7,20,10],[21,7,21,10],[19,11,19,18],[20,11,20,18],[22,11,22,18],[23,11,23,18],[24,11,24,18],[25,7,25,10],[17,7,17,10],[12,11,12,18],[13,7,13,10],[13,11,13,18],[14,7,14,10],[14,11,14,18],[12,7,12,10],[15,11,15,18],[15,7,15,10],[16,7,16,10],[16,11,16,18],[17,11,17,18],[8,7,8,10],[9,7,9,10],[10,7,10,10],[11,7,11,10],[8,11,8,18],[9,11,9,18],[11,11,11,18],[10,11,10,18],[7,11,7,18],[1,0,1,6],[1,7,1,10],[1,11,1,18],[2,7,2,10],[3,7,3,10],[2,11,2,18],[3,11,3,18],[4,7,4,10],[5,7,5,10],[6,7,6,10],[4,11,4,18],[5,11,5,18],[6,11,6,18],[7,7,7,10]]}
[]
["REQUIRED PHOTOS",null,null,null,null,null,null,"FILE NAME/NUMBER",null,null,null,"ADDITIONAL COMMENTS"]
["One Channel-Width UpStream of  Bridge:"]
[null,null,"UpStream Left Bank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Upstream channel from bridge"]
[null,null,"UpStream Right Bank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Downstream channel from bridge"]
[null,null,"UpStream looking DownStream at Bridge"]
["Immediately UpStream of  Bridge:"]
[null,null,"Bridge opening from UpStream side"]
[null,null,"UpStream Left Bank"]
[null,null,"UpStream Right Bank"]
["On / Under  Bridge:"]
[null,null,"Bridge Profile"]
["Substructure:"]
[null,null,"Representative Pier/Bent"]
[null,null,"Left Abutment"]
[null,null,"Right Abutment"]
["Immediately DownStream of  Bridge:"]
[null,null,"DownStream Left Bank"]
[null,null,"DownStream Right Bank"]
[null,null,"Bridge opening from DownStream side"]
["One Channel-Width DownStream of  Bridge:"]
[null,null,"DownStream looking UpStream at Bridge"]
[null,null,"DownStream Left Bank"]
[null,null,"DownStream Right Bank"]
[null,null,"Under bridge looking UpStream"]
[null,null,"Under bridge looking DownStream"]
["Soil Material:"]
[null,null,"Bed Material from Bridge"]
[null,null,"Bank Material from Bridge"]
["Other Photos:"]
[null,null,"Piers"]
[null,null,"Abutments"]
[null,null,"Roadway Approach - Right"]
[null,null,"Roadway Approach - Left"]
[null,null,"Floodplain Surface Cover"]
[null,null,"Tributary Confluences"]
[null,null,"Meander impacts / cutbanks"]
[null,null,"Point Bars"]
[null,null,"Mid-Channel Bars"]
[null,null,"Bank Erosion"]
[null,null,"Downstream Blow Hole"]
[null,null,"Debris"]
[null,null,"Countermeasures"]
[null,null,"RipRap"]

{"sheet":"Bridge Scour Office Infor","index":4,"n_rows":59,"n_cols":4,"rows_kept":59,"cut":false,"hidden":false,"merged":[[55,0,55,2],[56,0,56,2],[57,0,57,2],[58,0,58,3],[59,0,66,3],[54,0,54,2],[35,0,35,3],[36,0,43,3],[45,0,45,3],[48,0,48,2],[49,0,49,2],[50,0,50,2],[51,0,51,2],[52,0,52,2],[53,0,53,2],[47,0,47,2],[22,0,22,1],[1,0,1,3],[12,0,12,3],[13,0,13,3],[14,0,14,1],[15,0,15,1],[16,0,16,1],[3,0,3,3],[17,0,17,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,3]]}
[]
["OFFICE BASED INFORMATION FROM SCDOT, USGS, & FHWA:"]
[]
["STREAMGAGE INFORMATION"]
["AGENCY","SITE NO.","SITE NAME","LAT/LONG"]
[]
[]
[]
[]
[]
[]
[]
["FLOOD FREQUENCY & DESIGN FLOWS"]
["FHWA/State Transportation Information (Typically from H&H report or design data)"]
["Design Flow Probability (recurrence interval)",null,"Method","Flow"]
[]
[]
[]
[]
[]
[]
["USGS INFORMATION"]
["USGS Methods (Bull. 17B/PeakFQ, USGS NSS, PSU IV,FIS, etc.)",null,"Recurrence Interval(s)","Flow"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["COMMENTS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["OFFICE DATA CHECKLIST:"]
[]
["DATA CHECKLIST",null,null,"RECEIVED"]
["Bridge Plan & Elevation with Foundations Depicted"]
["Scour Countermeasures Plans"]
["Bridge Inspections Reports (if available)"]
["Topographic maps of the watercourse and surrounding area"]
["Aerial Photographs (list years below)"]
["Soils/Geologic Maps"]
["Streamgage Data (peak flows, annual flows, monthly flows, rating, etc.)"]
["USGS WaterWatch flood tracking chart, flow duration curve, and rating curve"]
["Hydraulic/Hydrologic or other studies of the watercourse"]
["Other appropriate data (describe below)"]
["COMMENTS"]

{"sheet":"Sheet1","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"COUNTIES","index":6,"n_rows":46,"n_cols":1,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["Abbeville"]
["Aiken"]
["Allendale"]
["Anderson"]
["Bamberg"]
["Barnwell"]
["Beaufort"]
["Berkeley"]
["Calhoun"]
["Charleston"]
["Cherokee"]
["Chester"]
["Chesterfield"]
["Clarendon"]
["Colleton"]
["Darlington"]
["Dillon"]
["Dorchester"]
["Edgefield"]
["Fairfield"]
["Florence"]
["Georgetown"]
["Greenville"]
["Greenwood"]
["Hampton"]
["Horry"]
["Jasper"]
["Kershaw"]
["Lancaster"]
["Laurens"]
["Lee"]
["Lexington"]
["Marion"]
["Marlboro"]
["McCormick"]
["Newberry"]
["Oconee"]
["Orangeburg"]
["Pickens"]
["Richland"]
["Saluda"]
["Spartanburg"]
["Sumter"]
["Union"]
["Williamsburg"]
["York"]