Please contact Zack Wu if you have any questions. Thanks!
 
   
 
Useful resources
 

The Big Move | 初到哥大指南

COMING TO COLUMBIA
《太傻签证——The Art of Visa》
哥伦比亚大学新生指南_update
Mitbbs.com
Orientation section of Columbia Spectator
Recommended:
116 Things to Do at Columbia

Transportation
New York Maps
Lower Manhattan
Manhattan bus
Subway
Columbia Campus Map
MTA maps and schedules
HopStop (Best tool to deal with subways!)
Maps Yahoo

Housing
UAH住房申请全攻略
ApartmenList.com
Craigslist.org

Foods
Index of New York restaurants
Menupages
Citisearch

Recommended restaurants around campus
Chinese:   Columbia Cottage (1034 Amsterdam Ave | At 111th St)
Ollie's (2957 Broadway | At 116th St)
French:      Le Monde (2885 Broadway | Btwn 112th & 113th St)
Terrace in the sky (400 W 119th St | Btwn Amsterdam Ave & Morningside Dr)
Asian:       Caffe Swish (2953 Broadway | Btwn 115th & 116th St)
American: Tom's Restaurant (2880 Broadway | At 112th St)
Japanese:      Tomo (2850 Broadway | Btwn 110th & 111th St)
Korean:      Mill (2895 Broadway | At 113th St)
Bars:           Havana Central (2911 Broadway | Btwn 113th & 114th St)
Radio Perfecto (1187 Amsterdam Ave | Btwn 118th & 119th St)

Recommended Chinese restaurants in the city
Midown:      Ollie's (411 W 42nd St | At 9th Ave)
Grand Sichuan International (229 9th Ave | At 24th St)
Grand Sichuan (1049 2nd Ave (55th-56th ST) Manhatton, Tel: (212) 355-5855)
WU LIANG YE 五粮液 (338 Lexington Avenue, Tel: 212-370-9648)
Duo Yi 朵颐 (39th street between 5th avenue and 6th avenue)
Shun Lee (43 W 65th St | Btwn Columbus Ave & Central Park West)
Chinatown: Laozhengxing老正兴 (65 Bayard St. @ mott street. Start at Canal St. and Mott St, turn south at the Chase bank, and find Bayard St.)
Peking Duck House (28 Mott St)
Joe's Shanghai (9 Pell St | Btwn Doyers St & Bowery)
Flushing:   Flushing 美食地图

 

Nightlife
Happy Hour Spreadsheet

Newsletter

Other useful sites
CUCSSA (Columbia University Chinese Students and Scholars Association )
Wikipedia