I want Columbia for my engineering major but I mean, isn't that what the engineering essay is for?
Yes, but you can write about your aspiration in many different ways. You can relate it to the world you come from in one essay and to the campus culture of Columbia in another essay. Each essay can have a unique theme based on the combination you choose. If you write about your engineering aspiration in relation to your current extracurricular activities, what theme would emerge? Maybe your theme would be "preoccupation" or "feeling misunderstood." That sort of thing makes an essay interesting and meaningful.
In this essay, the first part makes a brilliant contrast between the busy atmosphere of NY and the tranquility of the campus, and this is my favorite: as if someone up above wanted me to view Columbia in its entirety...
In the second part, when you start talking about the core you lose me. Only talk about how the core fits with this contrast you have just introduced. Narrow your focus, and stick with that great theme. Keep that theme, and the reader will have a memorable experience.
:-)