About this Dataset

Klamath Vegetation Monitoring Data Package

This dataset contains monitoring data for vegetation at Crater Lake NP, Lassen Volcanic NP, Lava Beds NM, Oregon Caves NMP, Redwood NSP, and Whiskeytown NRA. A core concept of the Klamath Inventory and Monitoring Networks vegetation monitoring protocol is that assessing the composition, structure, and function of vegetation communities, can be used to evaluate the ecological integrity of wider park habitats. Therefore, monitoring vegetation change is imperative to detecting and understanding the status and trends in park ecosystems. Objectives are to: sample vegetation and environmental parameters every 3 years using a 3 year revisit frequency; monitor status and trends in vegetation composition; monitor status and trends in vegetation structure and function.
Organization: Department of the Interior
Last updated: 2024-11-02T08:50:40.123611
Tags: ecological-data, ecological-monitoring, function, long-term-monitoring, national-parks, structure, vegetation

Tables

Densiometer

@usgov.doi_gov_klamath_vegetation_monitoring_data_package_428b8.densiometer

31.79 kB
888 rows
15 columns

CREATE TABLE densiometer (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "loc_name" VARCHAR,
  "start_date" TIMESTAMP,
  "canopycover_mod1" DOUBLE,
  "canopycover_mod2" DOUBLE,
  "canopycover_mod3" DOUBLE,
  "canopycover_mod4" DOUBLE,
  "canopycover_mod5" DOUBLE,
  "canopycover_mod6" BIGINT,
  "canopycover_mod7" BIGINT,
  "canopycover_mod8" BIGINT,
  "canopycover_mod9" BIGINT,
  "canopycover_mod10" DOUBLE,
  "notes" VARCHAR
);

Disturbance

@usgov.doi_gov_klamath_vegetation_monitoring_data_package_428b8.disturbance

23.68 kB
401 rows
14 columns

CREATE TABLE disturbance (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "loc_name" VARCHAR,
  "start_date" TIMESTAMP,
  "agriculture" VARCHAR,
  "browse" VARCHAR,
  "logging" VARCHAR,
  "fire" VARCHAR,
  "natural" VARCHAR,
  "insect" VARCHAR,
  "wind" VARCHAR,
  "animal" VARCHAR,
  "other" VARCHAR,
  "describe_other" VARCHAR
);

Events

@usgov.doi_gov_klamath_vegetation_monitoring_data_package_428b8.events

61.45 kB
926 rows
10 columns

CREATE TABLE events (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "loc_name" VARCHAR,
  "start_date" TIMESTAMP,
  "second_date" TIMESTAMP,
  "starttime_24hr" VARCHAR,
  "endtime_24hr" VARCHAR,
  "second_starttime_24hr" VARCHAR,
  "second_endtime_24hr" VARCHAR,
  "event_notes" VARCHAR
);

LargeWoodyStem

@usgov.doi_gov_klamath_vegetation_monitoring_data_package_428b8.largewoodystem

38.4 kB
4,832 rows
8 columns

CREATE TABLE largewoodystem (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "loc_name" VARCHAR,
  "start_date" TIMESTAMP,
  "width_cm" DOUBLE,
  "length_cm" DOUBLE,
  "decay_class" VARCHAR,
  "notes" VARCHAR
);

LitterDuff

@usgov.doi_gov_klamath_vegetation_monitoring_data_package_428b8.litterduff

49.22 kB
911 rows
25 columns

CREATE TABLE litterduff (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "loc_name" VARCHAR,
  "start_date" TIMESTAMP,
  "litterdepthat5m_cm" DOUBLE,
  "litterdepthat10m_cm" DOUBLE,
  "litterdepthat15m_cm" DOUBLE,
  "litterdepthat20m_cm" DOUBLE,
  "litterdepthat25m_cm" DOUBLE,
  "litterdepthat30m_cm" DOUBLE,
  "litterdepthat35m_cm" DOUBLE,
  "litterdepthat40m_cm" DOUBLE,
  "litterdepthat45m_cm" DOUBLE,
  "litterdepthat50m_cm" DOUBLE,
  "duffdepthat5m_cm" DOUBLE,
  "duffdepthat10m_cm" DOUBLE,
  "duffdepthat15m_cm" DOUBLE,
  "duffdepthat20m_cm" DOUBLE,
  "duffdepthat25m_cm" DOUBLE,
  "duffdepthat30m_cm" DOUBLE,
  "duffdepthat35m_cm" DOUBLE,
  "duffdepthat40m_cm" DOUBLE,
  "duffdepthat45m_cm" DOUBLE,
  "duffdepthat50m_cm" DOUBLE,
  "notes" VARCHAR
);

Locations

@usgov.doi_gov_klamath_vegetation_monitoring_data_package_428b8.locations

127.92 kB
317 rows
74 columns

CREATE TABLE locations (
  "network_code" VARCHAR,
  "unit_code" VARCHAR,
  "loc_name" VARCHAR,
  "park_name" VARCHAR,
  "loc_type" VARCHAR,
  "coord_units" VARCHAR,
  "coord_system" VARCHAR,
  "center_est_horiz_error_m" DOUBLE,
  "watershed" VARCHAR,
  "subwatershed" VARCHAR,
  "township" VARCHAR,
  "range" VARCHAR,
  "section" DOUBLE,
  "usgs_quad" VARCHAR,
  "center_easting" DOUBLE,
  "center_northing" DOUBLE,
  "site_name1" DOUBLE,
  "sitename1_easting" DOUBLE,
  "sitename1_northing" DOUBLE,
  "sitename1_est_horiz_error_m" DOUBLE,
  "site_name2" DOUBLE,
  "sitename2_easting" DOUBLE,
  "sitename2_northing" DOUBLE,
  "sitename2_est_horiz_error_m" DOUBLE,
  "site_name3" DOUBLE,
  "sitename3_easting" DOUBLE,
  "sitename3_northing" DOUBLE,
  "sitename3_est_horiz_error_m" DOUBLE,
  "site_name4" DOUBLE,
  "sitename4_easting" DOUBLE,
  "sitename4_northing" DOUBLE,
  "sitename4_est_horiz_error_m" DOUBLE,
  "utm_zone" DOUBLE,
  "datum" VARCHAR,
  "accuracy_notes" VARCHAR,
  "monument_date" TIMESTAMP,
  "installation_time" DOUBLE,
  "macro_position" VARCHAR,
  "slope_1_degrees" BIGINT,
  "slope_2_degrees" BIGINT,
  "slope_3_degrees" BIGINT,
  "slope_4_degrees" DOUBLE,
  "aspect_1_degrees" BIGINT,
  "aspect_2_degrees" BIGINT,
  "aspect_3_degrees" BIGINT,
  "aspect_4_degrees" DOUBLE,
  "elevation_meters" BIGINT,
  "loc_slope_shape" VARCHAR,
  "travel_directions" VARCHAR,
  "loc_notes" VARCHAR,
  "witnesstree1_sciname" VARCHAR,
  "witnesstree1_dbh_cm" DOUBLE,
  "witnesstree1_azimuth_degrees" DOUBLE,
  "witnesstree1_distance_m" DOUBLE,
  "witnesstree2_sciname" VARCHAR,
  "witnesstree2_dbh_cm" DOUBLE,
  "witnesstree2_azimuth_degrees" DOUBLE,
  "witnesstree2_distance_m" DOUBLE,
  "parking_easting" DOUBLE,
  "parking_northing" DOUBLE,
  "accuracy_type_at_corner1" VARCHAR,
  "accuracy_type_at_corner2" VARCHAR,
  "accuracy_type_at_corner3" VARCHAR,
  "accuracy_type_at_corner4" VARCHAR,
  "plot_size_m" VARCHAR,
  "centerlineazimuth_degrees" DOUBLE,
  "county" VARCHAR,
  "state" VARCHAR,
  "witnesstree1_tag" DOUBLE,
  "witnesstree2_tag" DOUBLE,
  "slope_aspect_name1" VARCHAR,
  "slope_aspect_name2" VARCHAR,
  "slope_aspect_name3" VARCHAR,
  "slope_aspect_name4" DOUBLE
);

NestedPlot

@usgov.doi_gov_klamath_vegetation_monitoring_data_package_428b8.nestedplot

608.39 kB
72,443 rows
12 columns

CREATE TABLE nestedplot (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "loc_name" VARCHAR,
  "start_date" TIMESTAMP,
  "nested_subplot" VARCHAR,
  "cover_strata1_percent" DOUBLE,
  "cover_strata2_percent" DOUBLE,
  "cover_strata3_percent" DOUBLE,
  "cover_strata4_percent" DOUBLE,
  "current_sp_code" VARCHAR,
  "current_sci_name" VARCHAR,
  "nested_notes" VARCHAR
);

Photos

@usgov.doi_gov_klamath_vegetation_monitoring_data_package_428b8.photos

77.24 kB
6,326 rows
8 columns

CREATE TABLE photos (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "loc_name" VARCHAR,
  "start_date" TIMESTAMP,
  "photograph_name" VARCHAR,
  "date_photo_taken" TIMESTAMP,
  "photo_description" VARCHAR,
  "notes" VARCHAR
);

Seedlings

@usgov.doi_gov_klamath_vegetation_monitoring_data_package_428b8.seedlings

45.73 kB
4,676 rows
13 columns

CREATE TABLE seedlings (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "loc_name" VARCHAR,
  "start_date" TIMESTAMP,
  "seedling_plot" DOUBLE,
  "current_sp_code" VARCHAR,
  "current_sci_name" VARCHAR,
  "seedlings_under15cmht" DOUBLE,
  "seedlings_under2_54cmdbh" DOUBLE,
  "seedlings_2_54cmto5cmdbh" DOUBLE,
  "seedlings_5cmto10cmdbh" DOUBLE,
  "seedlings_10cmto15cmdbh" DOUBLE,
  "notes" VARCHAR
);

Shrubs

@usgov.doi_gov_klamath_vegetation_monitoring_data_package_428b8.shrubs

31.91 kB
3,656 rows
9 columns

CREATE TABLE shrubs (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "loc_name" VARCHAR,
  "start_date" TIMESTAMP,
  "shrubht_quad1_m" DOUBLE,
  "shrubht_quad2_m" DOUBLE,
  "shrubht_quad3_m" DOUBLE,
  "shrubht_quad4_m" DOUBLE,
  "notes" VARCHAR
);

Substrate

@usgov.doi_gov_klamath_vegetation_monitoring_data_package_428b8.substrate

46.77 kB
15,908 rows
8 columns

CREATE TABLE substrate (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "loc_name" VARCHAR,
  "start_date" TIMESTAMP,
  "subplot" DOUBLE,
  "substrate" VARCHAR,
  "cover_percent" DOUBLE,
  "notes" VARCHAR
);

Successional

@usgov.doi_gov_klamath_vegetation_monitoring_data_package_428b8.successional

7.6 kB
242 rows
5 columns

CREATE TABLE successional (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "loc_name" VARCHAR,
  "start_date" TIMESTAMP,
  "successional_stage" VARCHAR
);

WoodyStem

@usgov.doi_gov_klamath_vegetation_monitoring_data_package_428b8.woodystem

59.87 kB
882 rows
35 columns

CREATE TABLE woodystem (
  "unit_code" VARCHAR,
  "park_name" VARCHAR,
  "loc_name" VARCHAR,
  "start_date" TIMESTAMP,
  "n_0_0_62cm_class_at_0_1m" BIGINT  -- 0-0.62cm Class At 0-1m,
  "n_0_63_2_54cm_class_at_0_1m" BIGINT  -- 0.63-2.54cm Class At 0-1m,
  "n_2_55_7_6cm_class_at_0_1m" BIGINT  -- 2.55-7.6cm Class At 0-1m,
  "n_0_0_62cm_class_at_5_6m" BIGINT  -- 0-0.62cm Class At 5-6m,
  "n_0_63_2_54cm_class_at_5_6m" BIGINT  -- 0.63-2.54cm Class At 5-6m,
  "n_2_55_7_6cm_class_at_5_6m" BIGINT  -- 2.55-7.6cm Class At 5-6m,
  "n_0_0_62cm_class_at_10_11m" BIGINT  -- 0-0.62cm Class At 10-11m,
  "n_0_63_2_54cm_class_at_10_11m" BIGINT  -- 0.63-2.54cm Class At 10-11m,
  "n_2_55_7_6cm_class_at_10_11m" BIGINT  -- 2.55-7.6cm Class At 10-11m,
  "n_0_0_62cm_class_at_15_16m" BIGINT  -- 0-0.62cm Class At 15-16m,
  "n_0_63_2_54cm_class_at_15_16m" BIGINT  -- 0.63-2.54cm Class At 15-16m,
  "n_2_55_7_6cm_class_at_15_16m" DOUBLE  -- 2.55-7.6cm Class At 15-16m,
  "n_0_0_62cm_class_at_20_21m" BIGINT  -- 0-0.62cm Class At 20-21m,
  "n_0_63_2_54cm_class_at_20_21m" BIGINT  -- 0.63-2.54cm Class At 20-21m,
  "n_2_55_7_6cm_class_at_20_21m" BIGINT  -- 2.55-7.6cm Class At 20-21m,
  "n_0_0_62cm_class_at_25_26m" BIGINT  -- 0-0.62cm Class At 25-26m,
  "n_0_63_2_54cm_class_at_25_26m" BIGINT  -- 0.63-2.54cm Class At 25-26m,
  "n_2_55_7_6cm_class_at_25_26m" BIGINT  -- 2.55-7.6cm Class At 25-26m,
  "n_0_0_62cm_class_at_30_31m" BIGINT  -- 0-0.62cm Class At 30-31m,
  "n_0_63_2_54cm_class_at_30_31m" BIGINT  -- 0.63-2.54cm Class At 30-31m,
  "n_2_55_7_6cm_class_at_30_31m" BIGINT  -- 2.55-7.6cm Class At 30-31m,
  "n_0_0_62cm_class_at_35_36m" BIGINT  -- 0-0.62cm Class At 35-36m,
  "n_0_63_2_54cm_class_at_35_36m" BIGINT  -- 0.63-2.54cm Class At 35-36m,
  "n_2_55_7_6cm_class_at_35_36m" BIGINT  -- 2.55-7.6cm Class At 35-36m,
  "n_0_0_62cm_class_at_40_41m" BIGINT  -- 0-0.62cm Class At 40-41m,
  "n_0_63_2_54cm_class_at_40_41m" BIGINT  -- 0.63-2.54cm Class At 40-41m,
  "n_2_55_7_6cm_class_at_40_41m" BIGINT  -- 2.55-7.6cm Class At 40-41m,
  "n_0_0_62cm_class_at_45_46m" BIGINT  -- 0-0.62cm Class At 45-46m,
  "n_0_63_2_54cm_class_at_45_46m" BIGINT  -- 0.63-2.54cm Class At 45-46m,
  "n_2_55_7_6cm_class_at_45_46m" BIGINT  -- 2.55-7.6cm Class At 45-46m,
  "notes" VARCHAR
);