Books and Technology
MAT 259, 2016
Technology continues to become apart of our lives a little more everyday. Just think about the smartphone in your pocket and the laptop you carry in your bag everywhere. The demand for engineers and computer scientists for future innovation has never been higher. With this in mind I wanted to looks into if the public of Seattle follow that same trend. Using MySQL I wrote queries that looked in to the checkout rates per year of specific Dewey Classes that include:
000 to 100 (Computer Science)
600 to 610 (Technology)
620 to 630 (Engineering)
740 to 741 (Graphic Arts)
776 to 777 (Computer/Digital Art)
deweyClass AS Dewey,
SUM(CASE WHEN YEAR(checkOut) = 2006 THEN 1 ELSE 0 END) AS '2006',
SUM(CASE WHEN YEAR(checkOut) = 2007 THEN 1 ELSE 0 END) AS '2007',
SUM(CASE WHEN YEAR(checkOut) = 2008 THEN 1 ELSE 0 END) AS '2008',
SUM(CASE WHEN YEAR(checkOut) = 2009 THEN 1 ELSE 0 END) AS '2009',
SUM(CASE WHEN YEAR(checkOut) = 2010 THEN 1 ELSE 0 END) AS '2010',
SUM(CASE WHEN YEAR(checkOut) = 2011 THEN 1 ELSE 0 END) AS '2011',
SUM(CASE WHEN YEAR(checkOut) = 2012 THEN 1 ELSE 0 END) AS '2012',
SUM(CASE WHEN YEAR(checkOut) = 2013 THEN 1 ELSE 0 END) AS '2013',
SUM(CASE WHEN YEAR(checkOut) = 2014 THEN 1 ELSE 0 END) AS '2014'
(deweyClass > 000 AND deweyClass < 100)
OR (deweyClass >= 600 AND deweyClass < 610)
OR (deweyClass >= 620 AND deweyClass < 630)
OR (deweyClass >= 740 AND deweyClass < 741)
OR (deweyClass >= 776 AND deweyClass < 777)
GROUP BY deweyClass
ORDER BY SUM(CASE
(YEAR(checkOut) >= 2006 OR YEAR(checkOut) <= 2014)
THEN 1 ELSE 0
When starting the project I always liked the idea of using size to reflect quantity. The sketch below is a simple mock up of what I hoped to achieve.
With this project the y-axis is the years from 2006 to 2015. The x-axis is the different Dewey Classes. The amount of checkouts for each of the Dewey Classes is reflected by the size of the ellipse shown in the data matrix as well as the color. The bigger the circle the more checkouts of books pertaining to the Dewey Class there is.
The visualization brings clarity to how many books that are related to technology are being checked out per year by the people of Seattle. The data reveals that as the years go by the public tends to check out books related to technology less frequently. This can be due to the fact that books, articles and other print related media is accessible online.
Here are a few shots of the final product.
This first image is using a greyscale colorscheme while the other two images that follow use a color scheme according to color map JPEG images that are included.