I'm pretty confident that this is a sewer vent and not a "domestic" vent inside the cadastral parcel of a property. It has the same substantial and decorative ironwork as other sewer pipes in Durham, and is distinct from "domestic" vents. I'm guessing that it vents a small sewer running along the service alley.