This is the Passage du Gois in France, connecting the Gulf of Burnёf and the island of Noirmoutier. It can only be used twice a day for a few hours at a time because it disappears underwater during high tide. That sounds adventurous!
Twice every day, when the high tide rises, the 2.58-mile long road disappears 13 ft under water. So people can use this road only two times a day for a few hours (special panels on both sides of the road show when it's safe to use it). Though sometimes people still get caught between the tides, but luckily there are elevated rescue towers for people to climb and wait to be rescued.
Man, that would never work in Los Angeles. People don't even understand not to pull into the middle of an intersection when the traffic light is about to turn red so they don't block traffic coming perpendicular when it changes. They just sit there looking dumb and trying not to make eye contact while I scream my face off about how I'm going to eat their family instead of picking up a pre-cooked rotisserie chicken from the grocery store.
Keep going for several more shots.
Thanks to Stephanie B, who agrees you don't need roads when you've got a hovercar.