Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | Title | Production Company | Director | Writer | Actor 1 | Actor 2 | Actor 3 | Locations | Fun Facts ▼ |
---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | 1 | 1 | 1 | 1 | 237 | 1 | 439 | Epic Roasthouse (399 Embarcadero) | |
2 | 2 | 1 | 1 | 1 | 1 | 237 | 1 | 439 | Mason & California Streets (Nob Hill) | |
3 | 3 | 1 | 1 | 1 | 1 | 237 | 1 | 439 | Justin Herman Plaza | |
4 | 4 | 1 | 1 | 1 | 1 | 237 | 1 | 439 | 200 block Market Street | |
5 | 5 | 1 | 1 | 1 | 1 | 237 | 1 | 439 | City Hall | |
6 | 6 | 1 | 1 | 1 | 1 | 237 | 1 | 439 | Polk & Larkin Streets | |
7 | 7 | 1 | 1 | 1 | 1 | 237 | 1 | 439 | Randall Museum | |
8 | 8 | 1 | 1 | 1 | 1 | 237 | 1 | 439 | 555 Market St. | |
9 | 9 | 2 | 2 | 2 | 238 | |||||
12 | 12 | 4 | 4 | 4 | 3 | 19 | 3 | 440 | ||
13 | 13 | 5 | 5 | 5 | 4 | 240 | 4 | Rainforest Café (145 Jefferson Street) | ||
14 | 14 | 6 | 6 | 6 | 5 | 241 | 5 | 20th and Folsom Streets | ||
19 | 19 | 7 | 7 | 7 | 6 | 242 | 6 | Broadway (North Beach) | ||
20 | 20 | 8 | 4 | 8 | 7 | 243 | 7 | 75 California Street | ||
22 | 22 | 9 | 4 | 8 | 7 | 243 | 7 | Hills Brothers Plaza (Embarcadero at Harrison Street) | ||
25 | 25 | 10 | 8 | 9 | 8 | 244 | 8 | 441 | Port of San Francisco | |
26 | 26 | 11 | 9 | 10 | 9 | 245 | 9 | 420 Jones St. at Ellis St. | ||
33 | 33 | 10 | 8 | 9 | 8 | 244 | 8 | 441 | Burger Island (901 3rd Street, China Basin) | |
34 | 34 | 10 | 8 | 9 | 8 | 244 | 8 | 441 | Van Ness Avenue | |
35 | 35 | 10 | 8 | 9 | 8 | 244 | 8 | 441 | Taylor and Jefferson Streets (Fisherman's Wharf) | |
36 | 36 | 12 | 10 | 11 | 10 | 246 | 10 | Broderick from Fulton to McAlister | ||
37 | 37 | 12 | 10 | 11 | 10 | 246 | 10 | Crissy Field | ||
38 | 38 | 12 | 10 | 11 | 10 | 246 | 10 | Powell from Bush and Sutter | ||
40 | 40 | 14 | 11 | 13 | 12 | 248 | 12 | 442 | Pier 50- end of the pier | |
41 | 41 | 14 | 11 | 13 | 12 | 248 | 12 | 442 | California @ Montgomery | |
42 | 42 | 14 | 11 | 13 | 12 | 248 | 12 | 442 | Montgomery/Green | |
43 | 43 | 14 | 11 | 13 | 12 | 248 | 12 | 442 | Driving various SF Streets | |
44 | 44 | 14 | 11 | 13 | 12 | 248 | 12 | 442 | Plate Shots SF streets various | |
45 | 45 | 15 | 12 | 14 | 13 | 249 | 13 | Filbert St. from Jones to Mason | ||
46 | 46 | 15 | 12 | 14 | 13 | 249 | 13 | Leavenworth from Filbert & Francisco St | ||
47 | 47 | 15 | 12 | 14 | 13 | 249 | 13 | Chestnut St. from Larkin to Columbus | ||
48 | 48 | 15 | 12 | 14 | 13 | 249 | 13 | Francisco St from Larkin to Polk | ||
49 | 49 | 15 | 12 | 14 | 13 | 249 | 13 | Broadway from Mason to Taylor | ||
50 | 50 | 15 | 12 | 14 | 13 | 249 | 13 | Taylor St. from Broadway to Filbert | ||
53 | 53 | 16 | 13 | 15 | 14 | 250 | 14 | 443 | San Francisco Bay | |
57 | 57 | 18 | 15 | 17 | 16 | 252 | 16 | 445 | 3355 Geary Blvd. | |
58 | 58 | 19 | 16 | 18 | 17 | 253 | 17 | |||
59 | 59 | 20 | 17 | 19 | 18 | 254 | 18 | 446 | St. Francis Episcopal Church (399 San Fernando Way) | |
60 | 60 | 20 | 17 | 19 | 18 | 254 | 18 | 446 | Romolo Place @ Fresno St. | |
61 | 61 | 20 | 17 | 19 | 18 | 254 | 18 | 446 | Palace of Fine Arts | |
62 | 62 | 20 | 17 | 19 | 18 | 254 | 18 | 446 | John Shelley Drive John McLaren Park | |
63 | 63 | 20 | 17 | 19 | 18 | 254 | 18 | 446 | Treasure Island | |
64 | 64 | 20 | 17 | 19 | 18 | 254 | 18 | 446 | The San Francisco School (300 Gavin St.) | |
65 | 65 | 20 | 17 | 19 | 18 | 254 | 18 | 446 | 33 Spruce St | |
66 | 66 | 20 | 17 | 19 | 18 | 254 | 18 | 446 | Coi Restaurant (373 Broadway) | |
67 | 67 | 20 | 17 | 19 | 18 | 254 | 18 | 446 | Foreign Cinema (2534 Mission) | |
68 | 68 | 20 | 17 | 19 | 18 | 254 | 18 | 446 | Bernal Heights Park | |
69 | 69 | 20 | 17 | 19 | 18 | 254 | 18 | 446 | Jackson St. at Spruce | |
70 | 70 | 20 | 17 | 19 | 18 | 254 | 18 | 446 | 679 Madrid St | |
71 | 71 | 20 | 17 | 19 | 18 | 254 | 18 | 446 | Roxie Theater (3117 16th St.) | |
72 | 72 | 20 | 17 | 19 | 18 | 254 | 18 | 446 | Variety Preview Room (582 Market St.) | |
73 | 73 | 20 | 17 | 19 | 18 | 254 | 18 | 446 | Laguna Honda Hospital; 375 Laguna Honda Blvd. | |
74 | 74 | 20 | 17 | 19 | 18 | 254 | 18 | 446 | 3232 Jackson Ave. | |
75 | 75 | 20 | 17 | 19 | 18 | 254 | 18 | 446 | 20th St and Illinois/Faxon St. and Kenwood/Glenbrook at Mt. Springs | |
76 | 76 | 21 | 18 | 4 | 3 | 3 | 19 | |||
78 | 78 | 11 | 9 | 10 | 9 | 245 | 9 | Lombard at Hyde | ||
79 | 79 | 11 | 9 | 10 | 9 | 245 | 9 | 601 Buena Vista Ave West at Java St. | ||
90 | 90 | 24 | 21 | 22 | 21 | 257 | 20 | |||
91 | 91 | 25 | 22 | 23 | 22 | 258 | 21 | 447 | Fairmont Hotel (950 Mason Street, Nob Hill) | |
92 | 92 | 25 | 22 | 23 | 22 | 258 | 21 | 447 | Embarcadero around Rincon Park | |
93 | 93 | 25 | 22 | 23 | 22 | 258 | 21 | 447 | San Remo Hotel (2237 Mason) | |
94 | 94 | 25 | 22 | 23 | 22 | 258 | 21 | 447 | Huntington Park (California & Taylor Streets, Nob Hill) | |
95 | 95 | 25 | 22 | 23 | 22 | 258 | 21 | 447 | Driving around Taylor/Pacific/Leavenworth | |
96 | 96 | 25 | 22 | 23 | 22 | 258 | 21 | 447 | California and Jones St. | |
97 | 97 | 25 | 22 | 23 | 22 | 258 | 21 | 447 | Another Café, 1191 Pine St at Leavenworth | |
98 | 98 | 26 | 23 | 24 | 23 | 259 | 22 | 448 | ||
99 | 99 | 27 | 24 | 25 | 24 | 245 | 23 | 449 | Yerba Buena Center for the Arts | |
101 | 101 | 27 | 24 | 25 | 24 | 245 | 23 | 449 | Tosca Café (242 Columbus Avenue) | |
103 | 103 | 27 | 24 | 25 | 24 | 245 | 23 | 449 | Raw Hide II (280 Seventh Street) | |
104 | 104 | 27 | 24 | 25 | 24 | 245 | 23 | 449 | Pier 7 (The Embarcadero) | |
105 | 105 | 27 | 24 | 25 | 24 | 245 | 23 | 449 | Kearney Street (Telegraph Hill) | |
106 | 106 | 28 | 25 | 26 | 25 | 260 | 24 | 450 | Nobles Alley | |
107 | 107 | 27 | 24 | 25 | 24 | 245 | 23 | 449 | Hall of Justice (850 Bryant Street) | |
108 | 108 | 27 | 24 | 25 | 24 | 245 | 23 | 449 | 2930 Vallejo Street | |
110 | 110 | 27 | 24 | 25 | 24 | 245 | 23 | 449 | Gibb Street (Chinatown) | |
111 | 111 | 27 | 24 | 25 | 24 | 245 | 23 | 449 | 1158-70 Montgomery Street | |
112 | 112 | 27 | 24 | 25 | 24 | 245 | 23 | 449 | 2104 Broadway | |
113 | 113 | 29 | 26 | 27 | 26 | 261 | 25 | 451 | ||
114 | 114 | 30 | 27 | 28 | 27 | 262 | 26 | 452 | Divisadero between Broadway and Greenwich | |
115 | 115 | 30 | 27 | 28 | 27 | 262 | 26 | 452 | Ohloff Recovery Center (601 Steiner St) | |
116 | 116 | 30 | 27 | 28 | 27 | 262 | 26 | 452 | Haight at Masonic | |
117 | 117 | 30 | 27 | 28 | 27 | 262 | 26 | 452 | Tenderloin Neighborhood | |
118 | 118 | 30 | 27 | 28 | 27 | 262 | 26 | 452 | Olympic Flame Café, 555 Geary St | |
119 | 119 | 30 | 27 | 28 | 27 | 262 | 26 | 452 | 18th St at San Bruno Ave. | |
120 | 120 | 30 | 27 | 28 | 27 | 262 | 26 | 452 | Wisconsin between 19th and 20th St | |
121 | 121 | 31 | 14 | 29 | 28 | 263 | 27 | 1155 Filbert Street at Hyde | ||
122 | 122 | 31 | 14 | 29 | 28 | 263 | 27 | Washington Square Park (Filbert, between Stockton and Powell) | ||
124 | 124 | 31 | 14 | 29 | 28 | 263 | 27 | Montgomery & Market Streets | ||
126 | 126 | 32 | 28 | 30 | 29 | 264 | 28 | |||
132 | 132 | 28 | 25 | 26 | 25 | 260 | 24 | 450 | Caffe Trieste | |
133 | 133 | 28 | 25 | 26 | 25 | 260 | 24 | 450 | Palace of Fine Arts | |
134 | 134 | 28 | 25 | 26 | 25 | 260 | 24 | 450 | 1101 Filbert St. | |
135 | 135 | 28 | 25 | 26 | 25 | 260 | 24 | 450 | Saints Peter & Paul Church | |
136 | 136 | 28 | 25 | 26 | 25 | 260 | 24 | 450 | Green St. & Grant Ave. | |
137 | 137 | 28 | 25 | 26 | 25 | 260 | 24 | 450 | Filbert St. & Leavenworth | |
138 | 138 | 28 | 25 | 26 | 25 | 260 | 24 | 450 | Pine St. & Grant | |
139 | 139 | 28 | 25 | 26 | 25 | 260 | 24 | 450 | Way Faire Inn on Leidesdorff | |
140 | 140 | 28 | 25 | 26 | 25 | 260 | 24 | 450 | Harry's Bar on Fillmore | |
141 | 141 | 34 | 30 | 32 | 31 | 266 | 29 | 453 | Tosca Café (242 Columbus Avenue, North Beach) | |
142 | 142 | 35 | 13 | 33 | 32 | 267 | 30 | 454 |
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE "Film_Locations_in_San_Francisco_fts" USING FTS4 ("Title", "Production Company", "Director", "Writer", "Actor 1", "Actor 2", "Actor 3", "Locations", "Fun Facts", content="Film_Locations_in_San_Francisco");