Chinese Related Books Interests at Seattle Public Library (2006 - 2022)
MAT 259, 2023
Zeyu Wang

Concept
In my project 2, I implemented The Chinese Related Books Interests at Seattle Public Library visualization, an interactive 3D environment allowing users to explore the library's circulation data from 2006 to 2022. It has two main views, the plot and the point of view. The plot view displays a plot that shows the checkout number of Chinese-related books over time, with a focus on the top 50 popular books. The point view presents a 3D visualization of popular books over time, highlighting trends in five-year intervals. Together, these views offer a comprehensive picture of the popularity of Chinese-related books at the Seattle Public Library, making it easy for users to understand the trends and identify popular titles.

Query
SELECT COUNT(title) AS Counts, title, deweyclass FROM ( SELECT DISTINCT id, barcode, itemNumber, itemtype, title, cout, CASE WHEN deweyclass > 000 and deweyclass < 100 THEN 0 WHEN deweyclass >= 100 and deweyclass < 200 THEN 1 WHEN deweyclass >= 200 and deweyclass < 300 THEN 2 WHEN deweyclass >= 300 and deweyclass < 400 THEN 3 WHEN deweyclass >= 400 and deweyclass < 500 THEN 4 WHEN deweyclass >= 500 and deweyclass < 600 THEN 5 WHEN deweyclass >= 600 and deweyclass < 700 THEN 6 WHEN deweyclass >= 700 and deweyclass < 800 THEN 7 WHEN deweyclass >= 800 and deweyclass < 900 THEN 8 WHEN deweyclass >= 900 and deweyclass < 1000 THEN 9 ELSE deweyclass END AS deweyclass FROM spl_2016.outraw INNER JOIN spl_2016.subject ON outraw.bibNumber = subject.bibNumber WHERE subject.subject LIKE '%chinese' OR subject.subject LIKE '%china%' ) AS A WHERE YEAR(cout) = 2006 and deweyclass != '' GROUP BY title, deweyclass ORDER BY Counts DESC LIMIT 50;

Preliminary sketches
Please put your sketches here with some explanations.






Process
Please put your work-in-progress images or screen shots here with some explanations.






Final result
Please put your final images or screen shots here with some explanations.






Code
All work is developed within Processing
Source Code + Data