Alaska thermokarst monitoring and permafrost soils database 2023

This database contains data on site, soil stratigraphy, soil physical and chemical properties, Carbon-14 (C14) and stable isotope, and vegetation composition and structure acquired from permafrost soil surveys and thermokarst monitoring sites. The data are from projects that we have conducted, as well as data compiled from numerous other project and reports, that have emphasized the study of the intermediate layer of upper permafrost and the dynamic responses of permafrost to environmental conditions. This 2023 update includes data from our recent National Science Foundation (NSF)-funded project on the upper permafrost. The Access Database has 11 main data tables (tbl_) for site (environmental), soil stratigraphy, soil physical data, soil chemical data, water Oxygen-18 (O18), soil radiocarbon dates, vegetation cover, vegetation structure, study areas, personnel, and project data sources. The Site data includes information of location, observers, geomorphology, topography, hydrology, soil summary characteristics, pH and electrical conductivity (EC), soil classification, and vegetation cover by species. Soil stratigraphy has information on soil texture and ground ice. Soil physical and chemical data includes lab data on bulk density, moisture, carbon, and nitrogen. The database has 40 reference tables (REF_) that have codes and descriptions for variables used in site, soil stratigraphy, and vegetation cover tables. Query tables (qry_) are used to link data tables and reference tables to display data with names instead of codes. In addition to the permafrost soils information, the Site data includes topographic survey control information for repeat monitoring of thermokarst study areas. The data and metadata are provided in three formats. The Access relational database has all the data and reference tables, as well as the metadata associated with each table. Two Excel workbooks are provided that separately contain all the data tables and reference tables. Finally, 52 csv files are provided that contain the information on each individual data and reference table, as well as a metadata file that serially lists information on all the fields for all the tables.