huge refactoring of helper functions, using views instead of sqlalchey
update web stuff to work with new data
changes to handle data for 'All'
fixing things to work with apc data