Vegetation Data From Valles Caldera National Preserve's Cerro Seco Unit 5 Forest Restoration Project, 2016-2022
Department of the Interior
@usgov.doi_gov_vegetation_from_valles_caldera_national_preser_60efe85e
Department of the Interior
@usgov.doi_gov_vegetation_from_valles_caldera_national_preser_60efe85e
Vegetation data files from the Cerro Seco Unit 5 forest restoration project (thinning, prescribed slash burning) during 2016-2022.
Organization: Department of the Interior
Last updated: 2025-07-20T15:57:02.127551
Tags: bryophyta, forest-restoration, hornworts, mosses, non-vascular-land-plants, plant-succession, plantae, plants, prescribed-fire, thinning
CREATE TABLE cerro_seco_veg_data_plant_species_list (
"division" VARCHAR,
"family" VARCHAR,
"species" VARCHAR,
"growth_form" VARCHAR,
"nativity" VARCHAR,
"life_cycle" VARCHAR
);CREATE TABLE cerro_seco_veg_data_vegetation_data (
"year" BIGINT,
"site_status" VARCHAR,
"treatment" VARCHAR,
"site" BIGINT -- Site #,
"transect" BIGINT -- Transect #,
"family" VARCHAR,
"species" VARCHAR,
"n__cover_by_transect" BIGINT -- % Cover (by Transect)
);CREATE TABLE cerro_seco_veg_vegetation_categories_percent_cover_by_site (
"treatment" VARCHAR,
"year" BIGINT,
"site" BIGINT,
"litter" DOUBLE,
"soil" DOUBLE,
"rock" DOUBLE,
"wood" DOUBLE,
"stump" DOUBLE,
"grass_basal" DOUBLE -- Grass (basal),
"sedge_basal" DOUBLE -- Sedge (basal),
"forb_basal" DOUBLE -- Forb (basal),
"sub_shrub_basal" DOUBLE -- Sub-shrub (basal),
"vine_basal" DOUBLE -- Vine (basal),
"fungus_basal" DOUBLE -- Fungus (basal),
"moss_basal" DOUBLE -- Moss (basal),
"lichen_basal" DOUBLE -- Lichen (basal),
"tree_basal" DOUBLE -- Tree (basal),
"total_herbaceous_basal" DOUBLE -- Total Herbaceous (basal),
"total_herbaceous_canopy" DOUBLE -- Total Herbaceous (canopy),
"grass_canopy" DOUBLE -- Grass (canopy),
"sedge_canopy" DOUBLE -- Sedge (canopy),
"forb_canopy" DOUBLE -- Forb (canopy),
"vine_canopy" DOUBLE -- Vine (canopy),
"sub_shrub_canopy" DOUBLE -- Sub-shrub (canopy)
);Anyone who has the link will be able to view this.