wiki:Obstacle pressure

Version 35 (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

view: geobs.obstacle

obs_id: identifiant de l'obstacle
obs_position_locale: projection
obs_original:
obs_table:
obs_nom:
obs_id_source:
obs_nom_source:
obs_id_etat:

table: geobs.franchissabilite_piscicole

fra_id:
fra_ref_id:
fra_note: note attribuée
fra_esp_id:

Describing the MIGANG database

Join ROE with CCM

CookBook join ROE_CCM

Some problems with the ROE2010 database

ROE2010 problems