Re: [weewx-user] Dewpoint does not get reported to Wunderground under rapid fire

[Thomas Keffer]

I did not write the WMR9x8 driver, but looking through the code, whether or
not it can report dewpoint depends on the type of sensor you have.

In any case, another option would be to ask WeeWX to calculate dewpoint for
you. To do this, set option dewpoint in StdWXCalculate to 'software':

[StdWXCalculate]
[[Calculations]]
pressure = prefer_hardware
barometer = prefer_hardware
altimeter = prefer_hardware
windchill = prefer_hardware
heatindex = prefer_hardware
dewpoint = software
inDewpoint = prefer_hardware
rainRate = prefer_hardware



On Fri, Aug 31, 2018 at 5:44 PM  wrote:

> HI Thanks for the suggestions.  I have run it via the command line and I
> do not see anywhere in the loop packer where it is reading the dew point
> from the weather station.
>
> LOOP:   2018-08-31 20:16:24 EDT (1535760984) dateTime: 1535760984,
> maxSolarRad: None, rain: None, rainRate: 0.0, rainTotal: 0.0, usUnits: 1,
> yesterdayRain: 0.0
> LOOP:   2018-08-31 20:16:29 EDT (1535760989) dateTime: 1535760989,
> maxSolarRad: None, usUnits: 1, windDir: None, windGust: 0.0, windGustDir:
> None, windSpeed: 0.0
> LOOP:   2018-08-31 20:16:34 EDT (1535760994) dateTime: 1535760994,
> maxSolarRad: None, usUnits: 1, windDir: None, windGust: 0.0, windGustDir:
> None, windSpeed: 0.0
> LOOP:   2018-08-31 20:16:34 EDT (1535760994) dateTime: 1535760994,
> inHumidity: 49, maxSolarRad: None, outHumidity: 71, usUnits: 1
> LOOP:   2018-08-31 20:16:34 EDT (1535760994) dateTime: 1535760994, inTemp:
> 83.66, maxSolarRad: None, outTemp: 62.78, usUnits: 1
> LOOP:   2018-08-31 20:16:34 EDT (1535760994) altimeter: 30.2944646458,
> barometer: 29.943407325, dateTime: 1535760994, maxSolarRad: None, pressure:
> 29.943407325, usUnits: 1
>
> The record packet has it so I assume the weewx is calculating it.  I
> looked in the driver and there is code to read the dewpoint packet, but I
> am not sure that it is reading it, not sure if the unit is not sending it
> or if there is an issue with the driver.
>
>
>
> On Thursday, August 30, 2018 at 9:56:49 PM UTC-4, Thomas Keffer wrote:
>>
>> If WeeWX is not reporting dewpoint in the Rapidfire post, then dewpoint
>> must not be in the LOOP packet. Or, at least, not often enough to show up
>> on the WU.
>>
>> Try running WeeWX directly from the command line
>> , and watch what
>> variables have a value in the LOOP packet. The LOOP packets are marked with
>> the label "LOOP." Records are marked with a label "REC".
>>
>> -tk
>>
>> On Thu, Aug 30, 2018 at 2:05 PM  wrote:
>>
>>> Hi All I am running WEEWX 3.8.2 under ubuntu installed via apt-get from
>>> the repository.  I have a WMR-918 weather station and under the normal
>>> setup of wunderground it works fine.  Everything gets updated.  I wanted to
>>> try rapid fire updates and everything seems to work except dewpoint.  I set
>>> debug to 2 and this is the packet it is sending to wunderground.  I am not
>>> sure why dewpoint is missing.
>>>
>>>
>>> http://rtupdate.wunderground.com/weatherstation/updateweatherstation.php?action=updateraw=KMANORTH221=XXX=weewx-3.8.2=1=29.619=055=2018-08-30%2017%3A42%3A14=2.5=0.00=82.8=0.0=0.0=0.00
>>>
>>>
>>> This isn't a big deal I'll just leave rapidfire off, but maybe it is a
>>> bug somewhere?  I understand that this weather station sends partial
>>> packets but after reading several post it seems like there is a cache mode
>>> that should send out cached data to make the rapid fire data complete.
>>>
>>>
>>>
>>> --
>>> 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.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>> --
> 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+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [weewx-user] Dewpoint does not get reported to Wunderground under rapid fire

[gjr80]

Would help to see more than 10 seconds of loop data, a good 2 or 3 archive 
intervals of data (ie seeing at least 3 REC: lines) would be better.

Gary

-- 
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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [weewx-user] Dewpoint does not get reported to Wunderground under rapid fire

[mattr100]

HI Thanks for the suggestions.  I have run it via the command line and I do 
not see anywhere in the loop packer where it is reading the dew point from 
the weather station.

LOOP:   2018-08-31 20:16:24 EDT (1535760984) dateTime: 1535760984, 
maxSolarRad: None, rain: None, rainRate: 0.0, rainTotal: 0.0, usUnits: 1, 
yesterdayRain: 0.0
LOOP:   2018-08-31 20:16:29 EDT (1535760989) dateTime: 1535760989, 
maxSolarRad: None, usUnits: 1, windDir: None, windGust: 0.0, windGustDir: 
None, windSpeed: 0.0
LOOP:   2018-08-31 20:16:34 EDT (1535760994) dateTime: 1535760994, 
maxSolarRad: None, usUnits: 1, windDir: None, windGust: 0.0, windGustDir: 
None, windSpeed: 0.0
LOOP:   2018-08-31 20:16:34 EDT (1535760994) dateTime: 1535760994, 
inHumidity: 49, maxSolarRad: None, outHumidity: 71, usUnits: 1
LOOP:   2018-08-31 20:16:34 EDT (1535760994) dateTime: 1535760994, inTemp: 
83.66, maxSolarRad: None, outTemp: 62.78, usUnits: 1
LOOP:   2018-08-31 20:16:34 EDT (1535760994) altimeter: 30.2944646458, 
barometer: 29.943407325, dateTime: 1535760994, maxSolarRad: None, pressure: 
29.943407325, usUnits: 1

The record packet has it so I assume the weewx is calculating it.  I looked 
in the driver and there is code to read the dewpoint packet, but I am not 
sure that it is reading it, not sure if the unit is not sending it or if 
there is an issue with the driver.



On Thursday, August 30, 2018 at 9:56:49 PM UTC-4, Thomas Keffer wrote:
>
> If WeeWX is not reporting dewpoint in the Rapidfire post, then dewpoint 
> must not be in the LOOP packet. Or, at least, not often enough to show up 
> on the WU.
>
> Try running WeeWX directly from the command line 
> , and watch what 
> variables have a value in the LOOP packet. The LOOP packets are marked with 
> the label "LOOP." Records are marked with a label "REC".
>
> -tk
>
> On Thu, Aug 30, 2018 at 2:05 PM > wrote:
>
>> Hi All I am running WEEWX 3.8.2 under ubuntu installed via apt-get from 
>> the repository.  I have a WMR-918 weather station and under the normal 
>> setup of wunderground it works fine.  Everything gets updated.  I wanted to 
>> try rapid fire updates and everything seems to work except dewpoint.  I set 
>> debug to 2 and this is the packet it is sending to wunderground.  I am not 
>> sure why dewpoint is missing.
>>
>>
>> http://rtupdate.wunderground.com/weatherstation/updateweatherstation.php?action=updateraw=KMANORTH221=XXX=weewx-3.8.2=1=29.619=055=2018-08-30%2017%3A42%3A14=2.5=0.00=82.8=0.0=0.0=0.00
>>
>>
>> This isn't a big deal I'll just leave rapidfire off, but maybe it is a 
>> bug somewhere?  I understand that this weather station sends partial 
>> packets but after reading several post it seems like there is a cache mode 
>> that should send out cached data to make the rapid fire data complete.
>>
>>
>>
>> -- 
>> 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 .
>> For more options, visit https://groups.google.com/d/optout.
>>
>

-- 
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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [weewx-user] Re: Belchertown skin for weewx now available!

[Thomas Keffer]

Off the top of my head, an $alltime query shouldn't be a problem and should
be directed to the daily summaries: it always uses the first and last
timestamp in the database.

Good theory about the database getting updated while the reporting thread
is running.

-tk

On Fri, Aug 31, 2018 at 2:57 PM gjr80  wrote:

> The (another) thing to remember about using 'wind' is that if the time
> span over which you are asking for an aggregate does not meet a number of
> constraints (must be on midnight boundary or first or last timestamp in db)
> the the query is directed to the archive (where 'wind' does not exist)
> rather than the daily summaries (where wind does exist). $year is well
> behaved, it has be n a long standing part of WeeWX and is well know,
> $alltime less so (it is an add on not an integral part of WeeWX) but I
> believe it is equally solid.
>
> Looking at the error:
>
> Aug 31 08:06:51 hathaway weewx[22213]: manager: getSQL: SELECT dateTime
> FROM archive WHERE dateTime > 1389475998 AND dateTime <= 1535720760 AND
> wind = (SELECT MAX(wind) FROM archive WHERE dateTime > 1389475998 and
> dateTime <= 1535720760) AND wind IS NOT NULL
>
> I am starting to wonder... the timestamp 1535720760 suggests a 60 second
> archive interval. We know from previous posts that the skin has been taking
> in excess of 60 seconds to execute. I am wondering if what is going on is
> that a report thread is launched but by the time this portion is executed
> another archive record has been saved thereby meaning that the already
> running report thread will no longer be getting the last record in the db
> because another has since been saved. This causes the archive to be used
> for wind (and other obs) but only wind throws an error, the other obs don't
> since they exist in the archive.
>
> A decent log extract over a few archive periods with debug=1 will confirm.
> Possible solutions are use a 5 minute archive ( I don't know why 1 minute
> seems to be so popular, it is often more trouble than it is worth) or
> re-order the reports in the skin to put the offending ones up front.
>
> Gary
>
> --
> 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+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [weewx-user] weewx 3.8.2, Raspberry Pi3B+, Vantage driver seems to be bouncing

[Thomas Keffer]

What version did you update from? There have been no significant changes to
the Vantage runtime in years --- just configuration changes.

You are using the port /dev/vantage. Make sure it points to the port you
think it points to. As an experiment, try using the real port name (usually
/dev/ttyUSB0). If that works, you know you have a udev problem.

-tk



On Fri, Aug 31, 2018 at 3:07 PM jfk  wrote:

> Hello there,
>
> Did a full update to the latest Raspberry PI 3B+, Weewx 3.8.2 it seems
> either the vantage tty is bouncing, or weewx has some issue with it:
>
> Aug 31 14:56:17 dcrwx weewx[12677]: engine: Initializing weewx version
> 3.8.2
>
> Aug 31 14:56:17 dcrwx weewx[12677]: engine: Using Python 2.7.13 (default,
> Nov 24 2017, 17:33:09) #012[GCC 6.3.0 20170516]
>
> Aug 31 14:56:17 dcrwx weewx[12677]: engine: Platform
> Linux-4.14.66-v7+-armv7l-with-debian-9.4
>
> Aug 31 14:56:17 dcrwx weewx[12677]: engine: Locale is 'en_US.UTF-8'
>
> Aug 31 14:56:17 dcrwx weewx[12677]: engine: pid file is
> /var/weewx/run/weewx.pid
>
> Aug 31 14:56:17 dcrwx weewx[12683]: engine: Using configuration file
> /home/drycreekwxuser/weewx/weewx.conf
>
> Aug 31 14:56:17 dcrwx weewx[12683]: engine: Loading station type Vantage
> (weewx.drivers.vantage)
>
> Aug 31 14:56:17 dcrwx weewx[12651]: .
>
> Aug 31 14:56:18 dcrwx weewx[12683]: engine: StdConvert target unit is 0x1
>
> Aug 31 14:56:18 dcrwx weewx[12683]: wxcalculate: The following values will
> be calculated: barometer=prefer_hardware, windchill=prefer_hardware,
> dewpoint=prefer_hardware, appTemp=prefer_hardware,
> rainRate=prefer_hardware, windrun=prefer_hardware,
> heatindex=prefer_hardware, maxSolarRad=prefer_hardware,
> humidex=prefer_hardware, pressure=prefer_hardware,
> inDewpoint=prefer_hardware, ET=prefer_hardware, altimeter=prefer_hardware,
> cloudbase=prefer_hardware
>
> Aug 31 14:56:18 dcrwx weewx[12683]: wxcalculate: The following algorithms
> will be used for calculations: altimeter=aaNOAA, maxSolarRad=RS
>
> Aug 31 14:56:18 dcrwx weewx[12683]: engine: Archive will use data binding
> wx_binding
>
> Aug 31 14:56:18 dcrwx weewx[12683]: engine: Record generation will be
> attempted in 'hardware'
>
> Aug 31 14:56:18 dcrwx weewx[12683]: engine: Using archive interval of 300
> seconds (specified by hardware)
>
> Aug 31 14:56:18 dcrwx weewx[12683]: engine: Using binding 'wx_binding' to
> database 'weewx.sdb'
>
> Aug 31 14:56:18 dcrwx weewx[12683]: manager: Starting backfill of daily
> summaries
>
> Aug 31 14:56:18 dcrwx weewx[12683]: restx: StationRegistry: Registration
> not requested.
>
> Aug 31 14:56:18 dcrwx weewx[12683]: restx: Wunderground: Posting not
> enabled.
>
> Aug 31 14:56:18 dcrwx weewx[12683]: restx: PWSweather: Posting not enabled.
>
> Aug 31 14:56:18 dcrwx weewx[12683]: restx: CWOP: Posting not enabled.
>
> Aug 31 14:56:18 dcrwx weewx[12683]: restx: WOW: Posting not enabled.
>
> Aug 31 14:56:18 dcrwx weewx[12683]: restx: AWEKAS: Posting not enabled.
>
> Aug 31 14:56:18 dcrwx weewx[12683]: engine: Starting up weewx version 3.8.2
>
> Aug 31 14:56:18 dcrwx weewx[12683]: engine: Clock error is -0.10 seconds
> (positive is fast)
>
> Aug 31 14:56:18 dcrwx weewx[12683]: manager: Added record 2018-08-31
> 14:25:00 PDT (1535750700) to database 'weewx.sdb'
>
> Aug 31 14:56:18 dcrwx weewx[12683]: manager: Added record 2018-08-31
> 14:25:00 PDT (1535750700) to daily summary in 'weewx.sdb'
>
> Aug 31 14:56:18 dcrwx weewx[12683]: manager: Added record 2018-08-31
> 14:30:00 PDT (1535751000) to database 'weewx.sdb'
>
> Aug 31 14:56:18 dcrwx weewx[12683]: manager: Added record 2018-08-31
> 14:30:00 PDT (1535751000) to daily summary in 'weewx.sdb'
>
> Aug 31 14:56:18 dcrwx weewx[12683]: manager: Added record 2018-08-31
> 14:35:00 PDT (1535751300) to database 'weewx.sdb'
>
> Aug 31 14:56:18 dcrwx weewx[12683]: manager: Added record 2018-08-31
> 14:35:00 PDT (1535751300) to daily summary in 'weewx.sdb'
>
> Aug 31 14:56:18 dcrwx weewx[12683]: manager: Added record 2018-08-31
> 14:40:00 PDT (1535751600) to database 'weewx.sdb'
>
> Aug 31 14:56:18 dcrwx weewx[12683]: manager: Added record 2018-08-31
> 14:40:00 PDT (1535751600) to daily summary in 'weewx.sdb'
>
> Aug 31 14:56:18 dcrwx weewx[12683]: manager: Added record 2018-08-31
> 14:45:00 PDT (1535751900) to database 'weewx.sdb'
>
> Aug 31 14:56:18 dcrwx weewx[12683]: manager: Added record 2018-08-31
> 14:45:00 PDT (1535751900) to daily summary in 'weewx.sdb'
>
> Aug 31 14:56:18 dcrwx weewx[12683]: manager: Added record 2018-08-31
> 14:50:00 PDT (1535752200) to database 'weewx.sdb'
>
> Aug 31 14:56:18 dcrwx weewx[12683]: manager: Added record 2018-08-31
> 14:50:00 PDT (1535752200) to daily summary in 'weewx.sdb'
>
> Aug 31 14:56:18 dcrwx weewx[12683]: manager: Added record 2018-08-31
> 14:55:00 PDT (1535752500) to database 'weewx.sdb'
>
> Aug 31 14:56:18 dcrwx weewx[12683]: manager: Added record 2018-08-31
> 14:55:00 PDT (1535752500) to daily summary in 'weewx.sdb'
>
> Aug 31 14:56:18 dcrwx weewx[12683]: engine: 

Re: [weewx-user] Re: Belchertown skin for weewx now available!

[gjr80]

The (another) thing to remember about using 'wind' is that if the time span 
over which you are asking for an aggregate does not meet a number of 
constraints (must be on midnight boundary or first or last timestamp in db) the 
the query is directed to the archive (where 'wind' does not exist) rather than 
the daily summaries (where wind does exist). $year is well behaved, it has be n 
a long standing part of WeeWX and is well know, $alltime less so (it is an add 
on not an integral part of WeeWX) but I believe it is equally solid.

Looking at the error:

Aug 31 08:06:51 hathaway weewx[22213]: manager: getSQL: SELECT dateTime FROM 
archive WHERE dateTime > 1389475998 AND dateTime <= 1535720760 AND wind = 
(SELECT MAX(wind) FROM archive WHERE dateTime > 1389475998 and dateTime <= 
1535720760) AND wind IS NOT NULL

I am starting to wonder... the timestamp 1535720760 suggests a 60 second 
archive interval. We know from previous posts that the skin has been taking in 
excess of 60 seconds to execute. I am wondering if what is going on is that a 
report thread is launched but by the time this portion is executed another 
archive record has been saved thereby meaning that the already running report 
thread will no longer be getting the last record in the db because another has 
since been saved. This causes the archive to be used for wind (and other obs) 
but only wind throws an error, the other obs don't since they exist in the 
archive.

A decent log extract over a few archive periods with debug=1 will confirm. 
Possible solutions are use a 5 minute archive ( I don't know why 1 minute seems 
to be so popular, it is often more trouble than it is worth) or re-order the 
reports in the skin to put the offending ones up front.

Gary

-- 
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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [weewx-user] Re: Belchertown skin for weewx now available!

[Thomas Keffer]

Most likely this is because the "alltime" search list extension does not
use the daily summaries.

It was written before the introduction of database bindings, so it dumbly
uses the archive table. A more modern version takes advantage of  bindings,
which automatically direct the query to the daily summaries or the archive
table as appropriate. It would not be hard to rewrite.

I've created issue #339  to
track. This is not a hard project. I encourage someone in this thread to
give it a try!

-tk


On Fri, Aug 31, 2018 at 1:38 PM David Hathaway 
wrote:

> The confusing thing is that this is the part that throws an exception:
>
> 
>   Strongest Wind Gust
>   $year.wind.max
>   $year.wind.maxtime.format("%B %-d, %Y at %-I:%M %p")
>   $alltime.wind.maxtime.format("%B %-d, %Y at
> %-I:%M %p")
>   $alltime.wind.max
>   
>
> Should this work?
>
> The exception is  NoColumnError: (1054, "Unknown column 'wind' in 'where
> clause'")
>
> On Fri, Aug 31, 2018 at 2:05 PM Thomas Keffer  wrote:
>
>> It all depends on what you want.
>>
>> In what follows, I am assuming that option loop_hilo
>>  is set to true (the
>> normal state of affairs). Much of this information is also in the section 
>> *Wind
>> *.
>>
>> $day.wind.max is the maximum wind speed seen during the day (including
>> LOOP packets). It's obtained from the daily summaries.
>> $day.windGust.max is the same. However, because windGust does not appear
>> in the daily summaries, it is calculated from the archive data.
>> $day.windSpeed.max is the max average wind speed. This is calculated from
>> the archive data. The wind is averaged over each of the archive intervals,
>> then the maximum of these values is taken. This is different from the above
>> two tags.
>>
>> Generally, you work with $day.wind.*something. *This is because, for the
>> average user, it's easier to just tell him/her to work with 'wind' and not
>> worry about how it got flattened. $day.wind.max is natural,
>> $day.windGust.max is not.
>>
>> Also, it's much more efficient to calculate things from the daily
>> archives.
>>
>> On Fri, Aug 31, 2018 at 11:15 AM Pat  wrote:
>>
>>> You're right, this is confusing. I do have one tmpl with
>>> day/week/month/year.wind. Are you suggesting that I change the week/month
>>> to the proper windGust, windSpeed, etc? or change all 4 types since
>>> day/year can be used in aggregation?
>>>
>>> On Friday, August 31, 2018 at 12:43:26 PM UTC-4, Thomas Keffer wrote:

 The tag "wind" can only be used in aggregations, such as day and year.
 The tags windSpeed, windDir, windGust, and windGustDir can be used for
 current observations, as well as aggregations. This is all explained in the
 Customizing Guide, section *Wind
 *.

 Confusing, I know. It's the product of a legacy schema from wview, and
 the need to flatten vector-like quantities into a two dimensional SQL
 table. A more general solution would have been a separate table for each
 type (much like the daily summaries), but that would break compatibility
 with wview, as well as be slower.

 -tk

 On Fri, Aug 31, 2018 at 9:16 AM Pat O'Brien 
 wrote:

 I'm on mobile, so I read this again. Maybe the difference is year.wind
 as opposed to day?

 On Fri, Aug 31, 2018, 12:12 PM Pat O'Brien 
 wrote:

 Interesting... Check this link as it is the official document.

 http://www.weewx.com/docs/customizing.htm

 Then search for "day.wind". You'll see the differences.


 On Fri, Aug 31, 2018, 11:57 AM David Hathaway 
 wrote:

 Reckoned it was easy enough to try, so I changed the records code to

 
 Strongest Wind Gust
 $year.windGust.max
 $year.windGust.maxtime.format("%B %-d, %Y at %-I:%M %p")
 $alltime.windGust.maxtime.format("%B %-d, %Y
 at %-I:%M %p")
 $alltime.windGust.max
 

 (using windGust instead of wind)

 It does work in my installation.


 On Friday, August 31, 2018 at 9:32:23 AM UTC-5, David Hathaway wrote:

 This was the query right before the exception:


 Aug 31 08:06:51 hathaway weewx[22213]: manager: getSQL: SELECT dateTime
 FROM archive WHERE dateTime > 1389475998 AND dateTime <= 1535720760 AND
 wind = (SELECT MAX(wind) FROM archive WHERE dateTime > 1389475998 and
 dateTime <= 1535720760) AND wind IS NOT NULL
 Aug 31 08:06:51 hathaway weewx[22213]: cheetahgenerator: Generate
 failed with exception ''
 Aug 31 08:06:51 hathaway weewx[22213]: cheetahgenerator:  Ignoring
 template /etc/weewx/skins/Belchertown/records/index.html.tmpl
 Aug 31 08:06:51 hathaway weewx[22213]: cheetahgenerator:  Reason:
 (1054, "Unknown column 'wind' in 'where 

Re: [weewx-user] Re: Belchertown skin for weewx now available!

[David Hathaway]

The confusing thing is that this is the part that throws an exception:


  Strongest Wind Gust
  $year.wind.max
  $year.wind.maxtime.format("%B %-d, %Y at %-I:%M %p")
  $alltime.wind.maxtime.format("%B %-d, %Y at %-I:%M
%p")
  $alltime.wind.max
  

Should this work?

The exception is  NoColumnError: (1054, "Unknown column 'wind' in 'where
clause'")

On Fri, Aug 31, 2018 at 2:05 PM Thomas Keffer  wrote:

> It all depends on what you want.
>
> In what follows, I am assuming that option loop_hilo
>  is set to true (the
> normal state of affairs). Much of this information is also in the section 
> *Wind
> *.
>
> $day.wind.max is the maximum wind speed seen during the day (including
> LOOP packets). It's obtained from the daily summaries.
> $day.windGust.max is the same. However, because windGust does not appear
> in the daily summaries, it is calculated from the archive data.
> $day.windSpeed.max is the max average wind speed. This is calculated from
> the archive data. The wind is averaged over each of the archive intervals,
> then the maximum of these values is taken. This is different from the above
> two tags.
>
> Generally, you work with $day.wind.*something. *This is because, for the
> average user, it's easier to just tell him/her to work with 'wind' and not
> worry about how it got flattened. $day.wind.max is natural,
> $day.windGust.max is not.
>
> Also, it's much more efficient to calculate things from the daily archives.
>
> On Fri, Aug 31, 2018 at 11:15 AM Pat  wrote:
>
>> You're right, this is confusing. I do have one tmpl with
>> day/week/month/year.wind. Are you suggesting that I change the week/month
>> to the proper windGust, windSpeed, etc? or change all 4 types since
>> day/year can be used in aggregation?
>>
>> On Friday, August 31, 2018 at 12:43:26 PM UTC-4, Thomas Keffer wrote:
>>>
>>> The tag "wind" can only be used in aggregations, such as day and year.
>>> The tags windSpeed, windDir, windGust, and windGustDir can be used for
>>> current observations, as well as aggregations. This is all explained in the
>>> Customizing Guide, section *Wind
>>> *.
>>>
>>> Confusing, I know. It's the product of a legacy schema from wview, and
>>> the need to flatten vector-like quantities into a two dimensional SQL
>>> table. A more general solution would have been a separate table for each
>>> type (much like the daily summaries), but that would break compatibility
>>> with wview, as well as be slower.
>>>
>>> -tk
>>>
>>> On Fri, Aug 31, 2018 at 9:16 AM Pat O'Brien 
>>> wrote:
>>>
>>> I'm on mobile, so I read this again. Maybe the difference is year.wind
>>> as opposed to day?
>>>
>>> On Fri, Aug 31, 2018, 12:12 PM Pat O'Brien  wrote:
>>>
>>> Interesting... Check this link as it is the official document.
>>>
>>> http://www.weewx.com/docs/customizing.htm
>>>
>>> Then search for "day.wind". You'll see the differences.
>>>
>>>
>>> On Fri, Aug 31, 2018, 11:57 AM David Hathaway 
>>> wrote:
>>>
>>> Reckoned it was easy enough to try, so I changed the records code to
>>>
>>> 
>>> Strongest Wind Gust
>>> $year.windGust.max
>>> $year.windGust.maxtime.format("%B %-d, %Y at %-I:%M %p")
>>> $alltime.windGust.maxtime.format("%B %-d, %Y
>>> at %-I:%M %p")
>>> $alltime.windGust.max
>>> 
>>>
>>> (using windGust instead of wind)
>>>
>>> It does work in my installation.
>>>
>>>
>>> On Friday, August 31, 2018 at 9:32:23 AM UTC-5, David Hathaway wrote:
>>>
>>> This was the query right before the exception:
>>>
>>>
>>> Aug 31 08:06:51 hathaway weewx[22213]: manager: getSQL: SELECT dateTime
>>> FROM archive WHERE dateTime > 1389475998 AND dateTime <= 1535720760 AND
>>> wind = (SELECT MAX(wind) FROM archive WHERE dateTime > 1389475998 and
>>> dateTime <= 1535720760) AND wind IS NOT NULL
>>> Aug 31 08:06:51 hathaway weewx[22213]: cheetahgenerator: Generate failed
>>> with exception ''
>>> Aug 31 08:06:51 hathaway weewx[22213]: cheetahgenerator:  Ignoring
>>> template /etc/weewx/skins/Belchertown/records/index.html.tmpl
>>> Aug 31 08:06:51 hathaway weewx[22213]: cheetahgenerator:  Reason:
>>> (1054, "Unknown column 'wind' in 'where clause'")
>>> Aug 31 08:06:51 hathaway weewx[22213]:   Traceback (most recent call
>>> last):
>>> Aug 31 08:06:51 hathaway weewx[22213]: File
>>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 330, in generate
>>> Aug 31 08:06:51 hathaway weewx[22213]:   print >> _file,
>>> compiled_template
>>> Aug 31 08:06:51 hathaway weewx[22213]: File
>>> "/usr/lib/python2.7/dist-packages/Cheetah/Template.py", line 1005, in
>>> __str__
>>> Aug 31 08:06:51 hathaway weewx[22213]:   rc = getattr(self,
>>> mainMethName)()
>>> Aug 31 08:06:51 hathaway weewx[22213]: File
>>> "_etc_weewx_skins_Belchertown_records_index_html_tmpl.py", line 1123, in
>>> respond
>>> Aug 31 08:06:51 hathaway weewx[22213]: 

[weewx-user] Re: after raspbian and weewx updates, weewx is still collecting data but stopped publishing to CWOP and Wunderground

[gjr80]

Yes Tom I suspect the issue will be due to the new hardware/software, would be 
good to know there was nothing else nefarious going on. Matthew has been 
otherwise pretty busy of late so he is not here as often, chances are he will 
eventually see this and comment.

Gary

-- 
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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[weewx-user] Winddirplot with weewx-Highcharts

[gjr80]

Hi,

Short answer is I don't know. As I understand it all points on the wind 
directions plots are 90 degree but the underlying json files that contain the 
wind direction data have normal (as expected) wind direction data that is not 
always 90 degrees. Is this correct? If you want to continue to find the issue 
it would be good to see one of the offending json files.

Gary

-- 
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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [weewx-user] Re: Belchertown skin for weewx now available!

[Thomas Keffer]

It all depends on what you want.

In what follows, I am assuming that option loop_hilo
 is set to true (the
normal state of affairs). Much of this information is also in the section *Wind
*.

$day.wind.max is the maximum wind speed seen during the day (including LOOP
packets). It's obtained from the daily summaries.
$day.windGust.max is the same. However, because windGust does not appear in
the daily summaries, it is calculated from the archive data.
$day.windSpeed.max is the max average wind speed. This is calculated from
the archive data. The wind is averaged over each of the archive intervals,
then the maximum of these values is taken. This is different from the above
two tags.

Generally, you work with $day.wind.*something. *This is because, for the
average user, it's easier to just tell him/her to work with 'wind' and not
worry about how it got flattened. $day.wind.max is natural,
$day.windGust.max is not.

Also, it's much more efficient to calculate things from the daily archives.

On Fri, Aug 31, 2018 at 11:15 AM Pat  wrote:

> You're right, this is confusing. I do have one tmpl with
> day/week/month/year.wind. Are you suggesting that I change the week/month
> to the proper windGust, windSpeed, etc? or change all 4 types since
> day/year can be used in aggregation?
>
> On Friday, August 31, 2018 at 12:43:26 PM UTC-4, Thomas Keffer wrote:
>>
>> The tag "wind" can only be used in aggregations, such as day and year.
>> The tags windSpeed, windDir, windGust, and windGustDir can be used for
>> current observations, as well as aggregations. This is all explained in the
>> Customizing Guide, section *Wind
>> *.
>>
>> Confusing, I know. It's the product of a legacy schema from wview, and
>> the need to flatten vector-like quantities into a two dimensional SQL
>> table. A more general solution would have been a separate table for each
>> type (much like the daily summaries), but that would break compatibility
>> with wview, as well as be slower.
>>
>> -tk
>>
>> On Fri, Aug 31, 2018 at 9:16 AM Pat O'Brien  wrote:
>>
>> I'm on mobile, so I read this again. Maybe the difference is year.wind as
>> opposed to day?
>>
>> On Fri, Aug 31, 2018, 12:12 PM Pat O'Brien  wrote:
>>
>> Interesting... Check this link as it is the official document.
>>
>> http://www.weewx.com/docs/customizing.htm
>>
>> Then search for "day.wind". You'll see the differences.
>>
>>
>> On Fri, Aug 31, 2018, 11:57 AM David Hathaway 
>> wrote:
>>
>> Reckoned it was easy enough to try, so I changed the records code to
>>
>> 
>> Strongest Wind Gust
>> $year.windGust.max
>> $year.windGust.maxtime.format("%B %-d, %Y at %-I:%M %p")
>> $alltime.windGust.maxtime.format("%B %-d, %Y
>> at %-I:%M %p")
>> $alltime.windGust.max
>> 
>>
>> (using windGust instead of wind)
>>
>> It does work in my installation.
>>
>>
>> On Friday, August 31, 2018 at 9:32:23 AM UTC-5, David Hathaway wrote:
>>
>> This was the query right before the exception:
>>
>>
>> Aug 31 08:06:51 hathaway weewx[22213]: manager: getSQL: SELECT dateTime
>> FROM archive WHERE dateTime > 1389475998 AND dateTime <= 1535720760 AND
>> wind = (SELECT MAX(wind) FROM archive WHERE dateTime > 1389475998 and
>> dateTime <= 1535720760) AND wind IS NOT NULL
>> Aug 31 08:06:51 hathaway weewx[22213]: cheetahgenerator: Generate failed
>> with exception ''
>> Aug 31 08:06:51 hathaway weewx[22213]: cheetahgenerator:  Ignoring
>> template /etc/weewx/skins/Belchertown/records/index.html.tmpl
>> Aug 31 08:06:51 hathaway weewx[22213]: cheetahgenerator:  Reason:
>> (1054, "Unknown column 'wind' in 'where clause'")
>> Aug 31 08:06:51 hathaway weewx[22213]:   Traceback (most recent call
>> last):
>> Aug 31 08:06:51 hathaway weewx[22213]: File
>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 330, in generate
>> Aug 31 08:06:51 hathaway weewx[22213]:   print >> _file,
>> compiled_template
>> Aug 31 08:06:51 hathaway weewx[22213]: File
>> "/usr/lib/python2.7/dist-packages/Cheetah/Template.py", line 1005, in
>> __str__
>> Aug 31 08:06:51 hathaway weewx[22213]:   rc = getattr(self,
>> mainMethName)()
>> Aug 31 08:06:51 hathaway weewx[22213]: File
>> "_etc_weewx_skins_Belchertown_records_index_html_tmpl.py", line 1123, in
>> respond
>> Aug 31 08:06:51 hathaway weewx[22213]: File
>> "_etc_weewx_skins_Belchertown_records_index_html_tmpl.py", line 385, in
>> __errorCatcher46
>> Aug 31 08:06:51 hathaway weewx[22213]: File "", line 1,
>> in 
>> Aug 31 08:06:51 hathaway weewx[22213]: File
>> "/usr/share/weewx/weewx/tags.py", line 329, in __getattr__
>> Aug 31 08:06:51 hathaway weewx[22213]:   return
>> self._do_query(aggregate_type)
>> Aug 31 08:06:51 hathaway weewx[22213]: File
>> "/usr/share/weewx/weewx/tags.py", line 343, in _do_query
>> Aug 31 08:06:51 hathaway 

Re: [weewx-user] Re: Belchertown skin for weewx now available!

[Pat]

You're right, this is confusing. I do have one tmpl with 
day/week/month/year.wind. Are you suggesting that I change the week/month 
to the proper windGust, windSpeed, etc? or change all 4 types since 
day/year can be used in aggregation? 

On Friday, August 31, 2018 at 12:43:26 PM UTC-4, Thomas Keffer wrote:
>
> The tag "wind" can only be used in aggregations, such as day and year. 
> The tags windSpeed, windDir, windGust, and windGustDir can be used for 
> current observations, as well as aggregations. This is all explained in the 
> Customizing Guide, section *Wind 
> *.
>
> Confusing, I know. It's the product of a legacy schema from wview, and the 
> need to flatten vector-like quantities into a two dimensional SQL table. A 
> more general solution would have been a separate table for each type (much 
> like the daily summaries), but that would break compatibility with wview, 
> as well as be slower.
>
> -tk
>
> On Fri, Aug 31, 2018 at 9:16 AM Pat O'Brien  > wrote:
>
> I'm on mobile, so I read this again. Maybe the difference is year.wind as 
> opposed to day? 
>
> On Fri, Aug 31, 2018, 12:12 PM Pat O'Brien  > wrote:
>
> Interesting... Check this link as it is the official document. 
>
> http://www.weewx.com/docs/customizing.htm
>
> Then search for "day.wind". You'll see the differences. 
>
>
> On Fri, Aug 31, 2018, 11:57 AM David Hathaway  > wrote:
>
> Reckoned it was easy enough to try, so I changed the records code to
>
> 
> Strongest Wind Gust
> $year.windGust.max
> $year.windGust.maxtime.format("%B %-d, %Y at %-I:%M %p")
> $alltime.windGust.maxtime.format("%B %-d, %Y at 
> %-I:%M %p")
> $alltime.windGust.max
> 
>
> (using windGust instead of wind)
>
> It does work in my installation.
>
>
> On Friday, August 31, 2018 at 9:32:23 AM UTC-5, David Hathaway wrote:
>
> This was the query right before the exception:
>
>
> Aug 31 08:06:51 hathaway weewx[22213]: manager: getSQL: SELECT dateTime 
> FROM archive WHERE dateTime > 1389475998 AND dateTime <= 1535720760 AND 
> wind = (SELECT MAX(wind) FROM archive WHERE dateTime > 1389475998 and 
> dateTime <= 1535720760) AND wind IS NOT NULL
> Aug 31 08:06:51 hathaway weewx[22213]: cheetahgenerator: Generate failed 
> with exception ''
> Aug 31 08:06:51 hathaway weewx[22213]: cheetahgenerator:  Ignoring 
> template /etc/weewx/skins/Belchertown/records/index.html.tmpl
> Aug 31 08:06:51 hathaway weewx[22213]: cheetahgenerator:  Reason: 
> (1054, "Unknown column 'wind' in 'where clause'")
> Aug 31 08:06:51 hathaway weewx[22213]:   Traceback (most recent call 
> last):
> Aug 31 08:06:51 hathaway weewx[22213]: File 
> "/usr/share/weewx/weewx/cheetahgenerator.py", line 330, in generate
> Aug 31 08:06:51 hathaway weewx[22213]:   print >> _file, 
> compiled_template
> Aug 31 08:06:51 hathaway weewx[22213]: File 
> "/usr/lib/python2.7/dist-packages/Cheetah/Template.py", line 1005, in 
> __str__
> Aug 31 08:06:51 hathaway weewx[22213]:   rc = getattr(self, 
> mainMethName)()
> Aug 31 08:06:51 hathaway weewx[22213]: File 
> "_etc_weewx_skins_Belchertown_records_index_html_tmpl.py", line 1123, in 
> respond
> Aug 31 08:06:51 hathaway weewx[22213]: File 
> "_etc_weewx_skins_Belchertown_records_index_html_tmpl.py", line 385, in 
> __errorCatcher46
> Aug 31 08:06:51 hathaway weewx[22213]: File "", line 1, in 
> 
> Aug 31 08:06:51 hathaway weewx[22213]: File 
> "/usr/share/weewx/weewx/tags.py", line 329, in __getattr__
> Aug 31 08:06:51 hathaway weewx[22213]:   return 
> self._do_query(aggregate_type)
> Aug 31 08:06:51 hathaway weewx[22213]: File 
> "/usr/share/weewx/weewx/tags.py", line 343, in _do_query
> Aug 31 08:06:51 hathaway weewx[22213]:   val=val, 
> **self.option_dict)
> Aug 31 08:06:51 hathaway weewx[22213]: File 
> "/usr/share/weewx/weewx/wxmanager.py", line 60, in getAggregate
> Aug 31 08:06:51 hathaway weewx[22213]:   return 
> weewx.manager.DaySummaryManager.getAggregate(self, timespan, obs_type, 
> aggregateType, **option_dict)
> Aug 31 08:06:51 hathaway weewx[22213]: File 
> "/usr/share/weewx/weewx/manager.py", line 1252, in getAggregate
> Aug 31 08:06:51 hathaway weewx[22213]:   **option_dict)
> Aug 31 08:06:51 hathaway weewx[22213]: File 
> "/usr/share/weewx/weewx/manager.py", line 461, in getAggregate
> Aug 31 08:06:51 hathaway weewx[22213]:   _row = 
> self.getSql(select_stmt % interpolate_dict)
> Aug 31 08:06:51 hathaway weewx[22213]: File 
> "/usr/share/weewx/weewx/manager.py", line 397, in getSql
> Aug 31 08:06:51 hathaway weewx[22213]:   _cursor.execute(sql, 
> sqlargs)
> Aug 31 08:06:51 hathaway weewx[22213]: File 
> "/usr/share/weewx/weedb/mysql.py", line 48, in guarded_fn
> Aug 31 08:06:51 hathaway weewx[22213]:   raise klass(e)
> Aug 31 08:06:51 hathaway weewx[22213]:   

RE: [weewx-user] Belchertown skin for weewx now available!

[Pat O'Brien]

NOAA tables are in a PRE container which is used for formatting as well as 
JavaScript to dynamically change report without needing to reload the page. 

 

From: weewx-user@googlegroups.com [mailto:weewx-user@googlegroups.com] On 
Behalf Of Praveen Chandrasekaran
Sent: Friday, August 31, 2018 1:23 PM
To: weewx-user 
Subject: Re: [weewx-user] Belchertown skin for weewx now available!

 

Awesome.I was just installing highcharts extension and running into some issues 
with wind direction. This beats highcharts totally. Will try this out this 
weekend.

 

One feedback - the NOAA charts are not so nice to view on mobile. It doesnt fit 
in a screen unlike three seasons skin where the NOAA tables fit nicely within 
screen on mobile also.

On Thursday, 23 August 2018 06:22:22 UTC+5:30, Pat wrote:

100% correct. That's my mistake. You can make that change for now and I'll 
update it in GitHub for the 0.3 version soon

 

The visibility comes from DarkSky, and they don't provide the units within the 
API output, so I I'll have to grab the DarkSky units from the config, and then 
change the unit within the skin based on that. 

 

And I'll fix the static unit in the records page. Thought I got them all!

 

Also, your map is still showing the East Coast of USA. Not sure if that's 
intended or not. 


On Wednesday, August 22, 2018 at 8:38:29 PM UTC-4, Colin Larsen wrote:

Have confirmed that this url with my API key returns the right data and 
timezone - using both auto and ca

 

https://api.darksky.net/forecast/xx/-41.36,174.05?units=ca

 

On Thu, Aug 23, 2018 at 11:58 AM Colin Larsen mailto:colin@gmail.com> > wrote:

Not sure but I think this line needs to change from

 

forecast_url = "https://api.darksky.net/forecast/%s/%s,%s?%s;

 

to

 

forecast_url = "https://api.darksky.net/forecast/%s/%s,%s?units=%s;

 

On Thu, Aug 23, 2018 at 11:23 AM Colin Larsen mailto:colin@gmail.com> > wrote:

And found a couple more records issues with changes of units in Rainfall - in 
-- mm

 


Highest Daily Rainfall

0.2 in

August 19, 2018

August 19, 2018 at 12:00 AM

0.2 in


Highest Daily Rainfall Rate

0.3 mm

August 19, 2018 at 12:00 AM

August 19, 2018 at 12:00 AM

0.3 mm


Month with Highest Total Rainfall

1.0 in

August

August, 2018

1.0 in


Total Rainfall for

2018

25.4 mm

2018

25.4 mm

 

On Thu, Aug 23, 2018 at 11:15 AM Colin Larsen mailto:colin@gmail.com> > wrote:

Hmmm, they weren't but the only difference was the Darksky_units I think. I'll 
fix that later.

 

Windy icon - fixed

Records change of units - fixed

Darksky - still a problem. Neither "auto" or "ca" seem to work so far. I'm 
guessing that 'Visibility' also comes from Darksky?

 


Visibility

3.84 miles

 

 

 

On Thu, Aug 23, 2018 at 10:34 AM Pat O'Brien mailto:p...@obrienphoto.net> > wrote:

Hopefully all of your configurations are in weewx.conf. If so you can just 
download it and install it like before with wee_extension. 

On Wed, Aug 22, 2018, 5:08 PM Colin Larsen mailto:colin@gmail.com> > wrote:

What's the best way to update Pat? 

 

On Thu, 23 Aug 2018, 08:29 Pat, mailto:p...@obrienphoto.net> > wrote:

Just released 0.2. Give it a try when you can. 

 

https://github.com/poblabs/weewx-belchertown/releases/tag/weewx-belchertown-0.2



On Wednesday, August 22, 2018 at 4:14:07 PM UTC-4, Colin Larsen wrote:

All good, thanks Pat 

 

On Thu, Aug 23, 2018 at 12:20 AM Pat mailto:p...@obrienphoto.net> > wrote:

Most of it looks pretty good. Not bad for my first skin attempt :) 

 

I knew imperial to metric would be an issue, and I had tried my best to plan 
for it. I didn't take timezones into consideration with my testing though - for 
example noticed on your test site that the forecast row has wrong borders and 
it's showing the weather for yesterday (for your timezone). I'll take a look 
into that. 

 

I see my error with the records page conversion, so I'll have to issue an 
update on that one later today. 

 

For DarkSky, I'll have to add the "units" flag. They have 6 different unit 
types, so I'll have to update the setup guide too. Can't believe I missed that 
one! 

 

I'll let you all know when I issue an update. Possibly late today (US Eastern 
time)

 


On Wednesday, August 22, 2018 at 12:30:47 AM UTC-4, Colin Larsen wrote:

Arrgh, typo - www.41south.net.nz  

 

Also found this on the records page, note the change from metric back to US 
units

 


Highest Temperature

21.1 °C

August 19, 2018 at 9:56 AM

August 19, 2018 at 9:56 AM

21.1 °C


Lowest Temperature

-1.1 °C

August 18, 2018 at 4:58 PM

August 18, 2018 at 4:58 PM

-1.1 °C


Highest Heat Index

21.1 °C

August 19, 2018 at 9:56 AM

August 19, 2018 at 9:56 AM

21.1 °C


Lowest Wind Chill

21.1 °C

August 19, 2018 at 9:56 AM

August 19, 2018 at 9:56 AM

August 19, 2018 at 9:56 AM


Largest Daily Temperature Range

40.0 °F

August 19, 2018
(Min: 30.0°F - Max: 70.0°F )

August 19, 2018
(Min: 30.0°F - 

Re: [weewx-user] Belchertown skin for weewx now available!

[Praveen Chandrasekaran]

Awesome.I was just installing highcharts extension and running into some 
issues with wind direction. This beats highcharts totally. Will try this 
out this weekend.

One feedback - the NOAA charts are not so nice to view on mobile. It doesnt 
fit in a screen unlike three seasons skin where the NOAA tables fit nicely 
within screen on mobile also.

On Thursday, 23 August 2018 06:22:22 UTC+5:30, Pat wrote:
>
> 100% correct. That's my mistake. You can make that change for now and I'll 
> update it in GitHub for the 0.3 version soon
>
> The visibility comes from DarkSky, and they don't provide the units within 
> the API output, so I I'll have to grab the DarkSky units from the config, 
> and then change the unit within the skin based on that. 
>
> And I'll fix the static unit in the records page. Thought I got them all!
>
> Also, your map is still showing the East Coast of USA. Not sure if that's 
> intended or not. 
>
> On Wednesday, August 22, 2018 at 8:38:29 PM UTC-4, Colin Larsen wrote:
>>
>> Have confirmed that this url with my API key returns the right data and 
>> timezone - using both auto and ca
>>
>>
>> https://api.darksky.net/forecast/xx/-41.36,174.05?units=ca
>>
>> On Thu, Aug 23, 2018 at 11:58 AM Colin Larsen  
>> wrote:
>>
>>> Not sure but I think this line needs to change from
>>>
>>> forecast_url = "https://api.darksky.net/forecast/%s/%s,%s?%s;
>>>
>>> to
>>>
>>> forecast_url = "https://api.darksky.net/forecast/%s/%s,%s?units=%s;
>>>
>>> On Thu, Aug 23, 2018 at 11:23 AM Colin Larsen  
>>> wrote:
>>>
 And found a couple more records issues with changes of units in 
 Rainfall - in -- mm

 Highest Daily Rainfall 0.2 in August 19, 2018 August 19, 2018 at 12:00 
 AM 0.2 in
 Highest Daily Rainfall Rate 0.3 mm August 19, 2018 at 12:00 AM August 
 19, 2018 at 12:00 AM 0.3 mm
 Month with Highest Total Rainfall 1.0 in August August, 2018 1.0 in
 Total Rainfall for 2018 25.4 mm 2018 25.4 mm

 On Thu, Aug 23, 2018 at 11:15 AM Colin Larsen  
 wrote:

> Hmmm, they weren't but the only difference was the Darksky_units I 
> think. I'll fix that later.
>
> Windy icon - fixed
> Records change of units - fixed
> Darksky - still a problem. Neither "auto" or "ca" seem to work so far. 
> I'm guessing that 'Visibility' also comes from Darksky?
>
> Visibility 3.84 miles
>
>
>
> On Thu, Aug 23, 2018 at 10:34 AM Pat O'Brien  
> wrote:
>
>> Hopefully all of your configurations are in weewx.conf. If so you can 
>> just download it and install it like before with wee_extension. 
>>
>> On Wed, Aug 22, 2018, 5:08 PM Colin Larsen  
>> wrote:
>>
>>> What's the best way to update Pat? 
>>>
>>> On Thu, 23 Aug 2018, 08:29 Pat,  wrote:
>>>
 Just released 0.2. Give it a try when you can. 


 https://github.com/poblabs/weewx-belchertown/releases/tag/weewx-belchertown-0.2


 On Wednesday, August 22, 2018 at 4:14:07 PM UTC-4, Colin Larsen 
 wrote:
>
> All good, thanks Pat 
>
> On Thu, Aug 23, 2018 at 12:20 AM Pat  wrote:
>
>> Most of it looks pretty good. Not bad for my first skin attempt 
>> :) 
>>
>> I knew imperial to metric would be an issue, and I had tried my 
>> best to plan for it. I didn't take timezones into consideration with 
>> my 
>> testing though - for example noticed on your test site that the 
>> forecast 
>> row has wrong borders and it's showing the weather for yesterday 
>> (for your 
>> timezone). I'll take a look into that. 
>>
>> I see my error with the records page conversion, so I'll have to 
>> issue an update on that one later today. 
>>
>> For DarkSky, I'll have to add the "units" flag. They have 6 
>> different unit types, so I'll have to update the setup guide too. 
>> Can't 
>> believe I missed that one! 
>>
>> I'll let you all know when I issue an update. Possibly late today 
>> (US Eastern time)
>>
>>
>> On Wednesday, August 22, 2018 at 12:30:47 AM UTC-4, Colin Larsen 
>> wrote:
>>>
>>> Arrgh, typo - www.41south.net.nz
>>>
>>> Also found this on the records page, note the change from metric 
>>> back to US units
>>>
>>> Highest Temperature 21.1 °C August 19, 2018 at 9:56 AM August 
>>> 19, 2018 at 9:56 AM 21.1 °C
>>> Lowest Temperature -1.1 °C August 18, 2018 at 4:58 PM August 
>>> 18, 2018 at 4:58 PM -1.1 °C
>>> Highest Heat Index 21.1 °C August 19, 2018 at 9:56 AM August 
>>> 19, 2018 at 9:56 AM 21.1 °C
>>> Lowest Wind Chill 21.1 °C August 19, 2018 at 9:56 AM August 19, 
>>> 2018 at 9:56 AM August 19, 2018 at 

[weewx-user] Winddirplot with weewx-Highcharts

[Praveen Chandrasekaran]

Hi,

I installed the HighCharts extension for weewx. Everything is fine except
that on plot wind direction shows 90 degrees for all days. In json file I
see the wind direction is fine. What could be the issue?

Regards,
Praveen

-- 
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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [weewx-user] Re: Belchertown skin for weewx now available!

[Thomas Keffer]

The tag "wind" can only be used in aggregations, such as day and year. The
tags windSpeed, windDir, windGust, and windGustDir can be used for current
observations, as well as aggregations. This is all explained in the
Customizing Guide, section *Wind
*.

Confusing, I know. It's the product of a legacy schema from wview, and the
need to flatten vector-like quantities into a two dimensional SQL table. A
more general solution would have been a separate table for each type (much
like the daily summaries), but that would break compatibility with wview,
as well as be slower.

-tk

On Fri, Aug 31, 2018 at 9:16 AM Pat O'Brien  wrote:

> I'm on mobile, so I read this again. Maybe the difference is year.wind as
> opposed to day?
>
> On Fri, Aug 31, 2018, 12:12 PM Pat O'Brien  wrote:
>
>> Interesting... Check this link as it is the official document.
>>
>> http://www.weewx.com/docs/customizing.htm
>>
>> Then search for "day.wind". You'll see the differences.
>>
>>
>> On Fri, Aug 31, 2018, 11:57 AM David Hathaway 
>> wrote:
>>
>>> Reckoned it was easy enough to try, so I changed the records code to
>>>
>>> 
>>> Strongest Wind Gust
>>> $year.windGust.max
>>> $year.windGust.maxtime.format("%B %-d, %Y at %-I:%M %p")
>>> $alltime.windGust.maxtime.format("%B %-d, %Y
>>> at %-I:%M %p")
>>> $alltime.windGust.max
>>> 
>>>
>>> (using windGust instead of wind)
>>>
>>> It does work in my installation.
>>>
>>>
>>> On Friday, August 31, 2018 at 9:32:23 AM UTC-5, David Hathaway wrote:

 This was the query right before the exception:


 Aug 31 08:06:51 hathaway weewx[22213]: manager: getSQL: SELECT dateTime
 FROM archive WHERE dateTime > 1389475998 AND dateTime <= 1535720760 AND
 wind = (SELECT MAX(wind) FROM archive WHERE dateTime > 1389475998 and
 dateTime <= 1535720760) AND wind IS NOT NULL
 Aug 31 08:06:51 hathaway weewx[22213]: cheetahgenerator: Generate
 failed with exception ''
 Aug 31 08:06:51 hathaway weewx[22213]: cheetahgenerator:  Ignoring
 template /etc/weewx/skins/Belchertown/records/index.html.tmpl
 Aug 31 08:06:51 hathaway weewx[22213]: cheetahgenerator:  Reason:
 (1054, "Unknown column 'wind' in 'where clause'")
 Aug 31 08:06:51 hathaway weewx[22213]:   Traceback (most recent
 call last):
 Aug 31 08:06:51 hathaway weewx[22213]: File
 "/usr/share/weewx/weewx/cheetahgenerator.py", line 330, in generate
 Aug 31 08:06:51 hathaway weewx[22213]:   print >> _file,
 compiled_template
 Aug 31 08:06:51 hathaway weewx[22213]: File
 "/usr/lib/python2.7/dist-packages/Cheetah/Template.py", line 1005, in
 __str__
 Aug 31 08:06:51 hathaway weewx[22213]:   rc = getattr(self,
 mainMethName)()
 Aug 31 08:06:51 hathaway weewx[22213]: File
 "_etc_weewx_skins_Belchertown_records_index_html_tmpl.py", line 1123, in
 respond
 Aug 31 08:06:51 hathaway weewx[22213]: File
 "_etc_weewx_skins_Belchertown_records_index_html_tmpl.py", line 385, in
 __errorCatcher46
 Aug 31 08:06:51 hathaway weewx[22213]: File "", line 1,
 in 
 Aug 31 08:06:51 hathaway weewx[22213]: File
 "/usr/share/weewx/weewx/tags.py", line 329, in __getattr__
 Aug 31 08:06:51 hathaway weewx[22213]:   return
 self._do_query(aggregate_type)
 Aug 31 08:06:51 hathaway weewx[22213]: File
 "/usr/share/weewx/weewx/tags.py", line 343, in _do_query
 Aug 31 08:06:51 hathaway weewx[22213]:   val=val,
 **self.option_dict)
 Aug 31 08:06:51 hathaway weewx[22213]: File
 "/usr/share/weewx/weewx/wxmanager.py", line 60, in getAggregate
 Aug 31 08:06:51 hathaway weewx[22213]:   return
 weewx.manager.DaySummaryManager.getAggregate(self, timespan, obs_type,
 aggregateType, **option_dict)
 Aug 31 08:06:51 hathaway weewx[22213]: File
 "/usr/share/weewx/weewx/manager.py", line 1252, in getAggregate
 Aug 31 08:06:51 hathaway weewx[22213]:   **option_dict)
 Aug 31 08:06:51 hathaway weewx[22213]: File
 "/usr/share/weewx/weewx/manager.py", line 461, in getAggregate
 Aug 31 08:06:51 hathaway weewx[22213]:   _row =
 self.getSql(select_stmt % interpolate_dict)
 Aug 31 08:06:51 hathaway weewx[22213]: File
 "/usr/share/weewx/weewx/manager.py", line 397, in getSql
 Aug 31 08:06:51 hathaway weewx[22213]:   _cursor.execute(sql,
 sqlargs)
 Aug 31 08:06:51 hathaway weewx[22213]: File
 "/usr/share/weewx/weedb/mysql.py", line 48, in guarded_fn
 Aug 31 08:06:51 hathaway weewx[22213]:   raise klass(e)
 Aug 31 08:06:51 hathaway weewx[22213]:   NoColumnError: (1054,
 "Unknown column 'wind' in 'where clause'")
 Aug 31 08:06:51 hathaway weewx[22213]: manager: getSQL: SELECT
 MIN(dateTime) FROM archive

 If I comment 

Re: [weewx-user] Re: Belchertown skin for weewx now available!

[Pat O'Brien]

I'm on mobile, so I read this again. Maybe the difference is year.wind as
opposed to day?

On Fri, Aug 31, 2018, 12:12 PM Pat O'Brien  wrote:

> Interesting... Check this link as it is the official document.
>
> http://www.weewx.com/docs/customizing.htm
>
> Then search for "day.wind". You'll see the differences.
>
>
> On Fri, Aug 31, 2018, 11:57 AM David Hathaway 
> wrote:
>
>> Reckoned it was easy enough to try, so I changed the records code to
>>
>> 
>> Strongest Wind Gust
>> $year.windGust.max
>> $year.windGust.maxtime.format("%B %-d, %Y at %-I:%M %p")
>> $alltime.windGust.maxtime.format("%B %-d, %Y
>> at %-I:%M %p")
>> $alltime.windGust.max
>> 
>>
>> (using windGust instead of wind)
>>
>> It does work in my installation.
>>
>>
>> On Friday, August 31, 2018 at 9:32:23 AM UTC-5, David Hathaway wrote:
>>>
>>> This was the query right before the exception:
>>>
>>>
>>> Aug 31 08:06:51 hathaway weewx[22213]: manager: getSQL: SELECT dateTime
>>> FROM archive WHERE dateTime > 1389475998 AND dateTime <= 1535720760 AND
>>> wind = (SELECT MAX(wind) FROM archive WHERE dateTime > 1389475998 and
>>> dateTime <= 1535720760) AND wind IS NOT NULL
>>> Aug 31 08:06:51 hathaway weewx[22213]: cheetahgenerator: Generate failed
>>> with exception ''
>>> Aug 31 08:06:51 hathaway weewx[22213]: cheetahgenerator:  Ignoring
>>> template /etc/weewx/skins/Belchertown/records/index.html.tmpl
>>> Aug 31 08:06:51 hathaway weewx[22213]: cheetahgenerator:  Reason:
>>> (1054, "Unknown column 'wind' in 'where clause'")
>>> Aug 31 08:06:51 hathaway weewx[22213]:   Traceback (most recent call
>>> last):
>>> Aug 31 08:06:51 hathaway weewx[22213]: File
>>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 330, in generate
>>> Aug 31 08:06:51 hathaway weewx[22213]:   print >> _file,
>>> compiled_template
>>> Aug 31 08:06:51 hathaway weewx[22213]: File
>>> "/usr/lib/python2.7/dist-packages/Cheetah/Template.py", line 1005, in
>>> __str__
>>> Aug 31 08:06:51 hathaway weewx[22213]:   rc = getattr(self,
>>> mainMethName)()
>>> Aug 31 08:06:51 hathaway weewx[22213]: File
>>> "_etc_weewx_skins_Belchertown_records_index_html_tmpl.py", line 1123, in
>>> respond
>>> Aug 31 08:06:51 hathaway weewx[22213]: File
>>> "_etc_weewx_skins_Belchertown_records_index_html_tmpl.py", line 385, in
>>> __errorCatcher46
>>> Aug 31 08:06:51 hathaway weewx[22213]: File "", line 1,
>>> in 
>>> Aug 31 08:06:51 hathaway weewx[22213]: File
>>> "/usr/share/weewx/weewx/tags.py", line 329, in __getattr__
>>> Aug 31 08:06:51 hathaway weewx[22213]:   return
>>> self._do_query(aggregate_type)
>>> Aug 31 08:06:51 hathaway weewx[22213]: File
>>> "/usr/share/weewx/weewx/tags.py", line 343, in _do_query
>>> Aug 31 08:06:51 hathaway weewx[22213]:   val=val,
>>> **self.option_dict)
>>> Aug 31 08:06:51 hathaway weewx[22213]: File
>>> "/usr/share/weewx/weewx/wxmanager.py", line 60, in getAggregate
>>> Aug 31 08:06:51 hathaway weewx[22213]:   return
>>> weewx.manager.DaySummaryManager.getAggregate(self, timespan, obs_type,
>>> aggregateType, **option_dict)
>>> Aug 31 08:06:51 hathaway weewx[22213]: File
>>> "/usr/share/weewx/weewx/manager.py", line 1252, in getAggregate
>>> Aug 31 08:06:51 hathaway weewx[22213]:   **option_dict)
>>> Aug 31 08:06:51 hathaway weewx[22213]: File
>>> "/usr/share/weewx/weewx/manager.py", line 461, in getAggregate
>>> Aug 31 08:06:51 hathaway weewx[22213]:   _row =
>>> self.getSql(select_stmt % interpolate_dict)
>>> Aug 31 08:06:51 hathaway weewx[22213]: File
>>> "/usr/share/weewx/weewx/manager.py", line 397, in getSql
>>> Aug 31 08:06:51 hathaway weewx[22213]:   _cursor.execute(sql,
>>> sqlargs)
>>> Aug 31 08:06:51 hathaway weewx[22213]: File
>>> "/usr/share/weewx/weedb/mysql.py", line 48, in guarded_fn
>>> Aug 31 08:06:51 hathaway weewx[22213]:   raise klass(e)
>>> Aug 31 08:06:51 hathaway weewx[22213]:   NoColumnError: (1054,
>>> "Unknown column 'wind' in 'where clause'")
>>> Aug 31 08:06:51 hathaway weewx[22213]: manager: getSQL: SELECT
>>> MIN(dateTime) FROM archive
>>>
>>> If I comment out this part, I don't get the exception:
>>>
>>> #if $Extras.has_key('show_windrun')
>>> and $Extras.show_windrun == '1'
>>> 
>>> >> colspan=5>Wind Records
>>> 
>>> 
>>> >> colspan=1> 
>>> >> colspan=2>$current.dateTime.format("%Y")
>>> >> class="records-header-alltime" colspan=2>All Time
>>> 
>>> 
>>> Strongest Wind Gust
>>>

Re: [weewx-user] Re: Belchertown skin for weewx now available!

[Pat O'Brien]

Interesting... Check this link as it is the official document.

http://www.weewx.com/docs/customizing.htm

Then search for "day.wind". You'll see the differences.


On Fri, Aug 31, 2018, 11:57 AM David Hathaway 
wrote:

> Reckoned it was easy enough to try, so I changed the records code to
>
> 
> Strongest Wind Gust
> $year.windGust.max
> $year.windGust.maxtime.format("%B %-d, %Y at %-I:%M %p")
> $alltime.windGust.maxtime.format("%B %-d, %Y at
> %-I:%M %p")
> $alltime.windGust.max
> 
>
> (using windGust instead of wind)
>
> It does work in my installation.
>
>
> On Friday, August 31, 2018 at 9:32:23 AM UTC-5, David Hathaway wrote:
>>
>> This was the query right before the exception:
>>
>>
>> Aug 31 08:06:51 hathaway weewx[22213]: manager: getSQL: SELECT dateTime
>> FROM archive WHERE dateTime > 1389475998 AND dateTime <= 1535720760 AND
>> wind = (SELECT MAX(wind) FROM archive WHERE dateTime > 1389475998 and
>> dateTime <= 1535720760) AND wind IS NOT NULL
>> Aug 31 08:06:51 hathaway weewx[22213]: cheetahgenerator: Generate failed
>> with exception ''
>> Aug 31 08:06:51 hathaway weewx[22213]: cheetahgenerator:  Ignoring
>> template /etc/weewx/skins/Belchertown/records/index.html.tmpl
>> Aug 31 08:06:51 hathaway weewx[22213]: cheetahgenerator:  Reason:
>> (1054, "Unknown column 'wind' in 'where clause'")
>> Aug 31 08:06:51 hathaway weewx[22213]:   Traceback (most recent call
>> last):
>> Aug 31 08:06:51 hathaway weewx[22213]: File
>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 330, in generate
>> Aug 31 08:06:51 hathaway weewx[22213]:   print >> _file,
>> compiled_template
>> Aug 31 08:06:51 hathaway weewx[22213]: File
>> "/usr/lib/python2.7/dist-packages/Cheetah/Template.py", line 1005, in
>> __str__
>> Aug 31 08:06:51 hathaway weewx[22213]:   rc = getattr(self,
>> mainMethName)()
>> Aug 31 08:06:51 hathaway weewx[22213]: File
>> "_etc_weewx_skins_Belchertown_records_index_html_tmpl.py", line 1123, in
>> respond
>> Aug 31 08:06:51 hathaway weewx[22213]: File
>> "_etc_weewx_skins_Belchertown_records_index_html_tmpl.py", line 385, in
>> __errorCatcher46
>> Aug 31 08:06:51 hathaway weewx[22213]: File "", line 1,
>> in 
>> Aug 31 08:06:51 hathaway weewx[22213]: File
>> "/usr/share/weewx/weewx/tags.py", line 329, in __getattr__
>> Aug 31 08:06:51 hathaway weewx[22213]:   return
>> self._do_query(aggregate_type)
>> Aug 31 08:06:51 hathaway weewx[22213]: File
>> "/usr/share/weewx/weewx/tags.py", line 343, in _do_query
>> Aug 31 08:06:51 hathaway weewx[22213]:   val=val,
>> **self.option_dict)
>> Aug 31 08:06:51 hathaway weewx[22213]: File
>> "/usr/share/weewx/weewx/wxmanager.py", line 60, in getAggregate
>> Aug 31 08:06:51 hathaway weewx[22213]:   return
>> weewx.manager.DaySummaryManager.getAggregate(self, timespan, obs_type,
>> aggregateType, **option_dict)
>> Aug 31 08:06:51 hathaway weewx[22213]: File
>> "/usr/share/weewx/weewx/manager.py", line 1252, in getAggregate
>> Aug 31 08:06:51 hathaway weewx[22213]:   **option_dict)
>> Aug 31 08:06:51 hathaway weewx[22213]: File
>> "/usr/share/weewx/weewx/manager.py", line 461, in getAggregate
>> Aug 31 08:06:51 hathaway weewx[22213]:   _row =
>> self.getSql(select_stmt % interpolate_dict)
>> Aug 31 08:06:51 hathaway weewx[22213]: File
>> "/usr/share/weewx/weewx/manager.py", line 397, in getSql
>> Aug 31 08:06:51 hathaway weewx[22213]:   _cursor.execute(sql,
>> sqlargs)
>> Aug 31 08:06:51 hathaway weewx[22213]: File
>> "/usr/share/weewx/weedb/mysql.py", line 48, in guarded_fn
>> Aug 31 08:06:51 hathaway weewx[22213]:   raise klass(e)
>> Aug 31 08:06:51 hathaway weewx[22213]:   NoColumnError: (1054,
>> "Unknown column 'wind' in 'where clause'")
>> Aug 31 08:06:51 hathaway weewx[22213]: manager: getSQL: SELECT
>> MIN(dateTime) FROM archive
>>
>> If I comment out this part, I don't get the exception:
>>
>> #if $Extras.has_key('show_windrun')
>> and $Extras.show_windrun == '1'
>> 
>> > colspan=5>Wind Records
>> 
>> 
>> > colspan=1> 
>> > colspan=2>$current.dateTime.format("%Y")
>> > class="records-header-alltime" colspan=2>All Time
>> 
>> 
>> Strongest Wind Gust
>> > class="leftborder">$year.wind.max
>> $year.wind.maxtime.format("%B
>> %-d, %Y at %-I:%M %p")
>> > class="leftborder">$alltime.wind.maxtime.format("%B %-d, %Y at %-I:%M
>> %p")

[weewx-user] Re: after raspbian and weewx updates, weewx is still collecting data but stopped publishing to CWOP and Wunderground

[Boston Tom]

Thank you Gary! Success!  The workaround of increasing the stale record 
time to 120 seconds is working.

I have had contact with the developer of the interceptor driver in the 
past, so I will post this issue to his GitHub page 
at https://github.com/matthewwall/weewx-interceptor

However, since all was fine with weewx and the interceptor driver until I 
changed hardware (and subsequent new Lacrosse software to run it)  I 
suspect the issue lies with how the new Lacrosse software is presenting the 
data to weewx.  Since the Lacrosse software is proprietary, there is likely 
little that can be done on that side.

The workaround is probably going to be the best long term solution.

For anyone else who may come here looking for support, my weather station 
model is Lacrosse S84060.

Thanks again for your helping me with this, and have a great weekend!





On Friday, August 31, 2018 at 12:32:24 AM UTC-4, gjr80 wrote:
>
> Tom,
>
> At least it is apparent from the log why the CWOP posts are failing, but 
> what is the underlying cause is another matter. By default CWOP posts the 
> relevant data from the archive record every 10 minutes; however, when the 
> data is to be posted it's age is checked and it's considered as stale if it 
> is older than 60 seconds. If you look at the log extract you provided you 
> can see the 11:20:00 archive record was generated and saved to database at 
> 11:21:33:
>
> Aug 29 11:21:33 raspberrypi2 weewx[26138]: manager: Added record 2018-08-
> 29 11:20:00 EDT (1535556000) to database 'weewx.sdb' 
> Aug 29 11:21:33 raspberrypi2 weewx[26138]: manager: Added record 2018-08-
> 29 11:20:00 EDT (1535556000) to daily summary in 'weewx.sdb'
>
> WeeWX attempted to post the 11:20:00 data to CWOP at 11:21:33 but by that 
> time the archive record data was 93 seconds old (11:21:33 - 11:20:00) and 
> hence it was skipped:
>
> Aug 29 11:21:33 raspberrypi2 weewx[26138]: restx: CWOP: record 2018-08-29 
> 11:20:00 EDT (1535556000) is stale (93 > 60).
>
> I assume this is the case on each archive record and that is why no CWOP 
> records are being posted. However, the underlying reason is another matter. 
> I have never used the interceptor driver but it seems odd that the 11:20:00 
> record is saved to database at 11:21:33, I would expect that to happen 
> about 1 minute earlier, usually within a few seconds of the archive record 
> timestamp; perhaps this is a peculiarity of the interceptor driver. Perhaps 
> someone knowledgeable on the interceptor driver and your station can 
> comment.
>
> In the meantime you get things working by explicitly setting the stale 
> config option for CWOP posts. To do this edit weewx.conf and locate the 
> [[CWOP]] stanza under [StdRESTful], add in a line stale = 120. You should 
> end up with something like:
>
>
> [[CWOP]]
> # This section is for configuring posts to CWOP.
> 
> # If you wish to do this, set the option 'enable' to true,
> # and specify the station ID (e.g., CW1234).
> enable = true
> station = XXX obfuscated by wee_debug XXX
> 
> # If this is an APRS (radio amateur) station, uncomment
> # the following and replace with a passcode (e.g., 12345).
> passcode = "removed"
> post_interval = 600
> server_list = rotate.aprs.net:14580, rotate.aprs.net:14580
> stale = 120
>
> Save weewx.conf then restart WeeWX. Monitor your log and hopefully you 
> will see CWOP data being posted. Once you are happy you can set debug=0 
> again (and restart WeeWX) to cut down on your log entries.
>
> Gary
>
>
>
>

-- 
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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [weewx-user] Re: Belchertown skin for weewx now available!

[David Hathaway]

Reckoned it was easy enough to try, so I changed the records code to


Strongest Wind Gust
$year.windGust.max
$year.windGust.maxtime.format("%B %-d, %Y at %-I:%M %p")
$alltime.windGust.maxtime.format("%B %-d, %Y at 
%-I:%M %p")
$alltime.windGust.max


(using windGust instead of wind)

It does work in my installation.


On Friday, August 31, 2018 at 9:32:23 AM UTC-5, David Hathaway wrote:
>
> This was the query right before the exception:
>
>
> Aug 31 08:06:51 hathaway weewx[22213]: manager: getSQL: SELECT dateTime 
> FROM archive WHERE dateTime > 1389475998 AND dateTime <= 1535720760 AND 
> wind = (SELECT MAX(wind) FROM archive WHERE dateTime > 1389475998 and 
> dateTime <= 1535720760) AND wind IS NOT NULL
> Aug 31 08:06:51 hathaway weewx[22213]: cheetahgenerator: Generate failed 
> with exception ''
> Aug 31 08:06:51 hathaway weewx[22213]: cheetahgenerator:  Ignoring 
> template /etc/weewx/skins/Belchertown/records/index.html.tmpl
> Aug 31 08:06:51 hathaway weewx[22213]: cheetahgenerator:  Reason: 
> (1054, "Unknown column 'wind' in 'where clause'")
> Aug 31 08:06:51 hathaway weewx[22213]:   Traceback (most recent call 
> last):
> Aug 31 08:06:51 hathaway weewx[22213]: File 
> "/usr/share/weewx/weewx/cheetahgenerator.py", line 330, in generate
> Aug 31 08:06:51 hathaway weewx[22213]:   print >> _file, 
> compiled_template
> Aug 31 08:06:51 hathaway weewx[22213]: File 
> "/usr/lib/python2.7/dist-packages/Cheetah/Template.py", line 1005, in 
> __str__
> Aug 31 08:06:51 hathaway weewx[22213]:   rc = getattr(self, 
> mainMethName)()
> Aug 31 08:06:51 hathaway weewx[22213]: File 
> "_etc_weewx_skins_Belchertown_records_index_html_tmpl.py", line 1123, in 
> respond
> Aug 31 08:06:51 hathaway weewx[22213]: File 
> "_etc_weewx_skins_Belchertown_records_index_html_tmpl.py", line 385, in 
> __errorCatcher46
> Aug 31 08:06:51 hathaway weewx[22213]: File "", line 1, in 
> 
> Aug 31 08:06:51 hathaway weewx[22213]: File 
> "/usr/share/weewx/weewx/tags.py", line 329, in __getattr__
> Aug 31 08:06:51 hathaway weewx[22213]:   return 
> self._do_query(aggregate_type)
> Aug 31 08:06:51 hathaway weewx[22213]: File 
> "/usr/share/weewx/weewx/tags.py", line 343, in _do_query
> Aug 31 08:06:51 hathaway weewx[22213]:   val=val, 
> **self.option_dict)
> Aug 31 08:06:51 hathaway weewx[22213]: File 
> "/usr/share/weewx/weewx/wxmanager.py", line 60, in getAggregate
> Aug 31 08:06:51 hathaway weewx[22213]:   return 
> weewx.manager.DaySummaryManager.getAggregate(self, timespan, obs_type, 
> aggregateType, **option_dict)
> Aug 31 08:06:51 hathaway weewx[22213]: File 
> "/usr/share/weewx/weewx/manager.py", line 1252, in getAggregate
> Aug 31 08:06:51 hathaway weewx[22213]:   **option_dict)
> Aug 31 08:06:51 hathaway weewx[22213]: File 
> "/usr/share/weewx/weewx/manager.py", line 461, in getAggregate
> Aug 31 08:06:51 hathaway weewx[22213]:   _row = 
> self.getSql(select_stmt % interpolate_dict)
> Aug 31 08:06:51 hathaway weewx[22213]: File 
> "/usr/share/weewx/weewx/manager.py", line 397, in getSql
> Aug 31 08:06:51 hathaway weewx[22213]:   _cursor.execute(sql, 
> sqlargs)
> Aug 31 08:06:51 hathaway weewx[22213]: File 
> "/usr/share/weewx/weedb/mysql.py", line 48, in guarded_fn
> Aug 31 08:06:51 hathaway weewx[22213]:   raise klass(e)
> Aug 31 08:06:51 hathaway weewx[22213]:   NoColumnError: (1054, 
> "Unknown column 'wind' in 'where clause'")
> Aug 31 08:06:51 hathaway weewx[22213]: manager: getSQL: SELECT 
> MIN(dateTime) FROM archive
>
> If I comment out this part, I don't get the exception:
>
> #if $Extras.has_key('show_windrun') 
> and $Extras.show_windrun == '1'
> 
>  colspan=5>Wind Records
> 
> 
>  colspan=1> 
>  colspan=2>$current.dateTime.format("%Y")
>  colspan=2>All Time
> 
> 
> Strongest Wind Gust
>  class="leftborder">$year.wind.max
> $year.wind.maxtime.format("%B 
> %-d, %Y at %-I:%M %p")
>  class="leftborder">$alltime.wind.maxtime.format("%B %-d, %Y at %-I:%M 
> %p")
> $alltime.wind.max
> 
> 
> #end if
>
> Perhaps instead of $year.wind.maxtime it should be 

Re: [weewx-user] Re: Belchertown skin for weewx now available!

[David Hathaway]

Andrew,

Thanks for the pointer.  I'll have to read this several times to let what 
it says sink in.

Dave

On Friday, August 31, 2018 at 9:10:30 AM UTC-5, Andrew Milner wrote:
>
> Gary gave a description of the wind tag in this thread:
>
> https://groups.google.com/forum/?fromgroups=#!topic/weewx-user/siTLWVi_fLM
>
>
> On Friday, 31 August 2018 16:13:59 UTC+3, Pat wrote:
>>
>> As far as I know, my skin isn’t specifying a query for wind. A search on 
>> the repo in GitHub shows that the columns I query are “windSpeed, 
>> windGust”, etc. 
>>
>>  
>>
>> Anything for “wind” is done through a built in weewx call for $day.wind, 
>> $week.wind, etc. 
>>
>>  
>>
>> Where do you see this query? 
>>
>>  
>>
>>  
>>
>> *From:* weewx...@googlegroups.com [mailto:weewx...@googlegroups.com] *On 
>> Behalf Of *David Hathaway
>> *Sent:* Friday, August 31, 2018 9:07 AM
>> *To:* weewx-user 
>> *Subject:* Re: [weewx-user] Re: Belchertown skin for weewx now available!
>>
>>  
>>
>> Well, this is interesting.  Here is a statement that fails:
>>
>>  
>>
>> SELECT dateTime FROM archive WHERE dateTime > 1389475998 AND dateTime <= 
>> 1535720400 AND wind = (SELECT MAX(wind) FROM archive WHERE dateTime > 
>> 1389475998 and dateTime <= 1535720400) AND wind IS NOT NULL
>>
>>  
>>
>> My schema has windSpeed, windDir, windGust, and windGustDir.  Should it 
>> have plain old 'wind'?
>>
>>  
>>
>> Dave
>>
>>  
>>
>>  
>>
>>  
>>
>> On Fri, Aug 31, 2018 at 7:50 AM David Hathaway  
>> wrote:
>>
>> I'd like to solve my "wind" issue, since I have to modify the template on 
>> each revision.  What table is lacking "wind"?
>>
>>  
>>
>> Aug 31 07:40:53 hathaway weewx[32401]: cheetahgenerator:  Ignoring 
>> template /etc/weewx/skins/Belchertown/records/index.html.tmpl
>>
>> Aug 31 07:40:53 hathaway weewx[32401]: cheetahgenerator:  Reason: 
>> (1054, "Unknown column 'wind' in 'where clause'")
>>
>> Aug 31 07:40:53 hathaway weewx[32401]:   Traceback (most recent call 
>> last):
>>
>> Aug 31 07:40:53 hathaway weewx[32401]: File 
>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 330, in generate
>>
>> Aug 31 07:40:53 hathaway weewx[32401]:   print >> _file, 
>> compiled_template
>>
>> Aug 31 07:40:53 hathaway weewx[32401]: File 
>> "/usr/lib/python2.7/dist-packages/Cheetah/Template.py", line 1005, in 
>> __str__
>>
>> Aug 31 07:40:53 hathaway weewx[32401]:   rc = getattr(self, 
>> mainMethName)()
>>
>> Aug 31 07:40:53 hathaway weewx[32401]: File 
>> "cheetah__etc_weewx_skins_Belchertown_records_index_html_tmpl_1535719243_19_63343.py",
>>  
>> line 1124, in respond
>>
>> Aug 31 07:40:53 hathaway weewx[32401]: File 
>> "cheetah__etc_weewx_skins_Belchertown_records_index_html_tmpl_1535719243_19_63343.py",
>>  
>> line 385, in __errorCatcher46
>>
>> Aug 31 07:40:53 hathaway weewx[32401]: File "", line 1, 
>> in 
>>
>> Aug 31 07:40:53 hathaway weewx[32401]: File 
>> "/usr/share/weewx/weewx/tags.py", line 329, in __getattr__
>>
>> Aug 31 07:40:53 hathaway weewx[32401]:   return 
>> self._do_query(aggregate_type)
>>
>> Aug 31 07:40:53 hathaway weewx[32401]: File 
>> "/usr/share/weewx/weewx/tags.py", line 343, in _do_query
>>
>> Aug 31 07:40:53 hathaway weewx[32401]:   val=val, 
>> **self.option_dict)
>>
>> Aug 31 07:40:53 hathaway weewx[32401]: File 
>> "/usr/share/weewx/weewx/wxmanager.py", line 60, in getAggregate
>>
>> Aug 31 07:40:53 hathaway weewx[32401]:   return 
>> weewx.manager.DaySummaryManager.getAggregate(self, timespan, obs_type, 
>> aggregateType, **option_dict)
>>
>> Aug 31 07:40:53 hathaway weewx[32401]: File 
>> "/usr/share/weewx/weewx/manager.py", line 1249, in getAggregate
>>
>> Aug 31 07:40:53 hathaway weewx[32401]:   **option_dict)
>>
>> Aug 31 07:40:53 hathaway weewx[32401]: File 
>> "/usr/share/weewx/weewx/manager.py", line 458, in getAggregate
>>
>> Aug 31 07:40:53 hathaway weewx[32401]:   _row = 
>> self.getSql(select_stmt % interpolate_dict)
>>
>> Aug 31 07:40:53 hathaway weewx[32401]: File 
>> "/usr/share/weewx/weewx/manager.py", line 394, in getSql
>>
>> Aug 31 07:40:53 hathaway weewx[32401]:   _cursor.execute(sql, 
>> sqlargs)
>>
>> Aug 31 07:40:53 hathaway weewx[32401]: File 
>> "/usr/share/weewx/weedb/mysql.py", line 48, in guarded_fn
>>
>> Aug 31 07:40:53 hathaway weewx[32401]:   raise klass(e)
>>
>> Aug 31 07:40:53 hathaway weewx[32401]:   NoColumnError: (1054, 
>> "Unknown column 'wind' in 'where clause'")
>>
>> Aug 31 07:41:11 hathaway weewx[32401]: cheetahgenerator: Generated 15 
>> files for report Belchertown in 113.97 seconds
>>
>>  
>>
>> On Fri, Aug 31, 2018 at 1:27 AM Juan Antonio Mosquera <
>> juananton...@juanantoniomosquera.com> wrote:
>>
>> Intall 0.6 version now... and same problem. My installation is wit APT
>>
>>  
>>
>>  
>>
>>  
>>
>> Aug 31 08:25:17 meteomontaos weewx[14817]: reportengine: Found 
>> configuration 

Re: [weewx-user] Re: Belchertown skin for weewx now available!

[David Hathaway]

This was the query right before the exception:


Aug 31 08:06:51 hathaway weewx[22213]: manager: getSQL: SELECT dateTime 
FROM archive WHERE dateTime > 1389475998 AND dateTime <= 1535720760 AND 
wind = (SELECT MAX(wind) FROM archive WHERE dateTime > 1389475998 and 
dateTime <= 1535720760) AND wind IS NOT NULL
Aug 31 08:06:51 hathaway weewx[22213]: cheetahgenerator: Generate failed 
with exception ''
Aug 31 08:06:51 hathaway weewx[22213]: cheetahgenerator:  Ignoring 
template /etc/weewx/skins/Belchertown/records/index.html.tmpl
Aug 31 08:06:51 hathaway weewx[22213]: cheetahgenerator:  Reason: 
(1054, "Unknown column 'wind' in 'where clause'")
Aug 31 08:06:51 hathaway weewx[22213]:   Traceback (most recent call 
last):
Aug 31 08:06:51 hathaway weewx[22213]: File 
"/usr/share/weewx/weewx/cheetahgenerator.py", line 330, in generate
Aug 31 08:06:51 hathaway weewx[22213]:   print >> _file, 
compiled_template
Aug 31 08:06:51 hathaway weewx[22213]: File 
"/usr/lib/python2.7/dist-packages/Cheetah/Template.py", line 1005, in 
__str__
Aug 31 08:06:51 hathaway weewx[22213]:   rc = getattr(self, 
mainMethName)()
Aug 31 08:06:51 hathaway weewx[22213]: File 
"_etc_weewx_skins_Belchertown_records_index_html_tmpl.py", line 1123, in 
respond
Aug 31 08:06:51 hathaway weewx[22213]: File 
"_etc_weewx_skins_Belchertown_records_index_html_tmpl.py", line 385, in 
__errorCatcher46
Aug 31 08:06:51 hathaway weewx[22213]: File "", line 1, in 

Aug 31 08:06:51 hathaway weewx[22213]: File 
"/usr/share/weewx/weewx/tags.py", line 329, in __getattr__
Aug 31 08:06:51 hathaway weewx[22213]:   return 
self._do_query(aggregate_type)
Aug 31 08:06:51 hathaway weewx[22213]: File 
"/usr/share/weewx/weewx/tags.py", line 343, in _do_query
Aug 31 08:06:51 hathaway weewx[22213]:   val=val, 
**self.option_dict)
Aug 31 08:06:51 hathaway weewx[22213]: File 
"/usr/share/weewx/weewx/wxmanager.py", line 60, in getAggregate
Aug 31 08:06:51 hathaway weewx[22213]:   return 
weewx.manager.DaySummaryManager.getAggregate(self, timespan, obs_type, 
aggregateType, **option_dict)
Aug 31 08:06:51 hathaway weewx[22213]: File 
"/usr/share/weewx/weewx/manager.py", line 1252, in getAggregate
Aug 31 08:06:51 hathaway weewx[22213]:   **option_dict)
Aug 31 08:06:51 hathaway weewx[22213]: File 
"/usr/share/weewx/weewx/manager.py", line 461, in getAggregate
Aug 31 08:06:51 hathaway weewx[22213]:   _row = 
self.getSql(select_stmt % interpolate_dict)
Aug 31 08:06:51 hathaway weewx[22213]: File 
"/usr/share/weewx/weewx/manager.py", line 397, in getSql
Aug 31 08:06:51 hathaway weewx[22213]:   _cursor.execute(sql, 
sqlargs)
Aug 31 08:06:51 hathaway weewx[22213]: File 
"/usr/share/weewx/weedb/mysql.py", line 48, in guarded_fn
Aug 31 08:06:51 hathaway weewx[22213]:   raise klass(e)
Aug 31 08:06:51 hathaway weewx[22213]:   NoColumnError: (1054, "Unknown 
column 'wind' in 'where clause'")
Aug 31 08:06:51 hathaway weewx[22213]: manager: getSQL: SELECT 
MIN(dateTime) FROM archive

If I comment out this part, I don't get the exception:

#if $Extras.has_key('show_windrun') and 
$Extras.show_windrun == '1'

Wind Records


 
$current.dateTime.format("%Y")
All Time


Strongest Wind Gust
$year.wind.max
$year.wind.maxtime.format("%B 
%-d, %Y at %-I:%M %p")
$alltime.wind.maxtime.format("%B %-d, %Y at %-I:%M 
%p")
$alltime.wind.max  
  

#end if

Perhaps instead of $year.wind.maxtime it should be $year.windGust.maxtime ?




On Friday, August 31, 2018 at 8:13:59 AM UTC-5, Pat wrote:
>
> As far as I know, my skin isn’t specifying a query for wind. A search on 
> the repo in GitHub shows that the columns I query are “windSpeed, 
> windGust”, etc. 
>
>  
>
> Anything for “wind” is done through a built in weewx call for $day.wind, 
> $week.wind, etc. 
>
>  
>
> Where do you see this query? 
>
>  
>
>  
>
> *From:* weewx...@googlegroups.com  [mailto:
> weewx...@googlegroups.com ] *On Behalf Of *David Hathaway
> *Sent:* Friday, August 31, 2018 9:07 AM
> *To:* weewx-user >
> *Subject:* Re: [weewx-user] Re: Belchertown skin for weewx now available!
>
>  
>
> Well, this is interesting.  Here is a 

Re: [weewx-user] Re: Belchertown skin for weewx now available!

[Andrew Milner]

Gary gave a description of the wind tag in this thread:

https://groups.google.com/forum/?fromgroups=#!topic/weewx-user/siTLWVi_fLM


On Friday, 31 August 2018 16:13:59 UTC+3, Pat wrote:
>
> As far as I know, my skin isn’t specifying a query for wind. A search on 
> the repo in GitHub shows that the columns I query are “windSpeed, 
> windGust”, etc. 
>
>  
>
> Anything for “wind” is done through a built in weewx call for $day.wind, 
> $week.wind, etc. 
>
>  
>
> Where do you see this query? 
>
>  
>
>  
>
> *From:* weewx...@googlegroups.com  [mailto:
> weewx...@googlegroups.com ] *On Behalf Of *David Hathaway
> *Sent:* Friday, August 31, 2018 9:07 AM
> *To:* weewx-user >
> *Subject:* Re: [weewx-user] Re: Belchertown skin for weewx now available!
>
>  
>
> Well, this is interesting.  Here is a statement that fails:
>
>  
>
> SELECT dateTime FROM archive WHERE dateTime > 1389475998 AND dateTime <= 
> 1535720400 AND wind = (SELECT MAX(wind) FROM archive WHERE dateTime > 
> 1389475998 and dateTime <= 1535720400) AND wind IS NOT NULL
>
>  
>
> My schema has windSpeed, windDir, windGust, and windGustDir.  Should it 
> have plain old 'wind'?
>
>  
>
> Dave
>
>  
>
>  
>
>  
>
> On Fri, Aug 31, 2018 at 7:50 AM David Hathaway  > wrote:
>
> I'd like to solve my "wind" issue, since I have to modify the template on 
> each revision.  What table is lacking "wind"?
>
>  
>
> Aug 31 07:40:53 hathaway weewx[32401]: cheetahgenerator:  Ignoring 
> template /etc/weewx/skins/Belchertown/records/index.html.tmpl
>
> Aug 31 07:40:53 hathaway weewx[32401]: cheetahgenerator:  Reason: 
> (1054, "Unknown column 'wind' in 'where clause'")
>
> Aug 31 07:40:53 hathaway weewx[32401]:   Traceback (most recent call 
> last):
>
> Aug 31 07:40:53 hathaway weewx[32401]: File 
> "/usr/share/weewx/weewx/cheetahgenerator.py", line 330, in generate
>
> Aug 31 07:40:53 hathaway weewx[32401]:   print >> _file, 
> compiled_template
>
> Aug 31 07:40:53 hathaway weewx[32401]: File 
> "/usr/lib/python2.7/dist-packages/Cheetah/Template.py", line 1005, in 
> __str__
>
> Aug 31 07:40:53 hathaway weewx[32401]:   rc = getattr(self, 
> mainMethName)()
>
> Aug 31 07:40:53 hathaway weewx[32401]: File 
> "cheetah__etc_weewx_skins_Belchertown_records_index_html_tmpl_1535719243_19_63343.py",
>  
> line 1124, in respond
>
> Aug 31 07:40:53 hathaway weewx[32401]: File 
> "cheetah__etc_weewx_skins_Belchertown_records_index_html_tmpl_1535719243_19_63343.py",
>  
> line 385, in __errorCatcher46
>
> Aug 31 07:40:53 hathaway weewx[32401]: File "", line 1, in 
> 
>
> Aug 31 07:40:53 hathaway weewx[32401]: File 
> "/usr/share/weewx/weewx/tags.py", line 329, in __getattr__
>
> Aug 31 07:40:53 hathaway weewx[32401]:   return 
> self._do_query(aggregate_type)
>
> Aug 31 07:40:53 hathaway weewx[32401]: File 
> "/usr/share/weewx/weewx/tags.py", line 343, in _do_query
>
> Aug 31 07:40:53 hathaway weewx[32401]:   val=val, 
> **self.option_dict)
>
> Aug 31 07:40:53 hathaway weewx[32401]: File 
> "/usr/share/weewx/weewx/wxmanager.py", line 60, in getAggregate
>
> Aug 31 07:40:53 hathaway weewx[32401]:   return 
> weewx.manager.DaySummaryManager.getAggregate(self, timespan, obs_type, 
> aggregateType, **option_dict)
>
> Aug 31 07:40:53 hathaway weewx[32401]: File 
> "/usr/share/weewx/weewx/manager.py", line 1249, in getAggregate
>
> Aug 31 07:40:53 hathaway weewx[32401]:   **option_dict)
>
> Aug 31 07:40:53 hathaway weewx[32401]: File 
> "/usr/share/weewx/weewx/manager.py", line 458, in getAggregate
>
> Aug 31 07:40:53 hathaway weewx[32401]:   _row = 
> self.getSql(select_stmt % interpolate_dict)
>
> Aug 31 07:40:53 hathaway weewx[32401]: File 
> "/usr/share/weewx/weewx/manager.py", line 394, in getSql
>
> Aug 31 07:40:53 hathaway weewx[32401]:   _cursor.execute(sql, 
> sqlargs)
>
> Aug 31 07:40:53 hathaway weewx[32401]: File 
> "/usr/share/weewx/weedb/mysql.py", line 48, in guarded_fn
>
> Aug 31 07:40:53 hathaway weewx[32401]:   raise klass(e)
>
> Aug 31 07:40:53 hathaway weewx[32401]:   NoColumnError: (1054, 
> "Unknown column 'wind' in 'where clause'")
>
> Aug 31 07:41:11 hathaway weewx[32401]: cheetahgenerator: Generated 15 
> files for report Belchertown in 113.97 seconds
>
>  
>
> On Fri, Aug 31, 2018 at 1:27 AM Juan Antonio Mosquera <
> juananton...@juanantoniomosquera.com > wrote:
>
> Intall 0.6 version now... and same problem. My installation is wit APT
>
>  
>
>  
>
>  
>
> Aug 31 08:25:17 meteomontaos weewx[14817]: reportengine: Found 
> configuration file /etc/weewx/skins/Belchertown/skin.conf for report 
> Belchertown
>
> Aug 31 08:25:18 meteomontaos weewx[14817]: cheetahgenerator: using search 
> list ['weewx.cheetahgenerator.Almanac', 'weewx.cheetahgenerator.Station', 
> 'weewx.cheetahgenerator.Current', 'weewx.cheetahgenerator.Stats', 
> 'weewx.cheetahgenerator.UnitInfo', 

RE: [weewx-user] Re: Belchertown skin for weewx now available!

[Pat O'Brien]

As far as I know, my skin isn’t specifying a query for wind. A search on the 
repo in GitHub shows that the columns I query are “windSpeed, windGust”, etc. 

 

Anything for “wind” is done through a built in weewx call for $day.wind, 
$week.wind, etc. 

 

Where do you see this query? 

 

 

From: weewx-user@googlegroups.com [mailto:weewx-user@googlegroups.com] On 
Behalf Of David Hathaway
Sent: Friday, August 31, 2018 9:07 AM
To: weewx-user 
Subject: Re: [weewx-user] Re: Belchertown skin for weewx now available!

 

Well, this is interesting.  Here is a statement that fails:

 

SELECT dateTime FROM archive WHERE dateTime > 1389475998 AND dateTime <= 
1535720400 AND wind = (SELECT MAX(wind) FROM archive WHERE dateTime > 
1389475998 and dateTime <= 1535720400) AND wind IS NOT NULL

 

My schema has windSpeed, windDir, windGust, and windGustDir.  Should it have 
plain old 'wind'?

 

Dave

 

 

 

On Fri, Aug 31, 2018 at 7:50 AM David Hathaway mailto:hathaway.d...@gmail.com> > wrote:

I'd like to solve my "wind" issue, since I have to modify the template on each 
revision.  What table is lacking "wind"?

 

Aug 31 07:40:53 hathaway weewx[32401]: cheetahgenerator:  Ignoring template 
/etc/weewx/skins/Belchertown/records/index.html.tmpl

Aug 31 07:40:53 hathaway weewx[32401]: cheetahgenerator:  Reason: (1054, 
"Unknown column 'wind' in 'where clause'")

Aug 31 07:40:53 hathaway weewx[32401]:   Traceback (most recent call last):

Aug 31 07:40:53 hathaway weewx[32401]: File 
"/usr/share/weewx/weewx/cheetahgenerator.py", line 330, in generate

Aug 31 07:40:53 hathaway weewx[32401]:   print >> _file, 
compiled_template

Aug 31 07:40:53 hathaway weewx[32401]: File 
"/usr/lib/python2.7/dist-packages/Cheetah/Template.py", line 1005, in __str__

Aug 31 07:40:53 hathaway weewx[32401]:   rc = getattr(self, 
mainMethName)()

Aug 31 07:40:53 hathaway weewx[32401]: File 
"cheetah__etc_weewx_skins_Belchertown_records_index_html_tmpl_1535719243_19_63343.py",
 line 1124, in respond

Aug 31 07:40:53 hathaway weewx[32401]: File 
"cheetah__etc_weewx_skins_Belchertown_records_index_html_tmpl_1535719243_19_63343.py",
 line 385, in __errorCatcher46

Aug 31 07:40:53 hathaway weewx[32401]: File "", line 1, in 


Aug 31 07:40:53 hathaway weewx[32401]: File 
"/usr/share/weewx/weewx/tags.py", line 329, in __getattr__

Aug 31 07:40:53 hathaway weewx[32401]:   return 
self._do_query(aggregate_type)

Aug 31 07:40:53 hathaway weewx[32401]: File 
"/usr/share/weewx/weewx/tags.py", line 343, in _do_query

Aug 31 07:40:53 hathaway weewx[32401]:   val=val, **self.option_dict)

Aug 31 07:40:53 hathaway weewx[32401]: File 
"/usr/share/weewx/weewx/wxmanager.py", line 60, in getAggregate

Aug 31 07:40:53 hathaway weewx[32401]:   return 
weewx.manager.DaySummaryManager.getAggregate(self, timespan, obs_type, 
aggregateType, **option_dict)

Aug 31 07:40:53 hathaway weewx[32401]: File 
"/usr/share/weewx/weewx/manager.py", line 1249, in getAggregate

Aug 31 07:40:53 hathaway weewx[32401]:   **option_dict)

Aug 31 07:40:53 hathaway weewx[32401]: File 
"/usr/share/weewx/weewx/manager.py", line 458, in getAggregate

Aug 31 07:40:53 hathaway weewx[32401]:   _row = self.getSql(select_stmt 
% interpolate_dict)

Aug 31 07:40:53 hathaway weewx[32401]: File 
"/usr/share/weewx/weewx/manager.py", line 394, in getSql

Aug 31 07:40:53 hathaway weewx[32401]:   _cursor.execute(sql, sqlargs)

Aug 31 07:40:53 hathaway weewx[32401]: File 
"/usr/share/weewx/weedb/mysql.py", line 48, in guarded_fn

Aug 31 07:40:53 hathaway weewx[32401]:   raise klass(e)

Aug 31 07:40:53 hathaway weewx[32401]:   NoColumnError: (1054, "Unknown 
column 'wind' in 'where clause'")

Aug 31 07:41:11 hathaway weewx[32401]: cheetahgenerator: Generated 15 files for 
report Belchertown in 113.97 seconds

 

On Fri, Aug 31, 2018 at 1:27 AM Juan Antonio Mosquera 
mailto:juanantoniomosqu...@juanantoniomosquera.com> > wrote:

Intall 0.6 version now... and same problem. My installation is wit APT

 

 

 

Aug 31 08:25:17 meteomontaos weewx[14817]: reportengine: Found configuration 
file /etc/weewx/skins/Belchertown/skin.conf for report Belchertown

Aug 31 08:25:18 meteomontaos weewx[14817]: cheetahgenerator: using search list 
['weewx.cheetahgenerator.Almanac', 'weewx.cheetahgenerator.Station', 
'weewx.cheetahgenerator.Current', 'weewx.cheetahgenerator.Stats', 
'weewx.cheetahgenerator.UnitInfo', 'weewx.cheetahgenerator.Extras', 
'user.belchertown.getData', 'user.belchertown.getForecast', 
'user.belchertown.getEarthquake', 
'user.belchertown_highchartsSearchX.highchartsDay', 
'user.belchertown_highchartsSearchX.highchartsWeek', 
'user.belchertown_highchartsSearchX.highchartsMonth', 
'user.belchertown_highchartsSearchX.highchartsYear']

Aug 31 08:25:18 meteomontaos weewx[14817]: manager: Daily summary version is 2.0

Re: [weewx-user] Re: Belchertown skin for weewx now available!

[David Hathaway]

Well, this is interesting.  Here is a statement that fails:

SELECT dateTime FROM archive WHERE dateTime > 1389475998 AND dateTime <=
1535720400 AND wind = (SELECT MAX(wind) FROM archive WHERE dateTime >
1389475998 and dateTime <= 1535720400) AND wind IS NOT NULL

My schema has windSpeed, windDir, windGust, and windGustDir.  Should it
have plain old 'wind'?

Dave



On Fri, Aug 31, 2018 at 7:50 AM David Hathaway 
wrote:

> I'd like to solve my "wind" issue, since I have to modify the template on
> each revision.  What table is lacking "wind"?
>
> Aug 31 07:40:53 hathaway weewx[32401]: cheetahgenerator:  Ignoring
> template /etc/weewx/skins/Belchertown/records/index.html.tmpl
> Aug 31 07:40:53 hathaway weewx[32401]: cheetahgenerator:  Reason:
> (1054, "Unknown column 'wind' in 'where clause'")
> Aug 31 07:40:53 hathaway weewx[32401]:   Traceback (most recent call
> last):
> Aug 31 07:40:53 hathaway weewx[32401]: File
> "/usr/share/weewx/weewx/cheetahgenerator.py", line 330, in generate
> Aug 31 07:40:53 hathaway weewx[32401]:   print >> _file,
> compiled_template
> Aug 31 07:40:53 hathaway weewx[32401]: File
> "/usr/lib/python2.7/dist-packages/Cheetah/Template.py", line 1005, in
> __str__
> Aug 31 07:40:53 hathaway weewx[32401]:   rc = getattr(self,
> mainMethName)()
> Aug 31 07:40:53 hathaway weewx[32401]: File
> "cheetah__etc_weewx_skins_Belchertown_records_index_html_tmpl_1535719243_19_63343.py",
> line 1124, in respond
> Aug 31 07:40:53 hathaway weewx[32401]: File
> "cheetah__etc_weewx_skins_Belchertown_records_index_html_tmpl_1535719243_19_63343.py",
> line 385, in __errorCatcher46
> Aug 31 07:40:53 hathaway weewx[32401]: File "", line 1, in
> 
> Aug 31 07:40:53 hathaway weewx[32401]: File
> "/usr/share/weewx/weewx/tags.py", line 329, in __getattr__
> Aug 31 07:40:53 hathaway weewx[32401]:   return
> self._do_query(aggregate_type)
> Aug 31 07:40:53 hathaway weewx[32401]: File
> "/usr/share/weewx/weewx/tags.py", line 343, in _do_query
> Aug 31 07:40:53 hathaway weewx[32401]:   val=val,
> **self.option_dict)
> Aug 31 07:40:53 hathaway weewx[32401]: File
> "/usr/share/weewx/weewx/wxmanager.py", line 60, in getAggregate
> Aug 31 07:40:53 hathaway weewx[32401]:   return
> weewx.manager.DaySummaryManager.getAggregate(self, timespan, obs_type,
> aggregateType, **option_dict)
> Aug 31 07:40:53 hathaway weewx[32401]: File
> "/usr/share/weewx/weewx/manager.py", line 1249, in getAggregate
> Aug 31 07:40:53 hathaway weewx[32401]:   **option_dict)
> Aug 31 07:40:53 hathaway weewx[32401]: File
> "/usr/share/weewx/weewx/manager.py", line 458, in getAggregate
> Aug 31 07:40:53 hathaway weewx[32401]:   _row =
> self.getSql(select_stmt % interpolate_dict)
> Aug 31 07:40:53 hathaway weewx[32401]: File
> "/usr/share/weewx/weewx/manager.py", line 394, in getSql
> Aug 31 07:40:53 hathaway weewx[32401]:   _cursor.execute(sql,
> sqlargs)
> Aug 31 07:40:53 hathaway weewx[32401]: File
> "/usr/share/weewx/weedb/mysql.py", line 48, in guarded_fn
> Aug 31 07:40:53 hathaway weewx[32401]:   raise klass(e)
> Aug 31 07:40:53 hathaway weewx[32401]:   NoColumnError: (1054,
> "Unknown column 'wind' in 'where clause'")
> Aug 31 07:41:11 hathaway weewx[32401]: cheetahgenerator: Generated 15
> files for report Belchertown in 113.97 seconds
>
> On Fri, Aug 31, 2018 at 1:27 AM Juan Antonio Mosquera <
> juanantoniomosqu...@juanantoniomosquera.com> wrote:
>
>> Intall 0.6 version now... and same problem. My installation is wit APT
>>
>>
>>
>> Aug 31 08:25:17 meteomontaos weewx[14817]: reportengine: Found
>> configuration file /etc/weewx/skins/Belchertown/skin.conf for report
>> Belchertown
>> Aug 31 08:25:18 meteomontaos weewx[14817]: cheetahgenerator: using search
>> list ['weewx.cheetahgenerator.Almanac', 'weewx.cheetahgenerator.Station',
>> 'weewx.cheetahgenerator.Current', 'weewx.cheetahgenerator.Stats',
>> 'weewx.cheetahgenerator.UnitInfo', 'weewx.cheetahgenerator.Extras',
>> 'user.belchertown.getData', 'user.belchertown.getForecast',
>> 'user.belchertown.getEarthquake',
>> 'user.belchertown_highchartsSearchX.highchartsDay',
>> 'user.belchertown_highchartsSearchX.highchartsWeek',
>> 'user.belchertown_highchartsSearchX.highchartsMonth',
>> 'user.belchertown_highchartsSearchX.highchartsYear']
>> Aug 31 08:25:18 meteomontaos weewx[14817]: manager: Daily summary version
>> is 2.0
>> Aug 31 08:25:18 meteomontaos weewx[14817]: Belchertown Extension: version
>> 0.6
>> Aug 31 08:25:25 meteomontaos wee_reports[16397]: reportengine: Caught
>> unrecoverable exception in generator weewx.cheetahgenerator.CheetahGenerator
>> Aug 31 08:25:25 meteomontaos wee_reports[16397]:   start time
>> (1514674800) is greater than stop time (1420066800)
>> Aug 31 08:25:26 meteomontaos wee_reports[16397]:   Traceback (most
>> recent call last):
>> Aug 31 08:25:26 meteomontaos 

Re: [weewx-user] Re: Belchertown skin for weewx now available!

[David Hathaway]

I'd like to solve my "wind" issue, since I have to modify the template on
each revision.  What table is lacking "wind"?

Aug 31 07:40:53 hathaway weewx[32401]: cheetahgenerator:  Ignoring
template /etc/weewx/skins/Belchertown/records/index.html.tmpl
Aug 31 07:40:53 hathaway weewx[32401]: cheetahgenerator:  Reason:
(1054, "Unknown column 'wind' in 'where clause'")
Aug 31 07:40:53 hathaway weewx[32401]:   Traceback (most recent call
last):
Aug 31 07:40:53 hathaway weewx[32401]: File
"/usr/share/weewx/weewx/cheetahgenerator.py", line 330, in generate
Aug 31 07:40:53 hathaway weewx[32401]:   print >> _file,
compiled_template
Aug 31 07:40:53 hathaway weewx[32401]: File
"/usr/lib/python2.7/dist-packages/Cheetah/Template.py", line 1005, in
__str__
Aug 31 07:40:53 hathaway weewx[32401]:   rc = getattr(self,
mainMethName)()
Aug 31 07:40:53 hathaway weewx[32401]: File
"cheetah__etc_weewx_skins_Belchertown_records_index_html_tmpl_1535719243_19_63343.py",
line 1124, in respond
Aug 31 07:40:53 hathaway weewx[32401]: File
"cheetah__etc_weewx_skins_Belchertown_records_index_html_tmpl_1535719243_19_63343.py",
line 385, in __errorCatcher46
Aug 31 07:40:53 hathaway weewx[32401]: File "", line 1, in

Aug 31 07:40:53 hathaway weewx[32401]: File
"/usr/share/weewx/weewx/tags.py", line 329, in __getattr__
Aug 31 07:40:53 hathaway weewx[32401]:   return
self._do_query(aggregate_type)
Aug 31 07:40:53 hathaway weewx[32401]: File
"/usr/share/weewx/weewx/tags.py", line 343, in _do_query
Aug 31 07:40:53 hathaway weewx[32401]:   val=val,
**self.option_dict)
Aug 31 07:40:53 hathaway weewx[32401]: File
"/usr/share/weewx/weewx/wxmanager.py", line 60, in getAggregate
Aug 31 07:40:53 hathaway weewx[32401]:   return
weewx.manager.DaySummaryManager.getAggregate(self, timespan, obs_type,
aggregateType, **option_dict)
Aug 31 07:40:53 hathaway weewx[32401]: File
"/usr/share/weewx/weewx/manager.py", line 1249, in getAggregate
Aug 31 07:40:53 hathaway weewx[32401]:   **option_dict)
Aug 31 07:40:53 hathaway weewx[32401]: File
"/usr/share/weewx/weewx/manager.py", line 458, in getAggregate
Aug 31 07:40:53 hathaway weewx[32401]:   _row =
self.getSql(select_stmt % interpolate_dict)
Aug 31 07:40:53 hathaway weewx[32401]: File
"/usr/share/weewx/weewx/manager.py", line 394, in getSql
Aug 31 07:40:53 hathaway weewx[32401]:   _cursor.execute(sql,
sqlargs)
Aug 31 07:40:53 hathaway weewx[32401]: File
"/usr/share/weewx/weedb/mysql.py", line 48, in guarded_fn
Aug 31 07:40:53 hathaway weewx[32401]:   raise klass(e)
Aug 31 07:40:53 hathaway weewx[32401]:   NoColumnError: (1054, "Unknown
column 'wind' in 'where clause'")
Aug 31 07:41:11 hathaway weewx[32401]: cheetahgenerator: Generated 15 files
for report Belchertown in 113.97 seconds

On Fri, Aug 31, 2018 at 1:27 AM Juan Antonio Mosquera <
juanantoniomosqu...@juanantoniomosquera.com> wrote:

> Intall 0.6 version now... and same problem. My installation is wit APT
>
>
>
> Aug 31 08:25:17 meteomontaos weewx[14817]: reportengine: Found
> configuration file /etc/weewx/skins/Belchertown/skin.conf for report
> Belchertown
> Aug 31 08:25:18 meteomontaos weewx[14817]: cheetahgenerator: using search
> list ['weewx.cheetahgenerator.Almanac', 'weewx.cheetahgenerator.Station',
> 'weewx.cheetahgenerator.Current', 'weewx.cheetahgenerator.Stats',
> 'weewx.cheetahgenerator.UnitInfo', 'weewx.cheetahgenerator.Extras',
> 'user.belchertown.getData', 'user.belchertown.getForecast',
> 'user.belchertown.getEarthquake',
> 'user.belchertown_highchartsSearchX.highchartsDay',
> 'user.belchertown_highchartsSearchX.highchartsWeek',
> 'user.belchertown_highchartsSearchX.highchartsMonth',
> 'user.belchertown_highchartsSearchX.highchartsYear']
> Aug 31 08:25:18 meteomontaos weewx[14817]: manager: Daily summary version
> is 2.0
> Aug 31 08:25:18 meteomontaos weewx[14817]: Belchertown Extension: version
> 0.6
> Aug 31 08:25:25 meteomontaos wee_reports[16397]: reportengine: Caught
> unrecoverable exception in generator weewx.cheetahgenerator.CheetahGenerator
> Aug 31 08:25:25 meteomontaos wee_reports[16397]:   start time
> (1514674800) is greater than stop time (1420066800)
> Aug 31 08:25:26 meteomontaos wee_reports[16397]:   Traceback (most
> recent call last):
> Aug 31 08:25:26 meteomontaos wee_reports[16397]: File
> "/usr/share/weewx/weewx/reportengine.py", line 239, in run
> Aug 31 08:25:26 meteomontaos wee_reports[16397]:   obj.start()
> Aug 31 08:25:26 meteomontaos wee_reports[16397]: File
> "/usr/share/weewx/weewx/reportengine.py", line 273, in start
> Aug 31 08:25:26 meteomontaos wee_reports[16397]:   self.run()
> Aug 31 08:25:26 meteomontaos wee_reports[16397]: File
> "/usr/share/weewx/weewx/cheetahgenerator.py", line 158, in run
> Aug 31 08:25:26 meteomontaos wee_reports[16397]:   ngen =
> 

[weewx-user] Re: weewx_wd

[Kalli]

Hallo

das bekomme ich


{
  "response": {
  "version":"0.1",
  "termsofService":"http://www.wunderground.com/weather/api/d/terms.html;,
  "features": {
  "conditions": 1
  }
,
"error": {
"type": "Station:OFFLINE"
}
}
}


Am Donnerstag, 22. Februar 2018 22:07:13 UTC+1 schrieb Kalli:
>
> hallo
>
> ich benutze WD-Live 
> da wird aber leider die Mondphase nicht angezeigt. 
> muss da noch was eingesellt werden.
>
>
>
> Hello
>
> I use WD-Live
> but unfortunately the moon phase is not displayed.
> there must be something else set up.
>
> cu. Kalli
>
>

-- 
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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [weewx-user] Re: Belchertown skin for weewx now available!

[Juan Antonio Mosquera]

Intall 0.6 version now... and same problem. My installation is wit APT



Aug 31 08:25:17 meteomontaos weewx[14817]: reportengine: Found 
configuration file /etc/weewx/skins/Belchertown/skin.conf for report 
Belchertown
Aug 31 08:25:18 meteomontaos weewx[14817]: cheetahgenerator: using search 
list ['weewx.cheetahgenerator.Almanac', 'weewx.cheetahgenerator.Station', 
'weewx.cheetahgenerator.Current', 'weewx.cheetahgenerator.Stats', 
'weewx.cheetahgenerator.UnitInfo', 'weewx.cheetahgenerator.Extras', 
'user.belchertown.getData', 'user.belchertown.getForecast', 
'user.belchertown.getEarthquake', 
'user.belchertown_highchartsSearchX.highchartsDay', 
'user.belchertown_highchartsSearchX.highchartsWeek', 
'user.belchertown_highchartsSearchX.highchartsMonth', 
'user.belchertown_highchartsSearchX.highchartsYear']
Aug 31 08:25:18 meteomontaos weewx[14817]: manager: Daily summary version 
is 2.0
Aug 31 08:25:18 meteomontaos weewx[14817]: Belchertown Extension: version 
0.6
Aug 31 08:25:25 meteomontaos wee_reports[16397]: reportengine: Caught 
unrecoverable exception in generator weewx.cheetahgenerator.CheetahGenerator
Aug 31 08:25:25 meteomontaos wee_reports[16397]:   start time 
(1514674800) is greater than stop time (1420066800)
Aug 31 08:25:26 meteomontaos wee_reports[16397]:   Traceback (most 
recent call last):
Aug 31 08:25:26 meteomontaos wee_reports[16397]: File 
"/usr/share/weewx/weewx/reportengine.py", line 239, in run
Aug 31 08:25:26 meteomontaos wee_reports[16397]:   obj.start()
Aug 31 08:25:26 meteomontaos wee_reports[16397]: File 
"/usr/share/weewx/weewx/reportengine.py", line 273, in start
Aug 31 08:25:26 meteomontaos wee_reports[16397]:   self.run()
Aug 31 08:25:26 meteomontaos wee_reports[16397]: File 
"/usr/share/weewx/weewx/cheetahgenerator.py", line 158, in run
Aug 31 08:25:26 meteomontaos wee_reports[16397]:   ngen = 
self.generate(gen_dict[section_name], self.gen_ts)
Aug 31 08:25:26 meteomontaos wee_reports[16397]: File 
"/usr/share/weewx/weewx/cheetahgenerator.py", line 232, in generate
Aug 31 08:25:26 meteomontaos wee_reports[16397]:   ngen += 
self.generate(section[subsection], gen_ts)
Aug 31 08:25:26 meteomontaos wee_reports[16397]: File 
"/usr/share/weewx/weewx/cheetahgenerator.py", line 232, in generate
Aug 31 08:25:26 meteomontaos wee_reports[16397]:   ngen += 
self.generate(section[subsection], gen_ts)
Aug 31 08:25:26 meteomontaos wee_reports[16397]: File 
"/usr/share/weewx/weewx/cheetahgenerator.py", line 320, in generate
Aug 31 08:25:26 meteomontaos wee_reports[16397]:   default_binding)
Aug 31 08:25:26 meteomontaos wee_reports[16397]: File 
"/usr/share/weewx/weewx/cheetahgenerator.py", line 372, in _getSearchList
Aug 31 08:25:26 meteomontaos wee_reports[16397]:   searchList += 
obj.get_extension_list(timespan, db_lookup)
Aug 31 08:25:26 meteomontaos wee_reports[16397]: File 
"/usr/share/weewx/user/belchertown_highchartsSearchX.py", line 1350, in 
get_extension_list
Aug 31 08:25:26 meteomontaos wee_reports[16397]:   (time_start_vt, 
time_stop_vt, outTemp_vt) = db_lookup().getSqlVectors(TimeSpan(_start_ts, 
timespan.stop), 'outTemp', 'max', 86400)
Aug 31 08:25:26 meteomontaos wee_reports[16397]: File 
"/usr/share/weewx/weeutil/weeutil.py", line 315, in __new__
Aug 31 08:25:26 meteomontaos wee_reports[16397]:   raise 
ValueError("start time (%d) is greater than stop time (%d)" % (args[0], 
args[1]))
Aug 31 08:25:26 meteomontaos wee_reports[16397]:   ValueError: start 
time (1514674800) is greater than stop time (1420066800)
Aug 31 08:25:26 meteomontaos wee_reports[16397]:   Generator terminated




Greetings.

El jueves, 30 de agosto de 2018, 20:14:47 (UTC+2), Pat escribió:
>
> Juan, how did you install weewx? APT/YUM or setup.py?
>
> On Thursday, August 30, 2018 at 2:27:32 AM UTC-4, Juan Antonio Mosquera 
> wrote:
>>
>> Hi, my steps>
>>
>> pi@meteomontaos:~ $ sudo vim /etc/weewx/weewx.conf
>> pi@meteomontaos:~ $ sudo wee_extension --install 
>> weewx-belchertown-0.5.tar.gz
>> Request to install 'weewx-belchertown-0.5.tar.gz'
>> Extracting from tar archive weewx-belchertown-0.5.tar.gz
>> Saving installer file to /usr/share/weewx/user/installer/Belchertown
>> Saved configuration dictionary. Backup copy at 
>> /etc/weewx/weewx.conf.20180830075700
>> Finished installing extension 'weewx-belchertown-0.5.tar.gz'
>> pi@meteomontaos:~ $ sudo wee_extension --list
>> Extension NameVersion   Description
>> Belchertown   0.1   A clean modern skin with real time streaming 
>> updates and interactive charts. Modeled after BelchertownWeather.com
>> csv   0.5   Emit loop or archive data in CSV format.
>> pi@meteomontaos:~ $ sudo vim /etc/weewx/weewx.conf
>> pi@meteomontaos:~ $ sudo service weewx stop
>> pi@meteomontaos:~ $ sudo service weewx start
>> pi@meteomontaos:~ $ sudo journalctl -f
>>
>>
>> Change your .py