Dam database for diadromous fish (and others)

ABOUT DIADROMOUS SPECIES

Many diadromous species:

  • Upstream migration, effects of dams, fishways, on habitat availability
  • Downstream migration (including, restocking/fishways), dam mortality
  • Salmon, eel, trout + shad, lamprey, etc

Habitat DB - the base for everything

Figure 1: Habitat Database
  • River network and catchments, all linking to marine areas used in ICES assessment
  • Hierchical structure
  • Everything is on Zenodo (https://zenodo.org/records/15856191)

Habitat DB hierarchical structure

WGBAST Hierarchical structure

Figure 2

Habitat DB hierarchical structure : River

This presentation

Regional and Global (Spatial) Models

These use the habitat information, including dams and freshwater habitat

Regional aspects, EDA examples

Regional aspects, EDA examples

  • Hydrographic network, obstacles and electrofishing information needed!

Database development and:

  • Migration obstacles

For habitat availability, mortality, …

Origin : FP6 Pose project, and SUDOANG interreg.

DAM DATABASE

flowchart TB
    A([Obstruction place]):::table
    %% Short Path
    A --> B([Obstruction]):::table
    B -->|Upstream| F([fish passage]):::table
    B -->|Downstream| C([Hydro Power Plant]):::table
    C --> D([Turbine]):::table    
    classDef table fill:#CD88
    classDef main fill:#268073,color:white

Simplied structure of the dam database

DAM DATABASE : Obstruction place

flowchart TB
    A([Obstruction place]):::main
    %% Short Path
    A --> B([Obstruction]):::table
    B -->|Upstream| F([fish passage]):::table
    B -->|Downstream| C([Hydro Power Plant]):::table
    C --> D([Turbine]):::table    
    classDef table fill:#CD88
    classDef main fill:#268073,color:white

Simplied structure of the dam database

  • Obstruction place is a point on the map
  • It has a hierarchy (dam related to other dams in braided network)
  • It belongs to a country (by inheritance), so dam data are filled in and replaced at the national level
  • Class following AMBER + sudoang

flowchart TB
    A([Obstruction place]):::table
    %% Short Path
    A --> B([Obstuction place FR]):::table
    A --> C([Obstuction place ES]):::table 
    A --> D([Obstuction place ...]):::table      
    classDef table fill:#CD88
    classDef main fill:#268073,color:white

DAM DATABASE : Obstruction place

Table 1

DAM DATABASE : Obstruction place

Figure 3: A subsample of the dam database in France

DAM DATABASE : Physical obstruction

flowchart TB
    A([Obstruction place]):::table
    %% Short Path
    A --> B([Obstruction]):::main
    B -->|Upstream| F([fish passage]):::table
    B -->|Downstream| C([Hydro Power Plant]):::table
    C --> D([Turbine]):::table    
    classDef table fill:#CD88
    classDef main fill:#268073,color:white

Simplied structure of the dam database

  • Physical obstruction has date of start and end
  • Events (Erasement, change of height change dam period)
  • Fishway types
  • Downstream water depth

DAM DATABASE : Physical obstruction

Table 2

DAM DATABASE : assessment of passability

flowchart TB
    A([Obstruction place]):::table
    %% Short Path
    A --> B([Obstruction]):::table
    B -->|Upstream| F([fish passage]):::main
    B -->|Downstream| C([Hydro Power Plant]):::table
    C --> D([Turbine]):::table    
    classDef table fill:#CD88
    classDef main fill:#268073,color:white

Simplied structure of the dam database

DAM DATABASE : assessment of passability

Table 3

DAM DATABASE : Hydro Power Plants

flowchart TB
    A([Obstruction place]):::table
    %% Short Path
    A --> B([Obstruction]):::table
    B -->|Upstream| F([fish passage]):::table
    B -->|Downstream| C([Hydro Power Plant]):::main
    C --> D([Turbine]):::table    
    classDef table fill:#CD88
    classDef main fill:#268073,color:white

Simplied structure of the dam database

DAM DATABASE : Hydro Power

Table 4: Hydropower plant table

DAM DATABASE : Turbines

flowchart TB
    A([Obstruction place]):::table
    %% Short Path
    A --> B([Obstruction]):::table
    B -->|Upstream| F([fish passage]):::table
    B -->|Downstream| C([Hydro Power Plant]):::table
    C --> D([Turbine]):::main    
    classDef table fill:#CD88
    classDef main fill:#268073,color:white

Simplied structure of the dam database

DAM DATABASE : Turbines

Table 5: Hydropower plant table



Table 6: Hydropower plant table

ELECTROFISHING

flowchart TB
    A([Electrofishing station]):::main
    %% Short Path
    A --> B([Operation]):::table
    B -->|group| F([Batch ope]):::table
    B -->|individual| C([Batch fish]):::table
    C --> D([Biological characteristics]):::table    
    classDef table fill:#efc9f9
    classDef main fill:#8926b5,color:white

Simplied structure of the electrofishing database

  • Structure similar to Dams (Electrofishing place > Electrofishing even > … )
  • Tested in SUDOANG
  • Adapted to ICES vocabularies and diadromous DB.

To remember: Upstream migration

  • The impact for migratory fishes can be interpreted through a cumulated impact, or the first large barrier for Salmon and Trutta.

  • Here is one example of cumulated impacts (number of dams from EU projet SUDOANG)

Wrap up: Upstream migration

  • The impact for migratory fishes can be interpreted through a cumulated impact, or the first large barrier for Salmon and Trutta.

  • Here is another example cumulated impacts (cumulated height from EU projet SUDOANG)

Wrap up: Downstream migration

  • Turbine mortality is an important, mostly missing part, of mortality assessment for eel.

Wrap up: Downstream migration

  • Turbine mortality is an important, mostly missing part, of mortality assessment for eel.

  • Using information on fish production and dam locations and characteristics, we can build regional estimates of mortalities. VISUANG

Wrap up: Downstream migration

  • Turbine mortality is an important, mostly missing part, of mortality assessment for eel.

  • Using information on fish production and dam locations and characteristics, we can build regional estimates of mortalities. VISUANG

Wrap up: Downstream migration

  • Turbine mortality is an important, mostly missing part, of mortality assessment for eel.

  • Using information on fish production and dam locations and characteristics, we can build regional estimates of mortalities. VISUANG

  • Mortality assessment requires details on the dams (turbine characteristics, flows, presence of bar racks …).

Conclusion

  • The database has been tested in real use.

  • It stores data from the sudoang area (currently). Scripts to extract data directly from three french databases on dams.

  • The database is designed to handle changes accross time on river continuity.

  • Working group on diadromous fishes (WGEEL, WGTRUTTA, WGNAS and WGBAST) can use/ validate data on dams in regional and international assessments.

  • Depending on the habitat referential used, the projection of dams will need to be checked.

Thank you!