Abstract
Soil health affects soil functions, food production, and climate change. Understanding our soil is important for our environment and food security. Therefore, we propose a data warehouse architecture for storing, processing, and visualizing soil data. In this study, we focused on the Maghreb region for the first time. This region is highly vulnerable to climate change and food insecurity, even though, as far as we know, it has not yet been considered. The proposed data warehouse architecture involves data mining and data science techniques to extract value from soil data and support decision-making at various levels. In our case, the warehoused data were analyzed using exploratory spatial data analysis tools to explore the spatial distribution, heterogeneity, and autocorrelation of soil properties. In our experiments, we presented the results of organic carbon (OC) analysis because of its importance to regulate climate change. The highest values of OC were situated in Morocco and Tunisia and we noticed a great distribution similarity in Algeria and Libya. One of the most important results of the autocorrelation analysis is the presence of positive spatial autocorrelation that leads to a perfect spatial clustering situation in the whole Maghreb region. This motivated us to a future work that aims to detect and interpret these clusters.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Similar content being viewed by others
References
Anselin, L.: Spatial econometrics: methods and models, vol. 4. Springer Science & Business Media (1988). https://doi.org/10.1007/978-94-015-7799-1
Bimonte, S., et al.: Collect and analysis of Agro-biodiversity data in a participative context: a business intelligence framework. Eco. Inform. 61, 101231 (2021)
Bimonte, S., Tchounikine, A., Miquel, M., Pinet, F.: When spatial analysis meets OLAP: multidimensional model and operators. Int. J. DataWarehousing Min. 6(4), 33–60 (2010)
Borojerdnia, A., Rozbahani, M.M., Nazarpour, A., Ghanavati, N., Payandeh, K.: Application of exploratory and spatial data analysis (sda), singularity matrix analysis, and fractal models to delineate background of potentially toxic elements: a case study of ahvaz, sw iran. Sci. Total Environ. 740, 140103 (2020)
Bouadi, T., Cordier, M.O., Moreau, P., Quiniou, R., Salmon-Monviola, J., Gascuel-Odoux, C.: A data warehouse to explore multidimensional simulated data from a spatially distributed agro-hydrological model to improve catchment nitrogen management. Environ. Modell. Softw. 97, 229–242 (2017)
Cima, E., Uribe Opazo, M., Johann, J., Rocha, W., Dalposso, G.: Analysis of spatial autocorrelation of grain production and agricultural storage in paraná. Engenharia Agrícola 38, 395–402 (2018)
Drias, H., Drias, Y., Houacine, N., Sonia, B.L., Zouache, D., Khennak, I.: Quantum OPTICS and deep self-learning on swarm intelligence algorithms for covid-19 emergency transportation. Soft Computing (2022). https://doi.org/10.1007/s00500-022-06946-8
Drias, H., Drias, Y., Khennak, I.: A novel orca cultural algorithm and applications. Expert Systems (2022)
Drias, Y., Drias, H., Khennak, I.: Data warehousing and mining for climate change: application to the Maghreb region. In: Abraham, A., et al. (eds.) SoCPaR 2021. LNNS, vol. 417, pp. 293–302. Springer, Cham (2022). https://doi.org/10.1007/978-3-030-96302-6_27
Haining, R., Wise, S., Ma, J.: Exploratory spatial data analysis. J. Royal Statist. Soc. Ser. D (Statistician) 47(3), 457–469 (1998)
Harmanny, K., Malek, Z.: Adaptations in irrigated agriculture in the mediterranean region: an overview and spatial analysis of implemented strategies. Reg. Environ. Change 19, 1401–1416 (2019). https://doi.org/10.1007/s10113-019-01494-8
Mirghaed, F.A., Souri, B.: Spatial analysis of soil quality through landscape patterns in the Shoor river basin, southwestern Iran. CATENA 211, 106028 (2022)
Protano, G., Lella, L., Nannoni, F.: Exploring distribution of potentially toxic elements in soil profiles to assess the geochemical background and contamination extent in soils of a metallurgical and industrial area in Kosovo. Environ. Earth Sci. 80, 486 (2021). https://doi.org/10.1007/s12665-021-09771-8
da Silva, G.S., Amarante, P.A., Amarante, J.C.A.: Agricultural clusters and poverty in municipalities in the northeast region of brazil: a spatial perspective. J. Rural. Stud. 92, 189–205 (2022)
Singh, S., Kasana, S.S.: Estimation of soil properties from the EU spectral library using long short-term memory networks. Geoderma Reg. 18, e00233 (2019)
Zaza, C., Bimonte, S., Faccilongo, N., Sala, P.L., Contò, F., Gallo, C.: A new decision-support system for the historical analysis of integrated pest management activities on olive crops based on climatic data. Comput. Electron. Agric. 148, 237–249 (2018)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2023 The Author(s), under exclusive license to Springer Nature Switzerland AG
About this paper
Cite this paper
Belkadi, W.H., Drias, Y., Drias, H. (2023). A Data Warehouse for Spatial Soil Data Analysis and Mining: Application to the Maghreb Region. In: Abraham, A., Pllana, S., Casalino, G., Ma, K., Bajaj, A. (eds) Intelligent Systems Design and Applications. ISDA 2022. Lecture Notes in Networks and Systems, vol 716. Springer, Cham. https://doi.org/10.1007/978-3-031-35501-1_16
Download citation
DOI: https://doi.org/10.1007/978-3-031-35501-1_16
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-031-35500-4
Online ISBN: 978-3-031-35501-1
eBook Packages: Intelligent Technologies and RoboticsIntelligent Technologies and Robotics (R0)