Film_Locations_in_San_Francisco

Data source: data.sfgov.org

52 rows where Distributor = 25

View and edit SQL

Suggested facets: Title, Release Year, Fun Facts, Production Company, Director, Writer, Actor 1, Actor 2

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
127 Bicentennial Man 33 1999 26 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. 1492 Pictures 29 Buena Vista Pictures 25 Chris Columbus 31 Nicholas Kazan 30 Robin Williams 265    
128 Bicentennial Man 33 1999 26 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. 1492 Pictures 29 Buena Vista Pictures 25 Chris Columbus 31 Nicholas Kazan 30 Robin Williams 265    
129 Bicentennial Man 33 1999 26 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. 1492 Pictures 29 Buena Vista Pictures 25 Chris Columbus 31 Nicholas Kazan 30 Robin Williams 265    
130 Bicentennial Man 33 1999 26 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. 1492 Pictures 29 Buena Vista Pictures 25 Chris Columbus 31 Nicholas Kazan 30 Robin Williams 265    
131 Bicentennial Man 33 1999 26 Grace Cathedral Episcopal Church (1100 California Street) Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. 1492 Pictures 29 Buena Vista Pictures 25 Chris Columbus 31 Nicholas Kazan 30 Robin Williams 265    
520 Flubber 97 1997 8 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. Walt Disney Pictures 70 Buena Vista Pictures 25 Les Mayfield 88 Samuel W. Taylor 89 Robin Williams 265 Marcia Gay Harden 77  
558 George of the Jungle 102 1997 8 755 Vallejo Street   Walt Disney Pictures 70 Buena Vista Pictures 25 Sam Weisman 93 Jay Ward 94 Brendan Fraser 263 Leslie Mann 82  
559 George of the Jungle 102 1997 8 The Tamalpais Building (1201 Greenwich Street at Hyde)   Walt Disney Pictures 70 Buena Vista Pictures 25 Sam Weisman 93 Jay Ward 94 Brendan Fraser 263 Leslie Mann 82  
560 George of the Jungle 102 1997 8 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. Walt Disney Pictures 70 Buena Vista Pictures 25 Sam Weisman 93 Jay Ward 94 Brendan Fraser 263 Leslie Mann 82  
561 George of the Jungle 102 1997 8 First Bank (550 Montgomery Street at Commercial) Called "Stanhope Bank" in the film. Walt Disney Pictures 70 Buena Vista Pictures 25 Sam Weisman 93 Jay Ward 94 Brendan Fraser 263 Leslie Mann 82  
562 George of the Jungle 102 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. Walt Disney Pictures 70 Buena Vista Pictures 25 Sam Weisman 93 Jay Ward 94 Brendan Fraser 263 Leslie Mann 82  
658 Homeward Bound II: Lost in San Francisco 124 1996 43 Pier 39 (Fisherman's Wharf)   Walt Disney Pictures 70 Buena Vista Pictures 25 David R. Ellis 115 Sheila Burnford 115 Michael J. Fox 278 Sally Field 100  
705 Jack 137 1996 43     American Zoetrope 92 Buena Vista Pictures 25 Francis Ford Coppola 127 James DeMonaco 127 Robin Williams 265 Diane Lane 112  
885 Metro 164 1997 8 Bush Street at Jones   Touchstone Pictures 104 Buena Vista Pictures 25 Thomas Carter 140 Randy Feldman 143 Eddie Murphy 3    
1022 Phenomenon 190 1996 43 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. Touchstone Pictures 104 Buena Vista Pictures 25 Jon Turteltaub 159 Gerald Dipego 164 John Travolta 359 Kyra Sedgwick 146  
1029 Playing Mona Lisa 192 2000 25 Conservatory of Flowers (Golden Gate Park) The Conservatory, unveiled in 1879, is the oldest public conservatory in the Western Hemisphere. The Bubble Factory 121 Buena Vista Pictures 25 Matthew Huffman 161 Marni Freedman 165 Alicia Witt 361 Harvey Fierstein 148  
1034 Pretty Woman 195 1990 17     Touchstone Pictures 104 Buena Vista Pictures 25 Garry Marshall 27 J.F. Lawton 168 Richard Gere 264 Julia Roberts 150  
1165 Sister Act 218 1992 22 St. Paul's Church (Church Street, Noe Valley)   Touchstone Pictures 104 Buena Vista Pictures 25 Emile Ardolino 180 Joseph Howard 190 Whoopi Goldberg 274 Maggie Smith 167  
1166 Sister Act 2: Back in the Habit 219 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. Touchstone Pictures 104 Buena Vista Pictures 25 Bill Duke 181 Joseph Howard 190 Whoopi Goldberg 274 Maggie Smith 167  
1167 Sister Act 2: Back in the Habit 219 1993 46 Maritime Museum, Building 201 (Fort Mason)   Touchstone Pictures 104 Buena Vista Pictures 25 Bill Duke 181 Joseph Howard 190 Whoopi Goldberg 274 Maggie Smith 167  
1168 Sister Act 2: Back in the Habit 219 1993 46 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. Touchstone Pictures 104 Buena Vista Pictures 25 Bill Duke 181 Joseph Howard 190 Whoopi Goldberg 274 Maggie Smith 167  
1169 Sister Act 2: Back in the Habit 219 1993 46 CCSF Alemany Campus   Touchstone Pictures 104 Buena Vista Pictures 25 Bill Duke 181 Joseph Howard 190 Whoopi Goldberg 274 Maggie Smith 167  
1170 Sister Act 2: Back in the Habit 219 1993 46 Carnelian Room, Bank of America Building (555 California Street, 53rd Floor) 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. Touchstone Pictures 104 Buena Vista Pictures 25 Bill Duke 181 Joseph Howard 190 Whoopi Goldberg 274 Maggie Smith 167  
1391 The Doctor 253 1991 37     Silver Screen Partners IV 26 Buena Vista Pictures 25 Randa Haines 208 Robert Caswell 220 William Hurt 400 Christine Lahti 194  
1450 The Nightmare Before Christmas 271 1993 46     Touchstone Pictures 104 Buena Vista Pictures 25 Henry Selick 129 Tim Burton 234 Danny Elfman 412 Catherine O'Hara 208  
1452 The Other Sister 273 1999 26 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. Mandeville Films 161 Buena Vista Pictures 25 Garry Marshall 27 Garry Marshall 236 Juliette Lewis 413 Diane Keaton 147  
1453 The Other Sister 273 1999 26 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. Mandeville Films 161 Buena Vista Pictures 25 Garry Marshall 27 Garry Marshall 236 Juliette Lewis 413 Diane Keaton 147  
1454 The Other Sister 273 1999 26 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. Mandeville Films 161 Buena Vista Pictures 25 Garry Marshall 27 Garry Marshall 236 Juliette Lewis 413 Diane Keaton 147  
1455 The Parent Trap 274 1998 18 Administration Building (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. Walt Disney Pictures 70 Buena Vista Pictures 25 Nancy Meyers 225 Nancy Meyers 237 Lindsay Lohan 414 Dennis Quaid 210  
1471 The Princess Diaries 276 2001 33 724 Brazil Avenue   Walt Disney Pictures 70 Buena Vista Pictures 25 Garry Marshall 27 Gina Wendkos 239 Julie Andrews 415 Anne Hathway 212  
1472 The Princess Diaries 276 2001 33 Fisherman's Wharf Supposedly, Mikhail S. Gorbachev has said that his favorite part of visiting America was touring Fisherman's Wharf. Walt Disney Pictures 70 Buena Vista Pictures 25 Garry Marshall 27 Gina Wendkos 239 Julie Andrews 415 Anne Hathway 212  
1473 The Princess Diaries 276 2001 33 Firestation #3 (Brazil Avenue and Athens Street)   Walt Disney Pictures 70 Buena Vista Pictures 25 Garry Marshall 27 Gina Wendkos 239 Julie Andrews 415 Anne Hathway 212  
1474 The Princess Diaries 276 2001 33 Cliff House (1090 Point Lobos Avenue) The Musee Mechanique, which Julie Andrews' character visits in the movie, was at the time housed under the Cliff House. Walt Disney Pictures 70 Buena Vista Pictures 25 Garry Marshall 27 Gina Wendkos 239 Julie Andrews 415 Anne Hathway 212  
1475 The Princess Diaries 276 2001 33 Broadway Tunnel (Broadway between Powell and Larkin)   Walt Disney Pictures 70 Buena Vista Pictures 25 Garry Marshall 27 Gina Wendkos 239 Julie Andrews 415 Anne Hathway 212  
1476 The Princess Diaries 276 2001 33 Baker Beach   Walt Disney Pictures 70 Buena Vista Pictures 25 Garry Marshall 27 Gina Wendkos 239 Julie Andrews 415 Anne Hathway 212  
1477 The Princess Diaries 276 2001 33 2601 Lyon Street   Walt Disney Pictures 70 Buena Vista Pictures 25 Garry Marshall 27 Gina Wendkos 239 Julie Andrews 415 Anne Hathway 212  
1487 The Rock 280 1996 43 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. Hollywood Pictures 95 Buena Vista Pictures 25 Michael Bay 229 David Weisberg 241 Sean Connery 107 Nicolas Cage 216  
1488 The Rock 280 1996 43 The San Francisco Bay   Hollywood Pictures 95 Buena Vista Pictures 25 Michael Bay 229 David Weisberg 241 Sean Connery 107 Nicolas Cage 216  
1489 The Rock 280 1996 43 New Russian Hill Market (1198 Pacific Avenue at Jones)   Hollywood Pictures 95 Buena Vista Pictures 25 Michael Bay 229 David Weisberg 241 Sean Connery 107 Nicolas Cage 216  
1490 The Rock 280 1996 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. Hollywood Pictures 95 Buena Vista Pictures 25 Michael Bay 229 David Weisberg 241 Sean Connery 107 Nicolas Cage 216  
1491 The Rock 280 1996 43 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. Hollywood Pictures 95 Buena Vista Pictures 25 Michael Bay 229 David Weisberg 241 Sean Connery 107 Nicolas Cage 216  
1492 The Rock 280 1996 43 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. Hollywood Pictures 95 Buena Vista Pictures 25 Michael Bay 229 David Weisberg 241 Sean Connery 107 Nicolas Cage 216  
1493 The Rock 280 1996 43 Alcatraz Island Alcatraz Island was a military fort before it became a prison. Hollywood Pictures 95 Buena Vista Pictures 25 Michael Bay 229 David Weisberg 241 Sean Connery 107 Nicolas Cage 216  
1557 Under the Tuscan Sun 295 2003 38 Mecca Restaurant (2029 Market Street)   Touchstone Pictures 104 Buena Vista Pictures 25 Audrey Wells 240 Audrey Wells 255 Diane Lane 112 Sandra Oh 229  
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 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 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 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 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 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 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 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  

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