Difference between revisions of "Wikidata"
Jump to navigation
Jump to search
Line 138: | Line 138: | ||
} | } | ||
</graphviz> | </graphviz> | ||
+ | === SPARQL Query === | ||
+ | <source lang='sparql'> | ||
+ | SELECT ?queenLabel ?realpropertyLabel ?fatherLabel | ||
+ | WHERE { | ||
+ | VALUES (?queen) {(wd:Q9439)} | ||
+ | VALUES (?property) {(wdt:P22)} | ||
+ | ?queen ?property ?father . | ||
+ | ?realproperty wikibase:directClaim ?property | ||
+ | SERVICE wikibase:label { bd:serviceParam wikibase:language "de". } | ||
+ | } | ||
+ | </source> | ||
= Import = | = Import = |
Revision as of 11:41, 19 January 2018
The Genesis of WikiData
Links
Structure
https://www.mediawiki.org/wiki/Wikibase/DataModel/Primer
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
- https://en.wikipedia.org/wiki/Queen_Victoria
- https://www.wikidata.org/wiki/Q9439
- http://royal-family.bitplan.com/index.php/Queen_Victoria
Entity:Queen Victoria
Statements | |
---|---|
PropertyId/name | value |
P18/image | |
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
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
SELECT ?queenLabel ?realpropertyLabel ?fatherLabel
WHERE {
VALUES (?queen) {(wd:Q9439)}
VALUES (?property) {(wdt:P22)}
?queen ?property ?father .
?realproperty wikibase:directClaim ?property
SERVICE wikibase:label { bd:serviceParam wikibase:language "de". }
}
Import
- https://www.wikidata.org/wiki/Wikidata:Data_Import_Guide
- https://www.wikidata.org/wiki/Q2140665
- https://github.com/maxlath/wikidata-cli
- https://www.wikidata.org/wiki/Wikidata:Tools/External_tools