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
336 60 30 1 Urbano   43 34 51 52 280 42 463
326 57 30 1000 Mason St.   43 34 52 53 280 42 463
302 54 30 1018 Tennessee St.   43 34 49 50 280 42 463
264 50 30 1055 Montgomery St.   43 34 48 47 280 42 463
897 74 30 1069 Tennessee Street   56 43 68 67 291 56 467
779 149 30 1080 Natoma Street   101 18 136 137 339 123 496
786 149 30 10th Street between Market & Mission   101 18 136 137 339 123 496
304 54 30 11 San Jacinto Ave.   43 34 49 50 280 42 463
780 149 30 1246 Folsom Street   101 18 136 137 339 123 496
322 56 30 145 Barlett St.   43 34 51 52 280 42 463
320 56 30 1461 Page St.   43 34 51 52 280 42 463
319 56 30 157 Commonwealth   43 34 51 52 280 42 463
308 54 30 15th St. between Vermont and Kansas   43 34 49 50 280 42 463
792 149 30 17th & Market Street   101 18 136 137 339 123 496
298 53 30 17th and Arkansas   43 34 3 49 280 42 463
337 60 30 18 Urbano   43 34 51 52 280 42 463
335 60 30 1901 Ocean Ave. at Ashton Ave.   43 34 51 52 280 42 463
321 56 30 1958 Valencia St.   43 34 51 52 280 42 463
314 55 30 2 Rowland   43 34 50 51 280 42 463
329 59 30 2 Rowland   43 34 54 51 280 42 463
307 54 30 200 Kansas St.   43 34 49 50 280 42 463
274 50 30 253 4th Ave.   43 34 48 47 280 42 463
969 173 30 2633 Vallejo Street   108 69 146 150 103 131 502
404 74 30 2930 3rd Street   56 43 68 67 291 56 467
795 149 30 3079 16th Street   101 18 136 137 339 123 496
292 53 30 350 Santa Ana Ave.   43 34 3 49 280 42 463
1040 74 30 42 Walter Street   56 43 68 67 291 56 467
1045 74 30 433 Baker Street,   56 43 68 67 291 56 467
957 173 30 500 Grove Street   108 69 146 150 103 131 502
959 173 30 535 Octavia Street   108 69 146 150 103 131 502
1050 74 30 5th Ave @ Fulton Street in Golden Gate Park   56 43 68 67 291 56 467
258 49 30 60 Leavenworth St.   43 34 47 46 280 42 463
265 50 30 60 Leavenworth St.   43 34 48 47 280 42 463
288 53 30 60 Leavenworth St.   43 34 3 49 280 42 463
311 55 30 60 Leavenworth St.   43 34 50 51 280 42 463
333 59 30 60 Leavenworth St.   43 34 54 51 280 42 463
295 53 30 60 Potomac   43 34 3 49 280 42 463
317 56 30 60 Potomac   43 34 51 52 280 42 463
958 173 30 600 Octavia Street   108 69 146 150 103 131 502
260 50 30 66 Potomac   43 34 48 47 280 42 463
1139 210 30 67-69 Deming St.   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
293 53 30 878-898 Chestnut St.   43 34 3 49 280 42 463
967 173 30 887 De Haro Street   108 69 146 150 103 131 502
303 54 30 901/909Tennessee St.   43 34 49 50 280 42 463
1038 74 30 915 Naples, San Francisco   56 43 68 67 291 56 467
268 50 30 940 Powell St.   43 34 48 47 280 42 463
306 54 30 Agua Vista Park at Mission Rock, 817 Terry A Francois Blvd.   43 34 49 50 280 42 463
273 50 30 Antonio Alley   43 34 48 47 280 42 463
300 54 30 Bayview Police Station, 201 Williams Ave.   43 34 49 50 280 42 463
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
280 52 30 Betelnut restaurant, 2030 Union St.   43 34 48 48 280 42 463
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
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
289 53 30 Blue Danube Café, 306 Clement   43 34 3 49 280 42 463
318 56 30 Buena Vista betweeen Upper Terrace and Java St.   43 34 51 52 280 42 463
299 54 30 Bush and Sansome St.   43 34 49 50 280 42 463
150 37 30 California at Grant   32 26 35 34 269 32 456
152 37 30 California at Mason   32 26 35 34 269 32 456
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
1150 210 30 Castle between Union and Green   131 53 173 182 374 126 514
791 149 30 Castro Street between 17th & 18th   101 18 136 137 339 123 496
1041 74 30 Church Street MUNI Station   56 43 68 67 291 56 467
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
956 173 30 Civic Center Plaza   108 69 146 150 103 131 502
1155 210 30 Clay between Stockton and Grant   131 53 173 182 374 126 514
331 59 30 Cliffhouse, 1090 Point Lobos Ave.   43 34 54 51 280 42 463
339 60 30 Cliffhouse, 1090 Point Lobos Ave.   43 34 51 52 280 42 463
1037 74 30 Cordova Market, 301 Rolph Street, San Francisco   56 43 68 67 291 56 467
1049 74 30 Daniel's Pharmacy, 943 Geneva Ave   56 43 68 67 291 56 467
1042 74 30 Double Happiness Health, 3380 20th Street   56 43 68 67 291 56 467
285 52 30 Duboce St., Duboce Café   43 34 48 48 280 42 463
1043 74 30 Ele Nino Traiing Cetner, 2920 3rd Street   56 43 68 67 291 56 467
270 50 30 Ellis Food Center, 398 Ellis   43 34 48 47 280 42 463
269 50 30 Ellis and Jones St.   43 34 48 47 280 42 463
782 149 30 Encore Karaoke, 1550 California Street   101 18 136 137 339 123 496
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
1156 210 30 Filbert between Hyde and Jones   131 53 173 182 374 126 514
796 149 30 Fisherman's Wharf   101 18 136 137 339 123 496
294 53 30 Forrest Hill Muni Station A Muni station agent played himself in this scene. 43 34 3 49 280 42 463
955 173 30 Golden Gate Park   108 69 146 150 103 131 502
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
788 149 30 Grant Avenue between Sacramento and Washington   101 18 136 137 339 123 496
151 37 30 Grant between Bush and Broadway   32 26 35 34 269 32 456
1149 210 30 Grant between Sacramento and Jack Kerouac Alley   131 53 173 182 374 126 514
310 55 30 Grant between Union and Green   43 34 50 51 280 42 463
1151 210 30 Green between Kearny and Montgomery   131 53 173 182 374 126 514
963 173 30 Hall of Justice (850 Bryant Street)   108 69 146 150 103 131 502
964 173 30 Harriet Alley   108 69 146 150 103 131 502
259 50 30 Harvey Milk Rec Center, 50 Scott St.   43 34 48 47 280 42 463
452 74 30 Hayes Street between Ashbury and Shrader   56 43 68 67 291 56 467
284 52 30 Heron and Berwick Alleys   43 34 48 48 280 42 463
965 173 30 Howard Street at Steuart Street   108 69 146 150 103 131 502
323 57 30 Huntington Park   43 34 52 53 280 42 463
149 37 30 Hyde at Union   32 26 35 34 269 32 456
1039 74 30 Infield Batting Cages, 1888 Clement Street   56 43 68 67 291 56 467
961 173 30 Ivy Street between Laguna and Gough Streets   108 69 146 150 103 131 502
266 50 30 Jefferson Square Park   43 34 48 47 280 42 463
278 52 30 John St. between Powell and Mason   43 34 48 48 280 42 463
271 50 30 Jonell's Bar, 401 Ellis   43 34 48 47 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
Powered by Datasette · Query took 1.683ms · Data source: data.sfgov.org