Film_Locations_in_San_Francisco

Data source: data.sfgov.org

1,622 rows sorted by Actor 3 descending

View and edit SQL

Link rowid Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3 ▲
1621 Yours, Mine and Ours 306 1968 31     Desilu Productions 179 United Artists 19 Melville Shavelson 249 Bob Carroll, Jr. 265 Lucille Ball 437 Henry Fonda 236 Van Johnson 551
1613 When We Rise 303 2017 20 Powell St. at Market St.   Film 49 Productions 176 Amercian Broadcasting Company 119 Gus Van Sant 142 Dustin Lance Black 145 Guy Pierce 435 Mary-Louise Parker 234 Michael Kenneth Williams 550
1612 When We Rise 303 2017 20 426 Castro St.   Film 49 Productions 176 Amercian Broadcasting Company 119 Gus Van Sant 142 Dustin Lance Black 145 Guy Pierce 435 Mary-Louise Parker 234 Michael Kenneth Williams 550
1611 When We Rise 303 2017 20 Castro St. between 17th and 18th St.   Film 49 Productions 176 Amercian Broadcasting Company 119 Gus Van Sant 142 Dustin Lance Black 145 Guy Pierce 435 Mary-Louise Parker 234 Michael Kenneth Williams 550
1610 When We Rise 303 2017 20 Eureka Arts Center, 4400 20th St.   Film 49 Productions 176 Amercian Broadcasting Company 119 Gus Van Sant 142 Dustin Lance Black 145 Guy Pierce 435 Mary-Louise Parker 234 Michael Kenneth Williams 550
1609 When We Rise 303 2017 20 Haight St. at Central   Film 49 Productions 176 Amercian Broadcasting Company 119 Gus Van Sant 142 Dustin Lance Black 145 Guy Pierce 435 Mary-Louise Parker 234 Michael Kenneth Williams 550
1608 When We Rise 303 2017 20 Buena Vista Park   Film 49 Productions 176 Amercian Broadcasting Company 119 Gus Van Sant 142 Dustin Lance Black 145 Guy Pierce 435 Mary-Louise Parker 234 Michael Kenneth Williams 550
1607 When We Rise 303 2017 20 Women's Building, 3543 18th St. Roma Guy was one of the founders of the Women's Building Film 49 Productions 176 Amercian Broadcasting Company 119 Gus Van Sant 142 Dustin Lance Black 145 Guy Pierce 435 Mary-Louise Parker 234 Michael Kenneth Williams 550
1606 When We Rise 303 2017 20 Twin Peaks Bar, 401 Castro   Film 49 Productions 176 Amercian Broadcasting Company 119 Gus Van Sant 142 Dustin Lance Black 145 Guy Pierce 435 Mary-Louise Parker 234 Michael Kenneth Williams 550
1605 When We Rise 303 2017 20 Harvey Milk Plaza, 17th and Castro   Film 49 Productions 176 Amercian Broadcasting Company 119 Gus Van Sant 142 Dustin Lance Black 145 Guy Pierce 435 Mary-Louise Parker 234 Michael Kenneth Williams 550
1604 When We Rise 303 2017 20 24th St. between Florida and Alabama   Film 49 Productions 176 Amercian Broadcasting Company 119 Gus Van Sant 142 Dustin Lance Black 145 Guy Pierce 435 Mary-Louise Parker 234 Michael Kenneth Williams 550
1603 When We Rise 303 2017 20 Bay Bridge   Film 49 Productions 176 Amercian Broadcasting Company 119 Gus Van Sant 142 Dustin Lance Black 145 Guy Pierce 435 Mary-Louise Parker 234 Michael Kenneth Williams 550
1602 When We Rise 303 2017 20 440 Castro St.   Film 49 Productions 176 Amercian Broadcasting Company 119 Gus Van Sant 142 Dustin Lance Black 145 Guy Pierce 435 Mary-Louise Parker 234 Michael Kenneth Williams 550
1601 When We Rise 303 2017 20 Castro Theatre, 429 Castro St.   Film 49 Productions 176 Amercian Broadcasting Company 119 Gus Van Sant 142 Dustin Lance Black 145 Guy Pierce 435 Mary-Louise Parker 234 Michael Kenneth Williams 550
1600 When We Rise 303 2017 20 520 Castro St.   Film 49 Productions 176 Amercian Broadcasting Company 119 Gus Van Sant 142 Dustin Lance Black 145 Guy Pierce 435 Mary-Louise Parker 234 Michael Kenneth Williams 550
1599 When We Rise 303 2017 20 United Nations Plaza   Film 49 Productions 176 Amercian Broadcasting Company 119 Gus Van Sant 142 Dustin Lance Black 145 Guy Pierce 435 Mary-Louise Parker 234 Michael Kenneth Williams 550
1598 When We Rise 303 2017 20 City Hall Exterior scenes include re-creating the White Night Riots on May 21, 1979 and the Gay Freedom March. Interior scenes included the wedding ceremony for Roma and Diane which had a few Board of Supervisors in the ceremony. The current Clerk for the Board of Supervisors played herself in one of the scenes filmed in the Chambers. Film 49 Productions 176 Amercian Broadcasting Company 119 Gus Van Sant 142 Dustin Lance Black 145 Guy Pierce 435 Mary-Louise Parker 234 Michael Kenneth Williams 550
1564 Vegas in Space 297 1992 22 Under Highway 101 (near Potrero and Cesar Chavez Streets)   Troma Entertainment 173 MCA/Universal Home Video 117 Phillip R. Ford 242 Doris Fish 257 Doris Fish 431 Miss X 230 Ginger Quest 549
1563 Vegas in Space 297 1992 22 3567 18th Street   Troma Entertainment 173 MCA/Universal Home Video 117 Phillip R. Ford 242 Doris Fish 257 Doris Fish 431 Miss X 230 Ginger Quest 549
1562 Vegas in Space 297 1992 22 422 Oak Street at Laguna   Troma Entertainment 173 MCA/Universal Home Video 117 Phillip R. Ford 242 Doris Fish 257 Doris Fish 431 Miss X 230 Ginger Quest 549
1561 Vegas in Space 297 1992 22 544 Natoma (SOMA)   Troma Entertainment 173 MCA/Universal Home Video 117 Phillip R. Ford 242 Doris Fish 257 Doris Fish 431 Miss X 230 Ginger Quest 549
1560 Vegas in Space 297 1992 22 Corona Heights Park   Troma Entertainment 173 MCA/Universal Home Video 117 Phillip R. Ford 242 Doris Fish 257 Doris Fish 431 Miss X 230 Ginger Quest 549
1559 Vegas in Space 297 1992 22 Project Artaud (Florida Street)   Troma Entertainment 173 MCA/Universal Home Video 117 Phillip R. Ford 242 Doris Fish 257 Doris Fish 431 Miss X 230 Ginger Quest 549
1545 Tucker: The Man and His Dream 293 1988 23 City Hall The dome of SF's City Hall is almost a foot taller than that of the US Capitol Building. In 1954, Joe DiMaggio and Marilyn Monroe married at the Beaux Arts-style building. Lucasfilm 170 Paramount Pictures 3 Francis Ford Coppola 127 Arnold Schulman 253 Jeff Bridges 113 Joan Allen 228 Marin Landau 548
1543 To the Ends of the Earth 291 1948 56     Kennedy-Buckman Pictures 169 Columbia Pictures 4 Robert Stevenson 112 Jay Richard Kennedy 251 Dick Powell 427 Signe Hasso 226 Maylia 547
1541 Time After Time 289 1979 44 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. Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1540 Time After Time 289 1979 44 Merchant Exchange (465 California Street at Leidesdorff)   Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1539 Time After Time 289 1979 44 One Embarcadero Center (Financial District)   Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1538 Time After Time 289 1979 44 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. Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1537 Time After Time 289 1979 44 SF General Hospital Center (1001 Potrero Avenue, Potrero Hill) SF General Hospital is the only Level I Trauma Center serving San Francisco and northern San Mateo County. Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1536 Time After Time 289 1979 44 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. Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1535 Time After Time 289 1979 44 Old St. Mary's Church (660 California Street at Grant)   Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1534 Time After Time 289 1979 44 100 Block of Union Street (Cow Hollow)   Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1533 Time After Time 289 1979 44 2340 Francisco Street   Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1532 Time After Time 289 1979 44 Broadway at Osgood Street (North Beach)   Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1531 Time After Time 289 1979 44 California Academy of Sciences (Golden Gate Park) Founded in 1853, 3 years after California joined the United States, the Academy was originally named the California Academy of Natural Sciences and was the first institution of its kind in the United States. Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1530 Time After Time 289 1979 44 Chestnut & Divisadero Streets (Marina District)   Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1529 Time After Time 289 1979 44 Ghirardelli Square (900 North Point Street, Fisherman's Wharf) In 1893, chocolatier Domingo Ghirardelli bought an entire city block to house the headquarters of Ghirardelli Chocolates. Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1528 Time After Time 289 1979 44 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. Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1527 Time After Time 289 1979 44 Golden Gate Park Golden Gate Park is similar in shape but 20% larger than New York's Central Park. Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1526 Time After Time 289 1979 44 Huntington Park (California & Taylor Streets, Nob Hill) The mansion of Arabella Huntington, widow of railroad magnate Collis P. Huntington, was destroyed in the 1906 earthquake and fire. Mrs. Huntington the donated the land on which the park now stands to the city. Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1525 Time After Time 289 1979 44 Hyatt Regency Hotel (5 Embarcadero Center)   Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1524 Time After Time 289 1979 44 Intersection of California & Grant Streets (Richmond District)   Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1523 Time After Time 289 1979 44 Intersection of Fulton & 6th Streets (Chinatown)   Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1522 Time After Time 289 1979 44 Justin Herman Plaza   Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1521 Time After Time 289 1979 44 Lombard & Broderick Streets (Marina District)   Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1520 Time After Time 289 1979 44 Lombard & Divisadero Streets (Marina District)   Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1519 Time After Time 289 1979 44 Lombard & Fillmore Streets (Marina District)   Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1518 Time After Time 289 1979 44 Lombard & Laguna Streets (Marina District)   Orion Pictures Corp. 166 Columbia Broadcasting System (CBS) 38 Nicholas Meyer 186 Karl Alexander 249 Malcolm McDowell 425 Mary Steenburgen 224 David Warner 546
1517 Thief of Hearts 288 1984 40     Paramount Pictures 4 Paramount Pictures 3 Douglas Day Stewart 236 Douglas Day Stewart 248 Steven Bauer  424 David Caruso 223 Barbara Williams 545
1496 The Times of Harvey Milk 283 1984 40 The Castro From 1910-1920 the Castro was called "Little Scandinavia" because of its high concentration of residents of Scandinavian ancestry. UCLA Film and Television Archive 164 TC Films International 114 Rob Epstein 60 Rob Epstein 244 Harvey Milk 420 Harvey Firestein 219 Anne Kronenberg 544
1486 The Right Stuff 279 1983 65 Financial District   The Ladd Company 163 The Ladd Company 113 Philip Kaufman 111 Philip Kaufman 240 Sam Shepard 417 Scott Glenn 215 Ed Harris 543
1485 The Right Stuff 279 1983 65 City Hall The dome of SF's City Hall is almost a foot taller than that of the US Capitol Building. In 1954, Joe DiMaggio and Marilyn Monroe married at the Beaux Arts-style building. The Ladd Company 163 The Ladd Company 113 Philip Kaufman 111 Philip Kaufman 240 Sam Shepard 417 Scott Glenn 215 Ed Harris 543
1484 The Right Stuff 279 1983 65 Cow Palace Supposedly, the Cow Palace's name derives from a newspaper editorial in which the writer wonders whether the soon-to-be-built structure for livestock was a "palace for cows". The Ladd Company 163 The Ladd Company 113 Philip Kaufman 111 Philip Kaufman 240 Sam Shepard 417 Scott Glenn 215 Ed Harris 543
1483 The Right Stuff 279 1983 65 American Can Company (Between Illinois & Kentucky, 20th and 22nd Streets)   The Ladd Company 163 The Ladd Company 113 Philip Kaufman 111 Philip Kaufman 240 Sam Shepard 417 Scott Glenn 215 Ed Harris 543
1502 The Towering Inferno 278 1974 49 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. Irwin Allen Productions 162 Twentieth Century - Fox 112 John Guillermin 228 Stirling Silliphant 222 Steve McQueen 273 Paul Newman 214 William Holden 542
1501 The Towering Inferno 278 1974 49 Firestation #38 (California & Laguna)   Irwin Allen Productions 162 Twentieth Century - Fox 112 John Guillermin 228 Stirling Silliphant 222 Steve McQueen 273 Paul Newman 214 William Holden 542
1500 The Towering Inferno 278 1974 49 Grace Cathedral Episcopal Church (1100 California Street) Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. Irwin Allen Productions 162 Twentieth Century - Fox 112 John Guillermin 228 Stirling Silliphant 222 Steve McQueen 273 Paul Newman 214 William Holden 542
1499 The Towering Inferno 278 1974 49 Hyatt Regency Hotel (5 Embarcadero Center, Financial District)   Irwin Allen Productions 162 Twentieth Century - Fox 112 John Guillermin 228 Stirling Silliphant 222 Steve McQueen 273 Paul Newman 214 William Holden 542
1498 The Towering Inferno 278 1974 49 San Francisco Fire Station 38 (2150 California Street, Pacific Heights)   Irwin Allen Productions 162 Twentieth Century - Fox 112 John Guillermin 228 Stirling Silliphant 222 Steve McQueen 273 Paul Newman 214 William Holden 542
1497 The Towering Inferno 278 1974 49 Bank of America Building (555 California Street, Financial District) 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. Irwin Allen Productions 162 Twentieth Century - Fox 112 John Guillermin 228 Stirling Silliphant 222 Steve McQueen 273 Paul Newman 214 William Holden 542
1481 The Towering Inferno 278 1974 49 2898 Vallejo Street   Irwin Allen Productions 162 Twentieth Century - Fox 112 John Guillermin 228 Stirling Silliphant 222 Steve McQueen 273 Paul Newman 214 William Holden 542
1445 The Maltese Falcon 267 1941 63 Burritt Alley (Off Bush Street, between Powell and Stockton Streets)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 John Huston 220 John Huston 231 Humphrey Bogart 289 Mary Astor 204 Gladys George 541
1444 The Maltese Falcon 267 1941 63 Ferry Building Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. Warner Bros. Pictures 38 Warner Bros. Pictures 6 John Huston 220 John Huston 231 Humphrey Bogart 289 Mary Astor 204 Gladys George 541
1443 The Maltese Falcon 267 1941 63 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. Warner Bros. Pictures 38 Warner Bros. Pictures 6 John Huston 220 John Huston 231 Humphrey Bogart 289 Mary Astor 204 Gladys George 541
1442 The Love Bug 266 1968 31 100 Block of Lombard Street Lombard Street is not actually the most crooked in SF. That honor goes to Potrero Hill's Vermont Street between 22nd and 23rd. Walt Disney Productions 82 Buena Vista Distribution 58 Robert Stevenson 112 Bill Walsh 111 Dean Jones 410 Michele Lee 203 David Tomlinson 540
1441 The Love Bug 266 1968 31 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. Walt Disney Productions 82 Buena Vista Distribution 58 Robert Stevenson 112 Bill Walsh 111 Dean Jones 410 Michele Lee 203 David Tomlinson 540
1440 The Lineup 265 1958 72 2090 Jackson Street   Pajemer Productions 158 Columbia Pictures 4 Don Siegel 71 Stirling Silliphant 222 Eli Wallach 409 Robert Keith 202 Richard Jaeckel 539
1439 The Lineup 265 1958 72 Mark Hopkins Intercontinental Hotel (1 Nob Hill Circle, Nob Hill) The Top of the Mark lounge and restaurant at the top of the hotel was formerly a penthouse suite. Pajemer Productions 158 Columbia Pictures 4 Don Siegel 71 Stirling Silliphant 222 Eli Wallach 409 Robert Keith 202 Richard Jaeckel 539
1438 The Lineup 265 1958 72 Pier 41   Pajemer Productions 158 Columbia Pictures 4 Don Siegel 71 Stirling Silliphant 222 Eli Wallach 409 Robert Keith 202 Richard Jaeckel 539
1437 The Lineup 265 1958 72 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. Pajemer Productions 158 Columbia Pictures 4 Don Siegel 71 Stirling Silliphant 222 Eli Wallach 409 Robert Keith 202 Richard Jaeckel 539
1436 The Lineup 265 1958 72 Sutro Baths (Point Lobos Avenue)   Pajemer Productions 158 Columbia Pictures 4 Don Siegel 71 Stirling Silliphant 222 Eli Wallach 409 Robert Keith 202 Richard Jaeckel 539
1435 The Lineup 265 1958 72 The Embarcadero   Pajemer Productions 158 Columbia Pictures 4 Don Siegel 71 Stirling Silliphant 222 Eli Wallach 409 Robert Keith 202 Richard Jaeckel 539
1434 The Lineup 265 1958 72 War Memorial Opera House (401 Van Ness Avenue) In 1945 the United Nations had its first conference at The War Memorial Opera House. Pajemer Productions 158 Columbia Pictures 4 Don Siegel 71 Stirling Silliphant 222 Eli Wallach 409 Robert Keith 202 Richard Jaeckel 539
1433 The Laughing Policeman 264 1973 16     Twentieth Century Fox Film Corporation 13 American Broadcasting Company (ABC) 51 Stuart Rosenberg 219 Thomas Rickman 230 Walter Matthau 408 Bruce Dern 70 Louis Gossett Jr. 538
1432 The Lady from Shanghai 263 1947 41 Former Hall of Justice (750 Kearny Street at Washington)   Columbia Pictures Corp. 93 Columbia Pictures 4 Orson Welles 218 Orson Welles 229 Rita Hayworth 354 Orson Welles 201 Everett Sloane 537
1431 The Lady from Shanghai 263 1947 41 Golden Gate Park The Playland amusement park where "Hall of Mirrors" sequence at the end of the movie was filmed has since been destroyed. However, relics from the park are now housed at the nearby Cliff House. Columbia Pictures Corp. 93 Columbia Pictures 4 Orson Welles 218 Orson Welles 229 Rita Hayworth 354 Orson Welles 201 Everett Sloane 537
1430 The Lady from Shanghai 263 1947 41 Mandarin Theatre (1021 Grant Avenue) The Mandarin Theatre was renamed the Sun Sing Theatre in 1949. It closed 1986. Columbia Pictures Corp. 93 Columbia Pictures 4 Orson Welles 218 Orson Welles 229 Rita Hayworth 354 Orson Welles 201 Everett Sloane 537
1429 The Lady from Shanghai 263 1947 41 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. Columbia Pictures Corp. 93 Columbia Pictures 4 Orson Welles 218 Orson Welles 229 Rita Hayworth 354 Orson Welles 201 Everett Sloane 537
1428 The Jazz Singer 262 1927 71 Coffee Dan's (O'Farrell Street at Powell)   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Alan Crosland 217 Alfred A. Cohn 228 Al Jolson 407 May McAvoy 200 Warner Oland 536
1427 The Internship 261 2013 27 Players Arcade at Pier 39   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Shawn Levy 216 Vince Vaughn 227 Vince Vaughn 406 Owen Wilson 199 Rose Byrne 535
1426 The Internship 261 2013 27 Epic Roasthouse   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Shawn Levy 216 Vince Vaughn 227 Vince Vaughn 406 Owen Wilson 199 Rose Byrne 535
1425 The Internship 261 2013 27 Montgomery and Union St.   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Shawn Levy 216 Vince Vaughn 227 Vince Vaughn 406 Owen Wilson 199 Rose Byrne 535
1424 The Internship 261 2013 27 Grant Ave from Sacramento to Clay   Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corporation 12 Shawn Levy 216 Vince Vaughn 227 Vince Vaughn 406 Owen Wilson 199 Rose Byrne 535
1423 The House on Telegraph Hill 260 1951 70 1227 Montgomery Street   Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Robert Wise 215 Elick Moll 226 Richard Basehart 405 Valentina Cortese 198 William Lundigan 534
1422 The House on Telegraph Hill 260 1951 70 Coit Tower The Tower was funded by a gift bequeathed by Lillie Hitchcock Coit, a socialite who reportedly liked to chase fires. Though the tower resembles a firehose nozzle, it was not designed this way. Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Robert Wise 215 Elick Moll 226 Richard Basehart 405 Valentina Cortese 198 William Lundigan 534
1421 The House on Telegraph Hill 260 1951 70 Market Street   Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Robert Wise 215 Elick Moll 226 Richard Basehart 405 Valentina Cortese 198 William Lundigan 534
1420 The House on Telegraph Hill 260 1951 70 Telegraph Hill Largely untouched by the 1906 earthquake, Telegraph Hill has the most pre-1870 buildings in the city. Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Robert Wise 215 Elick Moll 226 Richard Basehart 405 Valentina Cortese 198 William Lundigan 534
1419 The Graduate 259 1967 53 Bay Bridge Before opening in 1936, the bridge was blessed by Cardinal Secretary of State Eugenio Pacelli, who later became Pope Pius XII. Embassy Pictures Corporation 157 Embassy Pictures Corporation 111 Mike Nichols 214 Calder Willingham 225 Anne Bancroft 404 Dustin Hoffman 197 Katharine Ross 533
1418 The Graduate 259 1967 53 San Francisco Zoo (2701 Sloat Blvd.)   Embassy Pictures Corporation 157 Embassy Pictures Corporation 111 Mike Nichols 214 Calder Willingham 225 Anne Bancroft 404 Dustin Hoffman 197 Katharine Ross 533
1417 The Game 258 1997 8 1 Bush Street   Polygram Filmed Entertainment 156 Polygram Filmed Entertainment 110 David Fincher 213 John Brancato 224 Michael Douglas 245 Sean Penn 40 Deborah Kara Unger 532
1416 The Game 258 1997 8 301 Howard Street   Polygram Filmed Entertainment 156 Polygram Filmed Entertainment 110 David Fincher 213 John Brancato 224 Michael Douglas 245 Sean Penn 40 Deborah Kara Unger 532
1415 The Game 258 1997 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. Polygram Filmed Entertainment 156 Polygram Filmed Entertainment 110 David Fincher 213 John Brancato 224 Michael Douglas 245 Sean Penn 40 Deborah Kara Unger 532
1414 The Game 258 1997 8 Bay Bridge Before opening in 1936, the bridge was blessed by Cardinal Secretary of State Eugenio Pacelli, who later became Pope Pius XII. Polygram Filmed Entertainment 156 Polygram Filmed Entertainment 110 David Fincher 213 John Brancato 224 Michael Douglas 245 Sean Penn 40 Deborah Kara Unger 532
1413 The Game 258 1997 8 City Club (155 Sansome Street)   Polygram Filmed Entertainment 156 Polygram Filmed Entertainment 110 David Fincher 213 John Brancato 224 Michael Douglas 245 Sean Penn 40 Deborah Kara Unger 532
1412 The Game 258 1997 8 Harrison Street (The Embarcadero)   Polygram Filmed Entertainment 156 Polygram Filmed Entertainment 110 David Fincher 213 John Brancato 224 Michael Douglas 245 Sean Penn 40 Deborah Kara Unger 532
1411 The Game 258 1997 8 Mason & California Streets (Nob Hill)   Polygram Filmed Entertainment 156 Polygram Filmed Entertainment 110 David Fincher 213 John Brancato 224 Michael Douglas 245 Sean Penn 40 Deborah Kara Unger 532
1410 The Game 258 1997 8 Merchant Exchange Building   Polygram Filmed Entertainment 156 Polygram Filmed Entertainment 110 David Fincher 213 John Brancato 224 Michael Douglas 245 Sean Penn 40 Deborah Kara Unger 532
1409 The Game 258 1997 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. Polygram Filmed Entertainment 156 Polygram Filmed Entertainment 110 David Fincher 213 John Brancato 224 Michael Douglas 245 Sean Penn 40 Deborah Kara Unger 532
1408 The Game 258 1997 8 Ritz-Carlton Hotel (600 Stockton Street)   Polygram Filmed Entertainment 156 Polygram Filmed Entertainment 110 David Fincher 213 John Brancato 224 Michael Douglas 245 Sean Penn 40 Deborah Kara Unger 532

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Film_Locations_in_San_Francisco" (
"Title" INTEGER,
  "Release Year" INTEGER,
  "Locations" TEXT,
  "Fun Facts" REAL,
  "Production Company" INTEGER,
  "Distributor" INTEGER,
  "Director" INTEGER,
  "Writer" INTEGER,
  "Actor 1" INTEGER,
  "Actor 2" INTEGER,
  "Actor 3" INTEGER
,
FOREIGN KEY ("Title") REFERENCES [Title](id),
    FOREIGN KEY ("Director") REFERENCES [Director](id),
    FOREIGN KEY ("Actor 2") REFERENCES [Actors](id),
    FOREIGN KEY ("Actor 1") REFERENCES [Actors](id),
    FOREIGN KEY ("Writer") REFERENCES [Writer](id),
    FOREIGN KEY ("Release Year") REFERENCES [Release Year](id),
    FOREIGN KEY ("Actor 3") REFERENCES [Actors](id),
    FOREIGN KEY ("Production Company") REFERENCES [Production Company](id),
    FOREIGN KEY ("Distributor") REFERENCES [Distributor](id));
CREATE INDEX ["Film_Locations_in_San_Francisco_Title"] ON [Film_Locations_in_San_Francisco]("Title");
CREATE INDEX ["Film_Locations_in_San_Francisco_Director"] ON [Film_Locations_in_San_Francisco]("Director");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 2"] ON [Film_Locations_in_San_Francisco]("Actor 2");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 1"] ON [Film_Locations_in_San_Francisco]("Actor 1");
CREATE INDEX ["Film_Locations_in_San_Francisco_Writer"] ON [Film_Locations_in_San_Francisco]("Writer");
CREATE INDEX ["Film_Locations_in_San_Francisco_Release Year"] ON [Film_Locations_in_San_Francisco]("Release Year");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 3"] ON [Film_Locations_in_San_Francisco]("Actor 3");
CREATE INDEX ["Film_Locations_in_San_Francisco_Production Company"] ON [Film_Locations_in_San_Francisco]("Production Company");
CREATE INDEX ["Film_Locations_in_San_Francisco_Distributor"] ON [Film_Locations_in_San_Francisco]("Distributor");
Powered by Datasette · Query took 141.834ms · Data source: data.sfgov.org