The waterway , which is actually not a river despite its name , connects Upper New York Bay on its south end to Long Island Sound on its north end .
It connects Upper New York Bay on its south end to Long Island Sound on its north end .