Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: Title, Release Year, Production Company, Distributor, Director, Writer, Actor 2
| Link | rowid ▼ | Title | Release Year | Locations | Fun Facts | Production Company | Distributor | Director | Writer | Actor 1 | Actor 2 | Actor 3 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 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 | |
| 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 | ||
| 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 | ||
| 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 |
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");