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]
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
 
 

Les 200 spots topographiés

Recherche rapide :
A
Agen France   >   Aquitaine   >   Lot-et-Garonne (47)
Agos France   >   Midi-Pyrénées   >   Haute-Pyrénées (65)
Agout France   >   Midi-Pyrénées   >   Tarn (81)
Aiguillon France   >   Aquitaine   >   Lot-et-Garonne (47)
Allier - les Madeleines France   >   Auvergne   >   Puy-de-Dôme (63)
Allier - les Madeleines (NEW) France   >   Auvergne   >   Puy-de-Dôme (63)
Allier - les martres de veyres France   >   Auvergne
ally sur somme France   >   Picardie   >   Somme (80)
Ambialet France   >   Midi-Pyrénées   >   Tarn (81)
Ancerville France   >   Lorraine   >   Meuse (55)
Apremont France   >   Centre   >   Cher (18)
Archette France   >   Lorraine   >   Vosges (88)
Arcy sur aube France   >   Champagne-Ardennes   >   Aube (10)
Ardèche - le Charlemagne France   >   Rhône-Alpes   >   Ardèche (07)
Ardéche - Viaduc de vogüé France   >   Rhône-Alpes   >   Ardèche (07)
Ardèche - Voguë France   >   Rhône-Alpes   >   Ardèche (07)
Aren France   >   Aquitaine   >   Pyrénées-Atlantiques (64)
Ariège - le trou à Dudu France   >   Midi-Pyrénées   >   Ariège (09)
Arve - Sallanches France   >   Rhône-Alpes   >   Haute Savoie (74)
Aveyron - Cazals France   >   Midi-Pyrénées   >   Tarn-et-Garonne (82)
B
Banastère France   >   Bretagne   >   Morbihan (56)
Barrage de Magny ( Metz) France   >   Lorraine   >   Moselle (57)
Barrage de Phades France   >   Champagne-Ardennes   >   Ardennes (08)
Barrage de Ponviel France   >   Midi-Pyrénées   >   Tarn (81)
barrage des verres de montre France   >   Lorraine   >   Meurthe-et-Moselle (54)
bassin de périgueux France   >   Aquitaine   >   Dordogne (24)
Bassin de Quillan France   >   Languedoc-Roussillon   >   Aude (11)
Baume les Dames - le Millénium France   >   Franche-Comté   >   Doubs (25)
BEAUGENCY - JAKUZI France   >   Centre   >   Loiret (45)
Beaulieu France   >   Limousin   >   Corrèze (19)
Beaumont sur Sarthe France   >   Pays de Loire   >   Sarthe (72)
Berder France   >   Bretagne   >   Morbihan (56)
Bidos - Leader Price France   >   Aquitaine   >   Pyrénées-Atlantiques (64)
Big Joe Canada   >   Canada
bléré France   >   Centre   >   Indre-et-Loire (37)
Boo-Silhen France   >   Midi-Pyrénées   >   Haute-Pyrénées (65)
Bouillon Belgique   >   Belgique
Bourlafleur France   >   Normandie   >   Manche (50)
C
Camp des pirate France   >   Lorraine   >   Moselle (57)
Camp des Pirates France   >   Lorraine   >   Moselle (57)
Canche France   >   Nord Pas de Calais   >   Pas-de-Calais (62)
Carennac France   >   Aquitaine   >   Dordogne (24)
Castellane France   >   Provence-Alpes-Côte d'Azur   >   Alpes-de-Haute-Provence (04)
Cergy neuville France   >   Ile de France   >   Val-d'Oise (95)
Cesson-sevigné FS France   >   Bretagne   >   Ille-et-Vilaine (35)
Chancy-GE (Pougny) France   >   Rhône-Alpes   >   Ain (01)
Charité sur Loire (la) France   >   Bourgogne   >   Nièvre (58)
Charly sur Marne France   >   Picardie   >   Aisne (02)
Charnay les Chalon France   >   Bourgogne   >   Saône-et-Loire (71)
Chassezac - les dalles France   >   Rhône-Alpes   >   Ardèche (07)
Chatillon en Diois France   >   Rhône-Alpes   >   Drôme (26)
Cher France   >   Centre   >   Cher (18)
Civray France   >   Centre   >   Indre-et-Loire (37)
Clain France   >   Poitou-Charentes   >   Vienne (86)
Clapière (la) France   >   Provence-Alpes-Côte d'Azur   >   Hautes-Alpes (05)
Clécy France   >   Normandie   >   Calvados (14)
Clémenceau France   >   Lorraine   >   Vosges (88)
Club de St-Grégoire France   >   Bretagne   >   Ille-et-Vilaine (35)
Coulanges sur Yonne France   >   Bourgogne   >   Yonne (89)
D
dallet beach France   >   Auvergne   >   Puy-de-Dôme (63)
Deluz France   >   Franche-Comté   >   Doubs (25)
Descartes France   >   Centre   >   Indre-et-Loire (37)
Digue D'Offard France   >   Pays de Loire   >   Maine-et-Loire (49)
Donchery France   >   Champagne-Ardennes   >   Ardennes (08)
Dropt - le spot du pont France   >   Aquitaine   >   Lot-et-Garonne (47)
E
Ecourues France   >   Pays de Loire   >   Maine-et-Loire (49)
Eloyes France   >   Lorraine   >   Vosges (88)
Entraygues France   >   Midi-Pyrénées   >   Aveyron (12)
Epinal France   >   Lorraine   >   Vosges (88)
Estaing France   >   Midi-Pyrénées   >   Aveyron (12)
Evrunes France   >   Pays de Loire   >   Vendée (85)
F
Flip-Flap (Gave de Pau) France   >   Midi-Pyrénées   >   Haute-Pyrénées (65)
G
Gaetan Canada   >   Canada
Gave (le) à Pau France   >   Aquitaine   >   Pyrénées-Atlantiques (64)
Giffre - vague de Verchaix France   >   Rhône-Alpes   >   Haute Savoie (74)
Gland FS France   >   Picardie   >   Aisne (02)
Goncelin France   >   Rhône-Alpes   >   Isère (38)
Grez-neuville France   >   Pays de Loire   >   Maine-et-Loire (49)
Guingamp France   >   Bretagne   >   Côtes-d'Armor (22)
Guipry France   >   Bretagne   >   Ille-et-Vilaine (35)
Guisane - pontillas France   >   Provence-Alpes-Côte d'Azur   >   Hautes-Alpes (05)
H
Haguenau FS France   >   Alsace   >   Bas-Rhin (67)
Hawaii sur Rhône France   >   Rhône-Alpes   >   Rhône (69)
Hérault(Gignac) France   >   Languedoc-Roussillon   >   Hérault (34)
Huisne (spot de ponlieue) France   >   Pays de Loire   >   Sarthe (72)
Huningue France   >   Alsace   >   Haut-Rhin (68)
I
Ill - Abattoir France   >   Alsace   >   Bas-Rhin (67)
Ill - barrage du Doernel France   >   Alsace   >   Bas-Rhin (67)
Ill - Ehnwihr France   >   Alsace   >   Bas-Rhin (67)
Ill - Osthouse France   >   Alsace   >   Bas-Rhin (67)
Ill à Matzenheim France   >   Alsace   >   Bas-Rhin (67)
J
Joinville - barrage de Joinville France   >   Ile de France   >   Val-de-Marne (94)
Joze France   >   Auvergne   >   Puy-de-Dôme (63)
L
L'osmonerie France   >   Limousin   >   Haute-Vienne (87)
la cascade France   >   Aquitaine   >   Lot-et-Garonne (47)
LA CHIPAKAWAVE France   >   Midi-Pyrénées   >   Tarn (81)
la digue France   >   Midi-Pyrénées   >   Aveyron (12)
La Gachère France   >   Pays de Loire   >   Vendée (85)
La pétanque France   >   Midi-Pyrénées   >   Gers (32)
la petite villemadaise France   >   Midi-Pyrénées   >   Tarn-et-Garonne (82)
La Truchere France   >   Bourgogne   >   Saône-et-Loire (71)
Lachine (Québec - Montréal) Canada   >   Canada
Larcay France   >   Centre   >   Indre-et-Loire (37)
lavauzelle France   >   Limousin   >   Haute-Vienne (87)
le coulobre France   >   Aquitaine   >   Dordogne (24)
Le Figuier France   >   Midi-Pyrénées   >   Aveyron (12)
Le Guétin France   >   Centre   >   Cher (18)
Le Havre - bassin du commerce France   >   Normandie   >   Seine-Maritime (76)
Lisieux (Bassin) France   >   Normandie   >   Calvados (14)
Loir (le) Angevin France   >   Pays de Loire   >   Maine-et-Loire (49)
Longrine France   >   Languedoc-Roussillon   >   Lozère (48)
Lorient (Etang du Ter) France   >   Bretagne   >   Morbihan (56)
M
Maison rouge France   >   Alsace   >   Haut-Rhin (68)
Malate France   >   Franche-Comté   >   Doubs (25)
Marenla FS France   >   Nord Pas de Calais   >   Pas-de-Calais (62)
Mascaret de la Dordogne France   >   Aquitaine   >   Gironde (33)
Mascaret du Mont St Michel France   >   Normandie   >   Manche (50)
Massebiau France   >   Midi-Pyrénées   >   Aveyron (12)
Mehun sur Yèvre France   >   Centre   >   Cher (18)
Mende France   >   Languedoc-Roussillon   >   Lozère (48)
Metz France   >   Lorraine   >   Moselle (57)
Metz - La porte des allemands France   >   Lorraine   >   Moselle (57)
Meung sur Loire (Ruines du pont) France   >   Centre   >   Loiret (45)
Micaud France   >   Franche-Comté   >   Doubs (25)
Millau France   >   Midi-Pyrénées   >   Aveyron (12)
Miribel France   >   Rhône-Alpes   >   Rhône (69)
Montrichard France   >   Centre   >   Loir-et-Cher (41)
Moulin de Matheflon France   >   Pays de Loire   >   Maine-et-Loire (49)
Moulins France   >   Auvergne   >   Puy-de-Dôme (63)
N
nancy France   >   Lorraine   >   Meurthe-et-Moselle (54)
Née France   >   Bretagne   >   Morbihan (56)
Nérac France   >   Aquitaine   >   Lot-et-Garonne (47)
Neuves-Maison pont de la route France   >   Lorraine   >   Meurthe-et-Moselle (54)
Neuville-Ain France   >   Rhône-Alpes   >   Ain (01)
Nitray France   >   Centre   >   Indre-et-Loire (37)
Noisiel (barrage de) France   >   Ile de France   >   Seine-et-Marne (77)
O
Orb - Cessenon Réals France   >   Languedoc-Roussillon   >   Hérault (34)
Orléans - Digue France   >   Centre   >   Loiret (45)
Oxford France   >   Rhône-Alpes   >   Isère (38)
P
Picquigny France   >   Picardie
Poitiers France   >   Poitou-Charentes   >   Vienne (86)
Pont Afra, Maroc Maroc
Pont d'Artiguelouve-Lescar France   >   Aquitaine   >   Pyrénées-Atlantiques (64)
Pont de la révolution France   >   Limousin   >   Haute-Vienne (87)
pont de roide France   >   Franche-Comté   >   Doubs (25)
Pont du château France   >   Auvergne   >   Puy-de-Dôme (63)
Pont Lorois (Rivière d'Etel) France   >   Bretagne   >   Morbihan (56)
Pratgrau' France   >   Midi-Pyrénées   >   Tarn (81)
Puech-rodhil France   >   Midi-Pyrénées   >   Aveyron (12)
Pyramidal Canada   >   Canada
Q
Quimperlé - vague des quais France   >   Bretagne   >   Finistère (29)
R
Rabioux France   >   Provence-Alpes-Côte d'Azur   >   Hautes-Alpes (05)
Rennes France   >   Bretagne   >   Ille-et-Vilaine (35)
Rhône - vague à l'isle de la serre France   >   Rhône-Alpes   >   Ain (01)
Robineau France   >   Midi-Pyrénées   >   Haute-Garonne (31)
Rocaviale France   >   Midi-Pyrénées   >   Lot (46)
Roche France   >   Franche-Comté   >   Doubs (25)
Roger (Vague de) France   >   Languedoc-Roussillon   >   Gard (30)
rosières France   >   Rhône-Alpes   >   Ardèche (07)
S
Saint Clément France   >   Provence-Alpes-Côte d'Azur   >   Hautes-Alpes (05)
Saint Florent-sur-Cher France   >   Centre   >   Cher (18)
Saint leger des vignes France   >   Bourgogne   >   Nièvre (58)
Saint Pierre de Boeuf FS France   >   Rhône-Alpes   >   Loire (42)
Saint-Juéry - vague de lapine France   >   Midi-Pyrénées   >   Tarn (81)
Sarthe France   >   Pays de Loire   >   Sarthe (72)
Sault Brenaz France   >   Rhône-Alpes   >   Ain (01)
Scie France   >   Franche-Comté   >   Doubs (25)
Seiglan France   >   Bourgogne   >   Yonne (89)
Sorgue France   >   Provence-Alpes-Côte d'Azur   >   Vaucluse (84)
Sort Espagne   >   Quelque part en Espagne
Sougé le Ganelon France   >   Pays de Loire   >   Sarthe (72)
spot de la Pinette France   >   Midi-Pyrénées   >   Aveyron (12)
Spot des Legumes France   >   Aquitaine   >   Pyrénées-Atlantiques (64)
Spots disparus France
St Pé - Pont des Grottes France   >   Midi-Pyrénées   >   Haute-Pyrénées (65)
St Valéry sur Somme (situation géographique non définie)
T
Tarn - Barrage de Rivière France   >   Midi-Pyrénées   >   Tarn (81)
Thésée - écluse des Mazelles France   >   Centre   >   Loir-et-Cher (41)
Tonneins France   >   Aquitaine   >   Lot-et-Garonne (47)
Toulouse - Bras de la Loge France   >   Midi-Pyrénées   >   Haute-Garonne (31)
Toulouse summer spot France   >   Midi-Pyrénées   >   Haute-Garonne (31)
Tournon st martin France   >   Centre   >   Indre (36)
V
Vague d'Etupes France   >   Franche-Comté   >   Doubs (25)
Vague de Bonnel France   >   Limousin   >   Corrèze (19)
vague de Feyragut France   >   Midi-Pyrénées   >   Aveyron (12)
Vague de Rodez France   >   Midi-Pyrénées   >   Aveyron (12)
vague de Saint Pé France   >   Midi-Pyrénées   >   Haute-Pyrénées (65)
vague du breuil en auge France   >   Normandie   >   Calvados (14)
Vague du KCT France   >   Limousin   >   Corrèze (19)
Vague du Moulin France   >   Midi-Pyrénées   >   Tarn (81)
Vague du nil France   >   Poitou-Charentes   >   Charente (16)
vague du privilege France   >   Aquitaine   >   Dordogne (24)
Vagues d'Itxassou France   >   Aquitaine   >   Pyrénées-Atlantiques (64)
veine de st seurin France   >   Aquitaine   >   Gironde (33)
Vendôme France   >   Centre   >   Loir-et-Cher (41)
Véretz France   >   Centre   >   Indre-et-Loire (37)
Vinon sur Verdon France   >   Provence-Alpes-Côte d'Azur   >   Var (83)
voguette France   >   Rhône-Alpes   >   Ardèche (07)
Voray sur l'Ognon France   >   Franche-Comté   >   Haute-Saone (70)
Vuillafans Ile à ramage France   >   Franche-Comté   >   Doubs (25)
 
(default) 764 queries took 240 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `topos`10101
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_bin';111
3SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';111
4SHOW FULL COLUMNS FROM `topo_spot_details`20201
5SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';111
6SHOW FULL COLUMNS FROM `attachments`19191
7SHOW FULL COLUMNS FROM `topo_commentaires`661
8SHOW FULL COLUMNS FROM `niveaux`12121
9SHOW FULL COLUMNS FROM `niveau_stations_de_mesures`10101
10SHOW FULL COLUMNS FROM `phpbb_users`76762
11SHOW FULL COLUMNS FROM `coordonnees_administratives`991
12SHOW FULL COLUMNS FROM `aide_edition_topos`771
13SHOW FULL COLUMNS FROM `phpbb_profile_fields_data`12121
14SHOW FULL COLUMNS FROM `clubs_ffck`15151
15SHOW FULL COLUMNS FROM `petite_annonces`12121
16SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_swedish_ci';111
17SHOW FULL COLUMNS FROM `petite_annonce_types`551
18SHOW FULL COLUMNS FROM `petite_annonce_categories`221
19SHOW FULL COLUMNS FROM `petite_annonce_matos_types`331
20SHOW FULL COLUMNS FROM `attachments_links`661
21SHOW FULL COLUMNS FROM `petite_annonce_commentaires`661
22SHOW FULL COLUMNS FROM `petite_annonce_disciplines`331
23SHOW FULL COLUMNS FROM `petite_annonces_petite_annonce_disciplines`331
24SHOW FULL COLUMNS FROM `niveau_alertes`551
25SHOW FULL COLUMNS FROM `topo_types`221
26SHOW FULL COLUMNS FROM `topo_bassins`221
27SHOW FULL COLUMNS FROM `topo_bassin_details`21211
28SHOW FULL COLUMNS FROM `topo_parcours`441
29SHOW FULL COLUMNS FROM `topo_parcours_details`25251
30SHOW FULL COLUMNS FROM `topo_rivieres`221
31SHOW FULL COLUMNS FROM `topo_riviere_details`35352
32SHOW FULL COLUMNS FROM `topo_spots`221
33SHOW FULL COLUMNS FROM `niveau_references_de_niveaux`11111
34SHOW FULL COLUMNS FROM `niveau_source_donnees`661
35SHOW FULL COLUMNS FROM `niveau_donnees_temps_reels`12121
36SHOW FULL COLUMNS FROM `niveau_references_de_niveau_types`221
37SHOW FULL COLUMNS FROM `niveau_evaluations`331
38SHOW FULL COLUMNS FROM `coordonnee_administrative_topos`331
39SHOW FULL COLUMNS FROM `coordonnee_administrative_types`221
40select T.id,T.nom,T.slug,T.topo_type_id from topos T where T.topo_type_id = 2 order by nom collate utf8_unicode_ci asc2152153
41select T.topo_type_id from topos T where T.id=665111
42select count(*) from topo_spots TS,topo_spot_details TSD where TS.topo_id=665 and TSD.topo_spot_id=TS.id and TSD.etat >= 0110
43select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 665)111
44select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=118 and CA.coordonnee_administrative_type_id=CAT.id110
45select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=24 and CA.coordonnee_administrative_type_id=CAT.id110
46select 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.id110
47select T.topo_type_id from topos T where T.id=797110
48select count(*) from topo_spots TS,topo_spot_details TSD where TS.topo_id=797 and TSD.topo_spot_id=TS.id and TSD.etat >= 0110
49select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 797)111
50select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=115 and CA.coordonnee_administrative_type_id=CAT.id110
51select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=37 and CA.coordonnee_administrative_type_id=CAT.id110
52select T.topo_type_id from topos T where T.id=708110
53select count(*) from topo_spots TS,topo_spot_details TSD where TS.topo_id=708 and TSD.topo_spot_id=TS.id and TSD.etat >= 0110
54select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 708)111
55select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=110 and CA.coordonnee_administrative_type_id=CAT.id110
56select T.topo_type_id from topos T where T.id=751110
57select count(*) from topo_spots TS,topo_spot_details TSD where TS.topo_id=751 and TSD.topo_spot_id=TS.id and TSD.etat >= 0110
58select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 751)111
59select T.topo_type_id from topos T where T.id=683110
60select count(*) from topo_spots TS,topo_spot_details TSD where TS.topo_id=683 and TSD.topo_spot_id=TS.id and TSD.etat >= 0110
61select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 683)111
62select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=125 and CA.coordonnee_administrative_type_id=CAT.id110
63select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=25 and CA.coordonnee_administrative_type_id=CAT.id110
64select T.topo_type_id from topos T where T.id=716110
65select count(*) from topo_spots TS,topo_spot_details TSD where TS.topo_id=716 and TSD.topo_spot_id=TS.id and TSD.etat >= 0110
66select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 716)111
67select T.topo_type_id from topos T where T.id=696110
68select count(*) from topo_spots TS,topo_spot_details TSD where TS.topo_id=696 and TSD.topo_spot_id=TS.id and TSD.etat >= 0110
69select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 696)111
70select T.topo_type_id from topos T where T.id=739110
71select count(*) from topo_spots TS,topo_spot_details TSD where TS.topo_id=739 and TSD.topo_spot_id=TS.id and TSD.etat >= 0110
72select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 739)111
73select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=206 and CA.coordonnee_administrative_type_id=CAT.id110
74select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=40 and CA.coordonnee_administrative_type_id=CAT.id110
75select T.topo_type_id from topos T where T.id=1860110
76select count(*) from topo_spots TS,topo_spot_details TSD where TS.topo_id=1860 and TSD.topo_spot_id=TS.id and TSD.etat >= 0110
77select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 1860)111
78select T.topo_type_id from topos T where T.id=701110
79select count(*) from topo_spots TS,topo_spot_details TSD where TS.topo_id=701 and TSD.topo_spot_id=TS.id and TSD.etat >= 0110
80select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 701)111
81select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=169 and CA.coordonnee_administrative_type_id=CAT.id110
82select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=36 and CA.coordonnee_administrative_type_id=CAT.id110
83select T.topo_type_id from topos T where T.id=676110
84select count(*) from topo_spots TS,topo_spot_details TSD where TS.topo_id=676 and TSD.topo_spot_id=TS.id and TSD.etat >= 0110
85select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 676)111
86select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=146 and CA.coordonnee_administrative_type_id=CAT.id110
87select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=29 and CA.coordonnee_administrative_type_id=CAT.id110
88select T.topo_type_id from topos T where T.id=657110
89select count(*) from topo_spots TS,topo_spot_details TSD where TS.topo_id=657 and TSD.topo_spot_id=TS.id and TSD.etat >= 0110
90select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 657)111
91select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=172 and CA.coordonnee_administrative_type_id=CAT.id110
92select T.topo_type_id from topos T where T.id=788110
93select count(*) from topo_spots TS,topo_spot_details TSD where TS.topo_id=788 and TSD.topo_spot_id=TS.id and TSD.etat >= 0110
94select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 788)111
95select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=156 and CA.coordonnee_administrative_type_id=CAT.id110
96select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=30 and CA.coordonnee_administrative_type_id=CAT.id110
97select T.topo_type_id from topos T where T.id=682110
98select count(*) from topo_spots TS,topo_spot_details TSD where TS.topo_id=682 and TSD.topo_spot_id=TS.id and TSD.etat >= 0110
99select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 682)111
100select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=94 and CA.coordonnee_administrative_type_id=CAT.id110
101select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=43 and CA.coordonnee_administrative_type_id=CAT.id110
102select T.topo_type_id from topos T where T.id=2079110
103select count(*) from topo_spots TS,topo_spot_details TSD where TS.topo_id=2079 and TSD.topo_spot_id=TS.id and TSD.etat >= 0110
104select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2079)111
105select T.topo_type_id from topos T where T.id=740110
106select count(*) from topo_spots TS,topo_spot_details TSD where TS.topo_id=740 and TSD.topo_spot_id=TS.id and TSD.etat >= 0110
107select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 740)111
108select T.topo_type_id from topos T where T.id=700110
109select count(*) from topo_spots TS,topo_spot_details TSD where TS.topo_id=700 and TSD.topo_spot_id=TS.id and TSD.etat >= 0110
110select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 700)111
111select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=120 and CA.coordonnee_administrative_type_id=CAT.id110
112select T.topo_type_id from topos T where T.id=650110
113select count(*) from topo_spots TS,topo_spot_details TSD where TS.topo_id=650 and TSD.topo_spot_id=TS.id and TSD.etat >= 0110
114select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 650)111
115select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=114 and CA.coordonnee_administrative_type_id=CAT.id110
116select T.topo_type_id from topos T where T.id=664110
117select count(*) from topo_spots TS,topo_spot_details TSD where TS.topo_id=664 and TSD.topo_spot_id=TS.id and TSD.etat >= 0110
118select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 664)110
119select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=93 and CA.coordonnee_administrative_type_id=CAT.id110
120select T.topo_type_id from topos T where T.id=651110
121select count(*) from topo_spots TS,topo_spot_details TSD where TS.topo_id=651 and TSD.topo_spot_id=TS.id and TSD.etat >= 0110
122select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 651)110
123select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=111 and CA.coordonnee_administrative_type_id=CAT.id110
124select T.topo_type_id from topos T where T.id=786110
125select count(*) from topo_spots TS,topo_spot_details TSD where TS.topo_id=786 and TSD.topo_spot_id=TS.id and TSD.etat >= 0110
126select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 786)110
127select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=140 and CA.coordonnee_administrative_type_id=CAT.id110
128select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=28 and CA.coordonnee_administrative_type_id=CAT.id110
129select T.topo_type_id from topos T where T.id=784110
130select count(*) from topo_spots TS,topo_spot_details TSD where TS.topo_id=784 and TSD.topo_spot_id=TS.id and TSD.etat >= 0110
131select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 784)111
132select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=170 and CA.coordonnee_administrative_type_id=CAT.id110
133select T.topo_type_id from topos T where T.id=771110
134select count(*) from topo_spots TS,topo_spot_details TSD where TS.topo_id=771 and TSD.topo_spot_id=TS.id and TSD.etat >= 0110
135select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 771)111
136select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=153 and CA.coordonnee_administrative_type_id=CAT.id110
137select T.topo_type_id from topos T where T.id=782110
138select count(*) from topo_spots TS,topo_spot_details TSD where TS.topo_id=782 and TSD.topo_spot_id=TS.id and TSD.etat >= 0110
139select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 782)111
140select T.topo_type_id from topos T where T.id=750110
141select count(*) from topo_spots TS,topo_spot_details TSD where TS.topo_id=750 and TSD.topo_spot_id=TS.id and TSD.etat >= 0110
142select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 750)111
143select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=171 and CA.coordonnee_administrative_type_id=CAT.id110
144select T.topo_type_id from topos T where T.id=789110
145select count(*) from topo_spots TS,topo_spot_details TSD where TS.topo_id=789 and TSD.topo_spot_id=TS.id and TSD.etat >= 0110
146select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 789)111
147select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=116 and CA.coordonnee_administrative_type_id=CAT.id110
148select T.topo_type_id from topos T where T.id=742110
149select count(*) from topo_spots TS,topo_spot_details TSD where TS.topo_id=742 and TSD.topo_spot_id=TS.id and TSD.etat >= 0110
150select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 742)111
151select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=106 and CA.coordonnee_administrative_type_id=CAT.id110
152select 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.id110
153select T.topo_type_id from topos T where T.id=746110
154select count(*) from topo_spots TS,topo_spot_details TSD where TS.topo_id=746 and TSD.topo_spot_id=TS.id and TSD.etat >= 0110
155select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 746)111
156select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=157 and CA.coordonnee_administrative_type_id=CAT.id110
157select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=32 and CA.coordonnee_administrative_type_id=CAT.id110
158select T.topo_type_id from topos T where T.id=1640110
159select count(*) from topo_spots TS,topo_spot_details TSD where TS.topo_id=1640 and TSD.topo_spot_id=TS.id and TSD.etat >= 0110
160select T.topo_type_id from topos T where T.id=749110
161select count(*) from topo_spots TS,topo_spot_details TSD where TS.topo_id=749 and TSD.topo_spot_id=TS.id and TSD.etat >= 0110
162select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 749)111
163select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=141 and CA.coordonnee_administrative_type_id=CAT.id110
164select T.topo_type_id from topos T where T.id=689110
165select count(*) from topo_spots TS,topo_spot_details TSD where TS.topo_id=689 and TSD.topo_spot_id=TS.id and TSD.etat >= 0110
166select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 689)111
167select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=123 and CA.coordonnee_administrative_type_id=CAT.id110
168select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=35 and CA.coordonnee_administrative_type_id=CAT.id110
169select T.topo_type_id from topos T where T.id=768110
170select count(*) from topo_spots TS,topo_spot_details TSD where TS.topo_id=768 and TSD.topo_spot_id=TS.id and TSD.etat >= 0110
171select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 768)111
172select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=133 and CA.coordonnee_administrative_type_id=CAT.id110
173select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=39 and CA.coordonnee_administrative_type_id=CAT.id110
174select T.topo_type_id from topos T where T.id=672110
175select count(*) from topo_spots TS,topo_spot_details TSD where TS.topo_id=672 and TSD.topo_spot_id=TS.id and TSD.etat >= 0110
176select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 672)111
177select T.topo_type_id from topos T where T.id=717110
178select count(*) from topo_spots TS,topo_spot_details TSD where TS.topo_id=717 and TSD.topo_spot_id=TS.id and TSD.etat >= 0110
179select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 717)111
180select T.topo_type_id from topos T where T.id=772110
181select count(*) from topo_spots TS,topo_spot_details TSD where TS.topo_id=772 and TSD.topo_spot_id=TS.id and TSD.etat >= 0110
182select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 772)111
183select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=65 and CA.coordonnee_administrative_type_id=CAT.id110
184select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=17 and CA.coordonnee_administrative_type_id=CAT.id110
185select T.topo_type_id from topos T where T.id=761110
186select count(*) from topo_spots TS,topo_spot_details TSD where TS.topo_id=761 and TSD.topo_spot_id=TS.id and TSD.etat >= 0110
187select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 761)111
188select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=144 and CA.coordonnee_administrative_type_id=CAT.id110
189select T.topo_type_id from topos T where T.id=685110
190select count(*) from topo_spots TS,topo_spot_details TSD where TS.topo_id=685 and TSD.topo_spot_id=TS.id and TSD.etat >= 0110
191select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 685)111
192select T.topo_type_id from topos T where T.id=736110
193select count(*) from topo_spots TS,topo_spot_details TSD where TS.topo_id=736 and TSD.topo_spot_id=TS.id and TSD.etat >= 0110
194select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 736)111
195select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=46 and CA.coordonnee_administrative_type_id=CAT.id110
196select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=9 and CA.coordonnee_administrative_type_id=CAT.id110
197select T.topo_type_id from topos T where T.id=1646110
198select count(*) from topo_spots TS,topo_spot_details TSD where TS.topo_id=1646 and TSD.topo_spot_id=TS.id and TSD.etat >= 0110
199select T.topo_type_id from topos T where T.id=1674110
200select count(*) from topo_spots TS,topo_spot_details TSD where TS.topo_id=1674 and TSD.topo_spot_id=TS.id and TSD.etat >= 0110