Here’s where things start to get fun. I’m going to be setting up a number of views that will allow me to calculate some of the more advanced statistics. The ones that I am most interested in are Weighted On-Base Average (wOBA), Weighted Runs Created (wRC), Weighted Runs Above Average (wRAA), and Weighted Runs Created+ (wRC+). If this blog ever becomes a book or major motion picture, I will come back and fill in some detail about what these stats are and why they are meaningful. Until then, I will leave the links to do the explaining.
I am basing all of this Run Environment work on a couple of posts and formulas posted by Tom Tango on his blog.
wOBA is the gatekeeper to all of these other stats, and it can’t be derived from a player’s individual stats alone. It requires some baseline statistics about the run environment in which a batter plays. The first step is to determine, for each league year, the number of Runs, Outs, Plate Appearances, Runs per Out, and Runs per PA. I don’t have a good way, yet, to separate out sub_leagues, and Tango doesn’t seem to care at this point, so I leave it alone.
The other thing that Tango does and that I have decided to omit is limiting the summed pitching stats to those accumulated by players whose primary position is pitcher. My experience is that non-pitchers pitch so rarely in OOTP that it is not worth creating a new view to determine primary position.
I create a view, as such:
CREATE OR REPLACE VIEW vLeagueRunsPerOut AS
SELECT p.year
, p.league_id
, SUM(p.r)/sum(p.outs) AS "RperOut"
, sum(p.r) AS "totR"
, sum(p.outs) AS "totOuts"
, sum(p.outs)+sum(p.ha)+sum(p.bb)+ sum(p.iw)+ sum(p.sh)
+ sum(p.sf) AS "totPA"
, round(sum(p.r)/(sum(p.outs)+sum(p.ha)+sum(p.bb)+ sum(p.iw)+ sum(p.sh)
+ sum(p.sf)),8) AS "RperPA"
FROM players_career_pitching_stats AS p
GROUP BY p.year, p.league_id;