View Single Post
  #6   Spotlight this post!  
Unread 30-03-2014, 00:09
Fletch1373's Avatar
Fletch1373 Fletch1373 is offline
Registered User
AKA: Fletch
FRC #3181 (Panthers)
Team Role: Mentor
 
Join Date: Jan 2008
Rookie Year: 2004
Location: Rochester, NY
Posts: 251
Fletch1373 has much to be proud ofFletch1373 has much to be proud ofFletch1373 has much to be proud ofFletch1373 has much to be proud ofFletch1373 has much to be proud ofFletch1373 has much to be proud ofFletch1373 has much to be proud ofFletch1373 has much to be proud ofFletch1373 has much to be proud ofFletch1373 has much to be proud of
Re: Pulling FIRST Data

Quote:
Originally Posted by compsuppjk View Post
As far as I know, there are only three main sources from which you get data.

The first would be the twitter handle @FRCFMS, which is posted to by each individual event server as the matches are played. I would never solely use this data, because if an event is having an issue with the internet at their venue, you will never be able to get this data again (nobody goes back and creates those twitter posts).

The second source of data would be the event data posted in HTML format found through the FRC website (example: http://www2.usfirst.org/2014comp/Eve...hresults.html). Because these use the standard event codes in the URLs, you can programatically scrape these pages. You can find the match results and all of the rank data this way, and they should be updated every time a new match score is committed. In my mind, this is the best way to obtain data, as these HTML files will generally be posted after an event, even if there was an issue with the internet at the venue.

The third source of data pertains to your question about team information. This is unfortunately where it gets tricky (perhaps there's a better way to do this, but I'm not aware of one.) If you go to an event's page on the FRC website, there is a link "What teams are registered for this event?". If you open that in a new tab, you get something that looks like this: https://my.usfirst.org/myarea/index....5BB4Gjoq14A824 . You can individually click on teams in that list to get their TIMS data; perhaps this format is OK for what you're doing, as you'd be looking for data on teams by event. You could also script something to query all of the events and compile the data that way. The only other thing I could think of to do would be to iterate through the last value on this link: https://my.usfirst.org/myarea/index....ls&tpid=211505 until you grab all of the data (unfortunately that record number doesn't seem to correspond with team numbers in any way).

I hope this helps.
There's an additional source that you didn't mention. It's not well known, but has been mentioned a few times on this site. This data is available in tab-delimited format only(as far as I can tell), but is still quite useful.
__________________
Student:
<04: FRC0213> <05-08: FRC1373>
Mentor:
<09-10: FRC0809> <11-12: FRC3555> <12-14: FRC0073> <15-??: FRC3181>
Volunteer:
<FTAA> <CSA> <Defense Coordinator> <Scorekeeper> <Robot Inspector> <Official Scorer>
2016 Tour:
CTWAT [DefCoord] > Pittsburgh[Mentor/DefCoord] > TVR[FTAA] > FLR[CSA] > NE DCMP[CSA] > CMP[CSA]