variables <- dbGetQuery(db, "SELECT * FROM odm2.variables")
variableid variabletypecv variablecode variablenamecv variabledefinition speciationcv nodatavalue
1 Stable isotopes delta_18OOfH2O delta-18O of H2O Isotope 18O of water NA -9999
2 Stable isotopes delta_DOfH2O delta-D of H2O hydrogen isotopes of water NA -9999
3 Soil volumetricWaterContent Volumetric water content Volume of liquid water relative to bulk volume. Used for example to quantify soil moisture NA -9999
4 Soil temperature Temperature Temperature NA -9999
5 Soil bulkElectricalConductivity Bulk electrical conductivity Bulk electrical conductivity of a medium measured using a sensor such as time domain reflectometry (TDR), as a raw sensor response in the measurement of a quantity like soil moisture. NA -9999
6 Water quality methane Methane Methane (CH4) NA -9999
7 Water quality carbonDioxide Carbon dioxide Carbon dioxide (CO2) NA -9999
8 Climate windSpeed Wind speed Wind speed NA -9999
10 Climate windGustSpeed Wind gust speed Speed of gusts of wind NA -9999
11 Climate windDirection Wind direction Wind direction NA -9999
LS0tCnRpdGxlOiAiQ3VycmVudCB2YXJpYWJsZXMiCm91dHB1dDogaHRtbF9ub3RlYm9vawotLS0KCmBgYHtyIHNldHVwLCBpbmNsdWRlPUZBTFNFLCBtZXNzYWdlPUZBTFNFfQprbml0cjo6b3B0c19jaHVuayRzZXQoZWNobyA9IFRSVUUpCnBhc3N3b3JkIDwtIHNjYW4oIi5wZ3Bhc3MiLCB3aGF0PSIiKQpsaWJyYXJ5KHV1aWQpICMgdW5pcXVlIGlkcwpsaWJyYXJ5KFJQb3N0Z3JlU1FMKSAjIGRhdGFiYXNlCmxpYnJhcnkoa25pdHIpICMga2FibGUgZm9yIHRhYmxlIGZvcm1hdHRpbmcKbGlicmFyeShyZWFkcikgIyByZWFkX2NzdgpsaWJyYXJ5KERUKQpkYiA8LSBkYkNvbm5lY3QoUG9zdGdyZVNRTCgpLCAKICAgICAgICAgICAgICAgIGhvc3QgPSAic2VzeW5jLXBvc3RnaXMwMS5yZXNlYXJjaC5zZXN5bmMub3JnIiwKICAgICAgICAgICAgICAgIGRibmFtZSA9ICJjaG9wdGFuayIsIHVzZXIgPSAicGFsbWVyZ3JvdXAiLAogICAgICAgICAgICAgICAgcGFzc3dvcmQgPSBwYXNzd29yZCkKYGBgCgpgYGB7ciwgbWVzc2FnZT1GQUxTRSwgd2FybmluZz1GQUxTRX0KdmFyaWFibGVzIDwtIGRiR2V0UXVlcnkoZGIsICJTRUxFQ1QgKiBGUk9NIG9kbTIudmFyaWFibGVzIikKYGBgCgoKYGBge3IsIHJlc3VsdHM9J2FzaXMnLCBlY2hvID0gRkFMU0V9CmthYmxlKHZhcmlhYmxlcywgcm93bmFtZXMgPSBGQUxTRSkKYGBgCg==