wiki:Obstacle pressure

Version 2 (modified by celine, 15 years ago) (diff)

--

back to first page ..

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

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.

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

Describing the ROE database