| Version 39 (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 two database : ROE and MIGANG
Describing the ROE database
To download and load the data into postgreSQL you must follow ROE download and load
The data referential is here : http://sandre.eaufrance.fr/spip.php?article695&id_rubrique=177
and at : http://carmen.carmencarto.fr/66/ROE.map
The Physical Data Model PDM
Is in source:data/dataEDAcommun/barrage/SchemaGeobs.zip
geobs2010.obstacle_referentiel
47 colonnes dont
ref_id: identifiant de l'obstacle
ref_nom: nom/type d'obstacle
ref_hauteur_chute: hauteur de chute
ref_arasement_effacement:
ref_passe_poisson: présence/absence passe à poisson
une colonne rajoutée : goodproj
geobs2010.franchissabilite_piscicole
fra_id:
fra_ref_id:
fra_note: note attribuée
fra_esp_id:
Describing the MIGANG database
Join ROE with CCM
Some problems with the ROE2010 database
Describing the geobs2010 data, with the dams which are joined to the CCM (1000m)
ref_typ_id in obstacle_referentiel
| typ_nom | Barrage | Seuil en rivière | Digue | Pont | Epis en rivière | Grille | |
| ref_type_id | 0 | 1 | 2 | 3 | 4 | 5 | NA |
| Nb | 4582 | 22841 | 134 | 1772 | 90 | 71 | 13466 |
