Skip to content

Latest commit

 

History

History
187 lines (162 loc) · 7.71 KB

data_improvements.md

File metadata and controls

187 lines (162 loc) · 7.71 KB
Raw

Changes for Pelikone data (Liitokiekkoliito instance)

The following lists problems in the Pelikone data. The issues are divided in two categories: Mistakes and Improvement suggestions. Fixing the mistakes is a high priority task, but the system is usable even if those mistakes are not fixed.

Mistakes in the data

Player identities

There are small number of players, who might have mixed identities in the system. This becomes visible, when one navigates from the page listing all players (https://www.ultimate.fi/pelikone/?view=allplayers&list=all) to the individual player pages (like for Janne Aittomäki to https://www.ultimate.fi/pelikone/?view=playercard&series=0&player=12410) and compares the player name in the link (on the listing page) and the name on the player detail page. There are of course certain people who have changed their names (for example through marriage) or there are cases, where slighly different names for the same player have been used for different seasons. Below is a list of the players, which likely have some problems (although there are a couple of border cases like Janne Aittomäki, Jori Kuvaja and Juhani Puumalainen). In the following list the first name string is the name one has to follow from the player listing page and the second one is the one shown on the player detail page.

  • "Aittomäki Janne" -> "#21 Viljami Aittomäki", player id: 12410
  • "Hakalahti Johanna" -> "#", player id: 10929
  • "Hankalin Ville" -> "Iris Toivonen", player id : 6630
  • "Heinonen Riku" -> "Tuukka Lahti", player id: 6626
  • "Kima Riitta-Liisa" -> "#22 Tiina Lehtinen", player id: 9756
  • "Kuvaja Jori" -> "#88 George Kuvaja", player id: 28809
  • "Puumalainen Juhani" -> "Max Puumalainen", player id: 395
  • "Sellin Jutta" -> "Topias Mononen", player id: 6823
  • "Suonpää Mika" -> "Jesse Savo", player id: 6638
  • "Suoranta Simo" -> "Pia Olkinuora", player id: 5179
  • "Vehkaoja Antti" -> "Kalle Kyrö", player id: 6640

Incorrent final standings lists

For certain years, the standings contain additional/duplicate teams as the finals teams have been given new names like "A3', "A4" or the teams are created in the system just for finals as duplicates. This leads to final placing lists where there are 2-4 teams too many and most of the teams have final standing which is 2-4 positions too low. A couple of examples:

Merging these duplicate teams could create some problems because of possible small differences in rosters, so merging these teams might not be advisable. However the duplicate teams should not be visible in the final standings list and at least the temporary names (likes of "N3", "N4", "A3") should be fixed.

Suggested data improvements

Consistent series naming and categories

Currently different series category naming conventions are used. Also in some cases the category information is split between the category and series name.

The database should use a consistent way of naming the competitions. There should be separate fields for

  • Year (naturally with 4 numbers)
  • Season (possibly Ulkokausi, Sisäkausi, Beach)
  • Category (Avoin, Naiset, Mixed, Masters, U20, Opiskelijat, etc.)
  • possibly also Level (SM, B-tour, etc.)

It is most likely possible to convert the existing series and season categories to follow the decided guideline, but without seeing the contents of the database (which fields contain which things) I am not providing a suggestion yet.

Consolidate duplicate clubs and remove "childless" clubs

There are currently a number of clubs, which do not have any teams representing them. These are likely clubs which have been originally created as duplicates through a mistake and then the representing team is moved to already exiting club. These could be either deleted from the database, or just not displayed in the page listing all clubs.

Number of such clubs with not connected teams is 12. Below is a listing of those clubs:

  • EUC, 138
  • Lempäälän Kisa ry, 60
  • Nallet, 151
  • PKV, 142
  • TUrVoKe ry, 158
  • Tallinn Thunder, 153
  • UFO, 136
  • UFOUnlimited Frisbee Organization ry, 139
  • Ufo ry, 171
  • Ultimate Saku, 154
  • Vaasa Saints, 137
  • VirHe, 149

Additionally there are duplicate clubs entities for a number of clubs. The following list contains club ids which can be merged with the second id (meaning that the teams blenging to the first club can be moved to point to the second club).

  • 172 -> 5
  • 77 -> 70
  • 82 -> 160
  • 21 -> 160
  • 14 -> 160
  • 111 -> 96
  • 169 -> 58
  • 121 -> 58
  • 74 -> 37
  • 104 -> 37
  • 173 -> 113
  • 107 -> 114
  • 163 -> 114
  • 168 -> 141
  • 126 -> 46
  • 18 -> 108
  • 159 -> 144
  • 166 -> 144
  • 112 -> 144
  • 109 -> 91
  • 122 -> 91
  • 119 -> 91
  • 161 -> 17
  • 118 -> 90
  • 162 -> 90
  • 150 -> 117

After consolidating these teams / clubs, the newly created childless clubs (no teams representing them) could be deleted or alternatively they should not be shown on the club listing pages.

Add country & city information on all clubs

The country information is not available for most of the Finnish clubs and there are also good number of foreign clubs which do not seem to have that information. Below is the list of the foreign club ids missing the country information

  • Russia 146, 97, 98, 155, 157, 94, 96, 123, 125, 156 , 124, 177, 105, 110
  • Estonia 91, 174, 154
  • Latvia 141
  • Rest of the clubs are from Finland.

Add a parent club for all teams

There are 74 teams (at least) in Pelikone, which do not have club as a parent (meaning that if you try to find those teams from the directions of clubs, you will not find them). Below is a listing of the names of the teams. Most of the teams can be immediately recognized to be part of a club. There are also some teams, for which the parent club can be found (like A3, A4, J1, J2, etc) as those teams are just badly named teams for finals event (this practice has also created problem is final standings for certain years.

  • A3
  • A4
  • Aeroflop
  • Disc'O
  • Disquitos & UFO
  • EUC
  • EUC/UFBG
  • EePee
  • Flying Steps Avoin
  • Flying Steps Avoin
  • FreezeBees
  • Haaga-Helian AMK
  • Hamina
  • Hazardi
  • Hazardi
  • Helsingin Yliopisto
  • Hut-ilot
  • J1
  • J2
  • Jyväskylä Sleepwalkers
  • Jyväskylä Sleepwalkers
  • Jyväskylä United
  • Jyväskylän yliopisto
  • KK&PP
  • KK&PP
  • Kamaan Ketsup
  • Karhukopla
  • Kurjaa
  • LUC
  • LUC
  • LUC/Saints
  • Lempäälän Kisa
  • Mama & Papas
  • Mamas & Papas
  • Masters-mj
  • N3
  • N4
  • Nasters
  • Pros&Mamas&Papas
  • Puppets
  • SOS
  • Saints
  • Shadows
  • Shadows
  • Sisäsuomi United
  • Sleepwalkers
  • Sun City Ultimate
  • TT-lätty
  • Tamkon letut
  • Team
  • Team
  • Team 1
  • TeamEUC
  • Todella Upeeta
  • Turku 1
  • Turku Terror
  • U20
  • UFBG
  • UFBG
  • UFBG
  • UFBG
  • UFO&Hukka
  • Vaasa
  • Vaasa
  • Vaasa
  • Vaasa (n)
  • Vaasa Saints
  • Vaasa Saints (n)
  • ViRHE
  • ViRHe
  • ViRHe
  • WG
  • WWW
  • Welldone

Create a way to display the final standings of a season

There are number of years & series, for which there is no proper final standings list. As one example, there are no final standings for Summer 2018 (and others) because of the tournament format. You can only find the final placings for finals event and for the separate tour events, like

For archival purposes there should be a way to create (maybe manually) a final standings list, which contains all the teams, which participated in the competition that season / year.