Published December 3, 2024 | Version 2.0
Dataset Open

Century Long Reconstruction of Gridded Phosphorus Surplus Across Europe (1850-2019)

  • 1. Helmholtz-Zentrum für Umweltforschung UFZ
  • 2. Université Paris-Saclay, INRAE, UR HYCAR, 92160 Antony, France
  • 3. Helmholtz Centre for Environmental Research - UFZ

Description

Publication

Please cite this publication if you use the dataset:

Batool, M., Sarrazin, F. J. and  Kumar, R. Century Long Reconstruction of Gridded Phosphorus Surplus Across Europe (1850-2019), submitted to Earth System Science Data.

Please also refer to the above publication for methodological details.

License

The "Century Long Reconstruction of Gridded Phosphorus Surplus Across Europe (1850-2019)" is freely available under an Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0, https://creativecommons.org/licenses/by-nc-sa/4.0), in compliance with the terms of use of the Food and Agriculture Organization of the United Nations (FAO).

Data description (v1):

This dataset consists of annual long-term reconstruction of total P surplus (both agricultural and non-agricultural soils) across Europe at a 5 arcmin spatial resolution for the period 1850 to 2019. The dataset consists of 48 P surplus estimates that account for the uncertainties resulting from methodological choices and coefficients in major components of the P surplus. This dataset offers the flexibility of aggregating the P surplus at any spatial scale of relevance to support water and land management strategies. Notably, our P surplus dataset has been developed consistently with our N surplus dataset (Batool et al. 2022), enabling joint analysis of N and P budgets across Europe, thereby facilitating holistic nutrient management studies.
 

1. Gridded P surplus data (NetCDF format): 48 files, each of them containing 170 years (1850-2019) of gridded data P surplus

2. Aggregated P surplus at European NUTS level (csv format) : 3 files (NUTS 1, NUTS 2, NUTS 3), each of them containing 170 years (1850-2019) of P surplus (mean and standard deviation of 48 estimates). Additionally, a readme file is provided for the NUTS ID's.

3. Aggregated P surplus at European river basins (CSV format): 1 file, each of them containing 170 years (1850-2019) of P surplus (mean and standard deviation of 48 estimates). Additionally, a readme file is provided for the river basin ID's.

Unit: kg/ha/yr (ha = physical area of grid cell/NUTS/river basins)

Time period: 1850-2019

Data description (v2):

We have updated the dataset (v1) and creared v2, which includes  improvements and additional components for a more comprehensive phosphorus surplus analysis across Europe. The updates are as follows:

  • Refined P input estimates from mineral fertilizers (1850–1960): We have revised our methodology for historical P inputs from mineral fertilizers. In the revised estimates, instead of relying on nitrogen (N) fertilizer trends as a proxy for changes in P fertilizer, we have now incorporated a global dataset that traces the historical sources of phosphorus fertilizers from phosphate rock (1800–2000). This dataset provides a more reliable temporal trend for P fertilizer use. 
  • Exclusion of chemical weathering inputs to urban areas: This adjustment better reflects phosphorus dynamics in urban regions.
  • Expanded data components: In addition to P surplus, the dataset now includes detailed estimates of P inputs (e.g., mineral fertilizers, manure) and P outputs , offering a more granular view of phosphorus flows.
  1. Gridded datasets
    1. Total P surplus data (NetCDF format): 48 files, each of them containing 170 years (1850-2019) of gridded P surplus data
    2. Total P inputs data (NetCDF format): 1 file, containing 170 years (1850-2019) of gridded P inputs data
    3. Total P output data (NetCDF format): 1 file, containing 170 years (1850-2019) of gridded P outputs data
    4. P fertilizer (NetCDF format): 2 files, each of them containing 170 years (1850-2019) of gridded  P inputs from mineral fertilizer data
    5. P animal manure (NetCDF format): 6 files, each of them containing 170 years (1850-2019) of gridded P inputs from animal manure data
  2. Aggregated P surplus at European NUTS level (csv format) : 3 files (NUTS 1, NUTS 2, NUTS 3), each of them containing 170 years (1850-2019) of P surplus (mean and standard deviation of 48 estimates). Additionally, a readme file is provided for the NUTS ID's.

  3. Aggregated P surplus at European river basins (CSV format): 1 file, each of them containing 170 years (1850-2019) of P surplus (mean and standard deviation of 48 estimates). Additionally, a readme file is provided for the river basin ID's.

Unit: kg/ha/yr (ha = physical area of grid cell/NUTS/river basins)

Time period: 1850-2019

Acknowledgments and underlying datasets

Partial support for this work was provided by the Global Water Quality Analysis and Service Platform (GlobeWQ) project financed by the German Ministry for Education and Research (grant number 02WGR1527A) and the Development Bank of Saxony, Research Project Funding on Resilient Zero-Pollution Wastewater Systems in Climate Change – Case Study Saxony (Project No. 100669418). We are also thankful to UFZ for providing computing power and technical support to the EVE supercomputing facility. We would like to thank people from various organizations and projects for kindly providing us with the data that were used in this study, which includes among others: FAO, Eurostat, HYDE, and IFA.

Contact

Further queries regarding these datasets can be directed to Masooma Batool (masooma.batool@ufz.de) and Rohini Kumar (rohini.kumar@ufz.de).

Files

P_sur_total_kg_ha_NUTS_0.csv

Files (10.4 GB)

Name Size Download all
md5:aa83523b2600eef740127fa35d7c03d2
8.1 kB Download
md5:670dcea00d4442099d6fdf0268a7fb80
6.6 kB Download
md5:a01dd9217c863832c80c47de5364b1ba
7.0 kB Download
md5:7837b32397d3fe94943c1a61dd1f29af
21.8 kB Download
md5:d0e45b80f4d437bd6cc0299a87742bd2
126.4 MB Download
md5:a9d096cbb9704d48dc52d7acb507a277
126.4 MB Download
md5:efb3a5fa288bf9301dc07a6dd240ccef
183.0 MB Download
md5:98efa7d3f20a7eb4d4dc745c1670747d
111.9 MB Download
md5:6317392471dbaee1a8f18734628313e0
116.2 MB Download
md5:08a7d14b7721c3e06db4421f300c72f3
182.9 MB Download
md5:9866aadfc113bd4eb47e5e7ffc19a5fc
185.5 MB Download
md5:58aae11a4675b55e710291cd60957ba0
185.5 MB Download
md5:cfd32bae15144b24f8d2c0d783c03520
185.5 MB Download
md5:78a54cc31e65be72ffe067cc648a3e2a
187.2 MB Download
md5:bf890f8c36e5051a5f15b93b9da8dc9d
183.1 MB Download
md5:fc49640e0e0838c4a3dbc612c9554672
184.0 MB Download
md5:6b9c90be968a20428125a807aff92dc0
184.1 MB Download
md5:fc49640e0e0838c4a3dbc612c9554672
184.0 MB Download
md5:b4e416b7a6220606f62d138c534f640d
183.7 MB Download
md5:32e7dbd758dba92ce0b8a1c0b1ea0538
182.7 MB Download
md5:7f99e13de1990a310faa2d08934902e0
182.8 MB Download
md5:22ca825aca082d8c1c22978f74b58fef
183.5 MB Download
md5:5b2dacd6f813aed9725b4b4d67342052
182.8 MB Download
md5:8dbfa1863bd99f92063734d4403d35cd
182.7 MB Download
md5:2c4ff0b4fa7e6d4902b1787d6137a641
184.9 MB Download
md5:848c3308f1704fce0758b36294d89bf1
182.9 MB Download
md5:de8ea06f58d81a757854c78030ef170c
184.0 MB Download
md5:0dfb499dedcd333222bf7a371c0f3f5b
184.1 MB Download
md5:fd2abebb3bd8f0398aac8cc725f0c5ca
184.7 MB Download
md5:8315423c1718c9fc0791c899a1f9ec07
184.1 MB Download
md5:5f59c34a9f7bcceaa12246189d7bfa77
184.0 MB Download
md5:0fe6f8c5e89e938021586f23415c5580
183.2 MB Download
md5:c0172deb4c063e2ebdd91bce4a95a7b9
183.1 MB Download
md5:148f23ad4770250da73ed7dbd911c0b8
183.1 MB Download
md5:8dd995cb901bc647d7f1670ae5b1965b
183.0 MB Download
md5:78c01eb20ba54834eb4c7c3234e3e215
183.1 MB Download
md5:6a4e2aa5eadec5dabe6e02800f602735
182.8 MB Download
md5:5563a6ba47a1037d8f116139f9724241
183.0 MB Download
md5:2eb9f34148e57c8302f1e0b10cce5a2f
184.5 MB Download
md5:bf23a0811d1726fae54e80dc3696ef01
184.3 MB Download
md5:477f7fd1ddffc658e5dcab08a8113a4b
184.3 MB Download
md5:065cb4fa29e083b2bec85a0276b37826
184.3 MB Download
md5:f52a88cdd45d0562b1a06f29b15137e9
184.3 MB Download
md5:48b21f93e96885eba43f55fa2717ecbd
184.3 MB Download
md5:5d64d33d43f341df45bdca13c9cb12bf
183.4 MB Download
md5:2e8723ff9fd6ec2a630e1caca2d996ea
183.0 MB Download
md5:fa6c8b98d2f536cd9659b2ea0099c39f
183.1 MB Download
md5:92b9d323a53b7bfe70554b95b2983d9f
182.7 MB Download
md5:f82d6890214edf2daafbacc20b18f354
183.3 MB Download
md5:468a2b0b4d654ef9ed15d3e09aac7538
183.1 MB Download
md5:dc8723a8034e32a72ebeaef18689a201
183.0 MB Download
md5:474fb9bf1aab942f76868e484e354a0d
184.6 MB Download
md5:138a28aef72e03efbece9cc6c236fe35
184.3 MB Download
md5:a924c3d0eff7d53d7b17d78ec30bcbe8
184.3 MB Download
md5:4255188e66cff593622e18f943db11e8
184.5 MB Download
md5:d55e32eb04a220d90897c5f393de842f
184.3 MB Download
md5:3b70de8c06f844e86343ce9a1d486139
184.3 MB Download
md5:aaf0bd584c509dbaa091204428b6fa8f
184.5 MB Download
md5:18f4fca53507a0b513be26de0df605a6
184.2 MB Download
md5:c972c8c3d1759d020c971ec42c98de0c
184.1 MB Download
md5:2ea92678e6093fc3ca6ac2bce91c8d4a
184.0 MB Download
md5:6b9c90be968a20428125a807aff92dc0
184.1 MB Download
md5:3583d89bddd15fbe4702bf8eaa705a34
112.6 kB Preview Download
md5:0670d5eb6d8430df25374ad4b346a95c
395.5 kB Preview Download
md5:78a127503b7ba161ce9f707ad5731f82
1.1 MB Preview Download
md5:caafcacd5b1d13fddbe831872877d920
1.4 MB Preview Download
md5:b4e763360780fa5eb21d320e82b7bfad
1.1 kB Preview Download
md5:85045861f1134bb8c833df2d01f8bf7e
5.0 kB Preview Download
md5:34b54ae110b6b6535d2c4e45c2e401d7
18.1 kB Preview Download
md5:07b96cda930b419f7493efe160337322
839 Bytes Preview Download
md5:a22a6ee45d1d4294b32aab3bab9ffaac
2.0 kB Preview Download
md5:47d5847b742d2f8b48931d8b67ad223b
3.5 kB Preview Download
md5:2d012796a3edc9fa1212d1c13ef08515
4.5 kB Download
md5:cb21de3a69b650bba30098ff769ea475
10.5 kB Download

Additional details

Identifiers

Other
NA

Dates

Created
2024-07-12
Dataset