Funnily enough, his body double in "The Unstuck Man," James Bamford, has gone onto become a regular director and producer on ARROW.

https://slidecage.com/show/film-locations/

Of note would be the exterior of Rembrandt’s apartment:

1152 Montgomery St, San Francisco, CA, 94133

And some exterior shots from U.C. Berkeley:

University Dr, Berkeley, CA, 94708

The remainder of San Francisco locations listed on that site are areas that were driven through during the car scenes.

For more images from the Sliders pilot movie:

http://www.slidersimages.com/1a/1a_1.htm

While in San Francisco, you may also want to visit the Chancellor Hotel.  Sliders never filmed there, but the name was used in season three as the hotel the Sliders stayed at (as mentioned in “Double Cross”).  The name would be changed to The Chandler Hotel in season four after the real life Chancellor Hotel objected to the use of its name on Sliders without permission.

https://www.chancellorhotel.com/