A. This was tricky.
All
I really had to go on here was the view in the background of the scene,
which obviously included a bridge spanning a body of water, and a city
skyline on the other side.
So first, I had to determine which bridge it was.
I
started by identifying the tallest building in the skyline, which was
right next to the bridge. That 80-floor skyscraper turned out to be One Manhattan Square, located 225 Cherry St, in Manhattan. And the bridge that is right next to turned out to be the Manhattan Bridge, which spans the East River, between Manhattan on the northwest and Brooklyn on the southeast.
That meant the Dexter camera had to be looking from Brooklyn.
Once
I knew that, I switched to Google Earth, and used its 3-D view to
recreate the same angle between the bridge and the spot where the camera
stood. Then I simply drew a line from that skyscraper over to Brooklyn,
which put me roughly at the Brooklyn Navy Yard.
A closer look at the 225-acre Navy Yard helped pinpoint the exact spot
where the scene was shot, helped by the fact that there is a short,
rocky breakwater just to the left of the camera location, and a large,
open dock area where they simulated the garbage dump.
Only
one spot matched that description. And although there is no
StreetView at the Navy Yard to make it easy, when I zoomed in as close
as I could with Google Earth, and turned its view towards the bridge
(and that skyscraper), the view perfectly matched the background in that
Resurrection scene.
I was convinced.
But for a little extra proof, I found a photo on the website of BMB
(the company that owns that loading dock), which showed the view from
their loading dock across the water. And as you can see from the
comparison shots below, that too perfectly matched the views seen in
background of that garbage dump scene.
Below, I have highlighted in red (on the Dexter screenshot)
the exact same area that is seen in BMB’s photo, and then posted
comparison shots of both that blow-up from the scene and the photo of
the view from BMB.
On the left, you will see a blow-up of the view from the garbage dump as seen above.
. On the right, you will see an image from the BMB website of the view from their loading dock:
. 
As you can see, the two views are virtually identical
( other than that one was
shot in the daylight and the other was shot at night)
But The final confirmation came when the camera turns and looks back, away from the water.
In that brief shot (see below) , we see in the background a small, red structure
that somewhat resembles a red barn or a little red schoolhouse:
And here is that same red structure, seen at the Navy Yard via Google Earth:
