Supplemental Structure (SupplStruc) Dataset Containing Vegetation Vertical Structure At Tallgrass Prairie National Preserve by US Government | Environmental and Climate Sciences

About this Dataset

Supplemental Structure (SupplStruc) Dataset Containing Vegetation Vertical Structure At Tallgrass Prairie National Preserve

This dataset was originally developed as part of the HTLN breeding bird habitat monitoring program at Tallgrass Prairie National Preserve, KS (TAPR). The methodology is described in HTLN Breeding Bird Protocol (see linked references). The data were further developed (here) to study the relationships between vegetation structure, fire and grazing at TAPR.
Organization: Department of the Interior
Last updated: 2023-08-24T05:15:33.146452
Tags: ecological-framework-biological-integrity-focal-species-or-communities-grassland-herbaceous-com, fire, fire-ecology, htln, tallgrass-prairie, tallgrass-prairie-national-preserve, tapr, vegetation-structure, wildlife-habitat

Tables

HTLNSupplStruct StructurePatchesTimeSinceBurnt

@usgov.doi_gov_supplemental_structure_supplstruc_containing_v_dbe06533.htlnsupplstruct_structurepatchestimesinceburnt

20.78 KB
243 rows
25 columns


CREATE TABLE htlnsupplstruct_structurepatchestimesinceburnt (
  "locationid" VARCHAR,
  "management_unit" VARCHAR,
  "startutmx" DOUBLE,
  "startutmy" DOUBLE,
  "utmzone" BIGINT,
  "habitattype" VARCHAR,
  "aspect" BIGINT,
  "slope" DOUBLE,
  "slopevariability" VARCHAR,
  "aspectvariability" VARCHAR,
  "topoposition" VARCHAR,
  "ripariancorr" BIGINT,
  "sdate" BIGINT,
  "s0_025m" BIGINT,
  "s025_050m" BIGINT,
  "s050_075m" BIGINT,
  "s075_100m" BIGINT,
  "s100_125m" BIGINT,
  "s125_150m" BIGINT,
  "s150_175m" BIGINT,
  "s175_200m" BIGINT,
  "max_cat" BIGINT,
  "max_heightm" DOUBLE,
  "notes" VARCHAR,
  "patch" BIGINT
);

HTLNSupplStruct MaxHeight

@usgov.doi_gov_supplemental_structure_supplstruc_containing_v_dbe06533.htlnsupplstruct_maxheight

14.81 KB
94 rows
18 columns


CREATE TABLE htlnsupplstruct_maxheight (
  "locationid" VARCHAR,
  "eventid" VARCHAR,
  "date" TIMESTAMP,
  "parkcode" VARCHAR,
  "management_unit" VARCHAR,
  "startutmx" DOUBLE,
  "startutmy" DOUBLE,
  "utmzone" BIGINT,
  "habitattype" VARCHAR,
  "aspect" BIGINT,
  "slope" BIGINT,
  "slopevariability" VARCHAR,
  "aspectvariability" VARCHAR,
  "topoposition" VARCHAR,
  "ripariancorr" BOOLEAN,
  "pasture" VARCHAR,
  "max_height" DOUBLE,
  "notes" VARCHAR
);

HTLNSupplStruct VegStruct

@usgov.doi_gov_supplemental_structure_supplstruc_containing_v_dbe06533.htlnsupplstruct_vegstruct

22.68 KB
736 rows
23 columns


CREATE TABLE htlnsupplstruct_vegstruct (
  "locationid" VARCHAR,
  "eventid" VARCHAR,
  "date" TIMESTAMP,
  "parkcode" VARCHAR,
  "management_unit" VARCHAR,
  "startutmx" DOUBLE,
  "startutmy" DOUBLE,
  "utmzone" BIGINT,
  "habitattype" VARCHAR,
  "aspect" BIGINT,
  "slope" BIGINT,
  "slopevariability" VARCHAR,
  "aspectvariability" VARCHAR,
  "topoposition" VARCHAR,
  "ripariancorr" BOOLEAN,
  "pasture" VARCHAR,
  "strataclass" BIGINT,
  "coverclass" BIGINT,
  "patch" DOUBLE,
  "tlu_strataclasses_range" VARCHAR,
  "maxht_m" DOUBLE,
  "midpointvalue" DOUBLE,
  "tlu_coverclasses_range" VARCHAR
);

HTLNSupplStruct StructureData

@usgov.doi_gov_supplemental_structure_supplstruc_containing_v_dbe06533.htlnsupplstruct_structuredata

23.87 KB
436 rows
23 columns


CREATE TABLE htlnsupplstruct_structuredata (
  "locationid" VARCHAR,
  "management_unit" VARCHAR,
  "startutmx" DOUBLE,
  "startutmy" DOUBLE,
  "utmzone" BIGINT,
  "habitattype" VARCHAR,
  "aspect" BIGINT,
  "slope" DOUBLE,
  "slopevariability" VARCHAR,
  "aspectvariability" VARCHAR,
  "topoposition" VARCHAR,
  "ripariancorr" BIGINT,
  "sdate" BIGINT,
  "s0_025m" BIGINT,
  "s025_050m" BIGINT,
  "s050_075m" BIGINT,
  "s075_100m" BIGINT,
  "s100_125m" BIGINT,
  "s125_150m" BIGINT,
  "s150_175m" BIGINT,
  "s175_200m" BIGINT,
  "max_cat" BIGINT,
  "max_heightm" DOUBLE
);