Graph with the days at more than a certain temperature in the month or in the year in Belchertown

[enu...@gmail.com]

Is there a way to make a graphic like the one I ask for with the bechertown skin?
I do not get it

[enu...@gmail.com]

It seems easy but i don't get it. I try with aggregate_type = max_ge(25,"degree_C") buy it don't work

[Tom Keffer]

If your question is a general one, and not specific to the Belchertown skin, you already have a thread going on this topic. https://groups.google.com/g/weewx-user/c/8jmtc7RASgo/m/9WQ5vhbjAQAJ

Or, is your question specific to the Belchertown skin? In that case, I'm not familiar enough with the skin to help you.

--
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 weewx-user+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/9de082d7-1298-4382-829d-910c8db567cdn%40googlegroups.com.

[enu...@gmail.com]

Thank you very much. but it don't works in belchertown. It gives this error:

Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine: Caught unrecoverable exception in generator 'user.belchertown.HighchartsJsonGenerator'
Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine:         ****  Error trying to use database binding wx_binding to graph observation outTemp. Error was: no such column: None.
Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine:         ****  Traceback (most recent call last):
Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine:         ****    File "/usr/share/weewx/weedb/sqlite.py", line 39, in guarded_fn
Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine:         ****      return fn(*args, **kwargs)
Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine:         ****    File "/usr/share/weewx/weedb/sqlite.py", line 233, in execute
Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine:         ****      return sqlite3.Cursor.execute(self, *args, **kwargs)
Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine:         ****  sqlite3.OperationalError: no such column: None
Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine:         ****
Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine:         ****  During handling of the above exception, another exception occurred:
Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine:         ****
Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine:         ****  Traceback (most recent call last):
Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine:         ****    File "/usr/share/weewx/user/belchertown.py", line 3790, in get_observation_data
Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine:         ****      (time_start_vt, time_stop_vt, obs_vt) = weewx.xtypes.get_series(
Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine:         ****    File "/usr/share/weewx/weewx/xtypes.py", line 100, in get_series
Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine:         ****      return xtype.get_series(obs_type, timespan, db_manager, aggregate_type,
Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine:         ****    File "/usr/share/weewx/weewx/xtypes.py", line 167, in get_series
Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine:         ****      agg_vt = get_aggregate(obs_type, stamp, do_aggregate, db_manager)
Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine:         ****    File "/usr/share/weewx/weewx/xtypes.py", line 127, in get_aggregate
Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine:         ****      return xtype.get_aggregate(obs_type, timespan, aggregate_type, db_manager,
Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine:         ****    File "/usr/share/weewx/weewx/xtypes.py", line 551, in get_aggregate
Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine:         ****      row = db_manager.getSql(DailySummaries.agg_sql_dict[aggregate_type] % inter_dict)
Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine:         ****    File "/usr/share/weewx/weewx/manager.py", line 579, in getSql
Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine:         ****      _cursor.execute(sql, sqlargs)
Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine:         ****    File "/usr/share/weewx/weedb/sqlite.py", line 51, in guarded_fn
Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine:         ****      raise weedb.NoColumnError(e)
Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine:         ****  weedb.NoColumnError: no such column: None
Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine:         ****
Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine:         ****  During handling of the above exception, another exception occurred:
Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine:         ****
Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine:         ****  Traceback (most recent call last):
Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine:         ****    File "/usr/share/weewx/weewx/reportengine.py", line 197, in run
Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine:         ****      obj.start()
Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine:         ****    File "/usr/share/weewx/weewx/reportengine.py", line 385, in start
Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine:         ****      self.run()
Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine:         ****    File "/usr/share/weewx/user/belchertown.py", line 2819, in run
Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine:         ****      series_data = self.get_observation_data(
Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine:         ****    File "/usr/share/weewx/user/belchertown.py", line 3798, in get_observation_data
Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine:         ****      raise Warning(
Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine:         ****  Warning: Error trying to use database binding wx_binding to graph observation outTemp. Error was: no such column: None.
Jul 26 13:25:32 raspberrypi weewx[1189454] ERROR weewx.reportengine:         ****  Generator terminated

[enu...@gmail.com]

I try with the Seasson skin and i get the same error "no such column: None". Doesn't work.

[Tom Keffer]

Thanks.

Turns out there is a bug in how aggregates are calculated that prevents this. I've created issue #881.

I'll fix it, but not until Version 5.0.

-tk

To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/5bc2af84-6931-4cc7-a356-502c1249ab0en%40googlegroups.com.

[Tom Keffer]

Fixed in commit 52db478.

The fix is in the file weewx/xtypes.py. You can simply swap out your old version for the new one, if you are comfortable doing that. 

Otherwise, wait for V5.

[enu...@gmail.com]

Thank you it works with season but it still doesn't work with belchertown and i don't understand why.
I have modified belchertown.py by changing all calls to xtypes.get_series to have **option_dict but it still doesn't work and still gives the same "no such column" error. I understand that option_dict is a global variable accessible from all modules but i see that option_dict is empty