About this Dataset

Data And Code From: Extending Irrigation Reservoir Histories For Improved Groundwater Modeling And Conjunctive Water Management In Two Arkansas Critical Groundwater Areas

This dataset contains all data and code required to reproduce the time-to-event analysis in the associated manuscript. More detail is found in the associated README.md file.

Contents of repository

Yaeger_ReservoirDataset_Oct2022.csv: comma-separated data file with reservoir characteristics, construction times, and water table depths and percent saturation at 5-year intervals from 1975-2015.
CGA_reservoir_analysis.Rmd: RMarkdown notebook with all code required to reproduce the time-to-event analysis in the manuscript and generate the associated plots.
CGA_reservoir_analysis.html: HTML file rendered from the .Rmd notebook.
README.md: additional details, including column descriptions from the CSV file.

Software versions used

R version 4.1.2 (https://cran.r-project.org/bin/windows/base/old/4.1.2)

R packages:

data.table v1.14.8 (https://rdatatable.gitlab.io/data.table/)
ggplot2 v3.4.4 (https://ggplot2.tidyverse.org/)
sf v1.0-14 (https://r-spatial.github.io/sf/)
survival v3.5-5 (https://cran.r-project.org/package=survival)
icenReg v2.0.15 (https://cran.r-project.org/package=icenReg)
Organization: Department of Agriculture
Last updated: 2024-03-30T11:07:18.484302
Tags: aquifer, arkansas, cache-river-cga, critical-groundwater-area-cga, grand-prairie-cga, groundwater, hydrology, mississippi-river-valley, mississippi-river-valley-alluvial-aquifer, reservoir

Tables

Yaeger ReservoirDataset Oct2022

@usgov.usda_gov_data_and_code_from_extending_irrigation_reser_4093785b.yaeger_reservoirdataset_oct2022

204.44 kB
775 rows
37 columns

CREATE TABLE yaeger_reservoirdataset_oct2022 (
  "oid" BIGINT,
  "cga" VARCHAR,
  "type" VARCHAR,
  "county" VARCHAR,
  "area_ha" DOUBLE,
  "area_ac" DOUBLE,
  "timespan" VARCHAR,
  "prior_lulc" VARCHAR,
  "locationid" BIGINT,
  "x" DOUBLE,
  "y" DOUBLE,
  "dtw_y2020" DOUBLE,
  "dtw_y2015" DOUBLE,
  "dtw_y2010" DOUBLE,
  "dtw_y2005" DOUBLE,
  "dtw_y2000" DOUBLE,
  "dtw_y1995" DOUBLE,
  "dtw_y1990" DOUBLE,
  "dtw_y1985" DOUBLE,
  "dtw_y1980" DOUBLE,
  "dtw_y1975" DOUBLE,
  "dtw_y1970" DOUBLE,
  "mrva_botalt_mslft" DOUBLE,
  "mrva_topalt_mslft" DOUBLE,
  "mrva_thickness_ft" DOUBLE,
  "landsurface_elv_mslft" DOUBLE,
  "pctsat1970" DOUBLE,
  "pctsat1975" DOUBLE,
  "pctsat1980" DOUBLE,
  "pctsat1985" DOUBLE,
  "pctsat1990" DOUBLE,
  "pctsat1995" DOUBLE,
  "pctsat2000" DOUBLE,
  "pctsat2005" DOUBLE,
  "pctsat2010" DOUBLE,
  "pctsat2015" DOUBLE,
  "pctsat2020" DOUBLE
);