Result
# Query Poets on WikiTree
#
#defaultView:ImageGrid
SELECT DISTINCT ?pic ?person ?personLabel ?personDescription ?WikiTree WHERE {
{
?person wdt:P2949 ?WikiTreeID . #Find people marked WikiTree
?person wdt:P106 wd:Q49757 #Find Occupation Poets
OPTIONAL { ?person wdt:P18 ?pic}
BIND(URI(CONCAT("http://www.WikiTree.com/Wiki/",?WikiTreeID)) as ?WikiTree)
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en"}
}
Order By ?personLabel
LIMIT 100000
söndag 31 juli 2016
Primeministers
Position held
Video about adding properties in Wikidata for Swedish Prime ministers
- Q687075 Prime minister of Sweden
Video about adding properties in Wikidata for Swedish Prime ministers
Geospatial Question -
# Query Find people in WikiTree
# 200 km from Q1035422 Caraquet
#
#defaultView:Map
SELECT ?placeOfBirthLabel ?person ?personLabel ?personDescription ?WikiTree ?chicagoLoc ?pic ?location WHERE {
{
wd:Q1035422 wdt:P625 ?locCaraquet . #Find location Caraquet
?person wdt:P19 ?placeOfBirth.
?person wdt:P2949 ?WikiTreeID.
SERVICE wikibase:around {
?placeOfBirth wdt:P625 ?location .
bd:serviceParam wikibase:center ?locCaraquet .
bd:serviceParam wikibase:radius "200" .
bd:serviceParam wikibase:distance ?dist.
}
OPTIONAL {?person wdt:P18 ?pic} # If Wikidata has a illustration use that
# BIND (URI(CONCAT("http://www.wikitree.com/wiki/",?WikiTreeID)) AS ?WikiTree)
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en"}
}
LIMIT 10000
P54 members of a team that play icehockey Q41466 and in the National Icehockey League
# Query Find all P54 members of a team that play icehockey Q41466 and in the National Icehockey League
#
#defaultView:ImageGrid
SELECT DISTINCT ?person ?personLabel ?personDescription ?dateofBirth ?placeOfBirthLabel ?dateofDeath ?WikiTreeIDf ?findAGravef ?wikiTreeIDf ?genealogicsf ?pic WHERE
{
?icehockeyTeam wdt:P641 wd:Q41466 . # Team is a icehockey Team
?icehockeyTeam wdt:P118 wd:Q1215892 . # Team has been in the National Hockey League
?person wdt:P54 ?icehockeyTeam . # person in this team
?person wdt:P31 wd:Q5 .
OPTIONAL {?person wdt:P535 ?findAGrave } # FindAGraveID
OPTIONAL {?person wdt:P1819 ?genealogics } # Genealogics
{?person wdt:P2949 ?wikiTreeID } # WikiTreeID
OPTIONAL {?person wdt:P569 ?dateOfBirth }
OPTIONAL {?person wdt:P19 ?placeOfBirth } # Birth location
# OPTIONAL {?placeOfBirth wdt:P625 ?coord1 } . # Get coordinates of Place of birth
OPTIONAL {?person wdt:P570 ?dateofDeath } # Deathdate
OPTIONAL {?person wdt:P20 ?deathLoc } # Death location
# OPTIONAL {?deathLoc wdt:P625 ?coord2 } . # Get coordinates from Place of death
OPTIONAL {?person wdt:P119 ?placeOfBurial } # Burial location
# OPTIONAL {?placeOfBurial wdt:P625 ?coord3 } . # Get coordinates from Place of burial
OPTIONAL {?person wdt:P18 ?pic} # picture
BIND (URI(CONCAT("http://www.wikitree.com/wiki/",?wikiTreeID)) AS ?wikiTreeIDf)
BIND (URI(CONCAT("http://www.findagrave.com/cgi-bin/fg.cgi?page=gr&df=all&GRid=",?findAGrave)) AS ?findAGravef)
BIND (URI(CONCAT("http://www.genealogics.org/getperson.php?tree=LEO&personID=",?genealogics)) AS ?genealogicsf)
# BIND (URI(CONCAT("https://www.facebook.com/",?FB)) AS ?FBf)
SERVICE wikibase:label { bd:serviceParam wikibase:language "en","fr". } #English
}
Order By (?dateOfBirth)
LIMIT 10000
#
#defaultView:ImageGrid
SELECT DISTINCT ?person ?personLabel ?personDescription ?dateofBirth ?placeOfBirthLabel ?dateofDeath ?WikiTreeIDf ?findAGravef ?wikiTreeIDf ?genealogicsf ?pic WHERE
{
?icehockeyTeam wdt:P641 wd:Q41466 . # Team is a icehockey Team
?icehockeyTeam wdt:P118 wd:Q1215892 . # Team has been in the National Hockey League
?person wdt:P54 ?icehockeyTeam . # person in this team
?person wdt:P31 wd:Q5 .
OPTIONAL {?person wdt:P535 ?findAGrave } # FindAGraveID
OPTIONAL {?person wdt:P1819 ?genealogics } # Genealogics
{?person wdt:P2949 ?wikiTreeID } # WikiTreeID
OPTIONAL {?person wdt:P569 ?dateOfBirth }
OPTIONAL {?person wdt:P19 ?placeOfBirth } # Birth location
# OPTIONAL {?placeOfBirth wdt:P625 ?coord1 } . # Get coordinates of Place of birth
OPTIONAL {?person wdt:P570 ?dateofDeath } # Deathdate
OPTIONAL {?person wdt:P20 ?deathLoc } # Death location
# OPTIONAL {?deathLoc wdt:P625 ?coord2 } . # Get coordinates from Place of death
OPTIONAL {?person wdt:P119 ?placeOfBurial } # Burial location
# OPTIONAL {?placeOfBurial wdt:P625 ?coord3 } . # Get coordinates from Place of burial
OPTIONAL {?person wdt:P18 ?pic} # picture
BIND (URI(CONCAT("http://www.wikitree.com/wiki/",?wikiTreeID)) AS ?wikiTreeIDf)
BIND (URI(CONCAT("http://www.findagrave.com/cgi-bin/fg.cgi?page=gr&df=all&GRid=",?findAGrave)) AS ?findAGravef)
BIND (URI(CONCAT("http://www.genealogics.org/getperson.php?tree=LEO&personID=",?genealogics)) AS ?genealogicsf)
# BIND (URI(CONCAT("https://www.facebook.com/",?FB)) AS ?FBf)
SERVICE wikibase:label { bd:serviceParam wikibase:language "en","fr". } #English
}
Order By (?dateOfBirth)
LIMIT 10000
fredag 29 juli 2016
Using WikiData to add quality at WikiTree part 1
We have a new excellent way of finding duplicates….. as I connect and everyone else can connect WikiTree to WikiData ==> on the profile at WikiData we add the WikiTree ID…. ==> you find duplicates
==> When mapping you realise that we have some duplicates in WikiTree
Ex…. Christian August Holstein Gottorp (1673 - 1726)
WikiData: https://www.wikidata.org/wiki/Q62259
WikiTree
==> When I found Holstein-Gottorp-39 I couldn’t add it to WikiData as we already had Holstein_Gottorp-4 ==> suggested merge...
So please help add the WikiTree Attribute to WikiData it will increase the quality of WikiTree
This can be used also that when you find a profile in Wikipedia that you check in WikiData if the profile is linked to WikiTree….
Family Tree URL https://tools.wmflabs.org/reasonator/geneawiki2/?q=Q157812
Regards
Magnus Sälgö
Stockholm, Sweden
Tools to generate family trees
onsdag 27 juli 2016
Nobel house Bernadotte Q201625
# Query Find all people subclasses P279 to Nobelhouses Bernadotte Q201625
#
#defaultView:ImageGrid
SELECT DISTINCT ?person ?personLabel ?dateofBirth ?placeOfBirthLabel ?dateofDeath ?WikiTreeIDf ?findAGravef ?wikiTreeIDf ?genealogicsf ?pic WHERE
{
?nobelhouse wdt:P31*/wdt:P279* wd:Q201625 .
?person wdt:P53 ?nobelhouse
OPTIONAL {?person wdt:P535 ?findAGrave } # FindAGraveID
OPTIONAL {?person wdt:P1819 ?genealogics } # Genealogics
OPTIONAL {?person wdt:P2949 ?wikiTreeID } # WikiTreeID
OPTIONAL {?person wdt:P569 ?dateOfBirth }
OPTIONAL {?person wdt:P19 ?placeOfBirth } # Birth location
OPTIONAL {?person wdt:P570 ?dateofDeath } # Deathdate
OPTIONAL {?person wdt:P20 ?deathLoc } # Death location
OPTIONAL {?person wdt:P119 ?placeOfBurial } # Burial location
OPTIONAL {?person wdt:P18 ?pic} # picture
BIND (URI(CONCAT("http://www.wikitree.com/wiki/",?wikiTreeID)) AS ?wikiTreeIDf)
BIND (URI(CONCAT("http://www.findagrave.com/cgi-bin/fg.cgi?page=gr&df=all&GRid=",?findAGrave)) AS ?findAGravef)
BIND (URI(CONCAT("http://www.genealogics.org/getperson.php?tree=LEO&personID=",?genealogics)) AS ?genealogicsf)
SERVICE wikibase:label { bd:serviceParam wikibase:language "en","fr". } #English
}
Order By (?dateOfBirth)
LIMIT 1000
#
#defaultView:ImageGrid
SELECT DISTINCT ?person ?personLabel ?dateofBirth ?placeOfBirthLabel ?dateofDeath ?WikiTreeIDf ?findAGravef ?wikiTreeIDf ?genealogicsf ?pic WHERE
{
?nobelhouse wdt:P31*/wdt:P279* wd:Q201625 .
?person wdt:P53 ?nobelhouse
OPTIONAL {?person wdt:P535 ?findAGrave } # FindAGraveID
OPTIONAL {?person wdt:P1819 ?genealogics } # Genealogics
OPTIONAL {?person wdt:P2949 ?wikiTreeID } # WikiTreeID
OPTIONAL {?person wdt:P569 ?dateOfBirth }
OPTIONAL {?person wdt:P19 ?placeOfBirth } # Birth location
OPTIONAL {?person wdt:P570 ?dateofDeath } # Deathdate
OPTIONAL {?person wdt:P20 ?deathLoc } # Death location
OPTIONAL {?person wdt:P119 ?placeOfBurial } # Burial location
OPTIONAL {?person wdt:P18 ?pic} # picture
BIND (URI(CONCAT("http://www.wikitree.com/wiki/",?wikiTreeID)) AS ?wikiTreeIDf)
BIND (URI(CONCAT("http://www.findagrave.com/cgi-bin/fg.cgi?page=gr&df=all&GRid=",?findAGrave)) AS ?findAGravef)
BIND (URI(CONCAT("http://www.genealogics.org/getperson.php?tree=LEO&personID=",?genealogics)) AS ?genealogicsf)
SERVICE wikibase:label { bd:serviceParam wikibase:language "en","fr". } #English
}
Order By (?dateOfBirth)
LIMIT 1000
tisdag 26 juli 2016
Find all communes with the name Seine ==> plot the river Seine
#defaultView:Map
SELECT ?commune ?label ?coords {
?commune wdt:P31 wd:Q484170 ; rdfs:label ?label . FILTER(LANG(?label) = "fr") .
FILTER REGEX(?label, ".Seine($|[ -])") .
?commune wdt:P625 ?coords .
} ORDER BY ?label
SELECT ?commune ?label ?coords {
?commune wdt:P31 wd:Q484170 ; rdfs:label ?label . FILTER(LANG(?label) = "fr") .
FILTER REGEX(?label, ".Seine($|[ -])") .
?commune wdt:P625 ?coords .
} ORDER BY ?label
Geospatial searches in WikiData : WikiTree people buried in a 5 km radius from Chicago
Geospatial searches in WikiData Q1297 Chicago
http://tinyurl.com/gtc2pwv
# Query Find people in WikiTree buried
# 10 km from Q1297 Chicago
#
SELECT ?placeOfBurial ?placeOfBurialLabel ?person ?personLabel ?WikiTree ?chicagoLoc WHERE {
{
wd:Q1297 wdt:P625 ?chicagoLoc . #Find location Chicago
?person wdt:P119 ?placeOfBurial.
{?person wdt:P2949 ?WikiTreeID}.
SERVICE wikibase:around {
?placeOfBurial wdt:P625 ?location .
bd:serviceParam wikibase:center ?chicagoLoc .
bd:serviceParam wikibase:radius "10" .
bd:serviceParam wikibase:distance ?dist.
}
BIND (URI(CONCAT("http://www.wikitree.com/wiki/",?WikiTreeID)) AS ?WikiTree)
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en"}
}
LIMIT 10000
See also:
Find all WikiTree people with Occupation Lady in Waiting Q715222
#defaultView:ImageGrids
SELECT DISTINCT ?occupationLabel ?nobelhouseLabel ?person ?personLabel ?dateOfBirth ?WikiTree ?pic WHERE{
?person wdt:P106 wd:Q715222 . # Occupation Lady in Waiting
?person wdt:P106 ?occupation . # Occupation Lady in Waiting
OPTIONAL {?person wdt:P53 ?nobelhouse}
OPTIONAL {?person wdt:P2949 ?WikiTreeID } # WikiTreeID
?person wdt:P569 ?dateOfBirth .
OPTIONAL {?person wdt:P19 ?placeOfBirth } # Birth location
OPTIONAL {?person wdt:P18 ?pic} # picture
FILTER(?occupation = wd:Q715222)
BIND (URI(CONCAT("http://www.wikitree.com/wiki/",?WikiTreeID)) AS ?WikiTree)
SERVICE wikibase:label { bd:serviceParam wikibase:language "en","fr". } #English
}
Order By DESC(?WikiTree) ?nobelhouseLabel ?dateOfBirth
LIMIT 1000
Result
WikiTree profiles with this occupations
subclasses P279 to Nobel houses Q13417114
# Query Find all subclasses P279 to Nobel houses Q13417114
#
#defaultView:ImageGrid
SELECT distinct ?nobelhouse ?nobelhouseLabel ?personDescription ?personLabel ?wikiTree ?findaGrave ?pic
{
?nobelhouse wdt:P31*/wdt:P279* wd:Q13417114 .
{?nobelhouse wdt:P17 ?country .}
?person wdt:P53 ?nobelhouse
OPTIONAL {?person wdt:P535 ?findAGrave } # FindAGraveID
# OPTIONAL {?person wdt:P1819 ?genealogics } # Genealogics
{?person wdt:P2949 ?wikiTreeID } # WikiTreeID
OPTIONAL {?person wdt:P569 ?dateOfBirth }
OPTIONAL {?person wdt:P19 ?placeOfBirth } # Birth location
# OPTIONAL {?placeOfBirth wdt:P625 ?coord1 } . # Get coordinates of Place of birth
OPTIONAL {?person wdt:P570 ?dateofDeath } # Deathdate
OPTIONAL {?person wdt:P20 ?deathLoc } # Death location
OPTIONAL {?person wdt:P18 ?pic} # picture
BIND (URI(CONCAT("http://www.wikitree.com/wiki/",?wikiTreeID)) AS ?wikiTree)
BIND (URI(CONCAT("http://www.findagrave.com/cgi-bin/fg.cgi?page=gr&df=all&GRid=",?findAGrave)) AS ?findAGravef)
# BIND (URI(CONCAT("http://www.genealogics.org/getperson.php?tree=LEO&personID=",?genealogics)) AS ?genealogicsf)
SERVICE wikibase:label { bd:serviceParam wikibase:language "en","fr","sv","cs","de","nl","ru","pl","fi","ca","es","bg",
"da","ro","sk","be","fy","it","br","uk","yi","gsw","fa","he","sr". } #English
}
Order By ?countryLabel ?nobelhouseLabel
LIMIT 10000
#
#defaultView:ImageGrid
SELECT distinct ?nobelhouse ?nobelhouseLabel ?personDescription ?personLabel ?wikiTree ?findaGrave ?pic
{
?nobelhouse wdt:P31*/wdt:P279* wd:Q13417114 .
{?nobelhouse wdt:P17 ?country .}
?person wdt:P53 ?nobelhouse
OPTIONAL {?person wdt:P535 ?findAGrave } # FindAGraveID
# OPTIONAL {?person wdt:P1819 ?genealogics } # Genealogics
{?person wdt:P2949 ?wikiTreeID } # WikiTreeID
OPTIONAL {?person wdt:P569 ?dateOfBirth }
OPTIONAL {?person wdt:P19 ?placeOfBirth } # Birth location
# OPTIONAL {?placeOfBirth wdt:P625 ?coord1 } . # Get coordinates of Place of birth
OPTIONAL {?person wdt:P570 ?dateofDeath } # Deathdate
OPTIONAL {?person wdt:P20 ?deathLoc } # Death location
OPTIONAL {?person wdt:P18 ?pic} # picture
BIND (URI(CONCAT("http://www.wikitree.com/wiki/",?wikiTreeID)) AS ?wikiTree)
BIND (URI(CONCAT("http://www.findagrave.com/cgi-bin/fg.cgi?page=gr&df=all&GRid=",?findAGrave)) AS ?findAGravef)
# BIND (URI(CONCAT("http://www.genealogics.org/getperson.php?tree=LEO&personID=",?genealogics)) AS ?genealogicsf)
SERVICE wikibase:label { bd:serviceParam wikibase:language "en","fr","sv","cs","de","nl","ru","pl","fi","ca","es","bg",
"da","ro","sk","be","fy","it","br","uk","yi","gsw","fa","he","sr". } #English
}
Order By ?countryLabel ?nobelhouseLabel
LIMIT 10000
People part in the Gallipoli campaign
WikiTree Category:Anzacs:World_War_One
P607 Q164983 = conflict Gallipoli campaign
# Query Find people in WikiTree people part in Q164983 Gallipoli conflict
#
#defaultView:ImageGrid
SELECT ?person ?personLabel ?personDescription ?WikiTree ?pic ?MiltaryBranchLabel ?awardsLabel WHERE {
{
?person wdt:P607 wd:Q164983 . #Gallipoli conflict
OPTIONAL{ ?person wdt:P2949 ?WikiTreeID}
OPTIONAL{ ?person wdt:P241 ?MiltaryBranch}
OPTIONAL{ ?person wdt:P18 ?pic}
OPTIONAL{ ?person wdt:P166 ?awards}
BIND (URI(CONCAT("http://www.wikitree.com/wiki/",?WikiTreeID)) as ?WikiTree)
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en"}
}
LIMIT 1000
People marked in WikiData to have an profile in WikiTree and are part of Gallipoli campaign
==> ?person P607 Q164983
P607 Q164983 = conflict Gallipoli campaign
# Query Find people in WikiTree people part in Q164983 Gallipoli conflict
#
#defaultView:ImageGrid
SELECT ?person ?personLabel ?personDescription ?WikiTree ?pic ?MiltaryBranchLabel ?awardsLabel WHERE {
{
?person wdt:P607 wd:Q164983 . #Gallipoli conflict
OPTIONAL{ ?person wdt:P2949 ?WikiTreeID}
OPTIONAL{ ?person wdt:P241 ?MiltaryBranch}
OPTIONAL{ ?person wdt:P18 ?pic}
OPTIONAL{ ?person wdt:P166 ?awards}
BIND (URI(CONCAT("http://www.wikitree.com/wiki/",?WikiTreeID)) as ?WikiTree)
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en"}
}
LIMIT 1000
People marked in WikiData to have an profile in WikiTree and are part of Gallipoli campaign
==> ?person P607 Q164983
Location search in WikiData on Stockholm
# Query Find people in WikiTree
# 100 km from Q1754 Stockhlom
#
#defaultView:Mapxx
#SELECT DISTINCT ?placeOfBurial ?placeOfBurialLabel ?coord ?pic ?WikiTreeID WHERE {
#SELECT DISTINCT ?person ?personLabel WHERE {
SELECT ?placeOfBurial ?placeOfBurialLabel ?person ?personLabel ?WikiTreeID WHERE {
{
wd:Q1754 wdt:P625 ?sthlmLoc . #Find location Stockholm
?person wdt:P119 ?placeOfBurial.
SERVICE wikibase:around {
?placeOfBurial wdt:P625 ?location .
bd:serviceParam wikibase:center ?sthlmLoc .
bd:serviceParam wikibase:radius "3" .
bd:serviceParam wikibase:distance ?dist.
}
OPTIONAL {?person wdt:P2949 ?WikiTreeID}.
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en"}
}
LIMIT 10000
Result
# 100 km from Q1754 Stockhlom
#
#defaultView:Mapxx
#SELECT DISTINCT ?placeOfBurial ?placeOfBurialLabel ?coord ?pic ?WikiTreeID WHERE {
#SELECT DISTINCT ?person ?personLabel WHERE {
SELECT ?placeOfBurial ?placeOfBurialLabel ?person ?personLabel ?WikiTreeID WHERE {
{
wd:Q1754 wdt:P625 ?sthlmLoc . #Find location Stockholm
?person wdt:P119 ?placeOfBurial.
SERVICE wikibase:around {
?placeOfBurial wdt:P625 ?location .
bd:serviceParam wikibase:center ?sthlmLoc .
bd:serviceParam wikibase:radius "3" .
bd:serviceParam wikibase:distance ?dist.
}
OPTIONAL {?person wdt:P2949 ?WikiTreeID}.
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en"}
}
LIMIT 10000
Result
Location search 10 km Freehold Township, New Jersey
# Query Find Q19558910 Place listed on the National Register of Historic Places
# 100 km from Q1077969 Freehold Township, New Jersey#
#defaultView:Map
SELECT DISTINCT ?place ?placeLabel ?coord ?pic ?ref WHERE {
{
wd:Q1077969 wdt:P625 ?freeholdLoc . #Find location
?place wdt:P1435 wd:Q19558910 #Find Heritage status P1435 is Q19558910 Place listed on the National Register of Historic Places
SERVICE wikibase:around {
?place wdt:P625 ?location .
bd:serviceParam wikibase:center ?freeholdLoc .
bd:serviceParam wikibase:radius "100" .
bd:serviceParam wikibase:distance ?dist.
}
OPTIONAL{?place wdt:P625 ?coord} . #Get the coordinates
OPTIONAL{?place wdt:P18 ?pic} . #Get a Picture
OPTIONAL{?place wdt:P649 ?refnr} . #Ref
BIND(URI(CONCAT("http://focus.nps.gov/AssetDetail/NRIS/",?refnr)) as ?ref)
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en","fr","nl","de","fa"}
}
LIMIT 100000
Map
måndag 25 juli 2016
Place listed on the National Register of Historic Places
- Resullt displayed on a Map
- About National_Register_of_Historic_Places
# Query Find Q19558910 Place listed on the National Register of Historic Places
##defaultView:Map
SELECT DISTINCT ?place ?placeLabel ?coord ?pic ?ref WHERE
{
{
?place wdt:P1435 wd:Q19558910 #Find Heritage status P1435 is Q19558910 Place listed on the National Register of Historic Places
OPTIONAL{?place wdt:P625 ?coord} . #Get the coordinates
OPTIONAL{?place wdt:P18 ?pic} . #Get a Picture
OPTIONAL{?place wdt:P649 ?refnr} . #Ref
BIND(URI(CONCAT("http://focus.nps.gov/AssetDetail/NRIS/",?refnr)) as ?ref)
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en","fr","nl","de","fa"}
}
Order by ?countryLabel
LIMIT 100000
Map number of items at one place
#Map of all the paintings for which we know a location with the count per location
#defaultView:Map
SELECT ?locationLabel ?coord (count(*) as ?count)
WHERE {
?painting wdt:P31 wd:Q3305213 .
?painting wdt:P276 ?location .
?location wdt:P625 ?coord
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
GROUP BY ?locationLabel ?coord
#defaultView:Map
SELECT ?locationLabel ?coord (count(*) as ?count)
WHERE {
?painting wdt:P31 wd:Q3305213 .
?painting wdt:P276 ?location .
?location wdt:P625 ?coord
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
GROUP BY ?locationLabel ?coord
UNESCO place listed by the UNESCO as of special cultural or physical significance
Wikidata Q9259 is a place listed by the UNESCO as of special cultural or physical significance
==> I do a search I get about 1557 places ==>
- displayed on a map
- displayed in a table
- displayed with images
Query asked
?place wdt:P1435 wd:Q9259 #Find Heritage status P1435 is World Heritage Size
OPTIONAL{?place wdt:P625 ?coord} . #Get the coordinates
OPTIONAL{?place wdt:P18 ?pic} . #Get a Picture
OPTIONAL{?place wdt:P17 ?country} . # Get country
?place wdt:P1435 wd:Q9259 #Find Heritage status P1435 is World Heritage Size
OPTIONAL{?place wdt:P625 ?coord} . #Get the coordinates
OPTIONAL{?place wdt:P18 ?pic} . #Get a Picture
OPTIONAL{?place wdt:P17 ?country} . # Get country
WikiData Pope and WikiTree
P39 Position held
Q19546 Pope
WHERE
{
?pope wdt:P39 wd:Q19546;
p:P39 [
ps:P39 wd:Q19546;
pq:P580 ?start;
pq:P582 ?end;
pq:P1365 ?replace;
pq:P1366 ?replacedBy
].
OPTIONAL{?pope wdt:P2949 ?WikiTreeID}.
BIND (URI(CONCAT("http://www.wikitree.com/wiki/",?WikiTreeID)) AS ?WikiTree)
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
ORDER BY DESC(?end)
Q19546 Pope
Query Popes and WikiTree link
SELECT ?pope ?popeLabel ?popeDescription ?start ?end ?replace ?replacedby ?WikiTreeWHERE
{
?pope wdt:P39 wd:Q19546;
p:P39 [
ps:P39 wd:Q19546;
pq:P580 ?start;
pq:P582 ?end;
pq:P1365 ?replace;
pq:P1366 ?replacedBy
].
OPTIONAL{?pope wdt:P2949 ?WikiTreeID}.
BIND (URI(CONCAT("http://www.wikitree.com/wiki/",?WikiTreeID)) AS ?WikiTree)
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
ORDER BY DESC(?end)
Popes not with links to WikiTree = 252
MINUS{?pope wdt:P2949 ?WikiTreeID}.
Misc
Three pops the same year query
SELECT ?year ?pope1Label ?pope2Label ?pope3Label
WHERE
{
p:P39 [
pq:P580 ?p2s;
pq:P582 ?p2e;
pq:P1365 ?pope1;
pq:P1366 ?pope3
].
?pope1 p:P39 [
].
].
BIND(YEAR(?p2s) AS ?year).
FILTER(YEAR(?p2e) = ?year && YEAR(?p1e) = ?year && YEAR(?p3s) = ?year).
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
ORDER BY ?year
WikiData Swedish Prime ministers
P39 Position held
Q687075 Prime minister of Sweden
select ?person ?personLabel ?replaceLabel ?replacedbyLabel ?start ?end ?pic ?WikiTreeID{
{
?person wdt:P39 wd:Q687075;
p:P39 [
ps:P39 wd:Q687075;
pq:P580 ?start;
pq:P582 ?end;
pq:P1365 ?replace; #Replace
pq:P1366 ?replacedby #Replaced by
].
OPTIONAL { ?person wdt:P2949 ?WikiTreeID .} # If we have a WikiTree profile
OPTIONAL{ ?person wdt:P18 ?pic .} # If we have an illustration
BIND (URI(CONCAT("http://www.wikitree.com/wiki/",?WikiTreeID)) AS ?WikiTree)
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en"}
}
{
?person wdt:P39 wd:Q687075.
OPTIONAL { ?person wdt:P2949 ?WikiTreeID .} # If we have a WikiTree profile
OPTIONAL{ ?person wdt:P18 ?pic .} # If we have an illustration
BIND (URI(CONCAT("http://www.wikitree.com/wiki/",?WikiTreeID)) AS ?WikiTree)
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en"}
}
Order by ?end
{
?person wdt:P39 wd:Q687075.
{ ?person wdt:P2949 ?WikiTreeID .} # If we have a WikiTree profile
OPTIONAL{ ?person wdt:P18 ?pic .} # If we have an illustration
BIND (URI(CONCAT("http://www.wikitree.com/wiki/",?WikiTreeID)) AS ?WikiTree)
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en"}
}
Order by ?end
#
#select ?person ?personLabel ?personDescription ?WikiTreeID ?WikiTree ?replaceLabel ?replacedbyLabel ?start ?end ?pic{
select ?person ?personLabel ?personSeacription ?pic ?WikiTreeID{
{
?person wdt:P39 wd:Q687075.
OPTIONAL{ ?person wdt:P18 ?pic .} # If we have an illustration
MINUS { ?person wdt:P2949 ?WikiTreeID .} # If we have a WikiTree profile
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en"}
}
Order by ?end
Q687075 Prime minister of Sweden
select ?person ?personLabel ?replaceLabel ?replacedbyLabel ?start ?end ?pic ?WikiTreeID{
{
?person wdt:P39 wd:Q687075;
p:P39 [
ps:P39 wd:Q687075;
pq:P580 ?start;
pq:P582 ?end;
pq:P1365 ?replace; #Replace
pq:P1366 ?replacedby #Replaced by
].
OPTIONAL { ?person wdt:P2949 ?WikiTreeID .} # If we have a WikiTree profile
OPTIONAL{ ?person wdt:P18 ?pic .} # If we have an illustration
BIND (URI(CONCAT("http://www.wikitree.com/wiki/",?WikiTreeID)) AS ?WikiTree)
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en"}
}
Simple query
select ?person ?personLabel ?personDescription ?pic ?WikiTreeID{{
?person wdt:P39 wd:Q687075.
OPTIONAL { ?person wdt:P2949 ?WikiTreeID .} # If we have a WikiTree profile
OPTIONAL{ ?person wdt:P18 ?pic .} # If we have an illustration
BIND (URI(CONCAT("http://www.wikitree.com/wiki/",?WikiTreeID)) AS ?WikiTree)
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en"}
}
Order by ?end
Simple query returning people in WikiTree
select ?person ?personLabel ?personDescription ?pic ?WikiTreeID{{
?person wdt:P39 wd:Q687075.
{ ?person wdt:P2949 ?WikiTreeID .} # If we have a WikiTree profile
OPTIONAL{ ?person wdt:P18 ?pic .} # If we have an illustration
BIND (URI(CONCAT("http://www.wikitree.com/wiki/",?WikiTreeID)) AS ?WikiTree)
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en"}
}
Order by ?end
Returning people not linked to WikiTree
# Query Find in WikiData people with position held P39 Swedish Prime minister Q687075#
#select ?person ?personLabel ?personDescription ?WikiTreeID ?WikiTree ?replaceLabel ?replacedbyLabel ?start ?end ?pic{
select ?person ?personLabel ?personSeacription ?pic ?WikiTreeID{
{
?person wdt:P39 wd:Q687075.
OPTIONAL{ ?person wdt:P18 ?pic .} # If we have an illustration
MINUS { ?person wdt:P2949 ?WikiTreeID .} # If we have a WikiTree profile
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en"}
}
Order by ?end
Data-sgvizler
A Javascript to visualize SPARQL queries
- Sgvizler: A JavaScript Wrapper for Easy Visualization of SPARQL Result Sets pdf
fredag 22 juli 2016
Scientist
More Scientist both on Wikidata and WikiTree
Q901 person engaging in a systematic activity to acquire knowledge that describes and predicts the natural world
==>
?person wdt:P106 ?occupation
?occupation wdt:P279 wd:Q901 # subclass of Scientist
?person wdt:P2747 ?WikiTreeID #person in Wikidata has a link to WikiTree
Query
Result List
Image GalleryLink Image Gallery
Nice video about Tesla and Edison
Q901 person engaging in a systematic activity to acquire knowledge that describes and predicts the natural world
==>
?person wdt:P106 ?occupation
?occupation wdt:P279 wd:Q901 # subclass of Scientist
?person wdt:P2747 ?WikiTreeID #person in Wikidata has a link to WikiTree
Query
Result List
Image GalleryLink Image Gallery
Maps
Display on a MapNice video about Tesla and Edison
torsdag 21 juli 2016
Misc
Search different languages lables
# Query Finding all labels for Q299179 emperor of Japan Kōmei
# https://en.wikipedia.org/wiki/List_of_ISO_639-1_codes list of codes
#
select ?s ?langtag ?label Where
{
?s wdt:P31* wd:Q299179 .
?s rdfs:label ?label .
BIND( lang(?label) AS ?langtag)
# FILTER ( lang(?label) = "en") # get just english
# FILTER (!(lang(?label) = "en")) # get all except english
# FILTER ( langMatches(lang(?label),"zh")) #get all chinese version like zh-hans zh-hk
}
Order by ?langtag
Another search
# Query Finding all labels for Q299179 emperor of Japan Kōmei
# https://en.wikipedia.org/wiki/List_of_ISO_639-1_codes list of codes
#
select ?s ?langtag ?label Where
{
?s wdt:P31* wd:Q299179 .
?s rdfs:label ?label .
BIND( lang(?label) AS ?langtag)
# FILTER ( lang(?label) = "en") # get just english
# FILTER (!(lang(?label) = "en")) # get all except english
# FILTER ( langMatches(lang(?label),"zh")) #get all chinese version like zh-hans zh-hk
}
Order by ?langtag
Another search
Noble houses
- Query all people from Noble houses with WikiTree profile
- Result Timeline
- Result Image Grid Order By ?nobelhouseLabel ?countryLabel ?dateOfBirth
- Image Grid Order By DESC(?dateOfBirth)
- Result List
- Query map all WikiTree people
- Query Imperial House of Japan Q909452
- Query Imperial House of Japan part 2
- Timeline Royal House
- Report the House of Windsor ordered by Birth day
- Tweet The sixth most common cause of death for noble people on @wikidata is “horse fall”.
SELECT ?cause ?causeLabel (COUNT(?person) AS ?count)
WHERE
{
?person wdt:P31 wd:Q5;
wdt:P509 ?cause;
wdt:P53 [].
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
GROUP BY ?cause ?causeLabel
HAVING(?count > 1)
ORDER BY DESC(?count) - Longest Running Noble families Query limit 500 years
Music
Geography
- Longest river per continent
WikiData
- Properties of the name attribute
Roman names are complex tweet Query
Languages in WikiData 284
Former Capitals in a broader sense also counties etc.....
Family tree
- Family Tree of Ghingis Kahns - Q720
- Graphic Tool
- Query
- Other question { wd:Q720 wdt:P40* ?item } UNION { ?item wdt:P40* wd:Q720 }
- Family Tree of Gustav Vasa - Q52947
- Family Tree of Elizabeth_II - Q9682
- Family Tree of Beethoven - Q255
- Family Tree Henry VII - Q675493
- Family Tree Philip II of Spain - Q34417
- Family Tree George Washington - Q
- Graphic Tool - Q23
- Query
onsdag 20 juli 2016
Rubens
WikiTree Rubens-1 ==> Wikidata Q5599
Reasonator on Q5599 https://tools.wmflabs.org/reasonator/?q=Q5599
If we then Use SPARQL
#Locations of Paul Rubens creations
#defaultView:Map
SELECT ?label ?subjDescription ?coord ?subj ?pic ?locLabel ?locDescription ?MoreInfo WHERE {{
?subj wdt:P170 wd:Q5599 . #P170 creator Q5599 Paul Rubens
OPTIONAL {?subj wdt:P276 ?loc . #P276 is location
?loc wdt:P625 ?coord . #P625 coordinate location
} .
OPTIONAL{?subj wdt:P18 ?pic} .
OPTIONAL{?subj wdt:P973 ?MoreInfo} .
?subj rdfs:label ?label filter (lang(?label) = "en")
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
Reasonator on Q5599 https://tools.wmflabs.org/reasonator/?q=Q5599
If we then Use SPARQL
Nota Bene: An end user who finds A wikipedia article can always find Wikidata ... and get the Wikidata ID = argument in the Reasonator template {{WikiReasonator|Q5599}} and all the references but the Reasonator is trying to make it easier. Hope it makes sense....
#defaultView:Map
SELECT ?label ?subjDescription ?coord ?subj ?pic ?locLabel ?locDescription ?MoreInfo WHERE {{
?subj wdt:P170 wd:Q5599 . #P170 creator Q5599 Paul Rubens
OPTIONAL {?subj wdt:P276 ?loc . #P276 is location
?loc wdt:P625 ?coord . #P625 coordinate location
} .
OPTIONAL{?subj wdt:P18 ?pic} .
OPTIONAL{?subj wdt:P973 ?MoreInfo} .
?subj rdfs:label ?label filter (lang(?label) = "en")
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
Map location Philadelphia Museum of Art
tisdag 19 juli 2016
Royal house (Q1156073)
Royal House
Links
- Wikipedia Dynasty -
- Wikipedia Royal family - Q2006518
Wikidata items Q1156073
Q1156073 = Royal house: consists monarchs who are related to one another, as well as their non-reigning descendants and spousesSubclass
Q13417114 family part of the nobility of a region or countryQ164950 sequence of rulers considered members of the same family
Query Nobelhouses - 1
List of subclasses to Q1156073 - Royal Houses
?nobelhouse wdt:P31*/wdt:P279* wd:Q1156073 .
Query Royal house - 2 abt. 94 persons
Find all people- belonging to a Noble house or dynasty that is a Royal house
- Who has a picture
- Are connected to WikiTree
Also people without picture ==> also 94
Query Royal house - 3 abt 338 people
Find all people- belonging to a Noble house or dynasty that is a Royal house
- Who has a picture
Query Royal house - 4
Find all people- belonging to a Noble house or dynasty that is a Royal house
- Who has a picture
- Display on a map birth death burial locations
Image Gallery
Also people without picture
lördag 16 juli 2016
Histropedia Timeline - all Wikidata with
All Wikitree marked attributes
claim[2949] ==> All items with WikiTree attributehttp://histropedia.com/timeline?q=claim[2949]
shortcut http://goo.gl/yrPX1P
Former countries
Find all Former countriesHistropedia http://histropedia.com/timeline?q=claim[31:3024240]%20and%20claim[30:48]
claim[31:(TREE[3024240][][279])] AND CLAIM[571]
Histropedia
31 Instance of...
Q3024240 former country
279 Subclass
571 Date and time
Find all people part of a Royal House
Find all part of a royal house wd:Q1156073
Histropedia http://histropedia.com/timeline?q=claim[31:1156073] ==> SPARQL W
Proximity searches
http://histropedia.com/timeline?q=around[625, 51.500732, -0.124239,3] AND CLAIM[2949]q=around[625,48.858366,2.294449,50]and Claim[2949] ==>
http://histropedia.com/timeline?q=around[625,%2048.858366,%202.294449,50]%20and%20Claim[2949]
All Find A Grave
http://histropedia.com/timeline?q=claim[535]
Olympics
- Query Olympics USA
- All WikiTree Olympics
All American citizens who has participated in Olympics
#SPARQL query in Wikidata
# Find all people with WikiTreeID => they have a profile in WikiTree
# Display on the map
# - Place of Birth
# - Place of Death
# - Place of Burial
#
# In the popup window show illustration from Wikidata and URL to WikiTree
SELECT distinct ?person ?olympicsLabel ?personLabel ?personDescription ?BirthDate ?BirthlocLabel ?DeathDate ?DeathlocLabel ?WikiTree WHERE {
{
?olympics wdt:P31 wd:Q159821 . # All Olympics
?person wdt:P1344 ?olympics .
?person wdt:P27 wd:Q30 . # American
OPTIONAL{ ?person wdt:P2949 ?WikiTreeID .} # All item with WikiTreeID
# OPTIONAL { ?person wdt:P535 ?FindAGrave } # FindAGrave
# OPTIONAL { ?person wdt:P1819 ?Genealogics } # Genealogics
# OPTIONAL { ?person wdt:P2013 ?FB } # Facebook
OPTIONAL { ?person wdt:P569 ?BirthDate .} # P569 Birth
OPTIONAL { ?person wdt:P570 ?DeathDate .} # P569 Birth
OPTIONAL { ?person wdt:P19 ?Birthloc .} # P19 Place of Birth
OPTIONAL { ?person wdt:P20 ?Deathloc .} # P19 Place of Birth
# ?Birthloc wdt:P625 ?coord } . # Get coordinates from Place of Birth
# OPTIONAL {?person wdt:P18 ?ppicture} # If Wikidata has a illustration use that
BIND (URI(CONCAT("http://www.wikitree.com/wiki/",?WikiTreeID)) AS ?WikiTree)
# BIND (URI(CONCAT("https://www.facebook.com/",?FB)) AS ?FBf)
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
Order by ?olympicsLabel ?personLabel
LIMIT 10000
Prenumerera på:
Inlägg (Atom)