presence data
-
reimport data from excel to the postgis database -
get the geom_point of obstacles (using script compil_migrateur_data.sql) -
Import gis information into postgis for limits -
Select dams downstream from upper limit. -
select idsegment at the upper limit (table joining ROE and idsegment). -
using join_obstruction_rn and join_obstruction_rn_downstream collect all dams located downstream -
check if it is possible to do a selection of dam according to their characteristics.
-
-
Données historiques