River navigability



Rivière/Rivière Level/Flow Calibration Navigability

Contribute

You can contribute by adding:
  • monitoring stations to be linked to the topos
  • level calibrations (min and max) to indicate the navigability of a play spot/slalom course/river section
To do that you can :
  • add comment on the topo-guide (the administrator will see it and will perform the associated action)
  • contact the water level administrator by writing to teamevo@eauxvives.org

Last entries
Coming soon ...


Coming soon ...


Coming soon ...


Coming soon ...



(default) 9 queries took 91 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `niveau_statistiques`551
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';111
3SHOW FULL COLUMNS FROM `parametres`661
4SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_bin';111
5SELECT DISTINCT SRC.nom, TF.nom, TF.slug, S.nom, S.id, TR.hauteur_d_eau, TR.debit, TR.date_extraction, TR.tendance, R.niveau_references_de_niveau_type_id, TF.id, S.web_adress2, TF.id, R.min, R.max, TF.topo_type_id, TF.numero_ordre, TF.embarquement, TF.debarquement, CASE TF.topo_type_id WHEN 4 THEN TF2.nom ELSE TF.nom END as riviere, TF.parent_id as id_riviere, CASE TF.topo_type_id WHEN 4 THEN TF2.slug ELSE TF.slug END as slug, CAF.departement_id, CAF.departement_nom, CAF.region_id, CAF.region_nom, CAF.pays_id, CAF.pays_nom, R.id, Max(CASE WHEn A.user_id <> 128 THEN null else 128 end) as user_id FROM niveau_references_de_niveaux R -- Topos INNER JOIN topos_facility TF ON R.topo_id=TF.id LEFT JOIN topos TF2 ON TF.parent_id=TF2.id -- Niveaux INNER JOIN niveau_stations_de_mesures S ON R.niveau_stations_de_mesure_id=S.id INNER JOIN niveau_source_donnees SRC ON S.niveau_source_donnee_id=SRC.id INNER JOIN niveau_donnees_temps_reels TR ON TR.niveau_stations_de_mesure_id=S.id and IsLastInfo = 0 LEFT JOIN niveau_alertes A ON A.topo_id = TF.id -- Coordonnées administratives INNER JOIN coordonnee_administrative_topos CAT ON CAT.topo_id=TF.id INNER JOIN coordonnees_administratives_facility CAF ON CAT.coordonnees_administrative_id=CAF.id WHERE 1=2 GROUP BY SRC.nom, TF.nom, TF.slug, S.nom, S.id, TR.hauteur_d_eau, TR.debit, TR.date_extraction, TR.tendance, R.niveau_references_de_niveau_type_id, TF.id, S.web_adress2, TF.id, R.min, R.max, TF.topo_type_id, TF.numero_ordre, TF.embarquement, TF.debarquement, CASE TF.topo_type_id WHEN 4 THEN TF2.nom ELSE TF.nom END , TF.parent_id , CASE TF.topo_type_id WHEN 4 THEN TF2.slug ELSE TF.slug END , CAF.departement_id, CAF.departement_nom, CAF.region_id, CAF.region_nom, CAF.pays_id, CAF.pays_nom, R.id ORDER BY pays_id, riviere , TF.numero_ordre 001
6SELECT distinct CASE TF.topo_type_id WHEN 4 THEN TF2.nom ELSE TF.nom END as riviere, CASE TF.topo_type_id WHEN 4 THEN TF2.id ELSE TF.id END as id FROM niveau_references_de_niveaux R -- topos INNER JOIN topos_facility TF ON R.topo_id=TF.id LEFT JOIN topos_facility TF2 ON TF.parent_id=TF2.id -- coordonnees administratives INNER JOIN coordonnee_administrative_topos CAT ON CAT.topo_id=TF.id INNER JOIN coordonnees_administratives_facility CAF ON CAT.coordonnees_administrative_id=CAF.id WHERE 1=1 ORDER BY riviere -- Query Filtre ListeRivieres ;53353321
7SELECT distinct CAF.departement_nom as departement_nom, CAF.departement_id as departement_id FROM niveau_references_de_niveaux R -- topos INNER JOIN topos_facility TF ON R.topo_id=TF.id LEFT JOIN topos_facility TF2 ON TF.parent_id=TF2.id -- coordonnees administratives INNER JOIN coordonnee_administrative_topos CAT ON CAT.topo_id=TF.id INNER JOIN coordonnees_administratives_facility CAF ON CAT.coordonnees_administrative_id=CAF.id WHERE 1=1 order by departement_nom -- Query Filtre ListeDepartements ;747422
8SELECT distinct CAF.region_nom as region_nom, CAF.region_id as region_id FROM niveau_references_de_niveaux R -- topos INNER JOIN topos_facility TF ON R.topo_id=TF.id LEFT JOIN topos_facility TF2 ON TF.parent_id=TF2.id -- coordonnees administratives INNER JOIN coordonnee_administrative_topos CAT ON CAT.topo_id=TF.id INNER JOIN coordonnees_administratives_facility CAF ON CAT.coordonnees_administrative_id=CAF.id WHERE 1=1 order by region_nom -- Query Filtre ListeRegions ;343422
9SELECT distinct CAF.pays_id, CAF.pays_nom FROM niveau_references_de_niveaux R -- topos INNER JOIN topos_facility TF ON R.topo_id=TF.id LEFT JOIN topos_facility TF2 ON TF.parent_id=TF2.id -- coordonnees administratives INNER JOIN coordonnee_administrative_topos CAT ON CAT.topo_id=TF.id INNER JOIN coordonnees_administratives_facility CAF ON CAT.coordonnees_administrative_id=CAF.id WHERE 1=1 order by pays_nom -- Query Filtre ListePays ;7721
Page rendered in 3173ms.