LTAR Phosphorus Budget Summary by US Government | Academic Research

About this Dataset

LTAR Phosphorus Budget Summary

Surface agronomic P budgets for 61 cropping systems using field-scale P flux data across 24 research sites in the United States and Canada. Data are representative of P inputs and outputs associated with the production of each crop in a respective rotation year, ranging from 1 to 10 rotation years. This dataset provides a comparison of field-scale soil surface P fluxes and phosphorus budgets across sites and cropping systems.

Resources in this dataset:

Resource Title: LTAR Phosphorus Budget Summary Data Sources and References.

File Name: DataSourcesAndReferences.csv

Resource Description: This file includes data sources and references relevant to calculated P budgets. Affiliated numerical data can be found in the LTAR Phosphorus Budget Summary Data file.

Resource Title: LTAR Phosphorus Budget Summary Data.

File Name: PBudgetData.csv

Resource Description: Agronomic annual and system data for calculated P budgets for cropping systems throughout the United States and Canada.
Organization: Department of Agriculture
Last updated: 2024-03-30T11:51:51.284212
Tags: aafc, abs-uf, agrifoods-canada, archbold-biological-station, ars, caf, central-mississippi-river-basin, central-plains-experimental-range, cmrb, cper, cropping-systems, data-gov, eastern-corn-belt, ecb, field-scale, gacp, gulf-atlantic-coastal-plain-ltar, jer, jornada-experimental-range, kansas-state-university, kbs, kellogg-biological-station, ksu, lcb, lmrb, lower-chesapeake-bay, lower-mississippi-river-basin, ltar, ncsu, nisr, north-carolina-state-university, northern-plains, northwest-irrigation-and-soils-research, np, np211, np216, nutrient-cycling, nutrient-management, p-flux, phosphorus, phosphorus-flux, r-j-cook-agronomy-farm, soil-and-water-management-research, southern-plains, sp, swmr, texas-gulf, tg, u-of-a, ucb, uf, uk, umrb, university-of-arkansas, university-of-florida, university-of-kentucky, university-of-vermont, university-of-waterloo, upper-chesapeake-bay-ltar, upper-mississippi-river-basin, usda, uvm, uw

Tables

DataSourcesAndReferences

@usgov.usda_gov_ltar_phosphorus_budget_summary_d4e24.datasourcesandreferences

20.63 KB
174 rows
16 columns


CREATE TABLE datasourcesandreferences (
  "location" VARCHAR,
  "dominant_cropping_system_name" VARCHAR,
  "cropping_system_id" VARCHAR,
  "rotation_year" VARCHAR,
  "crop_names" VARCHAR,
  "p_application_rate_information_source" VARCHAR,
  "p_application_rate_references" VARCHAR,
  "atmospheric_p_deposition_information_source" VARCHAR,
  "atmospheric_p_deposition_references" VARCHAR,
  "p_in_irrigation_information_source" VARCHAR,
  "p_in_irrigation_references" VARCHAR,
  "p_removed_by_crop_information_source" VARCHAR,
  "p_removed_by_crop_references" VARCHAR,
  "p_loads_information_source" VARCHAR,
  "p_loads_references" VARCHAR,
  "notes" VARCHAR
);

PBudgetData

@usgov.usda_gov_ltar_phosphorus_budget_summary_d4e24.pbudgetdata

50.99 KB
224 rows
44 columns


CREATE TABLE pbudgetdata (
  "location" VARCHAR,
  "dominant_cropping_system_name" VARCHAR,
  "cropping_system_id" VARCHAR,
  "rotation_year" VARCHAR,
  "crop_names" VARCHAR,
  "field_area_ha" DOUBLE,
  "agricultural_production_system" VARCHAR,
  "p_source" VARCHAR,
  "soil_series" VARCHAR,
  "presence_of_subsurface_drainage" VARCHAR,
  "presence_of_irrigation" VARCHAR,
  "p_in_irrigation" VARCHAR,
  "use_of_fire" VARCHAR,
  "type_of_tillage" VARCHAR,
  "harvested_cover_crop" VARCHAR,
  "p_application_timing" VARCHAR,
  "p_application_placement" VARCHAR,
  "annual_average_p_application_rate_kg_ha" VARCHAR,
  "annual_std_dev_p_application_rate_kg_ha" VARCHAR,
  "system_average_p_application_rate_kg_ha" VARCHAR,
  "system_std_dev_p_application_rate_kg_ha" VARCHAR,
  "average_annual_atmospheric_p_deposition_kg_ha" VARCHAR,
  "annual_std_dev_atmospheric_p_deposition_kg_ha" VARCHAR,
  "system_average_atmospheric_p_deposition_kg_ha" VARCHAR,
  "system_std_dev_atmospheric_p_deposition_kg_ha" VARCHAR,
  "annual_average_p_in_irrigation_kg_ha" VARCHAR,
  "annual_std_dev_p_in_irrigation_kg_ha" VARCHAR,
  "system_average_p_in_irrigation_kg_ha" VARCHAR,
  "system_std_dev_p_in_irrigation_kg_ha" VARCHAR,
  "annual_average_p_removed_by_crop_kg_ha" VARCHAR,
  "annual_std_dev_p_removed_by_crop_kg_ha" VARCHAR,
  "system_average_crop_p_removal_kg_ha" VARCHAR,
  "system_std_dev_crop_p_removal_kg_ha" VARCHAR,
  "analyzed_hydrologic_p_form" VARCHAR,
  "annual_average_surface_p_loads_kg_ha" VARCHAR,
  "annual_std_dev_surface_p_loads_kg_ha" VARCHAR,
  "annual_average_subsurface_p_loads_kg_ha" VARCHAR,
  "annual_std_dev_subsurface_p_loads_kg_ha" VARCHAR,
  "system_average_hydrologic_p_loads_kg_ha" VARCHAR,
  "system_std_dev_hydrologic_p_loads_kg_ha" VARCHAR,
  "system_average_agronomic_p_budgets_kg_ha" VARCHAR,
  "system_std_dev_agronomic_p_budgets_kg_ha" VARCHAR,
  "system_average_overall_field_p_budgets_kg_ha" VARCHAR,
  "system_std_dev_overall_field_p_budgets_kg_ha" VARCHAR
);