sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTitleRelease YearLocationsFun FactsProduction CompanyDistributorDirectorWriterActor 1Actor 2Actor 3
1566 298 72 York Hotel (940 Sutter Street)   174 3 81 258 432 231 106
1338 249 49 Westin St. Francis Hotel (335 Powell Street, Union Square) The hotel was originally supposed to be named the Crocker Hotel, after Charles Founder the railroad magnate who founded it. However, the hotel took the name the St. Francis after one of the earliest Gold Rush hotels. 92 3 127 216 178 191 530
1214 225 28 West Harbor, Marina District   4 3 187 196 383 171 518
1456 275 23 Washington Street & Waverly Place (Chinatown)   4 3 226 238 107 211 46
709 126 39 Washington Square (North Beach) Washington Square Park is not actually a square, as it has 5 sides. North Beach is not a beach. 4 3 117 24 223 102 487
522 99 7 War Memorial Opera House (401 Van Ness Avenue) In 1945 the United Nations had its first conference at The War Memorial Opera House. 4 3 90 91 306 79 477
710 126 39 War Memorial Opera House (401 Van Ness Avenue) In 1945 the United Nations had its first conference at The War Memorial Opera House. 4 3 117 24 223 102 487
1552 209 5 Veterans' War Memorial Building (401 Van Ness Avenue)   4 3 111 181 324 160  
1555 209 5 Vesuvio Café (255 Columbus Avenue) Jack Kerouac was a regular at the café. 4 3 111 181 324 160  
1287 239 10 Van Ness between Fell and Lombard   145 3 196 208 334 183  
1300 239 10 Union Square   145 3 196 208 334 183  
1339 249 49 Union Square During the Civil War, pro-Union rallies were held in the Square, and thus the area was called "Union Square". 92 3 127 216 178 191 530
1556 209 5 The Saloon (1232 Grant Avenue)   4 3 111 181 324 160  
1024 191 62 The Music Concourse (Martin Luther King, Jr. Drive, Golden Gate Park) The theater closed in 1985. 4 3 160 35 360 147 507
1303 239 10 Sutter Stockton Garage   145 3 196 208 334 183  
523 99 7 Sutter & Buchannan Streets   4 3 90 91 306 79 477
524 99 7 Sutter & Baker Streets   4 3 90 91 306 79 477
631 115 42 Sutro Baths (Point Lobos Avenue)   79 3 107 91 318 92  
1025 191 62 Surf Theater (4520 Irving Street)   4 3 160 35 360 147 507
1495 282 73 St. Peter & Paul's Church (666 Filbert Street, Washington Square) Exteriors of the church were used. 4 3 231 243 419 218 15
525 99 7 Sokoji-Soto Zen Buddhist Temple (1691 Laguna Street)   4 3 90 91 306 79 477
711 126 39 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. 4 3 117 24 223 102 487
1457 275 23 Sansome Street (The Embarcadero)   4 3 226 238 107 211 46
23 9 8 San Francisco International Airport SFO has a museum dedicated to aviation history. 4 3 8 7 243 7  
1567 298 72 San Francisco Drydock (20th and Illinois Streets)   174 3 81 258 432 231 106
1301 239 10 San Francisco - Oakland Bay Bridge   145 3 196 208 334 183  
1340 249 49 Saks Fifth Avenue (384 Post Street, Union Square)   92 3 127 216 178 191 530
526 99 7 Sacramento & Hyde Streets (Nob Hill)   4 3 90 91 306 79 477
1622 307 75 SF Chronicle Building (901 Mission St)   4 3 213 266 438 118  
1547 209 5 Red's Java House (Pier 30-32, The Embarcadero)   4 3 111 181 324 160  
1458 275 23 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. 4 3 226 238 107 211 46
1305 239 10 Powell St at Geary St   145 3 196 208 334 183  
528 99 7 Potrero Hill Bathhouse & Feed Co. (199 Mississippi Street)   4 3 90 91 306 79 477
502 92 35 Postcard Row (Alamo Square, Hayes Valley) The 6 Victorian homes across from Alamo Square Park are among the few Victorians to survive the Great Fire. 4 3 83 85 214 72  
527 99 7 Postcard Row (Alamo Square, Hayes Valley) The 6 Victorian homes across from Alamo Square Park are among the few Victorians to survive the Great Fire. 4 3 90 91 306 79 477
1293 239 10 Pine and Leavenworth   145 3 196 208 334 183  
1309 239 10 Pine St. between Market and Montgomery   145 3 196 208 334 183  
1298 239 10 Pine St. between Market and Kearny   145 3 196 208 334 183  
1548 209 5 Piers 30-32   4 3 111 181 324 160  
1549 209 5 Pier 39   4 3 111 181 324 160  
1133 209 5 Pier 24   4 3 111 181 324 160  
1308 239 10 Pier 14   145 3 196 208 334 183  
1568 298 72 Park Hill Sanatorium (351 Buena Vista Avenue East) This location is now a condominium complex. 174 3 81 258 432 231 106
521 98 48 Palace of Fine Arts (3301 Lyon Street) The original Palace was built for the 1915 Panama-Pacific Exposition, and completely destroyed in 1964. It was rebuilt in 1965. 4 3 89 90 305 78  
1565 298 72 Palace of Fine Arts (3301 Lyon Street) The original Palace was built for the 1915 Panama-Pacific Exposition, and completely destroyed in 1964. It was rebuilt in 1965. 174 3 81 258 432 231 106
712 126 39 Palace of Fine Arts The original Palace was built for the 1915 Panama-Pacific Exposition, and completely destroyed in 1964. It was rebuilt in 1965. 4 3 117 24 223 102 487
1341 249 49 One Embarcadero Center (Financial District)   92 3 127 216 178 191 530
529 99 7 Octavia & Hayes Streets (Hayes Valley)   4 3 90 91 306 79 477
1215 225 28 North Beach   4 3 187 196 383 171 518
1342 249 49 Neiman Marcus (150 Stockton Street, Union Square) In the film the City of Paris Department Store is featured. That establishment was located where Neiman Marcus stands today 92 3 127 216 178 191 530
1459 275 23 Montgomery & Vallejo Streets (Telegraph Hill)   4 3 226 238 107 211 46
530 99 7 Montgomery & Pine Streets (Financial District)   4 3 90 91 306 79 477
1550 209 5 Mojito (1337-1339 Grant Avenue)   4 3 111 181 324 160  
1289 239 10 Mission at 1st and 2nd   145 3 196 208 334 183  
1302 239 10 Mission St., Embarcadero, and Front between Clay and Market   145 3 196 208 334 183  
1569 298 72 Mission San Juan Bautista (2nd & Mariposa Streets)   174 3 81 258 432 231 106
1570 298 72 Mission Dolores (3321 16th Street, Mission District) Mission Dolores' official name is Mission San Francisco de Assis. It is the oldest building in San Francisco, built in 1791, and has survived two major earthquakes. 174 3 81 258 432 231 106
1551 209 5 McCovey Point, China Basin Park (24 Willy Mays Plaza)   4 3 111 181 324 160  
1290 239 10 Market at Mason   145 3 196 208 334 183  
1297 239 10 Market St. at Embarcadero area   145 3 196 208 334 183  
1460 275 23 Market & 2nd Streets   4 3 226 238 107 211 46
1216 225 28 Marina Green, Marina District Before the 1906 earthquake, the land on which Marina Green sits was a tidal marsh, and rubble from the earthquake was dumped on the site. However, the site was filled in to provide land for the 1915 Panama-Pacific Exhibition. 4 3 187 196 383 171 518
660 126 39 Lombard & Hyde Streets   4 3 117 24 223 102 487
531 99 7 Laguna & Sacramento Streets (Pacific Heights)   4 3 90 91 306 79 477
1554 209 5 La Bodega (1332 Grant Avenue at Vallejo)   4 3 111 181 324 160  
1217 225 28 Kearny & Pacific Streets   4 3 187 196 383 171 518
706 126 39 Japanese Tea Garden (Hagiwara Tea Garden Drive, Golden Gate Park) The Japanese Hagiwara family invented "Chinese" fortune cookies in the tea-garden 4 3 117 24 223 102 487
1218 225 28 Intersection of Grant & Fresno Streets (North Beach)   4 3 187 196 383 171 518
1219 225 28 Intersection of Columbus & Mason Streets   4 3 187 196 383 171 518
1220 225 28 Intersection of Columbus & Kearney Streets   4 3 187 196 383 171 518
1026 191 62 Hyde Street Cable Car   4 3 160 35 360 147 507
1294 239 10 Howard St. from Embarcadero to 11 St.   145 3 196 208 334 183  
22 9 8 Hills Brothers Plaza (Embarcadero at Harrison Street)   4 3 8 7 243 7  
532 99 7 Hayes Valley Care (601 Laguna Street, Hayes Valley)   4 3 90 91 306 79 477
1461 275 23 Hayes & Polk Streets (Civic Center)   4 3 226 238 107 211 46
685 126 39 Hall of Justice (850 Bryant Street)   4 3 117 24 223 102 487
21 9 8 Grace Cathedral Episcopal Church (1100 California Street) Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. 4 3 8 7 243 7  
1030 193 47 Grace Cathedral Episcopal Church (1100 California Street) Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. 122 3 162 166 362 130 508
1571 298 72 Gough & Eddy Streets (Western Addition)   174 3 81 258 432 231 106
632 115 42 Golden Gate Park   79 3 107 91 318 92  
1213 224 4 Golden Gate Park   4 3 186 195 383 171 518
1221 225 28 Golden Gate Park   4 3 187 196 383 171 518
903 169 43 Golden Gate Bridge With 23 miles of ladders and 300,000 rivets in each tower, the Golden Gate Bridge was the world's longest span when it opened in 1937. 4 3 145 148 343 130  
1222 225 28 Golden Gate Bridge With 23 miles of ladders and 300,000 rivets in each tower, the Golden Gate Bridge was the world's longest span when it opened in 1937. 4 3 187 196 383 171 518
1225 226 37 Golden Gate Bridge With 23 miles of ladders and 300,000 rivets in each tower, the Golden Gate Bridge was the world's longest span when it opened in 1937. 4 3 186 197 383 171 518
1345 250 38 Golden Gate Bridge With 23 miles of ladders and 300,000 rivets in each tower, the Golden Gate Bridge was the world's longest span when it opened in 1937. 151 3 205 217 397 192  
1462 275 23 Golden Gate Bridge With 23 miles of ladders and 300,000 rivets in each tower, the Golden Gate Bridge was the world's longest span when it opened in 1937. 4 3 226 238 107 211 46
533 99 7 Golden Gate & Steiner Streets (Hayes Valley)   4 3 90 91 306 79 477
1299 239 10 Front St. between Market and Clay   145 3 196 208 334 183  
534 99 7 Fort Point, Presidio Built in 1853, Fort Point is the only West Coast fort built by the Union Army. Though the Confederate army planned to attack San Francisco, the commanding Confederate general learned that the war had ended while end route to SF. 4 3 90 91 306 79 477
1463 275 23 Fort Point (Presidio, Golden Gate National Recreation Area) Built in 1853, Fort Point is the only West Coast fort built by the Union Army. Though the Confederate army planned to attack San Francisco, the commanding Confederate general learned that the war had ended while end route to SF. 4 3 226 238 107 211 46
1572 298 72 Fort Point (Presidio, Golden Gate National Recreation Area) Built in 1853, Fort Point is the only West Coast fort built by the Union Army. Though the Confederate army planned to attack San Francisco, the commanding Confederate general learned that the war had ended while end route to SF. 174 3 81 258 432 231 106
535 99 7 Fort Mason (Golden Gate National Recreation Area) Constructed in 1864 as a coastal defense site, Fort Mason went on to serve as an army post for more than 100 years. 4 3 90 91 306 79 477
536 99 7 Flood Building (870 Market Street)   4 3 90 91 306 79 477
707 126 39 Fior d' Italia (601 Union Street at Stockton)   4 3 117 24 223 102 487
1343 249 49 Financial District   92 3 127 216 178 191 530
537 99 7 Fiesta Laundromat (898 S. Van Ness Ave., Mission)   4 3 90 91 306 79 477
1158 212 34 Ferry Building Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. 4 3 175 184 375 162  
1464 275 23 Ferry Building Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. 4 3 226 238 107 211 46
708 126 39 Fairmont Hotel (950 Mason Street, Nob Hill) In 1945 the Fairmont hosted the United Nations Conference on International Organization as delegates arrived to draft a charter for the organization. The U.S. Secretary of State, Edward Stettinius drafted the charter in the hotel's Garden Room. 4 3 117 24 223 102 487
904 169 43 Fairmont Hotel (950 Mason Street, Nob Hill) In 1945 the Fairmont hosted the United Nations Conference on International Organization as delegates arrived to draft a charter for the organization. The U.S. Secretary of State, Edward Stettinius drafted the charter in the hotel's Garden Room. 4 3 145 148 343 130  
Powered by Datasette · Query took 1.779ms · Data source: data.sfgov.org