Wikipédia

Utilisateur:Gz260/Routes/RN (F)/Wikidata/SPARQL

< Utilisateur:Gz260‎ | Routes‎ | RN (F)‎ | Wikidata

1824

modifier
1824

Brouillon : 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

SELECT ?item ?itemLabel ?dep ?depLabel WHERE { 
  ?item wdt:P16 wd:Q1426271 .
  ?item p:P131 ?s .
  ?s pq:P580 ?date FILTER (?date >= "1824-01-01T00:00:00Z"^^xsd:dateTime && ?date < "1825-01-01T00:00:00Z"^^xsd:dateTime) .
  ?s ps:P131 ?dep .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
}
Cliquez pour essayer !

Liste 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

SELECT ?item ?itemLabel WHERE {
  {
	SELECT ?item WHERE { 
	  ?item wdt:P16 wd:Q1426271 .
	  ?item p:P131 ?s .
	  ?s pq:P580 ?date FILTER (?date >= "1824-01-01T00:00:00Z"^^xsd:dateTime && ?date < "1825-01-01T00:00:00Z"^^xsd:dateTime) .
	  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
	}
	GROUP BY ?item
  }           
  . 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)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
} ORDER BY ?cledetri
Cliquez pour essayer !

Liste par route 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

SELECT ?item ?itemLabel ?count ?deps WHERE {
  {
	SELECT DISTINCT ?item (GROUP_CONCAT(?l; separator = ', ') as ?deps) (COUNT(?l) as ?count) WHERE { 
	  ?item wdt:P16 wd:Q1426271 .
	  ?item p:P131 ?s .
	  ?s pq:P580 ?date FILTER (?date >= "1824-01-01T00:00:00Z"^^xsd:dateTime && ?date < "1825-01-01T00:00:00Z"^^xsd:dateTime) .
	  ?s ps:P131 ?dep .
	  OPTIONAL { ?dep rdfs:label ?l filter (lang(?l) = "fr") }
	  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
	} 
	GROUP BY ?item
  }
  . 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)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
} ORDER BY ?cledetri
Cliquez pour essayer !

Liste par département 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
SELECT ?dep ?depLabel ?count ?routes WHERE {
  {
	SELECT DISTINCT ?dep (GROUP_CONCAT(?l; separator = ', ') as ?routes) (COUNT(?l) as ?count) WHERE { 
	  ?item wdt:P16 wd:Q1426271 .
	  ?item p:P131 ?s .
	  ?s pq:P580 ?date FILTER (?date >= "1824-01-01T00:00:00Z"^^xsd:dateTime && ?date < "1825-01-01T00:00:00Z"^^xsd:dateTime) .
	  ?s ps:P131 ?dep .
	  OPTIONAL { ?item rdfs:label ?l filter (lang(?l) = "fr") }
	  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
	}
	GROUP BY ?dep
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
} ORDER BY ?depLabel
Cliquez pour essayer !
 

1848

modifier
1848

Brouillon : 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

SELECT ?item ?itemLabel ?dep ?depLabel ?date ?datefin WHERE { 
  ?item wdt:P16 wd:Q1426271 .
  ?item p:P131 ?s .
  ?s pq:P580 ?date FILTER (?date >= "1824-01-01T00:00:00Z"^^xsd:dateTime && ?date < "1849-01-01T00:00:00Z"^^xsd:dateTime) .
  OPTIONAL { ?s pq:P582 ?x } .
  bind(year(?x) as ?y_x)
  bind(if(bound(?y_x),if(?x < "1849-01-01T00:00:00Z"^^xsd:dateTime, ?x, "1849-01-01T00:00:00Z"^^xsd:dateTime),"1849-01-01T00:00:00Z"^^xsd:dateTime) as ?datefin) FILTER (?datefin >= "1849-01-01T00:00:00Z"^^xsd:dateTime)
  ?s ps:P131 ?dep .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
}
Cliquez pour essayer !

Liste : 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

SELECT ?item ?itemLabel WHERE {
  {
	SELECT ?item WHERE { 
	  ?item wdt:P16 wd:Q1426271 .
	  ?item p:P131 ?s .
	  ?s pq:P580 ?date FILTER (?date >= "1824-01-01T00:00:00Z"^^xsd:dateTime && ?date < "1849-01-01T00:00:00Z"^^xsd:dateTime) .
	  OPTIONAL { ?s pq:P582 ?x } .
	  bind(year(?x) as ?y_x)
	  bind(if(bound(?y_x),if(?x < "1849-01-01T00:00:00Z"^^xsd:dateTime, ?x, "1849-01-01T00:00:00Z"^^xsd:dateTime),"1849-01-01T00:00:00Z"^^xsd:dateTime) as ?datefin) FILTER (?datefin >= "1849-01-01T00:00:00Z"^^xsd:dateTime)
	  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
	}
	GROUP BY ?item
  }           
  . 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)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
} ORDER BY ?cledetri
Cliquez pour essayer !

Liste par route : 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

SELECT ?item ?itemLabel ?count ?deps WHERE {
  {
	SELECT DISTINCT ?item (GROUP_CONCAT(?l; separator = ', ') as ?deps) (COUNT(?l) as ?count) WHERE { 
	  ?item wdt:P16 wd:Q1426271 .
	  ?item p:P131 ?s .
	  ?s pq:P580 ?date FILTER (?date >= "1824-01-01T00:00:00Z"^^xsd:dateTime && ?date < "1849-01-01T00:00:00Z"^^xsd:dateTime) .
      OPTIONAL { ?s pq:P582 ?x } .
      bind(year(?x) as ?y_x)
      bind(if(bound(?y_x),if(?x < "1849-01-01T00:00:00Z"^^xsd:dateTime, ?x, "1849-01-01T00:00:00Z"^^xsd:dateTime),"1849-01-01T00:00:00Z"^^xsd:dateTime) as ?datefin) FILTER (?datefin >= "1849-01-01T00:00:00Z"^^xsd:dateTime)
	  ?s ps:P131 ?dep .
	  OPTIONAL { ?dep rdfs:label ?l filter (lang(?l) = "fr") }
	  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
	} 
	GROUP BY ?item
  }
  . 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)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
} ORDER BY ?cledetri
Cliquez pour essayer !

Liste par département : 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
SELECT ?dep ?depLabel ?count ?routes WHERE {
  {
	SELECT DISTINCT ?dep (GROUP_CONCAT(?l; separator = ', ') as ?routes) (COUNT(?l) as ?count) WHERE { 
	  ?item wdt:P16 wd:Q1426271 .
	  ?item p:P131 ?s .
	  ?s pq:P580 ?date FILTER (?date >= "1824-01-01T00:00:00Z"^^xsd:dateTime && ?date < "1849-01-01T00:00:00Z"^^xsd:dateTime) .
      OPTIONAL { ?s pq:P582 ?x } .
      bind(year(?x) as ?y_x)
      bind(if(bound(?y_x),if(?x < "1849-01-01T00:00:00Z"^^xsd:dateTime, ?x, "1849-01-01T00:00:00Z"^^xsd:dateTime),"1849-01-01T00:00:00Z"^^xsd:dateTime) as ?datefin) FILTER (?datefin >= "1849-01-01T00:00:00Z"^^xsd:dateTime)
	  ?s ps:P131 ?dep .
	  OPTIONAL { ?item rdfs:label ?l filter (lang(?l) = "fr") }
	  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
	}
	GROUP BY ?dep
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
} ORDER BY ?depLabel
Cliquez pour essayer !
 

1860

modifier
1860

Brouillon : 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

SELECT ?item ?itemLabel ?dep ?depLabel ?date ?datefin WHERE { 
  ?item wdt:P16 wd:Q1426271 .
  ?item p:P131 ?s .
  ?s pq:P580 ?date FILTER (?date >= "1824-01-01T00:00:00Z"^^xsd:dateTime && ?date < "1861-01-01T00:00:00Z"^^xsd:dateTime) .
  OPTIONAL { ?s pq:P582 ?x } .
  bind(year(?x) as ?y_x)
  bind(if(bound(?y_x),if(?x < "1861-01-01T00:00:00Z"^^xsd:dateTime, ?x, "1861-01-01T00:00:00Z"^^xsd:dateTime),"1861-01-01T00:00:00Z"^^xsd:dateTime) as ?datefin) FILTER (?datefin >= "1861-01-01T00:00:00Z"^^xsd:dateTime)
  ?s ps:P131 ?dep .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
}
Cliquez pour essayer !

Liste : 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

SELECT ?item ?itemLabel WHERE {
  {
	SELECT ?item WHERE { 
	  ?item wdt:P16 wd:Q1426271 .
	  ?item p:P131 ?s .
	  ?s pq:P580 ?date FILTER (?date >= "1824-01-01T00:00:00Z"^^xsd:dateTime && ?date < "1861-01-01T00:00:00Z"^^xsd:dateTime) .
	  OPTIONAL { ?s pq:P582 ?x } .
	  bind(year(?x) as ?y_x)
	  bind(if(bound(?y_x),if(?x < "1861-01-01T00:00:00Z"^^xsd:dateTime, ?x, "1861-01-01T00:00:00Z"^^xsd:dateTime),"1861-01-01T00:00:00Z"^^xsd:dateTime) as ?datefin) FILTER (?datefin >= "1861-01-01T00:00:00Z"^^xsd:dateTime)
	  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
	}
	GROUP BY ?item
  }           
  . 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)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
} ORDER BY ?cledetri
Cliquez pour essayer !

Liste par route : 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

SELECT ?item ?itemLabel ?count ?deps WHERE {
  {
	SELECT DISTINCT ?item (GROUP_CONCAT(?l; separator = ', ') as ?deps) (COUNT(?l) as ?count) WHERE { 
	  ?item wdt:P16 wd:Q1426271 .
	  ?item p:P131 ?s .
	  ?s pq:P580 ?date FILTER (?date >= "1824-01-01T00:00:00Z"^^xsd:dateTime && ?date < "1861-01-01T00:00:00Z"^^xsd:dateTime) .
      OPTIONAL { ?s pq:P582 ?x } .
      bind(year(?x) as ?y_x)
      bind(if(bound(?y_x),if(?x < "1861-01-01T00:00:00Z"^^xsd:dateTime, ?x, "1861-01-01T00:00:00Z"^^xsd:dateTime),"1861-01-01T00:00:00Z"^^xsd:dateTime) as ?datefin) FILTER (?datefin >= "1861-01-01T00:00:00Z"^^xsd:dateTime)
	  ?s ps:P131 ?dep .
	  OPTIONAL { ?dep rdfs:label ?l filter (lang(?l) = "fr") }
	  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
	} 
	GROUP BY ?item
  }
  . 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)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
} ORDER BY ?cledetri
Cliquez pour essayer !

Liste par département : 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
SELECT ?dep ?depLabel ?count ?routes WHERE {
  {
	SELECT DISTINCT ?dep (GROUP_CONCAT(?l; separator = ', ') as ?routes) (COUNT(?l) as ?count) WHERE { 
	  ?item wdt:P16 wd:Q1426271 .
	  ?item p:P131 ?s .
	  ?s pq:P580 ?date FILTER (?date >= "1824-01-01T00:00:00Z"^^xsd:dateTime && ?date < "1861-01-01T00:00:00Z"^^xsd:dateTime) .
      OPTIONAL { ?s pq:P582 ?x } .
      bind(year(?x) as ?y_x)
      bind(if(bound(?y_x),if(?x < "1861-01-01T00:00:00Z"^^xsd:dateTime, ?x, "1861-01-01T00:00:00Z"^^xsd:dateTime),"1861-01-01T00:00:00Z"^^xsd:dateTime) as ?datefin) FILTER (?datefin >= "1861-01-01T00:00:00Z"^^xsd:dateTime)
	  ?s ps:P131 ?dep .
	  OPTIONAL { ?item rdfs:label ?l filter (lang(?l) = "fr") }
	  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
	}
	GROUP BY ?dep
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
} ORDER BY ?depLabel
Cliquez pour essayer !
 

1863

modifier
1863

Brouillon : 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

SELECT ?item ?itemLabel ?dep ?depLabel ?date ?datefin WHERE { 
  ?item wdt:P16 wd:Q1426271 .
  ?item p:P131 ?s .
  ?s pq:P580 ?date FILTER (?date >= "1824-01-01T00:00:00Z"^^xsd:dateTime && ?date < "1864-01-01T00:00:00Z"^^xsd:dateTime) .
  OPTIONAL { ?s pq:P582 ?x } .
  bind(year(?x) as ?y_x)
  bind(if(bound(?y_x),if(?x < "1864-01-01T00:00:00Z"^^xsd:dateTime, ?x, "1864-01-01T00:00:00Z"^^xsd:dateTime),"1864-01-01T00:00:00Z"^^xsd:dateTime) as ?datefin) FILTER (?datefin >= "1864-01-01T00:00:00Z"^^xsd:dateTime)
  ?s ps:P131 ?dep .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
}
Cliquez pour essayer !

Liste : 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

SELECT ?item ?itemLabel WHERE {
  {
	SELECT ?item WHERE { 
	  ?item wdt:P16 wd:Q1426271 .
	  ?item p:P131 ?s .
	  ?s pq:P580 ?date FILTER (?date >= "1824-01-01T00:00:00Z"^^xsd:dateTime && ?date < "1864-01-01T00:00:00Z"^^xsd:dateTime) .
	  OPTIONAL { ?s pq:P582 ?x } .
	  bind(year(?x) as ?y_x)
	  bind(if(bound(?y_x),if(?x < "1864-01-01T00:00:00Z"^^xsd:dateTime, ?x, "1864-01-01T00:00:00Z"^^xsd:dateTime),"1864-01-01T00:00:00Z"^^xsd:dateTime) as ?datefin) FILTER (?datefin >= "1864-01-01T00:00:00Z"^^xsd:dateTime)
	  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
	}
	GROUP BY ?item
  }           
  . 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)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
} ORDER BY ?cledetri
Cliquez pour essayer !

Liste par route : 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

SELECT ?item ?itemLabel ?count ?deps WHERE {
  {
	SELECT DISTINCT ?item (GROUP_CONCAT(?l; separator = ', ') as ?deps) (COUNT(?l) as ?count) WHERE { 
	  ?item wdt:P16 wd:Q1426271 .
	  ?item p:P131 ?s .
	  ?s pq:P580 ?date FILTER (?date >= "1824-01-01T00:00:00Z"^^xsd:dateTime && ?date < "1864-01-01T00:00:00Z"^^xsd:dateTime) .
      OPTIONAL { ?s pq:P582 ?x } .
      bind(year(?x) as ?y_x)
      bind(if(bound(?y_x),if(?x < "1864-01-01T00:00:00Z"^^xsd:dateTime, ?x, "1864-01-01T00:00:00Z"^^xsd:dateTime),"1864-01-01T00:00:00Z"^^xsd:dateTime) as ?datefin) FILTER (?datefin >= "1864-01-01T00:00:00Z"^^xsd:dateTime)
	  ?s ps:P131 ?dep .
	  OPTIONAL { ?dep rdfs:label ?l filter (lang(?l) = "fr") }
	  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
	} 
	GROUP BY ?item
  }
  . 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)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
} ORDER BY ?cledetri
Cliquez pour essayer !

Liste par département : 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
SELECT ?dep ?depLabel ?count ?routes WHERE {
  {
	SELECT DISTINCT ?dep (GROUP_CONCAT(?l; separator = ', ') as ?routes) (COUNT(?l) as ?count) WHERE { 
	  ?item wdt:P16 wd:Q1426271 .
	  ?item p:P131 ?s .
	  ?s pq:P580 ?date FILTER (?date >= "1824-01-01T00:00:00Z"^^xsd:dateTime && ?date < "1864-01-01T00:00:00Z"^^xsd:dateTime) .
      OPTIONAL { ?s pq:P582 ?x } .
      bind(year(?x) as ?y_x)
      bind(if(bound(?y_x),if(?x < "1864-01-01T00:00:00Z"^^xsd:dateTime, ?x, "1864-01-01T00:00:00Z"^^xsd:dateTime),"1864-01-01T00:00:00Z"^^xsd:dateTime) as ?datefin) FILTER (?datefin >= "1864-01-01T00:00:00Z"^^xsd:dateTime)
	  ?s ps:P131 ?dep .
	  OPTIONAL { ?item rdfs:label ?l filter (lang(?l) = "fr") }
	  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
	}
	GROUP BY ?dep
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
} ORDER BY ?depLabel
Cliquez pour essayer !
 

1870

modifier
1870

Brouillon : 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

SELECT ?item ?itemLabel ?dep ?depLabel ?date ?datefin WHERE { 
  ?item wdt:P16 wd:Q1426271 .
  ?item p:P131 ?s .
  ?s pq:P580 ?date FILTER (?date >= "1824-01-01T00:00:00Z"^^xsd:dateTime && ?date < "1871-01-01T00:00:00Z"^^xsd:dateTime) .
  OPTIONAL { ?s pq:P582 ?x } .
  bind(year(?x) as ?y_x)
  bind(if(bound(?y_x),if(?x < "1871-01-01T00:00:00Z"^^xsd:dateTime, ?x, "1871-01-01T00:00:00Z"^^xsd:dateTime),"1871-01-01T00:00:00Z"^^xsd:dateTime) as ?datefin) FILTER (?datefin >= "1871-01-01T00:00:00Z"^^xsd:dateTime)
  ?s ps:P131 ?dep .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
}
Cliquez pour essayer !

Liste : 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

SELECT ?item ?itemLabel WHERE {
  {
	SELECT ?item WHERE { 
	  ?item wdt:P16 wd:Q1426271 .
	  ?item p:P131 ?s .
	  ?s pq:P580 ?date FILTER (?date >= "1824-01-01T00:00:00Z"^^xsd:dateTime && ?date < "1871-01-01T00:00:00Z"^^xsd:dateTime) .
	  OPTIONAL { ?s pq:P582 ?x } .
	  bind(year(?x) as ?y_x)
	  bind(if(bound(?y_x),if(?x < "1871-01-01T00:00:00Z"^^xsd:dateTime, ?x, "1871-01-01T00:00:00Z"^^xsd:dateTime),"1871-01-01T00:00:00Z"^^xsd:dateTime) as ?datefin) FILTER (?datefin >= "1871-01-01T00:00:00Z"^^xsd:dateTime)
	  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
	}
	GROUP BY ?item
  }           
  . 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)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
} ORDER BY ?cledetri
Cliquez pour essayer !

Liste par route : 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

SELECT ?item ?itemLabel ?count ?deps WHERE {
  {
	SELECT DISTINCT ?item (GROUP_CONCAT(?l; separator = ', ') as ?deps) (COUNT(?l) as ?count) WHERE { 
	  ?item wdt:P16 wd:Q1426271 .
	  ?item p:P131 ?s .
	  ?s pq:P580 ?date FILTER (?date >= "1824-01-01T00:00:00Z"^^xsd:dateTime && ?date < "1871-01-01T00:00:00Z"^^xsd:dateTime) .
      OPTIONAL { ?s pq:P582 ?x } .
      bind(year(?x) as ?y_x)
      bind(if(bound(?y_x),if(?x < "1871-01-01T00:00:00Z"^^xsd:dateTime, ?x, "1871-01-01T00:00:00Z"^^xsd:dateTime),"1871-01-01T00:00:00Z"^^xsd:dateTime) as ?datefin) FILTER (?datefin >= "1871-01-01T00:00:00Z"^^xsd:dateTime)
	  ?s ps:P131 ?dep .
	  OPTIONAL { ?dep rdfs:label ?l filter (lang(?l) = "fr") }
	  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
	} 
	GROUP BY ?item
  }
  . 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)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
} ORDER BY ?cledetri
Cliquez pour essayer !

Liste par département : 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
SELECT ?dep ?depLabel ?count ?routes WHERE {
  {
	SELECT DISTINCT ?dep (GROUP_CONCAT(?l; separator = ', ') as ?routes) (COUNT(?l) as ?count) WHERE { 
	  ?item wdt:P16 wd:Q1426271 .
	  ?item p:P131 ?s .
	  ?s pq:P580 ?date FILTER (?date >= "1824-01-01T00:00:00Z"^^xsd:dateTime && ?date < "1871-01-01T00:00:00Z"^^xsd:dateTime) .
      OPTIONAL { ?s pq:P582 ?x } .
      bind(year(?x) as ?y_x)
      bind(if(bound(?y_x),if(?x < "1871-01-01T00:00:00Z"^^xsd:dateTime, ?x, "1871-01-01T00:00:00Z"^^xsd:dateTime),"1871-01-01T00:00:00Z"^^xsd:dateTime) as ?datefin) FILTER (?datefin >= "1871-01-01T00:00:00Z"^^xsd:dateTime)
	  ?s ps:P131 ?dep .
	  OPTIONAL { ?item rdfs:label ?l filter (lang(?l) = "fr") }
	  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
	}
	GROUP BY ?dep
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
} ORDER BY ?depLabel
Cliquez pour essayer !
 

1871

modifier
1871

Brouillon : 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

SELECT ?item ?itemLabel ?dep ?depLabel ?date ?datefin WHERE { 
  ?item wdt:P16 wd:Q1426271 .
  ?item p:P131 ?s .
  ?s pq:P580 ?date FILTER (?date >= "1824-01-01T00:00:00Z"^^xsd:dateTime && ?date < "1872-01-01T00:00:00Z"^^xsd:dateTime) .
  OPTIONAL { ?s pq:P582 ?x } .
  bind(year(?x) as ?y_x)
  bind(if(bound(?y_x),if(?x < "1872-01-01T00:00:00Z"^^xsd:dateTime, ?x, "1872-01-01T00:00:00Z"^^xsd:dateTime),"1872-01-01T00:00:00Z"^^xsd:dateTime) as ?datefin) FILTER (?datefin >= "1872-01-01T00:00:00Z"^^xsd:dateTime)
  ?s ps:P131 ?dep .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
}
Cliquez pour essayer !

Liste : 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

SELECT ?item ?itemLabel WHERE {
  {
	SELECT ?item WHERE { 
	  ?item wdt:P16 wd:Q1426271 .
	  ?item p:P131 ?s .
	  ?s pq:P580 ?date FILTER (?date >= "1824-01-01T00:00:00Z"^^xsd:dateTime && ?date < "1872-01-01T00:00:00Z"^^xsd:dateTime) .
	  OPTIONAL { ?s pq:P582 ?x } .
	  bind(year(?x) as ?y_x)
	  bind(if(bound(?y_x),if(?x < "1872-01-01T00:00:00Z"^^xsd:dateTime, ?x, "1872-01-01T00:00:00Z"^^xsd:dateTime),"1872-01-01T00:00:00Z"^^xsd:dateTime) as ?datefin) FILTER (?datefin >= "1872-01-01T00:00:00Z"^^xsd:dateTime)
	  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
	}
	GROUP BY ?item
  }           
  . 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)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
} ORDER BY ?cledetri
Cliquez pour essayer !

Liste par route : 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

SELECT ?item ?itemLabel ?count ?deps WHERE {
  {
	SELECT DISTINCT ?item (GROUP_CONCAT(?l; separator = ', ') as ?deps) (COUNT(?l) as ?count) WHERE { 
	  ?item wdt:P16 wd:Q1426271 .
	  ?item p:P131 ?s .
	  ?s pq:P580 ?date FILTER (?date >= "1824-01-01T00:00:00Z"^^xsd:dateTime && ?date < "1872-01-01T00:00:00Z"^^xsd:dateTime) .
      OPTIONAL { ?s pq:P582 ?x } .
      bind(year(?x) as ?y_x)
      bind(if(bound(?y_x),if(?x < "1872-01-01T00:00:00Z"^^xsd:dateTime, ?x, "1872-01-01T00:00:00Z"^^xsd:dateTime),"1872-01-01T00:00:00Z"^^xsd:dateTime) as ?datefin) FILTER (?datefin >= "1872-01-01T00:00:00Z"^^xsd:dateTime)
	  ?s ps:P131 ?dep .
	  OPTIONAL { ?dep rdfs:label ?l filter (lang(?l) = "fr") }
	  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
	} 
	GROUP BY ?item
  }
  . 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)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
} ORDER BY ?cledetri
Cliquez pour essayer !

Liste par département : 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
SELECT ?dep ?depLabel ?count ?routes WHERE {
  {
	SELECT DISTINCT ?dep (GROUP_CONCAT(?l; separator = ', ') as ?routes) (COUNT(?l) as ?count) WHERE { 
	  ?item wdt:P16 wd:Q1426271 .
	  ?item p:P131 ?s .
	  ?s pq:P580 ?date FILTER (?date >= "1824-01-01T00:00:00Z"^^xsd:dateTime && ?date < "1872-01-01T00:00:00Z"^^xsd:dateTime) .
      OPTIONAL { ?s pq:P582 ?x } .
      bind(year(?x) as ?y_x)
      bind(if(bound(?y_x),if(?x < "1872-01-01T00:00:00Z"^^xsd:dateTime, ?x, "1872-01-01T00:00:00Z"^^xsd:dateTime),"1872-01-01T00:00:00Z"^^xsd:dateTime) as ?datefin) FILTER (?datefin >= "1872-01-01T00:00:00Z"^^xsd:dateTime)
	  ?s ps:P131 ?dep .
	  OPTIONAL { ?item rdfs:label ?l filter (lang(?l) = "fr") }
	  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
	}
	GROUP BY ?dep
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
} ORDER BY ?depLabel
Cliquez pour essayer !
 

1933

modifier
1933

Brouillon : 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

SELECT ?item ?itemLabel ?dep ?depLabel ?date ?datefin WHERE { 
  ?item wdt:P16 wd:Q1426271 .
  ?item p:P131 ?s .
  ?s pq:P580 ?date FILTER (?date >= "1824-01-01T00:00:00Z"^^xsd:dateTime && ?date < "1934-01-01T00:00:00Z"^^xsd:dateTime) .
  OPTIONAL { ?s pq:P582 ?x } .
  bind(year(?x) as ?y_x)
  bind(if(bound(?y_x),if(?x < "1934-01-01T00:00:00Z"^^xsd:dateTime, ?x, "1934-01-01T00:00:00Z"^^xsd:dateTime),"1934-01-01T00:00:00Z"^^xsd:dateTime) as ?datefin) FILTER (?datefin >= "1934-01-01T00:00:00Z"^^xsd:dateTime)
  ?s ps:P131 ?dep .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
}
Cliquez pour essayer !

Liste : 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

SELECT ?item ?itemLabel WHERE {
  {
	SELECT ?item WHERE { 
	  ?item wdt:P16 wd:Q1426271 .
	  ?item p:P131 ?s .
	  ?s pq:P580 ?date FILTER (?date >= "1824-01-01T00:00:00Z"^^xsd:dateTime && ?date < "1934-01-01T00:00:00Z"^^xsd:dateTime) .
	  OPTIONAL { ?s pq:P582 ?x } .
	  bind(year(?x) as ?y_x)
	  bind(if(bound(?y_x),if(?x < "1934-01-01T00:00:00Z"^^xsd:dateTime, ?x, "1934-01-01T00:00:00Z"^^xsd:dateTime),"1934-01-01T00:00:00Z"^^xsd:dateTime) as ?datefin) FILTER (?datefin >= "1934-01-01T00:00:00Z"^^xsd:dateTime)
	  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
	}
	GROUP BY ?item
  }           
  . 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)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
} ORDER BY ?cledetri
Cliquez pour essayer !

Liste par route : 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

SELECT ?item ?itemLabel ?count ?deps WHERE {
  {
	SELECT DISTINCT ?item (GROUP_CONCAT(?l; separator = ', ') as ?deps) (COUNT(?l) as ?count) WHERE { 
	  ?item wdt:P16 wd:Q1426271 .
	  ?item p:P131 ?s .
	  ?s pq:P580 ?date FILTER (?date >= "1824-01-01T00:00:00Z"^^xsd:dateTime && ?date < "1934-01-01T00:00:00Z"^^xsd:dateTime) .
      OPTIONAL { ?s pq:P582 ?x } .
      bind(year(?x) as ?y_x)
      bind(if(bound(?y_x),if(?x < "1934-01-01T00:00:00Z"^^xsd:dateTime, ?x, "1934-01-01T00:00:00Z"^^xsd:dateTime),"1934-01-01T00:00:00Z"^^xsd:dateTime) as ?datefin) FILTER (?datefin >= "1934-01-01T00:00:00Z"^^xsd:dateTime)
	  ?s ps:P131 ?dep .
	  OPTIONAL { ?dep rdfs:label ?l filter (lang(?l) = "fr") }
	  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
	} 
	GROUP BY ?item
  }
  . 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)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
} ORDER BY ?cledetri
Cliquez pour essayer !

Liste par département : 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
SELECT ?dep ?depLabel ?count ?routes WHERE {
  {
	SELECT DISTINCT ?dep (GROUP_CONCAT(?l; separator = ', ') as ?routes) (COUNT(?l) as ?count) WHERE { 
	  ?item wdt:P16 wd:Q1426271 .
	  ?item p:P131 ?s .
	  ?s pq:P580 ?date FILTER (?date >= "1824-01-01T00:00:00Z"^^xsd:dateTime && ?date < "1934-01-01T00:00:00Z"^^xsd:dateTime) .
      OPTIONAL { ?s pq:P582 ?x } .
      bind(year(?x) as ?y_x)
      bind(if(bound(?y_x),if(?x < "1934-01-01T00:00:00Z"^^xsd:dateTime, ?x, "1934-01-01T00:00:00Z"^^xsd:dateTime),"1934-01-01T00:00:00Z"^^xsd:dateTime) as ?datefin) FILTER (?datefin >= "1934-01-01T00:00:00Z"^^xsd:dateTime)
	  ?s ps:P131 ?dep .
	  OPTIONAL { ?item rdfs:label ?l filter (lang(?l) = "fr") }
	  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
	}
	GROUP BY ?dep
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
} ORDER BY ?depLabel
Cliquez pour essayer !
 

1949

modifier
1949

Brouillon : 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

SELECT ?item ?itemLabel ?dep ?depLabel ?date ?datefin WHERE { 
  ?item wdt:P16 wd:Q1426271 .
  ?item p:P131 ?s .
  ?s pq:P580 ?date FILTER (?date >= "1824-01-01T00:00:00Z"^^xsd:dateTime && ?date < "1950-01-01T00:00:00Z"^^xsd:dateTime) .
  OPTIONAL { ?s pq:P582 ?x } .
  bind(year(?x) as ?y_x)
  bind(if(bound(?y_x),if(?x < "1950-01-01T00:00:00Z"^^xsd:dateTime, ?x, "1950-01-01T00:00:00Z"^^xsd:dateTime),"1950-01-01T00:00:00Z"^^xsd:dateTime) as ?datefin) FILTER (?datefin >= "1950-01-01T00:00:00Z"^^xsd:dateTime)
  ?s ps:P131 ?dep .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
}
Cliquez pour essayer !

Liste : 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

SELECT ?item ?itemLabel WHERE {
  {
	SELECT ?item WHERE { 
	  ?item wdt:P16 wd:Q1426271 .
	  ?item p:P131 ?s .
	  ?s pq:P580 ?date FILTER (?date >= "1824-01-01T00:00:00Z"^^xsd:dateTime && ?date < "1950-01-01T00:00:00Z"^^xsd:dateTime) .
	  OPTIONAL { ?s pq:P582 ?x } .
	  bind(year(?x) as ?y_x)
	  bind(if(bound(?y_x),if(?x < "1950-01-01T00:00:00Z"^^xsd:dateTime, ?x, "1950-01-01T00:00:00Z"^^xsd:dateTime),"1950-01-01T00:00:00Z"^^xsd:dateTime) as ?datefin) FILTER (?datefin >= "1950-01-01T00:00:00Z"^^xsd:dateTime)
	  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
	}
	GROUP BY ?item
  }           
  . 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)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
} ORDER BY ?cledetri
Cliquez pour essayer !

Liste par route : 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

SELECT ?item ?itemLabel ?count ?deps WHERE {
  {
	SELECT DISTINCT ?item (GROUP_CONCAT(?l; separator = ', ') as ?deps) (COUNT(?l) as ?count) WHERE { 
	  ?item wdt:P16 wd:Q1426271 .
	  ?item p:P131 ?s .
	  ?s pq:P580 ?date FILTER (?date >= "1824-01-01T00:00:00Z"^^xsd:dateTime && ?date < "1950-01-01T00:00:00Z"^^xsd:dateTime) .
      OPTIONAL { ?s pq:P582 ?x } .
      bind(year(?x) as ?y_x)
      bind(if(bound(?y_x),if(?x < "1950-01-01T00:00:00Z"^^xsd:dateTime, ?x, "1950-01-01T00:00:00Z"^^xsd:dateTime),"1950-01-01T00:00:00Z"^^xsd:dateTime) as ?datefin) FILTER (?datefin >= "1950-01-01T00:00:00Z"^^xsd:dateTime)
	  ?s ps:P131 ?dep .
	  OPTIONAL { ?dep rdfs:label ?l filter (lang(?l) = "fr") }
	  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
	} 
	GROUP BY ?item
  }
  . 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)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
} ORDER BY ?cledetri
Cliquez pour essayer !

Liste par département : 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
SELECT ?dep ?depLabel ?count ?routes WHERE {
  {
	SELECT DISTINCT ?dep (GROUP_CONCAT(?l; separator = ', ') as ?routes) (COUNT(?l) as ?count) WHERE { 
	  ?item wdt:P16 wd:Q1426271 .
	  ?item p:P131 ?s .
	  ?s pq:P580 ?date FILTER (?date >= "1824-01-01T00:00:00Z"^^xsd:dateTime && ?date < "1950-01-01T00:00:00Z"^^xsd:dateTime) .
      OPTIONAL { ?s pq:P582 ?x } .
      bind(year(?x) as ?y_x)
      bind(if(bound(?y_x),if(?x < "1950-01-01T00:00:00Z"^^xsd:dateTime, ?x, "1950-01-01T00:00:00Z"^^xsd:dateTime),"1950-01-01T00:00:00Z"^^xsd:dateTime) as ?datefin) FILTER (?datefin >= "1950-01-01T00:00:00Z"^^xsd:dateTime)
	  ?s ps:P131 ?dep .
	  OPTIONAL { ?item rdfs:label ?l filter (lang(?l) = "fr") }
	  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
	}
	GROUP BY ?dep
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
} ORDER BY ?depLabel
Cliquez pour essayer !
 

1950

modifier
1950

Brouillon : 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

SELECT ?item ?itemLabel ?dep ?depLabel ?date ?datefin WHERE { 
  ?item wdt:P16 wd:Q1426271 .
  ?item p:P131 ?s .
  ?s pq:P580 ?date FILTER (?date >= "1824-01-01T00:00:00Z"^^xsd:dateTime && ?date < "1951-01-01T00:00:00Z"^^xsd:dateTime) .
  OPTIONAL { ?s pq:P582 ?x } .
  bind(year(?x) as ?y_x)
  bind(if(bound(?y_x),if(?x < "1951-01-01T00:00:00Z"^^xsd:dateTime, ?x, "1951-01-01T00:00:00Z"^^xsd:dateTime),"1951-01-01T00:00:00Z"^^xsd:dateTime) as ?datefin) FILTER (?datefin >= "1951-01-01T00:00:00Z"^^xsd:dateTime)
  ?s ps:P131 ?dep .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
}
Cliquez pour essayer !

Liste : 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

SELECT ?item ?itemLabel WHERE {
  {
	SELECT ?item WHERE { 
	  ?item wdt:P16 wd:Q1426271 .
	  ?item p:P131 ?s .
	  ?s pq:P580 ?date FILTER (?date >= "1824-01-01T00:00:00Z"^^xsd:dateTime && ?date < "1951-01-01T00:00:00Z"^^xsd:dateTime) .
	  OPTIONAL { ?s pq:P582 ?x } .
	  bind(year(?x) as ?y_x)
	  bind(if(bound(?y_x),if(?x < "1951-01-01T00:00:00Z"^^xsd:dateTime, ?x, "1951-01-01T00:00:00Z"^^xsd:dateTime),"1951-01-01T00:00:00Z"^^xsd:dateTime) as ?datefin) FILTER (?datefin >= "1951-01-01T00:00:00Z"^^xsd:dateTime)
	  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
	}
	GROUP BY ?item
  }           
  . 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)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
} ORDER BY ?cledetri
Cliquez pour essayer !

Liste par route : 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

SELECT ?item ?itemLabel ?count ?deps WHERE {
  {
	SELECT DISTINCT ?item (GROUP_CONCAT(?l; separator = ', ') as ?deps) (COUNT(?l) as ?count) WHERE { 
	  ?item wdt:P16 wd:Q1426271 .
	  ?item p:P131 ?s .
	  ?s pq:P580 ?date FILTER (?date >= "1824-01-01T00:00:00Z"^^xsd:dateTime && ?date < "1951-01-01T00:00:00Z"^^xsd:dateTime) .
      OPTIONAL { ?s pq:P582 ?x } .
      bind(year(?x) as ?y_x)
      bind(if(bound(?y_x),if(?x < "1951-01-01T00:00:00Z"^^xsd:dateTime, ?x, "1951-01-01T00:00:00Z"^^xsd:dateTime),"1951-01-01T00:00:00Z"^^xsd:dateTime) as ?datefin) FILTER (?datefin >= "1951-01-01T00:00:00Z"^^xsd:dateTime)
	  ?s ps:P131 ?dep .
	  OPTIONAL { ?dep rdfs:label ?l filter (lang(?l) = "fr") }
	  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
	} 
	GROUP BY ?item
  }
  . 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)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
} ORDER BY ?cledetri
Cliquez pour essayer !

Liste par département : 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
SELECT ?dep ?depLabel ?count ?routes WHERE {
  {
	SELECT DISTINCT ?dep (GROUP_CONCAT(?l; separator = ', ') as ?routes) (COUNT(?l) as ?count) WHERE { 
	  ?item wdt:P16 wd:Q1426271 .
	  ?item p:P131 ?s .
	  ?s pq:P580 ?date FILTER (?date >= "1824-01-01T00:00:00Z"^^xsd:dateTime && ?date < "1951-01-01T00:00:00Z"^^xsd:dateTime) .
      OPTIONAL { ?s pq:P582 ?x } .
      bind(year(?x) as ?y_x)
      bind(if(bound(?y_x),if(?x < "1951-01-01T00:00:00Z"^^xsd:dateTime, ?x, "1951-01-01T00:00:00Z"^^xsd:dateTime),"1951-01-01T00:00:00Z"^^xsd:dateTime) as ?datefin) FILTER (?datefin >= "1951-01-01T00:00:00Z"^^xsd:dateTime)
	  ?s ps:P131 ?dep .
	  OPTIONAL { ?item rdfs:label ?l filter (lang(?l) = "fr") }
	  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
	}
	GROUP BY ?dep
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
} ORDER BY ?depLabel
Cliquez pour essayer !
 

1960

modifier
1960

Brouillon : 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

SELECT ?item ?itemLabel ?dep ?depLabel ?date ?datefin WHERE { 
  ?item wdt:P16 wd:Q1426271 .
  ?item p:P131 ?s .
  ?s pq:P580 ?date FILTER (?date >= "1824-01-01T00:00:00Z"^^xsd:dateTime && ?date < "1961-01-01T00:00:00Z"^^xsd:dateTime) .
  OPTIONAL { ?s pq:P582 ?x } .
  bind(year(?x) as ?y_x)
  bind(if(bound(?y_x),if(?x < "1961-01-01T00:00:00Z"^^xsd:dateTime, ?x, "1961-01-01T00:00:00Z"^^xsd:dateTime),"1961-01-01T00:00:00Z"^^xsd:dateTime) as ?datefin) FILTER (?datefin >= "1961-01-01T00:00:00Z"^^xsd:dateTime)
  ?s ps:P131 ?dep .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
}
Cliquez pour essayer !

Liste : 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

SELECT ?item ?itemLabel WHERE {
  {
	SELECT ?item WHERE { 
	  ?item wdt:P16 wd:Q1426271 .
	  ?item p:P131 ?s .
	  ?s pq:P580 ?date FILTER (?date >= "1824-01-01T00:00:00Z"^^xsd:dateTime && ?date < "1961-01-01T00:00:00Z"^^xsd:dateTime) .
	  OPTIONAL { ?s pq:P582 ?x } .
	  bind(year(?x) as ?y_x)
	  bind(if(bound(?y_x),if(?x < "1961-01-01T00:00:00Z"^^xsd:dateTime, ?x, "1961-01-01T00:00:00Z"^^xsd:dateTime),"1961-01-01T00:00:00Z"^^xsd:dateTime) as ?datefin) FILTER (?datefin >= "1961-01-01T00:00:00Z"^^xsd:dateTime)
	  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
	}
	GROUP BY ?item
  }           
  . 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)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
} ORDER BY ?cledetri
Cliquez pour essayer !

Liste par route : 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

SELECT ?item ?itemLabel ?count ?deps WHERE {
  {
	SELECT DISTINCT ?item (GROUP_CONCAT(?l; separator = ', ') as ?deps) (COUNT(?l) as ?count) WHERE { 
	  ?item wdt:P16 wd:Q1426271 .
	  ?item p:P131 ?s .
	  ?s pq:P580 ?date FILTER (?date >= "1824-01-01T00:00:00Z"^^xsd:dateTime && ?date < "1961-01-01T00:00:00Z"^^xsd:dateTime) .
      OPTIONAL { ?s pq:P582 ?x } .
      bind(year(?x) as ?y_x)
      bind(if(bound(?y_x),if(?x < "1961-01-01T00:00:00Z"^^xsd:dateTime, ?x, "1961-01-01T00:00:00Z"^^xsd:dateTime),"1961-01-01T00:00:00Z"^^xsd:dateTime) as ?datefin) FILTER (?datefin >= "1961-01-01T00:00:00Z"^^xsd:dateTime)
	  ?s ps:P131 ?dep .
	  OPTIONAL { ?dep rdfs:label ?l filter (lang(?l) = "fr") }
	  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
	} 
	GROUP BY ?item
  }
  . 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)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
} ORDER BY ?cledetri
Cliquez pour essayer !

Liste par département : 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
SELECT ?dep ?depLabel ?count ?routes WHERE {
  {
	SELECT DISTINCT ?dep (GROUP_CONCAT(?l; separator = ', ') as ?routes) (COUNT(?l) as ?count) WHERE { 
	  ?item wdt:P16 wd:Q1426271 .
	  ?item p:P131 ?s .
	  ?s pq:P580 ?date FILTER (?date >= "1824-01-01T00:00:00Z"^^xsd:dateTime && ?date < "1961-01-01T00:00:00Z"^^xsd:dateTime) .
      OPTIONAL { ?s pq:P582 ?x } .
      bind(year(?x) as ?y_x)
      bind(if(bound(?y_x),if(?x < "1961-01-01T00:00:00Z"^^xsd:dateTime, ?x, "1961-01-01T00:00:00Z"^^xsd:dateTime),"1961-01-01T00:00:00Z"^^xsd:dateTime) as ?datefin) FILTER (?datefin >= "1961-01-01T00:00:00Z"^^xsd:dateTime)
	  ?s ps:P131 ?dep .
	  OPTIONAL { ?item rdfs:label ?l filter (lang(?l) = "fr") }
	  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
	}
	GROUP BY ?dep
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
} ORDER BY ?depLabel
Cliquez pour essayer !
 

Actuellement (France métropolitaine)

modifier
Actuellement (France métropolitaine)

Brouillon : 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

SELECT ?item ?itemLabel ?dep ?depLabel WHERE { 
  ?item wdt:P16 wd:Q1426271 .
  MINUS { ?item wdt:P131 wd:Q17012 } MINUS { ?item wdt:P131 wd:Q17054 } MINUS { ?item wdt:P131 wd:Q3769 } MINUS { ?item wdt:P131 wd:Q17070 } MINUS { ?item wdt:P131 wd:Q34617 } MINUS { ?item wdt:P131 wd:Q17063 } MINUS { ?item wdt:P131 wd:Q25362 } MINUS { ?item wdt:P131 wd:Q126125 } . 
  ?item p:P131 ?s .
  FILTER NOT EXISTS { ?s pq:P582 [] } .
  ?s ps:P131 ?dep .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
}
Cliquez pour essayer !

Liste 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

SELECT ?item ?itemLabel WHERE {
  {
	SELECT ?item WHERE { 
	  ?item wdt:P16 wd:Q1426271 .
	  MINUS { ?item wdt:P131 wd:Q17012 } MINUS { ?item wdt:P131 wd:Q17054 } MINUS { ?item wdt:P131 wd:Q3769 } MINUS { ?item wdt:P131 wd:Q17070 } MINUS { ?item wdt:P131 wd:Q34617 } MINUS { ?item wdt:P131 wd:Q17063 } MINUS { ?item wdt:P131 wd:Q25362 } MINUS { ?item wdt:P131 wd:Q126125 } . 
	  ?item p:P131 ?s .
	  FILTER NOT EXISTS { ?s pq:P582 [] } .
	  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
	}
	GROUP BY ?item
  }           
  . 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)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
} ORDER BY ?cledetri
Cliquez pour essayer !

Liste par route 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

SELECT ?item ?itemLabel ?count ?deps WHERE {
  {
	SELECT DISTINCT ?item (GROUP_CONCAT(?l; separator = ', ') as ?deps) (COUNT(?l) as ?count) WHERE { 
	  ?item wdt:P16 wd:Q1426271 .
	  MINUS { ?item wdt:P131 wd:Q17012 } MINUS { ?item wdt:P131 wd:Q17054 } MINUS { ?item wdt:P131 wd:Q3769 } MINUS { ?item wdt:P131 wd:Q17070 } MINUS { ?item wdt:P131 wd:Q34617 } MINUS { ?item wdt:P131 wd:Q17063 } MINUS { ?item wdt:P131 wd:Q25362 } MINUS { ?item wdt:P131 wd:Q126125 } . 
	  ?item p:P131 ?s .
	  FILTER NOT EXISTS { ?s pq:P582 [] } .
	  ?s ps:P131 ?dep .
	  OPTIONAL { ?dep rdfs:label ?l filter (lang(?l) = "fr") }
	  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
	} 
	GROUP BY ?item
  }
  . 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)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
} ORDER BY ?cledetri
Cliquez pour essayer !

Liste par département 

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
SELECT ?dep ?depLabel ?count ?routes WHERE {
  {
	SELECT DISTINCT ?dep (GROUP_CONCAT(?l; separator = ', ') as ?routes) (COUNT(?l) as ?count) WHERE { 
	  ?item wdt:P16 wd:Q1426271 .
	  MINUS { ?item wdt:P131 wd:Q17012 } MINUS { ?item wdt:P131 wd:Q17054 } MINUS { ?item wdt:P131 wd:Q3769 } MINUS { ?item wdt:P131 wd:Q17070 } MINUS { ?item wdt:P131 wd:Q34617 } MINUS { ?item wdt:P131 wd:Q17063 } MINUS { ?item wdt:P131 wd:Q25362 } MINUS { ?item wdt:P131 wd:Q126125 } . 
	  ?item p:P131 ?s .
	  FILTER NOT EXISTS { ?s pq:P582 [] } .
	  ?s ps:P131 ?dep .
	  OPTIONAL { ?item rdfs:label ?l filter (lang(?l) = "fr") }
	  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
	}
	GROUP BY ?dep
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" . }
} ORDER BY ?depLabel
Cliquez pour essayer !
 
Ce document provient de « https://fr.wikipedia.org/w/index.php?title=Utilisateur:Gz260/Routes/RN_(F)/Wikidata/SPARQL&oldid=142213031 ».