Home

TROFOLIN DATABASE USER MANUAL

1. DATE SURVEYOR C ALTITUDE POSITION C EXPO C SLOFORM_C 1 03 23 91 0 O ng a A PT a inni ee _ _ _ t1211 l TEIN maan MELI A Sr A me 7 TITTI Se an aa AAA gt ea Figure 5 Example of a browse screen In the first part box at the top of the screen the key attributes AREA_ID GUY and the name of the entity SITEDESC are given In the second part central part of the screen the names of the attributes and the values for these attributes are given Usually only part of the attributes is displayed on the screen With the and arrows one can move along the complete set of attribute columns so that all can be viewed see para 3 3 3 for navigation Browse screens that contain many rows have a frozen first column in order to keep a reference number in sight In the third part box at the bottom of the screen five options and the record number are displayed The options can be activated by typing the first letter A dd To add new data the input and edit screen is activated E dit To edit existing data the input and edit screen is activated D elete To mark records for deletion R eport To generate a simple standard report of the entered data Q uit To return to ihe main menu 14 4 3 1 Options Add and Edit The A dd and E dit options activate a blank edit screen to add new data or an edit screen with existing data t
2. Fine Common Very fine Many IGHLY POROUS VERY RAPID ABSORPTION CF WATER Coarse Few Oblique Very fine Common NSOINIESSOM annex H 2 RCOTORI2 C ROOTF INE ROOTCOARS ROCKSIZ1 C ROCKABU1_C ROCKWEA1_C ROCKNATI C ROCXSIZ2 C ROCKABU2_C ROCKWEA2_C ROCKNAT2_C CONCQUA1_C CONCSIZ1_C CONCHARI C CONCSHAL C CONCNATI C CONCQUA2_C CONCSIZ2_C CONCHAR2_C CONCSHA2_C CONCNAT2_C CARBOCON_C CARBOLOC C PH H20 PH KCL EC SAMP_L R Random me Fine gravel E Few F Fresh MO Quartzite N None N Non calcareous 5 80 0 0 120 pa ANNEX IV EXAMPLES OF PROGRAMMING REPORTS IN DBASE annex IV 1 EXAMPLE 1 CLIMATE l a Programme procedure cli This program generates the report for climatic data Start initializing k set talk off set escape off public last station last station NULL _padvance FORMFEED on page okee f store getenv trofodata to trof dir climstat trof dir climstat use climstat if file repcli01 ndx ERASE repcli01 ndx endif index on station_c climdata_c to repcli01 set index to repcli01 accept Enter name of area to create report for to user_area if len user_area 0 retum endif user_area upper user_area locate for AREA_ID USER_AREA set console off set printer on do while found do print record with jan feb mar apr may jun jul aug sep oct nov dec climdata_c station_c beginperio endperiod x
3. In contrast to the TROFOLIN Report function that will only display all records of an entity it is possible to print all or parts of an active data file with the help of dBASE 1 Select the proper directory with SET DIRECTORY TO CATROFOLINDATA 2 Open the TROFOLIN data file to be transferred with USE 3 Selected data can be printed with REPORT FORM lt name gt FOR lt condition gt TO PRINT 9 8 Transfer TROFOLIN data files to text files ASCII or LOTUS files All or part of an active data file can be transferred to a text file or Lotus file 1 Select the proper directory with SET DIRECTORY TO CATROFOLINDATA 2 Open the TROFOLIN data file to be transferred with USE 3 Copy the file to a text file with COPY TO lt new name gt SDF 4 Copy the file to a lotus file with COPY TO lt new name gt WKS Field names are not copied Also tor this option specific records can be copied with COPY TO lt new name gt FIELDS lt field list gt FOR lt condition gt SDF 29 30 REFERENCES ASHTON TATE 1988 Database Package dBASE versions II and IV Manuals 5 vols FAO UNESCO ISRIC 1988 FAO Unesco Soil map of the world revised legend World soil resources report 60 FAO Rone Italy GESINK H J Y VAN RANDEN AND L TOUBER 1990 Datamodel for tropical forest land inventories at reconnaissance level Report 38 The Winand Staring Centre The Tropenbos Foundation Wageningen The Netherlands KOPPEN W 1931 Die Klimate der Erde W
4. This entity describes the mineral soil profile samples taken in a mineral soil profile pit Attribute AREA_ID OBS_NR SAMPDEP_UL SAMPDEP_LL char 7 number 4 number 3 number 3 Description Identification of survey area Sequence number of observation site within survey area Upper limit of sample depth cm below mineral soil surface Lower limit of sample depth cm below mineral soil surface annex I 38 annex I 39 Entity OBS_SITE OBSERVATION SITE This entity contains besides coordinates and a number of key attributes so called logical attributes which are used to store information about the type of observations made at a specific site Attribute AREA_ID OBS_NR XCOOR YCOOR PHOTOSY1_C PHOTOSY2_C LMU_NR LE_NR SITEATT_L VEGREL_L L_USE_L HP_PIT_L MSP_PIT_L AUGER_L REMARKS char 7 number 4 char 10 char 10 char 6 char 6 number 3 number 2 char 1 char 1 char 1 char 1 char 1 char 1 char 150 Description Identification of survey area Sequence number of observation site within survey area X coordinate degrees minutes seconds Y coordinate degrees minutes seconds Mapping unit symbol for physiographic unit on photo interpretation map codes to be established on location Mapping unit symbol for vegetation on photo interpretation map codes to be established on location Sequence number of Land Mapping Unit Sequence number of Land Element within Land M
5. Estimated percentage of boulders gt 250 mm NB No boulders lt 2 BO Bouldery 2 50 VB Very bouldery 50 90 BL Boulders gt 90 Consistence of dry soil LO Loose SO Soft SH Slightly hard HA Hard VH Very hard EH Extremely hard Consistence of moist soil LO Loose VR Very friable FR Friable FI Firm V Very firm EF Extremely firm Stickiness NS Non sticky SS Slightly sticky S Sticky VS Very sticky Plasticity NP Non plastic SP Slightly plastic P Plastic VP Very plastic Smeariness WS Weakly smeary MS Moderately smeary SS Strongly smeary ROOTSIZI_C ROOTABU1_C ROOTSIZ2_C ROOTABU2_C ROCKSIZ1 C ROCKABU1_C ROCKWEA1_C ROCKNATI_C ROCKSIZ2_C ROCKABU2_C ROCKWEA2_C ROCKNAT2_C CONCQUA1_C CONCSIZI_C CONCHAR1_C CONCSHA1_C CONCNATI_C char char char char 1 char 1 char 1 char 1 char 2 char 1 char 1 char 1 char 2 char 1 char 1 char 1 char 1 char 1 annex I 5 SF Slightly fluid VF Very fluid Size of first type of roots V Very fine lt imm F Fine 1 2mm M Medium 2 10mm C Coarse 10 25mm O Very coarse gt 25mm Abundance of first type of roots per unit area i e per 2 5x2 5cm for very fine and fine roots 25x25cm for coarser roots V Very few 3 F Few 3 10 C Common 10 20 M Many 20 30 A Abundant gt 30 Size of second type of roots Abundance of second type of roots per unit area Size of first type of rock
6. LA LA 1 LA la I A lb I A lc LA Ic 1 I A 1c 2 I A 1c 3 LA Ic 4 l A 1d l A le I A le 1 I A 1e 2 I A 1e 3 LA 1f LA 1f 1 I A 1 2 LA 1f 3 LA Ig I A 1g 1 l A 1g 2 I A lh LA 2 I A 2a I A 2b I A 2b 1 I A 2b 2 I A 2c I A 2d I A 3 I A 3a I A 3b LA 4 I A 5 1 A 9 I A 9a I A 9b I B B 1 I B la B 1b II H A ATTRIBUTE UNESVEGI_C ATTRIBUTE UNESVEG2_C ATTRIBUTE UNESVEG3_C f g h ATTRIBUTE UNESVEG4_C ATTRIBUTE UNESVEG5_C Closed forest Mainly evergreen forest Tropical ombrophilous forest Tropical ombrophilous lowland forest Tropical ombrophilous submontane forest Tropical ombrophilous montane forest Broad leaved Needle leaved Microphyllous Bamboo Tropical ombrophilous subalpine forest Tropical ombrophilous cloud forest Broad leaved Needle leaved Microphyllous Tropical ombrophilous alluvial forest Riparian forest frequently flooded Occasionally flooded Seasonally water logged for several months Tropical ombrophilous swamp forest Broad leaved Dominated by palms Tropical evergreen bog forest Tropical and subtropical evergreen seasonal forest Tropical or subtropical evergreen seasonal lowland forest Tropical or subtropical evergreen seasonal submontane forest Broad leaved Needle leaved Tropical or subtropical evergreen seasonal montane forest Tropical or subwopical evergreen dry subalpine forest Tropical and subtropical semi deciduous forest Tropical
7. Micro relief ions in cm Micro relief Micro relief average height variation cm minimum height variation cm maximum height variation cm lateral dimensions distance between tops or depress minimum lateral dimensions cm maximum lateral dimensions cm Morphological features of microrelief more codes to be established at location D Dimples G Gilgai N Animal tracks CRACKWI_LL CRACKWI_UL CRACKDE LL CRACKDE UL CRACKDI LL CRACKDI UL CRUSTCON C CRUST C CRUSTNAT C CRUSTTHICK TERMCOVER ANTCOVER TERMANTREM SHEET LL SHEET UL RILL LL RILL UL GULLY LL GULLY UL SLOSTAB_C OWASH_LL OWASH_UL HUMPRO HUMPRO_LL HUMPRO_UL SOLUM SOLUM_LL SOLUM_UL PAN PAN_LL PAN_UL PANTY PE_C PANHARD_C number 4 1 number 4 1 number 3 number 3 number 3 number 3 char 2 char 1 char 2 number 2 number 3 number 3 char 75 number 3 number 3 number 3 number 3 number 3 number 3 char 1 number 3 number 3 number 3 number 3 number 3 number 3 number 3 number 3 number 3 number 3 number 3 char 1 char 1 annex 1 43 S Slumping T Terracettes Minimum width of surface cracks cm Maximum width of surface cracks cm Minimum depth of surface cracks cm Maximum depth of surface cracks cm Minimum distance between surface cracks cm Maximum distance between surface cracks cm Consistence of crust SO Soft SH Slightly hard HA Hard VH Very h
8. TROFOLIN DATABASE A A E L Fouber Y van Randen and N Gijsen June 1993 DLO Winand Staring Centre for Integrated Land Soil and Water Research P O Box 125 NL 6700 AC Wageningen The Netherlands Phone 31 8370 74200 Fax 31 8370 24812 PENA TROPENBOS sc dlo Report prepared for the TROPENBOS Foundation P O Box 232 NL 6700 AE Wageningen The Netherlands CONTENTS page l INTRODUCTION l 2 INSTALLATION OF TROFOLIN 3 3 THE TROFOLIN APPLICATION gt 3 1 Getting started 2 3 2 Terminologv 9 3 3 Screens and navigation 5 3 3 1 Menu creen 6 3 3 2 Input and edit screen 6 3 3 3 Browse screen 7 3 3 4 Pick list 7 4 DATABASE 9 4 1 Database structure 9 4 2 Input and edit screen 12 4 3 Browse screen 14 4 3 1 Options Add and Edit 15 4 3 2 Option Delete 15 4 3 3 Option Report 15 5 CODES 17 5 1 General 17 5 2 Adding new codes 18 6 EXPORT 21 7 SYSTEM 23 7 1 Pack Database 23 7 2 Backup Database 23 7 3 Restore Database 23 7 4 Update Index 24 8 QUIT 25 9 TECHNICAL NOTES ON DBASE 27 9 1 General 27 9 2 Change structure of data files 27 9 3 Delete codes 27 9 4 Append data 28 9 5 Selections within one TROFOLIN datafile 28 9 6 Combine selections from different TROFOLIN datafiles 28 9 7 Report selected records 29 9 8 Transfer TROFOLIN data files to text files ASCII or LOTUS files 29 REFERENCES ANNEXES I Entities in alphabetical order and attribute descriptions II Codes III Example of a Trofol
9. 1 obs nr and area id user area gol if file sla dbf erase sla dbf endif if file sla dbf erase sla dbf endif copy to sla dbf if file sIb dbf erase si b dbf 3RD GF 4THGF 5TH GF TY AB TYAB TY AB endif set filter to use sla dbf if reccount gt 1 sort on layer_nr to slb dbf else copy to slb dbf endif use slb dbf erase sla dbf 9 ftt tt tt LATNAME LOCNAME FIELDNAME n_spec reccount spec_nr 1 do while spec_nr lt n_spec go spec_nr if last_page lt gt _pageno eject qn 9 9 9 ff tt LATNAME LOCNAME FIELDNAME last_page _pageno endif 2 lamame at 1 locname at 11 fieldname at 21 layer_nr at 36 picture 99 abund c at 40 picture 99 height at 43 picture 999 9 reprod_c at 50 decidu_c at 52 age cat 54 vital_c at 56 spec_nr spec_nr 1 enddo use in 2 erase slb dbf return annex IV 9 LAY AB HEIGHT RD A V LAY AB HEIGHT R DA V annex IV 10 2 b Report Output VEGETATION RELEVEE FOR OBS SITE 15 AREA UGUNG AUTHOR HOMMEL BOTANIST INDRA DATE 20 10 38 IST GE 2ND GF 3RD GF 4TH GF STA GE LAYER HEIGHT COVER TY AB TY AB TY AB TY AB TY AB de 3940 30 ET 2 20 0 85 ET 6 Ter L PL 1 2 6 0 2 BS 2 SP 2 Roi 1 Ce L 4 1 0 20 BH 2 GH 1 LATNAME LOCNAME FIELDNAME LAY AB HEIGHT RDA V NEESALTI BENGANG 3 40 0 BLMH ANTIVELU KISEUHEU de E 25 0 VLMH DIPTIRIN 2 2 25 0 F LMH LESASAMB SULANGKA 2 E 15 0 V L
10. 73 72 163 166 50 119 92 117 24 25 31 31 18 20 P precipitation T temperature 04 35 Apr TE 174 153 119 29 31 20 May 30 192 184 121 24 30 19 N Tmin minimum day temperature I hours of sunshine x 14 24 Jun Jul 31 84 139 105 173 112 96 89 23 22 29 27 19 19 Aug 83 94 161 91 23 27 19 E Sep Oct 81 2 112 128 217 274 94 99 23 24 29 29 19 19 annex IV 3 AREA ID Nov Dec Q 78 178 183 LIS 34 98 92 24 23 29 30 18 17 33 52 si 55 55 35 33 BIPINDI ONIROYIN PET potential evapotranspiration Tmax maximum day temperature Hum relative air humidity annex IV 4 annex IV 5 EXAMPLE 2 VEGETATION 2 a Programme set talk off store formfeed to _padvance use in 1 use in 2 close databases close indexes store getenv TROFOdata eg stru to veg_stru store getenv TROFOdata veg_rele to veg_rele store getenv TROFOdata veg_spec to veg_spec accept Enter area name to create report for to user_area if len user_area 0 retum endif user_area upper user_area select 1 use veg_stru set filter to area_id user_area set fields to obs_nr layer_nr height_av cover abund1_c grform1_c abund2_c grform2_c abund3_c grform3_c abund4_c grform4_c abund3_c grformS_c go 1 if file vla dbf erase vla dbf endif if file vlb dbf erase vlb dbf endi f copy to vla use vla if reccount gt 1 sort
11. DATELAB date LAB_C char 3 VALUE number 10 3 Description Identification of survey area Sequence number of observation site within survey area Upper limit of sample depth cm above mineral soil surface Type of analysis humus profile WN Weight necro mass WR Weight root mass C Carbon loss on ignition NO Organic N by destruction Kjeldahl PTO Total organic P by destruction Kjeldahl CAT Total Ca by destruction HF HNO3 KT Total K by destruction HF HNO3 MGT Total Mg by destruction HF HNO3 NAT Total Na by destruction HF HNO3 PT Total P by destruction HF HNO3 Date of analysis month day year Laboratory identification codes to be established on location Value for a chemical analysis annex I 10 annex I 11 Entity HP LAYER HUMUS PROFILE LAYER The layers of humus profile pits are described comprehensively Attributes like thickness of horizon structure consistency abundance of roots by size class biota are incorporated in this entity Attribute Type Description AREA_ID char 7 Identification of survey area OBS_NR number 4 Sequence number of observation site within survey area LAYER_NR number 2 Sequence number of layer HORIZHP_C char 6 Horizon designation Humus profile pit layer L Litter horizon LN Fresh non fragmented litter no visible signs of alteration or discolouration LV Non fragmented slightly altered litter partial or complete discolouration F Fermentation horizon F
12. F Fine 1 2mm M Medium 2 10mm C Coarse 10 25mm O Very coarse gt 25mm Abundance of first type of roots per unit area i e per 2 5x2 5cm for v fine and fine 25x25cm for coarser roots V Very few s3 F Few 3 10 C Common 10 20 M Many 20 30 A Abundant gt 30 Orientation of first type of roots H Horizontal O Oblique V Vertical R Random Size of second type of roots Abundance of second type of roots per unit area Orientation of second type of roots Dry weight of fine roots diam 25mm per sampled area g Dry weight of coarse roots diam gt 5mm per sampled arca g Size of first type of rock fragments F Fine gravel 0 2 1cm G Gravel 1 7 5cm S Stones 7 5 25cm B Boulders 25 50cm R Blocks gt 50cm Abundance of first type of rock fragments N None F Few 2 15 M Many 15 50 A Abundant gt 50 Degree of weathering of first type of rock fragments F Fresh W Slighly weathered S Strongly weathered Nature of first type of rock fragments sce Annex li fer codes Size of second type of rock fragments Abundance of second type of rock fragments Degree of weathering of second type of rock fragments ROCKNAT2_C CONCQUA1_C CONCSIZ1_C CONCHAR1_C CONCSHA1_C CONCNATI_C CONCQUA2_C CONCSIZ2_C CONCHAR2_C CONCSHA2_C CONCNAT2_C CARBOCON_C CARBOLOC_C PH_H20 PH_KCL EC SAMP_L char 2 char 1 char 1 char 1 char 1 char 1 char 1 char 1 char 1 char 1 char 1 ch
13. char 2 char 150 char 2 char 150 Labour input number of persons 100ha Rate of mechanization H Use of handtools only Use of animal traction T Use of communal tractor M Fully mechanized operations Remarks on rate of mechanization Use of organic manure Y N Application of chemical fertilizers Y N Remarks on kind amount and frequency of use of fermlizers Application of biocides Y N Remarks on kind amount and frequency of use of biocides Forms of land improvement IRP Irrigation and drainage infrastructure project imposed IRT Irrigation and drainage infrastructure traditional TEP Terracing for erosion control project imposed TET Terracing for erosion control traditional TIP Terracing for irrigation project imposed TIT Terracing for irrigation traditional Remarks on status of maintenance and efficiency of land impr Order of magnitude of fields agriculture ha Order of magnitude of concessional areas forestry ha Remarks on form and orientation of fields conc areas Intensity of agricultural activities SC Shifting cultivation BF Semi permanent or bush fallow cultivation PC Permanent cultivation Amount of land under actual cultivation ha 100ha Remarks on agricultural activities Harvesting method felling system in forestry Coppice felling system Shelterwood coppice felling system Copping with standards felling system Clear felling system Shelterwood felling system Shelterwood strip f
14. the CODES menu by pressing lt Esc gt Location of carbonates Character of humus profile material Chroma Munsell scale of dry soil Chroma Munsell scale of moist soil Chroma Munsell scale at moisture stat at time of descr a Chroma Munsell scale of wet soil CLIMDATA C Type of climatic data CLIMZONI C First climate zone covering Land Mapping Unit CLIMZON2_C Second climate zone covering Land Mapping Unit CLIM20N3 C Third climate zone covering Land Mapping Unit CLIMZONE C Climate zone CONCESSI2E Order of magnitude of concessional areas forestry ha CONCHAR1_C Hardness of first type of concretions CONCHAR2_C Hardness of second type of concretions CONCNAT1 C Nature of first type of concretions Edit Report Quit ga a a pc n Record 57 Figure 7 Attribute descriptions browse screen In many cases the attribute name under CODE TAB ss similar to the name under CO NAME However several groups of related attributes will need identical codes and values These all share therefore only one attribute name under CODE TAB for example CO NAME DESCRIPT CODE TAB CLIMZONI C First climate zone covering Land Mapping Unit CLIMZONE_C CLIMZON2_C Second climate zone covering Land Mapping Unit CLIMZONE C CLIMZON3_C Third climate zone covering Land Mapping U t CLIMZONE_C CLIMZONE_C Climate zone CLIMZONE_C By entering a certain code for CLIMZONE_C the same code will also become 18 valid for the attributes CLIMZONI_C CLIMZ
15. 10 years O Occasional less than twice in 10 years F Frequent more than twice in 10 years but not yearly Y Yearly duration less than one month B Yearly duration between 1 3 months A Yearly duration more than three months SOILTYPE_C char 3 Soil type codes to be established on location HPTYPE_C char 3 Humus profile type codes to be established on location VEGTYPE_C char 3 Vegetation type codes to be established on location LANDUSE_C char 8 Land use type codes to be established on location annex I 20 annex l 21 Entity LAND MAP LAND MAPPING UNIT Land mapping units are described in terms of climate landform relief geology surface hydrology morphometric features and each in a general classified and aggregated form vegetation and land use Most of this information is compiled in the office both before and after fieldwork Attribute AREA_ID LMU_NR PHOTOS Y1_C PHOTOSY2_C MAPSYMB_C AREA PERC_SA POLYGONS CLIMZONI_C CLIMZON2_C CLIMZON3_C LANDFORM_C RELIEF_C coco nar ar rr char 6 char 6 char 6 number 7 number 4 1 number 2 char 2 char 2 char 2 char 3 char 1 Description Identification of survey area Sequence number of Land Mapping Unit Mapping unit symbol for physiographic unit on photo interpretation map codes to be established on location Mapping unit symbol for vegetation on photo interpretation map codes to be established on location Final mapping unit sy
16. Leptosols LPC Calcaric Leptosol LPD Dystric Leptosol LPE Eutric Leptosol LPI Gelic Leptosol LPK Rendzic Leptosol LPM Mollic Leptosol LPQ Lithic Leptosol LPU Umbric Leptosol LV Luvisols LVF Ferric Luvisol LVG Gleyic Luvisol LVH Haplic Luvisol LVJ Stagnic Luvisol LVK Calcic Luvisol LVX Chromic Luvisol LX Lixisols LXA Albic Lixisol LXF Ferric Lixisol LXG Gleyic Lixisol LXH Haplic Lixisol LXJ Stagnic Lixisol LXP Plinthic Lixisol NT Nitisols NTH Haplic Nitisols NTR Rhodic Nitisols NTU Humic Nitisols PD Podzoluvisols PDD Dystric Podzoluvisol PDE Eutric Podzoluvisol PDG Gleyic Podzoluvisol PDI Gelic Podzoluvisol PDJ Stagnic Podzoluvisol PH Phaeozems PHC Calcaric Pheaozem PHG Gleyic Pheaozem PHH Haplic Pheaozem PHJ Stagnic Pheaozem PHL Luvic Pheaozem PL Planosols PLD PLE PLI PLM PLU PT PTA PZ PZC PZF PZH RG RGC RGD RGE RGI RGU RGY SC SCG SCH SCI SCK SCM SCN SCY SN SNH SNJ SNK SNM SNY VR VRD VRH VRK VRY Dystric Planosol Eutric Planosol Gelic Planosol Mollic Planosol Umbric Planosol Plinthosols Albic Plinthosol Dystric Plinthosol Eutric Plinthosol Humic Plinthosol Podzols Cambic Podzol Carbic Podzol Ferric Podzol Gleyic Podzol Haplic Podzol Gelic Podzol Regosols Calcaric Regosol Dystric Regosol Eutric Regosol Gelic Regosol Umbric Regosol Gypsic Regosol Solonchaks Gleyic Solonchak Haplic Solonchak Gelic Solonchak Calcic Solo
17. Munsell scale of wet soil VALWET_C char 3 Value Munsell scale of wet soil CHRWET_C char 3 Chroma Munsell scale of wet soil CONSIST_C char 1 Consistence of humus profile material L Loose no consistence S Friable easily crumbling annex I 12 CHARACT_C STRUCTGR_C STRUCTTY_C ROOTSIZ1_C ROOTABUI_C ROOTORI1 C ROOTSIZ2_C ROOTABU2_C ROOTORI2_C ROOTSIZ3_C ROOTABU3_C ROOTORI3_C ROOTSIZ4_C ROOTABU4_C ROOTORI4_C ROOTSIZS_C ROOTABUS_C ROOTORIS_C BIOTYP1_C char 2 chart 1 char 2 char 1 char 1 char 1 char 1 char 1 char 1 char 1 char 1 char 1 char 1 char 1 char 1 char 1 char 1 char 1 char 1 F Firn crushing needs moderate pressure P Pliable soft and plastic R Resilient springy and elastic T Tenaceous cohesive not easily pulled apart Character of humus profile material AC Acerose CR Crusty FE Felty FI Fibrous GE Greasy GI Gritty LE Leafy LI Ligneous MC Mucky MO Mossy MS Mushy Structure grade W Weak lt 20 aggregated material M Moderate 20 60 aggregated material S Strong gt 60 aggregated material Structure type BB Block like blocky BG Block like granular CR Column like recumbent CE Column like erect LC Plate like compact matted LM Plate like non compact matted NM Suuctureless massive NS Structureless single particle Size of first type of roots V Very fine lt lmm F Fine 1 2mm M Medium 2 10mm C Coa
18. Value Munsell scale of moist soil Chroma Munsell scale of moist soil Abundance of mottles area percentage Size of mottles F Fine lt 5mm M Medium 5 15mm C Coarse gt 15mm Contrast of mottles F Faint D Distinct P Prominent Sharpness of mottles D Diffuse gt 2mm C Clear lt 2mm S Sharp knife edge Hue Munsell scale of mottles Value Munsell scale of mottles Chroma Munsell scale of mottles Estimated texture of fine earth lt 2 mm SA Sand CSA Coarse sand MSA Medium sand FSA Fine sand VSA Very fine sand LSA Loamy sand LCSA Loamy coarse sand LMSA Loamy medium sand LFSA Loamy fine sand LVSA Loamy very fine sand SAL Sandy loam annex 1 4 F2_75_C F75_250_C F250_C CONSDRY_C CONSMOI_C STICKY C PLASTIC_C SMEARY_C char 2 char 2 char 2 char 2 char 2 char 2 char 2 char 2 CSAL Coarse sandy loam MSAL Medium sandy loam FSAL Fine sandy loam VSAL Very fine sandy loam L Loam SIL Silt loam SI Silt SACL Sandy clay loam SICL Silty clay loam CL Clay loam SAC Sandy clay SIC Silty clay C Clay HC Heavy clay Estimated percentage of gravel gt 2 mm and lt 75 mm NG No gravel lt 2 SG Slightly gravelly 2 15 GR Gravelly 15 50 VG Very gravelly 50 90 GA Gravel gt 90 Estimated percentage of stones gt 75 mm and lt 250 mm NS No stones lt 2 SS Slightly stony 2 15 ST Stony 15 50 VS Very stony 50 90 SO Stones gt 90
19. about TROFOLIN and has no operational function The other options of the main menu will be discussed in the chapters that follow Info Database Codes Export System Quit Figure 1 Main menu TROFOLIN 3 2 Terminology A short explanation of the terminology used in the manual and on the screen 1s given here before the various options within the main menu will be discussed Entity A number of interrelated data belonging to the same object In TROFOLIN an entity 1s represented by a table Attribute A property describing an aspect of an entity Key attribute The attribute which 1s used to identify the relations between entities Key attributes are essential for proper storage extraction and linkage of data Record Data line in the table or entity Each record consists of smaller elements fields 1 1 relation A record in entity A is only related to one record in entity B l n relation A record in entity A can be related to one or more records in entity B Default Standard value provided by the TROFOLIN application Index Records in TROFOLIN are ordered alphabetically chronologically or numerically to increase the programme performance Pick list List of possible values provided by the programme from which you can choose a value Packing Permanent removal of records marked for deletion 3 3 Screens and navigation In the Trofolin application four different screens can be distinguished Menu screen Input and edit
20. are possible l The code is accepted because it occurs in the pre defined list 2 The code is not accepted because it does not occur in the pre defined list A pick list of possible codes appears on the screen from which the proper code can be selected by using the arrows and pressing lt enter gt 3 The code is not accepted because no pre defined list exists yet The message no items found press a key will appear Codes will only be accepted after they have been entered see para 5 2 Info Database Codes Export System Quit Ater Value SO id d a Ea at nina attribute so Edit and Report of Attribute descriptions Figure 6 CODES menu 5 2 Adding new codes With the CODES option in the menu new code lists can be compiled and new codes can be added to existing lists Figure 6 The procedure for adding new codes will be illustrated with the following example l One wants to enter the code I as a new climatic zone which is classified as humid with a r Eo ratio gt 0 80 2 Select the option Attribute descriptions in the CODES menu This screen displays REF TABI with the attributes CO NAME DESCRIPT and CODE_TAB Move to the CO_NAME CLIMZONE_C The screen as displayed in figure 7 wili appear By using the arrow the right side of the screen comes into view Check the key attribute CODE_TAB which is needed for the next step In this case it is also CLIMZONE_C Leave the screen and retum to
21. can be viewed on screen is 200 C ancel To return to the browse screen An example of a report of one record in entity MSP LAY is given in annex III NOTE TROFOLIN will list all records of one entity in the R eport option It is not possible to display specific records in TROFOLIN One has to consult dBASE in order to display selected records This option is described in para 9 7 16 5 CODES 5 1 General The majority of attributes in TROFOLIN are so called coded attributes and can be recognized by the extension _C following tne attribute name These attributes have In most cases codes and descriptions that are already defined and standardized by TROFOLIN The standardized descriptions are meant to be universally applied in the Tropenbos research sites for the sake of comparability of their data and the development of common methodologies However a second category coded attributes exists that needs site specific codes and descriptions such as SURVEYOR_C CLIMSTAT_C PHOTOSYMLC etc Thus TROFOLIN contains pre defined code lists for a number of attributes and offers the possibility to compile new codes lists that suit a certain location All codes are stored in two separate entities The first entity REF TABI is a reference table for coded attributes In the second entity REF_TAB2 the values for a coded attribute are defined When a code is entered fOr an attribute in the editing screen of the DATABASE mode three situations
22. gt 5mm of layer among sampled plots g Maximum value dry weight of fine roots diam lt 5mm of layer among sampled plots g Maximum value dry weight of coarse roots diameter gt 5mm of layer among sampled plots g pH_H 20 av value of layer in plots pH_KCL av value of layer in plots Electric conductivity mS cm av value of layer in plots pH_H 20 minimum value of layer among plots pH_KCL minimum value of layer among plots Electric conductivity mS cm minimum value of layer among plots pH_H 0 maximum value of layer among plots pH_KCL maximum value of layer among plots Electric conductivity mS cm maximum value of layer among plots annex I 14 annex I 15 Entity HP_PIT HUMUS PROFILE PIT This entity contains general attributes on humus profile pits e g date of observation humus profile type Attribute Type Description AREA_ID char 7 Identification of survey area OBS_NR number 4 Sequence number of observation site within survey area DATE date Date of observations month day year SURVEYOR_C char 10 Surveyor codes to be established on location HPTYPE_C char 3 Humus profile type annex I 16 annex I 17 Entity HP SAMP HUMUS PROFILE SAMPLE This entity describes the humus profile samples taken at an observation site As these samples are usually a mixture of samples from several sample plots the attribute NUMBERSAM is included Attribute Type Description AREA_ID char 7 Identification o
23. mottles D Diffuse gt 2mm C Clear lt 2mm S Sharp knife edge Hue Munsell scale of mottles Value Munsell scale of mottles Chroma Munsell scale of mottles Estimated texture of fine earth lt 2mm SA Sand CSA Coarse sand MSA Medium sand FSA Fine sand VSA Very fine sand LSA Loamy sand LCSA Loamy coarse sand LMSA Loamy medium sand LFSA Loamy fine sand LYSA Loamy very fine sand SAL Sandy loam CSAL Coarse sandy loam annex I 30 F2_75_C F75_250_C F250_C CONSDRY_C CONSMOI_C STICKY_C PLASTIC_C SMEAR Y_C char 2 char 2 char 2 char 2 char 2 char 2 char 2 char 2 MSAL Medium sandy loam FSAL Fine sandy loam VSAL Very fine sandy loam L Loam SIL Silt loam SI Silt SACL Sandy clay loam SICL Silty clay loam CL Clay loam SAC Sandy clay SIC Silty clay C Clay HC Heavy clay Estimated percentage of gravel gt 2 mm and lt 75 mm NG No gravel lt 2 SG Slightly gravelly 2 15 GR Gravelly 15 50 VG Very gravelly 50 90 GA Gravel gt 90 Estimated percentage of stones gt 75 mm and lt 250 mm NS No stones lt 2 SS Slightly stony 2 15 ST Stony 15 50 VS Very stony 50 90 SO Stones gt 90 Estimated percentage of boulders gt 250 mm NB No boulders lt 2 BO Bouldery 2 50 VB Very bouldery 50 90 BL Boulders gt 90 Consistence of dry soil LO Loose SO Soft SH Slightly hard HA Hard VH Very hard EH Extremely hard Consistenc
24. or subtropical semi deciduous lowland forest Tropical or subtropical semi deciduous montane or cloud forest Subtropical ombrophilous forest Mangrove forest Tropical or subtropical evergreen needle leaved forest Tropical sub lowland submontane evergreen needly leaved forest Tropical sub montane subalpine evergreen necdly leaved forest Mainly deciduous forest Tropical and subtropical drought deciduous forest Drought deciduous broad leaved lowland and submontane forest Drought deciduous montane and cloud forest Woodland Mainly evergreen woodland annex II 2 ILA 1 IT B IL B 1 III HLA IIT A l III A la IILA lb IIT A lc III A 1d III A le IIT A 2b N B II B l III B 2 IV IV A IV A l IV A la IV A lb V V A V A 1 V A la V A 1b V A lc V A 1c 1 V A 2 V A 2d V A 3 V A 4 V A 4a V A 4a 1 V A S V A Sa V A 5a 1 V A 5a 2 V B V B 4 V B 4a V B 4a 1 V B 5 V B 5a V B 5a 1 V B 5a 2 V B 5b V C V C 5a V D V D 1 V D la V D la 1 V D 1b Evergreen broad leaved woodland Mainly deciduous woodland Drought deciduous woodland Scrub Mainly evergreen scrub Evergreen broad leaved shrubland Low bamboo thicket Evergreen tuft tree shrubland Evergreen broad leaved hemisclerophyllous thicket Evergreen broad leaved sclerophyllous shrubland Evergreen suffruticose thicket Evergreen microphyllous shrubland Mainly deciduous scrub Drought deciduous scrub with evergreen woody plants admixed Drought d
25. screen Browse screen Pick list 3 3 1 Menu screen The menu screen is used for selection of the different options of the Trofolin application Table 1 Navigation in menu screen Key Action Right arrow or ctrl D Move to next menu option Left arrow or ctrl S Move to previous menu option Enter Select menu option First letter of menu option Select menu option Esc Go back to higher menu level 3 3 2 Input and edit screen The input and edit screen is used for entering and editing of data The input and edit screen appears only in the database menu option Table 2 Navigation in input and edit screen Key Action Right arrow or ctrl S Move to next character Left arrow lt or ctrl D Move to previous character Down arrow J Move one field down Up arrow T Move one record up Ctrl right arrow gt Move to previous word remark attribute Ctrl left arrow Move to next word remark attribute Page down Move one screen down Page up Move one screen up Home or ctrl A Go to first character End or ctrl F Go to last character Del or ctrl G Delete character at cursor position Backspace or ctrl H Delete character left of cursor position Ctrl T Delete word right Table 2 continued Key Action Ctrl Y Delete from cursor to right Ins or ctrl V Insert mode Enter A Commit Esc Exit without changes F10 Save 3 3 3 Browse scre n The browse screen appears when data are already entered The browse screen can be use
26. to vlb on obs_nr else copy to vlb endif use vlb erase vla dbf if file vlb ndx erase vlb ndx endif index on obs_nr to vlb close databases annex IV 6 select 2 use veg_rele set filter to area_id user_area set fields to obs_nr surveyor_c surv_bot_c unesvegl_c unesveg2_c unesveg3_c unesveg4_c unesveg5_c unesveg6_c date if file v2a dbf erase v2a dbf endif if file v2b dbf erase v2b dbf endif GO 1 copy to v2a use v2a if reccount gt 1 sort on obs_nr to v2b else copy to v2b endif use v2b if file v2b ndx erase v2b ndx endif erase v2a dbf if file v2b ndx erase v2b ndx endif index on obs_nr to v2b close databases select 1 close databases use vlb use v2b in 2 if file v3 dbf erase v3 dbf endif if file v3b dbf erase v3b dbf endif join with B to v3 for a gt obs_nr b gt obs_nr if file v3b dbf erase v3b dbf endif use v3 if reccount gt 1 sort on obs_nr to v3b else annex IV 7 copy to v3b endif close databases use v3b erase v3 erase vlb erase v2b x Start of main report SET PRINT ON last_page _pageno n_rec_stru reccount rec_stru 1 last_obs_nr 1 do while rec_stru lt n_rec_stru go rec_stru if last_obs_nr lt gt obs_nr store unesvegl_c unesveg2_c unesveg3_c unesveg4_c unesveg5_c unesveg6_c to unesco do rel_header with surveyor_c surv_bot_c unesco date obs_nr do layer_header last_obs_nr obs_nr endif do while rec_stru lt n_re
27. 0 number irrelevant Cover about 50 number irrelevant Cover about 60 number irrelevant Cover about 70 number irrelevant Cover about 80 number irrelevant Cover about 90 number irrelevant 0 Cover about 100 number irrelevant First growth form Others to be established at location AF Acaulescent fern AH Aphyllous herb AT Aphyllous tree casuarina AV Aphyllous vine BH Broadleaf herb forb BL Broadleaf hana BS Broadleaf shrub BV Broadleaf vine CB Climbing bamboo CF Climbing fern CH Cushion herb DT Deciduous broadleaf tree ET Evergreen broadleaf tree FE Ferm epiphyte GA Giant aroid GH Graminoid herb GV Graminoid vine HE Broadleaf herbaceous epiphyte ma OOnNA UM A y N PL Palmoid liana PS Pachycaul scrub PT Pachycaul tree RS Rosette scrub annex I 52 ABUND2_C GRFORM2_C ABUND3_C GRFORM3_C ABUND4_C GRFORM4_C ABUNDS_C GRFORMS_C char 2 char 2 char 2 char 2 char 2 char 2 char 2 char 2 RT Rosette tree pandan SE Scrub epiphyte SF Strangling fig SP Scrub paimoid TB Tufted bamboo TG Tussock graminoid TP Tree palmoid Abundance class second growth form Second growth form Abundance class third growth form Third growth form Abundance class fourth growth form Fourth growth form Abundance class fifth growth form Fifth growth form ANNEX II CODES TABLE H I annex Il 1 UNESCO VEGETATION CLASSIFICATION SELECTED VEGETATION TYPES Source UNESCO 1973
28. 1 47 Entity VEG RELE VEGETATION RELEVEE In this entity vegetation characteristics are recorded This entity contains administrative and general structural attributes and aggregated data such as vegetation classification Attribute AREA_ID OBS_NR DATE SURVEYOR_C SURV_BOT_C RELEVSIZE RELEQUAL_C AERCOVER DENSITY_70 DENSITY_30 DENSITY_10 STEMCOVER VOLUME STRUCREM UNESVEGI_C UNESVEG2_C UNESVEG3_C UNESVEG4_C UNESVEG5 C UNESVEG6_C VEGTYP1_C VEGTY P2_C char 7 number 4 date char 10 char 10 number 4 char 1 char 2 number 5 number 5 number 5 number 3 number 7 1 char 75 char 3 char 1 char 1 char 1 char 3 char 6 char 3 char 3 number 3 number 3 number 3 Description nali i i i n i i i el aaa AG Identification of survey area Sequence number of observation site within survey area Date of observation month day year Surveyor codes to be established on location Local botanist informant Size of vegetation relevee m Quality and intensity of relevee C Relevee complete acc to survey scale I Incomplete relevee compulsory attributes registered no optional attr Q Quick look relevee no attributes registered obs point for groundtruth confirmation only Percentage external foliage cover Number of trees gt 70cm DBH per ha Number of trees gt 30cm DBH per ha Number of trees gt 10cm DBH per ha Stem or basal cover m ha of trees gt 10cm Estim
29. Attribute er rc rr raras SURVEYOR_C SOILTYPE_C SOILTAX1_C SOILTAX2_C SOILTAX3_C FAOSOIL1_C FAOSOIL2_C ORSTOM LOCALSOIL PHASE_C DIAGPROP_C char 7 number 4 date char 10 char 3 char 3 char 4 char 3 char 3 char 3 char 75 char 75 char 2 char 2 Description Identification of survey area Sequence number of observation site within survey area Date of observation month day year Surveyor codes to be established on location Soil type codes to be established on location Classification according to Soil Taxonomy 1987 great group see Annex II for codes Classification according to Soil Taxonomy 1987 subgroup see Annex II for codes Classification according to Soil Taxonomy 1987 family code see Annex II for codes Classification according to FAO Unesco legend soil unit see Annex II for codes Classification according to FAO Unesco legend third level see Annex II for codes Classification according to ORSTOM system codes to be estab lished on location Classification according to local system codes to be established on location Soil phase AN Anthraquic DU Duripan FR Fragipan GE Gelundic GI Gilgai IN Inundic LI Lithic PF Petroferric PH Phreatic PL Placic RU Rudic SA Salic SK Skeletic SO Sodictic TK Takyric YR Yermic Diagnostic properties codes to be established on location annex I 36 annex I 37 Entity MSP SAMP MINERAL SOIL PROFILE SAMPLE
30. C BOUND_UL BOUND_LL BOUNDW_C BOUNDTOP_C HUEDRY_C VALDRY_C CHRDRY_C HUEMOIST_C VALMOIST_C CHRMOIST_C MOTTABUND MOTTSIZ_C MOTTCON_C MOTTSHA_C MOTTHUE_C MOTTVAL_C MOTTCHR_C FO_2_C char 7 number 4 number 2 char 6 number 6 1 number 6 1 char 1 char l char 5 char 3 char 3 char 5 char 3 char 3 number 2 char l char 1 char 1 char 5 char 3 char 3 char 4 Description ii im pi i 4 MALLA INT AA A A a Identification of survey area Sequence number of observation site within survey area Sequence number of layer Horizon designation Mineral soil codes to be established on location Upper boundary of horizon cm below mineral soil surface Lower boundary of horizon cm below mineral soil surface Width of lower boundary of horizon Mineral soil profile A Abrupt lt 2cm C Clear 2 5cm G Gradual 5 12cm D Diffuse 12cm Topography of lower boundary of horizon S Smooth no pockets W Wavy pockets wider than deep I Irregular pockets deeper than wide B Broken boundary discontinuous Hue Munsell scale of dry soil Value Munsell scale of dry soil Chroma Munsell scale of dry soil Hue Munsell scale of moist soil Value Munsell scale of moist soil Chroma Munsell scale of moist soil Abundance of mottles area percentage Size of mottles F Fine lt 5mm M Medium 5 15mm C Coarse gt 15mm Contrast of mottles F Faint D Distinct P Prominent Sharpness of
31. C number 4 number 4 number 4 number 4 number 4 1 char 2 char 2 char 2 char 2 char 3 char 1 char 1 char 1 char 3 char 6 char 8 M Mountainous slopes gt 30 with great range in elevation Lower limit of elevation above sealevel m Upper limit of elevation above sealevel m Lower limit of internal relief m Upper limit of internal relief m Valley density length of valleys drainage lines per unit area Drainage pattern DE Dendritic PA Parallel RA Radial RE Rectangular SD Semi dendritic SP Sub parallel TR Trellised Geological formation codes to be established on location Parent material see Annex II for codes Age of parent material Q Quaternary QH Holocene QP Pleistocene T Tertiary TP Pliocene TM Miocene TO Oligocene TE Eocene TZ Paleecene M Mesozioc MC Cretaceous MJ Jurassic MT Triassic P Paleozoic PP Permian PC Carboniferous PD Devonian PS Silurian PO Ordovician PZ Cambrian Precambrian CP Proterozoic CA Archaean Unesco classification of vegetation partl see Annex Il for codes Unesco classification of vegetation part2 see Annex II for codes Unesco classification of vegetation part3 see Annex II for codes Unesco classification of vegetation part4 see Annex II for codes Unesco classification of vegetation part5 see Annex II for codes Unesco classification of vegetation part6 codes to be established on location Land use classif
32. CNTROFOLINDATA Open the TROFOLIN data file to be modified with USE The structure of the data files can be changed with MODIFY STRUCTURE lt CTRL gt lt N gt is used to insert new fields lt CTRL gt lt U gt to delete fields Save the new structure with lt CTRL gt lt End gt Use Update index option in TROFOLIN DU kh DON 9 3 Delete codes New codes can be added in the CODES menu of TROFOLIN but cannot be deleted For this dBASE needs to be consulted 1 Select the proper directory with SET DIRECTORY TO CATROFOLIN DATA 2 Open the TROFOLIN data file to be modified with USE 3 Mark record for deletion with DELETE lt scope gt FOR lt condition gt WHILE lt condition gt 4 Check result with LIST The records marked for deletion are indicated with an asterix 5 Remove the records that are marked permanently with PACK NOTE Records that are marked for deletion in the active database file can be reinstated with RECALL lt scope gt FOR lt condition gt WHILE lt condition gt 27 9 4 Append data In order to link two TROFOLIN data files of the same entity but with different data together into one the records from one data file source file can be copied to the end of the active data file target file 1 Select the proper directory with SET DIRECTORY TO CATROFOLIN DATA 2 Open one of the data files target file with USE 3 Add records from source data file with APPEND FROM lt source file gt Specific
33. Clay fraction 99 FO 2 WD Water dispersable clay fraction F2 20 Fine silt fraction 7o F20 50 Silt fraction F2 50 Total silt fraction Jo F50 100 Very fine sand fraction F100 250 Fine sand fraction F250 500 Medium sand fraction f F500 1000 Coarse sand fraction 9o F1000 2000 Very coarse sand fraction F50 2000 Total sand fraction Jo PHH PH H O 1 2 5 susp PHK PH KCL 1 2 5 susp PHC PH CaCL 1 2 5 susp EC 2 5 Electrical conductivity 1 2 5 susp ECE Electrical conductivity saturation extract OC Organic Carbon Walkley and Black OM Organic Matter 2 x OC N Total N Kjeldahl C N C N ratio C org N CA Exch Ca AAS MG Exch Mg AAS NA Exch Na Flame Emission Spect K Exch K Flame Emission Spect AL Exch Al AAS H Exch H IM KCL tit CEC Cation Exch Cap at PH 7 NH4AC ECEC Effect CEC Sum Exch Bases Acidity at pH soil BSAT Base saturation Sum Exch Bases ECEC 100 CACO3 CaC03 eq titr exc acid ESP Exch Sodium Perc Exch Na ETEC 100 PAB Available Phosphorus Bray surtz PAO Available Phosphorus Olsen Date of analysis month day year Laboratory identification codes to be established on location Value for a chemical analysis annex I 28 annex I 29 Entity MSP LAY MINERAL SOIL PROFILE LAYER An exhaustive list of soil horizon attributes is incorporated in this entity Atwibute AREA_ID OBS_NR LAYER_NR HORIZMSP_
34. EN_UL number 4 Upper limit of slope length m LOPARENT_C char 2 Local parent material see Annex II for codes FLOODREM char 75 Remarks on flooding or indications of flooding FLOODW EC number 5 2 Electric conductivity of floodwater mS cm SURFDRAI_C char 1 Surface drainage class P Ponded arca waterlogged for more than one month S Slow waterlogging not more than one month M Medium no waterlogging for more than 48 hours annex I 42 INFILCAP PERMEA PERMEA_LL PERMEA_UL PERMEA_C SOILDRAI_C SOILDRY_LL SOILMOI_LL SOILWET_LL GRWLEV_C GRW DEPTH GRWDEP LL GRWDEP UL GRW EC GRWORIG C STONECOVER STONEDIST STONESI LL STONESI UL STONENAT_C STONEORI_C ROCKCOVER ROCKDIST HEIGHTVAR HEIGHTV_LL HEIGHTV_UL LATERVAR LATERV_LL LATERV_UL MORPHO_C number 4 number 4 1 number 4 1 number 4 1 char 1 char 1 number 3 number 3 number 3 char 2 number 3 number 3 number 3 number 6 char 1 number 3 number 4 1 number 4 1 number 4 1 char 2 char 2 number 3 number 3 number 3 number 3 number 3 number 3 number 3 number 3 char 1 R Rapid excessive water drains rapidly even with heavy rains A Very rapid soil cannot ensure topsoil moisture for seed germination Infiltration capacity mm h Measured value of permeability Lowest measured value of permeability cm h Highest measured value of permeability cm h Estimated permeability class S Slow lt 0 5cm h M
35. G_LAY AUGERING LAYER The list of attributes is identical to the one of MSP_LAY except for attributes related to structure and cutans Most soil characteristics are described with lower accuracy than in a profile pit Attribute AREA_I OBS_NR LAYER_NR HORIZAUG_C BOUND_UL BOUND_LL BOUNDWI_C BOUNDTOP_C HUEDRY_C VALDRY_C CHRDRY_C HUEMOIST_C VALMOIST_C CHRMOIST_C MOTTABUND MOTTSIZ_C MOTTCON_C MOTTSHA_C MOTTHUE_C MOTTVAL_C MOTTCHR_C FO_2_C Type char 7 number 4 number 2 char 6 number 6 1 number 6 1 char 1 char 1 char 5 char 3 char 3 char 5 char 3 char 3 number 2 char 1 char 1 char 1 char 5 char 3 char 3 char 4 Description Identification of survey area Sequence number of observation site within survey area Sequence number of layer Horizon designation Augering layer codes to be established on location Upper boundary of horizon cm below mineral soil surface Lower boundary of horizon cm below mineral soil surface Width of lower boundary of horizon Augering layer A Abrupt lt 2cm C Clear 2 5cm G Gradual 5 12cm D Diffuse gt 12cm Topography of lower boundary of horizon S Smooth no pockets W Wavy pockeis wider than deep I Irregular pockets deeper than wide B Broken boundary discontinuous Hue Munsell scale of dry soil Value Munsell scale of dry soil Chroma Munsell scale of dry soil Hue Munsell scale of moist soil
36. IMZON3_c photosyl _c photosy2 c landform c relief c eleva Ileleva ul 9 tt e tt tt 7 no LAND MAPPING UNIT LMU PICTURE 99 AREA ID user_area 9 LR SORA IN het MENTE Ta IA SONE E tt 9 tt tf Photosymbol PHOTOSY1_C PHOTOSY2_C annex IV 15 Climatic zone CLIMZON1_C CLIMZON2_C CLIMZON3_C Landform LANDFORM C Relief RELIEF C Elevation ELEVA LL ELEVA_UL mn 9 mn 7 et tt Observation site information 9 mont Obs X coor Y coor Site Att Veg Rel Land use Humus Mineral Auger 9 i ae REE ON A EOE A E EO E E RETURN procedure obs parameters obs nr xcoor vcoor siteatt I vegrel LI use lhp pit l msp pit 1 auger l 2 obs nr picture 99 xcoor at 3 ycoor at 16 f SITEATT_L Yes No at 27 lif VEGREL_L Yes No at 37 lif L_USE_L Yes No at 47 f HP_PIT_L Yes No at 57 1f MSP_PIT_L Yes No at 64 if AUGER_L Yes No at 73 return annex IV 16 3 b Report Output LAND MAPPING UNIT 10 AREA ID Photosymboli 1693 F23v Climatic zone ER Lanaform LU Relief R S evation 480 660 Observation site information Obs X coor Y coor Site Att BIPINDI i n pp Cc gt MAaez2Ncupcu rrrofi_ _m gt Veg Rel Land use No Yes Yes No Yes Yes Yes Yes No Humus Mineral WE a AG aim o o ee A eee annex IV 17
37. LATION OF TROFOLIN TROFOLIN requires the following hardware and software a Personal Computer with MS DOS PC DOS or DR DOS 640 KB intemal memory 512 KB is also possible but the speed will be lower a Hard Disk with at least 2 MB free Hercules VGA CGA or EGA graphics card files 30 or more in config sys parallel printer Installation of TROFOLIN on the hard disk Insert the installation disk into drive A or B Type A or B and press lt enter gt Type install A or B C and press lt enter gt TROFOLIN will now be installed on the hard disk The system files are located in a TROFOLIN directory while the data files are installed in a subdirectory TROFOLIN DATA CAUTION KEEP ALWAYS A BACKUP OF BOTH SYSTEM AND DATA FILES NOTE If any problem with the installation is encountered please contact W Andriesse A K Bregt or Y van Randen of the Winand Staring Centre Phone 31 8370 74200 Fax 31 8370 24812 Telex 75230 visi nl 3 THE TROFOLIN APPLICATION 3 1 Getting started Follow these steps to start TROFOLIN Type CD TROFOLIN at the C 5 prompt and press lt enter gt The TROFOLIN directory is now active The programme is started by typing TROFOLIN and pressing lt enter gt The main menu will appear on the screen Figure 1 This menu contains six options which can be selected with the cursor keys or by striking their first letter The INFO option provides general information
38. MH CALAORNA ROTAN SE 2 E 15 0 VL ME STERCOCC HANAPBUU 2 E 10 0 VL MH NEONCALY CANGCARA es E 15 0 V LMH PIPER S KARU 2r JE 20 0 BLMH CINNSINT KITEJA 2 E 15 0 amp LM H DRYPRHAC KIBOLEND 2 E 20 0 VLMH MELINITI KIGONYOR 2 E 15 0 VLMH EURYACUM KUHKURAN 2 E 25 0 V LMH CISSDIFF AR KROKO 2 E 15 0 VLMH GARCROST KIMENYAN 2 F 20 0 VLMH MANGODOR MANGGA G 2 F 20 0 F LMH CYATJUNG PAKUHAGI 2 M 25 0 V LMH ARENOBTU LANGKAP 2 E 20 0 V LMH DRYPLONG KITULANG 2 E 15 0 Vib MH DIOSFRUT KISIRI 2 1 25 0 BLMH IXORGRAN 3 2 6 0 V LMH FREYSPEC AR HARAS 95 JE 8 0 7 MH LASIHIRS JALATONG 3 E 3 0 VLMH XANTFRUT REUREUND 3 JB 5 0 V LMH LASIRETI KIREGAS 5 LE 4 0 VLMH PLEOSPEC HANJUANG SA 9 0 V LMH CALAJAVE ROTANCAC ji 670 V LMH PANDNITI HARASHAS 3 oE 4 0 V LMH LABIPUMI BABAKOAN E E 6 0 VLMH LICUGRAC SADANGGU a d 6 0 F LMH PHYLEASS KINERENG 3 M 2 0 V LMH STENPALU PAKUHURA 3 JE 4 0 VLMH AMORVARI ACUNG 4 E 0 7 V LMH TECTVAST KADAKA d F 0 5 V LMH LATNAME LOCNAME FIELDNAME LAY AB HEIGHT pr SCHICALO CORTE ILC AP AMTOME SELAG S2 HOMACORD PHRYPUBT AMOMACUL SENTE R KROKOT KUTAK PAKURANE CAR IANG PATAT PARAHULU annex IV 11 annex IV 12 annex IV 13 EXAMPLE 3 I AND MAPPING UNITS OBSERVATION SITES 3 a Programme set talk off close databases Display for each Land Mapping Unit all the observation sites store getenv trofodata to trofdir if len trofdir 0 9 tt ott Environment variable TROFODATA not
39. MU NR AREA ID OBS NR la i E SITE_ VEGETATION_ ELEMENT LAND USE HP PIT AUGERING DESCRIPTION RELEVEE T AREA ID LMU NR LE NR AREA ID OBS NR AREA ID OBS NR AREA ID OBS NR AREA ID OBS NR d L MI j Bi BI i h LU SUB VEGETATION VEGETATION_ HP_PIT MSP_PIT MSP_ AUGERING_ ELEMENT STRUCTURE SPECIES LAYER LAYER SAMPLE LAYER AREA ID OBS NR SAMPDEP UL AREA D OBS NR SAMPDEP_ UL RE entity AREA_ID OBS NR key attribute HP_ MSP_ ANALYSIS ANALYSIS relation 1 1 I relation 1 n I I Figure 2 Datamodel TROFOLIN The structure of the database is also displayed in the database menu An example of this menu is presented in Figure 3 mera von rr ____ __rrem ee e gt rtrr_rrorrrr_rrreee rrrrrrrorr e r _ LL i A EL SEL LP FIA Database System i Survev area f limate Land mapping u bservation si observation site ob iia n cos si Site descr ipt ion A ae Vegetation releveeli Vegetation relevee Land use l Vegetation structure Humus profile pit Vegetation species ineral soil AA nn ET LI Figure 3 Example of DATABASE menu At the highest first level of TROFOLIN the entity survey area SUR_AREA is distinguished Within a Tropenbos location one or more survey areas may be distinguished each with a unique identification AREA_ID Each record has to be recognized as a record of a s
40. Moderate 0 5 15cm h R Rapid gt 15cm h Internal soil drainage class Very poorly drained Poorly drained Imperfectly drained Moderately well drained Well drained Somewhat excessively drained Excessively drained Lower limit of dry soil depth below surface cm Lower limit of moist soil depth below surface cm Lower limit of wet soil depth below surface cm Groundwater level class PD Always deeper than 200cm below surface TN Temporarily 100 200cm below surface PN Permanently 100 200cm below surface TH Temporarily less than 100cm below surface PH Permanently less than 100cm below surface DM Mottling deeper than 100cm below surface MM Mottling between 50 and 100cm below surface SM Mottling within 50cm below surface Groundwater table measured depth below surface cm Lowest groundwater table estim depth below surface cm Highest groundwater table estim depth below surface cm Electric conductivity of groundwater mS cm Groundwater origin MABE VC P Perched R Real S Seepage Estimated cover percentage of surface stones Estimated average distance of surface stones Minimum diameter of commonest surface stones cm Maximum diameter of commonest surface stones cm Nature of surface stones see Annex II for codes Origin of surface stones codes to be established on location Estimated cover percentage of rock outcrops Estimated average distance of rock outcrops m Micro relief Micro relief Micro relief
41. ON2_C and CLIMZON3_C This 1s the case for all the related attributes that share one CODE_TAB 3 Choose the next menu option Attribute Value definitions This screen displays REF_TAB2 that contains the codes values for coded attributes Enter the name CLIMZONE_C under CO_NAME If no codes are available for this attribute an edit screen will appear otherwise a browse screen If the browse screen appears one can go to the edit screen by pressing A dd see Figure 8 CLIMZONE C TROP_CODE TROP_DESC DEFINITION USER_CODE USER_DESC SEQUENCE Code used by tropenbos as reference within a codename Figure 8 Attribute Value definitions edit screen 4 The climate code I can be entered in TROP_CODE TROP_DESC gives a short description of the code value in this example humid DEFINITION can be used to specify the code value in more detail In this example r Eo ratio gt 0 80 should be entered All can be saved by pressing F10 USER_CODE and USER_DESC can be used when it is required to translate the attribute definitions into another language By selecting T ranslate in the R eport option in the DATABASE mode the value of the attribute will be described in the defined language see 4 3 3 However switching language in the pick lists attribute descriptions is not possible With SEQUENCE codes can be sorted so that they appear in the pick lists in the order that is required Without using the SEQUENCE attribute codes
42. Pachic Ultic Paleorthidic Paleustollic Palexerollic Paralithic Vertic Pergelic Pergelic Ruptic Histic Pergelic Sideric Petrocalcic Petrocalcic Ustalfic Petrocalcic Ustollic Petrocalcic Xerollic Petrofertic Petroferric Rhodic Petrogypsic PK PKIO PK12 PL PL04 PL06 PS PS02 PS04 PS06 PS08 PS09 PS10 Placic Plaggeptic Plaggic Plinthaquic Plinthic Plinthudic Psammaquentic Psammentic Psammentic Kandic Psammentic Rhodic Psammentic Kandic Rhodic Psammentic Ustollic Psammentic Ustalfic Quartzipsammentic Rendollic Rhodic Ruptic Alfic Ruptic Lithic Ruptic Lithic Entic Ruptic Lithic Xerochreptic Ruptic Ultic Ruptic Vertic Salorthidic Sapric Sapric Terric Sidfric Sombric Sombrihumic Sphagnic Sphagnic Terric Spodic Sulfic Terric Thapto Histic Thapto Histic Tropic Torrertic Torrifluventic Torriorthentic Torripsammentic Torroxic annex II 19 TR Tropaquodic TRO2 Tropeptic TR04 Tropic UD Udertic UDO1 Udalfic UDO2 Udic UD03 Udollic UD05 Udorthentic UD10 Udoxic UL Ultic UM Umbreptic UMO2 Umbric US Ustalfic US02 Usteric US04 Ustic US06 Ustochreptic US08 Ustollic US12 Ustoxic VE Vermic VEO2 Vertic XA Xanthic XE Xeralfic XE03 Xerertic XE04 Xeric XE08 Xerollic annex II 20 annex II 21 TABLE IH 7 CLASSIFICATION ACCORDING TO SOIL TAXONOMY Source Soil Survey Staff 1987 ATTRIBUTE SOILTAX3_C 03 allitic 27 illitic calcareous 05 carbonatic 28 kaolinitic 08
43. R Argiboroll MBV Vermiboroll MDA Hapludoll MDB Paleudoll MDR Argiudoll MDV Vermudoll MQA Haplaquoll MQC Cryaquoll MQD Duraquoll MQK Calciaquoll MQN Natraquoll MQR Argiaquoll MR Rendoll MUA Haplustoll MUB Paleustoll MUD Durustoll MUK Calciustoll MUN Natrustoll MUR Argiustoll MUV Vermustoll MWN _ Natralboll MWR Argialboll MXA Haploxeroll MXD Durixeroll MXK Calcixeroll MXN Natrixeroll MXP Palexeroll MXR Argixeroll ODA Hapludox ODC Acrudox ODE Eutrudox ODK Kandiudox ODS Sombriudox OPA Haploperox OPC Acroperox OPE Eutroperox OPK Kandiperox OPS Sombriperox OQA Haplaquox OQC Acraquox OQE Eutraquox OQL Plinthaquox OTA Haplotorrox OTC Acritorrox OTE Eutrotorrox OUA Haplustox OUC Acrustox OUE Eutrustox OUK Kandiustox OUS Sombriustox SHA Haplohumod SHC Cryohumod SHF Fragihumod SHP Placohumod SHT Tropohumod SI Ferrod SOA Haplorthod SOC Cryorthod SOF Fragiorthod SOP Placorthod SOT Troporthod SQA Haplaquod SQC Cryaquod SQD Duraquod SQF Fragiaquod SQP Placaquod SQS Sideraquod SQT Tropaquod UDA Hapludult UDB Paleudult UDF Fragiudult UDL Plinthudult UDR Rhodudult UHA Haplohumult UHB Palehumult UHH UHK UHL UHS UQB UQF UQK UQL UQM UQO UQW UUA UUB UUH UUK UUL UUR UXA Kandihaplohumult Kandihumult Plinthohumult Sombrihumult Paleaquult Fragiaquult Kandiaquult Plinthaquult Umbraquult Ochraquult Albaquult Haplustult Paleustult Kandihaplustult Kandiustult Plinthustult Rhodustult Hap
44. R Well identifiable litter fragments with minor amounts of organic material FM About equal amounts of more or less fragmented litter and finely divided organic material H Humus horizon HR Fine organic material dominant with some litter fragments HF Fine organic material dominant no litter fragments mineral grains are present AL Upper mineral horizon ALI Upper part of the A horizon with a dark colour due to the presence of organic material with a loose structure ALV Lower part of the A horizon moderately or slightly col oured by organic material and with a more compact struc lure BOUNDHP UL number 6 1 Upper boundary of horizon cm above mineral soil surface BOUNDHP LL number 6 1 Lower boundary of horizon cm above mineral soil surface BOUNDWID_C char 1 Width of lower boundary of horizon Humus profile layer A Abrupt lt 0 5cm C Clear 0 5 1 0cm G Gradual 1 0 2 0cm D Diffuse gt 2 0cm BOUNDTOP_C char 1 Topography of lower boundary of horizon S Smooth no pockets W Wavy pockets wider than deep I Irregular pockets deeper than wid B Broken boundary discontinuous MOISTURE_C char 1 Moisture status X Dessicated D Dry M Moist W Wet S Saturated HUE_C char 5 Hue Munsell scale at moisture status at time of description VALUE_C char 3 Value Munsell scale at moisture status at time of description CHROMA_C char 3 Chroma Munsell scale at moisture status at time of description HUEWET_C char 5 Hue
45. SE Some progamming examples are given in annex IV First three options can be selected in R eport T otal All records of the selected entity also those records that belong to an other AREA_ID will be reported The number of this total amount of records 1s shown here V lew All records of the selected entity within the presently active AREA_ID will be reported The number of these records within the survey area 1s given C ancel To return to the browse screen After selection of T otal or V iew three options are displayed T ranslate To translate codes and codes descriptions to another language 15 This option should only be used if USER_CODE and USER_DESC have been specified under CODES of the main menu see 5 2 N o Translation To describe codes in English as defined by the TROFOLIN application C ancel To return to the browse screen Finally the selection 1s made how to display the data F ile To send the list of records to a text file TROFOLIN creates a file with extension pm It is possible to use any text editor or word processor to open and edit this file P rint To send the list of records to a printer A printer should be connected to the system If the printer is not connected the message the printer is not ready Retry Y es N o will appear on the screen S creen To send the list of records to the screen option only access ible in the V iew option The maximum number of records that
46. a ESC Hi Figure 4 Example of an input and edit screen In the first part box at the top of the screen the key attributes e g AREA ID GUY and the name of the entity SITEDESC are given In the second part central part of the screen the attribute names and their input fields are displayed Usually not all of the entities attributes can be displayed on one screen The characters PGDN at the bottom of the screen indicate that there 12 are other attributes waiting o be described By pressing lt page down gt one will retrieve a next screen with more attributes see para 3 3 2 for navigation Four different types of attributes are distinguished numerical logical coded and remark attributes 1 Numerical attributes require figures as input These attributes have the value 0 as default CAUTION TROFOLIN always generates 0 as default for numerical attributes alike dBASE Therefore it is not possible to distinguish attributes which have a real 0 value from those for which data are lacking Confusion can be avoided by entering another value for the default e g a negative value or an unreal value such as 9999 2 Logical attributes attribute name with _L extension require yes Y or no N as input These attributes have the value N as default 3 Coded attributes attribute name with _C extension require a code as input Most of the codes are already pre defined in TROFOLIN see para 6 1 and Annexes I and II Thes
47. actices EN Ext grazing in natural or derived forest ecosystems IG Int grazing on grassl ext bush fallow agricult pract IP Int grazing on pasture land Rem on grazing practices type of animal number of animals ha Burning practices N No burning l Incidental S Intentional Remarks on burning practices reason extent frequency and impact annex I 25 Entity LU SUBEL LAND USE SUB ELEMENT Land use sub elements are described in terms of land use attributes which are grouped into the broad categories of produce tangible and non tangible technology and management aspects Attributes listed are comparable to the attributes listed under the entity LANDUSE Under the latter entity observation point data are stored while under the present entity aggregated land use data are stored Attribute Type Description AREA_ID char 7 Identification of survey area LMU_NR number 3 Sequence number of Land Mapping Unit LE_NR number 2 Scquence number of Land Element within Land Mapping Unit SUBEL_NR number 1 Sequence number of land use sub element within Land Element PERC_LE number 3 Percentage of Land Element LANDUSE_C char 8 Land use type codes to be established on location PRODUCT1_C char 3 First type of production benefits amenities F Fruits fibres resins etc G Game fish L Grazing browse for livestock A Agricultural products O Land under fallow W Wood products C Conservation R Recreation X Combination of above categor
48. alter de Gruyter Co Berlin Germany MEIJERINK A M J 1988 Data acquisition and data capture through terrain mapping units TC Journal 1988 1 23 44 SOIL SURVEY STAFF 1987 Keys to Soil Taxonomy third printing SMSS Technical Monograph 6 Comell University Ithaca USA TOUBER L E M A SMALING W ANDRIESSE and R T A HAKKELING 1989 Inventory and evaluation of tropical forest land Guidelines for a common methodology Tropenbos Technical Series 4 Tropenbos Ede The Netherlands UNESCO 1973 International classification and mapping of vegetation Ecology Conservation 6 Unesco Paris France WAVEREN VAN E J AND A B BOS 1988 ISRIC Soil Information System User Manual and Technical Manual Revised Edition Technical Paper no 15 ISRIC Wageningen The Netherlands 31 ANNEX I ENTITIES AND ATTRIBUTE DESCRIPTIONS in alphabetical order Entity AUGERING annex I 1 Augerings are recognized as a separate entity because of the different interpretation value of data collected from augerings as compared to profile pits Attribute AREA_ID OBS_NR DATE SURVEYOR_C SOILTYPE_C Type char 7 number 4 date char 10 char 3 a nl C Description Identification of survey area Sequence number of observation site within survey area Date of observation month day year Surveyor codes to be established on location Soil type codes to be established on location annex I 2 annex I 3 Entity AU
49. apping Unit Site attributes Y N Vegetation relevee Y N Landuse relevee Y N Humus profile pit Y N Mineral soil profile pit Y N Augering Y N Description of observation site annex I 40 annex I 41 Entity SITEDESC SITE DESCRIPTION Attributes of an observation site conceming surface form drainage conditions micro relief surface conditions degree of erosion and biological activity are incorporated in this entity Attribute Type Description AREA_ID char 7 Identification of survey area OBS_NR number 4 Sequence number of observation site within survey area DATE date Date of observation month day year SUR VEYOR_C char 10 Surveyor codes to be established on location ALTITUDE number 4 Altitude in meters above sea level POSITION_C char 1 Position in catena T Crest hilltop U Upper slope M Middle slope L Lower slope B Valley bottom EXPO_C char 3 Exposition to point of compass N NNE NE ENE E ESE SE SSE S SSW SW WSW W WNW NW NNW SLOFORM_C char 1 Slope form S Straight V Convex C Concave F Straight segments convex K Straight segments concave Z Convex concave I Irregular O Other SLOGRADIEN number 3 Slope gradient measured value SLOGRAD_LL number 3 Lower limit of slope gradient SLOGRAD_UL number 3 Upper limit of slope gradient SLOLENGTH number 4 Slope length measured or estimated value m SLOLEN_LL number 4 Lower limit of slope length m SLOL
50. ar 1 char 1 number 4 1 number 4 1 number 6 3 char 1 annex I 33 Nature of second type of rock fragments Quantity of first type of concretions N None V Very few 3 Yo F Few 5 15 Q Frequent 15 40 R Very frequent 40 80 D Dominant gt 80 Size of first type of concretions P Powderv diffuse S Small lt lcm L Large gt 1cm Hardness of first type of concretions H Hard S Soft Shape of first type of concretions A Angular I Irregular S Spherical Nature of first type of concretions C Argillaceous F Ferruginous K Calcareous M Manganiferous Q Siliceous Y Gypsiferous Z Saline Quantity of second type of concretions Size of second type of concretions Hardness of second type of concretions Shape of second type of concretions Nature of second type of concretions Content of carbonates intensity of reaction to HCL 10 N Non calcareous no reaction visible S Slightly calcareous slight reaction R Calcareous strong reaction V Strongly calcareous violent reaction Location of carbonates C In pores rootchannels and holes L Locally N On nodules O On coarse fragments S On ped faces T Throughout pH H 0 pH KCL Electric conductivity mS cm Sample taken Y N annex I 34 annex I 35 Entity MSP_PIT MINERAL SOIL PROFILE PIT Mineral soil profiles are described in detail in MSP_LAY mineral soil profile layer This entity contains attributes conceming soil classification
51. ard Presence of crusting N Unslaked P Partly slaked S Slaked C Capped Nature of crusting CA Crust by algae CO Crust of slaked overwash SS Sealing in denuded subsurface horizon Thickness of crusting mm Percentage of area covered with termite mounds Percentage of area covered with ant heaps Remarks on size form colour of termite mounds and ant heaps Estimated minimum percentage of surface affected by sheet erosion Estimated maximum percentage of surface affected by sheet erosion Estimated minimum percentage of surface affected by rill erosion Estimated maximum percentage of surface affected by rill erosion Estimated minimum percentage of surface affected by gully erosion Estimated maximum percentage of surface affected by gully erosion Slope stability and mass wasting N Stable surface not affected U Locally unstable 0 5 affected M Moderately unstable 5 20 affected H Highly unstable gt 20 surface affected Estimated minimum percentage of area with recent water erosion products Estimated maximum percentage of area with recent water erosion products Average thickness of humus profile Minimum thickness o humus profile Maximum thickness of humus profile Average thickness of solum cm Minimum thickness of solum cm Maximum thickness of solum cm Average depth of hardpan cm Minimum depth of hardpan cm Maximum depth of hardpan cm Type of hardpan C Clay pan F Fragipan D Duripan K Petrocalc
52. arenic Petroferric GRO6 Grossarenic Petroferric Rhodic GR07 Grossarenic Kandic GRO8 Grossarenic Kandic Rhodic GR09 Grossarenic Kanhaplic GR10 Grossarenic Kanhaplic Rhodic GR11 Grossarenic Rhodic GR12 Grossarenic Petrocalcic GR13 Grossarenic Ustollic GR14 Grossarenic Ustalfic GR15 Grossarenic Aridic HA Haplaquodic HAOI Haplaquic HA02 Haplic HAOS Haplohumic HA07 Haploxerollic HA09 Hapludic HA12 Hapludollic HA16 Haplustollic HE Hemic HEO2 Hemic Terric HI Histic HI02 Histic Lithic HIO6 Histic Pergelic HU HUO2 HUOS HU06 HU10 HU15 HU20 HY HY02 IN KA KA02 KA04 KH LE LI LIO2 LIO3 LIO4 LIOS LI06 LI07 LI08 LIO9 LI10 Ln 1 Ln2 Ln 3 LI14 LIIS LI16 LI18 LI20 LI22 LI24 MO NA06 OC OR ORO1 ORO2 PA Humic Humic Lithic Humic Pergelic Humoxic Humaqueptic Humic Rhodic Humic Xanthic Hydric Hydric Lithic Inceptic Kandicic Kandiudalfic Kandiustalfic Kanhaplic Leptic Limnic Lithic Lithic Petrocalcic Lithic Mollic Lithic Pergelic Lithic Ruptic Alfic 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 PA02 Pachic Udic PAQA PA06 PA08 PAIO PA20 PE PEOI PEO2 PEO4 PEO6 PE08 PE14 PE16 PE17 PE20
53. atabase Codes Export System Quit be eee u E a panon di i Pack Database Backup Database i Restore Database Update Index res Swan ran na vem el Delete records marked as deleted Figure 10 SYSTEM menu 7 1 Pack Database This option permanently removes all records n the database which are marked for deletion through the delete option in the browse screen see 4 3 2 Once this command is used data cannot be retrieved Additionally this option will update each of the indexes see para 7 4 NOTE The pack database option will start immediately after pressing lt enter gt 7 2 Backup Database This option creates a copy of all data files in the TROFOLIN DATA directory to diskette If this option is activated it has to be confirmed whether one wants to P roceed or C ancel the procedure After proceeding the drive has to be selected to which the data files are to be saved Again the question appears whether to P roceed or C ancel the procedure 7 3 Restore Database This option transfers data files from diskette to the hard disk in the TROFOLIN directory from a backup see Backup Database 23 CAUTION By using the restore database option all the existing data files in the TROFOLIN directory will be overwritten See also para 9 3 7 4 Update Index Index files NTX control the sequence of datafile fields numerically alphabetically chronologically The Update Index option rearranges the logi
54. ated volume of timber m ha Remarks on stucture of vegetation Unesco classification of vegetation part1 see Annex II for codes Unesco classification of vegetation part2 see Annex II for codes Unesco classification of vegetation part3 see Annex II for codes Unesco classification of vegetation part4 see Annex II for codes Unesco classification of vegetation part5 see Annex II for codes Unesco classification of vegetation part6 codes to be established on location Vegetation type structural local typification codes to be estab lished on location Vegetation type floristic local typification codes to be established on location Species richness number of Families represented Species richness number of Genera represented Species richness number of Species represented annex l 48 annex I 49 Entity VEG SPEC VEGETATION SPECIES This entity records the species at a relevee These are described in terms of abundance height volume stage age vitality and use Attribute Type Description AREA_ID char 7 Identification of survey area OBS_NR number 4 Sequence number of observation site within survey area NAME_NR number 4 Sequence number of species within this Vegetation Relevee FIELDNAME char 16 Provisional species name for survey purpose only NAME_REM char 60 Remark on species LATNAME char 9 Scientific name of species abbrev genus 4 1 spec 4 LOCNAME char 8 Local indigenous name of species LAYER_NR numb
55. c_stru and last_obs_nr obs_nr do layer with layer nr height_av cover abund1_c grform1_c abund2_c grform2_c abund3_c grform3_c abund4_c grform4_c abund5 c grform5 c rec stru rec_stru 1 if rec stru lt n_rec_stru goto rec stru endif enddo do species with last obs nr select 1 enddo set print off close databases procedure rel header parameters surveyor surv bot c unesco date obs nr 9 non 9 11 et VEGETATION RELEVEE FOR OBS SITE AT1 OBS_NR AT 36 PICTURE 99 AREA AT 40 USER AREA AT 47 annex IV 8 AUTHOR at 1 SURVEYOR at 12 BOTANIST at 1 SURV_BOT_C at 12 DATE at 1 DATE at 12 ttt tue retum procedure layer_header it zer ISTGF 2NDGF LAYER HEIGHT COVER TY AB TY AB RIA taa A TEO TEE EEE AAA retum procedure layer parameters layer nr height av cover abundl c grforml c abund2 c grform2 c abund3 c grform3 c abund4 c grformd c abund5_c grform5_c Layer_nr atl picture 99 height_av at5 picture 999 9 cover at 13 picture 999 abundl_c at 23 picture 99 grforml_c at 20 picture 99 abund2_c at 33 picture 99 grform2_c at 30 picture 99 abund3_c at43 picture 99 grform3_c at 40 picture 99 abund4_c at 53 picture 99 grform4_c at 50 picture 99 abund5 c at 63 picture 99 grform5 c at 60 picture 99 return procedure species parameter 1 obs nr select 2 use veg spec set filter to obs nr
56. cal sequences of the database after deleting or adding parts and should always be used when data are altered outside the TROFOLIN application e g through dBASE CAUTION In case key aitributes are changed outside TROFOLIN the update index option will not guarantee that the database will remain consistent 24 8 QUIT The QUIT option offers the possibility to exit the TROFOLIN application and retum to MS DOS er rr Lo LET REALE PP IP AA er Info Database Codes Figure 11 QUIT menu Select Y es and press lt enter gt Do not quit return to program System 25 26 9 TECHNICAL NOTES ON DBASE 9 1 General TROFOLIN primarily offers sufficient options for storage of data For the manipulation and selection of data for a sophisticated output of compiled reports and for modifications of the database it will be necessary to use dBASE Some user experience with dBASE is required This chapter briefly describes methods to solve certain problems but is by no means complete It should only be used in addition to the dBASE manual CAUTION Be always sure that you have an up to date backup of all files concerned 9 2 Change structure of data files Attributes fields can be deleted or added to entities data files It should be stressed that changing key attributes should be avoided Always use the Update Index option in TROFOLIN after changing the structure Select the proper directory with SET DIRECTORY TO
57. comparability of data and results from different research sites it was decided to develop a standard database fOr storage of physical and biotic data at the individual sites The database development was carried out by QRay Agrimathica Veenendaal in cooperation with the Winand Staring Centre Wageningen with financial support from the Tropenbos Foundation Wageningen The datamodel that underlies the database is described in the Winand Staring Centre Report Datamodel for tropical fOrest land inventory at reconnaissance level Gesink et al 1990 which in tum was based on the Tropenbos Technical Series 4 Touber et al 1989 In the development schedule of the database a field testing phase was included in which the prototype database was tested at the individual research sites The results of this testing phase were incorporated The present TROFOLIN Database User Manual provides guidelines on the installation of the database at the user s Personal Computer as well as a step by step explanation on its actual functions options and operation In addition the manual offers some guidelines to work with TROFOLIN data through the database package dBASE versions II or IV Ashton Tate In its final form the TROFOLIN database 1s primarily a tool for the storage of data Manipulation and selection of data is not possible within TROFOLIN but can be carried out with dBASE with which the TROFOLIN data files are fully compatible 2 INSTAL
58. coor ycoor AREA ID continue enddo 2 tt 11 2 tf tt P precipitation PET potential evapotranspiration at 2 2 T temperature Tmax maximum day temperature at 2 2 Tmin minimum day temperature Hum relative air humidity at 2 I hours of sunshine at 2 set printer off annex IV 2 set console on clear retum procedure print_record parameters jan feb mar apr mav jun jul aug sep oct nov dec climdata_c station_c beginperio endperiod xcoor ycoor area_id if station_c lt gt last_station do page_header with station_c xcoor ycoor AREA_ID last_station station_c endif climdata c at 2 jan at 7 picture 999 feb at 12 picture 999 mar at 17 picture 999 apr at 22 picture 999 may at 27 picture 999 jun at 32 picture 999 jul at 37 picture 999 aug at 42 picture 999 sep at 47 picture 999 oct at 52 picture 999 NOV at 57 picture 999 dec at 62 picture 999 mod beginperio 100 at 67 picture 99 at 70 mod endperiod 1 00 at 71 picture 99 retum procedure page_header parameters station_c xcoor ycoor area_id Day D aD a Station at 1 station_c at 10 y at 20 xcoor at 22 su at 34 ycoor at 36 AREA ID AT 60 AREA ID gun Type Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Per retum 1 b Report Output Station 3 Type Jan HUM 77 E 161 P 31 PET 95 T 23 TMAX 30 TMIN 17 reb Mar
59. coprogenous 30 marly 09 chloritic 32 micaceous 10 diatomaceous 34 mixed 12 ferrihumic 35 mixed calcareous 14 ferritic 37 montmorrilonitic 16 ferruginous 38 montmorrilonitic calcareous 18 gibbsitic 40 oxidic 20 glauconitic 44 serpentinitic 22 gypsic 46 siliceous 24 halloysitic 48 sesquic 26 illitic 50 vermiculitic annex II 22 ANNEX HI EXAMPLE OF A TROFOLIN DATA REPORT MSP_LAY Record nr AREA_ID OBS WR LAYER NR 4CRIZMSP C SOUND UL BOUND LL BOUNDW C BCUNDTCP C HUEDRY C VALDRY C CHRDRY_C HUEMOIST C VALMOIST C CHRMOIST C MOTTABUND MOTTSIZ C MOTTCON_C MOTTSHA C MOTTHUE_C MOTTVAL C MOTTCHR_C 0 2 E Ve F75_250 C F250 C CONSDRY_C CONSMOI_C STICKY C PLASTIC C SMEARY_C STRUCGR1 C STRUCSILC STRUCTY1 C STRUCGR2_C STRUCSI2_C STRUCTY2_C STRUCREL C CUTQUANI C CUTTHIC1 C CUTKIND1 C CUTLOC1 C CUTQUANZ C UTTHIC2 E CUTKIND2_C CUTLOC2 T PORESIZ C POREABU1 C PORESIZ2 C POREABU2 C POROSITY ROOTSIZ1 C ROOTABU1 C ROOTORI1 C ROOTSIZ2 C ROOTABU2 C annex IH 1 BIPINDI 20 ds 3w2 sO 0 Diffuse S Smooth 10YR 5 6 LOYR 6 8 l SS 9 D SACL Sandy clay loam SG Slightly gravelly NS No stones NB No boulders SH Slightly hard ER Eriable S Sticky P Plastic SS Strongly smeary MC Structureless moderately coherent PM Porous massive Patchy Thin faint Iron oxide O In voids pores lt S ng raj ty
60. d for data viewing and reporting Table 3 Navigation in browse screen Key Action Right arrow or ctrl S Left arrow or ctrl D Move to next data column attribute Down arrow J Up arrow 7 Page down Page up Home or ctrl A End or ctrl F Ctrl page up Ctrl page down Ctrl home Ctrl end Ctrl left arrow Ctrl right arrow gt F3 3 3 4 Pick list Move to previous data column attribute Move one record down Move one record up Move the amount of screen records down Move the amount of screen records up Move to first screen position Move to last screen position Move to first record Move to last record Move to left most data column in first record Move to right most data column in first record Move to previous data column and move screen position Move to next data column and move screen position View the entire field remark attribute The pick list appears in case attribute values have pre defined codes attributes with _C extension It shows up as an inset screen in the input and edit screen when non valid codes are entered or codes that have not yet been defined under the CODES option see 6 1 Navigation in the pick list 1s similar to that in the browse screen with the excep tion of the left and right actions Besides navigation with arrows in the pick list it Is also possible to move the cursor by entering the first character As this option 1s case sensitive one should enter lt s
61. e appear in a pick list which shows up as inset on the Input and edit screen when non existing codes are entered Location specific codes such as map unit symbols surveyors names meteo stations etc should be entered by the user see para 6 2 4 Remark attributes have no input restrictions any character can be entered In the third part box at the bottom of the screen a short description of the activated attribute 1s given If the data input is completed the record must be saved with lt F10 gt TROFOLIN will ask for confirmation befOre actually saving the record The following options can be selected Y es Save Clear This option saves the record and moves to an empty screen in which the next record can be entered C opy Save Copy This option saves the record and copies the last data input to the next input and edit screen This option 1s especially inter esting if only a few data in the next record differ from the former for example in soil horizons so that only the differ ing attributes have to be edited N o Continue This option continues the data input If no new records need to be stored return to the browse screen with lt Esc gt 13 4 3 Browse screen The browse screen is meant fOr viewing deleting and reporting of data It also may be used to activate the input and edit screen The browse screen consists of three parts Figure 5 Selected SITEDESC SE i e deva u AA m L i
62. e indexed with INDEX ON lt key variable s gt TO lt indexname gt When two or more key variables are used they should be jointed with Be aware that the key variables have to be of the same type numeric character string date logical If this is not the case the following functions can be interesting LOWER Puts all characters in lower case UPPER Puts all characters in upper case 28 SUBSTR Only uses part of the field STR Changes numerical type into string type Select the proper directory with SET DIRECTORY TO CATROFOLINDATA Select the first work area with SELECT 1 Open a first data file in this first work area with USE Select the second work area with SELECT 2 Open the second data file in the second work area with USE Open the index file on the key variable s of the second data file with SET INDEX TO lt indexname gt Select the first work area with SELECT 1 8 Relate the first data file with the second data file on the selected key variables with SET RELATION TO lt key variable s gt into lt datafile 2 gt DO PON The two data files are linked and information can be derived from both files simultaneously Fields in the non active area in this case work area 2 are referred to as b gt fieldname To obtain a listing of certain information with the key variables LIST FIELDS lt key variables other variables form work area 1 b gt other variables from work area 2 gt 9 7 Report selected records
63. e of moist soil LO Loose VR Very friable FR Friable FI Firm V Very firm EF Exwemely firm Stickiness NS Non sticky SS Slightly sticky S Sucky VS Very sticky Plasticity NP Non plastic SP Slightly plastic P Plastic VP Very plastic Smeariness WS Weakly smeary MS Moderately smeary SS Strongly smeary SF Slightly fluid VF Very fluid STRUCGRI C STRUCSII_C STRUCTY1_C STRUCGR2_C STRUCSI2_C STRUCTY2_C STRUCREL_C CUTQUANI_C CUTTHIC1_C CUTKINDI_C CUTLOCI_C CUTQUAN2_C CUTTHIC2_C char 2 char 2 char 2 char 2 char 2 char 2 char 1 char 1 char 1 char 1 char 2 char 1 char 1 annex l 31 Structure grade of first structure type WC Structureless weakly coherent MC Structureless moderately coherent SC Structureless strongly coherent WE Weak MO Moderate ST Strong Structure size of first structure type VF Very fine FI Fine ME Medium CO Coarse VC Very coarse First structure type PL Platy PR Prismatic CL Columnar AB Angular blocky SB Subangular blocky AW Wedge shaped GR Granular CR Crumb MA Massive PM Porous massive SG Single grain IR Irregular Structure grade of second structure type Structure size of second structure type Second structure type Relation between first and second structure codes to be established on location Quantity of first type of cutans N None P Patchv B Broken C Continuous Thickness of fi
64. eciduous scrub without evergreen woody plants admixed Dwarf scrub and related communities Mainly evergreen dwarf scrub Evergreen dwarf scrub thicket Evergreen caespitose dwarf shrub thicket Evergreen creeping or matted dwarf shrub thicket Herbaceous vegetation Tall graminoid vegetation Tall grassland with a tree synusia covering Woody synusia broad leaved evergreen Woody synusia broad leaved semi evergreen Woody synusia broad leaved deciduous Seasonally flooded Tall grassland with a tree synusia covering less than 10 Trop or subtrop tall grassl with trees and or shrubs growing in tufts on termite nests Tall grassland with synusia of shrubs Tall grassland with woody synusia consist mainly of tuft plants Tropical grassland with palms Seasonally flooded Tall grassland practically without woody synusia Tropical grassland Seasonally flooded Wet or flooded most of the year Medium tall grassland Medium tall grassland with an open synusia of tuft plants Medium tall subtropical grassland with open groves of palms Seasonally flooded Medium tall grassland practically without woody synusia Medium tall grassland consistinf mainly of sod grasses Wet or flooded most of the year On sandy soil or dunes Medium tall grassland consisting mainly of bunch grasses Short grassland Trop alpine open to closed bunch grass communities w 20dy synusia or tuft plants Forb vegetation Tall forb communities Mainly perennial flower
65. elling system Combinations of the two previous systems Selection felling system Irregular shelterwood felling system Other system specify 1 Other system specify 2 Other system specify 3 Other system specify 4 Other system specify 5 Regeneration of forest stands AP Artificial regeneration by planting AS Artificial regeneration by sowing NR Natural regeneration Remarks on extent status age and vigour of regeneration Intensity of grazing ZAS AO MIO Oa EE Ext grazing among ext bush fallow agricultural practices EN Ext grazing in natural or derived forest ecosystems IG Int grazing on grasslands ext bush fallow agricult pract IP Int grazing on pasture land Remarks on grazing practices type of animal number of animals ha Burning practices N No buming I Incidental S Intentional Remarks on burning practices reason extent frequency and impact annex I 27 Entity MSP_ ANAL MINERAL SOIL PROFILE ANALYSIS This entity comprises attributes conceming the physical and chemical composition of samples taken in the mineral soil profile pit Attribute Type AREA_ID char 7 OBS_NR number 4 SAMPDEP_UL number 3 ANALYS1_C char 10 DATELAB date LAB_C char 3 VALUE number 10 3 Description wera IP IIA Se ERA A MAS AIS it Identification of survev area Sequence number of observation site within survev area Upper limit of sample depth cm below min soil surf Tvpe of analvsis mineral soil FO 2
66. er 2 Sequence number of layer see structure ABUND_C char 2 Abundance class R Rare cover less than 5 F Few cover less than 5 M Many cover less than 5 A Abundant cover less than 5 1 Cover about 10 number irrelevant 2 Cover about 20 number irrelevant 3 Cover about 30 number irrelevant 4 Cover about 40 number irrelevant 5 Cover about 50 number irrelevant 6 Cover about 60 number irrelevant 7 Cover about 70 number irrelevant 8 Cover about 80 number irrelevant 9 Cover about 90 number irrelevant 10 Cover about 100 number irrelevant HEIGHT number 4 1 Estimated height m VOLUME number 7 1 Estimated volume of timber m ha REPROD_C char 1 Reproductional stage V Vegetative B Flowering F in Fruit X Flowers and fruits DECIDU_C char 1 Status deciduous species L In leaf S Without leaves AGE_C char 1 Growth stage of species J Species occurs only as seedling sapling or juvenile Y Young not yet fully grown M Mature fully grown VITAL_C char 1 Vitality H Healthy A Unhealthy O Dying D Dead USEPARTI_C char 2 First part of species used LE Leaf TW Twig BA Bark WO Wood BU Bud FL Flower FR Fruit SE Seed RO Root annex I 50 USEPURPI C USEPART2 C USEPURP2 C USEPART3_C USEPURP3_C char 2 char 2 char 2 char 2 char 2 TU Tuber JU Juice resin Purpose type of use of first part of species FO Food beverage FU Fuel firewood ME Medicine poison IN I
67. esite trachyte phonolite Basalt diabase dolerite Pyroclastic rocks fine grained tuffs Pyroclastic rocks fine grained tuffs acid Pyroclastic rocks fine grained tuffs interm Pyroclastic rocks fine grained tuffs basic Pyroclastic rocks coarse grained acid Pyroclastic rocks coarse grained interm Pyroclastic rocks coarse grained basic Tuffaceous formation Ophiolitic association ophiolite Dikes in general Metamorphic rocks MM Metamorphic rocks in gencral MO MC MQ Contact metamorphic sandstone Slate phyllite Quartzite MG ML MI MT MS MF MA MB Gneiss acid Marble Gneiss intermediate Calc silicate rocks Schist mica chlorite talc schist etc Serpentinite Gneiss rich in ferromagnesian minerals Amphibolite eclogite Magmatitic rock annex Il 7 annex II 8 annex II 9 TABLE II 3 CLASSIFICATION ACCORDING TO FAO UNESCO SOIL CLASSIFICATION SYSTEM Source FAO 1988 ATTRIBUTE FAOSOILI_C AC Acrisols ACF Ferric Acrisol ACG Gleyic Acrisol ACH Haplic Acrisol ACP Plinthic Acrisol ACU Humic Acrisol AL Alisols ALF Ferric Alisol ALG Gleyic Alisol ALH Haplic Alisol ALJ Stagnic Alisol ALP Plinthic Alisol ALU Humic Alisol AN Andosols ANG Gleyic Andosol ANH Haplic Andosol ANH Umblic Andosol ANI Gelic Andosol ANM Mollic Andosol ANU Umbric Andosol ANZ Vitric Andosol AR Arenosols ARA Albic Arenosol ATA Aric Anthrosol ARB Cambic Arenosol ARC Calcaric Arenosol ARG Gl
68. eyic Arenosol ARH Haplic Arenosol ARK Calcic Arenosol ARL Luvic Arenosol ARO Ferralic Arenosol AT Anthrosols ATC Cumulic Anthrosol ATF Fimic Anthrosol ATU Urbic Anthrosol CH Chemozems CHG Gleyic Chemozem CHH Haplic Chemozem CHK Calcic Chemozem CHL Luvic Chemozem CHW Glossic Chemozem CL Calcisols CLH Haplic Calcisol CLL Luvic Calcisol CLP Petric Calcisol CM Cambisol CMC Calcaric Cambisol CMD Dystric Cambisol CME Eutric Cambisol CMG Gleyic Cambisol CMI Gelic Cambisol CMJ Stagnic Cambisol CMO Ferralic Cambisol CMU Humic Cambisol CMV Vertic Cambisol CMX Chromic Cambisol FL Fluvisols FLC Calcaric Fluvisol FLD Dystric Fluvisol FLE Eutric Fluvisol FLM Mollic Fluvisol FLS Salic Fluvisol FLT Thionic Fluvisol FLU Umbric Fluvisol FR Ferralsols FRG Geric Ferralsol FRH Haplic Ferralsol FRP Plinthic Ferralsol FRR Rhodic Ferralsol FRU Humic Ferralsol FRX Xanthic Ferralsol GL Gleysols GLA Andic Gleysol GLD Dystric Gleysol GLE Eutric Gleysol GLI Gelic Gleysol GLK Calcic Gleysol GLM Mollic Gleysol GLT Thionic Gleysol GLU Umbric Gleysol GRG Gleyic Greysol GRH Haplic Greysol GY Gypsisols GYH Haplic Gypsisol GYK Calcic Gypsisol GYL Luvic Gypsisol GYP Petric Gypsisol HS Histosols HSF Fibric Histosol HSI Gelic Histosol annex Il 10 HSL Folic Histosol HSS Terric Histosol HST Thionic Histosol KS Kastanozems KSH Haplic Kastanozem KSK Calcic Kastanozem KSL Luvic Kastanozem KSY Gypsic Kastanozem LP
69. f survey area OBS_NR number 4 Sequence number of observation site within survey area SAMPDEP_UL number 3 Upper limit of sample cm above mineral soil surface SAMPDEP_LL number 3 Lower limit of sample cm above mineral soil surface NUMBERSAM number 2 Number of samples mixed before analysis annex I 18 annex l 19 Entity LAND ELE LAND ELEMENT The attributes of land elements mainly consist of classifications of the mineral soil profile humus profile vegetation and land use Detailed information on these aspects can be selected from the data collected at the observation sites within a specific land element The area of a land element is expressed as percentage of the area of its Land Mapping Unit Attribute Type Description AREA_ID char 7 Identification of survey area LMU_NR number 3 Sequence number of Land Mapping Unit LE_NR number 2 Sequence number of Land Element within Land Mapping Unit PERC_LMU number 3 Percentage of Land Element within Land Mapping Unit ELEVA_LL number 4 Lower limit of elevation above sealevel m ELEVA_UL number 4 Upper limit of elevation above sealevel m LOPARENT_C char 2 Local parent material see Annex II for codes FLOODC_C char 1 Class of floodwater quality C Fresh clear Blackwater W Fresh carrying sediment Whitewater F Fresh unspecified lt 0 8mS cm B Brackish 0 8 20mS cm S Saline gt 20mS cm FLOODING_C char 1 Frequency and duration of flooding N Never or less than once in
70. fluvent AQW Albaqualf EVD Udifluvent AUA Haplustalf EVP Torrifluvent AUB Paleustalf EVT Tropofluvent AUD Durustalf EVU Ustifluvent AUH Kanhaplustalf EVX Xerofluvent AUK Kandiustalf AUL Plinthustalf HAC Cryosaprist AUN Natrustalf HAM Medisaprist AUR Rhodustalf HAR Borosaprist AXA Haploxeralf HAT Troposaprist AXB Palexeralf HEB Borohemist AXD Durixeralf HEC Cryohemist AXF Fragixeralf HEI Sulfihemist AXL Plinthoxeralf HEL Luvihemist AXN Natrixeralf HEM Medihemist AXR Rhodoxeralf HEO Sulfohemist HET Tropohemist DOB Paleorthid HIB Borofibrist DOD Durorthid HIC Cryofibrist DOG Gypsiorthid HIL Luvifibrist DOK Calciorthid HIM Medifibrist DOM Camborthid HIS Sphagnofibrist DOS Salorthid HIT Tropofibrist DRA Haplargid HLB Borofolist DRB Paleargid HLC Cryofolist DRD Durargid HLT Tropofolist DRJ Nadurargid IG Plaggept annex II 14 IMA Haplumbrept IMC Cryumbrept IMF Fragiumbrept IMX Xerumbrept INC Cryandept IND Durandept INE Eutrandept INP Placandept INV Vitrandept INW Hydrandept INY Dystrandept IOC Cryochrept IOD Durochrept IOE Eutrochrept IOF Fragiochrept IOU Ustochrept IOX Xerochrept IOY Dystrochrept IQA Haplaquept IQC Cryaquept IQF Fragiaquept IQH Humaquept IQL Plinthaquept IQN Andaquept IQP Placaquept IQS Sulfaquept IQT Tropaquept IQX Halaquept ITE Eutropept ITH Humitropept ITS Sombritropept ITU Ustropept ITY Dystropept MBA Haploboroll MBB Paleboroll MBC Cryoboroll MBK Calciboroll MBN Natriboroll MB
71. fragments F Fine gravel 0 2 1cm G Gravel 1 7 5cm S Stones 7 5 25cm B Boulders 25 50cin R Blocks gt 50cm Abundance of first type of rock fragments N None F Few 2 15 M Many 15 50 A Abundant gt 50 Degree of weathering of first type of rock fragments F Fresh W Slighly weathered S Strongly weathered Nature of first type of rock fragments see Annex II for codes Size of second type of rock fragments Abundance of second type of rock fragments Degree of weathering of second type of rock fragments Nature of second type of rock fragments Quantity of first type of concretions N None V Very few lt 5 F Few S 15 Q Frequent 15 40 R Very frequent 40 80 D Dominant gt 80 Size of first type of concretions P Powdery diffuse S Small lt lcm L Large gt lcm Hardness of first type of concretions H Hard S Soft Shape of first type of concretions A Angular I Irregular S Spherical Nature of first type of concretions C Argillaceous F Ferruginous K Calcareous M Manganiferous annex I 6 CONCQUA2_C CONCSIZ2_C CONCHAR2_C CONCSHA2_C CONCNAT2_C CARBOCON_C PH_H20 PH_KCL EC char 1 char 1 char 1 char 1 char 1 char 1 number 4 1 number 4 1 number 6 3 Q Siliceous Y Gypsiferous Z Saline Quantity of second type of concretions Size of second type of concretions Hardness of second type of concretions Shape of second type of concretions Nature of second type of co
72. hat need to be edited The A dd option does not allow existing key attributes to be entered for a second time In case of LMU_NR or OBS_NR a waming will immediately appear This land mapping unit observation number is already in use Existing key attributes in lower level entities e g LAYER_NR in entity MSP_LAY can be entered twice without Immediate waming However when one tries to save the data entered in the editing screen the warning will appear One has to retum to the key attribute LAYER_NR and rectify the number 4 3 2 Option Delete The D elete option removes unwanted records directly from the browse screen In reality however this option only marks records fOr deletion Permanent removal of records 1s possible with the pack database option SYSTEM menu see para 7 1 CAUTION LOWER LEVEL RECORDS WHICH ARE RELATED TO A MARKED HIGHER LEVEL RECORD WILL AUTOMATICALLY BE MARKED FOR DELETION AS WELL Records that are deleted from the browse screen can be reinstated by the option RECALL in dBASE see para 9 3 This option resets brings back deleted records so that they are no longer marked for deletion 4 3 3 Option Report TROFOLIN offers several ways of viewing data both on and off the screen printer file The R eport option in TROFOLIN only generates a simple columnar display of the entered data More sophisticated reporting such as the compilation of tables of selected records can be generated through dBA
73. hift gt together with the character in case the codes name starts with a upper case character 4 DATABASE With the DATABASE option one enters the actual database The majority of the work within TROFOLIN will be carried out in this option 4 1 Database structure In Figure 2 the structure of the database is displayed Each block in this figure describes an entity and represents a number of interrelated data Each entity has its own data file in which all entity data are stored A short description of the entities is presented in Table 4 An exhaustive list of entities with associated attributes is given in Annex I Table 4 Description of entities Entity SUR_AREA CLIMSTAT LAND_MAP LAND_ELE LU_SUBEL OBS_SITE SITEDESC VEG_RELE VEG_STRU VEG_SPEC LAND_USE HP_PIT HP_LAY HP_SAMP HP_ANAL MSP_PIT MSP_LAY MSP_SAMP MSP_ANAL AUGERING AUG_LAY Description Survey area Climatic data Land mapping units Land elements Land use sub elements Observation site Site description Vegetation relevee Vegetation structure Vegetation species Land use at observation site Humus profile pit Humus profile pit layer Humus profile pit samples Humus profile pit analysis Mineral soil profile pit Mineral soil profile pit layer Mineral soil profile pit samples Mineral soil profile pit analysis Augering Augering layer SURVEY AREA i l LAND MAPPING OBSERVATION CLIMATE UNIT SITE Na AREA ID L
74. ic horizon x Gypsic horizon L Petroplinthite P Plough pan X Others Hardness of hardpan annex l 44 PANCONT_C PANSTRUC_C BIOABUND_C BIOKIND_C char 1 char 1 char 1 char 1 W Weakly cemented S Strongly cemented I Indurated Continuity of hardpan B Broken D Discontinuous C Continuous Structure of hardpan M Massive L Platy V Vesicular N Nodular P Pisolithic Abundance of biological activity O Nil F Few Q Frequent R Very frequent Kind of biological activity Animal channels Sclerotium Krotovina s Mounds Coprogenic elements Termite channels Shells Pedotubules Worm channels Channels unspecified Mycelium lt X FUA ZAN annex 1 45 Entity SUR AREA SURVEY AREA In this entity the survey area is described in general terms with attributes like area name country name area coordinates and project name Attribute AREA_ID AREA_NAME COUNTRY GENDESC AREA LATITU_LL LATITU_UL LONGITU_LL LONGITU_UL PROJNAME PROJDESC arnan mannna char 7 char 75 char 75 char 225 number 7 char 6 char 6 char 7 char 7 char 75 char 150 Description Identification of survey area Name of the survey area Country name General description of the survey area Area ha Lower limit of latitude degrees Upper limit of latitude degrees Lower limit of longitude degrees Upper limit of longitude degrees Project name Project description annex I 46 annex
75. ication codes to be established on location Entity LAND_USE annex I 23 Land use is described in terins of land use attributes which are grouped into the broad categories of produce tangible and non tangible technology and management aspects Attributes listed are comparable to the attributes listed under the entity LU_SUBEL Under the latter entity aggregated land use data are stored while under the present entity actual observation point data are stored Attribute AREA_ID OBS_NR SURVEYOR_C LANDUSE_C PRODUCT 1_C PRODUCT2_C PRODUCT3_C SPECROPI_C SPECROP2_C SPECROP3_C YIELDI YIELD2 YIELD3 YIELDRED_C VISITORS IMPACT_C LABOUR MECH_C MECHREM MANURE_L FERTUSE_L char 7 number 4 char 10 char 8 char 3 char 3 char 3 char 2 char 2 char 2 number 5 number 5 number 5 char 2 number 6 char 2 number 3 char 2 char 150 char 1 char 1 Description Identification of survey area Sequence number of observation site within survey area Surveyor codes to be established on location Land use type codes to be established on location First type of production benefits amenities Fruits fibres resins etc Game fish Grazing browse for livestock Agricultural products Land under fallow Wood products Conservation Recreation Combination of above categories Other 1 Other 2 Other 3 Second type of production benefits amenities Third type of production benefits ame
76. ied Aphanitic limestone micro or crypto crystalline texture Fossil fragment limestone coquinite coquinoid limestone Detrital limestone Limestone conglomerate Limestone breccia Reef limestone Oolitic limestone Pisolitic limestone Pseudo oolitic limestone pellet limestone limesandstone Crystalline recrystallized limestone Chalk Chalky limestone Dolomite Dolomitic limestone annex II 6 LM FM FL FD LS LC K KK KB KW KP FK KG KV FB CB E EY FY EN FN EP B BB BX I IN IA ID IB IP H HA HB VV VR VA VB TT T TD TB PA PD PB FT OP XD M Marl Marly formation Calcareous formation Dolomitic formation Sandy I mestone Argillaceous limestone Coals bitumens and related rocks Coal in general Thin coal bed Brown coal Peat Carbonaceous formation coal streaks Coal conglomerate Plant remains Bitumen bituminous formation in general Bituminous shale including oil shale Evaporites Salinastones Gypsum Gypsiferous formation Anhydrite rock salt in general Anhydrite formation Saliferous formation salt hoppers Basement Basement in general undifferentiated Folded basement Plutonic rocks Intrusive rocks in general Granite group acid Diorite syenite group intermediate Gabbro group basic Peridotite group ultrabasic Hypabyssal rocks Porphyry acid Porphyry intermediate to ultrabasic Extrusive rocks in general Liparite dacite rhyolite And
77. ies Ol Other 1 02 Other 2 03 Other 3 PRODUCT2_C char 3 Second type of production benefits amenities PRODUCT3_C char 3 Third type of production benefits amenities SPECROPI_C char 2 Name of first species or crop codes to be established on location SPECROP2_C char 2 Name of second species or crop SPECROP3_C char 2 Name of third species or crop SPECROP4_C char 2 Name of fourth species or crop SPECROPS_C char 2 Name of fifth species or crop YIELD 1 number 5 Estimated yield of first crop YIELD2 number 5 Estimated yield of second crop YIELD3 number 5 Estimated yield of third crop YIELD4 number 5 Estimated yield of fourth crop YIELDS number 5 Estimated yield of fifth crop YIELDRED_C char 2 Yield reducing factors WE Weeds BI Birds GA Game LI Livestock PD Pests and discases SN Soil nutrient deficiencies SD Other soil degradational factors CL Climatic factors VISITORS number 6 Number of visitors IMPACT_C char 2 Impact on ecosystem N None S Slight M Moderate E Severe annex I 26 LABOUR MECH_C MECHREM MANURE_L FERTUSE_L FERTREM BIOCUSE_L BIOCREM IMPROV_C IMPROVREM FIELDSIZE CONCESSIZE FIELDREM AGRIC_C INTAGRIC AGRICREM FORESTRY_C FORREGEN_C FORESTREM GRAZING_C GRAZREM BURNING_C BURNREM number 3 char 2 char 150 char 1 char 1 char 150 char 1 char 150 char 2 char 150 number 5 1 number 4 char 150 char 2 number 4 1 char 150 char 2 char 2 char 150
78. in report output MSP LAY IV Examples of programming reports in dBase FIGURES 1 Main menu TROFOLIN 2 Datamodel TROFOLIN 3 Example of DATABASE menu 4 Example of an input and edit screen 5 Example of a browse screen 6 CODES menu 7 Attribute descriptions browse screen 8 Attribute Value definitions edit screen 9 EXPORT menu 10 SYSTEM menu 11 QUIT menu TABLES l Navigation in menu screen 2 Navigation in input and edit screen 3 Navigation in browse screen 4 Description of entities page 31 10 11 12 14 17 18 19 21 23 25 Ono Oo 1 INTRODUCTION The TROFOLIN DATABASE TROpical FOrest Land INventory has been developed in the framework of the Tropenbos Programme One of the aims of this programme is the development of common methodologies for inventory and evaluation of humid tropical forest land In order to promote the comparability of the results of land inventories conducted at various sites the Tropenbos Technical Series 4 Inventory and evaluation of tropical forest lands Guidelines for a common methodology Touber et al 1989 was issued These guidelines describe methods for tropical forest land inventories of physical and biotic data at reconnais sance level In the course of the Tropenbos Programme many data from various research sites have become available and many more will follow The use of information technology 1s indispensable for the storage and processing of these data To maintain
79. ing forbs and ferns Saline substrate and or wet much of the year Fern thickets V D Ic V E V E 1 V E la V E 2 V E 2a Mainly annual forbs Hydromorphic fresh water vegetation Rooted fresh water communities Tropical and subtropical forb formations Free floating fresh water communities Tropical and subtropical free floating formations annex II 3 annex II 4 annex II 5 TABLE II 2 CLASSIFICATION OF PARENT MATERIAL Source Meijerink 1988 adapted ATTRIBUTES PARENMAT_C LOPARENT_C STONENAT_C ROCKNATI_C LO LP LS LX JJ LJ DL LD ROCKNAT2_C Clay Silt Sand Gravel Boulder Unconsilidated sheel sand and shell gravel coquina bed predominately composed of fossils Reef organisms and debris coral sand unconsolidated Marl Rudites coarse particles dominant Conglomerate Conglomerate arkose Breccia Arenites sand fraction dominant Sandstone in general undifferentiated Sandstone sandstone with siliceous cement giit Arkose Greywacke Conglomeratic sandstone Argillaceous sandstone Calcareous sandstone Carbonaceous sandstone Tuffaceous sandstone Ferruginous sandstone Lutites pelites pulverites clay or silt fraction dominant Siltstone Mudstone claystone homogeneous consolidated Shale stratified consolidated Argillaceous clayey or shaly formation Silty formation Carbonaceous shale Carbonate rocks Limestone in general stratified Limestone in general not stratif
80. ject imposed IRT Irrigation and drainage infrastructure traditional TEP Terracing for erosion control project imposed TET Terracing for erosion control traditional TIP Terracing for irrigation project imposed TIT Terracing for irrigation traditional Remarks on status of maintenance and efficiency of land improve ments Order of magnitude of fields agriculture Order of magnitude of concessional areas forestry ha Remarks on form and orientation of fields conc areas Intensity of agricultural activities SC Shifting cultivation BF Semi permanent or bush fallow cultivation PE Permanent cultivation Amount of land under actual cultivation ha 100ha Remarks on agricultural activities Harvesting method felling system in forestry Coppice felling system Shelterwood coppice felling system Copping with standards felling system Clear felling system Shelterwood felling system Shelterwood strip felling system Combinations of the two previous systems Selection felling system Irregular shelterwood felling system Other system specify 1 Other system specify 2 Other system specify 3 Other system specify 4 Other system specify 5 Regeneration of forest stands AP Aruficial regeneration by planting AS Artificial regeneration by sowing NR Natural regeneration Remarks on extent status age and vigour of regeneration Intensity of grazing zZ FR S EINEN DD EE Ext erazing among ext bush fallow agricultural pr
81. loxerult Palexerult VDL VDR VP VUL VUR VXL VXR Pelludert Chromudert Torrert Pellustert Chromustert Pelloxerert Chromoxerert annex II 15 annex II 16 annex II 17 TABLE II 6 CLASSIFICATION ACCORDING TO SOIL TAXONOMY Source Soil Survey Staff 1987 ATTRIBUTE SOILTAX2_C AA Typic AB Abruptic AB04 Abruptic Aridic AB08 Abruptic Cryic AB10 Abruptic Haplic AB14 Abruptic Udic AB16 Abruptic Xerollic AC Acric ACOS Acric Plinthic AE Aeric AE03 Aeric Arenic AEOS Aeric Grossarenic AE06 Aeric Mollic AE09 Aeric Tropic AE10 Aeric Umbric AE12 Aeric Xeric AL Albaquic ALO2 Albaquultic AL04 Albic ALO8 Albic glossic ALO9 Albic Alfic AL10 Albic AL12 Albic Arenic AL13 Albic Andeptic AL16 Albic Lithic AN Andic ANO1 Andeptic ANO3 Andaquic AN06 Andic Dystric AN11 Andeptic Glos soboric AN20 Andic Udic AN22 Andic Ustic AN24 Andaqueptic AN25 Anionic AN30 Anthropic AQ Aqualfic AQ02 Aquentic AQ04 Aqueptic AQ06 Aquic AQ08 Aquic Arenic AQ14 Aquic Duric AQ16 Aquic Durorthidic AQ18 Aquic Dystric AQ24 Aquic Haplic AQ26 Aquic Lithic AQ31 Aquic Psammentic AQ34 Aquollic AQ36 Aquultic AR Arenic ARO2 Arenic Aridic AR04 Arenic Plinthaquic AR06 Arenic Plinthic AR07 AR08 AR09 AR10 AR11 AR12 AR13 AR14 AR15 AR16 AR17 AR18 AR19 AR20 AR21 AR22 AR24 AR26 AR28 AR30 AR32 AR34 AR36 AR42 AR50 ARS2 BO BO02 BO04 BO06 BO08 BO10 BO12 CA CA04 CA06 CA10 CA20 CH CH06 CR Are
82. mbol codes to be established on location Area ha Percentage of survey area Number of polygons of Land Mapping Unit First climate zone covering Land Mapping Unit codes to be estab lished on location Second climate zone covering Land Mapping Unit Third climate zone covering Land Mapping Unit Landform Mountains and major scarps Hills and minor scarps Dissected lower slopes of volcanoes and mountains Footslopes glacis coalescing fans Plateaus and high level structural plains LC Coastal plateaus LU Plateau upland transitions U Uplands incl dissected peneplains UC Coastal uplands UP Upland plain transitions Papa Y Piedmont plains P Plains PN Non dissected erosional plains PD Dissected erosional plains PS Sedimentary plains PT Sedimentary plains of upper river terraces PF Sedimentary plains of large alluvial fans PC Coastal plains PV Volcanic plains PL Lacustrine plains A Flood plains B Bottom lands D Dunes LA Recent lava flows S Swamps T Tidal swamps flats V Minor valleys W Badlands L Beach ridges General descriptive classification of relief F Flat almost flat slopes lt 2 U Undulating slopes 2 8 R Rolling slopes 8 16 H Hilly slopes 16 30 S Steeply dissected slopes gt 30 annex I 22 ELEVA_LL ELEVA_UL INTREL_LL INTREL_UL VALDENS DRAINPAT_C GEOFORM_C PARENMAT_C PARENAGE_C UNESVEG1_C UNESVEG2_C UNESVEG3_C UNESVEG4_C UNESVEG5_C UNESVEG6_C LUCLASS_
83. nchak Mollic Solonchak Sodic Solonchak Gypsic Solonchak Solonetz Haplic Solonetz Stagnic Solonetz Calcic Solonetz Mollic Solonetz Gypsic Solonetz Vertisols Dystric Vertisol Haplic Vertisol Calcic Vertisol Gypsic Vertisol annex II 11 TABLE II 4 CLASSIFICATION ACCORDING TO FAO UNESCO SOIL CLASSIFICATION SYSTEM Source FAO 1988 ATTRIBUTE FAOSOIL2_C AL Albi KA Calci AN Andi LU Luvi AR Areni MA Mazi CA Calcari MO Molli CH Chromi NI Niti CM Cambi OR Orthi DY Dystri PE Pelli EU Eurti RH Rhodi FE Ferralo SM Sombri FL Fluvi SO Soli GL Gleyi UM Umbri GU Grumi VE Verti annex II 12 annex II 13 TABLE ILS CLASSIFICATION ACCORDING TO SOIL TAXONOMY Source Soil Survey Staff 1987 ATTRIBUTE SOILTAX ABB Paleboralf DRN Natrargid ABE Eutroboralf ABF Fragiboralf EOC Cryorthent ABG Glossoboralf EOD Udorthent ABN Natriboralf EOP Torriorthent ABO Cryoboralf EOT Troporthent ADA Hapludalf EOU Ustorhent ADB Paleudalf EOX Xerorthent ADC A grudalf EQA Haplaquent ADF Fragiudalf EQC Cryaquent ADG Glossudalf EQI Sulfaquent ADI Ferrudalf EQS Psammaquent ADK Kandiudalf EQT Tropaquent ADN Natrudalf EQV Fluvaquent ADR Rhodudalf EQW Hydraquent AGF Fraglossudalf ER Arent AQD Duraqualf ESC Cryopsamment AQF Fragiaqualf ESD Udipsamment AQG Grossaqualf ESP Torripsamment AQK Kandiaqualf EST Tropopsamment AQL Plinthaqualf ESU Ustipsamment AQM Umbraqualf ESX Xeropsamment AQN Natraqualf ESZ Quartzipsamment AQO Ochraqualf EVC Cryo
84. ncretions Content of carbonates intensity of reaction to HCI 10 N Non calcareous no reaction visible S Slightly calcareous slight reaction R Calcareous strong reaction V Strongly calcareous violent reaction pH H O pH KCI Electric conductivitv mS cm PM En annex I 7 Entity CLIMSTAT Meteorological station This entity contains measured mean monthly climatic data on precipitation potential evapotranspiration temperature humidity and hours of sunshine Attribute AREA_ID STATION_C CLIMDATA_C XCOOR YCOOR BEGINPERIO ENDPERIOD MEASCALC_C CALCREM JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC YEAR CLIMZONE_C KOPPEN_C Type char 7 char 2 char 4 char 10 char 10 number 4 number 4 char 1 char 150 number 7 1 number 7 1 number 7 1 number 7 1 number 7 1 number 7 1 number 7 1 number 7 1 number 7 1 number 7 1 number 7 1 number 7 1 number 7 1 char 2 char 4 Description Identification of survey area Identification of weather station codes to be established on loca tion Type of climatic data P Average monthly yearly precipitation PET Average monthly yearly potential evapotranspiration T Average monthly yearly temperature TMAX Average monthly yearly maximum day temperature TMIN Average monthly yearly minimum day temperature HUM Average monthly yearly relative air humidity I Average monthly yearly hours of sunshine X coordina
85. nic Kandic Arenic Rhodic Arenic Kandic Rhodic Arenic Ultic Arenic Kanhaplic Arenic Kanhaplic Rhodic Arenic Petrocalcic Arenic Umbric Arenic Calciorthidic Arenic Ustalfic Arenic Ustochreptic Arenic Ustollic Arenic Petroferric Arenic Petroferric Rhodic Arenic Paleorthidic Argiaquic Argiaquic Xeric Argic Argic Lithic Argic Pachic Argic Vertic Aridic Aridic Calcic 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 CR10 Cryic Lithic CR14 Cryic Pachic CU CU02 CU04 DU DUO2 DU08 DU10 DUI1 DU12 Cumulic Cumulic Udic Cumulic Ultic Durargidic Duric Duroxerollic Duroxerollic Lithic Durochreptic Durorthidic annex II 18 DU14 Durorthidic Xeric DY02 Dystric DY03 Dystric Enthic DY04 Dystric Fluventic DY06 Dystric Lithic DY08 Dystropeptic EN Entic EN02 Enthic Lithic EN04 Eutropeptic EN06 Enthic Ultic EP Epiaquic EP10 Epiaquic Orthoxic EU Eutric EU02 Eutrochreptic EU04 Eutropeptic FE Ferrudalfic FI Fibric FIO2 Fibric Terric FLO2 Fluvaquentic FLO6 Fluventic FL12 Fluventic Umbric FR10 Flagiaquic FR18 Fragic GL02 Glossaquic GL04 Glossic GL10 Glossic Udic GL12 Glossic Ustollic GL14 Glossoboralfic GL16 Glossoboric GR Grossarenic GRO1 Grossarenic Entic GR04 Grossarenic Plinthic GROS Gross
86. nities Name of first species or crop codes to be established on location Name of second species or crop Name of third species or crop Estimated yield of first crop Estimated yield of second crop Estimated yield of third crop Yield reducing factors zo gt rraoan O0OXZO NI ma UI WE Weeds BI Birds GA Game LI Livestock PD Pests and diseases SN Soil nutrient deficiencies SD Other soil degradational factors CL Climatic factors Number of visitors Impact on ecosystem N None S Slight M Moderate E Severe Labour input in agriculture number of persons 100ha Rate of mechanization H Use of handtools A Use of animal traction T Use of communal tractor M Fully mechanized operations Remarks on rate of mechanization Use of organic manure Y N Application of chemical fertilizers Y N annex I 24 FERTREM BIOCUSE_L BIOCREM IMPROV_C IMPROVREM FIELDSIZE CONCESSIZE FIELDREM AGRIC_C INTAGRIC AGRICREM FORESTRY_C FORREGEN_C FORESTREM GRAZING_C GRAZREM BURNING_C BURNREM char 150 char 1 char 150 char 2 char 150 number 5 1 number 4 char 150 char 2 number 4 1 char 150 char 2 char 2 char 150 char 2 char 150 char 2 char 150 Remarks on kind amount and frequency of use of fertilizers Application of biocides Y N Remarks on kind amount and frequency of use of biocides Forms of land improvement IRP Irrigation and drainage infrastructure pro
87. nsect repellent scent perfume DE Decoration TI Timber construction TO Tool weapon Second part of species used Purpose type of use of second part of species Third part of species used Purpose type of use of third part of species annex I 51 Entity VEG_STRU VEGETATION STRUCTURE Vegetation structure is characterized by the presence height pattern and cover of various strata Within a vegetation layer several growth for ns are recorded Attribute AREA_ID OBS_NR LAYER_NR LAYER_C HEIGHT_AV HEIGHT_UL HEIGHT_LL COVER ABUNDI_C GRFORMI_C mura char 7 number 4 number 1 char 2 number 4 1 number 4 1 number 4 1 number 3 char 2 char 2 Description Identification of survey area Sequence number of observation site within survey area Sequence number of layer Layer in vegetation E Emergents solitary trees emerging above general forest canopy C Tree layer possibly to be subdivided into CU Upper canopy and CL Lower canopy if clearly present S Shrub layer incl saplings H Herb layer possibly to be subdivided into HT Tall herb layer HL Low herb layer Estimated average heigt m of layer Estimated average maximum height m of layer Estimated average minimum height m of layer Percentage cover of layer Abundance class first growth form in layer l Cover about 10 number irrelevant Cover about 20 number irrelevant Cover about 30 number irrelevant Cover about 4
88. o a lower level entity is possible only if the key attribute in the higher level entity is stored For example data cannot be entered in the entity SITEDESC if the entity OBSERVATION SITE does not contain already the OBS NR in question If a non existing OBS NR is entered in a third or lower level entity the following message will appear This observation number does not exist If the requested correct key attributes are given there are two possibilities 1 No records have been entered yet in the entity In this case the input and edit screen will appear Data can be entered now 2 Records were already entered under the given key attributes of the entity In this case the browse screen will appear to show the existing records 4 2 Input and edit screen The input and edit screen can be used to add new records or to modify existing records of an entity The screen consists of three parts Figure 4 re 1r rir l 1 Ium mreei i ri ti edtdte_ rr e ee _ Park ni ara ka kk mm ki mc mn Ka Selected SITEDESC RECENT a eiqiaqe__nmne 6 6 amp kb o net 11 io SEE En RA a OBS_NR 0 SURVEYOR_C ALTITUDE 0 POSITION_C EXPO_C SLOFORM_C SLOGRADIEN SLOGRAD_LL SLOGRAD_UL SLOLENGTH SLOLEN LL SLOLEN UL LOPARENT_C FLOODREM FLOODW_EC 0 00 SURFDRAI_C OOO ooo SAVE EXIT PGDNJ F10 Sequence number of observation site within survey are
89. pecific survey area therefore AREA_ID is the key attribute of each entity in the database At the second level the entities climate CLIMSTAT land mapping unit LAND_ MAP and observation site OBS_SITE are distinguished Land mapping unit and observation site is identified by a sequence number LMU_NR and OBS_NR The entities land mapping unit and observation site are further subdivided see Figure 2 and 3 LMU_NR and OBS_NR each in a unique combination with AREA_ID are used as key attributes at the third level In the example presented in Figure 4 the entity site description SITEDESC has been selected from the menu Key attributes are AREA_ID identification of the survey area and OBS_NR number of observation site The key attribute AREA_ID has a default value while the second key attribute OBS_NR has no default value The last entered AREA_ID will be the default value during one TROFOLIN session The OBS_NR can be entered directly or can be selected from a pick list by pressing lt enter gt From this pick list one can choose the required one out of the observation numbers previously entered Some entities LU_SUBEL HP_ANAL and MSP_ANAL even require a third key attribute before data can be entered in these entities For example for the entity land use subeiement the key attributes AREA_ID LMU_NR and LE_NR must be known before one is admitted to enter and save data into the entities attribute fields NOTE Entering data int
90. records can be selected by adding a condition to APPEND FROM lt source file gt FOR lt condition gt Not only records can be copied between TROFOLIN data files also data from non TROFOLIN data files can be entered into a TROFOLIN file The structure of this non TROFOLIN file source file has to be similar to the TROFOLIN data file target file Only attributes with the same attribute name and attribute type are copied 9 5 Selections within one TROFOLIN data file Selections can be made on a number of selection requirements attributes attribute value ranges within one TROFOLIN entity One has to make use of logical and relational operators The result can be copied to a new file This file should be tranferred to a newly created directory outside TROFOLIN to avoid error messages 1 Select the proper directory with SET DIRECTORY TO CXTROFOLIN DATA 2 Open one of the data files with USE 3 Copy the records selected with the required variables to a new file with COPY TO lt new name gt FOR lt condition e g AND OR NOT gt 4 Transfer new file to directory ouside TROFOLIN 9 6 Combine selections from different TROFOLIN data files Information out of different data files can be selected and listed on the screen A precondition is that one makes index files in dBASE in advance The data files are linked with unique key variable s The file to which the connection 1s made should be indexed on the key variable A data file can b
91. rse 10 25mm O Very coarse gt 25mm Abundance of first type of roots per unit area i e per 2 5x2 5cm for very fine and fine roots 25x25cm for coarser roots V Very few lt 3 F Few 3 10 C Common 10 20 M Many 20 30 A Abundant gt 30 Orientation of first type of roots H Horizontal O Oblique V Vertical R Random Size of second type of roots Abundance of second type of roots per unit area Orientation of second type of roots Size of third type of roots Abundance of third type of roots per unit area Orientation of third type of roots Size of fourth type of roots Abundance of fourth type of roots per unit area Orientation of fourth type of roots Size of fifth type of roots Abundance of fifth type of roots per unit area Orientation of fifth type of roots First type of biota BIOABUI_C BIODIS1_C BIOTYP2_C BIOABU2_C BIODIS2 C BIOTYP3_C BIOABU3_C BIODIS3_C BIOTYP4_C BIOABU4_C BIODIS4_C FUNGABU_C FUNGDIS_C NUMBERS DISTAN_LL DISTAN_UL WEIGHTAV WEIGHT_UL WEIGHT_LL ROOTFINE ROOTCOARS ROOTFI_LL ROOTCO_LL ROOTFI_UL ROOTCO_UL PH_H20 PH_KCL EC PH_H20_LL PH_KCL_LL EC_LL PH_H2O_UL PH_KCL_UL EC_UL char 1 char 1 char 1 char 1 char 1 char 1 char 1 char 1 char 1 char 1 char 1 char 1 char 1 number 1 number 4 1 number 4 1 number 4 number 4 number 4 number 4 number 4 number 4 number 4 number 4 number 4 number 4 1 number 4 1 number 6 3 n
92. rst type of cutans F Thin faint M Moderate distinct SE Thick prominent Kind of first type of cutans C Clay F Iron oxide H Humus M Manganese oxide P Slickenside Q Silica R Pressure face S Sesquioxides Z Salts Location of first type of cutans CF On coarse fragments LA As lamallae Clay bands NS Unspecified P On pedfaces PH On horizontal pedfaces PV On vertical pedfaces VO In voids pores Quantity of second type of cutans Thickness of second type of cutans annex I 32 CUTKIND2_C CUTLOC2_C PORESIZI_C POREABUI_C PORESIZ2_C POREABU2_C POROSITY ROOTSIZI_C ROOTABUI C ROOTORII C ROOTSIZ2_C ROOTABU2_C ROOTORI2_C ROOTFINE ROOTCOARS ROCKSIZI C ROCKABUI_C ROCKWEAI_C ROCKNATI_C ROCKSIZ2_C ROCKABU2_C ROCKWEA2_C char gt char 2 char 1 char 1 char 1 char 1 char 70 char 1 char 1 char 1 char 1 char 1 char 1 number 4 number 4 char 1 char 1 char 1 char 2 char 1 char 1 char 1 Kind of second type of cutans Location of second type of cutans Size of first type of pores I Micro lt 0 1mm V Very fine 0 1 1mm F Fine 1 2mm M Medium 2 5mm C Coarse 5 10mm A Very coarse gt 10mm Abundance of first type of pores N None F Few 1 50 dm C Common 50 200 dm M Many gt 200 dm Size of second type of pores Abundance of second type of pores General description of porosity Size of first type of roots V Very fine lt lmm
93. set 7 15 ff quit endif Ask the user which area is to be used x accept Enter area id to create report for to user_area if len user_area 0 retum endif user_area upper user_area x Define variables for the files to use de store trofdir Mand map to land map store trofdir Nobs site to obs_site do killfile with Ila dbf do killfile with 11b dbf use land_map use obs_site in 2 set filter to a gt area_id user_area join with B to lla dbf for a gt area_id b gt area_id and a Plmu nr b gt Imu_nr use lla if reccount gt 1 sort to 11b on Imu_nr obs_nr else copy to llb endif close databases erase lla dbf use llb annex IV 14 Start of main program n_rec reccount if n_rec 0 No records found quit endif rec_nr go last_lmu Imu nr set print on do while rec_nr lt n_rec do print_Imu with last Imu area CLIMZON1_c CLIMZON2_c CLIMZON3_c photosyl_c photosy2 c landform c relief c eleva Il eleva ul last_lmu Imu_nr do while rec nr lt n_rec and last Imu Imu nr do obs with obs_nr xcoor ycoor siteatt_l vegrel_1 1_use_1 hp_pit_1 msp_pit_1 auger_l rec_nr rec_nr 1 if rec nr lt n_rec go rec_nr endif enddo set print off retum amp amp end of main program procedure killfile parameters filename if file filename erase filename endif retum procedure print Imu parameters Imu area CLIMZON 1_c CLIMZON2_c CL
94. te degrees minutes seconds Y coordinate degrees minutes seconds Beginning of measurement period End of measurement period Data are measured or calculated C Calculated M Measured Remarks on meth of calc of clim data for the clim zones Value of Climdata in January Value of Climdata in February Value of Climdata in March Value of Climdata in April Value of Climdata in May Value of Climdata in June Value of Climdata in July Value of Climdata in August Value of Climdata in September Value of Climdata in October Value of Climdata in November Value of Climdata in December Total or average value of Climdata per year Climate zone codes to be established on location K ppen s climate classification AF Tropical wet climate Al Temp range between warmest coldest month lt 5 C AM Tropical monsoon climate AS Tropical wet dry climate dry spell in summer AW Tropical wet dry climate dry spell in winter AW1 Tropical wet dry climate rainfall max in autumn AW2 Tropical wet dry climate two diff rainfall maxima AG Ganges type of tropical climate annex I 8 annex I 9 Entity HP ANAL HUMUS PROFILE SAMPLE ANALYSIS This entity comprises attributes concerning the chemical composition of mixed samples taken in the profile pit and at the sample plots around the humus profile pit Attribute Type AREA_ID char 7 OBS_NR number 4 SAMPDEP_UL number 3 ANALYS2_C char 6
95. umber 4 1 number 4 1 number 6 3 number 4 1 number 4 1 number 6 3 annex I 13 Arthropoid type Enchytroid type Mite type Wormcasts bundance of first type of biota None Few Common Abundant istribution of first type of biota Banded Clustered Random Second type of biota Abundance of second type of biota Distribution of second type of biota Third type of biota Abundance of third type of biota Distribution of third type of biota Fourth type of biota Abundance of fourth type of biota Distribution of fourth type of biota Abundance of soil flora fungal mycelia zzm gt anwo gt nnZz gt gt N None not visible F Few occasionally present C Common commonly observed A Abundant continuously obs throughout horizon Distribution of soil flora fungal mycelia B Banded C Clustered R Random Number of sampled subplots partalaing Distance of nearest sampled subplot Distance of remotest sampled subplot Average value dry weight organic matter of layer in sampled plots Maximum value dry weight organic matter of layer among sample plots Minimum value dry weight organic matter of layer among sample plots Average value dry weight of fine roots diam lt 5mm of layer in sampled plots g Average value dry weight of coarse roots diam gt 5mm of layer in sampled plots g Minimum value dry weight of fine roots diam lt Smm of layer among sampled plots g Minimum value dry weight of coarse roots diameter
96. values are ordered alphabetically and appear in that order in the pick lists as well NOTE When adding new codes the message Added records cannot be deleted will appear Within TROFOLIN it ts not possible to delete codes This requires action in dBASE see para 9 3 NOTE The field length for a TROP CODE in REF TAB 2 is standard However do not enter a TROP CODE with more characters than the field length of the attribute can harbour Codes that are longer than the attribute s field length in the edit screen will not be recognised Consult ANNEX I when entering new codes 20 6 EXPORT The EXPORT option see Figure 9 offers the possibility to transfer data trom TROFOLIN into other programmes such as Lotus 1 2 3 Qpro Oracle SPSS This is achieved by means of a DBMS Copy programme This programme is activated by pressing lt enter gt TROFOLIN is now connected through DOS with the DBMS Copy For further action one has to consult the DBMS Copy manual NOTE In the present release of TROFOLIN the DBMS Copy programme is not yet available The DBMS Copy programme has to be acquired individually through the Tropenbos Foundation Database Codes Export System Quit i AAA I Start DBM5 Copy a nn pm a a Start the program DBMS copy for exporting database items Figure 9 EXPORT menu 21 22 7 SYSTEM The SYSTEM option offers maintenance utilities for TROFOLIN see Figure 10 A AAA em Terre Info D

TROFOLIN DATABASE USER MANUAL

Contents

Download Pdf Manuals

Related Search

Related Contents