News | Jobs | Publications | About JNCC | Accessibility | Contacts
Home  >  Marine  >  Marine Habitats  >  Marine Environment  >  Habitat  >  Biotope classification
 
 

Comparative Tables

Version 4.05 is now available - more information >>>

The comparative tables

The comparative tables enable a rapid comparison of the species composition and principal physical characteristics between a given set of biotopes.

The comparative tables are available as Microsoft Excel™ spreadsheets, which enable much more flexibility than the comparative tables of the 1997 paper version of the biotope classification (Connor et al. 1997 a,b). The biological comparative tables are downloadable in either Excel 97™ or Excel 2000™ file formats. The latter offers greater functionality to users of Excel 2000™ or higher through the use of pivot tables. The older format file contains the same information presented in more simple pivot tables. Instructions on how to use the spreadsheets can be found below.


download biological comparative tables (Excel 2000 ™ format)

download biological comparative tables (Excel 97™ format)

download physical comparative tables (Excel 97™ format)

Biological comparative tables - Excel 2000™ version

"Comparative tables" worksheet

Each column represents a biotope, with species names listed in taxonomic order down the left. The figures given in each cell represent the percentage of core biotope records of each biotope within which a given species is recorded.


The biotopes which are displayed at any one time is user-defined, using a series of data filters. In order to use the tables effectively, familiarity with the biotope codes is required.


Filtering options:


Broad Habitat (top left corner of worksheet): enables the selection of biotopes from within a single broad habitat.


EUNIS Level (top left corner of worksheet): enables the selection of biotopes from within a single hierarchical level of the classification (level 2 – broad habitat; 3 – habitat complex; 4 - biotope complex; 5 – biotope; 6 – sub-biotope).


SpeciesName: enables the display of information for a defined subset of species only.


biotopecode: enables the display of any combination of biotopes required.

Please note that if you wish to filter on one of these options only, it is adviseable to check all the other filters to make sure that the “show all” option is selected, to avoid inadvertently filtering data you want to include in the table.


"biotope_species_summary_data" worksheet

This worksheet provides a suite of additional species data for each biotope, including the total number of core biotope samples, characterising species, average infaunal counts for infaunal species, and SACFOR abundances for all species.

The format of this worksheet enables all data to be displayed at the same time, as the biotopes are displayed in rows rather than columns. There is a single row for each species in each biotope – i.e. if there are 20 species within the core records for a biotope, there will be 20 rows with that biotope code. The information displayed in the columns is as follows (each column can be filtered on):


Hierarchical biotope sort order: Enables the displayed biotopes to be sorted into their hierarchical classification order.


biotopecode: Displays biotope codes. The filter enables data to be displayed for a subset of biotopes.


Level: Enables data shown to be limited to a given hierarchical level from within the classification.


SpeciesName: Enables information to be displayed for a defined subset of species.


Total number of samples: shows the number of core biotope records for each biotope.


Constancy: This is percentage occurrence: numerical values refers to the percentage of core samples within which a species is recorded. The same value is shown on the Comparative Tables worksheet. The dots show percentage classes at a glance – the same scale is used in the ***characterising species tables of the biotope descriptions.


Density: This value shows the average number per m2 of individuals for species recorded in quantitative infaunal samples.


Sacfor: Shows the average frequency of each species on the MNCR SACFOR Scale


complex: enables the selection of data from within a single broad habitat.


Biological comparative tables – Excel 97™ format

"Littoral Rock", "Circalittoral Rock", "Littoral Sediment", and "Comparative Table – all" Worksheets

In each of these worksheets, each column represents a biotope, with species names listed in taxonomic order down the left. Biotope codes are shown in hierarchical order along the top row. In order to use the tables effectively, familiarity with the biotope codes is required. The figures given in each cell represent the percentage of core biotope records of each biotope within which a given species is recorded. The cells in the top left hand corner enables the user to filter the data on hierarchical level.


Within each of these worksheets, it is possible to display any combination of units from any level in the classification hierarchy in any given order, either by copying and pasting columns into a new worksheet, or by hiding selected columns on the existing sheets.


"biotope_species_summary_data" worksheet

This worksheet provides a suite of additional species data for each biotope, including the total number of core biotope samples, characterising species, average infaunal counts for infaunal species, and SACFOR abundances for all species.

The format of this worksheet enables all data to be displayed at the same time, as the biotopes are displayed in rows rather than columns. There is a single row for each species in each biotope – i.e. if there are 20 species within the core records for a biotope, there will be 20 rows with that biotope code. The information displayed in the columns is as follows (each column can be filtered on):


Hierarchical biotope sort order: Enables the displayed biotopes to be sorted into their hierarchical classification order.


biotopecode: Displays biotope codes. The filter enables data to be displayed for a subset of biotopes.


Level: Enables data shown to be limited to a given hierarchical level from within the classification.


SpeciesName: Enables information to be displayed for a defined subset of species.


Total number of samples: shows the number of core biotope records for each biotope.


Constancy: This is percentage occurrence: numerical values refers to the percentage of core samples within which a species is recorded. The same value is shown on the Comparative Tables worksheet. The dots show percentage classes at a glance – the same scale is used in the 'characterising species' tables of the biotope descriptions.


Density: This value shows the average number per m2 of individuals for species recorded in quantitative infaunal samples.


Sacfor: Shows the average frequency of each species on the MNCR SACFOR Scale


complex: enables the selection of data from within a single broad habitat.


Physical comparative tables – Excel 97™ format

"Physical Data" worksheet
This worksheet shows a summary of the physical data of the core biotope samples for each biotope. The left hand column contains biotope codes, with one row for each biotope. The remaining columns show physical factors, separated by background colouring. Each factor is split into a set of categories (e.g. salinity: full, variable, reduced), which relate to the field recording methodology (see Terms used for field recording and habitat definition). For each biotope, the figures show the percentage of core biotope records falling into a given category for a given factor. Note that it is possible for a single sample to fall into more than one category for some of the factors. Conversely, some of the samples have no data recorded for some of the factors.


It is possible to filter the data on biotope code, EUNIS level, number of core samples, and physical parameter values (e.g. it is possible to select all samples that fall within a particular salinity category).


Littoral sediment, Littoral Rock, Infralittoral Rock and Circalittoral rock worksheets

These worksheets display the same data as the “Physical Data” sheet, but with the samples in columns and the physical data in rows.


The reason for displaying the data this way around is to allow easy cross-referencing between biological and physical sets of comparative tables. By hiding unwanted columns in these worksheets, it is possible to display any combination of physical biotope profiles adjacent to each other (provided they are from within the same section of the classification). As with the biological comparative tables, familiarity with the codes is required to use these tables effectively.

The Comparative tables are compressed in zip format, to reduce their size and ease download. You will need appropriate software to open these files (e.g. WinZip, StuffIt etc).


Biological Comparative Tables 2000 File format Zip Size 971Kb
Biological Comparative Tables 97 File format Zip Size 2.17Mb
Physical Comparative Tables 97 File format Zip Size 856Kb

For information on winzip files http://www.winzip.com/info.htm?wzt

 

This report should be cited as:
DAVID W. CONNOR, JAMES H. ALLEN, NEIL GOLDING, LOUISE M. LIEBERKNECHT, KATE O. NORTHEN AND JOHNNY B. REKER
The National Marine Habitat Classification for Britain and Ireland Version 03.02 2003 Copyright JNCC, Peterborough ISBN 1 86107 546 4 (internet version)