|
||||
| ||||
|
|||||||
| OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome |
![]() |
|
|
Thread Tools |
|
|
#1 |
|
Hall Of Famer
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,383
|
International League db
Now that the PCL database construction is winding down, I am going to turn my attention towards gathering data for an International League equivalent.
From my reading, the IL's time as a NON minor league to MLB is from 1912-1945. If anyone has different ideas, please let me know. I am going to begin putting together data from BBRef on these years first. Then fielding stats will have to be added from Spaulding's guides most likely (as the PCL required). Is there interest in such a db being added to what available for OOTP? |
|
|
|
|
|
#2 |
|
All Star Reserve
Join Date: Apr 2009
Posts: 648
|
I think these minor league databases are going to outstanding additions to the wide world of OOTP mods. So much thanks to those of you who are working on them.
|
|
|
|
|
|
#3 |
|
Minors (Triple A)
Join Date: Jan 2006
Posts: 281
|
1945 is probably about as good a choice as any one year could be for the transition to teams virtually all operating purely as farm clubs for major league teams, but I think you could push your start date forward to include the Eastern League before 1912, if you wanted. The 1911 EL circuit is identical to the next season's IL. It's simply the same league operating under a different name. I wonder why they changed, actually.
Bb-ref doesn't see it this way, but I believe most authorities consider the IL to go back all the way to 1885, with occasional name changes along the way during the first thirty years. I think there probably wasn't really organizational continuity all the way back, but there certainly was for at least a few years going back past 1912. |
|
|
|
|
|
#4 |
|
All Star Starter
Join Date: Jan 2003
Location: Milwaukee, WI
Posts: 1,570
|
Cooley, are these databases going to conflict with the ML databases in the sense that you'll get duplicates on import? Meaning, Lefty Grove of the famous Baltimore Orioles first imports in 1920 with the IL database and when 1925 rolls around, he'll get imported again with the ML database. What's your vision in how this will be used within the game?
__________________
Uniforms compatible with OOTP23/24 Historical Major League Baseball 1901-current Historical Major League Baseball 1871-1900 Historical Federal League Historical Negro Leagues |
|
|
|
|
|
#5 | |
|
Hall Of Famer
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,383
|
Quote:
Spritze could give the definitive answer, but since he's putting the actual data into db form, I'll assume all will work fine. |
|
|
|
|
|
|
#6 |
|
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
|
The database playerids that are used in the PCL and International databases are the same as the Lahman Player IDs so duplication can be averted depending on the vast number of things it depends on. Like..........
IF the PCL and/or INT db's are incorporated with the Lahman Db, there will be no duplicates. IF the PCL and INT db's are used as seperate stand-alone db's duplication will ensue. A total of 3 iterations (max) of each player is then possible. |
|
|
|
|
|
#7 |
|
Hall Of Famer
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,383
|
I believe that someone simming only the IL or PCL using these as standalones would begin getting fictional players in '58 for the PCL and 46 for the IL. Correct Spritze?
|
|
|
|
|
|
#8 |
|
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
|
Yes
|
|
|
|
![]() |
| Bookmarks |
|
|