Film_Locations_in_San_Francisco_fts

Data source: data.sfgov.org

1,622 rows sorted by Actor 1

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid Title Production Company Director Writer Actor 1 ▼ Actor 2 Actor 3 Locations Fun Facts
196 196 40 35 38 37       Ina Coolbrith Park (1700 Taylor Street)  
197 197 40 35 38 37       0-100 block Halleck Street  
701 701 135 90 125 125       1 Post Street  
736 736 147 100 135 136       Lusty Lady Bar (North Beach)  
76 76 21 18 4 3 3 19      
429 429 79 60 72 72 3 61   Webster Street  
430 430 79 60 72 72 3 61   Telegraph Hill Blvd (Telegraph Hill)  
431 431 79 60 72 72 3 61   Larkin & Hyde Streets  
432 432 79 60 72 72 3 61   Gabbiano's Restaurant (Ferry Building) Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters.
433 433 79 60 72 72 3 61   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.
434 434 79 60 72 72 3 61   2107 Union Street  
435 435 79 60 72 72 3 61   2100 Green Street  
439 439 82 14 75 75 3 63   West Chrissy Field (Presidio, Golden Gate National Recreation Area) This movie was the first to film in the revamped Chrissy Field Picnic Area.
440 440 82 14 75 75 3 63   Sacramento St., Between Pierce & Broderick Streets  
441 441 82 14 75 75 3 63   Hyde Street & Lombard Street  
442 442 82 14 75 75 3 63   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.
443 443 82 14 75 75 3 63   Broadway, Between Franklin & Laguna Streets  
885 885 164 104 140 143 3     Bush Street at Jones  
676 676 131 4 122 121 12 107   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.
640 640 118 13 110 109 14 94 485    
12 12 4 4 4 3 19 3 440    
637 637 117 80 109 108 19 93 451 San Francisco Art Institute (800 Chestnut Street)  
638 638 117 80 109 108 19 93 451 Washington Square Bar & Grill (1707 Powell)  
639 639 117 80 109 108 19 93 451 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.
887 887 166 106 142 145 40 128   Duboce Park  
888 888 166 106 142 145 40 128   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.
889 889 166 106 142 145 40 128   Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US.
890 890 166 106 142 145 40 128   424 Sansome Street  
891 891 166 106 142 145 40 128   29th and Dolores Street  
892 892 166 106 142 145 40 128   El Camino Del Mar  
893 893 166 106 142 145 40 128   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.
894 894 166 106 142 145 40 128   Market & Castro Street From 1910-1920 the Castro was called "Little Scandinavia" because of its high concentration of residents of Scandinavian ancestry.
895 895 166 106 142 145 40 128   Marine Fireman's Union Headquarters  
896 896 166 106 142 145 40 128   Lower Haight Street  
898 898 166 106 142 145 40 128   Grace Cathedral Episcopal Church (1100 California Street) Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral.
899 899 166 106 142 145 40 128   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.
1310 1310 240 146 197 209 40 184   Tosca Café (242 Columbus Avenue, North Beach)  
1311 1311 240 146 197 209 40 184   766 Sutter Street  
1590 1590 302 104 246 262 58 46   Buena Vista Café (2765 Hyde Street)  
1591 1591 302 104 246 262 58 46   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.
1592 1592 302 104 246 262 58 46   Spring Valley School (1451 Jackson Street)  
1593 1593 302 104 246 262 58 46   International Studies Academy (993 Vermont Street, Potrero Hill)  
1594 1594 302 104 246 262 58 46   Grant Street at Pacific Avenue  
1595 1595 302 104 246 262 58 46   Cybelle's Pizza (1000 Bush Street)  
1596 1596 302 104 246 262 58 46   766 Vallejo Street at Stockton Street (North Beach)  
1597 1597 302 104 246 262 58 46   1521 Masonic Avenue at Piedmont Street  
370 370 62 46 56 56 65 44   387 Fair Oaks at 25th Street  
1157 1157 211 3 174 183 72 161      
884 884 163 38 33 142 79 126 499 St. Elizabeth Apartment House (901 Powell Street at Sacramento)  
1451 1451 272 160 224 235 90 209      
1516 1516 287 168 235 39 90 222 209    
912 912 171 108 146 150 103 131 502 1821 Alabama Street  
913 913 171 108 146 150 103 131 502 Hall of Justice (850 Bryant Street)  
914 914 171 108 146 150 103 131 502 Cameron House (920 Sacramento Street)  
915 915 171 108 146 150 103 131 502 504 Broadway  
916 916 171 108 146 150 103 131 502 9 Calhoun Terrace  
917 917 171 108 146 150 103 131 502 AT&T Park  
918 918 171 108 146 150 103 131 502 Berry Street between 3rd and 4th Streets  
919 919 171 108 146 150 103 131 502 Kearny Street between Broadway and Pacific Avenue  
920 920 171 108 146 150 103 131 502 731 Grant Avenue  
921 921 171 108 146 150 103 131 502 Waverly Alley between Grant and Sacramento Streets  
922 922 171 108 146 150 103 131 502 Joice Street at Clay Street  
923 923 171 108 146 150 103 131 502 Palace of Fine Arts (3301 Lyon Street)  
924 924 171 108 146 150 103 131 502 800 Bay Street  
925 925 171 108 146 150 103 131 502 1201 Columbus Avenue  
926 926 171 108 146 150 103 131 502 Pier 45 The famous Musee Mecanique is located on Pier 45
927 927 171 108 146 150 103 131 502 369 Embarcadero  
928 928 171 108 146 150 103 131 502 Dolores Park  
929 929 171 108 146 150 103 131 502 24th Street between Folsom and Harrison Streets  
930 930 171 108 146 150 103 131 502 13 Lucky Street  
931 931 171 108 146 150 103 131 502 1541 Grove Street  
932 932 171 108 146 150 103 131 502 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
933 933 171 108 146 150 103 131 502 Alamo Square Park  
934 934 171 108 146 150 103 131 502 50 California Street  
935 935 171 108 146 150 103 131 502 373 Columbus Avenue  
936 936 171 108 146 150 103 131 502 350 Union Street  
937 937 172 108 146 150 103 131 502 Potrero Hill Recreation Center (801 Arkansas Street)  
938 938 172 108 146 150 103 131 502 1243 19th Street  
939 939 172 108 146 150 103 131 502 372/374 Pennsylvania Avenue  
940 940 172 108 146 150 103 131 502 Stevenson Alley  
941 941 172 108 146 150 103 131 502 901 Missouri Street  
942 942 172 108 146 150 103 131 502 83 Watchman Way  
943 943 172 108 146 150 103 131 502 1059 Texas Street  
944 944 172 108 146 150 103 131 502 Sue Bierman Park  
945 945 172 108 146 150 103 131 502 Embarcadero Street at Washington Street  
946 946 172 108 146 150 103 131 502 Treasure Island  
947 947 172 108 146 150 103 131 502 Pier 50  
948 948 172 108 146 150 103 131 502 435 Broadway  
949 949 172 108 146 150 103 131 502 Columbus Avenue between Washington and Bay Streets  
950 950 172 108 146 150 103 131 502 Grant Avenue between Clay and Washington Streets  
951 951 172 108 146 150 103 131 502 1400 16th Street  
952 952 172 108 146 150 103 131 502 Pennsylvania Avenue at 19th Street  
953 953 172 108 146 150 103 131 502 Harriet Street between Bryant and Brannan Streets  
954 954 172 108 146 150 103 131 502 Boardman Place between Bryant and Brannan Streets  
955 955 173 108 146 150 103 131 502 Golden Gate Park  
956 956 173 108 146 150 103 131 502 Civic Center Plaza  
957 957 173 108 146 150 103 131 502 500 Grove Street  
958 958 173 108 146 150 103 131 502 600 Octavia Street  
959 959 173 108 146 150 103 131 502 535 Octavia Street  
960 960 173 108 146 150 103 131 502 Patricia's Green  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIRTUAL TABLE "Film_Locations_in_San_Francisco_fts" USING FTS4 ("Title", "Production Company", "Director", "Writer", "Actor 1", "Actor 2", "Actor 3", "Locations", "Fun Facts", content="Film_Locations_in_San_Francisco");
Powered by Datasette · Query took 134.225ms · Data source: data.sfgov.org