Flooding caused by torrential rain from the remnants of Tropical Storm Allison has forced thousands of people out of their homes in Houston.