how do I do a select from the database? I created a back up to run a select statement. I have sqlite running. im just not sure where to go from here.
On 8/19/19, vince <[email protected]> wrote: > On Monday, August 19, 2019 at 2:23:34 PM UTC-7, rich T wrote: >> >> Look in the "lightning_strikes" column of your weewx dB, the strike data >> contains a value something like "15.8906578" Try adding >> lightning_strikes >> = %0f under [StringFormat] the Belchertown skin.conf to see if that >> resolves the issue. >> >> > > Rather than mess with the graphical interface, lets look at the db first. > Do a select statement of the db and report the values in the > lightning-related elements for all the strikes. That would be pretty > interesting. > > I don't map lightning on my WF system or even capture it in my influxdb > either, we get so little lightning where we live. If it's a half-dozen > strikes a year it's a lot. > > -- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/weewx-user/4b23e1c8-d4e0-465d-a162-30225ec6d76f%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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CABn15dag3zAbfH89tOku0%2BjUWKqeDb%3DKaqdUJm%2BYb0-ycecz-g%40mail.gmail.com.
