Pacific Marine Energy Center Benthic Physical Conditions, Macrofauna, And Groundfish Abundances
Department of Energy
@usgov.doe_gov_pacific_marine_energy_center_benthic_physical__71a3d6eb
Department of Energy
@usgov.doe_gov_pacific_marine_energy_center_benthic_physical__71a3d6eb
CREATE TABLE pmec_box_cores_physical_data (
"unnamed_0" VARCHAR,
"depthbin" BIGINT,
"year" BIGINT,
"month" BIGINT,
"n__lon" DOUBLE,
"n__lat" DOUBLE,
"site" BIGINT,
"depth_m" DOUBLE,
"penetration_cm" DOUBLE,
"temp_deg_c" DOUBLE,
"do_ml_l" DOUBLE,
"salinity_psu" DOUBLE,
"fluorescence_mg_m_3" DOUBLE,
"ph" DOUBLE,
"turbidity_ntu" DOUBLE,
"silt_clay" DOUBLE,
"sand" DOUBLE,
"mediangs" DOUBLE,
"pdo" DOUBLE,
"noi" DOUBLE,
"mei" DOUBLE,
"upwelling" BIGINT,
"regime" BIGINT
);
CREATE TABLE pmec_trawls_physical_data (
"sampleid" VARCHAR,
"year" BIGINT,
"month" BIGINT,
"haul" BIGINT,
"station" VARCHAR,
"startlat" DOUBLE,
"startlon" DOUBLE,
"duration_min" DOUBLE,
"trawl_m2" BIGINT,
"start_depth_m" DOUBLE,
"bottom_temp_deg_c" DOUBLE,
"bottom_do_ml_l" DOUBLE,
"bottom_salinity_psu" DOUBLE,
"bottom_fluor_mg_m_3" DOUBLE,
"bottom_ph" DOUBLE,
"bottom_turbidity_ntu" DOUBLE,
"pdo" DOUBLE,
"noi" DOUBLE,
"mei" DOUBLE
);
Anyone who has the link will be able to view this.