In a scary article, the San Francisco Standard printed the locations of 18 San Francisco bridges which are in “poor” condition. Only one bridge traverses a body of water; the rest are highway overpasses or, in one case which is in Glen Park, an overpass above the J-Church Muni line. Here are the locations.
