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

=== view: geobs.obstacle ===
[[Color(,#3849ce,obs_id)]]: identifiant de l'obstacle [[BR]]
[[Color(,#3849ce,obs_position_locale)]]: projection[[BR]]
[[Color(,#3849ce,obs_original)]]: [[BR]]
[[Color(,#3849ce,obs_table)]]: [[BR]]
[[Color(,#3849ce,obs_nom)]]: [[BR]]
[[Color(,#3849ce,obs_id_source)]]: [[BR]]
[[Color(,#3849ce,obs_nom_source)]]: [[BR]]
[[Color(,#3849ce,obs_id_etat)]]: [[BR]]

=== table: geobs.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"]