Film_Locations_in_San_Francisco

Data source: data.sfgov.org

23 rows where Director = 40

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
211 Bullitt 42 1968 31 Bayshore Blvd near Cesar Chavez (Bayview)   Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
212 Bullitt 42 1968 31 Taylor & Vallejo Streets (Russian Hill)   Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
214 Bullitt 42 1968 31 SF General Hospital Center (1001 Potrero Avenue, Potrero Hill) SF General Hospital is the only Level I Trauma Center serving San Francisco and northern San Mateo County. Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
215 Bullitt 42 1968 31 McLaren Park (Visitacion Valley) McLaren Park is the 2nd largest park in San Francisco, after Golden Gate Park. Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
216 Bullitt 42 1968 31 Mark Hopkins Hotel (999 California Street) The Top of the Mark lounge and restaurant at the top of the hotel was formerly a penthouse suite. Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
217 Bullitt 42 1968 31 Marina Green (Marina District) Before the 1906 earthquake, the land on which Marina Green sits was a tidal marsh, and rubble from the earthquake was dumped on the site. However, the site was filled in to provide land for the 1915 Panama-Pacific Exhibition. Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
218 Bullitt 42 1968 31 Mansell & University Streets (Visitacion Valley)   Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
219 Bullitt 42 1968 31 Larkin & Francisco Streets (Russian Hill)   Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
220 Bullitt 42 1968 31 Larkin & Chestnut Streets (Russian Hill)   Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
221 Bullitt 42 1968 31 Kennedy Hotel (226 Embarcadero at Howard Street) Hotel was destroyed in the 1989 Loma Prieta earthquake. Corporate headquarters for the Gap reside at the location today. Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
222 Bullitt 42 1968 31 John Muir Drive (Lake Merced)   Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
223 Bullitt 42 1968 31 Intersection of York & Peralta (Bernal Heights)   Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
224 Bullitt 42 1968 31 Filbert & Taylor Streets (Russian Hill)   Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
225 Bullitt 42 1968 31 Enrico's Café (504 Broadway)   Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
226 Bullitt 42 1968 31 Columbus & Lombard Streets (North Beach)   Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
227 Bullitt 42 1968 31 Cesar Chavez & Mission Street (Mission)   Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
228 Bullitt 42 1968 31 Candlestick Park Exit, Highway 101   Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
229 Bullitt 42 1968 31 Café Cantata (2040 Union Street)   Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
230 Bullitt 42 1968 31 Brocklebank Apartments (1000 Mason Street)   Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
231 Bullitt 42 1968 31 Bay Bridge Before opening in 1936, the bridge was blessed by Cardinal Secretary of State Eugenio Pacelli, who later became Pope Pius XII. Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
232 Bullitt 42 1968 31 2700 Vallejo Street (Pacific Heights)   Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
233 Bullitt 42 1968 31 20th & Vermont Streets (Potrero Hill) The most crooked street in San Francisco is actually Potrero Hill's Vermont Street between 20th St & 22nd St. Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
234 Bullitt 42 1968 31 1153-57 Taylor Street Embarcadero Freeway, which was featured in the film was demolished in 1989 because of structural damage from the 1989 Loma Prieta Earthquake) Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Film_Locations_in_San_Francisco" (
"Title" INTEGER,
  "Release Year" INTEGER,
  "Locations" TEXT,
  "Fun Facts" REAL,
  "Production Company" INTEGER,
  "Distributor" INTEGER,
  "Director" INTEGER,
  "Writer" INTEGER,
  "Actor 1" INTEGER,
  "Actor 2" INTEGER,
  "Actor 3" INTEGER
,
FOREIGN KEY ("Title") REFERENCES [Title](id),
    FOREIGN KEY ("Director") REFERENCES [Director](id),
    FOREIGN KEY ("Actor 2") REFERENCES [Actors](id),
    FOREIGN KEY ("Actor 1") REFERENCES [Actors](id),
    FOREIGN KEY ("Writer") REFERENCES [Writer](id),
    FOREIGN KEY ("Release Year") REFERENCES [Release Year](id),
    FOREIGN KEY ("Actor 3") REFERENCES [Actors](id),
    FOREIGN KEY ("Production Company") REFERENCES [Production Company](id),
    FOREIGN KEY ("Distributor") REFERENCES [Distributor](id));
CREATE INDEX ["Film_Locations_in_San_Francisco_Title"] ON [Film_Locations_in_San_Francisco]("Title");
CREATE INDEX ["Film_Locations_in_San_Francisco_Director"] ON [Film_Locations_in_San_Francisco]("Director");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 2"] ON [Film_Locations_in_San_Francisco]("Actor 2");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 1"] ON [Film_Locations_in_San_Francisco]("Actor 1");
CREATE INDEX ["Film_Locations_in_San_Francisco_Writer"] ON [Film_Locations_in_San_Francisco]("Writer");
CREATE INDEX ["Film_Locations_in_San_Francisco_Release Year"] ON [Film_Locations_in_San_Francisco]("Release Year");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 3"] ON [Film_Locations_in_San_Francisco]("Actor 3");
CREATE INDEX ["Film_Locations_in_San_Francisco_Production Company"] ON [Film_Locations_in_San_Francisco]("Production Company");
CREATE INDEX ["Film_Locations_in_San_Francisco_Distributor"] ON [Film_Locations_in_San_Francisco]("Distributor");
Powered by Datasette · Query took 30.304ms · Data source: data.sfgov.org