It should be noted that the space elevator in Foundation is completely ridiculous. The cable structure would not need to be that utterly massive. A real elevator would use a cable or ribbon that would slow enough as it hit the atmosphere to be a nuisance that might kill a person if it hit them directly, but it wouldn't be leveling swathes if city.