Film_Locations_in_San_Francisco_fts

Data source: data.sfgov.org

1,622 rows sorted by Fun Facts

View and edit SQL

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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 133.019ms · Data source: data.sfgov.org