. Concept description
This project continued the concept from my previous assignment, with the addition of lines connecting checkout instances of the same title together. This highlights items that are checked out more than once, since it is the case with many of them.
This project is an extension of my 2D project. Each checkout instance is represented as a point that float from a certain distance y on the same plane as others. I used x axis to represent each day and hour of the month, y axis to represent the duration for which the item is kept, and y axis to represent each day and month of the year of 2016. Curved lines are drawn to connect checkout instances that share the same title, therefore tracking the checkout activity of that particular title throughout the year.
The x axis is very long, the visualization was intended as a "road" the the user goes through.
. MySQL Queries
SELECT title, (title LIKE '%depression%' AND title NOT LIKE '%great depression%' AND title NOT LIKE '%new deal%') AS depression, (title LIKE '%melanchol%') AS melancholia, (title LIKE '%boredom%') AS boredom, (title LIKE '%tedium%') AS tedium, -- (title LIKE '%ennui%') AS ennui MONTH(cout), DAY(cout), HOUR(cout), MONTH(cin), DAY(cin), HOUR(cin) FROM spl_2016.inraw WHERE DATE(cout) BETWEEN '2016-01-01' AND '2016-12-31' AND(HOUR(cout) BETWEEN 10 and 20) AND (-- title LIKE '%schizophrenia%' -- OR title LIKE '%bipolar%' (title LIKE '%depression%' AND title NOT LIKE '%great depression%' AND title NOT LIKE '%new deal%') OR title LIKE '%melanchol%' OR title LIKE '%boredom%' OR title LIKE '%tedium%' -- OR title LIKE '%ennui%' ) GROUP BY title , MONTH(cout), DAY(cout),HOUR(cout),MONTH(cin),DAY(cin),HOUR(cin) ORDER BY MONTH(cout) ASC,DAY(cout) ASC LIMIT 500
. Processing time
The query took 71 seconds.
. Sketches and work-in-progress screenshots
. Final Results
Proj 3 - 3D Visualization
Jump to
- Courses
- ↳ MAT 594CM
- ↳ Spring 2010
- ↳ Winter 2011
- ↳ MAT 200A
- ↳ Fall 2010
- ↳ Art 130
- ↳ Fall 2010
- ↳ Winter 2012
- ↳ Fall 2012
- ↳ MAT 201B
- ↳ Fall 2010
- ↳ MAT 259
- ↳ Winter 2011
- ↳ Winter 2012
- ↳ Winter 2013
- ↳ Winter 2014
- ↳ Winter 2015
- ↳ Winter 2016
- ↳ Winter 2017
- ↳ Winter 2018
- ↳ Winter 2019
- ↳ Winter 2020
- ↳ Winter 2021
- ↳ Winter 2022
- ↳ Winter 2023
- ↳ Winter 2024
- ↳ ART 102
- ↳ Winter 2011
- ↳ Spring 2012
- ↳ Winter 2013
- ↳ NMDS 551
- ↳ MAT 594CR
- ↳ Spring 2012
- ↳ MAT 254
- ↳ Fall 2013
- ↳ Fall 2014
- ↳ MAT 265
- ↳ Spring 2016
- ↳ Fall 2022
- ↳ Winter 2023
- ↳ ART 185GL
- ↳ Spring 2017
- ↳ Spring 2018
- ↳ MAT 594G
- ↳ Fall 2020
- ↳ MAT 255
- ↳ Spring 2021
- ↳ Spring 2022
- ↳ Fall 2022
- ↳ Fall 2023