That is one solvable group, they just need reasonably priced housing in reasonable locations. The mentally ill and substance abusers(including alcohol), is much more complex issue.

And then there is probably small group you will never house, because they prefer to be homeless. Still doesn't mean the two other groups should not be solved. It is just that there is no political will to build enough housing or solve the systematic issues.