Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: Title, Release Year, Production Company, Distributor, Writer, Actor 1, Actor 2
| Link | rowid ▼ | Title | Release Year | Locations | Fun Facts | Production Company | Distributor | Director | Writer | Actor 1 | Actor 2 | Actor 3 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 113 | 113 | Beaches 29 | 1988 23 | Silver Screen Partners IV 26 | Columbia Broadcasting System 22 | Garry Marshall 27 | Mary Agnes Donoghue 26 | Bette Midler 261 | Barbara Hershey 25 | John Heard 451 | ||
| 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 | |||
| 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 | |
| 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 |
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");