Three-Dimensional Interactive Project
MAT 259, 2013
Scott Bcesar

Introduction
I wanted to extend my 2d comparative visualization, so I started by converting from averaging the 2 sets to defining the rectangle which bounds the two sets, then plotting those along the z axis. This qudrangle view I hoped would make the data presented in my first comperative 2d visulization more clear and easy to follow.

Query
select count(*) as count, sum(case when (title = "lord of the rings return of the king") then 1 else 0 end) as lotrrotk, sum(case when (title = "hobbit or There and back again") then 1 else 0 end) as hobbit, sum(case when (title = "game of thrones") then 1 else 0 end) as got, sum(case when (title = "name of the wind the kingkiller chronicle day 01") then 1 else 0 end) as notw, sum(case when (title = "american gods") then 1 else 0 end) as ag, year(o) as years, month(o) as months from title inner join activity on activity.bib=title.bib inner join collection on activity.item=collection.item where (title= "lord of the rings return of the king" or title = "hobbit or There and back again" or title = "game of thrones" or title = "name of the wind the kingkiller chronicle day 01" or title = "american gods") and year(o)>=2006 group by YEAR(o), MONTH(o) ASC limit 100

Results and Analysis





Code
I used Processing and Peasycam.

Run in Browser

Source Code


Control