Riparian Vegetation Structure And Composition Of Wadeable Streams Monitoring For The Northern Colorado Plateau Network: 2008-2021 – Raw Data
Department of the Interior
@usgov.doi_gov_riparian_vegetation_structure_and_composition__d016f410
Department of the Interior
@usgov.doi_gov_riparian_vegetation_structure_and_composition__d016f410
Because of the scarcity of water on the Colorado Plateau and their disproportionately high use by flora and fauna, riparian areas have been identified as an ecosystem of concern for Northern Colorado Plateau Network (NCPN) parks. Riparian ecosystems are potentially sensitive indicators of landscape-level change because they are linked to both aquatic and upland systems, perform important ecological functions, and are biologically diverse. Riparian systems face a number of anthropogenic threats, including stream-flow damming or diversion, channel-stabilization structures, invasive exotic species, livestock grazing, timber harvesting, agricultural clearing, groundwater pumping, and trail creation. These disturbances can alter watershed conditions and directly or indirectly influence downstream riparian ecosystems.
In the Northern Colorado Plateau Network, riparian monitoring of wadeable streams occurs in the streams of four parks: Courthouse Wash in Arches National Park, Armstrong Canyon in Natural Bridges National Monument, the Fremont River in Capitol Reef National Park, and the East Fork Virgin River in Zion National Park. This data package pertains to the vital sign riparian vegetation structure and composition. The goal for monitoring this vital sign is to determine long-term trends in vegetation dynamics in the context of changes in other ecological drivers, stressors, and processes. Above-ground structures of riparian plants modify the physical environment by shading and depositing litter, strongly affecting spatial and temporal patterns of soil-resource availability to other organisms. The data herein includes vegetation and surface cover, tree seedling counts, diameter and counts of overstory trees, canopy closure, and frequency of exotic species.
Organization: Department of the Interior
Last updated: 2025-09-14T20:33:59.558762
Tags: canopies, climate, diameter-at-breast-height, long-term-monitoring, riparian, trees, vegetation, water-resources
CREATE TABLE canopy_closure_raw_240723 (
"unit_code" VARCHAR,
"stream_name" VARCHAR,
"plot_id" BIGINT,
"start_date" TIMESTAMP,
"visit_year" BIGINT,
"transect" BIGINT,
"point" VARCHAR,
"total1" BIGINT,
"total2" BIGINT,
"total3" BIGINT,
"total4" BIGINT
);CREATE TABLE exotic_frequency_long_240726 (
"unit_code" VARCHAR,
"stream_name" VARCHAR,
"plot_id" BIGINT,
"transect" BIGINT,
"start_date" TIMESTAMP,
"visit_year" BIGINT,
"species" VARCHAR,
"transect_position" VARCHAR,
"status" BIGINT
);CREATE TABLE ncpn_plants_lookup_231205 (
"master_family" VARCHAR,
"master_plant_code" VARCHAR,
"master_species" VARCHAR,
"ut_family" VARCHAR,
"co_family" VARCHAR,
"wy_family" VARCHAR,
"utah_plant_code" VARCHAR,
"utah_species" VARCHAR,
"co_plant_code" VARCHAR,
"co_species" VARCHAR,
"wy_plant_code" VARCHAR,
"wy_species" VARCHAR,
"add_synonyms" VARCHAR,
"taxonomic_notes" VARCHAR,
"master_common_name" VARCHAR,
"arch" VARCHAR,
"blca" VARCHAR,
"brca" VARCHAR,
"cany" VARCHAR,
"care" VARCHAR,
"cebr" VARCHAR,
"colm" VARCHAR,
"cure" VARCHAR,
"dino_ut" VARCHAR -- DINO (UT),
"dino_co" VARCHAR -- DINO (CO),
"fobu" VARCHAR,
"gosp" VARCHAR,
"hove_ut" VARCHAR -- HOVE (UT),
"hove_co" VARCHAR -- HOVE (CO),
"nabr" VARCHAR,
"pisp" VARCHAR,
"tica" VARCHAR,
"zion" VARCHAR,
"lifeform" VARCHAR,
"duration" VARCHAR,
"nativity" VARCHAR,
"trinomial" BIGINT,
"unique_species" BIGINT,
"lu_code" VARCHAR,
"wetland_code" VARCHAR,
"wetland_code_info_source" VARCHAR,
"photosynthetic_pathway" VARCHAR,
"protectedstatusid" BIGINT,
"protectedstatusnotes" VARCHAR
);CREATE TABLE overstory_tree_census_raw_240723 (
"unit_code" VARCHAR,
"stream_name" VARCHAR,
"start_date" TIMESTAMP,
"visit_year" BIGINT,
"plot_id" BIGINT,
"tag_no" BIGINT,
"species" VARCHAR,
"dbh" DOUBLE,
"crown_health" BIGINT,
"notes" VARCHAR
);CREATE TABLE seedling_count_raw_240723 (
"unit_code" VARCHAR,
"stream_name" VARCHAR,
"start_date" TIMESTAMP,
"visit_year" BIGINT,
"plot_id" BIGINT,
"transect" BIGINT,
"species" VARCHAR,
"total" VARCHAR
);CREATE TABLE tree_belt_raw_240723 (
"unit_code" VARCHAR,
"stream_name" VARCHAR,
"start_date" TIMESTAMP,
"visit_year" BIGINT,
"plot_id" BIGINT,
"transect" BIGINT,
"species" VARCHAR,
"alive" BIGINT,
"dbh" DOUBLE
);CREATE TABLE wadeable_pi_long2024_07_24 (
"unit_code" VARCHAR,
"stream_name" VARCHAR,
"start_date" TIMESTAMP,
"visit_year" BIGINT,
"plot_id" BIGINT,
"transect" BIGINT,
"point" DOUBLE,
"layer" VARCHAR,
"species" VARCHAR,
"status" VARCHAR,
"master_species" VARCHAR
);Anyone who has the link will be able to view this.