Forgot about that though snow depth values are in a separate database so I think you will need to specify a binding to use with wee_database.
Gary On Thursday, 18 January 2018 21:37:02 UTC+10, Tom Keffer wrote: > > If you change the snow depth values using SQL, you will also have to > rebuild the daily summaries. This is easily done. > > 1. Stop weeWX > > 2. Run the tool wee_database with the --drop-daily > <http://www.weewx.com/docs/utilities.htm#Action_--drop-daily> option > > wee_database --drop-daily > > > 3. Restart weewx > > weeWX will automatically rebuild the daily summaries. Depending on how > many records you have and how fast your processor is, this takes from a few > seconds to half an hour. > > -tk > > On Wed, Jan 17, 2018 at 8:16 PM, gjr80 <gjrod...@gmail.com <javascript:>> > wrote: > >> On Thursday, 18 January 2018 13:05:43 UTC+10, Joe Percival wrote: >>> >>> Thanks. It is sounding like my best, if not only, option is to trash >>> the current database and to start over after modifying my service to record >>> snow depth in inches and change the. >> >> >> Maybe, maybe not. Any data you are recording now (or will record until >> changeover to the modified service) is merely in the wrong units and is >> easily fixed with a little SQL - snow_depth = snow_depth / 25.4. You could >> let it keep running as is, that way you continue to record data. Modify >> your service as required at your leisure and when you are able to implement >> your changes stop weeWX, put the new service in place, run a couple of SQL >> update queries on your snow db to (1) change usUnits to US and (2) convert >> all you snow measurements from mm to inches then start weeWx with your >> modified service. You can easily fine tune/practise the SQL on a copy of >> your db and you should be able to test your service as well before the big >> bang. Of course if you have no snow data then maybe it is easiest to just >> start afresh. >> >> 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+...@googlegroups.com <javascript:>. >> 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.