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 MIGANG

== Describing the MIGANG database ==
Several tables and views are used

=== tables: t_ouvrage_ouv, t_franchisbar_fba, view: v_ouv_fba ===

Seulement le Bassin versant de la Loire et la Bretagne.

[[Color(,#3849ce,ouv_id)]]: obstacle identifier [[BR]]
[[Color(,#3849ce,ouv_ouv_id)]]: [[BR]]
[[Color(,#3849ce,ouv_baraval)]]: [[BR]]
[[Color(,#3849ce,ouv_codegenerique)]]: [[BR]]
[[Color(,#3849ce,ouv_distancesource)]]: distance à la source de l'ouvrage (km?)[[BR]]
[[Color(,#3849ce,ouv_distancemer)]]: distance à la mer de l'ouvrage (km?) [[BR]]
[[Color(,#3849ce,ouv_distancemareedyn)]]: distance à la marée dynamique de l'ouvrage (km?)[[BR]]
[[Color(,#3849ce,ouv_sbv)]]: surface bassin versant ?[[BR]]
[[Color(,#3849ce,ouv_bassin)]]: [[BR]]
[[Color(,#3849ce,ouv_rinom)]]: [[BR]]
[[Color(,#3849ce,ouv_abscisse)]]: [[BR]]
[[Color(,#3849ce,ouv_ordonnee)]]: [[BR]]
[[Color(,#3849ce,ouv_libelle)]]: [[BR]]
[[Color(,#3849ce,ouv_commentaires)]]: [[BR]]
[[Color(,#3849ce,ouv_zone_geo)]]: zone géographique (BV Loire, Bretagne)[[BR]]
[[Color(,#3849ce,fba_id)]]: [[BR]]
[[Color(,#3849ce,fba_ouv_id)]]: [[BR]]
[[Color(,#3849ce,fba_tax_code)]]: [[BR]]
[[Color(,#3849ce,fba_valeurnote)]]: note attribuée[[BR]]
[[Color(,#3849ce,fba_tyn_typenote)]]: type de notes (expertise, berge, diversite, hauteur, mortalite devalaison, profil, rugosite, score, score2[[BR]]
[[Color(,#3849ce,fba_datedebut)]]: [[BR]]
[[Color(,#3849ce,fba_datefin)]]: [[BR]]
[[Color(,#3849ce,fba_commentaire)]]: [[BR]]


== Describing the ROE database ==

=== 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]]