I've lived in NYC my whole life...
Columbia environment is much more pleasant/relaxed feel
NYU: more spread out gritty city area, however much more active part of the city with a little more convenience. (To an outsider however convenience is about equal).
BOTH SCHOOLS: Students overall think they are better than everyone else in the world....snooty, pretentious, u name it..
Of course not all, but there are a good amount that fit this mold.
I have friends that go to both for UG and they see it.
Pompous losers from out of state without a NY accent do get put into line from time to time. lol.
Either way if you don't act like your better than anyone and your social than you will be fine.
As far as name is concerned Columbia is better no matter what rankings say!!
And yes I know plenty of lawyers in this great city that can vouch.
LOL Hope I was of help