This project contains code for a Ruby-on-Rails web site that displays data about Aerobatic Contests of the International Aerobatic club.

Find the site deployed at http://iaccdb.iac.org/

For more information contact Douglas Lovell, doug@wbreeze.com

Here are some further development items, beginning with work items definitely in the queue:

• parse the collegiate participation data now coming in from JaSPer in order to set up the collegiate computations (must do soon)
• enable entry of Nationals Chief Judge assistants (must do).
• enable multiple Chief Judge assistants.
• identify for patch participation and eliminate it from series and soucy computations
• import more Nationals results from prior years
• vastly simplify the data schema, incrementally, from as-is to-be
  • replace references to the f_results table with direct references to the flights table
  • remove the f_result table
  • replace references to the c_results table with direct references to category and contest
  • remove the c_result table
  • remove the unnecessary relations among computed result tables
  • replace use of the regional_pilots and region_contests tables with use of the results and result_accums tables
  • remove the regional_pilots and region_contests tables
• incrementally extend the RESTful JSON API that enables anyone to pull this data and do useful things with it
• use the data for some statistical analysis projects and research
• add a system of authorizations/keys for specific roles on specific contests/flights
• add an AJAXy interface for selecting and adding members into the many member roles
• add an AJAXy interface for selecting and adding airplanes
• add an AJAXy interface for selecting and editing sequences
• add authorized edit screens for scoring director, chief judge table, boundary judge, and line judge roles
• add SVG capability for representing and displaying figures
• extend the sequence models with catalog numbers and figure representations