Dataset: Data From: Weather, Snow, And Streamflow Data From Four Western Juniper-dominated Experimental Catchments In South Western Idaho, USA.

About this Dataset

Data From: Weather, Snow, And Streamflow Data From Four Western Juniper-dominated Experimental Catchments In South Western Idaho, USA.

Weather, snow, stream, topographic, and vegetation data are presented from the South Mountain Experimental Catchments from water years 2007-2013 (10-1-2007 to 9-30-2013). The data provide detailed information on the weather and hydrologic response for four highly instrumented catchments in the late stages of woodland encroachment. Hourly data from six meteorologic stations and four weirs have been carefully processed and quality checked, are serially complete, and ideal for hydrologic, ecosystem, and biogeochemical modeling. Topographic and vegetation data, as well as stream and drainage area delineations are Lidar-derived. This study site was established in 2007 as a collaborative, long-term research laboratory to address the impacts of western juniper (Juniperus occidentalis Hook) encroachment and treatments in the interior Great Basin region of the western USA.

For more information about this dataset, contact: Patrick R. Kormos: patrick.kormos@ars.usda.gov Danny G. Marks: ars.danny@gmail.com
Organization: Department of Agriculture
Last updated: 2024-03-30T11:06:57.317032
Tags: ars, data-gov, earth-science-atmosphere-atmospheric-radiation-incoming-solar-radiation, earth-science-atmosphere-atmospheric-temperature-air-temperature, earth-science-atmosphere-atmospheric-water-vapor-dew-point-temperature, earth-science-atmosphere-atmospheric-water-vapor-humidity, earth-science-atmosphere-atmospheric-winds-surface-winds-wind-speed-wind-direction, earth-science-atmosphere-precipitation-precipitation-amount, earth-science-atmosphere-precipitation-rain, earth-science-atmosphere-precipitation-snow, earth-science-biosphere-aquatic-ecosystems, earth-science-terrestrial-hydrosphere-surface-water, earth-science-terrestrial-hydrosphere-surface-water-discharge-flow, juniperus-occidentalis, meteorological-data, np211, weather, weirs, western-united-states, woodland

Tables

Air Temp Final

@usgov.usda_gov_data_from_weather_snow_and_streamflow_from_fo_0c92ea68.air_temp_final

408.99 KB
52608 rows
11 columns


CREATE TABLE air_temp_final (
  "water_year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "calendar_year" BIGINT,
  "hour" BIGINT,
  "sme2_ta_c" DOUBLE,
  "smf1_ta_c" DOUBLE,
  "smg1_ta_c" DOUBLE,
  "smg2_ta_c" DOUBLE,
  "smm1_ta_c" DOUBLE,
  "smm2_ta_c" DOUBLE
);

Dewpoint Final

@usgov.usda_gov_data_from_weather_snow_and_streamflow_from_fo_0c92ea68.dewpoint_final

366.64 KB
52608 rows
11 columns


CREATE TABLE dewpoint_final (
  "water_year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "calendar_year" BIGINT,
  "hour" BIGINT,
  "sme2_dpt_c" DOUBLE,
  "smf1_dpt_c" DOUBLE,
  "smg1_dpt_c" DOUBLE,
  "smg2_dpt_c" DOUBLE,
  "smm1_dpt_c" DOUBLE,
  "smm2_dpt_c" DOUBLE
);

Incoming Solar Final

@usgov.usda_gov_data_from_weather_snow_and_streamflow_from_fo_0c92ea68.incoming_solar_final

539.19 KB
52608 rows
11 columns


CREATE TABLE incoming_solar_final (
  "water_year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "calendar_year" BIGINT,
  "hour" BIGINT,
  "sme2_sin_w_m2" DOUBLE,
  "smf1_sin_w_m2" DOUBLE,
  "smg1_sin_w_m2" DOUBLE,
  "smg2_sin_w_m2" DOUBLE,
  "smm1_sin_w_m2" DOUBLE,
  "smm2_sin_w_m2" DOUBLE
);

Precipitation Final

@usgov.usda_gov_data_from_weather_snow_and_streamflow_from_fo_0c92ea68.precipitation_final

63.22 KB
52608 rows
11 columns


CREATE TABLE precipitation_final (
  "water_year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "calendar_year" BIGINT,
  "hour" BIGINT,
  "sme2_ppt_mm" DOUBLE,
  "smf1_ppt_mm" DOUBLE,
  "smg1_ppt_mm" DOUBLE,
  "smg2_ppt_mm" DOUBLE,
  "smm1_ppt_mm" DOUBLE,
  "smm2_ppt_mm" DOUBLE
);

Relative Humidity Final

@usgov.usda_gov_data_from_weather_snow_and_streamflow_from_fo_0c92ea68.relative_humidity_final

279.06 KB
52608 rows
11 columns


CREATE TABLE relative_humidity_final (
  "water_year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "calendar_year" BIGINT,
  "hour" BIGINT,
  "sme2_rh" DOUBLE,
  "smf1_rh" DOUBLE,
  "smg1_rh" DOUBLE,
  "smg2_rh" DOUBLE,
  "smm1_rh" DOUBLE,
  "smm2_rh" DOUBLE
);

Snow Depth Final

@usgov.usda_gov_data_from_weather_snow_and_streamflow_from_fo_0c92ea68.snow_depth_final

194.61 KB
52608 rows
11 columns


CREATE TABLE snow_depth_final (
  "water_year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "calendar_year" BIGINT,
  "hour" BIGINT,
  "sme2_sd_mm" VARCHAR,
  "smf1_sd_mm" BIGINT,
  "smg1_sd_mm" BIGINT,
  "smg2_sd_mm" VARCHAR,
  "smm1_sd_mm" BIGINT,
  "smm2_sd_mm" BIGINT
);

Vapor Pressure

@usgov.usda_gov_data_from_weather_snow_and_streamflow_from_fo_0c92ea68.vapor_pressure

466.95 KB
52608 rows
11 columns


CREATE TABLE vapor_pressure (
  "water_year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "calendar_year" BIGINT,
  "hour" BIGINT,
  "sme2_vp_pa" BIGINT,
  "smf1_vp_pa" BIGINT,
  "smg1_vp_pa" BIGINT,
  "smg2_vp_pa" BIGINT,
  "smm1_vp_pa" BIGINT,
  "smm2_vp_pa" BIGINT
);

Wind Speed Final

@usgov.usda_gov_data_from_weather_snow_and_streamflow_from_fo_0c92ea68.wind_speed_final

226.19 KB
52608 rows
11 columns


CREATE TABLE wind_speed_final (
  "water_year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "calendar_year" BIGINT,
  "hour" BIGINT,
  "sme2_ws_m_s" DOUBLE,
  "smf1_ws_m_s" DOUBLE,
  "smg1_ws_m_s" DOUBLE,
  "smg2_ws_m_s" DOUBLE,
  "smm1_ws_m_s" DOUBLE,
  "smm2_ws_m_s" DOUBLE
);

Snow Course Final

@usgov.usda_gov_data_from_weather_snow_and_streamflow_from_fo_0c92ea68.snow_course_final

7.66 KB
17 rows
10 columns


CREATE TABLE snow_course_final (
  "water_year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "calendar_year" BIGINT,
  "sme2_swe_mm" VARCHAR,
  "smf1_swe_mm" VARCHAR,
  "smg1_swe_mm" VARCHAR,
  "smg2_swe_mm" VARCHAR,
  "smm1_swe_mm" VARCHAR,
  "smm2_swe_mm" VARCHAR
);

Station Coords 0

@usgov.usda_gov_data_from_weather_snow_and_streamflow_from_fo_0c92ea68.station_coords_0

3.72 KB
10 rows
4 columns


CREATE TABLE station_coords_0 (
  "station_id" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "elevation" BIGINT
);

Air Temp Raw

@usgov.usda_gov_data_from_weather_snow_and_streamflow_from_fo_0c92ea68.air_temp_raw

408.6 KB
52608 rows
11 columns


CREATE TABLE air_temp_raw (
  "water_year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "calendar_year" BIGINT,
  "hour" BIGINT,
  "sme2_ta_c" VARCHAR,
  "smf1_ta_c" VARCHAR,
  "smg1_ta_c" VARCHAR,
  "smg2_ta_c" VARCHAR,
  "smm1_ta_c" VARCHAR,
  "smm2_ta_c" VARCHAR
);

Incoming Solar Raw

@usgov.usda_gov_data_from_weather_snow_and_streamflow_from_fo_0c92ea68.incoming_solar_raw

554.32 KB
52608 rows
11 columns


CREATE TABLE incoming_solar_raw (
  "water_year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "calendar_year" BIGINT,
  "hour" BIGINT,
  "sme2_sin_w_m2" VARCHAR,
  "smf1_sin_w_m2" VARCHAR,
  "smg1_sin_w_m2" VARCHAR,
  "smg2_sin_w_m2" VARCHAR,
  "smm1_sin_w_m2" VARCHAR,
  "smm2_sin_w_m2" VARCHAR
);

Precipitation Raw

@usgov.usda_gov_data_from_weather_snow_and_streamflow_from_fo_0c92ea68.precipitation_raw

1.92 MB
631296 rows
12 columns


CREATE TABLE precipitation_raw (
  "water_year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "calendar_year" BIGINT,
  "hour" BIGINT,
  "minute" BIGINT,
  "sme2_ppt_mm" VARCHAR,
  "smf1_ppt_mm" VARCHAR,
  "smg1_ppt_mm" VARCHAR,
  "smg2_ppt_mm" VARCHAR,
  "smm1_ppt_mm" VARCHAR,
  "smm2_ppt_mm" VARCHAR
);

Relative Humidity Raw

@usgov.usda_gov_data_from_weather_snow_and_streamflow_from_fo_0c92ea68.relative_humidity_raw

277.71 KB
52608 rows
11 columns


CREATE TABLE relative_humidity_raw (
  "water_year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "calendar_year" BIGINT,
  "hour" BIGINT,
  "sme2_rh" VARCHAR,
  "smf1_rh" VARCHAR,
  "smg1_rh" VARCHAR,
  "smg2_rh" VARCHAR,
  "smm1_rh" VARCHAR,
  "smm2_rh" VARCHAR
);

Snow Course Raw

@usgov.usda_gov_data_from_weather_snow_and_streamflow_from_fo_0c92ea68.snow_course_raw

9.59 KB
345 rows
11 columns


CREATE TABLE snow_course_raw (
  "water_year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "calendar_year" BIGINT,
  "station_id" VARCHAR,
  "sample" BIGINT,
  "snowdepth_in" DOUBLE,
  "corelength_in" DOUBLE,
  "wt_total_in" VARCHAR,
  "wt_tube_in" VARCHAR,
  "bulk_y_n" VARCHAR
);

Snow Depth Raw

@usgov.usda_gov_data_from_weather_snow_and_streamflow_from_fo_0c92ea68.snow_depth_raw

1.66 MB
210432 rows
12 columns


CREATE TABLE snow_depth_raw (
  "water_year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "calendar_year" BIGINT,
  "hour" BIGINT,
  "minute" BIGINT,
  "sme2_sd_mm" VARCHAR,
  "smf1_sd_mm" VARCHAR,
  "smg1_sd_mm" VARCHAR,
  "smg2_sd_mm" VARCHAR,
  "smm1_sd_mm" VARCHAR,
  "smm2_sd_mm" VARCHAR
);

Wind Dir Raw

@usgov.usda_gov_data_from_weather_snow_and_streamflow_from_fo_0c92ea68.wind_dir_raw

358.61 KB
52608 rows
11 columns


CREATE TABLE wind_dir_raw (
  "water_year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "calendar_year" BIGINT,
  "hour" BIGINT,
  "sme2_wd_deg" VARCHAR,
  "smf1_wd_deg" VARCHAR,
  "smg1_wd_deg" VARCHAR,
  "smg2_wd_deg" VARCHAR,
  "smm1_wd_deg" VARCHAR,
  "smm2_wd_deg" VARCHAR
);

Wind Speed Raw

@usgov.usda_gov_data_from_weather_snow_and_streamflow_from_fo_0c92ea68.wind_speed_raw

251.14 KB
52608 rows
11 columns


CREATE TABLE wind_speed_raw (
  "water_year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "calendar_year" BIGINT,
  "hour" BIGINT,
  "sme2_ws_m_s" VARCHAR,
  "smf1_ws_m_s" VARCHAR,
  "smg1_ws_m_s" VARCHAR,
  "smg2_ws_m_s" VARCHAR,
  "smm1_ws_m_s" VARCHAR,
  "smm2_ws_m_s" VARCHAR
);

Stream Discharge Final 0

@usgov.usda_gov_data_from_weather_snow_and_streamflow_from_fo_0c92ea68.stream_discharge_final_0

62.58 KB
52608 rows
9 columns


CREATE TABLE stream_discharge_final_0 (
  "water_year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "calendar_year" BIGINT,
  "hour" BIGINT,
  "sme_q_mm" DOUBLE,
  "smf_q_mm" DOUBLE,
  "smg_q_mm" DOUBLE,
  "smm_q_mm" DOUBLE
);