Civic Art Collection by US Government | Demographics and Population Studies

About this Dataset

Civic Art Collection

A. SUMMARY This data set includes all of the publicly-sited works in the Civic Art Collection, which includes historic monuments, murals, and artworks commissioned through the City's Public Art Program. The data set includes the following categories: artist name, title of work, medium, dimensions and location. The location also includes the Cultural Districts and Supervisor District that an artwork resides in. B. HOW THE DATASET IS CREATED Dataset is exported manually by staff from internal collections database and re-formatted manually by staff. C. UPDATE PROCESS Dataset is updated as needed manually by staff. D. HOW TO USE THIS DATASET Artworks may be located at a specific addresses (traditional building number, street name format) or other locations (City Parks, Piers, SFO, etc.) that don't meet the traditional address format; in these cases, the closest intersection or building address has been used. Please look at the "Location Description" field for the location of the artwork (floor 2, International terminal, Northwest corner, etc.). An individual artwork can consist of a single piece or multiple pieces, this will be reflected in the last part of it's accession number with either a letter or number (i.e. 1904.2.a-b or 1999.22.1-2). A single artwork may have multiple entries, one for each part, or may have a single group entry. Therefore, the number of entries is not equivalent to the number of artworks. Generally, if an artworks' pieces are spread out over a distance, each piece will have an entry and if they are grouped at one location, there will be one group entry. When an artwork spans multiple blocks one end point was chosen for the address/map point. 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.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:51.892104
Tags: art, artist, artworks, civic-art, san-francisco-arts-commission, sfarts, sfo

Tables

Table 1

@usgov.city_of_san_francisco_civic_art_collection.table_1

129.43 KB
1038 rows
28 columns


CREATE TABLE table_1 (
  "creation_date" VARCHAR,
  "accession_number" VARCHAR,
  "artist" VARCHAR,
  "credit_line" VARCHAR,
  "display_title" VARCHAR,
  "display_dimensions" VARCHAR,
  "medium" VARCHAR,
  "media_support" VARCHAR,
  "facility" VARCHAR,
  "current_location" VARCHAR,
  "location_description" VARCHAR,
  "street_address_or_intersection" VARCHAR,
  "zip_code" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "number_of_districts" BIGINT,
  "cultural_districts" VARCHAR,
  "supervisor_district" DOUBLE,
  "analysis_neighborhood" VARCHAR,
  "the_geom" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR,
  "current_supervisor_districts" DOUBLE,
  "analysis_neighborhoods" DOUBLE,
  "neighborhoods" DOUBLE,
  "recreation_and_parks_properties" DOUBLE,
  "sf_find_neighborhoods" DOUBLE,
  "current_police_districts" DOUBLE
);