I’ve lived in north beach for about 11 years. Not really sure how to answer your question other than to say I still love it as much as the day I moved in.

I have everything I need within walking distance. The weather is incredible. I’ve never been robbed or had any particularly bad experiences (I’m relatively tall and a man so ymmv).

I don’t know, from my perspective it’s a pretty great city unless you have to spend a lot of time in SOMA or the tenderloin.

I can certainly understand why others haven’t had the same experience. But I don’t think it’s surprising that 3 in 10 are able to say they still enjoy it. It all comes down to when you moved here, where you live, and how much you’re paying.