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: 2025-09-14T18:52:16.896535
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 MaxHeight

@usgov.doi_gov_supplemental_structure_supplstruc_containing_v_dbe06533.htlnsupplstruct_maxheight

15.16 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 StructureData

@usgov.doi_gov_supplemental_structure_supplstruc_containing_v_dbe06533.htlnsupplstruct_structuredata

24.44 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
);

HTLNSupplStruct StructurePatchesTimeSinceBurnt

@usgov.doi_gov_supplemental_structure_supplstruc_containing_v_dbe06533.htlnsupplstruct_structurepatchestimesinceburnt

21.28 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 VegStruct

@usgov.doi_gov_supplemental_structure_supplstruc_containing_v_dbe06533.htlnsupplstruct_vegstruct

23.22 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
);