<< Click to Display Table of Contents >> Navigation:  Import > Import Cornell condensed species file

 

Menu: Import | Cornell condensed species file

 

You can import computerised vegetation tables in Cornell condensed format (input format for e.g. TWINSPAN, CANOCO) to a database. When doing so, only the species, cover values, and original relevé numbers will be read in. All other header data, with the exception of the cover scale, need to be entered manually (see example below).

 

After the Cornell condensed file has been read the following must be checked en choices must be made.

 

 

The species codes that are translated ‘by hand’ will be stored in a so-called shadow list. With each session this list will be used to translate species codes that are not in the Turboveg species list. The shadow list is called ccshadow.dbf and by default stored in the directory ..\TURBOWIN\DATA.

 

Species: In the first column of the table de species codes are stored which are extracted from the Cornell file. The second, third, and fourth column holds respectively the species name, the species code, and the vegetation layer. Codes that are could not be translated by Turboveg are presented in blue colour. Double click or press Enter to popup the species list for selecting the desired species.

 

Assign all species with layer code ‘0’ to…: All species without an indication for a vegetation layer can be assigned automatically here.

 

Species list: Click this button to popup the species list.

 

Export: Click to export list of translated species to a file.

 

Merge: Shadow lists from different sources can be combined. Useful if you are working in a team, and want to profit from other ones labour (importing Cornell files).  

 

Cover values: The first column holds the numerical values found in the Cornell file. The second column is the corresponding code according to the chosen scale. Double click or press Enter to modify the code.

 

Store cover values in field…: Cover values are by default stored in the field “Cover abundance”. There are however more possibilities to save the species attributes if the species table is extended with extra fields (see Modify database structure).

 

Translate values using cover scale…: Choose the scale according to which the values must be translated.

 

Store original relevés identifiers in…: You can store the original relevé identifiers (in most cases these are numebers) in a field in the table with header data. This is by default the remarks field.
However, it is recommended to store the relevé numbers in a separate field. When such a field is not yet present, you have to add it first. See Modify database structure

 

Click Import to load the data into the database.

 

 

An example:

 

Selection: 15 releves                                                 T

(I5,5(I5,F8.1))                                                      5

   1    1     3.0    2     8.0    3     8.0

   2    2     2.0    4     8.0    5    18.0    6     8.0    7     2.0

   2    8     2.0    9     2.0   10    38.0   11     8.0   12    38.0

   2   13     3.0   14     2.0

   3    1     2.0    2     2.0    5     8.0    6     8.0    7    18.0

   3    8     4.0    9     8.0   10    18.0   11     8.0   12    38.0

   3   15    68.0   16     3.0   17     3.0   18     3.0   19     2.0

   3   20     8.0

   4    2     8.0    3    18.0   21     4.0

   5    1     2.0    2     8.0    9     1.0   16     2.0

   6    1     3.0    9     2.0   10     8.0   11     8.0   16     3.0

   6   20    38.0

   7    1     3.0    2     2.0    7     3.0    9     2.0   10    38.0

   7   11     4.0   15     2.0   16     8.0   19     2.0   20     8.0

   7   21     8.0   22     2.0   23     2.0   24     2.0   25     2.0

   8   26    38.0

   9    8     1.0   26    18.0   27    18.0   28     2.0

  10    7     8.0   10     2.0   14     3.0   16     2.0   24     3.0

  10   26     4.0   27     1.0   28     2.0   29     2.0   30     4.0

  10   31     8.0   32     2.0   33     2.0

  11    1     8.0    5     2.0   11    18.0   13     2.0   14     4.0

  11   28     2.0   32     8.0

  12   24    68.0   29     2.0   34     3.0

  13   27    38.0

  14   35     3.0   36    68.0   37     8.0

  15   35     2.0   36    18.0   37    68.0

0000

GAZAR;U6LIMISCA6PLAAC;C6ACACCYC7ANTSLIT6CARBDEL6CHRSM-R7CYNANAT6PASSRIG7PHYILIT6

PSORREP6RHOCDIG6SILEPRI6ZALUMAR6EUGECAP7FICILAT6HELHTER6METAMUI7PENCHEP6SYNCSOR6

DELOECK6ASPRRAC6SENELIT6SPORVIR6STEASEC6EHRHV;M6ARCOPOP6DASISUF6GLADGUE6HELHPRA6

MARI/SP6SENEELE6STOEPLU7THINDIS6DISHCRA6SAROPER6SAROPIL6

  50097   50098   50099   50100   50101   50102   50103   50104   50105   50106

  50107   50108   50109   50110   50111