Around 2010 or so, I bought a print of this photo in a frame at either Target or Ikea, I can't recall which, because it made me nostalgic for New York City, which I had just left.
After spending about a year with this print on my wall, I realized that the orientation of bridge and moon in the original photo could probably be used to work out when the photo was taken.
My first estimate was that photo was taken from Emily Warren Roebling Plaza in Empire Fulton Ferry State Park just to the north of the southeast pier of the Brooklyn Bridge. The coordinates are roughly 40.70427ºN, 73.99420ºW.