sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

This data as json, CSV

rowidTitleRelease YearLocationsFun FactsProduction CompanyDistributorDirectorWriterActor 1Actor 2Actor 3
1 1 1 Epic Roasthouse (399 Embarcadero)   1   1 1 237 1 439
2 1 1 Mason & California Streets (Nob Hill)   1   1 1 237 1 439
3 1 1 Justin Herman Plaza   1   1 1 237 1 439
4 1 1 200 block Market Street   1   1 1 237 1 439
5 1 1 City Hall   1   1 1 237 1 439
6 1 1 Polk & Larkin Streets   1   1 1 237 1 439
7 1 1 Randall Museum   1   1 1 237 1 439
8 1 1 555 Market St.   1   1 1 237 1 439
9 2 2     2 1 2   238    
12 4 4     4 3 4 3 19 3 440
13 5 5 Rainforest Café (145 Jefferson Street)   5 4 5 4 240 4  
14 6 6 20th and Folsom Streets   6 5 6 5 241 5  
19 7 7 Broadway (North Beach)   7 6 7 6 242 6  
20 8 8 75 California Street   4 3 8 7 243 7  
22 9 8 Hills Brothers Plaza (Embarcadero at Harrison Street)   4 3 8 7 243 7  
25 10 9 Port of San Francisco   8 7 9 8 244 8 441
26 11 10 420 Jones St. at Ellis St.   9 8 10 9 245 9  
33 10 9 Burger Island (901 3rd Street, China Basin)   8 7 9 8 244 8 441
34 10 9 Van Ness Avenue   8 7 9 8 244 8 441
35 10 9 Taylor and Jefferson Streets (Fisherman's Wharf)   8 7 9 8 244 8 441
36 12 11 Broderick from Fulton to McAlister   10 9 11 10 246 10  
37 12 11 Crissy Field   10 9 11 10 246 10  
38 12 11 Powell from Bush and Sutter   10 9 11 10 246 10  
40 14 10 Pier 50- end of the pier   11   13 12 248 12 442
41 14 10 California @ Montgomery   11   13 12 248 12 442
42 14 10 Montgomery/Green   11   13 12 248 12 442
43 14 10 Driving various SF Streets   11   13 12 248 12 442
44 14 10 Plate Shots SF streets various   11   13 12 248 12 442
45 15 13 Filbert St. from Jones to Mason   12 11 14 13 249 13  
46 15 13 Leavenworth from Filbert & Francisco St   12 11 14 13 249 13  
47 15 13 Chestnut St. from Larkin to Columbus   12 11 14 13 249 13  
48 15 13 Francisco St from Larkin to Polk   12 11 14 13 249 13  
49 15 13 Broadway from Mason to Taylor   12 11 14 13 249 13  
50 15 13 Taylor St. from Broadway to Filbert   12 11 14 13 249 13  
53 16 14 San Francisco Bay   13 12 15 14 250 14 443
57 18 16 3355 Geary Blvd.   15 14 17 16 252 16 445
58 19 5     16   18 17 253 17  
59 20 10 St. Francis Episcopal Church (399 San Fernando Way)   17   19 18 254 18 446
60 20 10 Romolo Place @ Fresno St.   17   19 18 254 18 446
61 20 10 Palace of Fine Arts   17   19 18 254 18 446
62 20 10 John Shelley Drive John McLaren Park   17   19 18 254 18 446
63 20 10 Treasure Island   17   19 18 254 18 446
64 20 10 The San Francisco School (300 Gavin St.)   17   19 18 254 18 446
65 20 10 33 Spruce St   17   19 18 254 18 446
66 20 10 Coi Restaurant (373 Broadway)   17   19 18 254 18 446
67 20 10 Foreign Cinema (2534 Mission)   17   19 18 254 18 446
68 20 10 Bernal Heights Park   17   19 18 254 18 446
69 20 10 Jackson St. at Spruce   17   19 18 254 18 446
70 20 10 679 Madrid St   17   19 18 254 18 446
71 20 10 Roxie Theater (3117 16th St.)   17   19 18 254 18 446
72 20 10 Variety Preview Room (582 Market St.)   17   19 18 254 18 446
73 20 10 Laguna Honda Hospital; 375 Laguna Honda Blvd.   17   19 18 254 18 446
74 20 10 3232 Jackson Ave.   17   19 18 254 18 446
75 20 10 20th St and Illinois/Faxon St. and Kenwood/Glenbrook at Mt. Springs   17   19 18 254 18 446
76 21 17     18 3 4 3 3 19  
78 11 10 Lombard at Hyde   9 8 10 9 245 9  
79 11 10 601 Buena Vista Ave West at Java St.   9 8 10 9 245 9  
90 24 19     21 17 22 21 257 20  
91 25 20 Fairmont Hotel (950 Mason Street, Nob Hill)   22 18 23 22 258 21 447
92 25 20 Embarcadero around Rincon Park   22 18 23 22 258 21 447
93 25 20 San Remo Hotel (2237 Mason)   22 18 23 22 258 21 447
94 25 20 Huntington Park (California & Taylor Streets, Nob Hill)   22 18 23 22 258 21 447
95 25 20 Driving around Taylor/Pacific/Leavenworth   22 18 23 22 258 21 447
96 25 20 California and Jones St.   22 18 23 22 258 21 447
97 25 20 Another Café, 1191 Pine St at Leavenworth   22 18 23 22 258 21 447
98 26 21     23 19 24 23 259 22 448
99 27 22 Yerba Buena Center for the Arts   24 20 25 24 245 23 449
101 27 22 Tosca Café (242 Columbus Avenue)   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
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  
124 31 25 Montgomery & Market Streets   14 13 29 28 263 27  
126 32 2     28 24 30 29 264 28  
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
144 36 29 Pier 43 1/2   31 19 34 33 268 31 455
Powered by Datasette · Query took 3.655ms · Data source: data.sfgov.org