3D Visualization | SPL DIY Media
MAT 259, 2018
Adam Jahnke

Concept
This 3D visualization is meant to reflect all the different types of DIY (Do It Yourself) media offered through the Seattle Public Library. The mySQL search was fairly basic but yielded over 5000 results. I did end up editing out close to 500 results. The eliminated results did not contain a checkout date or checkout time.

Query
SELECT bibNumber, itemType, COUNT(bibNumber) AS Counts FROM spl_2016.inraw WHERE title Like '%DIY%' GROUP BY bibNumber , itemType ORDER BY Counts DESC

Preliminary sketches
This code and project relied on the help provided by insructor Rodger Luo.






Process
Work-in-progress image. This is the inital mapping of the data.






Final result
Final images. Once I got the data where I needed it, we are now able to see the the mapping of date, time, and frequncy of all of the types of media availabe at SPL that somehow invovles DIY culture.






Code
All work is developed within Processing
Source : Adam Jahnke Project 3