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
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
100 27 22 Transbay Terminal (Mission Street at 1st Street) Built in 1939, the Terminal linked San Francisco, the East Bay, and Sacramento by rail for the first time. 24 20 25 24 245 23 449
101 27 22 Tosca Café (242 Columbus Avenue)   24 20 25 24 245 23 449
102 27 22 Steinhart Aquarium (California Academy of Sciences, Golden Gate Park) The Steinhart Aquarium is home to over 38,000 animals, which represent more than 900 species. 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
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
109 27 22 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. 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
660 126 39 Lombard & Hyde Streets   4 3 117 24 223 102 487
685 126 39 Hall of Justice (850 Bryant Street)   4 3 117 24 223 102 487
706 126 39 Japanese Tea Garden (Hagiwara Tea Garden Drive, Golden Gate Park) The Japanese Hagiwara family invented "Chinese" fortune cookies in the tea-garden 4 3 117 24 223 102 487
707 126 39 Fior d' Italia (601 Union Street at Stockton)   4 3 117 24 223 102 487
708 126 39 Fairmont Hotel (950 Mason Street, Nob Hill) In 1945 the Fairmont hosted the United Nations Conference on International Organization as delegates arrived to draft a charter for the organization. The U.S. Secretary of State, Edward Stettinius drafted the charter in the hotel's Garden Room. 4 3 117 24 223 102 487
709 126 39 Washington Square (North Beach) Washington Square Park is not actually a square, as it has 5 sides. North Beach is not a beach. 4 3 117 24 223 102 487
710 126 39 War Memorial Opera House (401 Van Ness Avenue) In 1945 the United Nations had its first conference at The War Memorial Opera House. 4 3 117 24 223 102 487
711 126 39 Sheraton Palace Hotel (639 Market Street) The hotel was destroyed in the 1906 earthquake and fire, had to be rebuilt, and was reopened in 1909. 4 3 117 24 223 102 487
712 126 39 Palace of Fine Arts The original Palace was built for the 1915 Panama-Pacific Exposition, and completely destroyed in 1964. It was rebuilt in 1965. 4 3 117 24 223 102 487
713 138 9 Golden Gate Bridge With 23 miles of ladders and 300,000 rivets in each tower, the Golden Gate Bridge was the world's longest span when it opened in 1937. 93 4 128 24 331 113 446
714 138 9 City Hall The dome of SF's City Hall is almost a foot taller than that of the US Capitol Building. In 1954, Joe DiMaggio and Marilyn Monroe married at the Beaux Arts-style building. 93 4 128 24 331 113 446
106 28 11 Nobles Alley   25 21 26 25 260 24 450
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
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  
123 31 25 Vaillancourt Fountain (Justin Herman Plaza) Installed in 1975, the Vaillancourt Fountain is officially titled, "Québec Libre!". The night before the sculpture's inauguration, artist Armand Vaillancourt inscribed "Québec libre!" in red letters on the sculpture. The next day when he noticed that the note had been erased, Vaillancourt jumped on the statue to re-inscribe his message. 14 13 29 28 263 27  
124 31 25 Montgomery & Market Streets   14 13 29 28 263 27  
125 31 25 City Hall The dome of SF's City Hall is almost a foot taller than that of the US Capitol Building. In 1954, Joe DiMaggio and Marilyn Monroe married at the Beaux Arts-style building. 14 13 29 28 263 27  
126 32 2     28 24 30 29 264 28  
127 33 26 City Hall The dome of SF's City Hall is almost a foot taller than that of the US Capitol Building. In 1954, Joe DiMaggio and Marilyn Monroe married at the Beaux Arts-style building. 29 25 31 30 265    
128 33 26 Golden Gate Bridge With 23 miles of ladders and 300,000 rivets in each tower, the Golden Gate Bridge was the world's longest span when it opened in 1937. 29 25 31 30 265    
129 33 26 Treasure Island An artificial island, Treasure Island was created for the 1939 Golden Gate International Exposition, and is named after the novel by Robert Louis Stevenson, a one-time San Francisco resident. 29 25 31 30 265    
130 33 26 Postcard Row, Alamo Square, Hayes Valley The 6 Victorian homes across from Alamo Square Park are among the few Victorians to survive the Great Fire. 29 25 31 30 265    
131 33 26 Grace Cathedral Episcopal Church (1100 California Street) Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. 29 25 31 30 265    
1013 188 23 Bank of America (38th Street at Balboa Street) The Bank of America Building was the tallest building on the West Coast from 1969-1972, when it was surpassed by the TransAmerica Pyramid. Today, the Bank of America building is the 5th tallest building on the West Coast. 119 74 157 30 357 144 505
1014 188 23 Postcard Row (Alamo Square, Hayes Valley) The 6 Victorian homes across from Alamo Square Park are among the few Victorians to survive the Great Fire. 119 74 157 30 357 144 505
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
143 36 29 Alcatraz Island Alcatraz Island was a military fort before it became a prison. 31 19 34 33 268 31 455
144 36 29 Pier 43 1/2   31 19 34 33 268 31 455
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
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
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
156 38 27 Jones & Pacific   33 27 36 35 270 33 457
157 38 27 Pacific & Divisadero   33 27 36 35 270 33 457
158 38 27 Lombard & Hyde   33 27 36 35 270 33 457
159 38 27 5546 Geary Ave   33 27 36 35 270 33 457
160 38 27 2898 Broadway   33 27 36 35 270 33 457
161 38 27 Motel Capri   33 27 36 35 270 33 457
162 38 27 Marina Green   33 27 36 35 270 33 457
163 38 27 Ocean Beach at Lincoln   33 27 36 35 270 33 457
164 38 27 Heald College   33 27 36 35 270 33 457
165 38 27 Marina Blvd from Laguna to Baker   33 27 36 35 270 33 457
166 38 27 330 Santa Clara Ave.   33 27 36 35 270 33 457
167 38 27 200 Post St.   33 27 36 35 270 33 457
168 38 27 2179 48th Ave   33 27 36 35 270 33 457
169 38 27 The Ramp Restaurant   33 27 36 35 270 33 457
170 38 27 303-305 S. Van Ness   33 27 36 35 270 33 457
171 38 27 3563 20th St.   33 27 36 35 270 33 457
172 38 27 Taylor & Green St.   33 27 36 35 270 33 457
173 38 27 Grant & Washington St.   33 27 36 35 270 33 457
174 38 27 2934 24th St.   33 27 36 35 270 33 457
175 38 27 1138 Alabama St   33 27 36 35 270 33 457
176 38 27 South Park   33 27 36 35 270 33 457
177 38 27 2915 16th St.   33 27 36 35 270 33 457
178 38 27 Trolley Car from Market and 11th   33 27 36 35 270 33 457
179 38 27 Real Guitars   33 27 36 35 270 33 457
180 38 27 Aub Zam Zam Bar   33 27 36 35 270 33 457
181 38 27 790 Ulloa   33 27 36 35 270 33 457
182 38 27 SFO International Airport Terminal 3   33 27 36 35 270 33 457
183 38 27 2178 Palou Ave.   33 27 36 35 270 33 457
1023 191 62 Balboa at 22nd Avenue   4 3 160 35 360 147 507
Powered by Datasette · Query took 2.57ms · Data source: data.sfgov.org