[{"var_name":"obs_id","data_type":"bigint(20) unsigned","units":null,"label":"Record Number","description":"Record Number","category_units":null,"category_sensor":"metadata","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"station_id","data_type":"varbinary(32)","units":null,"label":"Station ID","description":"Station ID","category_units":null,"category_sensor":"metadata","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"obs_time","data_type":"datetime","units":"UTC","label":"Observation Timestamp","description":"Observation Timestamp","category_units":"time","category_sensor":"metadata","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"t1_air_150","data_type":"float","units":"C","label":"Temperature","description":"Average air Temperature from sensor #1 at 150 cm above the surface.","category_units":"temperature","category_sensor":"temperature","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"t2_air_150","data_type":"float","units":"C","label":"Temperature 2","description":"Average air Temperature from sensor #2 at 150 cm above the surface.","category_units":"temperature","category_sensor":"temperature","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"t1_air_900","data_type":"float","units":"C","label":"Temperature 4","description":"Average air Temperature from sensor #1 at 9 m above the surface.","category_units":"temperature","category_sensor":"temperature","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"td_150","data_type":"float","units":"C","label":"Dewpoint","description":"Average dewpoint from T&RH sensor at 150 cm","category_units":"dewpoint","category_sensor":"dewpoint","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"td_900","data_type":"float","units":"C","label":"Dewpoint Temperature 2","description":"Average dewpoint from T&RH sensor at 9m","category_units":"dewpoint","category_sensor":"dewpoint","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"rh_150","data_type":"float unsigned","units":"%","label":"Relative Humidity","description":"Average relative humidity from T&RH sensor at 150 cm","category_units":"relative humidity","category_sensor":"relative humidity","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"rh_900","data_type":"float unsigned","units":"%","label":"Relative Humidity 2","description":"Average relative humidity from T&RH sensor at 9m","category_units":"relative humidity","category_sensor":"relative humidity","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"vp_150","data_type":"float unsigned","units":"kPa","label":"Vapor Pressure 1","description":"Average vapor pressure at 150 cm over the output interval (5 min)","category_units":"vapor pressure","category_sensor":"vapor pressure","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"vp_900","data_type":"float unsigned","units":"kPa","label":"Vapor Pressure 2","description":"Average vapor pressure at 900 cm over the output interval (5 min)","category_units":"vapor pressure","category_sensor":"vapor pressure","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"satvp_150","data_type":"float unsigned","units":"kPa","label":"Saturated Vapor Pressure 1","description":"Average saturation vapor pressure at 150 cm over the output interval (5 min)","category_units":"vapor pressure","category_sensor":"vapor pressure","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"satvp_900","data_type":"float unsigned","units":"kPa","label":"Saturated Vapor Pressure 2","description":"Average saturation vapor pressure at 900 cm over the output interval (5 min)","category_units":"vapor pressure","category_sensor":"vapor pressure","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"t1_air_150_max","data_type":"float","units":"C","label":"Temperature 1 Max","description":"maximum air temperature from primary T sensor at 150 cm over the output interval (5 min)","category_units":"temperature","category_sensor":"temperature","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"t1_air_150_max_t","data_type":"datetime","units":"UTC","label":"Time of Temperature 1 Max","description":"time of the maximum air temperature over over the output interval (5 min)","category_units":"time","category_sensor":"temperature","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"t1_air_150_min","data_type":"float","units":"C","label":"Temperature 1 Min","description":"minimum air temperature from primary T sensor at 150 cm over the output interval (5 min)","category_units":"temperature","category_sensor":"temperature","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"t1_air_150_min_t","data_type":"datetime","units":"UTC","label":"Time of Temperature 1 Min","description":"time of the minimum air temperature over the over the output interval (5 min)","category_units":"time","category_sensor":"temperature","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"t2_air_150_max","data_type":"float","units":"C","label":"Temperature 2 Max","description":"maximum air temperature from primary T sensor at 150 cm over the output interval (5 min)","category_units":"temperature","category_sensor":"temperature","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"t2_air_150_max_t","data_type":"datetime","units":"UTC","label":"Time of Temperature 2 Max","description":"time of the maximum air temperature over over the output interval (5 min)","category_units":"time","category_sensor":"temperature","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"t2_air_150_min","data_type":"float","units":"C","label":"Temperature 2 Min","description":"minimum air temperature from primary T sensor at 150 cm over the output interval (5 min)","category_units":"temperature","category_sensor":"temperature","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"t2_air_150_min_t","data_type":"datetime","units":"UTC","label":"Time of Temperature 2 Min","description":"time of the minimum air temperature over the over the output interval (5 min)","category_units":"time","category_sensor":"temperature","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"t1_air_900_max","data_type":"float","units":"C","label":"Temperature 3 Max","description":"maximum air temperature from primary T sensor at 150 cm over the output interval (5 min)","category_units":"temperature","category_sensor":"temperature","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"t1_air_900_max_t","data_type":"datetime","units":"UTC","label":"Time of Temperature 3 Max","description":"time of the maximum air temperature over over the output interval (5 min)","category_units":"time","category_sensor":"temperature","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"t1_air_900_min","data_type":"float","units":"C","label":"Temperature 3 Min","description":"minimum air temperature from primary T sensor at 150 cm over the output interval (5 min)","category_units":"temperature","category_sensor":"temperature","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"t1_air_900_min_t","data_type":"datetime","units":"UTC","label":"Time of Temperature 3 Min","description":"time of the minimum air temperature over the over the output interval (5 min)","category_units":"time","category_sensor":"temperature","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"ws_1000","data_type":"float unsigned","units":"m/s","label":"Wind Speed","description":"Wind Speed from sensor at 10 m","category_units":"wind speed","category_sensor":"wind","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"ws_150","data_type":"float unsigned","units":"m/s","label":"Wind Speed 2","description":"Wind Speed from sensor at 150 cm","category_units":"wind speed","category_sensor":"wind","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"wd_1000","data_type":"float unsigned","units":"degree from north","label":"Wind Direction","description":"Wind Direction from sensor at 10 m","category_units":"wind direction","category_sensor":"wind","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"wd_150","data_type":"float unsigned","units":"degree from north","label":"Wind Direction 2","description":"Wind Direction from sensor at 150 cm","category_units":"wind direction","category_sensor":"wind","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"wd_1000_std","data_type":"float unsigned","units":"degree from north","label":"Std Deviation Wind Dir 1","description":"std dev of the wind direction over the output interval (5 min) from sensor at 10 m","category_units":"direction-raw","category_sensor":"wind","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"wd_150_std","data_type":"float unsigned","units":"degree from north","label":"Std Deviation Wind Dir 2","description":"std dev of the wind direction over the output interval (5 min) from sensor at 150 cm","category_units":"direction-raw","category_sensor":"wind","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"wg_1000","data_type":"float unsigned","units":"m/s","label":"Wind Gust","description":"Max wind speed (Wind Gust) over output interval (5 min) from sensor at 10 m","category_units":"wind speed","category_sensor":"wind","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"wg_150","data_type":"float unsigned","units":"m/s","label":"Wind Gust 2","description":"Max wind speed (Wind Gust) over output interval (5 min) from sensor at 150 cm","category_units":"wind speed","category_sensor":"wind","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"wg_1000_t","data_type":"datetime","units":"UTC","label":"Wind Gust 1 Time","description":"Time of max wind speed over the output interval (5 min) from sensor at 10 m","category_units":"time","category_sensor":"wind","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"wg_150_t","data_type":"datetime","units":"UTC","label":"Wind Gust 2 Time","description":"Time of max wind speed over the output interval (5 min) from sensor at 150 cm","category_units":"time","category_sensor":"wind","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"bp_stn","data_type":"float unsigned","units":"hPa","label":"Station Pressure","description":"Station Pressure","category_units":"pressure","category_sensor":"pressure","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"bp_slp","data_type":"float unsigned","units":"hPa","label":"Sea Level Pressure","description":"Sea Level Pressure","category_units":"pressure","category_sensor":"pressure","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"p_tot","data_type":"float unsigned","units":"mm","label":"Precipitation","description":"Total Precipitation in the report interval","category_units":"precip","category_sensor":"precip","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"p_rate","data_type":"float unsigned","units":"mm/hr","label":"Precip Rate","description":"Precip Rate - 1hr Precipitation/hr","category_units":"precip-hr","category_sensor":"precip","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"p_1h","data_type":"float unsigned","units":"mm","label":"1hr Precipitation","description":"1 hr Precipitation (running)","category_units":"precip","category_sensor":"precip","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"p_24h","data_type":"float unsigned","units":"mm","label":"24hr Precipitation","description":"24 hr Precipitation (running)","category_units":"precip","category_sensor":"precip","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"p_48h","data_type":"float unsigned","units":"mm","label":"48hr Precipitation","description":"48 hr Precipitation (running)","category_units":"precip","category_sensor":"precip","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"p_7d","data_type":"float unsigned","units":"mm","label":"7 Day Precipitation","description":"7 Day Precipitation (running)","category_units":"precip","category_sensor":"precip","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"p_30d","data_type":"float unsigned","units":"mm","label":"30 Day Precipitation","description":"30 Day Precipitation (running)","category_units":"precip","category_sensor":"precip","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"p_60d","data_type":"float unsigned","units":"mm","label":"60 Day Precipitation","description":"60 Day Precipitation (running)","category_units":"precip","category_sensor":"precip","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"p_90d","data_type":"float unsigned","units":"mm","label":"90 Day Precipitation","description":"90 Day Precipitation (running)","category_units":"precip","category_sensor":"precip","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"p_120d","data_type":"float unsigned","units":"mm","label":"120 Day Precipitation","description":"120 Day Precipitation (running)","category_units":"precip","category_sensor":"precip","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"p_150d","data_type":"float unsigned","units":"mm","label":"150 Day Precipitation","description":"150 Day Precipitation (running)","category_units":"precip","category_sensor":"precip","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"p_180d","data_type":"float unsigned","units":"mm","label":"180 Day Precipitation","description":"180 Day Precipitation (running)","category_units":"precip","category_sensor":"precip","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"p_365d","data_type":"float unsigned","units":"mm","label":"365 Day Precipitation","description":"365 Day Precipitation (running)","category_units":"precip","category_sensor":"precip","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"p_day","data_type":"float unsigned","units":"mm","label":"Precip Since Midnight","description":"Precipitation Since Local Midnight","category_units":"precip","category_sensor":"precip","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"p_month","data_type":"float unsigned","units":"mm","label":"Monthly Precipitation","description":"Month Precipitation","category_units":"precip","category_sensor":"precip","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"p_year","data_type":"float unsigned","units":"mm","label":"Yearly Precipitation","description":"Yearly Precipitation","category_units":"precip","category_sensor":"precip","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"p_wy","data_type":"float unsigned","units":"mm","label":"Water Year Precipitation","description":"Water Year Precip (Since Local Midnight 10/1)","category_units":"precip","category_sensor":"precip","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"r_swin","data_type":"float unsigned","units":"W/m^2","label":"Solar Radiation","description":"Incoming shortwave (Solar) radiation Flux Density","category_units":"radiation","category_sensor":"radiation","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"r_swin_tot","data_type":"float unsigned","units":"MJ/m^2","label":"Total Incoming Shortwave Flux","description":"Incoming shortwave (Solar) radiation totalted over the output interval (5 min)","category_units":"radiation","category_sensor":"radiation","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"t_soil_5","data_type":"float","units":"C","label":"Soil Temperature at 2 in.","description":"Soil Temperature at  5 cm below ground level","category_units":"temperature","category_sensor":"soil","var_class":"aux","public":1,"start_t":null,"end_t":null},{"var_name":"t_soil_10","data_type":"float","units":"C","label":"Soil Temperature at 4 in.","description":"Soil Temperature at  10 cm below ground level","category_units":"temperature","category_sensor":"soil","var_class":"aux","public":1,"start_t":null,"end_t":null},{"var_name":"t_soil_20","data_type":"float","units":"C","label":"Soil Temperature at 8 in.","description":"Soil Temperature at  20 cm below ground level","category_units":"temperature","category_sensor":"soil","var_class":"aux","public":1,"start_t":null,"end_t":null},{"var_name":"t_soil_30","data_type":"float","units":"C","label":"Soil Temperature at 12 in.","description":"Soil Temperature at  30 cm below ground level","category_units":"temperature","category_sensor":"soil","var_class":"aux","public":1,"start_t":null,"end_t":null},{"var_name":"t_soil_40","data_type":"float","units":"C","label":"Soil Temperature at 16 in.","description":"Soil Temperature at  40 cm below ground level","category_units":"temperature","category_sensor":"soil","var_class":"aux","public":1,"start_t":null,"end_t":null},{"var_name":"t_soil_50","data_type":"float","units":"C","label":"Soil Temperature at 20 in.","description":"Soil Temperature at  50 cm below ground level","category_units":"temperature","category_sensor":"soil","var_class":"aux","public":1,"start_t":null,"end_t":null},{"var_name":"vw_soil_5","data_type":"float unsigned","units":"%","label":"Soil moisture at 2 in.","description":"Soil volumetric water content at  5 cm below ground level","category_units":"soil-water","category_sensor":"soil","var_class":"aux","public":1,"start_t":null,"end_t":null},{"var_name":"vw_soil_10","data_type":"float unsigned","units":"%","label":"Soil moisture at 4 in.","description":"Soil volumetric water content at  10 cm below ground level","category_units":"soil-water","category_sensor":"soil","var_class":"aux","public":1,"start_t":null,"end_t":null},{"var_name":"vw_soil_20","data_type":"float unsigned","units":"%","label":"Soil moisture at 8 in.","description":"Soil volumetric water content at  20 cm below ground level","category_units":"soil-water","category_sensor":"soil","var_class":"aux","public":1,"start_t":null,"end_t":null},{"var_name":"vw_soil_30","data_type":"float unsigned","units":"%","label":"Soil moisture at 12 in.","description":"Soil volumetric water content at  30 cm below ground level","category_units":"soil-water","category_sensor":"soil","var_class":"aux","public":1,"start_t":null,"end_t":null},{"var_name":"vw_soil_40","data_type":"float unsigned","units":"%","label":"Soil moisture at 16 in.","description":"Soil volumetric water content at  40 cm below ground level","category_units":"soil-water","category_sensor":"soil","var_class":"aux","public":1,"start_t":null,"end_t":null},{"var_name":"vw_soil_50","data_type":"float unsigned","units":"%","label":"Soil moisture at 20 in.","description":"Soil volumetric water content at  50 cm below ground level","category_units":"soil-water","category_sensor":"soil","var_class":"aux","public":1,"start_t":null,"end_t":null},{"var_name":"pt_soil_5","data_type":"float unsigned","units":null,"label":"Soil moisture 1","description":"Soil permittivity at  5 cm below ground level","category_units":null,"category_sensor":"soil","var_class":"aux","public":1,"start_t":null,"end_t":null},{"var_name":"pt_soil_10","data_type":"float unsigned","units":null,"label":"Soil moisture 2","description":"Soil permittivity at  10 cm below ground level","category_units":null,"category_sensor":"soil","var_class":"aux","public":1,"start_t":null,"end_t":null},{"var_name":"pt_soil_20","data_type":"float unsigned","units":null,"label":"Soil moisture 3","description":"Soil permittivity at  20 cm below ground level","category_units":null,"category_sensor":"soil","var_class":"aux","public":1,"start_t":null,"end_t":null},{"var_name":"pt_soil_30","data_type":"float unsigned","units":null,"label":"Soil moisture 4","description":"Soil permittivity at  30 cm below ground level","category_units":null,"category_sensor":"soil","var_class":"aux","public":1,"start_t":null,"end_t":null},{"var_name":"pt_soil_40","data_type":"float unsigned","units":null,"label":"Soil moisture 5","description":"Soil permittivity at  40 cm below ground level","category_units":null,"category_sensor":"soil","var_class":"aux","public":1,"start_t":null,"end_t":null},{"var_name":"pt_soil_50","data_type":"float unsigned","units":null,"label":"Soil moisture 6","description":"Soil permittivity at  50 cm below ground level","category_units":null,"category_sensor":"soil","var_class":"aux","public":1,"start_t":null,"end_t":null},{"var_name":"ec_soil_5","data_type":"float unsigned","units":"dS/m","label":"Soil conductivity 1","description":"Soil bulk electrical conductivity at  5 cm 1 below ground level","category_units":"conductivity","category_sensor":"soil","var_class":"aux","public":1,"start_t":null,"end_t":null},{"var_name":"ec_soil_10","data_type":"float unsigned","units":"dS/m","label":"Soil conductivity 2","description":"Soil bulk electrical conductivity at  10 cm below ground level","category_units":"conductivity","category_sensor":"soil","var_class":"aux","public":1,"start_t":null,"end_t":null},{"var_name":"ec_soil_20","data_type":"float unsigned","units":"dS/m","label":"Soil conductivity 3","description":"Soil bulk electrical conductivity at  20 cm below ground level","category_units":"conductivity","category_sensor":"soil","var_class":"aux","public":1,"start_t":null,"end_t":null},{"var_name":"ec_soil_30","data_type":"float unsigned","units":"dS/m","label":"Soil conductivity 4","description":"Soil bulk electrical conductivity at  30 cm below ground level","category_units":"conductivity","category_sensor":"soil","var_class":"aux","public":1,"start_t":null,"end_t":null},{"var_name":"ec_soil_40","data_type":"float unsigned","units":"dS/m","label":"Soil conductivity 5","description":"Soil bulk electrical conductivity at  40 cm below ground level","category_units":"conductivity","category_sensor":"soil","var_class":"aux","public":1,"start_t":null,"end_t":null},{"var_name":"ec_soil_50","data_type":"float unsigned","units":"dS/m","label":"Soil conductivity 6","description":"Soil bulk electrical conductivity at  50 cm below ground level","category_units":"conductivity","category_sensor":"soil","var_class":"aux","public":1,"start_t":null,"end_t":null},{"var_name":"lw_raw_out","data_type":"float unsigned","units":"mV","label":"Leaf Wetness","description":"Leaf wetness sensor raw output (mV)","category_units":"voltage","category_sensor":"leaf wetness","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"lightning_tot","data_type":"int(10) unsigned","units":"count","label":"Lightning Total","description":"Lightning strike total","category_units":"count","category_sensor":"lightning","var_class":"aux","public":1,"start_t":null,"end_t":null},{"var_name":"lightning_dist_min","data_type":"int(10) unsigned","units":"mile","label":"Min Lightning Distance","description":"Minimum distance to closest lightning strike","category_units":"distance","category_sensor":"lightning","var_class":"aux","public":1,"start_t":null,"end_t":null},{"var_name":"lightning_dist_min_t","data_type":"datetime","units":"datetime","label":"Min Lightning Distance Time","description":"Time of closest lightning","category_units":"time","category_sensor":"lightning","var_class":"aux","public":1,"start_t":null,"end_t":null},{"var_name":"batt_min","data_type":"float unsigned","units":"V","label":"Battery Voltage","description":"minimum Battery Voltage recorded over the output interval (5 min)","category_units":"voltage","category_sensor":"diagnostics","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"t_sens_logger","data_type":"float","units":"C","label":"Logger Temperature","description":"Temperature of the logger  inside the control box","category_units":"temperature","category_sensor":"diagnostics","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"qc_maint_flag","data_type":"tinyint(1)","units":"boolean","label":"Maintenance Flag","description":"True/false station requires or in maintenance","category_units":"boolean","category_sensor":"diagnostics","var_class":"primary","public":1,"start_t":null,"end_t":null},{"var_name":"vp","data_type":"float unsigned","units":"kPa","label":"Vapor Pressure","description":"Vapor Pressure (unknown height)","category_units":"vapor pressure","category_sensor":"vapor pressure","var_class":"aux","public":1,"start_t":null,"end_t":null}]