C² PCL Database - Page 2

Cooleyvol · 06-24-2011, 08:23 PM

Seriously, the fielding stats are not on BBRef prior to about 1925 or so. Therefore, they're having to be hand input from Spaulding guides from 1903-1924 or so.

A lot of work, but I want as much information driving this database as possible. This is the last true grouping of tedious work and I would think this thing will be as statistically accurate as it possibly can be, given the years we are dealing with.

Spritze · 06-24-2011, 08:43 PM

Well better you than me as far as tedium goes.

FYI: Tedium goes nearly 330 miles before it gets bored and stops in Far, TN.

Cooleyvol · 06-25-2011, 11:54 AM

Fielding stats are completed up through 1909. After further review, it seems I only will need to go through 1918 with fielding input, so I'm halfway there.

With any luck, I can finish this over the weekend.

Cooleyvol · 06-26-2011, 02:44 PM

Completed fielding stats have been uploaded, Spritzy.

I'll begin work on park factors once you answer my email questions. I can finsh that up today with no problem.

tarmer · 06-26-2011, 10:55 PM

Looking forward to the testing...great work by ctorg and Mark

Cooleyvol · 06-26-2011, 11:33 PM

Quote:

Originally Posted by tarmer

Looking forward to the testing...great work by ctorg and Mark

I'm hoping you'll have something soon, Tony. Its in the hands of Spritze now. I believe he has everything completed but the fielding.csv and now has the information he asked for in order to complete that file.

Cooleyvol · 06-27-2011, 03:41 PM

Quote:

Originally Posted by Spritze

Real. Because the point is to have the PCL be on par with the Majors. Neutered to ML equivalents is possible though if more than nobody wanted/needed that.

Now who is going to do the International League?

I'm up for the International League now that the PCL is winding down. The best I can tell, the IL's days prior to becoming a true MINOR league of MLB are from 1912-1945.

Any IL experts out there that possess another point of view?

Spritze · 06-27-2011, 04:35 PM

Quote:

Originally Posted by Cooleyvol

I'm hoping you'll have something soon, Tony. Its in the hands of Spritze now. I believe he has everything completed but the fielding.csv and now has the information he asked for in order to complete that file.

After the fielding.csv is done I'll still need to add all the additional OOTP12 specific files and fields not included in the Lahman ones or on BBref or Retro-Sheet or nowheres else. That is the work part from my end.

Cooleyvol · 06-27-2011, 04:42 PM

Quote:

Originally Posted by Spritze

After the fielding.csv is done I'll still need to add all the additional OOTP12 specific files and fields not included in the Lahman ones or on BBref or Retro-Sheet or nowheres else. That is the work part from my end.

No worries, Spritze. Take your time.

No Pepper · 07-01-2011, 10:04 PM

Wow, great undertaking here! Not much database knowledge here, but I'm several OOTP versions behind. What files and fields are OOTP12 specific? If I wanted to use this in an earlier version, what would I need to do? Or is that mountain too high?

Regardless, big thank you to all involved!

Spritze · 07-02-2011, 12:22 AM

Medium-High Mountain - many new and revamped fields necessary to get the league to import in ver 12.

To use it in another version you would need to delete the extra fields from Pitching, Master and Fielding csv's that don't match the earlier versions. Things were added for later versions but nothing has been taken away.

Cooleyvol · 07-08-2011, 12:46 PM

UPDATE:

I am having to enter fielding stats for all pitchers from 1916-1940. Spritze has sent me scanned copies of this information from Spalding Guides from each year. Its just a matter of entering this data into the extensive spreadsheet that has sprung from this effort.

That is what's causing the delay. I am a good third of the way complete and hope to finish this weekend. I believe this is the last piece of the puzzle before the db can be created. I feel like, when completed, it will be a very good representation of the PCL years since there is very little information that has not been either pasted or hand entered over all this time.

Cooleyvol · 07-08-2011, 03:45 PM

1929-40 remain to input. Roughly about 4 hours of work, so this should definitely be to Spritze this weekend for final creation.

ctorg · 07-09-2011, 12:05 PM

I'm just now realizing that this thread is here.

It was sort of fun to work on for my part, in an extremely geeky way. I can't wait to see how the final product looks.

Cooleyvol · 07-12-2011, 01:03 PM

Heads up Spritzy. You will definitely get this in your inbox this afternoon late. All data is input.

Spritze · 07-12-2011, 05:46 PM

My head is up my what...............????

Cooleyvol · 07-12-2011, 06:02 PM

Quote:

Originally Posted by Spritze

My head is up my what...............????

Yeah, that too.

Check your email and/or your ftp site. You have everything.

Spritze · 07-18-2011, 04:05 PM

CooleyVol: Still patiently waiting on your stats update of updated stats that needed updating with the missing teams and years.

Ctorg's got it?

Updateificationalismness for an approx ETA would be apprecible as I'm vacating soon to "the dark continent". No Internet in Kumasi unless I create it from scratch or find an Internet Kafe' that allows "obruni Bob Marley" access.

I always introduce myself as "obruni Bob Marley", it even makes the guys in fatigues with the AK-47's smile. They all get it. The persona has gotten me through more than one checkpoint.

Cooleyvol · 07-18-2011, 04:10 PM

ctorg was going to send it to you. I just him what I sent you, so he doesnt have to compile the data, just convert it to your needed format.

When are you leaving?

Spritze · 07-19-2011, 12:23 AM

17 days

07-01-2011, 10:04 PM	#30
No Pepper All Star Starter Join Date: Jan 2003 Location: Milwaukee, WI Posts: 1,570	Wow, great undertaking here! Not much database knowledge here, but I'm several OOTP versions behind. What files and fields are OOTP12 specific? If I wanted to use this in an earlier version, what would I need to do? Or is that mountain too high? Regardless, big thank you to all involved! __________________ Uniforms compatible with OOTP23/24 Historical Major League Baseball 1901-current Historical Major League Baseball 1871-1900 Historical Federal League Historical Negro Leagues

07-08-2011, 12:46 PM	#32
Cooleyvol Hall Of Famer Join Date: Dec 2001 Location: Union City, TN Posts: 6,383	UPDATE: I am having to enter fielding stats for all pitchers from 1916-1940. Spritze has sent me scanned copies of this information from Spalding Guides from each year. Its just a matter of entering this data into the extensive spreadsheet that has sprung from this effort. That is what's causing the delay. I am a good third of the way complete and hope to finish this weekend. I believe this is the last piece of the puzzle before the db can be created. I feel like, when completed, it will be a very good representation of the PCL years since there is very little information that has not been either pasted or hand entered over all this time. Last edited by Cooleyvol; 07-08-2011 at 12:48 PM.

07-09-2011, 12:05 PM	#34
ctorg Global Moderator Join Date: Nov 2002 Location: Queens, NY Posts: 9,848	I'm just now realizing that this thread is here. It was sort of fun to work on for my part, in an extremely geeky way. I can't wait to see how the final product looks. __________________ My music "When the trees blow back and forth, that's what makes the wind." - Steven Wright Fjord emena pancreas thorax fornicate marmalade morpheme proteolysis smaxa cabana offal srue vitriol grope hallelujah lentils

07-12-2011, 01:03 PM	#35
Cooleyvol Hall Of Famer Join Date: Dec 2001 Location: Union City, TN Posts: 6,383	Heads up Spritzy. You will definitely get this in your inbox this afternoon late. All data is input. Last edited by Cooleyvol; 07-12-2011 at 02:21 PM.

06-24-2011, 08:23 PM	#21
Cooleyvol Hall Of Famer Join Date: Dec 2001 Location: Union City, TN Posts: 6,383	Seriously, the fielding stats are not on BBRef prior to about 1925 or so. Therefore, they're having to be hand input from Spaulding guides from 1903-1924 or so. A lot of work, but I want as much information driving this database as possible. This is the last true grouping of tedious work and I would think this thing will be as statistically accurate as it possibly can be, given the years we are dealing with.

06-24-2011, 08:43 PM	#22
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	Well better you than me as far as tedium goes. FYI: Tedium goes nearly 330 miles before it gets bored and stops in Far, TN.

06-25-2011, 11:54 AM	#23
Cooleyvol Hall Of Famer Join Date: Dec 2001 Location: Union City, TN Posts: 6,383	Fielding stats are completed up through 1909. After further review, it seems I only will need to go through 1918 with fielding input, so I'm halfway there. With any luck, I can finish this over the weekend.

06-26-2011, 02:44 PM	#24
Cooleyvol Hall Of Famer Join Date: Dec 2001 Location: Union City, TN Posts: 6,383	Completed fielding stats have been uploaded, Spritzy. I'll begin work on park factors once you answer my email questions. I can finsh that up today with no problem.

06-26-2011, 10:55 PM	#25
tarmer All Star Reserve Join Date: May 2005 Location: Out in Leftfield Posts: 618	Looking forward to the testing...great work by ctorg and Mark

07-02-2011, 12:22 AM	#31
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	Medium-High Mountain - many new and revamped fields necessary to get the league to import in ver 12. To use it in another version you would need to delete the extra fields from Pitching, Master and Fielding csv's that don't match the earlier versions. Things were added for later versions but nothing has been taken away.

07-08-2011, 03:45 PM	#33
Cooleyvol Hall Of Famer Join Date: Dec 2001 Location: Union City, TN Posts: 6,383	1929-40 remain to input. Roughly about 4 hours of work, so this should definitely be to Spritze this weekend for final creation.

07-12-2011, 05:46 PM	#36
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	My head is up my what...............????

07-18-2011, 04:05 PM	#38
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	CooleyVol: Still patiently waiting on your stats update of updated stats that needed updating with the missing teams and years. Ctorg's got it? Updateificationalismness for an approx ETA would be apprecible as I'm vacating soon to "the dark continent". No Internet in Kumasi unless I create it from scratch or find an Internet Kafe' that allows "obruni Bob Marley" access. I always introduce myself as "obruni Bob Marley", it even makes the guys in fatigues with the AK-47's smile. They all get it. The persona has gotten me through more than one checkpoint.

07-18-2011, 04:10 PM	#39
Cooleyvol Hall Of Famer Join Date: Dec 2001 Location: Union City, TN Posts: 6,383	ctorg was going to send it to you. I just him what I sent you, so he doesnt have to compile the data, just convert it to your needed format. When are you leaving?

07-19-2011, 12:23 AM	#40
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	17 days