back to first page [..] [[BR]]

= Obstacle pressure =

The obstacle pressure (characteristics, Steinbach rank…) comes from the National list of obstacles to river flows (ROE) from the ONEMA

The data set are in two database : ROE and MIGANG

== Describing the ROE database ==

To download and load the data into postgreSQL you must follow ["ROE download and load"][[BR]]
The data referential is here : http://sandre.eaufrance.fr/spip.php?article695&id_rubrique=177
[[BR]]and at : http://carmen.carmencarto.fr/66/ROE.map

=== The Physical Data Model PDM ===
Is in source:data/dataEDAcommun/barrage/SchemaGeobs.zip

=== geobs2010.obstacle_referentiel ===
47 colonnes dont [[BR]]
[[Color(,#3849ce,ref_id)]]: identifiant de l'obstacle [[BR]]
[[Color(,#3849ce,ref_nom)]]: nom/type d'obstacle[[BR]]
[[Color(,#3849ce,ref_hauteur_chute)]]: hauteur de chute[[BR]]
[[Color(,#3849ce,ref_arasement_effacement)]]: [[BR]]
[[Color(,#3849ce,ref_passe_poisson)]]: présence/absence passe à poisson [[BR]]

une colonne rajoutée : [[Color(,#3849ce,goodproj)]]

=== geobs2010.franchissabilite_piscicole ===

[[Color(,#3849ce,fra_id)]]: [[BR]]
[[Color(,#3849ce,fra_ref_id)]]: [[BR]]
[[Color(,#3849ce,fra_note)]]: note attribuée[[BR]]
[[Color(,#3849ce,fra_esp_id)]]: [[BR]]



=== Describing the ["MIGANG database"] ===


== Join ROE with CCM ==
["CookBook join ROE_CCM"]

== Some problems with the ROE2010 database ==
["ROE2010 problems"]

= Describing the geobs2010 data, with the dams which are joined to the CCM (1000m) =

ref_typ_id
||0||1||2||3||4||5||NA||
||4582||22841||134||1772||90||71||13466||