From Deep Space to Blue Sky

So many Sci-fi stories have this as a possibility!   My question is will this end up being good for the environment or will it require to many resources?