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.
