Stayed here one night when we arrived in San Fran. Great for first night as you wake up to a beautiful view of the city (and get an even more amazing view at night). It is definitely not the best spot for long term, very busy though we didn't find it too loud during the night.
Bathrooms were very dirty but better than pooping in a bag. Didn't feel the most safe though there are several other campers parked there I would assume basically every night. We were wedged between an RV and a camper, both fellow Canadians :)
Place: Vista Point San Francisco
Location: 37.83248, -122.47948