User:Gz260/Roads/RN (F)/Wikidata/Overseas/973/fr
Guyane
[edit]Dernière mise à jour : Wednesday 15 November 2023 01:58:03
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 ?itemLabel ?article (IF(bound(?article),CONCAT("{","{subst:Urltowiki\u007Curl=", str(?article), "\u007Cdisplay=", str(?itemLabel), "}","}"),str(?itemLabel)) As ?wparticle) ?p1824 WHERE { { ?item wdt:P31 wd:Q1426271 } UNION { ?item wdt:P16 wd:Q1426271 } .?item p:P131/ps:P131 wd:Q3769 . OPTIONAL { ?article schema:about ?item ; schema:inLanguage "fr" ; schema:isPartOf <https://fr.wikipedia.org/> } . 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) . OPTIONAL { ?item wdt:P131 ?loc } . OPTIONAL { ?loc wdt:P2586 ?code } . SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . } } ORDER BY ?cledetri ?code
# | Article | (fr) | Item Wikidata | Country | localisation administrative | Commons | numéro de route |
---|---|---|---|---|---|---|---|
1 | route nationale 1 | route nationale 1 | Q26460278 | France | Guyane | Route nationale 1 (French Guiana) | N1 |
2 | route nationale 1bis | route nationale 1bis | Q114064354 | France | Guyane | N1bis | |
3 | route nationale 2 | route nationale 2 | Q26460491 | France | Guyane | Route nationale 2 (French Guiana) | N2 |
4 | route nationale 3 | route nationale 3 | Q28736018 | France | Guyane | N3 | |
5 | route nationale 4 | route nationale 4 | Q28736022 | France | Guyane | N4 | |
6 | route nationale 2001 | route nationale 2001 | Q114064353 | France | Guyane | N2001 |
End of automatically generated list.