In attempting to create a States table, I've come across a number of odd state abbreviations: In Canada, PQ appears to be QC - Quebec. In Panama, Ca doesn't...
Quebec has TWO designations.... QC is used by everyone in the world, and PQ (province de quebec) is used by Quebecois. There is no one "official" one. Such...
This is a DB structure issue, so feel free to ignore if you don't know what I'm talking about. I have restructured the db with numeric keys. A full run down...
... Province de Quebec - French version of the name. ... Probably the Canal Zone, which no longer exists. Rod Carew? ... Definitely Texas; he was the mayor of...
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 :...
baseball-databank@yah...
Aug 2, 2005 11:26 pm
2750
... I created a States table to handle all countries the same way. This isn't nearly as good an option of having a Locations table, but for an incremental...
... I've been thinking about writing a script to generate this mapping... You could automate most of this process because most player names are unique and...
I tried to post this master table several times, but the server wouldn't let me, citing that 98% of the 20 MB limit has been reached. The file that I have is a...
I cleaned up some of the files I've posted that have already been rolled in; we're now at 92%, which isn't enough, but we're closer. Thanks for volunteering...
Has the question/issue regarding the numerous missing height/weights as mentioned in post #2701 been resolved? Also, just as a misplaced gripe, the new table...
... While I am very much in favor of the changes (using data in SQL rather than spread sheets), I think that this gripe is well founded. Most of the *users* of...
I had exactly the same comment/complaint. Those of us who do some work on adding or changing data often use "flat" files/.csv files as we work, then we import...
KJOK wrote "Re: New Structure" ... the files that I have in FILES are current, so I don't really have any deletable items. However, there are some files that...
... I'd like to add a "me too". I use only the CSV files, using Awk programs and some other Unix tools (grep, etc.). Coding issues aside, I have found it...
This group should be delivering a set of files that a DB developer or admin can use. THOSE people should be delivering a product that the end-user can use. ...
I think the process is something like this: Data Contributors/Maintainers ... FILES ... DB Developers ... Some application here? ... End-Users What may not be...
... Here is how I envision this going. We'll have whatever admins/board members we have discussed before. New data and corrections will be voted on in the...
http://www.linux-mag.com/content/view/2015/2304/ Here is the article in linux magazine that describes how apache structures their projects and decides on how...
... I like the Creative Commons with the following customizations: * Allow commercial uses * Allow modifications as long as others share alike * Generic...
... If by "data" you mean something granular, with no intelligence behind it, I agree. For example, "runs created" would not be considered "data" in its more ...
I tried to post the Universal master table again today and still received an error message indicating that there was not enough room left on the server. The...
Hi, I think the following from the databank statement of purpose applies: The Baseball Databank (BDB) is dedicated to creating and maintaining a comprehensive...
... admins/board ... be ... an ... peoples ... duty ... name ... own ... could ... previous ... I had previously downloaded the Comma Delimited version of the...
... OK, On the list of things to do is add views that will recreate the look and feel of the previous structures. Please keep in mind that the BDB is intended...
... I have to agree with Tom here. I think asking people to make open source anything that at all touches the BDB is WAY overstepping our bounds. What I was...