About this Dataset

StreetSmArts Murals

A. SUMMARY StreetSmARTS is a Department of Public Works (DPW) graffiti abatement program, administered through the San Francisco Arts Commission (SFAC). The program connects artists with private property owners to create murals on their buildings, enhancing the character of the property and surrounding neighborhood, while deterring ongoing vandalism. B. HOW THE DATASET IS CREATED In 2017, an inventory was compiled manually by staff and it has been updated with each new mural created since. C. UPDATE PROCESS Dataset updated as needed manually by staff. D. HOW TO USE THIS DATASET The majority of murals have street addresses but a few have street intersections instead. The address is the building location but the mural may be on the side of the building or around the corner. The data column "number_of_districts" refers to how many Cultural Districts a mural is in. If a mural is in more than Cultural Districts, the districts will be listed in the "Cultural_District" column and separated by a semicolon. This is because cultural districts can overlap. The cultural heritage districts dataset is also available online.
Organization: City of San Francisco
Last updated: 2020-11-10T16:57:03.338016

Tables

Table 1

@usgov.city_of_san_francisco_streetsmarts_murals.table_1

18.45 kB
70 rows
18 columns

CREATE TABLE table_1 (
  "street_address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" BIGINT,
  "artist" VARCHAR,
  "year" VARCHAR,
  "number_of_districts" BIGINT,
  "cultural_districts" VARCHAR,
  "supervisor_district" BIGINT,
  "analysis_neighborhood" VARCHAR,
  "the_geom" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR,
  "analysis_neighborhoods" BIGINT,
  "neighborhoods" BIGINT,
  "sf_find_neighborhoods" BIGINT,
  "current_police_districts" BIGINT,
  "current_supervisor_districts" BIGINT
);