[Babase] WeatherHawk design review
Karl O. Pinc
kop at meme.com
Wed Jul 1 18:20:50 EDT 2009
Hi,
The WeatherHawk tables are ready for review. Mostly what
has changed from the babase_pending.whawk table is to
change some column names for consistency with the rest
of Babase, or so that the column name actually reflects
what's recorded in the column. The idea here
is to make it easier to get the data out of the database.
This means that it's a little
harder to get the data into the database because some of the
column names as supplied by the WeatherHawk must be changed
before the final spreadsheet is uploaded. I figure this is
not too much trouble because the column names need changing
anyway because you really don't want spaces in column names.
The whole thing should be easily scripted with an Excel
macro or some such.
The data entry staff was also adding the date as a column
to the WeatherHawk data. This still needs to be done,
and another column, representing the weather station
(the WeatherHawk) itself, also needs to be added.
Like the date column it's a constant
value. (In fact it's more constant than the date because it
does not change for any given weatherhawk.)
Note the table name is WHAWKS instead of the WHAWK
as in babase_pending because (almost) all the table
names in Babase are plural.
Please read:
The WStations documentation.
https://papio.biology.duke.edu/babase_system_html/ch06s05.html
This raises some design issues for consideration.
Also read the WHawks documentation.
https://papio.biology.duke.edu/babase_system_html/ch05s06.html
Aside from the questions that may be raised by the documentation
I've also the following concerns:
The YearRain column is an integer, whereas the DayRain column
has two decimal points of precision. It seems to me that
the precision of the DayRain column (even if the instrument
is not accurate enough to use all the precision) should be
carried through to the YearRain column. I do see data
values to the right of the decimal point in some of the
WeatherHawk daily rain values. There is no point if
the WeatherHawk does not report decimal points of
precision for annual rainfall, does it?
In the babase_pending schema the hourrain and 24hrrain
columns are integral, and again the dayrain column has
2 digits of precision. In the babase schema I've made
the hourrain and lst24hrrain columns have 2 decimal
points of precision, but it'll obviously not be
used if we just copy over the data from the babase_pending.whawk
table.
I don't know if there is data to the right of the
decimal point for the hourrain and 24hrrain columns
in the WeatherHawk data dumps. If there is then
my guess is that it's rounded (always rounded up
from .5) when it's loaded.
As a general rule the database performs a lot
better if the data is integral, where "a lot"
may or may not make any difference in practical
terms. If we can get rid of the decimal points
lets do so, but we surely want to keep them rather
than lose any information.
The following statement could be used to copy the
data from babase_pending to babase, but for the 2
problems noted below:
insert
into whawks (whwstation, whdaytime, winddir, windspeed
, windgust, hum_in, humidity, temp_in, temp
, barom, yearrain, et, battv, solar
, heat_lx_in, heatindex, dayrain, hourrain
, lst24hrrain, degheat, degcool, monthrain
, degheat_mo, degcool_mo)
select 'BC4', date + time, wind_dir, wind_spd, wind_gust
, hum_in, humidity, temp_in, temp, raw_barom
, tot_rain, coalesce(et, ev), battv, solar
, heat_lx_in, heat_index, dailyrain, hourrain
, "24hrrain", deg_heat, deg_cool, monthrain
, degheat_mo, degcool_mo
from babase_pending.whawk;
The first problem is that there is a row with a
date of '2005-07-02' and a time of '23:00' which
has NULLs for all the data values.
The second problem is that there are 703
duplicate dates and times. The list of duplicate dates and
times are attached. I've not looked to see if the
data is actually duplicated or just the dates
and times. If they are for 2 different WeatherHawk
units then we will want to use separate weather station
codes. This will probably involve re-uploading the
overlapping data from the original spreadsheets;
that's the only way I can think of to tell which
rows go with which unit. Otherwise we will want to
cleanup and delete the duplicates. The easiest way
might also involve re-uploading the data.
On another note: we could consider deleting those columns
that are meaningless, but then again just because
they're meaningless now does not mean that we'll
never have a use for them. Again, the database
performs "a lot" better when there's less data.
I'd lean toward getting
rid of at least some of them, but that may mean
more work getting the data ready to load into
Babase. The right way to do it would be to
somehow keep the WeatherHawk from reporting
the data in the first place but that may
mean fussing with something that's not broken,
which provides a good opportunity to introduce
breakage.
Finally, I don't have indexes on anything but date
and time. These are the only values likely to
be involved in a join. If there are ever performance
problems creating indexes would speed up
sorting and comparisons of other data values.
We can certainly do this need be.
Karl <kop at meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
-------------- next part --------------
whdaytime
---------------------
2006-05-29 00:00:00
2006-05-29 01:00:00
2006-05-29 02:00:00
2006-05-29 03:00:00
2006-05-29 04:00:00
2006-05-29 05:00:00
2006-05-29 06:00:00
2006-05-29 07:00:00
2006-05-29 08:00:00
2006-05-29 09:00:00
2006-05-29 10:00:00
2006-05-29 11:00:00
2006-05-29 12:00:00
2006-05-29 13:00:00
2006-05-29 14:00:00
2006-05-29 15:00:00
2006-05-29 16:00:00
2006-05-29 17:00:00
2006-05-29 18:00:00
2006-05-29 19:00:00
2006-05-29 20:00:00
2006-05-29 21:00:00
2006-05-29 22:00:00
2008-08-02 00:00:00
2008-08-02 01:00:00
2008-08-02 02:00:00
2008-08-02 03:00:00
2008-08-02 04:00:00
2008-08-02 05:00:00
2008-08-02 06:00:00
2008-08-02 07:00:00
2008-08-02 08:00:00
2008-08-02 09:00:00
2008-08-02 10:00:00
2008-08-02 11:00:00
2008-08-02 12:00:00
2008-08-02 13:00:00
2008-08-02 14:00:00
2008-08-02 15:00:00
2008-08-02 16:00:00
2008-08-02 17:00:00
2008-08-02 18:00:00
2008-08-02 19:00:00
2008-08-02 20:00:00
2008-08-02 21:00:00
2008-08-02 22:00:00
2008-08-03 00:00:00
2008-08-03 01:00:00
2008-08-03 02:00:00
2008-08-03 03:00:00
2008-08-03 04:00:00
2008-08-03 05:00:00
2008-08-03 06:00:00
2008-08-03 07:00:00
2008-08-03 08:00:00
2008-08-03 09:00:00
2008-08-03 10:00:00
2008-08-03 11:00:00
2008-08-03 12:00:00
2008-08-03 13:00:00
2008-08-03 14:00:00
2008-08-03 15:00:00
2008-08-03 16:00:00
2008-08-03 17:00:00
2008-08-03 18:00:00
2008-08-03 19:00:00
2008-08-03 20:00:00
2008-08-03 21:00:00
2008-08-03 22:00:00
2008-08-04 00:00:00
2008-08-04 01:00:00
2008-08-04 02:00:00
2008-08-04 03:00:00
2008-08-04 04:00:00
2008-08-04 05:00:00
2008-08-04 06:00:00
2008-08-04 07:00:00
2008-08-04 08:00:00
2008-08-04 09:00:00
2008-08-04 10:00:00
2008-08-04 11:00:00
2008-08-04 12:00:00
2008-08-04 13:00:00
2008-08-04 14:00:00
2008-08-04 15:00:00
2008-08-04 16:00:00
2008-08-04 17:00:00
2008-08-04 18:00:00
2008-08-04 19:00:00
2008-08-04 20:00:00
2008-08-04 21:00:00
2008-08-04 22:00:00
2008-08-05 00:00:00
2008-08-05 01:00:00
2008-08-05 02:00:00
2008-08-05 03:00:00
2008-08-05 04:00:00
2008-08-05 05:00:00
2008-08-05 06:00:00
2008-08-05 07:00:00
2008-08-05 08:00:00
2008-08-05 09:00:00
2008-08-05 10:00:00
2008-08-05 11:00:00
2008-08-05 12:00:00
2008-08-05 13:00:00
2008-08-05 14:00:00
2008-08-05 15:00:00
2008-08-05 16:00:00
2008-08-05 17:00:00
2008-08-05 18:00:00
2008-08-05 19:00:00
2008-08-05 20:00:00
2008-08-05 21:00:00
2008-08-05 22:00:00
2008-08-06 00:00:00
2008-08-06 01:00:00
2008-08-06 02:00:00
2008-08-06 03:00:00
2008-08-06 04:00:00
2008-08-06 05:00:00
2008-08-06 06:00:00
2008-08-06 07:00:00
2008-08-06 08:00:00
2008-08-06 09:00:00
2008-08-06 10:00:00
2008-08-06 11:00:00
2008-08-06 12:00:00
2008-08-06 13:00:00
2008-08-06 14:00:00
2008-08-06 15:00:00
2008-08-06 16:00:00
2008-08-06 17:00:00
2008-08-06 18:00:00
2008-08-06 19:00:00
2008-08-06 20:00:00
2008-08-06 21:00:00
2008-08-06 22:00:00
2008-08-07 00:00:00
2008-08-07 01:00:00
2008-08-07 02:00:00
2008-08-07 03:00:00
2008-08-07 04:00:00
2008-08-07 05:00:00
2008-08-07 06:00:00
2008-08-07 07:00:00
2008-08-07 08:00:00
2008-08-07 09:00:00
2008-08-07 10:00:00
2008-08-07 11:00:00
2008-08-07 12:00:00
2008-08-07 13:00:00
2008-08-07 14:00:00
2008-08-07 15:00:00
2008-08-07 16:00:00
2008-08-07 17:00:00
2008-08-07 18:00:00
2008-08-07 19:00:00
2008-08-07 20:00:00
2008-08-07 21:00:00
2008-08-07 22:00:00
2008-08-08 10:00:00
2008-08-08 11:00:00
2008-08-08 12:00:00
2008-08-08 13:00:00
2008-08-08 14:00:00
2008-08-08 15:00:00
2008-08-08 16:00:00
2008-08-08 17:00:00
2008-08-08 18:00:00
2008-08-08 19:00:00
2008-08-08 20:00:00
2008-08-08 21:00:00
2008-08-08 22:00:00
2008-08-09 00:00:00
2008-08-09 01:00:00
2008-08-09 02:00:00
2008-08-09 03:00:00
2008-08-09 04:00:00
2008-08-09 05:00:00
2008-08-09 06:00:00
2008-08-09 07:00:00
2008-08-09 08:00:00
2008-08-09 09:00:00
2008-08-09 10:00:00
2008-08-09 11:00:00
2008-08-09 12:00:00
2008-08-09 13:00:00
2008-08-09 14:00:00
2008-08-09 15:00:00
2008-08-09 16:00:00
2008-08-09 17:00:00
2008-08-09 18:00:00
2008-08-09 19:00:00
2008-08-09 20:00:00
2008-08-09 21:00:00
2008-08-09 22:00:00
2008-08-10 00:00:00
2008-08-10 01:00:00
2008-08-10 02:00:00
2008-08-10 03:00:00
2008-08-10 04:00:00
2008-08-10 05:00:00
2008-08-10 06:00:00
2008-08-10 07:00:00
2008-08-10 08:00:00
2008-08-10 09:00:00
2008-08-10 10:00:00
2008-08-10 11:00:00
2008-08-10 12:00:00
2008-08-10 13:00:00
2008-08-10 14:00:00
2008-08-10 15:00:00
2008-08-10 16:00:00
2008-08-10 17:00:00
2008-08-10 18:00:00
2008-08-10 19:00:00
2008-08-10 20:00:00
2008-08-10 21:00:00
2008-08-10 22:00:00
2008-08-11 00:00:00
2008-08-11 01:00:00
2008-08-11 02:00:00
2008-08-11 03:00:00
2008-08-11 04:00:00
2008-08-11 05:00:00
2008-08-11 06:00:00
2008-08-11 07:00:00
2008-08-11 08:00:00
2008-08-11 09:00:00
2008-08-11 10:00:00
2008-08-11 11:00:00
2008-08-11 12:00:00
2008-08-11 13:00:00
2008-08-11 14:00:00
2008-08-11 15:00:00
2008-08-11 16:00:00
2008-08-11 17:00:00
2008-08-11 18:00:00
2008-08-11 19:00:00
2008-08-11 20:00:00
2008-08-11 21:00:00
2008-08-11 22:00:00
2008-08-12 00:00:00
2008-08-12 01:00:00
2008-08-12 02:00:00
2008-08-12 03:00:00
2008-08-12 04:00:00
2008-08-12 05:00:00
2008-08-12 06:00:00
2008-08-12 07:00:00
2008-08-12 08:00:00
2008-08-12 09:00:00
2008-08-12 10:00:00
2008-08-12 11:00:00
2008-08-12 12:00:00
2008-08-12 13:00:00
2008-08-12 14:00:00
2008-08-12 15:00:00
2008-08-12 16:00:00
2008-08-12 17:00:00
2008-08-12 18:00:00
2008-08-12 19:00:00
2008-08-12 20:00:00
2008-08-12 21:00:00
2008-08-12 22:00:00
2008-08-13 00:00:00
2008-08-13 01:00:00
2008-08-13 02:00:00
2008-08-13 03:00:00
2008-08-13 04:00:00
2008-08-13 05:00:00
2008-08-13 06:00:00
2008-08-13 07:00:00
2008-08-13 08:00:00
2008-08-13 09:00:00
2008-08-13 10:00:00
2008-08-13 11:00:00
2008-08-13 12:00:00
2008-08-13 13:00:00
2008-08-13 14:00:00
2008-08-13 15:00:00
2008-08-13 16:00:00
2008-08-13 17:00:00
2008-08-13 18:00:00
2008-08-13 19:00:00
2008-08-13 20:00:00
2008-08-13 21:00:00
2008-08-13 22:00:00
2008-08-14 00:00:00
2008-08-14 01:00:00
2008-08-14 02:00:00
2008-08-14 03:00:00
2008-08-14 04:00:00
2008-08-14 05:00:00
2008-08-14 06:00:00
2008-08-14 07:00:00
2008-08-14 08:00:00
2008-08-14 09:00:00
2008-08-14 10:00:00
2008-08-14 11:00:00
2008-08-14 12:00:00
2008-08-14 13:00:00
2008-08-14 14:00:00
2008-08-14 15:00:00
2008-08-14 16:00:00
2008-08-14 17:00:00
2008-08-14 18:00:00
2008-08-14 19:00:00
2008-08-14 20:00:00
2008-08-14 21:00:00
2008-08-14 22:00:00
2008-08-15 00:00:00
2008-08-15 01:00:00
2008-08-15 02:00:00
2008-08-15 03:00:00
2008-08-15 04:00:00
2008-08-15 05:00:00
2008-08-15 06:00:00
2008-08-15 07:00:00
2008-08-15 08:00:00
2008-08-15 09:00:00
2008-08-15 10:00:00
2008-08-15 11:00:00
2008-08-15 12:00:00
2008-08-15 13:00:00
2008-08-15 14:00:00
2008-08-15 15:00:00
2008-08-15 16:00:00
2008-08-15 17:00:00
2008-08-15 18:00:00
2008-08-15 19:00:00
2008-08-15 20:00:00
2008-08-15 21:00:00
2008-08-15 22:00:00
2008-08-16 00:00:00
2008-08-16 01:00:00
2008-08-16 02:00:00
2008-08-16 03:00:00
2008-08-16 04:00:00
2008-08-16 05:00:00
2008-08-16 06:00:00
2008-08-16 07:00:00
2008-08-16 08:00:00
2008-08-16 09:00:00
2008-08-16 10:00:00
2008-08-16 11:00:00
2008-08-16 12:00:00
2008-08-16 13:00:00
2008-08-16 14:00:00
2008-08-16 15:00:00
2008-08-16 16:00:00
2008-08-16 17:00:00
2008-08-16 18:00:00
2008-08-16 19:00:00
2008-08-16 20:00:00
2008-08-16 21:00:00
2008-08-16 22:00:00
2008-08-17 00:00:00
2008-08-17 01:00:00
2008-08-17 02:00:00
2008-08-17 03:00:00
2008-08-17 04:00:00
2008-08-17 05:00:00
2008-08-17 06:00:00
2008-08-17 07:00:00
2008-08-17 08:00:00
2008-08-17 09:00:00
2008-08-17 10:00:00
2008-08-17 11:00:00
2008-08-17 12:00:00
2008-08-17 13:00:00
2008-08-17 14:00:00
2008-08-17 15:00:00
2008-08-17 16:00:00
2008-08-17 17:00:00
2008-08-17 18:00:00
2008-08-17 19:00:00
2008-08-17 20:00:00
2008-08-17 21:00:00
2008-08-17 22:00:00
2008-08-18 00:00:00
2008-08-18 01:00:00
2008-08-18 02:00:00
2008-08-18 03:00:00
2008-08-18 04:00:00
2008-08-18 05:00:00
2008-08-18 06:00:00
2008-08-18 07:00:00
2008-08-18 08:00:00
2008-08-18 09:00:00
2008-08-18 10:00:00
2008-08-18 11:00:00
2008-08-18 12:00:00
2008-08-18 13:00:00
2008-08-18 14:00:00
2008-08-18 15:00:00
2008-08-18 16:00:00
2008-08-18 17:00:00
2008-08-18 18:00:00
2008-08-18 19:00:00
2008-08-18 20:00:00
2008-08-18 21:00:00
2008-08-18 22:00:00
2008-08-19 00:00:00
2008-08-19 01:00:00
2008-08-19 02:00:00
2008-08-19 03:00:00
2008-08-19 04:00:00
2008-08-19 05:00:00
2008-08-19 06:00:00
2008-08-19 07:00:00
2008-08-19 08:00:00
2008-08-19 09:00:00
2008-08-19 10:00:00
2008-08-19 11:00:00
2008-08-19 12:00:00
2008-08-19 13:00:00
2008-08-19 14:00:00
2008-08-19 15:00:00
2008-08-19 16:00:00
2008-08-19 17:00:00
2008-08-19 18:00:00
2008-08-19 19:00:00
2008-08-19 20:00:00
2008-08-19 21:00:00
2008-08-19 22:00:00
2008-08-20 00:00:00
2008-08-20 01:00:00
2008-08-20 02:00:00
2008-08-20 03:00:00
2008-08-20 04:00:00
2008-08-20 05:00:00
2008-08-20 06:00:00
2008-08-20 07:00:00
2008-08-20 08:00:00
2008-08-20 09:00:00
2008-08-20 10:00:00
2008-08-20 11:00:00
2008-08-20 12:00:00
2008-08-20 13:00:00
2008-08-20 14:00:00
2008-08-20 15:00:00
2008-08-20 16:00:00
2008-08-20 17:00:00
2008-08-20 18:00:00
2008-08-20 19:00:00
2008-08-20 20:00:00
2008-08-20 21:00:00
2008-08-20 22:00:00
2008-08-21 00:00:00
2008-08-21 01:00:00
2008-08-21 02:00:00
2008-08-21 03:00:00
2008-08-21 04:00:00
2008-08-21 05:00:00
2008-08-21 06:00:00
2008-08-21 07:00:00
2008-08-21 08:00:00
2008-08-21 09:00:00
2008-08-21 10:00:00
2008-08-21 11:00:00
2008-08-21 12:00:00
2008-08-21 13:00:00
2008-08-21 14:00:00
2008-08-21 15:00:00
2008-08-21 16:00:00
2008-08-21 17:00:00
2008-08-21 18:00:00
2008-08-21 19:00:00
2008-08-21 20:00:00
2008-08-21 21:00:00
2008-08-21 22:00:00
2008-08-22 00:00:00
2008-08-22 01:00:00
2008-08-22 02:00:00
2008-08-22 03:00:00
2008-08-22 04:00:00
2008-08-22 05:00:00
2008-08-22 06:00:00
2008-08-22 07:00:00
2008-08-22 08:00:00
2008-08-22 09:00:00
2008-08-22 10:00:00
2008-08-22 11:00:00
2008-08-22 12:00:00
2008-08-22 13:00:00
2008-08-22 14:00:00
2008-08-22 15:00:00
2008-08-22 16:00:00
2008-08-22 17:00:00
2008-08-22 18:00:00
2008-08-22 19:00:00
2008-08-22 20:00:00
2008-08-22 21:00:00
2008-08-22 22:00:00
2008-08-23 00:00:00
2008-08-23 01:00:00
2008-08-23 02:00:00
2008-08-23 03:00:00
2008-08-23 04:00:00
2008-08-23 05:00:00
2008-08-23 06:00:00
2008-08-23 07:00:00
2008-08-23 08:00:00
2008-08-23 09:00:00
2008-08-23 10:00:00
2008-08-23 11:00:00
2008-08-23 12:00:00
2008-08-23 13:00:00
2008-08-23 14:00:00
2008-08-23 15:00:00
2008-08-23 16:00:00
2008-08-23 17:00:00
2008-08-23 18:00:00
2008-08-23 19:00:00
2008-08-23 20:00:00
2008-08-23 21:00:00
2008-08-23 22:00:00
2008-08-24 00:00:00
2008-08-24 01:00:00
2008-08-24 02:00:00
2008-08-24 03:00:00
2008-08-24 04:00:00
2008-08-24 05:00:00
2008-08-24 06:00:00
2008-08-24 07:00:00
2008-08-24 08:00:00
2008-08-24 09:00:00
2008-08-24 10:00:00
2008-08-24 11:00:00
2008-08-24 12:00:00
2008-08-24 13:00:00
2008-08-24 14:00:00
2008-08-24 15:00:00
2008-08-24 16:00:00
2008-08-24 17:00:00
2008-08-24 18:00:00
2008-08-24 19:00:00
2008-08-24 20:00:00
2008-08-24 21:00:00
2008-08-24 22:00:00
2008-08-25 00:00:00
2008-08-25 01:00:00
2008-08-25 02:00:00
2008-08-25 03:00:00
2008-08-25 04:00:00
2008-08-25 05:00:00
2008-08-25 06:00:00
2008-08-25 07:00:00
2008-08-25 08:00:00
2008-08-25 09:00:00
2008-08-25 10:00:00
2008-08-25 11:00:00
2008-08-25 12:00:00
2008-08-25 13:00:00
2008-08-25 14:00:00
2008-08-25 15:00:00
2008-08-25 16:00:00
2008-08-25 17:00:00
2008-08-25 18:00:00
2008-08-25 19:00:00
2008-08-25 20:00:00
2008-08-25 21:00:00
2008-08-25 22:00:00
2008-08-26 00:00:00
2008-08-26 01:00:00
2008-08-26 02:00:00
2008-08-26 03:00:00
2008-08-26 04:00:00
2008-08-26 05:00:00
2008-08-26 06:00:00
2008-08-26 07:00:00
2008-08-26 08:00:00
2008-08-26 09:00:00
2008-08-26 10:00:00
2008-08-26 11:00:00
2008-08-26 12:00:00
2008-08-26 13:00:00
2008-08-26 14:00:00
2008-08-26 15:00:00
2008-08-26 16:00:00
2008-08-26 17:00:00
2008-08-26 18:00:00
2008-08-26 19:00:00
2008-08-26 20:00:00
2008-08-26 21:00:00
2008-08-26 22:00:00
2008-08-27 00:00:00
2008-08-27 01:00:00
2008-08-27 02:00:00
2008-08-27 03:00:00
2008-08-27 04:00:00
2008-08-27 05:00:00
2008-08-27 06:00:00
2008-08-27 07:00:00
2008-08-27 08:00:00
2008-08-27 09:00:00
2008-08-27 10:00:00
2008-08-27 11:00:00
2008-08-27 12:00:00
2008-08-27 13:00:00
2008-08-27 14:00:00
2008-08-27 15:00:00
2008-08-27 16:00:00
2008-08-27 17:00:00
2008-08-27 18:00:00
2008-08-27 19:00:00
2008-08-27 20:00:00
2008-08-27 21:00:00
2008-08-27 22:00:00
2008-08-28 00:00:00
2008-08-28 01:00:00
2008-08-28 02:00:00
2008-08-28 03:00:00
2008-08-28 04:00:00
2008-08-28 05:00:00
2008-08-28 06:00:00
2008-08-28 07:00:00
2008-08-28 08:00:00
2008-08-28 09:00:00
2008-08-28 10:00:00
2008-08-28 11:00:00
2008-08-28 12:00:00
2008-08-28 13:00:00
2008-08-28 14:00:00
2008-08-28 15:00:00
2008-08-28 16:00:00
2008-08-28 17:00:00
2008-08-28 18:00:00
2008-08-28 19:00:00
2008-08-28 20:00:00
2008-08-28 21:00:00
2008-08-28 22:00:00
2008-08-29 00:00:00
2008-08-29 01:00:00
2008-08-29 02:00:00
2008-08-29 03:00:00
2008-08-29 04:00:00
2008-08-29 05:00:00
2008-08-29 06:00:00
2008-08-29 07:00:00
2008-08-29 08:00:00
2008-08-29 09:00:00
2008-08-29 10:00:00
2008-08-29 11:00:00
2008-08-29 12:00:00
2008-08-29 13:00:00
2008-08-29 14:00:00
2008-08-29 15:00:00
2008-08-29 16:00:00
2008-08-29 17:00:00
2008-08-29 18:00:00
2008-08-29 19:00:00
2008-08-29 20:00:00
2008-08-29 21:00:00
2008-08-29 22:00:00
2008-08-30 00:00:00
2008-08-30 01:00:00
2008-08-30 02:00:00
2008-08-30 03:00:00
2008-08-30 04:00:00
2008-08-30 05:00:00
2008-08-30 06:00:00
2008-08-30 07:00:00
2008-08-30 08:00:00
2008-08-30 09:00:00
2008-08-30 10:00:00
2008-08-30 11:00:00
2008-08-30 12:00:00
2008-08-30 13:00:00
2008-08-30 14:00:00
2008-08-30 15:00:00
2008-08-30 16:00:00
2008-08-30 17:00:00
2008-08-30 18:00:00
2008-08-30 19:00:00
2008-08-30 20:00:00
2008-08-30 21:00:00
2008-08-30 22:00:00
2008-08-31 00:00:00
2008-08-31 01:00:00
2008-08-31 02:00:00
2008-08-31 03:00:00
2008-08-31 04:00:00
2008-08-31 05:00:00
2008-08-31 06:00:00
2008-08-31 07:00:00
2008-08-31 08:00:00
2008-08-31 09:00:00
2008-08-31 10:00:00
2008-08-31 11:00:00
2008-08-31 12:00:00
2008-08-31 13:00:00
2008-08-31 14:00:00
2008-08-31 15:00:00
2008-08-31 16:00:00
2008-08-31 17:00:00
2008-08-31 18:00:00
2008-08-31 19:00:00
2008-08-31 20:00:00
2008-08-31 21:00:00
2008-08-31 22:00:00
(703 rows)
More information about the Babase
mailing list