Changes between Version 1 and Version 2 of Obstacle pressure

Timestamp:

Mar 4, 2010 11:50:44 AM (15 years ago)

Author:

celine

Comment:

--

Obstacle pressure

@@ -4 +4 @@
 
 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 ==
+Different 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 ==
+
+