[Babase] Results of comparetables on PREGS

kfenn kfenn at princeton.edu
Thu May 31 17:44:35 EDT 2007


Just for the archives so we know where I left off with these comparison 
files...

I changed the matureddates for FED and NAD from ON to BY and added those 
dates as tdate per Jeanne's review.

I did, then UNDID, census changes for BLU and LIB.

I have proofed all the Pregs differences (prior to your fixing the 
RESUME cycles issue).  All differences between the old and new system 
were desired changes and there were no errors.  All estimated ddates 
showed up where they were supposed to.

I also proofed the cycles differences.  I found errors for three 
individuals (ORE, HAN, and HUR) that I thought had been fixed in a 
previous series of corrections... (Their cycles were split in Babase 2.0 
when they should have been connected as one cycle.)  I believe I found 
the source of this error (P values in the real cycgaps table for each t 
and ddate instead of S and E values).  I will check tomorrow to make 
sure these are fixed.  Otherwise, the 'new' cycles differences I saw 
were all additions of automatic mdates.  I did not track down each 
individually in the database as I have in the past ...but the context of 
each (the 3 records before and after each difference) indicated that 
these were just a bunch of additions of automatic mdates.

I checked the 'added' ddates against the estimated ddates tables and 
they all match.  I saw no errors there.

Mdates we checked earlier.

I didn't spend time on the mtddate sequence files as the changes are 
probably just a result of my rejoining so many incorrectly 'split' 
mtddates in Babase 2.0. 

So the files that were ultimately changed today were:
biograph (maturedates)
cycles (maturedates)
real_cycgaps (cycles)
babase_changelog
dump

Hmmm...seems like so little for so much work.


Tabby

Karl O. Pinc wrote:
> Hi,
>
> Here's the Babase 1.0/Babase 2.0 comparison
> for PREGS after I've fixed the conversion code.
>
> This gets rid of the problem of "lost" Resume dates.
>
> What's left seems to fall into two catagories:
>
> New Ddates, which hopefully are the estimated
> Ddates.
>
> Places where the system has assigned a Resume
> date but there was no Resume date in foxpro.
>
> pregs.TXT
> --- /var/tmp/foxsource.10955    2007-05-31 16:15:34.000000000 -0400
> +++ /var/tmp/postsource.10955    2007-05-31 16:15:34.000000000 -0400
> @@ -9,8 +9,8 @@
>  ALI1 1 1981-06-11 1982-11-29
>  ALI2 2 1984-06-23 1984-10-04
>  ALI3 3 1985-03-05 1986-06-08
> -ALT101 101
> -ALT102 102
> +ALT101 101 1968-01-05
> +ALT102 102 1970-02-19
>  ALT103 103 1972-12-23 1974-06-11
>  ALT104 104 1974-06-29
>  ASH1 1 1996-07-31 1997-09-23
> @@ -40,8 +40,8 @@
>  BRU1 1 1974-05-23 1974-12-11
>  BRU2 2 1975-02-21 1977-01-02
>  BRU3 3 1977-04-08
> -BUN101 101
> -BUN102 102
> +BUN101 101 1983-03-07
> +BUN102 102 1984-11-10
>  CAB1 1 2004-03-07 2005-08-05
>  CAB2 2 2006-06-18
>  CAI1 1 2002-04-27 2003-10-22
> @@ -70,7 +70,7 @@
>  COB1 1 2001-03-06 2002-12-17
>  COB2 2 2003-06-18 2005-04-01
>  COB3 3 2005-06-15 2006-09-10
> -DAD1 1 1985-07-08
> +DAD1 1 1984-06-21 1985-07-08
>  DAD10 10 1994-02-08 1994-12-11
>  DAD11 11 1995-04-07 1996-02-20
>  DAD12 12 1996-03-26 1997-04-23
> @@ -157,14 +157,14 @@
>  ENO4 4 1987-05-25 1988-10-09
>  ENO5 5 1989-02-05 1989-11-22
>  ENO6 6 1990-02-23
> -EST101 101
> +EST101 101 1970-01-04
>  EST102 102 1972-01-05 1972-10-08
>  EST103 103 1973-01-21 1974-06-19
>  EST104 104 1974-10-21 1976-04-25
>  EST105 105 1976-07-14 1977-12-23
>  EST106 106 1978-01-06
> -ETA101 101
> -ETA102 102 1982-01-08
> +ETA101 101 1975-07-26
> +ETA102 102 1980-12-03 1982-01-08
>  ETA103 103 1982-07-07 1984-12-07
>  EVA1 1 2005-09-10
>  FAC1 1 1998-01-26 1999-08-19
> @@ -192,7 +192,7 @@
>  FLA1 1 2002-02-22 2002-12-16
>  FLA2 2 2003-05-14 2005-04-12
>  FLA3 3 2005-09-25
> -FLU101 101 1971-08-18
> +FLU101 101 1970-02-19 1971-08-18
>  FLU102 102 1971-12-23
>  FUM1 1 1989-05-09 1990-12-10
>  FUM2 2 1990-12-29 1992-05-02
> @@ -270,7 +270,7 @@
>  HYM1 1 2002-06-29 2003-12-10
>  HYM2 2 2004-03-07 2005-06-01
>  HYM3 3 2005-09-27 2006-12-01
> -JAD101 101
> +JAD101 101 1983-11-19
>  JAD102 102 1985-03-27 1986-01-25
>  JAD103 103 1986-02-04 1986-10-14
>  JAD104 104 1986-12-15 1987-03-01
> @@ -284,7 +284,7 @@
>  JAD112 112 1993-10-26 1994-09-13
>  JAD113 113 1994-11-26 1995-08-03
>  JAD114 114 1996-02-25
> -JAN101 101
> +JAN101 101 1970-01-04
>  JAN102 102 1972-07-15 1973-01-25
>  JAN103 103 1973-03-01 1974-12-12
>  JAZ1 1 1992-07-08 1993-10-17
> @@ -362,8 +362,8 @@
>  KPM3 3 1985-08-07 1986-12-23
>  KPM4 4 1987-10-04 1989-05-20
>  KPM5 5 1990-02-18
> -KUP101 101
> -KUP102 102
> +KUP101 101 1977-04-29
> +KUP102 102 1979-02-09
>  KUP103 103 1980-09-15 1981-11-15
>  KUP104 104 1982-04-01 1983-05-27
>  KUP105 105 1983-07-17 1984-08-14
> @@ -450,10 +450,10 @@
>  LIN5 5 1993-06-11 1995-05-09
>  LIN6 6 1995-08-23 1996-12-09
>  LIN7 7 1997-02-03 1999-01-19
> -LIS101 101
> -LIS102 102
> -LIS103 103
> -LIS104 104 1981-08-18
> +LIS101 101 1975-05-07
> +LIS102 102 1977-04-28
> +LIS103 103 1979-06-15
> +LIS104 104 1980-06-15 1981-08-18
>  LIS105 105 1981-11-16 1982-11-15
>  LIS106 106 1983-04-25
>  LIW1 1 2004-05-01 2004-11-30
> @@ -467,7 +467,7 @@
>  LOC3 4 2004-04-26 2005-06-13
>  LOC4 3 2003-11-09 2003-12-07
>  LOC5 5 2005-11-19
> -LOI101 101
> +LOI101 101 1977-07-16
>  LOI102 102 1981-08-08
>  LOL1 1 2002-08-02 2003-12-11
>  LOL2 2 2004-03-19 2005-06-09
> @@ -501,7 +501,7 @@
>  LYE1 1 2005-02-06 2006-03-23
>  LYE2 2 2006-08-02
>  LYM1 1 2006-06-10
> -MAL101 101 1985-02-25
> +MAL101 101 1984-03-22 1985-02-25
>  MAL102 102 1985-05-03 1986-04-12
>  MAL103 103 1986-06-22 1987-04-06
>  MAL104 104 1987-06-26 1988-06-29
> @@ -530,7 +530,7 @@
>  MOJ6 6 1989-05-14 1991-02-24
>  MOJ7 7 1991-07-05 1993-04-13
>  MOJ8 8 1993-07-30
> -MOM101 101
> +MOM101 101 1971-01-14 1972-08-20
>  MOM102 102 1973-01-09
>  MOM103 103 1974-06-25 1975-01-26
>  MOM104 104 1975-02-16 1975-11-15
> @@ -607,9 +607,9 @@
>  NOB4 4 2004-05-04 2004-12-07
>  NOB5 5 2005-02-15 2006-09-17
>  NOO1 1 2006-01-12
> -NUB101 101
> -NUB102 102
> -NUB103 103
> +NUB101 101 1975-09-28
> +NUB102 102 1977-09-22
> +NUB103 103 1979-07-16
>  NUB104 104 1980-11-23 1982-05-29
>  NUB105 105 1982-10-10 1984-05-06
>  NUB106 106 1984-08-16 1985-01-27
> @@ -621,7 +621,7 @@
>  NUT5 5 2005-08-09 2006-04-20
>  NUT6 6 2006-09-28
>  NYA1 1 1989-03-11 1991-04-07
> -NYA2 2
> +NYA2 2 1992-01-14
>  NYA3 3 1994-05-02 1994-09-14
>  NYA4 4 1995-02-08 1997-04-05
>  NYA5 5 1997-07-10 1999-04-28
> @@ -705,9 +705,9 @@
>  PIC1 1 1986-03-19 1987-11-24
>  PIC2 2 1988-05-11 1989-10-11
>  PIC3 3 1990-01-01
> -PIN101 101
> -PIN102 102
> -PIN103 103
> +PIN101 101 1977-05-15
> +PIN102 102 1978-02-09
> +PIN103 103 1979-06-17
>  PIN104 104 1980-10-10 1981-05-15
>  PIN105 105 1981-08-09 1982-06-09
>  PIN106 106 1983-01-21 1984-02-17
> @@ -729,7 +729,7 @@
>  POK2 2 2004-04-20 2005-02-01
>  POK3 3 2005-04-01 2006-05-02
>  POK4 4 2006-10-16
> -PRE101 101
> +PRE101 101 1971-02-09
>  PRE102 102 1973-04-21
>  PRE103 103 1975-01-17 1976-04-16
>  PRE104 104 1976-09-05 1978-01-17
> @@ -767,8 +767,8 @@
>  RAH8 8 1995-11-10 1997-01-26
>  RAH9 9 1997-04-17
>  REG1 1 1988-10-18 1989-06-23
> -REM101 101
> -REM102 102 1985-05-11
> +REM101 101 1982-01-07
> +REM102 102 1984-03-19 1985-05-11
>  REM103 103 1985-06-01 1986-07-18
>  REM104 104 1986-08-14 1987-08-10
>  REM105 105 1987-09-05 1988-09-02
> @@ -785,17 +785,17 @@
>  RIB2 2 1994-11-30 1995-10-11
>  RIB3 3 1995-12-11 1996-12-01
>  RIB4 4 1996-12-25
> -RIN101 101
> -RIN102 102
> +RIN101 101 1968-01-05
> +RIN102 102 1969-08-14
>  RIN103 103 1971-11-07
>  RIT1 1 1991-06-07 1992-06-07
>  RIT2 2 1992-07-01 1993-08-15
>  RIT3 3 1993-09-07 1994-08-30
>  RIT4 4 1994-09-19 1995-10-02
>  RIT5 5 1996-04-01 1997-08-02
> -RUK101 101
> -RUK102 102
> -RUK103 103
> +RUK101 101 1975-07-07
> +RUK102 102 1977-04-29
> +RUK103 103 1979-03-05
>  RUK104 104 1980-10-25
>  SAF1 1 1981-04-12 1982-08-08
>  SAF2 2 1982-09-01 1983-11-30
> @@ -828,7 +828,7 @@
>  SCI3 3 1990-05-04 1991-09-25
>  SCI4 4 1991-11-30 1993-01-03
>  SCI5 5 1993-02-17
> -SER1 1 1995-05-11
> +SER1 1 1994-02-26 1995-05-11
>  SER2 2 1995-08-10 1996-09-19
>  SER3 3 1996-11-16 1997-11-20
>  SER4 4 1998-01-21 1999-03-22
> @@ -838,7 +838,7 @@
>  SER8 8 2004-04-04 2005-06-02
>  SID1 1 1991-09-22 1992-07-28
>  SID2 2 1992-08-23 1993-10-10
> -SID3 3
> +SID3 3 1993-10-24
>  SIK1 1 1985-01-05 1985-07-10
>  SIK2 2 1985-10-06 1986-12-26
>  SIK3 3 1987-06-08 1988-05-03
> @@ -853,7 +853,7 @@
>  SIS7 8 1989-02-06 1989-11-20
>  SIS8 9 1990-03-31
>  SIS9 7 1988-06-28 1988-12-18
> -SKI101 101
> +SKI101 101 1970-02-19
>  SLI1 1 1974-06-08 1974-12-11
>  SLI2 2 1975-01-01 1975-07-20
>  SLI3 3 1975-08-11 1977-02-25
> @@ -897,14 +897,14 @@
>  TTX101 101 1971-08-01
>  TTX102 102 1973-02-12
>  TTX103 103 1974-04-14
> -TWI101 101
> +TWI101 101 1970-09-04
>  UDI1 1 1989-07-25 1990-09-27
>  UDI2 2 1990-10-31 1992-01-15
>  UDI3 3 1992-06-08 1993-08-17
>  UDI4 4 1993-09-24 1994-11-19
>  UDI5 5 1995-04-12 1995-11-08
>  UDI6 6 1995-12-04 1997-04-06
> -UMB101 101
> +UMB101 101 1983-05-07
>  UMB102 102 1984-06-17 1985-03-28
>  UMB103 103 1985-05-24 1986-03-17
>  UMB104 104 1986-04-15 1987-01-16
> @@ -1126,6 +1126,6 @@
>  YAI2 2 2006-07-16
>  YOG1 1 2005-02-05 2006-08-12
>  YOG2 2 2006-12-20
> -ZUM101 101
> +ZUM101 101 1983-05-07
>  ZUM102 102 1985-08-07 1986-02-14
>  ZUM103 103 1986-07-08 1987-01-09
>
>
>
> Karl <kop at meme.com>
> Free Software:  "You don't pay back, you pay forward."
>                  -- Robert A. Heinlein
>
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase

-- 
Tabby Fenn
Research Assistant

Dept of Ecology and Evolutionary Biology
401 Guyot Hall
Princeton University
Princeton, NJ  08544

609 258-6898 (Ph)
609 258-2712 (Fx)



More information about the Babase mailing list