User:Bouzinac

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

Harvest

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 lookups

Recherches géographiques

Data quality

Requêtes de data quality

History stuffs

User:Bouzinac/Histoire

Countries

User:Bouzinac/Pays

Borders

Frontières

Ambassades

• https://w.wiki/Qa8 : liste
• https://w.wiki/QaC : la même liste filtrée sur un pays

Streets

User:Bouzinac/Rues

Train, buses and subways

User:Bouzinac/Trains

Airports

Ontologie des aéroports/Airport ontology in Wikidata

Ontologie

Patronages of airports

Fréquentations & patronages

Airports in a country

Airports lists

Airports/railways stations with a text search/codes

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

Nucléaire

Essais nucléaires

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

Centrales nucléaires

 Workinghttps://w.wiki/6EXw

dates et processus temporels

dates iraniennes à faire : https://w.wiki/6a4F

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

Run it!

éclipses

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)

Run it!

saros solaires

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)

Run it!

air catastrophes

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

Run it!

banknotes

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

Run it!

test

Map of Regional Transportation District (query)

This user loves OpenRefine.

This user is a member of the WikiProject France.