The province has cancelled a controversial plan for an overdose prevention site in the 900 block of Helmcken Street in downtown Vancouver.