Opioid prescriptions are declining: https://www.nytimes.com/2016/05/21/health/opioid-prescriptio.... And will hopefully continue to decline.
Identifying the source of the problem is easy, though. Solving the problem for the masses who already find themselves in the midst of an addiction they might not even know they're in yet is much harder and what places like these injection sites are aimed to address.