Data Package: Terrestrial Vegetation Monitoring In National Parks Of The Southeast Coast Network, 2019-2023
Department of the Interior
@usgov.doi_gov_data_package_terrestrial_vegetation_monitoring_d309ad0b
Department of the Interior
@usgov.doi_gov_data_package_terrestrial_vegetation_monitoring_d309ad0b
Vegetation communities serve as the foundation of habitat for many species, function as a carbon sink, produce oxygen, cycle nutrients and energy, improve water quality, and moderate flooding/erosion. Given the widespread anthropogenic influences in Southeast Coast Network parks and the importance of vegetation communities, quantifying trends in species diversity and forest regeneration is vital to understanding ecological processes and identifying stressors and their impacts. Evaluating trends in vegetation and environmental attributes provides measures for assessing the ecological integrity and sustainability of park’s terrestrial vegetation and identifies potential management activities on our park lands. The National Park Service Omnibus Management Act of 1998 and other reinforcing policies and regulations require park managers to establish baseline information and to provide information on the long-term trends in the condition of National Park System resources (Title II, Sec. 204). The data summarized herein is a tool to assist managers in fulfilling this mandate.
Organization: Department of the Interior
Last updated: 2025-09-14T20:31:41.018468
Tags: database, forest-health, ms-access, terrestrial-vegetation, vegetation-plot
CREATE TABLE canopy (
"park_name" VARCHAR,
"park_code" VARCHAR,
"subunit_name" VARCHAR,
"subunit_code" VARCHAR,
"plot_id" VARCHAR,
"event_date" TIMESTAMP,
"event_type" VARCHAR,
"module" BIGINT,
"cardinal_direction" VARCHAR,
"canopy_cover" BIGINT
);CREATE TABLE community (
"park_name" VARCHAR,
"park_code" VARCHAR,
"subunit_name" VARCHAR,
"subunit_code" VARCHAR,
"plot_id" VARCHAR,
"event_date" TIMESTAMP,
"event_type" VARCHAR,
"community_name" VARCHAR,
"common_name" VARCHAR,
"translated_name" VARCHAR,
"community_code" VARCHAR,
"community_level" VARCHAR,
"classification_notes" VARCHAR
);CREATE TABLE disturbance (
"park_name" VARCHAR,
"park_code" VARCHAR,
"subunit_name" VARCHAR,
"subunit_code" VARCHAR,
"plot_id" VARCHAR,
"event_date" TIMESTAMP,
"event_type" VARCHAR,
"disturbance_type" VARCHAR,
"other_type" VARCHAR,
"observed" BOOLEAN,
"cover_percent" BIGINT
);CREATE TABLE diversity (
"park_name" VARCHAR,
"park_code" VARCHAR,
"subunit_name" VARCHAR,
"subunit_code" VARCHAR,
"plot_id" VARCHAR,
"event_date" TIMESTAMP,
"event_type" VARCHAR,
"taxon_observed" VARCHAR,
"id_confidence" VARCHAR,
"cover_class_module_1" BIGINT,
"cover_class_module_2" BIGINT,
"cover_class_module_3" BIGINT,
"cover_class_module_4" BIGINT,
"presence_module_1_corner_2" VARCHAR,
"presence_module_1_corner_4" VARCHAR,
"presence_module_2_corner_2" VARCHAR,
"presence_module_2_corner_3" VARCHAR,
"presence_module_3_corner_2" VARCHAR,
"presence_module_3_corner_4" VARCHAR,
"presence_module_4_corner_2" VARCHAR,
"presence_module_4_corner_3" VARCHAR
);CREATE TABLE event (
"park_name" VARCHAR,
"park_code" VARCHAR,
"subunit_name" VARCHAR,
"subunit_code" VARCHAR,
"plot_id" VARCHAR,
"event_date" TIMESTAMP,
"event_type" VARCHAR,
"dpl" VARCHAR,
"water_on_plot" VARCHAR,
"submerged_percent" VARCHAR,
"canopy_height_1" BIGINT,
"canopy_height_2" BIGINT,
"canopy_height_3" BIGINT,
"plot_layout_notes" VARCHAR
);CREATE TABLE plots (
"park_name" VARCHAR,
"park_code" VARCHAR,
"subunit_name" VARCHAR,
"subunit_code" VARCHAR,
"plot_id" VARCHAR,
"event_date" TIMESTAMP,
"event_type" VARCHAR,
"terrain_complexity" VARCHAR,
"slope" VARCHAR,
"aspect" VARCHAR,
"landform" VARCHAR,
"topography" VARCHAR,
"tsi_aspect" VARCHAR,
"tsi_45" VARCHAR,
"tsi_90" VARCHAR,
"tsi_135" VARCHAR,
"tsi_180" VARCHAR,
"tsi_225" VARCHAR,
"tsi_270" VARCHAR,
"tsi_315" VARCHAR,
"broad_habitat_type_code" VARCHAR,
"broad_habitat_type_name" VARCHAR,
"physiognomy" VARCHAR,
"declination" BIGINT,
"environment_notes" VARCHAR
);CREATE TABLE seedling_sapling (
"park_name" VARCHAR,
"park_code" VARCHAR,
"subunit_name" VARCHAR,
"subunit_code" VARCHAR,
"plot_id" VARCHAR,
"event_date" TIMESTAMP,
"event_type" VARCHAR,
"module" BIGINT,
"corner" BIGINT,
"taxon_observed" VARCHAR,
"seedling_ht_5_15" VARCHAR,
"seedling_ht_15_30" VARCHAR,
"seedling_ht_30_50" VARCHAR,
"seedling_ht_50_137" VARCHAR,
"sapling_dbh_0_1" VARCHAR,
"sapling_dbh_1_2_5" VARCHAR,
"sapling_dbh_2_5_5" VARCHAR,
"sapling_dbh_5_10" VARCHAR
);CREATE TABLE soil (
"park_name" VARCHAR,
"park_code" VARCHAR,
"subunit_name" VARCHAR,
"subunit_code" VARCHAR,
"plot_id" VARCHAR,
"collected_date" TIMESTAMP,
"tec" DOUBLE,
"ph" DOUBLE,
"organicmatter_percent" DOUBLE,
"nitrogenrelease_nperacre" BIGINT,
"sulfur_ppm" BIGINT,
"phosphorus_ppm" BIGINT,
"phosphorous_brayii_ppm" DOUBLE,
"calcium_ppm" BIGINT,
"magnesium_ppm" BIGINT,
"potassium_ppm" BIGINT,
"sodium_ppm" BIGINT,
"calcium_percent" DOUBLE,
"magnesium_percent" DOUBLE,
"potassium_percent" DOUBLE,
"sodium_percent" DOUBLE,
"otherbases_percent" DOUBLE,
"hydrogen_percent" DOUBLE,
"boron_ppm" DOUBLE,
"iron_ppm" BIGINT,
"manganese_ppm" DOUBLE,
"copper_ppm" DOUBLE,
"zinc_ppm" DOUBLE,
"aluminum_ppm" DOUBLE
);CREATE TABLE table_2 (
"park_name" VARCHAR,
"park_code" VARCHAR,
"subunit_name" VARCHAR,
"subunit_code" VARCHAR,
"plot_id" VARCHAR,
"event_date" TIMESTAMP,
"event_type" VARCHAR,
"transect" BIGINT,
"diameter" BIGINT,
"decay_class" BIGINT
);CREATE TABLE trees (
"park_name" VARCHAR,
"park_code" VARCHAR,
"subunit_name" VARCHAR,
"subunit_code" VARCHAR,
"plot_id" VARCHAR,
"event_date" TIMESTAMP,
"event_type" VARCHAR,
"module" BIGINT,
"tree_number" BIGINT,
"taxon_observed" VARCHAR,
"dbh" VARCHAR,
"status_code" BIGINT,
"status_name" VARCHAR,
"crown_code" VARCHAR,
"crown_name" VARCHAR,
"vigor_code" VARCHAR,
"vigor_name" VARCHAR,
"dieback_code" VARCHAR,
"dieback_name" VARCHAR,
"dead_tree_decay_class" VARCHAR,
"snag_height" VARCHAR,
"condition_damage_code_1" VARCHAR
);Anyone who has the link will be able to view this.