Hours of heavy rainfall in the greater Charleston area on Wednesday led to downtown streets being flooded and warnings to avoid unnecessary driving in the Holy City.