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: