<< Click to Display Table of Contents >> Navigation:  General > Database structure

 

A Turboveg database is build up by three tables and three index files.

 

Tables                Index files        

TVHABITA.DBF        TVHABITA.CDX        (table with header data)

TVABUND.DBF                TVABUND.CDX                (table with species data)

REMARKS.DBF                REMARKS.CDX                (table with remarks)

 

The default structure of the tables is as follows.

 

 

 

Field name      

¦             Type  

¦            ¦    Width

¦            ¦    ¦  Decimals

¦            ¦    ¦  ¦    Description  

 

RELEVE_NR    N    6  0    Relevé number (= system number)

COUNTRY      C    2  0    Country code

REFERENCE    C    6  0    Publication reference number

TABLE_NR     C    6  0    Number of table in publication

NR_IN_TAB    C    3  0    Relevé number in table

COVERSCALE   C    2  0    Cover scale

PROJECT      C    3  0    Project code

AUTHOR       C    4  0    Author code

DATE         C    8  0    Date (year/month/day)

SYNTAXON     C    7  0    Syntaxon code

SURF_AREA    N    7  2    Surface area (m²)

UTM          C   15  0    UTM grid reference

ALTITUDE     C    4  0    Altitude (m)

EXPOSITION   C    3  0    Aspect (`NWZO')

INCLINATIO   C    2  0    Inclination (degrees)

COV_TOTAL    N    3  0    Total cover (%)

COV_TREES    N    3  0    Cover trees (%)

COV_SHRUBS   N    3  0    Cover shrubs (%)

COV_HERBS    N    3  0    Cover herb layer (%)

COV_MOSSES   N    3  0    Cover mosses (%)

COV_LICHEN   N    3  0    Cover lichens (%)

COV_ALGAE    N    3  0    Cover algae (%)

COV_LITTER   N    3  0    Cover litter (%)

COV_WATER    N    3  0    Cover open water (%)

COV_ROCK     N    3  0    Cover bare rock (%)

TREE_HIGH    N    2  0    Height (high) tree layer (m)

TREE_LOW     N    2  0    Height low tree layer (m)

SHRUB_HIGH   N    4  1    Height (high) shrub layer (m)

SHRUB_LOW    N    4  1    Height low shrub layer (m)

HERB_HIGH    N    3  0    Mean height high herb layer (cm)

HERB_LOW     N    3  0    Mean height low herb layer (cm)

HERB_MAX     N    3  0    Maximum height herb layer (cm)

CRYPT_HIGH   N    3  0    Mean height cryptogame layer (mm)

MOSS_IDENT   C    1  0    Mosses identified (Yes/No)

LICH_IDENT   C    1  0    Lichens identified (Yes/No)

REMARKS      C   56* 0    Remarks

 

*The total length of the remarks field covers a maximum of 1000 bytes. However, the first 56 bytes is stored in the table TVHABITA.DBF, and the remaining bytes are stored in the table REMARKS.DBF.

 

 

RELEVE_NR    N    6  0    Relevé number (= system number)

SPECIES_NR   N    5  0    Species number

COVER_CODE   C    2  0    Cover abundance code

LAYER        N    1  0    Vegetation layer

 

 

 

RELEVE_NR    N    6  0    Relevé number (= system number)

REMARKS      C    25 0    Remarks