This was shot on a walk across the Queensboro Bridge. You can see Roosevelt Island on the left and Queens on the right. You can also see the Roosevelt Island Bridge. That's the nearest one. Also visible are the Hellgate Bridge and the RFK Bridge, formerly known as the Triborough Bridge.
Although the only bridge to Roosevelt Island is from Queens, the island is considered part of Manhattan.