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
196 40 19 Ina Coolbrith Park (1700 Taylor Street)   35   38 37      
197 40 19 0-100 block Halleck Street   35   38 37      
701 135 1 1 Post Street   90   125 125      
736 147 25 Lusty Lady Bar (North Beach)   100 68 135 136      
76 21 17     18 3 4 3 3 19  
429 79 18 Webster Street   60 45 72 72 3 61  
430 79 18 Telegraph Hill Blvd (Telegraph Hill)   60 45 72 72 3 61  
431 79 18 Larkin & Hyde Streets   60 45 72 72 3 61  
432 79 18 Gabbiano's Restaurant (Ferry Building) Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. 60 45 72 72 3 61  
433 79 18 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. 60 45 72 72 3 61  
434 79 18 2107 Union Street   60 45 72 72 3 61  
435 79 18 2100 Green Street   60 45 72 72 3 61  
439 82 33 West Chrissy Field (Presidio, Golden Gate National Recreation Area) This movie was the first to film in the revamped Chrissy Field Picnic Area. 14 13 75 75 3 63  
440 82 33 Sacramento St., Between Pierce & Broderick Streets   14 13 75 75 3 63  
441 82 33 Hyde Street & Lombard Street   14 13 75 75 3 63  
442 82 33 Building 924, 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. 14 13 75 75 3 63  
443 82 33 Broadway, Between Franklin & Laguna Streets   14 13 75 75 3 63  
885 164 8 Bush Street at Jones   104 25 140 143 3    
676 131 35 Administration Building (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. 4 3 122 121 12 107  
640 118 54     13 12 110 109 14 94 485
12 4 4     4 3 4 3 19 3 440
637 117 34 San Francisco Art Institute (800 Chestnut Street)   80 56 109 108 19 93 451
638 117 34 Washington Square Bar & Grill (1707 Powell)   80 56 109 108 19 93 451
639 117 34 City Lights Bookstore (261 Columbus) One of the country's earliest bookstores, City Lights was founded by, and still owned by beat poet Lawrence Ferlinghetti. The bookstore was often frequented by Beat writers like Allen Ginsberg and Jack Kerouac. 80 56 109 108 19 93 451
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  
1310 240 5 Tosca Café (242 Columbus Avenue, North Beach)   146 104 197 209 40 184  
1311 240 5 766 Sutter Street   146 104 197 209 40 184  
1590 302 48 Buena Vista Café (2765 Hyde Street)   104 25 246 262 58 46  
1591 302 48 Victor's Restaurant, The Westin St. Francis Hotel (335 Powell Street) The hotel was originally supposed to be named the Crocker Hotel, after Charles Founder the railroad magnate who founded it. However, the hotel took the name the St. Francis after one of the earliest Gold Rush hotels. 104 25 246 262 58 46  
1592 302 48 Spring Valley School (1451 Jackson Street)   104 25 246 262 58 46  
1593 302 48 International Studies Academy (993 Vermont Street, Potrero Hill)   104 25 246 262 58 46  
1594 302 48 Grant Street at Pacific Avenue   104 25 246 262 58 46  
1595 302 48 Cybelle's Pizza (1000 Bush Street)   104 25 246 262 58 46  
1596 302 48 766 Vallejo Street at Stockton Street (North Beach)   104 25 246 262 58 46  
1597 302 48 1521 Masonic Avenue at Piedmont Street   104 25 246 262 58 46  
370 62 3 387 Fair Oaks at 25th Street   46 37 56 56 65 44  
1157 211 33     3 81 174 183 72 161  
884 163 22 St. Elizabeth Apartment House (901 Powell Street at Sacramento)   38 6 33 142 79 126 499
1451 272 42     160 19 224 235 90 209  
1516 287 74     168 19 235 39 90 222 209
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
952 172 10 Pennsylvania Avenue at 19th Street   108 69 146 150 103 131 502
953 172 10 Harriet Street between Bryant and Brannan Streets   108 69 146 150 103 131 502
954 172 10 Boardman Place between Bryant and Brannan Streets   108 69 146 150 103 131 502
955 173 30 Golden Gate Park   108 69 146 150 103 131 502
956 173 30 Civic Center Plaza   108 69 146 150 103 131 502
957 173 30 500 Grove Street   108 69 146 150 103 131 502
958 173 30 600 Octavia Street   108 69 146 150 103 131 502
959 173 30 535 Octavia Street   108 69 146 150 103 131 502
960 173 30 Patricia's Green   108 69 146 150 103 131 502
961 173 30 Ivy Street between Laguna and Gough Streets   108 69 146 150 103 131 502
Powered by Datasette · Query took 6.418ms · Data source: data.sfgov.org