Currently there are a handfull of bookstores specializing in SF. Borderlands Books, Dark Carnival, Future Fantasy, Other Change of Hobbit in Berkley and other nearby cities.

There are also several local publishers that specialize in SF and Fantasy, including Anamnesis Press and Tachyon Publications. Others who have made their home here:

MZB lived in berkley until her death in 1999

Pat Murphy

Emil Petaja

Genre books that have been set here:

Do Androids Dream of Electric Sheep? (Recommended) In 2021, Rick Deckard is a Blade Runner, a police officer in charge of hunting down and terminating replicants-androids who can pass for human. The movie version transplants the story to Los Angeles.

The Man in the High Castle - Philip K. Dick (Recommended)

An alternate history where the US lost WWII and the US is divided into German and Japanese occupied zones. A great deal of the novel takes place in Japanese-occupied San Francisco.

The Transmigration of Timothy Archer

All Tomorrow's Parties - William Gibson

Virtual Light - William Gibson

The Scarlet Plague - Jack London (Recommended)

Years after a sudden devastating plague wipes out almost all of the population a man attempts to describe what the world was once like to his savage descendants.

The City, Not Long After - Pat Murphy (Recommended)

A post-apocayptic novel about the idiosincratic survivors of a global plague and their fight to maintain a free San Francisco in the face of outside invaders.

Frameshift - Robert J. Sawyer

Genre movies that have been filmed or set here:

The Bicentennial Man

NorCal Movies

Big Trouble in Little China

Dr. Who (US TV Movie)

The Hulk

Interview with the Vampire

Innerspace

It Came from Beneath the Sea

Memoirs of an Invisible Man

Rollerball (2002)

Star Trek: The Motion Picture

Set, but not filmed here. NorCal Movies

Star Trek IV: The Voyage Home

Time After Time

Genre shws that have been filmed or set here:

Cliffhangers: The Curse of Dracula

Kindred: The Embraced

Mr. Merlin

Sliders

Star Trek

Various shows

Other facts which fen might find interesting:

Philo T. Farnsworth developed Television in a lab on Telegraph Hill. There is a historical marker (#941) at 202 Green Street, the cross-street is Sansome.

If you know of anything else that I should add to this page please let me know, I know it's nowhere near complete and am mainly doing it for my pleasure but additional info is always welcome.