About this Dataset

Gulf Coast Network Vegetation Monitoring Database Exports: 2018 Through January 2024

Flat file (.csv) exports from the latest accepted datasets for the Gulf Coast Network Vegetation Monitoring Project.
Organization: Department of the Interior
Last updated: 2025-05-08T17:17:19.885499
Tags: gulf-coast-network, guln-vegetation-monitoring, monitoring, vegetation-communities

Tables

Event Observations2018 Through Jan2024

@usgov.doi_gov_gulf_coast_network_vegetation_monitoring_datab_3a70605c.event_observations2018_through_jan2024

53.65 KB
356 rows
22 columns


CREATE TABLE event_observations2018_through_jan2024 (
  "plotnumber" VARCHAR,
  "unit" VARCHAR,
  "subunit" VARCHAR,
  "eventdate" TIMESTAMP,
  "timein" VARCHAR,
  "timeout" VARCHAR,
  "isqaqc" BIGINT,
  "notes" VARCHAR,
  "observerrole" VARCHAR,
  "waterplot" VARCHAR,
  "crownclosurepercent" VARCHAR,
  "crownclosurepercentnullnote" VARCHAR,
  "underwaterpercent" VARCHAR,
  "disturbance" VARCHAR,
  "threshold" VARCHAR,
  "pastinundation" VARCHAR,
  "taxonortaxongroup1" VARCHAR,
  "taxonortaxongroup1height" VARCHAR,
  "taxonortaxongroup2" VARCHAR,
  "taxonortaxongroup2height" VARCHAR,
  "taxonortaxongroup3" VARCHAR,
  "taxonortaxongroup3height" VARCHAR
);

SeedlingSaplingCounts2019 Through Jan2024

@usgov.doi_gov_gulf_coast_network_vegetation_monitoring_datab_3a70605c.seedlingsaplingcounts2019_through_jan2024

33.38 KB
933 rows
36 columns


CREATE TABLE seedlingsaplingcounts2019_through_jan2024 (
  "unit" VARCHAR,
  "eventdate" TIMESTAMP,
  "scientificname" VARCHAR,
  "plotnumber" VARCHAR,
  "s1seed1" VARCHAR,
  "s1seed2" VARCHAR,
  "s1seed3" VARCHAR,
  "s1seed4" VARCHAR,
  "s1sapl1" VARCHAR,
  "s1sapl2" VARCHAR,
  "s1sapl3" VARCHAR,
  "s1sapl4" VARCHAR,
  "s2seed1" VARCHAR,
  "s2seed2" VARCHAR,
  "s2seed3" VARCHAR,
  "s2seed4" VARCHAR,
  "s2sapl1" VARCHAR,
  "s2sapl2" VARCHAR,
  "s2sapl3" VARCHAR,
  "s2sapl4" VARCHAR,
  "s3seed1" VARCHAR,
  "s3seed2" VARCHAR,
  "s3seed3" VARCHAR,
  "s3seed4" VARCHAR,
  "s3sapl1" VARCHAR,
  "s3sapl3" VARCHAR,
  "s3sapl2" VARCHAR,
  "s3sapl4" VARCHAR,
  "s4seed1" VARCHAR,
  "s4seed2" VARCHAR,
  "s4seed3" VARCHAR,
  "s4seed4" VARCHAR,
  "s4sapl1" VARCHAR,
  "s4sapl2" VARCHAR,
  "s4sapl3" VARCHAR,
  "s4sapl4" VARCHAR
);

Species Presence And Cover2019 Through Jan2024 V2

@usgov.doi_gov_gulf_coast_network_vegetation_monitoring_datab_3a70605c.species_presence_and_cover2019_through_jan2024_v2

237.57 KB
10189 rows
32 columns


CREATE TABLE species_presence_and_cover2019_through_jan2024_v2 (
  "id" BIGINT,
  "plotnumber" VARCHAR,
  "unit" VARCHAR,
  "subunit" VARCHAR,
  "eventdate" TIMESTAMP,
  "isqaqc" BIGINT,
  "taxongroupid" BIGINT,
  "family" VARCHAR,
  "scientificname" VARCHAR,
  "commonname" VARCHAR,
  "isnative" BIGINT,
  "confidence" VARCHAR,
  "n_1a_smw" VARCHAR,
  "n_1b_smw" VARCHAR,
  "n_1a_cover" VARCHAR,
  "n_1bs_cover" VARCHAR,
  "n_1bm_cover" VARCHAR,
  "n_2a_smw" VARCHAR,
  "n_2b_smw" VARCHAR,
  "n_2a_cover" VARCHAR,
  "n_2bs_cover" VARCHAR,
  "n_2bm_cover" VARCHAR,
  "n_3a_smw" VARCHAR,
  "n_3b_smw" VARCHAR,
  "n_3a_cover" VARCHAR,
  "n_3bs_cover" VARCHAR,
  "n_3bm_cover" VARCHAR,
  "n_4a_smw" VARCHAR,
  "n_4b_smw" VARCHAR,
  "n_4a_cover" VARCHAR,
  "n_4bs_cover" VARCHAR,
  "n_4bm_cover" VARCHAR
);

TreeData2018 Through Jan2024

@usgov.doi_gov_gulf_coast_network_vegetation_monitoring_datab_3a70605c.treedata2018_through_jan2024

78.34 KB
4892 rows
18 columns


CREATE TABLE treedata2018_through_jan2024 (
  "plotnumber" VARCHAR,
  "unit" VARCHAR,
  "subunit" VARCHAR,
  "subplot" VARCHAR,
  "eventdate" TIMESTAMP,
  "scientificname" VARCHAR,
  "treenumber" BIGINT,
  "fork" VARCHAR,
  "isdbhunusual" BIGINT,
  "distance" VARCHAR,
  "azimuth" VARCHAR,
  "treestatus" VARCHAR,
  "condition" VARCHAR,
  "foliagecondition" VARCHAR,
  "canopy" VARCHAR,
  "leaf" VARCHAR,
  "height" VARCHAR,
  "dbh_cm" VARCHAR
);