So that's what that noise was. Thought it was an air-raid siren, it was. Except the one I heard, while working out with my traininer in Golden Gate Park must've been located somewhere a fair piece away. Couldn't hear one sounding from my Inner Sunset neighborhood. Yup, SF now has it's own outdoor warning system.
Phew. I feel safer already.