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
1052 1052 74 56 68 67 291 56 467 Turk Street between Steiner and Scott Streets  
483 483 88 65 80 81 300 69 472 Turk Street between Mason & Leavenworth  
1258 1258 232 141 191 202 388 177 523 Turk St between Lyon and Baker St  
178 178 38 33 36 35 270 33 457 Trolley Car from Market and 11th  
87 87 11 9 10 9 245 9   Treasure Island, Building #1, Ave of the Palms Aerial and exterior shots
63 63 20 17 19 18 254 18 446 Treasure Island  
129 129 33 29 31 30 265     Treasure Island An artificial island, Treasure Island was created for the 1939 Golden Gate International Exposition, and is named after the novel by Robert Louis Stevenson, a one-time San Francisco resident.
313 313 55 43 50 51 280 42 463 Treasure Island From the late 1980s, Treasure Island's old aircraft Hangar 2 (Building 2) and Hangar 3 (Building 3) served as sound stages for film-making and TV, including  Rent, The Pursuit of Happyness, Flubber, What Dreams May Come, Patch Adams, The Parent Trap, Bicentennial Man and the TV series Trauma.
380 380 68 52 62 61 285 50   Treasure Island An artificial island, Treasure Island was created for the 1939 Golden Gate International Exposition, and is named after the novel by Robert Louis Stevenson, a one-time San Francisco resident.
460 460 88 65 80 81 300 69 472 Treasure Island  
520 520 97 70 88 89 265 77   Treasure Island An artificial island, Treasure Island was created for the 1939 Golden Gate International Exposition, and is named after the novel by Robert Louis Stevenson, a one-time San Francisco resident.
665 665 128 15 119 118 326 104   Treasure Island An artificial island, Treasure Island was created for the 1939 Golden Gate International Exposition, and is named after the novel by Robert Louis Stevenson, a one-time San Francisco resident.
765 765 148 101 136 137 339 122 496 Treasure Island  
893 893 166 106 142 145 40 128   Treasure Island An artificial island, Treasure Island was created for the 1939 Golden Gate International Exposition, and is named after the novel by Robert Louis Stevenson, a one-time San Francisco resident.
946 946 172 108 146 150 103 131 502 Treasure Island  
1010 1010 187 118 156 162 265 143   Treasure Island An artificial island, Treasure Island was created for the 1939 Golden Gate International Exposition, and is named after the novel by Robert Louis Stevenson, a one-time San Francisco resident.
1022 1022 190 104 159 164 359 146   Treasure Island An artificial island, Treasure Island was created for the 1939 Golden Gate International Exposition, and is named after the novel by Robert Louis Stevenson, a one-time San Francisco resident.
1083 1083 202 127 31 175 369 155   Treasure Island An artificial island, Treasure Island was created for the 1939 Golden Gate International Exposition, and is named after the novel by Robert Louis Stevenson, a one-time San Francisco resident.
1581 1581 299 156 243 259 265 232   Treasure Island An artificial island, Treasure Island was created for the 1939 Golden Gate International Exposition, and is named after the novel by Robert Louis Stevenson, a one-time San Francisco resident.
100 100 27 24 25 24 245 23 449 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.
371 371 63 47 57 57 282 45   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.
565 565 103 71 95 95 308 83   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.
1452 1452 273 161 27 236 413 147   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.
688 688 134 89 111 124 286 110 491 Transamerica Building (600 Montgomery Street at Clay) The Pyramid was the tallest skyscraper west of the Mississippi from 1972-1974, until it was surpassed by Los Angeles' Aon Center.
546 546 100 38 91 92 282 80 478 TransAmerica Pyramid (600 Montgomery Street) The Pyramid was the tallest skyscraper west of the Mississippi from 1972-1974, until it was surpassed by Los Angeles' Aon Center.
1099 1099 205 129 170 178 258     TransAmerica Pyramid (600 Montgomery Street)  
141 141 34 30 32 31 266 29 453 Tosca Café (242 Columbus Avenue, North Beach)  
1310 1310 240 146 197 209 40 184   Tosca Café (242 Columbus Avenue, North Beach)  
1558 1558 296 172 241 256 430     Tosca Café (242 Columbus Avenue, North Beach)  
101 101 27 24 25 24 245 23 449 Tosca Café (242 Columbus Avenue)  
1381 1381 252 153 207 219 399 193 531 Tonic  
850 850 157 101 136 137 339 123 496 Tonga Room, Fairmont Hotel, 950 Mason Street  
1064 1064 198 124 165 171 366 153 512 Tonga Room  
740 740 148 101 136 137 339 122 496 Tiburon Hiking Trail, Tiburon, CA  
1140 1140 210 131 173 182 374 126 514 The Women's Building, 3543 18th St. The mural painted outside the building was painted by 7 women artists including Juana Alicia, Miranda Bergman and Meera Desai. The computer lab scene was filmed inside the building.
10 10 3 3 3 2 239 2   The Walden House, Buena Vista Park Established in 1867, Buena Vista Park is the oldest official park in San Francisco.
559 559 102 70 93 94 263 82   The Tamalpais Building (1201 Greenwich Street at Hyde)  
1241 1241 230 140 141 201 387 175 521 The Tamalpais Building (1201 Greenwich Street at Hyde)  
784 784 149 101 136 137 339 123 496 The Stud, 399 9th Street  
744 744 148 101 136 137 339 122 496 The Stud  
490 490 89 5 69 82 301 57 473 The Sea Captain's Chest (Fisherman's Wharf)  
64 64 20 17 19 18 254 18 446 The San Francisco School (300 Gavin St.)  
1488 1488 280 95 229 241 107 216   The San Francisco Bay  
1556 1556 209 4 111 181 324 160   The Saloon (1232 Grant Avenue)  
1380 1380 252 153 207 219 399 193 531 The Royal Oak  
169 169 38 33 36 35 270 33 457 The Ramp Restaurant  
1024 1024 191 4 160 35 360 147 507 The Music Concourse (Martin Luther King, Jr. Drive, Golden Gate Park) The theater closed in 1985.
1504 1504 284 165 232 245 421 220   The Music Concourse (Martin Luther King, Jr. Drive, Golden Gate Park) Golden Gate Park is similar in shape but 20% larger than New York's Central Park.
862 862 159 102 137 138 340     The Marsh Theatre (1062 Valencia Street)  
399 399 72 38 66 65 289 54 465 The Malloch Apartment Building (1360 Montgomery Street)  
977 977 178 29 31 154 348 135 265 The Malloch Apartment Building (1360 Montgomery Street)  
1388 1388 252 153 207 219 399 193 531 The Magazine at 920 Larkin  
238 238 44 39 42 41 275     The Lexington Club (3464 19th Street at Lexington)  
646 646 121 83 113 112 322 97   The Final Final (2990 Baker Street)  
674 674 130 86 121 120 328 106 489 The Ferry Building Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters.
766 766 148 101 136 137 339 122 496 The Fairmont  
789 789 149 101 136 137 339 123 496 The End Up, 401 6th Streeet  
1252 1252 231 38 113 71 295 176 522 The Embarcadero/Ferry Building Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters.
391 391 71 54 65 64 288 53 464 The Embarcadero/ Ferry Building Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters.
416 416 78 59 71 71 295 60   The Embarcadero  
1196 1196 221 15 183 192 381 169   The Embarcadero  
1328 1328 245 113 201 212 289 188 529 The Embarcadero  
1435 1435 265 158 71 222 409 202 539 The Embarcadero  
256 256 49 43 47 46 280 42 463 The Drew School, 2901 California  
296 296 53 43 3 49 280 42 463 The Drew School, 2901 California  
577 577 104 72 96 96 309 84 480 The Castro Theater, 429 Castro St.  
1147 1147 210 131 173 182 374 126 514 The Castro Theater, 429 Castro St. The theater has an organ which is played before every film showing.
378 378 66 50 60 60 283 48   The Castro From 1910-1920 the Castro was called "Little Scandinavia" because of its high concentration of residents of Scandinavian ancestry.
1113 1113 207 130 171   373 159   The Castro From 1910-1920 the Castro was called "Little Scandinavia" because of its high concentration of residents of Scandinavian ancestry.
1496 1496 283 164 60 244 420 219 544 The Castro From 1910-1920 the Castro was called "Little Scandinavia" because of its high concentration of residents of Scandinavian ancestry.
1349 1349 242 38 199 71 295 186 527 The Cannery (281 Leavenworth Street, Fisherman's Wharf)  
762 762 148 101 136 137 339 122 496 The Café at 2369 Market St.  
557 557 101 38 92 93 307 81 479 The Barbary Coast The Barbary Coast was a red-light district that was largely destroyed in the 1906 earthquake. Though some of the establishments were rebuilt after the earthquake, an anti-vice campaign put the establishments out of business.
1111 1111 206 8 12 179 372 158 315 The Barbary Coast The Barbary Coast was a red-light district that was largely destroyed in the 1906 earthquake. Though some of the establishments were rebuilt after the earthquake, an anti-vice campaign put the establishments out of business.
900 900 167   143 146 342     The 500 Club (500 Guerrero Street, Mission District)  
999 999 183 115 152 158 353 140   Texas & 19th Streets (Potrero Hill)  
328 328 59 43 54 51 280 42 463 Terry A. Francois Blvd.  
117 117 30 27 28 27 262 26 452 Tenderloin Neighborhood  
430 430 79 60 72 72 3 61   Telegraph Hill Blvd (Telegraph Hill)  
662 662 128 15 119 118 326 104   Telegraph Hill Largely untouched by the 1906 earthquake, Telegraph Hill has the most pre-1870 buildings in the city.
678 678 132 87 123 122 210 108 46 Telegraph Hill Largely untouched by the 1906 earthquake, Telegraph Hill has the most pre-1870 buildings in the city.
1420 1420 260 14 215 226 405 198 534 Telegraph Hill Largely untouched by the 1906 earthquake, Telegraph Hill has the most pre-1870 buildings in the city.
584 584 104 72 96 96 309 84 480 Taylor and Union  
35 35 10 8 9 8 244 8 441 Taylor and Jefferson Streets (Fisherman's Wharf)  
50 50 15 12 14 13 249 13   Taylor St. from Broadway to Filbert  
342 342 61 45 55 55 280 43 463 Taylor St, north of Jefferson St to end  
212 212 42 37 40 39 273 36 459 Taylor & Vallejo Streets (Russian Hill)  
172 172 38 33 36 35 270 33 457 Taylor & Green St.  
1058 1058 198 124 165 171 366 153 512 Tank Hill Park  
1384 1384 252 153 207 219 399 193 531 Tank Hill Park  
1199 1199 222 136 184 193 382 170   Swedenborgian Church (2107 Lyon Street)  
1228 1228 227 138 188 198 384 172 519 Sutter-Stockton Garage (444 Stockton)  
1315 1315 241 147 198 210 394 185   Sutter-Stockton Garage (330 Sutter Street at Stockton) Garage roof serves as a heliport in the movie
623 623 111 5 103 103 315 90 484 Sutter Street between Powell and Mason  
281 281 52 43 48 48 280 42 463 Sutter Stockton Garage, 444 Stockton  
1303 1303 239 145 196 208 334 183   Sutter Stockton Garage  
1393 1393 255 38 210 222 295 195 60 Sutter & Webster Streets  
523 523 99 4 90 91 306 79 477 Sutter & Buchannan Streets  
524 524 99 4 90 91 306 79 477 Sutter & Baker Streets  
631 631 115 79 107 91 318 92   Sutro Baths (Point Lobos Avenue)  

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 10.669ms · Data source: data.sfgov.org