Modeling Potential Changes In Seagrass Coverage, Biomass And Vulnerability Under Increased Temperature
Department of the Interior
@usgov.doi_gov_modeling_potential_changes_in_seagrass_coverag_21c8cd1e
Department of the Interior
@usgov.doi_gov_modeling_potential_changes_in_seagrass_coverag_21c8cd1e
CREATE TABLE caco_pb_ls_meansst_2013_2019 (
"location" VARCHAR,
"year" BIGINT,
"day_of_year" BIGINT,
"date" TIMESTAMP,
"temp_c" DOUBLE
);
CREATE TABLE caco_pb_tier2_eelgrass_survey_data_2006_2019 (
"year" BIGINT,
"hexagon" BIGINT,
"northing_coord" DOUBLE,
"easting_coord" DOUBLE,
"date" VARCHAR,
"species" VARCHAR,
"percent_cover" DOUBLE,
"canopy_height" DOUBLE,
"seagrass_presence" BIGINT,
"percent_fine_sediment" DOUBLE,
"sediment_type" VARCHAR,
"depth_m" DOUBLE
);
CREATE TABLE caco_pb_tier3_eelgrass_biomass_data_2003_2019 (
"year" BIGINT,
"date" TIMESTAMP,
"day_of_year" BIGINT,
"month" BIGINT,
"season" VARCHAR,
"transect" VARCHAR,
"quadrat" BIGINT,
"percent_cover" BIGINT,
"canopy_height_cm" DOUBLE,
"density_m2" DOUBLE,
"total_biomass_gm2" DOUBLE,
"ag_biomass_gm2" DOUBLE,
"leaf_biomass_gm2" DOUBLE,
"bg_biomass_gm2" DOUBLE,
"single_shoot_bio_g" DOUBLE,
"ratio_leaf_to_bg" DOUBLE,
"ratio_ag_to_bg" DOUBLE,
"sediment_type_center" VARCHAR,
"percent_clay" DOUBLE,
"percent_silt" DOUBLE,
"percent_sand" DOUBLE,
"percent_gravel" DOUBLE,
"percent_om" DOUBLE,
"depth_m" DOUBLE,
"depth_below_mhw_m" DOUBLE,
"depth_below_mtl_m" DOUBLE,
"depth_below_mlw_m" DOUBLE
);
CREATE TABLE read_me_caco_pb_kd_data_2007_2019 (
"station_type" VARCHAR,
"station_type_logging_station_continuous_logger_spatial_f9cd9bff" VARCHAR
);
CREATE TABLE read_me_caco_pb_ls_meansst_2013_2019 (
"location" VARCHAR,
"location_of_logger_ls_c_logging_station_in_seagrass_transect_c" VARCHAR
);
CREATE TABLE read_me_caco_pb_tier2_eelgrass_survey_data_2006_2019 (
"year" VARCHAR,
"year_of_sample" VARCHAR
);
CREATE TABLE read_me_caco_pb_tier3_eelgrass_biomass_data_2003_2019 (
"year" VARCHAR,
"year_of_sample" VARCHAR
);
Anyone who has the link will be able to view this.