User:Gz260/Roads/A (F)/Wikidata/Métropole

• list
• all
• en
• fr
• fr (+ WS)

• Related properties

Last update : Sunday 19 November 2023 12:33:25

Manually update list

This list is periodically updated by a bot. Manual changes to the list will be removed on the next update!

WDQS | PetScan | TABernacle | Find images | Recent changes | Query: SELECT DISTINCT ?item ?p1824 WHERE { { ?item wdt:P31 wd:Q3456602 } UNION { ?item wdt:P16 wd:Q3456602 } . MINUS { VALUES ?outre_mer { wd:Q17012 wd:Q17054 wd:Q3769 wd:Q17070 wd:Q34617 wd:Q17063 wd:Q25362 wd:Q126125 } . ?item wdt:P131 ?outre_mer } . OPTIONAL { ?item wdt:P1824 ?p1824 } BIND(STRLEN(str(?p1824)) as ?longp1824) BIND(SUBSTR(str(?p1824),1,1) as ?statut) BIND(SUBSTR(str(?p1824),2,(?longp1824 - 1)) as ?numero) BIND(REPLACE(SUBSTR(str(?numero),1,4),"[A-Za-z ]","") as ?num) BIND(STRLEN(str(?num)) as ?longnum) BIND(CONCAT(IF(?longnum=1,"000",IF(?longnum=2,"00",IF(?longnum=3,"0",""))), str(?num)) as ?numz) BIND(CONCAT(str(?statut),str(?num)) as ?numsp) BIND(STRLEN(str(?numsp)) as ?longnumsp) BIND((?longp1824 - ?longnumsp) as ?longprefixe) BIND(SUBSTR(str(?p1824),(?longnumsp + 1),?longprefixe) as ?prefixe) BIND(CONCAT(str(?statut),str(?numz),str(?prefixe)) as ?cledetri) } ORDER BY ?cledetri

#	Article	Item Wikidata	Pays	located in the administrative territorial entity	part of	Commons	road number
1	autoroute des Deux Mers	Q788997	France		European route E72 European route E9 in France European route E80 in France
2	autoroute 62	Q105732881	France	Toulouse	A62 autoroute road network of Toulouse
3	autoroute 61	Q105732883	France	Toulouse	A61 autoroute road network of Toulouse
4	autoroute 624	Q105734619	France	Toulouse	A624 autoroute road network of Toulouse
5	autoroute 68	Q105735413	France	Toulouse	A68 autoroute road network of Toulouse
6	autoroute 621	Q105735414	France	Toulouse	A621 autoroute road network of Toulouse
7	autoroute 64	Q105736075	France	Toulouse	A64 autoroute road network of Toulouse
8	A1 autoroute	Q692788	France	Paris Seine-Saint-Denis Val-d'Oise Oise Somme Pas-de-Calais Nord		A1 autoroute	A1
9	A1a autoroute	Q71852917	France	Nord			A1a
10	A2 autoroute	Q168759	France	Somme Pas-de-Calais Nord	European route E19 in France	A2 autoroute	A2
11	A3 autoroute	Q788719	France	Paris Seine-Saint-Denis Val-d'Oise	European route E15 in France	A3 autoroute	A3
12	A4 autoroute	Q733222	France	Paris Val-de-Marne Seine-Saint-Denis Seine-et-Marne Aisne Marne Meuse Meurthe-et-Moselle Moselle Bas-Rhin	European route E50 in France European route E17 in France European route E25 in France	A4 autoroute	A4
13	A5 autoroute	Q788832	France	Seine-et-Marne Yonne Aube Haute-Marne	European route E54 in France European route E511 European route E17 in France	A5 autoroute	A5
14	A6 autoroute	Q1595	France	Paris Val-de-Marne Essonne Seine-et-Marne Loiret Yonne Côte-d’Or Saône-et-Loire Rhône	European route E15 in France European route E60 in France European route E21	A6 autoroute (France)	A6
15	A6a autoroute	Q9162821	France	Paris Val-de-Marne Essonne	European route E5 in France	A6a autoroute (France)	A6a
16	A6b autoroute	Q9162818	France	Paris Val-de-Marne Essonne	European route E50 in France	A6b autoroute (France)	A6b
17	A7 autoroute	Q788948	France	Rhône Isère Drôme Vaucluse Bouches-du-Rhône	European route E15 in France European route E80 in France European route E714	A7 autoroute	A7
18	A8 autoroute	Q281357	France	Bouches-du-Rhône Var Alpes-Maritimes	European route E80 in France European route E74 in France	A8 autoroute	A8
19	A9 autoroute	Q789003	France	Vaucluse Var Hérault Aude Pyrénées-Orientales	European route E15 in France European route E80 in France	A9 autoroute	A9
20	A10 autoroute	Q788639	France	Val-de-Marne Hauts-de-Seine Essonne Loiret Loir-et-Cher Indre-et-Loire Vienne Deux-Sèvres Charente-Maritime Gironde		A10 autoroute	A10
21	A11 autoroute	Q788641	France	Yvelines Eure-et-Loir Sarthe Maine-et-Loire Loire-Atlantique	European route E50 in France European route E501 European route E60 in France	A11 autoroute	A11
22	A12 autoroute	Q788644	France	Yvelines		A12 autoroute	A12
23	A13 autoroute	Q788648	France	Paris Hauts-de-Seine Yvelines Eure Seine-Maritime Calvados	European route E5 in France European route E46 in France European route E402	A13 autoroute	A13
24	A13a autoroute	Q55501427	France	Yvelines		A13a autoroute	A13a
25	A14 autoroute	Q125360	France	Hauts-de-Seine Yvelines		A14 autoroute	A14
26	A15 autoroute	Q788666	France	Hauts-de-Seine Val-d'Oise		A15 autoroute	A15
27	A16 autoroute	Q788670	France	Val-d'Oise Oise Somme Pas-de-Calais Nord	European route E44 in France European route E402 European route E15 in France European route E40 in France	A16 autoroute	A16
28	A17 autoroute	Q98783297	France				A17
29	A18 autoroute	Q99194153	France				A18
30	A19 autoroute	Q788673	France	Yonne Loiret	European route E511 European route E60 in France	A19 autoroute	A19
31	A20 autoroute	Q788682	France	Cher Indre Creuse Haute-Vienne Corrèze Lot Tarn-et-Garonne	European route E9 in France European route E70 in France	A20 autoroute	A20
32	A21 autoroute	Q788683	France	Pas-de-Calais Nord		A21 autoroute	A21
33	A22 autoroute	Q788697	France	Nord	European route E17 in France European route E42 in France	A22 autoroute	A22
34	A23 autoroute	Q788695	France	Nord		A23 autoroute	A23
35	A24 autoroute	Q788700	France	Somme Pas-de-Calais Nord			A24
36	A25 autoroute	Q788704	France	Nord	European route E42 in France	A25 autoroute	A25
37	A26 autoroute	Q788708	France	Pas-de-Calais Nord Somme Aisne Marne Aube	European route E15 in France European route E17 in France	A26 autoroute	A26
38	A27 autoroute	Q788710	France	Nord	European route E42 in France	A27 autoroute	A27
39	A28 autoroute	Q168746	France	Somme Seine-Maritime Eure Calvados Orne Sarthe Indre-et-Loire	European route E402 European route E44 in France European route E502	A28 autoroute	A28
40	A29 autoroute	Q176069	France	Eure Calvados Seine-Maritime Somme Aisne	European route E44 in France	A29 autoroute	A29
41	A30 autoroute	Q788716	France	Moselle	European route E411	A30 autoroute	A30
42	A31 autoroute	Q788721	France	Côte-d’Or Haute-Marne Vosges Meurthe-et-Moselle Moselle	European route E21 European route E60 in France European route E17 in France European route E23 in France European route E25 in France	A31 autoroute	A31
43	A32 autoroute	Q788731	France				A32
44	A33 autoroute	Q168773	France	Meurthe-et-Moselle	European route E23 in France	A33 autoroute	A33
45	A34 autoroute	Q788742	France	Marne Ardennes	European route E46 in France	A34 autoroute	A34
46	A35 autoroute	Q788750	France	Bas-Rhin Haut-Rhin	European route E25 in France	A35 autoroute	A35
47	A36 autoroute	Q788763	France	Côte-d’Or Jura Doubs Territoire de Belfort Haut-Rhin	European route E60 in France	A36 autoroute	A36
48	A37 autoroute	Q2872910	France				A37
49	A38 autoroute	Q573445	France	Côte-d’Or		A38 autoroute	A38
50	A39 autoroute	Q581523	France	Côte-d’Or Jura Saône-et-Loire Ain		A39 autoroute	A39
51	A40 autoroute	Q788772	France	Saône-et-Loire Ain Haute-Savoie	European route E21 European route E62 in France European route E25 in France European route E712	A40 autoroute	A40
52	A41 autoroute	Q788784	France	Isère Savoie Haute-Savoie	European route E712 European route E62 in France European route E25 in France	A41 autoroute	A41
53	A42 autoroute	Q429675	France	Rhône Ain	European route E611	A42 autoroute	A42
54	A43 autoroute	Q429696	France	Rhône Isère Savoie	European route E70 in France European route E711 European route E712	A43 autoroute	A43
55	A44 autoroute	Q788799	France	Rhône Loire Isère			A44
56	A45 autoroute	Q788809	France	Rhône Loire		A45 autoroute	A45
57	A46 autoroute	Q788814	France	Rhône	European route E15 in France European route E70 in France	A46 autoroute	A46
58	A47 autoroute	Q788816	France	Rhône Loire		A47 autoroute	A47
59	A48 autoroute	Q788825	France	Isère	European route E711 European route E713	A48 autoroute	A48
60	A49 autoroute	Q168762	France	Drôme Isère	European route E713	A49 autoroute	A49
61	A50 autoroute	Q788833	France	Bouches-du-Rhône Var		A50 autoroute	A50
62	A51 autoroute	Q788853	France	Bouches-du-Rhône Vaucluse Alpes-de-Haute-Provence Hautes-Alpes Isère	European route E712	A51 autoroute	A51
63	A52 autoroute	Q788873	France	Bouches-du-Rhône		A52 autoroute	A52
64	A53 autoroute	Q15784789	France				A53
65	A54 autoroute	Q1878233	France	Gard Bouches-du-Rhône	European route E80 in France	A54 autoroute	A54
66	A55 autoroute	Q788879	France	Bouches-du-Rhône		A55 autoroute	A55
67	A56 autoroute	Q788889	France	Bouches-du-Rhône			A56
68	A57 autoroute	Q585851	France	Var		A57 autoroute	A57
69	A58 autoroute	Q2872918	France	Alpes-Maritimes			A58
70	A61 autoroute	Q168781	France	Haute-Garonne Aude	autoroute des Deux Mers European route E80 in France European route E9 in France	A61 autoroute	A61
71	A62 autoroute	Q788904	France	Gironde Lot-et-Garonne Tarn-et-Garonne Haute-Garonne	autoroute des Deux Mers European route E72 European route E9 in France	A62 autoroute	A62
72	A63 autoroute	Q168801	France	Pyrénées-Atlantiques Landes Gironde	European route E5 in France European route E70 in France European route E80 in France	A63 autoroute	A63
73	A64 autoroute	Q659709	France	Pyrénées-Atlantiques Hautes-Pyrénées Haute-Garonne	European route E80 in France	A64 autoroute	A64
74	A65 autoroute	Q788929	France	Gironde Landes Pyrénées-Atlantiques	European route E7 in France	A65 autoroute	A65
75	A66 autoroute	Q788936	France	Haute-Garonne Ariège	European route E9 in France	A66 autoroute	A66
76	A67 autoroute	Q99510213	France	Seine-et-Marne Loiret			A67
77	A68 autoroute	Q788942	France	Haute-Garonne Tarn		A68 autoroute	A68
78	A69 motorway	Q55681451	France	Haute-Garonne Tarn			A69
79	A71 autoroute	Q788946	France	Loiret Cher Allier Puy-de-Dôme	European route E9 in France European route E11 European route E70 in France	A71 autoroute	A71
80	A72 autoroute	Q642851	France	Loire		A72 autoroute	A72
81	A73 autoroute	Q99672659	France				A73
82	A74 autoroute	Q98590345	France				A74
83	A75 autoroute	Q429949	France	Puy-de-Dôme Haute-Loire Cantal Lozère Aveyron Hérault	European route E11	A75 autoroute	A75
84	A77 autoroute	Q168750	France	Seine-et-Marne Loiret Nièvre		A77 autoroute	A77
85	A79 autoroute	Q788968	France	Rhône Isère Drôme Ardèche Gard Hérault Aude			A79
86	A79 autoroute	Q30017777	France	Allier Saône-et-Loire	European route E62 in France	A79 autoroute	A79
87	A81 autoroute	Q788973	France	Sarthe Mayenne	European route E50 in France	A81 autoroute	A81
88	A82 autoroute	Q788971	France	Loire-Atlantique	European route E60 in France		A82
89	A83 autoroute	Q788977	France	Loire-Atlantique Vendée Deux-Sèvres	European route E3	A83 autoroute	A83
90	A84 autoroute	Q788978	France	Ille-et-Vilaine Manche Calvados	European route E3 European route E401	A84 autoroute	A84
91	A85 autoroute	Q788979	France	Maine-et-Loire Indre-et-Loire Loir-et-Cher Cher	European route E60 in France European route E604	A85 autoroute	A85
92	A86 autoroute	Q788981	France	Hauts-de-Seine Seine-Saint-Denis Val-de-Marne Essonne Yvelines		A86 autoroute	A86
93	A87 autoroute	Q788984	France	Maine-et-Loire Vendée		A87 autoroute	A87
94	autoroute A87	Q60484469	France				A87
95	A88 autoroute	Q2872940	France	Calvados Orne			A88
96	A89 autoroute	Q788989	France	Gironde Dordogne Corrèze Puy-de-Dôme Loire Rhône	European route E70 in France	A89 autoroute	A89
97	A103 autoroute	Q2602674	France	Seine-Saint-Denis			A103
98	A104 autoroute	Q689673	France	Val-d'Oise Seine-Saint-Denis Seine-et-Marne	Francilienne	A104 autoroute	A104
99	A105 autoroute	Q788638	France	Seine-et-Marne			A105
100	A106 autoroute	Q168764	France	Val-de-Marne Essonne		A106 autoroute	A106
101	A110 autoroute	Q788642	France	Eure-et-Loir Loir-et-Cher Indre-et-Loire			A110
102	A112 autoroute	Q2872896	France	Hauts-de-Seine Yvelines			A112
103	A115 autoroute	Q788643	France	Val-d'Oise		A115 autoroute	A115
104	A120 autoroute	Q55503623	France	Eure-et-Loir			A120
105	A126 autoroute	Q788646	France	Essonne		A126 autoroute	A126
106	A131 autoroute	Q788650	France	Eure Seine-Maritime	European route E5 in France	A131 autoroute	A131
107	A132 autoroute	Q788655	France	Calvados		A132 autoroute	A132
108	A133 autoroute	Q48758275	France	Seine-Maritime Eure			A133
109	A134 autoroute	Q48758409	France	Seine-Maritime			A134
110	A139 autoroute	Q788658	France	Seine-Maritime		A139 autoroute	A139
111	A140 autoroute	Q168747	France	Seine-et-Marne		A140 autoroute	A140
112	autoroute A147	Q60847929	France				A147
113	A150 autoroute	Q783403	France	Seine-Maritime		A150 autoroute	A150
114	A151 autoroute	Q179664	France	Seine-Maritime		A151 autoroute	A151
115	A154 autoroute	Q654709	France	Eure		A154 autoroute	A154
116	A170 autoroute	Q15784786	France	Val-d'Oise Seine-Saint-Denis			A170
117	A186 autoroute	Q15784787	France	Seine-Saint-Denis		A186 autoroute	A186
118	A199 autoroute	Q584625	France	Seine-et-Marne		A199 autoroute	A199
119	A203 autoroute	Q2872899	France	Ardennes			A203
120	A211 autoroute	Q788686	France	Pas-de-Calais			A211
121	A216 autoroute	Q788690	France	Pas-de-Calais			A216
122	A260 autoroute	Q2872902	France	Pas-de-Calais			A260
123	A304 autoroute	Q2872904	France	Ardennes			A304
124	A311 autoroute	Q636647	France	Côte-d’Or		A311 autoroute	A311
125	A313 autoroute	Q788724	France	Meurthe-et-Moselle		A313 autoroute	A313
126	A314 autoroute	Q788727	France	Moselle			A314
127	A315 autoroute	Q674210	France	Moselle			A315
128	A319 autoroute	Q2872906	France	Haute-Marne Haute-Saône			A319
129	A320 autoroute	Q762869	France	Moselle	European route E50 in France		A320
130	A330 autoroute	Q788740	France	Meurthe-et-Moselle	European route E23 in France	A330 autoroute	A330
131	A340 autoroute	Q132123	France	Bas-Rhin			A340
132	A344 autoroute	Q14748912	France	Marne		A344 autoroute	A344
133	A346 autoroute	Q2872908	France				A346
134	A350 autoroute	Q788748	France	Bas-Rhin			A350
135	A351 autoroute	Q788752	France	Bas-Rhin		A351 autoroute	A351
136	A352 autoroute	Q788757	France	Bas-Rhin		A352 autoroute	A352
137	A355 autoroute	Q2872909	France	Bas-Rhin		A355 autoroute	A355
138	A391 autoroute	Q2602681	France	Jura		A391 autoroute	A391
139	A400 autoroute	Q2872913	France	Haute-Savoie			A400
140	A401 autoroute	Q2055411	France	Haute-Savoie		A401 autoroute	A401
141	A404 autoroute	Q168766	France	Ain		A404 autoroute	A404
142	A406 autoroute	Q788782	France	Ain Saône-et-Loire	European route E62 in France	A406 autoroute	A406
143	A410 autoroute	Q788788	France	Haute-Savoie	European route E712	A410 autoroute	A410
144	A411 autoroute	Q788793	France	Haute-Savoie		A411 autoroute	A411
145	A412 autoroute	Q82463253	France	Haute-Savoie			A412
146	A430 autoroute	Q168777	France	Savoie		A430 autoroute	A430
147	A432 autoroute	Q788798	France	Ain Isère Rhône		A432 autoroute	A432
148	A450 autoroute	Q788805	France	Rhône		A450 autoroute	A450
149	A466 autoroute	Q2872915	France	Rhône		A466 autoroute	A466
150	A480 autoroute	Q788823	France	Isère	European route E712 rocade de Grenoble	A480 autoroute	A480
151	A500 autoroute	Q788838	France	Alpes-Maritimes		A500 autoroute	A500
152	A501 autoroute	Q788840	France	Bouches-du-Rhône			A501
153	A502 autoroute	Q788847	France	Bouches-du-Rhône			A502
154	A507 autoroute	Q2872916	France	Bouches-du-Rhône		A507 autoroute	A507
155	A508 autoroute	Q17521431	France	Var			A508
156	A510 autoroute	Q17521432	France	Bouches-du-Rhône Var			A510
157	A515 autoroute	Q788855	France	Bouches-du-Rhône			A515
158	A516 autoroute	Q788859	France	Bouches-du-Rhône			A516
159	A517 autoroute	Q788861	France	Bouches-du-Rhône			A517
160	A520 autoroute	Q788870	France	Bouches-du-Rhône			A520
161	A551 autoroute	Q15784790	France	Bouches-du-Rhône			A551
162	A552 autoroute	Q15784791	France	Bouches-du-Rhône			A552
163	A557 autoroute	Q788885	France	Bouches-du-Rhône			A557
164	A570 autoroute	Q788891	France	Var			A570
165	A585 autoroute	Q2872919	France	Alpes-de-Haute-Provence			A585
166	A620 autoroute	Q788900	France	Haute-Garonne	European route E80 in France Périphérique de Toulouse	A620 autoroute	A620
167	A621 autoroute	Q746596	France	Haute-Garonne		A621 autoroute	A621
168	A623 autoroute	Q2872920	France	Haute-Garonne			A623
169	A624 autoroute	Q788908	France	Haute-Garonne		A624 autoroute	A624
170	A630 autoroute	Q788916	France	Gironde	Rocade de Bordeaux	A630 autoroute	A630
171	A631 autoroute	Q788913	France	Gironde		A631 autoroute	A631
172	A641 autoroute	Q788923	France	Landes			A641
173	A645 autoroute	Q728493	France	Haute-Garonne			A645
174	A650 autoroute	Q2872922	France	Pyrénées-Atlantiques			A650
175	A660 autoroute	Q788934	France	Gironde		A660 autoroute	A660
176	A680 autoroute	Q788938	France	Haute-Garonne			A680
177	A701 autoroute	Q2614175	France	Loiret		A701 autoroute	A701
178	A709 autoroute	Q28940905	France	Hérault		A709 autoroute	A709
179	A710 autoroute	Q15784792	France	Puy-de-Dôme			A710
180	A711 autoroute	Q788950	France	Puy-de-Dôme		A711 autoroute	A711
181	A712 autoroute	Q15784793	France	Puy-de-Dôme			A712
182	A714 autoroute	Q788954	France	Allier	European route E62 in France	A714 autoroute	A714
183	A719 autoroute	Q788955	France	Allier		A719 autoroute	A719
184	A749 autoroute	Q17521433	France	Drôme			A749
185	A750 autoroute	Q788963	France	Hérault		A750 autoroute	A750
186	A801 autoroute	Q15784794	France	Loire-Atlantique			A801
187	A810 autoroute	Q15784795	France	Deux-Sèvres Charente-Maritime			A810
188	A811 autoroute	Q2872928	France	Loire-Atlantique		A811 autoroute	A811
189	A813 autoroute	Q2872927	France	Calvados			A813
190	A821 autoroute	Q2872925	France	Loire-Atlantique			A821
191	A831 autoroute	Q2872934	France	Vendée Charente-Maritime		A831 autoroute	A831
192	A837 autoroute	Q788976	France	Charente-Maritime	European route E602	A837 autoroute	A837
193	A844 autoroute	Q2872936	France	Loire-Atlantique	Nantes ring road European route E60 in France European route E3	A844 autoroute	A844
194	A851 autoroute	Q17521434	France				A851
195	A11.1 autoroute	Q59208995	France	Sarthe			A11.1

End of automatically generated list.