|#||User Site ID||Sensor Type||Depth||# Records||Min||Max||Mean||Std. Dev.||MAST||MSST||MWST||MSST-MWST|
|User Site ID||Project||Sensor Type||Depth|
The Henry Mount Soil Temperature and Water database was created to store soil climate data collected by NRCS staff from in-ground sensors ("HOBOs") and weather stations (Onset Weather Station). The "Henry" database can currently accept soil temperature, soil moisture (volumetric water content), and air temperature data. Pending future funding, there are plans to add support for precipitation and water table depth. This database does not house data collected as part of the SCAN or SNOTEL network of stations.
There are several ways to interact with the Henry database:
The Henry database is composed to two main sets of tables: the sensor table which houses sensor/site metadata, and the soil_temperature/soil_vwc/air_temperature tables which house uploaded sensor data. Sensor metadata (e.g. rows in the sensor table) must be uniquely identified by the combination of NASIS user site id / sensor type / sensor depth.
Pending future funding, all sensor metadata additions or edits must be manually applied. Please send a CSV file formatted as follows to Dylan Beaudette. Note that the "sid" column (internally generated "sensor ID") should be blank for new sensors and left as-is for existing sensors.
|2-SON||2015CA6304010||dylan under canopy||202059||soiltemp||50||onset_h0800102||-120.42||38.04||CA630||283|
Data can be uploaded using two possible file formats. The "single sensor" format is very similar to the data exported from single-sensor ONSET devices, such as the older "HOBO" loggers. The "multiple sensor" format is the most flexible, however, final editing of the user site ID and column names must be done in a text editor.
Column headings are optional. Columns can be split by comma or TAB characters.
datetime,value 07/16/15 00:23:21.0,20.95 07/16/15 04:23:21.0,20.95 07/16/15 08:23:21.0,20.95 ...
This file format is a CSV file with an additional line added at the top, with the NASIS user site ID. Adding this top line is only possible in a text editor.Template
[user_site_id] datetime,[sensortype]_[depth]cm, ... other sensors ... [sensor data here]
S2013CA019002 datetime,soiltemp_10cm,soiltemp_20cm,soiltemp_50cm,soiltemp_100cm,airtemp,soilVWC_10cm,soilVWC_20cm,soilVWC_50cm,soilVWC_100cm 01/22/2015 16:00:00,10.296,11.370,14.649,17.415,6.687,0.1342,0.1020,0.0247,0.1091 01/22/2015 18:00:00,10.075,11.467,14.697,17.463,5.102,0.1317,0.0998,0.0252,0.1096 01/22/2015 20:00:00,9.089,11.370,14.721,17.463,10.956,0.1326,0.1014,0.0261,0.1101 ...
S2013CA019002 datetime,soiltemp_10cm 01/22/2015 16:00:00,10.296 01/22/2015 18:00:00,10.075 01/22/2015 20:00:00,9.089 ...
(click to zoom in)