At least by the 2250s, tubes were used on the Golden Gate Bridge. During the 50s, they had solar panels, but they were removed by the 2270s. (Star Trek: The Motion Picture, DIS: "Such Sweet Sorrow, Part 2")
Sometime between 2257 and 2342, a large tube was constructed in Paris, which stretched beneath the Eiffel Tower. (TNG: "We'll Always Have Paris") This tube was removed by the year 2372. (DS9: "Paradise Lost")
The tubes shown on the Golden Gate Bridge seemed to be made of glass, transparent aluminum or some other see-through material. Their purpose was never made clear, but they may have been used to protect hovercars or other automobiles from the elements, such as heavy rain or other meteorological disturbances. This likely would have no longer been necessary by the 24th century, since the weather control system was firmly in place. Despite this, tubes were still being used even into the late twenty-fourth century.