Changes between Version 14 and Version 15 of R scripts


Ignore:
Timestamp:
Jun 15, 2018 5:51:10 PM (7 years ago)
Author:
cedric
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • R scripts

    v14 v15  
    1212* The file is in google sheet, download to pdata 
    1313* Load the database (as an excel sheet) 
    14 * Load complementary attributes (coming from ROE (geom) and rht). This is done in sql before running the rest of the script 
     14* Load complementary attributes (coming from ROE (geom) and rht). This is done in sql before running the rest of the script. 
     15The following information are collected from the topology extracted from RHT 
     16 
     17||ouv_id ||id_drain||module||dmer||cumnbbar||id_drainmer||the_geom||hydro_ref||idbvhydro||  
     18 
     19* ouv_id identifier of the dam 
     20* id_drain identifier of the riversegment 
     21* module  flow of the riversegment 
     22* dmer distance to the sea 
     23* cumnbbar cumulated number of dams 
     24* id_drainmer identifier of the sea riversegment 
     25* the_geom geometry column in postgis 
     26* 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. 
     27* 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  
     28have made a new shape corresponding to hydrobasins on which downtream migration classified flows are calculated 
     29 
    1530* Calculate supplementary assumptions (e.g. 4 blades when none are provided...) 
    1631* Run turbine models for smolts and eel