WCA World Simulation

fw

fw

Regular
Joined
Aug 1, 2007
Messages
120
Hey guys,

I started to play around with the new SQL export of the WCA database, which Stefan provided us with some time ago (thanks again). I tried to visualize the data a bit, I hope you like it :-)

[youtubehd]Exfm1LTQ_90[/youtubehd]

You can download a little-better-quality version of this video here: http://hackvalue.de/cubing/media/gource.avi

If you still want better quality (to read all the little text labels, etc.), download "gource" and load the original data, available here: http://hackvalue.de/cubing/media/gource.dat.gz

Enjoy!
Flo
 
Last edited by a moderator:
It looks cool, but I don't under stand it.. does each branch represent a country? Or an event? Or a competition? When a dot leaves the visual is it because they stopped being active?
 
Every competition is one node, which itself has one leaf-node for each of its events. The dots disappear after some time and the competitors disappear if they are inactive (and come back if they are active again). I just wanted to show how many competitions there are (and where, the tree is structured by country (although the structure is of course not geographically correct in any way)) and how many people (and which) "move around" between those competitions. I think its very funny if you "follow" people like Lars or Ron, who attended many competitions (and therefore their icon almost never disappears ;-)).
 
Cyrus C. said:
What program was this made in. What date is this up to?
Click to expand...
Read the video description. The program which visuallizes the data is called "gource" and is used to visualize the history of distributed version control systems (which is mainly used for big programming projects). I wrote a small script which reads Stefans SQL dump and creates a file which gource can understand. The SQL dump I used is some weeks old I think, but thats irrelevant because I aborted the video somewhere in 2008 because it was getting boring and nothing new happened (so dont try to find your name if your WCA ID begins with 2009 or 2010 :-)).
 
I laughed when it zoomed in on Tyson Mao and he disappeared.

Also, it highlighted Pembo for a second at 2:58! I wonder how he's doing....
 
Last edited:
You must log in or register to reply here.

Similar threads

Thomas.Caleb
MoYu WCA World Championship 2027
2
Replies
28
Views
1,317
Cubing_Grandson
Cubing_Grandson
Martyt7777
Where do you think WCA World Championships 2029 will be?
2
Replies
39
Views
5,358
acrystal
acrystal
CubeLite
What is World Class for every WCA event? Video is out!!
2
Replies
33
Views
4,161
CubeLite
CubeLite
abunickabhi
Rename WCA to World Twisty Puzzles Organization (WTPO)
2
Replies
31
Views
2,980
qwr
qwr
yes cubing
Scorecards from around the world
2
Replies
21
Views
1,976
cubenerd74
cubenerd74
Back
Top