Just in case folks don't know, here is an organization that is working on this issue. They work with partner agencies to house 'vulnerable Calgarians', some (but not all) of whom are dealing with substance issues. Usually, there are other services provided by those partner agencies, depending on the needs of those that are being housed.
https://www.homespace.org/about
Now by no means is this a perfect solution that will result in a utopia. I live across the street from one of their buildings, and for sure there are some challenges. We see EMS quite a bit, and there has been a few issues over the years, usually not with the residents, but with folks that were a part of the residents former lives.
I am posting to let people know that there are agencies trying to get folks 'off the streets', and get them the help they need.