Proj 3- 2D Matrix Spatial Map

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

Proj 3- 2D Matrix Spatial Map

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/

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

Re: Proj 3- 2D Matrix Spatial Map

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
Simple2DSpatialMap_V8.zip
Alternate version
Screenshot
Simple2DSpatialMap_V7.zip
Processing File
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

My doodle is here.

And my final code(sketch) is attached below.

thanks!
Attachments
socialmedia_pie.zip
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

Yeu-Shuan Tang
Attachments
MAT259proj3.docx
description
proj3_yeushuan.zip
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

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
food_2d.zip
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

Here is mine:

Attached is the zip file. Writeup is coming soon.
Attachments
assignment_3.zip
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

Sketch:

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
Screenshot
Sketch
saeed_pj3_iter1.pdf
Iteration 1 PDF
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

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.

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

I finally got my laptop back working...
Trying to improve the previous projects

Project description