Foodcodes, Was: Re: [Babase] FPSAMPS Kidcontact and
Kidsuckle blanks
Jeanne Altmann
babase@www.eco.princeton.edu
Mon, 08 Nov 2004 10:58:23 -0500
Sounds good,
jeanne
At 06:31 PM 11/7/2004 -0600, you wrote:
>On 2004.10.27 06:10 Susan Alberts wrote:
>>This is a very belated reply, sorry.
>
>Likewise, likewise. :-)
>
>>
>>>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.
>>
>>There is an option to enter an extended comment. They press *, then O,
>>then describe the interaction. There was no way to get around this one
>>relatively free-form type of entry.
>
>Ah, right. These are the ADLIBS table. Not a problem.
>
>
>>
>>>Which reminds me, arn't foodcodes single character codes that
>>>are 'lumped' together as a muti-character string?
>>
>>Yes basically although it is not the case that each column within the
>>field is equivalent across food codes.
>>
>>>This will make them hard to validate and I'd imagine odd
>>>to query.
>>
>>They are odd to query, it is not at all trivial. However, the codes
>>themselves are part of a rather deeply entrenched system of food codes
>>that were started decades ago by Stuart so i don't think changing is a
>>good option at this point.
>
>I'm making them into a table. This makes them easy to validate and
>you can add new ones when you like. We can make additional columns
>in the food code table to make things easier to query if you've
>got catagories, or rather alternate-catagories, as I've added a Ftype
>column and another support table (FOODTYPES) to support the
>foodcodes. This should help with querying.
>
>I'm using your attached document to populate the FOODCODES and
>FOODTYPES table for the conversion.
>
>Karl <kop@meme.com>
>Free Software: "You don't pay back, you pay forward."
> -- Robert A. Heinlein
>_______________________________________________
>Babase mailing list
>Babase@www.eco.princeton.edu
>http://www.eco.princeton.edu/mailman/listinfo/babase