A state of emergency has been declared in New York City after it was hit by record rainfall and flash flooding as a result of Tropical Storm Ida.