sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTitleRelease YearLocationsFun FactsProduction CompanyDistributorDirectorWriterActor 1Actor 2Actor 3
705 137 43     92 25 127 127 265 112  
715 139 43     94 62 129 128 252 114  
722 141 38     96 64 130 130 333 116  
730 143 2     84 59 131 132 335 118  
731 144 25 Ferry Building Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. 97 65 132 133 336 119  
732 145 28 Market Street Between Noe and Sanchez   98 66 133 134 337 120  
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    
887 166 59 Duboce Park   106 17 142 145 40 128  
888 166 59 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. 106 17 142 145 40 128  
889 166 59 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. 106 17 142 145 40 128  
890 166 59 424 Sansome Street   106 17 142 145 40 128  
891 166 59 29th and Dolores Street   106 17 142 145 40 128  
892 166 59 El Camino Del Mar   106 17 142 145 40 128  
893 166 59 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. 106 17 142 145 40 128  
894 166 59 Market & Castro Street From 1910-1920 the Castro was called "Little Scandinavia" because of its high concentration of residents of Scandinavian ancestry. 106 17 142 145 40 128  
895 166 59 Marine Fireman's Union Headquarters   106 17 142 145 40 128  
896 166 59 Lower Haight Street   106 17 142 145 40 128  
898 166 59 Grace Cathedral Episcopal Church (1100 California Street) Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. 106 17 142 145 40 128  
899 166 59 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. 106 17 142 145 40 128  
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    
902 168 38     107 4 144 147 150 129  
903 169 43 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. 4 3 145 148 343 130  
904 169 43 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 145 148 343 130  
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    
975 176 2     111 70 149 153 346 133  
976 177 48     112 47 132 133 347 134  
995 182 13 Bay Bridge   114 71 151 157 352 139  
996 182 13 Sacramento & Montgomery Streets   114 71 151 157 352 139  
997 182 13 2017 23rd Street   114 71 151 157 352 139  
998 182 13 Filbert & Leavenworth Streets   114 71 151 157 352 139  
999 183 17 Texas & 19th Streets (Potrero Hill)   115 12 152 158 353 140  
1000 183 17 Financial District   115 12 152 158 353 140  
1001 183 17 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. 115 12 152 158 353 140  
1005 185 39     116 72 154 160 355 142  
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    
1010 187 18 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. 118 41 156 162 265 143  
1011 187 18 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. 118 41 156 162 265 143  
1012 187 18 Presidio (Golden Gate National Recreation Area) In 1776, Spain made the Presidio a fortified area. The area was then given to Mexico, but then given to the US in 1848. The 1994 demilitarization of the area in 1994 marked the end of its 219 years of military use. 118 41 156 162 265 143  
1022 190 43 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. 104 25 159 164 359 146  
1029 192 25 Conservatory of Flowers (Golden Gate Park) The Conservatory, unveiled in 1879, is the oldest public conservatory in the Western Hemisphere. 121 25 161 165 361 148  
1034 195 17     104 25 27 168 264 150  
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    
1083 202 2 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. 127 4 31 175 369 155  
1084 203 3     48 79 168 176 370 156  
1085 204 25 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. 128 6 169 177 371 157  
1086 204 25 Embarcadero Street   128 6 169 177 371 157  
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    
1113 207 25 The Castro From 1910-1920 the Castro was called "Little Scandinavia" because of its high concentration of residents of Scandinavian ancestry. 130   171   373 159  
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    
1133 209 5 Pier 24   4 3 111 181 324 160  
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    
Powered by Datasette · Query took 2.239ms · Data source: data.sfgov.org