Comprehensive Conifer Sampling In North America
Evaluating Geographic and Niche-Based Sampling Strategies
@kaggle.thedevastator_comprehensive_conifer_sampling_in_north_america
Evaluating Geographic and Niche-Based Sampling Strategies
@kaggle.thedevastator_comprehensive_conifer_sampling_in_north_america
CREATE TABLE conifer_database_climoccs (
"genus" VARCHAR,
"species" VARCHAR,
"country" VARCHAR,
"x" DOUBLE,
"y" DOUBLE,
"bio1" DOUBLE,
"bio2" DOUBLE,
"bio3" DOUBLE,
"bio4" DOUBLE,
"bio5" DOUBLE,
"bio6" DOUBLE,
"bio7" DOUBLE,
"bio8" DOUBLE,
"bio9" DOUBLE,
"bio10" DOUBLE,
"bio11" DOUBLE,
"bio12" DOUBLE,
"bio13" DOUBLE,
"bio14" DOUBLE,
"bio15" DOUBLE,
"bio16" DOUBLE,
"bio17" DOUBLE,
"bio18" DOUBLE,
"bio19" DOUBLE,
"bio20" DOUBLE,
"bio21" DOUBLE,
"bio22" DOUBLE,
"bio23" DOUBLE,
"bio24" DOUBLE,
"bio25" DOUBLE,
"bio26" DOUBLE,
"bio27" DOUBLE,
"bio28" DOUBLE,
"bio29" DOUBLE,
"bio30" DOUBLE,
"bio31" DOUBLE,
"bio32" DOUBLE,
"bio33" DOUBLE,
"bio34" DOUBLE,
"bio35" DOUBLE,
"min_mint" DOUBLE,
"max_maxt" DOUBLE,
"aet" DOUBLE,
"pet" DOUBLE,
"aet_pet_ratio" DOUBLE,
"not_hot_precip" DOUBLE
);
CREATE TABLE itrdb_occs (
"species_code" VARCHAR,
"site_code" VARCHAR,
"id" BIGINT,
"x" DOUBLE,
"y" DOUBLE,
"genus" VARCHAR,
"species" VARCHAR,
"bio1" DOUBLE,
"bio2" DOUBLE,
"bio3" DOUBLE,
"bio4" DOUBLE,
"bio5" DOUBLE,
"bio6" DOUBLE,
"bio7" DOUBLE,
"bio8" DOUBLE,
"bio9" DOUBLE,
"bio10" DOUBLE,
"bio11" DOUBLE,
"bio12" DOUBLE,
"bio13" DOUBLE,
"bio14" DOUBLE,
"bio15" DOUBLE,
"bio16" DOUBLE,
"bio17" DOUBLE,
"bio18" DOUBLE,
"bio19" DOUBLE,
"bio20" DOUBLE,
"bio21" DOUBLE,
"bio22" DOUBLE,
"bio23" DOUBLE,
"bio24" DOUBLE,
"bio25" DOUBLE,
"bio26" DOUBLE,
"bio27" DOUBLE,
"bio28" DOUBLE,
"bio29" DOUBLE,
"bio30" DOUBLE,
"bio31" DOUBLE,
"bio32" DOUBLE,
"bio33" DOUBLE,
"bio34" DOUBLE,
"bio35" DOUBLE,
"min_mint" BIGINT,
"max_maxt" BIGINT,
"aet" DOUBLE,
"pet" BIGINT,
"aet_pet_ratio" DOUBLE,
"not_hot_precip" DOUBLE
);
Anyone who has the link will be able to view this.