Friday, February 24, 2012

Downloadable PITCHf/x

So MLB provides amazing amounts of data.  The term for the system that tracks the data (and for the data itself) is PITCHf/x.  To get this data MLB has two cameras mounted in every stadium to track the speed and location of a pitched baseball from the pitcher's mound to home plate with an accuracy of better than one mile per hour and one inch. This is the same data you see in MLB's online Gameday webcast to show the path and speed of each pitch, as well as the location with respect to the strike zone as the pitch crossed the front of home plate.   For a primer on Pitchfx and how to setup your own database, read these   http://fastballs.wordpress.com/page/2/  and this http://fastballs.wordpress.com/2007/08/23/how-to-build-a-pitch-database/ Seriously, it is better than anything I'll write.  However I do have something that might interest you.  Here is a LINK to the database I created (click file, download as to get it).  It isn't perfect as it doesn't parse all the defense information but it has every game, at bat, and pitch from 2007 through 2011.  You'll need to download a working MySQL system. I like http://www.easyphp.org/  which has PhpMyAdmin installined  (a gui for running MySQL).    So between my database, easyphp and the scripts that Mike Fast has available to update the database, you'll be doing painfully complicated baseball analysis that Tom Tango hates in no time.