Global Hotspots Of Sharks And Longline Fishing
Machine-Learning-Assisted Spatial Distribution of At-Risk Species
@kaggle.thedevastator_global_hotspots_of_sharks_and_longline_fishing
Machine-Learning-Assisted Spatial Distribution of At-Risk Species
@kaggle.thedevastator_global_hotspots_of_sharks_and_longline_fishing
CREATE TABLE n_1x1_count_all_rfmos_ll_effort_results (
"model" VARCHAR,
"effort_source" VARCHAR,
"rfmo" VARCHAR,
"rmse" DOUBLE,
"rsq" DOUBLE,
"mae" DOUBLE
);
CREATE TABLE n_1x1_mt_to_count_all_rfmos_ll_effort_results (
"model" VARCHAR,
"effort_source" VARCHAR,
"rfmo" VARCHAR,
"rmse" DOUBLE,
"rsq" DOUBLE,
"mae" DOUBLE
);
CREATE TABLE n_5x5_count_all_rfmos_ll_effort_results (
"model" VARCHAR,
"effort_source" VARCHAR,
"rfmo" VARCHAR,
"rmse" DOUBLE,
"rsq" DOUBLE,
"mae" DOUBLE
);
CREATE TABLE n_5x5_mt_to_count_all_rfmos_ll_effort_results (
"model" VARCHAR,
"effort_source" VARCHAR,
"rfmo" VARCHAR,
"rmse" DOUBLE,
"rsq" DOUBLE,
"mae" DOUBLE
);
CREATE TABLE iattc_ll_models_others_results (
"environmental_value" VARCHAR,
"include_ssh" BOOLEAN,
"price" VARCHAR,
"catch_transformation" VARCHAR,
"mtry_class" BIGINT,
"min_n_class" BIGINT,
"mtry_reg" BIGINT,
"min_n_reg" BIGINT,
"rmse" DOUBLE,
"rsq" DOUBLE,
"mae" DOUBLE
);
CREATE TABLE iattc_ll_untuned_final_predict (
"n__pred_class" BIGINT,
"pres_abs" VARCHAR,
"catch" DOUBLE,
"rfmo" VARCHAR,
"year" BIGINT,
"latitude" DOUBLE,
"longitude" DOUBLE,
"species_sciname" VARCHAR,
"gear_group" VARCHAR,
"spatial_notes" VARCHAR,
"species_commonname" VARCHAR,
"species_group" VARCHAR,
"species_resolution" VARCHAR,
"median_price_group" DOUBLE,
"median_price_species" DOUBLE,
"catch_units" VARCHAR,
"original_effort" DOUBLE,
"sdm" DOUBLE,
"zone" VARCHAR,
"location_cluster" BIGINT,
"target_effort" DOUBLE,
"target_effort_belize_longline" DOUBLE,
"target_effort_china_longline" DOUBLE,
"target_effort_french_polynesia_longline" DOUBLE,
"target_effort_japan_longline" DOUBLE,
"target_effort_korea_longline" DOUBLE,
"target_effort_spain_longline" DOUBLE,
"target_effort_taipei_longline" DOUBLE,
"target_effort_united_states_of_america_longline" DOUBLE,
"target_effort_vanuatu_longline" DOUBLE,
"target_effort_panama_longline" DOUBLE,
"mean_sst" DOUBLE,
"median_sst" DOUBLE,
"min_sst" DOUBLE,
"max_sst" DOUBLE,
"sd_sst" DOUBLE,
"se_sst" DOUBLE,
"cv_sst" DOUBLE,
"mean_chla" DOUBLE,
"median_chla" DOUBLE,
"min_chla" DOUBLE,
"max_chla" DOUBLE,
"sd_chla" VARCHAR,
"se_chla" VARCHAR,
"cv_chla" VARCHAR,
"mean_ssh" DOUBLE,
"median_ssh" DOUBLE,
"min_ssh" DOUBLE,
"max_ssh" DOUBLE,
"sd_ssh" DOUBLE,
"se_ssh" DOUBLE,
"cv_ssh" DOUBLE,
"n__pred" DOUBLE,
"n__final_pred" DOUBLE
);
CREATE TABLE iccat_ll_models_others_results (
"environmental_value" VARCHAR,
"include_ssh" BOOLEAN,
"price" VARCHAR,
"catch_transformation" VARCHAR,
"mtry_class" BIGINT,
"min_n_class" BIGINT,
"mtry_reg" BIGINT,
"min_n_reg" BIGINT,
"rmse" DOUBLE,
"rsq" DOUBLE,
"mae" DOUBLE
);
CREATE TABLE iccat_ll_untuned_final_predict (
"n__pred_class" BIGINT,
"pres_abs" VARCHAR,
"catch" DOUBLE,
"rfmo" VARCHAR,
"year" BIGINT,
"latitude" BIGINT,
"longitude" BIGINT,
"species_sciname" VARCHAR,
"catch_units" VARCHAR,
"gear_group" VARCHAR,
"spatial_notes" VARCHAR,
"original_effort" BIGINT,
"species_commonname" VARCHAR,
"species_group" VARCHAR,
"species_resolution" VARCHAR,
"median_price_group" DOUBLE,
"median_price_species" DOUBLE,
"sdm" DOUBLE,
"zone" VARCHAR,
"location_cluster" BIGINT,
"target_effort" DOUBLE,
"target_effort_belize_longline" DOUBLE,
"target_effort_china_longline" DOUBLE,
"target_effort_japan_longline" DOUBLE,
"target_effort_korea_longline" DOUBLE,
"target_effort_spain_longline" DOUBLE,
"target_effort_taipei_longline" DOUBLE,
"target_effort_united_states_of_america_longline" DOUBLE,
"target_effort_vanuatu_longline" DOUBLE,
"mean_sst" DOUBLE,
"median_sst" DOUBLE,
"min_sst" DOUBLE,
"max_sst" DOUBLE,
"sd_sst" DOUBLE,
"se_sst" DOUBLE,
"cv_sst" DOUBLE,
"mean_chla" DOUBLE,
"median_chla" DOUBLE,
"min_chla" DOUBLE,
"max_chla" DOUBLE,
"sd_chla" DOUBLE,
"se_chla" DOUBLE,
"cv_chla" DOUBLE,
"mean_ssh" DOUBLE,
"median_ssh" DOUBLE,
"min_ssh" DOUBLE,
"max_ssh" DOUBLE,
"sd_ssh" DOUBLE,
"se_ssh" DOUBLE,
"cv_ssh" DOUBLE,
"target_effort_barbados_longline" DOUBLE,
"target_effort_bermuda_longline" DOUBLE,
"target_effort_brazil_longline" DOUBLE,
"target_effort_canada_longline" DOUBLE,
"target_effort_malta_longline" DOUBLE,
"target_effort_maroc_longline" DOUBLE,
"target_effort_mexico_longline" DOUBLE,
"target_effort_namibia_longline" DOUBLE,
"target_effort_philippines_longline" DOUBLE,
"target_effort_st_vincent_and_grenadines_longline" DOUBLE,
"target_effort_trinidad_and_tobago_longline" DOUBLE,
"target_effort_uruguay_longline" DOUBLE,
"target_effort_venezuela_longline" DOUBLE,
"target_effort_turks_and_caicos_longline" DOUBLE,
"target_effort_great_britain_longline" DOUBLE,
"target_effort_cote_d_ivoire_longline" DOUBLE,
"target_effort_cyprus_longline" DOUBLE,
"n__pred" DOUBLE,
"n__final_pred" DOUBLE
);
CREATE TABLE iotc_ll_models_others_results (
"environmental_value" VARCHAR,
"include_ssh" BOOLEAN,
"price" VARCHAR,
"catch_transformation" VARCHAR,
"mtry_class" BIGINT,
"min_n_class" BIGINT,
"mtry_reg" BIGINT,
"min_n_reg" BIGINT,
"rmse" DOUBLE,
"rsq" DOUBLE,
"mae" DOUBLE
);
CREATE TABLE iotc_ll_untuned_final_predict (
"n__pred_class" BIGINT,
"pres_abs" VARCHAR,
"catch" DOUBLE,
"rfmo" VARCHAR,
"year" BIGINT,
"latitude" DOUBLE,
"longitude" BIGINT,
"species_sciname" VARCHAR,
"catch_units" VARCHAR,
"gear_group" VARCHAR,
"spatial_notes" VARCHAR,
"original_effort" BIGINT,
"species_commonname" VARCHAR,
"species_group" VARCHAR,
"species_resolution" VARCHAR,
"median_price_group" DOUBLE,
"median_price_species" DOUBLE,
"sdm" DOUBLE,
"zone" VARCHAR,
"location_cluster" BIGINT,
"bycatch_total_effort" DOUBLE,
"bycatch_total_effort_china_longline" DOUBLE,
"bycatch_total_effort_korea_longline" DOUBLE,
"bycatch_total_effort_japan_longline" DOUBLE,
"mean_sst" DOUBLE,
"median_sst" DOUBLE,
"min_sst" DOUBLE,
"max_sst" DOUBLE,
"sd_sst" DOUBLE,
"se_sst" DOUBLE,
"cv_sst" DOUBLE,
"mean_chla" DOUBLE,
"median_chla" DOUBLE,
"min_chla" DOUBLE,
"max_chla" DOUBLE,
"sd_chla" DOUBLE,
"se_chla" DOUBLE,
"cv_chla" DOUBLE,
"mean_ssh" DOUBLE,
"median_ssh" DOUBLE,
"min_ssh" DOUBLE,
"max_ssh" DOUBLE,
"sd_ssh" DOUBLE,
"se_ssh" DOUBLE,
"cv_ssh" DOUBLE,
"bycatch_total_effort_portugal_longline" DOUBLE,
"bycatch_total_effort_spain_longline" DOUBLE,
"bycatch_total_effort_france_longline" DOUBLE,
"bycatch_total_effort_india_longline" DOUBLE,
"bycatch_total_effort_seychelles_longline" DOUBLE,
"bycatch_total_effort_taiwan_longline" DOUBLE,
"bycatch_total_effort_madagascar_longline" DOUBLE,
"bycatch_total_effort_mauritius_longline" DOUBLE,
"bycatch_total_effort_united_kingdom_longline" DOUBLE,
"bycatch_total_effort_australia_longline" DOUBLE,
"bycatch_total_effort_mozambique_longline" DOUBLE,
"bycatch_total_effort_malaysia_longline" DOUBLE,
"bycatch_total_effort_indonesia_longline" DOUBLE,
"bycatch_total_effort_kenya_longline" DOUBLE,
"n__pred" DOUBLE,
"n__final_pred" DOUBLE
);
CREATE TABLE wcpfc_ll_models_others_results (
"environmental_value" VARCHAR,
"include_ssh" BOOLEAN,
"price" VARCHAR,
"catch_transformation" VARCHAR,
"mtry_class" BIGINT,
"min_n_class" BIGINT,
"mtry_reg" BIGINT,
"min_n_reg" BIGINT,
"rmse" DOUBLE,
"rsq" DOUBLE,
"mae" DOUBLE
);
CREATE TABLE wcpfc_ll_untuned_final_predict (
"n__pred_class" BIGINT,
"pres_abs" VARCHAR,
"catch" BIGINT,
"rfmo" VARCHAR,
"year" BIGINT,
"latitude" DOUBLE,
"longitude" DOUBLE,
"species_sciname" VARCHAR,
"catch_units" VARCHAR,
"gear_group" VARCHAR,
"spatial_notes" VARCHAR,
"original_effort" BIGINT,
"species_commonname" VARCHAR,
"species_group" VARCHAR,
"species_resolution" VARCHAR,
"median_price_group" DOUBLE,
"median_price_species" DOUBLE,
"sdm" DOUBLE,
"zone" VARCHAR,
"location_cluster" BIGINT,
"bycatch_total_effort" DOUBLE,
"mean_sst" DOUBLE,
"median_sst" DOUBLE,
"min_sst" DOUBLE,
"max_sst" DOUBLE,
"sd_sst" DOUBLE,
"se_sst" DOUBLE,
"cv_sst" DOUBLE,
"mean_chla" DOUBLE,
"median_chla" DOUBLE,
"min_chla" DOUBLE,
"max_chla" DOUBLE,
"sd_chla" DOUBLE,
"se_chla" DOUBLE,
"cv_chla" DOUBLE,
"mean_ssh" DOUBLE,
"median_ssh" DOUBLE,
"min_ssh" DOUBLE,
"max_ssh" DOUBLE,
"sd_ssh" DOUBLE,
"se_ssh" DOUBLE,
"cv_ssh" DOUBLE,
"bycatch_total_effort_na_longline" DOUBLE,
"n__pred" DOUBLE,
"n__final_pred" DOUBLE
);
Anyone who has the link will be able to view this.