Police say at least six people have been taken to hospital for treatment, and that the gunman was killed at the scene.