To the east is Napa, to the north is Mendocino County. Santa Rosa is 50 miles north of the Golden Gate. If you're looking to make a day trip from San Francisco then the town of Sonoma is your best bet for a close location, wineries, restaurants, site-seeing and shopping. Climate Sonoma County has a Mediterranean climate meaning wet relatively mild winters and warm dry summers. This is only a generality however because there are many micro-climates.
Summer is where the micro-climates come into play.
Because the Pacific Ocean's current comes from the north the water is always about 55 so coastal areas may be much cooler than inland areas protected from the ocean by the coastal hills. A layer of low clouds and fog often moves inland during the night and retreats in mid-morning. Summer evenings are usually quite cool. It's the warm days, cool nights and lack of rain during the growing season that makes for premium wine. Don't bother with ties or dresses.