I find some of these utilitarian railroad trestles across rivers quite satisfying.
Lancefield East angles across a shoal in the French Broad River. Keep going on this and you’ll leave Cocke County TN and hit Madison County NC in just a few miles. The trestle is 960′ long, with a handy walkway provided. I’ve been on a walkway similar to this when a train came by. I was safe enough, but that much power and sheer tonnage was certainly impressive. And loud.
I got to thinking: trestle or bridge? Both, I discovered. A trestle bridge is a span supported by piers or bents (says Google). This solidly built deck girder trestle bridge spans the French Broad River near Marshall NC. The man standing to the left is my buddy, who kindly entered the shot to provide a sense of scale. The bridge is over 600′ long.