Re: [weewx-user] 295kph windGust reading cannot find in database cannot fix

2023-07-06 Thread Greg Reive 
Actually 81.9 is metres per second which works out to be 294.84 KPH
Now I know what to look for next time.
Yes I thought it was US in the database as well but I selected METRICWX
from the beginning so it must store metric in the database.

Thanks


On Fri, 7 Jul 2023 at 14:51, Karen K  wrote:

>
>
> Greg from Oz schrieb am Freitag, 7. Juli 2023 um 04:46:06 UTC+2:
>
> All good now.Still don't know why I couldn't find 295. Why is it
> 81.9?
>
>
>
> I guess the database is in US units. This is the default.
>
> --
> You received this message because you are subscribed to a topic in the
> Google Groups "weewx-user" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/weewx-user/OcVhlHxEvHI/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> weewx-user+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/weewx-user/0d37b807-291c-4b35-bcba-65576d0f3fd8n%40googlegroups.com
> 
> .
>


-- 
¯\_(ツ)_/¯

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/CAD_tbc88R_NQj24hkt4z%3D8vJpafO3pSRhO_7CugMGqUrz8u8xA%40mail.gmail.com.

Re: [weewx-user] 295kph windGust reading cannot find in database cannot fix

2023-07-06 Thread Karen K 


Greg from Oz schrieb am Freitag, 7. Juli 2023 um 04:46:06 UTC+2:

All good now.Still don't know why I couldn't find 295. Why is it 
81.9?



I guess the database is in US units. This is the default. 

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/0d37b807-291c-4b35-bcba-65576d0f3fd8n%40googlegroups.com.

Re: [weewx-user] 295kph windGust reading cannot find in database cannot fix

2023-07-06 Thread Greg from Oz 
OK found it.
I did this:
select * from archive where windGust > 81.9;

Then I deleted the record:
delete from archive where dateTime = 1688648400;

Dropped the daily and rebuilt and now no more 295kph wind!

I think the first time I deleted the record for 23:00 of today's weather 
(collateral damage)

All good now.Still don't know why I couldn't find 295. Why is it 
81.9?
Anyway it is looking a lot better now.

https://weather.ubeaut.work/


On Friday, 7 July 2023 at 12:13:55 UTC+10 Greg Reive wrote:

> select * from archive_day_windGust where dateTime = 1688565600;
>
> ++--++++---+---++-+
> | dateTime   | min  | mintime|max| maxtime 
>|  sum   | count | wsum   | 
> sumtime |
>
> ++--++++---+---++-+
> | 1688565600 |0 | 1688566200 | 81.9006552 | 1688648400 | 
> 635.305082397 |   288 | 190590.00015247212 |   86400 |
>
> ++--++++---+---++-+
>
> date -d@1688565600
> Thu 06 Jul 2023 00:00:00 AEST
>
> Maxtime: date -d@1688648400
> Thu 06 Jul 2023 23:00:00 AEST
>
> The max is 81.9 and not 295? 
>
>
>
> On Fri, 7 Jul 2023 at 12:05, Greg Reive  wrote:
>
>> I only have the one database.
>> It is very strange that I can't even find the high wind record.
>> I will keep looking.
>>
>> On Fri, 7 July 2023, 12:02 Tom Keffer,  wrote:
>>
>>> If you did all those things, the only thing I can think of is that you 
>>> may not be working on the database you think you're working on. 
>>>
>>>
>>> On Thu, Jul 6, 2023 at 5:58 PM Greg from Oz  wrote:
>>>
 I have a windGust reading spike of 295kph and I cannot find it in the 
 database.
 295 km/h from N/A (N/A) at 06/07/23 23:00:00 

 select dateTime, windGust   from archive where (windGust  > 100); 
 Returned nothing.

 I deleted the record for that date and time in the mysql database:
 delete from archive where dateTime = 1686142800;

 I dropped the daily records and rebuilt them.
 wee_database /opt/weewx/weewx-data/weewx.conf --drop-daily
 wee_database /opt/weewx/weewx-data/weewx.conf --rebuild-daily

 I deleted the daywind.png file as well

 It is still there:

 [image: Screenshot from 2023-07-07 10-53-10.png]

 This has me stumped..

 I have been able to fix up wrong rain readings before and that worked 
 but this wind record is not working the same way.

 Any ideas?



 -- 
 You received this message because you are subscribed to the Google 
 Groups "weewx-user" group.
 To unsubscribe from this group and stop receiving emails from it, send 
 an email to weewx-user+...@googlegroups.com.
 To view this discussion on the web visit 
 https://groups.google.com/d/msgid/weewx-user/815dbad8-10cb-4843-b98c-bdab8ac34227n%40googlegroups.com
  
 
 .

>>> -- 
>>> You received this message because you are subscribed to a topic in the 
>>> Google Groups "weewx-user" group.
>>> To unsubscribe from this topic, visit 
>>> https://groups.google.com/d/topic/weewx-user/OcVhlHxEvHI/unsubscribe.
>>> To unsubscribe from this group and all its topics, send an email to 
>>> weewx-user+...@googlegroups.com.
>>> To view this discussion on the web visit 
>>> https://groups.google.com/d/msgid/weewx-user/CAPq0zEBDvt6OqFWPpZ0uxO-_T19_Lut00dCTM8zyVsRd30yR-Q%40mail.gmail.com
>>>  
>>> 
>>> .
>>>
>>
>
> -- 
> ¯\_(ツ)_/¯
>
>

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/e1fa6e44-1b85-4304-b85c-0feb07c348fan%40googlegroups.com.

Re: [weewx-user] 295kph windGust reading cannot find in database cannot fix

2023-07-06 Thread Greg Reive 
select * from archive_day_windGust where dateTime = 1688565600;
++--++++---+---++-+
| dateTime   | min  | mintime|max| maxtime
   |  sum   | count | wsum   |
sumtime |
++--++++---+---++-+
| 1688565600 |0 | 1688566200 | 81.9006552 | 1688648400 |
635.305082397 |   288 | 190590.00015247212 |   86400 |
++--++++---+---++-+

date -d@1688565600
Thu 06 Jul 2023 00:00:00 AEST

Maxtime: date -d@1688648400
Thu 06 Jul 2023 23:00:00 AEST

The max is 81.9 and not 295?



On Fri, 7 Jul 2023 at 12:05, Greg Reive  wrote:

> I only have the one database.
> It is very strange that I can't even find the high wind record.
> I will keep looking.
>
> On Fri, 7 July 2023, 12:02 Tom Keffer,  wrote:
>
>> If you did all those things, the only thing I can think of is that you
>> may not be working on the database you think you're working on.
>>
>>
>> On Thu, Jul 6, 2023 at 5:58 PM Greg from Oz  wrote:
>>
>>> I have a windGust reading spike of 295kph and I cannot find it in the
>>> database.
>>> 295 km/h from N/A (N/A) at 06/07/23 23:00:00
>>>
>>> select dateTime, windGust   from archive where (windGust  > 100);
>>> Returned nothing.
>>>
>>> I deleted the record for that date and time in the mysql database:
>>> delete from archive where dateTime = 1686142800;
>>>
>>> I dropped the daily records and rebuilt them.
>>> wee_database /opt/weewx/weewx-data/weewx.conf --drop-daily
>>> wee_database /opt/weewx/weewx-data/weewx.conf --rebuild-daily
>>>
>>> I deleted the daywind.png file as well
>>>
>>> It is still there:
>>>
>>> [image: Screenshot from 2023-07-07 10-53-10.png]
>>>
>>> This has me stumped..
>>>
>>> I have been able to fix up wrong rain readings before and that worked
>>> but this wind record is not working the same way.
>>>
>>> Any ideas?
>>>
>>>
>>>
>>> --
>>> 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.
>>> To view this discussion on the web visit
>>> https://groups.google.com/d/msgid/weewx-user/815dbad8-10cb-4843-b98c-bdab8ac34227n%40googlegroups.com
>>> 
>>> .
>>>
>> --
>> You received this message because you are subscribed to a topic in the
>> Google Groups "weewx-user" group.
>> To unsubscribe from this topic, visit
>> https://groups.google.com/d/topic/weewx-user/OcVhlHxEvHI/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to
>> weewx-user+unsubscr...@googlegroups.com.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/weewx-user/CAPq0zEBDvt6OqFWPpZ0uxO-_T19_Lut00dCTM8zyVsRd30yR-Q%40mail.gmail.com
>> 
>> .
>>
>

-- 
¯\_(ツ)_/¯

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/CAD_tbc-rxfz7xH9Tun5cYjr-Abso8gP4qVPV9pdhCw5GNQcV-w%40mail.gmail.com.

Re: [weewx-user] 295kph windGust reading cannot find in database cannot fix

2023-07-06 Thread Greg Reive 
I only have the one database.
It is very strange that I can't even find the high wind record.
I will keep looking.

On Fri, 7 July 2023, 12:02 Tom Keffer,  wrote:

> If you did all those things, the only thing I can think of is that you may
> not be working on the database you think you're working on.
>
>
> On Thu, Jul 6, 2023 at 5:58 PM Greg from Oz  wrote:
>
>> I have a windGust reading spike of 295kph and I cannot find it in the
>> database.
>> 295 km/h from N/A (N/A) at 06/07/23 23:00:00
>>
>> select dateTime, windGust   from archive where (windGust  > 100);
>> Returned nothing.
>>
>> I deleted the record for that date and time in the mysql database:
>> delete from archive where dateTime = 1686142800;
>>
>> I dropped the daily records and rebuilt them.
>> wee_database /opt/weewx/weewx-data/weewx.conf --drop-daily
>> wee_database /opt/weewx/weewx-data/weewx.conf --rebuild-daily
>>
>> I deleted the daywind.png file as well
>>
>> It is still there:
>>
>> [image: Screenshot from 2023-07-07 10-53-10.png]
>>
>> This has me stumped..
>>
>> I have been able to fix up wrong rain readings before and that worked but
>> this wind record is not working the same way.
>>
>> Any ideas?
>>
>>
>>
>> --
>> 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.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/weewx-user/815dbad8-10cb-4843-b98c-bdab8ac34227n%40googlegroups.com
>> 
>> .
>>
> --
> You received this message because you are subscribed to a topic in the
> Google Groups "weewx-user" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/weewx-user/OcVhlHxEvHI/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> weewx-user+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/weewx-user/CAPq0zEBDvt6OqFWPpZ0uxO-_T19_Lut00dCTM8zyVsRd30yR-Q%40mail.gmail.com
> 
> .
>

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/CAD_tbc-yqC4%3DQq%3DAewnMfK2Rufo2H_3qX_cf2ZrtOvxf6Exdgg%40mail.gmail.com.

Re: [weewx-user] 295kph windGust reading cannot find in database cannot fix

2023-07-06 Thread Tom Keffer 
If you did all those things, the only thing I can think of is that you may
not be working on the database you think you're working on.


On Thu, Jul 6, 2023 at 5:58 PM Greg from Oz  wrote:

> I have a windGust reading spike of 295kph and I cannot find it in the
> database.
> 295 km/h from N/A (N/A) at 06/07/23 23:00:00
>
> select dateTime, windGust   from archive where (windGust  > 100);
> Returned nothing.
>
> I deleted the record for that date and time in the mysql database:
> delete from archive where dateTime = 1686142800;
>
> I dropped the daily records and rebuilt them.
> wee_database /opt/weewx/weewx-data/weewx.conf --drop-daily
> wee_database /opt/weewx/weewx-data/weewx.conf --rebuild-daily
>
> I deleted the daywind.png file as well
>
> It is still there:
>
> [image: Screenshot from 2023-07-07 10-53-10.png]
>
> This has me stumped..
>
> I have been able to fix up wrong rain readings before and that worked but
> this wind record is not working the same way.
>
> Any ideas?
>
>
>
> --
> 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.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/weewx-user/815dbad8-10cb-4843-b98c-bdab8ac34227n%40googlegroups.com
> 
> .
>

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/CAPq0zEBDvt6OqFWPpZ0uxO-_T19_Lut00dCTM8zyVsRd30yR-Q%40mail.gmail.com.

[weewx-user] 295kph windGust reading cannot find in database cannot fix

2023-07-06 Thread Greg from Oz 
I have a windGust reading spike of 295kph and I cannot find it in the 
database.
295 km/h from N/A (N/A) at 06/07/23 23:00:00 

select dateTime, windGust   from archive where (windGust  > 100); 
Returned nothing.

I deleted the record for that date and time in the mysql database:
delete from archive where dateTime = 1686142800;

I dropped the daily records and rebuilt them.
wee_database /opt/weewx/weewx-data/weewx.conf --drop-daily
wee_database /opt/weewx/weewx-data/weewx.conf --rebuild-daily

I deleted the daywind.png file as well

It is still there:

[image: Screenshot from 2023-07-07 10-53-10.png]

This has me stumped..

I have been able to fix up wrong rain readings before and that worked but 
this wind record is not working the same way.

Any ideas?



-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/815dbad8-10cb-4843-b98c-bdab8ac34227n%40googlegroups.com.