Reddit mentions of San Francisco Street Secrets

Start here: https://www.amazon.com/Francisco-Street-Secrets-David-Eames/dp/0935182756. It's a history of SF from the view of it's citizens that have had our streets named after them. It's a fascinating book!

The "bad" sections of town are the Tenderloin and Bay View/Hunter's Point 'hoods. They're "bad" because they house poor residents and the area are prone to drug and human trafficking, as well as violence.

The "Muni Metro" subway is nice, but it's starting to show its age. Each station has different colored walls and floors to distinguish one from the other. They've finished boring out the main tunnel for the new "Central Subway" under Stockton Street, and how they're (block by block) ripping up the street and inserting the infrastructure around the tunnel.

It almost never snows in SF. I've lived here 20 years and I've seen it once (it evaporated before it touched the ground at Haight Street and Market Street, and this was at night!) and a friend "out in the Avenues" had a sleet / snow storm that laid out a couple of inches a few years ago. Other than those "freak" occurrences the Winter months are (WERE!) usually raining and overcast. However with the ongoing drought in California our Winter's have been pretty dry lately.

The "High Class" 'hoods are Pacific Heights and Sea Cliff.

The last two I cannot answer as they're too subjective. What's expensive to me wouldn't be to another, and "coolest" is far more subjective than just $ or $$$!

One of the biggest issues facing the city now is "Techies". These are well paid, IT-related, young professionals that are moving into the city and rents have been skyrocketing. SF is a very NIMBY city so for years now no one wanted to allow high density building in their 'hoods. Hence a shortage of rental units. We also have some very Renter-centic laws in the city that have owners of apartment buildings just not renting them out and having to deal with those laws.

That should be enough for you to get started on your research. Let me know if anything else comes up.

Personal Note: One of my favorite books is Altered Carbon (https://www.amazon.com/Altered-Carbon-Takeshi-Kovacs-Novels/dp/0345457684/ref=sr_1_1?s=books&ie=UTF8&qid=1474925617&sr=1-1&keywords=altered+carbon). It's a sci-fi novel based in SF that's intelligent, very well written and trippy as hell. The author does a great job basing it in SF, but not falling into the trap of "over explaining" the details/scenery to "prove a point". (I hope that makes sense.) It was a joy to read because of that. I could "tell" where they were by what he was describing!