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

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. Gridded datasets Total P surplus data (NetCDF format): 48 files, each of them containing 170 years (1850-2019) of gridded P surplus data Total P inputs data (NetCDF format): 1 file, containing 170 years (1850-2019) of gridded P inputs data Total P output data (NetCDF format): 1 file, containing 170 years (1850-2019) of gridded P outputs data P fertilizer (NetCDF format): 2 files, each of them containing 170 years (1850-2019) of gridded P inputs from mineral fertilizer data P animal manure (NetCDF format): 6 files, each of them containing 170 years (1850-2019) of gridded P inputs from animal manure data 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. 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 ([e-mail]) and Rohini Kumar ([e-mail]).引用说明 若使用本数据集，请引用以下文献： Batool, M., Sarrazin, F. J. 与 Kumar, R. 题为《1850-2019年欧洲网格化磷盈余的百年重建》的论文，已提交至《Earth System Science Data》期刊。 方法学细节请参阅上述文献。 许可证 本“1850-2019年欧洲网格化磷盈余的百年重建”数据集遵循知识共享署名-非商业性使用-相同方式共享4.0国际许可协议（Attribution-NonCommercial-ShareAlike 4.0 International, CC BY-NC-SA 4.0，https://creativecommons.org/licenses/by-nc-sa/4.0）进行免费发布，同时符合联合国粮食及农业组织（Food and Agriculture Organization of the United Nations, FAO）的使用条款要求。 数据集说明（v1版）： 本数据集包含1850年至2019年间欧洲全域的年度长期磷盈余（涵盖农业与非农业土壤）重建结果，空间分辨率为5弧分。数据集包含48组磷盈余估算结果，以覆盖磷盈余主要组成部分中方法学选择与系数带来的不确定性。本数据集支持按需聚合至任意空间尺度，可为水资源与土地管理策略制定提供支撑。值得注意的是，本磷盈余数据集与团队此前发布的氮盈余数据集（Batool et al. 2022）采用一致的构建框架，可实现欧洲地区氮、磷收支的联合分析，从而助力开展全域养分管理相关研究。 1. 网格化磷盈余数据（NetCDF格式）：共48个文件，每个文件包含1850-2019年共170年的网格化磷盈余数据 2. 欧洲NUTS级聚合磷盈余数据（CSV格式）：共3个文件（对应NUTS 1、NUTS 2、NUTS 3层级），每个文件包含1850-2019年共170年的磷盈余数据（48组估算结果的均值与标准差）。此外，附带一份用于说明NUTS标识符的readme文件。 3. 欧洲流域聚合磷盈余数据（CSV格式）：共1个文件，包含1850-2019年共170年的磷盈余数据（48组估算结果的均值与标准差）。此外，附带一份用于说明流域标识符的readme文件。 单位：千克/公顷/年（kg/ha/yr，其中ha指网格单元、NUTS区域或流域的实际面积） 时间范围：1850-2019 数据集说明（v2版）： 本团队已对v1版数据集进行更新并推出v2版，该版本包含多项改进与新增组成部分，可支持更全面的欧洲磷盈余分析。更新内容如下： 1. 矿物肥料磷投入估算优化（1850–1960年）：修订了历史矿物肥料磷投入的估算方法。此前的估算以氮肥趋势作为磷肥变化的代理变量，新版估算则引入了一套全球数据集，该数据集追踪了1800–2000年磷肥的磷矿石来源历史，可为磷肥使用量提供更可靠的时间序列趋势。 2. 排除城市区域的化学风化磷输入：该调整可更准确地反映城市区域的磷动态。 3. 扩充数据组成：除磷盈余数据外，本数据集新增了磷投入（如矿物肥料、畜禽粪便）与磷产出的详细估算结果，可更细致地展现磷流动过程。 网格化数据集 - 总磷盈余数据（NetCDF格式）：共48个文件，每个文件包含1850-2019年共170年的网格化磷盈余数据 - 总磷投入数据（NetCDF格式）：共1个文件，包含1850-2019年共170年的网格化磷投入数据 - 总磷产出数据（NetCDF格式）：共1个文件，包含1850-2019年共170年的网格化磷产出数据 - 磷肥数据（NetCDF格式）：共2个文件，每个文件包含1850-2019年共170年的网格化矿物肥料磷投入数据 - 畜禽粪便磷数据（NetCDF格式）：共6个文件，每个文件包含1850-2019年共170年的网格化畜禽粪便磷投入数据 欧洲NUTS级聚合磷盈余数据（CSV格式）：共3个文件（对应NUTS 1、NUTS 2、NUTS 3层级），每个文件包含1850-2019年共170年的磷盈余数据（48组估算结果的均值与标准差）。此外，附带一份用于说明NUTS标识符的readme文件。 欧洲流域聚合磷盈余数据（CSV格式）：共1个文件，包含1850-2019年共170年的磷盈余数据（48组估算结果的均值与标准差）。此外，附带一份用于说明流域标识符的readme文件。 单位：千克/公顷/年（kg/ha/yr，其中ha指网格单元、NUTS区域或流域的实际面积） 时间范围：1850-2019 致谢与依托数据集 本研究得到全球水质分析与服务平台（Global Water Quality Analysis and Service Platform, GlobeWQ）项目，以及萨克森州发展银行“气候变化下的零污染韧性废水系统研究项目——以萨克森州为例”（项目编号：100669418）的部分资助，其中GlobeWQ项目由德国教育与研究部资助（资助编号：02WGR1527A）。本团队感谢UFZ为EVE超级计算设施提供计算资源与技术支持。同时感谢多个组织与项目团队为本研究提供相关数据，包括但不限于联合国粮食及农业组织（FAO）、欧盟统计局（Eurostat）、全球环境历史数据库（History Database of the Global Environment, HYDE）与国际肥料工业协会（International Fertilizer Industry Association, IFA）。 联系方式 若对本数据集有进一步疑问，请联系Masooma Batool（邮箱：[e-mail]）与Rohini Kumar（邮箱：[e-mail]）。