Diff for "BabaseChangelog"

Date

Initials

Details

07AUG2007

LKM

one psion file was double entered so the associated rows had to be deleted using 'delete from where between ;' These deletions removed the following id's from babase. SID's 38529 to 38546, IID's 602800 to 602810, pntid's 416895 to 417063, the tables affected are parts, interact_data, neighbors, point_data, fpoints, samples. These id numbers will not be 'query-able' as the have been removed from the database. I just thought it important to note where these numbers disappeared to.

08OCT2007

LKM

"ISO's name was initially OXF, so OXF showed up in Psion data but wasn't in biograph. The neighbors entries were originally changed to 998's but I changed them to ISO after figuring this out (For reference, the associated pntid in neighbors was 428168)

02OCT2007

LKM

In the census table I previously changed BOR group to 10.00 with code of 'A', this was the wrong way to handle this, to correct it, I went back in and changed the group back to 1.00 and 'A'. This cenid was 1910452. I subsequently added a row using demog_census for BOR as being in group 10.00 (alone) on 28/10/86 this data is also saved as BOR demog notes.txt in Historical Census Folder at Duke. This created a new row with cenid=1927725.

02OCT2007

LKM

In the census table I previously changed BOR group to 10.00 with code of 'A', this was the wrong way to handle this, to correct it, I went back in and changed the group back to 1.00 and 'A' This cenid was 1899540. I subsequently added a row using demog_census for BOR as being in group 10.00 (alone) on 31/10/85 this data is also saved as BOR demog notes.txt in Historical Census Folder at Duke. This created a new row with cenid 1927724.

07DEC2007

LKM

It was brought to my attention by T. Fenn that OBR was missed in ALM ranks for 01/2004 and 02/2004. I had to delete the ranks for these two months, which meant deleting rnkid 13969 through 14026. I re-uploaded the ranks for these two months after having added in OBR at rank 13 (end of ADM) as per SCA. The new data are represented in rnkid no's 57590 through 57649

22JAN2007

LKM

The upload program found an error corresponding to a sample in which RWA was sampled as a 'FEM' more than 1 year before her Maturedate (which Tabby was trying to enter). In checking this sample, sid 31893 , it became clear that it should have been a 'JUV' sample, and was thus deleted. As RWA was out of sight for the whole sample, there were no rows in any tables except for samples, from which I deleted all information tied to sid 31893. This sample came from raw Psion file 050924P4.The deleted data is as follows: 31893 24/09/2005 \N JKW F 1.22 RWA 5 0 1 3 4

01MAR2008

LKM

There were a number of individuals in the database with status = 3, or missing. These individuals were all rechecked, and there is no evidence that they are dead, so their status was changed to 0, alive, in an effort to remove the missing code from babase. Affected Individuals are Ivan, Sinister, Crest, Cowlick, BJ ( BJX ), Chip, Max, Xenos, Peter, Seka, Ben, Baron, Wymouth, Raymond, Harvey, Warlock ( WLK ), Pigtail, Fred, Bristle, Teta, Slik ( SLK ), Dorus, Leroy, Kirk, Isaac, Shomo, Slant, Rasta, Styx, Vor, Peanut ( PNT ), Cymbal, Nami, Osborne, Mike, Omen, Thoth, Huxley, Juba, Spike, Fupi, Putz, Kuza, Fatso, Lemur, Ozzie, Giza, Wang, Manfred, Kobol, Hans ( HNS ), Ndimu, Tiptip, Jewel, Ross, Jomba, Sezna, Refu, Keith, Orlon, Nugu, and Dennis.

01MAR2008

LKM

In order to complete the previous change, a few individuals needed to have their statdates changed from an interpolated date to a real statdate. Those animals and the old and new statdates follow. FRE old = 11/02/1984 and new = 10/02/1984; BRI old = 14/02/1984 and new = 11/02/1984; TET old = 04/08/1984 and new = 03/08/1984; DOR old = 16/10/1985 and new = 15/10/1985; KIR old = 19/04/1986 and new = 18/04/1986; ISA old = 06/06/1986 and new = 05/06/1986; SHO old = 07/06/1986 and new = 05/06/1986; SLA old = 10/12/1986 and new = 05/12/1986; VOR old = 08/08/1987 and new = 05/08/1987; PNT old = 18-09-1987 and new = 16-09-1987; CYM old = 28/10/1987 and new = 22/10/1987; OME old = 03/05/1988 and new = 26/04/1988; THO old = 06/08/1988 and new = 03/08/1988

01AUG2008

LKM

There were a number of individuals in the database with status = 2 (Suspected Dead) All of these individuals had dcause of 8(under review) with the exception of POWELL whose dcause was 2(conspecific). In order to get rid of this code, SCA and LKM reviewed the notebooks and were able to assign individuals to alive, or dead, and to assign d-causes to those who are dead. The following were changed to status 0, dcause 0: JAKE, MSWAKI, ALY, KUKU. FAVAS was changed to status 1, dcause 4; AMIGO to status 1 dcause 4; MOLLOY to dcause 3, status 1; PEPO to status 1, dcause 4; and POWELL to status 1 dcause 2.

01AUG2008

LKM

Other individuals who needed to be changed from suspected dead to alive or dead require their statdates be changed. These individuals and their changes are as follows: DELTA: to status 0 dcause 0, old stat=1996-04-02 new stat=1996-03-23; HAHA to status 0 dcause 0, old stat=1996-04-02, new stat=1996-03-23; TUZO: to status 0, dcause 0, old stat= 1999-05-11, new stat= 1999-5-10.

27AUG2008

LKM

The last of the individuals with status of suspected dead were changed to dead with the following dcauses: NOG to status 1 dcause 1; STU to status 1 dcause 7; EDWARD to status 1 dcause 7; FAREX to status 1 dcause7; HEGEL to status 1 dcause 7; VATICAN to status 1 dcause 7.

18SEP2008

LKM

Susan and I stumbled upon some errors in the way that disperse dates were assigned during the period of 1992-1999. The exact error varies from case to case, but basically the assignment rule wasn't followed. Therefore, the disperse dates for 5 individuals had to be changed to reflect the day that they dispersed, and the disperse dates for 2 individuals were removed as it could not be determined that they did not simply reflect the end of observation or a fission. WAL disperse date was changed from 1993-02-03 to 1999-02-04; TUZ disp date was changed from 1993-07-11 to 1993-06-14; DAV disp date was changed from 1996-03-26 to 1996-02-16; BEA disp date was changed from 1996-09-04 to 1996-01-03; DIV disp date changed from 1999-08-03 to 1999-07-08. DAL and JIK disperse dates were removed as per SCA.