Its Mandeville, LA, the northshore of lake pontchatrain, New orleans/metairie is the southshore.
And thats the causeway bridge, it was the longest bridge in the world for like 50 years, but they just built one in china in 2011 that was longer but isnt technically over water the entire way lol.
History lesson for the day
And actually looking on wikipedia to see where that other bridge was, I see that the three longest bridges in the U.S. were all in LA. strange