Chile Vegetation Belts & Bioclimate Analysis
Representativeness, Conservation, and Climate Change Impacts
@kaggle.thedevastator_chile_vegetation_belts_bioclimate_analysis
Representativeness, Conservation, and Climate Change Impacts
@kaggle.thedevastator_chile_vegetation_belts_bioclimate_analysis
CREATE TABLE cambio_climatico (
"codigo_piso" VARCHAR,
"nombre_piso" VARCHAR,
"superficie_modelada_km2" BIGINT,
"n_2050_26_reducci_n_km2" BIGINT,
"n_2050_26_estable_km2" BIGINT,
"n_2050_26_expansi_n_km2" BIGINT,
"n_2050_85_reducci_n_km2" BIGINT,
"n_2050_85_estable_km2" BIGINT,
"n_2050_85_expansi_n_km2" BIGINT,
"n_2050_26_reducci_n" DOUBLE,
"n_2050_26_estable" DOUBLE,
"n_2050_26_expansi_n" DOUBLE,
"n_2050_85_reducci_n" DOUBLE,
"n_2050_85_estable" DOUBLE,
"n_2050_85_expansi_n" DOUBLE
);
CREATE TABLE estado_conservacion (
"c_digo_piso" VARCHAR,
"nombre_piso" VARCHAR,
"formaci_n" VARCHAR,
"superficie_total_km2" BIGINT,
"superficie_remanente_km2" BIGINT,
"p_rdida_proyectada_50_a_os" DOUBLE,
"p_rdida_hist_rica" DOUBLE,
"criterio_uicn_a2b" VARCHAR,
"criterio_uicn_a3" VARCHAR,
"evaluaci_n_final" VARCHAR
);
CREATE TABLE extra_intrazonal (
"id" BIGINT,
"nombre_comunidad" VARCHAR,
"fuente_coordenadas" VARCHAR,
"regi_n" VARCHAR,
"localidad" VARCHAR,
"altitud" VARCHAR,
"latdec" DOUBLE,
"longdec" DOUBLE,
"referencia" VARCHAR,
"categoria" VARCHAR,
"subcategor_a" VARCHAR,
"codigo_unidad" VARCHAR,
"nombre_unidad" VARCHAR,
"codigo_piso" VARCHAR,
"nombre_piso" VARCHAR,
"comentario" VARCHAR
);
CREATE TABLE otras_unidades_vegetacin (
"otras_unidades_de_vegetaci_n_cartograf_a_puntual" VARCHAR,
"region" VARCHAR,
"localidad" VARCHAR,
"latdec" VARCHAR,
"londec" DOUBLE,
"fuente" VARCHAR,
"coordenadas" VARCHAR
);
CREATE TABLE pisos_bioclimas (
"id" BIGINT,
"codigo" VARCHAR,
"nombre" VARCHAR,
"formacion" VARCHAR,
"bioclima" VARCHAR
);
CREATE TABLE representatividad (
"codigo_piso" VARCHAR,
"nombre_piso" VARCHAR,
"superficie_total_km2" VARCHAR,
"superficie_remanente_km2" DOUBLE,
"superficie_total_bnp_km2" DOUBLE,
"superficie_remanente_bnp_km2" DOUBLE,
"superficie_total_mn_km2" DOUBLE,
"superficie_remanente_mn_km2" DOUBLE,
"superficie_total_pn_km2" DOUBLE,
"superficie_remanente_pn_km2" DOUBLE,
"superficie_total_rn_km2" DOUBLE,
"superficie_remanente_rn_km2" DOUBLE,
"superficie_total_rf_km2" DOUBLE,
"superficie_remanente_rf_km2" DOUBLE,
"superficie_total_sn_km2" DOUBLE,
"superficie_remanente_sn_km2" DOUBLE,
"superficie_total_icp_km2" DOUBLE,
"superficie_remanente_icp_km2" DOUBLE,
"superficie_total_po_km2" DOUBLE,
"superficie_remanente_po_km2" DOUBLE,
"superficie_total_po_icp_km2" DOUBLE,
"superficie_remanente_po_icp_km2" DOUBLE,
"po_formula_1" DOUBLE,
"po_formula_2" DOUBLE,
"po_formula_3" DOUBLE,
"po_icp_formula_1" DOUBLE,
"po_icp_formula_2" DOUBLE,
"po_icp_formula_3" DOUBLE
);
Anyone who has the link will be able to view this.