The Coevolution of Galaxies and Supermassive Black Holes: Insights from Surveys of the Contemporary Universe