Film_Locations_in_San_Francisco

Data source: data.sfgov.org

1,622 rows sorted by Actor 3

View and edit SQL

Link rowid Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3 ▼
705 Jack 137 1996 43     American Zoetrope 92 Buena Vista Pictures 25 Francis Ford Coppola 127 James DeMonaco 127 Robin Williams 265 Diane Lane 112  
715 James and the Giant Peach 139 1996 43     Skellington Productions 94 Walt Disney Studios Home Entertainment 62 Henry Selick 129 Karey Kirkpatrick 128 Richard Dreyfuss 252 Jane Leeves 114  
722 Julie and Jack 141 2003 38     Moviehead Pictures 96 Echelon Entertainment 64 James Nguyen 130 James Nguyen & Joe Bright 130 Jenn Gotzon 333 Tippi Hedren 116  
730 Just Like Heaven 143 2005 2     DreamWorks SKG 84 DreamWorks Distribution 59 Mark Waters 131 Peter Tolan 132 Reese Witherspoon 335 Mark Ruffalo 118  
731 Just One Night 144 2000 25 Ferry Building Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. Panoptic Pictures 97 First Look International 65 Alan Jacobs 132 Alan Jacobs 133 Timothy Hutton 336 Maria Grazia Cucinotta 119  
732 Kamikaze Hearts 145 1986 28 Market Street Between Noe and Sanchez   Leger/Bashore 98 Facets Multimedia Distribution 66 Juliet Bashore 133 Juliet Bashore 134 Tigr 337 Sharon Mitchell 120  
736 Live Nude Girls Unite 147 2000 25 Lusty Lady Bar (North Beach)   Constant Communication 100 First Run Features 68 Vicky Funari 135 Vicky Funari 136      
862 Love & Taxes 159 2014 11 The Marsh Theatre (1062 Valencia Street)   Bad Company Films 102   Jacob Kornbluth 137 Jacob Kornbluth 138 Jacob Kornbluth 340    
863 Love & Taxes 159 2014 11 20 Hill Street   Bad Company Films 102   Jacob Kornbluth 137 Jacob Kornbluth 138 Jacob Kornbluth 340    
864 Love & Taxes 159 2014 11 198 Gough Street   Bad Company Films 102   Jacob Kornbluth 137 Jacob Kornbluth 138 Jacob Kornbluth 340    
885 Metro 164 1997 8 Bush Street at Jones   Touchstone Pictures 104 Buena Vista Pictures 25 Thomas Carter 140 Randy Feldman 143 Eddie Murphy 3    
887 Milk 166 2008 59 Duboce Park   Focus Features 106 Focus Features 17 Gus Van Sant 142 Dustin Lance Black 145 Sean Penn 40 Emile Hirsch 128  
888 Milk 166 2008 59 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. Focus Features 106 Focus Features 17 Gus Van Sant 142 Dustin Lance Black 145 Sean Penn 40 Emile Hirsch 128  
889 Milk 166 2008 59 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. Focus Features 106 Focus Features 17 Gus Van Sant 142 Dustin Lance Black 145 Sean Penn 40 Emile Hirsch 128  
890 Milk 166 2008 59 424 Sansome Street   Focus Features 106 Focus Features 17 Gus Van Sant 142 Dustin Lance Black 145 Sean Penn 40 Emile Hirsch 128  
891 Milk 166 2008 59 29th and Dolores Street   Focus Features 106 Focus Features 17 Gus Van Sant 142 Dustin Lance Black 145 Sean Penn 40 Emile Hirsch 128  
892 Milk 166 2008 59 El Camino Del Mar   Focus Features 106 Focus Features 17 Gus Van Sant 142 Dustin Lance Black 145 Sean Penn 40 Emile Hirsch 128  
893 Milk 166 2008 59 Treasure Island An artificial island, Treasure Island was created for the 1939 Golden Gate International Exposition, and is named after the novel by Robert Louis Stevenson, a one-time San Francisco resident. Focus Features 106 Focus Features 17 Gus Van Sant 142 Dustin Lance Black 145 Sean Penn 40 Emile Hirsch 128  
894 Milk 166 2008 59 Market & Castro Street From 1910-1920 the Castro was called "Little Scandinavia" because of its high concentration of residents of Scandinavian ancestry. Focus Features 106 Focus Features 17 Gus Van Sant 142 Dustin Lance Black 145 Sean Penn 40 Emile Hirsch 128  
895 Milk 166 2008 59 Marine Fireman's Union Headquarters   Focus Features 106 Focus Features 17 Gus Van Sant 142 Dustin Lance Black 145 Sean Penn 40 Emile Hirsch 128  
896 Milk 166 2008 59 Lower Haight Street   Focus Features 106 Focus Features 17 Gus Van Sant 142 Dustin Lance Black 145 Sean Penn 40 Emile Hirsch 128  
898 Milk 166 2008 59 Grace Cathedral Episcopal Church (1100 California Street) Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. Focus Features 106 Focus Features 17 Gus Van Sant 142 Dustin Lance Black 145 Sean Penn 40 Emile Hirsch 128  
899 Milk 166 2008 59 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. Focus Features 106 Focus Features 17 Gus Van Sant 142 Dustin Lance Black 145 Sean Penn 40 Emile Hirsch 128  
900 Mission (aka City of Bars) 167 2001 33 The 500 Club (500 Guerrero Street, Mission District)       Loren Marsh 143 Loren Marsh 146 Chris Coburn 342    
901 Mission (aka City of Bars) 167 2001 33 Mission Dolores Park (Mission District) The two land plots that comprise the Park were used as a Jewish cemetery until 1894 when San Francisco prohibited all burials within city limits. The graves were moved to Colma, CA.     Loren Marsh 143 Loren Marsh 146 Chris Coburn 342    
902 Mona Lisa Smile 168 2003 38     Revolution Studios 107 Columbia Pictures 4 Mike Newell 144 Lawrence Konner 147 Julia Roberts 150 Kirsten Dunst 129  
903 Mother 169 1996 43 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. Paramount Pictures 4 Paramount Pictures 3 Albert Brooks 145 Albert Brooks 148 Albert Brooks 343 Debbie Reynolds 130  
904 Mother 169 1996 43 Fairmont Hotel (950 Mason Street, Nob Hill) In 1945 the Fairmont hosted the United Nations Conference on International Organization as delegates arrived to draft a charter for the organization. The U.S. Secretary of State, Edward Stettinius drafted the charter in the hotel's Garden Room. Paramount Pictures 4 Paramount Pictures 3 Albert Brooks 145 Albert Brooks 148 Albert Brooks 343 Debbie Reynolds 130  
974 Never Die Twice 175 2001 33 Postcard Row (Alamo Square, Hayes Valley) The 6 Victorian homes across from Alamo Square Park are among the few Victorians to survive the Great Fire. Scott / Kelly Films 110   Sean A.F. Scott 148 Sean A.F. Scott & Nancy L. Kelly 152 Claudia Christian 345    
975 Night of Henna 176 2005 2     Zee Films 111 Illuminare Entertainment 70 Hassan Zee 149 Hassan Zee 153 Joyce Carlin 346 Nancy Carlin 133  
976 Nina Takes a Lover 177 1994 48     Alan Jacobs Productions 112 Columbia TriStar Home Video 47 Alan Jacobs 132 Alan Jacobs 133 Laura San Giacomo 347 Paul Rhys 134  
995 On the Road 182 2012 13 Bay Bridge   SPAD Films 114 IFC Films & Sundance Selects 71 Walter Salles 151 Jack Kerouac & Jose Rivera 157 Garrett Hedlund 352 Viggo Mortenson 139  
996 On the Road 182 2012 13 Sacramento & Montgomery Streets   SPAD Films 114 IFC Films & Sundance Selects 71 Walter Salles 151 Jack Kerouac & Jose Rivera 157 Garrett Hedlund 352 Viggo Mortenson 139  
997 On the Road 182 2012 13 2017 23rd Street   SPAD Films 114 IFC Films & Sundance Selects 71 Walter Salles 151 Jack Kerouac & Jose Rivera 157 Garrett Hedlund 352 Viggo Mortenson 139  
998 On the Road 182 2012 13 Filbert & Leavenworth Streets   SPAD Films 114 IFC Films & Sundance Selects 71 Walter Salles 151 Jack Kerouac & Jose Rivera 157 Garrett Hedlund 352 Viggo Mortenson 139  
999 Pacific Heights 183 1990 17 Texas & 19th Streets (Potrero Hill)   Morgan Creek Productions 115 Twentieth Century Fox Film Corporation 12 John Schlesinger 152 Daniel Pyne 158 Melanie Griffith 353 Matthew Modine 140  
1000 Pacific Heights 183 1990 17 Financial District   Morgan Creek Productions 115 Twentieth Century Fox Film Corporation 12 John Schlesinger 152 Daniel Pyne 158 Melanie Griffith 353 Matthew Modine 140  
1001 Pacific Heights 183 1990 17 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. Morgan Creek Productions 115 Twentieth Century Fox Film Corporation 12 John Schlesinger 152 Daniel Pyne 158 Melanie Griffith 353 Matthew Modine 140  
1005 Panther 185 1995 39     Gramercy Pictures 116 PolyGram Video 72 Mario Van Peebles 154 Mario Van Peebles 160 Kadeem Hardison 355 Bookeem Woodbine 142  
1006 Parks and Recreation 186 2014 11 Filbert from Hyde to Leavenworth   NBC Universal Media, LLC 117 NBC Universal Media, LLC 73 Dean Holland 155 Greg Daniels 161 Amy Poehler 356    
1007 Parks and Recreation 186 2014 11 Columbus and Green   NBC Universal Media, LLC 117 NBC Universal Media, LLC 73 Dean Holland 155 Greg Daniels 161 Amy Poehler 356    
1008 Parks and Recreation 186 2014 11 Larkin & Fulton   NBC Universal Media, LLC 117 NBC Universal Media, LLC 73 Dean Holland 155 Greg Daniels 161 Amy Poehler 356    
1009 Parks and Recreation 186 2014 11 Embarcadero & Market   NBC Universal Media, LLC 117 NBC Universal Media, LLC 73 Dean Holland 155 Greg Daniels 161 Amy Poehler 356    
1010 Patch Adams 187 1998 18 Treasure Island An artificial island, Treasure Island was created for the 1939 Golden Gate International Exposition, and is named after the novel by Robert Louis Stevenson, a one-time San Francisco resident. Bungalow 78 Productions 118 Universal Pictures 41 Tom Shadyac 156 Steve Oedekerk 162 Robin Williams 265 Philip Seymour Hoffman 143  
1011 Patch Adams 187 1998 18 Sheraton Palace Hotel (639 Market Street) The hotel was destroyed in the 1906 earthquake and fire, had to be rebuilt, and was reopened in 1909. Bungalow 78 Productions 118 Universal Pictures 41 Tom Shadyac 156 Steve Oedekerk 162 Robin Williams 265 Philip Seymour Hoffman 143  
1012 Patch Adams 187 1998 18 Presidio (Golden Gate National Recreation Area) In 1776, Spain made the Presidio a fortified area. The area was then given to Mexico, but then given to the US in 1848. The 1994 demilitarization of the area in 1994 marked the end of its 219 years of military use. Bungalow 78 Productions 118 Universal Pictures 41 Tom Shadyac 156 Steve Oedekerk 162 Robin Williams 265 Philip Seymour Hoffman 143  
1022 Phenomenon 190 1996 43 Treasure Island An artificial island, Treasure Island was created for the 1939 Golden Gate International Exposition, and is named after the novel by Robert Louis Stevenson, a one-time San Francisco resident. Touchstone Pictures 104 Buena Vista Pictures 25 Jon Turteltaub 159 Gerald Dipego 164 John Travolta 359 Kyra Sedgwick 146  
1029 Playing Mona Lisa 192 2000 25 Conservatory of Flowers (Golden Gate Park) The Conservatory, unveiled in 1879, is the oldest public conservatory in the Western Hemisphere. The Bubble Factory 121 Buena Vista Pictures 25 Matthew Huffman 161 Marni Freedman 165 Alicia Witt 361 Harvey Fierstein 148  
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  
1070 Raising Cain 199 1992 22     Pacific Western 125 Universal Pictures 41 Brian DePalma 45 Brian DePalma 172 John Lithgow 367    
1071 Red Diaper Baby 200 2004 5 Magic Theater (Fort Mason, Golden Gate National Recreation Area) Constructed in 1864 as a coastal defense site, Fort Mason went on to serve as an army post for more than 100 years. Hello Hooker Productions 77 Sundance Channel 78 Doug Pray 166 Josh Kornbluth 173 Josh Kornbluth 316    
1083 Rent 202 2005 2 Treasure Island An artificial island, Treasure Island was created for the 1939 Golden Gate International Exposition, and is named after the novel by Robert Louis Stevenson, a one-time San Francisco resident. Rent Productions LLC 127 Columbia Pictures 4 Chris Columbus 31 Stephen Chbosky 175 Anthony Rapp 369 Rosario Dawson 155  
1084 Rollerball 203 2002 3     Atlas Entertainment 48 MGM Home Entertainment 79 John McTiernan 168 William Harrison 176 Chris Klein 370 Jean Reno 156  
1085 Romeo Must Die 204 2000 25 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. Silver Pictures 128 Warner Bros. Pictures 6 Andrzej Bartkowiak 169 Mitchell Kapner 177 Jet Li 371 Aaliyah 157  
1086 Romeo Must Die 204 2000 25 Embarcadero Street   Silver Pictures 128 Warner Bros. Pictures 6 Andrzej Bartkowiak 169 Mitchell Kapner 177 Jet Li 371 Aaliyah 157  
1087 San Andreas 205 2015 10 2nd St. at Townsend St.   Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1088 San Andreas 205 2015 10 Jefferson St. at Powell St.   Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1089 San Andreas 205 2015 10 Grant St. at Bush St. Characters walk down street and it's totally wrecked from a massive earthquake Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1090 San Andreas 205 2015 10 Vallejo Garage Roof (Vallejo at Powell)   Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1091 San Andreas 205 2015 10 Clay St. at Taylor 3 characters walk down the street. An earthquake shakes the city and stuff starts breaking. One character gets a shard of glass stuck in his leg. Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1092 San Andreas 205 2015 10 Bay St. at Polk   Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1093 San Andreas 205 2015 10 Intersection of Lombard and Hyde   Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1094 San Andreas 205 2015 10 Mission between 3rd and 4th St.   Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1095 San Andreas 205 2015 10 555 California Characters walk out of broken window of 555 California out to Kearny St. Splinter unit films a car driving into the garage at 555 California Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1096 San Andreas 205 2015 10 Broadway and Kearney   Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1097 San Andreas 205 2015 10 Grant between Bush and Market   Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1098 San Andreas 205 2015 10 Coit Tower   Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1099 San Andreas 205 2015 10 TransAmerica Pyramid (600 Montgomery Street)   Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1100 San Andreas 205 2015 10 Washington Square   Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1101 San Andreas 205 2015 10 Battery Spencer   Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1102 San Andreas 205 2015 10 Pier 43 Bystanders watch as a tsunami crashes over them Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1103 San Andreas 205 2015 10 Vallejo St. Garage, 766 Vallejo St. Characters watch from roof of garage as tsunami hits SF waterfront Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1104 San Andreas 205 2015 10 Fort Baker   Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1105 San Andreas 205 2015 10 AT&T Stadium 3 characters run out of stadium, there is a group of people on the sidewalk, an earthquake hits, and they duck for cover Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1106 San Andreas 205 2015 10 AT&T Stadium two paragliders land on the field of AT&T Park Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1107 San Andreas 205 2015 10 Water work in SF Bay Characters drive in a high speed picture boat to see different views of the city. Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1108 San Andreas 205 2015 10 Stage Work, 47 Julian St.   Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1109 San Andreas 205 2015 10 Hyde St. at Greenwich and Hyde St. at Lombard Characters walk to get a vantage point for Coit tower. 250 actors walking "fleeing" the city after earthquake Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1110 San Andreas 205 2015 10 Asia Star Fantasy, 1126 Grant Ave. Characters look for a form of communication with LA in a post-quake trashed city Upside Down Productions, Inc. 129 Warner Bros. 80 Brad Peyton 170 Allan Loeb  178 Dwayne Johnson 258    
1113 Sausalito 207 2000 25 The Castro From 1910-1920 the Castro was called "Little Scandinavia" because of its high concentration of residents of Scandinavian ancestry. B.O.B and Partners 130   Andrew Lau 171   Maggie Cheung 373 Leon Lai 159  
1114 Sense8 208 2015 10 18th Street between Guerrero and Valencia Streets Re-enactment of "Dyke's on Bikes" and "Dyke March" Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1115 Sense8 208 2015 10 Atlas Café, 3049 20th St. Dialogue scene inside the café Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1116 Sense8 208 2015 10 Clarion Alley between Valencia & Mission St. Ladies discuss their relationship in the mural alley Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1117 Sense8 208 2015 10 Harrison & 20th Driving shots Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1118 Sense8 208 2015 10 Folsom Driving shots Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1119 Sense8 208 2015 10 16th St. Driving shots Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1120 Sense8 208 2015 10 S. Van Ness Driving shots Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1121 Sense8 208 2015 10 22nd St. Driving shots Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1122 Sense8 208 2015 10 Harrison Driving shots Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1123 Sense8 208 2015 10 20th Driving shots Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1124 Sense8 208 2015 10 Z Space Studios; 450 Florida St. Filming of the "Fresh Meat" Festival Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1125 Sense8 208 2015 10 375 Castro St. and 17th between Castro and Diamond St. Chase sequence on bicycles ends at gas station Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1126 Sense8 208 2015 10 Corbett St. Bicycle chase scene, actors dressed as fake officers present Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1127 Sense8 208 2015 10 Romain St. Bicycle chase scene Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1128 Sense8 208 2015 10 Market St. overpass Bicycle chase scene Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1129 Sense8 208 2015 10 Grand View Ave. Bicycle chase scene Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1130 Sense8 208 2015 10 Vallejo Street Garage; 766 Vallejo St. dialogue scene on top of a garage roof Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1131 Sense8 208 2015 10 Laguna Honda Hospital; 375 Laguna Honda Blvd. dialogue scene Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1132 Sense8 208 2015 10 Irving St. at 9th Ave. continuous driving shots of a taxi going with the flow of existing traffic Unpronounceable Productions, LLC 131 Netflix 53 The Wachowskis 172 The Wachowskis 180 Jamie Clayton 374    
1133 Twisted 209 2004 5 Pier 24   Paramount Pictures 4 Paramount Pictures 3 Philip Kaufman 111 Sarah Thorp 181 Ashley Judd 324 Samuel L. Jackson 160  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 20.866ms · Data source: data.sfgov.org