Processes of collating a European fisheries database to meet the objectives of the European Union Water Framework Directive

Abstract

Abstract FIsh Database of European Streams, a common database for the FAME project, was merged using existing data on electric fishing and environmental data. FIsh Database of European Stream is a relational database with eight tables. Metrics based on classification of fish species into guilds were calculated, and provided in separate tables. FIsh Database of European Stream contained information about 150 freshwater fish species, from 12 countries, 17 ecoregions, 40 main river regions, 2651 rivers and 8228 sites. Examples of data coverage and use are given. Relationships between environmental variables were illustrated using principal component analysis, which resulted in three environmental components – latitude, size and altitude. Environmental component scores were correlated with fish metrics used in the European Fish Index. Results exemplify how fish guilds reflect gradients in environmental variation. Benefits and problems concerning standardisation and data availability at the global level are discussed.