I believe that it is the longest bridge in Ohio at more than 7,000 feet in length. The hill in the background is an old neighborhood known as Price Hill. The Ohio River bridge in the background in a railroad-only bridge. The bridge is very busy and leads into the rail yard of Union Terminal. It is not possible to walk across the bridge.
More info is here .
The bridge originally had 3 lanes, but a fourth lane was added by eliminating the shoulders. The bridge opened in 1963, but it will soon be worn out. It will probably be replaced within a decade, but there are no specific plans yet. More info is here . Old suburbs such as Mount Adams are on the left.