Similarity data set used to test Synchronous Growth Changes (SGC) on dendrochronological data using tree-ring series from the ITRDB

Dataset used to test the SGC, SSGC and AGC in:

Visser, RM. 2021 On the similarity of tree-ring patterns: Assessing the influence of semi-synchronous growth changes on the Gleichläufigkeitskoeffizient for big tree-ring data sets. Archaeometry 63(1): 204–215. DOI: https://doi.org/10.1111/arcm.12600.

The dataset contains the database used in this study

itrdb_structure.sql described the structure of the database (PostgreSQL/PostGIS)

Tables

GC_??_tbl are tables with ?? denoting the continent (see below) containg the comparisons between tree-ring series and the growth changes

The following columns are present:

ID1 and ID2: These are the ID's of the series compared.

SGC: Synchronous Growth Changes

SSGC: Semi Synchronous Growth Changes

Overlap: the number of tree-rings compared

Data files with values in each table. The continents are as defined in the ITRDB (https://www.ncei.noaa.gov/access/paleo-search/?dataTypeId=18) 

GC_af_tbl_202005 (Africa)

GC_as_tbl_202005 (Asia)

GC_au_tbl_202005 (Australia)

GC_ca_tbl_202005 (Canada)

GC_eu_tbl_202005 (Europe)

GC_mx_tbl_202005 (Mexico)

GC_sa_tbl_202005 (South America)

GC_us_tbl_202005 (North America)

headers:

The following columns are present:

continent: two letter code of the continent (ITRDB)

filename: orginal filename as deposited in the ITRDB

line_nr: line number of the header

header_text: text of the header related to the line number

Datafile: headers_201905222007.csv

names:

The following columns are present:

filename: orginal filename as deposited in the ITRDB

name_orig: orginal name of the tree-ring series as deposited in the ITRDB

name_new: the IDs of the tree-ring series were replaced with a two‐letter code for the continent (AF, AS, AU, CA, EU, SA, US) and a sequence code to prevent duplicate IDs. These are used as ID1 and ID2 in  the tables GC_??_tbl

Datafile: names_201905240643.csv

file: geo_location_201906250635.csv

Contains the locations related to each site in the database

The following columns:

filename: orginal filename as deposited in the ITRDB

continent: two letter code of the continent (ITRDB)

lat: latitude

long: longitude

geom_point: WGS84 coordinates expressed as well-known text (WKT)

For the related code, see also: 

Ronald Visser. (2022). Code and data related to semi-synchronous growth changes and the similarity of tree-ring patterns (v1.0) [Data set]. Zenodo. https://doi.org/10.5281/zenodo.7157738

Or: https://github.com/RonaldVisser/SGC