In Buena Vista, San Francisco it is mostly about the corner stores--the closest of which, I think is Central Haight Market maybe.
The closest thing to a supermarket is probably the Whole Foods in the Haight (there is also one in Noe) and I know there are Safeways around--like down in the Twin Peaks area.