While I could be mistaken, I don't believe that I ever saw one like that on the Leahy-class DLG or the Adams-class DDG that I served aboard. As I recall, most, if not all, of the large watertight doors (usually condition Zebra doors) had a smaller (Xray) hatch included in them like the one below.
You would not be able to open this door from the other side if it were dogged down. Right?
The picture in 230? I think but it's been 38 years that that type of hatch was used in places like the shaft alleys. Again another space not normally manned but checked every two hours or so by a Rover Watch. IIRC that specific type can be opened either side as the dog handles are on a shaft that goes all the wall through the bulkhead. I could be wrong but that is the only place I remember seeing that type of hatch and it was down on the 6th deck and maybe a few machinery rooms elsewhere. Then there was the typical passageway hatches that had a handle which operated all dogs at the same time.