Data From: Alternative Fertilization Practices Lead To Improvements In Yield-scaled Global Warming Potential In Almond Orchards
Department of Agriculture
@usgov.usda_gov_data_from_alternative_fertilization_practices_28a923e8
Department of Agriculture
@usgov.usda_gov_data_from_alternative_fertilization_practices_28a923e8
CREATE TABLE all_flux_df (
"unnamed_0" BIGINT,
"n__1" BIGINT,
"x" BIGINT,
"day" BIGINT,
"treat" VARCHAR,
"rep" BIGINT,
"dist" BIGINT,
"wc" VARCHAR,
"temp" VARCHAR,
"date" TIMESTAMP,
"qn2on" DOUBLE,
"qco2" DOUBLE,
"qch4" DOUBLE,
"nh4" VARCHAR,
"no3" VARCHAR,
"date_3fe9f0" TIMESTAMP,
"season" BIGINT
);
CREATE TABLE n_2015rawdata (
"unnamed_0" BIGINT,
"x" BIGINT,
"day" BIGINT,
"treat" VARCHAR,
"rep" BIGINT,
"dist" BIGINT,
"wc" VARCHAR,
"temp" VARCHAR,
"date" TIMESTAMP,
"qn2on" DOUBLE,
"qco2" DOUBLE,
"qch4" DOUBLE,
"nh4" VARCHAR,
"no3" VARCHAR,
"date_3fe9f0" TIMESTAMP
);
CREATE TABLE n_2016rawdata (
"unnamed_0" BIGINT,
"x" BIGINT,
"day" BIGINT,
"treat" VARCHAR,
"rep" BIGINT,
"dist" BIGINT,
"wc" DOUBLE,
"temp" VARCHAR,
"date" TIMESTAMP,
"qn2on" DOUBLE,
"qco2" DOUBLE,
"qch4" DOUBLE,
"date_3fe9f0" TIMESTAMP
);
CREATE TABLE qemitter (
"unnamed_0" BIGINT,
"date" TIMESTAMP,
"treat" VARCHAR,
"rep" BIGINT,
"season" BIGINT,
"wc_new" VARCHAR,
"temp_new" VARCHAR,
"qn2onemitter" DOUBLE,
"qch4emitter" DOUBLE,
"qco2emitter" DOUBLE,
"qch4cemitter" DOUBLE,
"qco2cemitter" DOUBLE,
"n2on_emitter_mg_hr" DOUBLE,
"ch4c_emitter_mg_hr" DOUBLE,
"co2c_emitter_mg_hr" DOUBLE,
"n2on_emitter_mg_day" DOUBLE,
"ch4c_emitter_mg_day" DOUBLE,
"co2c_emitter_mg_day" DOUBLE,
"n2on_emitter_mg_m2_day" DOUBLE,
"ch4c_emitter_mg_m2_day" DOUBLE,
"co2c_emitter_mg_m2_day" DOUBLE,
"n2on_emitter_mg_ha_day" DOUBLE,
"ch4c_emitter_mg_ha_day" DOUBLE,
"co2c_emitter_mg_ha_day" DOUBLE,
"n2on_emitter_kg_ha_day" DOUBLE,
"ch4c_emitter_kg_ha_day" DOUBLE,
"co2c_emitter_kg_ha_day" DOUBLE
);
CREATE TABLE qemitterin (
"unnamed_0" BIGINT,
"date" TIMESTAMP,
"treat" VARCHAR,
"rep" BIGINT,
"season" BIGINT,
"wc_new" VARCHAR,
"temp_new" VARCHAR,
"nh4_new" VARCHAR,
"no3_new" VARCHAR,
"qn2onemitter" DOUBLE,
"qch4emitter" DOUBLE,
"qco2emitter" DOUBLE,
"qch4cemitter" DOUBLE,
"qco2cemitter" DOUBLE,
"n2on_emitter_mg_hr" DOUBLE,
"ch4c_emitter_mg_hr" DOUBLE,
"co2c_emitter_mg_hr" DOUBLE,
"n2on_emitter_mg_day" DOUBLE,
"ch4c_emitter_mg_day" DOUBLE,
"co2c_emitter_mg_day" DOUBLE,
"n2on_emitter_mg_m2_day" DOUBLE,
"ch4c_emitter_mg_m2_day" DOUBLE,
"co2c_emitter_mg_m2_day" DOUBLE,
"n2on_emitter_mg_ha_day" DOUBLE,
"ch4c_emitter_mg_ha_day" DOUBLE,
"co2c_emitter_mg_ha_day" DOUBLE,
"n2on_emitter_kg_ha_day" DOUBLE,
"ch4c_emitter_kg_ha_day" DOUBLE,
"co2c_emitter_kg_ha_day" DOUBLE,
"inorgnmg_kg" VARCHAR
);
CREATE TABLE qemitterstatsdf (
"unnamed_0" BIGINT,
"x" BIGINT,
"date" TIMESTAMP,
"treat" VARCHAR,
"rep" BIGINT,
"season" BIGINT,
"wc_new" VARCHAR,
"temp_new" VARCHAR,
"qn2ong_ha_day" DOUBLE,
"qch4cg_ha_day" DOUBLE,
"qco2cg_ha_day" DOUBLE,
"logqn2ong_ha_day" DOUBLE
);
CREATE TABLE totalcumulch4cg_ha_rep_combo (
"unnamed_0" BIGINT,
"date" TIMESTAMP,
"treatment" VARCHAR,
"rep" BIGINT,
"season" BIGINT,
"ch4ccumr" DOUBLE
);
CREATE TABLE totalcumuln2ong_ha_rep_combo (
"unnamed_0" BIGINT,
"date" TIMESTAMP,
"treatment" VARCHAR,
"rep" BIGINT,
"season" BIGINT,
"n2oncumr" DOUBLE
);
Anyone who has the link will be able to view this.