The Transamerica Pyramid was a distinctive pyramid-shaped building in San Francisco on Earth.
In 1986, the building was visible from the corner of Kearny and Columbus Avenue. (Star Trek IV: The Voyage Home)
The building was visible from the office Christopher Brynner, which seemed to be located fairly closely north of the building. (DS9: "Past Tense, Part I")
By extension it would seem that it was also in the general region of the building that Dax, Sisko and Bashir beamed down.
The building was visible among the skyline in from the San Francisco Bay Stadium, even from the podium. (ENT: "Home", "Affliction")
The building was visible from the Starfleet Academy campus in an alternate reality. (Star Trek)
Harry Kim and Libby's apartment was fairly close to the building, and had a clear view of it through their window before he was assigned to Voyager. (VOY: "Non Sequitur")
In 2375, the Transamerica Pyramid was visible on a viewscreen display Benjamin Sisko and Martok viewed that showed the damage inflicted on San Francisco by the Breen. (DS9: "The Changing Face of Evil")
In 2376, 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")
The building was never expicitly mentioned or named on the show, but as a recognizable part of the San Francisco skyline has popped up numerous times.
Dwarfed in an alternate 2258
As seen from ground level in 1986