The man had allegedly shot and killed two people before firing shots at San Diego Harbor Police officers, wounding one