| 11 | | Note: for the moment María and Cédric don't have exactly the same number of data as some schema (meuse, iav...) were not saved in Maria's database, to be fixed later. |
| 12 | | |
| 13 | | For the moment, we used the structure of the dbeel database (developed for the POSE Project). Firstly we use empty tables from dbeel database to import data from SIBIC database, whose structure is also defined in ["The SIBIC database"]. We will try to conserve the structure of the SIBIC as much as possible to exchange with their providers. |
| 14 | | |
| 15 | | You can see the code in: |
| 16 | | |
| 17 | | file: source:eda/EDAcommun/sql/sudoang/dbeel_sudoang_electrofishing.sql [[BR]] (use source explorer in the tabs to see the code) |
| 18 | | |
| 19 | | The steps realized until now are: |
| 20 | | 1. Integrate the name of establishments and data providers [[BR]] |
| 21 | | 2. Create station table from dbeel and insert the data from SIBIC [[BR]] |
| 22 | | 3. Correct the country of the station in the SIBIC database (using a view of dblink) [[BR]] |
| 23 | | 4. Integrate data from SIBIC for electrofishing (there are 140 methods of fishing and 19 of electrofishing, but there is not the type of electrofishing, we set "unknown") [[BR]] |
| 24 | | 5. Standardize the format of the date, area and density [[BR]] |
| 25 | | 6. Create temp_pesca_electrica, where all operations are included, also the operations where there are not eels (run2 is not included in the SIBIC database) [[BR]] |
| 26 | | 7. Check the efficiency used to calculate the density [[BR]] |
| 27 | | |
| 28 | | |
| 29 | | == Operations of electrofishing == |
| 30 | | [=#OPERATION] |
| 31 | | The spanish operations are available: |
| 32 | | |
| 33 | | [[Image(source:eda/data/Docs/trac/sudoang/fishing_operation_sibic.png, 400px)]] |
| 34 | | |
| 35 | | The operations in black indicate where eels are fished (1428 locationid). [[BR]] |
| 36 | | |
| 37 | | We can observe that there are not operations in Portugal. In fact, there are also operations in Portugal, but eels are indicated only in level of abundance: |
| 38 | | |
| 39 | | [[Image(source:eda/data/Docs/trac/sudoang/absence_presence_aang_pt.png, 200px)]] |
| 40 | | [[Image(source:eda/data/Docs/trac/sudoang/absence_presence_aang_pt_legend.png, 200px)]] |
| 41 | | [[Image(source:eda/data/Docs/trac/sudoang/abundance_order_aang_PT.png, 200px)]] |
| 42 | | [[Image(source:eda/data/Docs/trac/sudoang/abundance_order_aang_PT_legend.png, 200px)]] [[BR]] |
| 43 | | |
| 44 | | |
| 45 | | == Estimation of electrofishing efficiency == |
| 46 | | [=#EFFICIENCY] |
| 47 | | We also analyzed the electrofishing efficiency for the Spanish operations: |
| 48 | | |
| 49 | | [[Image(source:eda/data/Docs/trac/sudoang/efficiency.png,600px)]] [[BR]] |
| 50 | | |
| 51 | | Where we can see the efficiency estimated by year and basin when the density, area and first pass are availables. [[BR]] |
| 52 | | The most common efficiency is around 0.52. In orange the efficiency up to one, where there must be some problems of estimation. |
| | 7 | The different data from data providers are imported in the schema sudoang of the dbeel database. |
| | 8 | You can see the code in: source:eda/EDAcommun/sql/sudoang/dbeel_sudoang_obstruction.sql [[BR]] |
