[Babase] Re: min_max - leave out records with no data?

kfenn kfenn at princeton.edu
Wed Apr 22 14:48:37 EDT 2009


Karl O. Pinc wrote:
>
> On 04/22/2009 01:15:50 PM, kfenn wrote:
>> Hi Karl,
>>
>> Can you just confirm for me that we should NOT create a record for 
>> days where there were no min_max or precip readings?  In the old 
>> data, I think we had rows for the all the days...regardless of 
>> whether they had data.
>
> You do not want to enter rows with no data unless you want rows
> with no data in the database, which you don't.  (You and I once
> went over this with Jeanne.)
>
>>
>> Also, I need to use NULL wherever a min_max or precip reading is 
>> absent....right ? (this is assuming I've created a row because one of 
>> the readings does exist, but not both).
>
> You do need to use NULL when you have no data.  That includes
> where you have no notes for the weather reading.  You are
> free to use any value you like to mean NULL, so long as
> you tell the upload program what it is.  I once might
> have recommended using GWB for null data, but these
> days you probably want to take the easy way out and
> have no data mean NULL to the upload program.
>
> (Why not the list?)
Yes, why not the list ( ...maybe because I didn't want to lose the reply 
in a sea of Babase emails?)

Tabby

-- 
Tabby Fenn
Research Assistant

Dept of Ecology and Evolutionary Biology
401 Guyot Hall
Princeton University
Princeton, NJ  08544

609 258-6898 (Ph)
609 258-2712 (Fx)



More information about the Babase mailing list