Film_Locations_in_San_Francisco_fts

Data source: data.sfgov.org

1,622 rows sorted by Locations descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid Title Production Company Director Writer Actor 1 Actor 2 Actor 3 Locations ▲ Fun Facts
1447 1447 269 128 222 233 391 206   skyline/ exterior scenes  
1124 1124 208 131 172 180 374     Z Space Studios; 450 Florida St. Filming of the "Fresh Meat" Festival
1566 1566 298 174 81 258 432 231 106 York Hotel (940 Sutter Street)  
1072 1072 201 126 167 174 368 154 513 York & 24th St.  
1390 1390 252 153 207 219 399 193 531 Yerba Buena Island  
1063 1063 198 124 165 171 366 153 512 Yerba Buena Gardens  
99 99 27 24 25 24 245 23 449 Yerba Buena Center for the Arts  
282 282 52 43 48 48 280 42 463 YWCA, 940 Powell  
1607 1607 303 176 142 145 435 234 550 Women's Building, 3543 18th St. Roma Guy was one of the founders of the Women's Building
120 120 30 27 28 27 262 26 452 Wisconsin between 19th and 20th St  
1060 1060 198 124 165 171 366 153 512 Wine Impression  
808 808 151 101 136 137 339 123 496 Willy's Barber shop, 3227 22nd Street  
860 860 158 101 136 137 339 123 496 Willy's Barber shop, 3227 22nd Street  
754 754 148 101 136 137 339 122 496 Willy's Barber Shop  
263 263 50 43 48 47 280 42 463 William Stout Architectural Books, 804 Montgomery St.  
513 513 95 38 86 87 264 75   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.
1331 1331 247 150 203 214 169 189   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.
1338 1338 249 92 127 216 178 191 530 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.
393 393 71 54 65 64 288 53 464 Westin St. Francis Hotel (335 Powell Street) 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.
279 279 52 43 48 48 280 42 463 Westin St. Francis  
1138 1138 210 131 173 182 374 126 514 Westerfeld House, 1198 Fulton St. In the 1940's, the house became a 14-unit apartment building that housed jazz musicians including John Handy. This location serves as the hideout for the San Francisco-based character Nomi.
1214 1214 225 4 187 196 383 171 518 West Harbor, Marina District  
439 439 82 14 75 75 3 63   West Chrissy Field (Presidio, Golden Gate National Recreation Area) This movie was the first to film in the revamped Chrissy Field Picnic Area.
489 489 89 5 69 82 301 57 473 Wells Fargo Bank (1 California Street, Financial District)  
429 429 79 60 72 72 3 61   Webster Street  
139 139 28 25 26 25 260 24 450 Way Faire Inn on Leidesdorff  
155 155 37 32 35 34 269 32 456 Waverly Pl between Washington and Sacramento  
921 921 171 108 146 150 103 131 502 Waverly Alley between Grant and Sacramento Streets  
1107 1107 205 129 170 178 258     Water work in SF Bay Characters drive in a high speed picture boat to see different views of the city.
978 978 178 29 31 154 348 135 265 Wasteland Store (1600 Haight Street)  
1153 1153 210 131 173 182 374 126 514 Washington between Stockton and Kearny  
1405 1405 258 156 213 224 245 40 532 Washington Street & Waverly Place (Chinatown)  
1456 1456 275 4 226 238 107 211 46 Washington Street & Waverly Place (Chinatown)  
415 415 78 59 71 71 295 60   Washington Square, North Beach  
1314 1314 241 147 198 210 394 185   Washington Square Park (North Beach) Washington Square Park is not actually a square, as it has 5 sides. North Beach is not a beach. The statue in the Park is Ben Franklin, not George Washington.
1347 1347 242 38 199 71 295 186 527 Washington Square Park (North Beach) Washington Square Park is not actually a square, as it has 5 sides. North Beach is not a beach. The statue in the Park is Ben Franklin, not George Washington.
122 122 31 14 29 28 263 27   Washington Square Park (Filbert, between Stockton and Powell)  
262 262 50 43 48 47 280 42 463 Washington Square Park  
309 309 55 43 50 51 280 42 463 Washington Square Park  
638 638 117 80 109 108 19 93 451 Washington Square Bar & Grill (1707 Powell)  
709 709 126 4 117 24 223 102 487 Washington Square (North Beach) Washington Square Park is not actually a square, as it has 5 sides. North Beach is not a beach.
1100 1100 205 129 170 178 258     Washington Square  
275 275 50 43 48 47 280 42 463 Warren's Antiques, 375 9th St.  
283 283 52 43 48 48 280 42 463 Warren's Antiques, 375 9th St.  
522 522 99 4 90 91 306 79 477 War Memorial Opera House (401 Van Ness Avenue) In 1945 the United Nations had its first conference at The War Memorial Opera House.
635 635 116 15 108 107 319     War Memorial Opera House (401 Van Ness Avenue) In 1945 the United Nations had its first conference at The War Memorial Opera House.
710 710 126 4 117 24 223 102 487 War Memorial Opera House (401 Van Ness Avenue) In 1945 the United Nations had its first conference at The War Memorial Opera House.
1226 1226 227 138 188 198 384 172 519 War Memorial Opera House (401 Van Ness Avenue)  
1434 1434 265 158 71 222 409 202 539 War Memorial Opera House (401 Van Ness Avenue) In 1945 the United Nations had its first conference at The War Memorial Opera House.
564 564 103 71 95 95 308 83   War Memorial Building (401 Van Ness Avenue)  
345 345 61 45 55 55 280 43 463 Waller St between Masonic and Del Mar St  
1375 1375 252 153 207 219 399 193 531 Victoria Theatre  
1591 1591 302 104 246 262 58 46   Victor's Restaurant, The Westin St. Francis Hotel (335 Powell Street) 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.
1552 1552 209 4 111 181 324 160   Veterans' War Memorial Building (401 Van Ness Avenue)  
653 653 123 13 114 113 323 98   Vesuvio Café (255 Columbus Avenue) Jack Kerouac was a regular at the café.
1198 1198 222 136 184 193 382 170   Vesuvio Café (255 Columbus Avenue) Jack Kerouac was a regular at the café.
1555 1555 209 4 111 181 324 160   Vesuvio Café (255 Columbus Avenue) Jack Kerouac was a regular at the café.
866 866 160 59 138 139 295 124 497 Vermont Street between 20th and 22nd Streets  
857 857 158 101 136 137 339 123 496 Vega Coffee, 1245 Folsom Street  
616 616 108 5 100 100 292 87 482 Various locations in San Francisco during driving scene  
582 582 104 72 96 96 309 84 480 Various Haight St. Vintage Shops  
72 72 20 17 19 18 254 18 446 Variety Preview Room (582 Market St.)  
506 506 94 68 85 86 113 74 475 Varennes Alley between Filbert and Union  
1287 1287 239 145 196 208 334 183   Van Ness between Fell and Lombard  
785 785 149 101 136 137 339 123 496 Van Ness and Market Street MUNI exit The character of Doris was originally a recurring role, but everyone on the team liked Lauren Weedman's performance so much that she became a full time regular during the second season.
1136 1136 208 131 172 180 374     Van Ness and 12th St. A couple reminisces on the moment they first fell in love
34 34 10 8 9 8 244 8 441 Van Ness Avenue  
663 663 128 15 119 118 326 104   Vallejo Street at Sansome  
1130 1130 208 131 172 180 374     Vallejo Street Garage; 766 Vallejo St. dialogue scene on top of a garage roof
1080 1080 201 126 167 174 368 154 513 Vallejo Street Garage  
1103 1103 205 129 170 178 258     Vallejo St. Garage, 766 Vallejo St. Characters watch from roof of garage as tsunami hits SF waterfront
1090 1090 205 129 170 178 258     Vallejo Garage Roof (Vallejo at Powell)  
838 838 155 101 136 137 339 123 496 Valenti, Marini, Perata, 4840 Mission Street  
772 772 148 101 136 137 339 122 496 Valencia St. from 16th to 17th  
123 123 31 14 29 28 263 27   Vaillancourt Fountain (Justin Herman Plaza) Installed in 1975, the Vaillancourt Fountain is officially titled, "Québec Libre!". The night before the sculpture's inauguration, artist Armand Vaillancourt inscribed "Québec libre!" in red letters on the sculpture. The next day when he noticed that the note had been erased, Vaillancourt jumped on the statue to re-inscribe his message.
1051 1051 74 56 68 67 291 56 467 Uva Enoteca, 568 Haight Street  
821 821 152 101 136 137 339 123 496 Urban Flowers, 4029 18th Street  
756 756 148 101 136 137 339 122 496 Urban Flowers  
612 612 107 71 95 99 312 86   University of California Hastings College of the Law  
401 401 73 55 67 66 290 55 466 University Club  
687 687 134 89 111 124 286 110 491 United Nations Plaza (Civic Center) United Nations Plaza was built in 1975 and across its walkways are white lines into which the preamble to the preamble of the UN charter is carved.
724 724 142 67 84 131 334 117 494 United Nations Plaza (Civic Center) United Nations Plaza was built in 1975 and across its walkways are white lines into which the preamble to the preamble of the UN charter is carved.
1536 1536 289 166 186 249 425 224 546 United Nations Plaza (Civic Center) United Nations Plaza was built in 1975 and across its walkways are white lines into which the preamble to the preamble of the UN charter is carved.
1599 1599 303 176 142 145 435 234 550 United Nations Plaza  
1178 1178 220 135 182 191 380 168 517 Unitarian Church (1187 Franklin St.)  
349 349 61 45 55 55 280 43 463 Union St at Leavenworth St  
392 392 71 54 65 64 288 53 464 Union Square During the Civil War, pro-Union rallies were held in the Square, and thus the area was called "Union Square".
654 654 123 13 114 113 323 98   Union Square During the Civil War, pro-Union rallies were held in the Square, and thus the area was called "Union Square".
761 761 148 101 136 137 339 122 496 Union Square  
1300 1300 239 145 196 208 334 183   Union Square  
1339 1339 249 92 127 216 178 191 530 Union Square During the Civil War, pro-Union rallies were held in the Square, and thus the area was called "Union Square".
592 592 104 72 96 96 309 84 480 Underground SF, 424 Haight St.  
1564 1564 297 173 242 257 431 230 549 Under Highway 101 (near Potrero and Cesar Chavez Streets)  
267 267 50 43 48 47 280 42 463 UN Plaza/ Civic Center Bart steps  
467 467 88 65 80 81 300 69 472 UCSF Mt Zion 1600 Divisadero  
856 856 158 101 136 137 339 123 496 Twin Peaks Park  
154 154 37 32 35 34 269 32 456 Twin Peaks Blvd.  
1606 1606 303 176 142 145 435 234 550 Twin Peaks Bar, 401 Castro  
381 381 68 52 62 61 285 50   Twin Peaks The 2nd highest point in SF after Mt. Davidson, Twin Peaks sit at the geographic center of SF. The native Ohlone people called the area “Los Pechos de la Chola” or "Breasts of the Indian Maiden," but in the 19th Century when America took over the area, it was renamed "Twin Peaks".
545 545 100 38 91 92 282 80 478 Twin Peaks The 2nd highest point in SF after Mt. Davidson, Twin Peaks sit at the geographic center of SF. The native Ohlone people called the area "called the area “Los Pechos de la Chola” or "Breasts of the Indian Maiden," but in the 19th Century when America took over the area, it was renamed "Twin Peaks".

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIRTUAL TABLE "Film_Locations_in_San_Francisco_fts" USING FTS4 ("Title", "Production Company", "Director", "Writer", "Actor 1", "Actor 2", "Actor 3", "Locations", "Fun Facts", content="Film_Locations_in_San_Francisco");
Powered by Datasette · Query took 121.233ms · Data source: data.sfgov.org