Proj 3- 2D Matrix Spatial Map

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

Proj 3- 2D Matrix Spatial Map

Post by glegrady » Fri Feb 01, 2013 12:00 am

The assignment is to create a 2D spatial map where 3 sets of data are compared to each other and positioned in a x,y,z position. Z can represent depth, through brightness. Coloration or form deviation may be the way to compare the two.

The first step is to decide how your data will map itself within a 2D space. You may have time mapped horizontally (hours of the day) and media type mapped vertically, or the whole Dewey sequence from 0-999. Top layer may be 2010, bottom layer may be 2011. Transparency would allow us to see differences.

Another approach may be to compare Dewey in the top layer, and non-Dewey in the bottom layer. Or the comparison could be the same dataset contrasted according some other aspect of the metadata we have: collcode, item type, etc.

This project will require some thinking of what could be compared, followed by SQL queries to see if there are interesting results, and then to make visualization tests.

To stimulate thinking Scientific Visualization PhD candidate Basak Alper will come and present her research on February 5. In preparation for this, please read her article "Weighted Graph Comparison Techniques for Brain Connectivity Analysis".

For visual stimulus, the Visual Complexity website has many examples of both node-connected data and matrix mapping: http://www.visualcomplexity.com/vc/

http://www.mat.ucsb.edu/basak.alper/
George Legrady
legrady@mat.ucsb.edu

anastasiya
Posts: 6
Joined: Fri Jan 11, 2013 10:32 am

Re: Proj 3- 2D Matrix Spatial Map

Post by anastasiya » Sun Feb 10, 2013 6:50 pm

Hi guys,

I changed my idea, I used the code that Yoon wrote to show the ranks of the dewey classes in each hour and modified it so that you can look across each row (dewey category) and see how it's rank changes based on the brightness of the squares. You can see for example that dewey class 789 falls in rank at 8 and 9 am and also see how much the ranks fluctuate for each class based on the diference in brightness.

Also you can look at the vertical columns to see how the categories compare in rank to each other.
Screenshot and code attached.
Attachments
HW3.2.jpg
Simple2DSpatialMap_V8.zip
Alternate version
(4.71 KiB) Downloaded 298 times
HW 3 Pic.jpg
Screenshot
Simple2DSpatialMap_V7.zip
Processing File
(4.71 KiB) Downloaded 284 times
Last edited by anastasiya on Wed Feb 13, 2013 8:34 pm, edited 3 times in total.

bkang
Posts: 5
Joined: Fri Jan 11, 2013 10:32 am

Re: Proj 3- 2D Matrix Spatial Map

Post by bkang » Mon Feb 11, 2013 11:08 pm

My doodle is here.

https://docs.google.com/document/d/1LdT ... oyiaa8/pub

And my final code(sketch) is attached below.

thanks!
Attachments
socialmedia_pie.zip
(378.48 KiB) Downloaded 285 times
Last edited by bkang on Thu Feb 14, 2013 11:34 am, edited 1 time in total.

ytang
Posts: 5
Joined: Fri Jan 11, 2013 10:37 am

Re: Proj 3- 2D Matrix Spatial Map

Post by ytang » Tue Feb 12, 2013 1:39 am

Here is my doodle link.

https://docs.google.com/file/d/0BxTPhw- ... YtVEU/edit


Yeu-Shuan Tang
Attachments
MAT259proj3.docx
description
(335.48 KiB) Downloaded 266 times
Screen Shot 2013-03-26 at 4.08.45 PM.png
Screen Shot 2013-03-26 at 4.07.19 PM.png
Screen Shot 2013-03-21 at 12.26.02 AM.png
Screen Shot 2013-03-20 at 10.38.38 PM.png
proj3_yeushuan.zip
(9.21 KiB) Downloaded 285 times
Last edited by ytang on Tue Mar 26, 2013 3:25 pm, edited 5 times in total.

ramon.rovirosa
Posts: 5
Joined: Tue Jan 15, 2013 1:22 pm

Re: Proj 3- 2D Matrix Spatial Map

Post by ramon.rovirosa » Tue Feb 12, 2013 10:45 am

Link to my Project 3:

https://docs.google.com/document/d/1lmL ... sp=sharing

The following visualization is an interactive ranking of the top six food cuisines at the Seattle Public Library by month. For example, the first month desert was the most popular food item followed by Spanish, Chinese, French, Vegetarian, and then Italian food.

If you hover over a rectangle it displays the rank for that food cuisine over the 5 years so you can more easily see the changes in ranking over the months.
Attachments
proj2.jpg
proj_2.jpg
food_2d.zip
(11.95 KiB) Downloaded 276 times
IMG_5299.JPG
Last edited by ramon.rovirosa on Wed Feb 27, 2013 11:59 pm, edited 5 times in total.

gstocking
Posts: 3
Joined: Fri Jan 11, 2013 10:36 am

Re: Proj 3- 2D Matrix Spatial Map

Post by gstocking » Tue Feb 12, 2013 11:11 am

Here is mine:
https://docs.google.com/document/d/16Ct ... sp=sharing

Attached is the zip file. Writeup is coming soon.
Attachments
assignment_3.zip
(6.18 MiB) Downloaded 279 times
Last edited by gstocking on Tue Feb 19, 2013 9:38 am, edited 2 times in total.

saeedm
Posts: 6
Joined: Tue Jan 15, 2013 1:21 pm

Re: Proj 3- 2D Matrix Spatial Map

Post by saeedm » Tue Feb 12, 2013 11:34 am

Sketch:
https://docs.google.com/drawings/d/1y7m ... X99LE/edit

Intro

I was curious to see how the current most popular dewey categories ranked 6 years back.

Query


select
year(activity.o) as 'Year',
sum(case when (dewey.dewey = 811) then 1 else 0 end) as '811 Poetry',
sum(case when (dewey.dewey = 599) then 1 else 0 end) as '599 Food & Drink',
sum(case when (dewey.dewey = 746) then 1 else 0 end) as '746 Textile Arts',
sum(case when (dewey.dewey = 398) then 1 else 0 end) as '398 Folklore',
sum(case when (dewey.dewey = 613) then 1 else 0 end) as '613 Health',
sum(case when (dewey.dewey = 616) then 1 else 0 end) as '616 Diseases',
sum(case when (dewey.dewey = 796) then 1 else 0 end) as '796 Sports',
sum(case when (dewey.dewey = 917) then 1 else 0 end) as '917 North America',
from
dewey, activity
where
dewey.bib = activity.bib and
dewey.dewey in (811, 599, 746, 398, 613, 616, 796, 917, 5) and
year(activity.o) in (2006, 2012)
group by year(activity.o);

Query Explanation

Each of the chosen dewey categories is queried, and the checkout occurrences are tallied with the 'sum' SQL function, then grouped by year.

Results and Analysis

Since I wanted to visualize the counts from both years simultaneously, and both years had data for the same categories, I thought a 'web graph' was perfect. These graphs are typically used for displaying personality traits, each axis being a different personality. Here each axis represents one of the preselected dewey categories, and by making the polygonal shape that stretches across the axes translucent, both years are visible. I considered including data from the years in between, but this method broke down with any additional translucent layers as the colors could no longer be differentiated from the graph.
Attachments
saeed_pj3.zip
Code
(2.96 KiB) Downloaded 265 times
pj3screenshot.png
Screenshot
MAT 259 - Project 3 (2D) - Sketch.png
Sketch
saeed_pj3_iter1.pdf
Iteration 1 PDF
(22.36 KiB) Downloaded 269 times
Last edited by saeedm on Tue Mar 26, 2013 11:14 pm, edited 5 times in total.

andrewwaranis
Posts: 5
Joined: Fri Jan 11, 2013 10:38 am

Re: Proj 3- 2D Matrix Spatial Map

Post by andrewwaranis » Tue Feb 12, 2013 12:28 pm

Mostly a sketch at the moment: http://www.uweb.ucsb.edu/~andrewwaranis ... project_3/ .
Once I straighten this out, I can code the backend and compose my query.

Download: http://www.uweb.ucsb.edu/~andrewwaranis ... /dw_2d.zip .
Last edited by andrewwaranis on Thu Feb 14, 2013 11:27 am, edited 1 time in total.

giovanni
Posts: 24
Joined: Fri Oct 12, 2012 9:27 am

Re: Proj 3- 2D Matrix Spatial Map

Post by giovanni » Wed Feb 13, 2013 8:11 pm

[edit]

I finally got my laptop back working...
Trying to improve the previous projects
hw3.jpg
upgraded version
topdvd.jpg



Project description
https://docs.google.com/document/d/1672 ... qmH6s/edit#


Sketch

[The extension rar has been deactivated and can no longer be displayed.]

Last edited by giovanni on Wed Mar 27, 2013 11:29 am, edited 7 times in total.


Post Reply