Bridge_Inspection_Inventory_Spreadsheet.xlsx

This is a Bridge Inspection Inventory Spreadsheet for the City of Urbana, Illinois, documenting a comprehensive bridge and structure asset management database comprising 29 facilities. The spreadsheet details inspection schedules, facility characteristics, condition ratings, and maintenance responsibilities for bridges and structures under Urbana Public Works jurisdiction, with select facilities maintained by Norfolk Southern Railway, Urbana Park District, and entities with undetermined ownership. The 2026 inspection program requires 24 routine inspections and 3 element-level inspections, while the 2027 program requires 1 routine inspection and 9 channel cross-section inspections. Inspection cycles vary by facility type, with routine inspections typically scheduled at 24, 48, 72, or 96-month intervals and in-depth inspections at corresponding longer intervals ranging from 48 to 144 months. Facilities are classified by structure type, including steel beam bridges, precast and rigid frame structures, box culverts, and corrugated steel culverts, with construction years ranging from 1900 to 2023. Current condition ratings for deck, superstructure, substructure, and specialized components are documented numerically, and facilities are assessed for sufficiency, structural deficiency, and functional obsolescence status.

The spreadsheet serves as the supporting exhibit for the City of Urbana's Bridge Inspection Services 2026 and 2027 procurement (Section 26-00711-00-BI), with proposals due February 20, 2026. Of the 29 total facilities, 12 are subject to National Bridge Inspection Standards (NBIS) requiring documentation through the Illinois Department of Transportation Bridge Inspection System (BIS), while 17 structures are exempt from NBIS requirements. The inventory includes critical data fields such as average daily traffic (ADT) counts, functional classifications, structure dimensions, pavement surface types, water adequacy assessments, scour ratings, and railing adequacy evaluations. Notable facilities include structures on Saline Branch, Boneyard Creek, and McCullough Creek, with several facilities rated in good condition (ratings of 7-9 in key categories) and others requiring monitoring. Inspection documentation notes indicate several structures with specific characteristics such as permanent closure status (010-6119), park district ownership requiring city inspection coordination (010-5900), and recent replacement activity (010-6135 replacing former SN 010-6134).