2.02 Proj 1: Processing Visualization Project

Post Reply
Posts: 160
Joined: Wed Sep 22, 2010 12:26 pm

2.02 Proj 1: Processing Visualization Project

Post by glegrady » Mon Jan 16, 2012 1:52 am

Please post your first processing built visualization project here. The project needs to include a SQL query, and be realized in Processing. Give a brief introduction as to what you aim to achieve and describe any aspects either visual or technical, you would like to bring attention to.
George Legrady

Posts: 10
Joined: Tue Jan 17, 2012 4:41 pm

Re: 2.2 Proj 1: Processing Visualization Project

Post by anisbharon » Sun Feb 12, 2012 5:34 pm

(1.06 KiB) Downloaded 349 times
Query: select year(ckoutDateTime) as year,count(*) from trans_2005_thru_2011 where year(ckoutDateTime)>2004 AND (title like "%the catcher in the rye%" OR title like "%Holden Caulfield%") group by year order by year;

A simple single query visualization. Minimal design, and use of color to fully utilize available space.

Posts: 14
Joined: Tue Jan 17, 2012 4:40 pm

Re: 2.2 Proj 1: Processing Visualization Project

Post by rjduranjr » Sun Feb 12, 2012 10:38 pm

Project 1 Revised
https://docs.google.com/document/d/17fv ... Z705o/edit

The goal of this project was to become familiar with writing an interesting query to determine the top 10 checked out DVD's of 2011. My idea as you can see from the sketches started out as an interactive timeline that allows the user to explore the top items of a specific itemtype over a time period. I ultimately simplified the project to show 10 items for 2011 to practice combining aesthetic elements with the data set.

Technically the project is pretty straight forward in its design. I am not implementing the mysql query inside the primary application. Instead I ran the query using a separate program(saveQueryAsText.zip) to save the data to a text file for loading into the main program (top10dvds.zip). This speeds up the process and allows for greater experimentation with the data set.

The basic functionality of the application can be seen quickly after launching it. As the user moves the mouse from left to right they are able to rotate the spiral of items to reveal which items are more popular. The black circles represent the volume of checkouts or total checkouts throughout the year.

Initial sketches can be seen in project1_sketches.jpg and a screenshot of the resulting application is shown in top10dvds.png.

What are the top 10 checked out DVD’s of 2011?

SELECT title, itemtype, count(*) FROM transactions2011 WHERE year(ckoutDateTime) = '2011' and itemtype like ‘%dvd%’ GROUP BY title ORDER BYcount(*) DESC LIMIT 10;
http://rjduran.net/MAT/259/project1/RJD ... oject1.pdf
http://rjduran.net/MAT/259/project1/pro ... etches.jpg
(2.77 KiB) Downloaded 292 times
(55.06 KiB) Downloaded 333 times
(75.01 KiB) Downloaded 302 times
Last edited by rjduranjr on Mon Feb 13, 2012 10:33 am, edited 3 times in total.

Posts: 9
Joined: Tue Jan 17, 2012 4:40 pm

Proj 1: Processing Visualization Project by Yoon Chung Han

Post by hanyoonjung » Mon Feb 13, 2012 4:24 am

Project 1: Processing Visualization Project
(with the Revised Data Mining Assignment)
by Yoon Chung Han

How much are Seattle people interested in Microsoft compared to Apple?


Seattle is known as the city where have many well-known interstate or international companies such as Starbucks, Amazon, Microsoft... There are many famous companies, especially IT companies found in Seattle. The best example can be “Microsoft”, one of the biggest IT companies in the world. When it comes to a rival relationship between Microsoft and Apple, I was curious how much Seattle people are caring about their famous worldwide company “Microsoft” and how much they express interests in Microsoft with checking-out Microsoft books, media, or any other references about Microsoft from Seattle Public Library. Also, I wondered if the boom of “Apple,” the rival company, attacked to Seattle as like other cities and countries in the world, and I assumed it might affect to change Seattle people’s interests toward Apple over years or just stay in Microsoft.

Regarding the mining queries, I searched the number of checked out items titled “%Microsoft% and “%Apple%” in 10 different categories of dewey classes and past 6 years (2005-2010). Additionally, I searched the most popular 10 items that was checked-out within 6 years, and made a list for each company.

Revised queries are here: https://docs.google.com/document/d/11QP ... BwvQk/edit

Visualization Design Concept

In this first project, I would like to explore the different way of visualizing the mining data in various designs, so I used the basic design elements such as bars, circles, and texts. There were three different information, and I used the three different design concepts for each data information. My first attempt was to contain all the information in one space, however it looked too overwhelmed and packed so it was hard to read the information clearly in one sight. Thus, I divided it into three pages, and users can change pages by pushing keys. The first design is a simple bar animation, which is a very intuitive and direct design. The length of each bar represents the number of checked-out items on each dewey category. The dewey list is on the right side of the design. The second design shows the circles of each year, and the radius of circles represent the number of checked-out items each year. If users roll over a mouse pointer at the center of the circles, the exact number of checked-out items with year number is appeared. Lastly, the last page contains the best 10 checked-out items, and there’s no interactivity. Overall, the clear color contrast between blue and red shows the rival relationship between Microsoft and Apple.



First Draft Design


Final Design

First page - Dewey class

Second page - Number of checked out items every year

Third page - Best 10 checked out items

Check the Final Design here: http://www.yoonchunghan.com/MAT259/Project1/index.html

Source code is here: http://www.yoonchunghan.com/MAT259/Proj ... oject1.zip

Project PDF file is here: http://www.yoonchunghan.com/MAT259/Proj ... oject1.pdf

Posts: 7
Joined: Tue Jan 17, 2012 4:08 pm

Re: 2.2 Proj 1: Processing Visualization Project

Post by ansh2201 » Mon Feb 13, 2012 6:59 pm

Project 1 - Visualization using Processing.

Question - What kind of patterns are observed in checkouts of various media types (books, cds and dvds) across Dewey categories?
The idea was to visualize the checkout patterns of users across Dewey categories and the media type it belonged to. The visualization type used for this visualization is a Split Bar Graph. Each layer has been color coded (HSV format) to visualize a different media type - 180,100,60 for CDs; 0,75,80 for Books and 40,75,80 for DVDs. The length of each layer signifies the number of transactions for that media type and the overall length of the bar signifies the total checkouts for that Dewey Category.

The query used for the project is

Code: Select all

count(case when itemtype like '%bk' then ckoutDateTime end) book, 
count(case when itemtype like '%cd%' then ckoutDateTime end) cd,  
count(case when itemtype like '%dvd' then ckoutDateTime end) dvd, 
count(ckoutDateTime) total 
from transactions2011 
where deweyClass <> 'null' and 
month(ckoutDateTime) = "+ monthIndex + " 
group by FLOOR(deweyClass/100)*100 
order by FLOOR(deweyClass/100)*100";
where monthIndex signifies the month for which the query is executing.

It is interesting to see that the Dewey category Arts dominates overall with the maximum number of transactions, followed by Technology. It is also important to see how various media types compare against each other. For many categories especially Computer Science, Philosophy, Literature, etc book seem to be the main choice of media type for users. Although CDs and DVDs together dominate books when it comes to Arts, which shows what kind media preferences users have for each Dewey category.

Some basic interactivity has been embedded into this project so as to enable user to browse through the various data sets and be able to compare them against each other. Left Mouse Click enables a user to go forth (from January to February) and the right click allows the user to go back (from February to January). Each block displays the individual numbers for each media type when the mouse is over that bar.

Screenshot 1
Screenshot 1 - January
Screenshot 2
Screenshot 2 - February
(99.72 KiB) Downloaded 293 times

Posts: 4
Joined: Tue Jan 17, 2012 4:39 pm

Re: 2.2 Proj 1: Processing Visualization Project

Post by muhammadhafiz » Tue Feb 14, 2012 1:10 am

Name: Muhammad Hafiz Wan Rosli
Course: MAT 259: Visualizing information - Project 1
Instructor: George Legrady
TA: Joshua Dickinson
Title: Color names in book titles
processing sketch
(3.5 KiB) Downloaded 212 times
screen shot
(229.65 KiB) Downloaded 341 times
color names in book titles.pdf
Brief concept | Query | Sketch
(1.99 MiB) Downloaded 189 times

Posts: 7
Joined: Tue Jan 17, 2012 4:42 pm

Re: 2.2 Proj 1: Processing Visualization Project

Post by davidgordonartist » Tue Feb 14, 2012 9:53 am

This graph visualizes the Seattle Public Library transactions from 2006-2011 to investigate the impact of the 2008 financial crisis. I compared the terms "debt", "invest(ing)", and "real estate" with the total transactions at the library during those years.

The titles containing "real estate" dropped in frequency throughout the period, perhaps reflecting a lack of confidence in the housing market. On the other hand, titles containing "debt" increased from 2007-9, possibly due to a growing concern around issues of personal debt and budgeting.

The queries:

select year(cout) as year,count(*) from inraw where title like '%debt%' and deweyClass != 'null' and year(cout) >= '2006' group by year order by year;
select year(cout) as year,count(*) from inraw where title like '%invest%' and deweyClass != 'null' and year(cout) >= '2006' group by year order by year;
'Real Estate'
select year(cout) as year,count(*) from inraw where title like '%real estate%' and deweyClass != 'null' and year(cout) >= '2006' group by year order by year;
Total Transactions
select year(cout) as year, count(*) from inraw where deweyClass != 'null' and year(cout) >= '2006' group by year order by year;

Full Processing code:
(2.28 MiB) Downloaded 281 times
Last edited by davidgordonartist on Mon Mar 19, 2012 1:35 pm, edited 1 time in total.

Posts: 7
Joined: Tue Jan 17, 2012 4:43 pm

Re: 2.2 Proj 1: Processing Visualization Project

Post by dallasmercer » Thu Feb 16, 2012 7:28 am

https://docs.google.com/document/d/1jRe ... -2i0w/edit

Here is a link to my Google Doc about Project 1 and I've attached a folder with my Processing files and Query info. Here's a quick overview too:
-My question was to explore the data of the total number of CD's checked out from years 2005-2010 to see if the Internet/Digital music portability has had any influence on music available in a public library.
-My idea for a visual in Processing was rather basic but new and challenging to me since I've never used it before. I sketched out a simple bar graph on paper and it seemed to be a clear and accurate way to visualize my question. Now I had to learn how to program this, with my query info, into Processing. (full project details & results in Google Doc link & attached folder. All processing files included in folder as well)
MAT259 Project.1
(161.85 KiB) Downloaded 177 times

Post Reply