'This was maybe one of the worst': Atmospheric river causes historic flooding north of Bay Area