The SELECT query does find the rouge records so I know I have the db name etc correct > > *pi@raspberrypi*:*/var/lib/weewx/tmp $* echo "SELECT * FROM archive WHERE (windGust > 100);" | sqlite3 /var/lib/weewx/tmp/weewxback.sdb
1541477100|16|5|1015.63406205386|1014.94112877484|1015.3380873102|20.7777777777778|18.2190082644628|50.0|60.3553719008264|32.2668425791104|341.022851705169|106.217232001969|315.0|0.0|0.0|10.4055078790016|18.2190082644628|18.2190082644628|0.00166485423528066|134.057851239669|1.57520661157025|0.0|0.0|0.0|0.0|0.0|0.0|0.0|0.0|0.0|||0.0|0.0|0.0|0.0|0.0|0.0||1.0|0.0|||||||||| 1541477400|16|5|1015.74543504294|1015.05175906703|1015.44877912945|20.8268518518519|17.2013888888889|50.0|63.1916666666667|34.6681243339758|344.986725837175|106.217232001969|315.0|0.0|0.0|10.1329887215269|17.2013888888889|17.2013888888889|0.00167964919109554|104.25|1.51250000000001|0.0|0.0|0.0|0.0|0.0|0.0|0.0|0.0|0.0|||0.0|0.0|0.0|0.0|0.0|0.0||1.0|0.0|||||||||| 1542229500|16|5|1027.31710120178|1026.62485573394|1027.02830518995|20.7139577594123|20.5674931129477|56.0|60.0413223140496|6.46400885962392|7.44990218995227|109.435936002028|67.0|0.0|0.0|12.5361133103238|20.5674931129477|20.5674931129477|0.00262791834275244|507.074380165289|5.18532231404959|0.0|0.0|0.0|0.0|0.0|0.0|0.0|0.0|0.0|||0.0|0.0|0.0|0.0|0.0|0.0||1.0|0.0|||||||||| 1542229800|16|5|1027.34974066616|1026.65706950735|1027.06053684033|20.6722222222222|20.3518518518519|56.0|60.4416666666667|6.79951220012602|350.985120187468|109.435936002028|67.0|0.0|0.0|12.4345174317077|20.3518518518519|20.3518518518519|0.00266028720245799|563.558333333333|5.88933333333333|0.0|0.0|0.0|0.0|0.0|0.0|0.0|0.0|0.0|||0.0|0.0|0.0|0.0|0.0|0.0||1.0|0.0|||||||||| 1542238200|16|5|1026.82061751635|1026.12968326586|1026.53285791421|22.2467592592593|21.799537037037|52.225|56.7166666666667|8.56502589846382|331.062134258983|210.825112003907|313.0|0.0|0.0|12.8182544622233|21.79802259887|21.799537037037|0.00410429387224712|870.266666666667|4.82666666666666|0.0|0.0|0.0|0.0|0.0|0.0|0.0|0.0|0.0|||0.0|0.0|0.0|0.0|0.0|0.0||1.0|0.0|||||||||| 1542238500|16|5|1026.77947709822|1026.08860020855|1026.49175205575|22.2777777777778|21.783287419651|52.4380165289256|56.8925619834711|9.03099180182026|334.111099221049|210.825112003907|313.0|0.0|0.0|12.8506845658468|21.783287419651|21.783287419651|0.00414715091931264|874.454545454545|4.89669421487604|0.0|0.0|0.0|0.0|0.0|0.0|0.0|0.0|0.0|||0.0|0.0|0.0|0.0|0.0|0.0||1.0|0.0|||||||||| -- 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]. For more options, visit https://groups.google.com/d/optout.
