(covers information from several alternate timelines)
The Transamerica Pyramid was an office skyscraper dating from late 20th century San Francisco. This building was preserved to at least the late 24th century (prime universe) or the mid-23rd century (alternate reality). In the prime universe, an individual could see the western span of the San Francisco-Oakland Bay Bridge from this building.
In 1986, the building was seen from the corner of Kearny and Columbus Avenue. When the HMS Bounty flew into the city, the building was seen on the ship's viewscreen. A day later, the building was seen again on the viewscreen as the ship left the city. (Star Trek IV: The Voyage Home)
The building was seen from the Starfleet Academy campus in an alternate reality, in 2258. (Star Trek) In the next year, the Takayama flew past buildings that were near the Pyramid. Three days later, the crashing USS Vengeance stopped short of toppling this building into the streets of the city. (Star Trek Into Darkness)
In 2375, the Transamerica Pyramid was seen on a viewscreen display Benjamin Sisko and Martok viewed that showed the damage inflicted on San Francisco by the Breen during the Breen attack on Earth. (DS9: "The Changing Face of Evil")
In 2375, it was one of the buildings in San Francisco recreated by Species 8472 in Terrasphere 8 for training to infiltrate Earth. It was depicted on a graphic Seven of Nine brought up in astrometrics. (VOY: "In the Flesh")