[weewx-user] Re: update barometric pressure statistics in weewx 3.1.0
[image: barometer] Looks familiar! Mine is from the week data. - Paul VE1DX On Monday, September 9, 2019 at 8:40:58 AM UTC-3, Bill Morrow wrote: > > Guess when the hurricane went through: > > [image: Screenshot from 2019-09-09 08-39-03.png] > > > On Sunday, 8 September 2019 21:42:49 UTC-3, Bill Morrow wrote: >> >> Thanks for tip, Gary. I ran wee_config_database —drop-daily and saw this >> evidence in the log on weewxd startup: >> >> Sep 8 21:05:39 seal weewx[14232]: engine: Starting backfill of daily >> summaries >> Sep 8 21:12:27 seal weewx[14232]: engine: Processed 1116765 records to >> backfill 1631 day summaries in 408.15 seconds >> >> but it did not pick up my new drastically lower pressure. Then I realized >> the statistics are actually on pressure, not the barometer reading. I might >> be putting the reading from my pressure sensor in the wrong field. Again, >> in the short term, I fabricated pressure readings by finding a suitable >> linear adjustment to convert barometer to pressure from nearby readings >> with both, and updated the archive table where pressure was NULL for the >> three emergency readings: >> >> update archive set pressure = 0.992657*barometer where dateTime between >> 1567895340 and 1567905540; >> >> Then dropped the summaries again, and restarted weewxd. The statistics >> page now shows my new all time low *pressure*. I wouldn't say science >> has marched on. That will have to wait for our next hurricane. >> >> >> On Sunday, 8 September 2019 11:56:27 UTC-3, gjr80 wrote: >>> >>> Dropping the daily summaries is generally taken to mean using one of the >>> WeeWX utilities to drop the daily summaries rather than using SQL directly. >>> The current utility used to manage the database is wee_database; however, >>> in v3.1.0 the utility is wee_config_database. Try running >>> wee_config_database with the —drop-daily action (using —help will display >>> the list of available actions). >>> >>> You can also use wee_config_database to rebuild the daily summaries >>> using the -backfill-daily action. >>> >>> 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. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/3db29ddb-7799-4aa1-b173-3e0169858b85%40googlegroups.com.
[weewx-user] Re: update barometric pressure statistics in weewx 3.1.0
Guess when the hurricane went through: [image: Screenshot from 2019-09-09 08-39-03.png] On Sunday, 8 September 2019 21:42:49 UTC-3, Bill Morrow wrote: > > Thanks for tip, Gary. I ran wee_config_database —drop-daily and saw this > evidence in the log on weewxd startup: > > Sep 8 21:05:39 seal weewx[14232]: engine: Starting backfill of daily > summaries > Sep 8 21:12:27 seal weewx[14232]: engine: Processed 1116765 records to > backfill 1631 day summaries in 408.15 seconds > > but it did not pick up my new drastically lower pressure. Then I realized > the statistics are actually on pressure, not the barometer reading. I might > be putting the reading from my pressure sensor in the wrong field. Again, > in the short term, I fabricated pressure readings by finding a suitable > linear adjustment to convert barometer to pressure from nearby readings > with both, and updated the archive table where pressure was NULL for the > three emergency readings: > > update archive set pressure = 0.992657*barometer where dateTime between > 1567895340 and 1567905540; > > Then dropped the summaries again, and restarted weewxd. The statistics > page now shows my new all time low *pressure*. I wouldn't say science has > marched on. That will have to wait for our next hurricane. > > > On Sunday, 8 September 2019 11:56:27 UTC-3, gjr80 wrote: >> >> Dropping the daily summaries is generally taken to mean using one of the >> WeeWX utilities to drop the daily summaries rather than using SQL directly. >> The current utility used to manage the database is wee_database; however, >> in v3.1.0 the utility is wee_config_database. Try running >> wee_config_database with the —drop-daily action (using —help will display >> the list of available actions). >> >> You can also use wee_config_database to rebuild the daily summaries using >> the -backfill-daily action. >> >> 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. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/f4fcbd01-ce20-4448-ad12-8082aa500165%40googlegroups.com.
[weewx-user] Re: update barometric pressure statistics in weewx 3.1.0
Thanks for tip, Gary. I ran wee_config_database —drop-daily and saw this evidence in the log on weewxd startup: Sep 8 21:05:39 seal weewx[14232]: engine: Starting backfill of daily summaries Sep 8 21:12:27 seal weewx[14232]: engine: Processed 1116765 records to backfill 1631 day summaries in 408.15 seconds but it did not pick up my new drastically lower pressure. Then I realized the statistics are actually on pressure, not the barometer reading. I might be putting the reading from my pressure sensor in the wrong field. Again, in the short term, I fabricated pressure readings by finding a suitable linear adjustment to convert barometer to pressure from nearby readings with both, and updated the archive table where pressure was NULL for the three emergency readings: update archive set pressure = 0.992657*barometer where dateTime between 1567895340 and 1567905540; Then dropped the summaries again, and restarted weewxd. The statistics page now shows my new all time low *pressure*. I wouldn't say science has marched on. That will have to wait for our next hurricane. On Sunday, 8 September 2019 11:56:27 UTC-3, gjr80 wrote: > > Dropping the daily summaries is generally taken to mean using one of the > WeeWX utilities to drop the daily summaries rather than using SQL directly. > The current utility used to manage the database is wee_database; however, > in v3.1.0 the utility is wee_config_database. Try running > wee_config_database with the —drop-daily action (using —help will display > the list of available actions). > > You can also use wee_config_database to rebuild the daily summaries using > the -backfill-daily action. > > 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. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/45263342-751c-40d5-b218-fa0c031831a6%40googlegroups.com.