back to first page..

R scripts to run devalpomi

load turbine database

Turbine mortality calculation are in :
source:/devalpomi/R/tableau_mortalite.R
source:/devalpomi/R/tableau_mortalite_bretagne.R

these two scripts have been joined

The script is self explaining, follow the steps :

• The file is in google sheet, download to pdata
• Load the database (as an excel sheet)
• Load complementary attributes (coming from ROE (geom) and rht). This is done in sql before running the rest of the script.

The following information are collected from the topology extracted from RHT

ouv_id

id_drain

module

dmer

cumnbbar

id_drainmer

the_geom

hydro_ref

idbvhydro

• ouv_id identifier of the dam
• id_drain identifier of the riversegment
• module flow of the riversegment
• dmer distance to the sea
• cumnbbar cumulated number of dams
• id_drainmer identifier of the sea riversegment
• the_geom geometry column in postgis
• hydro_ref Identifier of the hydro basin, in Britany there is for some basins an expertise on the hydrographic behaviour of basins, and some basins are using hydro information from neighbours.
• idbvhydro Identifier of the bd carthage basin these have been projected on the RHT using the following script source:devalpomi/sql/correspondance_bv_stationhydro.sql. Based on Bd_carthage, we

have made a new shape corresponding to hydrobasins on which downtream migration classified flows are calculated (see Annex Basin et station pour les débits P163 Briand et al., devalopomi 2015)

• Calculate supplementary assumptions (e.g. 4 blades when none are provided...)
• Run turbine models for smolts and eel
• Save the result as two tables : one corresponding to turbines, one corresponding to dams.

current tickets

#87 #104 #102 #103 #106

run script to integrate mortality at the basin scale