Beyond the Box Score: An SB Nation Community

Navigation: Jump to content areas:


Pro Quality. Fan Perspective.
Login-facebook

A Non Database Pitch f/x Database. Interested?

I know most of the writers and users who use pitch f/x data have a MySql database to gather the data. This is the best way to go to collect and organize the data and even link it to retrosheet. 

However, there are some people who use pitch f/x data and are probably willing to have database, but don't know how or don't have the time to learn how or even to avoid learning the language. Through some  Google earching and elbow grease I have been able to develop a relatively easy method to create a sort of "database" for the pitch f/x xml files. The method limits itself to sorting the files only by pitcher and hitter so it is ideally used only for looking at a pitcher or two at a time (unless you have the time to add more).

Limited but useful for those wanting just the data for a specific pitcher or hitter for inseason comparison or player to player comparison. Or whatever else you want.

I just wanted to post this to see if there is some interest for me to write up a series of posts to explain how to do so. If so I will likely post it sometime in September and try to have one on even getting hit location.

0 recs  |  Comment 6 comments |

Story-email Email Printer Print

Comments

Display:

YES!!!!

in-season pitcher comparisons would be awesome (not just start-by-start). also rankings (vel, break, etc.) would be even more amazing.

by ktsharp on Aug 31, 2009 4:26 AM EDT reply actions  

PLEASE

"I'll be glad to have Ryan [Braun] help if he wants to. I'll give him a badge and he can be my deputy." - Doug Melvin

by all4tookie on Aug 31, 2009 2:03 PM EDT reply actions  

Comments For This Post Are Closed


User Tools

We use numbers and stuff.
Community Guidelines
Why be a member?
Start posting on Beyond the Box Score »

Join SB Nation and dive into communities focused on all your favorite teams.

Connect_with_facebook

FanPosts

Community blog posts and discussion.

Recent FanPosts

Small
FIP is a Garbage Statistic
Jeter_400_101709_small
Scarier opponent come October?
Ghanafan03_741584gm-a_small
Los Angeles Angels trade for Dan Haren
Pedoria1_small
Pointing Fingers: Rollie Fingers and WAR
Small
Rajai Davis versus Gabe Gross
Small
Year of the Pitcher
Sealab_murphy_small
Prospect Surplus Value
T-rex_small
Saberizing a Mac, revisited
Small
How do you use splits?
Sealab_murphy_small
My Wang Problem

+ New FanPost All FanPosts >

Sign up for the BtB Newsletter!

BtB on Facebook

BtB on Twitter

RSS Feed: @BtBScore

Sky: @BtB_Sky

Jeff: @jeffwzimmerman
Steve: @steve_sommer
Dan: @dturkenk
Harry: @harrypav
Jinaz: @jinazreds
Jack: @jh_moore
Tommy R: @trancel
Justin: @justinbopp
Satchel: @SatchelPrice
Adam: @baseballtwit
Larry: @wezen_ball
Peter: @CapitolAvenue
Paul: @TheDiaTribe
Daniel: @CamdenCrazies
Matt: @devil_fingers

SBNation.com Recent Stories

ST. LOUIS - MAY 18:  Ryan Ludwick #47 of the St. Louis Cardinals rounds third base after hitting a game-winning homerun against the Washington Nationals at Busch Stadium on May 18, 2010 in St. Louis, Missouri.  The Cardinals beat the Nationals 3-2.  (Photo by Dilip Vishwanat/Getty Images) +3 updates

Padres, Cardinals, Indians Complete Three-Way Trade Involving Ryan Ludwick, Jake Westbrook

SEATTLE - JULY 08:  Alex Rodriguez #13 of the New York Yankees hits an RBI single in the ninth inning to give the Yankees a 3-1 lead against the Seattle Mariners at Safeco Field on July 8 2010 in Seattle Washington. (Photo by Otto Greule Jr/Getty Images) +16 updates

Yankees' 9th-Inning Win Completely Overshadowed By A-Rod's Ongoing Homer Drought

Colorado Rockies' Carlos Gonzalez is congratulated by teammates after his walk-off home run against the Chicago Cubs in the ninth inning of a baseball game at Coors Field in Denver, Colo. on Saturday, July 31, 2010.  (AP Photo/ Matt McClain)

Carlos Gonzalez Completes Cycle With Walk-Off Homer; Rockies Beat Cubs, 6-5

More from SBNation.com >


Managers

Limes_125_small Sky Kalkman

Wbc_029_small Jeff Sullivan

Editors

Rawlings_baseball_bigger_small Dan Turkenkopf

Dayton_small Jeff Zimmerman (TucsonRoyal)

Aviles_small Justin Bopp

Paige_small Satchel Price

Authors

Jinaz-reds-avatar_small JinAZ

Face_small Harry Pavlidis

Newavatar_small Matt Klaassen

Wezenball-logo_small lar

Big_pun--300x300_small Tommy Rancel

Adam_small adarowski

Redcap_small SFiercex4

St_louis_cardinals_ce1141_003263_small stevesommer05

Small garik16

Julio_teheran_2_small PWHjort

Cclogo_small Daniel Moroz

Closeup4_small J-Doug

Nick_cage_small The DiaTriber