Issues with rankings for multiple events

[Logiqx]

I decided to write a Python script to check the British Speed Challenge 2022 rankings for data integrity issues.

It compares EventRankings and EventSessions (data retrieved via the GP3S API) and reports the following issues:

Duplicate speed_100 for Mark Ingram (5835)
Duplicate speed_10sec for Mark Ingram (5835)
Duplicate speed_10sec for Garry Connell (18265)
Duplicate speed_2sec for Mark Ingram (5835)
Duplicate speed_alpha_racing for Mark Ingram (5835)
Duplicate speed_avg for Will Trossell (2911)
Duplicate speed_avg for George Fulton (16978)
Duplicate speed_avg for Maciej Bukolt (23129)
Duplicate speed_avg for Maciej Bukolt (23129)
Duplicate speed_avg for Maciej Bukolt (23129)
Duplicate speed_avg for Maciej Bukolt (23129)
Duplicate speed_avg for Maciej Bukolt (23129)
Duplicate speed_avg for Norman Petty (2307)
Duplicate speed_halfhour for Mark Ingram (5835)
Duplicate speed_halfhour for Garry Connell (18265)
Duplicate speed_hour for Mark Ingram (5835)
Duplicate speed_mile for Garry Connell (18265)
Duplicate speed_mile for Mark Ingram (5835)

Steve Thompson (3592) mismatch for speed_avg - 26.15 ranking vs 29.63 session
Will Trossell (2911) mismatch for speed_avg - 29.57 ranking vs 40.18 session
Maciej Bukolt (23129) mismatch for speed_avg - 29.11 ranking vs 35.41 session
Norman Petty (2307) mismatch for speed_avg - 25.08 ranking vs 27.74 session
George Fulton (16978) mismatch for speed_avg - 29.38 ranking vs 33.05 session
Garry Connell (18265) mismatch for speed_avg - 5.38 ranking vs 34.14 session
Garry Goodwin (23091) mismatch for speed_2sec - 32.82 ranking vs 39.31 session
Steve Thompson (3592) mismatch for speed_2sec - 29.11 ranking vs 32.21 session
Will Trossell (2911) mismatch for speed_2sec - 31.53 ranking vs 42.33 session
Maciej Bukolt (23129) mismatch for speed_2sec - 30.65 ranking vs 37.02 session
Norman Petty (2307) mismatch for speed_2sec - 26.16 ranking vs 30.31 session
George Fulton (16978) mismatch for speed_2sec - 31.50 ranking vs 35.78 session
Garry Connell (18265) mismatch for speed_2sec - 29.05 ranking vs 36.62 session
Steve Thompson (3592) mismatch for speed_10sec - 26.80 ranking vs 30.66 session
Will Trossell (2911) mismatch for speed_10sec - 30.11 ranking vs 40.69 session
Maciej Bukolt (23129) mismatch for speed_10sec - 29.76 ranking vs 36.66 session
Norman Petty (2307) mismatch for speed_10sec - 25.92 ranking vs 29.01 session
George Fulton (16978) mismatch for speed_10sec - 31.08 ranking vs 34.12 session
Garry Connell (18265) mismatch for speed_10sec - 26.93 ranking vs 35.67 session
Steve Thompson (3592) mismatch for speed_100 - 27.02 ranking vs 30.88 session
Will Trossell (2911) mismatch for speed_100 - 30.74 ranking vs 41.67 session
Maciej Bukolt (23129) mismatch for speed_100 - 29.95 ranking vs 36.83 session
Norman Petty (2307) mismatch for speed_100 - 25.89 ranking vs 29.40 session
George Fulton (16978) mismatch for speed_100 - 31.19 ranking vs 35.18 session
Garry Connell (18265) mismatch for speed_100 - 32.23 ranking vs 36.13 session
Steve Thompson (3592) mismatch for speed_250 - 26.78 ranking vs 29.66 session
Will Trossell (2911) mismatch for speed_250 - 29.57 ranking vs 40.28 session
Maciej Bukolt (23129) mismatch for speed_250 - 29.41 ranking vs 36.55 session
Norman Petty (2307) mismatch for speed_250 - 25.63 ranking vs 28.36 session
George Fulton (16978) mismatch for speed_250 - 30.28 ranking vs 33.25 session
Garry Connell (18265) mismatch for speed_250 - 31.73 ranking vs 34.83 session
Steve Thompson (3592) mismatch for speed_500 - 21.32 ranking vs 28.48 session
Will Trossell (2911) mismatch for speed_500 - 27.91 ranking vs 39.44 session
Maciej Bukolt (23129) mismatch for speed_500 - 28.29 ranking vs 34.99 session
Norman Petty (2307) mismatch for speed_500 - 23.83 ranking vs 26.48 session
George Fulton (16978) mismatch for speed_500 - 29.57 ranking vs 31.69 session
Garry Connell (18265) mismatch for speed_500 - 30.36 ranking vs 32.69 session
Steve Thompson (3592) mismatch for speed_mile - 18.39 ranking vs 25.54 session
Will Trossell (2911) mismatch for speed_mile - 23.43 ranking vs 26.50 session
Maciej Bukolt (23129) mismatch for speed_mile - 21.80 ranking vs 26.58 session
George Fulton (16978) mismatch for speed_mile - 23.34 ranking vs 25.02 session
Garry Connell (18265) mismatch for speed_mile - 25.99 ranking vs 26.06 session
Steve Thompson (3592) mismatch for speed_hour - 7.18 ranking vs 15.39 session
Will Trossell (2911) mismatch for speed_hour - 15.94 ranking vs 17.90 session
Maciej Bukolt (23129) mismatch for speed_hour - 17.79 ranking vs 19.23 session
George Fulton (16978) mismatch for speed_hour - 10.20 ranking vs 14.66 session
Garry Connell (18265) mismatch for speed_hour - 10.82 ranking vs 12.92 session

7 / 42 users need a rebuild in BritishSpeedChallenge2022:
Garry Connell (18265)
Steve Thompson (3592)
Garry Goodwin (23091)
Norman Petty (2307)
George Fulton (16978)
Will Trossell (2911)
Maciej Bukolt (23129)

It's quite late now so I'll wait until tomorrow to tidy up the script and share on GitHub.

The script can easily be enhanced to check other events, should it be useful.

[jhdebruin]

Great work !!!

[Logiqx]

Ok, I've enhanced the scripts to check all active events:

Listing every individual error is extremely verbose so here is a summary for all events:

No users need a rebuild in 2022 FFF SPEED CHALLENGE (727)

3 / 22 users need a rebuild in 2022 Funsport Makkum GPS Speed Challenge (740):
Paul Salomons (3078) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Rob de Jong (4307) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_avg
Jan Hendrik de Bruin (2574) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_avg

1 / 29 users need a rebuild in 2022 Irish Speed Masters (717):
Gildas Bechet (3671) - speed_mile

8 / 47 users need a rebuild in Surf like a dude Zuidlaardermeer Speed Challenge 2022 (730):
Tim Heeringa (23642) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Martijn Mobach (4690) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Bert Bodde (20514) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Jan Joustra (23396) - speed_250, speed_500, speed_2sec, speed_100, speed_10sec, speed_avg
Benjamin de Bie (25351) - speed_avg
Eric Kamminga (3309) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Marco Bos (8545) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Peter kuiter (23407) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg

7 / 75 users need a rebuild in Norwegian speedmaster - 2022 (719):
Jone Vikingstad (3925) - speed_10sec, speed_2sec
Ole Erik Carlson (9552) - speed_250, speed_500, speed_hour, speed_100, speed_mile, speed_avg
Kjetil Enger Olsen (23700) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Tor Kjell Grytnes  (22817) - speed_250, speed_2sec, speed_100, speed_10sec, speed_avg
Kristian Grytnes (23632) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_avg
Bernt Ottem (19447) - speed_hour, speed_250
Tore Hvideberg (25617) - speed_hour

6 / 87 users need a rebuild in SSS Go big or go Home 2021-2022 (715):
Hans Prins (5376) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Sven Hulst (23299) - speed_250, speed_500, speed_2sec, speed_100, speed_10sec, speed_avg
Ingolf van Oostveen (3874) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
René Bijmolt (21711) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_avg
Jan Joustra (23396) - speed_250, speed_500, speed_2sec, speed_100, speed_10sec, speed_avg
Alwin Visker (15697) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg

No users need a rebuild in Wurster ONE hour (731)

No users need a rebuild in Lysakerfjorden 2022 (722)

6 / 119 users need a rebuild in 2022 Spanish Speed Challenge (737):
Sico Barber (25284) - speed_250, speed_500, speed_hour, speed_mile, speed_avg
eduardo de llano (25460) - speed_2sec
Kai Kaufmann (16746) - speed_250, speed_500, speed_hour, speed_100, speed_10sec, speed_avg
Alberto Marugan (25183) - speed_250, speed_500, speed_2sec, speed_100, speed_10sec, speed_avg
Anne Schindler (16739) - speed_250, speed_500, speed_2sec, speed_100, speed_10sec, speed_avg
Twan Verseput  (3923) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg

3 / 139 users need a rebuild in WSCA Westeinder Speedking 2022 (726):
Max Shytikov (25266) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Edwin Beekman (21797) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Leon Ippel (25523) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg

2 / 152 users need a rebuild in 2022 DBO Speed Challenge (732):
Andrei Josephsen (25722) - speed_2sec, speed_hour
Bjørn Olesen (25378) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_avg

3 / 157 users need a rebuild in Surf like a dude Zuidlaardermeer speed challenge 2021 (692):
Andre Poelman (24607) - speed_250, speed_500, speed_hour, speed_100, speed_10sec, speed_avg
Eric Kamminga (3309) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Tim Heeringa (23642) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg

44 / 439 users need a rebuild in 2022 Dunkerbeck Speed Challenge “The Summer Edition” (748):
Kai Kaufmann (16746) - speed_250, speed_500, speed_100, speed_10sec, speed_mile, speed_avg
Christopher Tyack (22404) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Tor Kjell Grytnes  (22817) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Konstantinos Palogos (23998) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Jorgen Dyblie (23206) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Torbjörn Hellström (23334) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Kristian Grytnes (23632) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_avg
Will Trossell (2911) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Sven Hulst (23299) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Pavlos Kapsianis (24816) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Jorrit Bonnema (22388) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Markus Lindman (5423) - speed_250, speed_500, speed_2sec, speed_100, speed_10sec, speed_avg
Marco Düwell (26365) - speed_250, speed_500, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Ingolf van Oostveen (3874) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Bert Bodde (20514) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Alwin Visker (15697) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Mandy van de Hoef (23463) - speed_250, speed_2sec, speed_100, speed_10sec, speed_avg
Ove Jansson (4642) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Alberto Marugan (25183) - speed_250, speed_500, speed_2sec, speed_100, speed_10sec, speed_avg
Chris Platt (25193) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
René Bijmolt (21711) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_avg
Jüri Kaldoja (4497) - speed_250, speed_500, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Fons van den Hove (24311) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Phil Noden (2708) - speed_250, speed_500, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Olsson Orjan (18230) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Frank Heinen (82) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Tore Hvideberg (25617) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Nicole Skodda (6348) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_avg
Lianne Hofstee (26179) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_avg
Hans Prins (5376) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Magnus Bengtsson (2046) - speed_250, speed_500, speed_hour, speed_100, speed_10sec, speed_avg
Anders Bjorkqvist (2558) - speed_mile, speed_hour, speed_avg
Dylan de Jong (53) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_avg
Arne Noer (24403) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Edwin Buruma (23550) - speed_250, speed_hour, speed_2sec, speed_100, speed_10sec, speed_avg
Peter L Rasmussen (26059) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Robert Baas (19409) - speed_250, speed_500, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Thomas Moldenhauer (24163) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Hans Kreisel (2042) - speed_250, speed_500, speed_hour, speed_100, speed_10sec, speed_mile, speed_avg
Regis Lesieur (22394) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_avg
Deyan Gospodinov (26011) - speed_250, speed_500, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Hannes Rieger (24349) - speed_250, speed_2sec, speed_100, speed_10sec, speed_mile
Saar Schuling  (25189) - speed_mile, speed_hour
Mateusz Kasprzak (25524) - speed_hour

8 / 453 users need a rebuild in World Speed Tour - GPS POS 2022  (734):
Thomas Moldenhauer (24163) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Rolf de Ruiter (2352) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Melek Toraman (25149) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Leon Ippel (25523) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Anne Fahner (4516) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Rainer Motloch (4470) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Heidi Ulrich (20629) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_avg
Willem Wolvers (23889) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg

1 / 456 users need a rebuild in 2021 Red Bull Bora Challenge (712):
Bjorn Dunkerbeck (6023) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg

5 / 472 users need a rebuild in 2022 Gps Kraaij Challenge (721):
Chris Föcking (4524) - speed_mile
Erwin Rovers (5095) - speed_mile
Aaron van den Elsen (25570) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Patricia Verduyn Lunel (25571) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_avg
Nicole Skodda (6348) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_avg

3 / 477 users need a rebuild in 2022  (733):
Regis Lesieur (22394) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_avg
Christopher Tyack (22404) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Marcel Mulder (15678) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg

2 / 500 users need a rebuild in Singlis-Speedchallenge 2022 (725):
Andreas Schaefer (2399) - speed_mile
Arnd Gottschalk (26098) - speed_2sec

10 / 506 users need a rebuild in Schildmeer Speed Challenge 2021-2022 (704):
Edwin Buruma (23550) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Frans Werkman (5650) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Stefan Bijmolt (25577) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_avg
Ingolf van Oostveen (3874) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Bert Bodde (20514) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
René Bijmolt (21711) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_avg
Sven Hulst (23299) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Hans Prins (5376) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Alwin Visker (15697) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Saar Schuling  (25189) - speed_250, speed_500, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg

6 / 519 users need a rebuild in 2022 Estonian Speed King (739):
Jüri Kaldoja (4497) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Toomas Kasenurm (4527) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Martin Keernik (5112) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Valde Viiding (21996) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Cerly Aulik (22317) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Aivo Prükk (4579) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg

12 / 549 users need a rebuild in 2022 Odyssey of Speed (736):
Marco Bos (8545) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Johan Huitema (4541) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Pavlos Kapsianis (24816) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Spiros Chouliaras (23430) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Konstantinos Palogos (23998) - speed_500, speed_hour, speed_2sec, speed_10sec, speed_mile, speed_avg
Wouter van Hilst (20700) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Twan Verseput  (3923) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Marco Lambers (22478) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Johnny Tuijn (2503) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Panos Christoforou (23748) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Peter kuiter (23407) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Mixalis Damigos (26300) - speed_hour

8 / 578 users need a rebuild in BritishSpeedChallenge2022 (710):
Mark Ingram (5835) - speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile
Garry Connell (18265) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Will Trossell (2911) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
George Fulton (16978) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Maciej Bukolt (23129) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Norman Petty (2307) - speed_250, speed_500, speed_2sec, speed_100, speed_10sec, speed_avg
Steve Thompson (3592) - speed_250, speed_500, speed_hour, speed_2sec, speed_100, speed_10sec, speed_mile, speed_avg
Garry Goodwin (23091) - speed_2sec

All done!

[Logiqx]

The code is now on GitHub - https://github.com/Logiqx/gp3s-query

[Logiqx]

p.s. My script only checks gps-speedsurfing events and not gps-foilsurfing events.

The API doesn't appear to fully support the gps-foilsurfing, unless I'm missing something?

[jhdebruin]

@Logiqx I've update all events , with exception of the Dunkerbeck Challenge , i will ask @djong1 to make a script for this specific event. (Make a new issue for this including your output) , could you run the script to check if validates the updates correctly ??

[Logiqx]

@jhdebruin I see many improvements but some issues still exist.

To be sure, I also checked 4 or 5 issues from the detailed output and the issues were definitely present on gps-speedsurfing.

Here is the new summary list:

No users need a rebuild in 2022 FFF SPEED CHALLENGE (727)

3 / 22 users need a rebuild in 2022 Funsport Makkum GPS Speed Challenge (740):
Paul Salomons (3078) - speed_avg, speed_2sec, speed_10sec, speed_100, speed_250, speed_500, speed_mile, speed_hour
Rob de Jong (4307) - speed_avg, speed_2sec, speed_10sec, speed_100, speed_250, speed_500, speed_hour
Jan Hendrik de Bruin (2574) - speed_avg, speed_2sec, speed_10sec, speed_100, speed_250, speed_500, speed_hour

1 / 29 users need a rebuild in 2022 Irish Speed Masters (717):
Gildas Bechet (3671) - speed_avg, speed_2sec, speed_10sec, speed_100, speed_250, speed_500, speed_hour

No users need a rebuild in Surf like a dude Zuidlaardermeer Speed Challenge 2022 (730)

No users need a rebuild in Norwegian speedmaster - 2022 (719)

6 / 86 users need a rebuild in SSS Go big or go Home 2021-2022 (715):
Hans Prins (5376) - speed_avg, speed_2sec, speed_10sec, speed_100, speed_250, speed_500, speed_mile, speed_hour
Sven Hulst (23299) - speed_avg, speed_2sec, speed_10sec, speed_100, speed_250, speed_500
Ingolf van Oostveen (3874) - speed_avg, speed_2sec, speed_10sec, speed_100, speed_250, speed_500, speed_mile, speed_hour
René Bijmolt (21711) - speed_avg, speed_2sec, speed_10sec, speed_100, speed_250, speed_500, speed_hour
Jan Joustra (23396) - speed_avg, speed_2sec, speed_10sec, speed_100, speed_250, speed_500
Alwin Visker (15697) - speed_avg, speed_2sec, speed_10sec, speed_100, speed_250, speed_500, speed_mile, speed_hour

No users need a rebuild in Wurster ONE hour (731)

No users need a rebuild in Lysakerfjorden 2022 (722)

1 / 118 users need a rebuild in 2022 Spanish Speed Challenge (737):
eduardo de llano (25460) - speed_100, speed_10sec, speed_250, speed_2sec, speed_500, speed_avg, speed_hour, speed_mile

No users need a rebuild in WSCA Westeinder Speedking 2022 (726)

1 / 151 users need a rebuild in 2022 DBO Speed Challenge (732):
Andrei Josephsen (25722) - speed_100, speed_10sec, speed_250, speed_2sec, speed_500, speed_avg, speed_hour, speed_mile

3 / 156 users need a rebuild in Surf like a dude Zuidlaardermeer speed challenge 2021 (692):
Eric Kamminga (3309) - speed_avg, speed_2sec, speed_10sec, speed_100, speed_250, speed_500, speed_mile, speed_hour
Tim Heeringa (23642) - speed_avg, speed_2sec, speed_10sec, speed_100, speed_250, speed_500, speed_mile, speed_hour
Andre Poelman (24607) - speed_avg, speed_2sec, speed_10sec, speed_100, speed_250, speed_500, speed_hour

46 / 452 users need a rebuild in 2022 Dunkerbeck Speed Challenge “The Summer Edition” (748):
Kai Kaufmann (16746) - speed_mile, speed_avg, speed_10sec, speed_100, speed_250, speed_500
Christopher Tyack (22404) - speed_100, speed_10sec, speed_250, speed_2sec, speed_500, speed_avg, speed_hour, speed_mile
Tor Kjell Grytnes  (22817) - speed_100, speed_10sec, speed_250, speed_2sec, speed_500, speed_avg, speed_hour, speed_mile
Konstantinos Palogos (23998) - speed_100, speed_10sec, speed_250, speed_2sec, speed_500, speed_avg, speed_hour, speed_mile
Jorgen Dyblie (23206) - speed_100, speed_10sec, speed_250, speed_2sec, speed_500, speed_avg, speed_hour, speed_mile
Torbjörn Hellström (23334) - speed_100, speed_10sec, speed_250, speed_2sec, speed_500, speed_avg, speed_hour, speed_mile
Kristian Grytnes (23632) - speed_100, speed_10sec, speed_250, speed_2sec, speed_500, speed_avg, speed_hour
Will Trossell (2911) - speed_100, speed_10sec, speed_250, speed_2sec, speed_500, speed_avg, speed_hour, speed_mile
Sven Hulst (23299) - speed_100, speed_10sec, speed_250, speed_2sec, speed_500, speed_avg, speed_hour, speed_mile
Pavlos Kapsianis (24816) - speed_100, speed_10sec, speed_250, speed_2sec, speed_500, speed_avg, speed_hour, speed_mile
Jorrit Bonnema (22388) - speed_100, speed_10sec, speed_250, speed_2sec, speed_500, speed_avg, speed_hour, speed_mile
Markus Lindman (5423) - speed_100, speed_10sec, speed_250, speed_2sec, speed_500, speed_avg
Ingolf van Oostveen (3874) - speed_100, speed_10sec, speed_250, speed_2sec, speed_500, speed_avg, speed_hour, speed_mile
Bert Bodde (20514) - speed_100, speed_10sec, speed_250, speed_2sec, speed_500, speed_avg, speed_hour, speed_mile
Alwin Visker (15697) - speed_100, speed_10sec, speed_250, speed_2sec, speed_500, speed_avg, speed_hour, speed_mile
Mandy van de Hoef (23463) - speed_100, speed_10sec, speed_250, speed_2sec, speed_avg
Ove Jansson (4642) - speed_100, speed_10sec, speed_250, speed_2sec, speed_500, speed_avg, speed_hour, speed_mile
Alberto Marugan (25183) - speed_100, speed_10sec, speed_250, speed_2sec, speed_500, speed_avg
Chris Platt (25193) - speed_100, speed_10sec, speed_250, speed_2sec, speed_500, speed_avg, speed_hour, speed_mile
René Bijmolt (21711) - speed_100, speed_10sec, speed_250, speed_2sec, speed_500, speed_avg, speed_hour
Jüri Kaldoja (4497) - speed_100, speed_10sec, speed_250, speed_2sec, speed_500, speed_avg, speed_mile
Fons van den Hove (24311) - speed_100, speed_10sec, speed_250, speed_2sec, speed_500, speed_avg, speed_hour, speed_mile
Phil Noden (2708) - speed_100, speed_10sec, speed_250, speed_2sec, speed_500, speed_avg, speed_mile
Olsson Orjan (18230) - speed_100, speed_10sec, speed_250, speed_2sec, speed_500, speed_avg, speed_hour, speed_mile
Frank Heinen (82) - speed_100, speed_10sec, speed_250, speed_2sec, speed_500, speed_avg, speed_hour, speed_mile
Tore Hvideberg (25617) - speed_100, speed_10sec, speed_250, speed_2sec, speed_500, speed_avg, speed_hour, speed_mile
Nicole Skodda (6348) - speed_100, speed_10sec, speed_250, speed_2sec, speed_500, speed_avg, speed_hour
Lianne Hofstee (26179) - speed_100, speed_10sec, speed_250, speed_2sec, speed_500, speed_avg, speed_hour
Dylan de Jong (53) - speed_avg, speed_2sec, speed_10sec, speed_100, speed_250, speed_500, speed_hour
Aart Veerman (3607) - speed_avg, speed_2sec, speed_10sec, speed_100, speed_250, speed_500, speed_mile, speed_hour
René van der Weijde (5123) - speed_avg, speed_2sec, speed_10sec, speed_100, speed_250, speed_500, speed_mile, speed_hour
Hans Prins (5376) - speed_avg, speed_2sec, speed_100, speed_mile
Uwe Eßer (6331) - speed_avg, speed_2sec, speed_10sec, speed_100, speed_250, speed_hour
Magnus Bengtsson (2046) - speed_avg, speed_10sec, speed_100, speed_250, speed_500, speed_hour
Anders Bjorkqvist (2558) - speed_avg, speed_mile, speed_hour
Arne Noer (24403) - speed_avg, speed_2sec, speed_10sec, speed_100, speed_250, speed_500, speed_mile, speed_hour
Edwin Buruma (23550) - speed_avg, speed_2sec, speed_10sec, speed_100, speed_250, speed_hour
Peter L Rasmussen (26059) - speed_avg, speed_2sec, speed_10sec, speed_100, speed_250, speed_500, speed_mile, speed_hour
Kirsten Baas (22540) - speed_avg, speed_2sec, speed_10sec, speed_100, speed_250, speed_500
Robert Baas (19409) - speed_avg, speed_2sec, speed_10sec, speed_100, speed_250, speed_500, speed_mile
Thomas Moldenhauer (24163) - speed_avg, speed_2sec, speed_10sec, speed_100, speed_250, speed_500, speed_mile, speed_hour
Hans Kreisel (2042) - speed_avg, speed_10sec, speed_100, speed_250, speed_500, speed_mile, speed_hour
Regis Lesieur (22394) - speed_avg, speed_2sec, speed_10sec, speed_100, speed_250, speed_500, speed_hour
Saar Schuling  (25189) - speed_mile, speed_hour
Kootstra Tom (24490) - speed_hour
Mateusz Kasprzak (25524) - speed_hour

No users need a rebuild in World Speed Tour - GPS POS 2022  (734)

No users need a rebuild in 2021 Red Bull Bora Challenge (712)

1 / 484 users need a rebuild in 2022 Gps Kraaij Challenge (721):
Erwin Rovers (5095) - speed_2sec

No users need a rebuild in 2022  (733)

1 / 512 users need a rebuild in Singlis-Speedchallenge 2022 (725):
Arnd Gottschalk (26098) - speed_100, speed_10sec, speed_250, speed_2sec, speed_500, speed_avg, speed_hour, speed_mile

8 / 517 users need a rebuild in Schildmeer Speed Challenge 2021-2022 (704):
Edwin Buruma (23550) - speed_avg, speed_2sec, speed_10sec, speed_100, speed_250
Ingolf van Oostveen (3874) - speed_avg, speed_2sec, speed_10sec, speed_100, speed_250, speed_500, speed_mile, speed_hour
Hans Prins (5376) - speed_avg, speed_2sec, speed_10sec, speed_100, speed_250, speed_500
Saar Schuling  (25189) - speed_avg, speed_2sec, speed_10sec, speed_100, speed_250
Alwin Visker (15697) - speed_250
Frans Werkman (5650) - speed_500, speed_mile, speed_hour
Bert Bodde (20514) - speed_mile, speed_hour
Sven Hulst (23299) - speed_mile, speed_hour

No users need a rebuild in 2022 Estonian Speed King (739)

No users need a rebuild in 2022 Odyssey of Speed (736)

5 / 589 users need a rebuild in BritishSpeedChallenge2022 (710):
Norman Petty (2307) - speed_avg, speed_2sec, speed_10sec, speed_100, speed_250, speed_500
George Fulton (16978) - speed_avg, speed_2sec, speed_10sec, speed_100, speed_250, speed_500
Garry Connell (18265) - speed_avg, speed_2sec, speed_500, speed_mile
Mark Ingram (5835) - speed_avg, speed_2sec, speed_10sec, speed_100, speed_250, speed_500, speed_mile, speed_hour
Steve Thompson (3592) - speed_500, speed_mile, speed_hour

[jhdebruin]

ok, thnx, will try some things tomorrow, think it could be the start date of the event also ( 2021 versus 2022)

[Logiqx]

@jhdebruin - The script now generates some browsable reports.

https://logiqx.github.io/gp3s-query/events/

[djong1]

p.s. My script only checks gps-speedsurfing events and not gps-foilsurfing events.

The API doesn't appear to fully support the gps-foilsurfing, unless I'm missing something?

We have created a separate issue for this one #24

[jhdebruin]

@Logiqx

Just done the rebuild of SSS Go big or go Home 2021-2022 (715) , could you run the script to see if its ok now ?

[Logiqx]

@jhdebruin - unfortunately issues remain. I looked at two examples of each type of issue to be sure.

Missing rankings:

• Sven Hulst and Hans Prins have sessions but no rankings

Incorrect results:

• Alwin Visker has a best average of 32.37 knots but the rankings use what appears to be the first session (28.15 knots).
• Likewise for Henk Vos

In most case the incorrect results (ranking speed < best session speed) appear to be using the earliest event session, but not in all cases (e.g NM and 1 hr for Alwin Visker).

[jhdebruin]

@Logiqx Did rebuilds of all the events / issues as from https://logiqx.github.io/gp3s-query/events/ , finished this around 20:00 CET , could you do a refresh of the script ? Thnx :)

[Logiqx]

@jhdebruin

Lots of improvements. Duplicates have disappeared from all except DSC which I'm assuming hasn't been touched yet.

• Funsport Makkum is fixed
• Spanish Speed Challenge has improved
• Odyssey has changed some rankings from missing to incorrect results
• DBO has improved
• Surf like a dude 2022 has changed some rankings from incorrect to missing
• Singlis is fixed
• Kraaij has more missing results
• SSS Go big has improved
• British Challenge has improved
• Schildmeer has improved
• Surf like a dude 2021 is fixed

I get to see changes as shown below (red = old report, green = new report).

Reports available at the usual address - https://logiqx.github.io/gp3s-query/events/

[jhdebruin]

@Logiqx Check, have done another rebuild of all the evens with just one issue left, lets see if this has effect, otherwise we have do some small stuff under the hood, the DSC is indeed not updated yet (wait for general script)

[Logiqx]

@jhdebruin

A few improvements:

[jhdebruin]

2022 Spanish Speed Challenge- ID 737 - removed "0 speed" entry 2022 DBO Speed Challenge - ID 732- removed "0 speed" entry 2022 Gps Kraaij Challenge - ID 721 - No action needed, reported session is excluded from event ranking because its outside event date (can be manually removed by Local Event Admin if she/he wants to do that ) 2022 Irish Speed Masters - ID 717 - No action needed, reported session is excluded from event ranking because its outside event date (can be manually removed by Local Event Admin if she/he wants to do that )

[jhdebruin]

SSS Go big or go Home 2021-2022 - ID 715 BritishSpeedChallenge2022 - ID 710 Schildmeer Speed Challenge 2021-2022 - ID 704

Rebuilds done with specific faster session from 2022 , this is an event running over 2021 & 2022 , so this could have caused some issues with the previous rebuild, hopes this works now

If all works now, its pretty isolated to the DSC Event (and that's logical :) )

[Logiqx]

@jhdebruin

Various improvements, except BSC 2022.

[jhdebruin]

@Logiqx Check, this confirms my suspicions :) The rebuild feature from the Admin Modules does a specific rebuild of the user specific results in the event in a specific year, so when you have the fastest hour in an event that runs from 2021 to 2022 and i do a rebuild for 2021 it takes the correct hour top speeds, but replaces the fastest event time for other categories from 2022.....

With all actions from the last days we have isolated it to three events (excluding the Dunkerbeck Event) that needs a manual solution (has to be done by @djong1 )

SSS Go big or go Home 2021-2022 - ID 715 Schildmeer Speed Challenge 2021-2022 - ID 704 BritishSpeedChallenge2022 - ID 710

Reports available at the usual address - https://logiqx.github.io/gp3s-query/events/

[Logiqx]

@jhdebruin

2022 DBO Speed Challenge - ID 732- removed "0 speed" entry

I think you also need to do a rebuild after removing the entry?

2022 Gps Kraaij Challenge - ID 721 - No action needed, reported session is excluded from event ranking because its outside event date (can be manually removed by Local Event Admin if she/he wants to do that ) 2022 Irish Speed Masters - ID 717 - No action needed, reported session is excluded from event ranking because its outside event date (can be manually removed by Local Event Admin if she/he wants to do that )

When I get time, I'l enhance the script to ignore sessions which are outside of the events dates.

I can scrape the event dates from the main website.

[jhdebruin]

@jhdebruin

2022 DBO Speed Challenge - ID 732- removed "0 speed" entry

I think you also need to do a rebuild after removing the entry? Just checked, the session i've removed is still visible in the "Weighted ranking" , this will be updated in next 48 hours...

[Logiqx]

I hate to say this but there are probably outstanding issues on gps-foilsurfing but it's not possible to check. I expect the Python script will readily support gps-foilsurfing with a minor tweak, once request #24 is implemented. Perhaps #24 should be regular priority (neither low nor high)?

Talking about events running across multiple years, I also see many that are 1 Jan-1 Jan, rather than 1 Jan-31 Dec. Perhaps those kinds of dates ranges should not be a thing?

[jhdebruin]

I hate to say this but there are probably outstanding issues on gps-foilsurfing but it's not possible to check. I expect the Python script will readily support gps-foilsurfing with a minor tweak, once request #24 is implemented. Perhaps #24 should be regular priority (neither low nor high)?

For sure it will be, but less events and less sessions :) So can be solved also , pretty sure #24 will be there in short time :)

Talking about events running across multiple years, I also see many that are 1 Jan-1 Jan, rather than 1 Jan-31 Dec. Perhaps those kinds of dates ranges should not be a thing? Will add this to some other enhancements i have i mind for creating events , would love to see some standardised names (including the year in the event , or two-years when it covers a longer range )

[Logiqx]

@jhdebruin

I've implemented the date check. It now ignores some "non-issues" (sessions outside of the event dates):

• 2022 Gps Kraaij Challenge is now clean

The script has found the following new issues because sessions outside of the event period are being used for rankings:

• SSS Go big or go Home 2021-2022
• 2021 Red Bull Bora Challenge
• Surf like a dude 2021.

[djong1]

side note @Logiqx see issue #24

[Logiqx]

I've added the number of date issues to the front page report. I've also added event dates to the event reports.

I can see that some events are using sessions outside of the event dates for the rankings and ideally, should be fixed.

No doubt this will be avoided for future sessions by the automatic event assignment but there are some issues present now.

https://logiqx.github.io/gp3s-query/events/

[Logiqx]

Another observation this morning after refreshing my event cache (i.e. downloaded latest data from the API).

Some events that were fine last night now have additional errors.

• Oddysey now has missing rankings for 1 person
• 2021 Red Bull has an additional incorrect ranking for 1 person

Seems there may still be an issue when people post new sessions?

[djong1]

@jhdebruin I have updated the rebuild script for an individual to support the 1 to many event change. Plus - when you set year parameter to 0 it will work over multiple years (timespan of the event).

[jhdebruin]

@djong1 Great, wil do some rebuild of the events still effected by the year issue, and lets see if this does the trick :)

[jhdebruin]

@Logiqx Just did a rebuild of the sessions https://logiqx.github.io/gp3s-query/events/710.html could you rerun the script to see of fixes worked from @djong1 ??

[Logiqx]

@Logiqx Just did a rebuild of the sessions https://logiqx.github.io/gp3s-query/events/710.html could you rerun the script to see of fixes worked from @djong1 ??

Just one oddity remaining. Garry's session which is listed in the sessions of BSC 2021 but appears in the NM rankings of BSC 2022.

https://logiqx.github.io/gp3s-query/events/710.html

[jhdebruin]

Allright, i've updated the other events with year related issues as wel

SSS Go big or go Home 2021-2022 - ID 715 Schildmeer Speed Challenge 2021-2022 - ID 704

Let's see what stays open, the session from Garry's is actual out the time range of the bSC 2021 event, and he also subscribed for the BSC 2022, so in that way it could make sense that's is automated included in the 2022...

[Logiqx]

@jhdebruin Reports updated.

Regarding Garry, it obviously makes sense for the session to contribute to the BSC 2022 rankings. My point was just that there is an inconsistency between the listed sessions and the resultant rankings.

Hopefully the full "multiple events per session" functionality will ensure that sessions are listed under the applicable events, via the website and API. I'm pretty sure this will be the intention of @djong1.

[Logiqx]

I've added totals to the front page report.

With just 2 ghost rankings remaining across all events it might be worth rebuilding 2022 DBO Speed Challenge.

https://logiqx.github.io/gp3s-query/events/732.html

[jhdebruin]

Ok, almost a clean sweep :) The remaining cases will have to be fixed manually. About the "Garry" case, i'm just curious how far the automated event part is already implemented by @djong1 , just try to understand.....

[Logiqx]

It would appear that the majority of the remaining issues are bad event selections (i.e. date out of range).

Is that something you can fix as a site admin?

[jhdebruin]

Yes, there is an option for this in the Event Admin module , not sure you have this already, but i can add it to your gps-speedsurfing account, might be handy to explore (you can only admin / edit events your started )

[Logiqx]

Yes, there is an option for this in the Event Admin module , not sure you have this already, but i can add it to your gps-speedsurfing account, might be handy to explore (you can only admin / edit events your started )

Thanks. I'll take a look when you've updated my account.

[jhdebruin]

@Logiqx done... you should have a new menu option in Personal Dashboard -> https://www.gps-speedsurfing.com/mygps.aspx?mnu=eventadminedit

[jhdebruin]

@djong1 Just checked the most actual report from https://logiqx.github.io/gp3s-query/events/ , and a bit concerning is the fact that the issues for The Dunkerbeck Speed Challenge have increased since last weekend....

[Logiqx]

@jhdebruin

A possibility to consider is that sessions are now being ranked using the automatic event code but they are not being listed in the event sessions being returned by the API.

I can see how this could happen but in due course, I'd also expect the API to list all of the sessions being used for event rankings.

@djong1 can probably confirm if this is the current situation.

[Logiqx]

@jhdebruin @djong1

The error counts are increasing again. The number of duplicates, "ghosts" and "incorrect" have increased since the last run 5 days ago.

It's possible that some of the "ghosts" and "incorrect" rankings could be caused by the newly-implemented automatic event assignment and it's the session list that is incorrect. This can't easily be accounted for in my checks until the session list returned by the API reflects the sessions assigned to the event.

The duplicates are clearly a bug.

[djong1]

@Logiqx I have created a beta API, can you have a look to validate: https://apimgp3s.portal.azure-api.net/docs/services/gps-speedsurfing-api-v2/operations/Eventranking

[Logiqx]

@djong1

I can successfully test event ranking from the service docs.

Once my trouble with event sessions is resolved, I'll be able to run my script to run my data integrity checks.

[Logiqx]

@djong1 @jhdebruin

I've re-run the reports using the V2 API.

Some inconsistencies still exist between event sessions and event rankings.

[Logiqx]

@djong1 @jhdebruin

I've done another refresh of the reports.

The number of duplicate, missing and incorrect rankings seems to be increasing with time.

[djong1]

@Logiqx I have found an additional bug when people RE-post within the batch time window to build the materialized view. Fixed this now. Please re-run the reports and keep an eye on-it for a week to see if it is stable.

[Logiqx]

@djong1 looking much better

Only 4 events with issues:

• 2022 Dunkerbeck Speed Challenge “The Summer Edition”
• 2022 Funsport Makkum GPS Speed Challenge
• 2022 Estonian Speed King
• BritishSpeedChallenge2022

[djong1]

closing for now and report on individual rider bases