sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

rowidTitleRelease YearLocationsFun FactsProduction CompanyDistributorDirectorWriterActor 1Actor 2Actor 3
1146 210 30 Billy Goat Hill, Castro St. & 30th St. This park was the location of a popular swing with great views of the City. 131 53 173 182 374 126 514
1147 210 30 The Castro Theater, 429 Castro St. The theater has an organ which is played before every film showing. 131 53 173 182 374 126 514
1140 210 30 The Women's Building, 3543 18th St. The mural painted outside the building was painted by 7 women artists including Juana Alicia, Miranda Bergman and Meera Desai. The computer lab scene was filmed inside the building. 131 53 173 182 374 126 514
332 59 30 850 Bryant- 6th floor County Jail The former County Jail on the 6th floor was re-created to resemble a Mexican jail for the scene 43 34 54 51 280 42 463
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
785 149 30 Van Ness and Market Street MUNI exit The character of Doris was originally a recurring role, but everyone on the team liked Lauren Weedman's performance so much that she became a full time regular during the second season. 101 18 136 137 339 123 496
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
305 54 30 Palace of Fine Arts The Palace of Fine Arts was designed by Bernard Maybeck and was originally constructed for the 1915 Panama-Pacific Exposition.  It has been in films such as Time After Time, The Room, Twisted, So I Married An Axe Murderer and The Rock. 43 34 49 50 280 42 463
325 57 30 Fairmont Hotel The Fairmont Hotel was featured in many films, including The Rock and the TV series Hotel 43 34 52 53 280 42 463
778 149 30 Capital Restaurant, 839 Clay Street Russell Tovey originally auditioned for the role of Patrick, but was unsuccessful. After the show got picked up, the character of Kevin was written with him in mind. 101 18 136 137 339 123 496
1036 74 30 Blind Cat, 3050 24th Street, San Francisco Pushing Dead won the Audience Award for Frameline San Francisco International LGBTQ Film Festival 2016 56 43 68 67 291 56 467
1143 210 30 Grace Cathedral, 1100 California St. Martin Luther King, Jr. gave a sermon at the cathedral to celebrate the completion and consecration of the church in 1964. 131 53 173 182 374 126 514
1144 210 30 San Francisco City Hall, 1 Dr. Carlton B. Goodlett Pl. Many films have shot scene in and around the building including Raiders of the Lost Ark, Invasion of the Body Snatchers, Dirty Harry, The Towering Inferno, A View to a Kill and most recently, Milk. The Christmas party scene for this show was shot in the Rotunda. 131 53 173 182 374 126 514
781 149 30 Li Po Lounge, 916 Grant Avenue Li Po Cocktail Lounge was one of the Top 10 Dive Bars in San Francisco in 2011 by SF Weekly 101 18 136 137 339 123 496
794 149 30 Bernal Heights Neighborhood Jake Shears, lead singer of the band Scissor Sisters, auditioned for the role of Dom. 101 18 136 137 339 123 496
1138 210 30 Westerfeld House, 1198 Fulton St. In the 1940's, the house became a 14-unit apartment building that housed jazz musicians including John Handy. This location serves as the hideout for the San Francisco-based character Nomi. 131 53 173 182 374 126 514
1145 210 30 City Lights Bookstore, 261 Columbus Ave. Howl and Other Poems by Allen Ginsberg was published in 1956 by City Lights after poet and founder Laurence Ferlinghetti heard Ginsberg read it in 1955. 131 53 173 182 374 126 514
313 55 30 Treasure Island From the late 1980s, Treasure Island's old aircraft Hangar 2 (Building 2) and Hangar 3 (Building 3) served as sound stages for film-making and TV, including  Rent, The Pursuit of Happyness, Flubber, What Dreams May Come, Patch Adams, The Parent Trap, Bicentennial Man and the TV series Trauma. 43 34 50 51 280 42 463
1141 210 30 Julia Morgan Ballroom at the Merchant's Exchange Building, 465 California St. An extremely popular location for weddings, the namesake of the ballroom was an architect most famous for her work on Hearst Castle. 131 53 173 182 374 126 514
294 53 30 Forrest Hill Muni Station A Muni station agent played himself in this scene. 43 34 3 49 280 42 463
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
255 49 30 Maiden Lane between Kearny and Grant   43 34 47 46 280 42 463
256 49 30 The Drew School, 2901 California   43 34 47 46 280 42 463
257 49 30 State Garage, 818 Leavenworth   43 34 47 46 280 42 463
258 49 30 60 Leavenworth St.   43 34 47 46 280 42 463
259 50 30 Harvey Milk Rec Center, 50 Scott St.   43 34 48 47 280 42 463
260 50 30 66 Potomac   43 34 48 47 280 42 463
261 50 30 Mario's Café, 566 Columbus   43 34 48 47 280 42 463
262 50 30 Washington Square Park   43 34 48 47 280 42 463
263 50 30 William Stout Architectural Books, 804 Montgomery St.   43 34 48 47 280 42 463
264 50 30 1055 Montgomery St.   43 34 48 47 280 42 463
265 50 30 60 Leavenworth St.   43 34 48 47 280 42 463
266 50 30 Jefferson Square Park   43 34 48 47 280 42 463
267 50 30 UN Plaza/ Civic Center Bart steps   43 34 48 47 280 42 463
268 50 30 940 Powell St.   43 34 48 47 280 42 463
269 50 30 Ellis and Jones St.   43 34 48 47 280 42 463
270 50 30 Ellis Food Center, 398 Ellis   43 34 48 47 280 42 463
271 50 30 Jonell's Bar, 401 Ellis   43 34 48 47 280 42 463
272 50 30 State Garage, 818 Leavenworth   43 34 48 47 280 42 463
273 50 30 Antonio Alley   43 34 48 47 280 42 463
274 50 30 253 4th Ave.   43 34 48 47 280 42 463
275 50 30 Warren's Antiques, 375 9th St.   43 34 48 47 280 42 463
276 51 30 Private alley along 20th St. between Tennessee and Minnesota   43 34 47 46 280 42 463
277 52 30 Mason and Pacific   43 34 48 48 280 42 463
278 52 30 John St. between Powell and Mason   43 34 48 48 280 42 463
279 52 30 Westin St. Francis   43 34 48 48 280 42 463
280 52 30 Betelnut restaurant, 2030 Union St.   43 34 48 48 280 42 463
281 52 30 Sutter Stockton Garage, 444 Stockton   43 34 48 48 280 42 463
282 52 30 YWCA, 940 Powell   43 34 48 48 280 42 463
283 52 30 Warren's Antiques, 375 9th St.   43 34 48 48 280 42 463
284 52 30 Heron and Berwick Alleys   43 34 48 48 280 42 463
285 52 30 Duboce St., Duboce Café   43 34 48 48 280 42 463
286 52 30 Potomac and Waller   43 34 48 48 280 42 463
287 52 30 State Garage, 818 Leavenworth   43 34 48 48 280 42 463
288 53 30 60 Leavenworth St.   43 34 3 49 280 42 463
289 53 30 Blue Danube Café, 306 Clement   43 34 3 49 280 42 463
290 53 30 San Francisco Art Institute, 800 Chestnut   43 34 3 49 280 42 463
291 53 30 Laguna Honda Hospital   43 34 3 49 280 42 463
292 53 30 350 Santa Ana Ave.   43 34 3 49 280 42 463
293 53 30 878-898 Chestnut St.   43 34 3 49 280 42 463
295 53 30 60 Potomac   43 34 3 49 280 42 463
296 53 30 The Drew School, 2901 California   43 34 3 49 280 42 463
297 53 30 San Bruno and Alameda   43 34 3 49 280 42 463
298 53 30 17th and Arkansas   43 34 3 49 280 42 463
299 54 30 Bush and Sansome St.   43 34 49 50 280 42 463
300 54 30 Bayview Police Station, 201 Williams Ave.   43 34 49 50 280 42 463
301 54 30 Miraloma Mall at Portola Frontage Road   43 34 49 50 280 42 463
302 54 30 1018 Tennessee St.   43 34 49 50 280 42 463
303 54 30 901/909Tennessee St.   43 34 49 50 280 42 463
304 54 30 11 San Jacinto Ave.   43 34 49 50 280 42 463
306 54 30 Agua Vista Park at Mission Rock, 817 Terry A Francois Blvd.   43 34 49 50 280 42 463
307 54 30 200 Kansas St.   43 34 49 50 280 42 463
308 54 30 15th St. between Vermont and Kansas   43 34 49 50 280 42 463
309 55 30 Washington Square Park   43 34 50 51 280 42 463
310 55 30 Grant between Union and Green   43 34 50 51 280 42 463
311 55 30 60 Leavenworth St.   43 34 50 51 280 42 463
312 55 30 Montgomery between Pacific and Broadway   43 34 50 51 280 42 463
314 55 30 2 Rowland   43 34 50 51 280 42 463
315 55 30 McAllister between Leavenworth and Hyde   43 34 50 51 280 42 463
316 56 30 Punjab Café, 838 24th St.   43 34 51 52 280 42 463
317 56 30 60 Potomac   43 34 51 52 280 42 463
318 56 30 Buena Vista betweeen Upper Terrace and Java St.   43 34 51 52 280 42 463
319 56 30 157 Commonwealth   43 34 51 52 280 42 463
320 56 30 1461 Page St.   43 34 51 52 280 42 463
321 56 30 1958 Valencia St.   43 34 51 52 280 42 463
322 56 30 145 Barlett St.   43 34 51 52 280 42 463
323 57 30 Huntington Park   43 34 52 53 280 42 463
326 57 30 1000 Mason St.   43 34 52 53 280 42 463
327 57 30 St. Mary's Square Park   43 34 52 53 280 42 463
328 59 30 Terry A. Francois Blvd.   43 34 54 51 280 42 463
329 59 30 2 Rowland   43 34 54 51 280 42 463
330 59 30 Ocean Park Motel   43 34 54 51 280 42 463
331 59 30 Cliffhouse, 1090 Point Lobos Ave.   43 34 54 51 280 42 463
Powered by Datasette · Query took 2.196ms · Data source: data.sfgov.org