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.284216
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

PBudgetData

@usgov.usda_gov_ltar_phosphorus_budget_summary_d4e24.pbudgetdata

52.22 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  -- Field Area (ha),
  "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 Average P Application Rate (kg/ha),
  "annual_std_dev_p_application_rate_kg_ha" VARCHAR  -- Annual Std Dev P Application Rate (kg/ha),
  "system_average_p_application_rate_kg_ha" VARCHAR  -- System Average P Application Rate (kg/ha),
  "system_std_dev_p_application_rate_kg_ha" VARCHAR  -- System Std Dev P Application Rate (kg/ha),
  "average_annual_atmospheric_p_deposition_kg_ha" VARCHAR  -- Average Annual Atmospheric P Deposition (kg/ha),
  "annual_std_dev_atmospheric_p_deposition_kg_ha" VARCHAR  -- Annual Std Dev Atmospheric P Deposition (kg/ha),
  "system_average_atmospheric_p_deposition_kg_ha" VARCHAR  -- System Average Atmospheric P Deposition (kg/ha),
  "system_std_dev_atmospheric_p_deposition_kg_ha" VARCHAR  -- System Std Dev Atmospheric P Deposition (kg/ha),
  "annual_average_p_in_irrigation_kg_ha" VARCHAR  -- Annual Average P In Irrigation (kg/ha),
  "annual_std_dev_p_in_irrigation_kg_ha" VARCHAR  -- Annual Std Dev P In Irrigation (kg/ha),
  "system_average_p_in_irrigation_kg_ha" VARCHAR  -- System Average P In Irrigation (kg/ha),
  "system_std_dev_p_in_irrigation_kg_ha" VARCHAR  -- System Std Dev P In Irrigation (kg/ha),
  "annual_average_p_removed_by_crop_kg_ha" VARCHAR  -- Annual Average P Removed By Crop (kg/ha),
  "annual_std_dev_p_removed_by_crop_kg_ha" VARCHAR  -- Annual Std Dev P Removed By Crop (kg/ha),
  "system_average_crop_p_removal_kg_ha" VARCHAR  -- System Average Crop P Removal (kg/ha),
  "system_std_dev_crop_p_removal_kg_ha" VARCHAR  -- System Std Dev Crop P Removal (kg/ha),
  "analyzed_hydrologic_p_form" VARCHAR,
  "annual_average_surface_p_loads_kg_ha" VARCHAR  -- Annual Average Surface P Loads (kg/ha),
  "annual_std_dev_surface_p_loads_kg_ha" VARCHAR  -- Annual Std Dev Surface P Loads (kg/ha),
  "annual_average_subsurface_p_loads_kg_ha" VARCHAR  -- Annual Average Subsurface P Loads (kg/ha),
  "annual_std_dev_subsurface_p_loads_kg_ha" VARCHAR  -- Annual Std Dev Subsurface P Loads (kg/ha),
  "system_average_hydrologic_p_loads_kg_ha" VARCHAR  -- System Average Hydrologic P Loads (kg/ha),
  "system_std_dev_hydrologic_p_loads_kg_ha" VARCHAR  -- System Std Dev Hydrologic P Loads (kg/ha),
  "system_average_agronomic_p_budgets_kg_ha" VARCHAR  -- System Average Agronomic P Budgets (kg/ha),
  "system_std_dev_agronomic_p_budgets_kg_ha" VARCHAR  -- System Std Dev Agronomic P Budgets (kg/ha,
  "system_average_overall_field_p_budgets_kg_ha" VARCHAR  -- System Average Overall Field P Budgets (kg/ha),
  "system_std_dev_overall_field_p_budgets_kg_ha" VARCHAR  -- System Std Dev Overall Field P Budgets (kg/ha)
);