Difference between revisions of "Wikidata"

From BITPlan Wiki
Jump to navigation Jump to search
Line 95: Line 95:
 
</source>
 
</source>
 
[https://query.wikidata.org/#%23%20WikiData%20SPARQL%20Query%0A%23%0A%23%20Wolfgang%20Fahl%202018-01-06%0A%23%0A%23%20get%20childen%20of%20queen%20victoria%0ASELECT%20%3Fchild%20%3FchildLabel%20%3FgenderLabel%20%3Fdob%0AWHERE%20%7B%0A%23%20%20%0A%23%20child%0A%23%20https%3A%2F%2Fwww.wikidata.org%2Fwiki%2FProperty%3AP40%0A%23%20Queen%20Victoriy%0A%23%20https%3A%2F%2Fwww.wikidata.org%2Fwiki%2FQ9439%0A%20%20wd%3AQ9439%20wdt%3AP40%2B%20%3Fchild.%0A%23%20gender%0A%23%20https%3A%2F%2Fwww.wikidata.org%2Fwiki%2FProperty%3AP21%0A%20%20%3Fchild%20wdt%3AP21%20%3Fgender.%0A%23%20date%20of%20birth%0A%23%20https%3A%2F%2Fwww.wikidata.org%2Fwiki%2FProperty%3AP569%20%20%20%20%20%20%20%20%20%0A%20%20%3Fchild%20wdt%3AP569%20%3Fdob%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%7D%0AORDER%20BY%20%3Fdob%0A try it!]
 
[https://query.wikidata.org/#%23%20WikiData%20SPARQL%20Query%0A%23%0A%23%20Wolfgang%20Fahl%202018-01-06%0A%23%0A%23%20get%20childen%20of%20queen%20victoria%0ASELECT%20%3Fchild%20%3FchildLabel%20%3FgenderLabel%20%3Fdob%0AWHERE%20%7B%0A%23%20%20%0A%23%20child%0A%23%20https%3A%2F%2Fwww.wikidata.org%2Fwiki%2FProperty%3AP40%0A%23%20Queen%20Victoriy%0A%23%20https%3A%2F%2Fwww.wikidata.org%2Fwiki%2FQ9439%0A%20%20wd%3AQ9439%20wdt%3AP40%2B%20%3Fchild.%0A%23%20gender%0A%23%20https%3A%2F%2Fwww.wikidata.org%2Fwiki%2FProperty%3AP21%0A%20%20%3Fchild%20wdt%3AP21%20%3Fgender.%0A%23%20date%20of%20birth%0A%23%20https%3A%2F%2Fwww.wikidata.org%2Fwiki%2FProperty%3AP569%20%20%20%20%20%20%20%20%20%0A%20%20%3Fchild%20wdt%3AP569%20%3Fdob%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%7D%0AORDER%20BY%20%3Fdob%0A try it!]
−
== Regular Triple ==
+
= How Triples are stored in WikiData =
 +
== Regular triple ==
 
<graphviz>
 
<graphviz>
 
digraph Triple {
 
digraph Triple {
Line 102: Line 103:
 
}
 
}
 
</graphviz>
 
</graphviz>
−
=== WikiData Example Queen Victoria's father ===
+
== WikiData Example Queen Victoria's father ==
 
<graphviz>
 
<graphviz>
 
digraph TripleExample {
 
digraph TripleExample {
Line 140: Line 141:
 
=== SPARQL Query ===
 
=== SPARQL Query ===
 
<source lang='sparql'>
 
<source lang='sparql'>
−
SELECT ?queenLabel ?realpropertyLabel ?fatherLabel
+
# WikiData SPARQL Query
 +
#
 +
# Wolfgang Fahl 2018-01-06
 +
#
 +
# get father of queen victoria
 +
SELECT ?queenVictoria ?queenVictoriaLabel ?fatherProperty ?fatherPropertyLabel ?father ?fatherLabel
 
WHERE {
 
WHERE {
−
  VALUES (?queen) {(wd:Q9439)}
+
# 
−
  VALUES (?property) {(wdt:P22)}
+
# father
−
  ?queen ?property ?father .
+
# https://www.wikidata.org/wiki/Property:P42
−
  ?realproperty wikibase:directClaim ?property
+
# Queen Victoria
−
  SERVICE wikibase:label { bd:serviceParam wikibase:language "de". }
+
# https://www.wikidata.org/wiki/Q9439
 +
VALUES (?queenVictoria) {(wd:Q9439)}
 +
VALUES (?property) {(wdt:P22)}
 +
?queenVictoria ?property ?father.
 +
?fatherProperty wikibase:directClaim ?property
 +
SERVICE wikibase:label { bd:serviceParam wikibase:language "fr". }
 
}
 
}
 
</source>
 
</source>

Revision as of 11:46, 19 January 2018

The Genesis of WikiData

The Genesis of WikiData

Links

Structure

https://www.mediawiki.org/wiki/Wikibase/DataModel/Primer

Wikibase JavaScript Data Model 1.0.svg https://upload.wikimedia.org/wikipedia/commons/c/c2/Wikibase_JavaScript_Data_Model_1.0.svg

Example

Æthelstan King of the English - 927-939

Position Held


Queen Victoria

Entity:Queen Victoria

Statements
PropertyId/name value
P18/image 250px-Queen_Victoria_by_Bassano.jpg
P569/date of birth 24 May 1819
P39/position held Q9134365/Monarch of the United Kingdom qualifiers -> start:20 June 1837, end:22 January 1901, replaced by:https://www.wikidata.org/wiki/Q20875
P570/date of death 22 January 1901
P20/place of death Osborne House
P21/sex or gender] Q6581072/female

Descendants of Queen Victoria

# WikiData SPARQL Query
#
# Wolfgang Fahl 2018-01-06
#
# get childen of queen victoria
SELECT ?child ?childLabel ?genderLabel ?dob
WHERE {
#  
# child
# https://www.wikidata.org/wiki/Property:P40
# Queen Victoria
# https://www.wikidata.org/wiki/Q9439
  wd:Q9439 wdt:P40+ ?child.
# gender
# https://www.wikidata.org/wiki/Property:P21
  ?child wdt:P21 ?gender.
# date of birth
# https://www.wikidata.org/wiki/Property:P569         
  ?child wdt:P569 ?dob
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
ORDER BY ?dob

try it!

How Triples are stored in WikiData

Regular triple

WikiData Example Queen Victoria's father

WikiData Example Queen Victoria's father (technically)

WikiData Example Queen Victoria's father (multiple languages)

SPARQL Query

# WikiData SPARQL Query
#
# Wolfgang Fahl 2018-01-06
#
# get father of queen victoria
SELECT ?queenVictoria ?queenVictoriaLabel ?fatherProperty ?fatherPropertyLabel ?father ?fatherLabel
WHERE {
#  
# father
# https://www.wikidata.org/wiki/Property:P42
# Queen Victoria
# https://www.wikidata.org/wiki/Q9439
VALUES (?queenVictoria) {(wd:Q9439)}
VALUES (?property) {(wdt:P22)}
?queenVictoria ?property ?father.
?fatherProperty wikibase:directClaim ?property
SERVICE wikibase:label { bd:serviceParam wikibase:language "fr". }
}

Import

Tools

What Links Here

Retrieved from "https://wiki.bitplan.com/index.php?title=Wikidata&oldid=5863"