The entire city is only 7 miles wide so you can walk from the bay to the ocean in less than 3 hours if you don’t mind the hills. Most of the touristy areas are very close to each other. The ones that aren’t are Golden Gate Park and the associated museums, GG Bridge (not next to GG Park), the neighborhoods like the Haight, the Mission or the Castro, the zoo, beach and Cliff House. All are easy to get to on MUNI (either see the website or call 511 to find out how to get around- they are good about giving routes on the fly).
Most of the attractions are is the NE section of the city, within an area of 2 square miles. If you’re staying by the airport, take BART into the Powell station, then climb up to street level to take either a cable car to the wharf or the F street car the rest of the way out Market & around the Embarcadero. You can hop off the street car to check out anything on the way. MUNI costs only $2 with unlimited transfers within 1 1/2 hours (NOT applicable to cable cars or BART). If you want to go to GG Park or wherever, call 511 and tell them where you are and where you want to go.
Do you want a wine tour that goes into specifics of wine making or just a bunch of tastings? For the first, big wineries are better like Sebastiani in Sonoma. For the second, there are a million wineries. You can’t swing a cat in Sonoma or Napa without hitting about a dozen wineries.