trying to figure out sqlite data

90 views

Skip to first unread message

KnC Mc

unread,

Jan 12, 2020, 5:43:48 PM1/12/20

to weewx-user

I have some weird reporting while executing wee_reports, and trying to decipher sqlite archive data... I am running v3.8.0 and trying to generate html with cheetah generate with the Standard Template using wee_reports; I can see that the from logs that the data is being imported from WU, but the data appears to have different data (float, and long?) being populated in the database. My graphs being generated have gaps, and I think it is because of the long data? Is this supposed to populate like this? Is some of this cause by the missing_calc=True switch? It seems when the long data is present the graphs do not generate? Any thoughts?

1578658795|1|5|29.985|29.8761096323624|||44.8||95.0|0.0|146.0|0.0||0.0|0.0|43.3|44.8|44.8|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578659088|1|5|29.99|29.881088493416|||44.6||95.0|0.0|146.0|0.0||0.0|0.0|43.2|44.6|44.6|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578659388|1|5|29.995|29.8860733174157|||44.8||95.0|0.1|146.0|1.1||0.0|0.0|43.3|44.8|44.8|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578659691|1|5|29.995|29.8858513938269|||44.1||95.0|0.0|146.0|0.0||0.0|0.0|42.7|44.1|44.1|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578659995|1|5|30.005|29.8958089206109|||43.6||95.3|0.3|146.0|1.1||0.0|0.0|42.3|43.6|43.6|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578660288|1|5|30.01|29.9010209175344|||44.8||95.5|0.0|146.0|1.1||0.0|0.0|43.6|44.8|44.8|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578660588|1|5|30.01|29.900801236113|||44.4||95.0|0.0|146.0|0.0||0.0|0.0|43.0|44.4|44.4|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578660891|1|5|30.015|29.9057641779364|||43.1||95.0|0.0|146.0|0.0||0.0|0.0|41.6|43.1|43.1|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578661195|1|5|30.015|29.9057603259206|||42.8||95.1|0.0|146.0|0.0||0.0|0.0|41.4|42.8|42.8|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578661488|1|5|30.015|29.9055446491771|||42.5||95.4|0.1|146.0|1.1||0.0|0.0|41.3|42.5|42.5|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578661788|1|5|30.015|29.905545537471|||42.4||96.0|0.0|146.0|1.1||0.0|0.0|41.5|42.4|42.4|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578662091|1|5|30.015|29.9057623802369|||42.7||96.0|0.3|146.0|1.1||0.0|0.0|41.8|42.7|42.7|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578662395|1|5|30.025|29.9157345674942|||43.3||96.0|0.3|146.0|1.1||0.0|0.0|42.4|43.3|43.3|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578662688|1|5|30.025|29.915741851967|||43.8||96.0|0.0|146.0|1.1||0.0|0.0|42.9|43.8|43.8|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578662988|1|5|30.025|29.9157403852974|||43.7||96.0|0.0|146.0|0.0||0.0|0.0|42.8|43.7|43.7|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578663291|1|5|30.035|29.92569529528|||43.1||96.0|0.0|146.0|0.0||0.0|0.0|42.2|43.1|43.1|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578663595|1|5|30.035|29.9256981760096|||43.3||96.0|0.2|146.0|1.1||0.0|0.0|42.4|43.3|43.3|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578663888|1|5|30.045|29.9356632326362|||43.4||96.0|0.1|146.0|1.1||0.0|0.0|42.5|43.4|43.4|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578664188|1|5|30.045|29.9356646856104|||43.5||96.0|0.1|146.0|1.1||0.0|0.0|42.6|43.5|43.5|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578664491|1|5|30.045|29.9356632326362|||43.4||96.0|0.0|146.0|0.0||0.0|0.0|42.5|43.4|43.4|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578664795|1|5|30.04|29.93067139438|||42.7||96.0|0.0|146.0|1.1||0.0|0.0|41.8|42.7|42.7|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578665088|1|5|30.045|29.9354347320158|||42.3||96.0|0.0|146.0|1.1||0.0|0.0|41.4|42.3|42.3|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578665388|1|5|30.04|29.9304529655435|||42.3||96.0|0.1|146.0|1.1||0.0|0.0|41.4|42.3|42.3|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578665691|1|5|30.04|29.9304529655435|||42.3||96.0|0.0|146.0|0.0||0.0|0.0|41.4|42.3|42.3|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578665995|1|5|30.045|29.9354347320158|||42.3||96.0|0.0|146.0|1.1||0.0|0.0|41.4|42.3|42.3|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578666288|1|5|30.045|29.9354358730477|||42.3||96.3|0.0|146.0|0.0||0.0|0.0|41.5|42.3|42.3|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578666588|1|5|30.055|29.9456196470376|||42.9||96.0|0.0|146.0|0.0||0.0|0.0|42.0|42.9|42.9|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578666891|1|5|30.055|29.9456253930404|||43.3||96.0|0.0|146.0|0.0||0.0|0.0|42.4|43.3|43.3|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578667195|1|5|30.055|29.945623949298|||43.2||96.0|0.0|146.0|0.0||0.0|0.0|42.3|43.2|43.2|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578667488|1|5|30.055|29.9456268416336|||43.4||96.0|0.1|146.0|1.1||0.0|0.0|42.5|43.4|43.4|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578667788|1|5|30.055|29.9456297534278|||43.6||96.0|0.1|146.0|1.1||0.0|0.0|42.7|43.6|43.6|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578668091|1|5|30.055|29.9456344229049|||44.0||95.7|0.9|146.0|2.2||0.0|0.0|43.0|44.0|44.0|0.0|0.4|0.0||||||||||||||||||||||||||||||

1578668395|1|5|30.055|29.9458539312799|||44.7||95.0|0.8|146.0|2.2||0.0|0.0|43.2|44.7|44.7|0.0|2.6|0.0||||||||||||||||||||||||||||||

1578668688|1|5|30.055|29.9458554277356|||44.8||95.0|0.5|146.0|2.2||0.0|0.0|43.3|44.8|44.8|0.0|6.0|0.0||||||||||||||||||||||||||||||

1578668988|1|5|30.055|29.9458525216979|||44.8||94.3|0.1|146.0|1.1||0.0|0.0|43.1|44.8|44.8|0.0|9.1|0.0||||||||||||||||||||||||||||||

1578669291|1|5|30.055|29.9458542526677|||45.0||94.0|0.5|146.0|1.1||0.0|0.0|43.2|45.0|45.0|0.0|11.6|0.0||||||||||||||||||||||||||||||

1578669595|1|5|30.055|29.9458557483416|||45.1||94.0|0.3|146.0|1.1||0.0|0.0|43.3|45.1|45.1|0.0|15.5|0.0||||||||||||||||||||||||||||||

1578669888|1|5|30.055|29.9458596496277|||45.5||93.5|0.6|146.0|2.2||0.0|0.0|43.6|45.5|45.5|2.0942177262889e-06|19.5|0.0||||||||||||||||||||||||||||||

1578670188|1|5|30.055|29.9458666213938|||46.1||93.0|1.0|146.0|2.2||0.0|0.0|44.1|46.1|46.1|5.89549522089497e-06|23.9|0.0||||||||||||||||||||||||||||||

1578670491|1|5|30.055|29.9460809839368|||46.6||92.0|1.2|146.0|3.4||0.0|0.0|44.4|46.6|46.6|0.0|26.8|0.0||||||||||||||||||||||||||||||

1578670795|1|5|30.055|29.9460842144437|||47.1||91.0|1.1|146.0|3.4||0.0|0.0|44.8|47.1|47.1|0.0|30.3|0.0||||||||||||||||||||||||||||||

1578671088|1|5|30.065|29.9560542815745|||47.8||90.0|1.1|146.0|3.4||0.0|0.0|44.9|47.8|47.8|9.39623777614824e-06|33.4|0.0||||||||||||||||||||||||||||||

1578671388|1|5|30.065|29.9560598028846|||48.3||89.5|0.6|146.0|2.2||0.0|0.0|45.2|48.3|48.3|2.50623713644468e-05|37.2|0.0||||||||||||||||||||||||||||||

1578671691|1|5|30.07|29.9612527508426|||48.8||88.0|1.2|146.0|3.4||0.0|0.0|45.3|48.8|48.8|3.67913808824038e-05|39.9|0.0||||||||||||||||||||||||||||||

1578671995|1|5|30.075|29.9662350544047|||49.1||87.1|1.2|146.0|3.4||0.0|0.0|45.3|49.1|49.1|4.61443046720992e-05|42.0|0.0||||||||||||||||||||||||||||||

1578672288|1|5|30.075|29.9662406252073|||49.7||86.3|0.7|146.0|2.2||0.0|0.0|45.8|49.7|49.7|5.44310211601065e-05|45.5|0.0||||||||||||||||||||||||||||||

1578672588|1|5|30.075|29.9662456118445|||50.2||85.7|1.4|144.0|3.4||0.0|0.0|46.1|50.2|50.2|6.27743523001555e-05|50.3|0.0||||||||||||||||||||||||||||||

1578672891|1|5|30.08|29.9712255934949|||50.3||85.0|1.0|141.0|3.4||0.0|0.0|46.0|50.3|50.3|7.01405085496417e-05|53.3|0.0||||||||||||||||||||||||||||||

1578673195|1|5|30.085|29.976419961672|||50.8||84.0|1.0|142.0|2.2||0.0|0.0|46.2|50.8|50.8|7.83001079942806e-05|59.3|0.0||||||||||||||||||||||||||||||

1578673488|1|5|30.085|29.976419582298|||51.1||83.0|1.4|142.0|3.4||0.0|0.0|46.0|51.1|51.1|8.65512451660255e-05|69.7|0.0||||||||||||||||||||||||||||||

1578673788|1|5|30.085|29.9764207110939|||51.4||82.3|1.0|141.0|2.2||0.0|0.0|46.3|51.4|51.4|9.48021497635532e-05|77.6|0.0||||||||||||||||||||||||||||||

1578674091|1|5|30.085|29.9764298363454|||52.5||80.7|0.3|142.0|2.2||0.0|0.0|46.7|52.5|52.5|0.000104622112644121|92.7|1.0||||||||||||||||||||||||||||||

1578674395|1|5|30.09|29.9816267893359|||53.5||78.9|1.2|142.0|2.2||0.0|0.0|47.2|53.5|53.5|0.000116749470358061|114.5|1.0||||||||||||||||||||||||||||||

1578674688|1|5|30.095|29.9866092808673|||53.6||78.7|0.4|142.0|2.2||0.0|0.0|47.2|53.6|53.6|0.000128651641446013|150.5|1.0||||||||||||||||||||||||||||||

1578674988|1|5|30.095|29.9868213393751|||55.1||75.2|0.3|142.0|1.1||0.0|0.0|47.4|55.1|55.1|0.000148906341680189|201.6|2.0||||||||||||||||||||||||||||||

1578675291|1|5|30.095|29.9868367129608|||55.7||76.1|0.6|142.0|2.2||0.0|0.0|48.3|55.7|55.7|0.00017165950381034|267.2|3.0||||||||||||||||||||||||||||||

1578675595|1|5|30.095|29.9868339895739|||55.0||77.6|1.6|142.0|3.4||0.0|0.0|48.2|55.0|55.0|0.000199819808223611|314.4|3.0||||||||||||||||||||||||||||||

1578675888|1|5|30.095|29.9868291022289|||55.1||76.5|0.5|142.0|2.2||0.0|0.0|47.8|55.1|55.1|0.000229466346994443|327.5|3.0||||||||||||||||||||||||||||||

1578676188|1|5|30.105|29.9968024716844|||56.5||74.2|0.3|142.0|2.2||0.0|0.0|48.5|56.5|56.5|0.000260962827136992|325.8|3.0||||||||||||||||||||||||||||||

1578676491|1|5|30.1|29.9920345054124|||56.8||74.5|0.6|142.0|1.1||0.0|0.0|48.9|56.8|56.8|0.000292968478541916|320.1|3.0||||||||||||||||||||||||||||||

1578676795|1|5|30.105|29.9970157336112|||56.9||74.1|0.4|142.0|2.2||0.0|0.0|48.8|56.9|56.9|0.000323900677886034|313.5|3.0||||||||||||||||||||||||||||||

1578677088|1|5|30.105|29.9970272615709|||57.2||75.1|1.3|142.0|3.4||0.0|0.0|49.3|57.2|57.2|0.000351005216801969|271.5|3.0||||||||||||||||||||||||||||||

1578677388|1|5|30.11|30.0020028786333|||56.9||74.9|0.8|142.0|2.2||0.0|0.0|49.1|56.9|56.9|0.000381475473247797|291.4|3.0||||||||||||||||||||||||||||||

1578677691|1|5|30.115|30.0070001699107|||58.0||74.3|0.6|142.0|1.1||0.0|0.0|49.9|58.0|58.0|0.000415835118523333|312.7|3.0||||||||||||||||||||||||||||||

1578677995|1|5|30.115|30.0072279344021|||58.9||75.1|0.4|142.0|1.1||0.0|0.0|51.1|58.9|58.9|0.000448071055901136|332.3|3.0||||||||||||||||||||||||||||||

1578678288|1|5|30.115|30.0072286136187|||58.9||75.2|0.2|142.0|2.2||0.0|0.0|51.1|58.9|58.9|0.000481934005836999|366.0|4.0||||||||||||||||||||||||||||||

1578678588|1|5|30.12|30.0122212238357|||59.1||76.2|1.6|142.0|3.4||0.0|0.0|51.6|59.1|59.1|0.000505416955789248|357.8|4.0||||||||||||||||||||||||||||||

1578678891|1|5|30.125|30.0169894863692|||58.4||77.0|1.9|142.0|3.4||0.0|0.0|51.2|58.4|58.4|0.000522540832027778|375.2|4.0||||||||||||||||||||||||||||||

1578679195|1|5|30.125|30.0169889769885|||58.3||77.2|2.2|167.0|4.5||0.0|0.0|51.1|58.3|58.3|0.0005351108212577|379.1|4.0||||||||||||||||||||||||||||||

1578679488|1|5|30.125|30.0169873026633|||58.5||76.4|1.7|183.0|3.4||0.0|0.0|51.1|58.5|58.5|0.000549696290949304|369.1|4.0||||||||||||||||||||||||||||||

1578679788|1|5|30.125|30.0171967856954|||58.6||76.6|1.5|184.0|3.4||0.0|0.0|51.3|58.6|58.6|0.000560196950853844|371.8|4.0||||||||||||||||||||||||||||||

1578680091|1|5|30.13|30.0221833878024|||59.1||75.9|2.2|187.0|3.4||0.0|0.0|51.5|59.1|59.1|0.000571371624077494|382.5|4.0||||||||||||||||||||||||||||||

1578680395|1|5|30.125|30.0172036584872|||59.6||74.9|1.6|193.0|3.4||0.0|0.0|51.6|59.6|59.6|0.000586821887625527|399.1|4.0||||||||||||||||||||||||||||||

1578680688|1|5|30.13|30.0221861834176|||60.0||73.9|2.1|192.0|4.5||0.0|0.0|51.7|60.0|60.0|0.000606714357151979|397.7|4.0||||||||||||||||||||||||||||||

1578680988|1|5|30.125|30.0172043327695|||59.9||74.2|3.2|192.0|6.9||0.0|0.0|51.7|59.9|59.9|0.000624186020981369|377.8|4.0||||||||||||||||||||||||||||||

1578681291|1|5|30.125|30.0171999281149|||59.7||74.1|1.8|193.0|4.5||0.0|0.0|51.4|59.7|59.7|0.000636967860869586|387.0|4.0||||||||||||||||||||||||||||||

1578681595|1|5|30.12|30.0122171534745|||59.4||74.8|2.1|207.0|5.8||0.0|0.0|51.4|59.4|59.4|0.000648666990326473|413.7|4.0||||||||||||||||||||||||||||||

1578681888|1|5|30.12|30.0122161604646|||59.8||73.6|1.2|225.0|3.4||0.0|0.0|51.4|59.8|59.8|0.000656514314263048|412.5|4.0||||||||||||||||||||||||||||||

1578682188|1|5|30.115|30.0072318898377|||60.3||72.0|0.8|225.0|2.2||0.0|0.0|51.2|60.3|60.3|0.000669944162244181|422.4|4.0||||||||||||||||||||||||||||||

1578682491|1|5|30.12|30.0124286373718|||60.8||72.0|0.9|225.0|2.2||0.0|0.0|51.7|60.8|60.8|0.000680080738316916|412.5|4.0||||||||||||||||||||||||||||||

1578682795|1|5|30.12|30.0124220783779|||60.6||71.6|0.7|225.0|2.2||0.0|0.0|51.3|60.6|60.6|0.000695787664549894|468.9|5.0||||||||||||||||||||||||||||||

1578683088|1|5|30.115|30.007440357115|||61.1||70.4|0.9|225.0|2.2||0.0|0.0|51.4|61.1|61.1|0.000714984112324227|481.5|5.0||||||||||||||||||||||||||||||

1578683388|1|5|30.11|30.0024618429108|||61.5||69.9|1.2|225.0|3.4||0.0|0.0|51.5|61.5|61.5|0.000737205396479257|489.3|5.0||||||||||||||||||||||||||||||

1578683691|1|5|30.11|30.00246144482|||61.6||69.6|1.5|225.0|3.4||0.0|0.0|51.6|61.6|61.6|0.000756698475988469|497.0|5.0||||||||||||||||||||||||||||||

1578683995|1|5|30.1|29.9924968510916|||61.3||70.3|0.9|225.0|2.2||0.0|0.0|51.5|61.3|61.3|0.000769810787064101|484.5|5.0||||||||||||||||||||||||||||||

1578684288|1|5|30.095|29.987500976624|||61.9||67.0|1.6|225.0|4.5||0.0|0.0|50.9|61.9|61.9|0.00078772830191938|501.0|5.0||||||||||||||||||||||||||||||

1578684588|1|5|30.095|29.9874976168204|||61.5||67.5|2.2|221.0|4.5||0.0|0.0|50.7|61.5|61.5|0.000805093477778442|496.7|5.0||||||||||||||||||||||||||||||

1578684891|1|5|30.09|29.9810773128035|30.0922505046466||61.0||70.8|1.8|194.0|4.5||0.0|0.0|51.5|61.0|61.0|0.000818351053773162|478.8|5.0||||||||||||||||||||||||||||||

1578685195|1|5|30.09|29.9810664255406|30.0922395842297||61.1||69.1|0.8|192.0|3.4||0.0|0.0|51.0|61.1|61.1|0.000832925856735186|488.4|5.0||||||||||||||||||||||||||||||

1578685488|1|5|30.085|29.9762932694591|30.0874518927342||62.2||66.3|1.4|192.0|3.4||0.0|0.0|50.8|62.2|62.2|0.000850279381228297|497.0|5.0||||||||||||||||||||||||||||||

1578685788|1|5|30.075|29.9663329172972|30.0774612075915||63.0||64.9|1.0|192.0|3.4||0.0|0.0|51.1|63.0|63.0|0.000867799185649287|495.3|5.0||||||||||||||||||||||||||||||

1578686091|1|5|30.08|29.9713112592422|30.0824547106611||63.2||64.0|1.5|192.0|3.4||0.0|0.0|50.9|63.2|63.2|0.000880622478147838|493.1|5.0||||||||||||||||||||||||||||||

1578686395|1|5|30.08|29.971330043137|30.0824735517599||63.0||66.8|2.3|166.0|4.5||0.0|0.0|51.7|63.0|63.0|0.00107636118380373|475.4|5.0||||||||||||||||||||||||||||||

1578686688|1|5|30.075|29.9663330458015|30.0774613364872||62.4||66.3|1.5|160.0|4.5||0.0|0.0|51.0|62.4|62.4|0.00107475158930986|476.3|5.0||||||||||||||||||||||||||||||

1578686988|1|5|30.075|29.9661191529733|30.0772467922564||62.4||65.8|1.2|160.0|4.5||0.0|0.0|50.9|62.4|62.4|0.00107440085236624|487.1|5.0||||||||||||||||||||||||||||||

1578687291|1|5|30.075|29.9663245200952|30.0774527848161||62.8||64.3|2.1|167.0|4.5||0.0|0.0|50.6|62.8|62.8|0.00107428541199874|501.0|5.0||||||||||||||||||||||||||||||

1578687595|1|5|30.065|29.9563616145506|30.0674595367533||63.3||63.3|1.1|169.0|3.4||0.0|0.0|50.6|63.3|63.3|0.0010782764878967|501.8|5.0||||||||||||||||||||||||||||||

1578687888|1|5|30.065|29.9565775958981|30.0676761759012||64.0||62.6|1.4|174.0|3.4||0.0|0.0|51.0|64.0|64.0|0.0010836516659415|498.4|5.0||||||||||||||||||||||||||||||

1578688188|1|5|30.07|29.9615613724405|30.0726751309809||64.1||62.6|1.4|174.0|4.5||0.0|0.0|51.2|64.1|64.1|0.00108577125344505|499.7|5.0||||||||||||||||||||||||||||||

1578688491|1|5|30.065|29.9565706436232|30.0676692024522||64.4||60.9|1.9|174.0|4.5||0.0|0.0|50.6|64.4|64.4|0.00109474006107729|496.7|5.0||||||||||||||||||||||||||||||

1578688795|1|5|30.065|29.9565596234216|30.0676581486872||64.2||60.0|2.1|192.0|4.5||0.0|0.0|50.0|64.2|64.2|0.00110546933898488|497.5|5.0||||||||||||||||||||||||||||||

1578689088|1|5|30.065|29.9565679294861|30.0676664800488||64.2||61.0|2.5|163.0|6.9||0.0|0.0|50.4|64.2|64.2|0.00110580034103483|496.7|5.0||||||||||||||||||||||||||||||

1578689388|1|5|30.06|29.9515731006504|30.0626564385723||63.7||60.5|1.8|159.0|4.5||0.0|0.0|49.8|63.7|63.7|0.00110444760886195|491.1|5.0||||||||||||||||||||||||||||||

1578689691|1|5|30.055|29.9465853435692|30.0576534899466||63.6||60.0|1.4|159.0|3.4||0.0|0.0|49.5|63.6|63.6|0.00110214846496636|478.5|5.0||||||||||||||||||||||||||||||

1578689995|1|5|30.055|29.9463698352968|30.0574373252763||63.9||58.6|0.9|160.0|2.2||0.0|0.0|49.1|63.9|63.9|0.000904050974911509|458.0|5.0||||||||||||||||||||||||||||||

1578690288|1|5|30.055|29.9465782463053|30.0576463710658||64.8||56.7|2.7|193.0|5.8||0.0|0.0|49.2|64.8|64.8|0.000903984778823344|453.3|5.0||||||||||||||||||||||||||||||

1578690588|1|5|30.05|29.94158953926|30.0526424691404||64.7||56.1|2.0|200.0|3.4||0.0|0.0|48.7|64.7|64.7|0.000902299364627781|454.1|5.0||||||||||||||||||||||||||||||

1578690891|1|5|30.05|29.9413770841055|30.0524293668684||64.5||56.1|2.3|201.0|4.5||0.0|0.0|48.5|64.5|64.5|0.000898634276665261|454.6|5.0||||||||||||||||||||||||||||||

1578691195|1|5|30.045|29.9366057266158|30.0476434760826||65.0||55.3|2.1|200.0|5.8||0.0|0.0|48.6|65.0|65.0|0.000894323137751943|445.4|5.0||||||||||||||||||||||||||||||

1578691488|1|5|30.045|29.9363958140794|30.0474329241548||64.9||55.4|1.9|200.0|3.4||0.0|0.0|48.5|64.9|64.9|0.000883241721079085|421.6|4.0||||||||||||||||||||||||||||||

1578691788|1|5|30.045|29.9364050467833|30.0474421849814||65.3||55.7|1.3|200.0|3.4||0.0|0.0|49.1|65.3|65.3|0.000873316190425207|414.2|4.0||||||||||||||||||||||||||||||

1578692091|1|5|30.04|29.9314229953272|30.0424449580177||65.5||55.3|0.7|200.0|2.2||0.0|0.0|49.1|65.5|65.5|0.000859484230132493|401.3|4.0||||||||||||||||||||||||||||||

1578692395|1|5|30.045|29.9366320988694|30.0476699286658||66.1||56.2|1.5|202.0|5.8||0.0|0.0|50.1|66.1|66.1|0.000845406446393743|380.3|4.0||||||||||||||||||||||||||||||

1578692688|1|5|30.045|29.936449388083|30.0474866613443||65.5||60.4|3.0|210.0|5.8||0.0|0.0|51.4|65.5|65.5|0.000827748467468732|369.6|4.0||||||||||||||||||||||||||||||

1578692988|1|5|30.05|29.941450179055|30.052502684458||65.3||63.0|2.5|210.0|4.5||0.0|0.0|52.5|65.3|65.3|0.000808622001455958|364.8|4.0||||||||||||||||||||||||||||||

1578693291|1|5|30.045|29.936480598341|30.0475179666685||65.9||63.1|4.4|228.0|9.2||0.0|0.0|53.0|65.9|65.9|0.000797495555769203|374.4|4.0||||||||||||||||||||||||||||||

1578693595|1|5|30.05|29.9414526788173|30.0525051918343||64.8||64.4|4.6|235.0|8.1||0.0|0.0|52.5|64.8|64.8|0.000790056154637211|372.6|4.0||||||||||||||||||||||||||||||

1578693888|1|5|30.045|29.936252194634|30.0472888672455||64.6||63.8|3.0|251.0|5.8||0.0|0.0|52.1|64.6|64.6|0.00077663962600934|363.5|4.0||||||||||||||||||||||||||||||

1578694188|1|5|30.045|29.9362518827558|30.0472885544173||64.9||63.1|3.1|239.0|5.8||0.0|0.0|52.1|64.9|64.9|0.00076215404505301|349.6|4.0||||||||||||||||||||||||||||||

1578694491|1|5|30.055|29.9464293620777|30.0574970333648||65.2||62.9|3.7|248.0|8.1||0.0|0.0|52.2|65.2|65.2|0.00074604995380458|329.7|3.0||||||||||||||||||||||||||||||

1578694795|1|5|30.055|29.9464262870563|30.0574939489774||64.9||63.2|2.6|276.0|5.8||0.0|0.0|52.3|64.9|64.9|0.00072641551899773|303.6|3.0||||||||||||||||||||||||||||||

1578695088|1|5|30.055|29.9462139668187|30.0572809820514||65.5||61.6|3.0|259.0|5.8||0.0|0.0|52.0|65.5|65.5|0.000709511600987751|295.0|3.0||||||||||||||||||||||||||||||

1578695388|1|5|30.055|29.946227423366|30.0572944795849||65.2||63.8|4.0|250.0|8.1||0.0|0.0|52.7|65.2|65.2|0.000693064709436437|273.3|3.0||||||||||||||||||||||||||||||

1578695691|1|5|30.055|29.9462174958951|30.0572845218768||64.5||64.2|3.7|228.0|8.1||0.0|0.0|52.2|64.5|64.5|0.000677605945233669|278.9|3.0||||||||||||||||||||||||||||||

1578695995|1|5|30.06|29.9511980899416|30.0622802856836||64.7||63.6|3.4|223.0|8.1||0.0|0.0|52.1|64.7|64.7|0.000656630754128869|272.8|3.0||||||||||||||||||||||||||||||

1578696288|1|5|30.06|29.9512084619242|30.0622906892565||65.2||63.7|3.6|240.0|6.9||0.0|0.0|52.6|65.2|65.2|0.000640098133249148|265.8|3.0||||||||||||||||||||||||||||||

1578696588|1|5|30.06|29.9512048558266|30.0622870721756||64.3||65.3|4.8|232.0|6.9||0.0|0.0|52.4|64.3|64.3|0.00062396688909247|251.5|2.0||||||||||||||||||||||||||||||

1578696891|1|5|30.055|29.9462180690404|30.0572850967678||64.0||65.4|3.4|228.0|6.9||0.0|0.0|52.2|64.0|64.0|0.000596825762998937|206.4|2.0||||||||||||||||||||||||||||||

1578697195|1|5|30.06|29.9512010404249|30.0622832451534||64.1||65.3|3.9|234.0|6.9||0.0|0.0|52.2|64.1|64.1|0.000574597475218892|214.7|2.0||||||||||||||||||||||||||||||

1578697488|1|5|30.06|29.9512005585856|30.0622827618465||63.9||65.7|2.8|216.0|6.9||0.0|0.0|52.2|63.9|63.9|0.000548147639672869|167.0|1.0||||||||||||||||||||||||||||||

1578697788|1|5|30.06|29.9512230123123|30.0623052839612||64.2||67.7|4.8|230.0|10.3||0.0|0.0|53.3|64.2|64.2|0.000524448888829144|175.2|2.0||||||||||||||||||||||||||||||

1578698091|1|5|30.065|29.9559878080547|30.067084591777||63.2||69.3|4.2|236.0|8.1||0.0|0.0|53.1|63.2|63.2|0.000499914265382541|180.8|2.0||||||||||||||||||||||||||||||

1578698395|1|5|30.065|29.956189965078|30.0672873644983||63.1||68.5|3.5|235.0|6.9||0.0|0.0|52.6|63.1|63.1|0.0004819953757195|164.3|1.0||||||||||||||||||||||||||||||

1578698698|1|5|30.065|29.9561964026327|30.0672938216595||63.1||69.3|3.5|238.0|6.9||0.0|0.0|53.0|63.1|63.1|0.000458611130966542|151.0|1.0||||||||||||||||||||||||||||||

1578698988|1|5|30.065|29.955985568512|30.0670823454135||62.8||70.0|3.3|239.0|6.9||0.0|0.0|52.9|62.8|62.8|0.000437676218835023|140.4|1.0||||||||||||||||||||||||||||||

1578699291|1|5|30.065|29.9559828087004|30.0670795771965||62.7||69.9|3.8|237.0|6.9||0.0|0.0|52.8|62.7|62.7|0.000416898991526342|117.4|1.0||||||||||||||||||||||||||||||

1578699594|1|5|30.065|29.9559839698844|30.067080741917||62.8||69.8|2.8|233.0|8.1||0.0|0.0|52.8|62.8|62.8|0.000402523077873794|103.1|1.0||||||||||||||||||||||||||||||

1578699888|1|5|30.065|29.9559876060304|30.0670843891374||62.5||71.0|3.6|227.0|9.2||0.0|0.0|53.0|62.5|62.5|0.000364238915050671|80.6|0.0||||||||||||||||||||||||||||||

1578700188|1|5|30.07|29.9609646986571|30.0720766399973||61.9||71.9|3.4|238.0|5.8||0.0|0.0|52.7|61.9|61.9|0.000335066864884065|44.7|0.0||||||||||||||||||||||||||||||

1578700490|1|5|30.07|29.9609685712075|30.0720805243418||61.9||72.4|3.5|238.0|5.8||0.0|0.0|52.9|61.9|61.9|0.000320658367752657|43.3|0.0||||||||||||||||||||||||||||||

1578700794|1|5|30.075|29.9659570868251|30.0770842325412||62.0||73.0|3.5|231.0|5.8||0.0|0.0|53.2|62.0|62.0|0.000301561029487212|41.1|0.0||||||||||||||||||||||||||||||

1578701088|1|5|30.075|29.9659572647719|30.07708441103||61.7||73.8|3.4|241.0|5.8||0.0|0.0|53.3|61.7|61.7|0.000273041478640643|39.0|0.0||||||||||||||||||||||||||||||

1578701388|1|5|30.075|29.9659547964317|30.0770819351725||61.5||74.0|3.0|234.0|5.8||0.0|0.0|53.2|61.5|61.5|0.000249736970502583|37.2|0.0||||||||||||||||||||||||||||||

1578701690|1|5|30.07|29.9609742514283|30.0720862218621||61.3||74.7|3.0|239.0|5.8||0.0|0.0|53.3|61.3|61.3|0.000237942510376559|35.5|0.0||||||||||||||||||||||||||||||

1578701994|1|5|30.07|29.9609780219341|30.0720900038511||61.0||76.0|3.4|226.0|5.8||0.0|0.0|53.4|61.0|61.0|0.000218851731021635|32.4|0.0||||||||||||||||||||||||||||||

1578702288|1|5|30.07|29.9609707354996|30.0720826952254||60.6||76.1|2.3|225.0|4.5||0.0|0.0|53.1|60.6|60.6|0.00020153596555245|29.9|0.0||||||||||||||||||||||||||||||

1578702588|1|5|30.07|29.9607628980029|30.0718742247476||60.3||77.4|3.3|226.0|6.9||0.0|0.0|53.2|60.3|60.3|0.00018115490104067|27.3|0.0||||||||||||||||||||||||||||||

1578702890|1|5|30.07|29.9607552070392|30.0718665103607||59.7||78.0|2.9|219.0|6.9||0.0|0.0|52.9|59.7|59.7|0.000171868458755708|23.4|0.0||||||||||||||||||||||||||||||

1578703194|1|5|30.07|29.9607532123757|30.0718645096222||59.6||78.0|3.7|219.0|5.8||0.0|0.0|52.8|59.6|59.6|0.000158489469175279|20.3|0.0||||||||||||||||||||||||||||||

1578703488|1|5|30.07|29.9607563572742|30.0718676640988||59.4||79.0|2.5|220.0|5.8||0.0|0.0|52.9|59.4|59.4|0.000145252107748237|16.0|0.0||||||||||||||||||||||||||||||

1578703788|1|5|30.07|29.960540110138|30.0716507583686||59.2||79.0|1.9|220.0|3.4||0.0|0.0|52.7|59.2|59.2|0.000134729613572189|12.5|0.0||||||||||||||||||||||||||||||

1578704090|1|5|30.07|29.96053612303|30.0716467591176||59.0||79.0|2.4|220.0|4.5||0.0|0.0|52.5|59.0|59.0|0.000123890509269349|9.1|0.0||||||||||||||||||||||||||||||

1578704394|1|5|30.065|29.9555593568352|30.066654835646||58.9||80.0|2.0|220.0|4.5||0.0|0.0|52.8|58.9|58.9|0.00010923713365202|5.6|0.0||||||||||||||||||||||||||||||

1578704688|1|5|30.07|29.9603220696714|30.0714320538455||58.6||80.0|2.5|216.0|4.5||0.0|0.0|52.4|58.6|58.6|9.67155847174587e-05|2.9|0.0||||||||||||||||||||||||||||||

1578704988|1|5|30.075|29.9653039240724|30.076429080599||58.5||80.3|1.0|216.0|2.2||0.0|0.0|52.4|58.5|58.5|7.76777415754858e-05|1.2|0.0||||||||||||||||||||||||||||||

1578705290|1|5|30.07|29.9603210098846|30.0714309908311||58.2||81.0|1.4|216.0|4.5||0.0|0.0|52.4|58.2|58.2|4.92959237750384e-05|0.0|0.0||||||||||||||||||||||||||||||

1578705594|1|5|30.075|29.9653007805443|30.0764259274973||58.1||81.0|2.0|216.0|4.5||0.0|0.0|52.3|58.1|58.1|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578705888|1|5|30.075|29.965509974056|30.076635758103||57.9||81.0|1.0|216.0|2.2||0.0|0.0|52.2|57.9|57.9|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578706188|1|5|30.075|29.9655093579626|30.0766351401334||57.8||81.2|0.9|216.0|2.2||0.0|0.0|52.2|57.8|57.8|4.7578954234585e-06|0.0|0.0||||||||||||||||||||||||||||||

1578706490|1|5|30.07|29.9603158777763|30.0714258430926||57.6||82.0|1.5|216.0|3.4||0.0|0.0|52.2|57.6|57.6|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578706794|1|5|30.075|29.9652957139639|30.0764208454868||57.3||82.6|0.4|216.0|1.1||0.0|0.0|52.1|57.3|57.3|3.26925551502015e-05|0.0|0.0||||||||||||||||||||||||||||||

1578707088|1|5|30.075|29.9652911311992|30.0764162487653||56.8||83.4|0.2|216.0|1.1||0.0|0.0|51.8|56.8|56.8|2.56342447036032e-05|0.0|0.0||||||||||||||||||||||||||||||

1578707388|1|5|30.075|29.9652930761236|30.076418199613||56.7||84.0|0.8|216.0|2.2||0.0|0.0|51.8|56.7|56.7|2.13655794061689e-05|0.0|0.0||||||||||||||||||||||||||||||

1578707690|1|5|30.085|29.975258521912|30.0864139940774||56.6||84.6|0.0|216.0|1.1||0.0|0.0|51.9|56.6|56.6|1.49372507010685e-05|0.0|0.0||||||||||||||||||||||||||||||

1578707994|1|5|30.085|29.9750410907832|30.0861959008047||56.3||85.0|0.0|216.0|0.0||0.0|0.0|51.8|56.3|56.3|1.05323741881933e-05|0.0|0.0||||||||||||||||||||||||||||||

1578708288|1|5|30.085|29.9750395739827|30.086194379385||55.9||86.0|0.2|216.0|1.1||0.0|0.0|51.8|55.9|55.9|5.76511041271874e-06|0.0|0.0||||||||||||||||||||||||||||||

1578708588|1|5|30.085|29.9750375989123|30.0861923983||55.8||86.0|0.1|216.0|1.1||0.0|0.0|51.6|55.8|55.8|8.06797929209506e-06|0.0|0.0||||||||||||||||||||||||||||||

1578708890|1|5|30.085|29.9748230429645|30.0859771889631||55.5||87.0|0.0|216.0|0.0||0.0|0.0|51.7|55.5|55.5|5.57441207486878e-06|0.0|0.0||||||||||||||||||||||||||||||

1578709194|1|5|30.085|29.9748150553983|30.0859691770723||55.0||87.3|0.0|216.0|0.0||0.0|0.0|51.3|55.0|55.0|2.43978060195694e-06|0.0|0.0||||||||||||||||||||||||||||||

1578709488|1|5|30.085|29.9748213555789|30.0859754964389||55.1||88.0|0.0|216.0|0.0||0.0|0.0|51.5|55.1|55.1|7.48563102806471e-07|0.0|0.0||||||||||||||||||||||||||||||

1578709788|1|5|30.085|29.9750323591138|30.0861871425447||54.9||88.0|0.0|216.0|0.0||0.0|0.0|51.3|54.9|54.9|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578710090|1|5|30.085|29.9750343230316|30.0861891124432||55.0||88.0|0.0|216.0|0.0||0.0|0.0|51.4|55.0|55.0|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578710394|1|5|30.085|29.9750361681345|30.086190963165||55.0||88.3|0.0|216.0|0.0||0.0|0.0|51.5|55.0|55.0|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578710688|1|5|30.085|29.9750365073842|30.0861913034478||54.8||89.0|0.0|216.0|0.0||0.0|0.0|51.5|54.8|54.8|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578710988|1|5|30.085|29.9750306056693|30.0861853837604||54.5||89.0|0.0|216.0|0.0||0.0|0.0|51.2|54.5|54.5|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578711290|1|5|30.085|29.9750271497702|30.086181917337||54.2||89.4|0.0|216.0|0.0||0.0|0.0|51.2|54.2|54.2|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578711594|1|5|30.09|29.9800144223942|30.0911843775142||54.3||90.0|0.0|216.0|0.0||0.0|0.0|51.4|54.3|54.3|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578711888|1|5|30.09|29.9800144223942|30.0911843775142||54.3||90.0|0.0|216.0|0.0||0.0|0.0|51.4|54.3|54.3|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578712188|1|5|30.09|29.9800085479798|30.0911784852109||54.0||90.0|0.0|216.0|0.0||0.0|0.0|51.1|54.0|54.0|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578712490|1|5|30.09|29.9800050765756|30.0911750032355||53.7||90.4|0.0|216.0|0.0||0.0|0.0|51.0|53.7|53.7|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578712794|1|5|30.09|29.9799969992394|30.0911669013021||53.1||91.0|0.0|216.0|0.0||0.0|0.0|50.6|53.1|53.1|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578713088|1|5|30.095|29.9849787202429|30.0961637925141||53.1||91.0|0.0|216.0|0.0||0.0|0.0|50.5|53.1|53.1|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578713388|1|5|30.095|29.9849798686975|30.0961649444659||53.1||91.2|0.0|216.0|0.0||0.0|0.0|50.6|53.1|53.1|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578713690|1|5|30.095|29.9851916393589|30.096377359996||53.0||91.1|0.0|216.0|0.0||0.0|0.0|50.5|53.0|53.0|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578713994|1|5|30.09|29.9799901151854|30.0911599962846||52.5||91.8|0.0|216.0|0.0||0.0|0.0|50.3|52.5|52.5|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578714288|1|5|30.095|29.9851784635438|30.0963641440589||52.3||91.1|0.0|216.0|0.0||0.0|0.0|49.9|52.3|52.3|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578714588|1|5|30.095|29.9851816383217|30.0963673285045||52.5||91.0|0.0|216.0|0.0||0.0|0.0|50.0|52.5|52.5|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578714890|1|5|30.095|29.9851779079488|30.0963635867721||52.3||91.0|0.0|216.0|0.0||0.0|0.0|49.8|52.3|52.3|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578715194|1|5|30.095|29.9851753045364|30.096360975432||52.1||91.2|0.0|216.0|0.0||0.0|0.0|49.6|52.1|52.1|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578715488|1|5|30.095|29.9853895381659|30.0965758614296||52.2||91.0|0.0|216.0|0.0||0.0|0.0|49.6|52.2|52.2|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578715788|1|5|30.095|29.9853858578663|30.0965721699231||52.0||91.0|0.0|216.0|0.0||0.0|0.0|49.5|52.0|52.0|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578716090|1|5|30.095|29.9853840265609|30.096570333041||51.9||91.0|0.0|216.0|0.0||0.0|0.0|49.4|51.9|51.9|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578716394|1|5|30.09|29.9804004130922|30.0915715436368||51.8||91.0|0.0|216.0|0.0||0.0|0.0|49.3|51.8|51.8|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578716688|1|5|30.095|29.9853854616565|30.0965717725068||51.8||91.6|0.0|216.0|0.0||0.0|0.0|49.5|51.8|51.8|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578716988|1|5|30.095|29.9853839623696|30.0965702686543||51.6||92.0|0.0|216.0|0.0||0.0|0.0|49.5|51.6|51.6|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578717290|1|5|30.095|29.9853766871972|30.0965629713281||51.2||92.0|0.0|216.0|0.0||0.0|0.0|49.0|51.2|51.2|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578717594|1|5|30.095|29.9855861157806|30.0967730376469||50.9||92.4|0.0|216.0|0.0||0.0|0.0|48.7|50.9|50.9|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578717888|1|5|30.095|29.9855892580094|30.0967761894442||50.9||93.0|0.0|216.0|0.0||0.0|0.0|48.9|50.9|50.9|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578718188|1|5|30.095|29.9858047441536|30.096992331769||51.1||93.0|0.0|216.0|0.0||0.0|0.0|49.1|51.1|51.1|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578718490|1|5|30.095|29.9858029404582|30.0969905225812||51.0||93.0|0.0|216.0|0.0||0.0|0.0|49.0|51.0|51.0|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578718794|1|5|30.095|29.9858003899837|30.0969879643402||50.8||93.2|0.0|216.0|0.0||0.0|0.0|48.8|50.8|50.8|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578719088|1|5|30.095|29.9855867408824|30.0967736646522||50.5||93.9|0.0|216.0|0.0||0.0|0.0|48.7|50.5|50.5|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578719388|1|5|30.1|29.990781006512|30.1019837472014||50.5||94.0|0.0|216.0|0.0||0.0|0.0|48.7|50.5|50.5|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578719690|1|5|30.105|29.9959793866483|30.1071979563078||50.8||94.0|0.0|216.0|0.0||0.0|0.0|49.0|50.8|50.8|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578719994|1|5|30.105|29.9957610753118|30.106978980227||50.4||94.0|0.0|216.0|0.0||0.0|0.0|48.6|50.4|50.4|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578720288|1|5|30.1|29.9907686098197|30.1019713127609||49.8||94.0|0.0|216.0|0.0||0.0|0.0|48.0|49.8|49.8|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578720588|1|5|30.105|29.9957452369147|30.1069630936029||49.5||94.0|0.0|216.0|0.0||0.0|0.0|47.7|49.5|49.5|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578720890|1|5|30.105|29.9957435054944|30.1069613569106||49.4||94.0|0.0|216.0|0.0||0.0|0.0|47.6|49.4|49.4|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578721194|1|5|30.1|29.9909745588505|30.1021778889117||49.5||94.0|0.0|216.0|0.0||0.0|0.0|47.7|49.5|49.5|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578721488|1|5|30.105|29.995951290905|30.1071697750148||49.2||94.0|0.0|216.0|0.0||0.0|0.0|47.4|49.2|49.2|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578721788|1|5|30.1|29.9909711155595|30.1021744351359||49.3||94.0|0.0|216.0|0.0||0.0|0.0|47.5|49.3|49.3|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578722090|1|5|30.105|29.9959616562738|30.1071801719455||49.8||94.0|0.0|216.0|0.0||0.0|0.0|48.0|49.8|49.8|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578722394|1|5|30.105|29.9959616562738|30.1071801719455||49.8||94.0|0.0|216.0|0.0||0.0|0.0|48.0|49.8|49.8|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578722688|1|5|30.105|29.9959634035676|30.1071819245596||49.9||94.0|0.0|216.0|0.0||0.0|0.0|48.1|49.9|49.9|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578729888|1|5|30.09|29.9809658512528|30.0921387036731||46.5||95.0|0.0|216.0|0.0||0.0|0.0|45.1|46.5|46.5|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578730188|1|5|30.09|29.9809683213853|30.0921411813277||46.6||95.2|0.0|216.0|0.0||0.0|0.0|45.3|46.6|46.6|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578730491|1|5|30.09|29.981177894075|30.0923513922079||46.6||95.0|0.0|216.0|0.0||0.0|0.0|45.1|46.6|46.6|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578730795|1|5|30.09|29.9809634793612|30.0921363245587||46.1||95.9|0.0|216.0|0.0||0.0|0.0|45.1|46.1|46.1|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578731088|1|5|30.09|29.9811743863236|30.0923478737748||46.1||96.0|0.0|216.0|0.0||0.0|0.0|45.2|46.1|46.1|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578731388|1|5|30.09|29.9811712546663|30.092344732581||45.9||96.0|0.0|216.0|0.0||0.0|0.0|45.0|45.9|45.9|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578731691|1|5|30.085|29.9761846805416|30.0873429731326||45.6||96.0|0.0|216.0|0.0||0.0|0.0|44.7|45.6|45.6|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578731995|1|5|30.085|29.9759726647515|30.0871303116933||45.5||96.0|0.0|216.0|0.0||0.0|0.0|44.6|45.5|45.5|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578732288|1|5|30.085|29.9761877807266|30.0873460827584||45.8||96.0|0.0|216.0|0.0||0.0|0.0|44.9|45.8|45.8|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578732588|1|5|30.08|29.9712027651884|30.0823458862024||45.6||96.0|0.0|216.0|0.0||0.0|0.0|44.7|45.6|45.6|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578732891|1|5|30.085|29.9761893385389|30.0873476453148||45.9||96.0|0.0|216.0|0.0||0.0|0.0|45.0|45.9|45.9|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578733195|1|5|30.08|29.9712074224115|30.0823505576086||45.9||96.0|0.0|216.0|0.0||0.0|0.0|45.0|45.9|45.9|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578733488|1|5|30.075|29.9662162394741|30.0773441744306||45.3||96.0|0.0|216.0|0.0||0.0|0.0|44.4|45.3|45.3|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578733788|1|5|30.075|29.9662177711642|30.0773457107854||45.4||96.0|0.0|216.0|0.0||0.0|0.0|44.5|45.4|45.4|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578734091|1|5|30.075|29.9662208498351|30.0773487988323||45.6||96.0|0.0|216.0|0.0||0.0|0.0|44.7|45.6|45.6|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578734395|1|5|30.075|29.9662223968447|30.0773503505532||45.7||96.0|0.0|216.0|0.0||0.0|0.0|44.8|45.7|45.7|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578734688|1|5|30.075|29.9662239489896|30.0773519074251||45.8||96.0|0.0|216.0|0.0||0.0|0.0|44.9|45.8|45.8|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578734988|1|5|30.075|29.9662255062841|30.0773534694623||45.9||96.0|0.0|216.0|0.0||0.0|0.0|45.0|45.9|45.9|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578735291|1|5|30.075|29.9662286363803|30.0773566090911||46.1||96.0|0.0|216.0|0.0||0.0|0.0|45.2|46.1|46.1|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578735595|1|5|30.075|29.9664366315093|30.077565237661||46.0||96.0|0.0|216.0|0.0||0.0|0.0|45.1|46.0|46.0|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578735888|1|5|30.075|29.9662270687429|30.0773550366795||46.0||96.0|0.0|216.0|0.0||0.0|0.0|45.1|46.0|46.0|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578736188|1|5|30.075|29.9662255062841|30.0773534694623||45.9||96.0|0.0|216.0|0.0||0.0|0.0|45.0|45.9|45.9|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578736491|1|5|30.075|29.9664350750652|30.0775636764769||45.9||96.0|0.0|216.0|0.0||0.0|0.0|45.0|45.9|45.9|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578816288|1|5|29.95||||47.9||94.0|0.0|203.0|0.0||0.0|0.0|46.1|47.9|47.9|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578816588|1|5|29.95||||47.6||94.0|0.0|203.0|0.0||0.0|0.0|45.8|47.6|47.6|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578816890|1|5|29.945||||47.7||94.0|0.0|203.0|0.0||0.0|0.0|45.9|47.7|47.7|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578822588|1|5|29.955||||46.8||94.5|0.0|203.0|0.0||0.0|0.0|45.1|46.8|46.8|0.0|0.0|0.0||||||||||||||||||||||||||||||

1578822890|1|5|29.955||||46.6||94.8|0.0|203.0|1.1||0.0|0.0|45.0|46.6|46.6|0.0|0.0|0.0||||||||||||||||||||||||||||||

vince

unread,

Jan 12, 2020, 5:54:08 PM1/12/20

to weewx-user

On Sunday, January 12, 2020 at 2:43:48 PM UTC-8, KnC Mc wrote:

I have some weird reporting while executing wee_reports, and trying to decipher sqlite archive data... I am running v3.8.0 and trying to generate html with cheetah generate with the Standard Template using wee_reports; I can see that the from logs that the data is being imported from WU, but the data appears to have different data (float, and long?) being populated in the database. My graphs being generated have gaps, and I think it is because of the long data? Is this supposed to populate like this? Is some of this cause by the missing_calc=True switch? It seems when the long data is present the graphs do not generate? Any thoughts?

The schema dictates the data type, which by default is REAL everywhere basically. I'm guessing you're seeing 29.945 and thinking it's a different data type than 29.500001324567 perhaps (?)

To see the schema, try:

echo ".schema" | sqlite3 /home/weewx/archive/weewx.sdb | grep "TABLE archive"

(or substitute in the path to your weewx.sdb if you used a pre-packaged weewx or if you put your db in an unusual place)

KnC Mc

unread,

Jan 12, 2020, 6:12:15 PM1/12/20

to weewx-user

Actually, now that I look again, there are NULL values and long values in the 'pressure' column and that is what I was seeing that raised a flag.

I might mention that this box is running simulator driver, and I pull the data from WU with wee_importv4 / wee-reportsv3.8.0 to populate the graphs via cheetah and the Standard template. I have been trying the beta v4 wee_import, and cron a script that calls the utilities. It was working for a day or so, but it started failing, so I changed the script to call wee_import every 12 hours, and now every 10 minutes, but it only seems to work from 1-2am everyday now, and I am trying too figure out why. The logs show the imports, but the only discrepancy in the archive database I can see is the integer/long differences.

If there is something else I can provide to troubleshoot this, let me know. This is deeper than I have looked before, so I am still reading docs. I change the trachea value from 250 to 50 thinking that had something to do with it, and I have played with the time frames that I call the script in cron, but don't see a difference. The odd thing is that when I do a full days import I see some PRIMARY Key errors, but if I wait a couple hours the graphs update. I do not understand why the graphs do not update immediately like they did before the api_key was required back in May?

just and FYI, so my level of knowledge is understood: I am not a programmer, just a network engineer, with a fair amount of experience with linux and internet systems, so I am fumbling thru the sqlite syntax, and trying to look at the python code with a very basic knowledge of where things are being called.

gjr80

unread,

Jan 12, 2020, 8:24:53 PM1/12/20

to weewx-user

OK, let's see if we can clear up a few things here.

just and FYI, so my level of knowledge is understood: I am not a programmer, just a network engineer, with a fair amount of experience with linux and internet systems, so I am fumbling thru the sqlite syntax, and trying to look at the python code with a very basic knowledge of where things are being called.

That's OK, I am just an electronics engineer and an outdated one at that, when I started using WeeWX I wondered 'is that python with an ie or a y', so you will be fine.

My graphs being generated have gaps, and I think it is because of the long data?

To understand why you see gaps in plots you need to understand a little of how the WeeWX plot engine works. Assume we are plotting an observation on a 'line' type plot. When WeeWX starts plotting points for the line the current point is joined to the last point with a line. However, to provide a realistic plot when there is say a large gap in time for the observation concerned (say your sensor was offline for some time) rather than join two points quite some time apart with a straight line, WeeWX will leave out the joining line if the gap in time is sufficiently long. The gaps are controlled by the line_gap_fraction setting in skin.conf under [ImageGenerator]. A gap is considered to be the time period covered by the entire plot * line_gap_fraction. Any gaps in data greater than this value will be considered a gap and the connecting line omitted. So for a standard WeeWX day plot (nominally covering 27 hours) and the default line_gap_fraction value of 0.01 this value is about 16 minutes (it will actually vary as it is calculated based on the timestamps of the earliest point in the plot and the most recent point in the plot). So I would expect that you will be seeing gaps if you have successive points that are > 16 minutes apart. Remember that whilst you may have archive records every 5 or so minutes if the observation concerned is None/NULL that point/timestamp is omitted from the plot series so it is quite possible to have continuous archive records every 5 minutes but still have gaps if data is missing. A common source of 'gaps in plots' is Davis station users who initially use the default 30 minute archive period, they only have data points in the plots every 30 minutes so the plots end up being a series of sparsely spaced dots.

Not sure what you mean by long data, type LONG or long as in 'this one has more digits than that one'? Either way it doesn't matter, if the data is in the archive and is not None/NULL it will be plotted without detriment.

Is some of this cause by the missing_calc=True switch

All the calc-missing option does is calculate any derived observations that are missing from imported data. So for example if dewpoint is missing from an imported record and calc-missing is True then WeeWX will calculate dewpoint for that record. As usual there are a couple of provisos; firstly WeeWX can only calculate those derived obs that it knows about, these are specified in the [StdWXCalculate] [[Calculations]] stanza in weewx.conf. So for a default install that would be pressure, barometer, altimeter, windchill, heatindex, dewpoint, inDewpoint and rainRate. Secondly, WeeWX can only calculate the derived obs if the required pre-requisites exist, for example dewpoint is a function of outTemp and outHumidity, if outHumidity does not exist dewpoint cannot be calculated and it will be left as is. The one to watch out here is WeeWX field pressure (aka station pressure), if the station provides WeeWX with barometer and WeeWX is to calculate pressure the outTemp value from 12 hours previous is required, if that historical data is not available then pressure will not be calculated. This is why you sometimes see no pressure data for the first 12 hours of an import (and this is the main cause for the reworking of wee_import in v4)

So unless you have some very weird intermittent data I suspect that calc-missing will have nothing to do with your gaps.

Any thoughts?

Yes, for any meaningful diagnosis you need to provide the plot you believe to have issues and details of the underlying data. You have provided details of the data (I think) but without knowing when or what was plotted it is impossible to say anything more.

Just a few words on wee_import. wee_import was never designed with the intent of using it as a cron job for importing WU data. In fact, there was some trepidation on Tom's behalf when a WU module was proposed for wee_import, WU is just to , well, all over the place and full of quirks to be a reliable and consistent data source. Take for example the current (new) WU API. During testing of the v4 wee_import it was found that successive API queries for the current days data for a given station would only return part of the day's data. The first query on the current day would return all records up until the current time of day but subsequent queries on the current day would return the same data as the first query of the day, any records published between the two queries would not be returned. Queries on historical days were fine. For this reason the v4 Utilities Guide has the following note warning to not rely on WU imports for the current day:

The new (2019) Weather Underground API appears to have an issue when obtaining historical data for the current day. The first time the API is queried the API returns all historical data up to and including the most recent record. However, subsequent later API queries during the same day return the same set of records rather than all records up to and including the time of the latest API query. Users importing Weather Underground data that includes data from the current day are advised to carefully check the WeeWX log to ensure that all expected records were imported. If some records are missing from the current day try running an import for the current day again using the --date option setting. If this fails then wait until the following day and perform another import for the day concerned again using the --date option setting. In all cases confirm what data has been imported by referring to the WeeWX log.

I am not 100% certain exactly how you are running wee_import but if you are using a cron job to import the current day then you could quite likely be being affected by this quirk in the WU API. If the cron job runs continuously it is quite possible that sometime in the future (of the current day) the API query returns the correct data so you could be seeing some hybrid mix of current and missing data.

My suggestion is to not run wee_import as a cron job. If you must run it as a cron job then run it on historical days only.

I change the trachea value from 250 to 50 thinking that had something to do with it

Perhaps you mean tranche? If so this merely sets the number of records save to database in a single transaction. It will not affect the actual data being stored and it will only have a noticeable affect on very large imports.

The odd thing is that when I do a full days import I see some PRIMARY Key errors, but if I wait a couple hours the graphs update. I do not understand why the graphs do not update immediately like they did before the api_key was required back in May?

What graphs? WeeWX generated I presume. Remember the WeeWX generated plots update at different rates dependent on the aggregate period being used. Daily plots (no aggregate period) update every time the reports are run. Weekly plots use a one hour aggregate so update every hour, month use a three hour aggregate so update every three hours and year use a 24 hour aggregate (and you can guess when they update). The best approach when checking plots for changes is to delete all plots before the report cycle occurs, this forces all plots to be regenerated. Checking plot file timestamps via the operating system is a quick way to see the plot was last generated. The log also gives a good clue as well.

I might mention that this box is running simulator driver, and I pull the data from WU with wee_importv4 / wee-reportsv3.8.0 to populate the graphs via cheetah and the Standard template.

Soooo, simulator writes data to archive and then you use wee_import to import WU data, is that WU data that covers the same times as the simulator was running? If so the WU data will not be saved to archive. Is the WU data the simulator data that has been posted to WU or data from another station? If the latter I expect there may be a mix of simulated and real life data. Not a problem in itself but I expect it may confuse the issue when seeing what was/was not imported, especially when judging by plots.

One more hint, when providing an SQLite query output use the .headers on command before executing the query and then post the resulting output with the headers info and the data, that way we can see what each field contains.

Gary

KnC Mc

unread,

Jan 15, 2020, 1:23:52 AM1/15/20

to weewx-user

Gary,

You are an amazing contributor, and I can not thank you enough. And you sound like the guy "I wanted to be when I grew up"... I started my computer journey being encouraged by an uncle who built an Altair... I learned to solder before I ever touched a computer, but while deciding whether to be an Electrical Engineer or an Internet Systems Engineer, my older brother convinced me that this new thing called the Internet might be something to study for as I was exiting high school... so Network Engineering became the goal, and here I am... I run MRTG to monitor and graph network equipment and figured out how to scrap weather web sites to populate a local weather graph a few years back... but dang if they didn't keep changing their websites and breaking my scripts! So I bought an Ambient Weather Station and found this Weewx project to allow me to have control of a webpage that wouldn't change. I have never installed the interceptor driver, I have always just used wee_import to grab my station data from WU.

Your explanation about same day imports is exactly what I am experiencing, and was why I was tweaking my cron times and looking at tranche settings to see if something was happening between data gathering and archiving. I guess the WU anomaly will motivate me to finally get a pi running with the interceptor driver... just need to find more time in the day. :)

I haven't digested everything you wrote yet earlier on this thread, but I am sure I will, once I read it a few more times, and look in the docs directory. Thanks again for your dedication to this group. I am fairly new here, but I can see that you put a lot into this group, and as an open source advocate, am very grateful for folks like you! Cheers!

Thomas Keffer

unread,

Jan 15, 2020, 8:24:39 AM1/15/20

to weewx-user

On Tue, Jan 14, 2020 at 10:23 PM KnC Mc <knc.geo...@gmail.com> wrote:

Gary,
You are an amazing contributor...

+1 on that!

Reply all

Reply to author

Forward

0 new messages