Design and functional features of the world leading soil databases. Analytical review
DOI:
https://doi.org/10.31073/acss89-01Keywords:
attributes; construction; database; metadata; soilAbstract
The development of the concept of structural and functional foundations of the soil information system of Ukraine should be based on the analysis of information about the existing soil information centers and databases in the world. For this purpose, an analytical review of modern world publications in scientific journals and other sources of information was performed. The total list of investigated publications includes more than 90 scientific articles, presentations, instructions, manuals, web pages etc. The review article presents the main results of analytical research and conclusions on the possibility of introducing in Ukraine various aspects of the positive experience of world soil science in the creation of soil databases. The work was carried out in three stages. The first was an expert review of published materials on relevant topics in foreign publications in order to identify the world's major international centers of soil information and leading databases most used in the World Society of Soil Scientists. As a result, a list of leading international information centers was provided, with an indication of their location and source of information. The second stage was a detailed study of the design characteristics, principles of operation and methods of information transformation in the three most famous international soil databases: SOTER: Soil and Terrain database; GSM: Global Soil Map; WoSIS: World Soil Information Service. The information about the list of attributes in each database, methods of their coding, common approaches to the construction of tables, normalization of parameters, formation of a set of metadata, etc. was summarized. And at the third stage the list of the most innovative features of national database designs in different countries over the World, acceptable for use in Ukraine, was determined.
References
References
Batjes N.H. 2017. Overview of procedures and standards in use at ISRIC WDC-Soils. Wageningen : ISRIC World Soil Information, 2017. 28 p.
ISRIC Soil Information System (ISIS) [Electronic resource]. Wageningen : ISRIC World Soil Information, 2012-2018. URL: http://isis.isric.org (viewed on November 2, 2018).
Engelen V.W.P. van, Dijkshoorn J.A. (eds.), 2013. Global and National Soils and Terrain Databases (SOTER). Procedures Manual, Version 2.0, ISRIC - World Soil Information, Wageningen. 198 p. URL: https://esdac.jrc.ec.europa.eu/public_path/shared_folder/SOTER/isric_report_2013_04.pdf
Batjes N.H. Harmonized soil profile data for applications at global and continental scales: updates to the WISE database. Soil Use Management. Vol. 25. 2009. P. 124-127. DOI: 10.1111/j.1475-2743.2009.00202.x
Batjes N.H. World Inventory of Soil Emission Potentials: WISE 2.1 – Profile database user manual and coding protocols. Wageningen : ISRIC Technical Paper 26, 1995. 56 p.
Ribeiro E, Batjes NH, Leenaars JGB, van Oostrum AJM, Mendes de Jesus J 2015. Towards the standardization and harmonization of world soil data: Procedures manual ISRIC World Soil Information Service (WoSIS version 2.0). Report 2015/03, ISRIC - World Soil Information, Wageningen. 100 p. URL: https://www.isric.org/sites/default/files/isric_report_2015_03.pdf
Ribeiro E., Batjes N.H., Oostrum A.J.M. World Soil Information Service (WoSIS)-Towards the standardization and harmonization of world soil data. Wageningen : ISRIC World Soil Information, 2018. 166 p. URL: https://www.isric.org/sites/default/files/isric_report_2018_01.pdf
Leenaars J.G.B. Africa Soil Profiles Database: a compilation of georeferenced and standardised legacy soil profile data for Sub Saharan Africa (version 1.2). Wageningen : ISRIC World Soil Information, 2014. 160 p. DOI: 10.13140/RG.2.2.10667.75040
Tóth G., Jones A., Montanarella L. The Lucas topsoil database and derived information on the regional variability of cropland topsoil properties in the European Union. Environmental Monitoring and Assessment. 2013. Vol. 185. P. 7409-7425. DOI: 10.1007/s10661-013-3109-3
LUCAS: Land Use/Cover Area frame Statistical Survey [Electronic resource]: Ispra: ESDAC, 2018. URL: https://esdac.jrc.ec.europa.eu/projects/lucas. (viewed on November 2, 2018).
Arrouays D. Leenaars, J.G.B., Richer-de-Forges A.C. [et al.]. 2017. Soil legacy data rescue via GlobalSoilMap and other international and national initiatives. GeoResJ. Vol. 14. P. 1–19. DOI: 10.1016/j.grj.2017.06.001 2214-2428
Laktionova T. , Medvedev V. Bigun O., Nakis’ko S., Savchenko K., Sheyko S. 2013. Soil data from Ukraine. In: European Hydropedological Data Inventory (EU-HYDI). Publications Office of the European Union. Luxembourg. Р. 106-110. URL: https://esdac.jrc.ec.europa.eu/content/european-hydropedological-data-inventory-eu-hydi
Panagos P., Liedekerke M., Montanarella L. European Soil Portal. Luxembourg : Office for Official Publications of the European Communities, 2006. 77 p.
World Reference Base for soil resources. World Soil Resources Report No 84. Rome : FAO, 1998. 88 p.
FAO/IIASA/ISRIC/ISS-CAS/JRC. Harmonized World Soil Database. Rome : FAO, 2012. 50 p. URL: http://www.fao.org/soils-portal/soil-survey/soil-maps-and-databases/harmonized-world-soil-database-v12/ru/
The European Soil Information System. World Soil Resources Reports 91/ Proceedings of a Technical Consultation Rome, Italy, 2-3 September 1999. FAO. Rome, 2000. 163 p.
Soil and Terrain (SOTER) database [Electronic resource]. Wageningen : ISRIC World Soil Information, 2012-2018. URL: http://www.isric.org/projects/soil-and-terrain-soter-database-programme (viewed on November 2, 2018).
Global and National Soils and Terrain Databases (SOTER). Procedures Manual. Version 2.0 / ed. V.W.P. van Engelen, J.A. Dijkshoorn. Wageningen : ISRIC World Soil Information, 2013. 198 p. URL: https://esdac.jrc.ec.europa.eu/public_path/shared_folder/SOTER/isric_report_2013_04.pdf
Batjes N.H., Van Engelen V.W.P., Kauffman H., Oldeman L.R. 1994. Development of soil databases for global modelling / In: Transactions: 15th World Congress of Soil Science : conference abstracts (Mexico, Acapulco, 10-16 July 1994). International Society of Soil Science, Mexican Society of Soil Science. Acapulco : ISSS; MSSS. Vol. 6a. P. 40-57.
SOTER Databases [Electronic resource]. Wageningen : ISRIC World Soil Information, 2012-2018. URL: http://www.isric.org/explore/soter(viewed on November 2, 2018).
World reference base for soil resources 2006 / IUSS Working Group WRB. Rome : FAO, 2006. 145 p. URL: http://www.fao.org/3/a-a0510e.pdf
FAO/UNESCO soil map of the world: revised legend. FAO, International Soil Reference and Information Centre. Rome : FAO, 1988. 119 p.
Guidelines for Soil Description. FAO. Rome : FAO, 2006. 110 p. URL: http://www.fao.org/3/a-a0541e.pdf
ISRIC Soil Data Hub [Electronic resource]. Wageningen : ISRIC World Soil Information, 2012-2018. URL: https://www.isric.online/explore/isric-soil-data-hub (viewed on November 2, 2018).
Data and Software Policy [Electronic resource]. Wageningen : ISRIC World Soil Information, 2012-2018. URL: https://www.isric.org/about/data-policy (viewed on November 2, 2018).
GLOBALSOILMAP.NET [Electronic resource]. Wageningen : ISRIC World Soil Information, 2008-2018. URL: http://www.globalsoilmap.net (viewed on November 2, 2018).
CSIRO contributes to Global Soil Map [Electronic resource]. Canberra : CSIRO, 2010-2018. URL: https://data.csiro.au/dap/landingpage?pid=csiro%3A11413 (viewed on November 2, 2018).
Minasny B., McBratney A. 2010. Methodologies for Global Soil Mapping. In: Digital Soil Mapping: Bridging Research, Environmental Application and Operation – 2010. Р. 429-436. DOI: 10.1007/978-90-481-8863-5_34
GLOBALSOILMAP.NET [Electronic resource]. Wageningen : ISRIC World Soil Information, 2008-2018. URL: http://www.globalsoilmap.net (viewed on November 2, 2018).
Soil survey manual. Washington : U.S. Department of Agriculture Handbook, 1993. 639 p.
Burt R. Soil Survey Laboratory Methods Manual. In: Soil Survey Investigations Report. 2004. No. 42. 700 p. URL: https://www.nrcs.usda.gov/Internet/FSE_DOCUMENTS/nrcseprd1026807.pdf
Global Soil Partnership : The five pillars of action, FAO Global Soil Partnership [Electronic resource] : [Website]. Electronic data. Rome : FAO-GSP, 2018. URL: http://www.fao.org/globalsoilpartnership/the-5-pillars-of-action/en/ (viewed on November 2, 2018).
Baritz R., Erdogan H., Fujii K. Harmonization of methods, measurements and indicators for the sustainable management and protection of soil resources. Rome : Global Soil Partnership, FAO, 2014. 44 p.
GlobalSoilMap 2015. Specifications – Tiered GlobalSoilMap products (Release 2.4), 52 p. URL: https://www.researchgate.net/publication/283156396_The_GlobalSoilMap_project_specifications
Omuto C., Nachtergaele F., Vargas R. State of the Art Report on Global and Regional Soil Information: Where are we? Where to go?, Rome : FAO, 2012. 69 p. URL: http://www.fao.org/3/a-i3161e.pdf
PostgressSQL [Electronic resource] : [Website]. Electronic data. California : The PostgreSQL Global Development Group, 1996-2019. URL: http://www.postgresql.org/docs/9.2/static/index.html (viewed on November 2, 2018).
Batjes N.H., Ribeiro E., van Oostrum A., Leenaars J.G.B., Hengl T., Mendes De Jesus J., 2016. WoSIS: providing standardised soil profile data for the world. Earth Syst. Sci. Data 9, 1–14. DOI: http://dx.doi.org/10.5194/essd-9-1-2017.
Web soil survey [Electronic resource]. Washington : United States Department of Agriculture, 2018. URL: http://websoilsurvey.nrcs.usda.gov (viewed on November 2, 2018).
Effland W.R., Helms D., Eswaran H., Reich P., Waltman S., Yeh A. 2006. A digital collection of selected historical publications on soil survey and soil classification in the United States of America. Soil survey division. Washington, DC: USDA Natural Resources Conservation Service. URL: https://www.nrcs.usda.gov/wps/portal/nrcs/detail/soils/survey/publication/?cid=stelprdb1256535
Laroche B., Richer de Forges A.C., Leménager A., Arrouays D., Schnebelen N., Eimberck M., et al. 2014. Le programme Inventaire Gestion et conservation des Sols. Volet Référentiel Régional Pédologique. Etude et Gestion des Sols. 21:125–140.
Grundy M.J., Viscarra Rossel R.A., Searle R.D., Wilson P.L., Chen C., Gregory L.J. 2015. Soil and landscape grid of Australia. Soil Research. 53:835–844 .DOI: https://doi.org/10.1071/SR15191
McKenzie N.J., Jacquier D.W., Gregory L.J. 2008. Chapter 24. Online Soil Information Systems – Recent Australian Experience. In: A.E. Hartemink et al. (eds.), Digital Soil Mapping with Limited Data. Springer Science+Business Media B.V. P. 283-284.
Akpa S.I.C., Odeh I.O.A., Bishop T.F.A., Hartemink A.E., Amapu I.Y. 2016. Total soil organic carbon and carbon sequestration potential in Nigeria. Geoderma. 271. P. 202–215. DOI: https://doi.org/10.1016/j.geoderma.2016.02.021
Sulaeman Y., Minasny B., McBratney A.B., Sarwani M., Sutandi A. 2013. Harmonizing legacy soil data for digital soil mapping in Indonesia. Geoderma. 192. P. 77–85. URL: https://www.academia.edu/3326578/Harmonising_legacy_soil_data_for_digital_soil_mapping_in_Indonesia
Nikodemus O., Kasparinskis R. , Karklins A. Development of Digital Land and Soil Database of Latvia for support of sustainable land management. Final Report, Ministry of Agriculture. 2016.
Ivanov A.L., Shoba S.A. Unique state register of soil resources of Russia. Moscow : V.V. Dokuchaev Soil Science Institute. 2014. 768 p .
Ramos T.B., Hortab A., Goncalvesc M.C., Piresc F.P., Duffyd D., Martinsc J.C. 2017. The INFOSOLO databaseas a first step towards the development of a soil information system in Portugal. Catena. 158. P. 390–412. DOI: https://doi.org/10.1016/j.catena.2017.07.020
Weynants M., Montanarella L., Tóth G., Strauss P., Feichtinger F., Cornelis W., et al., 2013. European Hydropedological Data Inventory (EU-HYDI). EUR – Scientific and Technical Research Series. Publications Office of the European Union, Luxembourg. 168 p. URL: https://biblio.ugent.be/publication/5988012/file/5988022.pdf
Van Orshoven J., Maes J., Vereecken H., Feyen J. 1991. A procedure for the statistical characterization of the units of the Belgian soil map. Pedologie. XLI-3. P. 193-212. URL: https://www.researchgate.net/profile/Jan_Feyen/publication/279705431_A_procedure_for_the_statistical_characterization_of_the_units_of_the_Belgian_soil_map/links/559e532308aeb45d171623b9/A-procedure-for-the-statistical-characterization-of-the-units-of-the-Belgian-soil-map.pdf
Van Orshoven J., Maes J., Vereecken H., Feyen J., Dudal R. 1988. A structured database of Belgian profile data. Pedologie. 38. P. 191-206.
Bezu T.B. Building a soil information system for multi-source data integration. In: A case study in Lake Naivasha area, Kenya. ITC, Enschede, 2001. 133 p. Avalable at: URL: https://sites.google.com/site/naivasharesearch/Home/scientific-publications/msc-theses
Reeve D.E., Petch J.R. GIS, Organisations and People: A Socio-technical Approach. In: GIS for Beginners. London : Taylor & Francis Ltd. 1999. 232 p.
Elmasri R., Navathe S.B. Fundamentals of Database Systems. The Вenjamin. Cummings publishing C, Inc. Redwood California. 1989. 1201 p.
Laktionova T.N., Medvedev V.V., Savchenko K.V., Bigun O.N., Sheiko S.N., Nakisko S.G. 2012. Soil properties database of Ukraine (structure and operating procedure). 2nd edition. CT No1, Kharkiv. 150 p. (Rus.).
Laktionova T.M. 2018. The experience of creating and using seven soil databases in the Soil-Geoeocophysics Laboratory. Agrochemistry and Soil Science. Collected papers. No. 87. Kharkiv: NSC ISSAR, P. 63-71. (Ukr.). DOI: https://doi.org/10.31073/acss87-10.
Downloads
Published
Issue
Section
License
This work is distributed under the Creative Commons Attribution-NonCommercial 4.0 International License.
