Travel Book Checkouts from 2009 to 2014
MAT 259, 2016
Woohun Joo
Concept
I was curious about which area attracted people's attention the most during the vacation. To observe the differences between six dewey classes in a particular month and year, I referred to checkout counts in a travel book category (from 914 to 919) in the Seattle Public Library for 6 years (from 2009 to 2014).
914: Europe
915: Asia
916: Africa
917: North America
918: South America
919: Australasia, Pacific Ocean, Atlantic Ocean, Arctic islands, and Antarctica
914: Europe
915: Asia
916: Africa
917: North America
918: South America
919: Australasia, Pacific Ocean, Atlantic Ocean, Arctic islands, and Antarctica
Query
SELECT
FLOOR(deweyClass) AS Dewey,
MONTH(checkOut) AS MONTH,
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'
FROM
spl3._rawXmlDataCheckOuts
WHERE
deweyClass >= 914 AND deweyClass <= 919
GROUP BY MONTH, Dewey
Preliminary sketches
Color Classified by Dewey Class - Each Dewey Class has a particular hue.
Process
Height mapping with Color Variation 1 and 2.
The height of each shape, and hue values correspond to the checkout frequencies.
The height of each shape, and hue values correspond to the checkout frequencies.
Final result
Color Classified by Year.
Code