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

08MAR2008

KHF

Jeanne noticed a number of males missing their mature and dispersedates that should have been entered during recent updates. This was due to a a maladapted FoxPro query that I was running in the new system. I checked the data for males age 4+ during the 06B and later updates and fixed the syntax of the query. The only male dispersedate I had to add from 06B was for WOL. I had to enter maturedates for the following individuals: NOZ DAS KOR WUA KUT (06B) BUC and SEB (07B).

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.

02Oct2008

KHF

Patrick O. discovered that a pid for LAD7 (LAQUER) had not been entered in BIOGRAPH. This was due to the fact that the conception and birth ended up being entered in the same demog update and the pid was omitted initially to allow the BIOGRAPH record to load. I should have updated the pid subsequently but did not for some reason. I used an update statement to enter the pid into BIOGRAPH. I also queried BIOGRAPH for all other pid's that are null. There did not seem to be any other omission errors of known mothers from our 5 study groups. All the other unknown pids came from grps 1,2,3 or 9 in much earlier decades.

12Dec2008

KHF

DIC1 and WIR3 had blanks instead of NULL in the name column of BIOGRAPH. I changed these to NULL and checked for other similar situations, changing all blanks to NULLS. There were only a few others

05Feb2009

LKM

OFR had a row in samples for 9Feb08, a day when she was not in the group. The whole sample was out of sight so, there were no rows in any tables except for samples, from which I deleted all information tied to sid 50688. This sample came from raw Psion file 080209P3.The deleted data is as follows: 50688 09/02/2008 11:21:00 SNS F 1.21 OFR 10 0 2 4 3

05Feb2009

KHF

LKM deleted a row in samples for OFR on 9Feb08, allowing me to updated OFR statdate from 2009-02-09 to 2009-02-08. This was her assigned deathdate, but due to the empty SAMPLES row, her statdate did not correctly input at the time of the last update. Earlier corrections to statdate for ABB and OBO were also made on 9 December 2008. ABB statdate was changed to 2008-02-08 and OBO statdate was changed to 2008-03-04. In each case their statdates had defaulted to the following day because there was a demog note saying that a thorough search was done on the first date that their absence was noted. I deleted these demog notes since they were unnecessary and created false census data. On 9 December 2008 I also searched for and changed any blank names in BIOGRAPH to null values where the sname was also already null.

24Feb2009

KHF

RE: the changes made above for OFR, ABB, OBO. I rebuilt CYCSTATS because OFR had incorrect information for April 2008. She was D almost the entire month even though MTD_CYCLES showed her tdate of 5 April and ddate of 19 April. This error probably had something to do with her incorrect statdate. When I rebuilt the table, (after corrections above to her statdate) her CYCSTATS state for April was altered to correctly show the S and D and O that should have been triggered by the MTD_CYCLES data. I also rebuilt Babase_test CYCSTATS. REPSTATS, MMINTERVALS, MDINTERVALS should also be rebuild but as I am currently working on the 08b update, this will be done shortly. CYCSTATS was rebuilt immediately because P. Onyango needed the data.

25Feb2009

KHF

I added a demog Note for SHOMO for 11 June 1986, per a discovery of the missing note by L.Maryott. I updated his status and dcause to 0 (formerly 3 and 8).

18Jun2009

NHL

I changed JIL's matgrp from 9.00 (unknown) to 6.00 (Ositeti), as she is a member of Ositeti and females do not disperse.

26Aug2009

NHL

Morris' bstatus should not have been 9 and was changed to 2. Investigation also uncovered some anomalies in demography data, which were corrected in babase on 3 Sep. Morris should not have been marked present in Nyayo's group via demography note on 25 July 2001 - he was just visiting the group from Sinya; the male ranks for Nyayo's group for that month were adjusted accordingly. Census entries marking him present in group 9 (unknown group) on 20 Oct 1997 and 28 Jul 2001 were also removed. Corrected demography notes were added.

4Jun2010

NHL

HEE and GEM had incorrect sexes listed in babase. HEE is male, GEM is female. These were corrected and HEE's female ranks reassigned to GEM.

Winter 2009/2010

NHL

Baboons from groups no longer being monitored and males that have not been seen in at least one update cycle were censored for the first time. They have been given a status of 2 in biograph and dcause 99 so that they appear dead to babase. This will prevent accidental upload of data for these animals while indicating that we have no data on their current status. Males that return to a study group after an absence will be uncensored prior to upload. Some animals that should be censored threw samples errors and will be censored following resolution of those errors.

10Mar2010

NHL

Ositeti group is now officially recognized as two distinct groups. Ositeti census data for Feb - Jun 2009 was adjusted to reflect the split during the 09B census update. Groups 6.1 (Jill's), 6.2 (Ceejay's - initially called Latin's but updated in May 2010 once a marker female was chosen), and 6.9 (unidentified Ositeti group) are now recognized.

10Mar2010

NHL

While censoring animals, census records were compared with wounds and pathologies reports (now in babase_pending) to check for animals that likely died but were not previously declared dead. The following individuals were declared dead: Vipi, Adriano, Zidi, Khan, Nugu, and Ole. Additionally, demography notes indicated that Nod's deathdate should be changed from 21 Oct to 24 Oct 1997. These changes were all made with the 09B demographic update.

23Mar2010

LKR

All rankdates and all male maturedates were rolled back to the first of the month such that older rankdates and maturedates would be brought in line with current protocols.

5May2010

NHL & LKR

Billy and Amok were determined to be the same baboon. Billy's birth and early census data were added unto Amok and Billy was deleted from babase.

4Jun2010

LKR

Rankdates for WEU and DEA were corrected. VIP was moved below all adult males for Weaver's group in Mar and Apr 2000. ARS was added to the ADM ranks in Viola's group at the bottom of the list in Feb 2004.

13Jul2010

NHL

Adjustments were made to cycpoints to include a missing cycle (Lizzy) and to better align ddates with consortship data as follows: Lizzy's ddate corresponding to the conceive data for LIZ6 was changed from 20 Jul 2008 to 18 Aug 2008 and the correct end of the prior resume cycle and beginning of this cycle were added; Nap's ddate was moved forward two days to 4 Jan 2002, Wheatear's forward three days to 23 Jul 2002, and Kelly's forward two days to 3 Sep 2006.

22Sep2010

LKR

The following changes had to be made to their neighbors table to correct for Males being neighbors after their statdates. All ID numbers correspond to NGHID in the neighbors table. All changes confirmed by SCA. 559484 - MAN was changed to MAH as per surrounding samples. 561996 - VER was changed to VEX as per surrounding samples. 622978 - NEL was changed to NER as per surrounding samples. 657856 - DAN was changed to DAM as per surrounding samples. 693529 - ZAI was changed to ZAN as per surrounding samples. The following neighbor rows were changed to 998 for WYL as an alternative could not be easily discerned; 630098 630101 630104 582684 582686 582688 582690. The following neighbor rows were changed to 998 for DIG as an alternative could not easily be discerned; 647713 643715 647717 645070 645071 645072 645073 645074 645019 642802 642804 642780 610064 610062 554224 554225 554227 554229

15Nov2010

NHL

Birth estimates and bstatuses for MOZ and TOR were originally entered in reverse (i.e., with TOR instead of MOZ as the older animal). The birth and bstatus columns were corrected.

13Dec2010

NHL

Maturedate for LEC revised from 1 Nov 2009 to 1 Feb 2010 when he first consistently was marked as "E".

5Jan2011

NHL & LKR

Several errors in the early 1994 census data for Hook's, and consequently in the male ranks for Hook's, were discovered. Felix and Alex were present in Hook's beginning in Jan 1994, not March. Orlon was present beginning in February, not April. None appeared in the male ranks for those months. Dennis was also present in February though he was not listed as such in Babase; he was, however, ranked. Census data for Felix, Alex, Orlon, and Dennis were added. Kitok was not present in Hook's in February as previously indicated in Babase; his census and rank data for Feb 1994 were deleted. Male ranks for Jan - Mar were adjusted accordingly. Maturedates for Felix and Alex were adjusted from 1 Feb 1994 to 1 Jan 1994.

5Jan2011

NHL

30 Mar 1994 census data for Dotty's group was previously entered into Babase as being for 30 Apr 1994, which was not a census day. This has been corrected. Ajabu was incorrectly deleted from the Alto's census on 5 Mar 1994 in Nov 1994 per a somewhat unclear and belated note from the team about him, Orange, and Villa. Ajabu was present per census, demog notes, and the wounds report for his broken leg. Since he is absent from ranks and was following the group at a distance on the only census day he was live in March, I have left him marked absent but created a demography note (to be uploaded with the other 1993-1996 Alto's demog notes soon) stating that he was alone and following the group and updated his deathdate from 21 Feb to 7 Mar 1994. Orange was similarly deleted from the census in April per the same corrections note but was also really present for the first two census days per the census and a grooming event and was noted as absent on the 27th in demog notes. He showed up in April ranks anyway (perhaps due to the 30 April census error) so ranks is okay. His census data was restored and his deathdate was changed from 12 Sep 1994 (where did that date come from???) to 25 Apr 1994. The assigned dcauses were correct.

06 Jan 2011

LKR

ZEN had incorrectly assigned matured and ranked dates. ZEN's ranked by and matured by dates were backed up to the time at which he entered a study group, 1993-08-01. No rankings were affected by this change.

06 Jan 2011

LKR

LUD was never assigned a matured date. Somehow, the team allowed him to fall off of the scrotal enlargement sheets. At last observation in Nov 07, He had been almost E for 5 months. Susan felt it was safe to assume that 2 months after his last monitored month at Almost E was a safe Matured BY date. So, he was assigned a BY date of 2008-01-01

06 Jan 2011

LKR

COO and DEF were both missed for ranked by dates when they entered or reenetered study groups. DEF was also missing a matured date as a result of being missed. For COO, a ranked on of 2008-12-01 was added. For DEF, mat and ranked by dates of 2008-09-01 were added.

21 Jan 2011

NHL

ORI3 was added to biograph. This fetus was missed when Orion died in 2007.

21 Jan 2011

NHL

Lenga's dcause was changed from 3 to 2 due to evidence of conspecific origin of the wounds in notes.

21 Jan 2011

NHL

More ddates adjusted to reflect consortship data: Dunlin's zdate changed from 16 to 17 Feb 2005 - Dunlin was consorted on the 16th and was T on that date. Yogi's zdate changed from 1 to 2 Sep 2007 - Yogi was consorted on the 1st and had a short cycle with rapid increase and decrease in turgescence. Limau's zdate changed from 19 to 20 Aug 2003 - Limau was consorted by Vipi on the 19th but was not seen doing so prior and Vipi is Luo's father; repro notes indicate that Limau had some wrinkles but was being consorted by Vipi.

27 Jan 2011

LKR

A number of consort errors were discovered through a thorough search done by NL. After discussion with SCA/JA/NL (see email from N Learn 17 Jun 2010 and subsequent email exchanges) the following changes were made in Jan 2011. iid 654028 was a consort between TOG and WAD. WAD was lactating during this time. The decision was made to change this to NAP.

27 Jan 2011

LKR

iid 736916 was a consort between KAG and LAN that started at 15:38 and ended at 12:30. This is obviously an error. JA and SCA suspect this is a swahili time converstion problem and the end time was changed to 18:32 as per GPS records.

27 Jan 2011

LKR

iid 737014 was a consort between ZAN and COB for which the start time was 16:10 and the stop was 12:30. Again, this was an obvious error. GPS start and stop times were 8:01 and 12:32. Start time for this file was changed to 10:10. subsequently, there was another consort between THU and COB from 930-1610 this day. Using the same information,the stop time here was changed to 10:10(iid 737013). an E record between ZAN and COB recorded at 16:23 was also changed to 10:23 (iid 737004).

27 Jan 2011

LKR

iid 453924 was a consort between LIB and DOV starting at 07:58 and stopping at 18:15. This is an unusually long time for a consort. GPS data start at 7:58 and end at 8:15, so the stop time for this was changed to 8:15.

27 Jan 2011

LKR

iid 492866 was a consort between HIB and LIW starting at 6:42 and stopping at 15:58. There was also a consort between MOR and KAT with the same stop time (iid 492867). Swerb records ended at 12:30, so the stop time for both of these was changed to 12:30.

27 Jan 2011

LKR

iid 653944 This was a consort between TOG and NAP starting at 6:44 and stopping at 18:29. Swerb data ended at 12:32, so stop time was changed to 12:29.

27 Jan 2011

LKR

iid 654020 was a consort between KAG and WIP starting at 7:34 and stopping at 19:16. swerb data ended at 9:16, and so the stop time was changed to 9:16.

27 Jan 2011

LKR

iid 736941 was a consort between RAJ and WIF starting at 7:12 and stopping at 18:21. Swerb data didn't start until 12:45 this day, and so assuming a swahili time conversion error, start time was changed to 13:12, which fits other data for the day

27 Jan 2011

LKR

The next group of consort errors were all on darting days, and it is likely the team just didn't keep track of stops and starts. iid 654055 starts at 7:04 and stops at 17:04. Swerb data stop at 10:56, and resume at 14:48, continuing until 17:04, so this was split into two consorts, one from 704-1056 and another from 1448-1704.

27 Jan 2011

LKR

iids 711981 711982 and 711983 (TAP DRO, YOB HYM, and AYU HUC)started at 7:09, 7:10, and 8:38 respectively and all ended at 18:10. Swerb for this day stopped at 9:38 and resumed at 16:11 with another small break from 17:21 to 18:03. SCA decided all C's should stop at 09:38, start back up and 16:11, and continue through the second, short break, with stop times of 18:10.

27 Jan 2011

LKR

iid 711983 was also originally recorded between AYU and HYM, but as hym was already being consorted, it was decided that this was likely HUC. HYM was changed to HUC

27 Jan 2011

LKR

iid 654552 was a consort between LOZ and WED stating at 7:12 and stopping at 16:25. Swerb go from 6:26-11:03 and then 16:03-16:25. This was split into two consorts which reflect swerb times

27 Jan 2011

LKR

The following consort errors are errors in that the females being consorted were in reproductive states that would not elicit consortship. iids 544296 and 544298 were Consorts for DUD who was over a month post-swelling. These records were deleted.

27 Jan 2011

LKR

iid 621961 was for WIF who was Menstrating. this was deleted.

27 Jan 2011

LKR

iid 621996 was for LAO who was menstrating. this was deleted.

27 Jan 2011

LKR

The following consorts seemed too early in a females' swelling to be real. The changes were made accordingly. iid 566652 (as well as iid 566645) were between GAN and YAI on 2 Nov 2005. This day was not a census day and so date for these interactions as well as iid 566653 for ARS and VAI changed to 3 Nov 2005 as per census

27 Jan 2011

LKR

iid 622480 EDU C RHO and 622479 GYP C VEX. RHO was not nearly swollen enough to be consorted at this point, and after further review it was noted that this whole (original data) page of consorts was a bit messy. EDU RHO was changed to the 25th of the month, as well as another consort added for GYP and DIC. Another C for the 13th was missed as well for QUA and VAA and that was added as well. the interaction between GYP and VEX was the only correct one.

27 Jan 2011

LKR

iid 493137 was a consort between KER and SCE. she was only on day 4 of her swelling and was unlikely being consorted.It is unclear who may have been the consort female, but the interaction was deleted due to uncertainty.

27 Jan 2011

LKR

iids 454940 and 601130 were consorts with LIZ and LYE when both were 3 days deturgesent. These interactions were deleted.

27 Jan 2011

LKR

iids 622805 and 622806 were consorts for KEL as well as iid 622781 which was an E for KEL all on 5 Sep 2006 when she was D+3. It was deduced that this was KIW and all three were changed to KIW

27 Jan 2011

LKR

iid 544968 was a consort for IAG and VOG(who was lactating). This was deduced to be and was changed to YOG

27 Jan 2011

LKR

iid 622612 was a consort between GAN and VIN(who is pregnant). This was deduced to be VIG and was changed to VIG

27 Jan 2011

LKR

iid 654426 was a consort between GAN and YAI(who is lactating). No obvious mistake was found, so this interaction was deleted from the database.

21 Mar 2011

LKR

sid 55934 was a point sample for LOP. However, this was a F sample during the time when LOP was still a Juvenile. The logs indicated the sample should have been for her mom LOL, and so the samples table was updated to reflect this.

30 Mar 2011

NHL & LKR

A census/agonism/rank error was discovered for Waka in August 1994. iid 252067 was changed to WAC A LUN instead of WAK A LUN. Incorrect manual census entries for WAK at the end of July and beginning of August were removed and her statdate adjusted from 5 Aug to 31 Jul 1994 to in accordance with her absence on the first census in Aug; this also required that WAK be removed from the female ranks (only ADF exists for this year) for that month. NHL also noticed at that time that WAK suddenly went from rank 2 to rank 16 and back to rank 2 - the April 1992 Hook's female ranks were incorrect, apparently the age-default version of ranks was uploaded. Investigation showed that April ranks should be the same as March's so this was corrected. Also Wema was suddenly rank 23 in May 1992 instead of rank 5 - she was moved to her correct position.