Spreadsheet for lysimeter data analysis, Bushland, Texas
공공데이터포털
,A spreadsheet was designed for weighing lysimeter raw relative water storage data analysis and reduction to values of evapotranspiration (ET), dew and frost accumulation, precipitation, irrigation, and drainage tank emptying. A new version of the spreadsheet uploaded in April 2025 includes more facilities for visualization, error checking, and validation of ET values. Algorithms in the spreadsheet automatically identify precipitation, and dew and frost accumulations in the 5-minute data, and places flags appropriately (“P” or “DW”) in a column that is referenced by formulae that separately calculate values for these. Noise can, however, cause false identification of precipitation or frost and dew accumulations, so another column is made available in which the user can enter flags to either nullify (“NO”) false automatic identification, or conversely, identify precipitation or dew and frost accumulations (“P” or “DW”) not automatically identified. This column also serves for entry of flags identifying irrigation, drainage tank emptying, counterweight adjustments, etc. Algorithms in other columns act upon these flags to correct the original raw relative storage values so that the adjusted relative storage reflects only evapotranspiration, while simultaneously computing 5-min values for precipitation, irrigation, dew and frost accumulation, and drainage tank emptying.,
Evapotranspiration, Irrigation, Dew/frost - Water Balance Data for The Bushland, Texas Winter Wheat Datasets
공공데이터포털
,This dataset contains water balance data for each year when winter wheat was grown at the USDA-ARS Conservation and Production Laboratory (CPRL), Soil and Water Management Research Unit (SWMRU) research weather station, Bushland, Texas (Lat. 35.186714°, Long. -102.094189°, elevation 1170 m above MSL). Winter wheat was grown on two large, precision weighing lysimeters, each in the center of a 4.44 ha square field in the 1989-1990, 1991-1992, and 1992-1993 seasons. Irrigation was by linear move sprinkler system. Full irrigations were managed to replenish soil water used by the crop on a weekly or more frequent basis as determined by soil profile water content readings made with a neutron probe to 2.4-m depth in the field. Deficit irrigations were less than full - see crop calendars and irrigation data in these files for details. The weighing lysimeters were used to measure relative soil water storage to 0.05 mm accuracy at 5-minute intervals, and the 5-minute change in soil water storage was used along with precipitation and irrigation amounts to calculate crop evapotranspiration (ET), which is reported at 15-minute intervals. Because the large (3 m by 3 m surface area) weighing lysimeters are better rain gages than are tipping bucket gages, the 15-minute precipitation data are derived for each lysimeter from changes in lysimeter mass. The land slope is <0.3% and flat. The water balance data consist of 15-minute and daily amounts of evapotranspiration (ET), dew/frost fall, precipitation (rain/snow), irrigation, scale counterweight adjustment, and emptying of drainage tanks, all in mm. The values are the result of a rigorous quality control process involving algorithms for detecting dew/frost accumulations, and precipitation (rain and snow). Changes in lysimeter mass due to emptying of drainage tanks, counterweight adjustment, maintenance activity, and harvest are accounted for such that ET values are minimally affected. The ET data should be considered to be the best values offered in these datasets. Even though ET data are also presented in the "lysimeter" datasets, the values herein are the result of a more rigorous quality control process. Dew and frost accumulation varies from year to year and seasonally within a year, and it is affected by lysimeter surface condition [bare soil, tillage condition, residue amount and orientation (flat or standing), etc.]. Particularly during winter and depending on humidity and cloud cover, dew and frost accumulation sometimes accounts for an appreciable percentage of total daily ET. These datasets originate from research aimed at determining crop water use (ET), crop coefficients for use in ET-based irrigation scheduling based on a reference ET, crop growth, yield, harvest index, and crop water productivity as affected by irrigation method, timing, amount (full or some degree of deficit), agronomic practices, cultivar, and weather. Prior publications have focused on winter wheat ET, crop coefficients, and crop water productivity. Crop coefficients have been used by ET networks. The data have utility for testing simulation models of crop ET, growth, and yield.,,
Evapotranspiration, Irrigation, Dew/frost - Water Balance Data for The Bushland, Texas Alfalfa Datasets
공공데이터포털
,This dataset contains water balance data for each year when alfalfa was grown at the USDA-ARS Conservation and Production Laboratory (CPRL), Soil and Water Management Research Unit (SWMRU) research weather station, Bushland, Texas (Lat. 35.186714°, Long. -102.094189°, elevation 1170 m above MSL). Alfalfa was grown on two large, precision weighing lysimeters, each in the center of a 4.44 ha square field in 1996 through 1999. Irrigation was by linear move sprinkler system. Irrigations were managed to replenish soil water used by the crop on a weekly or more frequent basis as determined by soil profile water content readings made with a neutron probe to 2.4-m depth in the field. The weighing lysimeters were used to measure relative soil water storage to 0.05 mm accuracy at 5-minute intervals, and the 5-minute change in soil water storage was used along with precipitation and irrigation amounts to calculate crop evapotranspiration (ET), which is reported at 15-minute intervals. Because the large (3 m by 3 m surface area) weighing lysimeters are better rain gages than are tipping bucket gages, the 15-minute precipitation data are derived for each lysimeter from changes in lysimeter mass. The land slope is <0.3% and flat. The water balance data consist of 15-minute and daily amounts of evapotranspiration (ET), dew/frost fall, precipitation (rain/snow), irrigation, scale counterweight adjustment, and emptying of drainage tanks, all in mm. The values are the result of a rigorous quality control process involving algorithms for detecting dew/frost accumulations, and precipitation (rain and snow). Changes in lysimeter mass due to emptying of drainage tanks, counterweight adjustment, maintenance activity, and harvest are accounted for such that ET values are minimally affected. The ET data should be considered to be the best values offered in these datasets. Even though ET data are also presented in the "lysimeter" datasets, the values herein are the result of a more rigorous quality control process. Dew and frost accumulation varies from year to year and seasonally within a year, and it is affected by lysimeter surface condition [bare soil, tillage condition, residue amount and orientation (flat or standing), etc.]. Particularly during winter and depending on humidity and cloud cover, dew and frost accumulation sometimes accounts for an appreciable percentage of total daily ET. These datasets originate from research aimed at determining crop water use (ET), reference "tall crop" ET, crop coefficients for use in ET-based irrigation scheduling based on a reference ET, crop growth, yield, harvest index, and crop water productivity as affected by irrigation method, timing, amount (full or some degree of deficit), agronomic practices, cultivar, and weather. Prior publications have focused on alfalfa ET, crop coefficients, crop water productivity reference "tall crop" ET, alternative methods of estimating reference ET from weather data. Crop coefficients have been used by ET networks. The data have utility for testing simulation models of crop ET, growth, and yield.,,
Evapotranspiration, Irrigation, Dew/frost - Water Balance Data for The Bushland, Texas Soybean Datasets
공공데이터포털
,This dataset contains water balance data for each year when soybean [Glycine max (L.) Merr.] was grown at the USDA-ARS Conservation and Production Laboratory (CPRL), Soil and Water Management Research Unit (SWMRU), Bushland, Texas (Lat. 35.186714°, Long. -102.094189°, elevation 1170 m above MSL). Soybean [Glycine max (L.) Merr.] was grown on two large, precision weighing lysimeters, each in the center of a 4.44 ha square field in 1995, 2003, 2004 and 2010. Soybean was grown on four large, precision weighing lysimeters and their surrounding 4.4-ha fields in 2019. Irrigation in 1995, 2003, 2004, and 2010 was by linear move sprinkler system. Irrigation in 2019 was by subsurface drip irrigation (SDI) system on the northeast (NE) and southeast (SE) weighing lysimeters an fields, while irrigation was by linear move sprinkler system on the northwest (NW) and southwest (SW) lysimeters and fields. Full irrigations were managed to replenish soil water used by the crop on a weekly or more frequent basis as determined by soil profile water content readings made with a neutron probe to 2.4-m depth in the field. Deficit irrigations were less than full - see crop calendars and irrigation data in these files for details. The weighing lysimeters were used to measure relative soil water storage to 0.05 mm accuracy at 5-minute intervals, and the 5-minute change in soil water storage was used along with precipitation and irrigation amounts to calculate crop evapotranspiration (ET), which is reported at 15-minute intervals. Because the large (3 m by 3 m surface area) weighing lysimeters are better rain gages than are tipping bucket gages, the 15-minute precipitation data are derived for each lysimeter from changes in lysimeter mass. The land slope is <0.3% and flat. The water balance data consist of 15-minute and daily amounts of evapotranspiration (ET), dew/frost fall, precipitation (rain/snow), irrigation, scale counterweight adjustment, and emptying of drainage tanks, all in mm. The values are the result of a rigorous quality control process involving algorithms for detecting dew/frost accumulations, and precipitation (rain and snow). Changes in lysimeter mass due to emptying of drainage tanks, counterweight adjustment, maintenance activity, and harvest are accounted for such that ET values are minimally affected. The ET data should be considered to be the best values offered in these datasets. Even though ET data are also presented in the "lysimeter" datasets, the values herein are the result of a more rigorous quality control process. Dew and frost accumulation varies from year to year and seasonally within a year, and it is affected by lysimeter surface condition [bare soil, tillage condition, residue amount and orientation (flat or standing), etc.]. Particularly during winter and depending on humidity and cloud cover, dew and frost accumulation sometimes accounts for an appreciable percentage of total daily ET. These datasets originate from research aimed at determining crop water use (ET), crop coefficients for use in ET-based irrigation scheduling based on a reference ET, crop growth, yield, harvest index, and crop water productivity as affected by irrigation method, timing, amount (full or some degree of deficit), agronomic practices, cultivar, and weather. Prior publications have focused on crop ET, crop coefficients, and crop water productivity. Crop coefficients have been used by ET networks. The data have utility for testing simulation models of crop ET, growth, and yield.,See the README for descriptions of each data file.,,
Evapotranspiration, Irrigation, Dew/frost - Water Balance Data for The Bushland, Texas Maize for Grain Datasets
공공데이터포털
,This dataset contains water balance data for each growing season (year) when maize (Zea mays, L., also known as corn in the United States) was grown for grain at the USDA-ARS Conservation and Production Laboratory (CPRL), Soil and Water Management Research Unit (SWMRU) research weather station, Bushland, Texas (Lat. 35.186714°, Long. -102.094189°, elevation 1170 m above MSL). Maize was grown for grain on two large, precision weighing lysimeters, each in the center of a 4.44 ha square field. Irrigation was by linear move sprinkler system in 1989, 1990, and 1994. In 2013, 2016, and 2018, maize was grown on four lysimeters; two lysimeters and their respective fields were irrigated using subsurface drip irrigation (SDI), and two lysimeters and their respective fields were irrigated by a linear move sprinkler system. Irrigations were managed to replenish soil water used by the crop on a weekly or more frequent basis as determined by soil profile water content readings made with a neutron probe to 2.4-m depth in the field. The weighing lysimeters were used to measure relative soil water storage to 0.05 mm accuracy at 5-minute intervals, and the 5-minute change in soil water storage was used along with precipitation and irrigation amounts to calculate crop evapotranspiration (ET), which is reported at 15-minute intervals. Because the large (3 m by 3 m surface area) weighing lysimeters are better rain gages than are tipping bucket gages, the 15-minute precipitation data are derived for each lysimeter from changes in lysimeter mass. The land slope is <1% and flat. The water balance data consist of 15-minute and daily amounts of evapotranspiration (ET), dew/frost fall, precipitation (rain/snow), irrigation, scale counterweight adjustment, and emptying of drainage tanks, all in mm. The values are the result of a rigorous quality control process involving algorithms for detecting dew/frost accumulations, and precipitation (rain and snow). Changes in lysimeter mass due to emptying of drainage tanks, counterweight adjustment, maintenance activity, and harvest are accounted for such that ET values are minimally affected. The ET data should be considered to be the best values offered in these datasets. Even though ET data are also presented in the "lysimeter" datasets, the values herein are the result of a more rigorous quality control process. Dew and frost accumulation varies from year to year and seasonally within a year, and it is affected by lysimeter surface condition [bare soil, tillage condition, residue amount and orientation (flat or standing), etc.]. Particularly during winter and depending on humidity and cloud cover, dew and frost accumulation sometimes accounts for an appreciable percentage of total daily ET. These datasets originate from research aimed at determining crop water use (ET), crop coefficients for use in ET-based irrigation scheduling based on a reference ET, crop growth, yield, harvest index, and crop water productivity as affected by irrigation method, timing, amount (full or some degree of deficit), agronomic practices, cultivar, and weather. Prior publications have focused on maize ET, crop coefficients, and crop water productivity. Crop coefficients have been used by ET networks. The data have utility for testing simulation models of crop ET, growth, and yield and have been used by the Agricultural Model Intercomparison and Improvement Project (AgMIP), by OPENET, and by many others for testing, and calibrating models of ET that use satellite and/or weather data.,Resources in this dataset:,,
Automated Retrieval and Evaluation of Precipitation Data Sources for Environmental Modeling
공공데이터포털
36 years of daily precipitation data from NLDAS, GLDAS, PRISM, NCEI, and DAYMET. This dataset is associated with the following publication: Sitterson, J., S. Sinnathamby, R. Parmar, J. Koblich, K. Wolfe, and C. Knightes. Demonstration of an online web services tool incorporating automatic retrieval and comparison of precipitation data. ENVIRONMENTAL MODELLING & SOFTWARE. Elsevier Science, New York, NY, 123: 104570, (2020).
Muche et al Comparison and Evaluation of Gridded Precipitation Datasets in a Kansas Agricultural Watershed using SWAT
공공데이터포털
The dataset is excel file that contains data for figures in the manuscript. This dataset is associated with the following publication: Muche, M., S. Sinnathamby, R. Parmar, C. Knightes, J. Johnston, K. Wolfe, T. Purucker, M. Cyterski, and D. Smith. Comparison and Evaluation of Gridded Precipitation Datasets in a Kansas Agricultural Watershed Using SWAT. JOURNAL OF THE AMERICAN WATER RESOURCES ASSOCIATION. American Water Resources Association, Middleburg, VA, USA, 56(3): 486-506, (2020).