Bryan Scott, of the great blog (and book) Winnipeg: Love It Or Hate It, posted some aerial photos of Winnipeg to his Flickr account, including this great one of the Canadian Pacific Railway yard in Winnipeg. I'd post it here but he has disabled embedding of the photo. Just follow the link - it's worth it.
The photo is looking east-south-east, with the Arlington Street bridge just visible in the bottom right of the photo and the Slaw Rebchuk bridge in the distance. The hump yard is visible on the left side. I've heard rumours that the hump yard is to be shut down or has been shut down. I haven't been there in a while so I can't verify that.
You can also find aerial photos of the yard on the Winnipeg Aerial Photos blog but the real treat is at the Winnipeg Free Press from July 2012! There are some beautiful aerial photos of the yard, including this gem:
This is viewing the yard from the other end, looking more or less west. The Slaw Rebchuk bridge is in the foreground and the CP Carberry subdivision stretches off the top of the photo.