Community Research and Development Information Service - CORDIS

Generation of a common database structure to collect auxiliary fisheries data

One important challenge of the TECTAC project was to merge information from existing surveillance programmes (e.g. log-books) with information that lye outside the traditional recorded measures of fishing effort and yield. Auxiliary data sources have included accountancy records, regulatory orders, and new information from electronic log-books, in-depth interviews and harbour enquiries. A common structure was agreed by the consortium to compile both routinely recorded and newly acquired data into standard tables.

The following tables were generated:
- EFLALO: Effort and landings, based on combined log-books and sales slips;

- LASORT: Landings by market sorting categories, based on sales slips;

- TECVESS: Technological developments of vessel, based on both harbour and on-board enquiries;

- TECGEAR: Technological developments of gears, based on both harbour and on-board enquiries;

- TACENQ: Fishing tactics: haul-by-haul data;

- TACSAT: Fishing activity, based on satellite monitoring;

- ECOENQ1: Costs and earnings, by year and by vessel;

- ECOENQ2: Costs and earnings, by year, vessel and fishing trip;

- MANENQ1: Vessel- and gear- related management measures;

- MANENQ2: Minimum landing sizes by species;

- MANENQ3: TAC by species

The format of EFLALO, TECVESS, TECGEAR, TACENQ, TACSAT, MANENQ1, MANENQ2 and MANENQ3 was common to the consortium. The format of ECOENQ1 and ECOENQ2 was country-specific. All data, both routinely recorded and newly acquired, were computerized into standard tables by each country. Given the specificity of economic data within national institutes, it was decided to keep ECOENQ1 and ECOENQ2 (costs and earnings) country-specific. The consortium also concluded that only little use would be made of the LASORT (landings by market sorting categories), and no further consideration was given to this database in the course of the project.

This database structure was used to a large extent during the TECTAC project to compile data and provide directly inputs to the analyses. It is also available, with minor adjustments, for future projects pertaining fleet dynamics (e.g. the CAFE project which starts in 2006).

In addition, another database structure was generated to compile aggregated data. Two tables were aggregated, i.e. EFLALO and TACENQ, and the data compiled, and these have been submitted on a CD-ROM to the Commission.

Reported by

150 Quai Gambetta
62321 Boulogne sur mer
See on map
Follow us on: RSS Facebook Twitter YouTube Managed by the EU Publications Office Top