Bouzinac
Joined 11 March 2015
Babel user information | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
Users by language |
HarvestEdit
Geographical-GPS lookupsEdit
Data qualityEdit
History stuffsEdit
CountriesEdit
BordersEdit
AmbassadesEdit
- https://w.wiki/Qa8 : liste
- https://w.wiki/QaC : la même liste filtrée sur un pays
StreetsEdit
Train, buses and subwaysEdit
AirportsEdit
Ontologie des aéroports/Airport ontology in WikidataEdit
Patronages of airportsEdit
Airports in a countryEdit
Airports/railways stations with a text search/codesEdit
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. }
}
==>à 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
é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)
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)
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
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
testEdit
Map of Tramways in Île-de-France (query)
This user loves OpenRefine. |
This user is a member of the WikiProject France. |