Film_Locations_in_San_Francisco

Data source: data.sfgov.org

1,622 rows sorted by Release Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid Title Release Year ▲ Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
648 648 High Anxiety 122 1977 55 Hyatt Regency Hotel (5 Embarcadero Center)   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Mel Brooks 114 Mel Brooks 113 Mel Brooks 323 Madeline Kahn 98 Cloris Leachman 486
649 649 High Anxiety 122 1977 55 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. Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Mel Brooks 114 Mel Brooks 113 Mel Brooks 323 Madeline Kahn 98 Cloris Leachman 486
650 650 High Anxiety 122 1977 55 Conservatory of Flowers, Golden Gate Park The Conservatory, unveiled in 1879, is the oldest public conservatory in the Western Hemisphere. Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Mel Brooks 114 Mel Brooks 113 Mel Brooks 323 Madeline Kahn 98 Cloris Leachman 486
640 640 Hello Frisco, Hello 118 1943 54     Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Bruce Humberstone 110 Robert Ellis 109 Alice Faye 14 John Payne 94 Jack Oakie 485
623 623 Guess Who's Coming to Dinner 111 1967 53 Sutter Street between Powell and Mason   Columbia Pictures Corporation 5 Columbia Pictures 4 Stanley Kramer 103 William Rose 103 Spencer Tracy 315 Sidney Poitier 90 Katharine Hepburn 484
624 624 Guess Who's Coming to Dinner 111 1967 53 San Francisco International Airport SFO has a museum dedicated to aviation history. Columbia Pictures Corporation 5 Columbia Pictures 4 Stanley Kramer 103 William Rose 103 Spencer Tracy 315 Sidney Poitier 90 Katharine Hepburn 484
625 625 Guess Who's Coming to Dinner 111 1967 53 Mel's Drive-In (Corner South Van Ness & Mission St.) This restaurant location was demolished; however another Mel's was reopened in 1986 on 3355 Geary Blvd. Columbia Pictures Corporation 5 Columbia Pictures 4 Stanley Kramer 103 William Rose 103 Spencer Tracy 315 Sidney Poitier 90 Katharine Hepburn 484
626 626 Guess Who's Coming to Dinner 111 1967 53 634 Raycliff Terrace   Columbia Pictures Corporation 5 Columbia Pictures 4 Stanley Kramer 103 William Rose 103 Spencer Tracy 315 Sidney Poitier 90 Katharine Hepburn 484
1032 1032 Point Blank 194 1967 53 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. Metro-Goldwyn Mayer 8 Metro-Goldwyn Mayer 10 John Boorman 163 Alexander Jacobs 167 Lee Marvin 363 Angie Dickinson 149 Keenan Wynn 509
1033 1033 Point Blank 194 1967 53 Alcatraz Island Alcatraz Island was a military fort before it became a prison. Metro-Goldwyn Mayer 8 Metro-Goldwyn Mayer 10 John Boorman 163 Alexander Jacobs 167 Lee Marvin 363 Angie Dickinson 149 Keenan Wynn 509
1418 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
1419 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
617 617 Greed 109 1924 52 Cliff House (1090 Point Lobos Avenue) In 1887, the Cliff House was severely damaged when the schooner Parallel, abandoned and loaded with dynamite, ran aground on the rocks below. Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Eric von Stroheim  101 Eric von Stroheim  101 Zasu Pitts 313 Gibson Gowland 88 Jean Hersholt 483
618 618 Greed 109 1924 52 Bush and Sutter Streets   Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Eric von Stroheim  101 Eric von Stroheim  101 Zasu Pitts 313 Gibson Gowland 88 Jean Hersholt 483
619 619 Greed 109 1924 52 Hayes Street at Laguna   Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Eric von Stroheim  101 Eric von Stroheim  101 Zasu Pitts 313 Gibson Gowland 88 Jean Hersholt 483
616 616 Good NeighborSam 108 1964 51 Various locations in San Francisco during driving scene   Columbia Pictures Corporation 5 Columbia Pictures 4 David Swift 100 James Fritzell 100 Jack Lemmon 292 Romy Schneider 87 Dorothy Provine 482
880 880 Marnie 161 1964 51 On Board the SS President Cleveland, docked at Pier 50   Universal Pictures 15 Universal Pictures 41 Alfred Hitchcock 81 Jay Presson Allen 140 Tippi Hedren 116 Sean Connery 107 Martin Gabel 498
557 557 Gentleman Jim 101 1942 50 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. Warner Bros. Pictures 38 Warner Bros. Pictures 6 Raoul Walsh 92 Vincent Lawrence 93 Errol Flynn 307 Alexis Smith 81 Jack Carson 479
544 544 Freebie and the Bean 100 1974 49 Alco Plaza   Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
545 545 Freebie and the Bean 100 1974 49 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". Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
546 546 Freebie and the Bean 100 1974 49 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. Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
547 547 Freebie and the Bean 100 1974 49 Stockton Tunnel (Stockton Street at Sutter Street) Opened in 1914, the Stockton Tunnel was built to provide North Beach residents access to the thriving downtown area. Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
548 548 Freebie and the Bean 100 1974 49 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. Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
549 549 Freebie and the Bean 100 1974 49 Potrero Hill The most crooked street in San Francisco is actually Potrero Hill's Vermont Street between 20th St & 22nd St. Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
550 550 Freebie and the Bean 100 1974 49 Nob Hill Railroad tycoons like Leland Stanford (founder of Stanford University) lived in Nob Hill at the turn of the 20th Century. The 1906 earthquake completely destroyed Nob Hill, with the exception of the wall that surrounded the mansions of Stanford and his neighbor Mark Hopkins. Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
551 551 Freebie and the Bean 100 1974 49 Hyatt Regency Hotel (5 Embarcadero Center)   Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
552 552 Freebie and the Bean 100 1974 49 Folsom Street (SOMA)   Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
553 553 Freebie and the Bean 100 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. Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
554 554 Freebie and the Bean 100 1974 49 Embarcadero Freeway   Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
555 555 Freebie and the Bean 100 1974 49 Candlestick Park (602 Jamestown Ave.) Then Vice President Richard Nixon threw out the first pitch when Candlestick opened in 1960. On August 29, 1966, The Beatles played their last concert for paying fans at Candlestick Park. Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
556 556 Freebie and the Bean 100 1974 49 Broadway and Columbus Avenue (North Beach)   Warner Bros. Pictures 38 American Broadcasting Company (ABC) 51 Richard Rush 91 Robert Kaufman 92 Alan Arkin 282 James Caan 80 Loretta Swit 478
642 642 Herbie Rides Again 120 1974 49 Castagnola's Restaurant (Fisherman's Wharf)   Walt Disney Productions 82 Buena Vista Distribution 58 Robert Stevenson 112 Bill Walsh 111 Helen Hayes 321 Ken Berry 96 Stefanie Powers 473
643 643 Herbie Rides Again 120 1974 49 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. Walt Disney Productions 82 Buena Vista Distribution 58 Robert Stevenson 112 Bill Walsh 111 Helen Hayes 321 Ken Berry 96 Stefanie Powers 473
644 644 Herbie Rides Again 120 1974 49 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 Helen Hayes 321 Ken Berry 96 Stefanie Powers 473
1334 1334 The Conversation 249 1974 49 American Roofing Co. Building (297 Kansas Street, Potrero Hill)   American Zoetrope 92 Paramount Pictures 3 Francis Ford Coppola 127 Francis Ford Coppola 216 Gene Hackman 178 John Cazale 191 Allen Garfield 530
1335 1335 The Conversation 249 1974 49 Alta Plaza Park (Steiner Street) The park was originally a rock quarry and served as a campground for many survivors of the 1906 earthquake. The site was converted to a park in 1910. American Zoetrope 92 Paramount Pictures 3 Francis Ford Coppola 127 Francis Ford Coppola 216 Gene Hackman 178 John Cazale 191 Allen Garfield 530
1336 1336 The Conversation 249 1974 49 Alcoa Building (1 Maritime Plaza) A partially-above ground parking structure near the building made it necessary for architects to make the Alcoa Building's diagonal bracing visible, instead of placing it inside and drastically reducing the amount usable interior space. American Zoetrope 92 Paramount Pictures 3 Francis Ford Coppola 127 Francis Ford Coppola 216 Gene Hackman 178 John Cazale 191 Allen Garfield 530
1337 1337 The Conversation 249 1974 49 Alamo Square (Hayes Valley)   American Zoetrope 92 Paramount Pictures 3 Francis Ford Coppola 127 Francis Ford Coppola 216 Gene Hackman 178 John Cazale 191 Allen Garfield 530
1338 1338 The Conversation 249 1974 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. American Zoetrope 92 Paramount Pictures 3 Francis Ford Coppola 127 Francis Ford Coppola 216 Gene Hackman 178 John Cazale 191 Allen Garfield 530
1339 1339 The Conversation 249 1974 49 Union Square During the Civil War, pro-Union rallies were held in the Square, and thus the area was called "Union Square". American Zoetrope 92 Paramount Pictures 3 Francis Ford Coppola 127 Francis Ford Coppola 216 Gene Hackman 178 John Cazale 191 Allen Garfield 530
1340 1340 The Conversation 249 1974 49 Saks Fifth Avenue (384 Post Street, Union Square)   American Zoetrope 92 Paramount Pictures 3 Francis Ford Coppola 127 Francis Ford Coppola 216 Gene Hackman 178 John Cazale 191 Allen Garfield 530
1341 1341 The Conversation 249 1974 49 One Embarcadero Center (Financial District)   American Zoetrope 92 Paramount Pictures 3 Francis Ford Coppola 127 Francis Ford Coppola 216 Gene Hackman 178 John Cazale 191 Allen Garfield 530
1342 1342 The Conversation 249 1974 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 American Zoetrope 92 Paramount Pictures 3 Francis Ford Coppola 127 Francis Ford Coppola 216 Gene Hackman 178 John Cazale 191 Allen Garfield 530
1343 1343 The Conversation 249 1974 49 Financial District   American Zoetrope 92 Paramount Pictures 3 Francis Ford Coppola 127 Francis Ford Coppola 216 Gene Hackman 178 John Cazale 191 Allen Garfield 530
1344 1344 The Conversation 249 1974 49 Cathedral Hill Hotel (1101 Van Ness Avenue, Civic Center)   American Zoetrope 92 Paramount Pictures 3 Francis Ford Coppola 127 Francis Ford Coppola 216 Gene Hackman 178 John Cazale 191 Allen Garfield 530
1481 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
1497 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
1498 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
1499 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
1500 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
1501 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
1502 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
521 521 Forrest Gump 98 1994 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. Paramount Pictures 4 Paramount Pictures 3 Robert Zemeckis 89 Eric Roth 90 Tom Hanks 305 Robin Wright 78  
563 563 Getting Even with Dad 103 1994 48 California & Grant Streets   Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Howard Dutch 94 Tom S. Parker 95 Macaulay Culkin 308 Ted Danson 83  
564 564 Getting Even with Dad 103 1994 48 War Memorial Building (401 Van Ness Avenue)   Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Howard Deutch 95 Tom S. Parker 95 Macaulay Culkin 308 Ted Danson 83  
565 565 Getting Even with Dad 103 1994 48 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. Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Howard Deutch 95 Tom S. Parker 95 Macaulay Culkin 308 Ted Danson 83  
566 566 Getting Even with Dad 103 1994 48 140 Maiden Lane   Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Howard Deutch 95 Tom S. Parker 95 Macaulay Culkin 308 Ted Danson 83  
567 567 Getting Even with Dad 103 1994 48 St. Peter & Paul's Church (666 Filbert Street, Washington Square) Though Marilyn Monroe and Joe DiMaggio were not allowed to be married at the Church (DiMaggio had married his first wife at the Church but was divorced), the couple returned to the steps of the Church for photos, following their City Hall nuptials. Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Howard Deutch 95 Tom S. Parker 95 Macaulay Culkin 308 Ted Danson 83  
568 568 Getting Even with Dad 103 1994 48 Neiman Marcus (150 Stockton Street, Union Square) The City of Paris department store previously occupied the space that now houses Neiman Marcus. City of Paris' original rotunda and glass dome were incorporated into Neiman Marcus' design. Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Howard Deutch 95 Tom S. Parker 95 Macaulay Culkin 308 Ted Danson 83  
569 569 Getting Even with Dad 103 1994 48 Mason Street at Jackson   Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Howard Deutch 95 Tom S. Parker 95 Macaulay Culkin 308 Ted Danson 83  
570 570 Getting Even with Dad 103 1994 48 M.H. de Young Memorial Museum (Golden Gate Park)   Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Howard Deutch 95 Tom S. Parker 95 Macaulay Culkin 308 Ted Danson 83  
571 571 Getting Even with Dad 103 1994 48 Embarcadero Street Station- BART   Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Howard Deutch 95 Tom S. Parker 95 Macaulay Culkin 308 Ted Danson 83  
572 572 Getting Even with Dad 103 1994 48 Candlestick Park (602 Jamestown Ave.) Then Vice President Richard Nixon threw out the first pitch when Candlestick opened in 1960. On August 29, 1966, The Beatles played their last concert for paying fans at Candlestick Park. Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Howard Deutch 95 Tom S. Parker 95 Macaulay Culkin 308 Ted Danson 83  
611 611 Golden Gate 107 1994 48 Ross Alley (Chinatown) Ross Alley is the oldest alley in San Francisco. American Playhouse Theatrical Films 75 The Samuel Goldwyn Company 54 John Madden 99 David Henry Hwang 99 Matt Dillon 312 Joan Chen 86  
612 612 Golden Gate 107 1994 48 University of California Hastings College of the Law   Metro-Goldwyn-Mayer (MGM) 71 Metro-Goldwyn-Mayer (MGM) 52 Howard Deutch 95 David Henry Hwang 99 Matt Dillon 312 Joan Chen 86  
613 613 Golden Gate 107 1994 48 Bush Street (between Grant & Kearny Streets)   American Playhouse Theatrical Films 75 The Samuel Goldwyn Company 54 John Madden 99 David Henry Hwang 99 Matt Dillon 312 Joan Chen 86  
614 614 Golden Gate 107 1994 48 Buena Vista Park (Haight Street at Buena Vista) Established in 1867, Buena Vista Park is the oldest official park in San Francisco. American Playhouse Theatrical Films 75 The Samuel Goldwyn Company 54 John Madden 99 David Henry Hwang 99 Matt Dillon 312 Joan Chen 86  
615 615 Golden Gate 107 1994 48 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. American Playhouse Theatrical Films 75 The Samuel Goldwyn Company 54 John Madden 99 David Henry Hwang 99 Matt Dillon 312 Joan Chen 86  
680 680 Interview With The Vampire 133 1994 48 Ferry Building Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. Geffen Pictures 88 Geffen Pictures 61 Neil Jordan 124 Anne Rice 123 Brad Pitt 329 Christian Slater 109 Tom Cruise 490
681 681 Interview With The Vampire 133 1994 48 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. Geffen Pictures 88 Geffen Pictures 61 Neil Jordan 124 Anne Rice 123 Brad Pitt 329 Christian Slater 109 Tom Cruise 490
682 682 Interview With The Vampire 133 1994 48 100 Market Street at 6th Street   Geffen Pictures 88 Geffen Pictures 61 Neil Jordan 124 Anne Rice 123 Brad Pitt 329 Christian Slater 109 Tom Cruise 490
683 683 Interview With The Vampire 133 1994 48 6th Street On-ramp to Highway 280   Geffen Pictures 88 Geffen Pictures 61 Neil Jordan 124 Anne Rice 123 Brad Pitt 329 Christian Slater 109 Tom Cruise 490
723 723 Junior 142 1994 48 2552 Hyde Street   Northern Lights Entertainment 67 Universal Pictures 41 Ivan Reitman 84 Kevin Wade 131 Arnold Schwarzenegger 334 Danny DeVito 117 Emma Thompson 494
724 724 Junior 142 1994 48 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. Northern Lights Entertainment 67 Universal Pictures 41 Ivan Reitman 84 Kevin Wade 131 Arnold Schwarzenegger 334 Danny DeVito 117 Emma Thompson 494
725 725 Junior 142 1994 48 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. Northern Lights Entertainment 67 Universal Pictures 41 Ivan Reitman 84 Kevin Wade 131 Arnold Schwarzenegger 334 Danny DeVito 117 Emma Thompson 494
726 726 Junior 142 1994 48 Hyatt Fisherman's Wharf (555 Northpoint Street)   Northern Lights Entertainment 67 Universal Pictures 41 Ivan Reitman 84 Kevin Wade 131 Arnold Schwarzenegger 334 Danny DeVito 117 Emma Thompson 494
727 727 Junior 142 1994 48 Fairmont Hotel (950 Mason Street, Nob Hill)   Northern Lights Entertainment 67 Universal Pictures 41 Ivan Reitman 84 Kevin Wade 131 Arnold Schwarzenegger 334 Danny DeVito 117 Emma Thompson 494
728 728 Junior 142 1994 48 Chinatown Gate Designed in 1970, the Chinatown Gate (aka the Dragon Gate) is based on ceremonial gates found in Chinese villages. Northern Lights Entertainment 67 Universal Pictures 41 Ivan Reitman 84 Kevin Wade 131 Arnold Schwarzenegger 334 Danny DeVito 117 Emma Thompson 494
729 729 Junior 142 1994 48 722 Steiner Street   Northern Lights Entertainment 67 Universal Pictures 41 Ivan Reitman 84 Kevin Wade 131 Arnold Schwarzenegger 334 Danny DeVito 117 Emma Thompson 494
976 976 Nina Takes a Lover 177 1994 48     Alan Jacobs Productions 112 Columbia TriStar Home Video 47 Alan Jacobs 132 Alan Jacobs 133 Laura San Giacomo 347 Paul Rhys 134  
1590 1590 When a Man Loves a Woman 302 1994 48 Buena Vista Café (2765 Hyde Street)   Touchstone Pictures 104 Buena Vista Pictures 25 Luis Mandoki 246 Ronald Bass 262 Andy Garcia 58 Meg Ryan 46  
1591 1591 When a Man Loves a Woman 302 1994 48 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. Touchstone Pictures 104 Buena Vista Pictures 25 Luis Mandoki 246 Ronald Bass 262 Andy Garcia 58 Meg Ryan 46  
1592 1592 When a Man Loves a Woman 302 1994 48 Spring Valley School (1451 Jackson Street)   Touchstone Pictures 104 Buena Vista Pictures 25 Luis Mandoki 246 Ronald Bass 262 Andy Garcia 58 Meg Ryan 46  
1593 1593 When a Man Loves a Woman 302 1994 48 International Studies Academy (993 Vermont Street, Potrero Hill)   Touchstone Pictures 104 Buena Vista Pictures 25 Luis Mandoki 246 Ronald Bass 262 Andy Garcia 58 Meg Ryan 46  
1594 1594 When a Man Loves a Woman 302 1994 48 Grant Street at Pacific Avenue   Touchstone Pictures 104 Buena Vista Pictures 25 Luis Mandoki 246 Ronald Bass 262 Andy Garcia 58 Meg Ryan 46  
1595 1595 When a Man Loves a Woman 302 1994 48 Cybelle's Pizza (1000 Bush Street)   Touchstone Pictures 104 Buena Vista Pictures 25 Luis Mandoki 246 Ronald Bass 262 Andy Garcia 58 Meg Ryan 46  
1596 1596 When a Man Loves a Woman 302 1994 48 766 Vallejo Street at Stockton Street (North Beach)   Touchstone Pictures 104 Buena Vista Pictures 25 Luis Mandoki 246 Ronald Bass 262 Andy Garcia 58 Meg Ryan 46  
1597 1597 When a Man Loves a Woman 302 1994 48 1521 Masonic Avenue at Piedmont Street   Touchstone Pictures 104 Buena Vista Pictures 25 Luis Mandoki 246 Ronald Bass 262 Andy Garcia 58 Meg Ryan 46  
518 518 Flower Drum Song 96 1961 47 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. Fields Productions 69 Universal Pictures 41 Henry Koster 87 Joseph Fields 88 Nancy Kwan 304 James Shigeta 76 Benson Fong 476
519 519 Flower Drum Song 96 1961 47 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. Fields Productions 69 Universal Pictures 41 Henry Koster 87 Joseph Fields 88 Nancy Kwan 304 James Shigeta 76 Benson Fong 476
1030 1030 Pleasure of His Company 193 1961 47 Grace Cathedral Episcopal Church (1100 California Street) Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. Perlsea Company 122 Paramount Pictures 3 George Seaton 162 Samuel A. Taylor 166 Fred Astaire 362 Debbie Reynolds 130 Lilli Palmer 508
1031 1031 Pleasure of His Company 193 1961 47 2700 Vallejo Street (Pacific Heights)   Perlsea Company 122 Parmaount Pictures 76 George Seaton 162 Samuel A. Taylor 166 Fred Astaire 362 Debbie Reynolds 130 Lilli Palmer 508
1270 1270 Susan Slade 234 1961 47 On Board the SS President Cleveland, docked at Pier 50   Warner Bros. Pictures 38 Warner Bros. Pictures 6 Delmer Daves 66 Delmer Daves 204 Troy Donahue 390 Connie Stevens 179 Dorothy McGuire 525
1282 1282 Swingin' Along 237 1961 47 Powell Street   Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 Charles Barton 195 Jameson Brewer 207 Tommy Noonan 393 Barbara Eden 181 Peter Marshall 526
504 504 Fearless 94 1993 46 400 Montgomery Street   Spring Creek Productions 68 Warner Bros. Pictures 6 Peter Weir 85 Rafael Yglesias 86 Jeff Bridges 113 Isabella Rosellini 74 Rosie Perez 475
505 505 Fearless 94 1993 46 Folsom Street & Embarcadero   Spring Creek Productions 68 Warner Bros. Pictures 6 Peter Weir 85 Rafael Yglesias 86 Jeff Bridges 113 Isabella Rosellini 74 Rosie Perez 475
506 506 Fearless 94 1993 46 Varennes Alley between Filbert and Union   Spring Creek Productions 68 Warner Bros. Pictures 6 Peter Weir 85 Rafael Yglesias 86 Jeff Bridges 113 Isabella Rosellini 74 Rosie Perez 475
507 507 Fearless 94 1993 46 St. Peter & Paul's Church (666 Filbert Street, Washington Square) Though Marilyn Monroe and Joe DiMaggio were not allowed to be married at the Church (DiMaggio had married his first wife at the Church but was divorced), the couple returned to the steps of the Church for photos, following their City Hall nuptials. Spring Creek Productions 68 Warner Bros. Pictures 6 Peter Weir 85 Rafael Yglesias 86 Jeff Bridges 113 Isabella Rosellini 74 Rosie Perez 475
508 508 Fearless 94 1993 46 San Francisco General Hospital Medical Center (1001 Potrero Avenue, Potrero Hill) SF General Hospital is the only Level I Trauma Center serving San Francisco and northern San Mateo County. Spring Creek Productions 68 Warner Bros. Pictures 6 Peter Weir 85 Rafael Yglesias 86 Jeff Bridges 113 Isabella Rosellini 74 Rosie Perez 475
509 509 Fearless 94 1993 46 Kohl Building (400 Montgomery Street)   Spring Creek Productions 68 Warner Bros. Pictures 6 Peter Weir 85 Rafael Yglesias 86 Jeff Bridges 113 Isabella Rosellini 74 Rosie Perez 475

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