There is consort data for June 30, which is why I am getting an error in Linda's.<br><br>Thanks!<br>Lacey<br><br><div class="gmail_quote">On Fri, Oct 30, 2009 at 1:47 PM, Niki Learn <span dir="ltr"><<a href="mailto:nlearn@princeton.edu">nlearn@princeton.edu</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div link="blue" vlink="purple" lang="EN-US">
<div>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">Linda’s should be fine. The last incomplete census was June 27
and the last team census was June 29…. I don’t see any agonism data for after
that date.</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">Getting ready to upload Weaver’s now.</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<div style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0in 0in;">
<p class="MsoNormal"><b><span style="font-size: 10pt;">From:</span></b><span style="font-size: 10pt;">
<a href="mailto:babase-bounces@eeblistserv.Princeton.EDU" target="_blank">babase-bounces@eeblistserv.Princeton.EDU</a>
[mailto:<a href="mailto:babase-bounces@eeblistserv.Princeton.EDU" target="_blank">babase-bounces@eeblistserv.Princeton.EDU</a>] <b>On Behalf Of </b>Lacey
Roerish<br>
<b>Sent:</b> Friday, October 30, 2009 1:13 PM<div><div></div><div class="h5"><br>
<b>To:</b> The Baboon Database Project<br>
<b>Subject:</b> Re: [Babase] Statdate problem for End June 2009</div></div></span></p>
</div><div><div></div><div class="h5">
<p class="MsoNormal"> </p>
<p class="MsoNormal" style="margin-bottom: 12pt;">It looks like Weaver's and
Linda's. Everyone elses data went in fine! :-D<br>
<br>
You probably should log in as admin when trying to create tables in
pending. As for the 'types' of data, You might look on the ppa
website <a href="http://www.postgresql.org/docs/8.1/interactive/bookindex.html" target="_blank">http://www.postgresql.org/docs/8.1/interactive/bookindex.html</a>
I only use a couple of different types because I don't know what the rest of
them mean.<br>
I mostly use character, char var, numeric, date, time without timezone as they
are the only ones I understand :)<br>
<br>
Thanks again<br>
Lacey</p>
<div>
<p class="MsoNormal">On Fri, Oct 30, 2009 at 1:02 PM, Niki Learn <<a href="mailto:nlearn@princeton.edu" target="_blank">nlearn@princeton.edu</a>> wrote:</p>
<div>
<div>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">No, it won’t take me long at all.
I can do it after lunch. Is Weaver’s the only group affected?</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">I got stuck trying to create wounds
tables in pending anyway. Do I need to log in as administrator to make
those or something? Getting weird errors. Also, is there a list
somewhere of what all these options in the type column are??? I couldn’t
find one and many are not self explanatory.</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<div style="border-style: solid none none; border-color: -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0in 0in;">
<p class="MsoNormal"><b><span style="font-size: 10pt;">From:</span></b><span style="font-size: 10pt;"> <a href="mailto:babase-bounces@eeblistserv.Princeton.EDU" target="_blank">babase-bounces@eeblistserv.Princeton.EDU</a>
[mailto:<a href="mailto:babase-bounces@eeblistserv.Princeton.EDU" target="_blank">babase-bounces@eeblistserv.Princeton.EDU</a>] <b>On Behalf Of </b>Lacey
Roerish<br>
<b>Sent:</b> Friday, October 30, 2009 12:56 PM</span></p>
<div>
<p class="MsoNormal"><span style="font-size: 10pt;"><br>
<b>To:</b> The Baboon Database Project</span></p>
</div>
<p class="MsoNormal"><b><span style="font-size: 10pt;">Subject:</span></b><span style="font-size: 10pt;"> Re: [Babase] Statdate problem for End June 2009</span></p>
</div>
<div>
<div>
<p class="MsoNormal"> </p>
<p class="MsoNormal" style="margin-bottom: 12pt;">Animals
who would be included in her census would be the only animals affected by this
anyway as Courtney won't know them to collect data on them. So as long as the
statdates are updated for those animals who she would be collecting data on,
everyone would be covered. <br>
<br>
This is likely to only occur on this update, and potentially 10B as I think
Courtney will be back in kenya then. So it wouldn't be a recurring
problem.<br>
<br>
It would also mean just holding back one or two lines of data which can very
easily get lost, unlike cycles, which are bigger events, which can't and won't
be lost.<br>
<br>
It it looks like something that you just won't have time to do by Tues, does it
make more sense for me to enter these few demog notes?<br>
<br>
Thanks<br>
Lacey</p>
<div>
<p class="MsoNormal">On
Fri, Oct 30, 2009 at 12:47 PM, Niki Learn <<a href="mailto:nlearn@princeton.edu" target="_blank">nlearn@princeton.edu</a>>
wrote:</p>
<div>
<div>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">Hmm… When we have any kind of
cycling (example a cycle has begun in June or December but has not been completed
by the last census day and so is left dangling) or reproductive data (example a
birth estimated to be at the end of June but after the last census date) that
occurs at the end of an update period we hold it over for the next update.</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">I can see why we might not want to do
that for agonisms in December (although you guys do male agonisms for the first
half of the year separately?) since I guess we’d want them included in the 09b
update in order to count them when doing the ranks. Does it matter for
June? Will you do the 09a male agonisms before the 09b update?</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">I <i>can</i> add a census column for
6/29 BUT the animals that Courtney did not census (mostly juveniles) would
still not have a change in statdate since they would still get no census record
for that day. I guess for male ranks only the adult male interactions
matter though so it would be okay if only the adults were marked through the
29th?</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">Niki</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<div style="border-style: solid none none; border-color: -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0in 0in;">
<p class="MsoNormal"><b><span style="font-size: 10pt;">From:</span></b><span style="font-size: 10pt;"> <a href="mailto:babase-bounces@eeblistserv.Princeton.EDU" target="_blank">babase-bounces@eeblistserv.Princeton.EDU</a>
[mailto:<a href="mailto:babase-bounces@eeblistserv.Princeton.EDU" target="_blank">babase-bounces@eeblistserv.Princeton.EDU</a>] <b>On Behalf Of </b>Lacey
Roerish<br>
<b>Sent:</b> Friday, October 30, 2009 12:34 PM<br>
<b>To:</b> The Baboon Database Project<br>
<b>Subject:</b> [Babase] Statdate problem for End June 2009</span></p>
</div>
<div>
<div>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Hi
All!<br>
<br>
I am working on the uploads of data and have found june to
be a bit tricky. Since Courtney is often in the field collecting data on
'last days' when the team isn't doing a complete census, the 'censored'
statdate of individuals in Weaver's group is 6-27, however courtney has (at
least) agonism data for animals on 6/29. <br>
<br>
Is the best solution here to add demog notes? It looks like Courtney did a
partial census that day. I know we set up a rule that we wouldn't enter
her partial censuses unless a demographic change occured.. but maybe we should
add to this these special june and december cases where we are likely to have
interaction data corresponding with her partial census. If we don't use
that partial census, the animal's statdate is before its final interactions for
the 6 month update period.<br>
<br>
Let me know if I need to do anything on my end to make this happen so I can get
these data in.<br>
<br>
Thanks<br>
Lacey<br clear="all">
<br>
-- <br>
- -<br>
Lacey K. Maryott Roerish<br>
Alberts Lab<br>
Department of Biology<br>
Duke University<br>
ph: 919-660-7306<br>
fax: 919-660-7293<br>
<a href="mailto:Lacey.Maryott@duke.edu" target="_blank">Lacey.Maryott@duke.edu</a></p>
</div>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-bottom: 12pt;"><br>
_______________________________________________<br>
Babase mailing list<br>
<a href="mailto:Babase@www.eco.princeton.edu" target="_blank">Babase@www.eco.princeton.edu</a><br>
<a href="http://www.eco.princeton.edu/mailman/listinfo/babase" target="_blank">http://www.eco.princeton.edu/mailman/listinfo/babase</a></p>
</div>
<p class="MsoNormal"><br>
<br clear="all">
<br>
-- <br>
- -<br>
Lacey K. Maryott Roerish<br>
Alberts Lab<br>
Department of Biology<br>
Duke University<br>
ph: 919-660-7306<br>
fax: 919-660-7293<br>
<a href="mailto:Lacey.Maryott@duke.edu" target="_blank">Lacey.Maryott@duke.edu</a></p>
</div>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-bottom: 12pt;"><br>
_______________________________________________<br>
Babase mailing list<br>
<a href="mailto:Babase@www.eco.princeton.edu" target="_blank">Babase@www.eco.princeton.edu</a><br>
<a href="http://www.eco.princeton.edu/mailman/listinfo/babase" target="_blank">http://www.eco.princeton.edu/mailman/listinfo/babase</a></p>
</div>
<p class="MsoNormal"><br>
<br clear="all">
<br>
-- <br>
- -<br>
Lacey K. Maryott Roerish<br>
Alberts Lab<br>
Department of Biology<br>
Duke University<br>
ph: 919-660-7306<br>
fax: 919-660-7293<br>
<a href="mailto:Lacey.Maryott@duke.edu" target="_blank">Lacey.Maryott@duke.edu</a></p>
</div></div></div>
</div>
<br>_______________________________________________<br>
Babase mailing list<br>
<a href="mailto:Babase@www.eco.princeton.edu">Babase@www.eco.princeton.edu</a><br>
<a href="http://www.eco.princeton.edu/mailman/listinfo/babase" target="_blank">http://www.eco.princeton.edu/mailman/listinfo/babase</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>- -<br>Lacey K. Maryott Roerish<br>Alberts Lab<br>Department of Biology<br>Duke University<br>ph: 919-660-7306<br>fax: 919-660-7293<br><a href="mailto:Lacey.Maryott@duke.edu">Lacey.Maryott@duke.edu</a><br>