It 's very exciting and it gives Long Island Sound the same status as Chesapeake Bay , San Francisco Bay and other estuaries of national significance , '' said Robert D. Yaro , the president of the Regional Plan Association , a private group in Manhattan that does planning for the New York , New Jersey and Connecticut metropolitan area . ''