• Welcome to the DeeperBlue.com Forums, the largest online community dedicated to Freediving, Scuba Diving and Spearfishing. To gain full access to the DeeperBlue.com Forums you must register for a free account. As a registered member you will be able to:

    • Join over 44,280+ fellow diving enthusiasts from around the world on this forum
    • Participate in and browse from over 516,210+ posts.
    • Communicate privately with other divers from around the world.
    • Post your own photos or view from 7,441+ user submitted images.
    • All this and much more...

    You can gain access to all this absolutely free when you register for an account, so sign up today!

AIDA Results Register

Thread Status: Hello , There was no answer in this thread for more than 60 days.
It can take a long time to get an up-to-date response or contact with relevant users.
Where to send it to Ivo? I cannot find any email addres?
 
Last edited:
Well, if you want to send them to me, use IVO at APNEA dot CZ. If you want to use AIDA's address, it should be listed on their website (probably on the competition calendar page). I would of, course prefer, if I get the results from the officials (the judge or the organizer), or that you attach their contact adress or phone number, where the authenticity could be verified, in case some complaints come in.
 
And also, if you find any errors in the ranking, please let me know so that I can check it out and fix if necessary. I already had some feedback from Will Trubridge and from Morten Villardsen, which helped me finding some impropely imported files.

In the original ranking lists, there were also many duplicate entries for competitors, which were filed under several different variations of their name. I tried to locate them, used different automated algorithms for that purpose, and a lot of manual data combing, and detected over 800 such cases, but there still may be some others I did not find (Morten told me about one too). So if you see yourself, or someone else you know, filed under different names, please let me know.
 
Last edited:
Fantastic ranking, trux! Really, excellent. I much prefer your format, too, to what I'm assuming in the draft of the AIDA register emerging (the one linked to you database) or is that an old version?

Kudos!

Pete
 
Thanks Pete. Well, the two systems are separated and independent, though we can now exchange data. I processed the data that was already in the old AIDA Register, fixed diverse errors, removed duplicates, completed missing data from the old Excel tables, added many more old competitions from other sources, and also all remaining available result sheets for 2009. We will now feed back the data from my database to the AIDA Result Register, which for the time being remains running Jome's software, which is quite fine too.

That's for the moment the simplest and quickest solution. Though, the most urgent task is actually not the user interface, but the data entry - the old data is now more or less fixed, but we urgently need to put up a compulsory registration system so that there is no more need on AIDA's side to enter the data manually - it is much more horrible work than anyone can imagine, and I do not wish anyone to have to do it. As already written earlier in this thread, the Freedive Central is the solution at the hand, but we need to see how exactly to implement it, and what modifications, and rewriting it needs.

So there may be some temporary solution using the elements already available, but the project only gets shape, and the IT team investigates the best and fastest paths. I do not want to speak too much about it, although personally I am for absolute transparency, and would prefer if all the discussion about the system was open to anyone interested, but I do not know yet the opinion of AIDA officials, and of the other members of the IT team on this topic.

However, I can tell you whatever you wish to know about my own ranking. So if you have any questions or wishes, do not hesitate to ask.
 
Monumental effort, thank you!

By the way, what was your record for "types of spellings for one person"?

If I remember correctly, Stig Severinsen was spelled in at least 10 different variations
 
Thanks, Jome, Pehtran!

jome said:
By the way, what was your record for "types of spellings for one person"?

If I remember correctly, Stig Severinsen was spelled in at least 10 different variations
Click to expand...
Yes, there were a few for Stig too, but I guess you already cleaned up many of the duplicates in the Result Register, so only variants from the other sources added to it. And additionally, I do not count variants with simply inversed first and last name, with and without diacritics (accented characters), because theses cases are trapped automatically by the program, and not passed to the database. So at Stig I have in fact only three recorded variants needing the handling for duplicates. The other ones are fixed automatically by the filters during the data import.

The worst, I believe, was Karol Meyer, and other Brazilians who all have up to six names. Sometimes they use only the first and the last, sometimes, the first and one of the middle names in different combinations, sometimes just the first letter for some of them, and sometimes all of them. So if the records are correct, the full name (or the longest used name) of Karol is "Karoline Mariechen Meyer Dal Toe", while most commonly she is just under "Karol Meyer". You can imagine for how many variants it allows. Additionally it is unclear to me what should be the first name (or given / "christian" name), and what the last name (or family name / surname), so often even the order of the names in the source data differs.

Fortunately in her case, there are only 7 variants needing handling, but at some of the other Brazilians (and at some others from Southern America) it is worse. Processing the data from southern and central America was a real nightmare.

EDIT: problematic are also Russian, Greek, or Japanese names, which are often transcribed in many different ways from the original alphabets to latin. At Russian and Greek, I am still able to catch it up in most cases, but fear that I still have miss-assignments at some of the Japanese names.
 
Last edited:
Reactions: TimoP and apneaboy
You are a star Trux.

Good luck with the database its going to be fantastic I can tell.
Posted via Mobile Device
 
I just added 10 other competitions I received from organizers. Please go on with sending me information about the missing ones. I know some of them were cancelled, but there are still a few that certainly took place. It would be a pity not having them there. I'll post an updated list of the missing ones in a while. If you can contact any of the organizers, please put some stress on them to deliver the data.

I did not post the URL here yet for those that did not see Jorg's blog. And it is not yet linked from the main menu or anywhere else on the website. Mainly because I fear the server may get too slow. Well, it is not too bad, just be patient if the page takes long to load. I'll be moving to a faster machine, but it needs some time, money, and effort, so it may take a week or two. Here you go: APNEA.cz - Ranking
 
I added a list of competitions available in the ranking, and also those still missing. If you go to the ranking, on the page with the ranking reports, select the mode "competition list" in the 3rd dropdown box to get it. You can filter the list by diverse criteria (year, federation, country, continent, region), or search by a string in the name or location (enter it in the field "competition"). You can also sort the list by any column - simply click the respective column header.

To get the list of missing competitions (still 79 of them), simply enter an exclamation sign (!) into the "competition" search field. You can also filter and sort it in any way you want with the help of the selection menu bar.

If you have access to any results still missing, please let me know.
 
Last edited:
I can see for STA in Rhein-Main Cup 2009 2 red cards with status of NR
See correct results of Robert Cetler and Goran Cholac at results_men

I also dislike representing of ALL competition result as mess list of separate disciplines together ordered by a discipline's points instead of total number of points.
 
osusim said:
I can see for STA in Rhein-Main Cup 2009 2 red cards with status of NR
Click to expand...
Thanks! These ones are fixed. Keep it coming, there are still certainly plenty of other discrepancies.

osusim said:
I also dislike representing of ALL competition result as mess list of separate disciplines together ordered by a discipline's points instead of total number of points.
Click to expand...
Well, nobody forces you to look at the reports you dislike (finally, you were already banned from APNEA.cz once) . Others may find useful to see which performances take the most points. Combinations are not available yet, but as I wrote, there are still plenty of other features in development that I did not release yet. It just takes time and effort to get them ready, so you'll need to keep your patience. Finally, you were pratically two years without ranking, so you should be happy with what you get

PS: I added also a checkbox for showing the official AIDA ranking results only (filtering out non-AIDA performances, individual record attempts, and non-ranking AIDA competitions). It is not yet labeled accordingly (just "AR" at it, and with a mouse-over description), but you can find it on the right side of the selection bar, above the OK button.
 
Last edited:
Same place: Michal Risian in DNF has yellow card and 69.5 points.

Could you also remove (or filter out) all empty results for DYN/DNF competitions which were inherited from AIDA database till 2008?
 
osusim said:
Same place: Michal Risian in DNF has yellow card and 69.5 points.
Click to expand...
Hm, the only DNF I see at the Rhein-Main Cup 2009 is the 158m of Michal Mrozowski, but it has a white card. And I see no yellow card of Michal Risian in DNF anywhere else also. Can you specify which competition exactly you mean?

osusim said:
Could you also remove (or filter out) all empty results for DYN/DNF competitions which were inherited from AIDA database till 2008?
Click to expand...
Well, most of them were already removed. Some of them are legit (i.e. DNS). If you know about any specific ones, and are sure they are not DNS, please tell me which ones exactly - I'll have to do it manually, since an automated algorithm could remove some records belonging there.
 
Thanks, Frank! When I have you here, could you help me get the results of the "2nd Columbian Freediving Championship in Pool" from 2003?
 
trux said:
Hm, the only DNF I see at the Rhein-Main Cup 2009 is the 158m of Michal Mrozowski, but it has a white card. And I see no yellow card of Michal Risian in DNF anywhere else also. Can you specify which competition exactly you mean?
Click to expand...
You can see announce DYN/DNF for RMC-09 at Teilnehmer and at list half of athletes performed DNF. I missed that mistake at my first look to your DB. Same for Michal Risian but his AP was larger then RP (145 versa 142), so yellow card and less points.

Results of 12 German Night of Apnea 2009 can be found at 11. Deutsche Nacht des Apnoetauchens in Berlin And may be you need to add 16x50 discipline to the list. You know, there are many WRs and NRs in 16x50. Results weren't reported to AIDA because 16x50 is not ranking discipline. But it's possible to look at all Night of Apnea competition at Infos der Apnoe - Gruppe

 
osusim said:
You can see announce DYN/DNF for RMC-09 at Teilnehmer and at list half of athletes performed DNF. I missed that mistake at my first look to your DB. Same for Michal Risian but his AP was larger then RP (145 versa 142), so yellow card and less points.
Click to expand...
Well, I admit that if the points and penalties are not in the source results, I simply calculate the points from the RP, so in case of incomplete results like at the RMC 2009, there may be such mishaps. In future I may add a more complex calculation, and taking in view the rules valid in the time of the respective competition, but these data actually should come from the organizer/judge - it is not really myself who is authorized to assign penalties and yellow/red cards. If you want to have them there, you best speak to the organizer or the judge, and tell them to send me the full data sheet, including the penalties and assigned points for each discipline.

First of all, they should have sent the complete result chart a long time ago to AIDA, but apparently three quarters of organizers never do it, or send incomplete data, or some stupid file in PDF or bitmap format that cannot even be parsed by machine, is full of errors, and does not include the mandatory data (like for example full names, genders, nationalities, penalties, points, etc.). This is exactly why we need, and why AIDA now builds a central competition registration software.

Thanks for the GNA12 results! Yes, I have the 16x50 results in my database too. But since they are currently only from one of the GNA, I did not add a separate report for them yet. As soon as I get my fingers on more of them, I list the 16x50 discipline there too. Perhaps, after adding the GNA 2009 (though I just see the 16x50 results are not listed yet at the GNA 2009).
 
Last edited:
You must log in or register to reply here.
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…