Vegetation Monitoring In The Great Lakes Network, 2007-2024 - Data Package
Department of the Interior
@usgov.doi_gov_vegetation_monitoring_in_the_great_lakes_netwo_ca2e1785
Department of the Interior
@usgov.doi_gov_vegetation_monitoring_in_the_great_lakes_netwo_ca2e1785
CREATE TABLE glkn_vegetation_coarsewoodymaterials_base (
"samplinground" VARCHAR,
"samplingyear" BIGINT,
"protocol_name" VARCHAR,
"park" VARCHAR,
"plot" BIGINT,
"samplingtype" VARCHAR,
"panel_type" VARCHAR,
"location_status" VARCHAR,
"habitat" VARCHAR,
"transect" DOUBLE,
"transectlength_inmeters" BIGINT,
"sampledtransectlength_inmeters" VARCHAR,
"sampled" VARCHAR,
"accepted_latinname" VARCHAR,
"vegtype" VARCHAR,
"sm_diameter_incentimeters" VARCHAR,
"lg_diameter_incentimeters" VARCHAR,
"trans_diameter_incentimeters" VARCHAR,
"length_inmeters" VARCHAR,
"decayclass" VARCHAR,
"type" VARCHAR,
"basisofrecord" VARCHAR
);
CREATE TABLE glkn_vegetation_directbase (
"samplinground" VARCHAR,
"samplingyear" BIGINT,
"protocol_name" VARCHAR,
"park" VARCHAR,
"plot" BIGINT,
"samplingtype" VARCHAR,
"panel_type" VARCHAR,
"location_status" VARCHAR,
"habitat" VARCHAR,
"transect" DOUBLE,
"transectlength_inmeters" BIGINT,
"sampledtransectlength_inmeters" BIGINT,
"sampled" VARCHAR,
"quadrat_inmeters" BIGINT,
"quadsampled" VARCHAR,
"accepted_latinname" VARCHAR,
"vegtype" VARCHAR,
"present_2sqm" VARCHAR,
"browsed_2sqm" VARCHAR,
"present_4sqm" VARCHAR,
"browsed_4sqm" VARCHAR,
"present_3sqm" VARCHAR,
"browsed_3sqm" VARCHAR,
"type" VARCHAR,
"basisofrecord" VARCHAR
);
CREATE TABLE glkn_vegetation_directbase_pre2009 (
"samplinground" VARCHAR,
"samplingyear" BIGINT,
"protocol_name" VARCHAR,
"park" VARCHAR,
"plot" BIGINT,
"samplingtype" VARCHAR,
"panel_type" VARCHAR,
"location_status" VARCHAR,
"habitat" VARCHAR,
"transect" BIGINT,
"transectlength_inmeters" BIGINT,
"sampledtransectlength_inmeters" BIGINT,
"sampled" VARCHAR,
"quadrat_inmeters" BIGINT,
"quadsampled" VARCHAR,
"accepted_latinname" VARCHAR,
"vegtype" VARCHAR,
"isbrowsepresent" VARCHAR,
"type" VARCHAR,
"basisofrecord" VARCHAR
);
CREATE TABLE glkn_vegetation_forestcanopy (
"samplinground" VARCHAR,
"samplingyear" BIGINT,
"protocol_name" VARCHAR,
"park" VARCHAR,
"plot" BIGINT,
"samplingtype" VARCHAR,
"panel_type" VARCHAR,
"location_status" VARCHAR,
"habitat" VARCHAR,
"canopylayer" VARCHAR,
"sampled" VARCHAR,
"canopylayercover" VARCHAR,
"vegtype" VARCHAR,
"accepted_latinname" VARCHAR,
"speciescover" VARCHAR,
"type" VARCHAR,
"basisofrecord" VARCHAR
);
CREATE TABLE glkn_vegetation_forestcanopy_pre2010 (
"samplinground" VARCHAR,
"samplingyear" BIGINT,
"protocol_name" VARCHAR,
"park" VARCHAR,
"plot" BIGINT,
"samplingtype" VARCHAR,
"panel_type" VARCHAR,
"location_status" VARCHAR,
"habitat" VARCHAR,
"accepted_latinname" VARCHAR,
"vegtype" VARCHAR,
"cover_inpercent" BIGINT,
"type" VARCHAR,
"basisofrecord" VARCHAR
);
CREATE TABLE glkn_vegetation_groundlayer (
"samplinground" VARCHAR,
"samplingyear" BIGINT,
"protocol_name" VARCHAR,
"park" VARCHAR,
"plot" BIGINT,
"samplingtype" VARCHAR,
"panel_type" VARCHAR,
"location_status" VARCHAR,
"habitat" VARCHAR,
"transect" DOUBLE,
"transectlength_inmeters" BIGINT,
"sampledtransectlength_inmeters" BIGINT,
"sampled" VARCHAR,
"quadrat_inmeters" BIGINT,
"quadsampled" VARCHAR,
"accepted_latinname" VARCHAR,
"vegtype" VARCHAR,
"present" VARCHAR,
"sapling_count" VARCHAR,
"type" VARCHAR,
"basisofrecord" VARCHAR
);
CREATE TABLE glkn_vegetation_indirectbase (
"samplinground" VARCHAR,
"samplingyear" BIGINT,
"protocol_name" VARCHAR,
"park" VARCHAR,
"plot" BIGINT,
"samplingtype" VARCHAR,
"panel_type" VARCHAR,
"location_status" VARCHAR,
"habitat" VARCHAR,
"transect" DOUBLE,
"transectlength_inmeters" BIGINT,
"sampledtransectlength_inmeters" BIGINT,
"sampled" VARCHAR,
"quadrat_inmeters" BIGINT,
"quadsampled" VARCHAR,
"accepted_latinname" VARCHAR,
"vegtype" VARCHAR,
"maxheight_incentimeters" VARCHAR,
"maxtype" VARCHAR,
"numunbrowsednonreprod" VARCHAR,
"numunbrowsedreprod" VARCHAR,
"numbrowsed" VARCHAR,
"isbrowsepresent" VARCHAR,
"isreproductionpresent" VARCHAR,
"type" VARCHAR,
"basisofrecord" VARCHAR
);
CREATE TABLE glkn_vegetation_shrubs (
"samplinground" VARCHAR,
"samplingyear" BIGINT,
"protocol_name" VARCHAR,
"park" VARCHAR,
"plot" BIGINT,
"samplingtype" VARCHAR,
"panel_type" VARCHAR,
"location_status" VARCHAR,
"habitat" VARCHAR,
"transect" BIGINT,
"transectlength_inmeters" BIGINT,
"sampledtransectlength_inmeters" BIGINT,
"sampled" VARCHAR,
"shrubcircle" BIGINT,
"circlesampled" VARCHAR,
"accepted_latinname" VARCHAR,
"vegtype" VARCHAR,
"cover_inpercent" VARCHAR,
"numindividuals" VARCHAR,
"type" VARCHAR,
"basisofrecord" VARCHAR
);
CREATE TABLE glkn_vegetation_walkthrough (
"samplinground" VARCHAR,
"samplingyear" BIGINT,
"protocol_name" VARCHAR,
"park" VARCHAR,
"plot" BIGINT,
"samplingtype" VARCHAR,
"panel_type" VARCHAR,
"location_status" VARCHAR,
"habitat" VARCHAR,
"accepted_latinname" VARCHAR,
"vegtype" VARCHAR,
"type" VARCHAR,
"basisofrecord" VARCHAR
);
Anyone who has the link will be able to view this.