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.317038
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 Raw

@usgov.usda_gov_data_from_weather_snow_and_streamflow_from_fo_0c92ea68.air_temp_raw

418.41 kB
52,608 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
);

Dewpoint Final

@usgov.usda_gov_data_from_weather_snow_and_streamflow_from_fo_0c92ea68.dewpoint_final

375.44 kB
52,608 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

552.13 kB
52,608 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
);

Incoming Solar Raw

@usgov.usda_gov_data_from_weather_snow_and_streamflow_from_fo_0c92ea68.incoming_solar_raw

567.63 kB
52,608 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 Final

@usgov.usda_gov_data_from_weather_snow_and_streamflow_from_fo_0c92ea68.precipitation_final

64.74 kB
52,608 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
);

Precipitation Raw

@usgov.usda_gov_data_from_weather_snow_and_streamflow_from_fo_0c92ea68.precipitation_raw

2.02 MB
631,296 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 Final

@usgov.usda_gov_data_from_weather_snow_and_streamflow_from_fo_0c92ea68.relative_humidity_final

285.75 kB
52,608 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
);

Relative Humidity Raw

@usgov.usda_gov_data_from_weather_snow_and_streamflow_from_fo_0c92ea68.relative_humidity_raw

284.37 kB
52,608 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 Final

@usgov.usda_gov_data_from_weather_snow_and_streamflow_from_fo_0c92ea68.snow_course_final

7.84 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
);

Snow Course Raw

@usgov.usda_gov_data_from_weather_snow_and_streamflow_from_fo_0c92ea68.snow_course_raw

9.82 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 Final

@usgov.usda_gov_data_from_weather_snow_and_streamflow_from_fo_0c92ea68.snow_depth_final

199.28 kB
52,608 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
);

Snow Depth Raw

@usgov.usda_gov_data_from_weather_snow_and_streamflow_from_fo_0c92ea68.snow_depth_raw

1.74 MB
210,432 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
);

Station Coords 0

@usgov.usda_gov_data_from_weather_snow_and_streamflow_from_fo_0c92ea68.station_coords_0

3.81 kB
10 rows
4 columns

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

Stream Discharge Final 0

@usgov.usda_gov_data_from_weather_snow_and_streamflow_from_fo_0c92ea68.stream_discharge_final_0

64.08 kB
52,608 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
);

Vapor Pressure

@usgov.usda_gov_data_from_weather_snow_and_streamflow_from_fo_0c92ea68.vapor_pressure

478.15 kB
52,608 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 Dir Raw

@usgov.usda_gov_data_from_weather_snow_and_streamflow_from_fo_0c92ea68.wind_dir_raw

367.22 kB
52,608 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 Final

@usgov.usda_gov_data_from_weather_snow_and_streamflow_from_fo_0c92ea68.wind_speed_final

231.62 kB
52,608 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
);

Wind Speed Raw

@usgov.usda_gov_data_from_weather_snow_and_streamflow_from_fo_0c92ea68.wind_speed_raw

257.16 kB
52,608 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
);