As you see, it displays information from RobotEvents on every team in the world.
Right now, we only have a text-based interface we can use to search for teams and view their tournament performance, awards, and skills data. We can also search for team information by location and by team name.
We got our data both from the .csv files on RobotEvents and through HTML parsing of the data available on event pages. The data is stored in a MySQL database and is currently being accessed through a simple Linux shell script. All of this is being run on a Raspberry Pi and is accessed by our club members via an SSH client.
In the next week or so, we’re planning on adding a GUI, and, if we’re successful, we will make the complete version available to the public on our website.
This has been a pretty substantial effort on the part of our team members. If you have any questions, feel free to ask us here! Likewise, if you have any suggestions for us, we’d love to hear them.
It looks cool
It would be interesting if it could say what alliance the team was on(1st, 2nd etc.) and if they were the captain, 2nd team or 3rd team on the alliance.
First off, I think this awesome and would be unimaginably useful.
Secondly, I don’t think that information is listed on RobotEvents. The teams are just listed in ascending order (by team number) not by their pick number.
Thanks! Our members have really spent a lot of time working on this, and we hope to finish a simple GUI within the next week or so.
Also, I’m fairly sure that the teams are listed in order of their pick both under the Results tab on RobotEvents and in the .csv files for the event’s matches. It might, however, be difficult to figure out which seed alliance a team was part of since this isn’t listed on RobotEvents and the order of the elimination round matches isn’t always the same.
How would you be interested in merging codebases and providing tournament information as well, and allowing me to provide more comprehensive team information in my app?
I was referring to the list of matches under the “Results” tab, which is where we got the data for the “finish” column for. (See [http://i.imgur.com/jk0lOob.png for the data from CA State.) The team numbers for elimination round matches are in order of pick, so we should be able to parse the data for pick number.
We probably won’t be doing this before Worlds this year though. It might be something that we consider working on over the summer, but we’re focusing on getting a working GUI done for now.](http://i.imgur.com/jk0lOob.png for the data from CA State.) The team numbers for elimination round matches are in order of pick, so we should be able to parse the data for pick number.)
I didn’t notice that because for the event I was looking at the data was reported incorrectly. The reporter never selected the correct team that was competing so the matches just looked like qualification matches.
Either way, can’t wait for you guys to release this!
Here is my scouting database that I made for world. It hasn’t been updated since after Pan Pacific but can be pretty easily (just takes 15 minutes or so to run). It goes out and downloads all of the .csv files from robotevents.com and saves them to a folder. The programmed pictured reads those files in and calculates OPR (offensive power ranking) based off of this algorithm. It is not ready for release but my week long spring break is next week and if people are interested, I can finish it up over then.
As you can see, it ranks teams via their highest OPR. It also shows their best programming skills run and driver skills run.
There is also the option to view via competion.
There are several bugs to still work out (working on a multi-team search) but could be finished reletivley easy. This scout also has the option of importing partial competitions (think mid-world championship).
I’d be interested in seeing what our options are as far as sharing data. We have more information on each tournament than what is shown in the screenshot. I’ve seen some of your posts about your app, but don’t have an Android device to run it on (and it’s not compatible with BlueStacks).
Yeah, that’s a problem with some of our RobotEvents data. Not every tournament reports its Elimination Round matches correctly–I actually had to go in and delete some duplicates from one of the tournaments we attended. When we do make this public, please tell us if there are any events you’ve attended with incorrect data!
Hi! Your database actually looks pretty cool. It seems as if yours and ours fill different niches, so it’d be great for both of our teams and the community at large if we were both to release ours. Our database covers things like awards and basic stats, so a scout can get a feel for how well a team did over the course of the season within their own region (did they dominate? or did they qualify from a lucky alliance?). But your database is far more useful for getting a feel for how a team does during matches (how easily does it score? does it allow the opponent to score much?). We’re looking forward to the release of your database!
I like the idea of combining our databases. What programming language did you use? Maybe it could be a thing where I help make the GUI and add it to my program so that people could use both of ours at the same time.
The back end of our database is pure MySQL. The text UI in that screenshot is a very simple Linux shell script. We are currently working on getting a web GUI working using PHP/HTML. What did you use to create yours?
I used C# .NET so it is windows only (sorry). I have never done any database work before in C# but have worked on it in other languages. It would probably be pretty easy to integrate.
We are actually mostly done with our database work for right now. We managed to get a GUI working using and up on our website using PHP/HTML. Thanks for offering your help and please let us know if you have any questions or suggestions!
Feel free to take a look at our post detailing its features and let us know what you think.
WOW, I just went to your scout database online and it is very useful. I love how easy it is to just search a team by number and find out what awards they got throughout the whole year, it’s so easy!!
