Last active
December 10, 2015 13:48
-
-
Save benben/4442954 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
arDate = 03-JAN-2013 | |
arTime = 12:00PM | |
arOutTemp = 6.0 | |
arOutTempHi = 6.0 | |
arOutTempLo = 5.7 | |
arRainfall = 0 | |
arRainRateHi = 0 | |
arBaro = 1027.630 | |
arWindSamples = 116 | |
arInTemp = 23.1 | |
arInHum = 41 | |
arOutHum = 88 | |
arWindAvg = 28 | |
arWindHi = 53 | |
arWindHiDir = WSW | |
arWindPrevailDir = WSW | |
arForecastRuleNum = 1 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
rtBaroTrend = Rising Slowly | |
rtBaroTrendImg = baro_rs | |
rtBaroCurr = 1027.5 | |
rtInsideTemp = 23.4 | |
rtInsideHum = 43 | |
rtOutsideTemp = 6.2 | |
rtOutsideHum = 87 | |
rtWindSpeed = 22 | |
rtWindAvgSpeed = 27 | |
rtWindDir = 249 | |
rtWindDirRose = WSW | |
rtWindChill = 2.3 | |
rtHeatIndex = 6.2 | |
rtRainRate = 0.00 | |
rtIsRaining = no | |
rtUVIndex = n/a | |
rtSolarRad = n/a | |
rtRainStorm = 48.51 | |
rtStormStartDate = 25-DEC-2012 | |
rtDayRain = 0.76 | |
rtMonthRain = 5.84 | |
rtYearRain = 5.84 | |
rtDayET = 0.000 | |
rtDayETmL = 0.00 | |
rtMonthET = 0.000 | |
rtYearET = 0.000 | |
rtXmitBattt = 0 | |
rtBattVoltage = 2.7 | |
rtForeIcon = 8 | |
rtForeRule = 1 | |
rtForecast = Mostly clear with little temperature change. | |
rtSunrise = 8:19AM | |
rtSunset = 4:24PM | |
rtCaptureTimestamp = 2013-01-03 12:53:03 (1357213983) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE TABLE archive ( | |
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 | |
) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment