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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1503 | 1503 | The Wedding Planner 284 | 2001 33 | Grace Cathedral Episcopal Church (1100 California Street) | Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. | Columbia Pictures 165 | Sony Pictures Entertainment 115 | Adam Shankman 232 | Pamela Falk 245 | Jennifer Lopez 421 | Matthew McConaughey 220 | |
| 1504 | 1504 | The Wedding Planner 284 | 2001 33 | The Music Concourse (Martin Luther King, Jr. Drive, Golden Gate Park) | Golden Gate Park is similar in shape but 20% larger than New York's Central Park. | Columbia Pictures 165 | Sony Pictures Entertainment 115 | Adam Shankman 232 | Pamela Falk 245 | Jennifer Lopez 421 | Matthew McConaughey 220 | |
| 1505 | 1505 | The Wedding Planner 284 | 2001 33 | Pleasant Street at Taylor | Columbia Pictures 165 | Sony Pictures Entertainment 115 | Adam Shankman 232 | Pamela Falk 245 | Jennifer Lopez 421 | Matthew McConaughey 220 | ||
| 1506 | 1506 | The Wedding Planner 284 | 2001 33 | Pier 7 (The Embarcadero) | Columbia Pictures 165 | Sony Pictures Entertainment 115 | Adam Shankman 232 | Pamela Falk 245 | Jennifer Lopez 421 | Matthew McConaughey 220 | ||
| 1507 | 1507 | The Wedding Planner 284 | 2001 33 | Montgomery Street at Union Street | Columbia Pictures 165 | Sony Pictures Entertainment 115 | Adam Shankman 232 | Pamela Falk 245 | Jennifer Lopez 421 | Matthew McConaughey 220 | ||
| 1508 | 1508 | The Wedding Planner 284 | 2001 33 | Lincoln Park | The land on which the park stands was a cemetery until the late 1860s. | Columbia Pictures 165 | Sony Pictures Entertainment 115 | Adam Shankman 232 | Pamela Falk 245 | Jennifer Lopez 421 | Matthew McConaughey 220 | |
| 1509 | 1509 | The Wedding Planner 284 | 2001 33 | Japanese Tea Garden (Hagiwara Tea Garden Drive, Golden Gate Park) | The Japanese Hagiwara family invented "Chinese" fortune cookies in the tea-garden | Columbia Pictures 165 | Sony Pictures Entertainment 115 | Adam Shankman 232 | Pamela Falk 245 | Jennifer Lopez 421 | Matthew McConaughey 220 | |
| 1510 | 1510 | The Wedding Planner 284 | 2001 33 | 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. | Columbia Pictures 165 | Sony Pictures Entertainment 115 | Adam Shankman 232 | Pamela Falk 245 | Jennifer Lopez 421 | Matthew McConaughey 220 |
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");