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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
121 | 121 | Bedazzled 31 | 2000 25 | 1155 Filbert Street at Hyde | Twentieth Century Fox Film Corp. 14 | Twentieth Century Fox Film Corp. 13 | Harold Ramis 29 | Harold Ramis 28 | Brendan Fraser 263 | Elizabeth Hurley 27 | ||
122 | 122 | Bedazzled 31 | 2000 25 | Washington Square Park (Filbert, between Stockton and Powell) | Twentieth Century Fox Film Corp. 14 | Twentieth Century Fox Film Corp. 13 | Harold Ramis 29 | Harold Ramis 28 | Brendan Fraser 263 | Elizabeth Hurley 27 | ||
123 | 123 | Bedazzled 31 | 2000 25 | Vaillancourt Fountain (Justin Herman Plaza) | Installed in 1975, the Vaillancourt Fountain is officially titled, "Québec Libre!". The night before the sculpture's inauguration, artist Armand Vaillancourt inscribed "Québec libre!" in red letters on the sculpture. The next day when he noticed that the note had been erased, Vaillancourt jumped on the statue to re-inscribe his message. | Twentieth Century Fox Film Corp. 14 | Twentieth Century Fox Film Corp. 13 | Harold Ramis 29 | Harold Ramis 28 | Brendan Fraser 263 | Elizabeth Hurley 27 | |
124 | 124 | Bedazzled 31 | 2000 25 | Montgomery & Market Streets | Twentieth Century Fox Film Corp. 14 | Twentieth Century Fox Film Corp. 13 | Harold Ramis 29 | Harold Ramis 28 | Brendan Fraser 263 | Elizabeth Hurley 27 | ||
125 | 125 | Bedazzled 31 | 2000 25 | 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. | Twentieth Century Fox Film Corp. 14 | Twentieth Century Fox Film Corp. 13 | Harold Ramis 29 | Harold Ramis 28 | Brendan Fraser 263 | Elizabeth Hurley 27 | |
558 | 558 | George of the Jungle 102 | 1997 8 | 755 Vallejo Street | Walt Disney Pictures 70 | Buena Vista Pictures 25 | Sam Weisman 93 | Jay Ward 94 | Brendan Fraser 263 | Leslie Mann 82 | ||
559 | 559 | George of the Jungle 102 | 1997 8 | The Tamalpais Building (1201 Greenwich Street at Hyde) | Walt Disney Pictures 70 | Buena Vista Pictures 25 | Sam Weisman 93 | Jay Ward 94 | Brendan Fraser 263 | Leslie Mann 82 | ||
560 | 560 | George of the Jungle 102 | 1997 8 | Neiman Marcus (150 Stockton Street, Union Square) | The City of Paris department store previously occupied the space that now houses Neiman Marcus. City of Paris' original rotunda and glass dome were incorporated into Neiman Marcus' design. | Walt Disney Pictures 70 | Buena Vista Pictures 25 | Sam Weisman 93 | Jay Ward 94 | Brendan Fraser 263 | Leslie Mann 82 | |
561 | 561 | George of the Jungle 102 | 1997 8 | First Bank (550 Montgomery Street at Commercial) | Called "Stanhope Bank" in the film. | Walt Disney Pictures 70 | Buena Vista Pictures 25 | Sam Weisman 93 | Jay Ward 94 | Brendan Fraser 263 | Leslie Mann 82 | |
562 | 562 | George of the Jungle 102 | 1997 8 | Bay Bridge | Before opening in 1936, the bridge was blessed by Cardinal Secretary of State Eugenio Pacelli, who later became Pope Pius XII. | Walt Disney Pictures 70 | Buena Vista Pictures 25 | Sam Weisman 93 | Jay Ward 94 | Brendan Fraser 263 | Leslie Mann 82 |
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");