Rivières Le guide des rivières Consulter les topos Tuela (rio)

Au fil de l'eau

Le Guide des Rivières

Ressources

Tuela (rio)

Espagne >> Quelque part en Espagne

EDITER < >

Auteur : Yelsub
> créé le 19-01-2007
> révisé le 19-01-2007

Lien permanent vers l'onglet de ce parcours (faire clic droit/copier le lien).

Contribuez !

Nom

Difficulté

II III IV (1x)

Longueur

12 km

	Amont A-52
	pont XVIIIème d'Hermisende

Logistique

Sortie 106 si on vient de l'Est (107 si on vient de Galice) Lubián Hermisende sur l'A-52.
Point amont : au Nord de l'A-52, traverser Lubián et descendre Ouest puis N (direction Chanos ?). On arrive rapidement à un petit pont qui enjambe la rivière.
Aval : prendre la route vers le Sud vers Hermisende, puis descendre à la rivière (pont du XVIIIème), bivouac idéal pour bien commencer ou finir un périple !
http://www.hermisende.com/puente.htm

Paysage

Superbe

Isolement

important, la petite route de la navette passe très loin sur le plateau RG.

Durée

Dernière descente

mars 2003

Cliquer sur la photo pour voir le diaporama,
ou sur cette icone pour voir la photo originale
(s'ouvre dans une nouvelle fenêtre).

03-05-2013

vitalextra

23/4/2013. Dernier point de vue de la gorge par le haut.

03-05-2013

vitalextra

Gianfranco dans la grosse rapide a mi-percours.

22-01-2007

paddler

Joli seuil dans la gorge.

20-01-2007

Yelsub

Arrivée. Superbe coin...

20-01-2007

Yelsub

joli parcours engorgé...

20-01-2007

Yelsub

Chaos vers le milieu du parcours, portage RD

Parcours	Distance	Difficulté	Nom
P2	12 km	II III IV (1x)	-

(default) 72 queries took 64 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SHOW FULL COLUMNS FROM `topos`	10	10	1
2	SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_bin';	1	1	1
3	SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';	1	1	1
4	SHOW FULL COLUMNS FROM `topo_types`	2	2	1
5	SHOW FULL COLUMNS FROM `topo_bassins`	2	2	1
6	SHOW FULL COLUMNS FROM `topo_bassin_details`	21	21	1
7	SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';	1	1	1
8	SHOW FULL COLUMNS FROM `phpbb_users`	76	76	2
9	SHOW FULL COLUMNS FROM `topo_parcours`	4	4	1
10	SHOW FULL COLUMNS FROM `topo_parcours_details`	25	25	1
11	SHOW FULL COLUMNS FROM `topo_rivieres`	2	2	1
12	SHOW FULL COLUMNS FROM `topo_riviere_details`	35	35	2
13	SHOW FULL COLUMNS FROM `topo_spots`	2	2	1
14	SHOW FULL COLUMNS FROM `topo_spot_details`	20	20	1
15	SHOW FULL COLUMNS FROM `niveau_references_de_niveaux`	11	11	1
16	SHOW FULL COLUMNS FROM `niveau_stations_de_mesures`	10	10	1
17	SHOW FULL COLUMNS FROM `niveau_source_donnees`	6	6	1
18	SHOW FULL COLUMNS FROM `niveau_donnees_temps_reels`	12	12	1
19	SHOW FULL COLUMNS FROM `niveau_references_de_niveau_types`	2	2	1
20	SHOW FULL COLUMNS FROM `niveaux`	12	12	1
21	SHOW FULL COLUMNS FROM `niveau_evaluations`	3	3	1
22	SHOW FULL COLUMNS FROM `coordonnee_administrative_topos`	3	3	1
23	SHOW FULL COLUMNS FROM `coordonnees_administratives`	9	9	1
24	SHOW FULL COLUMNS FROM `coordonnee_administrative_types`	2	2	1
25	SHOW FULL COLUMNS FROM `attachments`	19	19	1
26	SHOW FULL COLUMNS FROM `attachments_links`	6	6	1
27	SHOW FULL COLUMNS FROM `phpbb_profile_fields_data`	12	12	1
28	SHOW FULL COLUMNS FROM `clubs_ffck`	15	15	1
29	SHOW FULL COLUMNS FROM `petite_annonces`	12	12	1
30	SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_swedish_ci';	1	1	1
31	SHOW FULL COLUMNS FROM `petite_annonce_types`	5	5	1
32	SHOW FULL COLUMNS FROM `petite_annonce_categories`	2	2	1
33	SHOW FULL COLUMNS FROM `petite_annonce_matos_types`	3	3	1
34	SHOW FULL COLUMNS FROM `petite_annonce_commentaires`	6	6	1
35	SHOW FULL COLUMNS FROM `petite_annonce_disciplines`	3	3	1
36	SHOW FULL COLUMNS FROM `petite_annonces_petite_annonce_disciplines`	3	3	1
37	SHOW FULL COLUMNS FROM `niveau_alertes`	5	5	1
38	select T.id from topos T where T.slug = 'tuela-rio' and T.topo_type_id=1	1	1	3
39	select T.id,T.nom,T.slug,T.topo_type_id from topos T where T.id=426	1	1	0
40	select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 426)	1	1	1
41	select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=64 and CA.coordonnee_administrative_type_id=CAT.id	1	1	0
42	select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=4 and CA.coordonnee_administrative_type_id=CAT.id	1	1	0
43	select T.id,T.nom,T.topo_type_id,TP.longueur,TP.numero_ordre from topos T,topo_parcours TP where T.parent_id=426 and TP.topo_id=T.id order by TP.numero_ordre	1	1	1
44	select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 1451)	1	1	1
45	select T.id,T.topo_type_id from topos T where T.parent_id=426 and T.topo_type_id=1	0	0	0
46	select T.parent_id from topos T where T.id=426	1	1	0
47	select A.*,U.username from attachments A,attachments_links AL,phpbb_users U,topos T where T.parent_id=426 and T.topo_type_id=4 and AL.foreign_id=T.id and AL.class='Topo' and AL.attachment_id=A.id and A.user_id=U.user_id order by A.created desc	6	6	2
48	select T.id,T.slug,T.topo_type_id,TRD.* from topos T,topo_rivieres TR,topo_riviere_details TRD where T.id=426 and TR.topo_id=T.id and TRD.topo_riviere_id=TR.id	1	1	1
49	select U.user_id,U.username,U.username_clean,P.pf_nom,P.pf_prenom from phpbb_users U left join phpbb_profile_fields_data P on U.user_id=P.user_id where U.user_id=60	1	1	0
50	select C.* from topo_commentaires C where C.topo_id=426 order by C.created desc	0	0	0
51	select TPD.etat from topos T,topo_parcours TP,topo_parcours_details TPD where T.id=1451 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id	1	1	0
52	select T.id,T.slug,T.topo_type_id,TP.numero_ordre,TPD.* from topos T,topo_parcours TP,topo_parcours_details TPD where T.id=1451 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id	1	1	1
53	select C.* from topo_commentaires C where C.topo_id=1451 order by C.created desc	0	0	0
54	select A.*,U.username from attachments A, attachments_links AL, phpbb_users U where AL.foreign_id=1451 and AL.class='Topo' and AL.attachment_id=A.id and A.user_id=U.user_id order by A.created desc	6	6	1
55	select U.user_id,U.username,U.username_clean,P.pf_nom,P.pf_prenom from phpbb_users U left join phpbb_profile_fields_data P on U.user_id=P.user_id where U.user_id=1	1	1	0
56	select N.*, NE.name from niveaux N, niveau_evaluations NE where N.topo_id in (426,1451) and N.niveau_evaluation_id=NE.id order by quand desc	0	0	1
57	select T.topo_type_id from topos T where T.id=426	1	1	0
58	select D.* from dernieres_descentes D where D.topo_id in (1451) order by D.quand desc	0	0	1
59	select distinct SM.id,SM.nom,SM.web_adress1,SM.web_adress2,RN.niveau_references_de_niveau_type_id from topos T,niveau_stations_de_mesures SM,niveau_references_de_niveaux RN where (T.id=426 or (T.topo_type_id=4 and T.parent_id=426)) and RN.topo_id=T.id and RN.niveau_stations_de_mesure_id=SM.id and RN.publiable=1 and (SM.actif is null or SM.actif=1) order by SM.nom asc	0	0	1
60	select T.id,T.slug,T.nom from topos T left join topo_rivieres TR on TR.topo_id = T.id left join topo_riviere_details TRD on TRD.topo_riviere_id = TR.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 left join topo_spots TS on TS.topo_id = T.id left join topo_spot_details TSD on TSD.topo_spot_id = TS.id left join topo_bassins TB on TB.topo_id = T.id left join topo_bassin_details TBD on TBD.topo_bassin_id = TB.id where T.slug < 'tuela-rio' and T.topo_type_id = 1 and case T.topo_type_id when 1 then TRD.etat when 4 then TPD.etat when 2 then TSD.etat when 3 then TBD.etat else null end = 0 order by T.slug desc limit 1	1	1	5
61	select T.id,T.slug,T.nom from topos T left join topo_rivieres TR on TR.topo_id = T.id left join topo_riviere_details TRD on TRD.topo_riviere_id = TR.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 left join topo_spots TS on TS.topo_id = T.id left join topo_spot_details TSD on TSD.topo_spot_id = TS.id left join topo_bassins TB on TB.topo_id = T.id left join topo_bassin_details TBD on TBD.topo_bassin_id = TB.id where T.slug > 'tuela-rio' and T.topo_type_id = 1 and case T.topo_type_id when 1 then TRD.etat when 4 then TPD.etat when 2 then TSD.etat when 3 then TBD.etat else null end = 0 order by T.slug asc limit 1	1	1	4
62	select id,nom,slug,topo_type_id from topos where id=318	1	1	0
63	select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 318)	2	2	1
64	select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=103 and CA.coordonnee_administrative_type_id=CAT.id	1	1	0
65	select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=34 and CA.coordonnee_administrative_type_id=CAT.id	1	1	0
66	select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=1 and CA.coordonnee_administrative_type_id=CAT.id	1	1	0
67	select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=262 and CA.coordonnee_administrative_type_id=CAT.id	1	1	0
68	select id,nom,slug,topo_type_id from topos where id=1871	1	1	0
69	select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 1871)	1	1	1
70	select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=51 and CA.coordonnee_administrative_type_id=CAT.id	1	1	0
71	select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=11 and CA.coordonnee_administrative_type_id=CAT.id	1	1	0
72	select U.user_id,U.username,U.username_clean,P.pf_nom,P.pf_prenom from phpbb_users U left join phpbb_profile_fields_data P on U.user_id=P.user_id where U.user_id=15003	1	1	0

(default) 72 queries took 64 ms

Query

Error

Affected

Num. rows

Took (ms)

SHOW FULL COLUMNS FROM `topos`

SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_bin';

SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';

SHOW FULL COLUMNS FROM `topo_types`

SHOW FULL COLUMNS FROM `topo_bassins`

SHOW FULL COLUMNS FROM `topo_bassin_details`

SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';

SHOW FULL COLUMNS FROM `phpbb_users`

SHOW FULL COLUMNS FROM `topo_parcours`

SHOW FULL COLUMNS FROM `topo_parcours_details`

SHOW FULL COLUMNS FROM `topo_rivieres`

SHOW FULL COLUMNS FROM `topo_riviere_details`

SHOW FULL COLUMNS FROM `topo_spots`

SHOW FULL COLUMNS FROM `topo_spot_details`

SHOW FULL COLUMNS FROM `niveau_references_de_niveaux`

SHOW FULL COLUMNS FROM `niveau_stations_de_mesures`

SHOW FULL COLUMNS FROM `niveau_source_donnees`

SHOW FULL COLUMNS FROM `niveau_donnees_temps_reels`

SHOW FULL COLUMNS FROM `niveau_references_de_niveau_types`

SHOW FULL COLUMNS FROM `niveaux`

SHOW FULL COLUMNS FROM `niveau_evaluations`

SHOW FULL COLUMNS FROM `coordonnee_administrative_topos`

SHOW FULL COLUMNS FROM `coordonnees_administratives`

SHOW FULL COLUMNS FROM `coordonnee_administrative_types`

SHOW FULL COLUMNS FROM `attachments`

SHOW FULL COLUMNS FROM `attachments_links`

SHOW FULL COLUMNS FROM `phpbb_profile_fields_data`

SHOW FULL COLUMNS FROM `clubs_ffck`

SHOW FULL COLUMNS FROM `petite_annonces`

SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_swedish_ci';

SHOW FULL COLUMNS FROM `petite_annonce_types`

SHOW FULL COLUMNS FROM `petite_annonce_categories`

SHOW FULL COLUMNS FROM `petite_annonce_matos_types`

SHOW FULL COLUMNS FROM `petite_annonce_commentaires`

SHOW FULL COLUMNS FROM `petite_annonce_disciplines`

SHOW FULL COLUMNS FROM `petite_annonces_petite_annonce_disciplines`

SHOW FULL COLUMNS FROM `niveau_alertes`

select T.id from topos T where T.slug = 'tuela-rio' and T.topo_type_id=1

select T.id,T.nom,T.slug,T.topo_type_id from topos T where T.id=426

select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 426)

select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=64 and CA.coordonnee_administrative_type_id=CAT.id

select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=4 and CA.coordonnee_administrative_type_id=CAT.id

select T.id,T.nom,T.topo_type_id,TP.longueur,TP.numero_ordre from topos T,topo_parcours TP where T.parent_id=426 and TP.topo_id=T.id order by TP.numero_ordre

select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 1451)

select T.id,T.topo_type_id from topos T where T.parent_id=426 and T.topo_type_id=1

select T.parent_id from topos T where T.id=426

select A.*,U.username from attachments A,attachments_links AL,phpbb_users U,topos T where T.parent_id=426 and T.topo_type_id=4 and AL.foreign_id=T.id and AL.class='Topo' and AL.attachment_id=A.id and A.user_id=U.user_id order by A.created desc

select T.id,T.slug,T.topo_type_id,TRD.* from topos T,topo_rivieres TR,topo_riviere_details TRD where T.id=426 and TR.topo_id=T.id and TRD.topo_riviere_id=TR.id

select U.user_id,U.username,U.username_clean,P.pf_nom,P.pf_prenom from phpbb_users U left join phpbb_profile_fields_data P on U.user_id=P.user_id where U.user_id=60

select C.* from topo_commentaires C where C.topo_id=426 order by C.created desc

select TPD.etat from topos T,topo_parcours TP,topo_parcours_details TPD where T.id=1451 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id

select T.id,T.slug,T.topo_type_id,TP.numero_ordre,TPD.* from topos T,topo_parcours TP,topo_parcours_details TPD where T.id=1451 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id

select C.* from topo_commentaires C where C.topo_id=1451 order by C.created desc

select A.*,U.username from attachments A, attachments_links AL, phpbb_users U where AL.foreign_id=1451 and AL.class='Topo' and AL.attachment_id=A.id and A.user_id=U.user_id order by A.created desc

select U.user_id,U.username,U.username_clean,P.pf_nom,P.pf_prenom from phpbb_users U left join phpbb_profile_fields_data P on U.user_id=P.user_id where U.user_id=1

select N.*, NE.name from niveaux N, niveau_evaluations NE where N.topo_id in (426,1451) and N.niveau_evaluation_id=NE.id order by quand desc

select T.topo_type_id from topos T where T.id=426

select D.* from dernieres_descentes D where D.topo_id in (1451) order by D.quand desc

select distinct SM.id,SM.nom,SM.web_adress1,SM.web_adress2,RN.niveau_references_de_niveau_type_id from topos T,niveau_stations_de_mesures SM,niveau_references_de_niveaux RN where (T.id=426 or (T.topo_type_id=4 and T.parent_id=426)) and RN.topo_id=T.id and RN.niveau_stations_de_mesure_id=SM.id and RN.publiable=1 and (SM.actif is null or SM.actif=1) order by SM.nom asc

select T.id,T.slug,T.nom from topos T left join topo_rivieres TR on TR.topo_id = T.id left join topo_riviere_details TRD on TRD.topo_riviere_id = TR.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 left join topo_spots TS on TS.topo_id = T.id left join topo_spot_details TSD on TSD.topo_spot_id = TS.id left join topo_bassins TB on TB.topo_id = T.id left join topo_bassin_details TBD on TBD.topo_bassin_id = TB.id where T.slug < 'tuela-rio' and T.topo_type_id = 1 and case T.topo_type_id when 1 then TRD.etat when 4 then TPD.etat when 2 then TSD.etat when 3 then TBD.etat else null end = 0 order by T.slug desc limit 1

select T.id,T.slug,T.nom from topos T left join topo_rivieres TR on TR.topo_id = T.id left join topo_riviere_details TRD on TRD.topo_riviere_id = TR.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 left join topo_spots TS on TS.topo_id = T.id left join topo_spot_details TSD on TSD.topo_spot_id = TS.id left join topo_bassins TB on TB.topo_id = T.id left join topo_bassin_details TBD on TBD.topo_bassin_id = TB.id where T.slug > 'tuela-rio' and T.topo_type_id = 1 and case T.topo_type_id when 1 then TRD.etat when 4 then TPD.etat when 2 then TSD.etat when 3 then TBD.etat else null end = 0 order by T.slug asc limit 1

select id,nom,slug,topo_type_id from topos where id=318

select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 318)

select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=103 and CA.coordonnee_administrative_type_id=CAT.id

select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=34 and CA.coordonnee_administrative_type_id=CAT.id

select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=1 and CA.coordonnee_administrative_type_id=CAT.id

select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=262 and CA.coordonnee_administrative_type_id=CAT.id

select id,nom,slug,topo_type_id from topos where id=1871

select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 1871)

select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=51 and CA.coordonnee_administrative_type_id=CAT.id

select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=11 and CA.coordonnee_administrative_type_id=CAT.id

select U.user_id,U.username,U.username_clean,P.pf_nom,P.pf_prenom from phpbb_users U left join phpbb_profile_fields_data P on U.user_id=P.user_id where U.user_id=15003