Paleo-Dendrochronological "Tree-Ring" Hyrdoclimatic Reconstructions For Northern And Southern California River Basins by US Government | Environmental and Climate Sciences

About this Dataset

Paleo-Dendrochronological "Tree-Ring" Hyrdoclimatic Reconstructions For Northern And Southern California River Basins

Background

Tree-ring chronologies allow assessment of hydrologic variability over centuries to millennia, gives historic context for assessing recent droughts, and can be used in climate change research. Tree-ring based reconstructions of annual streamflow and precipitation provide a way to evaluate the observed record of streamflow and precipitation in the context of past centuries and reveal cyclic behavior that may not be detectable in the shorter observed records.

In all reconstructions, longer droughts (consecutive years below the observed record average) have occurred over the past centuries, in some cases double the length of the longest period drought in the observed record. In southern California, a number of the reconstructions indicate that the 2012-2016 drought was the worst 5-year drought in the past six centuries.

Northern California Tree Ring Study

For this study, 16 new tree-ring reconstructions of streamflow and precipitation for use in water-resources planning and operation are provided for the Klamath Basin and Sacramento and San Joaquin Basins. Analysis of droughts in the reconstructions for the three basins indicates the 1920s-30s and 1990s contained periods of drought notably severe in the long-term (centuries to millennia) context. However, the observed record does not contain the driest multi-decadal (50-yr) periods, and in the case of Klamath and San Joaquin, does not include the longest run of drought years.

Southern California Tree Ring Study

For this project, six southern California records were reconstructed: four for total water year precipitation (Ojai, Lake Arrowhead, San Gabriel Dam, and Cuyamaca) and two for water year streamflow (Arroyo Seco and Santa Ana River), along with a reconstruction of Kern River streamflow in the southern Sierra Nevada. In addition, a reconstruction for Colorado River flow at Lees Ferry was updated. One of the most notable findings in this assessment is that, over the 20th and 21st centuries, southern California precipitation and streamflow, along with Kern River streamflow, have been more variable with correspondingly less year-to-year persistence, than over the past six centuries.
Organization: State of California
Last updated: 2023-09-15T13:49:10.851187
Tags: american-river, california-department-of-water-resources, climate, climate-change, colorado-river, flow, hydrologic, kern-river, klamath-river, paleo, precipitation, river, sacramento-river, san-gabriel, san-joaquin-river

Tables

Southern California Nested Reconstructions

@usgov.ca_gov_paleo_dendrochronological_tree_ring_hyrdoclimat_84f322a8.southern_california_nested_reconstructions

153.89 KB
901 rows
25 columns


CREATE TABLE southern_california_nested_reconstructions (
  "year" BIGINT,
  "arroyo_seco_reconstruction_flow_taf" DOUBLE,
  "arroyo_seco_lower_50percent_flow_taf" DOUBLE,
  "arroyo_seco_flow_upper_50percent_flow_taf" DOUBLE,
  "sangab_reconstruction_precip_inches" DOUBLE,
  "sangab_flow_lower_50percent_precip_inches" DOUBLE,
  "sangab_flow_upper_50percent_precip_inches" DOUBLE,
  "santaana_reconstruction_flow_taf" DOUBLE,
  "santaana_lower_50percent_flow_taf" DOUBLE,
  "santaana_upper_50percent_flow_taf" DOUBLE,
  "lakearrow_reconstruction_precip_inches" DOUBLE,
  "lakearrow_lower_50percent_precip_inches" DOUBLE,
  "lakearrow_upper_50percent_precip_inches" DOUBLE,
  "ojai_reconstruction_precip_inches" DOUBLE,
  "ojai_lower_50percent_precip_inches" DOUBLE,
  "ojai_upper_50percent_precip_inches" DOUBLE,
  "cuyam_reconstruction_precip_inches" DOUBLE,
  "cuyam_lower_50percent_precip_inches" DOUBLE,
  "cuyam_upper_50percent_precip_inches" DOUBLE,
  "kern_reconstruction_flow_taf" DOUBLE,
  "kern_lower_50percent_flow_taf" DOUBLE,
  "kern_upper_50percent_flow_taf" DOUBLE,
  "colo_reconstruction_flow_taf" DOUBLE,
  "colo_lower_50percent_confidence_flow_taf" DOUBLE,
  "colo_upper_50percent_confidence_flow_taf" DOUBLE
);

Northern California Nested Reconstructions

@usgov.ca_gov_paleo_dendrochronological_tree_ring_hyrdoclimat_84f322a8.northern_california_nested_reconstructions

315.76 KB
1113 rows
49 columns


CREATE TABLE northern_california_nested_reconstructions (
  "year" BIGINT,
  "klk_reconstruction_flow_af" BIGINT,
  "klk_lower_50_percent_flow_af" BIGINT,
  "klk_upper_50_percent_flow_af" BIGINT,
  "trn_reconstruction_flow_af" BIGINT,
  "trn_lower_50_percent_flow_af" BIGINT,
  "trn_upper_50_percent_flow_af" BIGINT,
  "kfl_reconstruction_precip_inches" DOUBLE,
  "kfl_lower_50_percent_precip_inches" DOUBLE,
  "kfl_upper_50_percent_precip_inches" DOUBLE,
  "kfs_reconstruction_precip_inches" DOUBLE,
  "kfs_lower_50_percent_precip_inches" DOUBLE,
  "kfs_upper_50_percent_precip_inches" DOUBLE,
  "wea_reconstruction_precip_inches" DOUBLE,
  "wea_lower_50_percent_precip_inches" DOUBLE,
  "wea_upper_50_percent_precip_inches" DOUBLE,
  "yrk_reconstruction_precip_inches" DOUBLE,
  "yrk_lower_50_percent_precip_inches" DOUBLE,
  "yrk_upper_50_percent_precip_inches" DOUBLE,
  "fto_reconstruction_flow_af" BIGINT,
  "fto_lower_50_percent_flow_af" BIGINT,
  "fto_upper_50_percent_flow_af" BIGINT,
  "yrs_reconstruction_flow_af" BIGINT,
  "yrs_lower_50_percent_flow_af" BIGINT,
  "yrs_upper_50_percent_flow_af" BIGINT,
  "amf_reconstruction_flow_af" BIGINT,
  "amf_lower_50_percent_flow_af" DOUBLE,
  "amf_upper_50_percent_flow_af" BIGINT,
  "sbb_reconstruction_flow_af" BIGINT,
  "sbb_lower_50_percent_flow_af" BIGINT,
  "sbb_upper_50_percent_flow_af" BIGINT,
  "sac4_reconstruction_flow_af" BIGINT,
  "sac4_lower_50_percent_flow_af" BIGINT,
  "sac4_upper_50_percent_flow_af" BIGINT,
  "sns_reconstruction_flow_af" BIGINT,
  "sns_lower_50_percent_flow_af" BIGINT,
  "sns_upper_50_percent_flow_af" BIGINT,
  "tlg_reconstruction_flow_af" BIGINT,
  "tlg_lower_50_percent_flow_af" BIGINT,
  "tlg_upper_50_percent_flow_af" BIGINT,
  "mrc_reconstruction_flow_af" BIGINT,
  "mrc_lower_50_percent_flow_af" BIGINT,
  "mrc_upper_50_percent_flow_af" BIGINT,
  "sjf_reconstruction_flow_af" BIGINT,
  "sjf_lower_50_percent_flow_af" BIGINT,
  "sjf_upper_50_percent_flow_af" BIGINT,
  "sjq4_reconstruction_flow_af" BIGINT,
  "sjq4_lower_50_percent_flow_af" BIGINT,
  "sjq4_upper_50_percent_flow_af" BIGINT
);