Integrating national open databases for a comprehensive view on food systems, environment sustainability and health in Brazil

TL;DR

This paper combines open data on food systems, environment, and health in Brazil to provide a detailed, long-term view of agricultural and consumption trends.

Contribution

The novel contribution is the integration of 114 datasets across eight platforms to create a unified, multi-year agrifood system database for Brazil.

Findings

The integration process covered four phases, including water and land use, pesticide records, and food consumption metrics.

The resulting database spans 48 years and offers insights into agricultural production and consumption variations in Brazil.

The work provides a comprehensive resource for analyzing food systems, environmental sustainability, and health outcomes.

Abstract

This paper details the integration of open-source databases on food production and consumption, pesticide use, water and land use, and nutrient supply, segmented by year and region. The process of extracting, transforming, and loading information was divided into four phases: 1) water and land use, harvest, and nutrient metrics; 2) pesticide and crop records; 3) pesticide residues with legal limits and their environment risk; 4) food acquisition and consumption by region and year. This effort resulted in 48 years of agrifood system data from 114 datasets across eight public platforms, providing a comprehensive view of the variations in agricultural production and consumption in Brazil.

Figures