Tell me what I should know about moving to the SD area, specifically what neighborhoods/areas of the city I should look into or avoid. What's public transportation like? Is traffic a nightmare?

What do you like/not like about living there?

ETA: anyone who's made a cross-country trip with a dog, give me your tips on how to do it without traumatizing my poor doggie and/or tearing my hair out.