2.02 Proj 1: Processing Visualization Project

Post Reply
glegrady
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
legrady@mat.ucsb.edu

anisbharon
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

Screenshot.png
sketch01.zip
(1.06 KiB) Downloaded 344 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.

rjduranjr
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

Introduction
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.

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

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

hanyoonjung
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


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



Description:

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.


Doodles

Image



First Draft Design

Image


Final Design

Image
First page - Dewey class

Image
Second page - Number of checked out items every year

Image
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

ansh2201
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

select 
FLOOR(deweyClass/100)*100, 
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.

Interactivity
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.

Doodle
HW1.png
Doodle
Screenshot 1
January.png
Screenshot 1 - January
Screenshot 2
February.png
Screenshot 2 - February
Code
HW1-Revisited.zip
Code
(99.72 KiB) Downloaded 291 times

muhammadhafiz
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
Attachments
color_names_in_book_titles.zip
processing sketch
(3.5 KiB) Downloaded 211 times
visualization.pdf
screen shot
(229.65 KiB) Downloaded 340 times
color names in book titles.pdf
Brief concept | Query | Sketch
(1.99 MiB) Downloaded 188 times

davidgordonartist
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

gordon_frequency_screenshot.jpg
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:

'Debt'
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;
'Invest'
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:
gordon_frequency.zip
(2.28 MiB) Downloaded 279 times
Last edited by davidgordonartist on Mon Mar 19, 2012 1:35 pm, edited 1 time in total.

dallasmercer
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)
Attachments
Project.1processing_DM.zip
MAT259 Project.1
(161.85 KiB) Downloaded 175 times

Post Reply