A new national study suggests Canadians generally view supervised consumption sites as beneficial and do not believe they have negative effects.