Perfect Tom, thanks!
Op zaterdag 30 mei 2020 14:46:48 UTC+2 schreef Tom Keffer: > > Hello, Maarten > > I am not familiar with Belchertown, but wanted to note that there is a > 'cumulative' aggregation type. Belchertown may have a different way of > doing things, but for a normal WeeWX plot > > [[[monthdroughtcum]]] > plot_type = bar > [[[[drought]]]] > aggregate_type = cumulative > label = Drought (cumulative) > > would give you a plot of accumulated 'drought' for the month. > > -tk > > On Sat, May 30, 2020 at 3:39 AM Maarten van der Hoeven <[email protected] > <javascript:>> wrote: > >> Hi, >> >> I wrote an extension to weewx, that calculates the amount of drought >> (evapotranspiration minus rain). Basilcally, drought is a 'bucket'-type. >> Every time a rain-tick of an evaotranspiration (ET)-calculation (on top >> every hour), drought is calculated as ET minus rain. I am talking about a >> Davis Vantage Pro. It's an extension on schema_extended >> >> I saw that the Belchertown skin calculates rainTotal, to use that >> variable to draw an accumulated (growing when rain occurs during the year) >> rain graph. >> >> I also want to plot the drought-variable as an accumulated value, just >> like rainTotal. Is this possible in the graph.conf file, to achieve this? >> Or do I need an calculation by myself, and store that accumulated value in >> another column (for example, droughtyear)? >> >> I have added a column 'drought' to the archive table, also a table is >> created 'archive_day_drought'. All is populated using the weewx-services; >> this is working very well. Only question is: how to plot the accumulated >> drought as a graph. >> >> Archive table (see at the end, *drought*): >> | dateTime | usUnits | interval | altimeter | >> appTemp | appTemp1 | barometer | batteryStatus1 | >> batteryStatus2 | batteryStatus3 | batteryStatus4 | batteryStatus5 | >> batteryStatus6 | batteryStatus7 | batteryStatus8 | cloudbase | >> co | co2 | consBatteryVoltage | dewpoint | dewpoint1 | ET | >> extraHumid1 | extraHumid2 | extraHumid3 | extraHumid4 | extraHumid5 | >> extraHumid6 | extraHumid7 | extraHumid8 | extraTemp1 | extraTemp2 | >> extraTemp3 | extraTemp4 | extraTemp5 | extraTemp6 | extraTemp7 | extraTemp8 >> | forecast | hail | hailBatteryStatus | hailRate | heatindex | >> heatindex1 | heatingTemp | heatingVoltage | humidex | >> humidex1 | inDewpoint | inHumidity | inTemp | >> inTempBatteryStatus | leafTemp1 | leafTemp2 | leafWet1 | leafWet2 | >> lightning_distance | lightning_disturber_count | lightning_energy | >> lightning_noise_count | lightning_strike_count | luminosity | maxSolarRad | >> nh3 | no2 | noise | o3 | outHumidity | outTemp | >> outTempBatteryStatus | pb | pm10_0 | pm1_0 | pm2_5 | pressure | >> radiation | rain | rainBatteryStatus | rainRate | >> referenceVoltage | rxCheckPercent | signal1 | signal2 | signal3 | >> signal4 | signal5 | signal6 | signal7 | signal8 | snow | snowBatteryStatus >> | snowDepth | snowMoisture | snowRate | so2 | soilMoist1 | soilMoist2 | >> soilMoist3 | soilMoist4 | soilTemp1 | soilTemp2 | soilTemp3 | soilTemp4 | >> supplyVoltage | txBatteryStatus | UV | uvBatteryStatus >> | windBatteryStatus | windchill | windDir | >> windGust | windGustDir | windrun >> | windSpeed | *drought* | >> >> Live data: >> +-------------------------+---------+--------+------+ >> | from_unixtime(dateTime) | drought | ET | rain | >> +-------------------------+---------+--------+------+ >> >> | 2020-05-30 12:05:00 | 0 | 0 | 0 | >> | 2020-05-30 12:04:00 | 0 | 0 | 0 | >> | 2020-05-30 12:03:00 | 0 | 0 | 0 | >> | 2020-05-30 12:02:00 | 0 | 0 | 0 | >> | 2020-05-30 12:01:00 | 0 | 0 | 0 | >> | 2020-05-30 12:00:00 | 0.4826 | 0.4826 | 0 | >> | 2020-05-30 11:59:00 | 0 | 0 | 0 | >> | 2020-05-30 11:58:00 | 0 | 0 | 0 | >> | 2020-05-30 11:57:00 | 0 | 0 | 0 | >> +-------------------------+---------+--------+------+ >> >> >> Archive table archive_day_drought, live data: >> >> mysql> select >> from_unixtime(datetime),min,mintime,max,maxtime,sum,count,wsum,sumtime from >> archive_day_drought order by datetime desc limit 10; >> >> +-------------------------+--------+------------+---------------------+------------+--------------------+-------+---------------------+---------+ >> | from_unixtime(datetime) | min | mintime | max | >> maxtime | sum | count | wsum | sumtime | >> >> +-------------------------+--------+------------+---------------------+------------+--------------------+-------+---------------------+---------+ >> | 2020-05-30 00:00:00 | 0 | 1590789660 | 0.4826 | >> 1590832800 | 1.6256 | 756 | 97.536 | 45360 | >> | 2020-05-29 00:00:00 | 0 | 1590703260 | 0.5334 | >> 1590757200 | 5.206999999999999 | 1440 | 312.42 | 86400 | >> | 2020-05-28 00:00:00 | 0 | 1590616860 | 0.5588 | >> 1590670800 | 5.029200000000001 | 1435 | 301.752 | 86100 | >> | 2020-05-27 00:00:00 | 0 | 1590530460 | 0.4826 | >> 1590577200 | 4.4196 | 1437 | 265.17600000000004 | 86220 | >> | 2020-05-26 00:00:00 | 0 | 1590444060 | 0.508 | >> 1590498000 | 4.572 | 1440 | 274.31999999999994 | 86400 | >> | 2020-05-25 00:00:00 | -0.254 | 1590388620 | 0.3302 | >> 1590415200 | 2.5907999999999998 | 1440 | 155.448 | 86400 | >> | 2020-05-24 00:00:00 | -0.254 | 1590312540 | 0.22859999999999997 | >> 1590307200 | -4.648199999999999 | 1315 | -278.89200000000005 | 78900 | >> | 2020-05-23 00:00:00 | 0 | 1590184860 | 0.5334 | >> 1590235200 | 5.1053999999999995 | 1424 | 306.324 | 85440 | >> | 2020-05-22 00:00:00 | 0 | 1590098460 | 0.4064 | >> 1590148800 | 3.1750000000000003 | 1440 | 190.50000000000003 | 86400 | >> | 2020-05-21 00:00:00 | 0 | 1590012060 | 0.5334 | >> 1590066000 | 4.978400000000001 | 1440 | 298.704 | 86400 | >> >> +-------------------------+--------+------------+---------------------+------------+--------------------+-------+---------------------+---------+ >> 10 rows in set (0.00 sec) >> >> -- >> You received this message because you are subscribed to the Google Groups >> "weewx-user" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/weewx-user/1b6a65b8-c050-4801-bec0-00653be0a28b%40googlegroups.com >> >> <https://groups.google.com/d/msgid/weewx-user/1b6a65b8-c050-4801-bec0-00653be0a28b%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/7dd66a50-75f6-4387-a235-c1e525629a7b%40googlegroups.com.
