sf-film-locations

Data source: data.sfgov.org

Custom SQL query returning 46 rows (hide)

Query parameters

This data as json, CSV

rowidTitleRelease YearLocationsFun FactsProduction CompanyDistributorDirectorWriterActor 1Actor 2Actor 3
504 94 46 400 Montgomery Street   68 6 85 86 113 74 475
505 94 46 Folsom Street & Embarcadero   68 6 85 86 113 74 475
506 94 46 Varennes Alley between Filbert and Union   68 6 85 86 113 74 475
507 94 46 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. 68 6 85 86 113 74 475
508 94 46 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. 68 6 85 86 113 74 475
509 94 46 Kohl Building (400 Montgomery Street)   68 6 85 86 113 74 475
510 94 46 Bank of America Building (555 California 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. 68 6 85 86 113 74 475
511 94 46 90 Gold Street   68 6 85 86 113 74 475
512 94 46 5th and Beale Streets   68 6 85 86 113 74 475
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    
716 140 46 Hang Ah Alley (Chinatown)   95 63 46 129 332 115 493
717 140 46 Horace Mann School (3351 23rd Street)   95 63 46 129 332 115 493
718 140 46 901 Union Street   95 63 46 129 332 115 493
719 140 46 610 Rhode Island Street (Potrero Hill)   95 63 46 129 332 115 493
720 140 46 375 Laguna Honda Blvd.   95 63 46 129 332 115 493
721 140 46 180 Manchester Street   95 63 46 129 332 115 493
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
1166 219 46 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. 104 25 181 190 274 167  
1167 219 46 Maritime Museum, Building 201 (Fort Mason)   104 25 181 190 274 167  
1168 219 46 Coit Tower The Tower was funded by a gift bequeathed by Lillie Hitchcock Coit, a socialite who reportedly liked to chase fires. Though the tower resembles a firehose nozzle, it was not designed this way. 104 25 181 190 274 167  
1169 219 46 CCSF Alemany Campus   104 25 181 190 274 167  
1170 219 46 Carnelian Room, Bank of America Building (555 California Street, 53rd Floor) 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. 104 25 181 190 274 167  
1198 222 46 Vesuvio Café (255 Columbus Avenue) Jack Kerouac was a regular at the café. 136 20 184 193 382 170  
1199 222 46 Swedenborgian Church (2107 Lyon Street)   136 20 184 193 382 170  
1200 222 46 St. John's Presbyterian Church (25 Lake Street)   136 20 184 193 382 170  
1201 222 46 San Francisco Chronicle (901 Mission Street at 15th Street) The paper is called the San Francisco Globe in the movie. 136 20 184 193 382 170  
1202 222 46 Rocco's Corner (Columbus Street)   136 20 184 193 382 170  
1203 222 46 Prudente's Italian Deli (1462 Grant Ave at Union) Prudente's Italian Deli, which has since closed, is called "Meats of the World" in the film. 136 20 184 193 382 170  
1204 222 46 Fog City Diner (1300 Battery Street)   136 20 184 193 382 170  
1205 222 46 Edinburgh Castle (950 Geary Street)   136 20 184 193 382 170  
1206 222 46 City Light Bookstore (261 Columbus Avenue)   136 20 184 193 382 170  
1207 222 46 Café Picaro 3120 16th Street   136 20 184 193 382 170  
1208 222 46 Alcatraz Island Alcatraz Island was a military fort before it became a prison. 136 20 184 193 382 170  
1209 222 46 Aladdin Terrace (off of Taylor Street, Between Filbert and Union)   136 20 184 193 382 170  
1210 222 46 305 Hugo Street   136 20 184 193 382 170  
1211 222 46 1462 Grant Avenue, at Union Street   136 20 184 193 382 170  
1450 271 46     104 25 129 234 412 208  
Powered by Datasette · Query took 1.347ms · Data source: data.sfgov.org