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
9 2 2     2 1 2   238    
88 22 18 Ocean Beach On Jan. 25, 1878, the King Philip ship crashed in Ocean Beach. Occasionally, the ship's wreckage may be found on the beach-- most recently it was seen in 2007. 19 15 20 19 255    
89 23 7 Hyde Street Cable Car SF Cable Cars are the only moving National Historical Landmark. 20 16 21 20 256    
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    
196 40 19 Ina Coolbrith Park (1700 Taylor Street)   35   38 37      
197 40 19 0-100 block Halleck Street   35   38 37      
238 44 33 The Lexington Club (3464 19th Street at Lexington)   39 31 42 41 275    
239 44 33 Royan Hotel (405 Valencia Street, Mission District)   39 31 42 41 275    
240 44 33 Department of Public Health (101 Grove Street at Polk, Civic Center)   39 31 42 41 275    
324 58 7     44 35 53 54 281    
594 105 19 Sacramento & Washington Streets   73   97 97 310    
628 113 43     78 41 105 105 240    
629 114 40 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. 15 41 106 106 317    
633 116 46 Stockton Tunnel (Stockton Street at Sutter Street) Opened in 1914, the Stockton Tunnel was built to provide North Beach residents access to the thriving downtown area. 15 55 108 107 319    
634 116 46 2810 Pacific Avenue   15 55 108 107 319    
635 116 46 War Memorial Opera House (401 Van Ness Avenue) In 1945 the United Nations had its first conference at The War Memorial Opera House. 15 55 108 107 319    
636 116 46 Conservatory of Flowers (Golden Gate Park) The Conservatory, unveiled in 1879, is the oldest public conservatory in the Western Hemisphere. 15 55 108 107 319    
701 135 1 1 Post Street   90   125 125      
736 147 25 Lusty Lady Bar (North Beach)   100 68 135 136      
862 159 11 The Marsh Theatre (1062 Valencia Street)   102   137 138 340    
863 159 11 20 Hill Street   102   137 138 340    
864 159 11 198 Gough Street   102   137 138 340    
885 164 8 Bush Street at Jones   104 25 140 143 3    
900 167 33 The 500 Club (500 Guerrero Street, Mission District)       143 146 342    
901 167 33 Mission Dolores Park (Mission District) The two land plots that comprise the Park were used as a Jewish cemetery until 1894 when San Francisco prohibited all burials within city limits. The graves were moved to Colma, CA.     143 146 342    
974 175 33 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. 110   148 152 345    
1006 186 11 Filbert from Hyde to Leavenworth   117 73 155 161 356    
1007 186 11 Columbus and Green   117 73 155 161 356    
1008 186 11 Larkin & Fulton   117 73 155 161 356    
1009 186 11 Embarcadero & Market   117 73 155 161 356    
1070 199 22     125 41 45 172 367    
1071 200 5 Magic Theater (Fort Mason, Golden Gate National Recreation Area) Constructed in 1864 as a coastal defense site, Fort Mason went on to serve as an army post for more than 100 years. 77 78 166 173 316    
1087 205 10 2nd St. at Townsend St.   129 80 170 178 258    
1088 205 10 Jefferson St. at Powell St.   129 80 170 178 258    
1089 205 10 Grant St. at Bush St. Characters walk down street and it's totally wrecked from a massive earthquake 129 80 170 178 258    
1090 205 10 Vallejo Garage Roof (Vallejo at Powell)   129 80 170 178 258    
1091 205 10 Clay St. at Taylor 3 characters walk down the street. An earthquake shakes the city and stuff starts breaking. One character gets a shard of glass stuck in his leg. 129 80 170 178 258    
1092 205 10 Bay St. at Polk   129 80 170 178 258    
1093 205 10 Intersection of Lombard and Hyde   129 80 170 178 258    
1094 205 10 Mission between 3rd and 4th St.   129 80 170 178 258    
1095 205 10 555 California Characters walk out of broken window of 555 California out to Kearny St. Splinter unit films a car driving into the garage at 555 California 129 80 170 178 258    
1096 205 10 Broadway and Kearney   129 80 170 178 258    
1097 205 10 Grant between Bush and Market   129 80 170 178 258    
1098 205 10 Coit Tower   129 80 170 178 258    
1099 205 10 TransAmerica Pyramid (600 Montgomery Street)   129 80 170 178 258    
1100 205 10 Washington Square   129 80 170 178 258    
1101 205 10 Battery Spencer   129 80 170 178 258    
1102 205 10 Pier 43 Bystanders watch as a tsunami crashes over them 129 80 170 178 258    
1103 205 10 Vallejo St. Garage, 766 Vallejo St. Characters watch from roof of garage as tsunami hits SF waterfront 129 80 170 178 258    
1104 205 10 Fort Baker   129 80 170 178 258    
1105 205 10 AT&T Stadium 3 characters run out of stadium, there is a group of people on the sidewalk, an earthquake hits, and they duck for cover 129 80 170 178 258    
1106 205 10 AT&T Stadium two paragliders land on the field of AT&T Park 129 80 170 178 258    
1107 205 10 Water work in SF Bay Characters drive in a high speed picture boat to see different views of the city. 129 80 170 178 258    
1108 205 10 Stage Work, 47 Julian St.   129 80 170 178 258    
1109 205 10 Hyde St. at Greenwich and Hyde St. at Lombard Characters walk to get a vantage point for Coit tower. 250 actors walking "fleeing" the city after earthquake 129 80 170 178 258    
1110 205 10 Asia Star Fantasy, 1126 Grant Ave. Characters look for a form of communication with LA in a post-quake trashed city 129 80 170 178 258    
1114 208 10 18th Street between Guerrero and Valencia Streets Re-enactment of "Dyke's on Bikes" and "Dyke March" 131 53 172 180 374    
1115 208 10 Atlas Café, 3049 20th St. Dialogue scene inside the café 131 53 172 180 374    
1116 208 10 Clarion Alley between Valencia & Mission St. Ladies discuss their relationship in the mural alley 131 53 172 180 374    
1117 208 10 Harrison & 20th Driving shots 131 53 172 180 374    
1118 208 10 Folsom Driving shots 131 53 172 180 374    
1119 208 10 16th St. Driving shots 131 53 172 180 374    
1120 208 10 S. Van Ness Driving shots 131 53 172 180 374    
1121 208 10 22nd St. Driving shots 131 53 172 180 374    
1122 208 10 Harrison Driving shots 131 53 172 180 374    
1123 208 10 20th Driving shots 131 53 172 180 374    
1124 208 10 Z Space Studios; 450 Florida St. Filming of the "Fresh Meat" Festival 131 53 172 180 374    
1125 208 10 375 Castro St. and 17th between Castro and Diamond St. Chase sequence on bicycles ends at gas station 131 53 172 180 374    
1126 208 10 Corbett St. Bicycle chase scene, actors dressed as fake officers present 131 53 172 180 374    
1127 208 10 Romain St. Bicycle chase scene 131 53 172 180 374    
1128 208 10 Market St. overpass Bicycle chase scene 131 53 172 180 374    
1129 208 10 Grand View Ave. Bicycle chase scene 131 53 172 180 374    
1130 208 10 Vallejo Street Garage; 766 Vallejo St. dialogue scene on top of a garage roof 131 53 172 180 374    
1131 208 10 Laguna Honda Hospital; 375 Laguna Honda Blvd. dialogue scene 131 53 172 180 374    
1132 208 10 Irving St. at 9th Ave. continuous driving shots of a taxi going with the flow of existing traffic 131 53 172 180 374    
1134 208 10 Dolores Park, 20th St. between Church & Dolores St. group of friends have a heated argument, then flashback of pre-argument 131 53 172 180 374    
1135 208 10 Palace of Fine Arts: 3306 Lyon St. Filming of "Dyke's on Bikes" and "Dyke March" 131 53 172 180 374    
1136 208 10 Van Ness and 12th St. A couple reminisces on the moment they first fell in love 131 53 172 180 374    
1137 208 10 "Metzger's Apt" 151 Alice B. Toklas Pl. Overnight scene involving aggressive arguments between actors, spfx shoot out involved 131 53 172 180 374    
1280 236 38 Broadway Studios (435 Broadway at Montgomery Street)   143 102 194 206 392    
1281 236 38 Regency Building (1290 Sutter Street)   143 102 194 206 392    
1327 244 68 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. 148 106 200   395    
1330 246 2     149 107 202 213 396    
1359 251 23     152 108 206 218 398    
1403 257 38     155 27 212   403    
1546 294 2     171 116 239 254 429    
1558 296 37 Tosca Café (242 Columbus Avenue, North Beach)   172 6 241 256 430    
1582 300 5 Golden Gate National Recreation Area The size of the Recreation Area is over two and a half greater than that of the city and county of San Francisco. 175 118 244 260 433    
1620 305 25 312 Fillmore Street   178 24 248 264 436    
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
Powered by Datasette · Query took 1.407ms · Data source: data.sfgov.org