[Babase] WeatherHawk design review

Niki Learn nlearn at princeton.edu
Tue Jul 7 10:11:23 EDT 2009


It looks like you deleted the duplicates too?  I am having difficulty
telling for sure since the dates are somewhat out of order now (at least in
2008).  How do I get babase to return all results for a single date,
regardless of time stamp?  I tried just using the date and it only gives me
00:00:00 (why are there seconds in the time stamp anyway?) and no other
times.  I tried some wildcards and bits of stuff from the SQL you sent to
look up other things but with no luck.  Are you sure separate dates and
times aren't easier for the end users?  I couldn't figure out how to get it
to return all results the month of August 2008 either.

Btw, there is a paper weatherhawk log that includes a column for upload to
babase_pending.  Tabby uploaded everything through September 2008 before I
arrived, so I guess we just added October - December 2008.  The log says she
uploaded August and September on 2008-11-07 and that July and August were
uploaded on 2008-09-24.  She would have had all of the August data in
September.  Maybe she forgot to log that she uploaded August too and then
uploaded it again in November?  That's my best guess anyway unless there was
some kind of freak uploading glitch that caused it to upload twice.

-----Original Message-----
From: babase-bounces at eeblistserv.Princeton.EDU
[mailto:babase-bounces at eeblistserv.Princeton.EDU] On Behalf Of Karl O. Pinc
Sent: Monday, July 06, 2009 6:23 PM
To: The Baboon Database Project
Subject: Re: [Babase] WeatherHawk design review


On 07/06/2009 02:32:07 PM, Niki Learn wrote:


> Also, while poking around for the duplicates, I noticed that there is
> NO
> data in the whawks table for 2300 hours.  This probably explains why
> you
> weren't getting any rain for that hour in your queries.  I don't know
> why
> this should be.  My only theory is that you somehow deleted all 2300
> data
> when getting rid of the blank row for 2005-07-02?

That is exactly what happened.   I've recopied the data and
now there's data for 23:00.   Thanks for catching that.


Karl <kop at meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein

_______________________________________________
Babase mailing list
Babase at www.eco.princeton.edu
http://www.eco.princeton.edu/mailman/listinfo/babase



More information about the Babase mailing list