Skip to main content
Data in Brief logoLink to Data in Brief
. 2020 Dec 24;34:106694. doi: 10.1016/j.dib.2020.106694

Data for spatio-temporal modelling and optimisation of multi-product rice value chains

Stephen S Doliente a,b, Sheila Samsatli a,
PMCID: PMC7806799  PMID: 33490325

Abstract

A current and fully-referenced dataset of resources and technologies for rice provision system is presented in this paper. These data served as model input data for the first multi-objective spatio-temporal optimisation of Philippine rice value chains. Data on available farmland area and their characteristics, such as paddy rice yield, rice farming costs and GHG emissions, are reported. As scenarios were developed for optimal rice value chains of integrated food and non-food production, estimates on the spatio-temporal demands on food, energy, fuels and chemical are presented. Data on sale prices and GHG emission factors of the raw materials and products are also compiled. Processing and transporting technologies involved in the modelling have their economic and operating parameters presented in this paper. This dataset has been collated through academic journals, technical papers and government agencies; all of which have been properly referenced. These data are valuable to various stakeholders of the rice industry across the globe aiming to understand rice value chains optimisation studies and to conduct further scenario development under different conditions and assumptions.

Keywords: Multi-product rice value chains, Paddy rice yield, Rice farming costs, Cost of rice processing and transport, GHG emissions, Food and non-food demands, Spatio-temporal modelling and optimisation, Value Web Model

Specifications Table

Subject Agricultural Economics
Specific subject area Modelling and optimisation of rice value chains
Type of data Table
How data were acquired Data were acquired from academic journals, technical papers and government agencies. All of which are presented and fully referenced in the Supplementary Material (MS Excel format).
Data format Raw
Parameters for data collection Realistic national-level estimates for the demands for various resources from rice crop are collected in order to model and optimise multi-product rice value chains for integrated production of food, energy, fuels and chemicals. Reliable estimates for the yields, efficiency, costs and GHG emissions were collected in order to model the economic and environmental impacts of relevant resources and technologies. The rice value chain optimisation model, called the Value Web Model, requires that these input data are in a specific format.
Description of data collection Data were collected by literature search in academic journals, technical papers and government agencies. Where applicable, the data were processed into a format suitable for input into the rice value chain optimisation model. This article discusses the details of the data processing conducted.
Data source location The data relate to the rice value chains in the Philippines. Primary sources of data on resources are Philippine government agencies such as the Philippine Statistics Authority [1] and the Philippine Department of Energy [2]. Primary sources of data for processing and transporting technologies are various academic journals and technical papers, which the list of references is provided in the Supplementary Material. Many of these data are applicable to many rice producing countries desiring to understand and optimise their value chains.
Data accessibility Supplementary Material of this data article, which is also available for download in Mendeley Data via http://dx.doi.org/10.17632/htgr7k5b79.1
Related research article S.S. Doliente, S. Samsatli, Integrated production of food, energy, fuels and chemicals from rice crops: Multi-objective optimisation for efficient and sustainable value chains, Journal of Cleaner Production, 124900, 2020, https://doi.org/10.1016/j.jclepro.2020.124900. [3]

Value of the Data

  • This article compiles the latest and fully referenced data on resources and technologies required for the first multi-objective spatio-temporal optimisation of rice value chains in the Philippines.

  • These data will be useful to investigators seeking to maximise the benefits and minimise the negative impacts of Philippine rice value chains, and other groups needing data on resources and technologies within rice value chains.

  • These data have been used for the development of optimal scenarios for integrated food and non-food production of the Philippine rice value chains, which researchers in this subject area can utilise for further investigation and cross-checking of assumptions with other models and/or rice producing nations.

  • Publishing these data provides a template in processing and organising the resource and technology data of many rice-producing countries for their appropriate use in spatio-temporal tools and techniques in aid of complex decision-making.

1. Data Description

This data article presents the compilation of model input data for the first multi-objective spatio-temporal optimisation of rice value chains in the Philippines. The data were utilised for the scenario development of rice value chains for optimal food (white rice) production only, optimal integrated production of food (white rice) and energy (bio-electricity), and optimal integrated production of food (white rice), energy (bio-electricity), fuels (bio-FT diesel, bio-FT jet and bioethanol) and chemicals (bio-naphtha). For the mathematical formulation of the multi-objective spatio-temporal mixed-integer linear programming model based on the Value Web Model [4], [5], [6], scenarios developed, and insights drawn of the modelling and optimisation of the Philippine rice value chains, readers are directed to this work [3]. All model input data are compiled in the Supplementary Material of this data article, which includes the following:

  • Total land area and farmland area in each provinces or zones of the Philippines;

  • Farmland characteristics such as paddy rice yield, rice farming costs, and rice farming GHG emissions;

  • Spatio-temporal demands on food, energy, fuels and chemicals;

  • Sale price and GHG emission factor of resources;

  • Cost and operational data of various processing technologies (e.g. rice mill, boiler-steam turbine) and transporting technologies (e.g. truck and barges).

The Supplementary Material provides detailed description of these data. Section 2 discusses further details of data processing needed.

2. Experimental Design, Materials and Methods

2.1. Spatial representation

Spatio-temporal data presented in this article must be referred to the spatial representation of Philippines depicting 81 provinces in the related research article [3]. Each province or zone has a coordinate (xz,yz) to represent its demand centre. These demand centres were processed in ArcMap (ArcGIS Desktop 10.5 (advanced license), version 10.5.0.6491) using population density data from WorldPop [7] and provincial boundaries from OCHA Philippines [8].

2.2. Calculation of the farmland characteristics in the Philippines

The following data were collected from the Philippine Statistics Authority [1]: 1) harvested paddy rice of each province in odt/yr; 2) harvested area of each province in ha; 3) paddy rice production cost based on area of each province in PhP/ha/yr; 4) total land area of each province in ha; and 5) farmland (or arable land) area of each province in ha. By dividing harvested paddy rice of each province with harvested area of each province, the paddy rice yield potential of each province in odt/ha/yr was determined. The quantity of rice straw of each province in odt/ha/yr was estimated from paddy rice yield potential by multiplying with 0.75 residue-to-crop ratio and adjusted with 15% for the quantity of rice straw set aside for soil nutrients replenishment and other applications in the Philippines [9,10]. By dividing paddy rice production cost based on area of each province with paddy rice yield potential of each province, the cost of paddy rice production of each province in PhP/odt was computed. By dividing country average rice cultivation GHG emission factor of 3.11 × 103 kgCO2e/ha [11] with paddy rice yield potential of each province, the GHG emissions of paddy rice production of each province in kgCO2e/odt was calculated. Tables 1 and 2 of the Supplementary Material tabulate the available farmlands and farmland characteristics per province, respectively.

2.3. Calculation of the hourly demands for food, energy, fuels and chemicals

Annual consumption data on white rice was collected from the Philippine Statistics Authority [1]; while annual consumption data on grid electricity, diesel, jet fuel and naphtha were obtained from the Philippine Department of Energy [2]. Annual consumption data on bioethanol was provided by the USDA Foreign Agricultural Service [12]. Population data of each province, also collected from the Philippine Statistics Authority [1], rendered the spatial demand variation across the provinces. Table 3 of the Supplementary Material tabulates the estimated hourly demands for food, energy, fuels and chemicals per province.

2.4. Estimation of the properties of resources

The properties of the resources (primary, intermediates and products) of the rice value chains were collated from various sources. Table 4 of the Supplementary Material provides data (when applicable to the case studies) on the sale prices and GHG emission factors.

2.5. Estimation of characteristics and conversion efficiencies of processing technologies

Tables 5 and 6 of the Supplementary Material show the estimated data of the characteristics and conversion efficiencies for the processing technologies, respectively. An assumption of 5% of the capital economic impact of a processing technology was used to estimate its fixed O&M economic impact. The capital environmental impact of each processing technology was estimated by multiplying its typical land footprint (in m2) with an average associated GHG emissions of constructing per unit area of 1665 kgCO2e/m2 [13]. An assumption of 5% of the capital environmental impact was also used to estimate the fixed O&M environmental impact.

2.6. Estimation of characteristics and conversion efficiencies of transporting technologies

The last three tables in the Supplementary Material present the estimated data on the characteristics (Table 7) and conversion efficiencies (Tables 8 and 9) of the transporting technologies and their infrastructures. Physical losses during resource transport are due to the inefficient existing Philippine transport and logistics system [14,15]. However, the losses occurring at the destination were assumed more significant compared to the losses per transport distance due to unavailability of storage facilities in the country [15]. Thus, distance-independent losses only were considered. In Table 8 of the Supplementary Material, transport efficiency X at the destination was varied at values 0.60, 0.70. 0.80, 0.90, 0.95 and 1.00 in order to study the effect of transport losses on rice value chains for food production only. In Table 9 of the Supplementary Material, transport efficiency at the destination was set to 0.80 for rice value chains with integrated food and non-food production in order to embody the inefficiencies of existing Philippine freight transport system [15].

Declaration of Competing Interest

The authors declare that they have no known competing financial interests or personal relationships which have, or could be perceived to have, influenced the work reported in this article.

Acknowledgments

The authors would like to acknowledge the CHED-Newton Agham PhD Scholarship grant by the British Council Philippines through the Newton Fund Project (Application ID: 333426643) and the Commission of Higher Education under the Office of the President, Republic of the Philippines through the CHED K-12 Transition Programme (Scholar No.: BC-17-009). Mr. Doliente would also like to acknowledge the University of the Philippines Los Baños for the study leave granted to pursue his PhD studies at University of Bath, UK. The authors would like to thank the EPSRC for the partial funding of this research through the Biomass and the Environment-Food-Energy-Water Nexus (BEFEW) project (Grant No. EP/P018165/1).

Footnotes

Supplementary material associated with this article can be found in the online version at doi:10.1016/j.dib.2020.106694.

Appendix. Supplementary materials

mmc1.xlsx (51.9KB, xlsx)

References

  • 1.PSA . Philippine Statistics Authory (PSA), Republic of the Philippines; Quezon City, Metro Manila, Philippines: 2018. OpenSTAT. [Google Scholar]; Available online at http://openstat.psa.gov.ph/. (accessed 23 July 2018).
  • 2.DOE P. Department of Energy, Republic of the Philippines; Tagiug City, Metro Manila Philippines: 2018. Philippines' Department of Energy. [Google Scholar]; Available online at https://www.doe.gov.ph/. (accessed 11 September 2018).
  • 3.Doliente S.S., Samsatli S. Integrated production of food, energy, fuels and chemicals from rice crops: multi-objective optimisation for efficient and sustainable value chains. J. Cleaner Prod. 2020;124900 doi: 10.1016/j.jclepro.2020.124900. [DOI] [Google Scholar]
  • 4.Samsatli S., Samsatli N.J. A multi-objective MILP model for the design and operation of future integrated multi-vector energy networks capturing detailed spatio-temporal dependencies. Appl. Energy. 2018;220:893–920. doi: 10.1016/j.apenergy.2017.09.055. [DOI] [Google Scholar]
  • 5.Samsatli S., Samsatli N.J. A general mixed integer linear programming model for the design and operation of integrated urban energy systems. J. Cleaner Prod. 2018;191:458–479. doi: 10.1016/j.jclepro.2018.04.198. [DOI] [Google Scholar]
  • 6.Samsatli S., Samsatli N.J. The role of renewable hydrogen and inter-seasonal storage in decarbonising heat – Comprehensive optimisation of future renewable energy value chains. Appl. Energy. 2019;233-234:854–893. doi: 10.1016/j.apenergy.2018.09.159. [DOI] [Google Scholar]
  • 7.WorldPop . U.o.S. School of Geography and Environmental Science; Southampton, United Kingdom: 2013. AsiaPop–Philippines 100m Population. [DOI] [Google Scholar]
  • 8.OCHA Philippines . P.S.A.P. National Mapping and Resource Information Authority (NAMRIA), Republic of the Philippines; Philippines: 2018. Philippines Administrative Level 0 (Country), 1 (Region), 2 (Province), And 3 (Municipality) Boundaries, Points, and Lines, Shapefiles and Live Services. [Google Scholar]; Available online at https://data.humdata.org/dataset/philippines-administrative-levels-0-to-3. (accessed 25 July 2018).
  • 9.Rosmiza M.Z. Farmers’ knowledge on potential uses of rice straw: an assessment in MADA and Sekinchan, Malaysia. Malaysian J. Soc. Space. 2014;10:14. [Google Scholar]; Available online at http://ejournal.ukm.my/gmjss/article/viewFile/18609/5942. (accessed 20 August 2018)
  • 10.Shafie S.M., Masjuki H.H., Mahlia T.M.I. Rice straw supply chain for electricity generation in Malaysia: economical and environmental assessment. Appl. Energy. 2014;135:299–308. doi: 10.1016/j.apenergy.2014.08.101. [DOI] [Google Scholar]
  • 11.Bautista E.G., Saito M. Greenhouse gas emissions from rice production in the Philippines based on life-cycle inventory analysis. J. Food Agric. Environ. 2015;13:139–144. doi: 10.1234/4.2015.3912. [DOI] [Google Scholar]
  • 12.Corpuz P. UDSA Foreign Agricultural Service; Manila, Philippines: 2018. Philippine Biofuels Situation and Outlook; pp. 1–14. [Google Scholar]; Available online at https://gain.fas.usda.gov/Recent%20GAIN%20Publications/Biofuels%20Annual_Manila_Philippines_11-28-2018.pdf. (accessed 01 December 2018).
  • 13.Aye L. in 18th Annual ARCOM Conference, University of Northumbria, United Kingdom. Association of Researchers in Construction Management; United Kingdom: 2002. The carbon footprint of a new commercial building; pp. 129–136. [Google Scholar]; Available online at http://www.arcom.ac.uk/-docs/proceedings/ar2002-129-136_Aye_et_al.pdf. (accessed 28 August 2018)
  • 14.Alavi H.R. in Directions in Development. The World Bank; Washington D.C., USA: 2012. Trusting trade and the private sector for food security in southeast Asia; pp. 1–264. [Google Scholar]; Available online at http://documents.worldbank.org/curated/en/741701468170978381/Trusting-trade-and-the-private-sector-for-food-security-in-Southeast-Asia. (accessed 14 September 2018).
  • 15.Mopera L.E. Food loss in the food value chain: the Philippine agriculture scenario. J. Devel. Sustain. Agricult. 2016;11:8–16. doi: 10.11178/jdsa.11.8. [DOI] [Google Scholar]

Associated Data

This section collects any data citations, data availability statements, or supplementary materials included in this article.

Supplementary Materials

mmc1.xlsx (51.9KB, xlsx)

Articles from Data in Brief are provided here courtesy of Elsevier

RESOURCES