Skip to content

Instantly share code, notes, and snippets.

@benben
Last active December 10, 2015 13:48
Show Gist options
  • Save benben/4442954 to your computer and use it in GitHub Desktop.
Save benben/4442954 to your computer and use it in GitHub Desktop.
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
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)
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