Electrofishing data for eel (Anguilla anguilla) in the SUDOE area

<strong>1. DESCRIPTION</strong> <strong> 1.1. THE SUDOANG PROJECT</strong> The SUDOANG project aims at providing common tools to managers to support eel conservation in the SUDOE area (Spain, France and Portugal). Three main datasets have been used to implement EDA. A database of rivers and their attributes along with tools for chaining. A database of dams. A database of electrofishing (current dataset). Electrofishing data include site locations, fishing operations which can be done several times at one site, and fish data collected during each operation. The operations are attached to stretches of river or river segments whose characteristics describe the conditions for presence, density, size structure, or silvering rate of the eels. The electrofishing operation are classified by type, com full two pass fishing, coa full two pass electrofishing for eel, iaa eel abundance point sampling, ber bank sampling gm point fishing for large streams oth other, or unspecified. <strong> 1.2. TEMPORAL SCOPE </strong> From 1985 to 2018, beware incomplete dataset after 2015 in France. <strong> 1.3. GEOGRAPHICAL RANGE</strong> The SUDOE area including Iberian Peninsula and France. <strong>2. DATASETS DESCRIPTION</strong> <strong>2.1. DENSITIES AND PRESENCE ABSENCE</strong> dataset : frsppt_12_2020.Rdata Most variables are built here The script to create cumulated values for dams can be found here For a technical description see the report Contains : ddd =&gt; dataset used to calibrate the presence absence model, 46147 lines ddg =&gt; dataset used to calibrate the gamma model (only positive values retained), 19993 lines. tdd =&gt; dataset corresponding to places where transport operation have been identified, presence absence model, 6582 lines. tdg =&gt; dataset corresponding to places where transport operation have been identified, gamma model (only positive values) 984 lines. And the following columns (in alphabetical order) : altitudem. Altitude in meter truncated to 800 m area_sudo Area for recruitment (Drouineau et al., 2021) codesea Code of the Sea, factor A = Atlantic, M = Mediterranean country A factor (FR, SP, PT) for France, Portugral and Spain country2 Country with grouping for the Iberian Peninsula, levels: FR SPPT cs_height_08_n Cumulated height from the sea, dam height transformed with power 0.8, no prediction for missing values. cs_height_08_n. Same variable but truncated to 300 cs_height_08_p Cumulated height from the sea, dam height transformed with power 0.8, with prediction for missing values. cs_height_08_p. Same variable but truncated to 300 cs_height_08_pp Cumulated height from the sea, dam height transformed with power 0.8, with prediction for missing values, the height of dam is set to zero if equiped with an efficient fishway for eel cs_height_08_pps Cumulated height from the sea, dam height transformed with power 0.8, with prediction for missing values, the height of dam is set to zero if a score of efficient passage was attributed for eel on this structure cs_height_10_FR Cumulated height from the sea, no transformation, no prediction for missing values, only the dams from France are considered when building on a transnational water course. cs_height_10_n Cumulated height from the sea, no transformation, no prediction for missing values. cs_height_10_n. Same variable but truncated to 200 cs_height_10_p Cumulated height from the sea, no transformation, missing height are extrapolated from two different models in France and the Iberian Peninsula cs_height_10_p. Same variable but truncated to 200 cs_height_10_pass0 Cumulated height from the sea, no transformation, no prediction for missing values, only the dams without pass are used to build the cumulated value. cs_height_10_pass1 Cumulated height from the sea, no transformation, no prediction for missing values, only the dams with pass are used to build the cumulated value. cs_height_10_pp Cumulated height from the sea, no transformation, with prediction for missing values, the height of dam is set to zero if equiped with an efficient fishway for eel cs_height_10_ppass0 Cumulated height from the sea, no transformation, including prediction for missing values, only the dams without pass are used to build the cumulated value. cs_height_10_ppass1 Cumulated height from the sea, no transformation, including prediction for missing values, only the dams with pass are used to build the cumulated value. cs_height_10_pps Cumulated height from the sea, no transformation, with prediction for missing values, the height of dam is set to zero if a score of efficient passage was attributed for eel on this structure cs_height_10_pscore0 Cumulated height from the sea, no transformation, including prediction for missing values, only the dams without score are used to build the cumulated value. cs_height_10_pscore1 Cumulated height from the sea, no transformation, including prediction for missing values, only the dams with score (that have been expertised as no or small barrier for eel) are used to build the cumulated value. cs_height_10_PT Cumulated height from the sea, no transformation, no prediction for missing values, only the dams from Portugal are considered when building on a transnational water course. cs_height_10_score0 Cumulated height from the sea, no transformation, no prediction for missing values, only the dams without score are used to build the cumulated value. cs_height_10_score1 Cumulated height from the sea, no transformation, no prediction for missing values, only the dams with score (that have been expertised as no or small barrier for eel) are used to build the cumulated value. cs_height_10_SP Cumulated height from the sea, no transformation, no prediction for missing values, only the dams from Spain are considered when building on a transnational water course. cs_height_12_n Cumulated height from the sea, dam height transformed with power 1.2, no prediction for missing values. cs_height_12_n. Same variable but truncated to 500 cs_height_12_p Cumulated height from the sea, dam height transformed with power 1.2, with prediction for missing values. cs_height_12_p. Same variable but truncated to 500 cs_height_12_pp Cumulated height from the sea, dam height transformed with power 1.2, with prediction for missing values, the height of dam is set to zero if equiped with an efficient fishway for eel cs_height_12_pps Cumulated height from the sea, dam height transformed with power 1.2, with prediction for missing values, the height of dam is set to zero if a score of efficient passage was attributed for eel on this structure cs_height_15_n Cumulated height from the sea, dam height transformed with power 1.5, no prediction for missing values. cs_height_15_n. Same variable but truncated to 800 cs_height_15_p Cumulated height from the sea, dam height transformed with power 1.5, with prediction for missing values. cs_height_15_p. Same variable but truncated to 800 cs_height_15_pp Cumulated height from the sea, dam height transformed with power 1.5, with prediction for missing values, the height of dam is set to zero if equiped with an efficient fishway for eel cs_height_15_pps Cumulated height from the sea, dam height transformed with power 1.5, with prediction for missing values, the height of dam is set to zero if a score of efficient passage was attributed for eel on this structure cumnbdamp Cumulated number of dam from the sea cumnbdamso duplicate of cumnbdamp cumwettedsurfacebothkm2. Surface of water downstream from the segment in the river. Corresponds to both riversegment and waterbodies. cumwettedsurfacekm2. Surface of water downstream from the segment in the river. Corresponds only to rivers cumwettedsurfaceotherkm2. Surface of water downstream from the segment in the river. Corresponds only waterbodies (water surfaces, associated with the segment). densCS Density from Carle and Strub, number in second pass extrapolated from efficiency if only one pass. dist_from_gibraltar_km Distance to Gibraltar calculated using an enveloppe along the coastline (e.g. the estuaries ingress inland are not counted for this distance). distanceseakm Distance to the sea distanceseakm. Distance to the sea, truncated at 500 distancesourcem distance to the source in m downstdrainagewettedsurfaceboth. Percentage of wetted surface downstream for both rivers and associated waterbodies (cumwettedsurfacebothkm2) divided by land surface for all segments within the basin located at a same or lesser distance to the sea. downstreamwettedsurface Percentage of wetted surface downstream (cumwettedsurfacekm2) divided by land surface for all segments within the basin located at a same or lesser distance to the sea. drainage_density_perm. River length / surface of basin in the basin downstream (m-1) Numeric, multiplied by $10^4$, truncated to 20 ef_fishingmethod Fishing method. See details in text and Briand et al (2022) ef_wetted_area Surface of the electrofishing station emu Eel management unit. See https://github.com/ices-eg/wg_WGEEL/wiki hydraulicdensityperm2. Number of riversegments per surface of basin (m-2). Numeric Multiplied by 10^6, truncated to 1.5 idsegment Unique identifier of the segment TEXT laltitudem. Log transformed value of altitude (truncated) lcs_height_10_n. Log transformed value of cumulated height lddws Log transformed value of downstdrainagewettedsurfaceboth. ldownstreamwettedsurface Log of previous column lriverwidthm. Log transformed value of river width month Month NCS Number of eels estimated by Carle and Strub ob_id Operation (observation) id op_id Station (observation place) id riverwidthm Width of the river in m (comes from various sources see Atlas and Briand et al 2022). seaidsegment Identifier of the sea idsegment temperature Average temperature from 1960-2000 from the CCM (Vogt 2007) temperature.1 duplicate of temperature transport code of transport operation year year of electrofishing <strong>2.2. SIZE STRUCTURE OF EELS</strong> table_ind.Rdata A dataset of 494163 lines. In this dataset, one line correspond to one eel. altitudem Altitude in meter altitudem. Altitude in meter truncated to 800 m area_sudo Area for recruitment (Drouineau et al., 2021) basin Name (or code from bd_carthage France) of the basin codesea Code of the Sea, factor A = Atlantic, M = Mediterranean country A factor (FR, SP, PT) for France, Portugral and Spain cs_height_08_n Cumulated height from the sea, dam height transformed with power 0.8, no prediction for missing values. cs_height_08_n. Same variable but truncated to 300 cs_height_08_p Cumulated height from the sea, dam height transformed with power 0.8, with prediction for missing values. cs_height_08_p. Same variable but truncated to 300 cs_height_08_pp Cumulated height from the sea, dam height transformed with power 0.8, with prediction for missing values, the height of dam is set to zero if equiped with an efficient fishway for eel cs_height_08_pps Cumulated height from the sea, dam height transformed with power 0.8, with prediction for missing values, the height of dam is set to zero if a score of efficient passage was attributed for eel on this structure cs_height_10_FR Cumulated height from the sea, no transformation, no prediction for missing values, only the dams from France are considered when building on a transnational water course. cs_height_10_n Cumulated height from the sea, no transformation, no prediction for missing values. cs_height_10_n. Same variable but truncated to 200 cs_height_10_p Cumulated height from the sea, no transformation, missing height are extrapolated from two different models in France and the Iberian Peninsula cs_height_10_p. Same variable but truncated to 200 cs_height_10_pass0 Cumulated height from the sea, no transformation, including prediction for missing values, only the dams with pass are used to build the cumulated value. cs_height_10_pass1 Cumulated height from the sea, no transformation, including prediction for missing values, only the dams without pass are used to build the cumulated value. cs_height_10_pp Cumulated height from the sea, no transformation, with prediction for missing values, the height