Image of “Maru” by Gerard Tsutakawa at the University of Washington, Tacoma.
The dataset used in creating this project was the Washington State Art Collection. The dataset is available via data.WA.gov, the open data portal for the State of Washington. The link to the state art collection is: https://data.wa.gov/Education/State-Art-Collection/yfjt-f6ae
There were a few, small steps in preparing the data for analysis. Working from the full data set of the collection, I filtered the column 'Artwork Site' by 'College' and 'University' and saved this filtered list as the dataset that I would use for analysis. In looking at the full list of colleges and universities represented in the database, I noticed there was a middle and a high school that had 'University' in their school name, I removed these entries from the data.
Additionally, I reached out to the Washington State Arts Commission to clarify the meaning of the 'Date' column and learned that it referred to either the date the artwork was installed or the date the work was created (if it was created prior to being acquired by the state). I learned that the year represented in the column 'ID Number' - where entries were formatting as 'WSAC1977.025.000' - indicated the year of acquisition for the state collection. I used OpenRefine to separate this column into multiple columns, separated after WSAC and each period, I then removed all the columns except for the one containing the year. This column became the year of acquisition.
In mapping the latitude and longitude coordinates, there were two art pieces whose longitude coordinates were missing a period, making them a value in the hundreds of thousands and impossible to map. I added a decimal place after the third digit, to generate a coordinate that matched the others in the dataset and would come up as in the state of Washington. I used Excel for most of my data cleaning and manipulation, creating additional sheets to count the number of unique institutions represented and how many pieces were at each, for example.
Finally, information about the artists' educational background was gathered from a range of sources; including, the ArtsWA database, artist, collective, and gallery websites, artist Wikipedia pages, obituaries, and newspaper articles.
The data visualizations for this project were created using Tableau Public, Flourish, Sutori, and Mapchart.net. I used Tableau Public to create the density map of the artwork pieces, the line graph showing how many pieces were acquired by each institution in each year, as well as the visualizations showing the proportions of artwork and artists affiliated with various institutions. I used Flourish to create the line chart showing acquisitions over time as well as a bubble chart that I used to show the shift towards site-specific, commissioned pieces. The latter chart was initially created in Excel and then I shifted to Flourish to be able to embed the chart with more interactive features (i.e. if you hover over any of the bubbles, information about that point of data appears). I used Mapchart to create a quick map showing the states with active and inactive percent for art programs.
Finally, I used Sutori to create the embedded timeline of percent for arts programs in the United States. The majority of the data for the timeline came from a list of programs maintained by the National Assembly of State Art Agencies as well as each state program's website (often the site for the local arts commission or council). I added in information about two states no longer on the list: North Carolina and Wisconsin, but was unable to find information about Michigan's old percent for art program.
This perspective I take in this project, looking at public art through the specific context of higher education, is informed by my academic and research background in the field of higher education. Additionally, I come to the project as someone who has volunteered and supported the work of Art in the Park, Worcester since its first exhibit in 2008. AIP Worcester is a large-scale public art exhibit at historic Elm Park, in Worcester, Massachusetts. My interest in public art has been shaped by this experience with public art in my hometown during my college years.