sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 40 rows (hide)

Query parameters

rowidTitleRelease YearLocationsFun FactsProduction CompanyDistributorDirectorWriterActor 1Actor 2Actor 3
26 11 10 420 Jones St. at Ellis St.   9 8 10 9 245 9  
51 11 10 Broadway between Powell and Davis Driving shots 9 8 10 9 245 9  
77 11 10 Conzelman Rd at McCollough Rd and down Conzelman Rd. Aerial shots 9 8 10 9 245 9  
78 11 10 Lombard at Hyde   9 8 10 9 245 9  
79 11 10 601 Buena Vista Ave West at Java St.   9 8 10 9 245 9  
80 11 10 Columbus between Bay and Washington Driving shots 9 8 10 9 245 9  
81 11 10 California between Kearney and Davis Driving shots 9 8 10 9 245 9  
82 11 10 Pine between Kearney and Davis Driving shots 9 8 10 9 245 9  
83 11 10 Market between Stuart and Van Ness Driving shots 9 8 10 9 245 9  
84 11 10 Grant between Bush and Broadway Driving shots 9 8 10 9 245 9  
85 11 10 Intersection of Broadway at Kearney Driving shots 9 8 10 9 245 9  
86 11 10 Intersection of California at Polk Driving shots 9 8 10 9 245 9  
87 11 10 Treasure Island, Building #1, Ave of the Palms Aerial and exterior shots 9 8 10 9 245 9  
99 27 22 Yerba Buena Center for the Arts   24 20 25 24 245 23 449
100 27 22 Transbay Terminal (Mission Street at 1st Street) Built in 1939, the Terminal linked San Francisco, the East Bay, and Sacramento by rail for the first time. 24 20 25 24 245 23 449
101 27 22 Tosca CafĂ© (242 Columbus Avenue)   24 20 25 24 245 23 449
102 27 22 Steinhart Aquarium (California Academy of Sciences, Golden Gate Park) The Steinhart Aquarium is home to over 38,000 animals, which represent more than 900 species. 24 20 25 24 245 23 449
103 27 22 Raw Hide II (280 Seventh Street)   24 20 25 24 245 23 449
104 27 22 Pier 7 (The Embarcadero)   24 20 25 24 245 23 449
105 27 22 Kearney Street (Telegraph Hill)   24 20 25 24 245 23 449
107 27 22 Hall of Justice (850 Bryant Street)   24 20 25 24 245 23 449
108 27 22 2930 Vallejo Street   24 20 25 24 245 23 449
109 27 22 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. 24 20 25 24 245 23 449
110 27 22 Gibb Street (Chinatown)   24 20 25 24 245 23 449
111 27 22 1158-70 Montgomery Street   24 20 25 24 245 23 449
112 27 22 2104 Broadway   24 20 25 24 245 23 449
1404 258 8 Merchant Exchange Building (465 California Street)   156 110 213 224 245 40 532
1405 258 8 Washington Street & Waverly Place (Chinatown)   156 110 213 224 245 40 532
1406 258 8 Stockton Tunnel Southern Approach Overhang (Bush & Stockton Streets, Chinatown) Opened in 1914, the Stockton Tunnel was built to provide North Beach residents access to the thriving downtown area. 156 110 213 224 245 40 532
1407 258 8 Sheraton Palace Hotel (639 Market Street) The hotel was destroyed in the 1906 earthquake and fire, had to be rebuilt, and was reopened in 1909. 156 110 213 224 245 40 532
1408 258 8 Ritz-Carlton Hotel (600 Stockton Street)   156 110 213 224 245 40 532
1409 258 8 Presidio (Golden Gate National Recreation Area) In 1776, Spain made the Presidio a fortified area. The area was then given to Mexico, but then given to the US in 1848. The 1994 demilitarization of the area in 1994 marked the end of its 219 years of military use. 156 110 213 224 245 40 532
1410 258 8 Merchant Exchange Building   156 110 213 224 245 40 532
1411 258 8 Mason & California Streets (Nob Hill)   156 110 213 224 245 40 532
1412 258 8 Harrison Street (The Embarcadero)   156 110 213 224 245 40 532
1413 258 8 City Club (155 Sansome Street)   156 110 213 224 245 40 532
1414 258 8 Bay Bridge Before opening in 1936, the bridge was blessed by Cardinal Secretary of State Eugenio Pacelli, who later became Pope Pius XII. 156 110 213 224 245 40 532
1415 258 8 Bank of America Building (555 California Street) The Bank of America Building was the tallest building on the West Coast from 1969-1972, when it was surpassed by the TransAmerica Pyramid. Today, the Bank of America building is the 5th tallest building on the West Coast. 156 110 213 224 245 40 532
1416 258 8 301 Howard Street   156 110 213 224 245 40 532
1417 258 8 1 Bush Street   156 110 213 224 245 40 532
Powered by Datasette · Query took 1.181ms · Data source: data.sfgov.org