-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

KJOK,

>   File        : / Team-Franchises Data/Franchise Summary.xls
>   Uploaded by : kjokbaseball <kjokbaseball@...>
>   Description : Summary of Franchises File

Do you have a Leagues.[xls|csv] file that corresponds to the LG field in
this table?

- --
Michael Westbay
Writer/System Administrator
http://JapaneseBaseball.com
Public Key:  http://www.japanesebaseball.com/keys/westbaystars.gpgkey
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (Darwin)

iD8DBQE/887KEGkvdz3fJlcRAh5QAJ4uOGBw8m+IveM72Elz3DlnyFOjQQCg076j
xMLC3D7dKkDdEYWQXdb1GvM=
=45xD
-----END PGP SIGNATURE-----

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

>   File        : / Team-Franchises Data/Team Franchise Nickname Park
History.zip
>   Uploaded by : kjokbaseball <kjokbaseball@...>
>   Description : Year by Year Franchise Team Info

Regarding the above spreadsheet, which does PARK_ID point to:

   1. RetroParkID
   2. KJOKParkID

as per ParksXREF.txt under Team-Franchises Data?

Furthermore, can said Parks data be made available in SQL and/or CSV
format?  I can't access the Access files under the "Park Factors" directory.

- --
Michael Westbay
Writer/System Administrator
http://JapaneseBaseball.com
Public Key:  http://www.japanesebaseball.com/keys/westbaystars.gpgkey
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (Darwin)

iD8DBQE/89r3EGkvdz3fJlcRAgHsAJ0ZRj/nSc2GR8Bk9n2FC9U9Y60++ACgiWKb
TnA2a77GpBluuX8nl0v94Ps=
=r39w
-----END PGP SIGNATURE-----

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

KJOK,

>   File        : / Team-Franchises Data/Franchise Summary.xls
>   Uploaded by : kjokbaseball <kjokbaseball@...>
>   Description : Summary of Franchises File

Do you have a Leagues.[xls|csv] file that corresponds to the LG field in
this table?

- --
Michael Westbay
Writer/System Administrator
http://JapaneseBaseball.com
Public Key:  http://www.japanesebaseball.com/keys/westbaystars.gpgkey
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (Darwin)

iD8DBQE/887KEGkvdz3fJlcRAh5QAJ4uOGBw8m+IveM72Elz3DlnyFOjQQCg076j
xMLC3D7dKkDdEYWQXdb1GvM=
=45xD
-----END PGP SIGNATURE-----


http://www.baseball-databank.org/

---

Yahoo! Groups Links

• To visit your group on the web, go to:
  http://groups.yahoo.com/group/baseball-databank/
   
• To unsubscribe from this group, send an email to:
  baseball-databank-unsubscribe@yahoogroups.com
   
• Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the baseball-databank
group.

   File        : / Team-Franchises Data/Leagues_Table.xls
   Uploaded by : kjokbaseball <kjokbaseball@...>
   Description : Leagues (Major) Master Table

You can access this file at the URL

http://groups.yahoo.com/group/baseball-databank/files/%20Team-Franchises%20Data/\
Leagues_Table.xls

To learn more about file sharing for your group, please visit

http://help.yahoo.com/help/us/groups/files

Regards,

kjokbaseball <kjokbaseball@...>

Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the baseball-databank
group.

   File        : / Team-Franchises Data/Organizations.csv
   Uploaded by : westbaystars <westbaystars@...>
   Description : Recursive heirarchy of league organization information.

You can access this file at the URL

http://groups.yahoo.com/group/baseball-databank/files/%20Team-Franchises%20Data/\
Organizations.csv

To learn more about file sharing for your group, please visit

http://help.yahoo.com/help/us/groups/files

Regards,

westbaystars <westbaystars@...>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

KJOK wrote:

> Funny you should ask that, as I'm actually working on a "super"
> league table while watching football today.  This new table will
> include ALL leagues, both major and minor, so that it can be used
> with minor legue data, or transactions data, or Japanese League
> data, etc.

To that end, I've generated such a table from the
Team_Table_CMS_Version.xls file on the SABR research site.  The method
by which I generated the leagues was to extract the "class" field from
the table (MAJ, MIN, MINA, etc.) as the highest level.  Then all "Teams"
with "LeagueID" of "AA" are the league names, so I extracted them with
references to the "class"es inserted before as their parents.  The plan
is to then insert divisions (AL East, NL Central, etc.) under those
which the team will reference.  Because the table is recursive, it can
be adopted for many different league (organization) structures, such as:

   MLB             NPB           KBO
    + AL            + CL          + Teams
    |  + East       |  + Teams
    |      + Teams  + PL
    |  + Central       + Teams
    |      + Teams
    |  + West
    |      + Teams
    + NL
       + East
           + Teams
       + Central
           + Teams
       + West
           + Teams

The table definition is:

   CREATE TABLE Organizations (
     organizationID smallint NOT NULL auto_increment,
     organizationName varchar(50),
     locationID int NOT NULL default 1,
     startYear smallint default null,
     endYear smallint default null,
     comments varchar(255) default null,
     parentOrganizationID smallint default null,
     updated timestamp NOT NULL,
     PRIMARY KEY (organizationID)
   );

"locationID" points to a Locations table.

Does this help?  Or are you building it strictly 2-D?

- --
Michael Westbay
Writer/System Administrator
http://JapaneseBaseball.com
Public Key:  http://www.japanesebaseball.com/keys/westbaystars.gpgkey
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (Darwin)

iD8DBQE/9PXqEGkvdz3fJlcRAkajAJ4queeJQ/Aq83boQjFFLfSIq6geQQCfWhvd
ihPHD1JTMqSUnhL94nhwV8s=
=kJHe
-----END PGP SIGNATURE-----

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I wrote:

> To that end, I've generated such a table from the
> Team_Table_CMS_Version.xls file on the SABR research site.

Please see this message for the uploaded data file:

   http://groups.yahoo.com/group/baseball-databank/message/1903

- --
Michael Westbay
Writer/System Administrator
http://JapaneseBaseball.com
Public Key:  http://www.japanesebaseball.com/keys/westbaystars.gpgkey
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (Darwin)

iD8DBQE/9PZ0EGkvdz3fJlcRAj8FAJ9laNHRZ9B8hmNlRlpweIdLH3iLBACfX0Ut
5EApYS2Heyu9LzlI6/gI6+s=
=nMRq
-----END PGP SIGNATURE-----

Michael:

Actually, what you've done is great!  I was basically doing the same
thing, only a little more manually, with the Classification Codes in
a separate table, and using CODE + CLASS as my key (AA + MAJ for the
American Association 1880's).  I do think that we'll need the
abbreviations (AA for American Association, for example) to be able
to link to Transactions and other databases....

THANKS,
Kevin

--- In baseball-databank@yahoogroups.com, Michael Westbay
<westbaystars@j...> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> KJOK wrote:
>
> > Funny you should ask that, as I'm actually working on a "super"
> > league table while watching football today.  This new table will
> > include ALL leagues, both major and minor, so that it can be used
> > with minor legue data, or transactions data, or Japanese League
> > data, etc.
>
> To that end, I've generated such a table from the
> Team_Table_CMS_Version.xls file on the SABR research site.  The
method
> by which I generated the leagues was to extract the "class" field
from
> the table (MAJ, MIN, MINA, etc.) as the highest level.  Then
all "Teams"
> with "LeagueID" of "AA" are the league names, so I extracted them
with
> references to the "class"es inserted before as their parents.  The
plan
> is to then insert divisions (AL East, NL Central, etc.) under those
> which the team will reference.  Because the table is recursive, it
can
> be adopted for many different league (organization) structures,
such as:
>
>   MLB             NPB           KBO
>    + AL            + CL          + Teams
>    |  + East       |  + Teams
>    |      + Teams  + PL
>    |  + Central       + Teams
>    |      + Teams
>    |  + West
>    |      + Teams
>    + NL
>       + East
>           + Teams
>       + Central
>           + Teams
>       + West
>           + Teams
>
> The table definition is:
>
>   CREATE TABLE Organizations (
>     organizationID smallint NOT NULL auto_increment,
>     organizationName varchar(50),
>     locationID int NOT NULL default 1,
>     startYear smallint default null,
>     endYear smallint default null,
>     comments varchar(255) default null,
>     parentOrganizationID smallint default null,
>     updated timestamp NOT NULL,
>     PRIMARY KEY (organizationID)
>   );
>
> "locationID" points to a Locations table.
>
> Does this help?  Or are you building it strictly 2-D?
>
> - --
> Michael Westbay
> Writer/System Administrator
> http://JapaneseBaseball.com
> Public Key:
http://www.japanesebaseball.com/keys/westbaystars.gpgkey
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.2.1 (Darwin)
>
> iD8DBQE/9PXqEGkvdz3fJlcRAkajAJ4queeJQ/Aq83boQjFFLfSIq6geQQCfWhvd
> ihPHD1JTMqSUnhL94nhwV8s=
> =kJHe
> -----END PGP SIGNATURE-----

--- In baseball-databank@yahoogroups.com, Michael Westbay
<westbaystars@j...> wrote:
.....
> >   Description : Year by Year Franchise Team Info
>
> Regarding the above spreadsheet, which does PARK_ID point to:
>
>   1. RetroParkID
>   2. KJOKParkID
>
> as per ParksXREF.txt under Team-Franchises Data?
>
> Furthermore, can said Parks data be made available in SQL and/or CSV
> format?  I can't access the Access files under the "Park Factors"
directory.
....

The spreadsheet refers to the "KJOKParkID's" which are now 99.9% the
same as the RetroParkID's, the only differences being parks such as
Fenway and Yankee Stadium that had "major" renovations have 2 KJOK
Park ID's (A and B suffixes) while Retrosheet just uses one ID for
the history of these parks.

I can make all the tables available in CSV tomorrow.

THANKS,
Kevin

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

KJOK wrote:

> Actually, what you've done is great!  I was basically doing the same
> thing, only a little more manually, with the Classification Codes in
> a separate table, and using CODE + CLASS as my key (AA + MAJ for the
> American Association 1880's).

It's part of the effort to normalize the database.  One key rule is to
have only ONE primary key per table.  (Multiple unique fields are OK.)

> I do think that we'll need the
> abbreviations (AA for American Association, for example) to be able
> to link to Transactions and other databases....

For linking to current data, yes.  There's a bridge table to map from
integer IDs to the two-character IDs of old to aid importing/exporting
with the older style distributions.

- --
Michael Westbay
Writer/System Administrator
http://JapaneseBaseball.com
Public Key:  http://www.japanesebaseball.com/keys/westbaystars.gpgkey
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (Darwin)

iD8DBQE/9RWjEGkvdz3fJlcRAnquAKCgU1XcbU8W4JCa76GsEGlwJQDeQACgpiSs
l7STamM8Ix8lL4NsHMV7t7M=
=7/MQ
-----END PGP SIGNATURE-----

Hi folks!

In working with the Design group on the normalization, three data errors
have cropped up.  These aren't incorrect numbers, but, rather, incorrect
data types (that is, spaces where a NULL should be, stuff like that).  They
are:

In MASTER
12911    Jim       Sheehan  deathMonth should be 12, deathYear should be
2003 (are reversed in DB).

In PITCHINGPOST
contrjo01, 2003, WS, NYA, AL.  Col030 (GIDP) s/b 0 or NULL.

In FIELDING
clarkje02, 2003, 1, 2B.  Col015 (ZR) s/b 0 or NULL.

-Daniel

______________________________________________________________

Daniel Levine
http://www.DMLCo.com            713.861.6557
DMLCo: solving the challenges where people and technology meet
*** Now featuring the DMLContent Management System ***

--- In baseball-databank@yahoogroups.com, Daniel Levine <Daniel@d...>
wrote:
........
>
> In PITCHINGPOST
> contrjo01, 2003, WS, NYA, AL.  Col030 (GIDP) s/b 0 or NULL.
>

Don't know why, as the pitchingpostalt.csv file has NULL, but it
should definitely be NULL.

> In FIELDING
> clarkje02, 2003, 1, 2B.  Col015 (ZR) s/b 0 or NULL.
>
I believe this value should also be NULL, at least until Zone Ratings
are entered into the database.

THANKS,
KJOK

Thanks for pointing these out Mitchell.  I'll add them to the list of
corrections to make.

The pitcher's batting entries are handled poorly.  I believe what has
happened in various places and various cases is that the pitcher was
credited with a game batting when they appeared in the batting lineup
(even if they didn't bat) Think Billy Wagner.  In the AL, the pitchers
were DH'ed for (except in various cases), like when Jimy Williams would
lose his DH and then the pitcher was credited with a batting game.

Sean

Mitchell Dickerman wrote:
> Here's the errors I've spotted in the latest release. I presume the
> previously reported errors are problems in the official records and
> we'll have to wait for future resolutions.
>
> BATTING: 8 entries where G=0 (all AL pitchers from 1997 & 1998)
>
> BATTING: murphbo01, 1890 - 1 HR, 0 RBI - Retrosheet has the same
> data, though.
>
> FIELDING: willimi03, 1997 - 1 E - should be 0 E
>
> FIELDINGOF: hoganed02 entries listed under hoganed01
>
> PITCHING: Many records have .000 BAOPP and H>0. Almost all of these
> are from 1998-2002, though 18 are from before then.
>
> PITCHING: sharrja01, 1891, 1, NY1, NL - G=10, W=5, L=5, SV=1
> PITCHING: whitedo01, 1902, 1, PHI, NL - G=36, W=16, L=20, SV=1
> (Retrosheet has these numbers as well) [Both previously reported]
>
> PITCHING: Something doesn't add up [previously reported]
> lacke01 ,  1890, 1, PH4, AA - IP=2, H=1, BFP=3
> mcmahsa01, 1890, 1, PH4, AA - IP=410, H=414,BFP=133
> osterfr01, 1943, 2, BRO, NL - IP=27.1, H=21, BFP=12
> pricebi01, 1890, 1, PH4, AA - IP=9, H=6, BFP=7
> pruiete01, 1908, 1, BOS, AL - IP=58.2, H=55, BFP=46
> richile01, 1907, 1, PHI, NL - IP=117, H=88, BFP=83
>
> PITCHING: fournja01, 1922, 1, SLN, NL - 0 BFP - Retrosheet also says
> 0 BFP w/ 1 IP. [Previously reported]
>
> PITCHING: Still have 50 entries with GS+GF>G, though only 4 of them
> are off by more than one. All double-switches where the pitcher moves
> into the field and then comes back into the game, I presume.
> [Previously reported]
>
> PITCHING: 4 entries where W=0 and SHO=1 - not a problem; these are
> all 0-0 ties.
>
> PITCHING: SV>GF - according to Retrosheet data, these should all be
> flip-flopped, SV->GF, GF->SV
> pennohe01, 1929, 1, NYA, AL - SV=2, GF=1
> erricdi01, 1940, 1, BSN, NL - SV=4, GF=3
> schmijo01, 1953, 1, NYA, AL - SV=2, GF=1
> spahnwa01, 1954, 1, ML1, NL - SV=3, GF=2
>
> Hope that helps,
> Mitch
>
>
>
> http://www.baseball-databank.org/
>
> To unsubscribe from this group, send an email to:
> baseball-databank-unsubscribe@yahoogroups.com
>
>
>
>
> *Yahoo! Groups Sponsor*
> ADVERTISEMENT
>
<http://rd.yahoo.com/SIG=12cvpugrr/M=266841.4316200.5507732.1261774/D=egroupweb/\
S=1705066645:HM/EXP=1072813912/A=1911858/R=0/*http://www.lifescapeinc.com/picasa\
/landing.php?capid=222&caId=1987>
>
>
> ------------------------------------------------------------------------
> *Yahoo! Groups Links*
>
>     * To visit your group on the web, go to:
>       http://groups.yahoo.com/group/baseball-databank/
>
>     * To unsubscribe from this group, send an email to:
>       baseball-databank-unsubscribe@yahoogroups.com
>      
<mailto:baseball-databank-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
>     * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
>       Service <http://docs.yahoo.com/info/terms/>.
>
>


--
Sincerely,
Sean Forman

Baseball Stats!   http://www.Baseball-Reference.com/
Baseball Analysis!    http://www.BaseballPrimer.com/

tjruane wrote:
> I noticed that SH and SF allowed data seems to be missing from the
> pitching tables.  Was this omission intentional (or did I misread
> the documentation)?  While not exactly or earth-shaking importance,
> this data has been routinely included in the statistical data
> published in the various guides and I think we would want to include
> fields for it in the pitching tables.  Other fields I'd find room
> for include doubles and triples allowed.
>
> Tom Ruane


I don't believe it was intentional.  I don't believe the data is known,
and the columns were added with the intention that it would be added in
the future.

--
Sincerely,
Sean Forman

Baseball Stats!   http://www.Baseball-Reference.com/
Baseball Analysis!    http://www.BaseballPrimer.com/

Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the baseball-databank
group.

   File        : / Park Factors/Parkfactors Files.zip
   Uploaded by : kjokbaseball <kjokbaseball@...>
   Description : Parks Database Files in csv Format

You can access this file at the URL

http://groups.yahoo.com/group/baseball-databank/files/%20Park%20Factors/Parkfact\
ors%20Files.zip

To learn more about file sharing for your group, please visit

http://help.yahoo.com/help/us/groups/files

Regards,

kjokbaseball <kjokbaseball@...>

Sean Forman wrote:

> I don't believe it was intentional.  I don't believe the data is
> known, and the columns were added with the intention that it would
> be added in the future.

That's odd.  My database has this information and I believe I got it
originally from the 1994 TB CD, which I think was also the source
for Sean's data.

Also, in looking at the documentation on the web-site, I didn't see
where columns had been added for this data.  Maybe the documentation
is back-level (or perhaps I simply mis-read it).

Tom Ruane

Sean Forman wrote:

> The pitcher's batting entries are handled poorly.  I believe what
> has happened in various places and various cases is that the
> pitcher was credited with a game batting when they appeared in
> the batting lineup (even if they didn't bat) Think Billy Wagner.
> In the AL, the pitchers were DH'ed for (except in various cases),
> like when Jimy Williams would lose his DH and then the pitcher
> was credited with a batting game.

Again, perhaps I'm misunderstanding something, but if this is how
batting games are handled, how do we tell how many games a pitcher
appeared in?  Let's say a pitcher pitched only in 60 games (8 of
which he appeared in the lineup as a batter), pinch-ran in 3
games, and pinch-ran AND pitched in another 3.  It is my
understanding that:

his pitching games would be 63
his batting games would be 14
his pinch-ran games (if this exists) would be 6

Where from this information can we deduce that he appeared in a
total of 66 games?

In my database, I have included a batting record for ALL players,
even pitchers who never batting in the AL since 1973.  The games
played field in these records always contains the total number of
games played by the player.

However you decide to handle this, it should be at least that easy
to determine the total number of games played by a player.

In apologize in advance if I have simply misunderstood the design
of the database or the meanings of these fields.

Tom Ruane

> Again, perhaps I'm misunderstanding something, but if this is how
> batting games are handled, how do we tell how many games a pitcher
> appeared in?  Let's say a pitcher pitched only in 60 games (8 of
> which he appeared in the lineup as a batter), pinch-ran in 3
> games, and pinch-ran AND pitched in another 3.  It is my
> understanding that:
>
> his pitching games would be 63
> his batting games would be 14
> his pinch-ran games (if this exists) would be 6
>
> Where from this information can we deduce that he appeared in a
> total of 66 games?
>
> In my database, I have included a batting record for ALL players,
> even pitchers who never batting in the AL since 1973.  The games
> played field in these records always contains the total number of
> games played by the player.
>
> However you decide to handle this, it should be at least that easy
> to determine the total number of games played by a player.

> Tom Ruane

I was mainly referring to the reason that the pitchers had low numbers
of games appeared in the batting table.  We don't at the moment have a
policy about how to handle this.  Clearly it would be best to have table
where the games played total equals the number of games the player
played in.  Likewise, it would be nice to have a correct total of PA's,
PH, PR, etc. appearances.

  From an idealistic standpoint, we should ask if it does make sense for
a player to have a batting entry if they never appeared in a lineup.
We've made previous decisions to exclude the Chester Trail's of the world.

--
Sincerely,
Sean Forman

Baseball Stats!   http://www.Baseball-Reference.com/
Baseball Analysis!    http://www.BaseballPrimer.com/

tjruane wrote:
> Sean Forman wrote:
>
>  > I don't believe it was intentional.  I don't believe the data is
>  > known, and the columns were added with the intention that it would
>  > be added in the future.
>
> That's odd.  My database has this information and I believe I got it
> originally from the 1994 TB CD, which I think was also the source
> for Sean's data.
>
> Also, in looking at the documentation on the web-site, I didn't see
> where columns had been added for this data.  Maybe the documentation
> is back-level (or perhaps I simply mis-read it).
>
> Tom Ruane


Ahh, I didn't think we had SH and SF columns, but I was too lazy to
check and took Tom's note to say they were in there.  We have never had
these columns, but would naturally add them if someone were offering to
provide the data just as we would with any other dataset.

--
Sincerely,
Sean Forman

Baseball Stats!   http://www.Baseball-Reference.com/
Baseball Analysis!    http://www.BaseballPrimer.com/

Tom,

You are correct that the current design does not
support the "games played" for a single player, but
rather by his "role" or "position".

The new design will handle this (though I don't know
if the data available will support the design).

Tom

__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree

I apologize that I didn't think this through when Michael first
questioned about League tables.  Upon further review, since
the "main" data level of baseball-databank is league/year, the "main"
league table should also be a league/year table.  This table could
then be used with the major league data, minor league data, Japanese
league data, etc.  Then, if desired, it can be summarized up to
create a league summary table.

I will post a "sample" table of what I think the League/Year table
should look like.

THANKS,
KJOK

--- In baseball-databank@yahoogroups.com, "KJOK" <kjokbaseball@y...>
wrote:
> Michael:
>
> Actually, what you've done is great!  I was basically doing the
same
> thing, only a little more manually, with the Classification Codes
in
> a separate table, and using CODE + CLASS as my key (AA + MAJ for
the
> American Association 1880's).  I do think that we'll need the
> abbreviations (AA for American Association, for example) to be able
> to link to Transactions and other databases....
>
> THANKS,
> Kevin
>
> --- In baseball-databank@yahoogroups.com, Michael Westbay
> <westbaystars@j...> wrote:
> > -----BEGIN PGP SIGNED MESSAGE-----
> > Hash: SHA1
> >
> > KJOK wrote:
> >
> > > Funny you should ask that, as I'm actually working on a "super"
> > > league table while watching football today.  This new table will
> > > include ALL leagues, both major and minor, so that it can be
used
> > > with minor legue data, or transactions data, or Japanese League
> > > data, etc.
> >
> > To that end, I've generated such a table from the
> > Team_Table_CMS_Version.xls file on the SABR research site.  The
> method
> > by which I generated the leagues was to extract the "class" field
> from
> > the table (MAJ, MIN, MINA, etc.) as the highest level.  Then
> all "Teams"
> > with "LeagueID" of "AA" are the league names, so I extracted them
> with
> > references to the "class"es inserted before as their parents.
The
> plan
> > is to then insert divisions (AL East, NL Central, etc.) under
those
> > which the team will reference.  Because the table is recursive,
it
> can
> > be adopted for many different league (organization) structures,
> such as:
> >
> >   MLB             NPB           KBO
> >    + AL            + CL          + Teams
> >    |  + East       |  + Teams
> >    |      + Teams  + PL
> >    |  + Central       + Teams
> >    |      + Teams
> >    |  + West
> >    |      + Teams
> >    + NL
> >       + East
> >           + Teams
> >       + Central
> >           + Teams
> >       + West
> >           + Teams
> >
> > The table definition is:
> >
> >   CREATE TABLE Organizations (
> >     organizationID smallint NOT NULL auto_increment,
> >     organizationName varchar(50),
> >     locationID int NOT NULL default 1,
> >     startYear smallint default null,
> >     endYear smallint default null,
> >     comments varchar(255) default null,
> >     parentOrganizationID smallint default null,
> >     updated timestamp NOT NULL,
> >     PRIMARY KEY (organizationID)
> >   );
> >
> > "locationID" points to a Locations table.
> >
> > Does this help?  Or are you building it strictly 2-D?
> >
> > - --
> > Michael Westbay
> > Writer/System Administrator
> > http://JapaneseBaseball.com
> > Public Key:
> http://www.japanesebaseball.com/keys/westbaystars.gpgkey
> > -----BEGIN PGP SIGNATURE-----
> > Version: GnuPG v1.2.1 (Darwin)
> >
> > iD8DBQE/9PXqEGkvdz3fJlcRAkajAJ4queeJQ/Aq83boQjFFLfSIq6geQQCfWhvd
> > ihPHD1JTMqSUnhL94nhwV8s=
> > =kJHe
> > -----END PGP SIGNATURE-----

Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the baseball-databank
group.

   File        : / Team-Franchises Data/League Detail Table Sample.xls
   Uploaded by : kjokbaseball <kjokbaseball@...>
   Description : Sample League Detail Table

You can access this file at the URL

http://groups.yahoo.com/group/baseball-databank/files/%20Team-Franchises%20Data/\
League%20Detail%20Table%20Sample.xls

To learn more about file sharing for your group, please visit

http://help.yahoo.com/help/us/groups/files

Regards,

kjokbaseball <kjokbaseball@...>

KJOK/Paul,

One thing that has come up is the association of the
minor league teams to the MLB teams, with respect to a
Franchise.

Suppose that you have a minor league team that is
owned by NYY and then sold to BOS.  All the players
are the same, the owners of the minor league team is
the same, just the "affiliation rights" (or whatever
they would be called) are sold.  Surely the minor
league team is not part of a new franchise, right?

In fact, the idea of a minor league team belonging to
a "franchise" might not even fit in the definition of
a franchise.  The franchise is really to set a
"continuity" among various incarnations of MLB teams
(whether that continuity is based on ownership,
management, players, fans, location, or some
combination of the above).

Therefore, I would see the case that we'd have "Minor
League Franchise IDs" that they themselves also have
their own continuity.  The mapping of a particular
minor league team to a particular major league team
would then be handled by a cross-reference table.

In the future, I can see such a case where the Yanks
and the Seibu Lions have a "working affiliation" or
some such.

Do you agree that Franchise, aka Continuity, ids
should only exist at the one league level?  That is, a
franchise can have one and only one team in any given
year.  You can have a Franchise ID that spans leagues,
but not in the same year (say like a team going from
the AA to the AL).

Tom










__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree

KJOK/Paul,

One thing that has come up is the association of the
minor league teams to the MLB teams, with respect to a
Franchise.

Suppose that you have a minor league team that is
owned by NYY and then sold to BOS.  All the players
are the same, the owners of the minor league team is
the same, just the "affiliation rights" (or whatever
they would be called) are sold.  Surely the minor
league team is not part of a new franchise, right?

In fact, the idea of a minor league team belonging to
a "franchise" might not even fit in the definition of
a franchise.  The franchise is really to set a
"continuity" among various incarnations of MLB teams
(whether that continuity is based on ownership,
management, players, fans, location, or some
combination of the above).

Therefore, I would see the case that we'd have "Minor
League Franchise IDs" that they themselves also have
their own continuity.  The mapping of a particular
minor league team to a particular major league team
would then be handled by a cross-reference table.

In the future, I can see such a case where the Yanks
and the Seibu Lions have a "working affiliation" or
some such.

Do you agree that Franchise, aka Continuity, ids
should only exist at the one league level?  That is, a
franchise can have one and only one team in any given
year.  You can have a Franchise ID that spans leagues,
but not in the same year (say like a team going from
the AA to the AL).

Tom










__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree


http://www.baseball-databank.org/

---

Yahoo! Groups Links

• To visit your group on the web, go to:
  http://groups.yahoo.com/group/baseball-databank/
   
• To unsubscribe from this group, send an email to:
  baseball-databank-unsubscribe@yahoogroups.com
   
• Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

It's on my to do list, but I have too many other projects going right now to get to it immediately, so if someone has an interest in the minor leagues, this would be a great project to tackle.

THANKS,

KJOK

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

KJOK wrote:

> Funny you should ask that, as I'm actually working on a "super"
> league table while watching football today.  This new table will
> include ALL leagues, both major and minor, so that it can be used
> with minor legue data, or transactions data, or Japanese League
> data, etc.

To that end, I've generated such a table from the
Team_Table_CMS_Version.xls file on the SABR research site.  The method
by which I generated the leagues was to extract the "class" field from
the table (MAJ, MIN, MINA, etc.) as the highest level.  Then all "Teams"
with "LeagueID" of "AA" are the league names, so I extracted them with
references to the "class"es inserted before as their parents.  The plan
is to then insert divisions (AL East, NL Central, etc.) under those
which the team will reference.  Because the table is recursive, it can
be adopted for many different league (organization) structures, such as:

  MLB             NPB           KBO
   + AL            + CL          + Teams
   |  + East       |  + Teams
   |      + Teams  + PL
   |  + Central       + Teams
   |      + Teams
   |  + West
   |      + Teams
   + NL
      + East
          + Teams
      + Central
          + Teams
      + West
          + Teams

The table definition is:

  CREATE TABLE Organizations (
    organizationID smallint NOT NULL auto_increment,
    organizationName varchar(50),
    locationID int NOT NULL default 1,
    startYear smallint default null,
    endYear smallint default null,
    comments varchar(255) default null,
    parentOrganizationID smallint default null,
    updated timestamp NOT NULL,
    PRIMARY KEY (organizationID)
  );

"locationID" points to a Locations table.

Does this help?  Or are you building it strictly 2-D?

- --
Michael Westbay
Writer/System Administrator
http://JapaneseBaseball.com
Public Key:  http://www.japanesebaseball.com/keys/westbaystars.gpgkey
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (Darwin)

iD8DBQE/9PXqEGkvdz3fJlcRAkajAJ4queeJQ/Aq83boQjFFLfSIq6geQQCfWhvd
ihPHD1JTMqSUnhL94nhwV8s=
=kJHe
-----END PGP SIGNATURE-----


http://www.baseball-databank.org/

---

Yahoo! Groups Links

• To visit your group on the web, go to:
  http://groups.yahoo.com/group/baseball-databank/
   
• To unsubscribe from this group, send an email to:
  baseball-databank-unsubscribe@yahoogroups.com
   
• Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the baseball-databank
group.

   File        : /fielders9902.zip
   Uploaded by : tangotiger <tmasc@...>
   Description : Fielding data, 1999-2002.

You can access this file at the URL

http://groups.yahoo.com/group/baseball-databank/files/fielders9902.zip

To learn more about file sharing for your group, please visit

http://help.yahoo.com/help/us/groups/files

Regards,

tangotiger <tmasc@...>

Fielding data has been uploaded, but not verified.  It's been broken
down by various keys.  3 separate files.  There's a readme file as
well.

Tom

Sean Forman wrote:

> From an idealistic standpoint, we should ask if it does make sense
> for a player to have a batting entry if they never appeared in a
> lineup.  We've made previous decisions to exclude the Chester
> Trail's of the world.

I think Sean is talking about 2 entirely different situations here.
Pitchers, even if there is a DH, still appear in the lineup.  If you
looked at lineup cards, starting lineups in both Retrosheet and
Stats event files, and so on, pitchers are listed.  They do not
appear in the batting order, but they still appear in the lineup.

The choice whether or not to have a batting entry for pitchers, or
have an entirely different table to handle this situation, is a
matter of style I suppose.  I will say that my original database
design did much what you are doing now.  I only included batting
records if a pitcher appeared in the batting order at least once
and then only contained the number of games they appeared in the
batting order.  After working with these files for a few years, I
changed my design and the result is a LOT easier to work with.

In general, I would prefer to work with as few tables as possible.
Being able to answer basic and obvious questions like "how many
games did a player appear in?" without having to resort to some
other table is an enormous advantage.  You do lose one piece of
information with the new design, however, and that is: how many
times a player pitched but did not appear in the batting order.
Since this piece of information is so seldom of interest, if you
wanted to track this (and I chose not to) perhaps you could create
a separate table for it.

Chester Trail never appeared in a game so of course he should get
a batting entry.

Tom Ruane

Sean Forman wrote:

> Ahh, I didn't think we had SH and SF columns, but I was too lazy to
> check and took Tom's note to say they were in there.  We have never
> had these columns, but would naturally add them if someone were
> offering to provide the data just as we would with any other
> dataset.

I'm too busy working on the next release of the Retrosheet web-site,
transaction data and player data-base right now, but in a month or so
I would be more than happy to provide this information (as well as
any other things that Retrosheet has you are interested in (perhaps
pitcher doubles, triples allowed, stolen bases and caught stealing?
catcher wild pitches? batting reached on catcher interference?).  I
would provide something like:

id,year,team,stint,stat1,stat2,....

The IDs and team would be in Retrosheet format, but if someone is
willing to both identify the data you want and work to incorporate
what I provide into your existing tables, please let me know.

Tom Ruane

I will just say yes, yes, yes, yes, yes, please!  THANK YOU!

KJOK

tjruane <truane@...> wrote:

Sean Forman wrote:

> Ahh, I didn't think we had SH and SF columns, but I was too lazy to
> check and took Tom's note to say they were in there.  We have never
> had these columns, but would naturally add them if someone were
> offering to provide the data just as we would with any other
> dataset.

I'm too busy working on the next release of the Retrosheet web-site,
transaction data and player data-base right now, but in a month or so
I would be more than happy to provide this information (as well as
any other things that Retrosheet has you are interested in (perhaps
pitcher doubles, triples allowed, stolen bases and caught stealing?
catcher wild pitches? batting reached on catcher interference?).  I
would provide something like:

id,year,team,stint,stat1,stat2,....

The IDs and team would be in Retrosheet format, but if someone is
willing to both identify the data you want and work to incorporate
what I provide into your existing tables, please let me know.

Tom Ruane



http://www.baseball-databank.org/

---

Yahoo! Groups Links

• To visit your group on the web, go to:
  http://groups.yahoo.com/group/baseball-databank/
   
• To unsubscribe from this group, send an email to:
  baseball-databank-unsubscribe@yahoogroups.com
   
• Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.