Difference between revisions of "2018-19 Academic Year Research Report"
Jump to navigation
Jump to search
| Line 15: | Line 15: | ||
### For [https://wikibase.slis.ua.edu/w/index.php?title=Template:Infobox_drive&action=edit a drive] | ### For [https://wikibase.slis.ua.edu/w/index.php?title=Template:Infobox_drive&action=edit a drive] | ||
### For [https://wikibase.slis.ua.edu/w/index.php?title=Template:Infobox_game&action=edit a game] | ### For [https://wikibase.slis.ua.edu/w/index.php?title=Template:Infobox_game&action=edit a game] | ||
| − | ## Example SPARQL queries for retrieving entity instances (to run each query, click on the Blue Arrow in lower left portion of screen after clicking on links below): | + | ## Example SPARQL queries for retrieving entity instances ('''to run each query, click on the Blue Arrow icon in lower left portion of screen after clicking on links below'''): |
### [https://wikibase.slis.ua.edu/sparql/#%23%20Rushing%20touchdowns%20for%20plays%20over%2050%20yards%0ASELECT%20%3FPlay%20%3FTextual_Description_of_Play_Outcome%20%3FYardage_Resulting_from_Play_Outcome%20%3FTeam_on_DefenseLabel%20WHERE%20%7B%0A%20%20%3FPlay%20wdt%3AP17%20wd%3AQ8.%0A%20%20%3FPlay%20wdt%3AP16%20wd%3AQ39.%0A%20%20%3FPlay%20wdt%3AP38%20%3Fplays__statYardage.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FPlay%20wdt%3AP20%20%3FTextual_Description_of_Play_Outcome.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FPlay%20wdt%3AP38%20%3FYardage_Resulting_from_Play_Outcome.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FPlay%20wdt%3AP25%20%3FTeam_on_Defense.%20%7D%0A%20%20FILTER%28%3Fplays__statYardage%20%3E%3D%2050%29%0A%7D%0ALIMIT%20100 Rushing touchdowns for plays over 50 yards during the 2017 Alabama Crimson Tide football season] | ### [https://wikibase.slis.ua.edu/sparql/#%23%20Rushing%20touchdowns%20for%20plays%20over%2050%20yards%0ASELECT%20%3FPlay%20%3FTextual_Description_of_Play_Outcome%20%3FYardage_Resulting_from_Play_Outcome%20%3FTeam_on_DefenseLabel%20WHERE%20%7B%0A%20%20%3FPlay%20wdt%3AP17%20wd%3AQ8.%0A%20%20%3FPlay%20wdt%3AP16%20wd%3AQ39.%0A%20%20%3FPlay%20wdt%3AP38%20%3Fplays__statYardage.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FPlay%20wdt%3AP20%20%3FTextual_Description_of_Play_Outcome.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FPlay%20wdt%3AP38%20%3FYardage_Resulting_from_Play_Outcome.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FPlay%20wdt%3AP25%20%3FTeam_on_Defense.%20%7D%0A%20%20FILTER%28%3Fplays__statYardage%20%3E%3D%2050%29%0A%7D%0ALIMIT%20100 Rushing touchdowns for plays over 50 yards during the 2017 Alabama Crimson Tide football season] | ||
| − | + | ### [https://wikibase.slis.ua.edu/sparql/#%23%20Touchdown%20passes%20involving%20Jalen%20Hurts%20for%20plays%20over%2050%20yards%0ASELECT%20%3FPlay%20%3FTextual_Description_of_Play_Outcome%20%3FYardage_Resulting_from_Play_Outcome%20%3FTeam_on_DefenseLabel%20WHERE%20%7B%0A%20%20%3FPlay%20wdt%3AP17%20wd%3AQ8%3B%20%20%23Is%20a%20play%0A%20%20%20%20%20%20%20%20wdt%3AP16%20wd%3AQ35%3B%20%20%23Touchdown%20pass%20play%0A%20%20%20%20%20%20%20%20wdt%3AP60%20wd%3AQ1355%3B%20%23Jalen%20Hurts%20as%20a%20participating%20player%0A%20%20%20%20%20%20%20%20wdt%3AP38%20%3Fplays__statYardage.%20%23%20Yardage%20gain%0A%20%20%20%20%20%20%20%20%20%20FILTER%28%3Fplays__statYardage%20%3E%3D%2050%29.%20%20%23Yardage%20gained%20%3E%3D%2050%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FPlay%20wdt%3AP20%20%3FTextual_Description_of_Play_Outcome.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FPlay%20wdt%3AP38%20%3FYardage_Resulting_from_Play_Outcome.%20%7D%0A%20%20OPTIONAL%20%7B%20%3FPlay%20wdt%3AP25%20%3FTeam_on_Defense.%20%7D%0A%7D%0ALIMIT%20100 Touchdown passes involving Jalen Hurts for plays over 50 yards] | |
| − | + | # Demonstrating the ability to organize digital assets using linked data methods deployed in a Wikibase instance: | |
| − | + | ## https://wikibase.slis.ua.edu/wiki/Tua_Tagovailoa_pass_complete_to_DeVonta_Smith_for_27_yds_for_a_TD_(Andy_Pappanastos_KICK)_(9/23/17) | |
| − | https://wikibase.slis.ua.edu/wiki/Tua_Tagovailoa_pass_complete_to_DeVonta_Smith_for_27_yds_for_a_TD_(Andy_Pappanastos_KICK)_(9/23/17) | + | ## https://wikibase.slis.ua.edu/wiki/Da%27Ron_Payne_1_Yd_pass_from_Jalen_Hurts_(Andy_Pappanastos_Kick)_(1/1/18) |
| − | https://wikibase.slis.ua.edu/wiki/Da%27Ron_Payne_1_Yd_pass_from_Jalen_Hurts_(Andy_Pappanastos_Kick)_(1/1/18) | + | ## https://wikibase.slis.ua.edu/wiki/Calvin_Ridley_12_Yd_pass_from_Jalen_Hurts_(Andy_Pappanastos_Kick)_(1/1/18) |
| − | https://wikibase.slis.ua.edu/wiki/Calvin_Ridley_12_Yd_pass_from_Jalen_Hurts_(Andy_Pappanastos_Kick)_(1/1/18) | + | ## https://wikibase.slis.ua.edu/wiki/Damien_Harris_run_for_75_yds_for_a_TD_(Andy_Pappanastos_KICK)_(10-14-17) |
| − | https://wikibase.slis.ua.edu/wiki/Damien_Harris_run_for_75_yds_for_a_TD_(Andy_Pappanastos_KICK)_(10-14-17) | ||
Collaborator List | Collaborator List | ||
Revision as of 21:01, 29 April 2019
This is an addendum to my 2018-19 Academic Year Research Report submitted for review via Digital Measures.
Online documentation for research accomplishments:
- We were able to successfully convert publicly accessible JSON-encoded statistical play-by-play datasets for all 14 games in the 2017 Alabama Crimson Tide football season into a linked data application using Wikibase. One can now navigate from play to play, drive to drive, and game to game within the 2017 football season using data drawn from existing statistical play-by-play datasets incorporated into the application by way of linked data methods. Highlights:
- Example of a JSON-encoded statistical play-by-play dataset from 2017 Alabama versus Florida State football game.
- Property list for the ontology developed for this application.
- Examples of three types of entities ("play" "drive" "game") in our linked data application. Each example provides links to Mediawiki site pages and to Wikibase item pages (each item page contains the metadata statements (each statement a "triple") about each entity using properties drawn from our ontology):
- Mediawiki site page for a typical play (here is this play's corresponding Wikibase item page)
- Mediawiki site page for a typical drive (here is this drive's corresponding Wikibase item page)
- Mediawiki site page for a typical game (here is this game's corresponding Wikibase item page)
- Infobox templates deployed to generate infoboxes on each Mediawiki page:
- Example SPARQL queries for retrieving entity instances (to run each query, click on the Blue Arrow icon in lower left portion of screen after clicking on links below):
- Demonstrating the ability to organize digital assets using linked data methods deployed in a Wikibase instance:
- https://wikibase.slis.ua.edu/wiki/Tua_Tagovailoa_pass_complete_to_DeVonta_Smith_for_27_yds_for_a_TD_(Andy_Pappanastos_KICK)_(9/23/17)
- https://wikibase.slis.ua.edu/wiki/Da%27Ron_Payne_1_Yd_pass_from_Jalen_Hurts_(Andy_Pappanastos_Kick)_(1/1/18)
- https://wikibase.slis.ua.edu/wiki/Calvin_Ridley_12_Yd_pass_from_Jalen_Hurts_(Andy_Pappanastos_Kick)_(1/1/18)
- https://wikibase.slis.ua.edu/wiki/Damien_Harris_run_for_75_yds_for_a_TD_(Andy_Pappanastos_KICK)_(10-14-17)
Collaborator List Important collaborators contributing to the research reported here (see online documentation for detailed contributions): 1. Dr. Greg Bott, Assistant Professor, UA Culverhouse School of Business 2. David McMillan, IT Team Leader, Enterprise Development & Application Support, UA Office of Information Technology (OIT) 3. Huapu Liu, Graduate Research Assistant and MLIS student (see 4. Christine Schultz-Richert, MLIS student
