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

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

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

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  -- 1A SMW,
  "n_1b_smw" VARCHAR  -- 1B SMW,
  "n_1a_cover" VARCHAR  -- 1A%cover,
  "n_1bs_cover" VARCHAR  -- 1BS%cover,
  "n_1bm_cover" VARCHAR  -- 1BM%cover,
  "n_2a_smw" VARCHAR  -- 2A SMW,
  "n_2b_smw" VARCHAR  -- 2B SMW,
  "n_2a_cover" VARCHAR  -- 2A%cover,
  "n_2bs_cover" VARCHAR  -- 2BS%cover,
  "n_2bm_cover" VARCHAR  -- 2BM%cover,
  "n_3a_smw" VARCHAR  -- 3A SMW,
  "n_3b_smw" VARCHAR  -- 3B SMW,
  "n_3a_cover" VARCHAR  -- 3A%cover,
  "n_3bs_cover" VARCHAR  -- 3BS%cover,
  "n_3bm_cover" VARCHAR  -- 3BM%cover,
  "n_4a_smw" VARCHAR  -- 4A SMW,
  "n_4b_smw" VARCHAR  -- 4B SMW,
  "n_4a_cover" VARCHAR  -- 4A%cover,
  "n_4bs_cover" VARCHAR  -- 4BS%cover,
  "n_4bm_cover" VARCHAR  -- 4BM%cover
);

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