[Babase] MEMBERS Comparison - Final Summary

Karl O. Pinc babase@www.eco.princeton.edu
Fri, 30 Sep 2005 19:45:25 +0000


On 09/30/2005 12:58:37 PM, Catherine Markham wrote:
> Questions:
> 
> 1.  Several individuals had only rows in the new MEMBERS table  
> despite having no rows in CENSUS.  These individuals include: A21,  
> B11, CS1*, D13*, DM1*, MN1*, MT5*, NZ5*, R14, RH9, and UT4*.
> 
> All of the ones with asterisks were on my list of conversion errors  
> from Leah (corrections have been discussed, but I still need to make  
> the changes).  I'm not sure what is up with the others, though - I'll  
> have to look into them more carefully.  What the program is doing in  
> all cases is giving a single row for the baboon's birth in MEMBERS,  
> despite there being no data in CENSUS.  The only exception is A21  
> because this is the only individual in the list who also has a death  
> date - in this case, there are rows from birth through death in  
> MEMBERS, again without any info in CENSUS.  All of this seems  
> logical, even if it is a bit weird to have MEMBERS entries when  
> nothing is listed in CENSUS.  Karl, am I working through this one  
> right?

Yes.  According to the rules it's supposed to do this.  And I think
we want it to, right?

> 
> 2.  Lots of "glitches" arising from the partially loaded Wn0303b file  
> showed up as rows in MEMBERS not matching CENSUS.  I flagged these to  
> go back and recheck after that census file for Weaver's on 5 March  
> 2003 can be uploaded completely.

Ok.

> 3.  The last few records in the comparison txt file you sent me start  
> out for ZUM - the last line itself is nothing more than a plus sign.   
> Is this the correct end?  No real errors to look at for ZUM?

That means there's an extra blank line at the end of the
postgres data dump.  Nothing to worry about.

> Common discrepancies:

Those sounded like what we'd expect.

> How I did it (just for archive):

Sounds good to me.

Karl <kop@meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein