Video shows scene where an NYPD officer was shot in Brooklyn on June 23