View Single Post
  #4   Spotlight this post!  
Unread 05-12-2010, 04:05
timothyb89 timothyb89 is offline
code monkey
FRC #1977 (Loveland High Robotics)
Team Role: Alumni
 
Join Date: Oct 2008
Rookie Year: 2009
Location: Loveland, Colorado
Posts: 45
timothyb89 will become famous soon enough
Re: Best Data Format?

I had partially dismissed CSV/TSV/PSV/etc before because I wasn't able to export our data tree to it directly. But it's probably the most accessible format we can offer so I think I'll need to find a way

I don't think it could be done in the same manner as JSON or other tree-based formats (XML, etc) so it'd probably multiple files of lists, like:

teams.csv
Code:
# number, nickname, location, rookie season, other stats...
1,The Juggernauts,Pontiac, MI  USA,1997,...
4,Team 4 ELEMENT,Van Nuys, CA  USA,1997,...
events.csv
Code:
# name, short name, start date, end date, other stats
Ann Arbor FIRST Robotics District Competition,ann-arbor,1268377200000,1268463600000,...
ann-arbor-matches.csv
Code:
# number, red 1, red 2, red 3, blue 1, blue 2, blue 3, red score, blue score
1,68,1998,49,2591,2619,862,1,5
2,2611,1684,3415,2627,3302,1940,0,0
...plus more for standings, awards, and the like. Hopefully that should be easy enough for everyone to parse, and we'll have that up and running in a few days!
We've also finished JSON exporting for events, mostly, e.g. http://glass.frcdb.net/event/colorado/json returns basically the same data as the normal event page. (A somewhat more readable example of event JSON here). With any luck, the 2 current choices should make things pretty accessible!
__________________
FRC-DB: A detailed, web-based scouting database for FRC teams with lots of interesting statistics.