About the location (from Wiki):
Lombard Street is an east-west street in San Francisco, California. It is famous for having a steep, one-block section that consists of tight hairpin turns. Lombard Street begins at Presidio Boulevard inside The Presidio and runs east through the Cow Hollow neighborhood. For 12 blocks between Broderick Street and Van Ness Avenue, it is a principal arterial road that is co-signed as U.S. Route 101. Lombard Street then continues through the Russian Hill and Telegraph Hill neighborhoods, breaks off at a point becoming Telegraph Hill Boulevard. That leads to Pioneer Park and Coit Tower. Lombard Street starts again at Winthrop Street and finally terminates at The Embarcadero as a collector road.

Lombard Street is best known for the one-way section on Russian Hill between Hyde and Leavenworth Streets, in which the roadway has eight sharp turns (or switchbacks) that have earned the street the distinction of being the crookedest [most winding] street in the world (though this title is contested – see below). The switchback’s design, first suggested by property owner Carl Henry and instituted in 1922, was born out of necessity in order to reduce the hill’s natural 27% grade, which was too steep for most vehicles to climb. It is also a serious hazard to pedestrians, who are accustomed to a more reasonable sixteen-degree incline. The crooked section of the street, which is about 1/4 mile (400 m) long, is reserved for one-way traffic traveling east (downhill) and is paved with red bricks. The speed limit in this section is a mere 5 mph (8 km/h).

Movies shot at this location:
AdiyE KolludhEy from Vaaranam Aayiram
Masti Masti song from Chalo Ishq LadaayE