I’ll have to check my database when I get home, but if this is widespread, we may have to rethink our strategy of checking for data before generating a plot.
On Fri, Oct 15, 2021 at 10:12 PM Vince Skahan <[email protected]> wrote: > On Friday, October 15, 2021 at 7:46:37 PM UTC-7 Tom Keffer wrote: > >> What triggered all this is that V4.6 figures out what to display on the >> basis of what's in the database. It's quite possible lots of Vantage >> stations are emitting bogus data for missing sensors, but no one ever >> bothered to plot it. I'll have to check my own database when I get home. >> > > Here's mine - wow is there ever some bogus data in there, but I've done > things like run weewx-wd for a while (then turned it off) and had a > Lacrosse station before switching to a VP2 ages ago, but I see thousands of > bogus measurements over the years when I had no soil/leaf/solar sensors > ever. > > I can rerun this limiting it to the last year if needed. > > ========================================= > My db field counts sorted by record count > ========================================= > dateTime 1437009 > barometer 1436996 > outTemp 1434802 > dewpoint 1434574 > outHumidity 1434479 > windGust 1423973 > windSpeed 1421912 > ET 1342089 > inHumidity 1342089 > inTemp 1342089 > rain 1342089 > rainRate 1342089 > heatindex 1339861 > windchill 1339859 > rxCheckPercent 1318752 > txBatteryStatus 1154921 > consBatteryVoltage 1154717 > windGustDir 1112577 > pressure 1069647 > altimeter 1051853 > windDir 962745 > > ======================= > (elements with lesser counts) > I never had leaf or soil sensors on this station > ======================= > inDewpoint 170470 > maxSolarRad 164396 > windrun 164394 > cloudbase 164388 > humidex 164388 > appTemp 164386 > extraTemp1 98776 > extraTemp2 98776 > soilMoist1 88430 > soilMoist2 88430 > soilMoist3 88430 > soilTemp1 65396 > soilTemp2 65396 > soilTemp3 65396 > extraTemp3 3638 > extraHumid1 2231 > extraHumid2 2231 > hail 2231 > hailRate 2231 > heatingTemp 2231 > heatingVoltage 2231 > inTempBatteryStatus 2231 > leafTemp1 2231 > leafTemp2 2231 > leafWet1 2231 > leafWet2 2231 > outTempBatteryStatus 2231 > rainBatteryStatus 2231 > referenceVoltage 2231 > soilMoist4 2231 > soilTemp4 2231 > supplyVoltage 2231 > windBatteryStatus 2231 > > > I did this by making a file called 'elements' from the schema of the > archive table with the element names one-per-line, then generated the > output by: > for e in `cat elements`; do echo -n "$e "; echo "select COUNT(*) from > archive where ${e} is not NULL" | sqlite3 weewx.sdb ; done | grep -v " 0$" > | sort +1nr > counts > > > -- > You received this message because you are subscribed to the Google Groups > "weewx-development" 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-development/6bf017e0-c84c-4185-97bb-23cebbf3062an%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-development/6bf017e0-c84c-4185-97bb-23cebbf3062an%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- -tk -- You received this message because you are subscribed to the Google Groups "weewx-development" 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-development/CAPq0zECKBVpZb360agEE4eq7bLpZtb30J9fq9g9H7pMHvvBGqg%40mail.gmail.com.
