Navigabilité des rivières



Supprimer les filtres
Rivière/Rivière Côte/Débit Calibrage Navigabilité

Contribuer

Vous pouvez contribuer en ajoutant :
  • des stations de mesure à rattacher aux topos
  • des calibrages de niveau (min et max) pour signaler la navigabilité d'un spot/bassin/tronçon de rivière
Pour cela vous pouvez :
  • ajouter un commentaire sur le topo (l'admin le verra et prendra en charge l'action associée)
  • contacter l'admin niveaux d'eau en écrivant à teamevo@eauxvives.org

Les dernières entrées
Coming soon ...


Coming soon ...


Coming soon ...


Coming soon ...



(default) 9 queries took 86 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 ;53353319
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 ;747421
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 ;343421
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 ;7720
Page rendered in 2593ms.