A Database for the Stocks and Flows of Sand and Gravel

Increasing demand for sand and gravel globally is leading to social, environmental, and political issues that are becoming more widely recognised. Lack of data and poor accessibility of the few available data contribute to exacerbating these issues and impair evidence-based management efforts. This paper presents a database to store stocks and flows data for sand and gravel from different sources. The classification system underlying within it builds on the Universal Materials Information System (UMIS) nomenclature, which is used to construct hierarchical order in the data and in the same manner as the Yale Stocks and Flow Database (YSTAFDB), a common data format. To illustrate how the database is built and used, a case study using UK data is presented. The UK is chosen owing to relatively better access to data compared to other locations. Quantitative analyses of the data show the supply chain of these materials to be currently stable for the UK as indigenous extraction contributes 95.6% to UK sand and gravel production, with imports accounting for the rest of the inputs, of which 50% is reliant on only one nation.