sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 28 rows (hide)

Query parameters

This data as json, CSV

rowidTitleRelease YearLocationsFun FactsProduction CompanyDistributorDirectorWriterActor 1Actor 2Actor 3
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    
905 170 46 1200 Washington Street at Taylor Street   13 12 31 149 265 100 501
906 170 46 Hancock School (940 Filbert Street)   13 12 31 149 265 100 501
907 170 46 Danilo's Bakery (Green Street & Bannam Place)   13 12 31 149 265 100 501
908 170 46 Chrissy Field Chrissy Field was originally an airfield for the Presidio Army Base. 13 12 31 149 265 100 501
909 170 46 520-522A Green Street at Grant Street   13 12 31 149 265 100 501
910 170 46 516 Green Street   13 12 31 149 265 100 501
911 170 46 100 Embarcadero Street   13 12 31 149 265 100 501
977 178 39 The Malloch Apartment Building (1360 Montgomery Street)   29 13 31 154 348 135 265
978 178 39 Wasteland Store (1600 Haight Street)   29 13 31 154 348 135 265
979 178 39 Star's CafĂ© (55 Golden Gate Avenue at Van Ness)   29 13 31 154 348 135 265
980 178 39 St. Peter & Paul's Church (666 Filbert Street, Washington Square) Though Marilyn Monroe and Joe DiMaggio were not allowed to be married at the Church (DiMaggio had married his first wife at the Church but was divorced), the couple returned to the steps of the Church for photos, following their City Hall nuptials. 29 13 31 154 348 135 265
981 178 39 San Francisco General Hospital Medical Center (1001 Potrero Avenue, Potrero Hill) SF General Hospital is the only Level I Trauma Center serving San Francisco and northern San Mateo County. 29 13 31 154 348 135 265
982 178 39 Pierce Street between Pacific & Green Streets   29 13 31 154 348 135 265
983 178 39 Montgomery & Vallejo Streets   29 13 31 154 348 135 265
984 178 39 Marathon Plaza (303 2nd Street)   29 13 31 154 348 135 265
985 178 39 Jones Street at Bush   29 13 31 154 348 135 265
986 178 39 Jack Kerouac Alley between Columbus & Grant Streets   29 13 31 154 348 135 265
987 178 39 Chrissy Field Chrissy Field was originally an airfield for the Presidio Army Base. 29 13 31 154 348 135 265
988 178 39 Belli Building (722 Montgomery Street at Washington)   29 13 31 154 348 135 265
989 178 39 Alamo Square   29 13 31 154 348 135 265
990 178 39 60 Spear Street   29 13 31 154 348 135 265
991 178 39 101 Henry Adams Place, 4th Floor   29 13 31 154 348 135 265
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  
Powered by Datasette · Query took 1.462ms · Data source: data.sfgov.org