European Alps Snow Depth Observations
Spatial and Long-term Trends 1971-2019
@kaggle.thedevastator_european_alps_snow_depth_observations
Spatial and Long-term Trends 1971-2019
@kaggle.thedevastator_european_alps_snow_depth_observations
CREATE TABLE data_daily_de_dwd (
"provider" VARCHAR,
"name" VARCHAR,
"date" TIMESTAMP,
"hn" DOUBLE,
"hs" DOUBLE,
"hn_after_qc" DOUBLE,
"hs_after_qc" DOUBLE,
"hs_after_gapfill" DOUBLE
);
CREATE TABLE data_daily_fr_meteofrance (
"provider" VARCHAR,
"name" VARCHAR,
"date" TIMESTAMP,
"hn" DOUBLE,
"hs" DOUBLE,
"hn_after_qc" DOUBLE,
"hs_after_qc" DOUBLE,
"hs_after_gapfill" DOUBLE
);
CREATE TABLE data_daily_it_bz (
"provider" VARCHAR,
"name" VARCHAR,
"date" TIMESTAMP,
"hn" DOUBLE,
"hs" DOUBLE,
"hn_after_qc" DOUBLE,
"hs_after_qc" DOUBLE,
"hs_after_gapfill" DOUBLE
);
CREATE TABLE data_daily_it_fvg (
"provider" VARCHAR,
"name" VARCHAR,
"date" TIMESTAMP,
"hn" DOUBLE,
"hs" DOUBLE,
"hn_after_qc" DOUBLE,
"hs_after_qc" DOUBLE,
"hs_after_gapfill" DOUBLE
);
CREATE TABLE data_daily_it_lombardia (
"provider" VARCHAR,
"name" VARCHAR,
"date" TIMESTAMP,
"hn" DOUBLE,
"hs" DOUBLE,
"hn_after_qc" DOUBLE,
"hs_after_qc" DOUBLE,
"hs_after_gapfill" DOUBLE
);
CREATE TABLE data_daily_it_tn (
"provider" VARCHAR,
"name" VARCHAR,
"date" TIMESTAMP,
"hn" DOUBLE,
"hs" DOUBLE,
"hn_after_qc" DOUBLE,
"hs_after_qc" DOUBLE,
"hs_after_gapfill" DOUBLE
);
CREATE TABLE data_daily_it_vda_cf (
"provider" VARCHAR,
"name" VARCHAR,
"date" TIMESTAMP,
"hn" VARCHAR,
"hs" DOUBLE,
"hn_after_qc" VARCHAR,
"hs_after_qc" DOUBLE,
"hs_after_gapfill" DOUBLE
);
CREATE TABLE data_monthly_at_hzb (
"name" VARCHAR,
"year" BIGINT,
"month" BIGINT,
"hnsum" DOUBLE,
"hsmean" DOUBLE,
"hsmax" DOUBLE,
"scd1" DOUBLE,
"scd1gt" DOUBLE,
"scd10" DOUBLE,
"scd20" DOUBLE,
"scd30" DOUBLE,
"scd50" DOUBLE,
"scd100" DOUBLE,
"hsmean_gapfill" DOUBLE,
"frac_gapfilled" DOUBLE,
"hsmax_gapfill" DOUBLE,
"scd1_gapfill" DOUBLE,
"scd1gt_gapfill" DOUBLE,
"scd10_gapfill" DOUBLE,
"scd20_gapfill" DOUBLE,
"scd30_gapfill" DOUBLE,
"scd50_gapfill" DOUBLE,
"scd100_gapfill" DOUBLE
);
CREATE TABLE data_monthly_ch_meteoswiss (
"name" VARCHAR,
"year" BIGINT,
"month" BIGINT,
"hnsum" DOUBLE,
"hsmean" DOUBLE,
"hsmax" DOUBLE,
"scd1" DOUBLE,
"scd1gt" DOUBLE,
"scd10" DOUBLE,
"scd20" DOUBLE,
"scd30" DOUBLE,
"scd50" DOUBLE,
"scd100" DOUBLE,
"hsmean_gapfill" DOUBLE,
"frac_gapfilled" DOUBLE,
"hsmax_gapfill" DOUBLE,
"scd1_gapfill" DOUBLE,
"scd1gt_gapfill" DOUBLE,
"scd10_gapfill" DOUBLE,
"scd20_gapfill" DOUBLE,
"scd30_gapfill" DOUBLE,
"scd50_gapfill" DOUBLE,
"scd100_gapfill" DOUBLE
);
CREATE TABLE data_monthly_ch_slf (
"name" VARCHAR,
"year" BIGINT,
"month" BIGINT,
"hnsum" DOUBLE,
"hsmean" DOUBLE,
"hsmax" DOUBLE,
"scd1" DOUBLE,
"scd1gt" DOUBLE,
"scd10" DOUBLE,
"scd20" DOUBLE,
"scd30" DOUBLE,
"scd50" DOUBLE,
"scd100" DOUBLE,
"hsmean_gapfill" DOUBLE,
"frac_gapfilled" DOUBLE,
"hsmax_gapfill" DOUBLE,
"scd1_gapfill" DOUBLE,
"scd1gt_gapfill" DOUBLE,
"scd10_gapfill" DOUBLE,
"scd20_gapfill" DOUBLE,
"scd30_gapfill" DOUBLE,
"scd50_gapfill" DOUBLE,
"scd100_gapfill" DOUBLE
);
CREATE TABLE data_monthly_de_dwd (
"name" VARCHAR,
"year" BIGINT,
"month" BIGINT,
"hnsum" DOUBLE,
"hsmean" DOUBLE,
"hsmax" DOUBLE,
"scd1" DOUBLE,
"scd1gt" DOUBLE,
"scd10" DOUBLE,
"scd20" DOUBLE,
"scd30" DOUBLE,
"scd50" DOUBLE,
"scd100" DOUBLE,
"hsmean_gapfill" DOUBLE,
"frac_gapfilled" DOUBLE,
"hsmax_gapfill" DOUBLE,
"scd1_gapfill" DOUBLE,
"scd1gt_gapfill" DOUBLE,
"scd10_gapfill" DOUBLE,
"scd20_gapfill" DOUBLE,
"scd30_gapfill" DOUBLE,
"scd50_gapfill" DOUBLE,
"scd100_gapfill" DOUBLE
);
CREATE TABLE data_monthly_fr_meteofrance (
"name" VARCHAR,
"year" BIGINT,
"month" BIGINT,
"hnsum" DOUBLE,
"hsmean" DOUBLE,
"hsmax" DOUBLE,
"scd1" DOUBLE,
"scd1gt" DOUBLE,
"scd10" DOUBLE,
"scd20" DOUBLE,
"scd30" DOUBLE,
"scd50" DOUBLE,
"scd100" DOUBLE,
"hsmean_gapfill" DOUBLE,
"frac_gapfilled" DOUBLE,
"hsmax_gapfill" DOUBLE,
"scd1_gapfill" DOUBLE,
"scd1gt_gapfill" DOUBLE,
"scd10_gapfill" DOUBLE,
"scd20_gapfill" DOUBLE,
"scd30_gapfill" DOUBLE,
"scd50_gapfill" DOUBLE,
"scd100_gapfill" DOUBLE
);
CREATE TABLE data_monthly_it_bz (
"name" VARCHAR,
"year" BIGINT,
"month" BIGINT,
"hnsum" DOUBLE,
"hsmean" DOUBLE,
"hsmax" DOUBLE,
"scd1" DOUBLE,
"scd1gt" DOUBLE,
"scd10" DOUBLE,
"scd20" DOUBLE,
"scd30" DOUBLE,
"scd50" DOUBLE,
"scd100" DOUBLE,
"hsmean_gapfill" DOUBLE,
"frac_gapfilled" DOUBLE,
"hsmax_gapfill" DOUBLE,
"scd1_gapfill" DOUBLE,
"scd1gt_gapfill" DOUBLE,
"scd10_gapfill" DOUBLE,
"scd20_gapfill" DOUBLE,
"scd30_gapfill" DOUBLE,
"scd50_gapfill" DOUBLE,
"scd100_gapfill" DOUBLE
);
CREATE TABLE data_monthly_it_fvg (
"name" VARCHAR,
"year" BIGINT,
"month" BIGINT,
"hnsum" DOUBLE,
"hsmean" DOUBLE,
"hsmax" DOUBLE,
"scd1" DOUBLE,
"scd1gt" DOUBLE,
"scd10" DOUBLE,
"scd20" DOUBLE,
"scd30" DOUBLE,
"scd50" DOUBLE,
"scd100" DOUBLE,
"hsmean_gapfill" DOUBLE,
"frac_gapfilled" DOUBLE,
"hsmax_gapfill" DOUBLE,
"scd1_gapfill" DOUBLE,
"scd1gt_gapfill" DOUBLE,
"scd10_gapfill" DOUBLE,
"scd20_gapfill" DOUBLE,
"scd30_gapfill" DOUBLE,
"scd50_gapfill" DOUBLE,
"scd100_gapfill" DOUBLE
);
CREATE TABLE data_monthly_it_lombardia (
"name" VARCHAR,
"year" BIGINT,
"month" BIGINT,
"hnsum" DOUBLE,
"hsmean" DOUBLE,
"hsmax" DOUBLE,
"scd1" DOUBLE,
"scd1gt" DOUBLE,
"scd10" DOUBLE,
"scd20" DOUBLE,
"scd30" DOUBLE,
"scd50" DOUBLE,
"scd100" DOUBLE,
"hsmean_gapfill" DOUBLE,
"frac_gapfilled" DOUBLE,
"hsmax_gapfill" DOUBLE,
"scd1_gapfill" DOUBLE,
"scd1gt_gapfill" DOUBLE,
"scd10_gapfill" DOUBLE,
"scd20_gapfill" DOUBLE,
"scd30_gapfill" DOUBLE,
"scd50_gapfill" DOUBLE,
"scd100_gapfill" DOUBLE
);
CREATE TABLE data_monthly_it_tn (
"name" VARCHAR,
"year" BIGINT,
"month" BIGINT,
"hnsum" DOUBLE,
"hsmean" DOUBLE,
"hsmax" DOUBLE,
"scd1" DOUBLE,
"scd1gt" DOUBLE,
"scd10" DOUBLE,
"scd20" DOUBLE,
"scd30" DOUBLE,
"scd50" DOUBLE,
"scd100" DOUBLE,
"hsmean_gapfill" DOUBLE,
"frac_gapfilled" DOUBLE,
"hsmax_gapfill" DOUBLE,
"scd1_gapfill" DOUBLE,
"scd1gt_gapfill" DOUBLE,
"scd10_gapfill" DOUBLE,
"scd20_gapfill" DOUBLE,
"scd30_gapfill" DOUBLE,
"scd50_gapfill" DOUBLE,
"scd100_gapfill" DOUBLE
);
CREATE TABLE data_monthly_it_vda_cf (
"name" VARCHAR,
"year" BIGINT,
"month" BIGINT,
"hnsum" VARCHAR,
"hsmean" DOUBLE,
"hsmax" DOUBLE,
"scd1" DOUBLE,
"scd1gt" DOUBLE,
"scd10" DOUBLE,
"scd20" DOUBLE,
"scd30" DOUBLE,
"scd50" DOUBLE,
"scd100" DOUBLE,
"hsmean_gapfill" DOUBLE,
"frac_gapfilled" DOUBLE,
"hsmax_gapfill" DOUBLE,
"scd1_gapfill" DOUBLE,
"scd1gt_gapfill" DOUBLE,
"scd10_gapfill" DOUBLE,
"scd20_gapfill" DOUBLE,
"scd30_gapfill" DOUBLE,
"scd50_gapfill" DOUBLE,
"scd100_gapfill" DOUBLE
);
CREATE TABLE data_monthly_it_veneto (
"name" VARCHAR,
"year" BIGINT,
"month" BIGINT,
"hnsum" DOUBLE,
"hsmean" DOUBLE,
"hsmax" DOUBLE,
"scd1" DOUBLE,
"scd1gt" DOUBLE,
"scd10" DOUBLE,
"scd20" DOUBLE,
"scd30" DOUBLE,
"scd50" DOUBLE,
"scd100" DOUBLE,
"hsmean_gapfill" DOUBLE,
"frac_gapfilled" DOUBLE,
"hsmax_gapfill" DOUBLE,
"scd1_gapfill" DOUBLE,
"scd1gt_gapfill" DOUBLE,
"scd10_gapfill" DOUBLE,
"scd20_gapfill" DOUBLE,
"scd30_gapfill" DOUBLE,
"scd50_gapfill" DOUBLE,
"scd100_gapfill" DOUBLE
);
CREATE TABLE data_monthly_si_arso (
"name" VARCHAR,
"year" BIGINT,
"month" BIGINT,
"hnsum" DOUBLE,
"hsmean" DOUBLE,
"hsmax" DOUBLE,
"scd1" DOUBLE,
"scd1gt" DOUBLE,
"scd10" DOUBLE,
"scd20" DOUBLE,
"scd30" DOUBLE,
"scd50" DOUBLE,
"scd100" DOUBLE,
"hsmean_gapfill" DOUBLE,
"frac_gapfilled" DOUBLE,
"hsmax_gapfill" DOUBLE,
"scd1_gapfill" DOUBLE,
"scd1gt_gapfill" DOUBLE,
"scd10_gapfill" DOUBLE,
"scd20_gapfill" DOUBLE,
"scd30_gapfill" DOUBLE,
"scd50_gapfill" DOUBLE,
"scd100_gapfill" DOUBLE
);
CREATE TABLE meta_all (
"provider" VARCHAR,
"name" VARCHAR,
"longitude" DOUBLE,
"latitude" DOUBLE,
"elevation" DOUBLE,
"hn_year_start" DOUBLE,
"hn_year_end" DOUBLE,
"hs_year_start" DOUBLE,
"hs_year_end" DOUBLE
);
Anyone who has the link will be able to view this.