riviere
148
 Eauxvives.org
 
 

Navigabilité des rivières Info

Attention !Vérifiez bien les dates des données qui ne sont pas toujours à jour. D'autre part la navigabilité n'est donnée qu'à titre indicatif et est à vérifier lors de vos sorties. La rivière étant un milieu vivant, les indications peuvent se révéler obsolètes. Les donneés brutes issues des différents serveurs peuvent également être erronées et ne sont pas garanties.

Notice (8): Undefined offset: 0 [APP/views/niveau_donnees_temps_reels/index.ctp, line 59]
 
Navigable   Pas assez d'eau   Trop d'eau   Tendance (passez sur les flèches pour voir l'historique)
Rivière Parcours Etat   Débit (m3/s) Côte(m ou cm) Station Date Min Max
LANGUEDOC-ROUSSILLON
Riv TêtTêt1.35Rodes19/06/2019 00:401.36 
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) 41 queries took 163 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `niveau_donnees_temps_reels`12121
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';111
3SHOW FULL COLUMNS FROM `niveau_stations_de_mesures`10102
4SHOW FULL COLUMNS FROM `niveau_source_donnees`662
5SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';111
6SHOW FULL COLUMNS FROM `niveau_references_de_niveaux`11112
7SHOW FULL COLUMNS FROM `phpbb_users`76762
8SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_bin';111
9SHOW FULL COLUMNS FROM `topos`10101
10SHOW FULL COLUMNS FROM `topo_types`221
11SHOW FULL COLUMNS FROM `topo_bassins`222
12SHOW FULL COLUMNS FROM `topo_bassin_details`21212
13SHOW FULL COLUMNS FROM `topo_parcours`442
14SHOW FULL COLUMNS FROM `topo_parcours_details`25252
15SHOW FULL COLUMNS FROM `topo_rivieres`222
16SHOW FULL COLUMNS FROM `topo_riviere_details`35352
17SHOW FULL COLUMNS FROM `topo_spots`222
18SHOW FULL COLUMNS FROM `topo_spot_details`20202
19SHOW FULL COLUMNS FROM `niveaux`12121
20SHOW FULL COLUMNS FROM `niveau_evaluations`331
21SHOW FULL COLUMNS FROM `coordonnee_administrative_topos`332
22SHOW FULL COLUMNS FROM `coordonnees_administratives`992
23SHOW FULL COLUMNS FROM `coordonnee_administrative_types`221
24SHOW FULL COLUMNS FROM `attachments`19192
25SHOW FULL COLUMNS FROM `attachments_links`661
26SHOW FULL COLUMNS FROM `niveau_references_de_niveau_types`222
27SHOW FULL COLUMNS FROM `niveau_statistiques`552
28SHOW FULL COLUMNS FROM `phpbb_profile_fields_data`12122
29SHOW FULL COLUMNS FROM `clubs_ffck`15152
30SHOW FULL COLUMNS FROM `petite_annonces`12122
31SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_swedish_ci';111
32SHOW FULL COLUMNS FROM `petite_annonce_types`552
33SHOW FULL COLUMNS FROM `petite_annonce_categories`221
34SHOW FULL COLUMNS FROM `petite_annonce_matos_types`332
35SHOW FULL COLUMNS FROM `petite_annonce_commentaires`662
36SHOW FULL COLUMNS FROM `petite_annonce_disciplines`332
37SHOW FULL COLUMNS FROM `petite_annonces_petite_annonce_disciplines`331
38SHOW FULL COLUMNS FROM `niveau_alertes`552
39SELECT 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 ='148' ) ORDER BY pays_id, region_nom, riviere , TP.numero_ordre -- putain bonjour la requête !!!! ;1121
40SELECT 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 ;47747760
41SELECT 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 = '148' ORDER BY region_nom ;1119