Bridge_Inspection_Inventory_Spreadsheet.xlsx

This is a Bridge Inspection Inventory Spreadsheet for the City of Urbana, Illinois, documenting the City's complete bridge and structure inventory comprising 29 bridges and structures. The spreadsheet provides comprehensive data on all facilities, including 12 bridges subject to National Bridge Inspection Standards (NBIS) and 17 structures exempt from NBIS requirements. The inventory details critical information for each structure, including facility name, location, maintenance responsibility, AASHTO designation, traffic volume (ADT), condition ratings (Sufficiency, Structural Deficiency, Functional Obsolescence, and Inventory ratings), structural composition, dimensions, construction year, and inspection schedules. Routine inspections scheduled for 2026 include 24 inspections, while 3 element-level inspections are due in 2026; for 2027, 1 routine inspection and 9 channel cross-section inspections are scheduled. Notable structures include the Vine Street Railway bridge (Steel Beam, built 1933), Lincoln Avenue bridge over Saline Branch (RC Slab, built 2010), and multiple Boneyard Creek structures with varying conditions and construction types.

The inventory indicates that most bridges and structures are owned and maintained by the City of Urbana's Public Works department, with exceptions including the Railway Bridge (010-0110) owned by Norfolk Southern Railway, the Crystal Lake Park bridge (010-5900) owned by the Urbana Park District, and two structures (010-6111 and 010-6119) with undetermined ownership. Condition ratings across the inventory vary significantly, with some structures maintaining high ratings (8 or 9) while others show lower assessments. The spreadsheet incorporates inspection data using the IDOT Bridge Inspection System (BIS) format, with routine inspection cycles typically occurring every 24 or 48 months, in-depth inspections every 96 or 144 months, and channel cross-section inspections on similar intervals. Several structures feature recent inspection updates dated in late 2024 and early 2024, with maintenance concerns including corrosion, wear surfaces, deck conditions, and scour ratings documented in the supplementary notes field.