[Babase] rain gauge rounding

Niki Learn nlearn at princeton.edu
Wed Jul 29 15:30:23 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.

Karl wrote:
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:
Ah.  Maybe that is why the numbers are off more than we expected - who
knows?  I can probably do the rounding - then I can also take a short time
to add the most recent data before I upload.  

What is the best way to delete the previously uploaded version?




More information about the Babase mailing list