Sorry my Database ar in MYSQL [image: Kopieren] <http://amd350/phpmyadmin/themes/dot.gif>
MIN <http://amd350/phpmyadmin/sql.php>Max <http://amd350/phpmyadmin/sql.php> 16 16 in all 609.177 data ar usUnits "16" I searched ascending and descending via phpMyAdmin. sorry gruss Hartmut Am Freitag, 22. November 2019 14:39:15 UTC+1 schrieb Tom Keffer: > > Please send us the result of this query: > > *sqlite3 weewx.sdb* > sqlite> *SELECT MIN(usUnits), MAX(usUnits) FROM archive;* > > -tk > > On Fri, Nov 22, 2019 at 5:34 AM Hartmut Schweidler <[email protected] > <javascript:>> wrote: > >> Hallo Tom, >> >> my data is stored as METRIC >> >> Problem: >> in den NOAA-Dateien erscheinen die Daten windSpeed und windgust nicht wie >> in der Datenbank als km/h sondern es werden diese km/h-Daten als m/s-Daten >> gelesen und in km/h umgerechnet >> >> ------------------------- >> >> >> In the NOAA files, the windSpeed data and windGust data do not appear as >> km/h as in the database, but these km/h data are read as m/s data and >> converted into km/h >> >> [image: windSpeedNov.PNG] >> >> [image: windSpeed_windGusst_Max_Nov.PNG] >> >> MONTHLY CLIMATOLOGICAL SUMMARY for Nov 2019 >> >> >> NAME: Klein Rogahn, Deutschland >> ELEV: 53 m LAT: 53-36.36 N LONG: 011-20.48 E >> >> >> TEMPERATURE (C), RAIN (mm), WIND SPEED (km/h) >> >> HEAT COOL AVG >> MEAN DEG DEG WIND >> DOM >> DAY TEMP HIGH TIME LOW TIME DAYS DAYS RAIN SPEED HIGH >> TIME DIR >> >> --------------------------------------------------------------------------------------- >> 01 2,0 5,2 23:58 -1,9 00:55 16,3 0,0 0,2 24,5 133,3 >> 13:40 138 >> 02 9,6 13,5 14:15 5,1 00:00 8,7 0,0 0,2 26,0 127,5 >> 18:00 175 >> 03 10,6 13,4 12:45 9,0 07:48 7,7 0,0 0,1 8,6 69,5 >> 12:45 160 >> 04 9,5 11,1 15:06 7,6 23:51 8,8 0,0 0,0 12,1 98,5 >> 12:55 210 >> 05 8,3 10,8 12:35 6,4 01:50 10,0 0,0 0,1 5,5 69,5 >> 21:35 296 >> 06 6,4 7,2 14:45 4,9 19:53 11,9 0,0 0,1 4,7 46,3 >> 12:40 333 >> 07 5,9 8,1 22:11 4,1 09:18 12,4 0,0 0,1 11,8 63,7 >> 20:29 138 >> 08 5,3 7,8 13:56 1,9 07:13 13,0 0,0 0,1 2,5 46,3 >> 23:55 247 >> 09 5,5 8,8 13:02 1,8 22:37 12,8 0,0 0,1 23,3 86,9 >> 13:15 274 >> 10 2,8 8,3 13:15 -0,8 07:43 15,5 0,0 0,0 3,6 40,6 >> 12:24 190 >> 11 0,5 2,5 21:22 -1,9 05:35 17,8 0,0 0,4 31,6 110,1 >> 21:15 145 >> 12 4,4 8,2 14:12 0,9 02:16 13,9 0,0 0,0 39,0 127,5 >> 13:30 165 >> 13 3,2 5,7 13:10 0,4 07:50 15,1 0,0 0,0 19,9 110,1 >> 09:45 169 >> 14 3,7 7,9 12:31 -0,4 07:40 14,6 0,0 0,0 18,0 98,5 >> 12:50 107 >> 15 5,3 7,6 22:18 2,7 00:43 13,0 0,0 0,0 47,7 144,8 >> 08:08 77 >> 16 5,8 7,7 03:05 1,5 23:59 12,5 0,0 3,9 11,5 81,1 >> 11:31 220 >> 17 3,1 7,0 23:59 -1,1 07:40 15,2 0,0 3,0 4,5 33,8 >> 18:52 51 >> 18 7,0 8,6 11:30 5,3 22:06 11,3 0,0 1,0 5,2 30,6 >> 23:40 173 >> 19 5,8 7,8 13:07 4,1 05:22 12,5 0,0 0,8 14,7 48,3 >> 07:24 191 >> 20 4,4 6,0 13:24 2,9 02:18 13,9 0,0 1,8 0,1 9,7 >> 03:11 264 >> 21 6,4 8,6 22:43 3,8 00:00 11,9 0,0 0,8 4,1 20,9 >> 11:54 76 >> 22 7,2 8,6 00:00 6,1 13:38 11,1 0,0 0,4 6,0 20,9 >> 10:46 154 >> >> Auch in allen anderen Dateien erscheinen die Daten windSpeed und windgust >> nicht wie in der Datenbank als km/h sondern es werden diese km/h-Daten als >> m/s-Daten gelesen und in km/h umgerechnet >> >> -------- >> >> Also in all other files, the data windSpeed and windGust do not appear as >> km / h as in the database but these km / h data are read as m / s data and >> converted into km / h >> >> I hope I could express myself correctly, >> thanks for your patience >> >> Gruss Hartmut >> >> -- >> 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] <javascript:>. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/weewx-development/04c96401-e359-45bb-91a2-27a301f283be%40googlegroups.com >> >> <https://groups.google.com/d/msgid/weewx-development/04c96401-e359-45bb-91a2-27a301f283be%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- 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/cf5c2763-c3e6-4112-a818-65d8d304c1ef%40googlegroups.com.
