Differences

This shows you the differences between two versions of the page.

--- project:matchquote [2014/05/24 23:13] – [Data] tamberg
+++ project:matchquote [2014/05/25 21:39] (current) – tagged loleg
@@ Line 13: / Line 13: @@
 {{https://farm6.staticflickr.com/5579/14258525474_be82667a8c_z.jpg}}
-Foosball is usually played to 7 or 10 goals. In order to match the ongoing foosball game to a soccer game we have to slightly change the rules. Our foosball game is played for 9 minutes (a tenth of 90 minutes). We further assume that there's a local team that everybody loves, e.g. FCB in Basel. As it happens, there is a nice dataset of past FCB games denoting which team shot a goal in which minute.
+Foosball is usually played to 7 or 10 goals. In order to match the ongoing foosball game to a soccer game we have to slightly change the rules. Our foosball game is played for 9 minutes (a tenth of 90 minutes). We further assume that there's a local team that everybody loves, e.g. FCB in Basel. As it happens, there is a nice JSON dataset of past FCB games denoting which team shot a goal in which minute.
+We took this data set and calculated the current score of each game for each goal. Then we stored it together with the minute a goal was shot, the home team and opponent name, and the date of the game.
+Whenever a foosball goal happens, we use the current score to lookup soccer games that had the same score, then check if a goal happened at roughly the same time (scaled by 1/10). Note that we only match a single goal, i.e. the quote relates to the current situation but not the overall timeline. This has the side effect that different games are quoted.
 {{https://farm4.staticflickr.com/3795/14255484391_2d7014befd_z.jpg}}
-TODO: integrate quotes into Scoreboard Webpage
+TODO: integrate quotes into score board Web page.
 ===== Data =====
   * http://datahub.io/dataset/fc-basel/resource/601caa05-f735-420d-81d4-b7ea1d2b9b62
   * https://tageswoche.herokuapp.com/fcb/situations
+  * http://datahub.io/dataset/openligadb-football-results
+  * http://www.openligadb.de/Matches/WebserviceLivetest
+  * http://www.openligadb.de/Sports (Liga-Id: 55, Liga-Shortcut: WM2010, Saison: 2010)
+===== Code =====
+  * https://bitbucket.org/tamberg/makeopendata/src/tip/2014/MatchQuote/MatchQuote.cs
 ===== Team =====
@@ Line 30: / Line 41: @@
   * http://buglabs.tumblr.com/post/78116792759/dweet-io-paired-with-arduino-gives-table-game-a-live
-  * Tools you used ...
+  * http://james.newtonking.com/json/help/index.html
+  * http://james.newtonking.com/json
+  * http://jsonlint.com/
-{{tag>status:concept needs:dev needs:design}}
+{{tag>status:concept needs:dev needs:design sport}}