Pondría los datos de cada estación en una base de datos diferente, no en una tabla. Puede saber si una estación está funcionando si su base de datos se está rellenando.
On Tue, Feb 18, 2020 at 6:23 PM jose riaño <[email protected]> wrote: > Amigo tomas entiendo tengo varias en una sola plataforma y se me > dificulta consultar datos en general de todas por ejemplo cual esta en > linea y cual esta caida es por eso mi pregunta. No se si tengas alguna idea > yo las tego asi una base de datos y diferentes tablas pero son mas de 30 > estaciones > > El mar., 18 de febrero de 2020 7:40 p. m., Thomas Keffer < > [email protected]> escribió: > >> Es mejor usar una base de datos separada para cada estación. >> >> Ver el artículo wiki *How to run multiple instances of WeeWX >> <https://github.com/weewx/weewx/wiki/weewx-multi>*. >> >> On Tue, Feb 18, 2020 at 11:54 AM jose riaño <[email protected]> wrote: >> >>> Tengo mi base de datos en mariadb y tengo varias estaciones, me sucede >>> tengo la siguiente tabla creada para que las estaciones guarden los datos >>> pero como hago para saber cual datos es de cual estación?? >>> >>> >>> CREATE TABLE datos(`dateTime` INTEGER NOT NULL UNIQUE PRIMARY KEY, >>> `usUnits` INTEGER NOT NULL, `interval` INTEGER NOT NULL, `barometer` REAL, >>> `pressure` REAL, `altimeter` REAL, `inTemp` REAL, `outTemp` REAL, >>> `inHumidity` REAL, `outHumidity` REAL, `windSpeed` REAL, `windDir` REAL, >>> `windGust` REAL, `windGustDir` REAL, `rainRate` REAL, `rain` REAL, >>> `dewpoint` REAL, `windchill` REAL, `heatindex` REAL, `ET` REAL, >>> `radiation` REAL, `UV` REAL, `extraTemp1` REAL, `extraTemp2` REAL, >>> `extraTemp3` REAL, `soilTemp1` REAL, `soilTemp2` REAL, `soilTemp3` REAL, >>> `soilTemp4` REAL, `leafTemp1` REAL, `leafTemp2` REAL, `extraHumid1` REAL, >>> `extraHumid2` REAL, `soilMoist1` REAL, `soilMoist2` REAL, `soilMoist3` >>> REAL, `soilMoist4` REAL, `leafWet1` REAL, `leafWet2` REAL, >>> `rxCheckPercent` REAL, `txBatteryStatus` REAL, `consBatteryVoltage` REAL, >>> `hail` REAL, `hailRate` REAL, `heatingTemp` REAL, `heatingVoltage` REAL, >>> `supplyVoltage` REAL, `referenceVoltage` REAL, `windBatteryStatus` REAL, >>> `rainBatteryStatus` REAL, `outTempBatteryStatus` REAL, >>> `inTempBatteryStatus` REAL); >>> >>> en esta tabla se guardan los datos per de todas las estaciones como hago >>> para saber cual es de cual?? >>> >>> Agradesco su ayuda. >>> >>> -- >>> 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]. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/weewx-user/d2110451-831b-47b0-9e17-c3d16c022dab%40googlegroups.com >>> <https://groups.google.com/d/msgid/weewx-user/d2110451-831b-47b0-9e17-c3d16c022dab%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >> -- >> 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]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/weewx-user/CAPq0zEAwjqpeQhErapSUtCcdm-6vZax%3DizPKBpySwyw1qhhO0w%40mail.gmail.com >> <https://groups.google.com/d/msgid/weewx-user/CAPq0zEAwjqpeQhErapSUtCcdm-6vZax%3DizPKBpySwyw1qhhO0w%40mail.gmail.com?utm_medium=email&utm_source=footer> >> . >> > -- > 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]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/weewx-user/CAJ%2BHrV4WZL9Ao9KSgCCVEHZ7F7nwJJSz_dziKVjAosuQBEwatQ%40mail.gmail.com > <https://groups.google.com/d/msgid/weewx-user/CAJ%2BHrV4WZL9Ao9KSgCCVEHZ7F7nwJJSz_dziKVjAosuQBEwatQ%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > -- 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CAPq0zEDsB1d0KA617p1KcPiE283OA7oPVZTz-KL3sQ5M7WcxWg%40mail.gmail.com.
