This is one of many stairway walks here in San Francisco. Each one is unique and in a variety of neighborhoods and this one starts near Diamond Heights; so if you don’t have a car, it might not work. There are plenty downtown; so do whatever you can. If you’re serious about this, purchase a book titled Stairway Walks of San Francisco, which has maps and detailed directions that allow you to explore neighborhoods that most locals don’t even know exist.
This one is Harry Street and the stairs you see is actually all there is to Harry Street. There is no street, just stairs. AND, there are homes on this street which makes you wonder how they get moved in or out?