Wikidata

Bouzinac

Joined 11 March 2015
User page Discussion
Google-refine-logo.svgThis user loves OpenRefine.
Wikidata WikiProject france.svgThis user is a member of the WikiProject France.
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&

Ontologie des aéroports/Airport ontology in WikidataEdit

Ontologie

tring search elements without P31 P279Edit

SELECT DISTINCT ?item ?itemLabel 
WHERE {
  hint:Query hint:optimizer "None".
  SERVICE wikibase:mwapi {
    bd:serviceParam wikibase:api "Search";
                    wikibase:endpoint "www.wikidata.org";
                    mwapi:srsearch "siege -haswbstatement:P31 -haswbstatement:P279" .
    ?title wikibase:apiOutput mwapi:title.
  }
  BIND(IRI(CONCAT(STR(wd:), ?title)) AS ?item)
  #add any other requirements here
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!

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

Qualité des données / Data qualityEdit

Requêtes de data quality

Check wiki airport element having neither IATA nor ICAO nor FAA LIDEdit

SELECT DISTINCT ?airport ?airportlabel ?pays ?paysLabel WHERE {
  ?airport (wdt:P31/wdt:P279*) wd:Q62447.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,fr,de,kk". }
  FILTER(NOT EXISTS { ?airport wdt:P239 ?icao. })
  FILTER(NOT EXISTS { ?airport wdt:P238 ?iata. })
  FILTER(NOT EXISTS { ?airport wdt:P240 ?FAA. })
  FILTER(NOT EXISTS { ?airport wdt:P5699 ?tc_cad.})
  FILTER(NOT EXISTS { ?airport wdt:P5746 ?DGAC.})
  FILTER(NOT EXISTS { ?airport wdt:P5851 ?russ. })
  FILTER(NOT EXISTS { ?airport wdt:P6120 ?argent. })

  FILTER NOT EXISTS { ?airport p:P239 [rdf:type wdno:P239].} #we do not want the ?item if ICAO has a <no value>   
  MINUS {?airport wdt:P576 [].} # remove items with P576 (dissolved, abolished or demolished) as a main property
  MINUS {?airport wdt:P582 [].} # remove items with P582 (end date) as a main property
  MINUS {?airport wdt:P31/wdt:P279* wd:Q695850.} # exclude military airports
  MINUS {?airport wdt:P31/wdt:P279* wd:Q2265915.}  # exclude vol à voile
  MINUS {?airport wdt:P31/wdt:P279* wd:Q1311670.}  # exclude railways stations
  MINUS {?airport a wdno:P17.}                                    #exclude airports that aren't physically based in a country
  MINUS {?airport wdt:P31/wdt:P279* wd:Q7373622.}  # exclude Royal Air Force
  MINUS {?airport (wdt:P31/wdt:P279*) wd:Q782667. } # exclude motorways where plane can land
  minus {?airport wdt:P31/wdt:P279* wd:Q502074.}   # exclude héliports
  minus {?airport wdt:P31/wdt:P279* wd:Q44665966.}   # exclude airports in project
  OPTIONAL {?airport wdt:P17 ?pays. }
} order by ?paysLabel

Try it!

Recherches géographiques/Geographical-GPS lookupsEdit

Recherches géographiques

Aéroports triés par coordonnées dupliquéesEdit

SELECT ?item ?itemLabel ?coord1 ?coord2 ?distance ?rank1 ?rank2 WITH {
SELECT DISTINCT ?item ?coord1 ?coord2 ?rank1 ?rank2 WHERE {
    ?item  (wdt:P31/wdt:P279*) wd:Q62447.
    hint:Prior hint:gearing "forward".
    ?item p:P625 ?stat1 . ?stat1 ps:P625 ?coord1 . ?stat1 wikibase:rank ?rank1 . 
    ?item p:P625 ?stat2 . ?stat2 ps:P625 ?coord2 . ?stat2 wikibase:rank ?rank2 . 
    filter ( str(?stat1)  < str(?stat2) ) . # not the same
    filter ( str(?rank1)  = str(?rank2) ) . # are the same
} 
} AS %if WHERE {
  include %if
  BIND(geof:distance(?coord1, ?coord2) as ?distance)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en,[AUTO_LANGUAGE]". }
}
ORDER BY ?itemLabel

Try it!

Number of countries in the historyEdit

select ?bound (count(?country) as ?count)
with {
select ?country {
?country wdt:P31/wdt:P279* wd:Q3624078 # sovereign states, I don’t know if it’s the right item
} 
}as %countries
with
{
select distinct ?bound {
?country (wdt:P571

Try it!

List of countries + nature + timeEdit

select distinct ?country (group_concat(?NatureLabelFr;separator=", ") as ?NatureLabelFr) ?countryLabel  ?creationDate ?dissolutionDate
with {
select ?country (coalesce(?countryLabelFr, ?countryLabelEn,  ?country) as ?countryLabel) ?creationDate ?dissolutionDate{
VALUES ?what { 
               wd:Q3624078 # sovereign states, I don’t know if it’s the right item
               wd:Q3024240 # états historiques
             }
?country wdt:P31/wdt:P279* ?what . 
MINUS { ?country (wdt:P31/wdt:P279*) wd:Q1790360. } #empires coloniaux
MINUS { ?country (wdt:P31/wdt:P279*) wd:Q1371288. } #états vassals
MINUS { ?country (wdt:P31/wdt:P279*) wd:Q21512251. } #états autoproclamés
MINUS { ?country (wdt:P31/wdt:P279*) wd:Q1642488. } #chefferies
optional { ?country rdfs:label ?countryLabelFr filter(lang(?countryLabelFr)= "fr")} .
optional { ?country rdfs:label ?countryLabelEn filter(lang(?countryLabelEn)= "en")}
optional { ?country wdt:P571 ?creationDate }
optional { ?country wdt:P576 ?dissolutionDate }
} order by ?countryLabel
} as %datas
where {
include %datas .
optional{
?country wdt:P31/rdfs:label ?NatureLabelFr filter(lang(?NatureLabelFr)= "fr") .
}
} group by ?country ?countryLabel  ?creationDate ?dissolutionDate

Try it!

autre liste à nettoyerEdit

SELECT distinct ?item ?itemLabel ?itemdesc ?creat  ?dissolution  WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  ?item wdt:P31/wdt:P279* wd:Q3024240.
  OPTIONAL { ?item wdt:P571 ?creat. }
  OPTIONAL { ?item wdt:P576 ?dissolution. }
  ?item schema:description ?itemdesc .
  FILTER((LANG(?itemdesc)) = "fr")
} order by ?creat

Try it!

nouvelle liste des 2800 à nettoyerEdit

SELECT distinct ?item ?itemLabel ?itemdesc_fr ?itemdesc_en ?creat  ?dissolution  WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en,fr". }
#  values ?item {wd:Q101104073}
  ?item wdt:P31/wdt:P279* wd:Q3024240.
MINUS { ?item (wdt:P31/wdt:P279*) wd:Q1790360. } #empires coloniaux
MINUS { ?item (wdt:P31/wdt:P279*) wd:Q1371288. } #états vassals
MINUS { ?item (wdt:P31/wdt:P279*) wd:Q21512251. } #états autoproclamés
MINUS { ?item (wdt:P31/wdt:P279*) wd:Q1642488. } #chefferies
  OPTIONAL { ?item wdt:P571 ?creat. }
  OPTIONAL { ?item wdt:P576 ?dissolution. }
  FILTER (!bound(?dissolution))
  OPTIONAL {?item schema:description ?itemdesc_fr . FILTER((LANG(?itemdesc_fr)) = "fr") BIND (TRUE as ?true) }
  OPTIONAL {?item schema:description ?itemdesc_en . FILTER((LANG(?itemdesc_en)) = "en") BIND (TRUE as ?true) }
  OPTIONAL { FILTER NOT EXISTS {?item schema:description ?itemdesc .} BIND (TRUE as ?true)}
  filter(BOUND(?true))
} order by ?creat

Try it!

Taïfas espagnolesEdit

SELECT ?ta_fa ?ta_faLabel ?date_de_fondation_ou_de_cr_ation ?capitale ?capitaleLabel ?partie_de ?partie_deLabel WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  ?ta_fa wdt:P31 wd:Q217177.
  OPTIONAL { ?ta_fa wdt:P571 ?date_de_fondation_ou_de_cr_ation. }
  OPTIONAL { ?ta_fa wdt:P36 ?capitale. }
  OPTIONAL { ?ta_fa wdt:P361 ?partie_de. } 
}

Try it!

FrontièresEdit

Frontières

Durée des sièges dans l'histoire v3Edit

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>

select ?siège ?siègeLabel (sample(?whereLabel) as ?whereLabel2) ?start ?tp_end ?tv_end ?end ?days ?years ?_articleFR ?_articleEN {
SELECT ?siège ?siègeLabel ?whereLabel ?start ?tp_end ?tv_end ?end ?days ?years ?_articleFR ?_articleEN WHERE {
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
?siège wdt:P31 wd:Q188055.
OPTIONAL { ?siège wdt:P580 ?start. }
OPTIONAL { 
           ?siège p:P582/psv:P582 ?p582node. 
           ?p582node wikibase:timeValue ?tv_end .       # get the time value
           ?p582node wikibase:timePrecision ?tp_end .   # get the time precision
           BIND(
             IF(?tp_end=9,?tv_end + "P1Y"^^xsd:duration - "P1D"^^xsd:duration,# set end date to 31 December if time precision is "year" (9)
             IF(?tp_end=10,?tv_end + "P1M"^^xsd:duration - "P1D"^^xsd:duration,# set end date to 28th if time precision is "month" (10)
             ?tv_end))
              AS ?end).
         }
OPTIONAL { ?siège wdt:P276 ?where. } 
OPTIONAL { ?siège p:P2047/psn:P2047/wikibase:quantityAmount ?lengthNorm.}
BIND(COALESCE(?lengthNorm/86400,(?end - ?start+1)) as ?days)
BIND(?days/365.00 as ?years)
    OPTIONAL {
    ?_articleFR schema:about ?siège.
    ?_articleFR schema:isPartOf <https://fr.wikipedia.org/>.
    ?_articleEN schema:about ?siège.
    ?_articleEN schema:isPartOf <https://en.wikipedia.org/>.
  }
}
}
group by ?siège ?siègeLabel ?start ?tp_end ?tv_end ?end ?days ?years  ?_articleFR ?_articleEN
order by desc(?years) ?whereLabel2

Try it!

à faireEdit

SELECT DISTINCT ?item ?itemLabel 
WHERE {
  hint:Query hint:optimizer "None".
  SERVICE wikibase:mwapi {
    bd:serviceParam wikibase:api "Search";
                    wikibase:endpoint "www.wikidata.org";
                    mwapi:srsearch "airport -haswbstatement:P31 -haswbstatement:P279" .
    ?title wikibase:apiOutput mwapi:title. 
  }
  BIND(IRI(CONCAT(STR(wd:), ?title)) AS ?item)
  #add any other requirements here
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!

à faire 2Edit

SELECT DISTINCT ?item ?itemLabel 
WHERE {
  hint:Query hint:optimizer "None".
  SERVICE wikibase:mwapi {
    bd:serviceParam wikibase:api "Search";
                    wikibase:endpoint "www.wikidata.org";
                    mwapi:srsearch "bataille -haswbstatement:P31 -haswbstatement:P279" .
    ?title wikibase:apiOutput mwapi:title. 
  }
  BIND(IRI(CONCAT(STR(wd:), ?title)) AS ?item)
  #add any other requirements here
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} order by ?itemLabel

Try it!

à faire 3 rues en FREdit

https://w.wiki/c8q

rues martiniqueEdit

SELECT ?item ?itemLabel ?nomm__en_r_f_rence__ ?nomm__en_r_f_rence__Label WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr". }
  ?item wdt:P131 ?local;
    wdt:P31 wd:Q79007;
    (wdt:P131*) wd:Q617806.
  OPTIONAL { ?item wdt:P138 ?nomm__en_r_f_rence__. }
}

Try it!

Frontières 2 à faireEdit

SELECT ?item ?itemLabel ?qualifier ?qualifierLabel ?statutLabel ?pays ?paysLabel 
  WHERE {
   ?item p:P31 ?statut_statement .
   ?statut wdt:P279 wd:Q1292279 .
   ?statut_statement ps:P31 ?statut .
   OPTIONAL { ?item p:P31 [ pq:P642 ?qualifier ] }
   OPTIONAL { ?item wdt:P17 ?pays. }
   SERVICE wikibase:label { bd:serviceParam wikibase:language "fr". }
  }

Try it!

Gares indiennesEdit

SELECT ?item ?itemLabel ?Indian_Railways WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  ?item wdt:P31 wd:Q55488.
  ?item wdt:P17 wd:Q668.
  OPTIONAL { ?item wdt:P5696 ?Indian_Railways. }
    MINUS    { ?item wdt:P576 [].}                    # remove items with P576 (dissolved, abolished or demolished) as a main property
  MINUS    { ?item wdt:P582 [].}                    # remove items with P582 (end date) as a main property
}

Try it!

Dédoublonnage aérodromes prrrrtEdit

SELECT DISTINCT ?pays ?paysLabel ?item ?itemLabel ?itemDescription ?sitelink
WHERE {
?item (wdt:P31/wdt:P279*) wd:Q62447.
 optional{ ?item wdt:P17 ?pays}
MINUS { ?item wdt:P625 ?coord. }
    MINUS { ?item wdt:P576 _:b2. }                                # remove items with P576 (dissolved, abolished or demolished) as a main property
  MINUS { ?item wdt:P582 _:b3. }                                # remove items with P582 (end date) as a main property
  MINUS { ?item (wdt:P31/wdt:P279*) wd:Q695850. }               # exclude military airports
  MINUS { ?item (wdt:P31/wdt:P279*) wd:Q1311670. }              # exclude railways stations
  MINUS { ?item (wdt:P31/wdt:P279*) wd:Q7373622. }              # exclude Royal Air Force
  MINUS { ?item (wdt:P31/wdt:P279*) wd:Q502074. }               # exclude héliports
  MINUS { ?item wdt:P31/wdt:P279* wd:Q2265915.}                 # exclude vol à voile/gliders
  MINUS { ?item (wdt:P31/wdt:P279*) wd:Q44665966. }             # exclude  airports being build
  MINUS { ?item (wdt:P31/wdt:P279*) wd:Q782667. }               # exclude motorways where plane can land
  MINUS { ?item a wdno:P17.}                                    # exclude airports that aren't physically based in a country
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,ms". }
}

Try it!

AmbassadesEdit

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

guerres à faireEdit

https://w.wiki/dEY

coups d'étatsEdit

SELECT DISTINCT ?coup_d__tat ?coup_d__tatLabel ?date ?pays ?paysLabel WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  ?coup_d__tat wdt:P31/wdt:P279* wd:Q45382.
  OPTIONAL { ?coup_d__tat wdt:P585 ?date. }
  OPTIONAL { ?coup_d__tat wdt:P17 ?pays. }
}order by ?date

Try it!

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!

Retrieved from "https://www.wikidata.org/w/index.php?title=User:Bouzinac&oldid=1363782829"