Turfgrass Soil Carbon Change Through Time: Raw Data And Code
Department of Agriculture
@usgov.usda_gov_turfgrass_soil_carbon_change_through_time_raw_4906b4ac
Department of Agriculture
@usgov.usda_gov_turfgrass_soil_carbon_change_through_time_raw_4906b4ac
CREATE TABLE braun2019_kansas_tidy (
"year" BIGINT,
"age" DOUBLE,
"plot" BIGINT,
"mgt_int" VARCHAR,
"depth" BIGINT,
"upper_cm" BIGINT,
"lower_cm" BIGINT,
"mgt_int_rep" BIGINT,
"tn_pct" DOUBLE,
"tc_pct" DOUBLE,
"bd_g_cm3" DOUBLE,
"soc_g_cm2" DOUBLE,
"d_soc_mg_ha_yr" DOUBLE,
"d_soc_g_m2_yr" DOUBLE,
"outlier" VARCHAR
);
CREATE TABLE campbell2014_authorscopy_tidy (
"subdivision" VARCHAR,
"address" BIGINT,
"street" VARCHAR,
"yr_built" BIGINT,
"home_age" BIGINT,
"age_class" VARCHAR,
"age_class_1" BIGINT,
"mgt_int" VARCHAR,
"clips_returned" VARCHAR,
"location" VARCHAR,
"depth" VARCHAR,
"soillayer" BIGINT,
"n_percent" DOUBLE,
"c_percent" DOUBLE,
"cnratio" VARCHAR,
"f_bd_g_cm3" DOUBLE,
"c_g_m2" DOUBLE,
"env_score" DOUBLE
);
CREATE TABLE contosta2020_manchester_tidy (
"lawn_id" BIGINT,
"year" BIGINT,
"upper_cm" BIGINT,
"lower_cm" BIGINT,
"soc_pct" DOUBLE,
"bd_g_cm3" DOUBLE,
"soc_contosta" DOUBLE,
"soc_g_m2" DOUBLE
);
CREATE TABLE gautum2020_tidy_0 (
"lawn_id" BIGINT,
"year" BIGINT,
"upper_cm" DOUBLE,
"lower_cm" DOUBLE,
"soc_pct" DOUBLE,
"som_pct" DOUBLE,
"bd_g_cm3" DOUBLE,
"soc_g_cm2" DOUBLE,
"soc_g_m2" DOUBLE
);
CREATE TABLE golubiewski2006_denver (
"column" VARCHAR,
"year" BIGINT,
"upper_cm" BIGINT,
"lower_cm" BIGINT,
"soc_g_m2" DOUBLE
);
CREATE TABLE huh2008 (
"year" BIGINT,
"upper_cm" BIGINT,
"lower_cm" BIGINT,
"depth" VARCHAR,
"soc_g_m2" BIGINT,
"soc_g_m2_se" BIGINT
);
CREATE TABLE huyler2013_authorscopy_tidy (
"type" VARCHAR,
"addresses" VARCHAR,
"yard_num" DOUBLE,
"sample_num" VARCHAR,
"depth" VARCHAR,
"carbon_kg_m2" DOUBLE,
"nitrogen_kg_m2" DOUBLE,
"bulkdensity_g_cm3" DOUBLE,
"home_age" DOUBLE,
"lbc_ppm_caco3_ph" DOUBLE,
"phcacl2" DOUBLE,
"waterph" DOUBLE,
"ca_mg_kg" DOUBLE,
"k_mg_kg" DOUBLE,
"mg_mg_kg" DOUBLE,
"mn_mg_kg" DOUBLE,
"p_mg_kg" DOUBLE,
"zn_mg_kg" DOUBLE,
"percent_sand" DOUBLE,
"percent_clay" DOUBLE,
"percent_silt" DOUBLE,
"fertilize" DOUBLE,
"water" DOUBLE,
"mow" DOUBLE,
"biomass_kg" DOUBLE,
"biomass_below10m_kg" DOUBLE,
"biomass_below_5_m_kg" DOUBLE
);
CREATE TABLE qian2002_fairwaysco (
"year" BIGINT,
"som_percent" DOUBLE,
"bd_g_cm3" DOUBLE,
"samplingdepth_cm" DOUBLE,
"multiplier" DOUBLE,
"soc_g_m2" BIGINT
);
CREATE TABLE qian2002_fairwayswy (
"year" BIGINT,
"som_percent" DOUBLE,
"bd_g_cm3" DOUBLE,
"samplingdepth_cm" DOUBLE,
"multiplier" DOUBLE,
"soc_g_m2" BIGINT
);
CREATE TABLE qian2002_greensco (
"year" DOUBLE,
"som_percent" DOUBLE,
"bd_g_cm3" DOUBLE,
"samplingdepth_cm" DOUBLE,
"multiplier" DOUBLE,
"soc_g_m2" BIGINT
);
CREATE TABLE sapkota2020_lubbock (
"year" BIGINT,
"soc_g_m2" BIGINT
);
CREATE TABLE selhorst2011_ohfairways_tidy (
"year" BIGINT,
"rep" BIGINT,
"upper_cm" DOUBLE,
"lower_cm" DOUBLE,
"soc_pct" DOUBLE,
"bd_g_cm3" DOUBLE
);
CREATE TABLE selhorst2011_ohrough_tidy (
"year" BIGINT,
"rep" BIGINT,
"upper_cm" DOUBLE,
"lower_cm" DOUBLE,
"soc_pct" DOUBLE,
"bd_g_cm3" DOUBLE
);
CREATE TABLE selhorst2013_albuquerque_tidy (
"year" BIGINT,
"rep" BIGINT,
"upper_cm" DOUBLE,
"lower_cm" DOUBLE,
"soc_pct" DOUBLE,
"bd_g_cm3" DOUBLE
);
CREATE TABLE selhorst2013_atlanta_tidy (
"year" BIGINT,
"rep" BIGINT,
"upper_cm" DOUBLE,
"lower_cm" DOUBLE,
"soc_pct" DOUBLE,
"bd_g_cm3" DOUBLE
);
CREATE TABLE selhorst2013_cheyenne_tidy (
"year" BIGINT,
"rep" BIGINT,
"upper_cm" DOUBLE,
"lower_cm" DOUBLE,
"soc_pct" DOUBLE,
"bd_g_cm3" DOUBLE
);
CREATE TABLE selhorst2013_dallas_tidy (
"year" BIGINT,
"rep" BIGINT,
"upper_cm" DOUBLE,
"lower_cm" DOUBLE,
"soc_pct" DOUBLE,
"bd_g_cm3" DOUBLE
);
CREATE TABLE selhorst2013_denver_tidy (
"year" BIGINT,
"rep" BIGINT,
"upper_cm" DOUBLE,
"lower_cm" DOUBLE,
"soc_pct" DOUBLE,
"bd_g_cm3" DOUBLE
);
CREATE TABLE selhorst2013_duluth_tidy (
"year" BIGINT,
"rep" BIGINT,
"upper_cm" DOUBLE,
"lower_cm" DOUBLE,
"soc_pct" DOUBLE,
"bd_g_cm3" DOUBLE
);
CREATE TABLE selhorst2013_houston_tidy (
"year" BIGINT,
"rep" BIGINT,
"upper_cm" DOUBLE,
"lower_cm" DOUBLE,
"soc_pct" DOUBLE,
"bd_g_cm3" DOUBLE
);
CREATE TABLE selhorst2013_lasvegas_tidy (
"year" BIGINT,
"rep" BIGINT,
"upper_cm" DOUBLE,
"lower_cm" DOUBLE,
"soc_pct" DOUBLE,
"bd_g_cm3" DOUBLE
);
CREATE TABLE selhorst2013_minneapolis_tidy (
"year" BIGINT,
"rep" BIGINT,
"upper_cm" DOUBLE,
"lower_cm" DOUBLE,
"soc_pct" DOUBLE,
"bd_g_cm3" DOUBLE
);
CREATE TABLE selhorst2013_orlando_tidy (
"year" BIGINT,
"rep" BIGINT,
"upper_cm" DOUBLE,
"lower_cm" DOUBLE,
"soc_pct" DOUBLE,
"bd_g_cm3" DOUBLE
);
CREATE TABLE selhorst2013_phoenix_tidy (
"year" BIGINT,
"rep" BIGINT,
"upper_cm" DOUBLE,
"lower_cm" DOUBLE,
"soc_pct" DOUBLE,
"bd_g_cm3" DOUBLE
);
CREATE TABLE selhorst2013_portland_tidy (
"year" BIGINT,
"rep" BIGINT,
"upper_cm" DOUBLE,
"lower_cm" DOUBLE,
"soc_pct" DOUBLE,
"bd_g_cm3" DOUBLE
);
Anyone who has the link will be able to view this.