Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: Title, Release Year, Locations, Fun Facts, Distributor, Director, Writer, Actor 1, Actor 2, Actor 3
| Link | rowid ▼ | Title | Release Year | Locations | Fun Facts | Production Company | Distributor | Director | Writer | Actor 1 | Actor 2 | Actor 3 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24 | 24 | A View to a Kill 10 | 1985 9 | 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. | Metro-Goldwyn Mayer 8 | MGM/UA Entertainment Company 7 | John Glen 9 | Richard Maibaum 8 | Roger Moore 244 | Christopher Walken 8 | Tanya Roberts 441 |
| 25 | 25 | A View to a Kill 10 | 1985 9 | Port of San Francisco | Metro-Goldwyn Mayer 8 | MGM/UA Entertainment Company 7 | John Glen 9 | Richard Maibaum 8 | Roger Moore 244 | Christopher Walken 8 | Tanya Roberts 441 | |
| 27 | 27 | A View to a Kill 10 | 1985 9 | Lefty O' Doul Drawbridge/ 3rd Street Bridge (3rd Street, China Basin) | This is SF's only drawbridge, and was named after Francis Joseph "Lefty" O'Doul, a local baseball hero. | Metro-Goldwyn Mayer 8 | MGM/UA Entertainment Company 7 | John Glen 9 | Richard Maibaum 8 | Roger Moore 244 | Christopher Walken 8 | Tanya Roberts 441 |
| 28 | 28 | A View to a Kill 10 | 1985 9 | 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. | Metro-Goldwyn Mayer 8 | MGM/UA Entertainment Company 7 | John Glen 9 | Richard Maibaum 8 | Roger Moore 244 | Christopher Walken 8 | Tanya Roberts 441 |
| 29 | 29 | A View to a Kill 10 | 1985 9 | Embarcadero Freeway | Embarcadero Freeway, which was featured in the film, was demolished in 1989 because of structural damage from the 1989 Loma Prieta Earthquake) | Metro-Goldwyn Mayer 8 | MGM/UA Entertainment Company 7 | John Glen 9 | Richard Maibaum 8 | Roger Moore 244 | Christopher Walken 8 | Tanya Roberts 441 |
| 30 | 30 | A View to a Kill 10 | 1985 9 | Potrero Hill | The most crooked street in San Francisco is actually Potrero Hill's Vermont Street between 20th St & 22nd St. | Metro-Goldwyn Mayer 8 | MGM/UA Entertainment Company 7 | John Glen 9 | Richard Maibaum 8 | Roger Moore 244 | Christopher Walken 8 | Tanya Roberts 441 |
| 31 | 31 | A View to a Kill 10 | 1985 9 | 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. | Metro-Goldwyn Mayer 8 | MGM/UA Entertainment Company 7 | John Glen 9 | Richard Maibaum 8 | Roger Moore 244 | Christopher Walken 8 | Tanya Roberts 441 |
| 32 | 32 | A View to a Kill 10 | 1985 9 | Chinatown | First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. | Metro-Goldwyn Mayer 8 | MGM/UA Entertainment Company 7 | John Glen 9 | Richard Maibaum 8 | Roger Moore 244 | Christopher Walken 8 | Tanya Roberts 441 |
| 33 | 33 | A View to a Kill 10 | 1985 9 | Burger Island (901 3rd Street, China Basin) | Metro-Goldwyn Mayer 8 | MGM/UA Entertainment Company 7 | John Glen 9 | Richard Maibaum 8 | Roger Moore 244 | Christopher Walken 8 | Tanya Roberts 441 | |
| 34 | 34 | A View to a Kill 10 | 1985 9 | Van Ness Avenue | Metro-Goldwyn Mayer 8 | MGM/UA Entertainment Company 7 | John Glen 9 | Richard Maibaum 8 | Roger Moore 244 | Christopher Walken 8 | Tanya Roberts 441 | |
| 35 | 35 | A View to a Kill 10 | 1985 9 | Taylor and Jefferson Streets (Fisherman's Wharf) | Metro-Goldwyn Mayer 8 | MGM/UA Entertainment Company 7 | John Glen 9 | Richard Maibaum 8 | Roger Moore 244 | Christopher Walken 8 | Tanya Roberts 441 | |
| 39 | 39 | After the Thin Man 13 | 1936 12 | 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. | Metro-Goldwyn Mayer 8 | Metro-Goldwyn Mayer 10 | W.S. Van Dyke 12 | Frances Goodrich 11 | William Powell 247 | Myrna Loy 11 | James Stewart 432 |
| 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 |
| 1111 | 1111 | San Francisco 206 | 1936 12 | 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. | Metro-Goldwyn Mayer 8 | Metro-Goldwyn Mayer 10 | W.S. Van Dyke 12 | Anita Loos 179 | Clark Gable 372 | Jeanette MacDonald 158 | Spencer Tracy 315 |
| 1112 | 1112 | San Francisco 206 | 1936 12 | 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. | Metro-Goldwyn Mayer 8 | Metro-Goldwyn Mayer 10 | W.S. Van Dyke 12 | Anita Loos 179 | Clark Gable 372 | Jeanette MacDonald 158 | Spencer Tracy 315 |
| 1160 | 1160 | Shadow of the Thin Man 214 | 1941 63 | Bay Bridge | Before opening in 1936, the bridge was blessed by Cardinal Secretary of State Eugenio Pacelli, who later became Pope Pius XII. | Metro-Goldwyn Mayer 8 | Metro-Goldwyn Mayer 10 | W.S. Van Dyke 12 | Harry Kurnitz 186 | William Powell 247 | Myrna Loy 11 | Barry Nelson 515 |
| 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 |
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");