The Scioto Mile in Downtown Columbus officially opened last week. A ton of attention has been paid to the fountains (photos here and here) but the most appealing part for me to the Scioto Mile is the promenade along the river and it's landscaping, seating areas and fish fountains.
