It's the Dain City train bridge in Welland, Ontario

This train bridge is on a forgotten stretch of the Welland Canal that has long since been rerouted. The stretch of water now serves the local rowing club. More images here: Dain City train bridge.