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
1240 230 64 Lombard Street Lombard Street is not actually the most crooked in SF. That honor goes to Potrero Hill's Vermont Street between 22nd and 23rd. 140 87 141 201 387 175 521
1241 230 64 The Tamalpais Building (1201 Greenwich Street at Hyde)   140 87 141 201 387 175 521
1242 230 64 Brocklebank Apartments (1000 Mason Street)   140 87 141 201 387 175 521
1243 230 64 2800 Scott Street   140 87 141 201 387 175 521
1239 229 36     139 86 190 200 386 174 520
1238 228 26 19th and Kansas St.   8 85 189 199 385 173  
1212 223 18 S.S. Jeremiah O'Brien   137 84 185 194 197 23  
1161 215 37     133 83 177 187 377 164  
1159 213 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. 132 82 176 185 376 163  
1157 211 33     3 81 174 183 72 161  
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    
1084 203 3     48 79 168 176 370 156  
1511 285 40 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. 166 79 233 246 422 221  
1512 285 40 Brocklebank Apartments (1000 Mason Street)   166 79 233 246 422 221  
1513 285 40 Palace of Fine Arts (3301 Lyon Street) The original Palace was built for the 1915 Panama-Pacific Exposition, and completely destroyed in 1964. It was rebuilt in 1965. 166 79 233 246 422 221  
1514 285 40 Montgomery Street at Union Street   166 79 233 246 422 221  
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    
1035 196 31     123 77 91 169 364 151 510
1031 193 47 2700 Vallejo Street (Pacific Heights)   122 76 162 166 362 130 508
1015 189 31 Japanese Tea Garden, Hagiwara Tea Garden Drive, Golden Gate Park The Japanese Hagiwara family invented "Chinese" fortune cookies in the tea-garden 120 75 158 163 358 145 506
1016 189 31 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. 120 75 158 163 358 145 506
1017 189 31 Pier 43 1/2   120 75 158 163 358 145 506
1018 189 31 Cala Foods (California Street and Hyde)   120 75 158 163 358 145 506
1019 189 31 307 Filbert Street   120 75 158 163 358 145 506
1020 189 31 2417 Franklin Street   120 75 158 163 358 145 506
1021 189 31 Fort Point (Presidio, Golden Gate National Recreation Area) Built in 1853, Fort Point is the only West Coast fort built by the Union Army. Though the Confederate army planned to attack San Francisco, the commanding Confederate general learned that the war had ended while end route to SF. 120 75 158 163 358 145 506
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
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    
1005 185 39     116 72 154 160 355 142  
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  
975 176 2     111 70 149 153 346 133  
912 171 11 1821 Alabama Street   108 69 146 150 103 131 502
913 171 11 Hall of Justice (850 Bryant Street)   108 69 146 150 103 131 502
914 171 11 Cameron House (920 Sacramento Street)   108 69 146 150 103 131 502
915 171 11 504 Broadway   108 69 146 150 103 131 502
916 171 11 9 Calhoun Terrace   108 69 146 150 103 131 502
917 171 11 AT&T Park   108 69 146 150 103 131 502
918 171 11 Berry Street between 3rd and 4th Streets   108 69 146 150 103 131 502
919 171 11 Kearny Street between Broadway and Pacific Avenue   108 69 146 150 103 131 502
920 171 11 731 Grant Avenue   108 69 146 150 103 131 502
921 171 11 Waverly Alley between Grant and Sacramento Streets   108 69 146 150 103 131 502
922 171 11 Joice Street at Clay Street   108 69 146 150 103 131 502
923 171 11 Palace of Fine Arts (3301 Lyon Street)   108 69 146 150 103 131 502
924 171 11 800 Bay Street   108 69 146 150 103 131 502
925 171 11 1201 Columbus Avenue   108 69 146 150 103 131 502
926 171 11 Pier 45 The famous Musee Mecanique is located on Pier 45 108 69 146 150 103 131 502
927 171 11 369 Embarcadero   108 69 146 150 103 131 502
928 171 11 Dolores Park   108 69 146 150 103 131 502
929 171 11 24th Street between Folsom and Harrison Streets   108 69 146 150 103 131 502
930 171 11 13 Lucky Street   108 69 146 150 103 131 502
931 171 11 1541 Grove Street   108 69 146 150 103 131 502
932 171 11 Ida B. Wells High School (1099 Hayes Street) Ida B. Wells High School is named after the African-American journalist, suffragist and early leader in the Civil Rights Movement Ida B. Wells 108 69 146 150 103 131 502
933 171 11 Alamo Square Park   108 69 146 150 103 131 502
934 171 11 50 California Street   108 69 146 150 103 131 502
935 171 11 373 Columbus Avenue   108 69 146 150 103 131 502
936 171 11 350 Union Street   108 69 146 150 103 131 502
937 172 10 Potrero Hill Recreation Center (801 Arkansas Street)   108 69 146 150 103 131 502
938 172 10 1243 19th Street   108 69 146 150 103 131 502
939 172 10 372/374 Pennsylvania Avenue   108 69 146 150 103 131 502
940 172 10 Stevenson Alley   108 69 146 150 103 131 502
941 172 10 901 Missouri Street   108 69 146 150 103 131 502
942 172 10 83 Watchman Way   108 69 146 150 103 131 502
943 172 10 1059 Texas Street   108 69 146 150 103 131 502
944 172 10 Sue Bierman Park   108 69 146 150 103 131 502
945 172 10 Embarcadero Street at Washington Street   108 69 146 150 103 131 502
946 172 10 Treasure Island   108 69 146 150 103 131 502
947 172 10 Pier 50   108 69 146 150 103 131 502
948 172 10 435 Broadway   108 69 146 150 103 131 502
949 172 10 Columbus Avenue between Washington and Bay Streets   108 69 146 150 103 131 502
950 172 10 Grant Avenue between Clay and Washington Streets   108 69 146 150 103 131 502
951 172 10 1400 16th Street   108 69 146 150 103 131 502
Powered by Datasette · Query took 12.082ms · Data source: data.sfgov.org