Relations between weather and book checkout
MAT 259, 2015
Intae

Concept
The goal of this assignment was manipulate the arrangement to find out some kinds of relationship between number of book check out to weather in Seattle.

Query

SELECT
SUM(case When deweyClass > '741.49' and deweyClass < '741.6' then 1 else 0 end) as Comic,
SUM(case When deweyClass = '741.5952' then 1 else 0 end) as Japan,
SUM(case When deweyClass = '741.5973' then 1 else 0 end) as US

FROM
spl2.inraw

WHERE
DATE(cout) > '20121122'
AND DATE(cout) < '20121210'

LIMIT 100000


Preliminary sketches
Based on last CSV file, I rearranged the checkout number of each categories "Comic book entire", "American comic book", "Japanese comic book", and "Harry Potter"related books. The goal of this assignment was manipulate the arrangement to find out some kinds of relationship between number of book check out to weather in Seattle.




Process
There are three buttons in the rendering. I put the average high temperature and average precipitation in Seattle of the last severals decades. I was able to find it there was increasing when the temperature was high and precipitation was low.




Final result
The color is matching with each month's temperature and precipitation. You can see that during winter period, there were decreasing of check outs. I would said that this indicate that people like to go to library when the weather is nice. I also need to do more invention the button and slide to show the exact connection between different integers.








Code
I used Processing.

Control: Average Temperature High
Average Precipitation High
Number pop up
Chagne arrangement X,Y
Draw circle by each months

Source Code + Data