[Babase] Members not pulling in census rows, only interpolation rows

Niki Learn nlearn at princeton.edu
Wed May 19 10:59:27 EDT 2010


Catherine emailed me earlier about a problem she was having with members.
She was working on a count of baboons in each group at the start of each
month and was getting no output for some groups in some months.  An example
she gave was 

 

select * from members where date >= '2008-01-01' and grp = '1.10'

 

whereas queries for other groups on the same dates worked fine (e.g.,
Linda's group on the above date).

 

I dug around a little and found that members was only listing dates with an
origin of I - only the interpolated data is showing up in members.  Example
- all the census data is missing from Apollo's members record:

 

select * from members where date >= '2008-01-01' and grp = '1.10' and sname
= 'APO' order by date;

select * from census where date >= '2008-01-01' and grp = '1.10' and sname =
'APO' order by date;

 

This happens with older data too (e.g., select * from biograph where sname =
'BEA'; select * from census where sname = 'BEA' order by date; select * from
members where sname = 'BEA' order by date;     Beam doesn't even show up in
members until the end of 1993 when his "L" census records cease)

 

I thought maybe something buggy happened during the last rebuild so I tried
rebuilding it but it is still the same.  It is doing the same thing in
babase_test.

 

Remember last week when I said Amok was weird because he was the only baboon
with more than one entry where the interp column = 0?  This is why.  Amok's
census data we just added for when he was Billy (1995-1997) is in members
(each census line gets interp = 0) but his later census data when he entered
a study group is not in members so there are no rows there with origin C or
interp = 0.

 

select * from members where interp = 0;

select * from members where sname = 'AMO' order by date;  

 

Karl, when you made that change to the interpolation rules to interpolate
correctly around Amok's birth, could that have thrown off whatever
interpolation rule pulls the census data into members with the interpolated
data?  Or does rebuilding it from scratch not pull in the existing census
data (which would be another bug)?

 

Thanks,

Niki

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://eeblistserv.Princeton.EDU/pipermail/babase/attachments/20100519/4e8523db/attachment.html


More information about the Babase mailing list