Why San Francisco Is Denying Reality

The author's main point seems to be that San Francisco is "moving forward with supervised drug consumption and drug dealing in ways that are totally inconsistent with the successful approach used by Amsterdam, Frankfurt, Lisbon, Vienna, and Zurich." The linked article provides details on successful approaches but the author needs to provide more specifics on how San Francisco is not adhering to those approaches.

I have so many questions,

Do the drugs/needles/etc. get provided by the government that are known to be safe or is it bring your own drugs and anything goes?

What are the legal liabilities the government could face if there is an overdose/fatality as a result of this, or if someone gets injured or attacks someone else?