Local freight rail lines in U.S. cities

I went to your link, figuring it was going to mention the State Belt Railroad (Later the Embarcadero Railroad) a truly short line that ran along (where else) the Embarcadero, serving the piers and warehouses there.

Back about 1980 a railroad buddy and I were prowling around the route one Sunday looking to some of the dual-gauge trackage mentioned in paragraph three in the link. We found a section about twenty feet long, probably the last bit extant, in front of a building, but to our surprise we also found one of the railroad’s locomotives. It wasn’t running or anything, just sitting there between two buildings, oddly vulnerable to vandalism, we thought. When we’d examined things a bit, the reason was evident: They’d turned a rail over all along one side. We imagined it happened on Friday afternoon so the crew threw up their collective hands and intended to come back on Monday to get things going again.