Granularity and Archives

71 views
Skip to first unread message

cycle.l...@gmail.com

unread,
Oct 2, 2020, 4:41:13 PM10/2/20
to weewx-user
Hi,
Very bad rain tonight in the UK, and I mentioned to my wife that it must have been the worst rain for years.  She remarked that we had had heavier rain two years ago. 

Then it occurred to me that I had no way of verifying that.  If I select '2018', for example, it will tell me what day we had very heavy rain, but it won't let see what the weather was (all of the parameters) on my birthday, or any other day.  

Is there a way to get 'granular' data of this kind?  Is it already in 'sqllite' database, or would I have to switch to MySQL to get it?  Whichever method I use, will that data only be available via CLI, or is there a way to get it on the GUI - without learning HTML and Python to create it myself? 

Thanks.  

p q

unread,
Oct 2, 2020, 4:57:26 PM10/2/20
to weewx...@googlegroups.com
I'm using a custom search expression that gives me the high low and rain for "this day" for each year that I have data for. 

When I get off work I'll look up the details. 

You should be able to craft a SQL query to get what you want with either db and it will be the same query either way. It just might not be easy. 

--
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/127feef8-1241-4f8d-a199-bbcfff027b8fn%40googlegroups.com.

Tom Keffer

unread,
Oct 2, 2020, 6:26:54 PM10/2/20
to weewx-user
If you use one of the standard skins, the "NOAA" report will tell you daily rain totals for each day.

--

p q

unread,
Oct 2, 2020, 7:07:48 PM10/2/20
to weewx...@googlegroups.com

Greg from Oz

unread,
Oct 2, 2020, 7:28:56 PM10/2/20
to weewx-user
I use this:
Then I look in the NOAA for the exact date as Tom said.

Glenn McKechnie

unread,
Oct 2, 2020, 7:39:02 PM10/2/20
to weewx...@googlegroups.com
wxobs will give you some of what you are after. (It doesn't return
every weewx database field.)

There are no charts, just a table of values for any specific date in
your database.

The default is to display 30 minute intervals, but that can be changed
in skin.conf if you want to fine tune it (see display_interval)

https://github.com/glennmckechnie/weewx-wxobs

Given you have sqlite as your database, it works best as a local
installation. (ie: it requires direct access to your database)

http://203.213.243.61/weewx/wxobs/
That link has a working demo, but the database only goes back a month.
Selecting the 12th Sept 2020 will show a rain day (adjusted for the
Australian start time of 9 a.m.)



On 03/10/2020, p q <peterq...@gmail.com> wrote:
> This <https://github.com/gjr80/weewx_utilities> is the one I'm using.
> <https://github.com/gjr80/weewx_utilities>
>>> <https://groups.google.com/d/msgid/weewx-user/127feef8-1241-4f8d-a199-bbcfff027b8fn%40googlegroups.com?utm_medium=email&utm_source=footer>
>>> .
>>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "weewx-user" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to weewx-user+...@googlegroups.com.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/weewx-user/CAPq0zEDtEmijp3%2Bq4cc1w88GaNnVr5UaqK1-FM%3D8A0cDnSRLUw%40mail.gmail.com
>> <https://groups.google.com/d/msgid/weewx-user/CAPq0zEDtEmijp3%2Bq4cc1w88GaNnVr5UaqK1-FM%3D8A0cDnSRLUw%40mail.gmail.com?utm_medium=email&utm_source=footer>
>> .
>>
>
>
> --
> Peter Quinn
> (415)794-2264
>
> --
> 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/CAA1SM233i9W-AYL-PoOsb982gUKiEAU8bAMfdGS%2B1c_WPcEhOA%40mail.gmail.com.
>


--


Cheers
Glenn

rorpi - read only raspberry pi & various weewx addons
https://github.com/glennmckechnie
Reply all
Reply to author
Forward
0 new messages