söndag 31 juli 2016

Find all poets on WikiTree also on WikiData

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



Primeministers

Position held

  1. Q687075 Prime minister of Sweden
    1. Table
    2. Image gallery
    3. Timeline

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

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)



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….

Regards
Magnus Sälgö
Stockholm, Sweden

Tools to generate family trees

onsdag 27 juli 2016

Wikipedia -> Wikidata -> WikiTree

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


tisdag 26 juli 2016

SPARQL in 10 minutes and VIAF in WikiData


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


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

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

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

  • Query
    • Result
    • Map - problem that more points on the same spot are just displaying one
    • Image Gallery

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




# 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

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 ==> 
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

WikiData Pope and WikiTree

P39 Position held
Q19546 Pope

Query Popes and WikiTree link

SELECT ?pope ?popeLabel ?popeDescription ?start ?end ?replace ?replacedby ?WikiTree
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)

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
{
  ?pope2 wdt:P39 wd:Q19546;
         p:P39 [
           ps:P39 wd:Q19546;
           pq:P580 ?p2s;
           pq:P582 ?p2e;
           pq:P1365 ?pope1;
           pq:P1366 ?pope3
         ].
  ?pope1 p:P39 [
           ps:P39 wd:Q19546;
           pq:P582 ?p1e
         ].
  ?pope3 p:P39 [
           ps:P39 wd:Q19546;
           pq:P580 ?p3s
         ].
  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"}
 }






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



Wikidata search plug-in



Linked Open Data




Linked Data Implementations-Who, What and Why? from CNI Video Channel on Vimeo.



Sgvizler

Sgvizler: A JavaScript Wrapper for EasyVisualization of SPARQL Result Sets

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


  • Ex. Nikola Tesla Q9036
    • has an P106 occupation   is a Q169470 Physicist 
      • that is a Q901 Scientist


==>

?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 Gallery
Link Image Gallery


Maps

Display on a Map

Nice 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

Noble houses

Music 

Geography


WikiData

Family tree

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

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.... 
  
 
Record at Wikidata Q5599
Wikipedia en ja ....

Some external links from WikiData Q5599


#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". }
}

Map location Philadelphia Museum of Art
                


tisdag 19 juli 2016

People part of Imperial House of Japan Q909452 #

Query https://goo.gl/LzjvP4

?person wdt:P53* wd:Q909452 .

Royal house (Q1156073)

Royal House

Links

Wikidata items Q1156073

Q1156073 = Royal house: consists monarchs who are related to one another, as well as their non-reigning descendants and spouses

Subclass 

Q13417114 family part of the nobility of a region or country
Q164950 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 .


Search query, result,  image Gallery for those with coatOfArms



Query Royal house - 2  abt. 94 persons

Find all people

  1. belonging to a Noble house or dynasty that is a Royal house
  2. Who has a picture
  3. Are connected to WikiTree 

Also people without picture ==> also 94


Query Royal house - 3  abt 338 people

Find all people

  1. belonging to a Noble house or dynasty that is a Royal house
  2. Who has a picture

Also people without picture ==> result also 338



Query Royal house - 4

Find all people

  1. belonging to a Noble house or dynasty that is a Royal house
  2. Who has a picture 
  3. Display on a map birth death burial locations
Image Gallery 
Also people without picture

Timeline on the fly - TBD

=claim[31:1156073]%20and%20claim[30:48]


lördag 16 juli 2016

Histropedia Timeline - all Wikidata with

All Wikitree marked attributes

claim[2949] ==> All items with WikiTree attribute

http://histropedia.com/timeline?q=claim[2949]

shortcut http://goo.gl/yrPX1P



Former countries

Find all Former countries
Histropedia 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]


Timeline all WikiTree items in Wikidata

WikiData Timeline claim[2949]

Former countries in Asia claim[31:3024240] and claim[30:48]



Former countries



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