sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTitleRelease YearLocationsFun FactsProduction CompanyDistributorDirectorWriterActor 1Actor 2Actor 3
101 27 22 Tosca Café (242 Columbus Avenue)   24 20 25 24 245 23 449
102 27 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. 24 20 25 24 245 23 449
103 27 22 Raw Hide II (280 Seventh Street)   24 20 25 24 245 23 449
104 27 22 Pier 7 (The Embarcadero)   24 20 25 24 245 23 449
105 27 22 Kearney Street (Telegraph Hill)   24 20 25 24 245 23 449
106 28 11 Nobles Alley   25 21 26 25 260 24 450
107 27 22 Hall of Justice (850 Bryant Street)   24 20 25 24 245 23 449
108 27 22 2930 Vallejo Street   24 20 25 24 245 23 449
109 27 22 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. 24 20 25 24 245 23 449
110 27 22 Gibb Street (Chinatown)   24 20 25 24 245 23 449
111 27 22 1158-70 Montgomery Street   24 20 25 24 245 23 449
112 27 22 2104 Broadway   24 20 25 24 245 23 449
113 29 23     26 22 27 26 261 25 451
114 30 24 Divisadero between Broadway and Greenwich   27 23 28 27 262 26 452
115 30 24 Ohloff Recovery Center (601 Steiner St)   27 23 28 27 262 26 452
116 30 24 Haight at Masonic   27 23 28 27 262 26 452
117 30 24 Tenderloin Neighborhood   27 23 28 27 262 26 452
118 30 24 Olympic Flame Café, 555 Geary St   27 23 28 27 262 26 452
119 30 24 18th St at San Bruno Ave.   27 23 28 27 262 26 452
120 30 24 Wisconsin between 19th and 20th St   27 23 28 27 262 26 452
121 31 25 1155 Filbert Street at Hyde   14 13 29 28 263 27  
122 31 25 Washington Square Park (Filbert, between Stockton and Powell)   14 13 29 28 263 27  
123 31 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. 14 13 29 28 263 27  
124 31 25 Montgomery & Market Streets   14 13 29 28 263 27  
125 31 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. 14 13 29 28 263 27  
126 32 2     28 24 30 29 264 28  
127 33 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. 29 25 31 30 265    
128 33 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. 29 25 31 30 265    
129 33 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. 29 25 31 30 265    
130 33 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. 29 25 31 30 265    
131 33 26 Grace Cathedral Episcopal Church (1100 California Street) Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. 29 25 31 30 265    
132 28 11 Caffe Trieste   25 21 26 25 260 24 450
133 28 11 Palace of Fine Arts   25 21 26 25 260 24 450
134 28 11 1101 Filbert St.   25 21 26 25 260 24 450
135 28 11 Saints Peter & Paul Church   25 21 26 25 260 24 450
136 28 11 Green St. & Grant Ave.   25 21 26 25 260 24 450
137 28 11 Filbert St. & Leavenworth   25 21 26 25 260 24 450
138 28 11 Pine St. & Grant   25 21 26 25 260 24 450
139 28 11 Way Faire Inn on Leidesdorff   25 21 26 25 260 24 450
140 28 11 Harry's Bar on Fillmore   25 21 26 25 260 24 450
141 34 27 Tosca Café (242 Columbus Avenue, North Beach)   30   32 31 266 29 453
142 35 28     13 12 33 32 267 30 454
143 36 29 Alcatraz Island Alcatraz Island was a military fort before it became a prison. 31 19 34 33 268 31 455
144 36 29 Pier 43 1/2   31 19 34 33 268 31 455
145 37 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. 32 26 35 34 269 32 456
146 37 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. 32 26 35 34 269 32 456
147 37 30 Leavenworth at Green   32 26 35 34 269 32 456
148 37 30 Leavenworth at Union   32 26 35 34 269 32 456
149 37 30 Hyde at Union   32 26 35 34 269 32 456
150 37 30 California at Grant   32 26 35 34 269 32 456
151 37 30 Grant between Bush and Broadway   32 26 35 34 269 32 456
152 37 30 California at Mason   32 26 35 34 269 32 456
153 37 30 Spofford between Clay and Washington   32 26 35 34 269 32 456
154 37 30 Twin Peaks Blvd.   32 26 35 34 269 32 456
155 37 30 Waverly Pl between Washington and Sacramento   32 26 35 34 269 32 456
156 38 27 Jones & Pacific   33 27 36 35 270 33 457
157 38 27 Pacific & Divisadero   33 27 36 35 270 33 457
158 38 27 Lombard & Hyde   33 27 36 35 270 33 457
159 38 27 5546 Geary Ave   33 27 36 35 270 33 457
160 38 27 2898 Broadway   33 27 36 35 270 33 457
161 38 27 Motel Capri   33 27 36 35 270 33 457
162 38 27 Marina Green   33 27 36 35 270 33 457
163 38 27 Ocean Beach at Lincoln   33 27 36 35 270 33 457
164 38 27 Heald College   33 27 36 35 270 33 457
165 38 27 Marina Blvd from Laguna to Baker   33 27 36 35 270 33 457
166 38 27 330 Santa Clara Ave.   33 27 36 35 270 33 457
167 38 27 200 Post St.   33 27 36 35 270 33 457
168 38 27 2179 48th Ave   33 27 36 35 270 33 457
169 38 27 The Ramp Restaurant   33 27 36 35 270 33 457
170 38 27 303-305 S. Van Ness   33 27 36 35 270 33 457
171 38 27 3563 20th St.   33 27 36 35 270 33 457
172 38 27 Taylor & Green St.   33 27 36 35 270 33 457
173 38 27 Grant & Washington St.   33 27 36 35 270 33 457
174 38 27 2934 24th St.   33 27 36 35 270 33 457
175 38 27 1138 Alabama St   33 27 36 35 270 33 457
176 38 27 South Park   33 27 36 35 270 33 457
177 38 27 2915 16th St.   33 27 36 35 270 33 457
178 38 27 Trolley Car from Market and 11th   33 27 36 35 270 33 457
179 38 27 Real Guitars   33 27 36 35 270 33 457
180 38 27 Aub Zam Zam Bar   33 27 36 35 270 33 457
181 38 27 790 Ulloa   33 27 36 35 270 33 457
182 38 27 SFO International Airport Terminal 3   33 27 36 35 270 33 457
183 38 27 2178 Palou Ave.   33 27 36 35 270 33 457
184 39 25 1122 Folsom Street   34 28 37 36 271 34  
185 39 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. 34 28 37 36 271 34  
186 39 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. 34 28 37 36 271 34  
187 39 25 Fisherman's Wharf Supposedly, Mikhail S. Gorbachev has said that his favorite part of visiting America was touring Fisherman's Wharf. 34 28 37 36 271 34  
188 39 25 Ferry Building Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. 34 28 37 36 271 34  
189 39 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. 34 28 37 36 271 34  
190 39 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. 34 28 37 36 271 34  
191 39 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. 34 28 37 36 271 34  
192 39 25 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. 34 28 37 36 271 34  
193 39 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. 34 28 37 36 271 34  
194 39 25 Alcatraz Island Alcatraz Island was a military fort before it became a prison. 34 28 37 36 271 34  
195 39 25 628 Cole Street   34 28 37 36 271 34  
196 40 19 Ina Coolbrith Park (1700 Taylor Street)   35   38 37      
197 40 19 0-100 block Halleck Street   35   38 37      
198 41 20 3050 24th Street   36 29 39 38 272 35 458
199 41 20 3033 24th Street   36 29 39 38 272 35 458
200 41 20 2937 24th Street   36 29 39 38 272 35 458
201 41 20 1167 Alabama Street   36 29 39 38 272 35 458
Powered by Datasette · Query took 1.475ms · Data source: data.sfgov.org