[Babase] male dispersal query
Niki Learn
nlearn at princeton.edu
Fri May 14 15:53:27 EDT 2010
Aside: Speaking of which, while looking at the interp column in members I
discovered that AMO is weird. Everyone else has no more than one date where
interp = 0 (but not everyone has a 0 point at all...what does that mean? I
thought they each got one at birth?) but AMO has interp = 0 for every census
date we added to fill in his time when he was known as Billy... It seems
like something went wrong there? [Btw, I added BIL to snames_not_in_biog.]
Main point: I have encountered a similar problem (to the male dispersal
query problem) when dealing with female sexual cycle data. We recently
wanted to know about the time period spent lactating and then cycling after
each birth. But each pid is linked to the cycle PRIOR to birth, not the one
after it. I could not find a way to get babase to link to the cycle for the
next pid (which is tricky anyway since a few females have pids that are out
of order or where one is skipped) and ended up having to run separate
queries, then line them up in Excel and calculate the cycling time after
sorting by pid. Maybe it joining in parity from the pregs table should work
but parity doesn't show up anywhere else so that is yet another level of
complexity and I couldn't get it to work.
Anyway, it seems like it would be helpful to be able to pull data out by the
start and end of each event (whether it be changing groups or transitioning
to another reproductive phase, etc.) and to be able to link one event to the
next one chronologically. What's the best way to go about that? Is making
views the only way to do it? I had thought maybe I could identify the end
of an event and then add a day to the date to get the start of the next
event but could not figure out how to do get babase to add a day to a
previously identified date.
Thanks,
Niki
-----Original Message-----
From: babase-bounces at eeblistserv.Princeton.EDU
[mailto:babase-bounces at eeblistserv.Princeton.EDU] On Behalf Of Susan Alberts
Sent: Friday, May 14, 2010 3:17 PM
To: The Baboon Database Project
Cc: Elizabeth Archie
Subject: [Babase] male dispersal query
HI Karl,
Here is a problem that has come up before and will again.
We'd like to be able to extract data from members of the following
form, regarding male dispersal and group membership patterns
Group, Date into that group, Date out of that group, Sname
Where each male has an exhaustive set of rows that shows where he is
for all the chunks of his life. I don't know how to get this out of
members easily.
Can you provide advise? Is this something we could set up as a view
sometime?
Thanks,
Susan
------------------------------------------------------------
Susan Alberts, Dept of Biology, Duke University, Box 90338, Durham NC
27708. Phone 919-660-7272, FAX 919-660-7293
_______________________________________________
Babase mailing list
Babase at www.eco.princeton.edu
http://www.eco.princeton.edu/mailman/listinfo/babase
More information about the Babase
mailing list