I mentioned Jack London Square earlier. Here's a Google view: [
www.google.com]
In addition to plenty of UP freights, it carries the Amtrak Coast Starlight and all of the Capitol Corridor trains. 5-6 of the Capitol Corridor trains terminate at Coliseum or Jack London stations, and deadhead back to the service area off the upper left of the picture. The Jack London Square station is just off the lower right of the picture. While the track area is marked off with paint stripes, it's all paved over and the "island" with tracks in it tends to get ignored if respecting it is inconvenient. Probably one of the busier bits of "street running" at least in the US. Suspect the main reason it didn't appear in the collection was that there aren't a lot of pictures of it in action on whatever service they used as a source (Youtube?).
Jack London Square is the waterfront area in the lower part of the picture. Downtown Oakland is less than a mile up Broadway off the upper part of the picture.