[Babase] Interpolation coding done!

Catherine Markham babase@www.eco.princeton.edu
Fri, 14 Oct 2005 16:20:06 -0400


> I have also gone over the interpolation documentation again
> to make sure everybody's concerns are addressed.  In particular
> take a look at the text surrounding Figure 10, and the footnotes
> and text of CENSUS.Status, the D value.

Hi Karl,

Sorry I missed the second part of your message about the interpolation 
documentation before.  Turns out I do just have a quick question about 
the text describing "D" status in CENSUS.

The text says:

D (demography) The animal was noted, in the field notebooks or 
elsewhere, to be in a group but was not marked present in a field census 
on that day. There is an associated DEMOG row associated with the CENSUS 
row. The individual may or may not have been marked “absent” on the same 
group's field census for the day.[10]

[10] D usually occurs when a male is seen alone or in a non-census group.


I read this to say that a Demog Note will override an absence for an 
animal in a particular group, but I didn't think this was possible in 
practice.  I did the following to query the current CENSUS table and 
didn't find any records (assuming the query steps below look correct):

select * from census into table census2

select * from census, census2 where census.sname = census2.sname and 
census.date = census2.date and census.grp = census2.grp and 
census.status = "D" and census2.status = "A"

Am I misreading the documentation or rusty on the rules for Demog Notes?

Thanks,
Catherine