SOMA was always pretty clean, Civic Center a bit more hit or miss, 16th Street was generally a bit dirtier and rougher.
The number of times I encountered human feces though was very low, like not even a monthly occurrence. Now I'm sure there's parts of San Francisco that are worse than others, and the walk from 16th Street BART to Potrero Hill would take me past plenty of homeless people camped out on the sidewalks, but I rarely if ever encountered human feces.
But every. single. time. San Francisco comes up, it's the same tired line, "Oh I couldn't deal with the absolute deluge of human feces" which like cool, neither could I and it was fine because what the heck is everyone talking about. I'm not going to claim that every sidewalk and roadway is completely free of poo, but as someone that managed a team of people and would frequently go for walking meetings all around San Francisco, it was never my experience.