I've lived here for over 5 years and can absolutely confirm there are a few parts of the city that are dirty and have the feces/needles that people who honestly can't afford to live here love to talk about when they're denigrating the city. As you've noted, there are lots of neighborhoods, MOST of the city, that are very clean, safe, and obviously very desirable to live in.