PACN Weather Monitoring Dataset
Department of the Interior
@usgov.doi_gov_pacn_weather_monitoring_dataset
Department of the Interior
@usgov.doi_gov_pacn_weather_monitoring_dataset
CREATE TABLE pacn_wrcc_station_data_amme_2012_2024 (
"n" VARCHAR,
"n__lst" VARCHAR,
"n__in" VARCHAR,
"n__mph" VARCHAR,
"n__deg" VARCHAR,
"n__deg_1" VARCHAR,
"deg_f" VARCHAR,
"n_02e762" VARCHAR,
"volts" VARCHAR,
"n__mph_1" VARCHAR,
"n__deg_2" VARCHAR,
"n__mph_2" VARCHAR,
"deg_f_1" VARCHAR,
"deg_f_2" VARCHAR,
"n__1" VARCHAR,
"n__2" VARCHAR,
"n__3" VARCHAR,
"n__in_1" VARCHAR,
"n__ly" VARCHAR,
"deg_f_3" VARCHAR,
"deg_f_4" VARCHAR,
"deg_f_5" VARCHAR,
"deg_f_6" VARCHAR,
"n__4" VARCHAR,
"volts_1" VARCHAR,
"volts_2" VARCHAR,
"deg_f_7" VARCHAR
);
CREATE TABLE pacn_wrcc_station_data_havo_kahuku_2012_2024 (
"n" VARCHAR,
"n__lst" VARCHAR,
"n__in" VARCHAR,
"n__mph" VARCHAR,
"n__deg" VARCHAR,
"deg_f" VARCHAR,
"deg_f_1" VARCHAR,
"n_02e762" VARCHAR,
"volts" VARCHAR,
"n__1" VARCHAR,
"n__deg_1" VARCHAR,
"n__mph_1" VARCHAR,
"deg_f_2" VARCHAR,
"deg_f_3" VARCHAR,
"n__2" VARCHAR,
"n__3" VARCHAR,
"n__ly" VARCHAR
);
CREATE TABLE pacn_wrcc_station_data_havo_kahuku_lower_2012_2024 (
"n" VARCHAR,
"n__lst" VARCHAR,
"n__in" VARCHAR,
"n__mph" VARCHAR,
"n__deg" VARCHAR,
"deg_f" VARCHAR,
"n_02e762" VARCHAR,
"volts" VARCHAR,
"n__deg_1" VARCHAR,
"n__mph_1" VARCHAR,
"n__ly" VARCHAR,
"deg_f_1" VARCHAR,
"deg_f_2" VARCHAR,
"deg_f_3" VARCHAR,
"deg_f_4" VARCHAR,
"deg_f_5" VARCHAR,
"deg_f_6" VARCHAR
);
CREATE TABLE pacn_wrcc_station_data_havo_kealakomo_2012_2024 (
"n" VARCHAR,
"n__lst" VARCHAR,
"n__in" VARCHAR,
"n__mph" VARCHAR,
"n__deg" VARCHAR,
"deg_f" VARCHAR,
"deg_f_1" VARCHAR,
"n_02e762" VARCHAR,
"volts" VARCHAR,
"n__1" VARCHAR,
"n__deg_1" VARCHAR,
"n__mph_1" VARCHAR,
"deg_f_2" VARCHAR,
"deg_f_3" VARCHAR,
"n__2" VARCHAR,
"n__3" VARCHAR,
"n__ly" VARCHAR
);
CREATE TABLE pacn_wrcc_station_data_havo_nene_cabin_2012_2024 (
"n" VARCHAR,
"n__lst" VARCHAR,
"n__in" VARCHAR,
"n__mph" VARCHAR,
"n__deg" VARCHAR,
"deg_f" VARCHAR,
"n_02e762" VARCHAR,
"volts" VARCHAR,
"n__deg_1" VARCHAR,
"n__mph_1" VARCHAR,
"n__ly" VARCHAR,
"deg_f_1" VARCHAR,
"deg_f_2" VARCHAR,
"deg_f_3" VARCHAR,
"deg_f_4" VARCHAR,
"deg_f_5" VARCHAR,
"deg_f_6" VARCHAR
);
CREATE TABLE pacn_wrcc_station_data_havo_pali_2_2012_2024 (
"n" VARCHAR,
"n__lst" VARCHAR,
"n__in" VARCHAR,
"n__mph" VARCHAR,
"n__deg" VARCHAR,
"deg_f" VARCHAR,
"deg_f_1" VARCHAR,
"n_02e762" VARCHAR,
"volts" VARCHAR,
"n__deg_1" VARCHAR,
"n__mph_1" VARCHAR,
"deg_f_2" VARCHAR,
"deg_f_3" VARCHAR,
"n__1" VARCHAR,
"n__2" VARCHAR,
"n__ly" VARCHAR
);
CREATE TABLE pacn_wrcc_station_data_kaho_2012_2024 (
"n" VARCHAR,
"n__lst" VARCHAR,
"n__in" VARCHAR,
"n__mph" VARCHAR,
"n__deg" VARCHAR,
"deg_f" VARCHAR,
"deg_f_1" VARCHAR,
"n_02e762" VARCHAR,
"volts" VARCHAR,
"in_hg" VARCHAR,
"n__1" VARCHAR,
"n__deg_1" VARCHAR,
"n__mph_1" VARCHAR,
"n__ly" VARCHAR
);
CREATE TABLE pacn_wrcc_station_data_kala_makapulapai_2012_2024 (
"n" VARCHAR,
"n__lst" VARCHAR,
"n__in" VARCHAR,
"n__mph" VARCHAR,
"n__deg" VARCHAR,
"deg_f" VARCHAR,
"deg_f_1" VARCHAR,
"n_02e762" VARCHAR,
"volts" VARCHAR,
"n__1" VARCHAR,
"n__deg_1" VARCHAR,
"n__mph_1" VARCHAR,
"deg_f_2" VARCHAR,
"deg_f_3" VARCHAR,
"n__2" VARCHAR,
"n__3" VARCHAR,
"n__ly" VARCHAR
);
CREATE TABLE pacn_wrcc_station_data_npsa_siufaga_ridge_2012_2024 (
"n" VARCHAR,
"n__lst" VARCHAR,
"n__in" VARCHAR,
"n__mph" VARCHAR,
"n__deg" VARCHAR,
"deg_f" VARCHAR,
"n_02e762" VARCHAR,
"volts" VARCHAR,
"n__deg_1" VARCHAR,
"n__mph_1" VARCHAR,
"n__ly" VARCHAR,
"deg_f_1" VARCHAR,
"deg_f_2" VARCHAR,
"deg_f_3" VARCHAR,
"deg_f_4" VARCHAR,
"deg_f_5" VARCHAR,
"deg_f_6" VARCHAR
);
CREATE TABLE pacn_wrcc_station_data_npsa_toa_ridge_2012_2024 (
"n" VARCHAR,
"n__lst" VARCHAR,
"n__in" VARCHAR,
"n__mph" VARCHAR,
"n__deg" VARCHAR,
"deg_f" VARCHAR,
"n_02e762" VARCHAR,
"volts" VARCHAR,
"n__deg_1" VARCHAR,
"n__mph_1" VARCHAR,
"n__ly" VARCHAR,
"deg_f_1" VARCHAR,
"deg_f_2" VARCHAR,
"deg_f_3" VARCHAR,
"deg_f_4" VARCHAR,
"deg_f_5" VARCHAR,
"deg_f_6" VARCHAR
);
CREATE TABLE pacn_wrcc_station_data_puhe_2012_2024 (
"n" VARCHAR,
"n__lst" VARCHAR,
"n__in" VARCHAR,
"n__mph" VARCHAR,
"n__deg" VARCHAR,
"deg_f" VARCHAR,
"n_02e762" VARCHAR,
"volts" VARCHAR,
"n__deg_1" VARCHAR,
"n__mph_1" VARCHAR,
"n__ly" VARCHAR,
"deg_f_1" VARCHAR,
"deg_f_2" VARCHAR,
"deg_f_3" VARCHAR,
"deg_f_4" VARCHAR,
"deg_f_5" VARCHAR
);
CREATE TABLE pacn_wrcc_station_data_puho_2012_2024 (
"n" VARCHAR,
"n__lst" VARCHAR,
"n__in" VARCHAR,
"n__mph" VARCHAR,
"n__deg" VARCHAR,
"deg_f" VARCHAR,
"n_02e762" VARCHAR,
"volts" VARCHAR,
"n__deg_1" VARCHAR,
"n__mph_1" VARCHAR,
"n__ly" VARCHAR,
"deg_f_1" VARCHAR,
"deg_f_2" VARCHAR,
"deg_f_3" VARCHAR
);
Anyone who has the link will be able to view this.