Port Susan Buoy Raw Data Output (Dec 20, 2023 - Present)
King County, Washington
@usgov.king_county_washington_port_susan_buoy_raw_output_dec__0d9a7e0f
King County, Washington
@usgov.king_county_washington_port_susan_buoy_raw_output_dec__0d9a7e0f
CREATE TABLE table_1 (
"unixtimestamp" BIGINT,
"date_america_los_angeles" TIMESTAMP,
"time_america_los_angeles" VARCHAR,
"winddirection" DOUBLE,
"windspeed" DOUBLE,
"systembattery" DOUBLE,
"hcep_temp" DOUBLE,
"hcep_cond" DOUBLE,
"hcep_pres" DOUBLE,
"hcep_oxy" DOUBLE,
"hcep_ph" DOUBLE,
"hcep_fl" DOUBLE,
"hcep_turb" DOUBLE,
"hcep_fsd" DOUBLE,
"hcep_tsd" DOUBLE,
"hcep_sal" DOUBLE,
"hcep_sndv" DOUBLE,
"hcep_spc" DOUBLE,
"hcep_osat" DOUBLE,
"hcep_volt" DOUBLE,
"hcep_num" DOUBLE,
"suna_m_parameter1" DOUBLE,
"suna_m_parameter2" DOUBLE,
"suna_m_parameter3" DOUBLE,
"suna_m_parameter4" DOUBLE,
"hcep_err" DOUBLE,
"par_par_sq_421x" DOUBLE,
"wtx534_temp" DOUBLE,
"wtx534_humidity" DOUBLE,
"wtx534_pressure" DOUBLE
);
Anyone who has the link will be able to view this.