Department of Agriculture
@usgov.usda_gov_vegetation_rainfall_simulation_and_overland_f_a42d49cd
Simulated rainfall and overland-flow experiments are useful for enhancing understanding of surface hydrologic and erosion processes, quantifying runoff and erosion rates, and developing and testing predictive quantitative models. This extensive dataset (1021 experimental plots) consists of rainfall simulation (1300 plot runs, 0.5 m2 to 13 m2 scales) and overland flow (838 plot runs, ~9 m2 scale) experimental plot data coupled with associated measures of vegetation, ground cover, and surface soil properties across point to hillslope scales. The data were collected at three woodland-encroached sagebrush (Artemisia spp.) rangelands in the Great Basin, USA, under undisturbed/untreated conditions and 1 yr to 9 yr following fire and/or mechanical tree-removal treatments. The methodology employed and resulting experimental data contribute to quantifying and understanding scale-dependent surface hydrologic and erosion processes for Great Basin woodlands and sagebrush rangelands before and after tree removal and for sparsely vegetated sites elsewhere. The dataset is a valuable source for developing and testing hydrology and erosion models for applications to diverse vegetation and ground cover conditions. Lastly, the series of repeated measures in the dataset for some sites over time provides a valuable dataset for exploring long-term landscape vegetation and hydrologic and erosion responses to various land management practices and disturbances.
The resulting collective dataset of 1021 experimental plots contains vegetation, ground cover, soils, hydrology, and erosion data collected across multiple spatial scales, diverse cover and surface conditions, three study sites, and five different study years. The collective dataset contains 57 plots at the hillslope scale (site characterization plots), 528 small-rainfall plots, 146 large-rainfall plots, and 290 overland-flow plots. The hydrology and erosion experiments yielded time series datasets for small-rainfall plot, large-rainfall plot, and overland-flow plot simulations. Some time series hydrographs and sedigraphs from rainfall and overland flow simulations were excluded due to various equipment failures. The final time series datasets consist of 1020 small-rainfall, 280 large-rainfall, and 838 overland-flow plot run hydrographs and sedigraphs, not excluding plots without runoff. Restricting the data to plots that generated runoff results in 749 small-rainfall, 251 large-rainfall, and 719 overland-flow plot simulation hydrographs and sedigraphs. Overall, the hydrology and erosion time series dataset amounts to 2138 hydrographs/sedigraphs including plots with zero runoff and 1719 hydrographs/sedigraphs for plots that generated runoff.
Field experiments and data management were conducted as part of the Sagebrush Steppe Treatment Evaluation Project (SageSTEP, (www.sagestep.org) funded by the US Joint Fire Science Program, US Department of Interior (USDI) Bureau of Land Management, and US National Interagency Fire Center. This dataset is contribution number 134 of the Sagebrush Steppe Treatment Evaluation Project.
See README file for information regarding experimental design and methods.
Organization: Department of Agriculture
Last updated: 2024-04-10T09:15:49.165628
Tags: ars, concentrated-flow, data-gov, erosion, fire, fire-effects, great-basin, hydrologic-recovery, infiltration, interrill, islands-of-fertility, juniper, mastication, mechanical-treatments, overland-flow, pinyon, rainfall-simulation, rainsplash, rangeland, restoration, rill, rills, runoff, sagebrush, sagebrush-restoration, sagebrush-steppe, sagestep, sheetflow, soil-loss, soil-water-repellency, tree-cutting, tree-shredding, wildfire, woodland-encroachment, woodland-expansion
CREATE TABLE large_plots (
"field_plot_num" BIGINT,
"site" VARCHAR,
"utmnrth_nad83" BIGINT,
"utmeast_nad83" BIGINT,
"year" BIGINT,
"microsite" VARCHAR,
"treatment_area" VARCHAR,
"treated_y_n" VARCHAR,
"treatment_date" VARCHAR,
"cut_tree_y_n" VARCHAR,
"cut_tree_type" VARCHAR,
"cuttree_trnkdiam_cm" VARCHAR,
"cuttreeheight_cm" VARCHAR,
"cuttree_crowndiam_cm" VARCHAR,
"dryrun_runoff_y_n" VARCHAR,
"wetrun_runoff_y_n" VARCHAR,
"apprain_dryrun_mm" BIGINT,
"apprain_wetrun_mm" BIGINT,
"slope_percent" DOUBLE,
"rand_rgh_mm" BIGINT,
"soil_moisture_gperg" DOUBLE,
"bullhog_litter_depthcm" DOUBLE,
"folcvr_shrub" DOUBLE,
"folcvr_grass" DOUBLE,
"folcvr_forb" DOUBLE,
"folcvr_standing_dead" DOUBLE,
"folcvr_woody_dead" BIGINT,
"folcvr_litter" DOUBLE,
"folcvr_small_tree" DOUBLE,
"folcvr_bullhog_litter" DOUBLE,
"grd_shrub" DOUBLE,
"grd_grass" DOUBLE,
"grd_forb" DOUBLE,
"grd_moss" DOUBLE,
"grd_dung" DOUBLE,
"grd_standing_dead" DOUBLE,
"grd_woody_dead" DOUBLE,
"grd_litter" DOUBLE,
"grd_ash" DOUBLE,
"grd_bullhog_litter" DOUBLE,
"grd_bare_soil" DOUBLE,
"grd_rock" DOUBLE,
"percangap20_24" DOUBLE,
"percangap25_50" DOUBLE,
"percangap51_100" DOUBLE,
"percangap101_150" DOUBLE,
"percangap151_200" DOUBLE,
"percangap201_250" DOUBLE,
"percangap251_300" DOUBLE,
"percangap301_350" DOUBLE,
"percangap351_400" DOUBLE,
"percangap401_450" DOUBLE,
"percangap451_500" DOUBLE,
"percangap501_550" DOUBLE,
"percangap551_600" DOUBLE,
"perbasgap20_24" DOUBLE,
"perbasgap25_50" DOUBLE,
"perbasgap51_100" DOUBLE,
"perbasgap101_150" DOUBLE,
"perbasgap151_200" DOUBLE,
"perbasgap201_250" DOUBLE,
"perbasgap251_300" DOUBLE,
"perbasgap301_350" DOUBLE,
"perbasgap351_400" DOUBLE,
"perbasgap401_450" DOUBLE,
"perbasgap451_500" DOUBLE,
"perbasgap501_550" DOUBLE,
"perbasgap551_600" DOUBLE,
"avgcangap_cm" BIGINT,
"avgbasgap_cm" BIGINT,
"maxcangap_cm" BIGINT,
"maxbasgap_cm" BIGINT,
"utm_zone" VARCHAR,
"plot_id" VARCHAR
);CREATE TABLE large_time_series (
"field_plot_num" BIGINT,
"site" VARCHAR,
"year" BIGINT,
"microsite" VARCHAR,
"treatment_area" VARCHAR,
"cut_tree_y_n" VARCHAR,
"treated_y_n" VARCHAR,
"treatment_date" VARCHAR,
"run_type" VARCHAR,
"runoff_y_n" VARCHAR,
"rainrate_mm_hr" BIGINT,
"runoff_start_mm_ss" VARCHAR,
"plot_time_mm_ss" VARCHAR,
"fill_time_sec" BIGINT,
"runoff_l_min" DOUBLE,
"sedconc_g_l" DOUBLE,
"runoff_mm_hr" DOUBLE,
"seddisch_g_s" DOUBLE,
"plot_id" VARCHAR
);CREATE TABLE rill_plots (
"field_plot_num" BIGINT,
"site" VARCHAR,
"utmnrth_nad83" DOUBLE,
"utmeast_nad83" DOUBLE,
"year" BIGINT,
"microsite" VARCHAR,
"treated_y_n" VARCHAR,
"treatment_area" VARCHAR,
"treatment_date" VARCHAR,
"bordered_y_n" VARCHAR,
"cut_tree_y_n" VARCHAR,
"largeplotro_dryrun_y_n" VARCHAR,
"largeplotro_wetrun_y_n" VARCHAR,
"runoff_y_n_15lmin" VARCHAR,
"runoff_y_n_30lmin" VARCHAR,
"runoff_y_n_45lmin" VARCHAR,
"slope_percent" DOUBLE,
"rand_rgh_mm" BIGINT,
"soil_moisture_gperg" DOUBLE,
"bullhog_litter_depthcm" DOUBLE,
"numrills_15lmin_1m" BIGINT,
"numrills_30lmin_1m" BIGINT,
"numrills_45lmin_1m" BIGINT,
"numrills_15lmin_2m" BIGINT,
"numrills_30lmin_2m" BIGINT,
"numrills_45lmin_2m" BIGINT,
"numrills_15lmin_3m" BIGINT,
"numrills_30lmin_3m" BIGINT,
"numrills_45lmin_3m" BIGINT,
"traw15lmin_1m_cm" BIGINT,
"traw15lmin_2m_cm" BIGINT,
"traw15lmin_3m_cm" BIGINT,
"traw30lmin_1m_cm" BIGINT,
"traw30lmin_2m_cm" BIGINT,
"traw30lmin_3m_cm" BIGINT,
"traw45lmin_1m_cm" BIGINT,
"traw45lmin_2m_cm" BIGINT,
"traw45lmin_3m_cm" BIGINT,
"avgwidth15lmin_1m_cm" BIGINT,
"avgwidth30lmin_1m_cm" BIGINT,
"avgwidth45lmin_1m_cm" BIGINT,
"avgwidth15lmin_2m_cm" BIGINT,
"avgwidth30lmin_2m_cm" BIGINT,
"avgwidth45lmin_2m_cm" BIGINT,
"avgwidth15lmin_3m_cm" BIGINT,
"avgwidth30lmin_3m_cm" BIGINT,
"avgwidth45lmin_3m_cm" BIGINT,
"avgdepth15lmin_1m_cm" DOUBLE,
"avgdepth30lmin_1m_cm" DOUBLE,
"avgdepth45lmin_1m_cm" DOUBLE,
"avgdepth15lmin_2m_cm" DOUBLE,
"avgdepth30lmin_2m_cm" DOUBLE,
"avgdepth45lmin_2m_cm" DOUBLE,
"avgdepth15lmin_3m_cm" DOUBLE,
"avgdepth30lmin_3m_cm" DOUBLE,
"avgdepth45lmin_3m_cm" DOUBLE,
"avgvel_15lmin_ms" DOUBLE,
"avgvel_30lmin_ms" DOUBLE,
"avgvel_45lmin_ms" DOUBLE,
"folcvr_shrub" DOUBLE,
"folcvr_grass" DOUBLE,
"folcvr_forb" DOUBLE,
"folcvr_standing_dead" DOUBLE,
"folcvr_woody_dead" DOUBLE,
"folcvr_litter" DOUBLE,
"folcvr_small_tree" DOUBLE,
"folcvr_bullhog_litter" DOUBLE,
"grd_shrub" DOUBLE,
"grd_grass" DOUBLE,
"grd_forb" DOUBLE,
"grd_moss" DOUBLE,
"grd_dung" DOUBLE,
"grd_standing_dead" DOUBLE,
"grd_woody_dead" DOUBLE,
"grd_small_tree" DOUBLE,
"grd_litter" DOUBLE,
"grd_ash" DOUBLE,
"grd_bullhog_litter" DOUBLE,
"grd_bare_soil" DOUBLE,
"grd_rock" DOUBLE,
"percangap20_24" DOUBLE,
"percangap25_50" DOUBLE,
"percangap51_100" DOUBLE,
"percangap101_150" DOUBLE,
"percangap151_200" DOUBLE,
"percangap201_250" DOUBLE,
"percangap251_300" DOUBLE,
"percangap301_350" DOUBLE,
"percangap351_400" DOUBLE,
"perbasgap20_24" DOUBLE,
"perbasgap25_50" DOUBLE,
"perbasgap51_100" DOUBLE,
"perbasgap101_150" DOUBLE,
"perbasgap151_200" DOUBLE,
"perbasgap201_250" DOUBLE,
"perbasgap251_300" DOUBLE,
"perbasgap301_350" DOUBLE,
"perbasgap351_400" DOUBLE,
"avgcangap_cm" BIGINT,
"avgbasgap_cm" BIGINT
);CREATE TABLE rill_time_series (
"treatment_date" VARCHAR,
"field_plot_num" BIGINT,
"site" VARCHAR,
"year" BIGINT,
"microsite" VARCHAR,
"treated_y_n" VARCHAR,
"treatment_area" VARCHAR,
"bordered_y_n" VARCHAR,
"cut_tree_y_n" VARCHAR,
"largeplotro_dryrun_y_n" VARCHAR,
"largeplotro_wetrun_y_n" VARCHAR,
"runoff_y_n_15lmin" VARCHAR,
"runoff_y_n_30lmin" VARCHAR,
"runoff_y_n_45lmin" VARCHAR,
"rate_lmin" BIGINT,
"plot_time_mm_ss" VARCHAR,
"fill_time_sec" BIGINT,
"runoff_l_min" DOUBLE,
"sedconc_g_l" DOUBLE,
"plot_id" VARCHAR
);CREATE TABLE sagestep_database_data_dictionary (
"file_name" VARCHAR,
"table_name" VARCHAR,
"variable" VARCHAR,
"description" VARCHAR,
"unit" VARCHAR,
"data_type" VARCHAR,
"character_length" BIGINT,
"acceptable_values" VARCHAR,
"missing_data_value" BIGINT,
"not_applicable_value" VARCHAR,
"unnamed_10" VARCHAR -- Unnamed: 10
);CREATE TABLE small_plots (
"field_plot_num" BIGINT,
"site" VARCHAR,
"year" BIGINT,
"treated_y_n" VARCHAR,
"treatment_date" VARCHAR,
"treatment_area" VARCHAR,
"bullhog_subtreatment" VARCHAR,
"microsite" VARCHAR,
"utmnrth_nad83" DOUBLE,
"utmeast_nad83" DOUBLE,
"dryrun_runoff_y_n" VARCHAR,
"wetrun_runoff_y_n" VARCHAR,
"apprain_dryrun_mm" VARCHAR,
"apprain_wetrun_mm" VARCHAR,
"slope_percent" DOUBLE,
"rand_rgh_mm" DOUBLE,
"soil_moisture_gperg" DOUBLE,
"lit_depth_cm" DOUBLE,
"bullhog_lit_depth_cm" DOUBLE,
"soil_stability" BIGINT,
"folcvr_shrub" DOUBLE,
"folcvr_grass" DOUBLE,
"folcvr_forb" DOUBLE,
"folcvr_standing_dead" DOUBLE,
"folcvr_woody_dead" DOUBLE,
"folcvr_litter" DOUBLE,
"folcvr_small_tree" DOUBLE,
"grd_shrub" DOUBLE,
"grd_grass" DOUBLE,
"grd_forb" DOUBLE,
"grd_moss" DOUBLE,
"grd_dung" DOUBLE,
"grd_standing_dead" DOUBLE,
"grd_woody_dead" DOUBLE,
"grd_litter" DOUBLE,
"grd_bare_soil" DOUBLE,
"grd_rock" DOUBLE,
"grd_bullhog_litter" DOUBLE,
"grd_ash" DOUBLE,
"mwdpt0cm_s" BIGINT,
"mwdpt1cm_s" BIGINT,
"mwdpt2cm_s" BIGINT,
"mwdpt3cm_s" BIGINT,
"mwdpt4cm_s" BIGINT,
"mwdpt5cm_s" BIGINT,
"utm_zone" VARCHAR,
"plot_id" VARCHAR
);CREATE TABLE small_time_series (
"field_plot_num" BIGINT,
"site" VARCHAR,
"year" BIGINT,
"microsite" VARCHAR,
"treatment_area" VARCHAR,
"bullhog_subtreatment" VARCHAR,
"treated_y_n" VARCHAR,
"treatment_date" VARCHAR,
"run_type" VARCHAR,
"runoff_y_n" VARCHAR,
"rainrate_mm_hr" BIGINT,
"runoff_start_mm_ss" VARCHAR,
"plot_time_mm_ss" VARCHAR,
"fill_time_sec" BIGINT,
"runoff_l_min" DOUBLE,
"sedconc_g_l" DOUBLE,
"runoff_mm_hr" DOUBLE,
"seddisch_g_s" DOUBLE,
"plot_id" VARCHAR
);CREATE TABLE soils (
"microsite" VARCHAR,
"site" VARCHAR,
"per_sand" DOUBLE,
"per_silt" DOUBLE,
"per_clay" DOUBLE,
"bulk_density_gcm3" DOUBLE
);Anyone who has the link will be able to view this.