San Francisco is a target for waves of destructive meteors after a rogue comet breaks from its orbit