[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