Film_Locations_in_San_Francisco

Data source: data.sfgov.org

33 rows where Release Year = 26

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Title, Locations, Fun Facts, Production Company, Distributor, 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 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 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 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 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 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    
449 449 Edtv 86 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. Imagine Entertainment 64 MCA / Universal Pictures 49 Ron Howard 78 Lowell Ganz 79 Matthew McConaughey 220 Jenna Elfman 67  
450 450 Edtv 86 1999 26 Moose's Restaurant (1652 Stockton)   Imagine Entertainment 64 MCA / Universal Pictures 49 Ron Howard 78 Lowell Ganz 79 Matthew McConaughey 220 Jenna Elfman 67  
451 451 Edtv 86 1999 26 Mario's Bohemian Cigar Store (Washington Square)   Imagine Entertainment 64 MCA / Universal Pictures 49 Ron Howard 78 Lowell Ganz 79 Matthew McConaughey 220 Jenna Elfman 67  
453 453 Edtv 86 1999 26 Center for the Arts, Yerba Buena Gardens (701 Mission Street)   Imagine Entertainment 64 MCA / Universal Pictures 49 Ron Howard 78 Lowell Ganz 79 Matthew McConaughey 220 Jenna Elfman 67  
454 454 Edtv 86 1999 26 Castro Theatre (429 Castro Street, The Castro) The original Castro Theatre was built in 1910, a few doors down from the current theatre. The original theatre was converted into retail space, and the current theatre was built in the 1920s. Imagine Entertainment 64 MCA / Universal Pictures 49 Ron Howard 78 Lowell Ganz 79 Matthew McConaughey 220 Jenna Elfman 67  
455 455 Edtv 86 1999 26 20th & Connecticut Streets (Potrero Hill)   Imagine Entertainment 64 MCA / Universal Pictures 49 Ron Howard 78 Lowell Ganz 79 Matthew McConaughey 220 Jenna Elfman 67  
456 456 Edtv 86 1999 26 19 Green Street (North Beach)   Imagine Entertainment 64 MCA / Universal Pictures 49 Ron Howard 78 Lowell Ganz 79 Matthew McConaughey 220 Jenna Elfman 67  
457 457 Edtv 86 1999 26 1138 Filbert Street   Imagine Entertainment 64 MCA / Universal Pictures 49 Ron Howard 78 Lowell Ganz 79 Matthew McConaughey 220 Jenna Elfman 67  
458 458 Edtv 86 1999 26 North Beach Video (1398 Grant Avenue at Green) The video store has since moved to an adjacent location. Imagine Entertainment 64 MCA / Universal Pictures 49 Ron Howard 78 Lowell Ganz 79 Matthew McConaughey 220 Jenna Elfman 67  
1159 1159 Seven Girlfriends 213 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. White Dwarf Productions 132 Lions Gate Films Home Entertainment 82 Paul Lazarus 176 Paul Lazarus 185 Laura Leighton 376 Tim Daly 163  
1238 1238 Stigmata 228 1999 26 19th and Kansas St.   Metro-Goldwyn Mayer 8 Metro-Goldwyn Mayer Distributing 85 Rupert Wainwright 189 Tom Lazarus 199 Patricia Arquette 385 Gabriel Byrne 173  
1312 1312 The Bachelor 241 1999 26 Merchant Exchange (465 California Street at Leidesdorff)   George Street Pictures 147 New Line Cinema 105 Gary Sinyor 198 Steve Cohen 210 Chris O'Donnell 394 Renee Zellweger 185  
1314 1314 The Bachelor 241 1999 26 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. George Street Pictures 147 New Line Cinema 105 Gary Sinyor 198 Steve Cohen 210 Chris O'Donnell 394 Renee Zellweger 185  
1315 1315 The Bachelor 241 1999 26 Sutter-Stockton Garage (330 Sutter Street at Stockton) Garage roof serves as a heliport in the movie George Street Pictures 147 New Line Cinema 105 Gary Sinyor 198 Steve Cohen 210 Chris O'Donnell 394 Renee Zellweger 185  
1316 1316 The Bachelor 241 1999 26 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. George Street Pictures 147 New Line Cinema 105 Gary Sinyor 198 Steve Cohen 210 Chris O'Donnell 394 Renee Zellweger 185  
1317 1317 The Bachelor 241 1999 26 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. George Street Pictures 147 New Line Cinema 105 Gary Sinyor 198 Steve Cohen 210 Chris O'Donnell 394 Renee Zellweger 185  
1318 1318 The Bachelor 241 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. George Street Pictures 147 New Line Cinema 105 Gary Sinyor 198 Steve Cohen 210 Chris O'Donnell 394 Renee Zellweger 185  
1319 1319 The Bachelor 241 1999 26 Roof of Cable Car (California at Front Street) SF Cable Cars are the only moving National Historical Landmark. George Street Pictures 147 New Line Cinema 105 Gary Sinyor 198 Steve Cohen 210 Chris O'Donnell 394 Renee Zellweger 185  
1320 1320 The Bachelor 241 1999 26 Pacific Stock Exchange (301 Pine Street at Sansome)   George Street Pictures 147 New Line Cinema 105 Gary Sinyor 198 Steve Cohen 210 Chris O'Donnell 394 Renee Zellweger 185  
1321 1321 The Bachelor 241 1999 26 Nina M. Designs (52 2nd Street at Jessie)   George Street Pictures 147 New Line Cinema 105 Gary Sinyor 198 Steve Cohen 210 Chris O'Donnell 394 Renee Zellweger 185  
1322 1322 The Bachelor 241 1999 26 Moose's Restaurant (1652 Stockton)   George Street Pictures 147 New Line Cinema 105 Gary Sinyor 198 Steve Cohen 210 Chris O'Donnell 394 Renee Zellweger 185  
1323 1323 The Bachelor 241 1999 26 Mama's Restaurant (1701 Stockton)   George Street Pictures 147 New Line Cinema 105 Gary Sinyor 198 Steve Cohen 210 Chris O'Donnell 394 Renee Zellweger 185  
1324 1324 The Bachelor 241 1999 26 Danilo's Bakery (Green Street & Bannam Place)   George Street Pictures 147 New Line Cinema 105 Gary Sinyor 198 Steve Cohen 210 Chris O'Donnell 394 Renee Zellweger 185  
1325 1325 The Bachelor 241 1999 26 Columbus Avenue at Green & Stockton   George Street Pictures 147 New Line Cinema 105 Gary Sinyor 198 Steve Cohen 210 Chris O'Donnell 394 Renee Zellweger 185  
1447 1447 The Matrix 269 1999 26 skyline/ exterior scenes   Silver Pictures 128 Warner Bros. Pictures 6 The Wachowski Brothers 222 The Wachowski Brothers 233 Keanu Reeves 391 Laurence Fishburne 206  
1452 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 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 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  

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