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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
9 | 9 | 24 Hours on Craigslist 2 | 2005 2 | Yerba Buena Productions 2 | Zealot Pictures 1 | Michael Ferris Gibson 2 | Craig Newmark 238 | |||||
88 | 88 | Around the Fire 22 | 1998 18 | Ocean Beach | On Jan. 25, 1878, the King Philip ship crashed in Ocean Beach. Occasionally, the ship's wreckage may be found on the beach-- most recently it was seen in 2007. | Paradigm Studio 19 | Ardustry Home Entertainment 15 | John Jacobsen 20 | John Comerford 19 | Tara Reid 255 | ||
89 | 89 | Attack of the Killer Tomatoes 23 | 1978 7 | Hyde Street Cable Car | SF Cable Cars are the only moving National Historical Landmark. | Four Square Productions 20 | NAI Entertainment 16 | John DeBello 21 | John DeBello 20 | David Miller 256 | ||
127 | 127 | Bicentennial Man 33 | 1999 26 | 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. | 1492 Pictures 29 | Buena Vista Pictures 25 | Chris Columbus 31 | Nicholas Kazan 30 | Robin Williams 265 | ||
128 | 128 | Bicentennial Man 33 | 1999 26 | 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. | 1492 Pictures 29 | Buena Vista Pictures 25 | Chris Columbus 31 | Nicholas Kazan 30 | Robin Williams 265 | ||
129 | 129 | Bicentennial Man 33 | 1999 26 | 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. | 1492 Pictures 29 | Buena Vista Pictures 25 | Chris Columbus 31 | Nicholas Kazan 30 | Robin Williams 265 | ||
130 | 130 | Bicentennial Man 33 | 1999 26 | 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. | 1492 Pictures 29 | Buena Vista Pictures 25 | Chris Columbus 31 | Nicholas Kazan 30 | Robin Williams 265 | ||
131 | 131 | Bicentennial Man 33 | 1999 26 | Grace Cathedral Episcopal Church (1100 California Street) | Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. | 1492 Pictures 29 | Buena Vista Pictures 25 | Chris Columbus 31 | Nicholas Kazan 30 | Robin Williams 265 | ||
196 | 196 | Broken-A Modern Love Story 40 | 2010 19 | Ina Coolbrith Park (1700 Taylor Street) | RKW Films 35 | Ryan K. Whiting 38 | Ryan K. Whiting 37 | |||||
197 | 197 | Broken-A Modern Love Story 40 | 2010 19 | 0-100 block Halleck Street | RKW Films 35 | Ryan K. Whiting 38 | Ryan K. Whiting 37 | |||||
238 | 238 | By Hook or By Crook 44 | 2001 33 | The Lexington Club (3464 19th Street at Lexington) | Steakhaus Productions 39 | Artistic License 31 | Harriet Dodge & Silas Howard 42 | Harriet Dodge & Silas Howard 41 | Silas Howard 275 | |||
239 | 239 | By Hook or By Crook 44 | 2001 33 | Royan Hotel (405 Valencia Street, Mission District) | Steakhaus Productions 39 | Artistic License 31 | Harriet Dodge & Silas Howard 42 | Harriet Dodge & Silas Howard 41 | Silas Howard 275 | |||
240 | 240 | By Hook or By Crook 44 | 2001 33 | Department of Public Health (101 Grove Street at Polk, Civic Center) | Steakhaus Productions 39 | Artistic License 31 | Harriet Dodge & Silas Howard 42 | Harriet Dodge & Silas Howard 41 | Silas Howard 275 | |||
324 | 324 | Faces of Death 58 | 1978 7 | F.O.D Productions 44 | Aquarius Releasing 35 | Conan Le Cilaire 53 | Alan Black 54 | Michael Carr 281 | ||||
594 | 594 | God is a Communist?* (show me heart universe) 105 | 2010 19 | Sacramento & Washington Streets | Trismegistus Productions 73 | Jon Poznanter 97 | Jon Poznanter 97 | John Wynn 310 | ||||
628 | 628 | Happy Gilmore 113 | 1996 43 | Brillstein-Grey Entertainment 78 | Universal Pictures 41 | Dennis Dugan 105 | Tim Herlihy 105 | Adam Sandler 240 | ||||
629 | 629 | Hard to Hold 114 | 1984 40 | 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. | Universal Pictures 15 | Universal Pictures 41 | Larry Peerce 106 | Thomas Hedley, Jr. 106 | Rick Springfield 317 | ||
633 | 633 | Heart and Souls 116 | 1993 46 | Stockton Tunnel (Stockton Street at Sutter Street) | Opened in 1914, the Stockton Tunnel was built to provide North Beach residents access to the thriving downtown area. | Universal Pictures 15 | Electric Parc 55 | Tomas Gislason 108 | Tomas Gislason 107 | Jorgen Leth 319 | ||
634 | 634 | Heart and Souls 116 | 1993 46 | 2810 Pacific Avenue | Universal Pictures 15 | Electric Parc 55 | Tomas Gislason 108 | Tomas Gislason 107 | Jorgen Leth 319 | |||
635 | 635 | Heart and Souls 116 | 1993 46 | War Memorial Opera House (401 Van Ness Avenue) | In 1945 the United Nations had its first conference at The War Memorial Opera House. | Universal Pictures 15 | Electric Parc 55 | Tomas Gislason 108 | Tomas Gislason 107 | Jorgen Leth 319 | ||
636 | 636 | Heart and Souls 116 | 1993 46 | Conservatory of Flowers (Golden Gate Park) | The Conservatory, unveiled in 1879, is the oldest public conservatory in the Western Hemisphere. | Universal Pictures 15 | Electric Parc 55 | Tomas Gislason 108 | Tomas Gislason 107 | Jorgen Leth 319 | ||
701 | 701 | I's 135 | 2011 1 | 1 Post Street | Banshee Cinema 90 | Chris Edgette 125 | Kyle Tuck 125 | |||||
736 | 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 | 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 | 863 | Love & Taxes 159 | 2014 11 | 20 Hill Street | Bad Company Films 102 | Jacob Kornbluth 137 | Jacob Kornbluth 138 | Jacob Kornbluth 340 | ||||
864 | 864 | Love & Taxes 159 | 2014 11 | 198 Gough Street | Bad Company Films 102 | Jacob Kornbluth 137 | Jacob Kornbluth 138 | Jacob Kornbluth 340 | ||||
885 | 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 | |||
900 | 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 | 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 | ||||
974 | 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 | |||
1006 | 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 | 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 | 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 | 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 | |||
1070 | 1070 | Raising Cain 199 | 1992 22 | Pacific Western 125 | Universal Pictures 41 | Brian DePalma 45 | Brian DePalma 172 | John Lithgow 367 | ||||
1071 | 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 | ||
1087 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | ||
1114 | 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 | 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 | 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 | 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 | 1118 | Sense8 208 | 2015 10 | Folsom | Driving shots | Unpronounceable Productions, LLC 131 | Netflix 53 | The Wachowskis 172 | The Wachowskis 180 | Jamie Clayton 374 | ||
1119 | 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 | 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 | 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 | 1122 | Sense8 208 | 2015 10 | Harrison | Driving shots | Unpronounceable Productions, LLC 131 | Netflix 53 | The Wachowskis 172 | The Wachowskis 180 | Jamie Clayton 374 | ||
1123 | 1123 | Sense8 208 | 2015 10 | 20th | Driving shots | Unpronounceable Productions, LLC 131 | Netflix 53 | The Wachowskis 172 | The Wachowskis 180 | Jamie Clayton 374 | ||
1124 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | ||
1134 | 1134 | Sense8 208 | 2015 10 | Dolores Park, 20th St. between Church & Dolores St. | group of friends have a heated argument, then flashback of pre-argument | Unpronounceable Productions, LLC 131 | Netflix 53 | The Wachowskis 172 | The Wachowskis 180 | Jamie Clayton 374 | ||
1135 | 1135 | Sense8 208 | 2015 10 | Palace of Fine Arts: 3306 Lyon St. | Filming of "Dyke's on Bikes" and "Dyke March" | Unpronounceable Productions, LLC 131 | Netflix 53 | The Wachowskis 172 | The Wachowskis 180 | Jamie Clayton 374 | ||
1136 | 1136 | Sense8 208 | 2015 10 | Van Ness and 12th St. | A couple reminisces on the moment they first fell in love | Unpronounceable Productions, LLC 131 | Netflix 53 | The Wachowskis 172 | The Wachowskis 180 | Jamie Clayton 374 | ||
1137 | 1137 | Sense8 208 | 2015 10 | "Metzger's Apt" 151 Alice B. Toklas Pl. | Overnight scene involving aggressive arguments between actors, spfx shoot out involved | Unpronounceable Productions, LLC 131 | Netflix 53 | The Wachowskis 172 | The Wachowskis 180 | Jamie Clayton 374 | ||
1280 | 1280 | Swing 236 | 2003 38 | Broadway Studios (435 Broadway at Montgomery Street) | unlisted 143 | Crazy Dreams Entertainment 102 | Martin Guigui 194 | Mary Keil 206 | Constance Brenneman 392 | |||
1281 | 1281 | Swing 236 | 2003 38 | Regency Building (1290 Sutter Street) | unlisted 143 | Crazy Dreams Entertainment 102 | Martin Guigui 194 | Mary Keil 206 | Constance Brenneman 392 | |||
1327 | 1327 | The Bridge 244 | 2006 68 | 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. | Easy There Tiger Productions 148 | IFC Films 106 | Eric Steel 200 | John Snowden 395 | |||
1330 | 1330 | The Californians 246 | 2005 2 | Parker Film Company 149 | Fabrication Films 107 | Jonathan Parker 202 | Jonathan Parker & Catherine DiNapoli 213 | Noah Wyle 396 | ||||
1359 | 1359 | The Last of the Gladiators 251 | 1988 23 | Twin Tower Enterprises 152 | Evel Videos 108 | Martin Jay Sadoff 206 | Martin Jay Sadoff 218 | Evel Knievel 398 | ||||
1403 | 1403 | The Fog of War 257 | 2003 38 | Sony Pictures Classics 155 | Sony Pictures Classics 27 | Errol Morris 212 | Robert McNamara 403 | |||||
1546 | 1546 | Tweek City 294 | 2005 2 | Tweek City LLC 171 | Maverick Entertainment Group 116 | Eric G. Johnson 239 | Eric G. Johnson 254 | Giuseppe Andrews 429 | ||||
1558 | 1558 | Until the End of the World 296 | 1991 37 | Tosca Café (242 Columbus Avenue, North Beach) | Village Roadshow Pictures 172 | Warner Bros. Pictures 6 | Wim Wenders 241 | Wim Wenders 256 | Solveig Dommartin 430 | |||
1582 | 1582 | What the Bleep Do We Know 300 | 2004 5 | Golden Gate National Recreation Area | The size of the Recreation Area is over two and a half greater than that of the city and county of San Francisco. | Captured Light 175 | Samuel Goldwyn Films 118 | William Arntz 244 | William Arntz & Betsy Chasse 260 | Marlee Matlin 433 | ||
1620 | 1620 | Woman on Top 305 | 2000 25 | 312 Fillmore Street | Fox Searchlight Pictures 178 | Fox Searchlight Pictures 24 | Fina Torres 248 | Vera Blasi 264 | Penelope Cruz 436 | |||
1 | 1 | 180 1 | 2011 1 | Epic Roasthouse (399 Embarcadero) | SPI Cinemas 1 | Jayendra 1 | Umarji Anuradha, Jayendra, Aarthi Sriram, & Suba 1 | Siddarth 237 | Nithya Menon 1 | Priya Anand 439 | ||
2 | 2 | 180 1 | 2011 1 | Mason & California Streets (Nob Hill) | SPI Cinemas 1 | Jayendra 1 | Umarji Anuradha, Jayendra, Aarthi Sriram, & Suba 1 | Siddarth 237 | Nithya Menon 1 | Priya Anand 439 | ||
3 | 3 | 180 1 | 2011 1 | Justin Herman Plaza | SPI Cinemas 1 | Jayendra 1 | Umarji Anuradha, Jayendra, Aarthi Sriram, & Suba 1 | Siddarth 237 | Nithya Menon 1 | Priya Anand 439 | ||
4 | 4 | 180 1 | 2011 1 | 200 block Market Street | SPI Cinemas 1 | Jayendra 1 | Umarji Anuradha, Jayendra, Aarthi Sriram, & Suba 1 | Siddarth 237 | Nithya Menon 1 | Priya Anand 439 | ||
5 | 5 | 180 1 | 2011 1 | City Hall | SPI Cinemas 1 | Jayendra 1 | Umarji Anuradha, Jayendra, Aarthi Sriram, & Suba 1 | Siddarth 237 | Nithya Menon 1 | Priya Anand 439 | ||
6 | 6 | 180 1 | 2011 1 | Polk & Larkin Streets | SPI Cinemas 1 | Jayendra 1 | Umarji Anuradha, Jayendra, Aarthi Sriram, & Suba 1 | Siddarth 237 | Nithya Menon 1 | Priya Anand 439 | ||
7 | 7 | 180 1 | 2011 1 | Randall Museum | SPI Cinemas 1 | Jayendra 1 | Umarji Anuradha, Jayendra, Aarthi Sriram, & Suba 1 | Siddarth 237 | Nithya Menon 1 | Priya Anand 439 |
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");