[Babase] Foodcodes table?

Catherine Markham amarkham at princeton.edu
Fri Feb 17 15:26:11 EST 2006


Hi Leah,

I'll send you the info on food codes that Daphne compiled before she 
left (I'll do that to your email address in just a second).  I'm not 
sure how this compares to what would be on Karl's list, so wanted to 
make sure you had both lists.

Catherine

Karl O. Pinc wrote:

> 
> On 02/17/2006 11:25:55 AM, Leah Gerber wrote:
> 
>> Karl,
>>
>> I am trying to look through a list of the valid foodcodes in Babase.  
>> I can't find a support table with the foodcodes. Do you have one that  
>> i could take a look at?
> 
> 
> This works on papio in the babase_copy database (where everything is
> at the moment.)
> 
> select * from foodcodes, foodtypes
>  where foodcodes.ftype = foodtypes.ftype order by fcode;
> 
> 
> I just took what was in the monitoring guide and coded it into
> the conversion script.  (Actually I've a tab delimited text
> file, but that's awkward to look at.)
> 
> (If you want text try this at the Unix prompt:
>  psql -d babase_copy -c 'select * from foodcodes, foodtypes
>  where foodcodes.ftype = foodtypes.ftype order by fcode;'
> 
> or
>  psql --pset border=0 -d babase_copy -c 'select *
>  from foodcodes, foodtypes
>  where foodcodes.ftype = foodtypes.ftype order by fcode;'
> )
> 
> Karl <kop at meme.com>
> Free Software:  "You don't pay back, you pay forward."
>                  -- Robert A. Heinlein
> 
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase


-- 
Catherine Markham
Department of Ecology and Evolutionary Biology
Princeton University
Phone: (609) 258-6898
Fax: (609) 258-2712


More information about the Babase mailing list