Babel user information
en-5 This user has professional knowledge of English.
fr-N Cet utilisateur a pour langue maternelle le français.
de-2 Dieser Benutzer beherrscht Deutsch auf fortgeschrittenem Niveau.
es-0 Esta persona no tiene ningún conocimiento del español (o lo entiende con mucha dificultad).
it-1 Questo utente può contribuire con un livello elementare in italiano.
br-0 Ne oar an implijer-mañ tamm Brezhoneg ebet (pe en deus mil boan o kompren anezhañ).
nb-0 Denne brukeren har lite eller ingen kjennskap til norsk (bokmål) (eller har svært vanskelig for å forstå det).
Users by language

HarvestEdit

https://tools.wmflabs.org/pltools/harvesttemplates/share.php?action=savenew&siteid=ceb&project=wikipedia&namespace=0&property=131&template=geobox&parameter=region&addprefix=&removeprefix=&category=Mga%20tugpahanan%20sa%20Tinipong%20Bansa&depth=2&set=1&offset=0&limit=10000&wikisyntax=0&

Geographical-GPS lookupsEdit

Recherches géographiques


Data qualityEdit

Requêtes de data quality


History stuffsEdit

User:Bouzinac/Histoire

CountriesEdit

User:Bouzinac/Pays

BordersEdit

Frontières

AmbassadesEdit

StreetsEdit

User:Bouzinac/Rues

Train, buses and subwaysEdit

User:Bouzinac/Trains

AirportsEdit

Ontologie des aéroports/Airport ontology in WikidataEdit

Ontologie

Patronages of airportsEdit

Fréquentations & patronages

Airports in a countryEdit

Airports lists

Airports/railways stations with a text search/codesEdit

Recherches d'aéroports par codes IATA, ICAO etc

Essais nucléairesEdit

SELECT ?essai_nucl_aire ?essai_nucl_aireLabel ?date ?op_rateur ?op_rateurLabel ?tnt ?equivalent_nergie_kT ?partie_de ?partie_deLabel WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  ?essai_nucl_aire (wdt:P31 /(wdt:P279*)) wd:Q210112.
  MINUS { ?essai_nucl_aire (wdt:P31/(wdt:P279*)) wd:Q98391050. }
  OPTIONAL { ?essai_nucl_aire wdt:P585 ?date. }
  OPTIONAL { ?essai_nucl_aire wdt:P137 ?op_rateur. }
  OPTIONAL { ?essai_nucl_aire wdt:P2145 ?tnt. }
  OPTIONAL {
    ?essai_nucl_aire p:P2145 ?yield_statement.
    ?yield_statement rdf:type wikibase:BestRank;
      (psn:P2145/wikibase:quantityAmount) ?joule.
    BIND((?joule / 4184000000 ) / "1000.0"^^xsd:decimal AS ?equivalent_nergie_kT)
 }
  OPTIONAL { ?essai_nucl_aire wdt:P361 ?partie_de.  }
 }
Try it!

==>à finir https://w.wiki/avZ (france) ==>résultat final ? https://w.wiki/bXH

dates et processus temporelsEdit

SELECT ?item ?start ?start_prc ?end ?end_prc ?nature_de_l__l_ment ?nature_de_l__l_mentLabel WHERE {
  VALUES ?start_prc {
    9 
    10 
    11 
  }
  ?item (p:P580/psv:P580) _:b12.
  _:b12 wikibase:timePrecision ?start_prc;
    wikibase:timeValue ?start.
  VALUES ?end_prc {
    9 
    10 
    11 
  }
  ?item (p:P582/psv:P582) _:b13.
  _:b13 wikibase:timePrecision ?end_prc;
    wikibase:timeValue ?end.
  MINUS { ?item p:P585 _:b14. }
  FILTER((YEAR(?start)) = (YEAR(?end)))
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
  OPTIONAL { ?item wdt:P31 ?nature_de_l__l_ment. }
}
LIMIT 1000
Try it!

éclipsesEdit

SELECT ?_clipse ?_clipseLabel ?date WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  ?_clipse wdt:P31/wdt:P279* wd:Q141022.
  ?_clipse wdt:P585 ?date. 
}
order by asc(?date)
Try it!

saros solairesEdit

SELECT ?item ?itemLabel ?corps ?rang ?date_de_d_but ?date_de_fin
WHERE
{
?item  wdt:P31/wdt:P279* wd:Q220397 .
?item  p:P31 [ pq:P376 ?qualifier ].
?item  p:P31 [ pq:P376 ?corps ].
?item  p:P31 [ pq:P1545 ?rang].

     OPTIONAL { ?item wdt:P580 ?date_de_d_but. }
  OPTIONAL { ?item wdt:P582 ?date_de_fin. }
     SERVICE wikibase:label { bd:serviceParam wikibase:language "fr,en". }
}
ORDER BY xsd:integer(?rang)
Try it!

air catastrophesEdit

SELECT ?accidents ?accidentsLabel ?date ?operateurLabel ?flight_num (sample(?perpetrateurLabel) as ?perpetrateur)  (max(?victime) as ?victimes) (sample(?ASN_ids) as ?ASN_ids ) WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
  VALUES ?what {
    wd:Q744913
    wd:Q898712
    wd:Q3149875
    wd:Q15931405
    wd:Q1863435
    wd:Q3002150
    wd:Q12051532
    wd:Q104776655
  }
  ?accidents (wdt:P31/wdt:P279) ?what.  
  OPTIONAL { ?accidents wdt:P585 ?date. }
  OPTIONAL { ?accidents wdt:P137 ?operateur. } 
  OPTIONAL { ?accidents wdt:P8031 ?perpetrateur. } 
  OPTIONAL { ?accidents wdt:P1590|wdt:P1120 ?victime. } 
  OPTIONAL { ?accidents wdt:P1755|wdt:P1760 ?ASN_ids. } 
  OPTIONAL { ?accidents wdt:P3090 ?flight_num. }    
} 
group by ?accidents ?accidentsLabel ?flight_num ?date ?operateurLabel
order by ?victimes ?date
Try it!

banknotesEdit

SELECT ?item ?itemLabel ?valeur_faciale WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,fr". }
  OPTIONAL { ?item wdt:P3934 ?valeur_faciale. }
} order by ?valeur_faciale
Try it!

testEdit

Map of Tramways in Île-de-France (query)


 This user is a member of the WikiProject France.