MBARI WEC 2021 Deployment
Department of Energy
@usgov.doe_gov_mbari_wec_2021_deployment_a7dc1
Department of Energy
@usgov.doe_gov_mbari_wec_2021_deployment_a7dc1
CREATE TABLE sofar_spotter_buoy_data (
"battery_voltage_v" DOUBLE,
"power_w" DOUBLE,
"humidity_rel" DOUBLE,
"epoch_time" BIGINT,
"significant_wave_height_m" DOUBLE,
"peak_period_s" DOUBLE,
"mean_period_s" DOUBLE,
"peak_direction_deg" DOUBLE,
"peak_directional_spread_deg" DOUBLE,
"mean_direction_deg" DOUBLE,
"mean_directional_spread_deg" DOUBLE,
"latitude_deg" DOUBLE,
"longitude_deg" DOUBLE,
"f_0" DOUBLE,
"f_1" DOUBLE,
"f_2" DOUBLE,
"f_3" DOUBLE,
"f_4" DOUBLE,
"f_5" DOUBLE,
"f_6" DOUBLE,
"f_7" DOUBLE,
"f_8" DOUBLE,
"f_9" DOUBLE,
"f_10" DOUBLE,
"f_11" DOUBLE,
"f_12" DOUBLE,
"f_13" DOUBLE,
"f_14" DOUBLE,
"f_15" DOUBLE,
"f_16" DOUBLE,
"f_17" DOUBLE,
"f_18" DOUBLE,
"f_19" DOUBLE,
"f_20" DOUBLE,
"f_21" DOUBLE,
"f_22" DOUBLE,
"f_23" DOUBLE,
"f_24" DOUBLE,
"f_25" DOUBLE,
"f_26" DOUBLE,
"f_27" DOUBLE,
"f_28" DOUBLE,
"f_29" DOUBLE,
"f_30" DOUBLE,
"f_31" DOUBLE,
"f_32" DOUBLE,
"f_33" DOUBLE,
"f_34" DOUBLE,
"f_35" DOUBLE,
"f_36" DOUBLE,
"f_37" DOUBLE,
"f_38" DOUBLE,
"df_0" DOUBLE,
"df_1" DOUBLE,
"df_2" DOUBLE,
"df_3" DOUBLE,
"df_4" DOUBLE,
"df_5" DOUBLE,
"df_6" DOUBLE,
"df_7" DOUBLE,
"df_8" DOUBLE,
"df_9" DOUBLE,
"df_10" DOUBLE,
"df_11" DOUBLE,
"df_12" DOUBLE,
"df_13" DOUBLE,
"df_14" DOUBLE,
"df_15" DOUBLE,
"df_16" DOUBLE,
"df_17" DOUBLE,
"df_18" DOUBLE,
"df_19" DOUBLE,
"df_20" DOUBLE,
"df_21" DOUBLE,
"df_22" DOUBLE,
"df_23" DOUBLE,
"df_24" DOUBLE,
"df_25" DOUBLE,
"df_26" DOUBLE,
"df_27" DOUBLE,
"df_28" DOUBLE,
"df_29" DOUBLE,
"df_30" DOUBLE,
"df_31" DOUBLE,
"df_32" DOUBLE,
"df_33" DOUBLE,
"df_34" DOUBLE,
"df_35" DOUBLE,
"df_36" DOUBLE,
"df_37" DOUBLE,
"df_38" DOUBLE,
"a1_0" DOUBLE,
"a1_1" DOUBLE,
"a1_2" DOUBLE,
"a1_3" DOUBLE,
"a1_4" DOUBLE,
"a1_5" DOUBLE,
"a1_6" DOUBLE,
"a1_7" DOUBLE,
"a1_8" DOUBLE
);
Anyone who has the link will be able to view this.