[Babase] FPSAMPS Kidcontact and Kidsuckle blanks
Karl O. Pinc
babase@www.eco.princeton.edu
Wed, 13 Oct 2004 14:17:44 -0500
On 2004.10.13 04:19 Susan Alberts wrote:
>>
>>
>> This all presumes that the data that goes into the corresponding
>> columns of FPSAMPS and JPSAMPS are encoded the same way. For
>> example the two Foodcode columns should have the same codes for
>> the same food. If not let me know and we'll figure out a way
>> to deal with this.
>
>
> Yes, the fields that have the same names generally have the same
> meaning. The exception is neighbors, but i don't think this will
> affect our decision to merge them. For juveniles, we collect the
> three nearest neighbors no matter what their ID or age/sex class, and
> the three fields (nearest, next, next) will always be different. For
> adult females, we collect the nearest neighbor and then the nearest
> adults, so the second field could be the same as the first.
>
> However, while this is an issue that we have to know in retrieving
> the data, I am not sure that we need to have it affect how the data
> are stored. Karl, what are your opinions on this? Have i been clear?
Yes. This is clear. I don't think it effects how the data is
stored. I can encode these rules into the database.
>
>
>
>>
>> As far as "bad data" goes, the database is not checking for bad
>> data. It probably should, but I don't know what good data looks
>> like,
>> I just rely on the Psion to get the data right. We do want the
>> ability to make manual corrections (right?) in which case the
>> database should be checking.
>
>
> Yes my feeling is that we do want the ability to make manual
> corrections.
That's good, but then you should also be keeping the original
Psion data somewhere or else they'll be no record of what's
actually recorded in the field. Is this happening?
>
>> That would mean the bad data would
>> need cleaning before the conversion. However, AFIK, there's
>> no description of each column as the other tables have so I've
>> nothing to go on to write the rules. Comment anybody?
>
>
> I've attached a document that describes the content of each field in
> the point samples, from the point of view of data collectors. I
> pulled this out of our monitoring guide. Let us know if you need more
> info - I may have misunderstood waht you were asking above.
This looks right.
What does "- If "Other social" is recorded in the point sample, the
nature of the social interaction is recorded.. - If the food being
eaten is Other or Unknown, notes on the food are recorded."
mean? That is, what's recorded where? Is this a demography note?
I didn't think Psions took comments.
The foodcodes are not listed.
Which reminds me, arn't foodcodes single character codes that
are 'lumped' together as a muti-character string?
This will make them hard to validate and I'd imagine odd
to query.
I'll write back with more questions if I have any as I do
the work.
Karl <kop@meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein