The last table for our Run Environment set is almost exactly the same as the one I presented before with two differences: we’re returning the runMinus and RunPlus from the intermediate table, and we’re using a variable to define wOBAscale- making the whole thing much more elegant and easy to understand.<\/p>\n
# The last Run Values table, returning fields from RunValues1A, defining wOBAscale\r\n# as a variable, and giving us the weighted factors by league year for batting events\r\nDROP TABLE IF EXISTS tblRunValues2;\r\nCREATE TABLE tblRunValues2 AS\r\nSELECT year\r\n, league_id\r\n, RperOut \r\n, runBB \r\n, runHB \r\n, run1B \r\n, run2B \r\n, run3B \r\n, runHR \r\n, runSB \r\n, runCS \r\n, runMinus \r\n, runPlus \r\n, wOBA \r\n, @ws := 1\/(runPlus+runMinus) AS wOBAscale \r\n, (runBB+runMinus)*@ws AS wobaBB \r\n, (runHB+runMinus)*@ws AS wobaHB \r\n, (run1B+runMinus)*@ws AS woba1B \r\n, (run2B+runMinus)*@ws AS woba2B \r\n, (run3B+runMinus)*@ws AS woba3B \r\n, (runHR+runMinus)*@ws AS wobaHR \r\n, runSB*@ws AS wobaSB \r\n, runCS*@ws AS wobaCS \r\nFROM tblRunValues1A;<\/code><\/pre>\nThis is the table that we’ll refer to when calculating wOBA for individual players, factoring wobaXX against their counting stats XX. \u00a0It’ll make more sense when we actually do it.<\/p>\n
This is almost all of the data we need to complete our batting stats. \u00a0What remains is park factor. \u00a0I had been hoping that we could use the factors listed on the parks table. \u00a0Unfortunately, OOTP’s resident MySQL Whisperer says it’s not true<\/a>. I’m going to set that aside for today- while I figure out how to calculate park factors – and use an incremental approach to developing the batting stats view. \u00a0I figure that will give me one, maybe two, posts to get a good method for that.<\/p>\n","protected":false},"excerpt":{"rendered":"The last table for our Run Environment set is almost exactly the same as the one I presented before with two differences: we’re returning the runMinus and RunPlus from the intermediate table, and we’re using a variable to define wOBAscale- making the whole thing much more elegant and easy to understand. # The last Run… Continue reading Run Environment 6: Run Values 2<\/span>