Data source: data.sfgov.org
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
610 | 610 | Godzilla 106 | 2014 11 | Potrero &San Bruno | Nautilus Productions, LLC 74 | Warner Bros. Pictures 6 | Gareth Edwards 98 | Max Borenstein 98 | Aaron Taylor-Johnson 311 | Elizabeth Olsen 85 | Bryan Cranston 481 | |
609 | 609 | Godzilla 106 | 2014 11 | Mission & Beal | Nautilus Productions, LLC 74 | Warner Bros. Pictures 6 | Gareth Edwards 98 | Max Borenstein 98 | Aaron Taylor-Johnson 311 | Elizabeth Olsen 85 | Bryan Cranston 481 | |
608 | 608 | Godzilla 106 | 2014 11 | Embarcadero & Washington | Nautilus Productions, LLC 74 | Warner Bros. Pictures 6 | Gareth Edwards 98 | Max Borenstein 98 | Aaron Taylor-Johnson 311 | Elizabeth Olsen 85 | Bryan Cranston 481 | |
607 | 607 | Godzilla 106 | 2014 11 | Pier 1 | Nautilus Productions, LLC 74 | Warner Bros. Pictures 6 | Gareth Edwards 98 | Max Borenstein 98 | Aaron Taylor-Johnson 311 | Elizabeth Olsen 85 | Bryan Cranston 481 | |
606 | 606 | Godzilla 106 | 2014 11 | Pier 7 (The Embarcadero) | Nautilus Productions, LLC 74 | Warner Bros. Pictures 6 | Gareth Edwards 98 | Max Borenstein 98 | Aaron Taylor-Johnson 311 | Elizabeth Olsen 85 | Bryan Cranston 481 | |
605 | 605 | Godzilla 106 | 2014 11 | Eddy & Taylor St. | Nautilus Productions, LLC 74 | Warner Bros. Pictures 6 | Gareth Edwards 98 | Max Borenstein 98 | Aaron Taylor-Johnson 311 | Elizabeth Olsen 85 | Bryan Cranston 481 | |
604 | 604 | Godzilla 106 | 2014 11 | Mission & Fremont St | Nautilus Productions, LLC 74 | Warner Bros. Pictures 6 | Gareth Edwards 98 | Max Borenstein 98 | Aaron Taylor-Johnson 311 | Elizabeth Olsen 85 | Bryan Cranston 481 | |
603 | 603 | Godzilla 106 | 2014 11 | Bush & Kearny | Nautilus Productions, LLC 74 | Warner Bros. Pictures 6 | Gareth Edwards 98 | Max Borenstein 98 | Aaron Taylor-Johnson 311 | Elizabeth Olsen 85 | Bryan Cranston 481 | |
602 | 602 | Godzilla 106 | 2014 11 | Stockton & Clay St | Nautilus Productions, LLC 74 | Warner Bros. Pictures 6 | Gareth Edwards 98 | Max Borenstein 98 | Aaron Taylor-Johnson 311 | Elizabeth Olsen 85 | Bryan Cranston 481 | |
601 | 601 | Godzilla 106 | 2014 11 | Post & Jones St. | Nautilus Productions, LLC 74 | Warner Bros. Pictures 6 | Gareth Edwards 98 | Max Borenstein 98 | Aaron Taylor-Johnson 311 | Elizabeth Olsen 85 | Bryan Cranston 481 | |
600 | 600 | Godzilla 106 | 2014 11 | Broadway & Columbus | Nautilus Productions, LLC 74 | Warner Bros. Pictures 6 | Gareth Edwards 98 | Max Borenstein 98 | Aaron Taylor-Johnson 311 | Elizabeth Olsen 85 | Bryan Cranston 481 | |
599 | 599 | Godzilla 106 | 2014 11 | Broadway & Sansome | Nautilus Productions, LLC 74 | Warner Bros. Pictures 6 | Gareth Edwards 98 | Max Borenstein 98 | Aaron Taylor-Johnson 311 | Elizabeth Olsen 85 | Bryan Cranston 481 | |
598 | 598 | Godzilla 106 | 2014 11 | Sacramento & Front St. | Nautilus Productions, LLC 74 | Warner Bros. Pictures 6 | Gareth Edwards 98 | Max Borenstein 98 | Aaron Taylor-Johnson 311 | Elizabeth Olsen 85 | Bryan Cranston 481 | |
597 | 597 | Godzilla 106 | 2014 11 | Pine St. & Davis St | Nautilus Productions, LLC 74 | Warner Bros. Pictures 6 | Gareth Edwards 98 | Max Borenstein 98 | Aaron Taylor-Johnson 311 | Elizabeth Olsen 85 | Bryan Cranston 481 | |
596 | 596 | Godzilla 106 | 2014 11 | California & Davis St | Nautilus Productions, LLC 74 | Warner Bros. Pictures 6 | Gareth Edwards 98 | Max Borenstein 98 | Aaron Taylor-Johnson 311 | Elizabeth Olsen 85 | Bryan Cranston 481 | |
595 | 595 | Godzilla 106 | 2014 11 | Kearney & Pine St. | Nautilus Productions, LLC 74 | Warner Bros. Pictures 6 | Gareth Edwards 98 | Max Borenstein 98 | Aaron Taylor-Johnson 311 | Elizabeth Olsen 85 | Bryan Cranston 481 | |
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 |
517 | 517 | Final Analysis 95 | 1992 22 | Bix Restaurant (56 Gold Street) | Warner Bros. Pictures 38 | Warner Bros. Pictures 6 | Phil Joanou 86 | Robert Berger 87 | Richard Gere 264 | Kim Basinger 75 | ||
516 | 516 | Final Analysis 95 | 1992 22 | 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. | Warner Bros. Pictures 38 | Warner Bros. Pictures 6 | Phil Joanou 86 | Robert Berger 87 | Richard Gere 264 | Kim Basinger 75 | |
515 | 515 | Final Analysis 95 | 1992 22 | 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. | Warner Bros. Pictures 38 | Warner Bros. Pictures 6 | Phil Joanou 86 | Robert Berger 87 | Richard Gere 264 | Kim Basinger 75 | |
514 | 514 | Final Analysis 95 | 1992 22 | Public Health Service Hospital (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. | Warner Bros. Pictures 38 | Warner Bros. Pictures 6 | Phil Joanou 86 | Robert Berger 87 | Richard Gere 264 | Kim Basinger 75 | |
513 | 513 | Final Analysis 95 | 1992 22 | 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. | Warner Bros. Pictures 38 | Warner Bros. Pictures 6 | Phil Joanou 86 | Robert Berger 87 | Richard Gere 264 | Kim Basinger 75 | |
512 | 512 | Fearless 94 | 1993 46 | 5th and Beale Streets | Spring Creek Productions 68 | Warner Bros. Pictures 6 | Peter Weir 85 | Rafael Yglesias 86 | Jeff Bridges 113 | Isabella Rosellini 74 | Rosie Perez 475 | |
511 | 511 | Fearless 94 | 1993 46 | 90 Gold Street | Spring Creek Productions 68 | Warner Bros. Pictures 6 | Peter Weir 85 | Rafael Yglesias 86 | Jeff Bridges 113 | Isabella Rosellini 74 | Rosie Perez 475 | |
510 | 510 | Fearless 94 | 1993 46 | 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. | 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 | |
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 |
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 |
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 | |
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 | |
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 | |
409 | 409 | Days of Wine and Roses 75 | 1962 29 | Warner Bros. Pictures 38 | Warner Bros. Pictures 6 | Blake Edwards 69 | JP Miller 68 | Jack Lemmon 292 | Lee Remick 57 | Charles Bickford 468 | ||
400 | 400 | Dark Passage 72 | 1947 41 | Filbert Steps, Filbert Street | Warner Bros. Pictures 38 | Warner Bros. Pictures 6 | Delmer Daves 66 | Delmer Daves & David Goodis 65 | Humphrey Bogart 289 | Lauren Bacal 54 | Bruce Bennett 465 | |
399 | 399 | Dark Passage 72 | 1947 41 | The Malloch Apartment Building (1360 Montgomery Street) | Warner Bros. Pictures 38 | Warner Bros. Pictures 6 | Delmer Daves 66 | Delmer Daves & David Goodis 65 | Humphrey Bogart 289 | Lauren Bacal 54 | Bruce Bennett 465 | |
398 | 398 | Dark Passage 72 | 1947 41 | 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 | Delmer Daves 66 | Delmer Daves & David Goodis 65 | Humphrey Bogart 289 | Lauren Bacal 54 | Bruce Bennett 465 |
385 | 385 | Copycat 68 | 1995 39 | 82 & 67 Rico Way (Marina District) | Regency Enterprises 52 | Warner Bros. Pictures 6 | Jon Amiel 62 | Ann Biderman 61 | Sigourney Weaver 285 | Holly Hunter 50 | ||
384 | 384 | Copycat 68 | 1995 39 | Alta Plaza Park | 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. | Regency Enterprises 52 | Warner Bros. Pictures 6 | Jon Amiel 62 | Ann Biderman 61 | Sigourney Weaver 285 | Holly Hunter 50 | |
383 | 383 | Copycat 68 | 1995 39 | Java House (Pier 40, Embarcadero) | Regency Enterprises 52 | Warner Bros. Pictures 6 | Jon Amiel 62 | Ann Biderman 61 | Sigourney Weaver 285 | Holly Hunter 50 | ||
382 | 382 | Copycat 68 | 1995 39 | Sound Factory (1st and Harrison Streets) | Regency Enterprises 52 | Warner Bros. Pictures 6 | Jon Amiel 62 | Ann Biderman 61 | Sigourney Weaver 285 | Holly Hunter 50 | ||
381 | 381 | Copycat 68 | 1995 39 | 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 “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". | Regency Enterprises 52 | Warner Bros. Pictures 6 | Jon Amiel 62 | Ann Biderman 61 | Sigourney Weaver 285 | Holly Hunter 50 | |
380 | 380 | Copycat 68 | 1995 39 | 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. | Regency Enterprises 52 | Warner Bros. Pictures 6 | Jon Amiel 62 | Ann Biderman 61 | Sigourney Weaver 285 | Holly Hunter 50 | |
374 | 374 | City of Angels 64 | 1998 18 | San Francisco Public Library Main Branch (100 Larkin Street) | Atlas Entertainment 48 | Warner Bros. Pictures 6 | Brad Silberling 58 | Dana Stevens 58 | Nicolas Cage 216 | Meg Ryan 46 | ||
237 | 237 | Burglar 43 | 1987 32 | 1400 18th Street | Warner Bros. Pictures 38 | Warner Bros. Pictures 6 | Hugh Wilson 41 | Joseph Loeb III 40 | Whoopi Goldberg 274 | Bobcat Goldwait 37 | ||
236 | 236 | Burglar 43 | 1987 32 | Green Valley Restaurant (510 Green Street Near Grant) | Warner Bros. Pictures 38 | Warner Bros. Pictures 6 | Hugh Wilson 41 | Joseph Loeb III 40 | Whoopi Goldberg 274 | Bobcat Goldwait 37 | ||
235 | 235 | Burglar 43 | 1987 32 | 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. | Warner Bros. Pictures 38 | Warner Bros. Pictures 6 | Hugh Wilson 41 | Joseph Loeb III 40 | Whoopi Goldberg 274 | Bobcat Goldwait 37 | |
213 | 213 | Burglar 43 | 1987 32 | 1627 Haight Street | Warner Bros. Pictures 38 | Warner Bros. Pictures 6 | Hugh Wilson 41 | Joseph Loeb III 40 | Whoopi Goldberg 274 | Bobcat Goldwait 37 | ||
19 | 19 | A Night Full of Rain 7 | 1978 7 | Broadway (North Beach) | Liberty Film 7 | Warner Bros. Pictures 6 | Lina Wertmuller 7 | Lina Wertmuller 6 | Candice Bergen 242 | Giancarlo Gianni 6 | ||
18 | 18 | A Night Full of Rain 7 | 1978 7 | San Francisco Chronicle (901 Mission Street at 15th Street) | The San Francisco Zodiac Killer of the late 1960s sent his notes and letters to the Chronicle's offices. | Liberty Film 7 | Warner Bros. Pictures 6 | Lina Wertmuller 7 | Lina Wertmuller 6 | Candice Bergen 242 | Giancarlo Gianni 6 | |
17 | 17 | A Night Full of Rain 7 | 1978 7 | 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. | Liberty Film 7 | Warner Bros. Pictures 6 | Lina Wertmuller 7 | Lina Wertmuller 6 | Candice Bergen 242 | Giancarlo Gianni 6 | |
16 | 16 | A Night Full of Rain 7 | 1978 7 | Embarcadero Freeway | Embarcadero Freeway, which was featured in the film was demolished in 1989 because of structural damage from the 1989 Loma Prieta Earthquake) | Liberty Film 7 | Warner Bros. Pictures 6 | Lina Wertmuller 7 | Lina Wertmuller 6 | Candice Bergen 242 | Giancarlo Gianni 6 |
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");