Proj 3- 2D Matrix Spatial Map

Post Reply
Posts: 160
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:
George Legrady

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.
Alternate version
(4.71 KiB) Downloaded 215 times
HW 3 Pic.jpg
Processing File
(4.71 KiB) Downloaded 204 times
Last edited by anastasiya on Wed Feb 13, 2013 8:34 pm, edited 3 times in total.

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. ... oyiaa8/pub

And my final code(sketch) is attached below.

(378.48 KiB) Downloaded 209 times
Last edited by bkang on Thu Feb 14, 2013 11:34 am, edited 1 time in total.

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. ... YtVEU/edit

Yeu-Shuan Tang
(335.48 KiB) Downloaded 197 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
(9.21 KiB) Downloaded 210 times
Last edited by ytang on Tue Mar 26, 2013 3:25 pm, edited 5 times in total.

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: ... 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.
(11.95 KiB) Downloaded 209 times
Last edited by ramon.rovirosa on Wed Feb 27, 2013 11:59 pm, edited 5 times in total.

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: ... sp=sharing

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

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: ... X99LE/edit


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


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',
dewey, activity
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.
(2.96 KiB) Downloaded 193 times
MAT 259 - Project 3 (2D) - Sketch.png
Iteration 1 PDF
(22.36 KiB) Downloaded 180 times
Last edited by saeedm on Tue Mar 26, 2013 11:14 pm, edited 5 times in total.

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: ... project_3/ .
Once I straighten this out, I can code the backend and compose my query.

Download: ... / .
Last edited by andrewwaranis on Thu Feb 14, 2013 11:27 am, edited 1 time in total.

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


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

Project description ... qmH6s/edit#


[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