Integrating data from vessel monitoring system and fish landings in Menditerranean small fleets, using a PostgreSQL database with PostGIS extension

Abstract

Geospatial technologies represent an advance in knowledge of marine ecosystems, allowing approach the study of the potential effect of world fishing fleets and their dynamics. Nevertheless, their application to fisheries biology is very recent and its use is generalizing when the ICES (International Council for the Exploration of the Sea) proposed one methodology to study fisheries and their impact in Atlantic Ocean ecosystems in the 2008 year. This procedure is based on the use of position data from the "blue boxes" (VMS-Vessel Monitoring System), mandatory since 2006 due to a European regulation, and it's present in most fishing boats. The junction of the VMS, fishing logbooks and landings data enables us to obtain among others results, maps of fishing effort, behaviour of fishing fleet and precise location of fishing grounds at the European waters. However, its design is made for large trawlers and longliners, and extensive Atlantic areas. This fact makes impossible its application for the study of the fleet and fisheries in Mediterranean waters. Because, the boats are much smaller, have lower mobility and they work in small fishing areas. The aim of this work has been to develop and apply a methodology (ICES based) to study fishing effort on species of commercial interest in Catalan coast, using scripting PL/SQL procedures of PostgreSQL system database with Post- GIS extension.