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.
elements
Description: Binary data
