NCBN Estuarine Nutrient Enrichment Tier-3 Seagrass Monitoring Data 2003-2024 (Certified)
Department of the Interior
@usgov.doi_gov_ncbn_estuarine_nutrient_enrichment_tier_3_seag_e528eb79
Department of the Interior
@usgov.doi_gov_ncbn_estuarine_nutrient_enrichment_tier_3_seag_e528eb79
CREATE TABLE ncbn_tier3_seagrass_data_certified_2024 (
"id" BIGINT,
"eventid" VARCHAR,
"location" VARCHAR,
"sgnetcode" VARCHAR,
"transect" VARCHAR,
"quadrat" BIGINT,
"species" VARCHAR,
"date" TIMESTAMP,
"time" VARCHAR,
"percent_cover" DOUBLE,
"density_source" VARCHAR,
"density_zm" DOUBLE,
"shoot_density" DOUBLE,
"canopy_height" DOUBLE,
"flowers" DOUBLE,
"fruits" DOUBLE,
"shoot_count" DOUBLE,
"biomass" DOUBLE,
"biomass_stems" DOUBLE,
"biomass_roots" DOUBLE,
"grazing_evidence" VARCHAR,
"epiphytes" VARCHAR,
"wasting" VARCHAR,
"tidal_depth" VARCHAR,
"distance_to_edge_left" DOUBLE,
"distance_to_edge_center" DOUBLE,
"distance_to_edge_right" DOUBLE,
"distance_to_last_shoot_left" DOUBLE,
"distance_to_last_shoot_center" DOUBLE,
"distance_to_last_shoot_right" DOUBLE,
"salinity" DOUBLE,
"sediment_type_left" VARCHAR,
"sediment_type_center" VARCHAR,
"sediment_type_right" VARCHAR,
"qc_notes" VARCHAR,
"certified_by" VARCHAR,
"certified_date" TIMESTAMP,
"data_source" VARCHAR
);
Anyone who has the link will be able to view this.