Notice (8): Undefined offset: 0 [APP/app_controller.php, line 35]
Notice (8): Undefined offset: 0 [APP/app_controller.php, line 38]
Notice (8): Undefined offset: 0 [APP/app_controller.php, line 41]
riviere
67
Warning (2): Cannot modify header information - headers already sent by (output started at /var/www/vhosts/eauxvives.org/httpdocs/cake/libs/debugger.php:686) [CORE/cake/libs/controller/components/cookie.php, line 376]
Warning (2): Cannot modify header information - headers already sent by (output started at /var/www/vhosts/eauxvives.org/httpdocs/cake/libs/debugger.php:686) [CORE/wwwroot/forum/includes/session.php, line 1042]
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
PROVENCE-ALPES-CôTE D'AZUR
Riv EsteronEsteron0-0.46Sigale - Pont du Coude14/11/2019 11:30  
1 - Vascogne a Roquesteron0.11Le Broc - La Clave15/12/2019 01:150.6 
2 - Gorges sportives : clue de la Cerise0.11Le Broc - La Clave15/12/2019 01:150.45 
3 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 82 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`10101
4SHOW FULL COLUMNS FROM `niveau_source_donnees`661
5SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';111
6SHOW FULL COLUMNS FROM `niveau_references_de_niveaux`11111
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`221
12SHOW FULL COLUMNS FROM `topo_bassin_details`21211
13SHOW FULL COLUMNS FROM `topo_parcours`441
14SHOW FULL COLUMNS FROM `topo_parcours_details`25251
15SHOW FULL COLUMNS FROM `topo_rivieres`221
16SHOW FULL COLUMNS FROM `topo_riviere_details`35352
17SHOW FULL COLUMNS FROM `topo_spots`221
18SHOW FULL COLUMNS FROM `topo_spot_details`20201
19SHOW FULL COLUMNS FROM `niveaux`12121
20SHOW FULL COLUMNS FROM `niveau_evaluations`331
21SHOW FULL COLUMNS FROM `coordonnee_administrative_topos`331
22SHOW FULL COLUMNS FROM `coordonnees_administratives`991
23SHOW FULL COLUMNS FROM `coordonnee_administrative_types`221
24SHOW FULL COLUMNS FROM `attachments`19191
25SHOW FULL COLUMNS FROM `attachments_links`661
26SHOW FULL COLUMNS FROM `niveau_references_de_niveau_types`221
27SHOW FULL COLUMNS FROM `niveau_statistiques`552
28SHOW FULL COLUMNS FROM `phpbb_profile_fields_data`12121
29SHOW FULL COLUMNS FROM `clubs_ffck`15151
30SHOW FULL COLUMNS FROM `petite_annonces`12121
31SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_swedish_ci';111
32SHOW FULL COLUMNS FROM `petite_annonce_types`551
33SHOW FULL COLUMNS FROM `petite_annonce_categories`221
34SHOW FULL COLUMNS FROM `petite_annonce_matos_types`331
35SHOW FULL COLUMNS FROM `petite_annonce_commentaires`661
36SHOW FULL COLUMNS FROM `petite_annonce_disciplines`331
37SHOW FULL COLUMNS FROM `petite_annonces_petite_annonce_disciplines`331
38SHOW FULL COLUMNS FROM `niveau_alertes`551
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 ='67' ) ORDER BY pays_id, region_nom, riviere , TP.numero_ordre -- putain bonjour la requête !!!! ;3322
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 ;4794790
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 = '67' ORDER BY region_nom ;1119