Dataset: Film Locations In San Francisco

About this Dataset

Film Locations In San Francisco

Update - Dec 17, 2024: Columns for the latitude and longitude of the film location, supervisor district, and analysis neighborhood have been added to the datasets. A blank value means geocoding was not possible based on the location description. If you love movies, and you love San Francisco, you're bound to love this -- a listing of filming locations of movies shot in San Francisco starting from 1915. You'll find the titles, locations, fun facts, names of the director, writer, actors, and studio for most of these films.
Organization: City of San Francisco
Last updated: 2020-11-10T16:57:06.930284
Tags: actors, directors, film, locations, movies

Tables

Table 1

@usgov.city_of_san_francisco_film_locations_in_san_francisco.table_1

164.51 KB
2084 rows
21 columns


CREATE TABLE table_1 (
  "title" VARCHAR,
  "release_year" BIGINT,
  "locations" VARCHAR,
  "fun_facts" VARCHAR,
  "production_company" VARCHAR,
  "distributor" VARCHAR,
  "director" VARCHAR,
  "writer" VARCHAR,
  "actor_1" VARCHAR,
  "actor_2" VARCHAR,
  "actor_3" VARCHAR,
  "point" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "analysis_neighborhood" VARCHAR,
  "supervisor_district" DOUBLE,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR,
  "sf_find_neighborhoods" DOUBLE,
  "analysis_neighborhoods" DOUBLE,
  "current_supervisor_districts" DOUBLE
);