Deputy Inspector Elisa Cokkinos will retire next Wednesday.
The actor had ingested a lethal dose of cocaine, heroin, sedatives and amphetamines, the report says.
An informant told police this week that Hoffman was a regular at 302 Mott St., sources said.
The actor's ex-girlfriend told police he seemed high when she last saw him, an official said.
Neighbors and colleagues remembered Hoffman as a "neighborhood guy" and "sweet dad."
The action star grew up in the West Village artists' complex on Bethune Street.
Michael Archer, 36, was arrested after allegedly soliciting an undercover officer in Greenwich Village.
Get our daily New York City news and alerts!
Thank you for signing up!
Would you like to sign up for additional newsletters?
Thank you for signing up for additional newsletters.