[Babase] rain gauge rounding
Karl O. Pinc
kop at meme.com
Wed Jul 29 15:22:38 EDT 2009
On 07/29/2009 01:01:20 PM, Niki Learn wrote:
> Now for the technicalities, for the record.
>
> Niki and I will have to work out re-doing what Tabby and
> I did, I think. Because I recall running the weather
> data through some program or another and one of the things
> that was done was to round the rain data to the nearest
> mm. Either we can re-do/re-enter everything, or do something
> to just update the rain data. Niki, what do you think?
>
> Niki writes:
> Yes, I saw in the old babase emails something about a file you had
> sent
> Tabby that contained rain data with rounded numbers but I am not
> finding
> that file. The one I found in the folder marked as uploaded to
> babase
> had
> the rain data with 1-2 decimals (depending on year). That's why it
> seemed
> to me that it must have been uploaded that way and that babase then
> rounded
> the numbers. Can you confirm this one way or the other? Either way
> I
> have
> the file with the unrounded numbers so if we need to do something to
> that to
> make all the numbers have one decimal place, I can easily supply it.
> I can
> even add through June this year with little effort so we're all up to
> date.
Postgres rounds, but it rounds up rather than rounding to
the even. Maybe that's why the numbers are off?
If we want to round to the even you can supply me with the data
files and I can round to the even, or you can in excel, and
then re-upload the data.
> Niki writes:
> It definitely sounds like having it in tenths of a mm would be
> confusing.
> The temperature in the same table has one decimal place already so I
> would
> stick with the decimal for rain too. I have had no problems with the
> speed
> of this table when using it.
Let's do it in mm then.
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