riviere
518
River Levels Niveaux en direct - Eauxvives.org
 
 

River Levels Info

Attention !The data is not always up-to-date and calibrations (minimum and maximum) may not be fully accurate.
Rivers are ever changing so data cannot be garanteed. Data Providers may sometimes also be incorrect.

Notice (8): Undefined offset: 0 [APP/views/niveau_donnees_temps_reels/index.ctp, line 59]
 
Good   Low   Too High   Tendance (passez sur les flèches pour voir l'historique)
River Section Etat   Flow (m3/s) Gauge(m ou cm) Gauge Date Min Max
PIEMONTE (ITALIE)
Riv ChiusellaChiusella0-0.04Parella25/08/2020 05:40  
1 référence(s) de niveaux.
***
Application developpée par Punglas. Remerciements à Joker-eph
Pour toute remarque, question ou demande à propos de ce tableau écrivez moi.
(default) 5 queries took 105 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
3SELECT DISTINCT SRC.nom, T.nom, T.slug, S.nom, S.id, TR.hauteur_d_eau, TR.debit, TR.date_extraction, TR.tendance, R.niveau_references_de_niveau_type_id, T.id, S.web_adress2, T.id, R.min, R.max, T.topo_type_id, TP.numero_ordre, TPD.embarquement, TPD.debarquement, CASE T.topo_type_id WHEN 4 THEN T2.nom ELSE T.nom END as riviere, CASE T.topo_type_id WHEN 4 THEN T2.id ELSE T.id END as id_riviere, CASE T.topo_type_id WHEN 4 THEN T2.slug ELSE T.slug END as slug, CASE CA.coordonnee_administrative_type_id WHEN 2 THEN CA.id WHEN 1 THEN CA1.id ELSE NULL END as region_id, CASE CA.coordonnee_administrative_type_id WHEN 2 THEN CA.nom WHEN 1 THEN CA1.nom ELSE NULL END as region_nom, CASE CA.coordonnee_administrative_type_id WHEN 3 THEN CA.id WHEN 2 THEN CA1.id WHEN 1 THEN CA2.id ELSE NULL END as pays_id, CASE CA.coordonnee_administrative_type_id WHEN 3 THEN CA.nom WHEN 2 THEN CA1.nom WHEN 1 THEN CA2.nom ELSE NULL END as pays_nom FROM niveau_references_de_niveaux R -- 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 -- Topos INNER JOIN topos T ON R.topo_id=T.id LEFT JOIN topos T2 ON T.parent_id=T2.id LEFT JOIN topo_parcours TP ON TP.topo_id=T.id LEFT JOIN topo_parcours_details TPD ON TPD.topo_parcours_id=TP.id -- Coordonnées administratives INNER JOIN coordonnee_administrative_topos CAT ON CAT.topo_id=T.id INNER JOIN coordonnees_administratives CA ON CAT.coordonnees_administrative_id=CA.id LEFT JOIN coordonnees_administratives CA1 ON CA.parent_id=CA1.id LEFT JOIN coordonnees_administratives CA2 ON CA1.parent_id=CA2.id WHERE 1=1 AND ( CASE T.topo_type_id WHEN 4 THEN T2.id ELSE T.id END ='518' ) ORDER BY pays_id, region_nom, riviere , TP.numero_ordre -- putain bonjour la requête !!!! ;1122
4SELECT distinct CASE T.topo_type_id WHEN 4 THEN T2.nom ELSE T.nom END as riviere, CASE T.topo_type_id WHEN 4 THEN T2.id ELSE T.id END as id FROM niveau_references_de_niveaux R -- 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 -- Topos INNER JOIN topos T ON R.topo_id=T.id LEFT JOIN topos T2 ON T.parent_id=T2.id LEFT JOIN topo_parcours TP ON TP.topo_id=T.id LEFT JOIN topo_parcours_details TPD ON TPD.topo_parcours_id=TP.id -- Coordonnées administratives INNER JOIN coordonnee_administrative_topos CAT ON CAT.topo_id=T.id INNER JOIN coordonnees_administratives CA ON CAT.coordonnees_administrative_id=CA.id LEFT JOIN coordonnees_administratives CA1 ON CA.parent_id=CA1.id LEFT JOIN coordonnees_administratives CA2 ON CA1.parent_id=CA2.id WHERE 1=1 ORDER BY riviere ;49849862
5SELECT distinct CASE CA.coordonnee_administrative_type_id WHEN 2 THEN CA.nom WHEN 1 THEN CA1.nom ELSE NULL END as region_nom, CASE CA.coordonnee_administrative_type_id WHEN 2 THEN CA.id WHEN 1 THEN CA1.id ELSE NULL END as id FROM niveau_references_de_niveaux R -- 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 -- Topos INNER JOIN topos T ON R.topo_id=T.id LEFT JOIN topos T2 ON T.parent_id=T2.id LEFT JOIN topo_parcours TP ON TP.topo_id=T.id LEFT JOIN topo_parcours_details TPD ON TPD.topo_parcours_id=TP.id -- Coordonnées administratives INNER JOIN coordonnee_administrative_topos CAT ON CAT.topo_id=T.id INNER JOIN coordonnees_administratives CA ON CAT.coordonnees_administrative_id=CA.id LEFT JOIN coordonnees_administratives CA1 ON CA.parent_id=CA1.id LEFT JOIN coordonnees_administratives CA2 ON CA1.parent_id=CA2.id WHERE 1=1 AND CASE T.topo_type_id WHEN 4 THEN T2.id ELSE T.id END = '518' ORDER BY region_nom ;1119