Data source: data.sfgov.org
This data as json, CSV (advanced)
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 | 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 | ||
520 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | |
1455 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 |
JSON shape: default, array, newline-delimited
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");