[Babase] MCE or CID duplicate entries
Lacey Maryott
lacey.maryott at duke.edu
Tue Jan 13 12:11:25 EST 2009
Karl, is there a query to search for duplicate information, in either
the actor_actees table, or in cycles. Is there a rule in cycles or in
interact_data that disallows duplicate id numbers?
-------- Original Message --------
Subject: mating behaviors dataset
Date: Tue, 13 Jan 2009 09:58:12 -0500
From: Jenny Tung <jt5 at duke.edu>
To: Marie Charpentier <mariecharp at yahoo.fr>, Lacey Maryott
<lacey.maryott at duke.edu>
CC: Susan Alberts <alberts at duke.edu>
Hi Marie and Lacey,
I was working with the mating behaviors dataset last night and found
a few inconsistencies in data from Group 2, July - Sep 1993. These
are records that are repeated--i.e., there are two duplicate lines of
data for a consortship between Kestrel and Nelson for cid 11424 (they
are exactly the same--same day, same start and stop times). I'm
assuming the error comes from Babase itself, not the query to extract
the data, because I've only found this problem during this time
period for this group (but not for all individuals in that group in
that time period).
I suspect this list is not exhaustive, but these are the records that
I've found that are affected:
KES consortship with NEL, cid 11424
KES consortship with NEL, cid 11427
LIM consortship with PEP cid 13012
LUN consortship with LEO cid 14286
NIX consortship with KEI cid 16132
I can do a more thorough search for this kind of thing if you want me
to do so; let me know.
Jenny
--
Lacey Maryott
Alberts Lab
Department of Biology
Duke University
ph: 919-660-7306
fax: 919-660-7293
Lacey.Maryott at duke.edu
More information about the Babase
mailing list