The Blue Alliance - Data Loss

[Greg Marra]

Originally Posted by Littleboy

Many team names have been lost and replaced with just the number.

Yea, we don't have fully up to date team names for teams that didn't compete in 2012. If you find any missing for 2012 teams, let me know.

For pre-2012 teams, I've opened an issue to fix this (we've never done it right): https://github.com/gregmarra/the-blu...nce/issues/108

Originally Posted by ~Cory~

Said user should have run tests on a local machine.

Can you expand a little more on this portion?

There was no malicious intent. This was a combination of curiosity and us having a big bug in our configurations. Everyone learned something.

[dodar]

Team 801 is missing name and sponsors.

[Greg Marra]

Originally Posted by dodar

Team 801 is missing name and sponsors.

Hmm, trying to figure out why we're not re-grabbing these right. Thanks for the pointers. FIRST's page structure makes scraping this information tricky (you can't just look up a team with it's team number), so I think something may have changed in the mean time.

Will dig in later this week, thanks.

[kmehta]

Originally Posted by Greg Marra

FIRST's page structure makes scraping this information tricky (you can't just look up a team with it's team number), so I think something may have changed in the mean time.

You could use frclinks.com/t/####.

[The Lucas]

Oddly enough, it looks like you only have team info for defunct team numbers like 40, 47 & 65. Wonder if that is stale backup data because it is not overloading them in failed scrapes.


All the team info TBA uses is available in one (easy to parse) tab deliminated page
https://my.usfirst.org/frc/scoring/i...?page=teamlist
It would be easier to just scrape that page. Plus, that is only 1 page request instead of thousands.

Alternatively, you could ask 358 for its database (especially if you want to fill in defunct team data)

Great job getting it back up, Greg!

[Eugene Fang]

Originally Posted by The Lucas

Oddly enough, it looks like you only have team info for defunct team numbers like 40, 47 & 65. Wonder if that is stale backup data because it is not overloading them in failed scrapes.


All the team info TBA uses is available in one (easy to parse) tab deliminated page
https://my.usfirst.org/frc/scoring/i...?page=teamlist
It would be easier to just scrape that page. Plus, that is only 1 page request instead of thousands.

Alternatively, you could ask 358 for its database (especially if you want to fill in defunct team data)

Great job getting it back up, Greg!

Just found https://my.usfirst.org/frc/scoring/i...page=eventlist too!
This is amazing...

[qzrrbz]

Originally Posted by EugeneF

Just found https://my.usfirst.org/frc/scoring/i...page=eventlist too!
This is amazing...

Don't believe the headers on this one though! Seems the "num_teams" field isn't there.

[Joseph Bisch]

Originally Posted by The Lucas

All the team info TBA uses is available in one (easy to parse) tab deliminated page
https://my.usfirst.org/frc/scoring/i...?page=teamlist
It would be easier to just scrape that page. Plus, that is only 1 page request instead of thousands.

Originally Posted by EugeneF

Just found https://my.usfirst.org/frc/scoring/i...page=eventlist too!
This is amazing...

While those would reduce the page requests, those seem to only provide data for 2012. I tried tacking on "&year=2011" and "&season_FRC=2011" to both URLs, but neither provided 2011 data. Is there something I am missing?

I think we should go ahead with implementing it and use it when we need data for the current season.

[The Lucas]

Originally Posted by Joseph Bisch

While those would reduce the page requests, those seem to only provide data for 2012. I tried tacking on "&year=2011" and "&season_FRC=2011" to both URLs, but neither provided 2011 data. Is there something I am missing?

I think we should go ahead with implementing it and use it when we need data for the current season.

You are not missing anything. That page is for the FMS so it only needs this year's data. Again, I recommend talking to 358 for any historical team data.

Other FMS pages you might find useful
2012 Event List
Sample Event Team List ('12 CMP)
You can get to the event team list by using index.lasso?page=event_teamlist&ID_event=<ID on the Event List Page>
I have been using these pages for a for scouting/stat purposes since they parse easier in Excel than the /myarea/ ones linked from the FRC regional page (copypasta a team list from there each team will have their town will show up in its own row, and it may be over multiple pages).

[Greg Marra]

Originally Posted by The Lucas

All the team info TBA uses is available in one (easy to parse) tab deliminated page
https://my.usfirst.org/frc/scoring/i...?page=teamlist
It would be easier to just scrape that page. Plus, that is only 1 page request instead of thousands.

!!

This page is amazing!!! Issue opened to switch our scrapers to this - it's so much simpler!

I made a FIRST Wiki page to trade notes on how to scrape FIRST pages. Borrowing Pat Fairbank's TPID scraper made scraping Team pages possible before, but I don't think that's a widely known technique. It needs more love, but an OK start.

[Eugene Fang]

I'm currently super confused about the event code for the Michigan State Championship. http://frclinks.frclinks.com/ and https://my.usfirst.org/myarea/index....=2012&event=gl both suggest it should be "GL"

However http://www2.usfirst.org/2012comp/eve...edulequal.html and http://www2.usfirst.org/2012comp/eve...edulequal.html show similar but conflicting data, both for Gull Lake District.

I'm guessing Gull Lake (MIGL) accidentally started posting to GL, and they changed half way through? With GL being the Michigan State Chapmionship?
Can anyone shed some light on this discrepancy? Thanks.

[The Lucas]

Originally Posted by EugeneF

I'm guessing Gull Lake (MIGL) accidentally started posting to GL, and they changed half way through? With GL being the Michigan State Chapmionship?
Can anyone shed some light on this discrepancy? Thanks.

The recently updated MSC teamlist suggests that it is still GL since its query includes "&year=2012&event=gl"

Perhaps, this is the reason why MIGL is so odd among event codes. It is the only 4 digit event code and doesn't follow FiM's usually standard of basing the event code off of the Michigan county where is is held (it would probably be KZ for Kalamazoo County).