[Babase] Re: min/max weather file example
Karl O. Pinc
kop at meme.com
Tue Jan 20 02:27:55 EST 2009
On 01/14/2009 07:56:46 AM, kfenn wrote:
> Hi Karl,
>
> FWIW, this is the text file I uploaded to a table I made in
> babase_pending so you can also grab the same info from there. It's
> all our min/max data from the dinosaurs through the 08a update. I've
> just been appending the table with each 6 month update.
Tabby,
As you can see I'm not done with the weather tables just yet.
(See off-list email for scheduling a Tues phone call.)
I'm not far away, but I'm not done.
I've questions.
The tables are designed to hold temperature measurements
as read off the instrument, in either Fahrenheit or
Centigrade. I'd prefer to record the actual readings.
Looking over the data you sent I don't see any Fahrenheit
readings, and I know that readings were in Fahrenheit
for some years. Is there any way to recover the actual
data? (It's easy enough to have a query (or view)
convert everything to Centigrade when you want to
actually use the data.)
When the data is in Fahrenheit, what is the precision?
The current documentation does not say. I'm keeping
four decimal digits, 3 to the left of the decimal point
and 1 to the right. The Centigrade measurements are
supposed to be accurate to a tenth of a degree, but
this is probably not true for the Fahrenheit measurements
because it's a finer scale.
Is it ok if the view used for inserting and deleting
weather data cannot be used to update weather data?
Please read over the docs and see if you can catch anything
else. I've updated them (but have not put the view in the
docs yet).
Karl <kop at meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
More information about the Babase
mailing list