Worst of the storm could coincide with Monday’s midnight high tide, with people in some coastal communities and low-lying areas urged to leave