Pilot Terrestrial Vegetation Monitoring In The Southeastern United States, 2009-2010 - Data Package
Department of the Interior
@usgov.doi_gov_pilot_terrestrial_vegetation_monitoring_in_the_df04b17c
Department of the Interior
@usgov.doi_gov_pilot_terrestrial_vegetation_monitoring_in_the_df04b17c
CREATE TABLE secn_vegetation_shrubs (
"park_name" VARCHAR,
"park_code" VARCHAR,
"type" VARCHAR,
"basisofrecord" VARCHAR,
"start_date" TIMESTAMP,
"scientificname" VARCHAR,
"scientificname_flag" VARCHAR,
"taxonrank" VARCHAR,
"verbatimidentification" VARCHAR,
"custom_coverinpercent" VARCHAR,
"location_name" VARCHAR,
"custom_shrubplot" VARCHAR
);
CREATE TABLE secn_vegetation_canopy (
"park_name" VARCHAR,
"park_code" VARCHAR,
"type" VARCHAR,
"basisofrecord" VARCHAR,
"start_date" TIMESTAMP,
"canopy_id" BIGINT,
"location_name" VARCHAR,
"custom_cardinaldirectionofobservationpoint" VARCHAR,
"custom_coverinpercent" VARCHAR,
"custom_coverinpercent_flag" VARCHAR
);
CREATE TABLE secn_vegetation_locations (
"park_name" VARCHAR,
"park_code" VARCHAR,
"location_name" VARCHAR,
"type" VARCHAR,
"basisofrecord" VARCHAR
);
CREATE TABLE secn_vegetation_events (
"park_name" VARCHAR,
"park_code" VARCHAR,
"type" VARCHAR,
"basisofrecord" VARCHAR,
"start_date" TIMESTAMP,
"location_name" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE secn_vegetation_frequency (
"park_name" VARCHAR,
"park_code" VARCHAR,
"type" VARCHAR,
"basisofrecord" VARCHAR,
"start_date" TIMESTAMP,
"scientificname" VARCHAR,
"scientificname_flag" VARCHAR,
"taxonrank" VARCHAR,
"verbatimidentification" VARCHAR,
"substrate" VARCHAR,
"custom_nestedfrequency1" VARCHAR,
"custom_nestedfrequency2" VARCHAR,
"custom_nestedfrequency3" VARCHAR,
"custom_nestedfrequency3_flag" VARCHAR,
"custom_coverinpercent" VARCHAR,
"custom_coverinpercent_flag" VARCHAR,
"custom_seedlingcount" VARCHAR,
"location_name" VARCHAR,
"custom_groundcoverplot" BIGINT
);
CREATE TABLE secn_vegetation_treedbh (
"park_name" VARCHAR,
"park_code" VARCHAR,
"type" VARCHAR,
"basisofrecord" VARCHAR,
"start_date" TIMESTAMP,
"status" VARCHAR,
"scientificname" VARCHAR,
"scientificname_flag" VARCHAR,
"taxonrank" VARCHAR,
"verbatimidentification" VARCHAR,
"dbh0_60incentimeter" VARCHAR,
"dbh120_180incentimeter" VARCHAR,
"dbh240_300incentimeter" VARCHAR,
"location_name" VARCHAR
);
Anyone who has the link will be able to view this.