Home

SDBm Plus - Evenor Tech

1. CODE VOIDS TYPE TIPO DE HUECOS TYPE DES VIDES PORENART interstitial pores poros intersticiales pores interstitiels B vesicles poros vesiculares v sicules Bl schen V vughs cavidades cavit s C channels canales chenaux Kan le P planes poros planos CODE POROSITY POROSIDAD POROSIT POROSITAT 0 very low porosity muy baja porosit tr s basse sehr niedrige Porositat L low porosity baja porosit basse niedrige Porositat M medium porosity media porosit moyenne mittlere Porositat H high porosity elevada porosit lev e hohe Porositat V very high porosity muy elevada porosit tr s lev e sehr hohe Porosit t 2 6 Concentrations CODE CUTANTS QUANTITY CANTIDAD DE CUTANES ABONDANCE DE CUTANES 0 none ninguna n ant keine V very few muy poca tr s peu sehr wenige F few poca peu wenige C common frecuente fr quents einige M many mucha nombreux viele A abundant abundante abondantes D dominant dominante dominant dominant CODE CUTANTS CONTRAST CONTRASTE DE CUTANES NETTET DES CUTANES KONTRAST DER KUTANE F faint indiferenciado faibles schwach D distinct definido distincts klar ausgepr gt P prominent destacado prononc s sehr ausgepr gt CODE CUTANTS NATURE NATURALEZA DE CUTANES NATURE DES CUTANES MATERIAL DER KUTANE CL clay arcillosas argileux purs Ton CS clay sesquioxides cutans sesqui xido arcillosas argileux sesquioxydes Ton Sesquioxid Kutane CH clay humus cutans arcillo h
2. Code FAO 90 classification Location CH nan EE EE gt proyectos 030 visals distritos cipales de Castelldefe B0301 Luvisols Distritos municipales de Castelldefel gt SDBmHYPRES 2 Calcic Luvisol Distritos municipales de Castelldefel 3 Luvisols Distritos municipales de Castelldefel 4 Luvisols Distritos municipales de Castelldefel 5 Calcic Luvisol Distritos municipales de Castelldefel 6 Luvisols Distritos municipales de Castelldefel H Luvisols Distritos municipales de Castelldefel 8 Calcic Luvisol Distritos municipales de Castelldefel M 8 Calcic Luvisol Distritos municipales de Castelldefel C proyectos SDBmHYPRES Export Soil variables General information Physical analysis Replace Horizon description Hydraulic conductivity Add to file Standard analysis Water retention Salts Heavy metals Additional variables Cancel Help Figure 3 14 Export data screen Backup Restore This option allows the user make backup copies into a file and restore them if any problem occurs Main option Codes This SDBm Plus main option facilitates effective database management of most of the descriptive field data needed to be stored in a coded format Storage of coded data and metadata reduces the size of the database and what is equally important it standardizes the descriptive data and thus allows for selection comparison and validity control Data The coding system gives the class co
3. 3 24 Ga Ge e SDBmPlus FAO CSIC MULTILINGUAL SOIL PROFILE DATABASE For using in soil monitoring and evaluation systems Version 1 00 ORGANIZACI N DE LAS NACIONES UNIDAS PARA LA AGRICULTURA Y LA ALIMENTACI N CONSEJO SUPERIOR DE INVESTIGACIONES CIENT FICAS CSICARNAS Sevilla Figure 3 24 Help screen Chapter 4 Soil profile outputs The SDBm Plus system gives access to a range of functions to report the stored data and metadata on soil profiles These reports or outputs can be displayed on screen printed or exported as text files basically as HTML reports The output files with the HTML extension are kept in the directory designed by the user Examples of the SDBm soil profile outputs basically printouts are shown in this chapter STORED SOIL PROFILES LIST A printout with the list of current stored soil profiles Figure 4 1 is generated using the Main option Content Chapter 3 For each soil profile stored this list includes the profile code FAO classification location and type of stored information morphological M photographical P analytical A physical F and hydraulic H data MORPHOLOGICAL DESCRIPTION A printout with the conventionally accepted morphological description i general ii horizons and iii photographs of a selected soil profile Figure 4 2 is generated using the Main options Content and Search Chapter 3 This soil profile morphological description
4. 1995 which has been developed by CSIC IRNAS with the collaboration of FAO AGLL through a joint project Letter of Agreement PR 15621 7 12 1999 during 1999 and 2000 The initial version of SDBm was the SDB database FAO ISRIC World Soil Resources Reports 64 1989 As its predecessors SDBm Plus is an open system which can be modified in the future SDBm Plus has been totally re designed and re written as a WINDOWS application It is a user friendly software designed to harmonise store and use large amounts of geo referenced soil profile data elaborated in the field and the laboratory in an efficient and systematic way The soil profile database can be utilised regardless of scale at regional national or local level in soil monitoring and evaluation M amp E The main characteristics of this database are the following i software development for WINDOWS platforms ii multilingual function and automatic translation from English as source language to other target languages so far Spanish French and German iii detailed soil profile characterisation following the conventional procedures of soil survey making use of assist menus in the selected language which greatly facilitates data storage iv possibility of monitoring the temporal variability of analytical physical and hydraulic soil properties v metabase facility to describe the methods used in the laboratory analysis and vi interface facility to automatize the linkage of
5. Codes coding system which offers the classification and class codes of all the variables used in the soil profile description 3 2 Content option which shows the list of soil profiles or views or prints a selected soil profile description Search selection engine which searches soil profiles based on the presence of one or more variables with specified values Customise this option de activates fields to facilitate and speed up the data entry Language selects or creates a new working language Evaluation interface which allows the database to be utilised as a source of input data for land systems GIS or LES models Help gives access to the user manual and to basic information about the programme Main option File The database operations related to the entry and exit of soil data are made possible by this SDBm Plus main option Input Edit Delete Input Edit data The button is used to enter new profile descriptions and or laboratory data into the database The following set of input data screens appear one after the other O 0 0 D 0 0 Block 1 General information screens Figure 3 2 and 3 3 Block 2 Horizon description screen Figure 3 4 Block 3 Standard analyses screen Figure 3 5 Block 4 Soluble salts heavy metals screen Figure 3 6 Block 5 Physical analyses screen Figure 3 7 Block 6 Water retention screen Figure 3 8 Blo
6. Fragments de roches Cartact ristiques tranchantes pH du champ Tiefe muB eine unabh ngige Variable sein Dicke der Schicht Art der Berechnung dominanter Wert Felder f r allgemeine Informationen Registrierung Bodenklassifikation Eigenschaften der Oberfl che Verh ltnis Boden Wasser Felder zur Beschreibung der Bodenhorizonte Bodenfarbe Poren und Porosit t Konzentrationen Biologische Aktivit t Bodenreaktion Horizontbegrenzung Farbe der Matrix Gesteinsreste pH im Feld D 14 Standard analyses fields General data Very Coarse Coarse Medium Fine Very fine Soluble salts heavy metals fields Select directory and type of output file Type of output file Separator Campos de datos anal ticos generales Datos generales Muy gruesa Gruesa Media Fina Muy fina Campos de datos de sales solubles metales pesados Seleccionar directorio y tipo de archivo de salida Tipo de archivo de salida Separador Champ d analyses standards Donn es g nerales tr s grossier Grossier Moyen Fin Tr s fin Sels solubles champs de m taux lourds Choisir r pertoire et type d archive output type d archive d output Separateur Felder f r Standardanalysen Allgemeine Daten sehr grob grob mittel fein sehr fein l sliche Salze Schwermetalle W hlen Sie directory und den des output files Typ des output files Seperator D 15 Appendix E Technical informati
7. H Hydraulical data P Photographs Figure 4 1 Example of stored soil profiles list printout SDBm Plus FAO CSIC Multilingual Soil Profile Database SOIL PROFILE DESCRIPTION Profile code SE0305 Date 1 06 76 Sheet 1020 Coordinates N370700 W 054720 Survey area Zonas Agricolas del Bajo Guadalquivir Elevation 18 location Finca El Pinganillo Utrera Administrative unit La Campi a Authors Jose L Arrue FAO 90 classification Calcic Vertisol Soil climate WRB 98 classification Vertisol Calcic Local soil classification serie USDA 87 classification Pelloxerert Land use Annual field cropping Topography Flat Human influence Land form Plain Crops Wheat Land element depression Vegetation Position Species Slope 2 8 Grass cover Micro topography Parent material Drainage Effective soil depth gt 150 Water table Rock outcrops Flood Surface stoniness Moisture conditions Erosion Sealing crusts Remarks PROYECTO METALES PESADOS SUELOS DE ANDALUCIA MEPESA ARRUE UGARTE J L 1976 Factores qu micos fisico qu micos y f sicos determinantes de los caracteres propiedades y din mica de la porosidad de los suelos Tesis Doctoral Universidad de Sevi Horizon Depth cm Morphological description Ap 0 30 Very dark gray 10YR 3 1 moist and Light gray to gray 10YR 6 1 dry clay weak medium subangular prismatic parting into fine structure hard
8. HHH HHH 3 0 9 0 0 0 10 0 0 00 4 00 0 00 4 00 0 00 1 00 0 00 20 0 HHHH 0 00 1 00 0 00 3 00 0 0 20 0 0 00 5 00 0 0 40 0 2 0 20 0 0 01 2 00 3 0 25 0 3 150 2 250 0 01 0 50 10 3000 0 1 40 0 3 100 3 200 0 2 10 0 0 01 12 00 3 1000 string string HHH HHH Actual water content cm3 cm3 Bulk density g cm3 Resistance to penetration Mpa Stability index Particle density g cm3 Total porosity cm3 cm3 Saturated hydraulic conductivity cm d Block 6 WATER RETENTION HYDRAULIC CONDUCTIVITY Sample code Date Depth cm upper lower Suction 1 to 25 entries cm bar or kPa Water content 1 to 25 entries cm cm or g 100g Hydraulic conductivity 1 to 25 entries cm d or mm s Block 7 ADDITIONAL ANALYTICAL VARIABLES Sample code Date Additional variable 1 Additional variable 2 Additional variable 3 Additional variable 4 Additional variable 5 Additional variable 6 Additional variable 7 Additional variable 8 Additional variable 9 Additional variable 10 Block 8 PHOTOGRAPHS Profile site Soil profile Other Block 9 METADATA Method used for each analytical variable The corresponding field name of each soil variable can be find in the Appendix E 0 2 0 6 1 0 1 7 0 01 7 00 TH E 2 55 2 85 0 3 0 6 0 001 100 string string HHH HEH HHHH HH ZE HH HHH
9. SDBm Plus FAO CSIC Multilingual Soil Profile Database Input data A ST Double click to see the coding system Figure 3 9 Input data soil hydraulic conductivity screen SDBm Plus FAO CSIC Multilingual Soil Profile Database Input data EE Double click to see the coding system Figure 3 10 Input data soil additional variables screen SDBm Plus FAO CSIC Multilingual Soil Profile Database Input data E Right mouse button to see the menu Figure 3 11 Input data soil photographs screen The metadata or method used for the analytical variables are entered on the same screen and after each analytical data The coded general and horizon information is entered according to the SDBm Plus coding system Appendix B and making use of the pop up coding windows Windows showing codes and definitions of the field on which the cursor is positioned can be opened from the input screen pressing the F key or double clicking In order to facilitate data entry tasks normally tedious and slow these tables of conversion which are arranged alphabetically by definition can be displayed for each coded variable Codes are entered in the entry form using the selection bar to locate the desired definition and then pressing the Enter key Figure 3 12 shows an example of a pop up window from the general information screen This window shows a list of valid codes and thus avoids checking the manual for
10. AR28 Argic Lithic GR09 Grossarenic Kanhaplic PE06 Petrocalcic Ustalfic AR30 Argic Pachic GR10 Grossarenic Kanhaplic PE08 Petrocalcic Ustollic Rhodic USDA 87 CLASSIFICATION FAMILIES Mineralogy 03 allitic 16 ferrigenous 28 kaolinitic 40 oxidic 05 carbonatic 18 gibbsitic 30 marly 44 serpentinitic 08 coprogenous 20 glauconitic 32 micaceous 46 siliceous 09 chloritic 22 gypsic 34 mixed 50 vermiculitic 10 diatomaceous 24 halloysitic 35 mixed calcareous 12 ferrihumic 26 37 montmorrilonitic 14 ferritic 27 illitic calcareous 38 montmorrilonitic calc Texture 003 cindery 020 medial o loamy skeletal 056 clayey skeletal 098 fine loamy o fragmental 004 cindery over sandy 022 medial over sandy 058 clayey skeletal o sandy 100 fine loamy o sandy skel 005 ashy 024 medial o thixotropic 062 sandy 102 fine loamy o clayey 006 cindery over loamy 026 thixotropic 063 sandy or sandy skeletal 106 fine silty 007 ashy over cindery 027 thixotropic skeletal 064 sandy over clayey 108 fine silty o fragmental 008 ashy over loamy 028 thixotropic o fragmental 066 sandy over clayey 110 fine silty o sandy 009 ashy skeletal 030 thixotropic o sandy sk 068 loamy 112 fine silty o clayey 010 medial 032 thixotropic o loamy skel 072 loamy over sandy skel 114 clayey 011 medial skeletal 034 thixotropic over loamy 080 coarse loamy 116 clayey over fragmental 012 medial o cindery 036 fragmental 082 coarse loamy o fragmental 118 clayey over sandy 013 ashy over loa
11. AR52 BO BO02 BO04 BO06 BO08 BO10 BO12 CA CA04 CA06 CA10 CA20 Argic Vertic Aridic Aridic Calcic Aridic Calcic Aridic Duric Aridic Duric Aridic Pachic Aridic Petrocalcic Boralfic Boralfic Lithic Boralfic Udic Borollic Borollic Glossic Borollic Lithic Borollic Vertic Calcic Calcic Pachic Calciorthidic Calcixerollic Cambic Chromic Chromudic Cryic Cryic Lithic Cryic Pachic Cumulic Cumulic Udic Cumulic Ultic Durargidic Duric GR11 GR12 GR13 GR14 GR15 1 HA02 HA05 HA07 HA09 HA12 HA16 HE02 HI HI02 HI06 HU HU02 HU05 HU06 HU10 HU15 HU20 HY HY02 IN KA KA02 Grossarenic Rhodic Grossarenic Petrocalcic Grossarenic Ustollic Grossarenic Ustalfic Grossarenic Aridic Haplaquodic Haplaquic Haplic Haplohumic Haploxerollic Hapludic Hapludollic Haplustollic Hemic Hemic Terric Histic Histic Lithic Histic Pergelic Humic Humic Lithic Humic Pergelic Humoxic Humaqueptic Humic Rhodic Humic Xanthic Hydric Hydric Lithic Inceptic Kandic Kandiudalfic PE14 PE16 PE17 PE20 PK PK10 PK12 PL04 PL06 PS PS02 PS04 PS06 PS08 PS09 PS10 RE RH RU02 RU09 RU11 RU15 RU17 RU19 SA SA02 SA04 SI Petrocalcic Xerollic Petroferric Petroferric Rhodic Petrogypsic Placic Plaggeptic Plaggic Plinthaquic Plinthic Plinthudic Psammaquentic Psammentic Psammentic Kandic Psammentic Rhodic Psammentic Kandic Rhodic Psammentic Ustollic Psammentic U
12. ENOO EO00 EPO EQ00 ES00 ETOO EUO0 EVOO EWOO EX00 EYOO EZ00 FA00 Rhodic Ruptic Ruptic Alfic Ruptic Histic Ruptic Lithic Ruptic Ultic Salic Salidic Sapric Sodic Sodic Ustic Sodic Xeric Sombric Sphagnic Spodic Sulfaqueptic Sulfic Sulfuric Terric Thaptic Thapto Histic Torrertic Torrifluventic Torriorthentic Torripsammentic Torroxic Udandic Udertic Udic Udifluventic Udollic Udorthentic Udoxic AS00 ATOO ATO1 AUO1 AUO2 AUO4 AUO5 AUO6 AUO8 AUO9 AVOO AWOO AX00 AY00 AZ00 AZ01 AZ02 AZ03 AZ04 AZ05 AZ06 AZ07 BA00 Aqueptic Aquertic Aquertic Chromic Aquic Aquic Arenic Aquic Cumulic Aquic Duric Aquic Durinodic Aquic Dystric Aquic Humic Aquic Lithic Aquic Natrargidic Aquic Petroferric Aquicambidic Aquodic Aquollic Aquultic Arenic Arenic Aridic Arenic Plinthaquic Arenic Plinthic Arenic Rhodic Arenic Ultic Arenic Umbric Arenic Ustic Argiaquic BS00 BS01 BT00 BIO BUOO BV00 BV01 BW00 BX00 BY00 BY01 BY02 BZ00 BZ01 CA00 CB00 CB01 CC00 CD00 CD01 CD02 CD03 CE00 CF00 CG00 CG01 Fluvaquentic Fluvaquentic Vertic Fluventic Fluventic Humic Fragiaquic Fragic Fragic Oxyaquic Glacic Glossaquic Glossic Glossic Ustic Glossic Vertic Grossarenic Grossarenic Plinthic Gypsic Halic Halic Terric Haplargidic Haplic Haplic Haploxerollic Haplic Palexerollic Haplic Ustic Haplocalcidic Haploduridic Haploxer
13. Glossic Chernozem Haplic Chernozem Calcic Chernozem Luvic Chernozem Podzoluvisols Dystric Podzoluvisol Eutric Podzoluvisol Gleyic Podzoluvisol Rendzinas Ferralsols Acric Ferralsol Humic Ferralsol Orthic Ferralsol Plinthic Ferralsol Rhodic Ferralsol Xanthic Ferralsol Gleysols HC HH HL JC JD JE JT Calcaric Phaeozem Gleyic Phaeozem Haplic Phaeozem Luvic Phaeozem Lithosol Fluvisols Calcaric Fluvisol Dystric Fluvisol Eutric Fluvisol Thionic Fluvisol Kastanozems Haplic Kastanozem Calcic Kastanozem Luvic Kastanozem Luvisols Albic Luvisol Chromic Luvisol Ferric Luvisol Gleyic Luvisol Calcic Luvisol Orthic Luvisol Plinthic Luvisol Vertic Luvisol Greyzems Gleyic Greyzem Orthic Greyzem Gelic Histosol Podzols Ferric Podzol Gleyic Podzol Humic Podzol Leptic Podzol Orthic Podzol Placic Podzol Arenosols Albic Arenosol Cambic Arenosol Calcaric Arenosol Dystric Arenosol Eutric Arenosol Ferralic Arenosol Calcic Arenosol Luvic Arenosol Petrocalcic Arenosol Regosols Calcaric Regosol Dystric Regosol Eutric Regosol Gelic Regosol Solonetz Gleyic Solonetz Mollic Solonetz Vertisols Chromic Vertisol Pellic Vertisol Planosols Dystric Planosol Eutric Planosol Humic Planosol Mollic Planosol Solodic Planosol Gelic Planosol Xerosols Haplic Xerosol Calcic Xerosol Luvic Xerosol Gypsic Xerosol Yermosols Haplic Yermosol Calcic Yermosol Luvic Yermosol Takyric Yermoso
14. N370250 W052625 170 BN 570 607 480 100 80 60 740 10 250 VA HI HI HI HI HI HI HI MO VA HI HI HI HI HI VA HI HI HI VA HI LAEL SLGR STOQ STOS VA SL SL SL SL SL SL SL SL SL SL VA SL SL SL SL SL VA SL SL SL SL VA SL Em uo WU Eu uo bm bo ou b b U gt lt lt lt lt lt 7552552 222322 2 CROL 1135 FR OL OL OL FR FR OL Figure 4 8a Example of LEIS GIS input file Main file El_ADMINUNIT DBF NUTA p NUTA CAOL Campi a de Cadiz CAO2 Carrpo de Gibraltar CAOA De la J anda COOL Carrpi a Alta COCO2 Carrpi a Baja COO5 Pedroches COO6 Penibetica HOL Andevalo Occidental HO2 Andevalo Oriental HO3 Condado Carrpi a HO Condado Litoral HO5 Costa HOG Siera SEOL De Estepa SEO2 El Aljarafe SEO3 La Carrpi a SEO4 La Sierra Norte SEO5 La Vega SEO7 Sierra Sur El_USDAS7GROUP DBF STG D STGG AXA Haploxeralf AXB Palexeralf AXR Rhodoxeralf EOX Xerorthent Fluvaquent ER Aert EVX Xerofluvent IMX Xerumbrept IOE Eutrochrept Xerochrept MXA Haploxeroll UXB Palexerult VXL Pelloxerert VXR Chrorroxerert EL LANDFORM DBF LAFO D LAFO HI hill MO mountain PT plateau VA valley E1_STONESABUNDANC DBF STOQ nil A abundant F few M nany V very few EL LANDUSE DBF LUT Dur
15. O Block 2 Soil horizon description Information on the soil morphological and other characteristics are described horizon by horizon O Block 3 Standard analyses Information on the standard analysis results in the soil survey characterization studies O Block 4 Soluble salts Heavy metals Information on the most frequent soluble salts in the soil which are interesting from agricultural point of view and on the most important trace elements related to soil contamination O Block 5 Physical data Information on soil physical determinations which used to be input data for crop simulation models and land evaluation systems O Block 6 Water retention Hydraulic conductivity Information on detailed water economy in soil for specific use in mechanistic simulation modelling O Block 7 Additional analytical variables A total of up to 10 specific soil characteristics such as soil cohesion internal friction angle preconsolidation stress void load relationship etc O Block 8 Photographs Digitized information on site soil profile and other plates Block 9 Metadata Information on the procedures and methods followed for elaborating soil analysis data rm vm mee em A Stored Derived variables variables mne File Evaluation Language S D B Im P u S SSES Languages Customi change database Content Search Evaluation Text table Text table yn LES GIS input
16. Rome Horn R De la Rosa D Rajkai K Dexter T Simota C 1999 SIDASS A spacially distributed model predicting the dynamics of agrophysical soil state within eastern and western European countries for the selection of management practices to prevent soil erosion Project Work Program INCO Copernicus IC15 CT98 0106 project DG CEC Page A L et al Eds 1982 Methods of soil analysis Part 2 Chemical and microbiological properties American Society of Agronomy Inc Madison Rayment G E and Higginson F R 1992 Australian laboratory handbook of soil and water chemical methods Intaka Press Melbourne Simota C and Mayr T 1996 Pedotransfer functions In Loveland et al Eds EuroACCESS Agroclimatic change and European soil suitability Cranfield Univ Pub Silsoe UK USDA 1984 Procedures for collecting soil samples and methods of analysis for soil survey Soil Survey Staff Pub US Govt Printing Office Washington DC USDA 1987 Soil taxonomy A basic system of soil classification for making and interpreting soil surveys USDA Handbook Washington DC USDA 1998 Keys to soil taxonomy Eighth Edition Soil Survey Staff USDA Handbook Washington DC SOFTWARE USED BORLAND C Builder Version 5 2000 Borland International Inc HTML Report Version 3 1 2000 ProGa Inc Appendix A List of stored soil variables VARIABLE DESCRIPTION TYPE RANGE Profile code string Block 1 G
17. horizon by horizon which follows the Guidelines for Soil Profile Descriptions FAO ISRIC 1990 15 intended to enhance the standardisation and comparison of soil descriptions ANALYTICAL DATA TABLES Several printouts with the analytical data tables i general analyses ii particle size iii soluble salts iv heavy metals v physical properties vi water retention and vii hydraulic conductivity of the soil profile previously selected Figure 4 3 can be generated using the Main options Content and Search Chapter 3 This set of seven analytical data tables can be enlarged sample by sample if any block of data has been determined for more than one date SDBm Plus FAO CSIC Multilingual Soil Profile Database Profiles list Profile FAO 90 classification Location Data type SE0211 Cambisols Finca El Aljarafe La Hampa Km 13 5 de lac MAFH SE0305 Calcic Vertisol Finca El Pinganillo Utrera MAFH SE0306 Vertisols Las Marismas de Lebrija MAFH SE0403 Fluvisol Guillena Finca Torre de la Reina MAFH SE0502 Calcic Luvisol La Rinconada Finca Casa de las Vacas MAFH SE0503 Cambisols Finca La Hampa MAFH SE0504 Fluvisol Finca La Suerte Tocina MAFH SE0505 Fluvisol Finca El Aljarafe La Hampa Km 13 5 de lac MPAFH SE0601 Salic Fluvisol Puebla del Rio Finca La Mejorada MAFH SE0602 Salic Fluvisol Puebla del Rio Finca La Mejorada MAFH M Morphological data A Analytical data F Physical data
18. micas argileux humiques Ton Humus Kutane PF pressure faces caras de presi n faces de pression SL slickensides slickensides faces de glissement Slickensides SP partly intersecting slickensides slickensides parcialmente faces de glissement partiellement sich kreuzende Slickensides disectadas entrecoup es SI predominantly intersecting slickensides predominantemente faces de glissement entrecoup es sich teilweise kreuzende slickensides disectadas Slickensides CODE CUTANTS LOCATION UBICACI N DE CUTANES LOCALISATION DES CUTANES FUNDORT DER KUTANE PF on pedfaces en las caras de los agregados en surface des agr gats an nat rlichen Aggregaten PV on vertical pedfaces en las caras verticales de los sur les faces verticales des an nat rlichen vertikal gelagerten agregados agr gats Aggregaten PH on horizontal pedfaces en las caras horizontales de los sur les faces horizontales des na nat rlichen horizontal gelagerten agregados agr gats Aggregaten PO in pores en los poros dans les pores in den Poren LA lamellae formando lamelas en lamelles bl ttrig lamellenartig CF coarse fragments fragmentos gruesos fragments grossiers grobe Bruchst cke NS not specified no especificado no especifi e nicht bestimmt CODE CEMENTATION CONTINUITY CONTINUIDAD DE CONTINUIT DES KONTINUITAT DER CEMENTACIONES CIMENTATIONS ZEMENTIERUNG 0 no no n ant nein D discontinuous discontinua discontinue nicht zusammenh ngend C continuous con
19. re fein bis grob MV medium to very coarse medio a muy grueso de moyenne tr s grossi re mittel bis sehr grob FF fine and very fine fino y muy fino fine et tr s fine fein und sehr fein CODE STRUCTURE TIPE TIPO DE ESTRUCTURA TYPE DE STRUCTURE STRUKTURART GR granular granular granulaire k rnig CR crumb migajoso grumeleuse klumpig kr melig PR prismatic prism tico prismatique prismenartig SB subangular blocky en bloques subangulares poly drique sub angulaire subpolyedrisch AB angular blocky en bloques angulares poly drique angulaire polyedrisch AW wedge shaped angular blocky en bloques angulares cuneiformes poly drique angulaire en fuseaux keilf rmig polyedrisch CO columnar columnar en colonnes saulenformig PL platy laminar feuillet e plattig SA subangular and angular blocky en bloques angulares y poly drique angulaire et sub subpolyedrisch und polyedrisch subangulares angulaire AS angular and subangular blocky en bloques subangulares y poly drique sub angulaire et polyedrisch und subpolyedrisch angulares angulaire PS subangular prismatic prismatico subangular prismatique subangulaire subpolyedrische Prismen SN nutty subangular blocky bloques en forma de nuez bloc en forme de noix RS rocky structure estructura rocosa structure rocheuse steinige Struktur SS stratified structure estructura estratificada structure stratifi e Schichtstruktur CODE STRUCTURE RELATION RELACI N DE ESTRUCTURA RELATION DE STRUCTUR
20. tre bl ulich schwarz BR brown pardo brune braun BS brownish pardusco brun tres br unlich GR gray gris grises grau GS grayish gris ceo gris tres gr ulich GE green verde vertes gr n RE red rojo rouges rot RS reddish rojizo rouge tres r tlich RB reddish brown pardo rojizo brun rouge tre r tlich braun RY reddish yellow amarillo rojizo jaune rouge tre r tlich gelb WH white blanco blanches wei YE yellow amarillo jaunes gelb YB yellowish brown pardo amarillento brun jaun tre gelblich braun YR yellowish red rojo amarillento rouge jaun tre gelblich rot BA yellowish white blanco amarillento blanc jaunatre gelblich weiR 2 3 Primary constituents CODE TEXTURE TEXTURA TEXTURE K RNUNG C clay arcillosa argile Ton CL clayloam franco arcillosa limon argileux toniger Lehm CS coarse sand arenoso gruesa sable grossier Grobsand CSL coarse sandy loam franco arenoso gruesa limon sableux grossier grobsandiger Lehm FS fine sand arenoso fina sable fin Feinsand FSL fine sandy loam franco arenoso fina limon sableux fin feinsandiger Lehm L loam franca limon Lehm LCS loamy coarse sand areno francoso gruesa sable limoneux grossier lehmiger Grobsand LFS loamy fine sand areno francoso fina sable limoneux fin lehmiger Feinsand LS loamy sand areno francosa sable limoneux lehmiger Sand LVFS loamy very fine sand areno francoso muy fina sable limoneux tr s fin lehmiger sehr feiner Sand MS medium sand arena media sable moye
21. 1 7 Soil water relationships CODE DRAINAGE CLASS CLASE DE DRENAJE CLASSE DE DRAINAGE ENTWASSERUNG V very poor muy pobre tr s pauvre schlecht P poor pobre pauvre schlecht unzureichend imperfect imperfecto imparfait mangelhaft unvollkommen M moderately well moderadamente bueno mod r m ig gut W well bueno normal gut S somewhat excessively algo excesivo l g rement excessif E excessively excesivo excessif berm ig CODE INTERNAL DRAINAGE DRENAJE INTERNO DRAINAGE INTERNE V very slow muy lento tr s pauvre sehr langsam S slow lento pauvre langsam M moderate moderado mod r m ig H high r pido excessif hoch CODE EXTERNAL DRAINAGE DRENAJE EXTERNO DRAINAGE SUPERFICIEL EXTERNE ENTW SSERUNG P ponded impedido tr s pauvre S slow lento pauvre langsam M moderate moderado mod r m ig R rapid r pido excessif schnell CODE FLOOD FREQUENCY FRECUENCIA DE FR QUENCE DES INONDATIONS ANZAHL DER INUNDACIONES BERSCHWEMMUNGEN 0 nil nula n ant keine D daily diaria journali re taglich W weekly semanal hebdomadaire w chentlich M monthly mensual mensuelle monatlich A annually anual annuelle j hrlich B biennually bianual bisannuelle halbj hrlich R rare escasa rare selten F every 2 4 years cada 2 4 a os chaque 2 4 ann alle 2 4 Jahre T every 5 10 ye cada 5 10 a os chaque 5 10 an alle 5 10 Jahre N not known desconocida inconnu unbekannt CODE FLOOD DURATION TIEMPO D
22. 10 35m 4 3 10m 5 lt 3m CODE EROSION DEPOSITION TYPE TIPO DE EROSI N DEPOSICI N TYPE D EROSION DEPOT EROSIONSTYP WG gully erosion erosi n en c rcavas rosion par ravinement Gulli Erosion WR rill erosion erosi n en surcos rosion en rigoles Rinnenerosion WS sheet erosion erosi n laminar rosion en nappe flachenhafte Erosion Massenversatz AM wind erosion deposition erosi n deposici n e lica rosion accumulation olienne Winderosion akkumulation AE wind erosion erosi n e lica rosion olienne Winderosion AD wind deposition deposici n e lica d p t olien Windakkumulation WD deposition by water deposici n por agua d p t aquatique Akkumulation durch Wasser WT tunnel erosion erosi n en t nel rosion souterraine Tunnelerosion CODE EROSION DEPOSITION INTENSIDAD DE EROSION INTENSIT DES D P TS EROSIONSINTENSITAT INTENSITY DEPOSICION 0 nil nula nulle keine SL slight ligera l g re leicht MO moderate moderada mod r e m ig ST strong fuerte forte stark SE severe severa s v re besonders stark E extreme extrema extr me extrem CODE SEALING CRUSTING SELLADO ENCOSTRAMIENTO CIMENTATION CUIRASSE VERSIEGELUNGSKRUSTEN 0 nil ninguno n ant keine CR crust costra cuirasse Krusten SL slight sealing ligeramente cementado peu ciment leichte Versiegelung MO moderate sealing moderadamente cementado fortement ciment m ige Versiegelung ST strong sealing fuertemente cementado indur starke Versiegelung
23. Example of soil profile graphical presentation printout Vertical distribution E water retention iof x Soil profile SE0305 Sample A Suction cm 0 0 01 02 03 04 05 06 OF 08 OF 1 0 Water content cm3 cm3 Figure 4 4b Example of soil profile graphical presentation printout Suction vs water content SDBm Plus FAO CSIC Multilingual Soil Profile Database Database content Variables pH H20 ph Cacl2 Electrical conductivity Phosphorus Nitrogen Carbon Total calcic carbonate Effective calcic carbonate Calcic sulphate Cation exchange capacity Exchangeable calcium 294 98 17 31 204 301 275 144 144 Minimum 3 9 CA0510 3 CA0510 1 09 SE0601 0 53 100501 0 CA0509 0 CA0507 0 SE0502 14 5 CO0205 N A 3 23 CA0503 0 07 CA0506 STATISTICAL SUMMARY Maximum 8 8 SE0601 7 5 CA0504 3 5 SE0602 85 CA0104 1 42 CA0510 59 02 CA0507 69 38 0503 15 8 CO0205 N A 132 22 CA0514 59 78 CA0508 Figure 4 5 Example of statistical summary printout Mean 7 20 5 59 1 98 14 42 0 28 4 57 16 09 15 23 N A 40 85 19 14 o 1 06 1 38 0 81 16 66 0 46 9 48 14 56 2 27 N A 32 20 14 83 CV 14 77 24 73 40 70 115 55 160 58 207 62 90 49 14 90 N A 78 81 77 47 SDBm Plus FAO CSIC Multilingual Soil Profile Database Input
24. Inhalt der Datenbank Anzahl der Profile MorphologischeDaten Analytische Daten Physikalische Daten Hydraulische Daten Drucken Ansehen FAO 90 Klassifikation WRB 98 Klassifikation USDA 87 Klassifikation Profil D 11 Soil profile description Coordinates Rock outcrops Surface stoniness Horizon Morphological description Multicoloured and in dry in moist in wet by in Sample Soluble salts Graphical presentation Determinations Vertical variability Descripci n del perfil de suelo Coordenadas Afloramientos rocosos Pedregosidad superficial Horizonte Descripci n morfol gica Abigarrado y en seco en h medo en mojado por en Muestra Sales solubles Representaci n gr fica Determinaciones Variabilidad vertical Description du profil du sol Coordonn es Roche affleurante Gravellosit de la surface Horizon Description morphologique Multicolor Et A sec A humide A mouill Par En Echantillon Sels solubles Pr sentations graphiques Determinations Variabilit verticale Beschreibung des Bodenprofil Koordinaten Rock outcrops Skelettanteil Steingehalt an der Oberfl che Horizont Morphologische Beschreibung vielfarbig und trocken feucht Probe l sliche Salze graphische Darstellung Bestimmungen vertical variability Searchs ENGLISH SPANISH FRENCH GERMAN Search fields Campos de b squeda Chercher champs gesuchte Felder Key C
25. LXH LXF LXP LXA LXJ LXG AC ACH ACF ACU ACP Umbric Planosol Gelic Planosol Podzoluvisols Eutric Podzoluvisol Dystric Podzoluvisol Stagnic Podzoluvisol Gleyic Podzoluvisol Gelic Podzoluvisol Podzols Haplic Podzol Cambic Podzol Ferric podzol Carbic Podzol Gleyic Podzol Gelic Podzol Lixisols Haplic Lixisol Ferric Lixisol Plinthic Lixisol Albic Lixisol Stagnic Lixisol Gleyic Lixisol Acrisols Haplic Acrisol Ferric Acrisol Humic Acrisol Plinthic Acrisol FRG FRP PT PTE PTD PTU PTA CM CME CMD CMU CMC CMX CMV CMO CMG CMI CMJ AT ARA ATC ATF ATU HS HSL HSS HSF HST HSI Geric Ferralsol Plinthic Ferralsol Plinthosols Eutric Plinthosol Dystric Plinthosol Humic Plinthosol Albic Plinthosol Cambisols Eutric Cambisol Dystric Cambisol Humic Cambisol Calcaric Cambisol Chromic Cambisol Vertic Cambisol Ferralic Cambisol Gleyic Cambisol Gelic Cambisol Stagnic Cambisol Anthrosols Aric Anthrosol Cumulic Anthrosol Fimic Anthrosol Urbic Anthrosol Histosols Folic Histosol Terric Histosol Fibric Histosol Thionic Histosol Gelic Histosol B 4 ANG Gleyic Andosol PHC Calcaric Phaeozem ACG Gleyic Acrisol FAO 90 CLASSIFICATION THIRD LEVEL AL Albi NI Niti EU Eutri MA Mazi FE Ferralo AR Areni DY Dystri GU Grumi CM Cambi GL Gleyi UM Umbri AL Albi AN Andi SO Sodi MO Molli SM Sombri LU Luvi OR Orthi CA Calcari FL Fluvi CH Chrom
26. O lt SDBHORIZ Block 3 9 Standard analyses O lt SDBANA1 i Block 4 9 Salts metals SDBANA2 Block 5 9 Physical analyses PHYSICS gl Block 6 9 Water retention WAT_RET Q N C Block 6 9 Hyd conductivity KUNSAT Block 7 9 Additional variables ADDVARS O ZN Figure 2 2 Structure of the SDBm Plus database tables Date Standard analyses soluble salts and heavy metals physical analyses water content and hydraulic conductivity and additional variables data all maintain a one to many relationship with the general information but also the designation of a sample is made through the combination of the profile code plus the sample code and plus the date when the determinations were performed e g 10 01 2000 With this feature the dataset also has a temporal reference Chapter 3 Software features CONTROL FUNCTIONS SDBm Plus is a standard WINDOWS application using the regular WINDOWS control functions In addition other helpful functions have been implemented most of which are described in this chapter Menu controls Figure 3 1 shows the software main menu or start up screen Mouse clicking on any menu item on this screen opens a sub menu window or an a different screen The Down arrow and Up arrow keys can be used to move through the sub menu and the Enter key to activate the option highlighted SDBm Plus FAD CSIC Multilingual Soil Profile Database Ver
27. both field description and laboratory analysis Commonly their potentials to generate useful information are exploited to only a minimal extent because of the data handling limitations of manual methods of analysis and the summary in written documents of voluminous data recorded in the field By enabling the storage and retrieval of soil profile data in a quick efficient and systematic way SDBm Plus can enhance the exploitation of soil survey data for various purposes In particular it can ease the flow of such data into computerised land evaluation systems LES and land resource based geographic information systems GIS The SDBm Plus FAO CSIC Multilingual Soil Profile Database was developed by CSIC IRNAS with the collaboration of FAO AGLS through a joint project Letter of Agreement PR 15621 7 12 99 This new database draws on the SDBm database previously carried out by FAO ISRIC and CSIC World Soil Resources Reports 81 1995 Its development was funded by the Spanish Ministry of Environment through the SEIS net project Sistema Espa ol de Informacion de Suelos sobre Internet De la Rosa et al 2000 Also important contributions were made by the SIDASS EU project Horn et al 1999 specially for developing the database models interface included in the Main option Evaluation along with the German translation of codes and labels The previous SDB versions has been applied to numerous projects and adopted by various instituti
28. cola agricole Landwirtschaft AA annual field cropping cultivo anual cultures annuelles Jahreskultur AP perennial field cropping cultivo perenne cultures p rennes halbj hrliche Kultur AT tree cropping cultivo arboreo arbre Baumanbau H animal husbandry cria de ganado levage Tierzucht F forestry forestal for t Forst M mixed farming agricultura mixta agriculture mixte gemischte Landwirtschaft E extraction and collection cantera extraction et collection P nature protection zona protegida zone prot g e Naturschutz AF agroforestry system dehesa syst me agro sylvicole SR residential use uso residencial usage r sidence Wohngebiete SI industrial use uso industrial usage industriel Industrie ST roads carreteras routes Strafen SC recreational use uso recreativo usage r cr atif SX excavation excavaci n excavation Ausgrabungen A1 shifting cultivation cultivo migratorio divagation des cultures Wechselwirtschaft A2 fallow system barbecho terre en jach re Brache A3 ley system cultivation prado temporal p ture temporaire A4 rainfed arable cultivo arable inundado culture arable inond e Acker A5 paddy rice cultivation arroz bajo inundaci n culture de riz inond e Reiskultur A6 irrigated cultivation cultivo de riego culture d irrigation Bewasserungskultur CODE HUMAN INFLUENCE INFLUENCIA ANTR PICA INFLUENCE HUMAINE MENSCHLICHER EINFLUSS 0 no influence sin influencia sans influence kein Einfluf FE application of fertilizers fert
29. conglom rat Konglomerat CO conglomerate Pleistocene conglomerado Pleistoceno conglom rat Pl istoc ne Konglomerat Pleistoz n CP conglomerate Pliocene conglomerado Plioceno conglom rat Plioc ne Konglomerat Plioz n DI diorite diorita diorite Diorith DO dolerite dolerita dol rite Dolerith DM dolomite dolomita dolomite Dolomit EV evaporite evaporita vaporite Evaporite GN gneiss gneis gneiss Gneis GR granite granito granite Granit IA igneous rock roca gnea roche ign e LM lime Miocene caliza Mioceno calcaire Mioc ne Kalk Mioz n lime sandstone Miocene lime sandstone Pliocene limestone limestone Cambrium limestone Eocene limestone Jurassic marl marl Cretaceous marl Eocene marl Miocene marl Oligocene marl Trias marl gypsum Pliocene marl gypsum Triassic not known pumice pyroclastic rock quartzite sandstone sandstone Oligocene sandstone Pleistocene schist schist Cambrium schist Triassic sedimentary rock shale shale Cambrium shale Carboniferous shale Devonian shale Devonian siltstone tuff ultrabasic rock arenisca caliza Mioceno arenisca caliza Plioceno caliza caliza C mbrico caliza Eoceno caliza Jur sico marga marga Cret ceo marga Eoceno marga Mioceno marga Oligoceno marga Tr as marga yes fera Plioceno marga yesifera Tri sico desconocida pumita roca pirocl stica cuarcita aren
30. data METADATA REPORT List of methods used for analytical characterization of soil profile General analysis pH water Nitrogen Organic Carbon Total CaCO3 CEC Soil Exchangeable calcium Exchangeable magnesium Exchangeable Potassium Exchangeable Sodium Coarse Sand Fine Sand Sand Silt Clay pH water Phosphorus Nitrogen Organic Carbon Total CaCO3 Coarse Sand Fine Sand Sand Silt Clay Saturated paste Total Kjeldahl Walkley amp Black Calcimeter with HCI NH40Ac at pH 7 NH40Ac NH40Ac NH40Ac NH40Ac Hydrometer Hydrometer Hydrometer Hydrometer Hydrometer 1 2 5 soil water suspension Olsen extractable Total Kjeldahl Walkley amp Black Calcimeter with HCl Hydrometer Hydrometer Hydrometer Hydrometer Hydrometer Figure 4 6 Example of soil profile analytical metadata report printout Profile code SE0305 Date 1 06 76 Date 26 07 00 SDBm Plus FAO CSIC Multilingual Soil Profile Database Code Biological features type AB biological activity AR artefacts Bl infilled burrows BO open burrows BU burrows CC charcoal EW earthworms IA insect activity PT pedotubules TG termite channels Code Biological features quantity 0 nil C common F few M many V very few Code Boundary topography B broken irregular S smooth W Wavy Code Boundary width A abrupt C clear D diffuse G gradual Figure 4 7 Example of coding system report p
31. es Metadata D finition Voir Variables d riv es G nerateur de fichier Codes Data Metadata Definition Ansicht abgeleitete Variablen Datei Erzeuger Input data ENGLISH SPANISH FRENCH GERMAN Input data Entrada de datos Entre de Donn es Daten einf gen Double click or press F1 to see the coding system General information Horizon description Standard analysis Salts Heavy metals Physical analysis Water retention Hydraulic conductivity Additional variables Profile code Content Page Status Date Authors Soil unit Location Survey area Administrative unit Haga doble click o pulse F1 para ver el sistema de c digos Informaci n general Descripci n de horizonte An lisis general Sales Metales pesados An lisis f sico Retenci n de agua Conductividad hidr ulica Variables adicionales C digo del perfil Contenido P gina Status Fecha Autores Unidad de suelo Localizaci n Area de estudio Unidad admininstrativa Double clic ou presser F1 pour voir le syst me de codages Information g n rale Description de l horizon Analyse normale Sels Metaux lourds Analyse physique Retention d eau Conductivit hydraulique Variables additionnelles Code du profil Contenu Page Status Date Auteurs Unit de sol Local Surface prospect e Unit administrative Doppelklick oder F1 um das Kodiersystem zu sehen Allgemeine Informationen Horizontbeschreibung Standardanalysen Sal
32. in dry and friable in moist sticky and plastic in wet high porosity many Voids fine many voids very fine common nodules calcareous white hard strongly calcareous common biological activity abundant fine roots and abundant medium roots clear smooth boundary B 21 30 48 Dark gray 10YR 4 1 moist and Light gray to gray 10YR 6 1 dry clay weak medium structure very hard in dry and firm in moist very sticky and very plastic in wet few slickensides on pedfaces Cutans high porosity common Voids fine common voids very fine common nodules calcareous white hard strongly calcareous many biological activity abundant fine roots and abundant medium roots diffuse smooth boundary B 22 48 82 Dark gray 10YR 4 1 moist and Light gray to gray 10YR 6 1 dry clay moderate medium structure very hard in dry and firm in moist very sticky and very plastic in wet common distinct slickensides on pedfaces Cutans few Voids fine common voids very fine strongly calcareous common biological activity common fine roots diffuse smooth boundary C 1 82 Very dark gray 10YR 3 1 moist and Light gray to gray 10YR 6 1 dry clay strong medium structure very hard in dry and very firm in moist very sticky and very plastic in wet low porosity few Voids fine strongly calcareous very few biological activity few fine roots and few very fine roots Figura 4 2 Example of soil profile standard morphological description printout SD
33. interdune depression depresi n interdunar d pression interdunaire D nensenke IF interfluve interfluvio interfluve Riedel LA lagoon laguna lagune Lagune LE levee leve lev e Damm LD longitudinal dune duna longitudinal dune longitudinale langgestreckte D ne angeschnittene D ne ME meseta meseta meseta Hochebene PA pan pan pan RI ridge cordillera cr te de montagne Kamm Erddamm SL slope pendiente pente Hang TE terrace terraza terrasse Terasse VA valley valle vall e Tal VF valley floor fondo de valle fond de vall e Talgrund CODE POSITION EMPLAZAMIENTO DEL PERFIL POSITION DU PROFIL POSITION DES PROFILS CR crest cima cr te Kamm US upper slope pendiente alta pente sup rieure Oberhang MS middle slope pendiente media pente interm diaire Mittelhang LS lower slope pendiente baja pente inf rieure Unterhang SL slope pendiente pente Hang HI higher part parte m s alta partie plus lev e h hergelegenes St ck IN intermediate part parte intermedia partie interm diaire mittleres St ck LO lower part parte m s baja partie plus basse unteres St ck BO bottom fondo fond Fu CODE SLOPE GRADIENT CLASE DE PENDIENTE CLASSE DE PENTE DU TERRAIN GEF LLE 0 0 0 196 1 0 1 0 396 2 0 3 0 796 3 0 7 296 4 2 896 5 8 16 6 16 30 7 gt 30 CODE SLOPE FORM FORMA DE LA PENDIENTE FORME DE LA PENTE HANGFORM S straight recta droite gerade C concave c ncava concave konkav V convex
34. n Cementaci n Compactaci n continuidad Poros Porosidad Rocas forma meteorizaci n N dulos dureza Carbonatos Caracter sticas biol gicas Ra ces L mite anchura M todo C digo de la muestra fijado dimension contraste limite couleur Texture Structure Relation degr Consistance sec humide Adh sivit Plasticit Cutanes quantit contraste nature Local Cimentation Compactation continuit Pores Porosit Roches forme degr d alt ration Nodules duret Carbonates Caracteristiques biologiques Racines Limite largeur M thode Code de l chantillon fix Gr e Kontrast Grenze Farbe K rnung Struktur Verh ltnis Grad Konsistenz trocken feucht Bindigkeit Plastizit t Kutane Quantit t Kontrast Natur Lage Zementierung Verdichtung Kontiniut t Poren Porosit t Felsen Form Verwitterung Knollen Klumpen H rte Carbonate Biolog Eigenschaften Wurzeln Grenze Weite Methode Probennummer gebunden Method used Particle size vcS very coarse Sand cS coarse Sand mS medium Sand fS fine Sand vfS very fine Sand Sand cSi coarse Silt fSi fine Silt Silt Clay CECc Total Active Soluble cations Soluble anions Heavy metals Saturated hydraulic conductivity Actual water content Stability index Bulk density Resistance to penetration Particles density Total porosity Kind of measurement Number of measurements laboratory field Suct
35. pH 8 2 NaOAc a pH 8 2 NaOAc pH 8 2 NaOAc bei pH 8 2 D TEA TEA TEA E Ca absorption Absorci n de Ca Absorption de Ca Ca Absorption F NH4OAc at pH 8 2 NH4OAc a pH 8 2 NH4OAc pH 8 2 NH4OAc at pH 8 2 G CaCl CaCl CaCl CaCl H Li ETDA Li ETDA Li ETDA Sum of cations Suma de cationes Somme de cations Summe der Kationen CODE EXCHANGEABLE CATIONS CATIONES INTERCAMBIABLES CAPACIT D CHANGE AUSTAUSCHBARE KATIONEN CATIONIQUE A NH4OAc NH OAc NH OAc NH OAc B HCI N 20 HCI N 20 HCI N 20 HCI N 20 C ETDA ETDA ETDA D Base saturation Saturaci n base Saturation base Basens ttigung E Sodium saturation Saturaci n en sodio Saturation en sodium Natriums ttigung F Sodium absorption Absorci n de sodio Absorption de sodium Natriumabsorption CODE POTASSIUM K FIXED POTASIO K FIJADO POTASSIUM K FIX KALIUM gebundenes K Total X ray fluorescence Flourescencia total de rayos X Fluorescence totale des rayons X Gesamt Fluoreszenz der R ntgenstrahlung B Acid extractable cido extra ble Acide extraible CODE PARTICLE SIZE GRANULOMETR A GRANULOMETRIE TEILCHENGR BE A Pipette Pipeta Pipette Pipette B Hydrometer Hidr metro Hydrom tre Hydrometer CODE CALCIUM CARBONATE CaCO CARBONATO C LCICO CaCO CARBONATE CALCIQUE CaCO CALCIUMCARBONAT CaCO A Calcimeter with HCI Calcimetro con Calcim tre avec HCI Calcimeter mit B Hydrochloric acid Acido clorhidrico Acide chloridrique Sa
36. predict land productivity and land degradation and to assess the consequences of change Natural resources databases as part of a preliminary stage facilitate and simplify such interpretative processes These databases which includes data on climate soils topography land use and management practices offer the opportunity to i ensure standardised procedures ii allow rapid extension of analyses and interpretations from local to national continental regional or universal levels and iii enhance repeatability of analyses and results Over the last two decades and within the Agro Ecological Zoning AEZ programme development of computerised systems for inventory evaluation and planning of land resources has been made by FAO specially for use in developing countries FAO 1997 The purpose of zoning as carried out for rural land use planning is to separate areas with similar sets of potentials and constraints for development AEZ defines zones on the basis of combination of soil landform climate and management characteristics making a special application of the information technologies LRIS Antoine 1994 For surveys of land resources a physiographic approach is also recommended which integrates landforms soils and vegetation SOTER FAO 1995 In collaboration with the United Nations Environment Programme UNEP and other national and international institutions FAO has recently developed an improved framework for sustainable land
37. resources development and management that address the evolving nature of integrated land management FAO UNEP 1999 In 1977 the Consejo Superior de Investigaciones Cientificas CSIC through its Instituto de Recursos Naturales y Agrobiolog a de Sevilla IRNAS formerly Centro de Edafolog a y Biolog a Aplicada del Cuarto CEBAC undertook the development of a computerised methodology for soil survey and land evaluation with special reference to the Mediterranean regions which has crystallised into the MicroLEIS system The current version of this system MicroLEIS 2000 De la Rosa 1999 as an integrated package provides an orderly arrangement of rural resources data through spatial databases and land evaluation quality vulnerability assessment models In the last part of this version the land evaluation rationale has been adapted to the conceptual DPSIR framework D Drivers P Pressures S State I Impacts and R Responses in order to assess not only soil degradation risks but also the potential impact of soil degradation on crop productivity and the response of agricultural management on soil vulnerability The SDBm Plus database resulted from co operation between both institutions above FAO and CSIC Such a database is a user friendly microcomputer programme designed to store manipulate and transfer large amounts of soil survey and monitoring data in an efficient and systematic way Soil surveys generate large quantities of data from
38. selections of all soil profiles located in a particular soil unit Profile status selections according to the quality of the information stored Administrative unit searches according to the geographic administrative units where the soil profiles are located Geographic coordinates the database can be searched on any area defined by its coordinates However the area should be located in either the Eastern or Western hemisphere Run two selection procedures if the area includes parts of both hemispheres This sub option covers most of the ordinary selection requests in geo referenced soil databases SDBm Plus FAD CSIC Multilingual Soil Profile Database Fast search gi D e C D Ld e y D y e e e C Figure 3 17 Fast search screen Detailed search This procedure Figure 3 18 is used to select by virtually any field or laboratory characteristic or combination of these The key variables correspond to the following data blocks O Block 1 General information Block 2 Soil horizon description Block 3 Standard analyses Block 4 Soluble salts Heavy metals Block 5 Physical data Block 6 Water retention Hydraulic conductivity El er 0 0 O Block 7 Additional analytical variables Appendix A lists potential key variables for each data block To do a search select a data block a variable of the data block double clicking and then select a comparison operator from the list double clicking Finally i
39. sticky ligeramente adherente peu leicht bindig ST sticky adherente adh sif bindig VST very sticky muy adherente tr s collant sehr bindig SS slightly sticky to sticky ligeramente adherente a adherente peu collant collant leicht bindig bis bindig sv sticky to very sticky adherente a muy adherente collant tr s collant bindig bis sehr bindig CODE PLASTICITY PLASTICIDAD PLASTICIT PLASTIZITAT NPL non plastic no pl stico non plastique nicht plastisch SPL slightly plastic ligeramente pl stico peu plastique leicht plastisch PL plastic pl stico plastique plastisch VPL very plastic muy pl stico tr s plastique sehr plastisch 2 5 Voids porosity CODE VOIDS ABUNDANCE CANTIDAD DE HUECOS ABONDANCE DES VIDES PORENVORKOMMEN 0 nil ningunos n ant keine V very few muy pocos tr s peu nombreux sehr wenige F few pocos peu nombreux wenige C common frecuentes nombreux einige M many muchos tr s nombreux viele A abundant abundantes abondants reichlich CODE VOIDS SIZE TAMA O DE HUECOS DIMENSION DES VIDES PORENGR RE VF very fine muy finos tr s fins sehr fein FI fine finos fins fein FM fine medium de finos a medios fins et moyens fein bis mitel FF fine and very fine fino y muy finos fins et tr s fins fein und sehr fein ME medium medios moyens mittel MC medium coarse de medios a gruesos moyens et grossiers mittel bis grob CO coarse gruesos grossiers grob VC very coarse muy gruesos tr s grossiers sehr grob
40. tierras altas riz de montagne Hochlandreis VE vegetables cultivos hort colas horticulture Gem se VI vine vid vigne Wein WH wheat trigo bl Weizen YA yams ame igname Jams CODE VEGETATION TYPE TIPO DE VEGETACION TYPE DE V G TATION VEGETATIONSTYP N no vegetation sin vegetaci n sans vegetation ohne Vegetation F closed forest bosque cerrado for t dense geschlossener Wald FE evergreen forest bosque perennifolio for t feuillage permoment immergr ner Wald FS semi deciduous forest bosque semi caducifolio for t feuillage semi caduc Mischwald FD deciduous forest bosque caducifolio for t feuillage caduque Laubwald FX xeromorphic forest bosque xerom rfico for t x romorphe xeromorhischer Wald W woodland bosque maderero for t claire Waldland WE evergreen woodland bosque maderero perennifolio for t claire sempervirente immergr nes Waldland WS semi deciduous woodland bosque maderero semi caducifolio for t claire feuillage semi gemischtes Waldland caduque WD deciduous woodland bosque maderero caducifolio for t claire feuillage caduque Laubwaldland WX xeromorphic woodland bosque maderero xerom rfico for t claire x romorphe xeromorphisches Waldland 5 shrub arbusto arbuste Strauch SE evergreen shrub arbusto perennifolio arbuste sempervirent immergr ne Str ucher SS semi deciduous shrub arbusto semi caducifolio arbuste feuillage semi caduque gemischte Str ucher SD deciduous shrub arbusto caducifolio arbuste f
41. AA annual field cropping AF agroforestry system AP peremnial field cropping AT tree cropping U not used and not managed E1 LANDELEMENT DBF LAEL D LAEL ME meseta SL slope TE terrace VA valley EL STONESSIZE DBF STOS psros s stones E1 CROPTYPE DBF CROL p 1 FR fruits OL olive tree WH Wheat El_USDAS7SUBGR DBF El_SLOPEGRADIENT DBF E1_INTDRAINAGE DBF STSG DSTSG SLGR DRA D DRA AA Typic 3 0 7 2 1 irrperfect AQO6 4 2 8 M rroderately well CA Calcic 5 8 16 S somewhat excess DYO2 Dystric 6 16 3096 w well EN Entic Lio2 Lithic RE Rendollic E1 SLOPEFORM DBF SA Salorthidic SLFR D SLFR C concave S straight Figure 4 8b Example of LEIS GIS input file Descriptive files Andaluc a Spain Arent Rhodaseraif Xerubrepi Xarorihant Eutrochrept Fluvaquent Xercchrept Figure 4 9 Example of GIS map showing the combination of polygon information with point information referred to the STGG variable from SDBm Plus Bibliography Antoine J 1994 Linking geographical information systems GIS and FAO s agro ecological zone AEZ models for land resource appraisal pp 35 52 World Soil Resources Report 75 FAO Rome Black C A 1965 Methods of soil analysis Part 1 Physical and mineralogical properties American Society of Agronomy Inc Madison De la Rosa D 1979 Relation of several pedological character
42. ARTICULES TEILCHENDICHTE A Helium air pycnometer Picn metro helio aire Pycnom tre h lium air Helium Luft B Pycnometry Picnometr a Pycnometrie CODE STABILITY INDEX NDICE DE ESTABILIDAD INDICE DE STABILIT STABILITATSINDEX ESTRUCTURAL STRUCTURALE A Dry sieving Tamizado en seco Tamisage sec Trockensiebung B Moist sieving Tamizado en h medo Tamisage en humide NaBsiebung CODE TOTAL POROSITY POROSIDAD TOTAL POROSIT TOTAL GESAMTPOROSITAT A From bulk density and particle De la densidad aparente y densidad De la densit apparente et densit Von Lagerungsdichte und Dichte density de las part culas des particules der Partikel B From water content at saturation De humedad a saturaci n D humidit saturation Vom Wassergehalt bei S ttigung CODE SATURATED HYDRAULIC CONDUCTIVIDAD HIDRAULICA CONDUCTIVIT HYDRAULIQUE GESATTIGTE CONDUCTIVITY A SATURACI N SATUR E WASSERLEITFAHIGKEIT A Constant head permeameter Permeametro a presi n constante Perm ametre a pression constante Block 6 WATER RETENTION HYDRAULIC CONDUCTIVITY CODE A Suction in fretted glass plates Succi n en placas de vidrio poroso Succion en plaques de verres poreux B Pressure in ceramic plates Presi n en placas de cer mica Presion en plaques ceramiques Druck in keramischen Platten C Tension disc permeameter in the Perme metro de disco en el campo Perm am tre de disque au champ field D Internal drainage in the field Drenaje interno en el campo Drainage in
43. Acrustox FDD Haplotorrerts GAF Haplocryids BCC Cryosaprists ECC Eutrustox FEA Dystrusterts GBA Aquisalids BCD Haplosaprists ECD Kandiustox FEB Salusterts GBB Haplosalids BDA Sulfohemists ECE Haplustox FEC Gypsiusterts GCA Natridurids BDB Sulfihemists EDA Sombriperox FED Calciusterts GCB Argidurids BDC Luvihemists EDB Acroperox FEE Haplusterts GCC Haplodurids BDD Cryohemists EDC Eutroperox FFA Dystruderts GDA Petrogypsids BDE Haplohemists EDD Kandiperox FFB Hapluderts USDA 98 CLASSIFICATION SUBGROUPS BA01 Argiaquic Xeric CH00 Haploxerollic DQ00 Placic AB00 Abruptic BB00 Argic 100 Hapto Histic DROO Plagganthreptic 1 Abruptic Argiduridic BC00 Argidic CJ00 Hemic DS00 Plinthaquic AB02 Abruptic Haplic BD00 Argiduridic CK00 Histic DT00 Plinthic AB03 Abruptic Xeric BE00 Aridic CK01 Histic Lithic DU00 Psammentic AC00 Acraquoxic BE01 Aridic Leptic CK02 Histic Placic DV00 Rendollic ADOO ADO1 AD02 AD03 AD04 ADO5 AE00 AF00 AF01 AF02 AF03 AF04 AF05 AG00 AH00 100 101 AJ01 AJO2 AJ04 AJO5 ALOO ALO1 AMOO AMO01 ANOO AO00 APOO AQO0 AROO Acrudoxic Acrudoxic Hydric Acrudoxic Plinthic Acrudoxic Thaptic Acrudoxic Ultic Acrudoxic Vitric Acrustoxic Aeric Aeric Chromic Vertic Aeric Fragic Aeric Humic Aeric Umbric Aeric Vertic Albaquic Albaquultic Albic Albic Glossic Alfic Alfic Arenic Alfic Humic Alfic Lithic Alfic Oxyaquic Alfic Vertic Alic Andic Andic Omb
44. Bm Plus FAO CSIC Multilingual Soil Profile Database PHOTOGRAPHS Profile code SE0305 Date 1 06 76 Position Profile Other Other Figura 4 2 Example of soil profile standard morphological description printout Cont GRAPHICAL PRESENTATIONS Graphical presentations of 1 the vertical variability of analytical variables and ii suction vs hydraulic properties of the soil profile previously selected Figures 4 4a y 4 4b can be generated using the Main options Content and Search Chapter 3 Both kinds of sample by sample representations are useful to analyse the soil profile variability of a soil and to compare it with that of other soils STATISTICAL SUMMARY A statistical summary Figure 4 5 is developed from the soil profiles list with reference to a set of soil profiles and of analytical variables This summary includes a table with the following statistics number of soil samples n range m minimum value and M maximum value standard deviation and coefficient of variation This application 15 very useful to make a first statistical analysis of the stored data ANALYTICAL METADATA REPORT A report with the methods used for the analytical determinations of the soil profile previously selected Figure 4 6 can be generated using the Main options Content and Search Chapter 3 This metadata report displayed variable by variable is designed to facilitate data accuracy and th
45. CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR D D D D O1 01 O1 O1 ND D G Q N N O D D D ND D 2 parent material Permeability FAO phase Profile site photograph Profile photograph Another photograph Another photograph Position of site Profile Remarks Rock outcrop distance Rock outcrop abundance Rock outcrop height Rock type Soil climate Surface sealing crusting Sheet number Slope form Slope gradient class Soil moisture regime 1 specie 2 specie 3 specie 4 specie 5 specie Status Soil temperature USDA 87 great group USDA 87 mineralogy Surface stones abundance Surface stones size USDA 87 reaction USDA 87 subgroup USDA 87 texture Survey area Topography Soil unit Vegetation type World reference base for soil resources groups World reference base for soil resources specifiers World reference base for soil resources units SDBHORIZ DB file Data FIELD TYPE DESCRIPTION BIK1 CHAR 1 biological features kind BIK2 CHAR 2 biological features kind BIQ1 CHAR d biological features quantity BIQ2 CHAR pm biological features quantity BOUT CHAR Boundary topography BOUW CHAR Boundary width CARB CHAR Carbonates CEMC CHAR Cementation Compaction continuity CEMG CHAR Cementation Compaction grade CEMN CHAR Cementation Compaction nature CEMS CHAR Cementation Compaction str
46. CO coarse gruesas grossiers grob CV coarse and very coarse gruesas y muy gruesas grossiers et tr s grossiers grob und sehr grob VC very coarse muy gruesas tr s grossiers sehr grob EC extremely coarse extremadamente gruesas extr mement grossiers extrem grob SB stones and boulders piedras y cantos rodados pierres et cailloux roul s Steine und Ger ll CODE ROCK FRAGMENTS SHAPE FORMA DE LOS FRAGMENTOS FORME DES FRAGMENTS GESTEINSFORM DE ROCAS ROCHEUX R rounded redondeadas ronds abgerundet F flat planas plats glatt A angular angulares angulaires eckig S subrounded subredondeadas irr guliers CODE ROCK FRAGMENTS METEORIZACI N DE LOS ALT RATION DES FRAGMENTS VERWITTERUNGSZUSTAND WEATHERING FRAGMENTOS DE ROCAS ROCHEUX DER GESTEINE F fresh slightly weathered poco nada meteorizadas peu ou non alt r s leicht verwittert W weathered meteorizadas alt r s verwittert S strongly weathered fuertemente meteorizadas tr s alt r s stark verwittert CODE ROCK FRAGMENTS NATURE NATURALEZA DE LOS NATURE DES FRAGMENTS GESTEINSMATERIAL FRAGMENTOS DE ROCAS ROCHEUX BT basalt basalto basalte Basalt CH chert silex chert Hornstein DI diorite diorita diorite Diorith DO dolerite dolerita dol rite Dolerith DM dolomite dolomita dolomite Dolomit FE feldspar feldespato feldspathe Feldspat GA gabbro gabro gabbro Gabbro GN gneiss gneiss gneiss Gneis GR granite granito granite Granit LI limestone caliza calcaire Kalkstein MI mica mica mica Glimmer
47. CTIVE SOIL DEPTH PROFONDEUR UTIL EFFEKTIVE BODENTIEFE 1 0 25cm 2 25 50cm 3 50 100cm 4 100 150cm 5 gt 150 1 6 Surface characteristics CODE STONES ABUNDANCE PEDREGOSIDAD ABONDANCE D ELEMENTS STEINVORKOMMEN GROSSIERS 0 nil ninguna n ant keine V very few muy poca tr s peu nombreux sehr wenige F few poca peu nombreux wenige C common frecuente nombreux einige M many mucha tr s nombreux viele A abundant abundante abondants vorkommend D dominant dominante dominant dominierend CODE STONES SIZE TAMA O DE PIEDRAS DIMENSIONS DES L MENTS GROBE DER STEINE G gravel gravas graviers Kies F fine gravel gravas finas graviers fins feiner Kies M medium gravel gravas medias graviers moyens Mittelkies C coarse gravel gravas gruesas graviers grossiers grober Kies S stones piedras cailloux Steine B boulders cantos rodados blocs Ger ll L large boulders grandes cantos rodados grands cailloux roul s groRes Ger ll CODE ROCK OUTCROPS ABUNDANCE AFLORAMIENTOS ROCOSOS AFFLEUREMENTS ROCHEUX 0 nil ningunos non rocheux keine V very few muy pocos tr s peu rocheux sehr wenige F few pocos assez rocheux wenige C common frecuentes rocheux fr quents einige M many muchos tr s rocheux viele A abundant abundantes excessivement rocheux vorkommend D dominant dominantes dominant dominierend CODE ROCK OUTCROPS DISTANCE DISTANCIA ENTRE DISTANCE ENTRE AFLORAMIENTOS AFFLEUREMENTS 1 gt 100m 2 35 100m 3
48. E parting into que se deshace en se s parant en and y et und to a zu CODE DRY CONSISTENCE CONSISTENCIA EN SECO CONSISTANCE EN SEC KONSISTENZ BEI TROCKENHEIT LO loose suelta meuble locker SO soft blanda tendre weich SHA slightly hard ligeramente dura peu dur leicht hart HA hard dura dur hart VHA very hard muy dura tr s dur sehr hart EHA extremely hard extremadamente dura extr mement dur extrem hart SS soft to slightly hard blanda a ligeramente dura tendre peu dur weich bis leicht hart SH slightly hard to hard ligeramente dura a dura peu dur dur leicht hart bis hart HV hard to very hard dura a muy dura dur tr s dur hart bis sehr hart CODE MOIST CONSISTENCE CONSISTENCIA EN H MEDO CONSISTANCE L TAT FRAIS KONSISTENZ BEI FEUCHTIGKEIT LO loose suelta meuble locker VFR very friable muy friable tr s friable sehr br ckelig FR friable friable friable br ckelig FI firm firme ferme fest VFI very firm muy firme tr s ferme sehr fest EFI extremely firm extremadamente firme extr mement ferme extrem fest VF very friable to friable muy friable a friable tr s friable friable sehr br ckelig bis br ckelig FRF friable to firm friable a firme friable ferme br ckelig bis fest FV firm to very firm firme a muy firme ferme tr s ferme fest bis sehr fest CODE STICKINESS ADHESIVIDAD ADH SIVIT BINDIGKEIT NST non sticky no adherente non adh sif nicht bindig SST slightly
49. E INUNDACI N P RIODE DES INONDATIONS DAUER DER BERSCHWEMMUNG 1 less than 1 day menos de 1 dia moins d 1 jour weniger als 1 Tag 2 1 15 days 1 15 dias 1 15 jours 1 15 Tage 3 15 30 days 15 30 dias 15 30 jours 15 30 Tage 4 30 90 days 30 90 dias 30 90 jours 30 90 Tage 5 90 180 days 90 180 dias 90 180 jours 90 180 Tage 6 180 360 days 180 360 dias 180 360 jours 180 360 Tage 7 continuous continuamente continuellement kontinuierlich CODE WATER TABLE TYPE TIPO DE CAPA FRE TICA TYPE DE NAPPE PHR ATIQUE GRUNDWASSERTYP SA saline salina saline salzig BR brackish salobre saum tre brackig FR fresh agua dulce eau douce frisch OX oxygenated oxigenada oxyg n e sauerstoffreich PO polluted contaminada pollu e verschmutzt SG stagnating estancada stagnante stagnierend CODE WATER TABLE DEPTH PROFUNDIDAD DE LA CAPA PROFONDEUR DE LA NAPPE TIEFE DES GRUNDWASSERS FREATICA PHR ATIQUE 0 not observed no observada n ant nicht untersucht 1 0 25cm 0 25 cm 0 25 cm 0 25 cm 2 25 50cm 25 50 cm 25 50 cm 25 50 cm 3 50 100cm 50 100 cm 50 100 cm 50 100 cm 4 100 150cm 100 150 cm 100 150 cm 100 150 cm 5 gt 150cm gt 150 cm gt 150 cm gt 150 cm CODE MOISTURE CONDITION CONDICIONES DE HUMEDAD ETAT HYDRIQUE DU SOL WASSERVERHALTNISSE D dry seco sec trocken S slightly moist ligeramente h medo l g rement humide m ig feucht M moist h medo humide feucht W wet mojado mouill nak Block 2 SOIL HORIZON DESCRIPT
50. ENERAL INFORMATION Registration and location Soil profile description status string Date of description string Author 3 string Soil unit string Location string Survey area string Administrative unit string Latitude string Longitude string Elevation m HHHH Sheet string Grid string Soil classification FAO 74 classification unit phase code FAO 90 classification unit third level code WRB 98 classification group unit specifier code USDA 87 classification great group subgroup family t m r code USDA 98 classification great group subgroup family t m r code Local soil classification Serie code Soil climate class moisture regime thermic regime code Landform and topography Topography code Landform code Land element code Position code Slope class form code Microtopography code Land use and vegetation Land use type Human influence Crops 2 entries Vegetation type Species 5 entries Grass cover Parent material Parent material over derived from Effective soil depth Surface characteristics Stones abundance size Rock outcrops abundance distance height Erosion deposition type intensity Sealing crusting Soil water relationships Drainage class internal external Flood frequency duration Watertable type maximum and minimum depth observation Moisture condition 3 entries condition depth Other Remarks Block 2 SOIL HORIZON DESCRIPTION Horizon number Horizon desig
51. El c digo de la muestra no puede ser nulo El c digo se est usando en alg n registro de la base de datos si contin a perder esa informaci n Code d chantillon d j existant Code nul Code du profil ne peut pas tre annul Code d horizon ne peut pas tre annul Code d chantillon ne peut pas tre annul Ce code est en usage dans un enregistrement de base de donn es si vous continuez vous allez perdre cette information Probencode existiert bereits ung ltiger Code Profilcode ist nicht ung ltig Horizontcode can not be null Probencode can not be null Dieser Code wird bereits in einer Datenbank verwendet wenn Sie fortfahren k nnen die Daten verloren gehen Import ENGLISH SPANISH FRENCH GERMAN Profiles list Lista de perfiles Liste des profils Liste der Profile Data type Tipo de datos Type de donn es Datentyp Chemical determinations Soil variables Directory Select source directory First record Last record Language in which they were codified English Spanish French Import successful Determinaciones qu micas Variables de suelo Directorio Seleccionar directorio origen Primer registro Ultimo registro Idioma en el que fueron codificados Ingl s Espa ol Franc s Importaci n con xito D terminations chimiques Variables du sol Repertoire Choisir repertoire de source Premier enregistrement Dernier enregistrement Langage o ils ont t codifi s Anglais E
52. H HH string string HHHH HH HHHH HH HHHH HH HHHH HH HHHH HH HHHH HH HHHH HH HHHH HH HHHH HH HHHH HH graphic graphic graphic code Tentative ranges for the numeric variables which corresponds to the most frequent soil values although the SDBm Plus database allow any values out of these ranges Appendix B Coding system Translation tables of coded soil variable in English Spanish French and German The coding system followed below correspond basically to the standardized codes included in the publications Guidelines for Soil Profile Description 3 Edition FAO ISRIC 1990 and previous versions of this SDBm Plus database FAO ISRIC 1989 FAO ISRIC CSIC 1995 Block 1 GENERAL INFORMATION 1 1 Soil classifications only in English language FAO 74 CLASSIFICATION SOIL UNITS Acrisols Ferric Acrisol Gleyic Acrisol Humic Acrisol Orthic Acrisol Plinthic Acrisol Cambisols Chromic Cambisol Calcic Gleysol Dystric Gleysol Eutric Gleysol Humic Gleysol Mollic Gleysol Plinthic Gleysol Gelic Gleysol Phaeozems Nitosols Dystric Nitosol Eutric Nitosol Humic Nitosol Histosols Dystric Histosol Eutric Histosol SO TH TO TV Orthic Solonetz Andosols Humic Andosol Mollic Andosol Ochric Andosol Vitric Andosol Rankers Dystric Cambisol Eutric Cambisol Ferralic Cambisol Gleyic Cambisol Humic Cambisol Calcic Cambisol Vertic Cambisol Gelic Cambisol Chernozems
53. HAR 1 It Indicates if the hydraulic conductivity is related to the suction h or to the water content 0 VAR1 NUMBER 10 2 First value h o 0 VAR25 NUMBER 10 2 25 value h o 0 COND 1 NUMBER 6 2 Hydraulic conductivity for the first value COND25 NUMBER 6 2 Hydraulic conductivity for the 25 value METHODS CHAR 2 Method used to measure the hydraulic conductivity CONDUNIT CHAR 10 Hydraulic conductivity measure units ADDVARS DB file Data and Metadata FIELD TYPE SIZE DESCRIPTION PRNO CHAR 6 Profile code DATE DATE Sampling date SANO CHAR 1 Sample code Upper boundary depth Lower boundary depth Additional variable 1 Additional variable 2 Additional variable 3 Additional variable 4 Additional variable 5 Additional variable 6 Additional variable 7 Additional variable 8 Additional variable 9 Additional variable 10 UPBO NUMBER LOBO NUMBER ADDVAR1 NUMBER ADDVAR2 NUMBER ADDVAR3 NUMBER ADDVAR4 NUMBER ADDVAR5 NUMBER ADDVAR6 NUMBER ADDVAR7 NUMBER ADDVAR8 NUMBER ADDVAR9 NUMBER ADDVAR10 NUMBER SOURCE FILES On electronic format SDBm Plus Software version 1 02 and Spanish Manual Modifications and Improvements 1 With relation to the SDBm Plus version 1 00 December 2000 the following modifications and corrections have been made in the software 1 2 10 A new option to allow export ASCII format files has been developed 12 13 14 15 16 A bug has been fixed in the Code
54. I or HNO Trockenveraschung HCI oder HNO F Na CO fusion Fusi n de Fusi n de Na2COs G HNO3 HCIO4 H2SO4 HNO3 HCIO4 H2SO4 HNO3 HCIO4 H2SO4 HNO3 HCIO4 H2SO4 H K2S20g HCI K2S20g HCI K2S20g HCI K2S20g HCI H2SO KMnO HNO H2SO KMnO 4 HNO H2SO KMnO HNO H2SO KMnO J X ray fluorescence Fluorescencia de rayos X Fluorescence des rayons X Fluoreszenz der R ntgenstrahlen K Neutron activation Activaci n de neutrones Activation des neutrons Neutronenaktivit t Block 5 PHYSICAL ANALYSES CODE ACTUAL WATER CONTENT CONTENIDO EN AGUA REAL CONTENEU D EAU R ELLE AKTUELLER WASSERGEHALT A Gravimetry Gravimetr a Gravim trie Gravimetrisch B Neutron probe Sonda de neutrones Sonde de neutrons Neutronenprobe C TDR Time Domain Reflectometry TDR Time Domain Reflectometry TDR Time Domain Reflectometry TDR Time Domain Reflectometry CODE BULK DENSITY DENSIDAD APARENTE DENSIT APPARENTE LAGERUNGSDICHTE A 1 3 bar 1 3 bar 1 3 bar 1 3 bar B Oven dry Horno de secado Four sec ofentrocken C Field humidity Humedad de campo Humidit de champ feldfeucht D Air dry Aire seco Air sec lufttrocken E Absorption 3 cm Absorci n 3cm Absorption 3cm Absorption 3cm CODE RESISTANCE TO PENETRATION RESISTENCIA A LA R SISTANCE A LA PENETRACI N P N TRATION A Core penetrometer Penetr metro P netrom tre Penetrometer CODE PARTICLE DENSITY DENSIDAD DE LAS PART CULAS DENSIT DE P
55. ION 2 1 Horizon designation and dimensions 2 2 Soil colour CODE COLOUR MODIFIER MODIFICADOR DE COLOR MODIFICATEUR DE COULEUR M moist D dry MM mottled moist MD mottled dry h medo seco manchas h medo manchas seco humide sec tachet mouill tachet sec feucht trocken marmoriert gesprenkelt feucht marmoriert gesprenkelt trocken CODE MOTTLES ABUNDANCE CANTIDAD DE MANCHAS ABONDANCE DES TACHES VORKOMMEN VON FLECKEN 0 none sin n ant keine V very few muy poca tr s peu sehr viele F few poca peu wenige C common frecuente fr quentes einige M many mucha nombreuses viele A abundant abundante abondante MODE MOTTLES SIZE TAMA O DE MANCHAS DIMENSION DES TACHES GROBE DER FLECKEN V very fine muy fino tr s fines sehr klein F fine pequefio petites klein M medium mediano moyennes mittel C coarse grande grandes grob CODE MOTTLES CONTRAST NATURALEZA DE LAS NATURE DES TACHES FLECKENKONTRAST MANCHAS F faint indistinta faible verschwommen D distinct definida distinct P prominent destacada prononc ausgepr gt CODE MOTTLES BOUNDARY L MITE DE MANCHAS LIMITE DES TACHES FLECKENBEGRENZUNG S sharp brusco brusque scharf C clear neto nette klar D diffuse difuso diffuse verschwommen CODE MOTTLES COLOUR COLOR DE LAS MANCHAS COULEUR DES TACHES FARBE DER FLECKEN BL black negro noires schwarz BB bluish black negro azulado noir bleu
56. L glacial deposits dep sitos glaciales d p ts glaciaires glaziale Ablagerungen WE in situ weathered meteorizado in situ alt r in situ in situ Verwitterung lacustrine deposits dep sitos lacustres d p ts lacustres Seeablagerungen LG lagoonal deposits dep sitos lagunares d p ts lagunaires Haff Ablagerungen LI littoral deposits dep sitos litorales d p ts littoraux littorale Ablagerungen LO loess loess loess LOR LH loess Holocene loess Holoceno loess Holoc ne 0 Holozan MA marine deposits dep sitos marinos d p ts marins marine Ablagerungen OR organic deposits dep sitos org nicos d p ts organiques organische Ablagerungen PY pyroclastic deposits dep sitos pirocl sticos d p ts pyroclastiques pyroklastische Ablagerungen UU unconsolidated sin consolidar sans consolider unverdichtet VA volcanic ash cenizas volc nicas cendres volcaniques vulkanische Asche CODE PARENT ROCK ROCA ORIGINAL ROCHE M RE AUSGANGSGESTEIN AC acid igneous metamorphic roca cida gnea metam rfica roche acide ign e m tamorphique sauer igneous metamorph AN andesite andesita and site Andesit BT basalt basalto basalte Basalt BA basic igneous metamorphic roca b sica gnea metam rfica roche basique basisch igneous metamorph ign e m tamorphique AH clay Holocene arcilla Holoceno argile Holoc ne Ton Holoz n AP clay Pliocene arcilla Plioceno argile Plioc ne Ton Plioz n CO conglomerate conglomerado
57. LEITFAHIGKEIT EC CE CE See Soluble Salts Ver Sales Solubles Voir Sels Solubles siehe l sliche Salze CODE PHOSPHORUS P FOSFORO P PHOSPHORE P PHOSPHOR P B Total X ray fluorescence Fluorescencia total de rayos X Fluorescence totale des rayons X Gesamte Fluoreszenz der R ntgenstrahlen C Olsen extractable Olsen extra ble Olsen extraible OLSEN Extraktion D Bray Bray Bray Bray E Acid extractable extract Acido extraible Acide extraible F Phosphate retention Retenci n de fosfatos Retention de phosphates Phosphathalteverm gen G Phosphate sorption Absorci n de fosfatos Absorption de phosphates Phosphatabsorption CODE ORGANIC CARBON OC CARBONO ORG NICO CO CARBONO ORGANIQUE CO ORGANISCHES CARBONAT Corg A Walkley amp Black Walkley amp Black Walkley amp Black Walkley amp Black B Dry combustion Combusti n seca Combustion s che Trockene Verbrennung CODE NITROGEN N NITR GENO N AZOTE N STICKSTOFF N Total Kjeldahl Total Kjeldahl Totale Kjeldahl Gesamt Kjeldahl B Total steam distillation Total destilaci n Totale distillation Gesamt Wasserdampfdestillation CODE CATION EXCHANGE CAPACITY CAPACIDAD DE INTERCAMBIO CAPACIT D CHANGE KATIONENAUSTAUSCH CEC CATI NICO CATIONIQUE KAPAZITAT A NH4OAc at pH 7 0 NH4OAc a pH 7 0 NH4OAc pH 7 0 NH4OAc bei pH 7 0 B at pH 8 2 a pH 8 2 BaCl pH 8 2 BaCl bei pH 8 2 C NaOAc at
58. PU pumice pumita ponce QU quartz cuarzo quartz Quartz QZ quartzite cuarcita quartzite Quarzit SA sandstone arenisca gr s Sandstein SC schist esquisto schiste Schiefer SH shale lutita shale Schiefer SI siltstone limonita limon TU tuff toba volc nica tuf Tuff 2 4 Organisation and constituents CODE STRUCTURE GRADE GRADO DE ESTRUCTURA DEGR DE STRUCTURE KR MELUNGSGRAD VW very weak muy d bil tr s faible sehr schwach WE weak d bil faible schwach MO moderate moderado moyenne m ig ST strong fuerte forte stark VS very strong muy fuerte tr s forte sehr stark WM weak to moderate de d bil a moderado de faible moyenne schwach bis m ig MS moderate to strong de moderado a fuerte de moyenne forte m ig bis stark SG single grain de grano suelto particulaire Einzelk rner MA massive masivo massive massiv MP porous massive masivo poroso massive poreuse por s und massiv CODE STRUCTURE SIZE TAMA O DE ESTRUCTURA CLASSE DE STRUCTURE STRUKTURGROBE VF very fine muy fino tr s fine sehr fein Fl fine fino fine fein ME medium medio moyenne mittel CO coarse grueso grossi re grob VC very coarse muy grueso tr s grossi re sehr grob FM fine and medium fino y medio fine et moyenne fein und mittel MC medium and coarse medio y grueso moyenne et grossi re mittel und grob CV coarse and very coarse grueso y muy grueso grossi re et tr s grossi re grob und sehr grob FC fine to coarse fino a grueso de fine grossi
59. SH SPANISH FRENCH GERMAN Available languages Name of the language Select language Idiomas disponibles Nombre del idioma Seleccionar idioma Langages en vigueur Nom du langage Choisir langage verf gbare Sprachen Name der Sprache Sprache w hlen Language group Grupo de idiomas Groupe de langage Sprachgruppe Romance Romance Romance romanisch Germanic Germ nico Germanique germanisch Derived variables ENGLISH SPANISH FRENCH GERMAN Dependent variable Variable dependiente Variable d pendante abh ngige Variablen Name Nombre Nom Name Independent variable Base saturation percentage Syntax error Field not valid Format number not valid Variable independiente Porcentaje de saturaci n en base Error de sintaxis Campo no v lido Formato de n mero no v lido variable ind pendente Pourcentage de la saturation de base Erreur de syntaxe Champ non valable Nombre de format non valable unabh ngige Variablen Basens ttigung Syntax error Feld nicht g ltig Formatnummer nicht g ltig D 13 Evaluation ENGLISH SPANISH FRENCH GERMAN You must select the fields to export Debe seleccionar los campos a Vous devez choisir les champs pour Sie m ssen die Felder die Sie exportar l export exportieren wollen ausw hlen Depth must be an integer value Evaluation interface LES GIS file generator Layer thickness Way of calculation Weighted average Dominant value General information fiel
60. Software version 2 00 FAO CSIC Multilingual Soil Profile Database SDBm Plus For using in soil monitoring and evaluation systems CSIC IRNAS Sevilla FAO AGLL Rome April 2002 Project co ordinators D de la Rosa F Mayol CSIC IRNAS Sevilla Spain J Antoine FAO AGLL Rome Italy Main contributors F Moreno F Cabrera E Diaz Pereira Cord n I Gir n V Castillo B Hafidi CSIC IRNAS Sevilla Spain R Brinkman FAO AGLL Rome Italy J Sanchez J C Colomer CSIC CIDE Valencia Spain C Simota RISSA Bucharest Romania R Horn H Fleige N Prange KU Kiel Germany Institutional support FAO Food and Agriculture Organization CSIC Consejo Superior de Investigaciones Cient ficas MIMAM Ministerio Espa ol de Medio Ambiente CEC DGXII European Commission Science DG ISBN HHHHHHHHHHH Copyright FAO and CSIC 2001 Correct citation De la Rosa D Mayol F and Antoine J eds 2000 FAO CSIC multilingual soil profile database SDBm Plus World Soil Resources Report Rome FAO Consejo Superior de Investigaciones Cient ficas Food and Agriculture Organization Instituto de Recursos Naturales y Agrobiolog a Land and Water Development Division de Sevilla Land and Plant Nutrition Land Evaluation Unit Management Service Avda Reina Mercedes 10 Via della Terme di Caracalla 41012 Sevilla Spain 00100 Rome Italy Tel 34 954 624711 Tel 39 6 57051 Fax 34 954 620315 F
61. Soluble salts Heavy metals Block 5 Physical data Block 6 Water retention Hydraulic conductivity Block 7 Additional variables Block 10 Derived variables O Control section determination of the layer thickness or the control section to be analyzed within the vertical soil profile O Form of calculation determination of the type of calculation weighted average or dominant value The latter refers to the most represented values in the control section only codified variables use this method For the site variables codified as well as numerical the value corresponding to each profile is considered Ll Type of export file ASCII format and dBASE format can be produced The main input data files results is a matrix having as many rows as the number of selected soil profiles and the columns corresponding to the chosen soil variables The soil variable symbols correspond to the field names in the database tables Appendix E Also a set of descriptive files are generated which explain the codes used in each coded variable selected along with the corresponding analytical metadata Chapter 4 SDBm Plus FAO CSIC Multilingual Soil Profile Database Evaluation interface LES GIS file generator Code FAO 90 classification Location SE0305 Calcic Yertiso Finca El Pinganillo Utrera Figure 3 23 LES GIS file generation screen Main option Help This main function Figure 3 24 displays the SDBm Plus information included in this manual
62. UH AUK AUL AUN AUR AXA AXB AXD AXF Natriboralf Cryoboralf Hapludalf Paleudalf Agrudalf Fragiudalf Glossudalf Ferrudalf Kandiudalf Natrudalf Rhodudalf Fraglossudalf Duraqualf Fragiaqualf Glossaqualf Kandiaqualf Plinthaqualf Umbraqualf Natraqualf Ochraqualf Albaqualf Haplustalf Paleustalf Durustalf Kanhaplustalf Kandiustalf Plinthustalf Natrustalf Rhodustalf Haploxeralf Palexeralf Durixeralf Fragixeralf ESC ESD ESP EST ESU ESX ESZ EVC EVD EVP EVT EVU EVX Histosols HAC HAM HAR HAT HEB HEC HEI HEL HEM HEO HET HIB HIC HIL HIM HIS HIT HLB Cryopsamment Udipsamment Torripsamment Tropopsamment Ustipsamment Xeropsamment Quartzipsamment Cryofluvent Udifluvent Torrifluvent Tropofluvent Ustifluvent Xerofluvent Cryosaprist Medisaprist Borosaprist Troposaprist Borohemist Cryohemist Sulfihemist Luvihemist Medihemist Sulfohemist Tropohemist Borofibrist Cryofibrist Luvifibrist Medifibrist Sphagnofibrist Tropofibrist Borofolist IQX ITE ITH ITS ITU ITY Mollisols MBA MBB MBC MBK MBN MBR MBV MDA MDB MDR MDV MQA MQC MQD MQK MQN MQR MR MUA MUB MUD MUK MUN MUR MUV Halaquept Eutropept Humitropept Sombritropept Ustropept Dystropept Haploboroll Paleboroll Cryoboroll Calciboroll Natriboroll Argiboroll Vermiboroll Hapludoll Paleudoll Argiudoll Vermudoll Haplaquoll Cryaquoll Duraquoll Calciaquoll Natraquoll Argiaquoll Rendoll Hapl
63. XD MXK MXN MXR MXP Oxisols ODA ODC ODE ODK ODS OPA OPC OPE OPK OPS OQA OQC OQE OQL OTA OTC OTE Natralboll Argialboll Haploxeroll Durixeroll Calcixeroll Natrixeroll Argixeroll Palexeroll Hapludox Acrudox Eutrudox Kandiudox Sombriudox Haploperox Acroperox Eutroperox Kandiperox Sombriperox Haplaquox Acraquox Eutraquox Plinthaquox Haplotorrox Acritorrox Eutrotorrox UQB UQF UQK UQL UQM UQO UQW UUA UUB UUH UUK UUL UUR UXA UXB Vertisols VDL VDR VP VUL VUR VXL VXR Paleaquult Fragiaquult Kandiaquult Plinthaquult Umbraquult Ochraquult Albaquult Haplustult Paleustult Kandihaplustult Kandiustult Plinthustult Rhodustult Haploxerult Palexerult Pelludert Chromudert Torrert Pellustert Chromustert Pelloxerert Chromoxerert B 9 USDA 87 CLASSIFICATION SUBGROUPS AA AB AB04 AB08 AB10 AB14 AB16 AC ACO5 AE AE03 AE05 AE06 AE09 AE10 AE12 AL ALO2 ALO4 ALO8 ALO9 AL10 AL12 AL13 AL16 AN ANO1 ANO3 ANO6 AN11 Typic Abruptic Abruptic Aridic Abruptic Cryic Abruptic Haplic Abruptic Udic Abruptic Xerollic Acric Acric Plinthic Aeric Aeric Arenic Aeric Grossarenic Aeric Mollic Aeric Tropic Aeric Umbric Aeric Xeric Albaquic Albaquultic Albic Albic Glossic Albic Alfic Alfic Alfic Arenic Alfic Andeptic Alfic Lithic Andic Andeptic Andaquic Andic Dystric Andeptic Glos soboric AR32 AR34 AR36 AR36 AR42 AR42 AR50
64. a ol de Informacion de Suelos sobre Internet De la Rosa et al 2000 Also important apportions were made by the SIDASS EU project Horn et al 1999 Figure 2 1 Figure 2 2 Figure 3 1 Figure 3 2 Figure 3 3 Figure 3 4 Figure 3 5 Figure 3 6 Figure 3 7 Figure 3 8 Figure 3 9 Figure 3 10 Figure 3 11 Figure 3 12 Figure 3 13 Figure 3 14 Figure 3 15 Figure 3 16 Figure 3 17 Figure 3 18 Figure 3 19 Figure 3 20 Figure 3 21 Figure 3 22 Figure 3 23 Figure 3 24 Figure 4 1 Figure 4 2 Figure 4 3 Figure 4 4a Figure 4 4b Figure 4 5 Figure 4 6 Figure 4 7 Figure 4 8a Figure 4 8b Figure 4 9 List of figures General scheme of the SDBm Plus database Structure of the SDBm Plus database tables SDBm Plus main menu screen Input data soil profile general information page 1 screen Input data soil profile general information page 2 screen Input data soil horizon description screen Input data soil standard analysis screen Input data soil soluble salts heavy metals screen Input data soil physical analyses screen Input data soil water retention screen Input data soil hydraulic conductivity screen Input data soil additional variables screen Input data soil photographs screen Pop up window of the coding system Import data screen Export data screen Coding system screen Content screen Fast search screen Detailed search screen Additional variables screen Deactivating fields screen Labels translation s
65. ad Superior Inferior Colores Manchas abundancia abondance dimension Roches distance hauteur Erosion d position intensit Cimentation cro te Drainage interne externe Nappe phr atique maximum minimum observ Etat hydrique Profondeur utile Action anthropologique Remarques Photografies Position du profil Profil du sol Autre Charger image Effacer Sauvegarder image Nombre d horizons D signation Profondeur Sup rieur Inf rieur Couleurs Taches abondance Vorkommen Gr e Felsen Distanz H he Erosion Akkumulation Intensit t Versiegelung Krusten Entw sserung intern extern Grundwasserspiegel Maximum Minimum beobachtet Feuchtigkeit effektive Bodentiefe anthrop Ver ndrg Anmerkungen Fotografien Lage des Profils Bodenprofil Andere Bild laden L schen Bild speichern Horizontnummer Bezeichnung Tiefe H her Tiefer Farben Farbflecken Vorkommen size contrast boundary colour Texture Structure relationship grade Consistency dry moist Stickiness Plasticity Cutans quantity contrast nature location Cementation Compaction continuity Voids Porosity Rocks shape weathering Nodules hardness Carbonates Biological features Roots Boundary width Method Sample code fixed tama o contraste limite color Textura Estructura relaci n grado Consistencia seco h medo Adhesividad Plasticidad Cutanes cantidad contraste naturaleza localizaci
66. al Relaci n contenido de humedad succi n Conductividades hidr ulicas Carbonates Bicarbonates Chlore Sulfates Nitrates Relation Na Ca Mg Arsenic Cadmium Cobalte Chrome Cuivre Mercure Mangan se Molybd ne Nickel Plomb Antimoine S l nium Zinc Conductivit hydraulique Contenu d eau Indice de stabilit structurale Densit apparente Porosit totale Relation contenu d eau succion Conductivit s hydrauliques Carbonate Bicarbonate Chlor Sulfat Nitrat Verh ltnis Na Ca Mg Arsen Cadmium Kobalt Chrom Kupfer Quecksilber Mangan Molybd n Nickel Blei Antimon Selen Zink Wasserleitfahigkeit Wassergehalt Struktueller Stabilitatsindex Lagerungsdichte Gesamiporositat Verhaltnis Wassergehalt spannung Wasserleitfahigkeiten ENGLISH SPANISH FRENCH GERMAN Profile code already exists Horizon code already exists El c digo del perfil ya existe El c digo del horizonte ya existe Code du profil d j existant Code d horizon d ja existant Profilcode existiert bereits Horizontcode existiert bereits Sample code already exists Null code Profile code can not be null Horizon code can not be null Sample code can not be null This code is being used in some database record if continue you will lose that information El c digo de la muestra ya existe C digo nulo El c digo del perfil no puede ser nulo El c digo del horizonte no puede ser nulo
67. alfic Haploxeralfic Natrargids CY00 CZ00 DAOO DB00 DEOO DF00 DG00 DH00 DH01 DH02 DI00 DI01 DI02 DI03 DI04 DJ00 DK00 DL00 DM00 DN00 DO00 DO01 DP00 DP01 DP02 Lithic Ruptic Entic Mollic Natrargidic Natric Natrixeralfic Nitric Ombroaquic Oxic Oxyaquic Oxyaquic Ultic Oxyaquic Vertic Pachic Pachic Udertic Pachic Ultic Pachic Vertic Pachic Vitric Paleargidic Palexerollic Petrocalcic Petrocalcidic Petroferric Petrogypsic Petrogypsic Ustic Petronodic Petronodic Ustic Petronodic Xeric FB00 FC00 FD00 FD01 FE00 FF00 FG00 FH00 FIOO FJOO FL OO FMOO FNOO FOOO FPOO FQ00 FS00 FTOO FUOO FVOO FWOO Ultic Umbric Umbric Xeric Ustalfic Ustandic Ustertic Ustic Ustifluventic Ustollic Ustoxic Vermic Vertic Vitrandic Vitric Vitritorrandic Vitrixerandic Xanthic Xeralfic Xereptic Xerertic Xeric Xerofluventic Xerollic USDA 98 CLASSIFICATION FAMILIES Mineralogy 01 Allitic 09 Gibbsitic 17 Isotic 25 Mixed 02 Amorphic 10 Glassy 18 Kaolinitic 26 Paramicaceous 03 Carbonatic 11 Glauconitic 19 Kaolinitic 27 Parasesquic 04 Ferrihydritic 12 Gypsic 20 Magnesic 28 Sesquic 05 Ferritic 13 Halloysitic 21 Micaceous 29 Siliceous 06 Ferritic 14 Halloysitic 22 Mixed 30 Smectitic 07 Ferruginous 15 Illitic 23 Mixed 31 Vermiculitic 08 Gibbsitic 16 Isotic 24 Mixed Texture 01 Ashy 08 Coarse silty 15 Hydrous skeletal 23 Sandy 02 Ashy pumiceous 09 F
68. anguage The next time the user select the new language he 3 20 will be using a copy of the coding system tables this means that the next step to conclude the translation is to edit the coding system and change them for the new language Variables translation As shown for the coding system Figure 3 15 all the generalization levels presently defined for each coded soil variable can be translated into any other language maintaining the same codes Appendix B includes these defined generalization levels as translation tables in English Spanish French and German Label translation To develop a new working language in the SDBm Plus database it is necessary to translate all the user interface labels Figure 3 21 Appendix D includes as translation tables in English Spanish French and German the labels needed for these four languages Plus FAO CSIC Multilingual Soil Profile Database Languages Name of the language Spanish Select language FETE Language group Romance Germanic Multilingual Soil Profile Database Base de datos Multiling e de Perfiles de File Archivo Ayuda Introducir datos Importar Salir From SDBm Plus Desde SDBm Plus zi Accept Help Figure 3 21 Labels translation screen Main option Evaluation This function allows SDBm Plus to be used as a data source for the automatic application of land evaluation systems or models LESs and
69. anish French and German Standard reference books for the coded soil analytical methods are Procedures for Collecting Soil Samples and Methods of Analysis for Soil Survey USDA 1984 Australian Laboratory Handbook of Soil and Water Chemical Methods Rayment and Higginson 1992 and Methods of Soil Analysis Part 1 Physical and Mineralogical Properties Part 2 Chemical and Microbiological Properties ASA Black 1965 Page et al 1982 Block 3 STANDARD ANALYSES pH EN EAU pH IN WASSER CODE pH WATER pH EN AGUA A 1 1 soil water suspension 1 1 suspensi n suelo agua B 1 2 5 soil water suspension 1 2 5 suspensi n suelo agua C 1 5 soil water suspension 1 5 suspensi n suelo agua D 1 10 soil water suspension 1 10 suspensi n suelo agua E Saturated paste Pasta saturada 1 1 suspension sol eau 1 2 5 suspension sol eau 1 5 suspension sol eau 1 10 suspension sol eau P te satur e 1 1 Boden Wasser Suspension 1 2 5 Boden Wasser Suspension 1 5 Boden Wasser Suspension 1 10 Boden Wasser Suspension ges ttigte Paste CODE pH X pH X pH X pH X KCI solution of Soluci n de KCI Solution de KCI KCI L sung B Saturated paste in CaCOz Pasta saturada en CaCo3 P te satur e en CaCo ges ttigte Paste in CaCOz C CaCl solution Soluci n de CaCl Solution de CaCl CaClo L sung CODE ELECTRICAL CONDUCTIVITY CONDUCTIVIDAD ELECTRICA CONDUCTIVITE ELECTRIQUE ELEKTRISCHE
70. ase File Drivers Pressures State Impacts Responses framework Empresa de Pesquisa Agropecuaria e Extensao Rural Ethylenediaminetetra Acetic Acid Food and Agriculture Organization of the United Nations Geographic Information System International Business Machines Corporation Instituto de Recursos Naturales y Agrobiolog a de Sevilla International Soil Reference and Information Centre International Union of Soil Science Kiel University Land Evaluation System Land Resources Information System Land Use Planning Mega Byte Random Access Memory Monitoring and Evaluation Microcomputer based Land Evaluation Information System Ministerio Espa ol de Medio Ambiente Pedotransfer functions Research Institute for Soil Science and Agrochemistry Soil Database Multilingual Soil Database Sistema Espa ol de Informaci n de Suelos sobre Internet Soil and Terrain Database Triethanolamine Time Domain Reflectometry United Nations Environment Programme United Nations Educational Scientific and Cultural Organization United States Department of Agriculture World Bank World Reference Base for Soil Resources Worldwide Web Soil variables See Appendix A and E Chapter 1 Introduction BACKGROUND The increasing pressure on natural resources leads to the erosion physical degradation and chemical pollution of these resources along with a reduction of their productive capacity Computerised land evaluation techniques are a correct way to
71. ax 39 6 57053152 Http www microleis com Http www fao org AGL Contents Abstract List of figures List of abbreviations Chapter 1 INTRODUCTION Background Installation System requirements Set up Uninstall Conversion from previous database Chapter 2 STRUCTURE AND CONFIGURATION Variable types Stored variables Derived variables Data type Coded data Numerical data Text data String data Binary data Data organisation Profile code Horizon number Sample code Date Chapter 3 SOFTWARE FEATURES Control functions Menu controls Common buttons Pop up windows Help bars Detailed description Main menu Main option File Input Edit Delete Import Export Backup Restore Main option Codes Data Metadata Main option Content Soil profiles list View Print Graphics Statistics Metadata Main option Search Fast search Detailed search Main option Customize Additional variables Deactivating fields Main option Language Variables translation Labels translation Main option Evaluation Derived variables LES GIS files generator Main option Help Chapter 4 SOIL PROFILE OUTPUTS Stored soil profiles list Morphological description Analytical data tables Graphical presentations Statistical summary Analytical metadata report Coding system report LES GIS input files BIBLIOGRAPHY Appendix A List of stored soil variables Block 1 General information Block 2 Soil horizon descriptio
72. ble aluminium METCA CHAR 2 Method used to measure the exchangeable calcium METCACA CHAR 2 Method used to measure the effective CaCO3 METCACO CHAR 2 Method used to measure the total CaCO3 METCASO CHAR 2 Method used to measure the total CaSO4 METCECC CHAR 2 Method used to measure the CEC clay METCECS CHAR 2 Method used to measure the CEC soil METCL CHAR 2 Method used to measure the clay METCS CHAR 2 Method used to measure the coarse sand METCSI CHAR 2 Method used to measure the coarse silt METEC CHAR 2 Method used to measure the electro conductivity METFS CHAR 2 Method used to measure the fine sand METFSI CHAR 2 Method used to measure the fine silt METH CHAR 2 Method used to measure the exchangeable hydrogen CHAR CHAR CHAR CHAR CHAR NUMBER m D D D D D D ND D D D D Method used to measure the exchangeable potassium Method used to measure the fixed potassium Method used to measure the exchangeable magnesium Method used to measure the medium sand Method used to measure the nitrogen Method used to measure the exchangeable sodium Method used to measure the organic carbon Method used to measure the phosphorus Method used to measure the pH CaCl2 Method used to measure the pH water Method used to measure the sand Method used to measure the silt Method used to measure the very coarse sand Method used to measure the very fine sand Exchangeable magnesium Medium sand Nitrogen Exchangeable sodium Organic car
73. bon Phosphorus Base saturation percentage pH CaCI2 pH water Profile code Sand Sample code Silt Upper boundary depth Very coarse sand Very fine sand SDBANA2 DB file Data and Metadata FIELD TYPE SIZE DESCRIPTION ARS NUMBER 7 2 Arsenic BO NUMBER 5 2 Soluble boron CA NUMBER 52 Soluble calcium CD NUMBER 7 2 Cadmium CL NUMBER 52 Soluble Cl CO NUMBER 72 Cobalt CO3 NUMBER 52 Soluble CO3 CR NUMBER 7 2 Chrome CU NUMBER 72 Copper DATE DATE Sampling date EC NUMBER 5 2 Electro conductivity HCO3 NUMBER 52 Soluble HCO3 HG NUMBER 7 2 Mercury K NUMBER 52 Soluble potassium LOBO NUMBER 3 Lower boundary depth METARS CHAR 2 Method used to measure the arsenic METBO CHAR 2 Method used to measure the soluble boron METCA CHAR 2 Method used to measure the soluble calcium METCD CHAR 2 Method used to measure the cadmium METCL CHAR 2 Method used to measure the soluble CI METCO CHAR 2 Method used to measure the cobalt METCO3 METCR METCU METEC METHCO3 METHG METK METMG METMN METMO METNA METNI METNO3 METPB METPH METSAR METSB METSE METSO4 CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR NUMBER NUMBER NUMBER NUMBER NUMBER NUMBER NUMBER NUMBER CHAR CHAR NUMBER NUMBER NUMBER NUMBER NUMBER NUMBER D D D D D D ND D D D D ND D D D Method used to measure the soluble CO3 Method used to measure the chrome Method u
74. c Lithic Ruptic Argic Lithic Ruptic Entic Xerollic Lithic Ruptic Entic Lithic Udic Lithic Ruptic xerorthentic Lithic Ultic Lithic Ruptic Ultic Lithic Umbric Lithic Ruptic Xerochreptic Lithic Ustic Lithic Ustollic Lithic Vertic Lithic Xeric Lithic Xerollic Mollic Natric Ochreptic Orthidic Orthic Orthoxic Pachic Pachic udic Pachic Ultic Paleorthidic SO SO04 SP SP02 SP04 SU TE THO4 THOG TO TO02 TO04 TO06 TO10 TR TR02 TR04 UD UD01 UD02 UD03 UD05 UD10 UL UM UM02 US US02 US04 US06 US08 US12 VE Sombric Sombrihumic Sphagnic Sphagnic Terric Spodic Sulfic Terric Thapto Histic Thapto Histic Tropic Torrertic Torrifluventic Torriorthentic Torripsammentic Torroxic Tropaquodic Tropeptic Tropic Udertic Udalfic Udic Udollic Udorthentic Udoxic Ultic Umbreptic Umbric Ustalfic Usteric Ustic Ustochreptic Ustollic Ustoxic Vermic AR18 Arenic Ustollic GR Grossarenic PA08 Paleustollic VEO1 Vertic AR19 Arenic Petroferric GRO1 Grossarenic Entic PA10 Palexerollic XA Xanthic AR20 Arenic Petroferric Rhodic GRO4 Grossarenic Plinthic PA20 Paralithic Vertic Xeralfic AR21 Arenic Paleorthidic GROS Grossarenic Petroferric PE Pergelic XE02 Xerertic AR22 Argiaquic GR06 Grossarenic petroferric PE01 Pergelic Ruptic Histic XE04 Xeric Rhodic AR24 Argiaquic Xeric GRO7 Grossarenic Kandic PE02 Pergelic Sideric XE08 Xerollic AR26 Argic GR08 Grossarenic Kandic PE04 Petrocalcic Rhodic
75. c Salic Endosalic Episalic Hyposalic Sapric Silic Siltic Skeletic Endoskeletic Episkeletic Sodic Endosodic Hyposodic Spodic Spolic Stagnic Endostagnic Sulphatic Takyric Tephric Terric Thionic Orthithionic B 6 Cryic HI Histic Pl Placic TIT Protothionic CT Cutanic HIF Fibrihistic PA Plaggic TX Toxic DN Densic HIS Saprihistic PN Planic TU Turbic DU Duric HIB Thaptohistic PL Plinthic UM Umbric DY Dystric HT Hortic PLP Epiplinthic UB Urbic DYE Epidystric HU Humic PLH Hyperplinthic VT Vetic DYH Hyperdystric HUM Mollinumic PLO Orthiplinthic VM Vermic DYO Orthidystric HUU Umbrihumic PLR Paraplinthic VR Vertic ET Entic HG Hydragric PO Posic VI Vitric EU Eutric HY Hydric PF Profondic XA Xanthic EUN Endoeutric HK Hyperskeletic PR Protic YE Yermic EUH Ypereutric IR Irragric RD Reductic YES Nudiyermic EUO Orthieutric WRB 98 CLASSIFICATION SOIL UNIT SPECIFIER D Bathi P Epi Orthi T Proto C Cumuli H Hyper R Para B Thapto N Endo W Hypo USDA 87 CLASSIFICATION GREAT GROUPS Alfisols EQS Psammaquent IQL Plinthaquept OUA Haplustox ABB Paleboralf EQT Tropaquent IQN Andaquept OUC Acrustox ABE Eutroboralf EQV Fluvaquent IQP Placaquept OUE Eutrustox ABF Fragiboralf EQW Hydraquent IQS Sulfaquept OUK Kandiustox ABG Glossoboralf ER Arent IQT Tropaquept OUS Sombriustox B 7 ABN ABO ADA ADB ADC ADF ADG ADI ADK ADN ADR AGF AQD AQF AQG AQK AQL AQM AQN AQO AQW AUA AUB AUD A
76. cialmente compaction de la surface Oberfl chenverdichtung TE terracing aterrazado terrassement Terassierung VU vegetation disturbed con vegetaci n alterada v g tation d grad e gest rte Vegetation CODE CROPS CULTIVOS CULTURES FELDFRUCHT AL alfalfa alfalfa luzerne Luzerne AM almond tree almendro amandier Mandelbaum BA barley cebada orge Gerste BE beans jud as haricots verts Bohnen CR carthamus c rtamo cartheme CH cashew anacardo noix d acajou Cashewn sse CA cassava mandioca cassave CO cocoa cacao cacao Kakao CC coconut COCO noix de coco KokosnuR CF coffee caf caf Kaffee CT cotton algod n coton Baumwolle CP cowpea frijol ni b FB flooded rice arroz inundaci n riz inondation Reis FR fruits cultivos fruticolas fruits Obst GR groundnut cacahuete arachide ErdnuR MA maize maiz mais Mais MI millet mijo millet Hirse AM oats avena avoine Hafer OP oil palm palma aceitera palme huile lpalme OL olive tree olivos olivier Olivenbaum PE peas guisantes petit pois Erbsen PO potato patata pomme de terre Kartoffel RI rice arroz riz Reis RR rubber caucho caoutchouc Kautschuk SO sorghum Sorgo sorghum SY soyabean soja soja Sojabohne SC sugar cane ca a de az car canne sucre Zuckerrohr SB sugarbeet remolacha betterave Zuckerr be SF sunflower girasol tournesol Sonnenblumen SP sweet potato batata patate douce S Rkartoffel TE tea t th Tee TB tobacco tabaco tabac Tabak RU upland rice arroz de
77. ck 6 Hydraulic conductivity screen Figure 3 9 Block 7 Additional variables screen Figure 3 10 Block 8 Photographs screen Figure 3 11 SDBm Plus FAO CSIC Multilingual Soil Profile Database Input data Figure 3 2 Input data soil profile general information page 1 screen SDBm Plus FAO CSIC Multilingual Soil Profile Database Input data E Double click or press F1 to see the coding system Figura 3 3 Input data soil profile general information page 2 screen SDBm Plus FAD CSIC Multilingual Soil Profile Database Input data wm EE LI IN LL LL L N Figure 3 4 Input data soil horizon description screen SDBm Plus FAO CSIC Multilingual Soil Profile Database Input data E E po 1414119114 Double click to see the coding system Figure 3 5 Input data soil standard analyses screen SDBm Plus FAO CSIC Multilingual Soil Profile Database Input data EE bebe deed la LIN Ram mn mmm mn Double click to see the coding system Figure 3 6 Input data soil soluble salts heavy metals screen SDBm Plus FAO CSIC Multilingual Soil Profile Database Input data alate al ale Es Double click to see the coding system Figure 3 7 Input data soil physical analyses screen SDBm Plus FAO CSIC Multilingual Soil Profile Database Input data es Double click to see the coding system Figure 3 8 Input data soil water retention screen
78. convexa convexe konvex T terraced aterrazada tag e en terrasses terassenf rmig X complex compleja complexe komplex CODE MICROTOPOGRAPHY MICROTOPOGRAF A MICROTOPOGRAPHIE MIKROTOPOGRAPHIE GL low gilgai gilgai poco desarrollado gilgai peu d velopp niedriger Gilgai GM medium gilgai gilgai moderadamente desarrollado gilgai mod r ment d velopp mittlerer Gilgai GH high gilgai gilgai muy desarrollado gilgai tr s d velopp hoher Gilgai GI gilgai gilgai gilgai Gilgai TM termite mounds t mulos de termitas tumulus de termites Termitenh gel AT animal tracks huellas de animales empreintes d animoux Tierpfade AB animal burrows madrigueras galeries d animaux Tierh hlen bau HL low hummocks mont culos bajos monticules bas niedrieger Hummock H gel HM medium hummocks mont culos medios monticules moyens mittlerer Hummock H gel HH high hummocks mont culos altos monticules hauts hoher Hummock H gel HU hummocks mont culos monticules H gel UN uneven terreno no nivelado terrain non nivel uneben SS shifting sands arenas m viles sables mobiles Treibsand LE level llano niveau Meeresniveau 0 even terreno nivelado terrain nivel eben 1 4 Land use and vegetation CODE LAND USE USO DEL TERRENO USAGE DU TERRAIN LANDNUTZUNG 0 none ninguno n ant keine U not used and not managed sin uso ni manejo non utilis ungenutzt und nicht verwaltet S settlements urbano agglom rations urbaines Siedlungen A agriculture agr
79. creen Derived variables screen LES GIS file generation screen Help screen Example of stored soil profiles list printout Example of soil profile standard morphological description printout Example of soil profile analytical data table printout Example of soil profile graphical presentations printout Vertical distribution Example of soil profile graphical presentations printout Suction vs water content Example of statistical summary printout Example of soil profile analytical metadata report printout Example of coding system report printout Example of LES GIS input files Main file Example of LES GIS input files Descriptive files Example of GIS map showing the combination of polygon information with point information referred to the variable from SDBm Plus AEZ ASCII AGLL CD ROM CEBAC CEC CGIAR CIDE CSIC DBF DPSIR EPAGRI ETDA FAO GIS IBM IRNAS ISRIC IUSS KU LES LRIS LUP MB RAM M amp E MicroLEIS MIMAM PTF RISSA SDB SDBm SEIS net SOTER TEA TDR UNEP UNESCO USDA WB WRB WWW List of abbreviations Agro Ecological Zoning American Standard Code for Information Interchange Land and Plant Nutrition Management Service Compact Disk Read Only Memory Centro de Edafolog a y Biolog a Aplicada del Cuarto European Commission Consultive Group on International Agricultural Research Centro de Investigacion sobre la Desertificacion Consejo Superior de Investigaciones Cient ficas Datab
80. cuenca bassin Becken PY beach playa plage Strand CP coastal plain llano costero plaine c ti re K stenebene DT delta delta delta Delta DU dunefield campo de dunas champ de dunes D nenfeld FG fluvio glacial plain llano fluvio glacial plaine fluvio glaciale fluvio glaziale Ebene GP glacial plain llano glacial plaine glaciaire glaziale Ebene HI hill colina colline H gel LP lacustrine plain llano lacustre plaine lacustre Ebene aus Seesedimenten LA lava plain llano de lava plaine de lave Lavafeld MO mountain monta a montagne Berg PE pediment piedemonte p diment BergfuRniederung PN peneplane penillanura p n plaine Fastebene Penepl ne PL plain llano plaine Ebene PT plateau meseta plateau Plateau Hochebene SP sand plain llano de arena plaine de sable Sandebene TF tidal flat llanura mareal slikke Watt UP upland sierra cha ne de montagne Hochland VA valley valle vall e Tal VO volcano volc n volcan Vulkan CODE LAND ELEMENT POSICION FISIOGR FICA POSITION PHYSIOGRAPHIQUE LANDELEMENT AF alluvial fan abanico aluvial glacis alluvial Schwemmfacher BA backswamp pantano marais Auesumpf BR beachridge frente de dunas front de dunes maritimes Strandwall CA caldera caldera crat re Kaldera CH channel canal canal Kanal CO coral reef arrecife de coral r cif de corail Korallenriff DE depression depresi n d pression Senke DU dune duna dune D ne FP flood plain llano inundable plaine alluviale Uberschwemmungsgebiet ID
81. database and Save option is used to store the image from the database to a JPEG file All data are entered for individual soil profiles The soil profile is identified by its profile code Invalid codes are not accepted The profile codes are unique i e it is not possible to enter duplicates if a profile code that already exists is entered an error message will appear on the screen Delete data The button is used to remove all information stored under a particular soil profile code from the database Before proceed to the deletion SDBm Plus asks for confirmation SDBm Plus allows deletion of only part of the profile information stored Upon selecting any of the existing profiles 1t is possible to remove single horizons or analytical samples Methods used In the SDBm Plus system special attention is given to the harmonization of soil analytical measurement techniques among the different institutions This sub option intends to minimize the method effect on the class variability of the soil analytical properties Coded information on the methods used for the laboratory analysis should be entered under the heading Methods used and should follow the same criteria used in coded soil variables Appendix C Import Export Import data This facility Figure 3 13 is used to transfer information L From a previous SDBm database Chapter 1 From other SDBm Plus databases Available data on a single soil profile or a serie
82. deacivate fields SE lt q lt q lt q lt q lt q lt q lt q 4 M lt lt lt lt lt lt lt lt lt lt lt q lt q lt q lt q lt lt Figure 3 20 Deactivating fields screen Main option Language This SDBm Plus main option selects or creates a new working language The default language used is English and currently the database can also work in Spanish French and German The future software expansion is foreseen to include other languages In order to establish the grammatical rules for the sentences specially in the horizon description the language group Romance Spanish French etc or Germanic English German etc must be specified for each new language Upon selecting a different language the program changes the memory variables to those of the new language selected Through the Change language option is possible to select a new language between the previously created languages To create a new language or change an existing one select the Edit New language sub option If the language is a new one input the name of the language into the corresponding box Then select the language group Germanic or Romance And finally translate the corresponding labels in the screen After press the Accept button the system will create a new folder into the language folder of the installation containing the necessary files for the new l
83. des and definitions of all the generalisation levels of each coded variable Appendix B This system recognizes the codes and the correspondent definitions for the variable groups 3 12 O Block 1 General information 28 variables 28 fields O Bock 2 Soil horizon description 12 variables 77 fields The coding system which forms an integral part of the SDBm Plus system and is stored in a number of conversion tables is also used to develop the multilingual dimension of this database As shown in Figure 3 15 and Appendix B the first field of the conversion table contains the code of each generalization level whereas the following four contain the definition terms in the working languages English Spanish French and German The coding system follows the Guidelines for Soil Profile Descriptions of FAO ISRIC 1990 However the classifications of the variables are not fixed Each conversion table can be edited interactively This means that codes can be added definition terms can be changed and codes and definitions can be removed from the classification of each variable Consequently the default SDBm Plus coding system for the site and horizon description can be enhanced and updated by the user The current coding system can be viewed or printed alphabetically by code as a SDBm output Chapter 4 ia SDBm Plus FAD CSIC Multilingual Soil Profile Database Coding system Data Data blocks 2 Variables 50 Generalizatio
84. ds Registration Soil classification Surface characteristics Soil water relationship Soil horizon description fields Soil colour Primary constituents Organisation and constituents Voids and porosity Concentrations Biological activity Soil reaction Horizon boundary Matrix colour Rock fragments Cutanic features Field pH Las profundidades deben ser valores enteros Interfaz de evaluaci n generador de archivos LES GIS Espesor de la capa Forma de c lculo Media ponderada Valor dominante Campos de informaci n general Registro Clasificaci n de suelo Caracter sticas de la superficie Relaci n suelo agua Campos de descripci n de horizontes de suelo Color del suelo Constituyentes principales Organizaci n y constituyentes Huecos y porosidad Concentraciones Actividad biol gica Reacci n del suelo L mite del horizonte Matriz de colores Fragmentos rocosos Caract de los cutanes pH de campo La profondeur doit tre un nombre entier Interface d evaluation g nerateur d archive LES GIS Epaisseur de la couche Mode de calcul Moyenne pond r e Valeur dominante Champs d information g nerale Registre Classification du sol Caract ristiques de surface Relation Sol Eau Champs de description de l horizon du sol couleur du sol Constituants primaires Organisationet constituants Pores et porosit Concentrations Activit biologique R action du sol Limite d horizon Couleur de matrice
85. dudalfs Glossudalfs Hapludalfs Cryaquands Placaquands Duraquands Vitraquands Melanaquands Epiaquands Endoaquands Duricryands Hydrocryands Melanocryands Fulvicryands Vitricryands Haplocryands Duritorrands Vitritorrands Haplotorrands Vitrixerands Melanoxerands Haploxerands Ustivitrands Udivitrands LCB LCC LCD LCE LCF LDA LDB LDC LDD LDE LEA LEB LEC LED LEE Gelisols AAA AAB AAC AAD AAE ABA ABB ABC ABD ABE ABF ABG ACA ACB ACC ACD Torripsamments Quartzipsamments Ustipsamments Xeropsamments Udipsamments Cryofluvents Xerofluvents Ustifluvents Torrifluvents Udifluvents Cryiorthents Torriorthents Xerorthents Ustorthents Udorthents Folistels Glacistels Fibristels Hemistels Sapristels Histoturbels Aquiturbels Anhyturbels Molliturbels Umbriturbels Psammoturbels Haploturbels Historthels Aquorthels Anhyorthels Mollorthels Mollisols IAA IAB IBA IBB IBC IBD IBE IBF IBG ICA ICB IDA IDB IDC IDD IDE IDF IEA IER IEC IED IEE IEF IFA IFB IFC IFD IFE IFF IFG IGA IGB Natralbolls Argialbolls Cryaquolls Duraquolls Natraquolls Calciaquolls Argiaquolls Epiaquolls Endoaquolls Cryrendolls Haprendolls Duricryolls Natricryolls Palecryolls Argicryolls Calcicryolls Haplocryolls Durixerolls Natrixerolls Palexerolls Calcixerolls Argixerolls Haploxerolls Durustolls Natrustolls Calciustolls Paleustolls Argiustolls Vermustolls Haplustolls Natrudolls Ca
86. e class ELEV NUMBER 4 Elevation ERI CHAR 2 1 erosion deposition intensity ERI2 CHAR 2 2 erosion deposition intensity ERK1 CHAR 2 1 erosion deposition type ERK2 CHAR 2 2 erosion deposition type F3L CHAR 3 FAO 90 3 level FAO CHAR 3 FAO 74 soil unit FLOD CHAR 2 Flooding duration FLOF CHAR 2 Flooding frequency FSU CHAR 3 FAO 90 soil unit GRCO CHAR 1 Grass cover GRID CHAR 12 Grid number GWAB CHAR 2 Maximum watertable depth GWAD CHAR 2 Watertable depth GWAK CHAR 2 Watertable kind GWAT CHAR 2 Minimum watertable depth HUM CHAR 2 Human influence LAEL CHAR 2 Land element LAFO CHAR 2 Land form LAT CHAR 7 Latitude LOC CHAR 120 Location LON CHAR 8 Longitude LOSE CHAR 3 Local soil serie LUT CHAR 5 Land use type MITO CHAR 2 Micro topography MOC1 CHAR 1 1 moisture condition MOC2 CHAR 1 2 moisture condition MOC3 CHAR 1 3 moisture condition MOD1 NUMBER 3 1 moisture depth MOD2 NUMBER 3 2 moisture depth MOD3 NUMBER 3 3 moisture depth NUT4 CHAR 5 Level 4 NUT PAM1 CHAR 2 1 parent material PAM2 PERM PHAS PHOTO1 PHOTO2 PHOTO3 PHOTO4 POS PRNO REMARKS ROCD ROCQ ROCH ROTY SCLM SEAL SHNO SLFR SLGR SMOI SPE1 SPE2 SPE3 SPE4 SPE5 STAT STEM STGG STMI STOQ STOS STRE STSG STTX SURVEYAREA TOP UNIT VEG WRB98GR WRB98SP WRB98UN CHAR CHAR CHAR BLOB BLOB BLOB BLOB CHAR CHAR TEXT CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR
87. e harmonisation of soil analytical measurement techniques CODING SYSTEM REPORT A printout of the coding system stored in the database Figure 4 7 15 generated using the Main option Codes Chapter 3 This printout includes the conversion tables in the four different languages This report gives transparency to the coding system stored allowing for correction of the codes and definitions and also for the comparison between SDBm Plus databases SDBm Plus FAO CSIC Multilingual Soil Profile Database Profile code SE0305 Sample A B C D SDBm Plus FAO CSIC Multilingual Soil Profile Database Depth cm 0 30 30 48 48 82 82 Profile code SE0305 Sample Depth cm 0 30 30 48 48 82 82 7 7 7 5 7 5 7 5 As 6 1 5 7 5 7 EC Ca mS cm 1 53 0 511 1 93 0 667 3 63 1 349 4 81 1 756 Cd Co 0 12 1 0 125 0 11 8 0 5 02 SOLUBLE SALTS Mg K 0 134 0 035 0 139 0 037 0 254 0 044 0 362 0 048 HEAVY METALS Cr 56 5 57 59 5 67 5 Cu 26 9 27 1 26 9 27 8 Na 0 52 0 686 1 184 1 734 Hg 0 05 D 0 0 0 Bo ooo 2 o a Mn mg kg 511 603 530 472 Figura 4 3 Example of soil profile analytical data table printout CO meq 100g oooo Mo HCO 0 166 0 114 0 146 0 153 Ni 28 4 31 9 30 9 29 2 E Vertical variability A ES Soil profile SE0305 Cobalt mg kg 0 00 500 10 00 15 00 20 00 25 00 Figure 4 4a
88. et tendres hart und weich CODE NODULES NATURE NATURALEZA DE LOS NATURE DES NODULES BESCHAFFENHEIT DER N DULOS K calcareous calc rea calcaires kalkhaltig G gypsiferous yes fera gypsif res gipshaltig Q siliceous silicea siliceux silikathaltig S iron manganese de hierro manganeso ferro manganeux Eisen Mangan haltig F ferrigenous ferruginosa ferrugineux eisenhaltig M manganiferous mangan fera manganif re manganhaltig C argilleous arcillosa argileux tonhaltig X carbonate silic carbonato s lice carbonate silic Carbonat Silikat haltig T clay sesquioxid arcilla sesqui xido argile sesquiox Ton Sesquioxid haltig L salt sal sels Salz U sulphur sulfurosa sulfure Schwefel N not known desconocida inconnus unbekannt CODE NODULES COLOUR COLOR DE LOS N DULOS COULEUR DES NODULES FARBE DER WH white blanco blancs wei RE red rojo rouges rot BR brown pardo bruns braun GR grey gris gris grau YE yellow amarillo jaunes gelb BB bluish black negro azulado noir bleu tre blau schwarz BL black negro noirs schwarz RB reddish black negro rojizo noir rouge tre r tlich schwarz RS reddish rojizo rouge tres r tlich YR yellowish red rojo amarillen rouge jaun tre gelblich rot BS brownish parduzco brun tres br unlich YB yellowish brown pardo amarille brun jaun tre gelblich braun RY reddish yellow amarillo rojizo jaune rouge tre r tlich gelb GE green verde vert gr n GS greyish gris ceo gris tres gr ulich BU blue azul ble
89. etroargids Natrargids Paleargids Gypsiargids Calciargids Haplargids Petrocalcids Haplocalcids Aquicambids Petrocambids Anthracambids Haplocambids Sulfaquents Hydraquents Cryaquents Psammaquents Fluvaquents Epiaquents Endoaquents Ustarents Xerarents Torriarents Udarents Cryopsamments Inceptisols KAA Sulfaquepts KAB Petraquepts KAC Halaquepts KAD Fragiaquepts KAE Cryaquepts KAF Vermaquepts KAG Humaquepts KAH Epiaquepts KAI Endoaquepts KBA Plagganthrepts KBB Haplanthrepts KCA Eutrocryepts KCB Dystrocryepts KDA Durustepts KDB Calciustepts KDC Dystrustepts KDD Haplustepts KEA Durixerepts KEB Calcixerepts KEC Fragixerepts KED Dystroxerepts KEE Haploxerepts KFA Sulfudepts KFB Durudepts KFC Fragiudepts KFD Eutrudepts KFE Dystrudepts EDE Haploperox EEA Sombriudox EEB Acrudox EEC Eutrudox EED Kandiudox EEE Hapludox Spodosols CAA Cryaquods CAB Alaquods CAC Fragiaquods CAD Placaquods CAE Duraquods CAF Epiaquods CAG Endoaquods CBA Placocryods CBB Durycriods CBC Humicryods CBD Haplocryods CCA Placohumods CCB Durihumods CCC Fragihumods CCD Haplohumods CDA Placorthods CDB Durorthods CDC Fragiorthods CDD Alorthods CDE Haplorthods Ultisols JEA JEB JEC JED JEE JEF JEG JEH JEJ Andisols DAA DAB DAC DAD DAE DAF DAG DBA DBB DBC DBD DBE DBF DCA DCB DCC DDA DDB DDC DEA DEB Natrudalfs Ferrudalfs Fraglossudalfs Fragiudalfs Kandiudalfs Kanhapludalfs Paleudalfs Rho
90. euillage caduque Laubstr ucher SX xeromorphic shrub arbusto xerom rfico arbuste x romorphe xeromorphische Str ucher D dwarf shrub arbusto enano arbuste nain Zwergstr ucher DE evergreen dwarf shrub arbusto enano perennifolio arbuste nain sempervirent immergr ne Zwergstr ucher DS semi deciduous dwarf shrub arbusto enano semi caducifolio arbuste nain feuillage semi gemischte Zwergstr ucher caduque deciduous dwarf shrub arbusto enano caducifolio arbuste nain feuillage caduque Laubzwergstr ucher DX xeromorphic dwarf shrub arbusto enano xerom rfico arbuste nain x romorphe xeromorphische Zwergstr ucher DT tundra tundra toundra Tundra H herbaceous herb ceos herbe krautartige Pflanzen HT tall grassland pasto alto prairie haute Langgrassteppe HM medium tall grassland pasto medio prairie moyenne Steppe mit mittellangem Gras HS short grassland pasto bajo prairie basse Kurzgrassteppe HF forb helecho herbe G grassland pradera herbages Steppe SA savanna sabana brousse Savanne CODE SPECIES ESPECIES ESPECES ARTEN AO andaluz oak roble andaluz ch ne d Andalousie Andalusische Eiche AP aspen poplar chopo tembl n peuplier tremble BP black pine pino negro pin noir Schwarzkiefer CN black poplar chopo negro peuplier noir Schwarzpappel CP canario pine pino canario pin canario Kanarische Kiefer AL carob tree algarrobo caroubier Johannesbrotbaum CT chestnut tree casta o ch taigne Kastanie CO cork oak alcornoque ch ne
91. file and facilitates comparison with other soils Chapter 4 Statistics From the soil profiles list itis possible to see a summary statistical report of the data in this list After select the analytical variables to be considered and clicking over the Accept button atable with the following statistics is shown number of soil samples n range m minimum value and M maximum value standard deviation and coefficient of variation This application is very useful to make a first statistical analysis of the stored data Chapter 4 Metadata On the report screen and by clicking over the Metadata button it is possible to view the analytical method used for the determinations Also a report with the methods used in the analytical characterization of any soil profile can be printed Chapter 4 Main option Search This SDBm Plus main option selects soil profiles based on the presence of one or 3 15 more variables with specified values Fast search This procedure Figure 3 17 should be used if the database is to be searched by one or a combination of two of the following key soil variables O Profile code for instance profiles XXX000 to XXX100 Note that the lowest profile code should exist in the database otherwise the procedure results in a no find Soil classification FAO 74 and 90 USDA 87 and 98 or and WRB 98 Searches may be defined on a first and second level and if needed on a third level Soil unit
92. graphic displays files graphic reports Soil profile ouputs Figure 2 1 General scheme of the SDBm Plus database The blocks should be seen as separate datasets which can be manipulated inde pendently For instance for a certain soil profile only the analytical results may be entered updated printed or selected It is not important which data block is entered first or in which order the soil profiles are entered in the data blocks Derived variables A set of non stored variables calculated by using pedotransfer functions through the evaluation interface facility is also considered by the SDBm Plus system By using several approaches soil mechanical and hydraulic properties which are of difficult and time consuming determination can be estimated from more readily available simple data obtained during soil surveys This set of soil variables correspond to O Block 10 Derived variables Information calculated by pedotransfer functions DATA TYPE As specified for each variable in Appendix A the soil profile data stored in the SDBm Plus database are of the following types Coded data General and horizon information is largely stored in a coded format according to the SDB coding system This system is flexible and is part of the database It contains a set of default classes and codes however changes or additions can be made See Chapter 3 for more information on this subject Numerical data Laboratory data are predom
93. gruppe mineralogy reaction Soil temperature Soil Humidity Colour modifier Electrical conductivity Phosphorus Nitrogen Carbon Total calcic carbonate Effective calcic carbonate Calcic sulphate Cation exchange capacity Exchangeable calcium Exchangeable magnesium Exchangeable potassium Exchangeable sodium Hydrogen Aluminium Fixed potassium Very coarse sand Coarse sand Medium sand Fine sand Very fine sand Coarse silt Fine silt Sand Silt Clay CEC of the clay Calcium Magnesium Potassium Sodium Boron mineralog a reacci n Temperatura del suelo Humedad del suelo Modificador del color Conductividad el ctrica F sforo Nitr geno Carbono Carbonato c lcico total Carbonato c lcico efectivo Sulfato c lcico Capacidad de intercambio cati nico Calcio cambiable Magnesio cambiable Potasio cambiable Sodio cambiable Hidr geno Aluminio Potasio fijado Arena muy gruesa Arena gruesa Arena media Arena fina Arena muy fina Limo grueso Limo fino Arena Limo Arcilla CIC de la arcilla Calcio Magnesio Potasio Sodio Boro min ralogie r action Temp rature du sol Humidit du sol Modificateur de couleur Conductivit lectrique Phosphore Azote Carbone Carbonate calcique total Carbonate calcique effectif Sulfate calcique Capacit d change cationique Calcium changeable Magn sium changeable Potassium changeable Sodium changeable Hydrog ne Alumi
94. i KA Calci VE Verti RH Rhodi PE Pelli WRB 98 CLASSIFICATION SOIL GROUP AC Acrisol CH Chernozem KS Kastanozem PT Plinthosol AB Albeluvisol CR Cryosol LP Leptosol PZ Podzol AL Alisol DU Durisol LX Lixisol RG Regosol AN Andosol FR Ferralsol LV Luvisol SC Solonchak AT Anthrosol FL Fluvisol NT Nitisol SN Solonetz AR Arenosol GL Gleysol PH Phaeozem UM Umbrisol CL Calcisol GY Gypsisol PL Planosol VR Vertisol CM Cambisol HS Histosol B 5 WRB 98 CLASSIFICATION SOIL UNIT AP AE AC AO AB ABH ABG Abruptic Aceric Acric Acroxic Albic Hyperalbic Glossalbic Alcalic Alic Alumic Andic Aluandic Silandic Anthraquic Anthric Anthropic Aric Arenic Aridic Arzic Calcaric Calcic Hypercalcic Hypocalcic Orthicalcic Carbic Carbonatic Chernic Chloridic Chromic Eutrisilic Ferralic Hyperferralic Hypoferralic Ferric Hyperferric Fibric Folic Fluvic Fragic Fulvic Garbic Gelic Gelistagnic Geric Gibbsic Glacic Gleyic Endogleyic Epigleyic Glossic Molliglossic Umbriglossic Greyic Grumic Gypsic Hypergypsic Hypogypsic Gypsiric Haplic LL LEN LEP LIP Lamellic Leptic Endoleptic Epileptic Lithic Paralithic Lixic Luvic Hypoluvic Magnesic Mazic Melanic Mesotrophic Mollic Natric Nitic Ochric Hyperochric Ombric Orthic Oxyaquic Pachic Pellic Petric Epipetric Petrocalcic Petroduric Petrogypsic Petroplinthic Petrosalic Regic Rendizc Rheic Rhodic Rubic Ruptic Rusti
95. iction angle pre consolidation stress void load relationship etc These additional variable only contain numeric data These variables are defined by using the Main option Language Figure 3 19 selecting the additional variable labels and introducing the new variable names in the same language Once the variables are activated they can be used as any other SDBm Plus variable They may be printed shown on data screens or used for selections SDBm Plus FAO CSIC Multilingual Soil Profile Database Activate deacivate fields Figure 3 19 Additional variables screen Deactivating fields Tf not all the soil information available in SDBm Plus is to be entered this function Figure 3 20 allows to deactivate unnecessary fields This makes data entry faster and easier Deactivated fields will disappear from the Input Edit Delete screens The deactivation is permanent and it will be maintained until deactivated fields are re activated by the user Nevertheless activation and deactivation do not compromise data previously entered The De Activation sub option is possible with the following variable groups Block 1 General description Block 2 Soil horizon description Block 3 Standard analyses Block 4 Soluble salts Heavy metals Block 5 Physical data 0 Bb JE 0 ET Block 6 Water retention Hydraulic conductivity O Block 7 Additional variables SDBm Plus FAD CSIC Multilingual Soil Profile Database Activate
96. ilizado application d engrais Einsatz von D ngemitteln AD artificial drainage artificialmente drenado drainage artificiel k nstliche Entw sserung BU bunding cercado bunding BR burning with con restos quemados avec restes d incendies Verbrennung CL clearing aclarado clairci Rodung Abholzung IP flood irrigation riego a manta irrigation par inondation Bew sserng durch berschwemmung IF furrow irrigation riego por surco irrigation par sillon Rillen Furchenbew sserung IU irrigation de regad o irrigation Bew sserung IB Border irrigation riego irrigation Bew sserung MU mineral fertilizer use uso de fertilizantes usage des engrais Nutzung von Minerald ngern VM moderat disturbed vegetation vegetaci n modera disturbada v g tation mod r ment troubl m ig gest rte Vegetation NK not known desconocida inconnue unbekannt MP plaggen pl geno plaggen plaggen PL ploughing arado labourage pfl gen PO pollution contaminado pollution Verschmutzung MR raised beds levantado billons sur lev s Hochbeete MS sand additions enarenado apports de sable Sandzugabe VS slightly disturbed vegetation veget ligeramente disturbada v g tation l g rement troubl leicht gest rte Vegetation IS sprinkler irrigation riego por aspersi n irrigation par aspersion k nstliche Beregnung VE strongly disturbed vegetation vegetaci n fuert disturbada v g tation fortement troubl stark gest rte Vegetation SC surface compaction compactado superfi
97. inantly stored in a numerical format Text data Text or descriptive data such as remarks are stored in exactly the same way as they are entered String data Some variables are stored as a string of characters plus digits of limited size Binary data Photographs are stored in JPEG format DATA ORGANISATION In the SDBm Plus database the different datasets on soil profile are organized making use of the following data tables and connectors Figure 2 2 All the fields included in each of these tables are listed in Appendix E Profile code The soil profile code containing 6 digits e g SE0123 is particularly important since it identifies the information in each block of data links the data blocks and connects them to the actual horizon or sample Horizon number A soil horizon in a soil profile is referenced by the horizon number e g 1 2 3 etc although into the database it is referenced by the union of profile code plus horizon number This one to many relationship means that several horizons belong to a single soil profile Sample code A soil sample in a soil profile is referenced by the sample code e g A B C etc The analytical dataset maintains a one to many relationship with the general information through the profile code likewise a record is defined in the dataset by combining profile code and the sample code Block 1 8 General description SDBSITE Block 2 Horizons
98. ine 16 Loamy 24 Sandy skeletal 03 Ashy skeletal 10 Fine loamy 18 Loamy skeletal 25 Strongly Contrasting Particle Size Classes 04 Cindery 11 Fine silty 19 Medial 26 Very fine 05 Clayey 12 Fragmental 20 Medial pumiceous 06 Clayey skeletal 13 Hydrous 21 Medial skeletal 07 Coarse loamy 14 Hydrous pumiceous 22 Pumiceous Reaction 01 Acid 02 Allic 03 Calcareous 04 Nonacid 1 2 Climate classification only in English language SOIL CLIMATE USDA 87 AND 98 MOISTURE REGIME AQ Aquic AR Aridic UD Udic US Ustic PQ Peraquic TO Torric PU Perudic SOIL CLIMATE USDA 87 AND 98 TEMPERATURE REGIME PG Pergelic TH Thermic IT Isothermic SG Subgelic CR Cryic HT Hyperthermic IH Isohyperthermic FR Frigid IF Isofrigid MT Megathermic ME Mesic IM Isomesic HG Hypergelic 1 3 Landform and topography CODE TOPOGRAPHY TOPOGRAF A TOPOGRAPHIE TOPOGRAPHIE F flat plana plate flach A almost flat casi plana fresque plate nahezu flach G gently undulating ligeramente ondulada l g rement ondul e leicht wellig U undulating ondulada ondul e wellig R rolling moderadamente ondulada l g rement ondul e wellig H hilly colinada collinaire h gelig S steeply dissected a fuertemente socavada abrupte steil zerkl ftet M mountainous monta osa montagneuse bergig CODE LANDFORM GEOMORFOLOG A GEOMORPHOLOGIE GEOMORPHOLOGIE AP alluvial plain llano aluvial plaine alluviale alluviale Ebene BA basin
99. ion Water content Reference variable Hydr cond Additional variable 1 Additional variable 2 Additional variable 3 M todo usado Granulometria Amg Arena muy gruesa Ag Arena gruesa Am Arena media Af Arena fina Amt Arena muy fina Arena Lg grueso Lf X Limo fino Limo Arcilla CICa Total Activo Cationes solubles Aniones solubles Metales pesados Conductividad hidr ulica a saturaci n Contenido de agua real Indice de estabilidad estructural Densidad aparente Resistencia a la penetraci n Densidad de las part culas Porosidad total Tipo de medida N mero de medidas laboratorio campo Succi n Cont de agua Variable de referencia Cond hidr Variable adicional 1 Variable adicional 2 Variable adicional 3 M thode utilis e Granulom trie Stg Sable tr s grossier Sg Sable grossier Sm Sable moyen Sf Sable fin Stf Sable tr s fin Sable Lg Limon grossier Lf Limon fin Limon Argile CECc Total Actif Cations solubles Anions solubles M taux Lourds Conductivit hydraulique satur e Contenu d eau r el Indice de stabilit structurale Densit apparente R sistance la p n tration Densit des particules Porosit totale Type de mesure Nombre de mesures laboratoire champ Succion Cont d eau Variable de r f rence Cond hydr Variable additionnelle 1 Variable additionnelle 2 Variable additionnelle 3 verw Methode Tei
100. isca arenisca Oligoceno arenisca Pleistoceno esquisto esquisto C mbrico esquisto Tri sico roca sedimentaria lutita lutita C mbrico lutita Carbon fero lutita Dev nico lutita Dev nico limonita toba volc nica roca ultrab sica gr s calcaire Mioc ne gr s limoniteux Plioc ne calcaire calcaire Cambrique calcaire Eoc ne calcaire Jurassique marne marne Cr tac marne Eoc ne marne Mioc ne marne Oligoc ne marne Trias marne gypsum Plioc ne marne gypsum Trias inconnue pierre ponce roche pyroclastique quartzite gr s gr s Oligoc ne gr s Pl istoc ne schiste schiste Cambrique schiste Triassique roche s dimentaire shale shale Cambrique shale Carbonif re shale D vonien shale D vonien limonite tuf roche ultrabasique Kalksandstein Mioz n Kalksandstein Plioz n Kalkstein Kalkstein Kambrium Kalkstein Eoz n Kalkstein Jura Mergel Mergel Kreide Mergel Eoz n Mergel Mioz n Mergel Oligoz n Mergel Trias Mergel Gips Plioz n Mergel Gips Trias unbekannt Bimsstein pyroklastiches Gestein Quarzit Sandstein Sandstein Oligoz n Sandstein Pleistoz n Schiefer Schiefer Kambrium Schiefer Trias Sedimentgestein Schiefer Schiefer Schiefer Schiefer Schiefer Kambrium Devon Tuff extrem basisches Gestein PROFUNDIDAD TIL CODE EFFE
101. istics to engineering qualities of soil Soil Science 30 793 799 De la Rosa D Coord 1999 MicroLEIS 2000 Integrated system for land data transfer and agro ecological land evaluation CSIC IRNAS Sevilla Http leu irnase csic es De la Rosa D Coord 2000 SEIS net Sistema espa ol de informaci n de suelos sobre Internet MIMAM CSIC Sevilla Http leu irnase csic es mimam seisnet htm FAO 1974 FAO UNESCO Soil map of the World Vol 1 Legend UNESCO Paris FAO 1976 A framework for land evaluation FAO Soils Bulletin 32 Rome FAO 1990 Soil units of the soil map of the World FAO UNESCO ISRIC Rome FAO 1995 Global and national soils and terrain digital database SOTER Procedures manual World Soil Resources Report 74 FAO Rome FAO 1997 Agro ecological zoning General guidelines FAO Soils Bulletin 73 Rome Http www fao org W AICENT FaoInfo Agricult AGL Aglhomep htm FAO and ISRIC 1989 SDB Soil database World Soil Resources Report 64 FAO Rome FAO and ISRIC 1990 Guidelines for soil profile description Third edition revised FAO Rome FAO ISRIC and CSIC 1995 SDBm Multilingual soil database World Soil Resources Report 81 FAO Rome FAO ISRIC and IUSS 1998 WRB World reference base for soil resources World Soil Resources Report 84 FAO Rome FAO and UNEP 1999 The future of our land Guidelines for integrated planning for sustainable management of land resources UNEP FAO
102. kannt CODE NODULES ABUNDANCE CANTIDAD DE NODULOS ABONDANCE DES NODULES 0 nil ninguna n ant keine V very few muy poca tr s peu nombreux sehr wenige F few poca peu nombreux wenige C common frecuente nombreux einige M many mucha tr s nombreux viele A abundant abundante abondants reichlich D dominant dominante dominants dominierend CODE NODULES KIND TIPO DE N DULOS TYPE DES NODULES C concretions n dulos concreciones concr tions Konkretionen T crystals cristales cristaux Kristalle S soft segregation n dulos segregaciones blandas nodules s gr gations tendres weiche Ablgerungen N nodules n dulos nodules Kn llchen Klumpen R residual fock fragments fragmentos de rocas residuales fragments de roches residuelles residuelle Steinfragmente CODE NODULE SIZE TAMA O DE N DULOS DIMENSION DES NODULES GR BE DER V very fine muy fino tr s fines sehr fein F fine pequefio petits fein M medium mediano moyens mittel C coarse grande grossiers grob CODE NODULES SHAPE FORMA DE LOS N DULOS FORME DES NODULES FORM DER S spherical esf rica sph rique irregular irregular irr gulier unregelm ig A angular angular angulaires polyedrisch F flat plana plain flach E elongated alargada allong e ausgestreckt ausgedehnt CODE NODULES HARDNESS DUREZA DE LOS N DULOS DURET DES NODULES HARTE DER H hard dura durs hart S soft blanda tendres weich B hard and soft dura y blanda durs
103. l Gypsic Yermosol Solonchaks Gleyic Solonchak Mollic Solonchak Orthic Solonchak Takyric Solonchak B 2 FAO 74 CLASSIFICATION PHASES LI Lithic PE Petric skeletic GI Gilgai YE Yermic PC Petrocalcic SO Sodic PF Petroferric CL Clayey DU Duripan ST Stony rudic SS Saline and sodic PH Phreatic PG Petrogypsic FR Fragipan IN Inundic FAO 90 CLASSIFICATION SOIL UNITS FL Fluvisols ANI Gelic Andosol PHJ Stagnic Phaeozem FLE Eutric Fluvisol PHL Luvic Phaeozem AL Alisols FLC Calcaric Fluvisol VR Vertisols ALH Haplic Alisol FLD Dystric Fluvisol GR Greyzems ALF Ferric Alisol FLM Mollic Fluvisol VRY Gypsic Vertisol GRH Haplic Greyzem ALU Humic Alisol FLU Umbric Fluvisol VRD Dystric Vertisol GRG Gleyic Greyzem ALP Plinthic Alisol FLT Thionic Fluvisol VRK Calcic Vertisol ALJ Stagnic Alisol FLS Salic Fluvisol VRH Haplic Vertisol LV Luvisols ALG Gleyic Alisol LVH Haplic Luvisol GL Gleysols CL Calcisols LVF Ferric Luvisol NT Nitisols GLE Eutric Gleysol CLH Haplic Calcisol LVX Chromic Luvisol NTH Haplic Nitisol GLK Calcic Gleysol CLL Luvic Calcisol LVK Calcic Luvisol NTR Rhodic Nitisol GLD Dystric Gleysol CLP Petric Calcisol LVJ Stagnic Luvisol GLA Andic Gleysol LVG Gleyic Luvisol NTU Humic Nitisol GLM Mollic Gleysol GY Gypsisols FR Ferralsols GLU Umbric Gleysol GYH Haplic Gypsisol PL Planosols FRH Haplic Ferralsol GLT Thionic Gleysol GYK Calcic Gypsisol PLE Eutric Planosol FRX Xanthic Ferralsol GLI Gelic Gley
104. l 98 colours chart in English Spanish French and German languages Update option in the installation program In order to update previous versions already installed this option creates the needed fields for the new coded variables In this case it is need to run the INSTALL EXE file Testing process After several test procedures followed on the previous versions in different places a number of little working problems have been solved User manuals The previous English and Spanish manuals have been passed to PDF format and including the new coded variables MicroLEIS Group www microleis com SDBm Plus Software version 2 01 June 2002 Modifications and Improvements 3 With relation to the previous version 2 00 February 2002 the following improvements and corrections have been made in the updated software 10 11 Date form The soil description and analysis dates have been change to ISO 8601 format yyyy mm dd Coordinates field This field has been enlarged until hundreths of second e g N 37 45 28 50 Suction unit A new suction unit referred to pF has been included into the hydraulic properties tables View profile In view soil profile it is now possible to see the FAO 90 classification Remarks The field remark is printed completely in the soil profile report Metadata The metadata report of each soil profile description can be saved Evaluating results The format
105. lDatalDefinition option and now it is possible to edit the different code sets A new button in the photographs input screen has been added in order to save the photographs easily The profile description included wrong information about the FAO 90 classification It has been fixed In the new version 1 02 the user is not able to input blank codes into the coding system edition which is very important for the software s correct working In the last version 1 00 we forgot the colour modifier importation Fixed When the user change the language the programme change also the language type In the last version 1 00 when the user deleted a profile description the associated horizons and samples remained into the database In the new version 1 02 they are deleted too The possibility of delete a record from the content screen has been added The graphical presentation has been improved representing only the not null values in the vertical variability graphs A fix size for the photograph in horizon description has been established All the graphic presentation types have been added including physical and hydraulic data A new statistical summary option has been included in the content option screen The coding system table for the field USDA 87 Great Group has been re indexed to the description in order to facilitate the location by the user The FAO 74 and 90 classification field in the input screen have been regrouped i
106. lave Cl Schl ssel FAO 74 classification Clasificaci n FAO 74 classification de la FAO 74 FAO 74 Klassifikation None Ninguno Aucun e keine You must select a field to the key You must fill in the first key value You must fill in the second key value Debe seleccionar un campo para la clave Debe rellenar el valor de la primera clave Debe rellenar el valor de la segunda Vous devez choisir un champ pour la cl Vous devez remplir la valeur de la premi re cl Vous devez remplir la valeur de la Sie m ssen ein Feld zu dem Schl ssel ausw hlen Sie m ssen den ersten Wert des Schl ssels eingeben Sie m ssen den zweiten Wert des D 12 Sorry the result is an empty set Comparison operators Selected profiles Maximum watertable depth Minimum watertable depth Field estimated clay Languages clave Lo siento el resultado es un conjunto vac o Operadores de comparaci n Perfiles seleccionados Profundidad m xima de la capa fre tica Profundidad m nima de la capa fre tica Arcilla estimada en el campo deuxi me cl D sol le r sultat est une s rie vide Op rateurs de comparaison Profils choisis profondeur maximale du bassin Profondeur minimale du bassin Argile estim e du champ Schl ssel eingeben Das Ergebnis ist ein leerer Datensatz Bedienervergleich ausgew hlte Profile maximaler Grundwasserspiegel minimaler Grundwasserspiegel gesch tzter Tongehalt Feld ENGLI
107. lchengr Be ggS grober Grobsand gS Grobsand mS Mittelsand fS Feinsand ffS feiner Feinsand Sand gU Grobschlufft fU Feinschluff Schluff Ton KAK Gesamt Aktiv L sliche Kationen L sliche Anionen Schwermetalle Ges ttigte Wasserleitf higkeit Aktueller Wassergehalt Stabilit tsindex Lagerungsdichte Resistance to Penetration Teilchendichte Gesamtporosit t Art der Messung Anzahl der Messungen Labor Feld Suction Wassergehalt Referenzvariable Wasserleitf higkeit Erg nzende Variable 1 Erg nzende Variable 2 Erg nzende Variable 3 Additional variable 4 Additional variable 5 Additional variable 6 Additional variable 7 Additional variable 8 Additional variable 9 Additional variable 10 Double click to see the coding system Right mouse button to see the menu Activate deacivate fields Select the visible fields Accept Cancel Invalid code Image format not valid Variable adicional 4 Variable adicional 5 Variable adicional 6 Variable adicional 7 Variable adicional 8 Variable adicional 9 Variable adicional 10 Haga doble click para ver el sistema de c digos Pulse el bot n derecho del rat n para ver el men Activar desactivar campos Seleccionar los campos visibles Aceptar Cancelar C digo no v lido Formato de imagen no v lido Variable additionnelle 4 Variable additionnelle 5 Variable additionnelle 6 Variable additionnelle 7 Variab
108. lciudolls HAA HAB HAC HAD HAE HAF HAG HAH HAI HBA HBB HBC HBD HBE HBF HCA HCB HCC HCD HCE HCF HCG HDA HDB HDC HDD HDE HDF HEA HEB Plinthaquults Fragiaquults Albaquults Kandiaquults Kanhaplaquults Paleaquults Umbraquults Epiaquults Endoaquults Sombrihumults Plinthohumults Kandihumults Kanhaplohumults Palehumults Haplohumults Plinthudults Fragiudults Kandiudults Kanhapludults Paleudults Rhodudults Hapludults Plinthustults Kandiustults Kanhaplustults Paleustults Rhodustults Haplustults Palexerults Haploxerults Vertisols FAA Salaquerts DEA Durustands ACE Umbrorthels IGC Paleudolls FAB Duraquerts DFB Haplustands ACF Argiorthels IGD Argiudolls FAC Natraquerts DGA Placudands ACG Psammorthels IGE Vermudolls FAD Calciaquerts DGB Durudands ACH Haplorthels IGF Hapludolls FAE Dystraquerts DGC Melanudands FAF Epiaquerts DGD Hydrudands Histosols Oxisols FAG Endoaquerts DGE Fulvudands BAA Cryofolists EAA Acraquox FBA Humicryerts DGF Hapludands BAB Torrifolist EAB Plinthaquox FBB Haplocryerts BAC Ustifolists EAC Eutraquox FCA Durixererts Aridisols BAD Udifolists EAD Haplaquox FCB Calcixererts GAA Salicryids BBA Cryofibrists EBA Acrotorrox FCC Haploxererts GAB Petrocryids BBB Sphagnofibrists EBB Eutrotorrox FDA Salitorrerts GAC Gypsicryids BBC Haplofibrists EBC Haplotorrox FDB Gypsitorrerts GAD Argicryids BCA Sulfosaprists ECA Sombriustox FDC Calcitorrerts GAE Calcicryids BCB Sulfisaprists ECB
109. le additionnelle 8 Variable additionnelle 9 Variable additionnelle 10 Double clic pour voir le syst me de codage Cliquer le bouton droit de la souris pour voir le menu Activer d sactiver champs S lectionner les champs visibles Accepter Annuler Code non valable Format d image non valable Erg nzende Variable 4 Erg nzende Variable 5 Erg nzende Variable 6 Erg nzende Variable 7 Erg nzende Variable 8 Erg nzende Variable 9 Erg nzende Variable 10 Doppelklick um das Kodiersystem zu sehen rechte Maustaste um das Men zu sehen aktivierte deaktivierte Felder Wahl der sichtbaren Felder Akzeptieren Abbrechen Ung ltiger Code Bildformat nicht g ltig Code forms ENGLISH SPANISH FRENCH GERMAN Coding system Sistema de c digos Syst me de codages Codierungssystem Data blocks Bloques de datos Blocs de donn es Datens tze Variables Variables Variables Variablen Generalization levels Analytical methods Code Description Rock type Permeability third level great group subgroup Niveles de generalizaci n M todos anal ticos C digo Descripci n Tipo de roca Permeabilidad tercer nivel gran grupo subgrupo Niveaux de g n ralisation M thodes analytiques Code Description Type de roche P rm abilit trosieme niveau grand groupe sous groupe verallgemeinerte Stufen analytische Methoden Codes Beschreibung Gesteinstyp Durchl ssigkeit dritte Stufe Hauptgruppe Unter
110. li ge Korkeiche GU guayule guayule guayule HO holm oak encina yeuse Stecheiche LP laricio pine pino laricio pin laricio L rche MP monterey pine pino insigne pin monterey MO muricated oak quejigo ch neau Pl pinsapo pinsapo pinsapo RE red eucaliptus eucalipto rojo eucalyptus rouge roter Eukalyptus SP silvestre pine pino silvestre pin sylvestre PP stone pine pino pi onero pin pignons comestibles Steinkiefer WP swamp pine pino carrasco pin des mar cages Sumpfkiefer TO Turkey oak rebollo ch ne de Turquie T rkische Eiche WE white eucaliptus eucalipto blanco eucalyptus blanc wei er Eukalyptus CB white poplar chopo blanco peuplier blanc WeiRpappel WO wild olive acebuche olivier sauvage Wilder Olivenbaum CODE GRASS COVER CUBIERTA VEGETAL COUVERTURE HERBACEE GRASBEDECKUNG 0 0 15 1 15 40 2 40 80 3 gt 80 1 5 Parent material CODE PARENT MATERIAL MATERIAL ORIGINAL MATERIAU PARENTAL AUSGANGSMATERIAL AU aeolian deposits dep sitos e licos d p ts oliens olische Ablagerungen AS aeolian sand arenas e licas sable olien olische Sande AV alluvium terreno aluvial sol alluvial Alluvium AH alluvium Holocene aluvial Holoceno sol alluvial Holoc ne Alluvium Holoz n AP alluvium Pleistocene aluvial Pleistoceno sol alluvial Pl istoc ne Alluvium Pleistoz n CO colluvium terreno coluvial sol colluvial Kolluvium FL fluvial deposits dep sitos fluviales d p ts fluviaux fluviale Ablagerungen G
111. lzsaure CODE GYPSUM CaSO YESO CaSO GYPSE CaSO GIPS CaSO A Acetone precipitation Precipitaci n de acetona Pr cipitacion d acetone F llung in Essig B Na3 ETDA solution Soluci n de Na3 ETDA Solution deNaz ETDA C NH4OAc NH OAc NH OAc NH OAc Block 4 SOLUBLE SALTS HEAVY METALS CODE SOLUBLE SALTS SALES SOLUBLES SELS SOLUBLES L SLICHE SALZE A 1 5 soil water suspension 1 5 suspensi n suelo agua 1 5 suspension sol eau 1 5 Boden Wasser Suspension B 1 10 soil water suspension 1 10 suspensi n suelo agua 1 10 suspension sol eau 1 10 Boden Wasser Suspension C Saturated paste Pasta saturada P te satur e ges ttigte Paste D CaCl CaCl CaCl CaCl E 1 1 soil water suspension 1 1 suspensi n suelo agua 1 1 suspension sol eau 1 1 Boden Wasser Suspension F 1 1 5 soil water suspension 1 1 5 suspensi n suelo agua 1 1 5 suspension sol eau 1 1 5 Boden Wasser Suspension G 1 2 soil water suspension 1 2 suspensi n suelo agua 1 2 suspension sol eau 1 2 Boden Wasser Suspension H 1 2 5 soil water suspension 1 2 5 suspensi n suelo agua 1 2 5 suspension sol eau 1 2 5 Boden Wasser Suspension CODE HEAVY METALS METALES PESADOS METAUX LOURDS SCHWERMETALLE A HNOs HCIO HF HNO3 HCIO HF HNO HCIO HF HNO HCIO HF B HNO3 HCIO HNO HCIO HNO HCIO HNO HCIO C HNO HCI aqua regia HNO HCI agua regia HNO HCI eau r gale HNO HCI D HNO3 HNO HNO HNO E Dry ashing HCI or HNO3 Ceniza en seco HCI o HNO3 Cendre s cher HC
112. mer Bl infilled burrows madrigueras rellenadas galeries remplies IA insect activity actividad de insectos activit d insectes Insektenaktivit t BO open burrows madrigueras abiertas galeries ouvertes PT pedotubules pedot bulos pedotubules TC termite channels termiteras galeries de termites Termitenkan le 2 8 Soil reaction CODE CARBONATES CARBONATOS CARBONATES KARBONATE 0 non calcareous no calc reo non calcarif re nicht kalkhaltig SL slightly calcareous ligeramente calc reo peu calcarif re leicht kalkhaltig MO moderately calcareous moderadamente calc reo moyennement calcarif re m ig kalkhaltig ST strongly calcareous fuertemente calc reo tr s calcarif re stark kalkhaltig EX extremely calcareous extremadamente calc reo extr mement calcarif re extrem kalkhaltig 2 9 Horizon boundary CODE BOUNDARY WIDTH ANCHURA DEL L MITE ENTRE NETTET DE LA TRANSITION BREITE DER GRENZE HORIZONTES VERS L HORIZON SOUS JACENT A abrupt brusco abrupte abrupt C clear neto distincte klar G gradual gradual graduelle D diffuse difuso diffuse verschwommen CODE BOUNDARY TOPOGRAPHY TOPOGRAF A DEL L MITE REGULARIT DE LA ENTRE HORIZONTES TRANSITION VERS L HORIZON SOUS JACENT S smooth y plano r guli re glatt W wavy y ondulado ondul e irregular e irregular irr guli re unregelm ig B broken e interrumpido interrompue unterbrochen Appendix C Coding system Translation tables of coded analytical metadata in English Sp
113. my skeletal 044 sandy skeletal 084 coarse loamy o sandy sk 120 clayey o loamy skeletal 014 medial o clayey 046 sandy skeletal o loamy 086 coarse loamy o clayey 122 clayey over fine silty 015 cindery o medial skeletal 050 loamy skeletal 088 coarse silty 124 clayey over loamy 016 medial o fragmental 051 loamy skeletal o fragment 092 coarse silty o sandy 126 fine 017 cindery over medial 052 loamy skeletal o sandy 094 coarse silty o clayey 134 very fine 018 medial o loamy 054 loamy skeletal o clayey 096 fine loamy 019 ashy over medial 055 loamy or clayey skeletal 097 fine loamy over cindery Reaction AL allic AC acid EU euic DY dysic NC noncalcareous NA nonacid USDA 98 CLASSIFICATION GREAT GROUPS Alfisols JAA JAB JAC JAD JAE JAF JAG JAH JAI JAJ JAK JBA JBB JBC JCA JCB JCC JCD JCE JCF JCG JCH JDA JDB JDC JDD JDE JDF JDG Cryaqualfs Plinthaqualfs Duraqualfs Natraqualfs Fragiaqualfs Kandiaqualfs Vermaqualfs Albaqualfs Glossaqualfs Epiaqualfs Endoaqualfs Palecryalfs Glossocryalfs Haplocryalfs Durustalfs Plinthustalfs Natrustalfs Kandiustalfs Kanhaplustalfs Paleustalfs Rhodustalfs Haplustalfs Durixeralfs Natrixeralfs Fragixeralfs Plinthoxeralfs Rhodoxeralfs Palexeralfs Haploxeralfs GDB GDC GDD GDE GEA GEB GEC GED GEE GEF GFA GFB GGA GGB GGC GGD Entisols LAA LAB LAC LAD LAE LAF LAG LBA LBB LBC LBD LCA Natrigypsids Argigypsids Calcigypsids Haplogypsids P
114. n Block 3 Standard analyses Block 4 Soluble salts Heavy metals Block 5 Physical analyses Block 6 Water retention Hydraulic conductivity Block 7 Additional analytical variables Block 8 Photographs Block 9 Metadata Appendix B Coding system Translation tables of coded soil variables in English Spanish French and German Soil classifications FAO 74 and 90 WRB 98 USDA 87 and 98 Climate classification Landform and topography Land use and vegetation Parent material Surface characteristics Soil water relationships Horizon designation and dimensions Soil colour Primary constituents Organisation and constituents Voids Concentrations Biological activity Soil reaction Horizon boundary Appendix C Coding system Translation tables of coded analytical metadata in English Spanish French and German Standard analyses Soluble salts Heavy metals Physical analyses Water retention Hydraulic conductivity Appendix D Language change Translation tables of user interface labels in English Spanish French and German Main menu Input data Coding system Database Import Export Codes view Content Search Languages Derived variables Evaluation Appendix E Technical information and data dictionary Data files Index files Conversion files Fields of data files Source files Abstract SDBm Plus FAO CSIC Multilingual Soil Profile Database is a derivative from the SDBm database FAO ISRIC CSIC World Soil Resources Reports 81
115. n Mittelsand S sand arenosa sable Sand SC sandy clay arcillo arenosa argile sableux sandiger Ton SCL sandy clayloam franco arcillo arenosa limon argilo sableux sandig toniger Lehm SL sandy loam franco arenosa limon sableux sandiger Lehm SI silt limosa limon Schluff SIL siltloam franco limosa limon fin schluffiger Lehm SIC silty clay arcillo limosa argile limoneuse schluffiger Ton SICL silty clayloam franco arcillo limosa limon argileux fin schluffig toniger Lehm US unsorted sand arena sin clasificar sable sans classer unsortierter Sand VFS very fine sand arenoso muy fina sable tr s fin sehr feiner Sand VFSL very fine sandy loam franco arenoso muy fina limon sableux tr s fin sehr feinsandiger Lehm CODE ROCK FRAGMENTS CANTIDAD DE FRAGMENTOS ABONDANCE DES FRAGMENTS VORKOMMEN VON ABUNDANCE DE ROCAS ROCHEUX GESTEINSRESTEN 0 none ningunas n ant keine V very few muy pocas tr s peu nombreux sehr wenige F few pocas peu nombreux wenige C common frecuentes nombreux einige M many muchas tr s nombreux viele A abundant abundantes abondants reichlich D dominant dominantes dominantes dominant CODE ROCK FRAGMENTS SIZE TAMA O DE FRAGMENTOS DE DIMENSION DES FRAGMENTS GR BE DER GESTEINSRESTE ROCAS ROCHEUX Fl fine peque as fins klein FM fine and medium peque as y medianas fins et moyens klein und mittel ME medium medianas moyens mittel MC medium and coarse medio y gruesas moyens et grossiers mittel und grob
116. n levels 326 AQ1 Central General information Horizon description Land form A02 Marquesado Land element AD3 Meridional Micro topography AD4 Monta a Position AD5 Vinalopo Topography ABO1 Almansa Slope form ABOZ Centro Sealing crusts ABOSHellin Stones abundance Mancha Stones size ABOE Manchuela Rocks abundance ABOESierra Alcaraz EA Code Description Ce ntral Figure 3 15 Coding system screen 3 13 Metadata In the SDBm Plus system the coding system has also been extended to the metadata variables Appendix C Block 9 Analytical metadata 32 variables following the same criteria used for data variables Main option Content All the database contents can be visualized in different formats text photographic tabular and graphic using this SDBm Plus main option Soil profiles list The current relation of soil profiles stored in the database is displayed on screen and may be printed Figure 3 16 Chapter 4 The total number of stored profiles appears on the top right corner SDBm Plus FAO CSIC Multilingual Soil Profile Database Database content Cambisols T rmino municipal de And jar Km 7 de la carretera deM A Luvisols T rmino municipal de And jar Km 5 de la carretera de M A i Cambisols Finca Gayoso Castro Cambisols Finca El Aljarafe La Hampa Km 13 5 de la carre MA FH Calcic Vertisol Finca El Pinganillo Utrera MAFH Vertisols Las Marismas de Leb
117. n order to save space and improve the use of this fields The USDA 98 coding system tables have been developed Appendix B although they have not been still included into the software Sevilla March 2001 SDBm Plus Software version 2 00 February 2002 Modifications and Improvements 2 With relation to the SDBm Plus database previous versions 1 00 1 02 and 1 03 December 2000 March 2001 and April 2001 respectively the following improvements and corrections have been made in the updated software 17 18 19 20 21 22 23 24 Multiple document interface Software re programming to change from the simple document procedure of the previous versions to a new working multiple document procedure Input edit data Modification of the input edit data procedure in order to maintain closed the database tables during the entrance of new data on the input screens Working on LAN Through the Preference option it is possible to select access path of the database in order to work on local area network LAN sharing the software and operating on the same database tables In this case the users control file PDOXUSRS NET located by default on C directory must be copied within the shared database directory New_order of the Main Screen options Files Codes Content Search Evaluation Preferences and Languages New coded variables USDA 98 and WRB 98 soil classifications in English language and Munsel
118. nation and dimensions Horizon symbol Depth cm upper lower Soil colour Matrix colour 2 entries hue value chroma modifier Mottles 2 entries abundance size contrast boundary colour Primary constituents Texture of the fine earth 2 entries Rock fragments 2 entries abundance size shape weathering nature Organisation and constituents Structure 2 entries grade size type relation Consistence dry moist stickiness plasticity code code code code code code code code code code code code code code code code text string HHH HHH string code code code code code Voids porosity Voids 2 entries abundance size type porosity Concentrations Cutanic features 2 entries quantity contrast nature location Cementation Compaction continuity structure grade nature Nodules 2 entries abundance kind size shape hardness nature colour Biological activity Roots 2 entries abundance size Biological features 2 entries abundance kind Soil reaction Carbonates Field pH Horizon boundary Boundary width topography Block 3 STANDART ANALYSES Sample code Date Depth cm upper lower pH H20 other Electrical conductivity EC mS cm Phosphorus P mg kg Organic carbon OC g 100g Nitrogen g 100g Cation exchange capacity CEC meq 100g Exchangable cations meg 100g Calcium Ca Magnesium Mg Potassium K Sodium Na H
119. nium Potassium fix Sable tr s grossier Sable grossier Sable moyen Sable fin Sable tr s fin Limon grossier Limon fin Sable Limon Argile CEC de l argile Calcium Magn sium Potassium Sodium Bore Mineralogie Reaktion Bodentemperatur Bodenfeuchte Farbmodifikator Elektrische Leitf higkeit Phosphor Stickstoff Carbonat Gesamtes Calciumcarbonat Effektives Calciumcarbonat Calciumsulfat Kationenaustauschkapazit t Austauschbares Calcium Austauschbares Magnesium Austauschbares Kalium Austauschbares Natrium Wasserstoff Aluminium Gebundenes Kalium Sehr grober Sand Grobsand Mittelsand Feinsand feiner Feinsand Grobschluff Feinschluff Sand Schluff Ton KAK von Ton Calcium Magnesium Kalium Natrium Bor Carbonates Bicarbonates Chlorine Sulphates Nitrates Na Ca Mg relationship Arsenic Cadmium Cobalt Chrome Copper Mercury Manganese Molybdenum Nickel Lead Antimony Selenium Zinc Hydraulic conductivity Water content Structural stability index Bulk density Total porosity Water content suction relationship Hydraulic conductivities Data base Carbonatos Bicarbonatos Cloro Sulfatos Nitratos Relaci n Na Ca Mg Ars nico Cadmio Cobalto Cromo Cobre Mercurio Manganeso Molibdeno N quel Plomo Antimonio Selenio Zinc Conductividad hidr ulica Contenido de agua Indice de estabilidad estructural Densidad aparente Porosidad tot
120. nput the value of the variable into the box that will appear in the screen strike the Enter key and the search expression will be shown in the box for the expression Simultaneously the number of selected profiles will be changed The user will be able to repeat this operation in order to refine the search Furthermore it is possible to return to the last state of the search clicking the Undo button Once the fast or detailed search operation is accepted the search result is displayed on screen The soil profiles that meet the selection criteria are listed alphabetically or numerically by codes From this profile list it is possible to continue through the options View Print Export or Evaluation checking the appropriate button 3 17 SDBm Plus FAO CSIC Multilingual Soil Profile Database Detailed search General information Profile code Horizon description Administrative unit Standard analysis Salts Heavy metals Physical analysis Water retention Hydraulic cont Additional variables Longitude Elevation Figure 3 18 Detailed search screen Main option Customize This SDBm Plus main option tailors the database to the user needs Additional variables In SDBm Plus up to ten blank additional variables may be defined These are shown in the Block 7 Additional analytical variables This allows for the description of features which are not covered by the basic blocks such as soil cohesion internal fr
121. ock 10 Derived variables which will be used in the input file generator along with the basic variables stored It uses the following variable groups as independent variables O Block 3 Standard analyses O Block 5 Physical data Block 7 Additional variables The dependent variable symbol is chosen by the user and the symbols used for independent variable correspond to the field names in the database tables Appendix E Ie Plus FAD CSIC Multilingual Soil Profile Database Derived variables Data blocks Standard analysis Dependent variable Physical analysis Name FLAS Description Plasticity index De la Rosa 1979 Definition pedotransfer function PLAS 5 47 CL 0 20 CECS 0 03 CL CECS 0 03 CL CECS 0C 1 724 ph 2 Electrical conductivity Phosphorus Nitrogen El E ES El 3 An exp Lie SA Effective calcic carbonat Calcic sulphate Help i El Independent variable Figure 3 22 Derived variables screen LES GIS files generator Input data files This function Figure 3 23 generates an input data file following a series of steps Ll Range of profiles selection of the profiles to be included in this analysis O Soil characteristics selection of the morphological and analytical variables to be analyzed The following sets of soil variables can be used Block 1 General description Block 2 Soil horizon description Block 3 Standard analyses Block 4
122. of geographic information 3 21 systems GISs According to the Framework for Land Evaluation FAO 1976 a LES involves the interpretation of data concerning the physical environment and past and present land use in terms of its resource potential GISs are essentially databases which store and analyse a large amount of information in a spatial format Both types of land systems interpretation and spatialisation processes are key tools to develop land use planning LUP approaches This main option offers the possibility to create LES GIS input data files for a control section or layer within a profile or a group of profiles Derived variables In order to enlarge the application possibilities of the Main option Evaluation a set of non stored soil variables Block 10 Derived variables can be calculated by using pedotransfer functions Pedotransfer functions relate costly and time consuming soil determinations e g mechanical or hydraulic properties to more easily measured soil data such as soil texture organic matter and or other routinely determined by soil surveys Hence polynomial regression approaches can be formulated specially for the estimation of soil mechanical and water properties from other stored soil variables in the database e g De la Rosa 1979 Simota and Mayr 1996 This sub option Figure 3 22 facilitates the formulation of regression pedotransfer functions in order to calculate dependent variables Bl
123. of the files resulting from the evaluation option is now dBASE IV Help windows HTML format files have been created in English and Spanish languages for all the help windows New field A new field has been added in the hydraulic conductivity table in order to store the corresponding suction or water content values Testing process A number of little working problems have been solved e g in the field rocks abundance the coding system did not work properly some label words were in inappropriate language etc Installation program The update program has been modified to change the hydraulic conductivity table structure to adapt it to the new field Sevilla June 2002 This software can be freely downloaded from the MicroLEIS Website www microleis com Software section
124. on and data dictionary DATA FILES FILE NAME CONTENTS SBBSITE DB General information data SDBHORIZ DB Horizon description data SDBANA1 DB Standard analytical data SDBANA2 DB Soluble salts heavy metals data PHYSICS DB Soil physical data WAT_RET DB Water retention data KUNSAT DB Hydraulic conductivity data ADDVARS DB Additional analytical data INDEX FILES FILE NAME CONTENTS SDBSITE PX General information index SDBHORIZ PX Horizont description index SDBHORIZ XGO SDBHORIZ YGO Horizont description secundary indexes SDBANA1 PX Standar analitical index SDBANA2 PX Soluble salts heavy metals index PHYSICS PX Soil physical index WAT_RET PX Water retention index KUNSAT PX Hydraulic conductivity index ADDVARS PX Additional analytical index CONVERSION FILES FILE NAME CONTENTS SITECODES DB SITECODES PX SITECODES XGO SITECODES YGO HORIZCODES DB HORIZCODES PX HORIZCODES XGO HORIZCODES YGO Profile description codes Horizont description codes ANAMETCODES DB ANAMETCODES PX Analytical data description codes PHYSMETCODES DB PHYSMETCODES PX Physical data description codes COLOR DB COLOR PX Color code and equivalence files FIELDS OF DATA FILES SBBSITE DB file Data FIELD TYPE SIZE DESCRIPTION AUT1 CHAR 3 Author 1 AUT2 CHAR 3 Author 2 AUT3 CHAR 3 Author 3 CRO1 CHAR 2 1 crop CRO2 CHAR 2 2 crop DATE DATE Date DEPT CHAR 2 Effective soil depth DRAE CHAR 2 External drainage DRAI CHAR 2 Drainag
125. ons world wide Examples of SDBm practical applications include ongoing environmental renewal projects in Eastern Europe supported by the World Bank WB The system was used to record the condition of contaminated or depleted soils before and after land restoration and clean up projects and to guide assessment of project investment and follow up actions The system is also being used by the Consultive Group on International Agricultural Research CGIAR to facilitate technical research and development planning decisions on an international scale For example SDBm has helped to identify areas where a new crop variety should thrive As the original SDB version developed by FAO and ISRIC World Soil Resources Reports 64 1989 and the previous SDBm developed by FAO ISRIC and CSIC World Soil Resources Reports 81 1995 SDBm Plus remains being an open system under continuous development INSTALLATION System requirements The minimum software and hardware configuration required for SDBm Plus installation is the following IBM compatible computer 486 O 16 MB RAM memory O 10 MB free disk space Colour monitor Graphic adapter supporting 800 x 640 pixels screen resolution Microsoft mouse or other compatible pointing device Eb L E MS WINDOWS 95 It has to be noted that a faster processor based computer and or more board memory are recommended if frequent use of the programme is to be expected SDBm Plus version 1 00 is dis
126. ores type 2 pores type 1 rocks nature 2 rocks nature rocks quantity 2 rocks quantity 1 rocks size RCS2 RCW1 RCW2 RCH1 RCH2 RTQ1 RTQ2 RTS1 RTS2 ST12 STG1 STG2 STS1 STS2 STT1 STT2 TEX1 TEX2 UPBO VAL1 VAL2 CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR NUMBER CHAR CHAR GO NN N N N N N N HHH 2 rocks size 1 rocks weathering 2 rocks weathering 1 rocks shape 2 rocks shape 1 roots quantity 2 roots quantity 1 roots size 2 roots size Relation between 1 and 2 structures 1 structure grade 2 structure grade 1 structure size 2 structure size 1 structure type 2 structure type 1 texture 2 texture Upper boundary depth 1 colour value 2 colour value SDBANA1 DB file Data and Metadata FIELD TYPE SIZE DESCRIPTION AL NUMBER 52 Exchangeable aluminium CA NUMBER 5 2 Exchangeable calcium CACA NUMBER 52 Effective CaCO3 CACO NUMBER 5 2 Total CaCO3 CASO NUMBER 52 Total CaSO4 CECC NUMBER 5 2 CEC clay CECS NUMBER 5 2 CEC soil CL NUMBER 6 2 Clay CS NUMBER 5 2 Coarse sand CSI NUMBER 52 Coarse silt EC NUMBER 5 2 Electro conductivity FS NUMBER 52 Fine sand FSI NUMBER 52 Fine silt H NUMBER 5 2 Exchangeable hydrogen K NUMBER 5 2 Exchangeable potassium KF NUMBER 52 Fixed potassium LOBO NUMBER 3 Lower boundary depth METAL CHAR 2 Method used to measure the exchangea
127. orme Microtopographie Inondation fr quence Dur e Usage du sol type Cultures V g tation Esp ces Couverture herbac e Materiel d origine sur d riv de Roche m re Pierres Breite L nge H he Arb blatt Gitter FAO 90 Bodeneinheiten FAO 90 dritte Stufe FAO 74 Bodeneinheiten Phase Gruppe Einheit Spezifizierung Bodenklima Lokale Bodenklassifikation Serien Topographie Geomorphologie Landschaftselement Lage Hang Klasse Form Mikrotopographie Uberflutung Frequenz Dauer Landnutzung Typ Kultur Vegetation Arten Grasbedeckung Ausgangsmaterial ber hertransportiert aus Ausgangsgestein Steine abundance size Rocks distance height Erosion deposition intensity Sealing crusts Drainage internal external Water table maximum minimum observed Moisture conditions Effective soil depth Human influence Remarks Photographs Profile site Soil profile Other Load image Delete Save image Horizon number Designation Depth Upper Lower Colours Mottles abundance abundancia tama o Rocas distancia altura Erosi n deposici n intensidad Cementaci n costras Drenaje interno externo Capa fre tica m ximo m nimo observado Condiciones de humedad Profundidad til Influencia humana Observaciones Fotograf as Emplazamiento del perfil Perfil de suelo Otra Cargar imagen Eliminar Guardar imagen N mero de horizonte Denominaci n Profundid
128. otographs O More detailed information on metadata for analytical methods SDBm Plus includes a conversion procedure to turn the SDB type inventory into a SDBm Plus type inventory which is detailed in the Import Export sub option of the Main option File However the MicroLEIS group CSIC IRNAS can make this conversion upon reception of all SDB dbf files compressed zipped into one file The MicroLEIS group would in this case check the conversion and manually perform some splits that can not be done automatically Chapter 2 Structure and configuration VARIABLE TYPES Stored variables The SDBm Plus database contains information on geo referenced individual soil profiles A soil profile is a vertical exposure of a superficial portion of the earth s crust that includes all the layers that have been pedogenically altered during the period of soil formation and also deeper layers that influenced pedogenesis A soil profile is considered as the vertical exposure of the horizons of a soil individual and may be observed in a freshly dug pit along a road bank or in many other places Soil Survey Staff 1950 As shown in Figure 2 1 and detailed in Appendix A the field and laboratory information on a soil profile is grouped into the following data blocks O Block 1 General information Information on the characteristics of the profile site as well as the information related to its identification and classification
129. rija MAFH Fluvisol Guillena Finca Torre de la Reina MAFH Calcic Luvisol La Rinconada Finca Casa de las Vacas MAFH Cambisols Finca La Hampa MAFH Fluvisol Finca La Suerte Tocina Fluvisol Finca El Aljarafe La Hampa Km 13 5 de la carrel M PAFH Salic Fluvisol Puebla del R o Finca La Mejorada MAFH Salic Fluvisol Puebla del R o Finca La Mejorada MAFH Figure 3 16 Content screen 3 14 View Print Selecting from the previous list of stored soil profiles this sub option is used to view individual soil profiles on screen or to obtain printouts standard morphological description analytical data tables and graphics Chapter 4 As well as a metadata report including every method used for the lab and field measurements Graphics On the analytical data report the button is shown under next to the data column to be presented clicking it the graph is shown in a separate window This function calculates and displays the following graphic presentations Ol Vertical distribution of the analytical variables Ll Suction vs water content and hydraulic conductivity In the vertical distribution the x axis shows the values of the variable examined and the y axis the depth of the samples In the suction vs hydraulic properties up to 20 entries can be displayed This application as screen display or printout helps in the characterization of a soil pro
130. rintout LES GIS INPUT FILES The input data files i main file and ii descriptive files of the selected soil profiles and soil variables Figures 4 8a y 4 8b are generated using the Main option Evaluation Chapter 3 This output result facilitates the linkage of soil data to computerised information systems Figure 4 9 shows an example of a GIS map combining polygon information with point information related to the STGG variable from the SDBm Plus database SDBMPLUS EVALUATION E1 DBF PRNO CAO101 CAO102 CAO201 CAO401 CA0402 CO0101 COC201 COO2C2 COO501 CO0502 COO601 HO101 HO201 HO301 HO401 HO501 HO601 HO602 SEO101 SEO201 SEO301 SEO302 SEO401 SEO501 SEO701 NUTA CAOL CAOL 2 CAO4 CAO4 COOL COC2 2 5 5 COO6 HOL HO2 HOB HO4 HO5 SEOL SEO2 SEO3 SEO3 SEO4 SEO5 SEO7 STGG STSG VXL ER VXR AXR AXB EOX VXR IC IC UXB EVX CH RE AA CA RE 3292285522 3385 LAT LON N364832 VWO60030 N364456 NW061130 N361214 052250 N363049 060908 N363014 054015 N373110 043950 N374903 044702 N375825 V044730 N382105 043928 N381145 044856 N372304 VVO40820 N371214 WO72335 N373330 W065638 N372738 N062208 N370104 063028 N372046 070010 N375025 WO70335 N375304 VV062835 N371655 045445 N372258 W061120 N371410 W053935 N372238 053930 N375520 W053815 N373204 WO55510
131. roaquic Anionic Anionic Aquic Anthraquic Anthropic Aqualfic Aquandic Aquentic BEO2 BFOO BG00 BG01 BG02 BG03 BHOO BIOO BJOO BJ01 BJ02 BK00 BKO01 BK02 BLOO BL01 BL02 BM00 BN00 BN01 BO00 BO01 BO02 BP00 BP01 BP02 BP03 BP04 BQ00 BQ01 BQ02 BQ03 BR00 Aridic Lithic Calciargidic Calcic Calcic Lithic Calcic Pachic Calcic Udic Calcidic Cambidic Chromic Chromic Udic Chromic Vertic Cumulic Cumulic Ultic Cumulic Vertic Duric Duric Histic Duric Xeric Duridic Durinodic Durinodic Xeric Dystric Dystric Fluventic Dystric Vitric Entic Entic Grossarenic Entic Lithic Entic Udic Entic Ultic Eutric Eutric Lithic Eutric Pachic Eutric Thaptic Fibric CL00 CM00 CM01 CM02 CM03 CM04 CM05 CM06 CM07 CN00 CO00 CO01 CO02 CP00 CQ00 CR00 CS00 CT00 CU00 CU01 CV00 CV01 CV02 CV03 CW00 CX00 CX01 CX02 CX03 CX04 CX05 CX06 CX07 Humaqueptic Humic Humic Inceptic Humic Lithic Humic Pachic Humic Psammentic Humic Rhodic Humic Xanthic Humic Xeric Hydraquentic Hydric Hydric Pachic Hydric Thaptic Inceptic Kandic Kandiudalfic Kandiustalfic Kanhaplic Lamellic Lamellic Ustic Leptic Leptic Torrertic Leptic Udic Leptic Vertic Limnic Lithic Lithic Mollic Lithic Petrocalcic Lithic Ruptic Entic Lithic Ruptic Inceptic Lithic Ultic Lithic Ustic Lithic Xeric DW00 DX00 DY00 DZ00 EA00 EB00 EC00 ED00 EE00 EF00 EF01 EF02 EG00 EH00 E100 EJOO EL OU EMOO
132. s of profiles may be imported into the SDBm Plus database To import data from an older SDBm version select the directory where the SDBm data file are sited then choose the range of profiles to be imported writing the first and last profile codes and finally indicate the language used to codified the original profiles 3 10 To import data from SDBm Plus select the directory where the export files are located clicking the Directory button if the selected directory contains any export file the screen will show the list of profiles contained into the files and will be shown the data blocks available in the profiles Then 1t will be able to select the range of profiles from the list and the data blocks to be imported All imported information on site profile soil analytical or physical properties is appended to the database Existing data are overwritten Export data For this sub option Figure 3 14 a series of stored soil profiles can be transferred from the SDBm Plus system The set of soil profiles to be exported the groups of soil variables and the export path must be specified on the screen for each data export operation SDBm Plus FAO CSIC Multilingual Soil Profile Database Import from SDBm 5 GA Gimicrole PACO SDBmPlus Finca microlei PACO gt SDBmPlus g Wirnas voll Figure 3 13 Import data screen E SDBm Plus FAO CSIC Multilingual Soil Profile Database Export Profiles list
133. sed to measure the copper Method used to measure the electro conductivity Method used to measure the soluble HCO3 Method used to measure the mercury Method used to measure the soluble potassium Method used to measure the soluble magnesium Method used to measure the manganese Method used to measure the molybdenum Method used to measure the soluble sodium Method used to measure the nickel Method used to measure the soluble NO3 Method used to measure the lead Method used to measure the pH Method used to measure the sodium calcium magnesium relation Method used to measure the antimony Method used to measure the selenium Method used to measure the soluble SO4 Method used to measure the zinc Soluble magnesium Manganese Molybdenum Soluble sodium Nickel Soluble NO3 Lead pH Profile code Sample code Sodium calcium magnesium relation Antimony Selenium Soluble SO4 Upper boundary depth Zinc PHYSICS DB file Data and Metadata FIELD TYPE SIZE DESCRIPTION BULK NUMBER 5 2 Bulk density DATE DATE Sampling date KSAT NUMBER 6 2 Hydraulic conductivity in saturation LOBO NUMBER 3 Lower boundary depth METBULK CHAR 2 Method used to measure the bulk density METKSAT CHAR 2 Method used to measure the hydraulic conductivity in saturation METPART CHAR 2 Method used to measure the particles density METRESIST CHAR 2 Method used to measure the resistance to penetration METSATWAT CHAR 2 Method used to measure
134. sh French and German Content Current list of soil profile datasets already stored in the database Each selected dataset may be viewed or printed The printouts are identical to the conventional soil profile description Analytical results can be graphed on the screen as XY presentations Search Fast and detailed selection facilities connected to the view print and graphic and evaluation options Customise De activation data fields option allows for the specific restructuring of input data screens thus offering the possibility of adjusting the database to specific national or local conditions Language The database can be used in English and other languages as well as an automatic translation system The set of labels and the coding system are already available in English Spanish French and German Evaluation Linkage between the database and land evaluation systems geographic information systems LES GIS through the use of a soil layer generator which elaborates model input files with average or dominant values of selected variables by soil unit depth range and group of profiles This option can make use not only of stored variables but also of derived variables calculated using pedotransfer functions Help Help screens and on screen instructions assist the user in running the system SDBm Plus has been basically developed with funding of the Spanish Ministry of Environment MIMAM through the SEIS net project Sistema Esp
135. sion 1 03 April 2001 info Figure 3 1 SDBm Plus main menu screen Common buttons These buttons appear on several screens and fall within two categories Navigation buttons These buttons are on the top of the screen and have well known graphic symbols The functions of these buttons are the usual ones in databases New EE Delete LE Save 4 Cancel First Prior MSN Next BEN Last BE Function buttons These buttons are on the bottom of the screen and perform specific functions View Print Cancel Help Pop up coding windows These are combo boxes which appear as rectangular boxes containing a list of generalisation levels corresponding to the input coded variable marked by the selection cursor There is a scroll bar on the right side which scrolls the list as usual in WINDOWS These lists are arranged alphabetically by definition for the soil variables Appendix B and by code for the analytical metadata Appendix C Help bars Help windows provide additional on screen information on the possible alternatives and data screen facilities to easily input and edit data DETAILED DESCRIPTION Main menu Upon entering the SDBm Plus database a start up window with logos and a main menu appears on the top of the screen Figure 3 1 The following main options are then visible 1 File data manager which enables manipulation of data and files in the database O
136. soil data to computerised information systems The following soil data sets can be stored in the SDBm Plus database General information Characteristics of the site as well as the information related to the identification of the soil profile O Horizon description Morphological data described by horizon which is stored along with the general information in a coded format following the Guidelines for Soil Profile Descriptions FAO ISRIC 1990 Standard analyses Conventional soil profile analytical results Soluble salts Heavy metals Soluble salts and most trace elements present in the soil and considered as major soil contaminants O Physical analyses General soil physical analytical results O Water retention Hydraulic conductivity Up to 25 determinations per soil sample of water content and hydraulic conductivity by different suctions O Photographs Site profile and other soil photographs Metadata Analytical methods and procedures used The SDBm Plus database includes the following set of conventional and special main functions O File Input and edit screens which are provided with pop up menus for entering data using selection bar Import and export options are also included to access other SDB databases Codes Through a flexible coding system the database translates morphological soil variables from English into the other alternative languages The set of coded variables is also available in Spani
137. sol GYL Luvic Gypsisol PLD Dystric Planosol FRR Rhodic Ferralsol GYP Petric Gypsisol PLM Mollic Planosol FRU Humic Ferralsol B 3 RG RGE RGC RGY RGD RGU RGI LP LPE LPD LPK LPM LPU LPQ LPI LPC AR ARH ARB ARL ARO ARA ARK ARC ARG AN ANH ANM ANU ANZ Regosols Eutric Regosol Calcaric Regosol Gypsic Regosol Dystric Regosol Umbric Regosol Gelic Regosol Leptosols Eutric Leptosol Dystric leptosol Rendzic Leptosol Mollic Leptosol Umbric leptosol Lithic Leptosol Gelic leptosol Calcaric Leptosol Arenosols Haplic Arenosol Cambic Arenosol Luvic Arenosol Ferralic Arenosol Albic Arenosol Calcic Arenosol Calcaric Arenosol Gleyic Arenosol Andosols Haplic Andosol Mollic Andosol Umbric Andosol Vitric Andosol SN SNH SNM SNK SNY SNJ SC SCH SCM SCK SCY SCN SCG SCI KS KSH KSL KSK KSY CH CHH CHK CHL CHW CHG PH PHG PHH Solonetz Haplic solonetz Mollic Solonetz Calcic Solonetz Gypsic Solonetz Stagnic Solonetz Solonchaks Haplic Solonchak Mollic Solonchak Calcic Solonchak Gypsic Solonchak Sodic Solonchak Gleyic Solonchak Gelic Solonchak Kastanozems Haplic Kastanozem Luvic Kastanozem Calcic Kastanozem Gypsic Kastanozem Chernozems Haplic Chernozem Calcic Chernozem Luvic Chernozem Glossic Chernozem Gleyic Chernozem Phaeozems Gleyic Pheaozem Haplic Phaeozem PLU PLI PD PDE PDD PDJ PDG PDI PZ PZH PZB PZF PZC PZG PZI LX
138. spagnol Francais Import r ussi Chemische Bestimmung Bodenvariablen Auflistung Select source directory Erste Aufzeichnung Letzte Aufzeichnung Sprache in der sie codiert wurden Englisch Spanisch Franz sisch Import erfolgreich D 10 Export ENGLISH SPANISH FRENCH GERMAN Replace Reemplazar Remplacer Ersetzen Add to file A adir al archivo Ajouter au fichier In die Datei einf gen Export successful You can see the results into Codes view Exportaci n con xito Puede ver los resultados en Export r ussi Vous pouvez voir les r sultats dedans Export erfolgreich Sie k nnen die Ergebnisse sehen in ENGLISH SPANISH FRENCH GERMAN Select block Seleccionar bloque Choisir bloc Ausgew hlter Block Content ENGLISH SPANISH FRENCH GERMAN Database content Number of profiles Morphological data Analytical data Physical data Hydraulical data Print View FAO 90 classification WRB 98 classification USDA 87 classification Profile Contenido de la base de datos N mero de perfiles Datos morfol gicos Datos anal ticos Datos f sicos Datos hidr ulicos Imprimir Visualizar Clasificaci n FAO 90 Clasificaci n WRB 98 Clasificaci n USDA 87 Perfil Contenu de base de donn es Nombres de profils Donn es morphologiques Donn es analytiques Donn s physiques Donn es hydrauliques Imprimer Voir classification de la FAO 90 classification de WRB 98 classification de l USDA 87 Profil
139. stalfic Quartzipsammentic Rendollic Rhodic Ruptic Alfic Ruptic Lithic Ruptic Lithic Entic Ruptic Lithic Xerochreptic Ruptic Ultic Ruptic Vertic Salorthidic Sapric Sapric Terric Sidfric AN20 AN22 AN24 AN25 AN30 AQ AQ02 AQ04 AQ06 AQ08 AQ14 AQ16 AQ18 AQ24 AQ26 AQ31 AQ34 AQ36 AR ARO2 ARO4 ARO6 ARO7 8 9 10 11 12 AR13 AR14 AR15 AR16 AR17 Andic Udic Andic Ustic Andaqueptic Anionic Anthropic Aqualfic Aquentic Aqueptic Aquic Aquic Arenic Aquic Duric Aquic Durorthidic Aquic Dystric Aquic Haplic Aquic Lithic Aquic Psammentic Aquollic Aquultic Arenic Arenic Aridic Arenic Plinthaquic Arenic Plinthic Arenic Kandic Arenic Rhodic Arenic Kandic Rhodic Arenic Ultic Arenic Kanhaplic Arenic Kanhaplic Rhodic Arenic Petrocalcic Arenic Umbric Arenic Calciorthidic Arenic Ustalfic Arenic Ustochreptic Duroxerollic Duroxerollic Lithic Durochreptic Durorthidic Durorthidic Xeric Dystric Dystric Enthic Dystric Fluventic Dystric Lithic Dystropeptic Entic Enthic Lithic Eutropeptic Enthic Ultic Epiaquic Epiaquic Orthoxic Eutric Eutrochreptic Eutropeptic Ferrudalfic Fibric Fibric Terric Fluvaquentic Fluventic Fluventic Umbric Fragiaquic Fragic Glossaquic Glossic Glossic Udic Glossic Ustollic Glossoboralfic Glossoboric Kandiustalfic Kanhaplic Leptic Limnic Lithic Lithic Petrocalcic Lithic Mollic Lithic Pergelic Lithic Ruptic Alfi
140. terne au champ Interne Entw sserung im Feld Appendix D Language change Translation tables of user interface labels in English Spanish French and German Main menu ENGLISH SPANISH FRENCH GERMAN Multilingual Soil Profile Database Base de datos Multiling e de Perfiles Base de donn es Multilingue des Mehrsprachige Bodenprofil de Suelo profiles du sol Datenbank File Archivo Fichier Datei Content Contenido Contenu Inhalt Search B squeda Recherche Suche Evaluation Evaluaci n Evaluation Berechnung Customize Personalizar Personnaliser Customize Languages Idiomas Langues Sprache Help Ayuda Aide Hilfe Input data Introducir datos Entr e de donn es Dateneingabe Import Importar Import Einf gen Export Exportar Export Exportieren Exit Salir Sortir Beenden From SDBm Plus Desde SDBm Plus Depuis SDBm Plus Von SDBm Plus From SDBm Desde SDBm Depuis SDBm Von SDBm Fast search Detailed search Change language Edit New language Delete language B squeda r pida B squeda detallada Cambiar idioma Editar Nuevo idioma Eliminar idioma Recherche rapide Recherche d taill e Changer langue Editer Nouvelle langue Effacer langue Schnelle Suche Detaillierte Suche Sprache wechseln Neue Sprache Sprache l schen Codes Data Metadata Definition View Derived variables File generator C digos Datos Metadatos Definici n Visualizaci n Variables derivadas Generador de archivos Codes Donn
141. the correct code to enter Unknown codes codes not included in the coding system are not accepted during data entry All coded information can be entered in both upper and lower cases On screen SDBm Plus automatically changes lower to upper case Each numerical information basically an analytical variable has a fixed number of decimals The text information such as site location and remarks are stored exactly in the way it is entered Digitized photographic information is stored into the database through the menus that are shown after click the Right mouse button over the space reserved for the photograph aa Plus FAO CSIC Multilingual Soil Profile Database Input data Profile code 60301 Page 1 E Status Date 1 01 90 Location Distritos municipales Latitude os Longitude mue Local soil classification seri WRB 98 group Fluvisol GL Gleysol GY Gypsisol HS Histosol KS Kastanozem Leptosol Lixisol Nitisol Phaeozem PL Planosol PT Plinthosol Topography DR Land forr Slope ISC Solonchak zi Land use tyr Exit Wegetation type 5 Species Grass cover D Figure 3 12 Pop up window of the coding system The options of these menus are Load Delete and Save image Clicking over Load option you will be able to select a photograph from a file in JPEG format Delete option allows erase the photograph from the
142. the water content in saturation METSTAB CHAR 2 Method used to measure the structure stability index METTPOR CHAR 2 Method used to measure the total porosity PART NUMBER 52 Particles density PRNO RESIST SANO SATWAT STAB TPOR UPBO CHAR 6 NUMBER 52 CHAR 1 NUMBER 6 4 NUMBER 52 NUMBER 6 4 NUMBER 3 Profile code Resistance to penetration Sample code Actual water content Structure stability index Total porosity Upper boundary depth WAT_RET DB file Data and Metadata FIELD TYPE SIZE DESCRIPTION PRNO CHAR 6 Profile code DATE DATE Sampling date SANO CHAR 1 Sample code UPBO NUMBER 3 Upper boundary depth LOBO NUMBER 3 Lower boundary depth FLAG CHAR 1 Kind of measurement Field or laboratory HEAD1 NUMBER 7 2 Value of the first measurement of the suction HEAD25 NUMBER 72 Value of the 25 measurement of the suction THETA1 NUMBER 10 2 Value of the water content for the first suction FHETA25 NUMBER 10 2 Value of the water content for the 25 suction METHODS CHAR 2 Method used to measure the water content suction relation HEADUNIT CHAR 10 Suction measure units THETAUNIT CHAR 10 Water content measure units KUNSAT DB file Data and Metadata FIELD TYPE SIZE DESCRIPTION PRNO CHAR 6 Profile code DATE DATE Sampling date SANO CHAR 1 Sample code UPBO NUMBER 3 Upper boundary depth LOBO NUMBER 3 Lower boundary depth FLAG CHAR 1 Kind of measurement Field or laboratory IND VAR C
143. tinua continue zusammenh ngend B broken quebrada cass e unterbrochen CODE CEMENTATION STRUCTURE ESTRUCTURA DE STRUCTURE DES STRUKTUR DER CEMENTACIONES CIMENTATIONS ZEMENTIERUNG M massive masiva massive massiv V vesiculair vesicular v siculaire blasenf rmig P platy laminar lamellaire plattig N nodular nodular noduleuse klumpig knollenf rmig CODE CEMENTATION GRADE GRADO DE CEMENTACION DEGR DE CIMENTATION GRAD DER ZEMENTIERUNG W weakly cemented d bil peu ciment schwach zementiert M moderately cement moderada peu c ment e m ig zementiert C cemented cementada ciment verdichtet S strongly cemented fuerte fortement ciment stark zementiert indurated endurecida endurci N not cemented nor compacted no cementada ni compactada ni ciment ni compact nicht zementiert nicht verdichtet Y compactes but not cemented compactada pero no cementada compact mois non peu ciment kompakt aber nicht zementiert CODE CEMENTATION NATURE NATURALEZA DE LA NATURE DE LA CIMENTATION MATERIAL DER CEMENTACION ZEMENTIERUNGEN K carbonates carbonatos carbonates Karbonate Q quartz s lice silice Quartz S sesquioxides sesqui xidos sesquioxydes Sesquioxide F iron hierro fer Eisen M iron manganese hierro manganeso fer mangan se Eisen Mangan O iron organic matt hierro mat org nica fer mati re organique Eisen organisches Material Y gypsum yeso gypse Gips C clay arcilla argile Ton N not known desconocida inconnue nicht be
144. tributed on CD ROM Also this software is available free of charge through the FAO AGLS Internet site Http www fao org W AICENT FaolInfo Agricult AGL Aglhomep htm or the CSIC IRNAS WWW MicroLEIS site Http leu irnase csic es Set up The set up procedure by double clicking the setup exe file is a typical MS WINDOWS application set up environment After set up a reboot of MS WINDOWS is recommended A new icon will have been added in the programme manager The set up function will copy the main files in the destination directory PROGRAM FILE SDBMPLUS is the default directory The SDBm Plus directory structure is as follows SDBMPLUS DATA EXPORT EVALUATION LANGUAGES ENGLISH SPANISH FRENCH GERMAN The data files and field names are described in the Appendix E Uninstall An uninstall option is available Use standard add remove programme procedure on the WINDOWS Control Panel to uninstall SDBm Plus CONVERSION FROM PREVIOUS DATABASES Two earlier versions of the SDBm Plus database can be used SDB 1989 and SDBm 1995 since they have the same SDB coding system However this new version is different in that it offers Ll Blocks of soil analytical variables that include new soil variables referred to heavy metals water content and hydraulic conductivity Ll Time referenced dimension for the analytical variables of any stored soil profile The possibility to store soil ph
145. ucture CLAY NUMBER Field estimated clay RCN2 RCQ1 RCQ2 RCS1 CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR NUMBER CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR NUMBER CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR Dry consistence Moist consistence Wet consistence plasticity Wet Consistence stickiness 1 cutans contrast 2 cutans contrast 1 cutans location 2 cutans location 1 cutans nature 2 cutans nature 1 cutans quantity 2 cutans quantity 1 colour chroma 2 colour chroma Horizon designation Horizon number 1 colour hue 2 colour hue Lower boundary depth Method used to measure the field pH 1 nodules colour 2 nodules colour 1 nodules shape 2 nodules shape 1 nodules kind 2 nodules kind 1 nodules nature 27 nodules nature 1 nodules quantity 2 nodules quantity 1 nodules hardness 2 nodules hardness 1 nodules size 2 nodules size 1 colour modifier 2 colour modifier 1 mottles boundary 2 mottles boundary 1 mottles colour 2 mottles colour 1 mottles contrast 2 mottles contrast 1 mottles abundance 2 mottles abundance 1 mottles size 2 mottles size Field pH Porf e code 1 pores quantity 2 pores quantity 1 pores size 2 pores size Porosity 1 p
146. us blau 2 7 Biological activity CODE ROOTS ABUNDANCE CANTIDAD DE RA CES ABONDANCE DES RACINES WURZELVORKOMMEN 0 nil ninguna n ant keine V very few muy poca tr s peu nombreuses sehr wenige F few poca peu nombreuses wenige C common frecuente nombreuses einige M many mucha tr s nombreuses viele A abundant abundante abondantes reichlich CODE ROOTS SIZE TAMA O DE RA CES DIAMETRE DES RACINES GR BE DER WURZELN VF very fine muy fino tr s fines sehr fein Fl fine fino fines fein FM fine medium de fino a medio fines et moyennes fein bis mittel FF fine and very fine fino y muy fino fins et tr s fines fein und sehr fein ME medium medio moyennes mittel MC medium coarse de medio a grueso moyennes et grossi res mittel bis grob CO coarse grueso grossi res grob VC very coarse muy grueso tr s grossi res sehr grob CODE BIOLOGICAL FEATURES CANTIDAD DE RASGOS CAR CTERES D ORIGINE ABUNDANCE BIOLOGICOS BIOLOGIQUE 0 nil ninguna n ant e keine V very few muy poca tr s peu sehr wenige F few poca peu wenige C common frecuente fr quent es einige M many mucha beaucoup viele CODE BIOLOGICAL FEATURES KIND TIPOS DE RASGOS BIOL GICOS TYPES DE CAR CT RES D ORIGINE BIOLOGIQUE AR artefacts artefactos engin AB biological activity actividad biol gica activit biologique biologische Aktivit t BU burrows madrigueras galeries d animaux CC charcoal carb n vegetal charbon de bois EW earthworms lombrices vers Erdw r
147. ustoll Paleustoll Durustoll Calciustoll Natrustoll Argiustoll Vermustoll Spodosols SHA SHC SHF SHP SHT SI SOA SOC SOF SOP SOT SQA SQC SQD SQF SQP SQS SQT Ultisols UDA UDB UDF UDL UDR UHA UHB UHH UHK UHL UHS Haplohumod Cryohumod Fragihumod Placohumod Tropohumod Ferrod Haplorthod Cryorthod Fragiorthod Placorthod Troporthod Haplaquod Cryaquod Duraquod Fragiaquod Placaquod Sideraquod Tropaquod Hapludult Paleudult Fragiudult Plinthudult Rhodudult Haplohumult Palehumult Kandihaplohumult Kandihumult Plinthohumult Sombrihumult B 8 AXL AXN AXR Aridisols DOB DOD DOG DOK DOM DOS DRA DRB DRD DRJ DRN Entisols EOC EOD EOP EOT EOU EOX EQA EQC EQI Plinthoxeralf Natrixeralf Rhodoxeralf Paleorthid Durorthid Gypsiorthid Calciorthid Camborthid Salorthid Haplargid Paleargid Durargid Nadurargid Natrargid Cryorthent Udorthent Torriorthent Troporthent Ustorthent Xerorthent Haplaquent Cryaquent Sulfaquent HLC HLT Inceptisols IG IMA IMC IMF IMX INC IND INE INP INV INW INY IOC IOD IOE IOF IOU IOX IOY IQA IOC IQF IQH Cryofolist Tropofolist Plaggept Haplumbrept Cryumbrept Fragiumbrept Xerumbrept Cryandept Durandept Eutrandept Placandept Vitrandept Hydrandept Dystrandept Cryochrept Durochrept Eutrochrept Fragiochrept Ustochrept Xerochrept Dystrochrept Haplaquept Cryaquept Fragiaquept Humaquept MWN MWR MXA M
148. ydrogenum H Aluminium Al Percentage of base saturation Potassium K mg kg Particles size Gand g 100g very coarse coarse medium fine very fine total Silt 0 1009 coarse fine total Clay g 100g code code code code code code code 5 0 9 0 code string string HHH HHH 5 0 9 0 0 0 4 0 0 0 40 0 0 00 5 00 0 00 0 50 2 0 25 0 0 0 25 0 0 0 15 0 0 00 3 00 0 00 5 00 HHHH 0 100 HHHH 0 100 0 100 0 100 Cation exchange capacity of clay meq 100g Carbonates content CaCO3 g 100g total active Gypsum content CaSO4 g 100g Block 4 SOLUBLE SALTS HEAVY METALS Sample code Date Depth cm upper lower pH Electrical conductivity EC mS cm Soluble cations Calcium Ca meq 100g Magnesium meq 100g Potassium meg 100g Sodium Na meq 100g Boron B meq 100g Soluble anions Carbonate CO3 meq 100g Bicarbonate HCO3 meq 100g Chloride CI meg 100g Sulphate SO4 meq 100g SAR Heavy metals Arsenic As mg kg Cadmium Cd mg kg Cobalt Co mg kg Chromium Cr mg kg Copper Cu mg kg Mercury Hg mg kg Manganese Mn mg kg Molybdenum Mo mg kg Nickel Ni mg kg Lead Pb mg kg Antimony Sb mg kg Selenium Se mg kg Zinc Zn mg kg Block 5 PHYSICAL ANALYSES Sample code Date Depth cm upper lower 0 0 150 0 0 0 50 0 0 0 15 0 string string
149. ze Schwermetalle Physikalische Analysen Wasserspeicherung Hydraulische Leitf higkeit Erg nzende Variablen Profilcode Inhalt Seite Status Datum Autoren Bodeneinheit Lage Unters gebiet Verw bezirk Latitude Longitude Elevation Sheet Grid FAO 90 soil unit FAO 90 third level FAO 74 soil unit Phase group unit specifier Soil climate Local soil classification serie Topography Land form Land element Position Slope class form Micro topography Flood frequency duration Land use type Crops Vegetation Species Grass cover Parent material over derived from Parent rock Stones Latitud Longitud Elevaci n Hoja Cuadr cula Unidad de suelo FAO 90 Tercer nivel FAO 90 Unidad de suelo FAO 74 Fase grupo unidad especificador Clima del suelo Clasificaci n local del suelo serie Topograf a Geomorfolog a Posici n fisiogr fica Emplazamiento del perfil Pendiente clase forma Microtopograf a Inundaci n frecuencia duraci n Uso del terreno tipo Cultivos Vegetaci n Especies Cobertura de herb ceas Material original sobre derivado de Roca original Piedras Latitude Longueur Altitude Couche Grille Unit de sol FAO 90 Trosi me niveau FAO 90 Unit de sol FAO 74 Phase groupe unit specifier Climat du sol Classification locale du sol s rie Topographie G omorphologie Position physiographique Situation du profile Pente classe f

SDBm Plus - Evenor Tech

Contents

Download Pdf Manuals

Related Search

Related Contents