Outer Ring Road:
Allandale Road, which is the link through the huge Pippy Park (it's Stanley Park-level in size) between the Outer Ring Road and Prince Philip Drive. St. John's is kind of shaped like a bowtie. Prince Phillip Drive is part of the ring round around the ball in the middle of the bowtie, which includes downtown.
And then Team Gushue Highway U/C. This will be one of the only north-south routes linking the Kenmount Road part of St. John's with the adjacent city of Mount Pearl, on the other side of the hill (which exceeds the until-recently maximum elevation for development, so nothing could link them.
Red circle is intersection above. I'm on Blackmarsh, camera is facing south: