Film_Locations_in_San_Francisco

Data source: data.sfgov.org

1,622 rows

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
101 Basic Instinct 27 1992 22 Tosca Café (242 Columbus Avenue)   Carolco Pictures 24 TriStar Pictures 20 Paul Verhoeven 25 Joe Eszterhas 24 Michael Douglas 245 Sharon Stone 23 George Dzundza 449
102 Basic Instinct 27 1992 22 Steinhart Aquarium (California Academy of Sciences, Golden Gate Park) The Steinhart Aquarium is home to over 38,000 animals, which represent more than 900 species. Carolco Pictures 24 TriStar Pictures 20 Paul Verhoeven 25 Joe Eszterhas 24 Michael Douglas 245 Sharon Stone 23 George Dzundza 449
103 Basic Instinct 27 1992 22 Raw Hide II (280 Seventh Street)   Carolco Pictures 24 TriStar Pictures 20 Paul Verhoeven 25 Joe Eszterhas 24 Michael Douglas 245 Sharon Stone 23 George Dzundza 449
104 Basic Instinct 27 1992 22 Pier 7 (The Embarcadero)   Carolco Pictures 24 TriStar Pictures 20 Paul Verhoeven 25 Joe Eszterhas 24 Michael Douglas 245 Sharon Stone 23 George Dzundza 449
105 Basic Instinct 27 1992 22 Kearney Street (Telegraph Hill)   Carolco Pictures 24 TriStar Pictures 20 Paul Verhoeven 25 Joe Eszterhas 24 Michael Douglas 245 Sharon Stone 23 George Dzundza 449
106 Big Eyes 28 2014 11 Nobles Alley   Blink & Wink Productions 25 Weinstein Company 21 Tim Burton 26 Scott Alexander 25 Amy Adams 260 Krysten Ritter 24 Christoph Waltz 450
107 Basic Instinct 27 1992 22 Hall of Justice (850 Bryant Street)   Carolco Pictures 24 TriStar Pictures 20 Paul Verhoeven 25 Joe Eszterhas 24 Michael Douglas 245 Sharon Stone 23 George Dzundza 449
108 Basic Instinct 27 1992 22 2930 Vallejo Street   Carolco Pictures 24 TriStar Pictures 20 Paul Verhoeven 25 Joe Eszterhas 24 Michael Douglas 245 Sharon Stone 23 George Dzundza 449
109 Basic Instinct 27 1992 22 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. Carolco Pictures 24 TriStar Pictures 20 Paul Verhoeven 25 Joe Eszterhas 24 Michael Douglas 245 Sharon Stone 23 George Dzundza 449
110 Basic Instinct 27 1992 22 Gibb Street (Chinatown)   Carolco Pictures 24 TriStar Pictures 20 Paul Verhoeven 25 Joe Eszterhas 24 Michael Douglas 245 Sharon Stone 23 George Dzundza 449
111 Basic Instinct 27 1992 22 1158-70 Montgomery Street   Carolco Pictures 24 TriStar Pictures 20 Paul Verhoeven 25 Joe Eszterhas 24 Michael Douglas 245 Sharon Stone 23 George Dzundza 449
112 Basic Instinct 27 1992 22 2104 Broadway   Carolco Pictures 24 TriStar Pictures 20 Paul Verhoeven 25 Joe Eszterhas 24 Michael Douglas 245 Sharon Stone 23 George Dzundza 449
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
114 Beautiful Boy 30 2018 24 Divisadero between Broadway and Greenwich   Big Indie Pictures 27 Amazon Studios 23 Felix van Groeningen 28 Luke Davies 27 Steve Carell 262 Timothee Chalamet 26 Maura Tierney 452
115 Beautiful Boy 30 2018 24 Ohloff Recovery Center (601 Steiner St)   Big Indie Pictures 27 Amazon Studios 23 Felix van Groeningen 28 Luke Davies 27 Steve Carell 262 Timothee Chalamet 26 Maura Tierney 452
116 Beautiful Boy 30 2018 24 Haight at Masonic   Big Indie Pictures 27 Amazon Studios 23 Felix van Groeningen 28 Luke Davies 27 Steve Carell 262 Timothee Chalamet 26 Maura Tierney 452
117 Beautiful Boy 30 2018 24 Tenderloin Neighborhood   Big Indie Pictures 27 Amazon Studios 23 Felix van Groeningen 28 Luke Davies 27 Steve Carell 262 Timothee Chalamet 26 Maura Tierney 452
118 Beautiful Boy 30 2018 24 Olympic Flame Café, 555 Geary St   Big Indie Pictures 27 Amazon Studios 23 Felix van Groeningen 28 Luke Davies 27 Steve Carell 262 Timothee Chalamet 26 Maura Tierney 452
119 Beautiful Boy 30 2018 24 18th St at San Bruno Ave.   Big Indie Pictures 27 Amazon Studios 23 Felix van Groeningen 28 Luke Davies 27 Steve Carell 262 Timothee Chalamet 26 Maura Tierney 452
120 Beautiful Boy 30 2018 24 Wisconsin between 19th and 20th St   Big Indie Pictures 27 Amazon Studios 23 Felix van Groeningen 28 Luke Davies 27 Steve Carell 262 Timothee Chalamet 26 Maura Tierney 452
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 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 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 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 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  
126 Bee Season 32 2005 2     Bee Season Productions 28 Fox Searchlight Pictures 24 Scott McGehee 30 David Siegel 29 Richard Gere 264 Juliette Binoche 28  
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 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 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 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 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    
132 Big Eyes 28 2014 11 Caffe Trieste   Blink & Wink Productions 25 Weinstein Company 21 Tim Burton 26 Scott Alexander 25 Amy Adams 260 Krysten Ritter 24 Christoph Waltz 450
133 Big Eyes 28 2014 11 Palace of Fine Arts   Blink & Wink Productions 25 Weinstein Company 21 Tim Burton 26 Scott Alexander 25 Amy Adams 260 Krysten Ritter 24 Christoph Waltz 450
134 Big Eyes 28 2014 11 1101 Filbert St.   Blink & Wink Productions 25 Weinstein Company 21 Tim Burton 26 Scott Alexander 25 Amy Adams 260 Krysten Ritter 24 Christoph Waltz 450
135 Big Eyes 28 2014 11 Saints Peter & Paul Church   Blink & Wink Productions 25 Weinstein Company 21 Tim Burton 26 Scott Alexander 25 Amy Adams 260 Krysten Ritter 24 Christoph Waltz 450
136 Big Eyes 28 2014 11 Green St. & Grant Ave.   Blink & Wink Productions 25 Weinstein Company 21 Tim Burton 26 Scott Alexander 25 Amy Adams 260 Krysten Ritter 24 Christoph Waltz 450
137 Big Eyes 28 2014 11 Filbert St. & Leavenworth   Blink & Wink Productions 25 Weinstein Company 21 Tim Burton 26 Scott Alexander 25 Amy Adams 260 Krysten Ritter 24 Christoph Waltz 450
138 Big Eyes 28 2014 11 Pine St. & Grant   Blink & Wink Productions 25 Weinstein Company 21 Tim Burton 26 Scott Alexander 25 Amy Adams 260 Krysten Ritter 24 Christoph Waltz 450
139 Big Eyes 28 2014 11 Way Faire Inn on Leidesdorff   Blink & Wink Productions 25 Weinstein Company 21 Tim Burton 26 Scott Alexander 25 Amy Adams 260 Krysten Ritter 24 Christoph Waltz 450
140 Big Eyes 28 2014 11 Harry's Bar on Fillmore   Blink & Wink Productions 25 Weinstein Company 21 Tim Burton 26 Scott Alexander 25 Amy Adams 260 Krysten Ritter 24 Christoph Waltz 450
141 Big Sur 34 2013 27 Tosca Café (242 Columbus Avenue, North Beach)   3311 Productions 30   Michael Polish 32 Jack Kerouac & Michael Polish 31 Josh Lucas 266 Kate Bosworth 29 Stana Katic 453
142 Big Trouble in Little China 35 1986 28     Twentieth Century Fox Film Corporation 13 Twentieth Century Fox Film Corporation 12 John Carpenter 33 Gary Goldman 32 Kurt Russell 267 Kim Catrall 30 James Hong 454
143 Birdman of Alcatraz 36 1962 29 Alcatraz Island Alcatraz Island was a military fort before it became a prison. Norma Productions 31 United Artists 19 John Frankenheimer 34 Guy Trosper 33 Burt Lancaster 268 Karl Maden 31 Thelma Ritter 455
144 Birdman of Alcatraz 36 1962 29 Pier 43 1/2   Norma Productions 31 United Artists 19 John Frankenheimer 34 Guy Trosper 33 Burt Lancaster 268 Karl Maden 31 Thelma Ritter 455
145 Birth of the Dragon 37 2016 30 Lands End Trail at Eagles Point/ Lincoln Park Golf Course The character of Steve McKee was based on actor Steve McQueen who studied with Bruce Lee in the later 60's. BOTD U.S. Productions, Inc. 32 Kylin Pictures 26 George Nolfi  35 Christopher Wilkinson, Stephen J. Rivele 34 Philip Ng 269 Billy Magnussen 32 Yu Xia 456
146 Birth of the Dragon 37 2016 30 Pier 45 - Jeremiah O'Brien Liberty Ship The SS Jeremiah O'Brien is a rare survivor of the invasion at Normandy on D-Day in WWII. BOTD U.S. Productions, Inc. 32 Kylin Pictures 26 George Nolfi  35 Christopher Wilkinson, Stephen J. Rivele 34 Philip Ng 269 Billy Magnussen 32 Yu Xia 456
147 Birth of the Dragon 37 2016 30 Leavenworth at Green   BOTD U.S. Productions, Inc. 32 Kylin Pictures 26 George Nolfi  35 Christopher Wilkinson, Stephen J. Rivele 34 Philip Ng 269 Billy Magnussen 32 Yu Xia 456
148 Birth of the Dragon 37 2016 30 Leavenworth at Union   BOTD U.S. Productions, Inc. 32 Kylin Pictures 26 George Nolfi  35 Christopher Wilkinson, Stephen J. Rivele 34 Philip Ng 269 Billy Magnussen 32 Yu Xia 456
149 Birth of the Dragon 37 2016 30 Hyde at Union   BOTD U.S. Productions, Inc. 32 Kylin Pictures 26 George Nolfi  35 Christopher Wilkinson, Stephen J. Rivele 34 Philip Ng 269 Billy Magnussen 32 Yu Xia 456
150 Birth of the Dragon 37 2016 30 California at Grant   BOTD U.S. Productions, Inc. 32 Kylin Pictures 26 George Nolfi  35 Christopher Wilkinson, Stephen J. Rivele 34 Philip Ng 269 Billy Magnussen 32 Yu Xia 456
151 Birth of the Dragon 37 2016 30 Grant between Bush and Broadway   BOTD U.S. Productions, Inc. 32 Kylin Pictures 26 George Nolfi  35 Christopher Wilkinson, Stephen J. Rivele 34 Philip Ng 269 Billy Magnussen 32 Yu Xia 456
152 Birth of the Dragon 37 2016 30 California at Mason   BOTD U.S. Productions, Inc. 32 Kylin Pictures 26 George Nolfi  35 Christopher Wilkinson, Stephen J. Rivele 34 Philip Ng 269 Billy Magnussen 32 Yu Xia 456
153 Birth of the Dragon 37 2016 30 Spofford between Clay and Washington   BOTD U.S. Productions, Inc. 32 Kylin Pictures 26 George Nolfi  35 Christopher Wilkinson, Stephen J. Rivele 34 Philip Ng 269 Billy Magnussen 32 Yu Xia 456
154 Birth of the Dragon 37 2016 30 Twin Peaks Blvd.   BOTD U.S. Productions, Inc. 32 Kylin Pictures 26 George Nolfi  35 Christopher Wilkinson, Stephen J. Rivele 34 Philip Ng 269 Billy Magnussen 32 Yu Xia 456
155 Birth of the Dragon 37 2016 30 Waverly Pl between Washington and Sacramento   BOTD U.S. Productions, Inc. 32 Kylin Pictures 26 George Nolfi  35 Christopher Wilkinson, Stephen J. Rivele 34 Philip Ng 269 Billy Magnussen 32 Yu Xia 456
156 Blue Jasmine 38 2013 27 Jones & Pacific   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
157 Blue Jasmine 38 2013 27 Pacific & Divisadero   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
158 Blue Jasmine 38 2013 27 Lombard & Hyde   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
159 Blue Jasmine 38 2013 27 5546 Geary Ave   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
160 Blue Jasmine 38 2013 27 2898 Broadway   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
161 Blue Jasmine 38 2013 27 Motel Capri   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
162 Blue Jasmine 38 2013 27 Marina Green   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
163 Blue Jasmine 38 2013 27 Ocean Beach at Lincoln   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
164 Blue Jasmine 38 2013 27 Heald College   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
165 Blue Jasmine 38 2013 27 Marina Blvd from Laguna to Baker   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
166 Blue Jasmine 38 2013 27 330 Santa Clara Ave.   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
167 Blue Jasmine 38 2013 27 200 Post St.   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
168 Blue Jasmine 38 2013 27 2179 48th Ave   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
169 Blue Jasmine 38 2013 27 The Ramp Restaurant   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
170 Blue Jasmine 38 2013 27 303-305 S. Van Ness   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
171 Blue Jasmine 38 2013 27 3563 20th St.   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
172 Blue Jasmine 38 2013 27 Taylor & Green St.   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
173 Blue Jasmine 38 2013 27 Grant & Washington St.   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
174 Blue Jasmine 38 2013 27 2934 24th St.   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
175 Blue Jasmine 38 2013 27 1138 Alabama St   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
176 Blue Jasmine 38 2013 27 South Park   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
177 Blue Jasmine 38 2013 27 2915 16th St.   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
178 Blue Jasmine 38 2013 27 Trolley Car from Market and 11th   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
179 Blue Jasmine 38 2013 27 Real Guitars   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
180 Blue Jasmine 38 2013 27 Aub Zam Zam Bar   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
181 Blue Jasmine 38 2013 27 790 Ulloa   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
182 Blue Jasmine 38 2013 27 SFO International Airport Terminal 3   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
183 Blue Jasmine 38 2013 27 2178 Palou Ave.   Perdido Productions 33 Sony Pictures Classics 27 Woody Allen 36 Woody Allen 35 Cate Blanchett 270 Alec Baldwin 33 Peter Sarsgaard 457
184 Boys and Girls 39 2000 25 1122 Folsom Street   Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
185 Boys and Girls 39 2000 25 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. Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
186 Boys and Girls 39 2000 25 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. Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
187 Boys and Girls 39 2000 25 Fisherman's Wharf Supposedly, Mikhail S. Gorbachev has said that his favorite part of visiting America was touring Fisherman's Wharf. Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
188 Boys and Girls 39 2000 25 Ferry Building Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
189 Boys and Girls 39 2000 25 Coit Tower The Tower was funded by a gift bequeathed by Lillie Hitchcock Coit, a socialite who reportedly liked to chase fires. Though the tower resembles a firehose nozzle, it was not designed this way. Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
190 Boys and Girls 39 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. Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
191 Boys and Girls 39 2000 25 Lombard Street Lombard Street is not actually the most crooked in SF. That honor goes to Potrero Hill's Vermont Street between 22nd and 23rd. Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
192 Boys and Girls 39 2000 25 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
193 Boys and Girls 39 2000 25 Aquatic Park (Jefferson Street) Located at one end of Fisherman's Wharf, Aquatic Park was built as part of FDR's Works Progress Administration Project. Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
194 Boys and Girls 39 2000 25 Alcatraz Island Alcatraz Island was a military fort before it became a prison. Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
195 Boys and Girls 39 2000 25 628 Cole Street   Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
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 Broken-A Modern Love Story  40 2010 19 0-100 block Halleck Street   RKW Films 35   Ryan K. Whiting 38 Ryan K. Whiting 37      
198 Budding Prospects, Pilot 41 2017 20 3050 24th Street   Picrow Streaming Inc. 36 Amazon  29 Terry Zwigoff 39 Melissa Axelrod, T. C. Boyle (based on the book by) 38 Adam Rose 272 Will Sasso 35 Joel David Moore 458
199 Budding Prospects, Pilot 41 2017 20 3033 24th Street   Picrow Streaming Inc. 36 Amazon  29 Terry Zwigoff 39 Melissa Axelrod, T. C. Boyle (based on the book by) 38 Adam Rose 272 Will Sasso 35 Joel David Moore 458
200 Budding Prospects, Pilot 41 2017 20 2937 24th Street   Picrow Streaming Inc. 36 Amazon  29 Terry Zwigoff 39 Melissa Axelrod, T. C. Boyle (based on the book by) 38 Adam Rose 272 Will Sasso 35 Joel David Moore 458

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.068ms · Data source: data.sfgov.org