Electrofishing data for eel in Spain and Portugal (SUDOANG project)

Resumen

<strong>1. SUDOANG PROJECT</strong> The SUDOANG project has provided common tools to managers to support eel conservation in the SUDOE area (Spain, France and Portugal). One of the goals of the project was to develop an eel abundance and distribution atlas in the three countries, based on the results of the implementation of Eel Density Analysis (EDA). This model extrapolates eel abundance from a range of river segments sampled by electrofishing, to the whole river and lake network, by considering how eel abundance, size and sex vary according to different parameters related to eel habitat. <strong>2. SUDOANG DATABASE</strong> Electrofishing data for Spain and Portugal were imported in the SUDOANG database (deliverable 1.2.1), whose structure is inherited from the DataBase for EEl (DBEEL), developed during a European research project (POSE - Pilot projects to estimate potential and actual escapement of silver eel, Walker et al., 2011). This database is designed to contain all data relative to eel biology and anthropogenic pressures applying to eel. During the course of SUDOANG, this database was used and ameliorated. The data providers (mainly SUDOE water managers, SUDOANG researchers and pilot basins from GT6: Task Group on eel stock monitoring transnational network) are listed below: Data Source Region Country Notes Ministry for ecological transition and the demographic challenge (MITECO) Spain Spain Spanish Fsih Chart (SIBIC) Spain Spain Data from different sources (indicated in the data) Basque Water Agency (URA) Basque Country Spain Gipuzkoa Council Gipuzkoa (B.C.) Spain Navarra Council (GAN-NIK) Navarra Spain Asturias Council (DGPM) Asturias Spain Galicia Council Galicia Spain University of Córdoba (UCO) Andalucía Spain Valencian Regional Hunting and Fishing Service (GVA) Valencia Spain Catalan Water Agency (ACA) Catalonia Spain <em>ACUERDO GOV/139/2013, de 15 de octubre, por el que se aprueba el Programa de seguimiento y control del Distrito de cuenca fluvial de Catalunya para el período 2013-2018</em> University of Porto (UP), CIIMAR Portugal Portugal <strong>3. DATA DESCRIPTION</strong> Electrofishing data is mainly based on fishing stations, operations and eel biometry. The <strong>station</strong> level corresponds to a location, identified by coordinates (Spatial Reference System 4326). The attributes associated with stations are: <em>op_id</em>: identifier [data type: UUID] <em>institution</em>: data provider [data type: character] <em>ref_article</em>: reference to the article from which the data originated (only for SIBIC data source) [data type: character] <em>articletitle</em>: title to the article from which the data originated (only for SIBIC data source) [data type: character] <em>op_placename</em>: station name [data type: character] <em>x_espg_4326</em>: longitude (EPSG: 4326) [data type: numeric] <em>y_espg_4326</em>: latitude (EPSG: 4326) [data type: numeric] <em>country</em>: country [data type: character] The <strong>operation</strong> level corresponds to an event occurring at a specific date. At this level, a few more details such as the method or the material used, the wetted area, and electrofished length and width are added. The total number of eels, the numbers collected at each pass, and the number of measured eels are also included. The type of sampling used could not be specified but it is mostly single or several pass surveys. Therefore, the type was set to an unknown type of fishing. All electrofishing reporting eels in the second pass were considered as full electrofishing. The attributes associated with operation are: <em>id</em>: identifier [data type: UUID] <em>op_id</em>: station identifier [data type: UUID] <em>op_gis_layername</em>: data provider [data type: character] <em>data_provider</em>: data provider [data type: character] <em>op_placename</em>: station name [data type: character] <em>ob_id</em>: observation identifier [data type: UUID] <em>ob_starting_date</em>: period starting date <em>ef_wetted_area</em>: wetted area of the station, in m² [data type: numeric] <em>ef_nbpas</em>: the number of electrofishing pass during the observation [data type: numeric] <em>ef_fished_length</em>: the electrofished river length, in m [data type: numeric] <em>ef_fished_width</em>: the electrofished river width, in m [data type: numeric] <em>ob_origin</em>: origing the observation, raw data [data type: character] <em>ob_type</em>: type of observation, electro-fishing [data type: character] <em>ob_period</em>: time step used for observation period, daily [data type: character] <em>ef_fishingmethod</em>: type of method used during the scientific sampling [data type: character] <em>ef_electrofishing_mean</em>: mean used to realize the scientific sampling, by foot [data type: character] <em>density</em>: density of eels collected, in nb/m² [data type: numeric] <em>totalnumber</em>: total number of eels collected [data type: numeric] <em>nbp1</em>: number of eels collected at 1^st pass [data type: numeric] <em>nbp2</em>: number of eels collected at 2^nd pass [data type: numeric] <em>nbp3</em>: number of eels collected at 3^th pass [data type: numeric] <em>nb_size_measured</em>: number of measured eels [data type: numeric] The <strong>individual </strong>level corresponds to the biological characteristics (length and weight) of the measured eels. The attributes associated with indivial are: <em>dp_name</em>: name of data provider [data type: character] <em>ob_id</em>: observation identifier [data type: UUID] <em>bc_id</em>: batch (eels sampled during the observation) identifier [data type: UUID] <em>bc_ba_id</em>: sub-batch identifier [data type: UUID] <em>size</em>: total length of eel, in mm [data type: numeric] <em>fish_id</em>: individual identifier [data type: UUID] <em>weight</em>: body weight of eel, in g [data type: numeric] The three tables can be related to each other through the identifiers, meaning that the eels measured in the <strong>individual</strong> table can be identified with the <strong>operations</strong> through the <em>ob_id</em> identifier, and these operations can be linked to the <strong>stations </strong>through the <em>op_id</em> identifier, allowing for a comprehensive view of the electrofishing sampling collected for Spain and Portugal. * Project co-financed by the INTERREG SUDOE Programme through the European Regional Development Fund (ERDF).